Whitefish, MT
Registered aircraft · 84
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 = 'WHITEFISH' 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 = 'WHITEFISH' 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.
N1067NBoeing E75 · S/N 75-5313N11WBCessna 525 · S/N 525-0616N123RGBeech V35A · S/N D-8816N1257RBellanca 14-19-3 · S/N 4325N13721Cessna 172M · S/N 17262968N165BCAmerican Champion 8GCBC · S/N 600-2019N1804VCessna R172K · S/N R1722214N193AAMitsubishi MU-2B-60 · S/N 741SAN19768Cessna 172L · S/N 17260736N1TWGates Learjet 35A · S/N 476Registration expired, pending cancellationN200Embraer-Empresa Brasileira De EMB-500 · S/N 50000058N2061ABeech A36 · S/N E-1425N2181FCessna U206 · S/N U206-0381N22076Cessna 150H · S/N 15068047N23WFScoda Aeronautica Ltda SUPER PETREL XP · S/N S0427Registration pendingN243SWWells P/Sands T JW 1 · S/N 001SWN244TACirrus Design SR22T · S/N 0138N244VPilatus PC-24 · S/N 252N2600DCessna 170B · S/N 20752N263SNRaytheon HAWKER 800XP · S/N 258580N2718FCessna 182J · S/N 18256818N281BTBig Wheel Cub CCX-2000 · S/N CCX-2000-0224N2961MPiper PA-12 · S/N 12-1354N305GLBell Helicopter Textron 206B · S/N 2790N316LVEpic E1000 · S/N K097N32MEmbraer Executive EMB-505 · S/N 50500792N333MXDassault FALCON 2000EX · S/N 120N348PSMooney M20M · S/N 27-0348N357EKTextron 525C · S/N 525C0357N35KMGinther Michael P KITFOX · S/N 035N363DFCirrus Design SR22T · S/N 10620N3951WPiper PA-32-260 · S/N 32-900N3994SCessna 172E · S/N 17251194N4029PRobinson Helicopter R44 II · S/N 14094N40MTCessna 180A · S/N 32681N423CSCessna 525B · S/N 525B0121N43415Taylorcraft BC12-D · S/N 7074N444DLCub Crafters CC19-215 · S/N CC19-0089N4610MPiper PA-11 · S/N 11-114N4740QCessna A185E · S/N 185-1194N48MRPiper PA-12S · S/N 12-2583N4997HPiper PA-11 · S/N 11-879N49SLPiper PA-12 · S/N 12-1302N5039HCessna 172M · S/N 17265311N510CKCirrus Design SR22T · S/N 2350N52981Cessna 182P · S/N 18262984N540KLDale R Johannes BEARHAWK · S/N 1083N552MTCub Crafters CC18-180 · S/N CC18-0064N560JDCessna 560 · S/N 560-0174N575SMCirrus Design SF50 · S/N 0537
Back to Whitefish, MT