Table description for OPR AGENCY 145 INFO in subject area OPERATOR
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| DSGN_CODE | varchar | 4 | 0 | NO | |
| CERT_HOLDING_RO | varchar | 2 | 0 | YES | |
| CERT_HOLDING_DO | varchar | 2 | 0 | YES | |
| JAA_LISTED | varchar | 1 | 0 | YES | |
| JAR_CERT_NO | varchar | 12 | 0 | YES | |
| FRGN_CERT_NO | varchar | 15 | 0 | YES | |
| IN_HOUSE_QMS | varchar | 1 | 0 | YES | |
| QMS_CONTRACTOR | varchar | 50 | 0 | YES | |
| CERT_MECH | numeric | 11 | 0 | YES | |
| NONCERT_MECH | numeric | 11 | 0 | YES | |
| REPAIRMEN | numeric | 11 | 0 | YES | |
| REPAIR_129_14 | varchar | 1 | 0 | YES | |
| NAA_CAA_CONTACT | varchar | 50 | 0 | YES | |
| NAA_CAA_TITLE | varchar | 50 | 0 | YES | |
| NAA_CAA_PHONE | varchar | 10 | 0 | YES | |
| NAA_CAA_PHONE_EXT | varchar | 4 | 0 | YES | |
| NAA_CAA_FAX | varchar | 16 | 0 | YES | |
| NAA_CAA_FRGN_PHONE | varchar | 16 | 0 | YES | |
| NAA_CAA_INTERNET | varchar | 50 | 0 | YES | |
| ACCNTBLE_MGR_NAME | varchar | 50 | 0 | YES | |
| ACCNTBLE_MGR_TITLE | varchar | 50 | 0 | YES | |
| ACCNTBLE_MGR_PHONE | varchar | 10 | 0 | YES | |
| ACCNTBLE_MGR_PHONE_EXT | varchar | 4 | 0 | YES | |
| ACCNTBLE_MGR_FAX | varchar | 16 | 0 | YES | |
| ACCNTBLE_MGR_INTERNET | varchar | 50 | 0 | YES | |
| ACCESSORY_1 | varchar | 1 | 0 | YES | |
| ACCESSORY_2 | varchar | 1 | 0 | YES | |
| ACCESSORY_3 | varchar | 1 | 0 | YES | |
| ACCESSORY_4 | varchar | 1 | 0 | YES | |
| AIRFRAME_1 | varchar | 1 | 0 | YES | |
| AIRFRAME_2 | varchar | 1 | 0 | YES | |
| AIRFRAME_3 | varchar | 1 | 0 | YES | |
| AIRFRAME_4 | varchar | 1 | 0 | YES | |
| INSTRUMENT_1 | varchar | 1 | 0 | YES | |
| INSTRUMENT_2 | varchar | 1 | 0 | YES | |
| INSTRUMENT_3 | varchar | 1 | 0 | YES | |
| INSTRUMENT_4 | varchar | 1 | 0 | YES | |
| POWERPLANT_1 | varchar | 1 | 0 | YES | |
| POWERPLANT_2 | varchar | 1 | 0 | YES | |
| POWERPLANT_3 | varchar | 1 | 0 | YES | |
| PROPELLER_1 | varchar | 1 | 0 | YES | |
| PROPELLER_2 | varchar | 1 | 0 | YES | |
| RADIO_1 | varchar | 1 | 0 | YES | |
| RADIO_2 | varchar | 1 | 0 | YES | |
| RADIO_3 | varchar | 1 | 0 | YES | |
| LIMIT_AAC | varchar | 1 | 0 | YES | |
| LIMIT_AF | varchar | 1 | 0 | YES | |
| LIMIT_EE | varchar | 1 | 0 | YES | |
| LIMIT_FAB | varchar | 1 | 0 | YES | |
| LIMIT_FLO | varchar | 1 | 0 | YES | |
| LIMIT_INS | varchar | 1 | 0 | YES | |
| LIMIT_LG | varchar | 1 | 0 | YES | |
| LIMIT_NDT | varchar | 1 | 0 | YES | |
| LIMIT_PP | varchar | 1 | 0 | YES | |
| LIMIT_PRP | varchar | 1 | 0 | YES | |
| LIMIT_RAD | varchar | 1 | 0 | YES | |
| LIMIT_RB | varchar | 1 | 0 | YES | |
| LIMIT_SS | varchar | 1 | 0 | YES | |
| LIMIT_OT | varchar | 1 | 0 | YES | |
| SFAR36_AUTH | varchar | 1 | 0 | YES | |
| JAR_EXPIR_DATE | date | 4 | 0 | YES | |
| FRGN_CERT_ISSUE_DATE | date | 4 | 0 | YES | |
| ACCESSORY_DATE | date | 4 | 0 | YES | |
| AIRFRAME_DATE | date | 4 | 0 | YES | |
| INSTRUMENT_DATE | date | 4 | 0 | YES | |
| POWERPLANT_DATE | date | 4 | 0 | YES | |
| PROPELLER_DATE | date | 4 | 0 | YES | |
| RADIO_DATE | date | 4 | 0 | YES | |
| HYDRSTAT_EX_DATE | date | 4 | 0 | YES | |
| DATE_TIME_STAMP | timestamp | 8 | 0 | YES | |
| DELETE_FLAG | varchar | 1 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |