# Cancelled registrations: Oneonta, NY

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

Cancelled aircraft registrations in Oneonta, NY.

- [N133H](https://openairdocs.org/deregistered/N133H-2023-02-06.md): Hughes Ronald A ROTORWAY EXEC 162-F · S/N 6727 · Cancelled Feb 6, 2023 · Registration expired, pending cancellation · Hughes Ronald A
- [N4386E](https://openairdocs.org/deregistered/N4386E-2018-12-06.md): Aeronca 11CC · S/N 11CC202 · Cancelled Dec 6, 2018 · Revoked, canceled · Built 1946 · Williams Thomas H
- [N72181](https://openairdocs.org/deregistered/N72181-2017-11-21.md): Cessna 120 · S/N 9350 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Helvey T C Dr
- [N5071X](https://openairdocs.org/deregistered/N5071X-2017-09-18.md): Champion 7KCAB · S/N 153 · Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1968 · Craigmyle Leslie K
- [N5923T](https://openairdocs.org/deregistered/N5923T-2015-05-13.md): Cessna 150D · S/N 15060623 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1964 · Craigmyle William R
- [N293HA](https://openairdocs.org/deregistered/N293HA-2014-12-22.md): Piper PA-28-235 · S/N 28-10876 · Cancelled Dec 22, 2014 · Registration pending, canceled · Built 1967
- [N7957U](https://openairdocs.org/deregistered/N7957U-2014-11-19.md): Cessna 172F · S/N 17251957 · Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · Hutman Norma L
- [N6391K](https://openairdocs.org/deregistered/N6391K-2013-04-29.md): Cessna 150M · S/N 15077680 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · Sidney Aviation Inc
- [N3719H](https://openairdocs.org/deregistered/N3719H-2002-07-31.md): Engineering & Research ERCOUPE 415-C · S/N 4344 · Cancelled Jul 31, 2002 · Triennial form not returned · Built 1946 · Craigmyle William R
- [N7371T](https://openairdocs.org/deregistered/N7371T-2002-02-07.md): Cessna 172A · S/N 46971 · Cancelled Feb 7, 2002 · Triennial form not returned · Built 1959 · Hazzard Robert E
- [N9375K](https://openairdocs.org/deregistered/N9375K-1996-12-18.md): Piper PA-28-181 · S/N 287690248 · Cancelled Dec 18, 1996 · Triennial form not returned · Anderson David L
- [N999CA](https://openairdocs.org/deregistered/N999CA-1990-12-20.md): Beech B-99 · S/N U150 · Cancelled Dec 20, 1990 · Exported to Canada · Catskill Airways Inc
- [N5128M](https://openairdocs.org/deregistered/N5128M-1982-08-30.md): Beech C23 · S/N M2029 · Cancelled Aug 30, 1982 · Catskill Airways Inc
- [N6628Z](https://openairdocs.org/deregistered/N6628Z-1981-10-14.md): Beech 77 · S/N WA-26 · Cancelled Oct 14, 1981 · Catskill Airways Inc
- [N17574](https://openairdocs.org/deregistered/N17574-1981-05-11.md): Beech 58 · S/N TH-800 · Cancelled May 11, 1981 · Built 1977 · Catskill Airways Inc
- [N6021K](https://openairdocs.org/deregistered/N6021K-1981-03-18.md): Beech 76 · S/N ME-169 · Cancelled Mar 18, 1981 · Exported to United Kingdom · Catskill Airways Inc
- [N3809N](https://openairdocs.org/deregistered/N3809N-1971-02-25.md): Beech 35 · S/N D-1037 · Cancelled Feb 25, 1971 · Exported to Canada · Wiltsie David G
- [N7587D](https://openairdocs.org/deregistered/N7587D-1961-12-29.md): Piper PA-18 · S/N 18-5883 · Cancelled Dec 29, 1961 · Exported to Sweden · Hyde Charles E
- [N4352H](https://openairdocs.org/deregistered/N4352H-1955-11-21.md): Piper PA-15 · S/N 15-136 · Cancelled Nov 21, 1955 · Oneonta Flying Service
- [N6279](https://openairdocs.org/deregistered/N6279-1931-11-20.md): Travel Air Mfg 2000 · S/N 718 · Cancelled Nov 20, 1931 · Oneonta Flying Club
- [N1921](https://openairdocs.org/deregistered/N1921-undated.md): Fairchild Airplane Mfg FC-2 · S/N 22 · Cancellation date not recorded · Daniel Franklin

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

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