Great Falls, MT
Registered aircraft · 88
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 = 'GREAT 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 = 'MT' AND g.registrant_city = 'GREAT 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.
N1007VBellanca 17-31ATC · S/N 73-31060N105BBAviat A-1A · S/N 1416N10JLTaylorcraft BC12-D · S/N 6681N11029Champion 7ECA · S/N 7ECA-6N11510Cessna 150L · S/N 15075473N12ALDavis A L PITTS SPECIAL S-1S · S/N DAV-1N1393ZBeech N35 · S/N D-6813N144DVAnderson Darrell L VANS RV-4 · S/N 2850N1557Corben E · S/N GN-1N156BDBede BD-4 · S/N 156N19822Grayson Robert E STAR-FIRE · S/N 0395N201VRMooney M20J · S/N 24-0349N211FBeech 95-B55 (T42A) · S/N TC-514N224APSiai-Marchetti SF260W · S/N 293/24-05N2258YCessna 177 · S/N 17700058N2314GCessna 182B · S/N 51614N23FTHawker Beechcraft 390 · S/N RB-275N24588Beech B24R · S/N MC-157N24GBCessna 421C · S/N 421C0287N25104Vandergeest HATZ-VAN · S/N 2501N2531DCessna 170B · S/N 20683N25622Piper PA-28-181 · S/N 28-8590090N2659GCessna 182B · S/N 51959N26CZCirrus Design SR22T · S/N 1962N28UPPiper PA-28R-200 · S/N 28R7335386N29083Piper J3C-65 · S/N 6055N293ASEa Vision EA J100 · S/N EAVUAV502585876Registration pendingN3100QPiper PA-28R-201T · S/N 28R-7703091N323GGEmbraer Executive EMB-505 · S/N 50500785N32681Piper PA-28-235 · S/N 28-7510029N331CBCessna T210N · S/N 21063747N340LZCessna 340 · S/N 340-0537First renewal noticeN355SCCessna T310Q · S/N 310Q0795N3688APiper PA-18-135 · S/N 18-3036N3835YCessna 210D · S/N 21058335N3840DCessna 182A · S/N 34540N3850KSmalley Kenneth L ZENAIR CH 701SP · S/N 7-9651N4013XAero Commander 100-180 · S/N 5113N406GLNoel Simmons RV14 · S/N 140373N40GFPilatus PC-12/47E · S/N 2142N42442Piper J3C-65 · S/N 14708N4301NPiper PA-32R-301T · S/N 32R-8329025N4459Dunning-Stits Playboy SA3B · S/N GD-1N447KSPiper PA-28-140 · S/N 28-25439N4535HMooney M20J · S/N 24-0793N455TBCessna 310R · S/N 310R1860N4800ZPiper PA-22-108 · S/N 22-8367N487JMJesse D Mcmurtry GLASTAR · S/N 5344N49019Taylorcraft DCO-65 · S/N L-5207N50747Cessna 150J · S/N 15069526
Back to Great Falls, MT