OpenAirDocs.org
Xenia, OH

Cancelled registrations · 52

Query with SQL
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 = 'XENIA'
  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.

N9362YHumphreys James M SORRELL SNS-7 · S/N 220Cancelled Apr 21, 2024 · Spurgeon RogerN3235RCessna 411 · S/N 411-0235Cancelled Oct 7, 2023 · Sale reported, canceledN900NGCessna 411A · S/N 411-0287Cancelled Oct 7, 2023 · Sale reported, canceledN310SJCessna 310B · S/N 35565Cancelled May 8, 2021 · Registration pending, canceledN81492Aeronca 7AC · S/N 7AC-110Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1945 · Stormont DylanN85LMCessna 310B · S/N 35771Cancelled Nov 27, 2020 · Sale reported, canceled · Built 1958N97085Stinson 108 · S/N 108-1085Cancelled Nov 13, 2020 · Sale reported, canceled · Built 1946N44606Piper PA-28-151 · S/N 28-7415682Cancelled Apr 22, 2020 · Macair Aviation LLCN574ABensen B-8M · S/N JG1Cancelled Dec 20, 2019 · Revoked, canceled · Built 1964 · Gray Jesse CN58621Cessna 182P · S/N 18262180Cancelled Dec 9, 2019 · Built 1973 · Macair Aviation LLCN2964LMooney M20C · S/N 670098Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Built 1967 · Rudhman Wylie E DBAN6935KPiper PA-20 · S/N 20-37Cancelled May 4, 2019 · Revoked, canceled · Built 1950 · Miller Arthur AllenN79534Cessna 172K · S/N 17258157Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1969 · Macair Aviation LLCN108EADingman Scott L EUROPA XS · S/N A226Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 2006 · Dingman Scott LN99876Engineering & Research ERCOUPE 415-C · S/N 2499Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Hofferbert Max MN9672HCessna T-50 · S/N 2443Cancelled Feb 13, 2017 · Revoked, canceled · Built 1942 · Dawson Wm CN7021HPiper J3C-65 · S/N 20266Cancelled Dec 2, 2014 · Revoked, canceled · Built 1946 · Art Cox StudiosN704ZGCessna 150M · S/N 15078998Cancelled Dec 2, 2014 · Revoked, canceled · Built 1976 · Wetrich Charles R DBAN2541FChampion 7GCAA · S/N 16Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1965 · Covert Chris EN99459Helton BENSEN B8M · S/N GH-1Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1977 · Wogoman Merle EN665MBeech E18S-9700 · S/N BA-421Cancelled May 6, 2013 · First renewal notice · Built 1959 · Skydive Greene Co IncN77BNNichols BD-5A · S/N 4556Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1975N302FMFouga CM 170R MAGISTER · S/N 354Cancelled Feb 19, 2013 · Sale reported, pending cancellation · Built 1962N18083Rearwin 9000-L · S/N 577DCancelled Jan 22, 2013 · Third renewal notice · Built 1937 · Olsen Walter J JrN614HAHispano Aviacion HA-200 SAETA · S/N E.14A-14Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1961N4362GMcculloch J-2 · S/N 072Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1972N582DGAlexander John D DOMINATOR GYROPLANE · S/N DG 1984 C1BCancelled Oct 5, 2011 · Built 2003 · Stinson Jeffrey SN92632Piper PA-32R-301 · S/N 3246018Cancelled Jun 18, 2010 · Exported to Australia · Built 1996 · Mohammad Dr JanN1057QGossett Daniel D FX SUPERLIGHT · S/N 1Cancelled Dec 8, 2004 · Triennial form not returned · Gossett Daniel DN4015LRaven Industries RALLY RX7 · S/N RX7277Cancelled Sep 22, 1994 · Triennial form not returned · Frederick W JeanneN777ASBoehmer SUPER ACRO SPORT · S/N 001Cancelled Feb 3, 1991 · Triennial form not returned · Boehmer Dennis AN8379BCessna 172 · S/N 36179Cancelled Nov 14, 1981 · Dorris Charles LN7218DPiper PA-22 · S/N 22-5043Cancelled Oct 19, 1981 · Nichols Daniel H Sr/Rademacher Rick/Smith Eddie CN87908Jackson Lewis A CONCEPT RA · S/N 9Cancelled Oct 10, 1980 · Jackson Lewis AN54919Stinson L-5 · S/N 76864Cancelled Jul 7, 1977 · Boehmer Dennis AN59JJJordan KR-2 · S/N 7828Cancelled May 31, 1977 · Jordan James JN8072Jackson Lewis A CONCEPT RA · S/N 8Cancelled May 27, 1976 · Jackson Lewis AN6355ACessna 182 · S/N 33155Cancelled May 26, 1976 · West LeeN9500SChampion 7ECA · S/N 7ECA239Cancelled Mar 16, 1976 · Exported to Canada · Zumrich AviationN33331Mleczko MINI-PLANE · S/N SS-1Cancelled Jun 11, 1975 · Built 1967 · Mlexzko William JN2699RPiper PA-28R-200 · S/N 28R-35249Cancelled May 7, 1975 · Virgallito P David DdsN96868Taylorcraft BC12-D · S/N 9168Cancelled Sep 24, 1973 · Hull Vernon WN4065EAeronca 11BC · S/N 11BC-153Cancelled Jul 13, 1970 · Exported to Canada · Mc Cormick Colin LN6763MUniversal Stinson 108-3 · S/N 108-4763Cancelled Jun 19, 1970 · Raymond J KoskiN661DBeech C35 · S/N D-2930Cancelled Jun 17, 1970 · Lehr Karl EN72242Cessna 140 · S/N 9415Cancelled Jun 5, 1965 · Hill Wayne TN22295Taylorcraft BL · S/N 1245Cancelled Nov 25, 1955 · Built 1939 · Benson William L/Ward John K/Donovan L Mcmahon/LogN69752Fairchild M-62C · S/N 135Cancelled Oct 14, 1955 · Richard Frank AntoineN84602Aeronca 7AC · S/N 7AC-3309Cancelled Oct 12, 1955 · Dawson W CN22271Taylorcraft BL · S/N 1220Cancelled Sep 13, 1954 · Built 1939 · Mitchell Jack & Heaton Roger D
Back to Xenia, OH