# Cancelled registrations: Media, PA

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

Cancelled aircraft registrations in Media, PA.

- [N20VA](https://openairdocs.org/deregistered/N20VA-2022-09-03.md): Raytheon 390 · S/N RB-31 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2002 · Main Line Jet LLC
- [N3993S](https://openairdocs.org/deregistered/N3993S-2019-09-06.md): Cessna 172E · S/N 17251193 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1964 · Black William A
- [N10884](https://openairdocs.org/deregistered/N10884-2013-12-10.md): Cessna 150L · S/N 15075106 · Cancelled Dec 10, 2013 · Exported to Chile · Built 1973 · Grill Ivan
- [N3AY](https://openairdocs.org/deregistered/N3AY-2013-07-02.md): Fairbanks WESTERN 0-65 · S/N 003 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1986 · Hohnke August C
- [N9519L](https://openairdocs.org/deregistered/N9519L-2013-05-23.md): Grumman American Avn. AA-5 · S/N AA5-0619 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1974 · Sweeney Charles J Jr
- [N3170A](https://openairdocs.org/deregistered/N3170A-2013-05-21.md): Balloon Works FIREFLY 9 · S/N F9-062 · Cancelled May 21, 2013 · Registration expired, pending cancellation · Built 1995 · Magical Mystery Flights Inc
- [N1913](https://openairdocs.org/deregistered/N1913-2013-04-11.md): Piper PA-22-135 · S/N 22-1633 · Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1953 · Mitchell Jr Benjamin G
- [N426RD](https://openairdocs.org/deregistered/N426RD-2012-11-21.md): Enstrom F-28A · S/N 74 · Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1972 · Fetsko Aviation Sales & Trans Inc
- [N181](https://openairdocs.org/deregistered/N181-2012-08-13.md): Dewey MIDGET MUSTANG · S/N 493 · Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1973 · Dewey Richard D
- [N1422Q](https://openairdocs.org/deregistered/N1422Q-2012-06-21.md): Cessna 150L · S/N 15072722 · Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1971
- [N2575N](https://openairdocs.org/deregistered/N2575N-2006-07-19.md): Balloon Works FIREFLY 8 · S/N F8-398 · Cancelled Jul 19, 2006 · Triennial form not returned · Built 1993 · Magical Mystery Flights Inc
- [N58ND](https://openairdocs.org/deregistered/N58ND-2006-06-22.md): Cessna 152 · S/N 15285975 · Cancelled Jun 22, 2006 · Exported to Canada · Behrle Ted H
- [N9035P](https://openairdocs.org/deregistered/N9035P-1996-11-06.md): Balloon Works FIREFLY 9 · S/N F9032 · Cancelled Nov 6, 1996 · Triennial form not returned · Magical Mysteryflights Inc
- [N14530](https://openairdocs.org/deregistered/N14530-1992-06-24.md): Fairbanks HOMEBUILT-02 · S/N 0076 · Cancelled Jun 24, 1992 · Triennial form not returned · Hohnke A C
- [N4553D](https://openairdocs.org/deregistered/N4553D-1982-05-26.md): Gulfstream American AA-5A · S/N AA5B1204 · Cancelled May 26, 1982 · Sale reported
- [N73193](https://openairdocs.org/deregistered/N73193-1976-01-04.md): Cessna 172M · S/N 17267320 · Cancelled Jan 4, 1976 · Exported to Canada · Fetsko Aviation Sales & Transportation Inc
- [N11483](https://openairdocs.org/deregistered/N11483-1975-10-16.md): Cessna 150L · S/N 15075452 · Cancelled Oct 16, 1975 · Exported to Canada · Built 1973 · Fetsko Aviation Sales & Transportation Inc
- [N30212](https://openairdocs.org/deregistered/N30212-1972-01-25.md): Cessna 177 · S/N 17701123 · Cancelled Jan 25, 1972 · Built 1968 · Fetsko Aviation Sales & Transportation Inc
- [N5406H](https://openairdocs.org/deregistered/N5406H-1963-02-12.md): Piper PA-14 · S/N 14-520 · Cancelled Feb 12, 1963 · Door To Life Gospel Ministries
- [N3071V](https://openairdocs.org/deregistered/N3071V-1956-10-03.md): Beech 35 · S/N D485 · Cancelled Oct 3, 1956 · Pierson P John

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

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