# Cancelled registrations: Brookville, OH

A list on [Brookville, OH](https://openairdocs.org/faa-place/OH/Brookville.md).

Cancelled aircraft registrations in Brookville, OH.

- [N16838](https://openairdocs.org/deregistered/N16838-2022-12-31.md): Fairchild 24 C8E · S/N 2838 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1936 · Rasor William E
- [N5538G](https://openairdocs.org/deregistered/N5538G-2021-05-08.md): Helio USAF U-10D · S/N 1270 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1967 · Mcgregor Larry
- [N1597Q](https://openairdocs.org/deregistered/N1597Q-2018-01-03.md): Cessna 150L · S/N 15072897 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1971 · Wolf Creek Aviation Inc
- [N7918G](https://openairdocs.org/deregistered/N7918G-2017-09-26.md): Cessna 172L · S/N 17259618 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1970 · Schaney Michael W
- [N2779Y](https://openairdocs.org/deregistered/N2779Y-2014-09-25.md): Beech 95 · S/N TD-152 · Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1958 · Schaney Michael W
- [N1693G](https://openairdocs.org/deregistered/N1693G-2014-09-10.md): Champion 7GCBC · S/N 136 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1968 · Halbeisen John F DBA
- [N85SG](https://openairdocs.org/deregistered/N85SG-2013-06-14.md): Greene Stephen A TIERRA II · S/N 00007 · Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1985 · Smith Richard E
- [N8099A](https://openairdocs.org/deregistered/N8099A-2013-05-13.md): Cessna 170B · S/N 20951 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1952 · Rasor William E
- [N4840B](https://openairdocs.org/deregistered/N4840B-2012-12-13.md): Cessna 152 · S/N 15283666 · Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Brookville Airpark
- [N9132T](https://openairdocs.org/deregistered/N9132T-2012-11-19.md): Beech B23 · S/N M-1150 · Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1968
- [N1690](https://openairdocs.org/deregistered/N1690-2012-07-19.md): Douglas DC3 · S/N 2180 · Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1939
- [N9304A](https://openairdocs.org/deregistered/N9304A-2012-03-13.md): Wassink SPEZIO SPORT · S/N 170 · Cancelled Mar 13, 2012 · Triennial form not returned · Built 1978 · Kircher Robert W
- [N8234S](https://openairdocs.org/deregistered/N8234S-2007-08-15.md): Arnold Robert F BENSEN · S/N BA-1 · Cancelled Aug 15, 2007 · Exported to Canada · Toht Lee C
- [N430S](https://openairdocs.org/deregistered/N430S-2003-07-02.md): Piper PA-31-350 · S/N 31-8252048 · Cancelled Jul 2, 2003 · Exported to Canada · Harvey Gilman Aircraft Sales Inc
- [N777FM](https://openairdocs.org/deregistered/N777FM-1998-08-26.md): Piper PA-31-325 · S/N 317512015 · Cancelled Aug 26, 1998 · Exported to Panama · Gilman Aircraft Inc
- [N4094T](https://openairdocs.org/deregistered/N4094T-1997-10-16.md): Piper PA-31-310 · S/N 318112060 · Cancelled Oct 16, 1997 · Exported to Mexico · Gilman Aircraft Inc
- [N32630](https://openairdocs.org/deregistered/N32630-1997-04-25.md): Piper PA-28-140 · S/N 287525092 · Cancelled Apr 25, 1997 · Exported to Canada · Gilman Aircraft Inc
- [N614C](https://openairdocs.org/deregistered/N614C-1997-02-05.md): Piper PA-31 · S/N 31-7400992 · Cancelled Feb 5, 1997 · Exported to Canada · Gilman Aircraft Inc
- [N27359](https://openairdocs.org/deregistered/N27359-1996-12-20.md): Piper PA-31-350 · S/N 317752185 · Cancelled Dec 20, 1996 · Exported to Canada · Gilman Aircraft Inc
- [N9709Z](https://openairdocs.org/deregistered/N9709Z-1996-10-24.md): Piper PA-31-310 · S/N 317612045 · Cancelled Oct 24, 1996 · Exported to Mexico · Gilman Aircraft Inc
- [N103DE](https://openairdocs.org/deregistered/N103DE-1996-10-04.md): Piper PA-31-310 · S/N 31753 · Cancelled Oct 4, 1996 · Exported to Canada · Gilman Aircraft Inc
- [N425MB](https://openairdocs.org/deregistered/N425MB-1994-12-16.md): Piper PA-31-325 · S/N 318112051 · Cancelled Dec 16, 1994 · Exported to El Salvador · Harvey Gilman Aircraft Sales Inc
- [N153KA](https://openairdocs.org/deregistered/N153KA-1994-08-05.md): Cessna 150L · S/N 15073358 · Cancelled Aug 5, 1994 · D L S Aviation Inc
- [N715HR](https://openairdocs.org/deregistered/N715HR-1990-12-12.md): Cessna 172H · S/N 17256104 · Cancelled Dec 12, 1990 · Brookville Airpark
- [N700SK](https://openairdocs.org/deregistered/N700SK-1983-03-31.md): Beech J35 · S/N D-5615 · Cancelled Mar 31, 1983 · Exported to Canada · Harvey Gilman Aircraft Sales Inc
- [N32122](https://openairdocs.org/deregistered/N32122-1982-03-01.md): Piper PA-28-151 · S/N 28-7515075 · Cancelled Mar 1, 1982 · Built 1974 · Brookville Air Park Inc
- [N846Z](https://openairdocs.org/deregistered/N846Z-1981-10-15.md): Smith Miniplane DSA-1 · S/N GN2 · Cancelled Oct 15, 1981 · Harvey Gilman Aircraft Sales Inc
- [N1320T](https://openairdocs.org/deregistered/N1320T-1979-06-05.md): Beech B95A · S/N TD-468 · Cancelled Jun 5, 1979 · Exported to Canada · Harvey Gilman Aircraft Sales Inc
- [N41500](https://openairdocs.org/deregistered/N41500-1975-10-20.md): Piper PA-28R-200 · S/N 28R7435192 · Cancelled Oct 20, 1975 · Exported to Canada · Harvey Gilman Aircraft Sales Inc
- [N1881Q](https://openairdocs.org/deregistered/N1881Q-1973-06-26.md): Cessna 177RG · S/N 177-RG-0281 · Cancelled Jun 26, 1973 · Built 1972 · Ishmael Metal Decorators Inc
- [N88483](https://openairdocs.org/deregistered/N88483-1968-02-15.md): Piper J3C-65 · S/N 16107 · Cancelled Feb 15, 1968 · Exported to Canada · Sauerman Ralph I

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 = 'BROOKVILLE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/OH/Brookville/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.