Skip to content

Cancelled registrations · 67

Query with SQL

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 = 'GOLDEN' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'GOLDEN'
  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 = 'GOLDEN'
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.

N434ATAlexander Schleicher AS 34 ME · S/N 34005Cancelled Oct 6, 2026 · Exported to Austria · Built 2022 · Tuertscher Albert N761EACessna T210M · S/N 21062187Cancelled Jul 22, 2024 · Registration expired, pending cancellation · Built 1977 · Lowe George H III N6383ECessna 172 · S/N 46483Cancelled Jul 17, 2024 · Built 1959 · Doelger Parker J N280RBEnstrom 280FX · S/N 2129Cancelled Mar 14, 2023 · Exported to Peru · New Course Aviaton Company N119LPLeptron RDASS · S/N LEP412Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Golden Police Dept N481MHEnstrom Helicopter 480B · S/N 5133Cancelled May 25, 2021 · Exported to Poland · Built 2010 · New Course Aviation Co N3292YCessna 182 · S/N 18254292Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1962 · Burnell Roger J N36MRClem William B III DOMINATOR GYROCOPTER · S/N Y-001Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Clem William B III N203PGPowrachute PEGASUS · S/N A-203 PEGCancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2003 · Furnace Joel R N109FUClmax Engineering FALCON HOVER QUADCOP · S/N FH016Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Colorado Department Of Transportation N107FUClmax Engineering FALCON FIXED WING · S/N FF048Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Colorado Department Of Transportation N18427Stinson SR-8E · S/N 9796Cancelled May 18, 2018 · Revoked, canceled · Harrington Robert D N8246Erkel BENSEN B-8M · S/N 1886Cancelled Mar 16, 2018 · Revoked, canceled · Built 1970 · Ludwig Dean R N508TGSkykits SAVANNAH VGW · S/N 08-11-51-789Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 2010 · Garrett Tony N919JLLokey James SINGLE SEAT B-8 · S/N 940156Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2001 · Lokey James B N99LABeech 95-B55 (T42A) · S/N TC-849Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1965 · Golden Eagle Aircraft Services Inc N364MECessna 182S · S/N 18280853Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2000 · Cuntz William C Jr N4914MSaum Nick M HGB-14 · S/N 1Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Saum Nick M N7452NBeech 36 · S/N E-34Cancelled Feb 4, 2017 · Revoked, canceled · Built 1968 · Whistle L Paul N3543VCessna 140 · S/N 14815Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1948 · Morgan Henry W N2181QCessna 177RG · S/N 177RG0581Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1974 · Md Air Inc N1931DBeech C35 · S/N D-3204Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1952 · Michelsen James S N7280LRaven Industries RX6 · S/N RX6-120Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1974 · Saum Nicholas M N8078MBoeing 747SR-100 · S/N 21606Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Atlas Air Inc N63EUHuot Donald L EUROPA-MONO WHEEL · S/N A-24Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1996 N37133Ercoupe 415-C · S/N 100Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1941 · Nerad Stanley L N9066AAdams Balloon L D-S · S/N 035Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1978 N39JGGill John R MONI TRI-GEAR · S/N 259TCancelled Jun 18, 2013 · Registration expired, pending cancellation · Gill John R N1XRSmith AEROSTAR 601 · S/N 61-0208-093Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1975 · Golden Eagle Aircraft Services Inc N99619Bell TH-13T · S/N 67-15942Cancelled May 31, 2013 · Registration expired, pending cancellation · Century Helicopters Of Denver Inc N3726JBalloon Works FIREFLY 7 · S/N F7-105Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1983 · Baxter Harry L Jr N81931Bristol-Gary SCORPION TOO · S/N GB-1077Cancelled May 13, 2013 · Registration expired, pending cancellation · Bristol Gary Norman N6064XMooney M20A · S/N 1660Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1960 · Tomlinson W L N5357CCessna 140A · S/N 15501Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1950 · Livingood Neil E N5252MTaylorcraft BC12-D · S/N 10552Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1947 · Antique Airplane Association Of Colorado N4058TBalloon Works FIREFLY 7 · S/N 10119Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1980 · Nogues Elizabeth M N8555TCessna 182C · S/N 52455Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1959 N51499Raven S55A · S/N S55A-125Cancelled Sep 10, 2012 · Sale reported, pending cancellation · Built 1973 N46820Ralph KR-1 · S/N CRALPH-1Cancelled Aug 1, 2012 · Revoked, canceled · Ralph Charles F N181SDInman Gregory L DR 107 · S/N 98-00408Cancelled Sep 29, 2009 · Triennial form not returned · Built 2001 · Inman Gregory L N99227Ercoupe 415-C · S/N 1850Cancelled Sep 17, 2009 · Registration revoked · Built 1946 · Dague Lyndel Delbert N1796JPiper PA-28-140 · S/N 28-24222Cancelled Mar 9, 2009 · Triennial form not returned · Built 1968 · Horn Linda J N42KLSturgis John Michael STURGIS RV8 · S/N RV80449Cancelled Apr 4, 2008 · Exported to United Kingdom · Built 2002 · Wyant Robert L N24251Cessna T206H · S/N T20608593Cancelled Jun 26, 2007 · Exported to Mexico · Built 2006 · Charter Jet Solutions LLC N4885ACessna P210N · S/N P21000826Cancelled Oct 11, 2005 · Exported to Canada · Alpha Centurion LLC N21PMNord STAMPE SV4C · S/N 556Cancelled Oct 9, 2002 · Exported to United Kingdom · Meyers John T N539MCBoeing 747-271C · S/N 21965Cancelled Jan 22, 2001 · Exported to Israel · Atlas Air Inc N538MCBoeing 747-271C · S/N 21964Cancelled Nov 18, 1999 · Exported to Israel · Atlas Air Inc N8078HBoeing 747SR-100 · S/N 21922Cancelled Aug 2, 1999 · Atlas Air Inc N8078QBoeing 747SR-100 · S/N 21923Cancelled Aug 2, 1999 · Atlas Air Inc

Back to Golden, CO