Montrose, CO
Registered aircraft · 83
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 = 'CO' AND g.registrant_city = 'MONTROSE' 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 = 'CO' AND g.registrant_city = 'MONTROSE' 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.
N115AHAirbus Helicopters AS 350B3 · S/N 9390N122CLCirrus Design SR22 · S/N 2108N13YMClifford L Scheel CCK-1865 · S/N CCK-1865-0026N14983Ryan Aeronautical ST-A · S/N 115First renewal noticeN152LCessna 152 · S/N 15283964N159XQXag P100 · S/N 8218250296UMN1661MCessna 182P · S/N 18264406N167EZErnest T Christley ZENITH ZODIAC 601XL · S/N 4942N175PCessna 175 · S/N 55064N175RCessna 175A · S/N 56574N202SCessna 180 · S/N 32355N20YBMooney M20C · S/N 2708First renewal noticeN21868Firefly Balloons FIREFLY 8B-15 · S/N F8B-2069N22WRCessna 182Q · S/N 18267626N235TTMaule M-7-235B · S/N 23031CN237BSAmerican Eurocopter AS350B3 · S/N 7542N248XNEvolution REVOLT · S/N 001021N2522WCessna 172D · S/N 17250128N2546LSoaring Concepts SKY TREK · S/N 2002010N2558CXag P100 PRO · S/N 82193438K2X7N2582UBalloon Works FIREFLY 7-15 · S/N F7-879N267PTPilatus PC-12/47E · S/N 2169N306SRCirrus Design SR22 · S/N 2469N319WAKaman Aerospace K-1200 · S/N A94-0048N3231ZPiper PA-22-150 · S/N 22-7176N32407Balloon Works FIREFLY 7-15 · S/N F71013N328HWAirbus Helicopters AS 350B3 · S/N 8739N3507JCessna 150E · S/N 15061207N352LCessna 310B · S/N 35769N3708ZPiper PA-22-150 · S/N 22-7577N373MACessna T206H · S/N T20608117N39RTTurnbull Ronald W KITFOX 4 · S/N 1494N3LMManary Lowell A MJ51 · S/N 1N4033RPiper PA-32-300 · S/N 32-40329N415SVCessna 337D · S/N 337-1135N4200Lake LA-4-200 · S/N 674N4500KCessna P210N · S/N P21000201N4503DBeech G35 · S/N D-4617N4564HMooney M20C · S/N 3006N4628BCessna 180 · S/N 31526N464PMCessna T206H · S/N T20608053N4733RBell 47G-3B-2 · S/N 6722N484TJEnstrom Helicopter 480B · S/N 5097N4926ACessna 180 · S/N 32323N494GBVector HD 580 · S/N 5300C831Registration pendingN505CEMooney M20C · S/N 680092N509RGHebb J/Dondale B SPORTSMAN 2+2 · S/N 1169N50JTPiper PA-22-150 · S/N 22-7287N5138XChampion 7GCBC · S/N 159N5166HCessna T182T · S/N T18208125
Back to Montrose, CO