Get the complete database in your preferred format. Free, no registration, updated monthly.
Licensed under Creative Commons Attribution 4.0 International (CC-BY-4.0). Share, adapt, and use for any purpose, including commercial use, as long as you provide appropriate credit.
-- Schema: airports (12 columns)
-- Updated: July 2026
iata_code CHAR(3) -- 3-letter IATA code (e.g. JFK, LHR)
icao_code VARCHAR(10) -- ICAO code or FAA ident (e.g. KJFK, EGLL)
name TEXT -- full airport name
type VARCHAR(32) -- large_airport, medium_airport, small_airport, heliport, seaplane_base
latitude DOUBLE -- decimal degrees (WGS84)
longitude DOUBLE -- decimal degrees (WGS84)
elevation DOUBLE -- elevation in metres above sea level
country_code CHAR(2) -- ISO 3166-1 alpha-2 country code (e.g. US, GB)
region_code VARCHAR(7) -- ISO 3166-2 region code (e.g. US-NY, CN-BJ)
municipality TEXT -- city or town name
iana_time_zone TEXT -- IANA timezone (e.g. America/New_York, Europe/London)