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 Name | Sample Description |
|---|---|
| last_aircraft_location_bizjets.csv | Subset for business jets |
| last_aircraft_location_comav.csv | Subset for commercial aviation |
| last_aircraft_location.csv | Sample data for commercial aviation and business jets |
| Column | Data Type | Data description | Key | Data Set | Join On |
|---|---|---|---|---|---|
| aircraft id | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Primary (combined)/Foreign | Aircraft | Aircraft ID |
| operator | varchar(255) | Operator name | |||
| opr. ch-a code | varchar(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) | Foreign | Operators | Operator ch-a Code |
| registration | varchar(16) | Aircraft registration | |||
| aircraft variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Foreign | Aircraft Variants | variant_text |
| aircraft role | varchar(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 date | date | The date when the aircraft arrived at current location. In UTC | |||
| location | varchar(255) | Airport display name of the current location (city name and airport name). | |||
| location ch-a code | varchar(6) | Primary airport code of the current location (in order of availability: IATA, ICAO, FAA, alternative code). | Primary (combined)/Foreign | Airports | Airport ch-a Code |
| location country iso code | char(2) | ISO 3166-1 Alpha-2 country code of the current location. | Foreign | Countries | Country ISO |
| location country | varchar(255) | Country name of the current location. |