Aircraft Histories Multiple Operators
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.
| Column | Data Type | Data description | Key | Data Set | Join On |
|---|---|---|---|---|---|
| aircraft_id | int(10) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation), the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Primary (combined)/foreign (combined) | Aircraft Histories | Aircraft ID |
| operator_ch_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Primary (combined)/foreign | Operators | Operator ch-a Code |
| operator_name | varchar(255) | Operator name | |||
| date_from_full | date | From date with operator, registration and variant, the aircraft_id and date_from_full fields are the combined primary key of the Aircraft Histories data set | Primary (combined)/foreign (combined) | Aircraft Histories | Date From Full |
| date_to_full | date | To date with operator, registration and variant |