Boonville, MO
Registered aircraft · 314
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 = 'BOONVILLE' 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 = 'BOONVILLE' 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.
N109FUEa Vision EA J100 · S/N 85623N113FUEa Vision EA J100 · S/N 85645N145RDDJI AGRAS T40 · S/N 1581F574B22BE001001DN146FADJI AGRAS T40 · S/N 64TBL4E002001RN155DAEa Vision EA J100 · S/N EAVUAV502585804N162FUEa Vision EA J100 · S/N 85554N163DAEa Vision EA J100 · S/N EAVUAV502585805N17219Cessna 177B · S/N 17702519N172FUEa Vision EA J100 · S/N 85700N174EAEa Vision EA J100 · S/N 85501N187ASEa Vision EA J100 · S/N EAVUAV502585859N189ARTextron 208B · S/N 208B5650N190DAEa Vision EA J100 · S/N EAVUAV502585808N193DAEa Vision EA J100 · S/N EAVUAV502585809N195ASEa Vision EA J100 · S/N EAVUAV502585860N205EAEa Vision EA J100 · S/N 85392N213DAEa Vision EA J100 · S/N EAVUAV502585812N219ASEa Vision EA J100 · S/N EAVUAV502585861N221DAEa Vision EA J100 · S/N EAVUAV502585813N223ZADJI AGRAS T20P · S/N 1581F574B23830010003N225GREa Vision EA J100 · S/N 85418N226FUEa Vision EA J100 · S/N 85573N227GREa Vision EA J100 · S/N 85368N228EAEa Vision EA J100 · S/N 85470N229FUEa Vision EA J100 · S/N 85663N231FUEa Vision EA J100 · S/N 85719N232FUEa Vision EA J100 · S/N 85544N232GREa Vision EA J100 · S/N 85379N233FUEa Vision EA J100 · S/N 85630N233GREa Vision EA J100 · S/N 85401N234FUEa Vision EA J100 · S/N 85611N235FUEa Vision EA J100 · S/N 85713N236FUEa Vision EA J100 · S/N 85730N238ASEa Vision EA J100 · S/N EAVUAV502585863N2393NAir Tractor AT-400 · S/N 400-0441N243DAEa Vision EA J100 · S/N EAVUAV502585815N248EAEa Vision EA J100 · S/N 85426N249ASEa Vision EA J100 · S/N EAVUAV502585864N250ASEavision EA-J150 · S/N 1596A30E22EC1E6N251DAEa Vision EA J100 · S/N EAVUAV502585816N254ASEa Vision EA J100 · S/N EAVUAV502585866N2574CDJI FLYCART 30 · S/N 1581F7C6B23AS001H153N260DAEa Vision EA J100 · S/N EAVUAV502585817N265EAEa Vision EA J100 · S/N 85499N267FUEa Vision J-150 · S/N JMZKJ150UAV602596048N267GREa Vision EA J100 · S/N EAVUAV502485324N268FUEa Vision J-150 · S/N JMZKJ150UAV602595460N269FUEa Vision J-150 · S/N JMZKJ150UAV602595481N270FUEa Vision J-150 · S/N JMZKJ150UAV602595710N271FUEa Vision J-150 · S/N JMZKJ150UAV602595716
Back to Boonville, MO