Global Airports — IATA/ICAO Codes, Coordinates, Altitude, Time Zones (OpenFlights)

DatasetCSV.GZOpenAirportsAviationGeographyIataReferenceFree

7,698 airports, heliports and stations worldwide with IATA and ICAO codes, city, country, latitude/longitude, altitude, UTC offset and IANA time zone, from the OpenFlights airports database as of 2026-09-05.

Use Cases

Airport code lookups
Route and distance calculations
Geospatial joins

Methodology

Parsed airports.dat; rows without valid coordinates dropped; OpenFlights null markers blanked.

Update Schedule

Static snapshot. OpenFlights updates irregularly; refresh quarterly.

Attribution

Source: OpenFlights airports database (openflights.org), Open Database License (ODbL).

Schema

name	type
openflights_id	integer
name	string
city	string
country	string
iata	string
icao	string
latitude	number
longitude	number
altitude_ft	integer
timezone_offset	number
dst	string
tz	string
type	string
source	string

Sample Data

tz	dst	city	iata	icao	name	type	source	country	latitude	longitude	altitude_ft	openflights_id	timezone_offset
Pacific/Port_Moresby	U	Goroka	GKA	AYGA	Goroka Airport	airport	OurAirports	Papua New Guinea	-6.081689834590001	145.391998291	5282	1	10
Pacific/Port_Moresby	U	Madang	MAG	AYMD	Madang Airport	airport	OurAirports	Papua New Guinea	-5.20707988739	145.789001465	20	2	10
Pacific/Port_Moresby	U	Mount Hagen	HGU	AYMH	Mount Hagen Kagamuga Airport	airport	OurAirports	Papua New Guinea	-5.826789855957031	144.29600524902344	5388	3	10
Pacific/Port_Moresby	U	Nadzab	LAE	AYNZ	Nadzab Airport	airport	OurAirports	Papua New Guinea	-6.569803	146.725977	239	4	10
Pacific/Port_Moresby	U	Port Moresby	POM	AYPY	Port Moresby Jacksons International Airport	airport	OurAirports	Papua New Guinea	-9.443380355834961	147.22000122070312	146	5	10

Get this via API

# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
#    Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
#    Cursor / Claude Code / others: mcp.json
{
  "mcpServers": {
    "dagentbase": {
      "url": "https://dagentbase.com/api/mcp",
      "headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
    }
  }
}

# 2. Then ask your agent, in plain language:
#    "Preview 'Global Airports — IATA/ICAO Codes, Coordinates, Altitude, Time Zones (OpenFlights)' and, if it fits, claim it and download the files."
#    Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls

# 1. Add dAgentBase once, in any MCP client. No install, no vendor keys.
#    Claude.ai / Claude Desktop: Settings -> Connectors -> Add custom connector
#    Cursor / Claude Code / others: mcp.json
{
  "mcpServers": {
    "dagentbase": {
      "url": "https://dagentbase.com/api/mcp",
      "headers": { "Authorization": "Bearer dm_live_YOUR_KEY" }
    }
  }
}

# 2. Then ask your agent, in plain language:
#    "Preview 'Global Airports — IATA/ICAO Codes, Coordinates, Altitude, Time Zones (OpenFlights)' and, if it fits, claim it and download the files."
#    Tools it will use: search_listings -> preview_listing -> purchase_listing -> get_download_urls

Free

one time · open license

Details

Rows7,698

Size327.2 KB

Files1

FormatCSV.GZ

Available formats

CSV.GZ327.2 KB

Freeopen