# Cancelled registrations: Franklin, PA

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

Cancelled aircraft registrations in Franklin, PA.

- [N2285X](https://openairdocs.org/deregistered/N2285X-2020-05-01.md): Cessna 337 · S/N 337-0185 · Cancelled May 1, 2020 · Built 1965 · Story Billy G
- [N1415V](https://openairdocs.org/deregistered/N1415V-2018-08-28.md): Cessna 172M · S/N 17263560 · Cancelled Aug 28, 2018 · Exported to Philippines · Built 1974 · Delucia Dennis DBA
- [N5184R](https://openairdocs.org/deregistered/N5184R-2018-08-28.md): Cessna 172M · S/N 17263401 · Cancelled Aug 28, 2018 · Exported to Philippines · Built 1974 · Delucia Dennis DBA
- [N3209Z](https://openairdocs.org/deregistered/N3209Z-2018-03-01.md): Piper PA-22-150 · S/N 22-7149 · Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1959 · Sottiaux Arden B
- [N4271N](https://openairdocs.org/deregistered/N4271N-2018-01-19.md): Cessna 120 · S/N 13742 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1947 · Eakin Howard M
- [N22552](https://openairdocs.org/deregistered/N22552-2017-11-15.md): Cessna 172M · S/N 17264068 · Cancelled Nov 15, 2017 · Exported to Philippines · Built 1974 · Delucia Dennis DBA
- [N7427L](https://openairdocs.org/deregistered/N7427L-2017-05-15.md): Lacy Oliver L STEEN SKYBOLT · S/N 1-4922 · Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1990 · Smith Jack L
- [N3600Q](https://openairdocs.org/deregistered/N3600Q-2015-05-14.md): Beech A23A · S/N M-1032 · Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 1967 · Baldwin Russell E
- [N39557](https://openairdocs.org/deregistered/N39557-2015-05-08.md): Aeronca 7AC · S/N 7AC-1 · Cancelled May 8, 2015 · Revoked, pending cancellation · Built 1944 · Franklin Aero Club Inc
- [N5164K](https://openairdocs.org/deregistered/N5164K-2013-04-01.md): Ryan NAVION A · S/N NAV-4-2064 · Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1950 · Fennell Blaine K
- [N4942T](https://openairdocs.org/deregistered/N4942T-2012-09-18.md): Piper PA-28-140 · S/N 28-7225284 · Cancelled Sep 18, 2012 · Revoked, canceled · Built 1972 · Horizon Aviation
- [N2299W](https://openairdocs.org/deregistered/N2299W-2006-02-23.md): Raytheon B200 · S/N BB-1626 · Cancelled Feb 23, 2006 · Exported to Brazil · Built 1998 · Penn-Aire Aviation Inc
- [N8041R](https://openairdocs.org/deregistered/N8041R-1995-06-08.md): Beech A24R · S/N MC36 · Cancelled Jun 8, 1995 · Houser Elizabeth A
- [N163JM](https://openairdocs.org/deregistered/N163JM-1992-09-17.md): Mitchell John C LITTLE TOOT · S/N 01 · Cancelled Sep 17, 1992 · Triennial form not returned · Mitchell John C
- [N6154](https://openairdocs.org/deregistered/N6154-1991-09-10.md): Tapaszy ROTORCRAFT · S/N 1 · Cancelled Sep 10, 1991 · Triennial form not returned · Hajduk Mario C
- [N7957M](https://openairdocs.org/deregistered/N7957M-1972-01-05.md): Beech D95A · S/N TD-668 · Cancelled Jan 5, 1972 · Exported to Canada · Built 1966 · Penn Aire Aviation Inc
- [N8179Y](https://openairdocs.org/deregistered/N8179Y-1970-10-26.md): Piper PA-30 · S/N 30-1294 · Cancelled Oct 26, 1970 · Exported to Canada · Built 1966 · Penn-Aire Aviation Inc
- [N99262](https://openairdocs.org/deregistered/N99262-1961-04-21.md): Engineering & Research 415-C · S/N 1885 · Cancelled Apr 21, 1961 · Exported to Canada · Hoovler Harvey H
- [N27964](https://openairdocs.org/deregistered/N27964-1956-02-23.md): Piper J3F-60 · S/N 4475 · Cancelled Feb 23, 1956 · Porter Norman
- [N46225](https://openairdocs.org/deregistered/N46225-1955-10-10.md): Taylorcraft DCO-65 · S/N L4852 · Cancelled Oct 10, 1955 · Firster Merle G
- [N1028K](https://openairdocs.org/deregistered/N1028K-1955-02-04.md): Luscombe 8A · S/N 3755 · Cancelled Feb 4, 1955 · Ramsey James S
- [N15734](https://openairdocs.org/deregistered/N15734-1951-04-25.md): Aeronca C-3 · S/N A-627 · Cancelled Apr 25, 1951 · Built 1936 · Bopp Charles W
- [N54486](https://openairdocs.org/deregistered/N54486-1948-12-09.md): Cessna T-50 · S/N 5966 · Cancelled Dec 9, 1948 · Joy Manufacturing Co
- [N22940](https://openairdocs.org/deregistered/N22940-1947-09-29.md): Piper J3L · S/N 2843 · Cancelled Sep 29, 1947 · Roy Bevington
- [N10497](https://openairdocs.org/deregistered/N10497-1935-03-01.md): Franklin Mfg B-HUMMER · S/N 9 · Cancelled Mar 1, 1935 · Franklin Aircraft Corp
- [N13122](https://openairdocs.org/deregistered/N13122-1933-01-01.md): Bauer J P/Bauer M A WAG-A-BOND TRAVELER · S/N 1 · Cancelled Jan 1, 1933 · Bauer Joseph P

## 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 = 'PA' 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/PA/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.