# Cancelled registrations: Camp Hill, PA

A list on [Camp Hill, PA](https://openairdocs.org/faa-place/PA/Camp%20Hill.md).

Cancelled aircraft registrations in Camp Hill, PA.

- [N1493A](https://openairdocs.org/deregistered/N1493A-2019-05-06.md): Piper PA-22 · S/N 22-401 · Cancelled May 6, 2019 · Revoked, canceled · Built 1952 · Grossman Harry L Co Ow
- [N589SS](https://openairdocs.org/deregistered/N589SS-2019-01-15.md): DJI PHANTOM 3 PROFESSION · S/N CD242220288938 · Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Triscari Productions Inc
- [N834W](https://openairdocs.org/deregistered/N834W-2018-03-30.md): Treadwell Walter L JENNY · S/N 3 · Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1990 · Storer Academy Of Aviation
- [N4425W](https://openairdocs.org/deregistered/N4425W-2018-02-28.md): Siler Ronald E ULTRASTAR · S/N 12748 · Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1991 · Siler Ronald E
- [N469LK](https://openairdocs.org/deregistered/N469LK-2017-11-20.md): Piper PA-23-250 · S/N 27-7405306 · Cancelled Nov 20, 2017 · Exported to Canada · Built 1974 · 205 Creek LLC
- [N335RM](https://openairdocs.org/deregistered/N335RM-2014-11-26.md): Mcfarland Robert F QUICKIE 2 · S/N 2061 · Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1982 · Mcfarland Robert F
- [N336RM](https://openairdocs.org/deregistered/N336RM-2013-08-13.md): Mcfarland Robert F QUICKIE · S/N 23 · Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Mcfarland Robert F
- [N5138W](https://openairdocs.org/deregistered/N5138W-2013-03-25.md): Piper PA-28-160 · S/N 28-168 · Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1961 · Chm Consulting Inc
- [N78P](https://openairdocs.org/deregistered/N78P-2005-03-21.md): Schleicher ASW-20C · S/N 20834 · Cancelled Mar 21, 2005 · Exported to Australia · Gere Jonathan
- [N73TE](https://openairdocs.org/deregistered/N73TE-1984-08-07.md): Cessna T210M · S/N 210-62738 · Cancelled Aug 7, 1984 · Hill Bertram C
- [N335RM](https://openairdocs.org/deregistered/N335RM-1982-05-19.md): Bede BD-5 · S/N 1586 · Cancelled May 19, 1982 · Mcfarland Robert R
- [N74668](https://openairdocs.org/deregistered/N74668-1954-09-07.md): Curtiss Wright C-46 · S/N 33481 · Cancelled Sep 7, 1954 · Exported to Brazil · L B S Aircraft Corp
- [N9983F](https://openairdocs.org/deregistered/N9983F-1952-05-08.md): Douglas C-47 · S/N 19218 · Cancelled May 8, 1952 · Exported to Chile · New York Car Wheel Co
- [N9986F](https://openairdocs.org/deregistered/N9986F-1952-05-05.md): Douglas C-47A · S/N 13727 · Cancelled May 5, 1952 · Exported to Chile · New York Car Wheel Co
- [N3927C](https://openairdocs.org/deregistered/N3927C-1952-03-07.md): Lockheed 18-56 · S/N 2442 · Cancelled Mar 7, 1952 · New York Car Wheel Co-Aircraft Division
- [N50003](https://openairdocs.org/deregistered/N50003-1951-06-08.md): Curtiss Wright C-46D · S/N 32836 · Cancelled Jun 8, 1951 · New York Car Wheel Company
- [N23474](https://openairdocs.org/deregistered/N23474-1949-05-31.md): Piper J-3 · S/N 3209 · Cancelled May 31, 1949 · Mcfarland Robert F

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

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