Aspen, CO
Registered aircraft · 50
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 = 'ASPEN' 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 = 'ASPEN' 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.
N101MWCirrus Design SR22 · S/N 2823N1127GCirrus Design SR22T · S/N 2440N1161PMooney M20K · S/N 25-0658N123PJEpic E1000 · S/N K012N133MDBeech F33A · S/N CE-1163N145EAEclipse EA500 · S/N 000145N145UADiamond Aircraft Ind DA 40 NG · S/N 40.NC239N1515CCessna 180 · S/N 30215N193CBNorton Claude C BOWERS FLY BABY 1A · S/N 03193N2477GCessna 182B · S/N 51777N265BLDiamond Aircraft Ind DA 40 NG · S/N 40.NC305N276BLDiamond Aircraft Ind DA 40 NG · S/N 40.NC306N2845FPiper PA-28-201T · S/N 28-7921062N308NJTextron 525 · S/N 525-0912N311AFDiamond Aircraft Ind DA 40 NG · S/N 40.NC365N332AFDiamond Aircraft Ind DA 40 NG · S/N 40.NC366N3484YCessna 180H · S/N 18051984N37JHDiamond Aircraft Ind DA 62 · S/N 62.C035N3975ABombardier BD-100-1A10 · S/N 20170N429MMBell Textron Canada 429 · S/N 57498N4362QCessna 172L · S/N 17260262N4431VCessna 182Q · S/N 18265958N514RSBeech 2000 · S/N NC-51N523SMCessna 182S · S/N 18280747N52ZGTextron 525 · S/N 525-0891N5678Smith AEROSTAR 600 · S/N 60-0017N5700MCessna 185D · S/N 185-0857N6094BCessna T210M · S/N 21062681N650DMSocata TBM 700 · S/N 85N694BHCompagnie Daher TBM 700 · S/N 1472N700HNSocata TBM 700 · S/N 204N701WCGulfstream Aerospace GIV-X (G450) · S/N 4224N751MMCessna 750 · S/N 750-0146N761XECessna T210M · S/N 21062594N825DLCirrus Design SR22T · S/N 1788N858EEEmbraer S A EMB-505 · S/N 50500352N858PGCirrus Design SR22T · S/N 2095N858ZGCirrus Design SR22T · S/N 1956N86WMCessna Ector 305A · S/N 2017N888GSCessna 510 · S/N 510-0209N89994Piper PA-18-150 · S/N 18-8510N8YUPilatus PC-12/45 · S/N 413N912FUSpeirs Thomas ANTERAS MA 33 · S/N 102N914FUThomas Speirs APOLLO AG1 · S/N 10116N924BBSocata TBM 700 · S/N 405N951LECessna 320F · S/N 320F-0029N96CBMooney M20J · S/N 24-3346N977RWRyan Walterscheid SLING HW · S/N 041GKN980AXCompagnie Daher TBM 700 · S/N 1633N995VJCirrus Design SF50 · S/N 0059
Back to Aspen, CO