Skip to content
aidb

Airports of the world with scheduled service

Every large and medium airport in the world that has scheduled airline service, with IATA and ICAO codes, location, elevation and country. One row per airport.

3,269 rows16 columns Updated 6 h ago Public domain (OurAirports); country codes CC BY 4.0 (GeoNames)
Loading all 3,269 rows…
#

Columns

Stable keys — use them in the API, SQL and code

KeyNameTypeDescription
identIdentstringOurAirports identifier — usually the ICAO code, otherwise a local or made-up code.
iataIATAstringThree-letter IATA airport code used on tickets and baggage tags.
icaoICAOstringFour-letter ICAO location indicator used by air traffic control.
nameAirportstring—
typeSize classstringOurAirports size class: Large airport or Medium airport.
municipalityCitystringCity or town the airport serves or is located in.
region_codeRegion codestringISO 3166-2 code of the first-level subdivision, as recorded by OurAirports (e.g. US-NY).
countryCountrycountryISO 3166-1 alpha-3 country code.
country_iso2Country codestringISO 3166-1 alpha-2 country code as recorded by OurAirports.
country_nameCountry namestring—
continentContinentstring—
elevation_ftElevationinteger · ftElevation of the airfield above mean sea level, in feet.
latLatitudenumber · °—
lonLongitudenumber · °—
wikipediaWikipediaurl—
websiteWebsiteurlAirport's official website, where known.