Airport Codes (IATA / IACO)

Airport codes are used to distinguish airports around the world to ensure that there is no confusion between countries and cities. Airport codes appear on passengers’ documents related to their reservations, flight tickets and they are also used by air traffic controllers and pilots.

The data set contains a single table of airport codes with the following attributes.

ID NUMBER It is the Internal integer identifier for the airport. This will stay persistent, even if the airport code changes.

IDENT TEXT The text identifier used to identify the codes of the airports. This is the ICAO code where applicable. Otherwise, it is a local airport code (if no conflict), or if nothing else is available, an internally-generated code starting with the ISO2 country code, followed by a dash and a four-digit number.

TYPE TEXT The type of the airport. The values are “closed_airport”, “heliport”, “large_airport”, “Balloon port”, “medium_airport”, “seaplane_base”, and “small_airport”

NAME TEXT The official airport name, including “Airport”, “Airstrip”, etc.

LATITUDE_DEG DECIMAL The airport latitude in decimal degrees (positive for north).

LONGITUDE_DEG DECIMAL The airport longitude in decimal degrees (positive for east).

ELEVATION_FT NUMBER The airport elevation MSL in feet (not metres).

ELEVATION_MT NUMBER The airport elevation MSL in metres.

CONTINENT TEXT The code for the continent where the airport is (primarily) located. The values such as “AF” (Africa), “AN” (Antarctica), “AS” (Asia), “EU” (Europe), “NA” (North America), “OC” (Oceania), or “SA” (South America).

ISO_COUNTRY TEXT The two-character ISO 3166:1-alpha2 code for the country where the airport is (primarily) located. A handful of unofficial, non-ISO codes are also in use, such as “XK” for Kosovo.

ISO_REGION TEXT An alphanumeric code for the high-level administrative subdivision of a country where the airport is primarily located (e.g. province, governorate), prefixed by the ISO2 country code and a hyphen.

MUNICIPALITY TEXT The primary municipality that the airport serves (when available). Note that this is not necessarily the municipality where the airport is physically located.

SCHEDULED_SERVICE TEXT “yes” if the airport currently has scheduled airline service; “no” otherwise.

GPS_CODE TEXT The code that an aviation GPS database (such as Jeppesen’s or Garmin’s) would normally use for the airport. This will always be the ICAO code if one exists. This is not guaranteed to be globally unique.

IATA_CODE TEXT The three-letter IATA code for the airport (if it has one).

LOCAL_CODE TEXT The local country code for the airport, if different from the gps_code and iata_code fields (used mainly for US airports).

HOME_LINK TEXT URL of the airport’s official home page on the web, if one exists.

WIKIPEDIA_LINK TEXT URL of the airport’s page on Wikipedia, if one exists.

KEYWORDS TEXT Extra keywords/phrases to assist with search, comma-separated. May include former names for the airport, alternate codes, names in other languages, nearby tourist destinations, etc.

The data dictionary can also be found in the documentation together with additional information.

搜集汇总

背景与挑战

背景概述

该数据集提供全球机场的代码信息，用于唯一区分机场，避免国家和城市间的混淆，并应用于乘客预订、机票及航空管理。数据集包含机场的多种属性，如代码、类型、名称、经纬度、所属大洲和国家、服务状态等，支持机场标识和位置查询。