Lifetime updates. Come back once in a while to stay updated of new versions of this database.

Database of 9,433 World Airports (Code, Area Code, Runway, Longitude, Latitude, Country)

Database Description:

This is simple one table database of 9,433 airports (unique, with 9,433 distinct airport codes) around the globe. Each airport record has a name, an airport code, a world area code, city name, country (both abbreviation and common name), length of runway, elevation of runway, longitude, latitude, GMT offset, telephone number, fax number, website URL and email address.

655 airports have a telephone number. 389 airports have a fax number. 816 airports have a website URL. 347 airports have an email address. All other fields are fully populated with usable data.

Database Meta:

  • Size: 1.6 MB
  • Last updated: May 7th, 2012
  • Formats Included: MySQL dump .sql text file, CSV, MS Excel
  • Tables: 1

Buy Now & Download: $189.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: Database of 9,433 World Airports (Code, Area Code, Runway, Longitude, Latitude, Country) for Sale

Table Details (Data Structure / Schema):

  • airport
    Records:9,433

    The one table in this database that contains all the airports data.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. airport_code: varchar(255)
    4. world_area_code: char(3)
    5. country_abbreviation: char(2)
    6. country_name: varchar(255)
    7. runway_length: varchar(255)
    8. runway_elevation: varchar(255)
    9. city: varchar(255)
    10. longitude: varchar(255)
    11. latitude: varchar(255)
    12. gmt_offset: varchar(255)
    13. telephone: varchar(255)
    14. fax: varchar(255)
    15. website: varchar(255)
    16. email: varchar(255)

Buy Now & Download: $189.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • Travel reference / aviation reference site
  • Aviation community / website reference
  • World airports reference

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.