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
Database APIs
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.
