US 18,347 Airports Data: FAA, Address, Phone, Lat, Lon, Radio Navigation Aid, Runway
In the United States airport database, there are 18,347 records with location, faa code, airport name, faa information effective, airport identifier, airport status, longitude or latitude, ownership, from nearest city, address, phone number, control tower, etc. in each. These tables runway information and remark have 11,095 and 25,399 records in each. In addition, the US airport data set also contains 188,435 radio navigation aid with radio number, type and etc. There are 9 tables in the whole US airports data set. Name n3_chennan_airport_airport_data_com_us Data 111.56M (+ 0B) Tables 9 (+ 0) Columns 87 (+ 0) Table Rows 537,106 (+ 0) Media 0B (+ 0B) Files 0 (+ 0) Data Samples By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download) Database APIs http://n3.datasn.io/data/api/v1/n3_chennan/airport_in_usa_information/ (By Table) Tables & Columns Tables Rows Columns Non-empty airport 18,347 location 100% faa_code 100% airport_name 100% faa_information_effective 99.97% airport_identifier 99.97% airport_status 99.97% longitude_or_latitude 99.97% elevation 99.97% land 99.97% from_nearest_city 99.97% magnetic_variation 99.97% ownership 99.97% owner 99.33% address 98.79% phone 98.21% manager 93.05% manager_address 92.57% manager_phone 91.31% airport_use 99.97% wind_indication 84% control_tower 99.97% sectional_chart 99.23% region 99.97% boundary_artcc 99.97% tie_in_fss 99.97% fss_phone 7.16% fss_toll_free 99.97% alternate_fss 1.17% alt_fss_toll_free 1.17% notams_facility 30.06% federal_agreement 18.52% airport_x_radio_navigation_aid 223,335 airport_id 100% radio_navigation_aid_id 100% airport_x_remark 33,095 airport_id 100% remark_id 100% airport_x_runway_information 19,002 airport_id 100% runway_information_id 100% radio_navigation_aid 188,435 name 100% radio_no 100% type 100% var 99.99% dist 93.96% ch 40.76% freq 94.71% remark 25,399 value 100% runway_information 11,095 dimension 100% surface 57.21% runway 100% runway_1 100% edge_light 33.2% traffic_pattern 100% traffic_pattern_1 100% marking 33.38% marking_1 33.38% latitude 37.42% latitude_1 37.42% longitude 37.31% longitude_1 37.31% elevation 34.7% elevation_1 34.7% alignment 29.29% alignment_1 29.29% state 51 title 100% state_x_airport 18,347 state_id 100% airport_id 100% Notes: Meta columns id and ts are not shown here, but included in columns total. Some statistical or memo columns are not shown here, but included in columns total. Non-empty percentage indicates the percent of values that are non-empty for that particular column. Media Sets No media sets.