Skip to content

Cancelled registrations · 37

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

N19950DJI AGRAS T30 · S/N 3U5BJ6R0010066Cancelled Apr 30, 2025 · Puckrin Grant T N9366NPolaris Motors FLYINGINFLATABLEBOAT · S/N 0431093Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 2007 · Twardzik Richard F N778GWDJI INSPIRE 1 · S/N W13DCB25020453Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Walton Bradley O N778HWDJI INSPIRE 1 · S/N W13DCH19040705Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Walton Bradley O N7038MCessna 175 · S/N 55338Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1958 · Nishida Sun Ae N9876ASchleicher ASH25M · S/N 25254Cancelled Mar 21, 2016 · Built 2005 · Knauer Larry D N557XSCole Daniel SAFARI · S/N BB2082Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Gdm Co LLC N74SHRogers Kenneth R KITFOX I · S/N 188Cancelled Nov 1, 2013 · Registration expired, pending cancellation · Built 1994 · Rogers Kenneth R N701MBBennett Max V ZENAIR CH-701 · S/N 7-1289Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1993 · Bennett Max V N769MAMitsubishi MU-2B-26A · S/N 379SACancelled Jul 9, 2013 · Registration expired, pending cancellation · Baronco Aire Ltd N82DGGilkison Richard L QUICKIE Q-2 · S/N 2212Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1982 · Fresch John J N881JWPiper PA-28-180 · S/N 28-2773Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1965 · Windisch John R N7399KPiper PA-20 · S/N 20-307Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1950 · Mcguire Stephen E N5897ZPiper PA-22-108 · S/N 22-9762Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1964 · Mcguire Stephen E N12LSRepublic RC-3 · S/N 579Cancelled Dec 18, 2012 · Sale reported, pending cancellation · Built 1947 N60223Cessna T-50 · S/N 5671Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Horn Wayne R N440SPiper PA-31T2 · S/N 31T8166016Cancelled Jan 15, 2010 · Exported to Brazil · Built 1981 · Seneca Properties Co N5325GDehavilland DHC-3 · S/N 233Cancelled Jul 23, 1993 · Exported to Canada · Griffing Sandusky Airport Inc N2370WBeech A23-19 · S/N MB8Cancelled Dec 29, 1992 · Triennial form not returned · Neff Leroy N8516CPiper PA-22-135 · S/N 22-1227Cancelled Oct 15, 1981 · Patsch Gene W N2878NCessna 120 · S/N 13139Cancelled Apr 1, 1971 · Zoellner Ronald W N2964DCessna 170B · S/N 26907Cancelled May 21, 1965 · Travelair Taxi Inc N97668Universal Stinson 108 · S/N 108-668Cancelled May 21, 1965 · Griffingsandusky Airport Inc N9610Ford 4-AT-B · S/N 53Cancelled May 18, 1965 · Built 1928 · Travelair Taxi Inc N7650XCessna 172B · S/N 17248150Cancelled Apr 9, 1962 · Travelair Taxi Inc N3849NBeech 35 · S/N D-1087Cancelled Jul 3, 1957 · Lansem Tool & Die Inc N14787Fairchild 22 C7G · S/N 1803Cancelled Feb 17, 1956 · Built 1935 · Kosbab Clare N9747HConsolidated Vultee BT-13A · S/N 6500Cancelled Feb 14, 1956 · Price Kermit N51684Fairchild M-62A · S/N T42-23320Cancelled Oct 11, 1955 · Joiner Robert L Kenneth A Patsch N34525Aeronca 65-CA · S/N CA15151Cancelled Mar 4, 1955 · Built 1941 · Andres Francis R Et Al N6066KRepublic RC-3 · S/N 241Cancelled Nov 3, 1954 · Kiffer Hilaire N1758VCessna 140 · S/N 13943Cancelled May 13, 1953 · Sandusky Airport Inc N85098Aeronca 7AC · S/N 7AC-3828Cancelled May 8, 1951 · Sandusky Airport Incorporated N92616Piper J3C-65 · S/N 16987Cancelled Dec 14, 1950 · Sandusky Arpt Inc N47310Ryan Aeronautical ST3KR · S/N 1754Cancelled Oct 27, 1948 · Hinde William J N39265Taylorcraft BC12-D · S/N 6519Cancelled Sep 16, 1948 · Built 1946 · Hinde-Dietrick Aviation N6798Roos LINCOLN PAGE 1928 · S/N 235Cancelled Jul 8, 1934 · Rodney Howey

Back to Sandusky, OH