Sharing my database of Aircraft, Airports and Routes

I have been gathering data for few years now, from multiple sources (databases found online, some special aircraft found manually online, …). I now have more than 35000 entries in my database of aircraft, including 6,000 that I flagged as “special”, meaning military or any other interesting features (helicopters, rare aircrafts …).

I also have more than 16,000 airports and 160,000 routes.

They are all accessible through dedicated API, returning detailed values in json format. I am happy to share them with the community, as most of the source I have been using are built by the community. I am always looking for new sources to identify the 10000+ unidentified hex codes I have been seeing or the years. Do not hesitate to share your sources in comments if you have great one. I will make a dedicated post about that someday.

Search aircraft by Mode S code or tail number

You can access my database of aircraft through the following API:
https://www.foxtrotcharlie.ovh/API/public/api?ModeS=XXXXXX
where XXXXXX is the ModeS code of the aircraft, on 6 digits in hexadecimal.
https://www.foxtrotcharlie.ovh/API/public/api?Registration=XXXXXX
where XXXXXX is the tail number (or registration) of the aircraft (in some countries, tail numbers have a – like in China B-8638, it should be put here).
The output is in json format (RFC4627).
Working samples of the API:
https://www.foxtrotcharlie.ovh/API/public/api?ModeS=78102f
https://www.foxtrotcharlie.ovh/API/public/api?Registration=B-8638

Returned data:

      {
          "ModeS":            "78102f",
          "ModeSCountry":     "China",
          "Registration":     "B-8638",
          "ICAOTypeCode":     "A321",
          "Type":             "Airbus A321-211",
          "SerialNo":         "---",
          "RegisteredOwners": "China Southern Airlines",
          "OperatorFlagCode": "CSN",
          "FirstSeen":        "2017-03-25 23:58:09",
          "LastSeen":         "2019-09-06 07:25:41"
      }
  
DesignatorDescriptionFormat
ModeSModeS code in HEX format of the Aircraft6 characters
ModeSCountryCountry of registration of the Aircraftstring
RegistrationTail Number of the Aircraftstring
ICAOTypeCodeICAO Type Code of the Typestring
TypeType of Aircraftstring
SerialNoSerial Number of the Aircraftstring
RegisteredOwnersRegistered Owners of the Aircraftstring
OperatorFlagCodeCode of the Airline if anystring
FirstSeenTime stamp when my trackers first detected the AircraftTimestamp
LastSeenTime stamp when my trackers last detected the AircraftTimestamp
Json structure description for Aircraft API

Search airports by ICAO code

You can also access my database of airports through the following API:
https://www.foxtrotcharlie.ovh/API/public/api?ICAO=XXXX
where XXXX is the ICAO code of the airport on 4 characters.
The output is in json format (RFC4627).
Working samples of the API:
https://www.foxtrotcharlie.ovh/API/public/api?ICAO=VHHH

Returned data:

      {
          "ICAO":       "VHHH",
          "IATA":       "HKG",
          "Name":       "Hong Kong International Airport",
          "Location":   "Hong Kong",
          "Region":     "Hong Kong",
          "Latitude":   22.3089,
          "Longitude":  113.915
       }
DesignatorDescriptionFormat
ICAOICAO code of the Airport4 characters
IATAIATA code of the Airport3 characters
NameName of the Airportstring
LocationLocation of the Airport in clearstring
RegionRegion or Country of the Airportstring
LatitudeLatitude of the Airportfloat
LongitudeLongitude of the Airportfloat
Json structure description for Airport API

Search routes by Flight Number (ICAO format)

You can also access my database of routes through the following API:
https://www.foxtrotcharlie.ovh/API/public/api?FNB=XXXXXX
where XXXXXX is the flight number in ICAO format.
The output is in json format (RFC4627).
Working samples of the API:
https://www.foxtrotcharlie.ovh/API/public/api?FNB=AFR188

Returned data:

      {
          "FNB":            "AFR188",
          "Airline":        "AFR",
          "FlightNumber":   "188",
          "Origin":         "LFPG",
          "Destination":    "VHHH",
          "Via":            ""
       }
DesignatorDescriptionFormat
FNBFlight number in ICAO formatstring
AirlineICAO code of the airline4 characters
FlightNumberFlight numberstring
OriginOrigin airport (ICAO format)string
DestinationDestination airport (ICAO format)string
ViaVia airport – if any (ICAO format)string
Json structure description for Airports API
Disclaimer – database of aircraft

All the information provided by these API are provided as is and for information only. They are coming from different sources and may contain mistakes or be out of date. Please use with caution and at your own risk.

You are welcome to comment if you see mistakes. Mode S codes can be re-allocated to new aircraft, and keeping the database of aircraft up to date is not an easy task.

Leave a Reply