Cancelled registrations · 23

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 = 'OH' AND d.registrant_city = 'WAYNESVILLE' 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 = 'OH' AND d.registrant_city = 'WAYNESVILLE'
  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 = 'OH' AND d.registrant_city = 'WAYNESVILLE'
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.

N264JMSchleicher Alexander ASH 26 E · S/N 26171Cancelled Jan 15, 2026 · Built 2000 · Kirkbride Larry A N292JSmith Miniplane DSA-1 · S/N 1Cancelled Dec 11, 2023 · Sale reported, canceled · Built 1970 N2602VCessna 170 · S/N 18240Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Stewart Stephen R N1858VCessna 140 · S/N 14037Cancelled Jul 12, 2018 · Sale reported, canceled · Built 1947 N58360Aeronca 0-58B · S/N 12403Cancelled May 30, 2018 · Sale reported, canceled N24PPPhillips Paul W SUPER KOALA · S/N 004Cancelled Sep 9, 2013 · Sale reported N3006ZPiper PA-22-150 · S/N 22-6957Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1959 · Doyle Michael E N987SCBeech UC-45J · S/N 23815Cancelled Jun 10, 2013 · Sale reported, pending cancellation · Built 1942 N8572BCessna 172 · S/N 36272Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1957 · Elam Susan D N125BWSchleicher ASH-25E · S/N 25129Cancelled Dec 8, 2003 · Exported to Germany · Big Wings Inc N5711Let L 33 SOLO · S/N 940217Cancelled Apr 10, 2001 · Exported to Canada · Soaring Society Of Dayton Inc N5777NPiper L-4A · S/N 8914Cancelled May 9, 1995 · Stewart Emerson C N65807Schweizer SGS 2-33A · S/N 297Cancelled Mar 15, 1995 · Triennial form not returned · Soaring Society Of Datyon Inc N2959HSchweizer SGS 2-33A · S/N 529Cancelled Dec 22, 1994 · Triennial form not returned · Soaring Society Of Dayton Inc N48407Aeronca 0-58B · S/N 058B-2262Cancelled Jul 6, 1984 · Grice Paul S N4937DCessna 182A · S/N 51037Cancelled Jun 9, 1975 · Stewart Cathy J N553HHAero Commander 500-B · S/N 500B92911Cancelled May 9, 1975 · Thill Charles D N98772Piper J3C-65 · S/N 19008Cancelled Mar 23, 1971 · Built 1946 · Emerson C Stewart N6749HPiper J3C-65 · S/N 19964Cancelled Mar 19, 1971 · Stewart Emerson C N44489Taylorcraft BC12-D · S/N 10289Cancelled Jun 29, 1970 · Edwin C Michener N33429Grumman J4F-2 · S/N 4-1373Cancelled Jan 29, 1960 · Campbell Lawrence Jr N46855Fairchild M-62A · S/N 9554 AECancelled Nov 18, 1955 · Schoonover Carl E N2079MPiper J3C-65 · S/N 20860Cancelled Jul 12, 1951 · Stewart Emerson C

Back to Waynesville, OH