Fort Morgan, CO
Registered aircraft · 32
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 = 'FORT MORGAN' 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 = 'FORT MORGAN' 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.
N1384LCessna T337H · S/N 33701876N14PTReid Nicholas M SPORTSMAN 2+2 · S/N 001N18ZDTextron 525C · S/N 525C0262N21404Cessna 182P · S/N 18261615N2223ZPiper PA-28RT-201T · S/N 28R-7931170N23788Cessna R172E · S/N R172E-0092N2462LCessna 172H · S/N 17255662N2523EAeronca 7BCM · S/N 7AC-6105N3096QCessna 182K · S/N 18258096N310NZCessna 310N · S/N 310N-0173N40SMRockwell International 690B · S/N 11559N42NZRockwell International 500-S · S/N 3322N440AAPiper PA-28-181 · S/N 2881254N49YHGreg Swingle SWINGLE RANS S-75 · S/N 0311553N557PGCessna 560 · S/N 560-0557N55WJRockwell International 690B · S/N 11427N602BAAir Tractor AT-602 · S/N 602-1173N660AAPiper PA-28-181 · S/N 2881255N7690GCessna 150L · S/N 15074716N802NZAir Tractor AT-802A · S/N 802A-0956N803NZAir Tractor AT-802A · S/N 802A-0645N804NZAir Tractor AT-802A · S/N 802A-0683N806NZAir Tractor AT-802A · S/N 802A-0735N809NZAir Tractor AT-802A · S/N 802A-0789N8291LCessna 172H · S/N 17256491N829BACessna P210N · S/N P21000819N881GBGame Composites GB1 GAMEBIRD · S/N 0009N88VPCullop VOLKSPLANE DC-1 · S/N 1First renewal noticeN922RCTextron 525C · S/N 525C0401N9416YBeech N35 · S/N D-6594N9488JPiper PA-28-180 · S/N 28-3605N9764WPiper PA-28-140 · S/N 28-23250
Back to Fort Morgan, CO