# Cancelled registrations: Martinsville, IN

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

Cancelled aircraft registrations in Martinsville, IN.

- [N99533](https://openairdocs.org/deregistered/N99533-2023-03-04.md): Engineering & Research ERCOUPE 415-C · S/N 2156 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Nashold Kenneth E
- [N765DB](https://openairdocs.org/deregistered/N765DB-2019-12-17.md): Lawrence A Chenaille CHENAILLE BOWERS FLY · S/N 1 · Cancelled Dec 17, 2019 · Second renewal notice · Chenaille Lawrence A
- [N8141N](https://openairdocs.org/deregistered/N8141N-2018-10-19.md): Donica William RANS S-9 · S/N 0998163 · Cancelled Oct 19, 2018 · Registration expired, pending cancellation · Built 1999 · Donica William M
- [N6457](https://openairdocs.org/deregistered/N6457-2018-03-15.md): Jungclaus Frederick Peter SE5A REPLICA · S/N 073081 · Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1988 · Jungclaus Frederick P
- [N1837Y](https://openairdocs.org/deregistered/N1837Y-2017-07-07.md): Beech 77 · S/N WA-309 · Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1982 · Boren Justin T
- [N807MT](https://openairdocs.org/deregistered/N807MT-2017-06-20.md): Glidden Robert E KR 2 · S/N BG 64 · Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Glidden Robert E
- [N1897P](https://openairdocs.org/deregistered/N1897P-2015-05-20.md): Piper PA-22-150 · S/N 22-2640 · Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1955 · Etter Robert D
- [N65706](https://openairdocs.org/deregistered/N65706-2015-05-04.md): Donica Jerry H AVID FLYER · S/N 685 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Donica Jerry D
- [N86BM](https://openairdocs.org/deregistered/N86BM-2014-02-24.md): Air Tractor AT-802A · S/N 802A-0285 · Cancelled Feb 24, 2014 · Built 2008 · Milhon Air Inc
- [N5346R](https://openairdocs.org/deregistered/N5346R-2013-08-19.md): Cessna 172F · S/N 17252875 · Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1965
- [N2152G](https://openairdocs.org/deregistered/N2152G-2013-07-01.md): Gillmore John BENSEN B8M · S/N 5159 · Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Gillmore John E
- [N4625E](https://openairdocs.org/deregistered/N4625E-2013-06-27.md): Donica Jerry D TIERRA · S/N 71150 · Cancelled Jun 27, 2013 · Sale reported, canceled
- [N6805K](https://openairdocs.org/deregistered/N6805K-2012-09-05.md): Piper PA-16 · S/N 16-635 · Cancelled Sep 5, 2012 · Revoked, canceled · Built 1949 · Knoy Leon
- [N6333M](https://openairdocs.org/deregistered/N6333M-2002-12-12.md): Cessna 152 · S/N 15284677 · Cancelled Dec 12, 2002 · Exported to Guatemala · Built 1980 · Manley Randy J
- [N10230](https://openairdocs.org/deregistered/N10230-1996-02-16.md): Air Tractor AT-502 · S/N 5020072 · Cancelled Feb 16, 1996 · Exported to Australia · Milhon Brent M
- [N59856](https://openairdocs.org/deregistered/N59856-1995-09-27.md): Piper PA-31-325 · S/N 317612066 · Cancelled Sep 27, 1995 · Exported to South Africa · Keystone Aviation
- [N72828](https://openairdocs.org/deregistered/N72828-1984-06-06.md): Cessna 120 · S/N 10014 · Cancelled Jun 6, 1984 · Revoked, pending cancellation · Built 1946 · Jungelaus Frederick P
- [N5708J](https://openairdocs.org/deregistered/N5708J-1973-06-25.md): Cessna P206E · S/N P20600608 · Cancelled Jun 25, 1973 · Full Gospel Fellowship Of Martinsville Indiana Inc
- [N5745A](https://openairdocs.org/deregistered/N5745A-1971-06-25.md): Cessna 172 · S/N 28345 · Cancelled Jun 25, 1971 · Mcdaniel Luford L
- [N83814](https://openairdocs.org/deregistered/N83814-1971-01-12.md): Aeronca 7AC · S/N 7AC-2494 · Cancelled Jan 12, 1971 · Joseph F Kersting

## 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 = 'IN' AND d.registrant_city = 'MARTINSVILLE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/IN/Martinsville/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, except the copies of manufacturers’ service documents, which belong to their rights holders.