Anaconda, MT
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 = 'MT' AND g.registrant_city = 'ANACONDA' 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 = 'ANACONDA' 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.
N11147Vauthier Gary Joseph ROTORWAY INTL EXEC · S/N 6748N115NFAraldi J Michael RV-8 · S/N 81268N12MRMolino PIK-20B · S/N 20038N14ZBell Helicopter Textron Canada 407 · S/N 54704N171GCDehavilland DHC-6-300 · S/N 406N178GCDehavilland DHC-6-300 · S/N 697N19WJJet Noise JSX-02 · S/N JSX0019N21310Cessna 182P · S/N 18261552N218SYCirrus Design SR22T · S/N 1720N222KP222kp AL-18 · S/N AL-412N230KSchempp-Hirth VENTUS-2C · S/N 64N248YSTailwheelz AL-18 · S/N AL-410N272GXEpic E1000 · S/N K072N285WYAviat A-1C-180 · S/N 3285N286JKDougherty Michael B VANS RV-7A · S/N 71577N307RTEnstrom F-28F · S/N 768N308BWCcx-1865 CCX-1865 · S/N CCX-1865-2037N3268BPiper PA-22-135 · S/N 22-2089N4100KTextron T240 · S/N T24002132N441ABCessna 441 · S/N 441-0284N4506YRobinson Helicopter R66 · S/N 0004N516RJRobinson Helicopter R44 II · S/N 13989N5523RCessna 172RG · S/N 172RG0069N56PHEdmund Harrison CCX-1865 · S/N CCX-1865-1011N7020FPiper PA-34-200T · S/N 34-7770051N712CMCirrus Design SR22T · S/N 1148N7257YPiper PA-30 · S/N 30-290N73CZPiper PA-31-350 · S/N 31-8052177N751BPHonda HA-420 · S/N 42000245N754BP46u CCK-2000 · S/N CCK-2000-0050N755BP46u CCX-2300 · S/N CCX-2300-0098N791BAeropro CZ A220 · S/N 499 16N8013KBurkhart Grob G 103 TWIN II · S/N 3702N937CASocata TBM 700 · S/N 1201N9605VChristen Industries A-1 · S/N 1144N977CHBell 206B-III · S/N 4032
Back to Anaconda, MT