| Operator Name | varchar(255) | Operator name | | | |
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Primary/Foreign | Operators | Operator ch-a Code |
| Start-Up Info | varchar(255) | Start-up information free text | | | |
| IATA | varchar(2) | Operator IATA two-character code | | | |
| Country | varchar(255) | Country name | | | |
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
| Type | varchar(255) | Description of operator's primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) | | | |
| Type Code | char(1) | Operator type code: S - Scheduled Carrier, V - Virtual Carrier, D - Division, C - Cargo Carrier, B - Business/Private Carrier, G - Government, M - Manufacturer, U - Supplier | | | |
| Website | varchar(255) | Website URL | | | |
| Planned Start-Up | varchar(255) | Planned start-up quarter (formatted yyyy/qq) | | | |
| Start-Up added | date | Date the start-up was added to the ch-aviation database | | | |
| Start-Up last updated | date | Date the start-up status was last updated | | | |
| Majority government owned | varchar(3) | Indicator if start-up is majority government owned | | | |
| Investor | varchar(255) | Investor names | | | |
| known investor in airlines | varchar(3) | Indicator if start-up has investor with an airline experience | | | |
| known investor in aviation | varchar(3) | Indicator if start-up has investor with aviation experience | | | |
| Planned fleet size | smallint(5) | Planned fleet size | | | |
| incorporation number/ VAT number | text | Incorporation number or VAT number | | | |
| Incorporation_source | text | Source of Incorporation number or VAT number | | | |
| Application_date_AOC | vachar(10) | AOC application date or month (formatted as YYYY/MM) | | | |
| AOC application in process? | varchar(3) | Indicator if AOC application is in progress | | | |
| AOC application source | text | Source of AOC application | | | |
| AOC number | varchar(255) | AOC number if AOC has been awarded | | | |
| AOC number source | text | AOC number source | | | |
| Start up aircraft variants | varchar(255) | Planned aircraft variants (if already known) | | | |
| Start up aircraft families | varchar(255) | Planned aircraft families (if already known) | | | |
