An iata airport code, also known as an iata location identifier, iata station code or simply a location identifier, is a threeletter code designating many airports around the world, defined by the international air transport association. Airline codes for download to excel the two character airline designator listed are for use in reservations, timetables, tickets, tariffs, air waybills, schedules publications and in airline interline telecommunications, as well as for the airline industry applications. City links open a map of the city or region with the location and a short description of the airports as well as some information about the city or region. Its not the data i have an issue with, as i pulled the codes originally from this site. The database provides detailed information about the airports listed including. This new efficient web download version allows iata to update the information such as new airlines, designators and location identifiers on a more frequent basis, i. Scribd is the worlds largest social reading and publishing site. A b c d e f g h i j k l m n o p q r s t u v w x y z city. Since the data is intended primarily for current flights, defunct iata codes are. United states airport codes alabama al birmingham international airport bhm dothan regional airport dhm huntsville international airport hsv mobile mob montgomery mgm alaska ak anchorage international airport anc fairbanks international airport fai juneau international airport jnu.
The database is presented in a simple token delimited format. International airport codes iata 3letter code for airports. Iata city and airport codes a b c d e f g h i j k l m n o p q r s t u v w x y z city code city code aalborg amba aal aarhus aar aberdeen ltd abz abu dhabi auh. You can download the database in excel, sql or csv format. I then select the folder on my machine that contains the attached custom geocoding data for airport codes ive attached the file to this thread. You need this spreadsheet to interpret the region codes in the airport file. Where can i find a free list of icao and iata airport identifiers. The international air transport associations iata location identifier is a unique 3letter code also commonly known as iata code used in aviation and also in logistics to identify an airport. A b c d e f g h i j k l m n o p q r s t u v w x y z city code.
This airline and location code search engine provides an official source for codes assigned by iata. The airport codes may refer to either iata airport code, a threeletter code which is. Download data tables in csv excel and json formats. The icao airport codes database is very developer friendly and its available for download in many different formats. Get iata codes, icao codes and european country codes from the largest international airports in the united kingdom, france, italy, spain or germany to the smaller, national and local airports in europe. Where can i find a free list of icao and iata airport. The dst column shows the months in which daylight saving time, a.
Iata delay codes others 6 9 oa sg no gatestand available. May 31, 2018 world airport database with iata code, icao code, latitude and longitude contains records of more than 11,000 airports around the world. 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. The first letter of icao code represents the region, the second letter is for countries and last two are for the name of the city in which the airport is located.
The global airport database gadb is a free downloadable database of 9300 airports big and small from all around the world. How many iata airport codes excel download results are available. Iata has a mechanism for assigning these airport codes thats available online. It allows you to download the most recent, official lists of country codes andor subdivisions not to mention formerly used codes in one convenient location. Download iata airport codes sql, csv, xml downloads.
By continuing to use our website, you agree to this. Please make sure to use the right codes for travel. During a recent project i needed a database of iata airport codes. They are also fundamental to the smooth running of hundreds of electronic applications which have been built around these coding systems for. According to couponxoos tracking system, there are currently 21 iata airport codes excel download results. Airport codes europe eu european airports airportcodes. Browse airports by iata codes starting with the letter s. 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. Where can i get a list of all airports codes, names. Iata airport and country codes is an application that includes two dictionaries, for country and airport codes.
Iata codes location airport location airport location airport aalborg aal glasgow gla okinawa oka aarhus aar glasgow, prestwick pik oklahoma city okc abadan abd goma gom omaha oma abakan aba goodnew bay gnu ontario ont aberdeen abr goose. Search the website to instantly connect with cargo related businesses. Open data downloads data should be open and sharable. This article is a navigation aid to access the lists that contain the data. Airport codes excel software free download airport codes. Search for major codes of european airports alphabetically, by country or by region.
Jul 08, 2011 download iata airport codes sql, csv, xml downloads. According to the wikipedia article on iata codes there have been several iata codes that have been reassigned. United states airport codes alabama al birmingham international airport bhm dothan regional airport dhm huntsville international airport hsv. Airports around the world are universally known by a unique threeletter. Find out the 3letter code of a location airport, city or identify which airport or city uses a particular code.
Download our icao airport codes database and gain access to unique fourletter icao codes each associated with a particular airport in the world. Easy to use, convenient roadlingua dictionary viewer extremely fast dictionary. Besides being location identifiers of the airports these codes also help in passenger reservation, ticketing and baggagehandling. Decimal degrees, usually to six significant digits. 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.
Airport codes excel software free download airport codes excel. 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. International airport codes iata 3letter code for airports nations. Iata 3letter codes, a comprehensive list of cities and airports throughout the world with the 3letter location identifier code for airports and cities. If a location is currently on dst, add one hour to the time in the time column. Find out the 2letter code of an airline or identify to which airline a 2letter code corresponds. World airport database with iata code, icao code, latitude and longitude contains records of more than 11,000 airports around the world.
Unique openflights identifier for airline see airline. Below you will find a list of iata codes in alphabetic order beginning with the letter a. Aviationedge ensures full support during subscription process and after database download. A blank dst box usually indicates that the location stays on standard time all year, although in some cases the location stays on summer time all year. When i attempt to load it i get the following error. Two dictionaries are included for country and airport codes. Embedded in the excel file are two files that you will need to do this work. 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. Al cda al cdn icao airline country dw 187 ucr acr aero. 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. Iata airport and city codes and names database aviation. The prefix statements are included here but can be omitted if these default prefixes are used i just discovered.
The software comes with a worldwide database with,000 airports, including icao and iata identifiers and geographical coordinates. The database is available in both microsoft excel spreadsheet and microsoft access database format. 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. Gift download icao airport database with a list of names and icao. The list shows 3letter location identifier codes predominantly for airports and some cities as well. Corrections and additions by email are much appreciated. Aircraft type in iata format 3 digits number of seats and aircraft type have to be entered without a blank in between. Although your original calculation came to some 17000 possible codes, theres a wide variety of reserved codes, and prefixes, so its actually less than 17500. This is a list of airports by iata code and icao code. Icao airport codes names in excel csv sql aviation. These deal offers are from many sources, selected by our smart and comprehensive system on coupon code, discounts, and deals. Iata 3 letter city transport companies airlines scribd. The new discount codes are constantly updated on couponxoo.
A list of all countries regions provinces, states, etc. Iata airport and city codes and names database aviation edge. The first letter of icao code represents the region, the. Apply and search for iata codes like airline designators, accounting or prefix, baggage and location identifiers.
Airport codes from around the world and coordinates. World airport database with iata code, icao code, latitude. Iata airport codes excel download can offer you many choices to save money thanks to 18 active results. This article includes an aviationrelated list of lists. List of country codes and locode mainfreight singapore.
Download iata airport codes database and gain access to unique threeletter iata city codes, each associated with a specific airport in the world. Iata codes are an integral part of the travel industry and essential for the identification of an airline, its destinations and its traffic documents. The airline coding directory is now available as a windows desktop application. The global airport database by arash partow is a free online downloadable database of aiports big and small, commercial and military from around the world. Iata codes location airport location airport location airport aalborg aal glasgow gla okinawa oka aarhus aar glasgow, prestwick pik oklahoma city okc abadan abd goma gom omaha oma abakan aba goodnew bay gnu ontario ont aberdeen abr goose bay yyr oran orn aberdeen abz goroka gka orebro orb abha ahb gothenburg got orlando mco. International air transport association iata airportcountry codes. Free airport and airline data with iata, icao, latitude, longitude, elevation. Download icao airport database with a list of names and icao codes download our icao airport codes database and gain access to unique fourletter icao codes each associated with a particular airport in the world. Figure 1 shows some airport iata codes that are included in an excel file you can download by clicking here. A significant number of records also contain information about the elevation or altitude of the airport above sea level and read more. The database is presented in a simple token seperated format. The collection contains the codes from parts 1, 2 and 3 of iso 3166 in 3 different formats. Besides being location identifiers of the airports these codes also help in passenger. Sign up excel list of all iata codes and geocodes from.
1572 1480 711 4 1278 1077 1357 792 715 459 1251 761 714 1622 791 910 1094 1042 204 250 38 1358 233 779 542 1494 663 797 120 35 1327 606 675 1057 1234 213 491