Then select the area where you are trying to send your letter for a list of the available zip codes for that area. 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. Saintlouis airport code xls free airport codes api data feed. In this video we create a geographic heat map in excel using a free addin. Airport codes from around the world and coordinates. Where can i find a free list of icao and iata airport identifiers. Kennedy international airport, so far so good, but do you know what kul stands for. Iata airport and country codes free download windows version. Airport hotels have grown popular due to their convenience for transient passengers and easy accessibility to the airport terminal.
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. Flight and aviation database download aviation edge. Our airport database is an allin, detailed database of all airports in the world. It also contains csv files with recent airport codes. The database is presented in a simple token delimited format. Search or browse airport codes and airport locations. Airport codes around the world iata 3 letter airport codes. Where do i get a list of airport codes for use in a database. The closest was the iso 3166 country list html version here, but there are a few issues with it in my opinion. Raja sansi india atw appletonoutagamie county regional airport united states aua aruba. Free airport and airline data with iata, icao, latitude, longitude, elevation.
The airline coding directory acd is the official industry source for airline designator codes, threedigit airline numeric codes and location identifiers. Complete list of airport codes for travel agents ccra. The database provides detailed information about the airports listed including. Simply parse the response in whatever language you prefer. Besides being location identifiers of the airports these codes also help in passenger reservation, ticketing and baggagehandling. Airports list hi, i am from turkey, i am a computer engineer. Iata airport and country codes is suitable for 32bit versions of windows xpvista78. Includes city, region, country, latitude and longitude. City links open a map of the city or region with the location and a short description of the airport s as well as some information about the city or region. Some airport structures include onsite hotels built within or attached to a terminal building. Finding the postal codes you need for your post is as simple as few clicks. Download iata airport codes sql, csv, xml downloads. 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. Airport locator, icao, and iata airport codes lookup.
Country list iso 3166 country codes and names in csv and. Update on icaos efforts in the international coronavirus response. We make it easy for you to add an airport code autocomplete field to your travel website. I recently had to add a country selection list on a form on the website of a customer who does business internationally, and couldnt find an uptodate, easytouse list of countries already available. 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. First select your country of choice to be taken to a list of the administrative divisions of that country. It is 320 km north of senegals current capital in dakar.
Icao airport codes names in excel csv sql aviation. Download data tables in csv excel and json formats. Besides being location identifiers of the airports these codes also help in passenger. Global logistics partner please visit us on the web at. Update on icao and who coronavirus recommendations.
Roadlingua is included with the dictionary distribution file. They are also fundamental to the smooth running of hundreds of electronic applications which have been built around these coding systems for. Logisticsworld is a worldwide directory of freight transportation and logistics resources on the internet. Where can i find a free list of icao and iata airport. For example, jfk is the iata code for, you might know it, new yorks john f. We have a spreadsheet containing the number of subscribers from different countries in the world. The icao airport code or location indicator is a fourletter alphanumeric code designating each airport around the world. 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. Most sites let you search for the codes or provides them in a list. 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. North america united states code airport name city, state 1 abq albuquerque international sunport atlanta, georgia 2 alb albany international airport albany, new york 3 atl hartsfieldjackson atlanta international airport atlanta, georgia 4 aus austin bergstrom airport austin, texas 5 bna nashville international airport nashville, tennessee. Find thousands of international airport codes, abbreviations, runway lengths and other airport information for major airports, landing pads, strips and heliports.
You can find it in below in the list of iata codes for airports in or near cities throughout the world, arranged alphabetically by city names. Data hub for all the worlds airports world airport codes. List of country codes and locode mainfreight singapore. The collection of scripts we used to compile the csv file. This is a comprehensive database of world city names with latitude and longitude for all the cities and places of each of the continents every country and region.
The icao codes are used by air traffic control and airline operations such as flight planning. Logisticsworld is the home of the www virtual library of logistics, the www virtual library of trucking, and the logisticsworld logistics business directory. Oct 23, 2008 i couldnt find a list of codes issued by iata. Our airport codes directory provides a comprehensive list of threeletter airport codes covering the united states and international. 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. For ip to city mappings, see our maxmind city product. Where do i get a list of airport codes for use in a. 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. Iata airport and country codes is an application that includes two dictionaries, for country and airport codes. We make accessing the airport codes data a breeze with a simple json response. List of country codes by alpha2, alpha3 code iso 3166. Iata codes are an integral part of the travel industry and essential for the identification of an airline, its destinations and its traffic documents. These codes are used throughout the it industry by computer systems and software to ease the identification of country names.
International airport codes iata 3letter code for airports nations. Are you interested in cheaper parking at uk airports. Iata 3letter codes, a comprehensive list of cities and airports throughout the world with the 3letter location identifier code for airports and cities. Airports around the world are universally known by a unique threeletter code. The airport codes may refer to either iata airport code, a threeletter code which is. I need it either in a format that can be exported to a database xml, excel, csv, etc. Free download icao airport database with a list of names and icao. Download iata airport codes database and gain access to unique threeletter iata city codes, each associated with a specific airport in the world. International airport codes iata 3letter code for airports. The zip file contains a readme which describes the format of the csv dump. 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. The readme file should tell you everything you need to know. Welcome to world airport codes, the place to find over 47,000 airport codes, abbreviations, runway lengths and other airport information.
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. 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. Open data downloads data should be open and sharable. Airport codes excel software free download airport codes excel.
Jul 08, 2011 download iata airport codes sql, csv, xml downloads. The database is presented in a simple token seperated format. Cities databases by country were happy to offer free world cities databases by country. They include fields such as latitude, longitude, population and more. You need this spreadsheet to interpret the country codes in the airports and navaids files.
World airport maps and illustrations of international airports. Icao secretary general contributes to wef2020 discussions on 21st century mobility, unmanned aircraft applications, and cleaner skies. I make the database available as a commadelimited flat file. 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. Saintlouis airport is an airport serving saintlouis, the capital of the saintlouis region in senegal. The global airport database gadb is a free downloadable database of 9300 airports big and small from all around the world.