Those companies assigned an iata airline designator code are to use such designators for reservations, schedules, timetables. Receive data in any format, from flat file transfer to smart api. These codes are defined by the international civil aviation organization, and. Airline name alaska airlines aloha air america west airlines american airlines air one continental airlines delta air lines hawaiian airlines. Convert zip codes in a block of selected cells in ms excel.
The executive offices are at the geneva airport in switzerland. Download all airports with iata codes iata is the international air transport association. The list shows 3letter location identifier codes predominantly for airports and some cities as well. The free images are pixel perfect to fit your design and available in both png and. The aviation codes web site iata icao airline codes databse search. Airline codes, airline numbers and airline websites. Iata code mawb iata code iata airlines iata 001 iata aa american airlines iata 002 iata 2g cargoitalia alternate iata 005 iata co continental airlines iata 006. Unique openflights identifier for airline see airline.
Used often in combination with other api solutions such as the flight tracker, airline schedules and routes. Iata 3letter codes, the location identifier code of airports and cities around the world. Weve put together a comprehensive guide to all airline codes used in the airline industry. 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.
Get free icons of airline in ios, material, windows and other design styles for web, mobile, and graphic design projects. There are two ways to obtain the airline database, either by downloading it in excel, csv or sql format or by. Search the website to instantly connect with cargo related businesses. 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. 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.
Free airport and airline data with iata, icao, latitude, longitude, elevation, timezone, dst information. Airport codes excel software free download airport codes. A list of all countries regions provinces, states, etc. Find out the 2letter code of an airline or identify to which airline a 2letter code corresponds. The database is a foundation for a wide range of software applications. Aviation edge database and api aviation database and api. 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. The idea behind using a macro code is to automate an action which you perform manually in excel, otherwise. The list below will help you find out the airline two letter code and designator. Threeletter iata codes and fourletter icao codes for all the worlds airports inc commercial, military, coast guard, helicopter, sea plane and more over. Download icons in all formats or edit them for your designs.
Airports around the world are universally known by a unique threeletter code. It also indicates if an airline is a member of an alliance. Jp airlines fleets freeware free download jp airlines fleets. Airlabs database, aviation database, airlines database, airports database, iata, icao, iata codes, iata codes database, iata database, iata codes api, iata api, iata. New charts and graphs help you present your data in compelling ways, with formatting, sparklines, and tables.
Airline codes find every airline code in the world. If its happening in commercial aviation, youll get the information and opinions here first. 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. You need this spreadsheet to interpret the region codes in the airport file. Airline two letter codes sterling travel management.
The worlds largest and most accurate airline schedules database. 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. Keep passengers, ground staff and clients up to date with changes via travel apps, email, and airport management systems. Official department of civil aviation government of bermuda web page of current civil registered aircraft. Access the worlds largest and most accurate airline schedules database. 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. Iata airport and city codes and names database aviation edge. Jul 08, 2011 download iata airport codes sql, csv, xml downloads.
The international air transport associations iata location identifier is a unique 3letter code also. Major airport code major city code major airline code list a b c d e f g h i j k l m n p. For example, you can use a code to print only a particular range of cells just with a single click instead of selecting the range file tab print print select ok button. World airport database with iata code, icao code, latitude and longitude contains records of more than 11,000 airports around the world. No airline iata numeric code1 icao no airline iata numeric code1 icao 1 ada air zy 121. Create spreadsheets with ease from templates or on your own, and perform calculations with modern. Corrections and additions by email are much appreciated. As well, welcome to check new icons and popular icons. Hi i am looking for an excel xls sheet with 2 letter. A complete database of all the airlines in the world. May 04, 2020 open data downloads data should be open and sharable. Historical assignments are also included for completeness.
See countries to crossreference to iso 31661 codes. The airport codes may refer to either iata airport code, a threeletter code which is. This airline and location code search engine provides an official source for codes assigned by iata. List of airport codes, locations and other information around the world datasetsairportcodes. Countryairportairline codes list in pdf format discussions about factual events happening in the airline and general aviation industries.
Promo code expires on date indicated and can be withdrawn at anytime without notice. Keep passengers, ground staff and clients up to date with changes. The table lists the iata airline designators, the icao airline. Enhanced by intelligence, excel learns your patterns, organizing your data to save you time. They are also fundamental to the smooth running of hundreds. Click on air traffic management, then click on ais and on the left menu click on products and services, then click on aircraft register. Iata airport and city codes and names database aviation. The table lists the iata airline designators, the icao airline designators and the airline call signs telephony designator. Airport codes from around the world and coordinates. The database is available in both microsoft excel spreadsheet and microsoft access database format.
Besides being location identifiers of the airports these codes also help in passenger. Jun 17, 2019 list of airport codes, locations and other information around the world datasetsairport codes. Find out the 2letter code of an airline or identify to which airline a 2letter code corresponds find out the 3letter code of a location airport, city or identify which airport or city uses a particular code. In this airline codes list of you can find the most current last updated on 14. Al cda al cdn icao airline country dw 187 ucr acr aero. Airline two letter codes business travel and event. Download iata airport codes sql, csv, xml downloads. This is a partial list of iata airline codes for international carriers provided. Iata and icao codes, full name, web site and country of airlines in the world system requirements. The free images are pixel perfect to fit your design and available in both png and vector. Malaysian airline system iata 232 iata mh iata 232 iata mh homepage iata 234 iata jd japan air system iata 235 iata tk turkish airlines iata 236 iata bd british midland airways iata 239 iata mk air mauritius iata 257 iata os. Bookmarkshare this page below is a comprehensive list of cities and airports throughout the world. Discussions about factual events happening in the airline and general aviation industries. Open data downloads data should be open and sharable.
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. Consisting of hundred of airlines, primarily major carriers, representing a hundred of countries, the iatas member. The aviation codes web site airline codes, airport codes. The international air transport association iata is an international industry trade group of airlines headquartered in montreal, quebec, canada, where the international civil aviation organization is also headquartered. The list contains 2digit iata international air transport association. A significant number of records also contain information about the elevation or altitude of the airport above sea level and read more. 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. 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. The following data table of shows iata and icao airport codes of 4046 airports worldwide. For example, change city, state to zip or zip to city, state. International airport codes iata 3letter code for airports.
Download data tables in csv excel and json formats. Find out the 3letter code of a location airport, city or identify which airport or city uses a particular code. The international air transport association iata is an international industry trade group of airlines headquartered in montreal, quebec, canada, where the international civil aviation organization is also. Ourairports has rss feeds for comments, csv and hxl data downloads for geographical regions, and kml files for individual. 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. The worlds largest and most accurate airline schedules. Besides being location identifiers of the airports these codes also help in passenger reservation, ticketing and baggagehandling. 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. Download iata airport codes database and gain access to unique threeletter iata city. Create spreadsheets with ease from templates or on your own, and perform calculations with modern formulas.