Skip to content

Cancelled registrations · 65

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

N351MMEurocopter AS 350 B3 · S/N 3853Cancelled Jun 27, 2025 · Exported to Canada · Built 2004 · Maggie'S Mixer LLC N421KTCessna 421B · S/N 421B0433Cancelled Oct 5, 2024 · Sale reported, canceled · Built 1973 N2702JSchleicher ASW-22 · S/N 22015Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Built 1982 · Jones David G Jr N308WKVickers SPITFIRE MARK IX · S/N MK9-TE308Cancelled Oct 4, 2019 · Exported to United Kingdom · Built 1944 · Greenwood William S N3147SCessna 182G · S/N 18255647Cancelled Mar 18, 2019 · Registration expired, pending cancellation · Built 1964 · De Lavaissiere Benoit N782LCCessna 421C · S/N 421C0486Cancelled May 31, 2018 · Sale reported, canceled N634APPiper PA-34-200T · S/N 34-7970188Cancelled Jan 16, 2018 · Exported to Colombia · Built 1979 · Aspen Higher Learning Flight Academy Inc N9550XCessna 210B · S/N 21057850Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1962 · Preferred Resort Properties N79208Cessna 172K · S/N 17257962Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Mahoney Philip S Jr N5821Schempp-Hirth NIMBUS-3DM · S/N 24Cancelled May 24, 2016 · Exported to Namibia · Built 1992 · Bitterwasser Colorado LLC N6160QCessna 320F · S/N 320F-0010Cancelled May 13, 2015 · Sale reported, canceled · Built 1967 N2GWCessna 320E · S/N 320E-0023Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1966 N4170QCessna 310N · S/N 310N-0070Cancelled Apr 18, 2014 · Sale reported · Built 1968 N71653Aerostar International S81A · S/N S81A-3005Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1996 · Unicorn Balloon Company Of Co Inc N3599TRaven Industries S-66A · S/N S66A-3031Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Unicorn Balloon Company N7117YBalloon Works FIREFLY 8-24 · S/N F8-124Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1988 · Adventrues Aloft II N142SWCessna 421A · S/N 421A0151Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1969 N910SCCessna 310P · S/N 310P0035Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1968 N2275FCessna 310L · S/N 310L-0075Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1967 N308RBBeech 95-B55 · S/N TC2283Cancelled Aug 5, 2013 · Sale reported · Built 1979 N74204Balloon Works FIREFLY 8B · S/N F8B-038Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Adventures Aloft II N7118BBalloon Works FIREFLY 8B · S/N F8B-132Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Adventures Aloft II N3970DDequine Louis E KASPERWING 180B · S/N 181Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Dequine Louis E N4081TRaven Industries S-66A · S/N S60A-251Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Reyna Xavier N N1800ZBeech A36TC · S/N EA-228Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1981 · Gibson Aviation LLC N5457GCessna 404 · S/N 404-0074Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1977 · Valley Harold E N52189Cessna 180J · S/N 18052547Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1975 · Baar Ronald N912WGMiller Rex A PULSAR XP · S/N 389Cancelled Nov 19, 2012 · Exported to Canada · Miller Rex A N580TCBeech 58P · S/N TJ-126Cancelled Sep 17, 2012 · Sale reported · Built 1977 N3262QCessna 401 · S/N 401-0062Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1967 N206LHCessna TU206G · S/N U20603540Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1976 N4726FCessna TP206B · S/N P206-0326Cancelled Aug 6, 2012 · Revoked, canceled · Built 1966 · Owen William H N444CDBeech C-50 · S/N CH-334Cancelled Jul 9, 2012 · Revoked, canceled · Built 1955 · Sabich Stefan DBA N9DJCessna 320C · S/N 320C0032Cancelled Sep 29, 2008 · Sale reported · Built 1964 N620JMGates Learjet 35A · S/N 207Cancelled Nov 26, 2007 · Triennial form not returned · Built 1978 · Aspen Base Operation Inc N4726CCessna T210N · S/N 21063603Cancelled Jul 12, 2007 · Triennial form not returned · Built 1979 · Mocklin Peter N5393UCessna TU206G · S/N U20605274Cancelled Aug 15, 2006 · Exported to Mexico · Built 1979 N403PBCessna 402B · S/N 402B-1217Cancelled Apr 14, 2006 · Exported to Mexico · Built 1976 N5446ACessna 310B · S/N 35646Cancelled Jul 25, 2005 · Built 1958 · Morehouse Craig M DBA N111KCCessna 310N · S/N 310N-0005Cancelled Apr 23, 2003 · Triennial form not returned · Built 1967 · Andrews Russell A N5638DMaule M-5-210TC · S/N 9003CCancelled Mar 30, 2001 · Hillman Tatnall L N886ATRaytheon C90A · S/N LJ-1485Cancelled Mar 15, 2001 · Exported to India · Nichols Albert Trustee N6125RCessna T210F · S/N T210-0025Cancelled Jun 23, 2000 · Triennial form not returned · Jallifier Jean Paul N281FHMooney M20M · S/N 27-0211Cancelled Apr 26, 2000 · Exported to Germany · Dittmar German N208DSBell 212 · S/N 30618Cancelled Dec 29, 1995 · Exported to Canada · Delta Bravo Sierra Corp N63016Cessna 172P · S/N 17275376Cancelled May 5, 1995 · Triennial form not returned · Aspen Base Operation Inc N3599WRaven Industries S-66A · S/N S66A3033Cancelled Feb 1, 1994 · Reyna Xavier N N3173KBeech B200 · S/N BB1304Cancelled Mar 19, 1993 · Exported to Canada · Continental Divide Company N3605TAerostar International S-77A · S/N S77A3011Cancelled Nov 5, 1992 · Triennial form not returned · Unicorn Balloon Company N8402HPiper PA-28R-201T · S/N 28R8131147Cancelled Jun 23, 1992 · Exported to Germany · Swiss Venus Inc

Back to Aspen, CO