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.

To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.

Sample File NameSample Description
last_aircraft_location_bizjets.csvSubset for business jets
last_aircraft_location_comav.csvSubset for commercial aviation
last_aircraft_location.csvSample data for commercial aviation and business jets
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)Primary (combined)/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. (if Opr. ch-a Code is MLT, the aircraft's multiple operators can be found in the Aircraft Multiple Operators table)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 (Ambulance, Cargo, Combi, Hospital, Maritime Patrol (Maritime Surveillance and Rescue), Military, Parachuting, Passenger, Police, Passenger-Freighter, Quick Change (Passenger - Ambulance), Quick Change (Passenger - Cargo), Tanker, Testbed, VIP, Water Bomber, Multi-Role Flexible, Aerial Observation Imaging and Mapping, Research, Calibrator, Intelligence, Surveillance and Reconnaissance, Operational Training and Readiness, Aero-Environmental, Military Transport)
last flight datedateThe date when the aircraft arrived at current location. In UTC
locationvarchar(255)Airport display name of the current location (city name and airport name).
location ch-a codevarchar(6)Primary airport code of the current location (in order of availability: IATA, ICAO, FAA, alternative code).Primary (combined)/ForeignAirportsAirport ch-a Code
location country iso codechar(2)ISO 3166-1 Alpha-2 country code of the current location.ForeignCountriesCountry ISO
location countryvarchar(255)Country name of the current location.