Last Aircraft Location

To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.

To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.

ColumnData TypeData descriptionKeyData SetJoin On
aircraft idint(11)Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation)ForeignAircraftAircraft ID
operatorvarchar(255)Operator name
opr. ch-a codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
registrationvarchar(16)Aircraft registration
aircraft variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)ForeignAircraft Variantsvariant_text
aircraft rolevarchar(32)Aircraft's primary role (Passenger, Passenger-Freighter, Cargo, Combi, Quick Change (Passenger - Ambulance), Quick Change (Passenger - Cargo), Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber, VIP)
last flight datedateThe date when the aircraft arrived at current location. In UTC
locationvarchar(255)Airport Display Name (combination of City Name and Airport Name)
location ch-a codevarchar(6)Origin primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive)ForeignAirportsAirport ch-a Code
location country iso codechar(2)ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
location countryvarchar(255)Country name