Little Falls, MN
Registered aircraft · 48
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 = 'LITTLE FALLS' 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 = 'LITTLE FALLS' 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.
N11059Champion 7ECA · S/N 71N1118HAeronca S15AC · S/N 15AC-134N1209HAeronca 15AC · S/N 15AC-221N1287HAeronca 15AC · S/N 15AC-303N1330HAeronca 15AC · S/N 15AC-367N1345HAeronca 15AC · S/N 15AC-388N1372HAeronca 15AC · S/N 15AC-421N1421HAeronca 15AC · S/N 15AC-482N159Aeronca 15AC · S/N 15AC-43N205JBSolsrud David A GLASAIR SH2 · S/N 713TDN3273FMooney M20F · S/N 670366N3353PPiper PA-23-160 · S/N 23-1308N344ARScott Ronald P SONEX · S/N 1074N39WLBell OH-13E · S/N 514N410AFRobinson Helicopter R44 II · S/N 13097N411HBPiper PA46-500TP · S/N 4697303N44134Taylorcraft BC12-D1 · S/N 9934N46201Cessna 172I · S/N 17257103N46ANNicoson Alan E LEGEND · S/N 2955N492VPPowrachute AIRWOLF 912ULS · S/N A457ULSN5523SCessna 188 · S/N 188-0023N55JEPiper PA-23 · S/N 23-772N5646ACessna 172 · S/N 28246N5676ACessna 172 · S/N 28276N5729ECessna 150 · S/N 17229N59PJBeech A36 · S/N E-2395N6311MStinson 108-3 · S/N 108-4311N65723Lake LA-4-200 · S/N 624N6641FCessna 150F · S/N 15063241N6717ACessna 172 · S/N 28817N6867ACessna 172 · S/N 28967N7019VMooney M20F · S/N 22-1371N7046AMathews Theodore K AVID MARK IV · S/N 1202DN7108GCessna 172K · S/N 17258808N7130TPiper PA-24-250 · S/N 24-598N735PMCessna 182Q · S/N 18265577N74522Mooney M20B · S/N 1833N77ZMCirrus Design SR22T · S/N 0923N7949BCessna 172 · S/N 29749N7955GSensefly EBEE · S/N EB-02-532N8013XBiggs Bret P ROTORWAY EXEC 90 · S/N 5030N8214ACessna 170B · S/N 25066N823SNAeronca 15AC · S/N 15AC 464N8570BCessna 172 · S/N 36270N8657XCessna 180D · S/N 18051057N8746BCessna 172 · S/N 36446N944QBeech N35 · S/N D-6818N96150Taylorcraft BC12-D · S/N 8450
Back to Little Falls, MN