Marion, MT
Registered aircraft · 42
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 = 'MT' AND g.registrant_city = 'MARION' 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 = 'MT' AND g.registrant_city = 'MARION' 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.
N103LHBeech 58 · S/N TH-1170N113SHBeech 100 · S/N B-18N114LHShort Bros. & Harland SC-7 · S/N SH-1926N11CLLowry MOD. CL-1 · S/N BB1N128WJDehavilland DHC-6 TWIN OTTER · S/N 128N155BKCarroll Brian D RV-7 · S/N 72908N17DXGary Gove CCX-2000 · S/N CCX-2000-0195N1861GDavid W Groat VANS RV-10 · S/N 41389N191BSCirrus Design SR22 · S/N 2733N192LHRockwell International 695 · S/N 95019N194LHDehavilland DHC-6 TWIN OTTER · S/N 194N204BDDehavilland DHC-6-200 · S/N 204N2071GCessna 182A · S/N 51371N224ALCessna 210-5 · S/N 2050342N22HUAviat A-1 · S/N 1355N2392PPiper PA-22-150 · S/N 22-2783N23LHCessna 185 · S/N 18502433N2507Dennis Murphy Wagar ZENITH 801 · S/N 5330N26LHShort Bros. & Harland SC-7 · S/N SH-1925N28LHShort Bros. & Harland SC-7 · S/N SH-1851N302MXAviat A-1B · S/N 2008N3473ZPiper PA-18-150 · S/N 18-7298N36BNBeech A36 · S/N E-1058N395XMaule M-5-235C · S/N 7037CRegistration pending, pending cancellationN39LHShort Bros. & Harland SC7 SERIES 3 · S/N SH1920N40628Maule M-4-220C · S/N 2149CN4662ECessna 182R · S/N 18268256N52LHShort Bros. & Harland SC7 SERIES 3 · S/N SH1968N544TGRobinson Helicopter R44 II · S/N 11177N5962ECessna 150 · S/N 17462N6078DPiper PA-22-150 · S/N 22-4732N6239NSwindle Donald M TORNADO · S/N 5240N62LHDehavilland DHC-6 TWIN OTTER · S/N 97N631LSLockheed 18-56 · S/N 2404N6433ACessna 182 · S/N 33233N72LHShort Bros. & Harland SC7 SERIES 2 · S/N SH-1960N762BMBaron R Marshall RV-8 · S/N 82351N82LHDehavilland DHC-6-200 · S/N 208N86875Bellanca 14-13 · S/N 1237N87LHBell 205A-1 · S/N 30087N96337Taylorcraft BC12-D · S/N 8637N990CKCessna 182P · S/N 18265006
Back to Marion, MT