# Cancelled registrations: Pottsville, PA

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

Cancelled aircraft registrations in Pottsville, PA.

- [N570MU](https://openairdocs.org/deregistered/N570MU-2019-09-06.md): DJI PHANTOM 3 PROFESSION · S/N P76DCJ13A26441 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Uranko Michael G Jr
- [N9903H](https://openairdocs.org/deregistered/N9903H-2018-08-23.md): Consolidated Vultee SNV-1 · S/N 10158 · Cancelled Aug 23, 2018 · Revoked, canceled · Built 1943 · Palles Gus
- [N8027E](https://openairdocs.org/deregistered/N8027E-2013-03-25.md): Brackbill Garth MITCHELL WING B-10 · S/N MW23015-79 · Cancelled Mar 25, 2013 · Sale reported, pending cancellation · Built 1979
- [N4031B](https://openairdocs.org/deregistered/N4031B-2012-10-03.md): Bellanca 17-30A · S/N 75-30754 · Cancelled Oct 3, 2012 · Sale reported, canceled · Built 1974
- [N1438X](https://openairdocs.org/deregistered/N1438X-2009-06-30.md): Piper PA-32-260 · S/N 32-7500039 · Cancelled Jun 30, 2009 · Registration revoked · Built 1975 · Dusselfink Inc
- [N108DR](https://openairdocs.org/deregistered/N108DR-1997-12-15.md): Piper PA-31-310 · S/N 317612025 · Cancelled Dec 15, 1997 · Exported to Canada · Richard B Ryon Insurance
- [N5104G](https://openairdocs.org/deregistered/N5104G-1997-11-25.md): Gardner Robert J BAKENG DUCE · S/N 573 · Cancelled Nov 25, 1997 · Triennial form not returned · Gardner Robert J
- [N7401F](https://openairdocs.org/deregistered/N7401F-1992-03-20.md): Hughes 269C · S/N 350406 · Cancelled Mar 20, 1992 · Exported to Spain · Mazzuca Enterprises
- [N9128](https://openairdocs.org/deregistered/N9128-1972-02-23-3.md): Poprivets C · S/N 3 · Cancelled Feb 23, 1972 · Yutz Joseph
- [N9128](https://openairdocs.org/deregistered/N9128-1972-02-23-4.md): Poprivets C · S/N 4 · Cancelled Feb 23, 1972 · Yutz Joseph
- [N69270](https://openairdocs.org/deregistered/N69270-1971-02-05.md): Yutz Parasol PARASOL · S/N 109 · Cancelled Feb 5, 1971 · Yutz Joseph
- [N46123](https://openairdocs.org/deregistered/N46123-1962-04-05.md): Aeronca 0-58B · S/N 58B-13133 · Cancelled Apr 5, 1962 · Built 1944 · Lowthert Melvin J
- [N1884](https://openairdocs.org/deregistered/N1884-1959-02-01.md): Beech D18S · S/N A-79 · Cancelled Feb 1, 1959 · Built 1946 · J H Zerbey Newspapers Inc
- [N86560](https://openairdocs.org/deregistered/N86560-1956-02-20.md): Fairchild M-62A · S/N T42-3654 · Cancelled Feb 20, 1956 · Palles Gus
- [N47571](https://openairdocs.org/deregistered/N47571-1951-09-24.md): Beech F17D · S/N 389 · Cancelled Sep 24, 1951 · Exported to Colombia · Yuengling Richard L
- [N16556](https://openairdocs.org/deregistered/N16556-1948-04-21.md): Aeronca C-3 · S/N A-697 · Cancelled Apr 21, 1948 · Weigand Robert Leslie
- [N8816H](https://openairdocs.org/deregistered/N8816H-1948-04-21.md): North American NAVION · S/N NAV-4-816 · Cancelled Apr 21, 1948 · Dunlap Betram
- [N22411](https://openairdocs.org/deregistered/N22411-1947-09-30.md): Howard DGA-15J · S/N 510 · Cancelled Sep 30, 1947 · Schoeneman Kenneth F
- [N14702](https://openairdocs.org/deregistered/N14702-1935-08-29.md): Snyder John B SNYDER-STOLP SA100 · S/N 2044 · Cancelled Aug 29, 1935 · Snyder Donald

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

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