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.

N1961EAeronca 7AC · S/N 7AC5528Cancelled Oct 18, 2019 · Revoked, canceled · Built 1946 · Aircraft Finance IncN15375Arbc Inc DBA Lindstrand 90A · S/N 5403Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 2008 · Mountain States Ad Fund IncN111UXDJI INSPIRE 1 · S/N W13DCK11051666Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Unmanned Experts IncN93617Engineering & Research ERCOUPE 415-C · S/N 940Cancelled Oct 2, 2019 · Revoked, canceled · Built 1946 · Murphy Patrick DN48627Aeronca 0-58B · S/N 058B7692Cancelled Sep 16, 2019 · Revoked, pending cancellation · Built 1942 · Bean Perry A JrN1313LBellanca 14-13-3 · S/N 1622Cancelled Sep 6, 2019 · Revoked, canceled · Built 1949 · Hagstrom Robert PN8679CPiper PA-18-135 · S/N 18-2828Cancelled Sep 6, 2019 · Revoked, canceled · Built 1953 · Curry John HN39986Taylorcraft BC12-D · S/N 6645Cancelled May 8, 2019 · Registration expired, pending cancellation · Built 1945 · Metropolitan State University Of DenverN20959Waco ZKS-7 · S/N 5232Cancelled May 4, 2019 · Revoked, canceled · Built 1939 · Aero Enterprises IncN2517GCessna 182B · S/N 51817Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1959 · Davis RichardN588SMDJI S900 · S/N 0380030172Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Murry ShawnN112UXAscending Technologies ASCTEC FALCON 8 · S/N 03083Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Unmanned Experts IncN113UXTarsier Systems MOAC · S/N A-15-0001Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Unmanned Experts IncN8157PPiper PA-24-250 · S/N 24-3412Cancelled Mar 20, 2019 · Revoked, canceled · Built 1963 · Faurus Flying IncN580GCColorado Dept Transportation ST-800 · S/N ST-800-CDOT-001Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Colorado Department Of TransportationN619UMDJI INSPIRE 1 · S/N W13DCG29040244Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Murry ShawnN102UXAeryon Labs SKY RANGER · S/N ASM-000521-09 SR6021144Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Unmanned ExpertsN5292LAerostar International S-57A · S/N S57A-3227Cancelled Mar 11, 2019 · First renewal notice · Built 2001 · Re/Max Of Pennsylvania Ad Fund IncN3479LCessna U206B · S/N U206-0779Cancelled Mar 6, 2019 · Revoked, canceled · Built 1967 · Bahler Fredrick HN904CStinson 108-3 · S/N 108-3904Cancelled Feb 27, 2019 · Revoked, canceled · Built 1947 · Mason Jerry LN9324UCessna 150M · S/N 15078273Cancelled Feb 27, 2019 · Revoked, canceled · Built 1976 · Star Aviation CorpN3344XCessna 310L · S/N 310L-0194Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Built 1967 · Vaughters Jonathan JN8096KStinson 108-2 · S/N 108-3096Cancelled Feb 9, 2019 · Revoked, canceled · Built 1947 · Higgason Norma LN403RLDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF30016835Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Lopez Richard EN20851Firefly Balloons FIREFLY 9B-15 · S/N F9B-2017Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 2006 · Brown Roger TobinN109UXDJI PHANTOM 2 · S/N TRM1184Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Unmanned Experts IncN110UXDJI PHANTOM 2 · S/N TRM1185Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Unmanned Experts IncN106UXDJI S800 EVO · S/N TRM530Cancelled Dec 28, 2018 · Registration expired, pending cancellation · Unmanned Experts IncN64407Aerostar International RX-7 · S/N RX7-3046Cancelled Dec 26, 2018 · Registration expired, pending cancellation · Built 1986 · Nusz Hannah MN580ECColorado Dept Transportation QAV 500 · S/N QAV500-CDOT-002Cancelled Dec 12, 2018 · Registration expired, pending cancellation · Colorado Department Of TransportationN9712ACessna 170B · S/N 19173Cancelled Nov 17, 2018 · Revoked, canceled · Built 1949 · Mcbride John JN5073ZAerostar International S-57A · S/N S57A-3211Cancelled Sep 24, 2018 · Built 1999 · Re/Max Central Atlantic RegionN101UXAeryon Labs SKY RANGER · S/N SKU-100001-00 SR5022294Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Unmanned ExpertsN103UXAeryon Labs SKY RANGER · S/N SKU-110001-00 SR2020219Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Unmanned ExpertsN104UXAeryon Labs SKY RANGER · S/N SKU-100001-00 SR9026256Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Unmanned ExpertsN105UXAltavian NOVA F6500 · S/N 3011Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Unmanned Experts IncN71956Hawker Beechcraft 4000 · S/N RC-39Cancelled Aug 31, 2018 · Exported to Denmark · Built 2010 · Rocket Air LLCN489VCIsrael Aircraft Industries GULFSTREAM 200 · S/N 110Cancelled Aug 24, 2018 · Exported to Canada · Built 2005 · Jk489 LLCN99185Engineering & Research ERCOUPE 415-C · S/N 1808Cancelled Aug 23, 2018 · Revoked, canceled · Built 1946 · Cox Charles EN3133HEngineering & Research ERCOUPE 415-C · S/N 3758Cancelled Aug 2, 2018 · Revoked, canceled · Built 1946 · Shay Owen LN822LPLeptron Industrial Robotic Hel LEPTRON AVENGER B · S/N LEP822Cancelled Jun 26, 2018 · Registration pending, canceledN385KTPatterson Thomas H FREEDOM II · S/N 001Cancelled May 30, 2018 · Sale reported, canceledN98969Cessna 172P · S/N 17276389Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1985 · Coronado RicardoN77246Cessna 120 · S/N 11708Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Kebba Edward JN8515DPiper PA-22-160 · S/N 22-5742Cancelled Apr 6, 2018 · Revoked, canceled · Built 1957 · Donovan Timothy PN3530APiper PA-22-135 · S/N 22-1802Cancelled Apr 5, 2018 · Revoked, canceled · Built 1953 · Vest Sky Ranch AirportN53028Cameron Balloons US N-90 · S/N 6149Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1998 · Re/Max California & Hawaii Ad Fund IncN29695Taylorcraft BF · S/N 2539Cancelled Mar 23, 2018 · Revoked, canceled · Built 1941 · Beedy Charles LN9661KStinson 108-2 · S/N 108-2661Cancelled Mar 23, 2018 · Revoked, canceled · Built 1947 · Newton Michael RN3731APiper PA-22-135 · S/N 22-1974Cancelled Mar 16, 2018 · Revoked, canceled · Built 1953 · Hodapp Robert J
Back to Denver, CO