Cancelled registrations · 17

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

N48387Grumman Acft ENG Cor-Schweizer G-164A · S/N 1626Cancelled Sep 24, 2025 · Exported to Uruguay · Built 1976 · Dickinson Harley Dean N335CTCessna 335 · S/N 335-0028Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Dingledine Trucking Co Inc N721FS3D Robotics IRIS+ · S/N IRS1502200047Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Ohio State University Extension N29ECQuad City Ultralight CHALLENGER II · S/N CH2-0698-1761Cancelled Mar 9, 2019 · Registration pending, canceled · Built 2006 N381ECDouglas A-26C · S/N 44-35948Cancelled May 31, 2017 · Registration expired, pending cancellation · Champaign Aviation Museum N5682FAlon A2 · S/N A-182Cancelled Nov 13, 2012 · Revoked, canceled · Built 1966 · Reece Robert Edward N68SSShaw Scott A ROTORWAY EXEC · S/N 001Cancelled Nov 7, 1997 · Triennial form not returned · Shaw Scott A N1124VCessna R172K · S/N R1722120Cancelled Feb 26, 1996 · Triennial form not returned · Shiffer Eric D N51241Cessna U206F · S/N U20601987Cancelled Aug 15, 1983 · Mad River Airport Inc N7073QCessna U206F · S/N U20603068Cancelled Dec 24, 1981 · Mad River Airport Inc N1085EAeronca 7AC · S/N 7AC-4638Cancelled Sep 1, 1977 · Built 1946 · Mcgowen Russell M N550ATrainum & Bensen B7MC BENSEN · S/N 60060Cancelled Oct 15, 1976 · Trainum W George Jr N72295Cessna 140 · S/N 9472Cancelled Apr 16, 1965 · Grimes Manufacturing Co N22601Taylorcraft BL · S/N 1248Cancelled Mar 10, 1955 · Built 1939 · Stickley Paul N29894Taylorcraft BC12-65 · S/N 2747Cancelled Oct 25, 1954 · Grimes Manufacturing Company N28456Luscombe 8C · S/N 1323Cancelled May 10, 1948 · Built 1940 · Grimes Manufacturing Co N32451Cessna C-165 · S/N 584Cancelled Oct 12, 1943 · Grimes Manufacturing Co

Back to Urbana, OH