Fort Collins, CO
Cancelled registrations · 92
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'CO' AND d.registrant_city = 'FORT COLLINS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'CO' AND d.registrant_city = 'FORT COLLINS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N159YUXag V40 · S/N 1865F10X000000002170N4110RDiamond Aircraft Ind DA20-C1 · S/N C0472N1076DFurniss Douglas W MURPHY REBEL · S/N DW542616N1490MPrecisionhawk LANCASTER 5 · S/N PCM-0V6-20162-032-VEXN1981WDJI INSPIRE 1 · S/N W13DDJ12060439N1490ZPrecisionhawk LANCASTER · S/N PCM-048-201530-003-MS1N710DPBell 407 · S/N 53249N5043CBeech B35 · S/N D-2305N462SRCirrus Design SR22 · S/N 2495N3537GLuscombe 8A · S/N S66N7466ADJI SPREADINGWINGS S1000 · S/N 03P0014296N748FADJI PHANTOM 4 · S/N 07DDD1PV080545N361PGDJI PHANTOM 3 ADVANCED · S/N P77DCE1N4XHLynch Raymond J HELICYCLE · S/N 03020AN627TBColorado State University SENIOR TELEMASTER · S/N 6349214N36655Aeronca 65-CA · S/N CA17331N3732ZPiper PA-22-160 · S/N 22-7611N4543EAeronca 7DC · S/N 7DC-145N2603VCessna 170 · S/N 18113N7390KCessna R172K · S/N R1722070N216TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 1995USAN7029LAerostar International RX 8 · S/N RX8-3202N136ZXSix Chuter SKYE RYDER AEROCHUTE · S/N 97-1721-2SR7N3145CBeech T-34A · S/N G-735N99AEGlasflugel STANDARD LIBELLE · S/N 182N7100LPraczko Vincent PARADRAGON · S/N PL-2N4448YPadelt PG37-1 · S/N 3898N122RBRaven Industries S-66A · S/N S66A-142N3581SRans S-12XL AIRAILE · S/N 10N4860TPiper PA-28-180 · S/N 28-7205211N95627Mcdonnell Douglas Helicopter 369E · S/N 0324EN92522Cessna 182N · S/N 18260243N77684Fairchild 24R-46 · S/N R46384N8859FHughes 269A · S/N 0226N3782JCessna 150G · S/N 15065082N28UKLindstrand Balloons 150A · S/N 5209N510DMBurns M J/Allerheiligen D A ZENITH CH 701 · S/N 7-5464N8892RDowner BELLANCA 14-19-3A · S/N 4254N81CSBalloon Works FIREFLY 7-B · S/N 10234N12XTExtra Flugzeugbau EA 300/L · S/N 1208N24965Cessna 152 · S/N 15280476N3143BAugustin V O DRAGON FLY · S/N 015N4721PCessna P210N · S/N P21000091N7421SSmith AEROSTAR 601 · S/N 61-0006N8228YPiper PA-28-161 · S/N 28-8016346N94298Schweizer SGS 1-23HM · S/N 70N1370BLuscombe 8F · S/N 5997N7418HBalloon Works FIREFLY 8B · S/N F8B-047N2532HErcoupe 415-C · S/N 3157N67284Cessna 152 · S/N 15281723
Back to Fort Collins, CO