Aircraft Histories Multiple Operators
| 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 | | | |
