Skip to content

Cancelled registrations · 28

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

N914CWDehavilland DHC-2 · S/N 1423Cancelled Mar 24, 2025 · Exported to Canada · Built 1960 · Concrete Works Of Colorado Inc N800RTReference Technologies HUMMINGBIRD XRP · S/N RT-HB01-08-0001Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Reference Technologies Inc N801RTReference Technologies HUMMINGBIRD XRP · S/N RT-HB01-08-0002Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Reference Technologies Inc N45836Luscombe 8A · S/N 2363Cancelled Feb 21, 2020 · Revoked, canceled · Built 1946 · Gibson George Thomas N660AHDJI INSPIRE 1 PRO · S/N CJ 171400037214Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Aerial Uav Services N202RTReference Technologies HUMMINGBIRD · S/N RT-HB00-PT-0001Cancelled Dec 14, 2018 · Registration expired, pending cancellation · Reference Technologies Inc N68640Cessna 210A · S/N 21057627Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1960 · Aschoff Quentin N45ELLong Eugene C LANCAIR ES · S/N 051996-ECLCancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2004 · Long Eugene C N2929ZAerostar International RX-7 · S/N RX7-3025Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1986 · Global Environmental Engineering Consultants Inc N86CTSchempp-Hirth VENTUS 2CT · S/N 154Cancelled May 18, 2017 · Exported to Australia · Built 2005 · Caldwell Robert J N430WWinton John W THORPE T-18 · S/N 4321Cancelled May 15, 2017 · Registration expired, pending cancellation · Haugland Solveig L N3539XMooney M20F · S/N 670076Cancelled Feb 20, 2015 · Built 1966 · Hamre Austin N94VCSyracuse Vic/Syracuse Carol KITFOX SPEEDSTER · S/N ECZ 007Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1994 · Bresler Neil S N20256Schweizer 269C-1 · S/N 0099Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1999 · Cjk Inc N1043RRaven Industries RX6 · S/N RX6-164Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1975 · Bacon Dennis J N5592THughes 269A · S/N 64-0522Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Alexander Dawson Foundation N5592WHughes 269A · S/N 1140330Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Alexander Dawson Foundation N4069YBalloon Works FIREFLY 7 · S/N 10050Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1979 · Cave Daniel E N3010RRaven S55A · S/N S55A-437Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1978 · Bacon Dennis J N51689Bell 407 · S/N 53763Cancelled Oct 8, 2009 · Exported to Germany · Built 2007 · Garuda Aviation LLC N33KCBell Helicopter Textron Canada 407 · S/N 53462Cancelled Dec 6, 2007 · Exported to Ukraine · Built 2000 · Garuda Aviation LLC N5557CRaven Industries RX6 · S/N RX6-341Cancelled Nov 5, 2004 · Triennial form not returned · Hunter Stephen W N3032RPiper PA-28R-200 · S/N 28R-35657Cancelled Apr 9, 2003 · Triennial form not returned · Built 1969 · Lorenz Robert M N36642Balloon Works FIREFLY 7 · S/N F7-060Cancelled May 14, 2002 · Triennial form not returned · Built 1983 · Fenn Stephen J N8380FHughes Helicopters HUGHES 369D · S/N 380277DCancelled Sep 22, 1978 · Built 1978 · Demarest Charles H DBA N71680Luscombe 8A · S/N 3107Cancelled Aug 3, 1977 · Drake John E N819MHogue A H BIPLANE · S/N H-100Cancelled Apr 27, 1971 · Welch George W N3387WPiper PA-32-260 · S/N 32-245Cancelled Feb 2, 1971 · Built 1965 · D & S Enterprises

Back to Lafayette, CO