East Helena, MT
Registered aircraft · 25
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 = 'EAST HELENA' 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 = 'EAST HELENA' 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.
N11146Cessna 150L · S/N 15075222N1428UCessna 172M · S/N 17267095N157MAAviat A-1C-180 · S/N 3167N177RVDibernardino Alfred F RV-6A · S/N 20146N18EBCessna 172M · S/N 17264188N2041FPoole Don VOLMER SPORTSMAN · S/N 856N2045GAir Tractor AT-502B · S/N 502B-2820N223AZIrwin Andrew VELOCITY RG · S/N NMO 223N30584Cessna 177A · S/N 17701344N342WFAerospatiale SA342J · S/N 1470N3584YCessna 182F · S/N 18254484N3587MPiper PA-28R-201T · S/N 28R-7803179N362DBHawker Beechcraft G36 · S/N E3941N3939HEngineering & Research ERCOUPE 415-CD · S/N 4640N5101DCessna 182A · S/N 51201N61LCAmerican Legend AL3 · S/N AL-1147N6502XLancair LC42-550FG · S/N 42039N713SSIai GULFSTREAM G280 · S/N 2070N726DNColumbia Aircraft Mfg LC41-550FG · S/N 41684N7720WPiper PA-28-180 · S/N 28-1726N772LMPiper J5A · S/N 5-239N8143DCirrus Design SR22 · S/N 0678N8BEMccoy-Heinbockel LONGEZE · S/N 998First renewal noticeN9561MMooney M20C · S/N 670106N9690SChampion 7ECA · S/N 418
Back to East Helena, MT