Cancelled registrations · 20

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 = 'MI' AND d.registrant_city = 'ZEELAND' 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 = 'MI' AND d.registrant_city = 'ZEELAND'
  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 = 'MI' AND d.registrant_city = 'ZEELAND'
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.

N3261YOverbeek Paul LONG EZ · S/N P01Cancelled Dec 4, 2025 · Built 2005 · Overbeek Paul N49233Cessna 152 · S/N 15283441Cancelled Mar 26, 2024 · Exported to Poland · R&G Aircraft LLC N94KJByerley Kent D RV9A · S/N 90322Cancelled Oct 19, 2021 · Built 2006 · Deweese Dale N N5388NCessna 182Q · S/N 18267683Cancelled Aug 12, 2020 · Built 1980 · Paradise Bound Ministries Inc N25498Cessna 152 · S/N 15280696Cancelled Mar 8, 2019 · Exported to Canada · Built 1977 · R&G Aircraft LLC N86199Aeronca 11AC · S/N 11AC-632Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1946 · West Drenthe Inc N51BBBoeve MJ-7 GNATSUM · S/N 211-69Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1972 · De Gaynor Gregory S N22323Infinity Power Parachutes INFINITY 2001 · S/N IPP1-028Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Nykamp Eric S N2907ABuckeye DREAM MACHINE · S/N 3857Cancelled Sep 3, 2014 · Registration pending, canceled · Built 2007 N5961PPiper PA-24-250 · S/N 24-1052Cancelled Feb 14, 2008 · Triennial form not returned · Built 1959 · Koeman Brian L N79301Cessna 172K · S/N 17258030Cancelled Sep 29, 2004 · Sale reported · Built 1969 N4131GHughes TH-55A · S/N 67-15439Cancelled Sep 27, 2004 · Triennial form not returned · Zuverink Mike J N4101QZuverink Mike TWO-SEAT · S/N MZ-100Cancelled Sep 10, 2003 · Triennial form not returned · Zuverink Mike J N81339W R ROTORWAY EXEC 90 · S/N 1000ZCancelled Aug 25, 2003 · Triennial form not returned · Built 1999 · W R Aircraft N51689Enstrom Helicopter 280C · S/N 1115Cancelled Dec 31, 2002 · W R Aircraft LLC N84514Cessna 172K · S/N 17258506Cancelled Dec 15, 1995 · Triennial form not returned · Zeeland Aero Inc N2965HEngineering & Research ERCOUPE 415-C · S/N 3590Cancelled Jul 13, 1995 · Triennial form not returned · Gras William J N534AASheats James Dale FALCON-XP · S/N 600157Cancelled Aug 26, 1994 · Triennial form not returned · Thorpe R Wayne N3247HErcoupe 415-C · S/N 3872Cancelled Oct 8, 1982 · Built 1946 · Gras William J N93785Engineering & Research ERCOUPE 415-C · S/N 1108Cancelled Jun 13, 1969 · Exported to Canada · Built 1946 · Van Hoven Abram A

Back to Zeeland, MI