# Cancelled registrations: Newburgh, NY

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

Cancelled aircraft registrations in Newburgh, NY.

- [N7381Y](https://openairdocs.org/deregistered/N7381Y-2020-05-29.md): Piper PA-30 · S/N 30-435 · Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1964 · Waldenmaier Herb
- [N137AW](https://openairdocs.org/deregistered/N137AW-2019-01-22.md): DJI INSPIRE 1 · S/N W13DCB14020453 · Cancelled Jan 22, 2019 · Registration expired, pending cancellation · First Flight Photography LLC
- [N137PJ](https://openairdocs.org/deregistered/N137PJ-2018-12-14.md): DJI INSPIRE 1 · S/N W13DCB12020252 · Cancelled Dec 14, 2018 · Registration expired, pending cancellation · First Flight Photography LLC
- [N98147](https://openairdocs.org/deregistered/N98147-2017-11-21.md): Piper J3C-65 · S/N 18306 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Rockwell Edward M
- [N7381M](https://openairdocs.org/deregistered/N7381M-2013-09-13.md): Cessna 175 · S/N 55681 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1958 · Hallett Terry
- [N866VF](https://openairdocs.org/deregistered/N866VF-2013-03-25.md): Cessna 150D · S/N 15060593 · Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1964
- [N4204J](https://openairdocs.org/deregistered/N4204J-2013-03-11.md): Piper PA-28-140 · S/N 28-22549 · Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1966 · Curtis Donald R
- [N7WP](https://openairdocs.org/deregistered/N7WP-2012-09-06.md): Cessna R172E · S/N R1720022 · Cancelled Sep 6, 2012 · Revoked, canceled · Built 1966 · United States Army Systems Command Owner
- [N58299](https://openairdocs.org/deregistered/N58299-2012-08-27.md): Fairchild M-62A · S/N FH819 · Cancelled Aug 27, 2012 · Revoked, canceled · Built 1942 · Clark Walter
- [N3853K](https://openairdocs.org/deregistered/N3853K-2011-01-31.md): Temco GC-1B · S/N 3553 · Cancelled Jan 31, 2011 · Revoked, canceled · Built 1948 · Schwartzman Irving
- [N52TW](https://openairdocs.org/deregistered/N52TW-2008-03-19.md): Aviat PITTS S-2B · S/N 5323 · Cancelled Mar 19, 2008 · Exported to Iceland · Turn-N-Slip Inc
- [N4752Z](https://openairdocs.org/deregistered/N4752Z-2004-08-18.md): Piper PA-22-108 · S/N 22-8308 · Cancelled Aug 18, 2004 · Triennial form not returned · Built 1961 · Phillips Lewis A
- [N9RA](https://openairdocs.org/deregistered/N9RA-1980-05-02.md): S.O.C.A.T.A. RALLYE 150 ST · S/N 2932 · Cancelled May 2, 1980
- [N65527](https://openairdocs.org/deregistered/N65527-1980-04-23.md): Sikorsky S-58J · S/N 58-749 · Cancelled Apr 23, 1980 · Exported to Canada · Nationwide Fabricators Inc
- [N1225D](https://openairdocs.org/deregistered/N1225D-1975-12-18.md): Cessna 170A · S/N 20115 · Cancelled Dec 18, 1975 · Exported to Canada · Ghislain G Lalonde
- [N42846](https://openairdocs.org/deregistered/N42846-1975-11-19.md): Piper J3C-65 · S/N 15166 · Cancelled Nov 19, 1975 · Exported to Canada · Built 1945 · Koriba Inc
- [N2HK](https://openairdocs.org/deregistered/N2HK-1975-05-07.md): Beech B24R · S/N MC-231 · Cancelled May 7, 1975 · Harold L Kahn Inc
- [N6432A](https://openairdocs.org/deregistered/N6432A-1974-09-06.md): Cessna 182 · S/N 33232 · Cancelled Sep 6, 1974 · Schneider Harvey L
- [N7130](https://openairdocs.org/deregistered/N7130-1974-08-09.md): Van Natta Craig B-8M · S/N CVN-1-68 · Cancelled Aug 9, 1974 · Weber Edward
- [N5259H](https://openairdocs.org/deregistered/N5259H-1972-02-03.md): Piper PA-16 · S/N 1663 · Cancelled Feb 3, 1972 · Hilderbrant John B Jr
- [N3506R](https://openairdocs.org/deregistered/N3506R-1972-01-13.md): Beech A23 · S/N M-661 · Cancelled Jan 13, 1972 · Dombroski Waddy
- [N3116N](https://openairdocs.org/deregistered/N3116N-1957-06-17.md): Cessna 120 · S/N 13374 · Cancelled Jun 17, 1957 · Smith James A Jr
- [N23514](https://openairdocs.org/deregistered/N23514-1951-01-24.md): Aeronca 65-C · S/N C-4649 · Cancelled Jan 24, 1951 · Built 1939 · Doughty Andrew
- [N22325](https://openairdocs.org/deregistered/N22325-1950-01-23.md): Aeronca 65-C · S/N 3279 · Cancelled Jan 23, 1950 · Barkley Donald S
- [N376K](https://openairdocs.org/deregistered/N376K-1949-03-08.md): Parks P-1 · S/N 197-14 · Cancelled Mar 8, 1949 · Built 1929 · Zalesak John Joseph
- [N70993](https://openairdocs.org/deregistered/N70993-1949-02-04.md): Piper J3C-65 · S/N 18158 · Cancelled Feb 4, 1949 · Edward M Rockwell
- [N16216](https://openairdocs.org/deregistered/N16216-1943-05-07.md): Waco YKS-6 · S/N 4419 · Cancelled May 7, 1943 · Built 1936 · Muthig Allen
- [N15108](https://openairdocs.org/deregistered/N15108-1939-11-08.md): Stinson A · S/N 9108 · Cancelled Nov 8, 1939 · Built 1935 · Gordon Robert

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

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