Stevensville, MT
Registered aircraft · 54
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 = 'STEVENSVILLE' 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 = 'STEVENSVILLE' 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.
N137YGrumman American Avn. AA-1C · S/N AA1C0137N13XZThomas Craig E WITTMAN W-10 · S/N 975N1714QCessna 150L · S/N 15073014N19717Cessna 172L · S/N 17260695N204AQBell 204-B · S/N 2198N204ASDJI AGRAS T20P · S/N 1581F574B226600100UUN204THBell UH-1P · S/N 63-13150N208SSCessna A185F · S/N 18502452N2234VCessna 140 · S/N 14465N225MZCameron Balloons US Z-225 · S/N 6543N2298JCessna 150G · S/N 15065498N23DPCameron Balloons US O-120 · S/N 6684N244SCLancair LC42-550FG · S/N 42047N2528LCessna 172H · S/N 17255728N2626FCessna 182J · S/N 18256726N267RDRockwell International 690B · S/N 11456N29181Cessna U206C · S/N U206-1147N2977FCessna 182J · S/N 18257077N2WCessna A185F · S/N 185-02982N3095ZPiper PA-18-150 · S/N 18-7151N3360RCessna A185F · S/N 18502874N3585KPiper J3C-65 · S/N 22276N3945PPiper PA-22-150 · S/N 22-3620N3948ZPiper PA-18-150 · S/N 18-7806N4328XPiper PA-12 · S/N 12144N4546FCessna A185E · S/N 185-1039N4737APiper PA-18A · S/N 18-4962N4969ZPiper PA-22-108 · S/N 22-8577N51047Cessna 150J · S/N 15069727N524JGKerner John KERNER LANCAIR IVP · S/N 411N524MRBeech 200 · S/N BB524N549MBUltramagic T210 · S/N 210/71N56WYRichmond Jim R CCK-1865 · S/N CCK-1865-0007N6059QMooney M20C · S/N 3247N69BAxelrod Dana RV-6 · S/N 21121N707TCTaylorcraft BC12-D · S/N 8435N719BCRainbow Skyreach BUSHCAT · S/N CH218CN743HCessna U206 · S/N U206-1297N748EEDJI AGRAS T40 · S/N 1581F574B23850010080N78937Mooney M20C · S/N 1971N8258DBeech J35 · S/N D-5361N8260NPiper PA-28-140 · S/N 28-25472N846SCCub Crafters CC11-100 · S/N CC11-00061N8506XCessna 175C · S/N 17557106N88RAPiper PA 46-350P · S/N 4636034N8942GCessna 182N · S/N 18260482Sale reported, canceledN902CBCameron Balloons U S O-160 · S/N 6688N906CBCameron Balloons US V-77 · S/N 942N920PMErick Frederick Roblessy RANS S12 · S/N ER01N9307GCessna 182P · S/N 18260847
Back to Stevensville, MT