Columbia Falls, MT
Registered aircraft · 33
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 = 'COLUMBIA 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 = 'COLUMBIA 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.
N110LVDedominicis Alex E VANS RV-10 · S/N AD002(40193)N166CAeropro CZ S R O A240 · S/N 55819N17656Beech V35B · S/N D-9995N185WCCessna A185E · S/N 18501771N214TSSchweizer 269D · S/N 0073AN2548APiper PA-22-135 · S/N 22-845N2687FCessna 182J · S/N 18256787N27LVDe Dominicis Alex RV7-A · S/N 72987N3040YCessna 182E · S/N 18254040N3128QCessna 182K · S/N 18258128N3975SCessna 172E · S/N 17251175Registration pendingN3977RPiper PA-28-180 · S/N 28-7105082N406DPCessna 180H · S/N 18051805N40892Wyman Corwyn W BENSEN B-80 A · S/N CW-AB1N419JNMast Jonathan VANS RV4 · S/N 419N4214PGame Composites GB1 GAMEBIRD · S/N 0113N439KFBurroughs Garrett KITFOX S7 STI · S/N KA21087491N470RStinson 108-3 · S/N 1084374N49105Interstate S-1B1 · S/N 203N50EHAviat A-1B · S/N 2083N527BCDidericksen Gar RV-6A · S/N 22465N5548ECessna 150 · S/N 17048N5618YCessna T206H · S/N T20608471Registration pendingN657MTJoern Jeff KITFOX SUPER SPORT · S/N KA08334149N674SRMaule M-6-235 · S/N 5008CN67DFFrancis Daniel FRANCIS CA-7 · S/N 98191N7276JPiper PA-28-140 · S/N 28-24619N727LVDe Dominicis Alex VANS RV7 · S/N 73283N727SRCirrus Design SR22 · S/N 2613N7927RBeech E33C · S/N CJ-20N81230Fairchild 24R-46S · S/N W46131N88ATCirrus Design SF50 · S/N 0616N998GSFreefly Systems ALTA · S/N ALTA627
Back to Columbia Falls, MT