Fort Garland, CO
Registered aircraft · 19
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 GARLAND' 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 GARLAND' 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.
N125PRaven Industries S77A · S/N S77A-111N15162Firefly Balloons GALAXY 11B · S/N GLX-1111BN15193Balloon Works FIREFLY 7-B · S/N 10969N1521GFirefly Balloons FIREFLY 8B · S/N F8B-2029N1642LFirefly Balloons FIREFLY 7-15 · S/N F7-2071N2106FBalloon Works FIREFLY 5 · S/N 501N2380HBalloon Works FIREFLY 7 · S/N 7724N2528GGeneral Balloon AX-6 · S/N 510N25536Balloon Works FIREFLY 8 · S/N F8-389N2570EBalloon Works FIREFLY 9 · S/N F9-060N3663CLange Joseph M STOL CH 701 · S/N 7-10503N40501Balloon Works FIREFLY 7 · S/N 7936N528AKMiller John A VANS RV-8A · S/N 81517N7155ZAerostar International RX 8 · S/N RX8-3247N7400NCameron Balloons US A-140 · S/N 5093N7417UBalloon Works FIREFLY 7 · S/N F7-358N9074MBalloon Works FIREFLY 8 · S/N F8-378N9089KBalloon Works FIREFLY 7 · S/N F7-604N9803LRaven Industries RX6 · S/N RX6-107
Back to Fort Garland, CO