Mar 16, 2020 the airport codes may refer to either iata airport code, a threeletter code which is used in passenger reservation, ticketing and baggagehandling systems, or the icao airport code which is a four letter code used by atc systems and for airports that do not have an iata airport code from wikipedia. World airport database download in excel, csv and sql we collect airport details from a number of resources. Microsoft excel users should read the special instructions below. Sultan abdul halim airport malaysia apf naples municipal airport united states apl nampula international airport mozambique apw faleolo international airport pac. Jul 08, 2011 download iata airport codes sql, csv, xml downloads. Country codes is a small database of country codes and additional information for. Iata 3letter codes, the location identifier code of airports and cities around the world. To download the current data dump from github as a very straightforward csv commaseparated value file, suitable for use in spreadsheets etc, simply click below. Complete list of airport codes for travel agents ccra. The complete list of over 36,000 airports and codes is available in two ways. I need it either in a format that can be exported to a database xml, excel, csv, etc. Explanatory information the air, rail and seaport codes are for use when completing customs documentation for uk trade with countries outside the european union. I make the database available as a commadelimited flat file. We provide this information for all of our travel agency members.
Find thousands of international airport codes, abbreviations, runway lengths and other airport information for major airports, landing pads, strips and heliports. Corrections and additions by email are much appreciated. The airport codes may refer to either iata airport code, a threeletter code which is. Please make sure to use the right codes for travel. They are also fundamental to the smooth running of hundreds of electronic applications which have been built around these coding systems for. Itineraries can include an unlimited number of airports. World airport database with detailed data on every airport. Download data tables in csv excel and json formats. Mar 23, 2020this page provides the message formats and technical specifications necessary to electronically transmit data to cbps automated systems. Large file, listing worldwide radio navigation aids.
The list below features airport codes starting with letter a. Welcome to world airport codes, the place to find over 47,000 airport codes, abbreviations, runway lengths and other airport information. Search or browse airport codes and airport locations. Jackson international airport united states atq amritsar international airport. Download options there are two ways you can download the countries list view in browser the show countries list button link opens the selected list as a regular plain text document in a new window or tab in your browser. Airport locator, icao, and iata airport codes lookup. World airport codes website offers alphabetical lists of airport codes. Airport codes excel software free download airport codes excel.
By selecting a country or territory, the system displays the entire unlocode code list of the country or territory. Data hub for all the worlds airports world airport codes. Airport codes find every airport code in the world. In addition to basic flight distances, the calculator supports elitelevel, booking class, and promotion bonus miles. Saintlouis is located near the senegal river, and served as the senegals capital until independence in 1960. Map charts have gotten even easier with geography data types. The zip file contains a readme which describes the format of the csv dump. World airport codes provides info for almost every airport in the world, including airport codes, abbreviations, runway lengths and other airport details. The database can be downloaded or reached through api.
The readme file should tell you everything you need to know. Where do i get a list of airport codes for use in a database. Download32 is source for airport codes shareware, freeware download aw airport codes pocket pc, aw airport codes palm os, travelers database on airport codes, ltsairports, airport codes 2012, etc. Other codes rail codes seaport codes airport codes information air, rail and seaport codes. The files contain codes for 3592 international airports sorted by name. I have used the best data available as of 30 nov 06 to come up with the formulas contained herein. The great circle mapper draw you flight path on a map and calculate the great circle distance in nautical miles and kilometers. World airport codes is the place to find airport codes, abbreviations, runway lengths and other airport information for nearly every airport worldwide. The airline coding directory acd is the official industry source for airline designator codes, threedigit airline numeric codes and location identifiers. City airport codes software free download city airport codes. Dw 187 ucr acr aerocharter airlines ukraine e2 837 kmp kampuchea airlines cambodia e4 532 rso aero asia international pakistan e6 417 brc bringer air cargo brazil e8 789 elg alpi eagles italy e9 766 trj ajt air international russia eb 591 eww emery worldwide united states ed 484 abq airblue pakistan eg 688 jaa japan asia airways japan. Excel will automatically convert your data to a geography data type, and will include properties relevant to that data that.
Airport code airport name country aoi ancona airport italy aor alor setar. Get estimated flight time by choosing an aircraft type or entering the cruising speed. Unlocode code list by country and territory trade unece. Our database is also used by many flight tracking software applications. It is 320 km north of senegals current capital in dakar. Download iata airport codes sql, csv, xml downloads. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the data tab data types geography. Download icao airport database with a list of names and icao codes. Most sites let you search for the codes or provides them in a list.
Flight and aviation database download aviation edge. The business project needs various activities which required to be fulfilled within the specified period of time and this type of travel schedule includes all the. The airport database which is prepared from different sources is then fed into our software, each entry is checked thoroughly by modules developed by our engineers which highlight any discrepancy. Roadlingua is included with the dictionary distribution file. I dont not take responsibility for any problems that might come up prior to, during, or after an airline interview. The codes are to be used to complete the location of goods box box 30 of the sad. They are also fundamental to the smooth running of hundreds of electronic applications which have been built around these coding systems for passenger and cargo traffic purposes. Airport codes from around the world and coordinates. Developed back in 2003, primarily with the aviation enthusiasts in mind, world airport codes should also prove useful to travellers, researchers or even those with only a fleeting interest in. Aviation edge database and api aviation database and api. The collection of scripts we used to compile the csv file. Cantonakron, oh cak cape girardeau, mo cgi cape lisburne, ak lur cape newenham, ak ehm. This program should be used as a tool for converting military flight time to civilian time. It includes the proper scheduling of construction activities, the times that the workforce is needed in the location, and the.
Quickly add airport codes, then calculate the total itinerary mileage. Saintlouis airport is an airport serving saintlouis, the capital of the saintlouis region in senegal. It also contains csv files with recent airport codes. The current version was published in december 2019 by selecting a country or territory, the system displays the entire unlocode code list of the country or territory the list of country and territory names official short name in english as in iso 3166 appears in alphabetical order, with the. Browse airports by iata codes starting with the letter f. The following data table of shows iata and icao airport codes of 4046 airports worldwide. Airports list hi, i am from turkey, i am a computer engineer. All internationally used codes such as iata and iso codes, names and local translations where available, longitude and latitude information, country and timezone information, routes, contact detail and many more groups of data are included in this database. Ourairports has rss feeds for comments, csv and hxl data downloads for geographical regions, and kml files for individual airports and personal airport lists so that you can get your personal airport list any time you want microsoft excel users should read the special instructions below.
Oct 23, 2008 i couldnt find a list of codes issued by iata. Airport name airport city and state airport country 3 digit airport code 4 digit airport code 2015 traffic hartsfield jackson atlanta international airport atlanta georgia united states atl katl 101491106. Update on icao and who coronavirus recommendations. Congo brazzaville congo kinshasa coral sea islands. The list shows 3letter location identifier codes predominantly for airports and.
From that page you can easily mark, select and copy the data. Logisticsworld is the home of the www virtual library of logistics, the www virtual library of trucking, and the logisticsworld logistics business directory. Iata codes are an integral part of the travel industry and essential for the identification of an airline, its destinations and its traffic documents. Raja sansi india atw appletonoutagamie county regional airport united states aua aruba. It actually contains data about all aviation platforms, including private and public airports, airstrips, helipads, seaports and much more. Icao secretary general contributes to wef2020 discussions on 21st century mobility, unmanned aircraft applications, and cleaner skies. International direct distance dialing country code and flag, fips. Our airport codes directory provides a comprehensive list of threeletter airport codes covering the united states and international. Iata airport and country codes is an application that includes two dictionaries, for country and airport codes. A simple excel spreadsheet that will convert three letter iata airport codes into four letter icao airport codes and displays the airport name and city. The list of country and territory names official short name in english as in iso 3166 appears in alphabetical order, with the corresponding iso 31661alpha2 code elements. Below is a comprehensive list of cities and airports throughout the world. Airport codes excel software free download airport codes.
It also includes iso currency, country codes, lists contacts for minimum connecting times mct, coordinators and airlines applying reconfirmation procedures, as well as the numeric. For no cost at all, use the form just above to search the database for the codes, cities, airports, states, or countries you are interested in. The airport codes may refer to either iata airport code, a threeletter code which is used in passenger reservation, ticketing and baggagehandling systems, or the icao airport code which is a four letter code used by atc systems and for airports that do not have an iata airport code from wikipedia. Open data downloads data should be open and sharable. Its possible to download in excel, csv or sql format. Download32 is source for airport codes shareware, freeware download aw airport codes pocket pc, aw airport codes palm os, travelers database on.
Global logistics partner please visit us on the web at. Click in the large textfield above to enter all the airports of your flight route. Download list countries, territories in continents or. Department of transportation federal aviation administration 800 independence avenue, sw washington, dc 20591 866 tellfaa 866 8355322. In the list are many locations where you most likely enter a country. Airport and aviation database great circle mapper flight. Logisticsworld is a worldwide directory of freight transportation and logistics resources on the internet.
Usually the browsers cache will stop having to download the file on each page load. Unique openflights identifier for airline see airline. Where do i get a list of airport codes for use in a. The list below allows obtaining the unlocode code list 20192 for each country or territory. This can be useful if your web application needs to convert airport names. Are you interested in cheaper parking at uk airports. Free airport and airline data with iata, icao, latitude, longitude, elevation, timezone, dst information. I have a list of airport codes, names, and locations in an excel spreadsheet like the below.
Al cda al cdn icao airline country dw 187 ucr acr aero. As of june 2014, the openflightsairline route mapper route database contains 67663 routes between 3321 airports on 548 airlines spanning the globe, as shown in the map above. Saintlouis airport code xls free airport codes api data feed. This document may qualify as a guidance document as set forth in exec. See countries to crossreference to iso 31661 codes.
319 149 573 34 1256 1208 889 905 242 441 1620 291 319 296 19 390 690 241 947 1443 1577 219 574 1076 469 1554 503 109 305 770 1384 185 224 918 454 943 223 900 208 116