# Cancelled registrations: Auburn, NY

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

Cancelled aircraft registrations in Auburn, NY.

- [N35391](https://openairdocs.org/deregistered/N35391-2020-06-26.md): Piper J5A · S/N 5641 · Cancelled Jun 26, 2020 · Revoked, canceled · Morgan Howard A
- [N2231P](https://openairdocs.org/deregistered/N2231P-2019-09-27.md): Piper PA-23-150 · S/N 23-840 · Cancelled Sep 27, 2019 · Revoked, canceled · Built 1956 · Wilmot David H
- [N420RX](https://openairdocs.org/deregistered/N420RX-2019-09-06.md): DJI PHANTOM 3 PROFESSION · S/N P76DCD13012940 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Post Todd R
- [N460NC](https://openairdocs.org/deregistered/N460NC-2018-01-05.md): Nicholas Coblio PA16 · S/N NC2011 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Coblio Nicholas A
- [N38683](https://openairdocs.org/deregistered/N38683-2017-11-18.md): Piper J3F-65 · S/N 7192 · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Lake Plains Aviation Svc
- [N3774U](https://openairdocs.org/deregistered/N3774U-2014-12-02.md): Balloon Works FIREFLY 7 · S/N F7-163 · Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1984 · Wolniak Bruce A
- [N2551W](https://openairdocs.org/deregistered/N2551W-2013-10-31.md): Balloon Works FIREFLY 8B-15 · S/N F8B-419 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Wolniak Bruce A
- [N880B](https://openairdocs.org/deregistered/N880B-2013-05-15.md): Piper PA-23 · S/N 23-504 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1956 · Caldwell Elwyn R
- [N13289](https://openairdocs.org/deregistered/N13289-2009-06-17.md): Consolidated 21-C · S/N 12 · Cancelled Jun 17, 2009 · Registration revoked · Built 1934 · Ohearn George T
- [N515JB](https://openairdocs.org/deregistered/N515JB-2000-06-05.md): Boccher John P51 MUSTANG · S/N 5683570 · Cancelled Jun 5, 2000 · Triennial form not returned · Ashby John L
- [N6487F](https://openairdocs.org/deregistered/N6487F-1976-07-26.md): Cessna 150F · S/N 15063087 · Cancelled Jul 26, 1976 · Exported to Canada · Peeters Johannes A
- [N60021](https://openairdocs.org/deregistered/N60021-1971-01-27.md): Boeing A75N1 · S/N 75-4053 · Cancelled Jan 27, 1971 · Hickey David E Andrew J Zeyak
- [N3333M](https://openairdocs.org/deregistered/N3333M-1970-06-04.md): Beech 65 · S/N LC-65 · Cancelled Jun 4, 1970 · Ontario Airways Inc
- [N1900C](https://openairdocs.org/deregistered/N1900C-1964-07-31.md): Cessna 170B · S/N 26045 · Cancelled Jul 31, 1964 · Exported to Canada · Built 1953 · Winters David E
- [N1244Z](https://openairdocs.org/deregistered/N1244Z-1963-02-13.md): Beech 95-55 · S/N TC-76 · Cancelled Feb 13, 1963 · Built 1961 · Ontario Airways Inc
- [N9523E](https://openairdocs.org/deregistered/N9523E-1955-10-17.md): Aeronca 11AC · S/N 11AC-1159 · Cancelled Oct 17, 1955 · G Ellsworth Case
- [N6310K](https://openairdocs.org/deregistered/N6310K-1955-10-04.md): Republic RC-3 · S/N 531 · Cancelled Oct 4, 1955 · Meaker Ellis R
- [N14108](https://openairdocs.org/deregistered/N14108-1955-03-04.md): Aeronca C-3 · S/N A-409 · Cancelled Mar 4, 1955 · Schreck Karl Joseph Jr
- [N6214K](https://openairdocs.org/deregistered/N6214K-1952-07-25.md): Republic RC-3 · S/N 417 · Cancelled Jul 25, 1952 · Exported to Canada · Carpenter Raymond
- [N11652](https://openairdocs.org/deregistered/N11652-1943-03-11.md): Fairchild 22 C7A · S/N 1002 · Cancelled Mar 11, 1943 · Built 1931 · Schafer Charles Jr
- [N321](https://openairdocs.org/deregistered/N321-1934-02-19.md): Allison ALCO · S/N 4 · Cancelled Feb 19, 1934 · Built 1927 · Post William H

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

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