Skip to content

Cancelled registrations · 60

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

N977RVDriver Larry VANS RV-7 · S/N 71409Cancelled Jan 30, 2025 · Built 2005 · Wells Stephanie A N5696SBeech A23-24 · S/N MA-98Cancelled Apr 11, 2023 · Schillinger Investments N9107WMaule MT-7-235 · S/N 18033CCancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1998 · Dbm Wireless Inc N931GBDJI PHANTOM 3 ADVANCED · S/N 03Z0300411Cancelled Oct 5, 2019 · Registration expired, pending cancellation · West John N103LPLeptron RDASS · S/N LEP432Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lt Enviromental Inc N7909BCessna 172 · S/N 29709Cancelled Aug 12, 2019 · Revoked, canceled · Built 1957 · Aviation Marketing N95852Taylorcraft BC12-D · S/N 8152Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Built 1946 · Shearer John W N30882Piper J5A · S/N 5-277Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1940 · Shearer John W N3877MPiper PA-12 · S/N 12-2788Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1949 · Shearer John W N22084Luscombe 8A · S/N 906Cancelled May 18, 2018 · Revoked, canceled · Built 1939 · Mcnitt Warren L N60848Naval Aircraft Factory N3N-3 · S/N 4358Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1941 · Shearer John W N9011JNational Ballooning 858 · S/N 142Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2002 · Dutrow James B N13NAHansen IB C CASSUTT III M · S/N NAC 001Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Hansen Ib C N65246Semco Balloon T · S/N SEM123Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1974 · Grinton Harry M N420FHHansen IB C CASSUTT III M · S/N NAC 2009-1Cancelled Jun 8, 2017 · Registration expired, pending cancellation · Built 2010 · Hansen Ib N49687Kulp Benjamin W TENNIE TWO · S/N 15-2747Cancelled May 31, 2017 · Registration expired, pending cancellation · Kulp Benjamin W N60RJJones Robert Y RJ06 · S/N 001Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 2001 · Jones Robert Y N924LBMclaughlin Ronald J RANS S-7 · S/N RJM-2Cancelled Nov 18, 2016 · Built 1996 · Mclaughlin Ronald J N5561KRaven S-50A · S/N S50A-281Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1979 · Century 21 Realty Services N1032RRaven Industries RX6 · S/N RX6-192Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1976 · Sheridan Dennis Lee N2791MRaven S-60A · S/N S60A-387Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1985 · Adventrues Aloft LLC N72706National Ballooning 858 · S/N 115Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1984 · Bradley Troy DBA N3936ZPiper PA-18-150 · S/N 18-7782Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1962 · Denver Soaring Council Inc N8268PPiper PA-18-150 · S/N 18-8037Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1963 · Denver Soaring Council Inc N5703ECessna 150 · S/N 17203Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1959 · Campbell Robert E N81SSDraves CASSUTT 3M · S/N WD-1Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1975 · Hansen Ib C N231FMooney M20K · S/N 25-0182Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1979 · Killion Terry L N79ASSzybowcowy Zaklad Doswiadczaln SZD-36-A · S/N W-779Cancelled May 31, 2013 · Sale reported, canceled · Built 1976 N5718XRaven Industries RALLY RX7 · S/N RX7-255Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1981 · Dolezal Kelly J N59WCassutt IIIM · S/N 300WCancelled Feb 26, 2013 · Revoked, canceled · Willard Edward J N3230VRobinson Helicopter R44 II · S/N 12054Cancelled Feb 21, 2013 · Exported to Russia · Built 2007 · Serenchenko Valeriy N1918RRaven S-60A · S/N S60A-128Cancelled Feb 1, 2013 · Registration expired, pending cancellation · Built 1978 · Wheeler Dennis J N3267RRaven S55A · S/N S55A-473Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Century 21 Realty Services Inc N7382TCessna 172A · S/N 46982Cancelled Sep 6, 2012 · Revoked, canceled · Built 1959 · Aces Eight Flg Club Inc N105APRaven S-60A · S/N S60A-160Cancelled Aug 23, 2012 · Registration pending, canceled · Built 1981 N81262Grumman American Avn. AA-5B · S/N AA5B0479Cancelled Jul 24, 2012 · Registration pending, canceled N172PNCessna 172N · S/N 17268450Cancelled Sep 18, 2007 · Exported to New Zealand · Built 1976 · Carel David T N3329SCessna 210J · S/N 21059129Cancelled Nov 1, 2006 · Triennial form not returned · Built 1969 · Eichman Barbara A N737SFCessna 172N · S/N 17269634Cancelled Apr 6, 2006 · Triennial form not returned · Built 1977 · R And R Aviation Inc N2783LRaven S-60A · S/N S60A-354Cancelled Aug 12, 2004 · Triennial form not returned · Built 1984 · Realty Services Inc N90MRMooney M20C · S/N 3025Cancelled Apr 26, 2000 · Airborne Computer Services Inc N8208HPiper PA-28-161 · S/N 28-8216162Cancelled Feb 14, 2000 · Triennial form not returned · Anderson Theodore K N5042ABellanca 8GCBC · S/N 29779Cancelled Aug 26, 1994 · Triennial form not returned · Wiser George R N5035KBellanca 8KCAB · S/N 46979Cancelled Mar 24, 1994 · Triennial form not returned · Wiser Beth A N53049Cessna 177RG · S/N 177RG1331Cancelled Mar 17, 1994 · Triennial form not returned · R & R Aviation Inc N8455KUniversal Stinson 108-1 · S/N 1081455Cancelled Feb 19, 1992 · Triennial form not returned · Kinney Don L N714YFCessna 152 · S/N 15279532Cancelled Feb 4, 1988 · R & R Aviation Inc N7413VMooney M20F · S/N 22-1206Cancelled Jun 28, 1984 · Peckham George W N20545Cessna 172M · S/N 17261382Cancelled Sep 28, 1982 · Built 1973 · Augustine Donald L N757CPCessna 152 · S/N 15279635Cancelled Dec 17, 1981 · Fedel Robert L

Back to Arvada, CO