Queries

Query: give me all the names starting air terminal
id iata_code airport_name city_name country_name latitude longitude
1 97 ADY Alldays Alldays South Africa -22.679017 29.055517
2 110 AET Allakaket Allakaket United States 66.551833 -152.622167
3 170 AIA Alliance Alliance United States 42.053222 -102.803778
4 888 BOI Boise Air Terminal/Gowen Field Boise, ID United States 43.564361 -116.222861
5 1846 DLS Columbia Gorge Regional/The Dalles Municipal Airport The Dalles United States 45.618556 -121.167333
6 2264 FAT Fresno Air Terminal Airport Fresno United States 36.776194 -119.718139
7 3135 HWD Air Terminal Hayward United States 37.658917 -122.12175
8 4374 LLU Alluitsup Paa Alluitsup Paa Greenland 60.464444 -45.577778
9 4752 MFE Mc Allen Miller International Mc Allen, TX United States 26.175833 -98.238611
10 4765 MFR Rogue Valley International - Medford Airport Medford United States 42.374222 -122.8735
11 4902 MLB Melbourne International Airport Melbourne United States 28.102753 -80.645257
12 6436 QNY Marine Air Terminal New York Colombia 40.733991 -73.972916
13 7518 TDN Theda Station Theda Turkey 38.08638889 27.73777778
14 7520 TDR Theodore Theodore United Kingdom -24.986667 150.093056
15 7797 TRM Thermal Thermal United States 33.626667 -116.159667
16 8183 VGT North Air Terminal Las Vegas United States 36.210694 -115.194444
17 8904 YKM Yakima Air Terminal Yakima United States 46.568167 -120.544056
18 9015 YQD The Pas The Pas Canada 53.971389 -101.091111
19 9070 YST Ste Therese Point Ste Therese Point Canada 53.846 -94.852
20 9284 ZLX British Rail Terminal London United Kingdom 51.51666667 0.1
Back to query list