Grand Rapids, MN
Registered aircraft · 53
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 = 'GRAND RAPIDS' 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 = 'GRAND RAPIDS' 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.
N105NRTextron T206H · S/N T20609780N125KPiper PA-18-150 · S/N 18-7709033N1265DCessna 170A · S/N 19841N145NREnstrom Helicopter 480B · S/N 5096N155NRMD Helicopters 369E · S/N 0623EN1646GChampion 7GCAA · S/N 100N168HLLearjet 60 · S/N 041N169LJLearjet 60 · S/N 60-169N18DPPiper PA-18-150 · S/N 18-7509140N1BPCessna 182D · S/N 18253260N205NRCessna A185F · S/N 18504317N210DRCessna T210N · S/N 21063011N2238CCessna 180 · S/N 30538N2567EAeronca 7AC · S/N 7AC-6150N2584KCessna 180K · S/N 18053005N25TECirrus Design SR22T · S/N 10707N2681MPiper PA-12 · S/N 12-1112N2880CCessna 170B · S/N 26423N2UYLake LA-4-200 · S/N 685N3446EAeronca 7AC · S/N 7AC-6839N39596Aeronca 65-TAC · S/N C5603TAN410CECessna 180J · S/N 18052477N41165Piper J3C-65 · S/N 7785N4163UCessna 150D · S/N 15060163N4652EAeronca 7EC · S/N 7EC-3N473PWJames Watsell Miller JR MK IV · S/N 1085DN528NRKodiak KODIAK 100 · S/N 100-0315N529NRQuest KODIAK 100 · S/N 100-0165N57468Bellanca 7GCBC · S/N 514-73N579JDCessna A185F · S/N 18503964N605NRCessna A185F · S/N 18504437N60822Cessna 150J · S/N 15070600N61841Cessna 172M · S/N 17264835N6189MStinson 108-3 · S/N 108-4189N6418DCessna 172N · S/N 17272793N646DCCessna A185F · S/N 18502781N6937MStinson 108-3 · S/N 108-4937N705NRAmerican Champion 8GCBC · S/N 415-2000N7189GCessna 172K · S/N 17258889N7234GCessna 172K · S/N 17258934First renewal noticeN739XKCessna 172N · S/N 17270887N764MSCessna 182B · S/N 52132N78850Cessna 172K · S/N 17257790N793CJCessna 525 · S/N 525-0021N805NRCessna A185F · S/N 18504197N8210RBellanca 17-30A · S/N 30421N832TCCessna 182T · S/N 18281269N8787MPiper PA-12 · S/N 12-3437N8912RChampion AERONCA 7EC · S/N 7EC-715N905NRAmerican Champion 8GCBC · S/N 479-2006
Back to Grand Rapids, MN