Parkville, MO
Registered aircraft · 16
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 = 'MO' AND g.registrant_city = 'PARKVILLE' 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 = 'MO' AND g.registrant_city = 'PARKVILLE' 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.
N124DSStarks Richard NIEUPORT 11 · S/N 36First renewal noticeN252CMFrederick Mark FREDERICK ROCKET II · S/N 4002N2954XCessna 177 · S/N 17700354N323SSStarks Sharon MORANE SAULNIER L · S/N 001First renewal noticeN3477MPiper PA-28-181 · S/N 28-7890305N3676QBeech A23-24 · S/N MA-267N421RFStephen V Rowson/William J Flo RANS S-6ES · S/N 11131977N42951Cessna 182L · S/N 18259264N44LRRanaudo Richard J VANS RV-4 · S/N 1N705VBBugnits Victor CGS HAWK · S/N 186N711PCPhillip H Cotter CHALLENGER II · S/N CH2-0105-2586N720JFCirrus Design SR22T · S/N 9068N797MSSiai-Marchetti F.260 · S/N 2-28N8541Powrachute PC 2000 · S/N A234POWN8573WPiper PA-28-235 · S/N 28-10085N88441Piper J3C-65 · S/N 16061
Back to Parkville, MO