| Airline Name | varchar(255) | Operator name | Airlines | | | |
| Airline ch-a Code | varchar(3) | Operator ch-aviation code (assigned by ch-aviation) | Airlines | Primary | | |
| Legal Name | varchar(255) | Operator legal name | Airlines | | | |
| Manufacturer | char(3) | Indication if the operator is an aircraft manufacturer: yes / no / (NULL) | Airlines | | | |
| Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Airlines | | | |
| Location ch-a Code | varchar(6) | Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code) | Airlines | | | |
| Location ID | int(11) | Location ID (assigned by ch-aviation) | Airlines | Foreign | Airports | Airport ID |
| Continent | varchar(255) | Continent name | Airlines | | | |
| Subdivision | varchar(255) | State description | Airlines | | | |
| Subdivision Code | char(2) | ISO 3166-2 Alpha-2 subdivision code (used for states) | Airlines | Foreign | States | State ISO |
| Metro Group | varchar(255) | Metro group name | Airlines | | | |
| Metro Group IATA | char(3) | Metro group three character IATA code | Airlines | Foreign | Metro Groups | Metro_Group |
| Country | varchar(255) | Country name | Airlines | | | |
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Airlines | Foreign | Countries | Country ISO |
| Country_IASA_Status | char(1) | Country International Aviation Safety Assessment program status (assigned by FAA): 0 – not assessed / 1 – Category 1 (meets ICAO standards) / 2 – Category 2 (does not meet ICAO standards) | Airlines | | | |
| IATA | varchar(2) | Airline IATA two-character code | Airlines | | | |
| ICAO | varchar(3) | Airline ICAO three-character code | Airlines | | | |
| Type | varchar(255) | Description of operator’s primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) | Airlines | | | |
| 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 | Airlines | | | |
| Status | varchar(255) | Operator status: Active, Start-Up, Restarting, Not Launched, Out of Business, Rebranded, Merged | Airlines | | | |
| Airline Info | varchar(255) | Free text remarks | Airlines | | | |
| IOSA Certified | char(3) | IOSA certification: yes / no / (NULL) | Airlines | | | |
| Offers ACMI Leases | char(3) | Operator actively offers ACMI leases: yes / no / (NULL) | Airlines | | | |
| Alliance | varchar(255) | Alliance name | Airlines | | | |
| Alliance ch-a Code | char(2) | Alliance ch-aviation code (assigned by ch-aviation) | Airlines | Foreign | Alliances | Alliance_Code |
| Parent | varchar(255) | Parent name | Airlines | | | |
| Parent ch-a Code | varchar(4) | Parent operator ch-aviation code (assigned by ch-aviation) | Airlines | Foreign | Airlines | Airline ch-a Code |
| Merged into | varchar(255) | Operator name this operator was merged into/rebranded to (only filled if carrier has Rebranded or Merged status) | Airlines | | | |
| Merged into ch-a Code | varchar(4) | Operator ch-aviation code of operator this operator was merged into/rebranded to (assigned by ch-aviation) (only filled if carrier has Rebranded or Merged status) | Airlines | Foreign | Airlines | Airline ch-a Code |
| Charter Availability | tinyint(1) | Offers charter flights (only filled for carriers with Scheduled status): 0 -no / 1 – yes | Airlines | | | |
| Cargo Carrier Type Code | char(1) | Cargo carrier type (only filled for operators with Type Cargo Carrier): C – Charter / S – Scheduled / (NULL) | Airlines | | | |
| Cargo Carrier Type | varchar(9) | Cargo carrier type (only filled for operators with Type Cargo Carrier): Charter / Scheduled / (NULL) | Airlines | | | |
| Address | varchar(512) | Address description | Airlines | | | |
| City | varchar(255) | City description | Airlines | | | |
| Address Country | varchar(255) | Address country name | Airlines | | | |
| Address Country ISO | char(2) | Address country ISO 3166-1 Alpha-2 country code | Airlines | Foreign | Countries | Country ISO |
| EU Country | char(3) | European Union country: Yes / No / (NULL) | Airlines | | | |
| Phone Country ISO | char(2) | Phone country ISO 3166-1 Alpha-2 country code | Airlines | Foreign | Countries | Country ISO |
| Phone Country Code | varchar(255) | Phone country dialling code | Airlines | | | |
| Phone Number | varchar(255) | Switchboard phone number | Airlines | | | |
| Email | varchar(255) | Generic e-mail address | Airlines | | | |
| Charter Email | varchar(255) | Generic charter e-mail address | Airlines | | | |
| Website | varchar(255) | Website URL | Airlines | | | |
| Linkedin | varchar(255) | LinkedIn profile URL | Airlines | | | |
| Facebook | varchar(255) | Facebook profile URL | Airlines | | | |
| Twitter | varchar(255) | Twitter profile URL | Airlines | | | |
| Stock Ticker | varchar(255) | Stock market ticker URL | Airlines | | | |
| Start-Up Info | varchar(255) | Start-up information free text | Airlines | | | |
| Start-Up added | date | Date the start-up was added to the ch-aviation database | Airlines | | | |
| Start-Up last updated | date | Date the start-up status was last updated | Airlines | | | |
| Launch Year | int(4) | Year the operator was launched | Airlines | | | |
| Planned Start-up | varchar(255) | Planned start-up quarter (formatted yyyy/qq) | Airlines | | | |
| Termination Year | int(4) | Year the operator stopped operations | Airlines | | | |
| Total Seats in Fleet | decimal(10,0) | Number of total seats of all aircraft operated by the operator | Fleets | | | |
| Number of Aircraft | bigint(20) | Number of aircraft operated by the operator | Fleets | | | |
| Aircraft on Order | decimal(10,0) | Number of aircraft on order by the operator | Fleets | | | |
| Number of Engines | decimal(10,0) | Number of engines fitted to aircraft operated by the operator | Fleets | | | |
| Reservation System | varchar(255) | Name of the reservation system used by the operator | PSS | | | |
