Airport, airline and route data

Navigation: Airport | Airline | Route | Plane | Country | Schedule | Other | License

Airport database


(click to enlarge)

As of January 2017, the OpenFlights Airports Database contains over 10,000 airports, train stations and ferry terminals spanning the globe, as shown in the map above. Each entry contains the following information:

Airport ID Unique OpenFlights identifier for this airport.
Name of airport. May or may not contain the City name.
City Main city served by airport. May be spelled differently from Name.
Country Country or territory where airport is located. See Countries to cross-reference to ISO 3166-1 codes.
IATA 3-letter IATA code. Null if not assigned/unknown.
ICAO 4-letter ICAO code.
Null if not assigned.
Latitude Decimal degrees, usually to six significant digits. Negative is South, positive is North.
Longitude Decimal degrees, usually to six significant digits. Negative is West, positive is East.
Altitude In feet.
Timezone Hours offset from UTC. Fractional hours are expressed as decimals, eg. India is 5.5.
DST Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None) or U (Unknown). See also: Help: Time
Tz database timezone Timezone in "tz" (Olson) format, eg. "America/Los_Angeles".
Type Type of the airport. Value "airport" for air terminals, "station" for train stations, "port" for ferry terminals and "unknown" if not known. In airports.csv, only type=airport is included.
Source Source of this data. "OurAirports" for data sourced from OurAirports, "Legacy" for old data not matched to OurAirports (mostly DAFIF), "User" for unverified user contributions. In airports.csv, only source=OurAirports is included.

The data is UTF-8 encoded.

Note: Rules for daylight savings time change from year to year and from country to country. The current data is an approximation for 2009, built on a country level. Most airports in DST-less regions in countries that generally observe DST (eg. AL, HI in the USA, NT, QL in Australia, parts of Canada) are marked incorrectly.

Sample entries

507,"London Heathrow Airport","London","United Kingdom","LHR","EGLL",51.4706,-0.461941,83,0,"E","Europe/London","airport","OurAirports"
26,"Kugaaruk Airport","Pelly Bay","Canada","YBB","CYBB",68.534401,-89.808098,56,-7,"A","America/Edmonton","airport","OurAirports"
3127,"Pokhara Airport","Pokhara","Nepal","PKR","VNPK",28.200899124145508,83.98210144042969,2712,5.75,"N","Asia/Katmandu","airport","OurAirports"
8810,"Hamburg Hbf","Hamburg","Germany","ZMB",\N,53.552776,10.006683,30,1,"E","Europe/Berlin","station","User"

Try it out: Airport Search (new window)

Note: The Airport Search window above is a part of OpenFlights. You will not be able to add or edit airports unless you are logged in.

Download

To download the current data dump from GitHub as a very straightforward CSV (comma-separated value) file, suitable for use in spreadsheets etc., simply click below:

Download: airports.dat (Airports only, high quality)

Download: airports-extended.dat (Airports, train stations and ferry terminals, including user contributions)

Creating and maintaining this database has required and continues to require an immense amount of work. We need your support to keep this database up-to-date: just click on the PayPal link to the right (Visa, MasterCard, American Express and Discover also accepted). We suggest US$50, but any amount at all is welcome, and you may use the data for free if you feel that you are unable to pay. If you do donate, please specify in the comments if you would like a itemized receipt for business expense or tax purposes.

Support OpenFlights

The GitHub copy is only a sporadically updated static snapshot of the live OpenFlights database (see revision log). If you would like an up-to-the-minute copy, or you would like your data filtered by any information available to us (eg. number of routes at the airport), do not hesitate to contact us.

If you'd like an even more thorough database, with extensive coverage of airstrips, heliports and other places of less interest for commercial airline frequent flyers, do check out OurAirports, whose public domain database covers over 40,000 places to fly from.

Airline database

As of January 2012, the OpenFlights Airlines Database contains 5888 airlines. Each entry contains the following information:

Airline ID Unique OpenFlights identifier for this airline.
Name Name of the airline.
Alias Alias of the airline. For example, All Nippon Airways is commonly known as "ANA".
IATA 2-letter IATA code, if available.
ICAO 3-letter ICAO code, if available.
Callsign Airline callsign.
Country Country or territory where airport is located. See Countries to cross-reference to ISO 3166-1 codes.
Active "Y" if the airline is or has until recently been operational, "N" if it is defunct. This field is not reliable: in particular, major airlines that stopped flying long ago, but have not had their IATA code reassigned (eg. Ansett/AN), will incorrectly show as "Y".

The data is UTF-8 encoded. The special value \N is used for "NULL" to indicate that no value is available, and is understood automatically by MySQL if imported.

Notes: Airlines with null codes/callsigns/countries generally represent user-added airlines. Since the data is intended primarily for current flights, defunct IATA codes are generally not included. For example, "Sabena" is not listed with a SN IATA code, since "SN" is presently used by its successor Brussels Airlines.

Sample entries

324,"All Nippon Airways","ANA All Nippon Airways","NH","ANA","ALL NIPPON","Japan","Y"
412,"Aerolineas Argentinas",\N,"AR","ARG","ARGENTINA","Argentina","Y"
413,"Arrowhead Airways",\N,"","ARH","ARROWHEAD","United States","N"

Try it out: Airline Search (new window)

Note: The Airline Search window above is a part of OpenFlights. You will not be able to view, add or edit airline details unless you are logged in.

Download

To download the current data dump from GitHub as a very straightforward CSV (comma-separated value) file, suitable for use in spreadsheets etc, simply click below:

Download: airlines.dat (~400 KB)

Creating and maintaining this database has required and continues to require an immense amount of work. We need your support to keep this database up-to-date: just click on the PayPal link to the right (Visa, MasterCard, American Express and Discover also accepted). We suggest US$50, but any amount at all is welcome, and you may use the data for free if you feel that you are unable to pay. If you do donate, please specify in the comments if you would like a itemized receipt for business expense or tax purposes.

Support OpenFlights

The GitHub copy is only a sporadically updated static snapshot of the live OpenFlights database (see revision log). If you would like an up-to-the-minute copy, or you would like your data filtered by any information available to us (eg. number of routes at the airport), do not hesitate to contact us.

Route database


(click to enlarge)

Warning: The third-party that OpenFlights uses for route data ceased providing updates in June 2014. The current data is of historical value only.

As of June 2014, the OpenFlights/Airline Route Mapper Route Database contains 67663 routes between 3321 airports on 548 airlines spanning the globe, as shown in the map above. Each entry contains the following information:

Airline 2-letter (IATA) or 3-letter (ICAO) code of the airline.
Airline ID Unique OpenFlights identifier for airline (see Airline).
Source airport 3-letter (IATA) or 4-letter (ICAO) code of the source airport.
Source airport ID Unique OpenFlights identifier for source airport (see Airport)
Destination airport 3-letter (IATA) or 4-letter (ICAO) code of the destination airport.
Destination airport ID Unique OpenFlights identifier for destination airport (see Airport)
Codeshare "Y" if this flight is a codeshare (that is, not operated by Airline, but another carrier), empty otherwise.
Stops Number of stops on this flight ("0" for direct)
Equipment 3-letter codes for plane type(s) generally used on this flight, separated by spaces

The data is UTF-8 encoded. The special value \N is used for "NULL" to indicate that no value is available, and is understood automatically by MySQL if imported.

Notes:
  • Routes are directional: if an airline operates services from A to B and from B to A, both A-B and B-A are listed separately.
  • Routes where one carrier operates both its own and codeshare flights are listed only once.

Sample entries

BA,1355,SIN,3316,LHR,507,,0,744 777
BA,1355,SIN,3316,MEL,3339,Y,0,744
TOM,5013,ACE,1055,BFS,465,,0,320

Route maps for airports and airlines can be viewed by searching for their names or code in the website's Search box; alternatively, check out the alphabetical list of all covered airports and airlines.

Download

To download the current data dump from GitHub as a comma-delimited file, suitable for use in spreadsheets etc, simply click below:

Download: routes.dat (~2 MB)

Creating and maintaining this database has required and continues to require an immense amount of work. We need your support to keep this database up-to-date: just click on the PayPal link to the right (Visa, MasterCard, American Express and Discover also accepted). We suggest US$50, but any amount at all is welcome, and you may use the data for free if you feel that you are unable to pay. If you do donate, please specify in the comments if you would like a itemized receipt for business expense or tax purposes.

Support OpenFlights

The GitHub copy is only a sporadically updated static snapshot of the live OpenFlights database (see revision log). If you would like an up-to-the-minute copy, or you would like your data filtered by any information available to us (eg. number of routes at the airport), do not hesitate to contact us.

Plane database

The OpenFlights plane database contains a curated selection of 173 passenger aircraft with IATA and/or ICAO codes, covering the vast majority of flights operated today and commonly used in flight schedules and reservation systems. Each entry contains the following information:

Name Full name of the aircraft.
IATA code Unique three-letter IATA identifier for the aircraft.
ICAO code Unique four-letter ICAO identifier for the aircraft.

The data is UTF-8 encoded. The special value \N is used for "NULL" to indicate that no value is available, and is understood automatically by MySQL if imported.

Notes:
  • Aircraft with IATA but without ICAO codes are generally aircraft classes: for example, IATA "747" can be any type of Boeing 747, whereas IATA "744"/ICAO "B744" is specifically a Boeing 747-400.

Sample entries

"Boeing 787","787",\N
"Boeing 787-10","78J","B78X"
"Boeing 787-8","788","B788"

Download

To download the current data dump from GitHub as a comma-delimited file, suitable for use in spreadsheets etc, simply click below:

Download: planes.dat (~5 KB)

Country database

The OpenFlights country database contains a list of ISO 3166-1 country codes, which can be used to look up the human-readable country names for the codes used in the Airline and Airport tables. Each entry contains the following information:

name Full name of the country or territory.
iso_code Unique two-letter ISO 3166-1 code for the country or territory.
dafif_code FIPS country codes as used in DAFIF.Obsolete and primarily of historical interested.

The data is UTF-8 encoded. The special value \N is used for "NULL" to indicate that no value is available, and is understood automatically by MySQL if imported.

Notes:
  • Some entries have DAFIF codes, but not ISO codes. These are primarily uninhabited islands without airports, and can be ignored for most purposes.

Sample entries

"Australia","AU","AS"
"Ashmore and Cartier Islands",\N,"AT"

Download

To download the current data dump from GitHub as a comma-delimited file, suitable for use in spreadsheets etc, simply click below:

Download: countries.dat (~5 KB)

Schedules (Timetables)

OpenFlights is currently considering launching an airline schedule (timetable) data service. Please register your interest by filling out this short survey.

Other

OpenFlights can, on request, create customized versions of the images you see above. Options include higher resolution (suitable for printing), different backgrounds, filtering to highlight an airport or airline, etc. Please contact us for a quote.

OpenFlights offers only airport, airline and route data; we do not have any other data available. We also do not have historical data older than 2009.

Some alternative commercial sources of data include:

If you or a website you know of offers any of these for free, please let us know!

Licensing and disclaimer

The OpenFlights Airport, Airline, Plane and Route Databases are made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License. In short, these mean that you are welcome to use the data as you wish, if and only if you both acknowledge the source and and license any derived works made available to the public with a free license as well.

Licenses for commercial use of data or derived images are available on request. Most simple cases, for example use of an image within a book or other printed publication, are granted for a flat fee of US$100. Please contact us for details.

Airport data derived OurAirports and DAFIF, as well as route data from Airline Route Mapper, is in the public domain. Airline and plane data derived from Wikipedia may be subject to the GNU Free Documentation License. Whether these databases pass the threshold of originality and are thus copyrightable in the United States is an open question, and OpenFlights does not assert the validity or lack thereof of such a claim.

This data is not suitable for navigation. OpenFlights does not assume any responsibility whatsoever for its accuracy, and consequently assumes no liability whatsoever for results obtained or loss or damage incurred as a result of application of the data. OpenFlights expressly disclaims all warranties, expressed or implied, including but not limited to implied warranties of merchantability and fitness for any particular purpose.

Any corrections will be gratefully received.

Sources

Airport base data was generated by from DAFIF (October 2006 cycle) and OurAirports, plus timezone information from EarthTools. All DST information was added manually. Significant revisions and additions made by the users of OpenFlights.

Airline data was extracted directly from Wikipedia's gargantuan List of airlines.

Plane data from List of ICAO aircraft type designators.

Significant revisions and additions made by the users of OpenFlights.

Route data is maintained by and imported directly from Airline Route Mapper. Duplicate entry removal and cross-referencing to airport/airline IDs by OpenFlights.

See also: Help: Database