# Cancelled registrations: Franklin, IN

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

Cancelled aircraft registrations in Franklin, IN.

- [N601AG](https://openairdocs.org/deregistered/N601AG-2018-04-18.md): Gluff Alan D ZENAIR CH601HD · S/N 63365 · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2001 · Gluff Alan D
- [N83001](https://openairdocs.org/deregistered/N83001-2017-11-21.md): Aeronca 7AC · S/N 7AC1653 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Bickley Matthew
- [N43003](https://openairdocs.org/deregistered/N43003-2017-09-26.md): Piper PA-28-151 · S/N 28-7415407 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1974 · Siherb Aviation Corp
- [N9129F](https://openairdocs.org/deregistered/N9129F-2015-11-24.md): Brunnemer Harlan M HMB-2 · S/N 9-95-2 · Cancelled Nov 24, 2015 · Built 1995 · Brunnemer Harlan M
- [N4267D](https://openairdocs.org/deregistered/N4267D-2014-11-26.md): Hunter Lee HAWK CLASSIC · S/N 0100 · Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1982 · Foley James E
- [N3137J](https://openairdocs.org/deregistered/N3137J-2014-02-20.md): Brunnemer Harlan M HMB-1 · S/N 10-91-1 · Cancelled Feb 20, 2014 · Built 1992 · Brunnemer Harlan M
- [N4448A](https://openairdocs.org/deregistered/N4448A-2013-09-16.md): Piper PA-22-150 · S/N 22-3780 · Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1956 · Walker Michael E
- [N168JP](https://openairdocs.org/deregistered/N168JP-2013-08-23.md): Petry James XP503 · S/N 0291 · Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1987
- [N240N](https://openairdocs.org/deregistered/N240N-2012-10-05.md): Wood Steven O NIEUPORT 24 · S/N 1642 · Cancelled Oct 5, 2012 · Exported to New Zealand · Built 2011 · Wood Steven O
- [N3787J](https://openairdocs.org/deregistered/N3787J-1998-04-24.md): Cessna 150G · S/N 15065087 · Cancelled Apr 24, 1998 · Si Herb Aviation Corporation
- [N49MC](https://openairdocs.org/deregistered/N49MC-1985-07-15.md): Piper PA-31-350 · S/N 31-7652084 · Cancelled Jul 15, 1985 · Built 1976 · Franklin Flying Field Inc
- [N3642Z](https://openairdocs.org/deregistered/N3642Z-1974-04-05.md): Piper PA-22-150 · S/N 22-7537 · Cancelled Apr 5, 1974 · Brown Horace E
- [N5641](https://openairdocs.org/deregistered/N5641-1970-06-17.md): Benson Gyroplane B8M · S/N 101 · Cancelled Jun 17, 1970 · Donald M Prince
- [N9516W](https://openairdocs.org/deregistered/N9516W-1968-04-22.md): Piper PA-28-140 · S/N 28-22941 · Cancelled Apr 22, 1968 · Built 1968 · Franklin Flying Field Inc
- [N8410D](https://openairdocs.org/deregistered/N8410D-1965-05-21.md): Piper PA-22-160 · S/N 225663 · Cancelled May 21, 1965 · Franklin Flying Field Inc
- [N7724K](https://openairdocs.org/deregistered/N7724K-1957-03-05.md): Piper PA-20 · S/N 20-544 · Cancelled Mar 5, 1957 · Built 1950 · Mullendore Jack Etal
- [N3757M](https://openairdocs.org/deregistered/N3757M-1956-02-17.md): Piper PA-12 · S/N 12-2692 · Cancelled Feb 17, 1956 · Vincent B Fitzpatrick
- [N64167](https://openairdocs.org/deregistered/N64167-1956-02-16.md): Cessna T-50 · S/N 2850 · Cancelled Feb 16, 1956 · Rust William J

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

This list as a web page: https://openairdocs.org/faa-place/IN/Franklin/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.