OpenAirDocs.org
Brookville, OH

Cancelled registrations · 31

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

N16838Fairchild 24 C8E · S/N 2838Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1936 · Rasor William EN5538GHelio USAF U-10D · S/N 1270Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1967 · Mcgregor LarryN1597QCessna 150L · S/N 15072897Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1971 · Wolf Creek Aviation IncN7918GCessna 172L · S/N 17259618Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1970 · Schaney Michael WN2779YBeech 95 · S/N TD-152Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1958 · Schaney Michael WN1693GChampion 7GCBC · S/N 136Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1968 · Halbeisen John F DBAN85SGGreene Stephen A TIERRA II · S/N 00007Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1985 · Smith Richard EN8099ACessna 170B · S/N 20951Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1952 · Rasor William EN4840BCessna 152 · S/N 15283666Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Brookville AirparkN9132TBeech B23 · S/N M-1150Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1968N1690Douglas DC3 · S/N 2180Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1939N9304AWassink SPEZIO SPORT · S/N 170Cancelled Mar 13, 2012 · Triennial form not returned · Built 1978 · Kircher Robert WN8234SArnold Robert F BENSEN · S/N BA-1Cancelled Aug 15, 2007 · Exported to Canada · Toht Lee CN430SPiper PA-31-350 · S/N 31-8252048Cancelled Jul 2, 2003 · Exported to Canada · Harvey Gilman Aircraft Sales IncN777FMPiper PA-31-325 · S/N 317512015Cancelled Aug 26, 1998 · Exported to Panama · Gilman Aircraft IncN4094TPiper PA-31-310 · S/N 318112060Cancelled Oct 16, 1997 · Exported to Mexico · Gilman Aircraft IncN32630Piper PA-28-140 · S/N 287525092Cancelled Apr 25, 1997 · Exported to Canada · Gilman Aircraft IncN614CPiper PA-31 · S/N 31-7400992Cancelled Feb 5, 1997 · Exported to Canada · Gilman Aircraft IncN27359Piper PA-31-350 · S/N 317752185Cancelled Dec 20, 1996 · Exported to Canada · Gilman Aircraft IncN9709ZPiper PA-31-310 · S/N 317612045Cancelled Oct 24, 1996 · Exported to Mexico · Gilman Aircraft IncN103DEPiper PA-31-310 · S/N 31753Cancelled Oct 4, 1996 · Exported to Canada · Gilman Aircraft IncN425MBPiper PA-31-325 · S/N 318112051Cancelled Dec 16, 1994 · Exported to El Salvador · Harvey Gilman Aircraft Sales IncN153KACessna 150L · S/N 15073358Cancelled Aug 5, 1994 · D L S Aviation IncN715HRCessna 172H · S/N 17256104Cancelled Dec 12, 1990 · Brookville AirparkN700SKBeech J35 · S/N D-5615Cancelled Mar 31, 1983 · Exported to Canada · Harvey Gilman Aircraft Sales IncN32122Piper PA-28-151 · S/N 28-7515075Cancelled Mar 1, 1982 · Built 1974 · Brookville Air Park IncN846ZSmith Miniplane DSA-1 · S/N GN2Cancelled Oct 15, 1981 · Harvey Gilman Aircraft Sales IncN1320TBeech B95A · S/N TD-468Cancelled Jun 5, 1979 · Exported to Canada · Harvey Gilman Aircraft Sales IncN41500Piper PA-28R-200 · S/N 28R7435192Cancelled Oct 20, 1975 · Exported to Canada · Harvey Gilman Aircraft Sales IncN1881QCessna 177RG · S/N 177-RG-0281Cancelled Jun 26, 1973 · Built 1972 · Ishmael Metal Decorators IncN88483Piper J3C-65 · S/N 16107Cancelled Feb 15, 1968 · Exported to Canada · Sauerman Ralph I
Back to Brookville, OH