| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|
| KEY_FIELD | numeric | 10 | 0 | YES | KEY FIELD |
| RECORD_TYPE | varchar | 3 | 0 | YES | RECORD TYPE |
| LANDING_FACILITY_SITE_NUMBER | varchar | 11 | 0 | NO | LANDING FACILITY SITE NUMBER |
| LANDING_FACILITY_TYPE | varchar | 13 | 0 | YES | LANDING FACILITY TYPE |
| LOCATION_IDENTIFIER | varchar | 4 | 0 | YES | LOCATION IDENTIFIER |
| ASSOCIATED_STATE | varchar | 2 | 0 | YES | ASSOCIATED STATE |
| ASSOCIATED_COUNTY | varchar | 21 | 0 | YES | ASSOCIATED COUNTY |
| ASSOCIATED_CITY | varchar | 26 | 0 | YES | ASSOCIATED CITY |
| OFFICIAL_FACILITY_NAME | varchar | 42 | 0 | YES | OFFICIAL FACILITY NAME |
| AIRPORT_OWNERSHIP_TYPE | varchar | 2 | 0 | YES | AIRPORT OWNERSHIP TYPE |
| FACILITY_USE | varchar | 2 | 0 | YES | FACILITY USE |
| FACILITY_OWNERS_NAME | varchar | 29 | 0 | YES | FACILITY OWNER S NAME |
| OWNER_ADDRESS | varchar | 29 | 0 | YES | OWNER S ADDRESS |
| OWNER_CITY_STATE_ZIP_CODE | varchar | 29 | 0 | YES | OWNER S CITY, STATE AND ZIP CODE |
| OWNER_PHONE_NUMBER | varchar | 12 | 0 | YES | OWNER S PHONE NUMBER |
| FACILITY_MANAGERS_NAME | varchar | 29 | 0 | YES | FACILITY MANAGER S NAME |
| MANAGER_ADDRESS | varchar | 29 | 0 | YES | MANAGER S ADDRESS |
| MANAGER_CITY_STATE_ZIP_CODE | varchar | 29 | 0 | YES | MANAGER S CITY, STATE AND ZIP CODE |
| MANAGER_PHONE_NUMBER | varchar | 12 | 0 | YES | MANAGER S PHONE NUMBER |
| AIRPORT_REFERENCE_LATITUDE | varchar | 14 | 0 | YES | AIRPORT REFERENCE POINT LATITUDE |
| AIRPORT_REFERENCE_LONGITUDE | varchar | 14 | 0 | YES | AIRPORT REFERENCE POINT LONGITUDE |
| AIRPORT_ELEVATION | numeric | 10 | 0 | YES | AIRPORT ELEVATION |
| CITY_AIRPORT_DISTANCE | numeric | 10 | 0 | YES | DISTANCE FROM ASSCOIATED CITY TO THE AIRPORT |
| BOUNDARY_ARTCC_IDENTIFIER | varchar | 3 | 0 | YES | BOUNDARY ARTCC IDENTIFIER |
| BOUNDARY_ARTCC_NAME | varchar | 20 | 0 | YES | BOUNDARY ARTCC NAME |
| RESPONSIBLE_ARTCC_IDENTIFIER | varchar | 3 | 0 | YES | RESPONSIBLE ARTCC IDENTIFIER |
| RESPONSIBLE_ARTCC_NAME | varchar | 20 | 0 | YES | RESPONSIBLE ARTCC NAME |
| TIE_IN_FSS_ON_FACILITY | varchar | 1 | 0 | YES | TIE-IN FSS PHYSICALLY LOCATED ON FACILITY |
| TIE_IN_FSS_IDENTIFIER | varchar | 4 | 0 | YES | TIE-IN FSS IDENTIFIER |
| TIE_IN_FSS_NAME | varchar | 26 | 0 | YES | TIE-IN FSS NAME |
| ALTERNATE_FSS_IDENTIFIER | varchar | 4 | 0 | YES | ALTERNATE FSS IDENTIFIER |
| ALTERNATE_FSS_NAME | varchar | 26 | 0 | YES | ALTERNATE FSS NAME |
| NOTAM_AND_WEATHER_FACILITY | varchar | 4 | 0 | YES | FACILITY ISSUING NOTAM AND WEATHER INFORMATION FOR THE AIRPORT |
| AVAILABILITY_OF_NOTAM_D | varchar | 1 | 0 | YES | AVAILABILITY OF NOTAM D SERVICE AT AIRPORT |
| AIRPORT_CERT_TYPE_AND_DATE | varchar | 8 | 0 | YES | AIRPORT CERTIFICATION TYPE AND DATE |
| NASP_FEDERAL_AGREEMENT_CODE | varchar | 7 | 0 | YES | NASP/FEDERAL AGREEMENT CODE |
| AIRPORT_AIRSPC_DETERMINATION | varchar | 13 | 0 | YES | AIRPORT AIRSPACE ANALYSIS DETERMINATION |
| CUSTOMS_LANDING_RIGHTS | varchar | 1 | 0 | YES | CUSTOMS LANDING RIGHTS AIRPORT |
| MILITARY_CIVIL_JOINT_USE | varchar | 1 | 0 | YES | MILITARY/CIVIL JOINT USE AGREEMENT |
| LANDING_RIGHTS_TO_MILITARY | varchar | 1 | 0 | YES | LANDING RIGHTS GRANTED TO THE MILITARY |
| NATIONAL_EMERGENCY_AVAILABLE | varchar | 1 | 0 | YES | AVAILABILITY DURING A NATIONAL EMERGENCY |
| AIRPORT_INSPECTION_METHOD | varchar | 2 | 0 | YES | AIRPORT INSPECTION METHOD |
| PHYSICAL_INSPECTION_AGENCY | varchar | 1 | 0 | YES | AGENCY/GROUP PERFORMING PHYSICAL INSPECTION |
| PUBLIC_FUEL_TYPES | varchar | 40 | 0 | YES | FUEL TYPES AVAILABLE FOR PUBLIC USE |
| AIRFRAME_REPAIR_AVAILABILITY | varchar | 5 | 0 | YES | AIRFRAME REPAIR SERVICE AVAILABILITY/TYPE |
| ENGINE_REPAIR_AVAILABILITY | varchar | 5 | 0 | YES | POWER PLANT REPAIR AVAILABILITY/TYPE |
| BOTTLED_OXYGEN_TYPE | varchar | 8 | 0 | YES | TYPE OF BOTTLED OXYGEN AVAILABLE |
| BULK_OXYGEN_TYPE | varchar | 8 | 0 | YES | TYPE OF BULK OXYGEN AVAILABLE |
| AIRPORT_ATTENDANCE_SCHEDULE | varchar | 77 | 0 | YES | AIRPORT ATTENDANCE SCHEDULE |
| AIRPORT_LIGHTING_SCHEDULE | varchar | 9 | 0 | YES | AIRPORT LIGHTING SCHEDULE |
| ATC_TOWER_LOCATED_ON_AIRPORT | varchar | 1 | 0 | YES | AIR TRAFFIC CONTROL TOWER LOCATED ON AIRPORT |
| SEGMENTED_CIRCLE_AIRPORT_MARK | varchar | 4 | 0 | YES | SEGMENTED CIRCLE AIRPORT MARKER SYSTEM ON THE AIRPORT |
| LENS_COLOR_OF_OPERABLE_BEACON | varchar | 3 | 0 | YES | LENS COLOR OF OPERABLE BEACON |
| NON_COMMERCIAL_LANDING_FEE | varchar | 1 | 0 | YES | LANDING FEE CHARGED TO NON-COMMERCIAL USERS |
| SINGLE_ENGINE_GA_AIRCRAFT | numeric | 10 | 0 | YES | SINGLE ENGINE GENERAL AVIATION AIRCRAFT |
| MULTI_ENGINE_GA_AIRCRAFT | numeric | 10 | 0 | YES | MULTI ENGINE GENERAL AVIATION AIRCRAFT |
| JET_ENGINE_GA_AIRCRAFT | numeric | 10 | 0 | YES | JET ENGINE GENERAL AVIATION AIRCRAFT |
| HELICOPTERS_GA_AIRCRAFT | numeric | 10 | 0 | YES | HELICOPTERS GENERAL AVIATION AIRCRAFT |
| OPERATIONAL_GLIDERS | numeric | 10 | 0 | YES | OPERATIONAL GLIDERS |
| OPERATIONAL_MILITARY_AIRCRAFT | numeric | 10 | 0 | YES | OPERATIONAL MILITARY AIRCRAFT |
| ULTRALIGHT_AIRCRAFT | numeric | 10 | 0 | YES | ULTRALIGHT AIRCRAFT |
| COMMERCIAL_SERVICES | numeric | 10 | 0 | YES | COMMERCIAL SERVICES |
| AIR_TAXI | numeric | 10 | 0 | YES | AIR TAXI |
| GA_LOCAL_OPERATIONS | numeric | 10 | 0 | YES | GENERAL AVIATION LOCAL OPERATIONS |
| GA_ITINERANT_OPERATIONS | numeric | 10 | 0 | YES | GENERAL AVIATION ITINERANT OPERATIONS |
| MILITARY_AIRCRAFT_OPERATIONS | numeric | 10 | 0 | YES | MILITARY AIRCRAFT OPERATIONS |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES | |
