Denver, CO
Cancelled registrations · 995
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 = 'DENVER' 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 = 'DENVER' 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.
N1961EAeronca 7AC · S/N 7AC5528N15375Arbc Inc DBA Lindstrand 90A · S/N 5403N111UXDJI INSPIRE 1 · S/N W13DCK11051666N93617Engineering & Research ERCOUPE 415-C · S/N 940N48627Aeronca 0-58B · S/N 058B7692N1313LBellanca 14-13-3 · S/N 1622N8679CPiper PA-18-135 · S/N 18-2828N39986Taylorcraft BC12-D · S/N 6645N20959Waco ZKS-7 · S/N 5232N2517GCessna 182B · S/N 51817N588SMDJI S900 · S/N 0380030172N112UXAscending Technologies ASCTEC FALCON 8 · S/N 03083N113UXTarsier Systems MOAC · S/N A-15-0001N8157PPiper PA-24-250 · S/N 24-3412N580GCColorado Dept Transportation ST-800 · S/N ST-800-CDOT-001N619UMDJI INSPIRE 1 · S/N W13DCG29040244N102UXAeryon Labs SKY RANGER · S/N ASM-000521-09 SR6021144N5292LAerostar International S-57A · S/N S57A-3227N3479LCessna U206B · S/N U206-0779N904CStinson 108-3 · S/N 108-3904N9324UCessna 150M · S/N 15078273N3344XCessna 310L · S/N 310L-0194N8096KStinson 108-2 · S/N 108-3096N403RLDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF30016835N20851Firefly Balloons FIREFLY 9B-15 · S/N F9B-2017N109UXDJI PHANTOM 2 · S/N TRM1184N110UXDJI PHANTOM 2 · S/N TRM1185N106UXDJI S800 EVO · S/N TRM530N64407Aerostar International RX-7 · S/N RX7-3046N580ECColorado Dept Transportation QAV 500 · S/N QAV500-CDOT-002N9712ACessna 170B · S/N 19173N5073ZAerostar International S-57A · S/N S57A-3211N101UXAeryon Labs SKY RANGER · S/N SKU-100001-00 SR5022294N103UXAeryon Labs SKY RANGER · S/N SKU-110001-00 SR2020219N104UXAeryon Labs SKY RANGER · S/N SKU-100001-00 SR9026256N105UXAltavian NOVA F6500 · S/N 3011N71956Hawker Beechcraft 4000 · S/N RC-39N489VCIsrael Aircraft Industries GULFSTREAM 200 · S/N 110N99185Engineering & Research ERCOUPE 415-C · S/N 1808N3133HEngineering & Research ERCOUPE 415-C · S/N 3758N822LPLeptron Industrial Robotic Hel LEPTRON AVENGER B · S/N LEP822N385KTPatterson Thomas H FREEDOM II · S/N 001N98969Cessna 172P · S/N 17276389N77246Cessna 120 · S/N 11708N8515DPiper PA-22-160 · S/N 22-5742N3530APiper PA-22-135 · S/N 22-1802N53028Cameron Balloons US N-90 · S/N 6149N29695Taylorcraft BF · S/N 2539N9661KStinson 108-2 · S/N 108-2661N3731APiper PA-22-135 · S/N 22-1974
Back to Denver, CO