David City, NE
Registered aircraft · 46
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'NE' AND g.registrant_city = 'DAVID CITY' ORDER BY g.n_number"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'NE' AND g.registrant_city = 'DAVID CITY' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1894APiper PA-18AS-125 · S/N 18-1724N2466UCessna 172D · S/N 17250066N267NATalos Drones T60X · S/N 2104F7EZB251J00107SMN268HCBoeing E75 · S/N 75-8608N277EHDJI AGRAS T20P · S/N 64UBK67001002TN30435Piper J4A · S/N 4-1219N31GWSchweizer G-164B · S/N 507BN33933Schweizer SGS 2-33A · S/N 403N4381GDuda Edward F RANS S-12XL · S/N 08980854N4698Grumman Acft ENG Cor-Schweizer G-164A · S/N 1081N48551Grumman Acft ENG Cor-Schweizer G-164B · S/N 71BN48655Grumman Acft ENG Cor-Schweizer G-164B · S/N 102BN48675Grumman Acft ENG Cor-Schweizer G-164B · S/N 109BN502PBAir Tractor AT-502B · S/N 502B-0500N5396Grumman Acft ENG Cor-Schweizer G-164A · S/N 1150N5474Grumman Acft ENG Cor-Schweizer G-164A · S/N 1172N6511HPiper J3C-65 · S/N 19700N6608QGrumman Acft ENG Cor-Schweizer G-164B · S/N 135BN667FAGrumman Acft ENG Cor-Schweizer G-164B · S/N 431BN6680QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1699N6761QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1352N677BGrumman Acft ENG Cor-Schweizer G-164B · S/N 677BN6819KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 496BN6832KGrumman Acft ENG Cor-Schweizer G-164B · S/N 502BN6892KGrumman Acft ENG Cor-Schweizer G-164B · S/N 516BN6966KGrumman Acft ENG Cor-Schweizer G-164B · S/N 530BN7252LAmerican AA-1A · S/N AA1A-0452N7364Grumman Acft ENG Cor-Schweizer G-164A · S/N 933N7480Grumman Acft ENG Cor-Schweizer G-164A · S/N 956N7501KSchweizer G-164B · S/N 802BN8066KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 552BN8080KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 554 BN8081VCessna A188 · S/N 188-0331N8114KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 569BN814YBGrumman G-164B · S/N 818BN8157KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 591BN8386Grumman Acft ENG Cor-Schweizer G-164A · S/N 884N8405KGrumman Acft ENG Cor-Schweizer G-164B · S/N 688BN8629HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1438N8766HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1522N90401Grumman Acft ENG Cor-Schweizer G-164A · S/N 688N9041GGrumman G-164A · S/N 464N9399XCessna 182E · S/N 18253799N9570SMichael B Burwell PIETENPOL SKY SCOUT · S/N 002N9650Grumman Acft ENG Cor-Schweizer G-164A · S/N 1381N981SUPiper PA-28-180 · S/N 28-7505252
Back to David City, NE