| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|
| DATE_OF_REPORT | date | 4 | 0 | NO | |
| UNIQUE_SEQUENTIAL_NUMBER | varchar | 5 | 0 | NO | |
| REGION_CODE | varchar | 2 | 0 | YES | |
| OPERATOR_CONTROL_NUMBER | varchar | 13 | 0 | YES | |
| SEGMENT_CODE | varchar | 1 | 0 | YES | |
| DATE_OF_OCCURRENCE | date | 4 | 0 | YES | |
| OPERATION_TYPE | varchar | 1 | 0 | YES | |
| AIR_TRANSPORT_ASSOCIATION_CODE | varchar | 4 | 0 | YES | |
| MANUFACTURER_PART_NUMBER | varchar | 16 | 0 | YES | |
| DESCRIPTIVE_NAME_OF_PART | varchar | 16 | 0 | YES | |
| COMPONENT_MANUFACTURER_NAME | varchar | 12 | 0 | YES | |
| COMPONENT_MANUFACTURER_MODEL | varchar | 12 | 0 | YES | |
| AIRCRAFT_MANUFACTURER_NAME | varchar | 6 | 0 | YES | |
| AIRCRAFT_GROUP_CODE | varchar | 6 | 0 | YES | |
| AIRCRAFT_MANUFACTURER_MODEL | varchar | 12 | 0 | YES | |
| AIRCRAFT_MAKE_MODEL_SEQUENCE | varchar | 7 | 0 | YES | |
| AIRCRAFT_REGION_RESPONSIBLE | varchar | 2 | 0 | YES | |
| ENGINE_MANUFACTURER_NAME | varchar | 6 | 0 | YES | |
| ENGINE_GROUP_CODE | varchar | 6 | 0 | YES | |
| ENGINE_MANUFACTURER_MODEL | varchar | 12 | 0 | YES | |
| ENGINE_MAKE_MODEL_SEQUENCE | varchar | 5 | 0 | YES | |
| REGION_RESPONSIBLE_FOR_ENGINE | varchar | 2 | 0 | YES | |
| PROPELLER_MANUFACTURER_NAME | varchar | 6 | 0 | YES | |
| PROPELLER_GROUP_CODE | varchar | 6 | 0 | YES | |
| PROPELLER_MANUFACTURER_MODEL | varchar | 12 | 0 | YES | |
| PROPELLER_REGION_RESPONSIBLE | varchar | 2 | 0 | YES | |
| DEFECTIVE_LOCATION_ON_AIRCRAFT | varchar | 16 | 0 | YES | |
| FAILED_PART_CONDITION | varchar | 16 | 0 | YES | |
| SUBMITTER_CODE | varchar | 1 | 0 | YES | |
| REPORT_SUBMITTED | varchar | 1 | 0 | YES | |
| ALERT_CODE | varchar | 1 | 0 | YES | |
| AIR_CARRIER_OPERATOR_CODE | varchar | 4 | 0 | YES | |
| STAGE_OF_OPERATION_CODE | varchar | 2 | 0 | YES | |
| REPORT_STATUS | varchar | 1 | 0 | YES | |
| ORIGINAL_REPORT_MICROFILM_ROLL | varchar | 2 | 0 | YES | |
| ORIGINAL_REPORT_MICROFILM_FRAM | varchar | 4 | 0 | YES | |
| REPORT_DISTRICT_OFFICE | varchar | 4 | 0 | YES | |
| AIRCRAFT_REGISTRATION | varchar | 5 | 0 | YES | |
| PART_TOTAL_TIME | numeric | 5 | 0 | YES | |
| PART_TOTAL_TIME_SINCE_OVERHAUL | numeric | 5 | 0 | YES | |
| SEVERITY_FACTOR_CODE | varchar | 1 | 0 | YES | |
| COMPONENT_MANUFACTURER_NUMBER | varchar | 12 | 0 | YES | |
| AIRCRAFT_MANUFACTURER_NUMBER | varchar | 12 | 0 | YES | |
| ENGINE_MANUFACTURER_NUMBER | varchar | 12 | 0 | YES | |
| PROPELLER_MANUFACTURER_NUMBER | varchar | 12 | 0 | YES | |
| ATA_CODE | varchar | 4 | 0 | YES | |
| AIRCRAFT_WEIGHT_CLASS_CODE | varchar | 1 | 0 | YES | |
| AIRCRAFT_WING_TYPE_CODE | varchar | 1 | 0 | YES | |
| AIRCRAFT_POWER_CLASS_CODE | varchar | 1 | 0 | YES | |
| NUMBER_OF_ENGINES | varchar | 2 | 0 | YES | |
| DESIGN_CHARACTERISTIC_CODE | varchar | 2 | 0 | YES | |
| ENGINE_POWER_CLASS_CODE | varchar | 1 | 0 | YES | |
| ENGINE_TYPE_CODE | varchar | 1 | 0 | YES | |
| LANDING_GEAR_CODE | varchar | 2 | 0 | YES | |
| AIRCRAFT_TYPE_CERTIFICATE | varchar | 8 | 0 | YES | |
| ENGINE_TYPE_CERTIFICATE | varchar | 8 | 0 | YES | |
| PROPELLER_POWER_CODE | varchar | 1 | 0 | YES | |
| PROPELLER_TYPE_CODE | varchar | 1 | 0 | YES | |
| PROPELLER_TYPE_CERTIFICATE | varchar | 8 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES | |
