Intl Falls, MN
Registered aircraft · 36
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 = 'INTL 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 = 'INTL 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.
N103TEDehavilland DHC-2 MK. I(L20A) · S/N 1441N104SWFlight Design CTSW · S/N 07-06-09N1246Piper PA-18-135 · S/N 18-3347N1385FCessna 172G · S/N 17254880N1530BLuscombe 8E · S/N 6157N160RVAselson James E RV6 · S/N 20244N172SETextron 172S · S/N 172S12632N1917QCessna 177RG · S/N 177RG0317N1946Piper J3C-65 · S/N 6570N194GSPiper PA-28-181 · S/N 2881515N2063ANelson Steven A WAG AERO SPORT · S/N 3812N21164Stinson HW75 · S/N 7049N23985Aeronca 65-C · S/N C-6469N24762Piper J3C-65 · S/N 3430N2508NCessna 140 · S/N 12765N2666ZBellanca 7ECA · S/N 1224-78N29838Taylorcraft BC12-65 · S/N 2689N30702Mittelstadt R/Mittelstadt G REBEL · S/N R206N3635XAero Commander 100-180 · S/N 5084N42568Piper J3C-65 · S/N 14849N4509BCessna 180 · S/N 31408N4752CCessna 180 · S/N 31650N478QADJI AGRAS T30 · S/N 1581F446LJCQ30300CP0N482BBEmbraer-Empresa Brasileira De EMB-505 · S/N 50500018N621JPCirrus Design SR22T · S/N 10611N6580ACessna 180 · S/N 32477N6850ZPiper PA-18-150 · S/N 18-8133N725HCAlleman Donald E KITFOX IV · S/N C94004-0021N73338Cessna 172M · S/N 17267386N7334VBellanca 17-30 · S/N 30212N7632XCessna 172B · S/N 17248132N81CJAeropro CZ S R O A240 · S/N 51017N84406Aeronca 7GC · S/N 7AC-3080N894MTTrompeter Mark Steven CHALLENGER II · S/N 1082N9258VAeronca 7AC · S/N 7AC449N9831QPiper PA-18-135 · S/N 18-3352
Back to Intl Falls, MN