Kalispell, MT
Registered aircraft · 1,281
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 = 'KALISPELL' 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 = 'KALISPELL' 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.
N1003CPiper PA-28-140 · S/N 28-22741N100EDGulfstream Aerospace GVII-G600 · S/N 73019N100TBeech B95 · S/N TD-350N101KJBaker Victor R KITFOX SERIES 7 · S/N S70308036N101YWaco RNF · S/N 3272N1020GAirbus Helicopters AS350B3 · S/N 8250N1021XPiper PA-28R-200 · S/N 28R-7535219N1023SWaco ATO · S/N A-69N102AAAviat A-1B · S/N 2393N102ZWWarren Hahne KIT FOX IV · S/N 1595N104MGalpin Henry M BUCKER AERO Z 131 · S/N 157N1063BMooney M20A · S/N 1290N10699Bell 206B · S/N 2857N106PCCessna 750 · S/N 750-0061N1076APiper PA-18 · S/N 18-659N108EHRobinson Helicopter R44 II · S/N 10951N11082Hughes Helicopters HUGHES 369D · S/N 1100845DN110FSCessna 182H · S/N 18256604N110GSScherrer Glenn R RV10 · S/N 40607N111HClarke Hap VANS RV-7A · S/N 70695N113JPAerospatiale AS350B1 ECUREUIL · S/N 2265N113PWKubicek Factory S R O BB78Z · S/N 2106N1141NMooney M20J · S/N 24-1168N1144MCessna 172L · S/N 17259444N1149GMooney M20K · S/N 25-0606N114VVWinfield Orville R VARIVIGGEN · S/N 114N1156TBeech V35B · S/N D-9761N1163BMooney M20K · S/N 25-0667N1167CPiper PA-22 · S/N 22-992N116HBeech 95-B55 (T42A) · S/N TC-812Registration pendingN118LABeech B-55 · S/N TC-1994N11FPBeech C35 · S/N D-3104N120AFRobinson Helicopter R44 · S/N 2055N121ARIar Sa Brasov IAR 823 · S/N 53N121PAMooney International M20U · S/N 32-0010N122GBDassault FALCON 900 · S/N 026N1238YCessna 150B · S/N 15059638N123TNAirplane Factory SLING 2 · S/N 006N123WLLenox Donald W LIGHTNING · S/N 63N124PWPaul A Westcott RV 7A · S/N 72854N124SLAviat A-1C-180 · S/N 3382N1252RBellanca 14-19-3 · S/N 4342N12753Cessna 172M · S/N 17262232N127RHCirrus Design SR22T · S/N 9592N127VTCirrus Design SR22T · S/N 0197N12813Cessna 208B · S/N 208B0808N128ACSmith AEROSTAR 601 · S/N 61-0170-084N128GCMesserschmitt-Bolkow-Blohm BO 105 P · S/N 6006N129MSMartinez Andrew R VANS RV-4 · S/N 3712N12PXPiper AEROSTAR 601P · S/N 61P-0524-220
Back to Kalispell, MT