Willmar, MN
Registered aircraft · 31
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 = 'MN' AND g.registrant_city = 'WILLMAR' 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 = 'MN' AND g.registrant_city = 'WILLMAR' 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.
N114DSSims Dale E VANS RV-8 · S/N 80886N1258RBellanca 14-19-3 · S/N 4329N144TLPiper PA-24 · S/N 24-1205N1587YCessna 172C · S/N 17249287N1842SCessna 414 · S/N 414-0433N1857FBeech F90 · S/N LA-167N223PTScott Allen L JR TANGO 2 · S/N 013N24878Piper J3C-65 · S/N 3511N2715PPiper PA-22-150 · S/N 22-3021N280NAEnstrom 280FX · S/N 2058N36460Piper AEROSTAR 602P · S/N 62P09008165029N3903RCessna 172H · S/N 17255403N402RXBeech 300 · S/N FA-163N406BWSportsman SPORTSMAN GS-2 · S/N 7271N4301FPiper PA-32R-300 · S/N 32R-7680433N4876VBellanca 17-30 · S/N 30118N507TMSportplanes Inc/Young/Reimer RANS S-6ES COYOTE · S/N 0593500N52BRBettcher Leroy KITFOX · S/N 52N54107Piper PA-18-150 · S/N 18-7709020N5430Schlueter CA65 · S/N GTS-1N5740QMooney M20C · S/N 3072N5884QMooney M20C · S/N 3150N681DBPilatus PC-12/47G · S/N 3029N699FLPiper PA-28-140 · S/N 28-7225193N7709HPiper PA-12 · S/N 12-601N8207NPiper PA-28-140 · S/N 28-25409N8796SCessna 150F · S/N 15062096N91567Samson Robert QUICKSILVER · S/N 0013N94EAGulfstream AM Corp Comm Div 695A · S/N 96094N9583YBeech P35 · S/N D-7043N9693DPiper PA-18A 150 · S/N 18-6794
Back to Willmar, MN