| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|
| DSGN_CODE | varchar | 4 | 0 | NO | |
| AIR_OPERATOR_NAME | varchar | 50 | 0 | YES | |
| OPERATOR_FAR | varchar | 7 | 0 | YES | |
| PREVIOUS_DESIGNATOR | varchar | 4 | 0 | YES | |
| CERTIFICATE_NUMBER | varchar | 8 | 0 | YES | |
| PREV_CERT_NUMBER | varchar | 11 | 0 | YES | |
| CERT_ISSUE_DATE | date | 4 | 0 | YES | |
| CERT_STATUS | varchar | 1 | 0 | YES | |
| CERT_TYPE | varchar | 1 | 0 | YES | |
| CERT_STATUS_DATE | date | 4 | 0 | YES | |
| CERT_HOLDING_RO | varchar | 2 | 0 | YES | |
| CERT_HOLDING_DO | varchar | 2 | 0 | YES | |
| VALIDATION_DATE | date | 4 | 0 | YES | |
| CERT_EXPIR_DATE | date | 4 | 0 | YES | |
| PRINCIPLE_OPS_INSP_KEY | varchar | 7 | 0 | YES | |
| PRINCIPLE_MAINT_INSP_KEY | varchar | 7 | 0 | YES | |
| PRINCIPLE_AVION_INSP_KEY | varchar | 7 | 0 | YES | |
| EXEMPTIONS_AUTHORIZED | varchar | 1 | 0 | YES | |
| DEVIATIONS_AUTHORIZED | varchar | 1 | 0 | YES | |
| RELIABILITY_PROGRAM_AUTH | varchar | 1 | 0 | YES | |
| KO_121_CERT_KIND_OF_OPER | varchar | 3 | 0 | YES | |
| KO_135_CERT_KIND_OPER_FIX_WNG | varchar | 4 | 0 | YES | |
| KO_135_CERT_KIND_OPER_ROTOR | varchar | 4 | 0 | YES | |
| KO_125_CERT_KIND_OF_OPER | varchar | 3 | 0 | YES | |
| KO_137_CERT_KIND_OF_OPER | varchar | 3 | 0 | YES | |
| KO_91_KIND_OF_OPERATION | varchar | 3 | 0 | YES | |
| TO_BASIC_PART_135_OPERATOR | varchar | 1 | 0 | YES | |
| TO_135_SINGLE_PILOT_OPERATOR | varchar | 1 | 0 | YES | |
| TO_135_SINGLE_PILOT_IN_COMM | varchar | 1 | 0 | YES | |
| TO_135_COMMUTR_9_PAX_OR_LESS | varchar | 1 | 0 | YES | |
| TO_135_ON_DMND_9_PAX_OR_LESS | varchar | 1 | 0 | YES | |
| TO_135_10_PAX_OR_MORE | varchar | 1 | 0 | YES | |
| TO_135_SEAPLANE | varchar | 1 | 0 | YES | |
| TO_135_EXTENDED_OVER_WATER | varchar | 1 | 0 | YES | |
| TO_135_DAY_ONLY | varchar | 1 | 0 | YES | |
| TO_135_VFR_ONLY_FIXED_WING | varchar | 1 | 0 | YES | |
| TO_135_VFR_ONLY_ROTORCRAFT | varchar | 1 | 0 | YES | |
| TO_129_APPRVD_MAINT_PROGRAM | varchar | 1 | 0 | YES | |
| TO_129_OPER_SCHD_PAX_US | varchar | 1 | 0 | YES | |
| TO_129_OPER_SCHD_CARGO_US | varchar | 1 | 0 | YES | |
| TO_129_OPER_NON_SCHD_US | varchar | 1 | 0 | YES | |
| TO_129_OPER_N_REGSTR_AIRCRAFT | varchar | 1 | 0 | YES | |
| TO_125_CORPORATE_DEVIATION | varchar | 1 | 0 | YES | |
| TO_125_FOREIGN | varchar | 1 | 0 | YES | |
| TO_125_EXTENDED_OVER_WATER | varchar | 1 | 0 | YES | |
| TO_125_PARACHUTE_DEVIATION | varchar | 1 | 0 | YES | |
| TO_125_HOTEL_CASINO_DEVIATION | varchar | 1 | 0 | YES | |
| TO_125_SPECIAL_DEVIATION | varchar | 1 | 0 | YES | |
| TO_133_EXTERNAL_LOAD_CLASS_A | varchar | 1 | 0 | YES | |
| TO_133_EXTERNAL_LOAD_CLASS_B | varchar | 1 | 0 | YES | |
| TO_133_EXTERNAL_LOAD_CLASS_C | varchar | 1 | 0 | YES | |
| TO_133_EXTERNAL_LOAD_CLASS_D | varchar | 1 | 0 | YES | |
| TO_137_ECONOMIC_POISONS | varchar | 1 | 0 | YES | |
| PIC_CAPTAINS | numeric | 5 | 0 | YES | |
| OTHER_PILOTS | numeric | 5 | 0 | YES | |
| FLIGHT_ENGINEER_EXAMNRS | numeric | 5 | 0 | YES | |
| FLIGHT_ENGINEERS | numeric | 5 | 0 | YES | |
| PILOT_EXAMINERS | numeric | 5 | 0 | YES | |
| CHECK_AIRMEN | numeric | 5 | 0 | YES | |
| AIRCREW_PROG_DESIGNEES | numeric | 5 | 0 | YES | |
| FLIGHT_ATTENDANTS | numeric | 5 | 0 | YES | |
| DISPATCHERS | numeric | 5 | 0 | YES | |
| NAVIGATORS | numeric | 5 | 0 | YES | |
| INSPECTORS | numeric | 5 | 0 | YES | |
| DESIGNATED_INSPECTORS | numeric | 5 | 0 | YES | |
| NONCERTIFICATED_MECHANICS | numeric | 5 | 0 | YES | |
| CERTIFICATED_MECHANICS | numeric | 5 | 0 | YES | |
| REPAIRMEN | numeric | 5 | 0 | YES | |
| TOTAL_NUMBER_OF_EMPLOYEES | numeric | 5 | 0 | YES | |
| CREWMEMBER_TRAINING | varchar | 1 | 0 | YES | |
| AIRWORTHINESS_AGREEMENT | varchar | 1 | 0 | YES | |
| OPERATES_IN_AL | varchar | 1 | 0 | YES | |
| OPERATES_IN_CE | varchar | 1 | 0 | YES | |
| OPERATES_IN_EA | varchar | 1 | 0 | YES | |
| OPERATES_IN_GL | varchar | 1 | 0 | YES | |
| OPERATES_IN_NE | varchar | 1 | 0 | YES | |
| OPERATES_IN_NM | varchar | 1 | 0 | YES | |
| OPERATES_IN_SO | varchar | 1 | 0 | YES | |
| OPERATES_IN_SW | varchar | 1 | 0 | YES | |
| OPERATES_IN_WP | varchar | 1 | 0 | YES | |
| OPERATES_IN_EU | varchar | 1 | 0 | YES | |
| HAZMAT_CARRIED | varchar | 1 | 0 | YES | |
| NATIONAL_USE | varchar | 4 | 0 | YES | |
| ASSOCIATED_REFERENCE_ID | varchar | 25 | 0 | YES | |
| SPECIAL_PURPOSE | varchar | 12 | 0 | YES | |
| TRANSFERRED_REGION | varchar | 2 | 0 | YES | |
| TRANSFERRED_DISTRICT | varchar | 2 | 0 | YES | |
| AAIP_135_419 | varchar | 1 | 0 | YES | |
| MAINT_135_411 | varchar | 1 | 0 | YES | |
| CAMP_10_OR_MORE | varchar | 1 | 0 | YES | |
| CAMP_D_9_OR_LESS | varchar | 1 | 0 | YES | |
| CAMP_C_9_OR_LESS | varchar | 1 | 0 | YES | |
| APP_CORROSION_PGM | varchar | 1 | 0 | YES | |
| REL_PGM_ENTIRE | varchar | 1 | 0 | YES | |
| REL_PGM_NOT_ENTIRE | varchar | 1 | 0 | YES | |
| OPSPEC | varchar | 1 | 0 | YES | |
| OPSS_SPECIAL | varchar | 1 | 0 | YES | |
| EXCEPTION_FLAG | varchar | 1 | 0 | YES | |
| DOWN_REGION | varchar | 2 | 0 | YES | |
| DOWN_DISTRICT | varchar | 2 | 0 | YES | |
| DOWN_FLAG | varchar | 1 | 0 | YES | |
| DOWN_DATE | date | 4 | 0 | YES | |
| FSDO_MAINT_DATE | date | 4 | 0 | YES | |
| DELETE_FLAG | varchar | 1 | 0 | YES | |
| PROCESS_DATE | date | 4 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES | |
