# Cancelled registrations: Middletown, NY

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

Cancelled aircraft registrations in Middletown, NY.

- [N972TC](https://openairdocs.org/deregistered/N972TC-2019-11-18.md): Thunder & Colt AX8 105SII · S/N 1492-US · Cancelled Nov 18, 2019 · Third renewal notice · Above The Clouds Inc
- [N10270](https://openairdocs.org/deregistered/N10270-2019-01-28.md): Baker Mcmillen CADET GLIDER · S/N 118 · Cancelled Jan 28, 2019 · Revoked, canceled · Built 1930 · Warner Douglas
- [N6343L](https://openairdocs.org/deregistered/N6343L-2018-12-13.md): American AA-1A · S/N AA1A-0343 · Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Built 1972 · Lee Christopher M
- [N5987L](https://openairdocs.org/deregistered/N5987L-2018-03-14.md): American AA-1 · S/N AA1-0287 · Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1969 · Lee Christopher M
- [N7193F](https://openairdocs.org/deregistered/N7193F-2014-10-23.md): Robinson Helicopter R44 · S/N 1173 · Cancelled Oct 23, 2014 · Built 2002 · Lakeside Helicopters LLC
- [N126L](https://openairdocs.org/deregistered/N126L-2013-07-09.md): Corben Baby Ace C-D · S/N F-1 · Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1960 · Lemieux Eugene R
- [N29805](https://openairdocs.org/deregistered/N29805-2012-08-30.md): Taylorcraft BL12-65 · S/N 2653 · Cancelled Aug 30, 2012 · Sale reported, canceled · Built 1941
- [N52793](https://openairdocs.org/deregistered/N52793-2011-03-28.md): Cessna 182P · S/N 18262849 · Cancelled Mar 28, 2011 · Exported to Canada · Built 1974 · Above The Clouds Inc
- [N6578](https://openairdocs.org/deregistered/N6578-2009-11-16.md): Grumman G-164A · S/N 717 · Cancelled Nov 16, 2009 · Triennial form not returned · Built 1970 · Air Spray Inc
- [N66347](https://openairdocs.org/deregistered/N66347-2006-02-14.md): Beech C23 · S/N M-2210 · Cancelled Feb 14, 2006 · Built 1979 · Hardy Michael H
- [N7432Y](https://openairdocs.org/deregistered/N7432Y-1995-09-23.md): Piper PA-30 · S/N 30493 · Cancelled Sep 23, 1995 · Triennial form not returned · Ami Aviation Inc
- [N6516F](https://openairdocs.org/deregistered/N6516F-1994-10-18.md): Cessna 150F · S/N 15063116 · Cancelled Oct 18, 1994 · Triennial form not returned · Candela Salvatore
- [N2915M](https://openairdocs.org/deregistered/N2915M-1974-08-07.md): Piper PA-12 · S/N 12-1335 · Cancelled Aug 7, 1974 · R Macvicar Aircraft Service
- [N24999](https://openairdocs.org/deregistered/N24999-1974-07-18.md): Piper J4A · S/N 4-787 · Cancelled Jul 18, 1974 · Skinner Carl
- [N61575](https://openairdocs.org/deregistered/N61575-1965-05-24.md): Fairchild M-62C(PT-23A) · S/N 2293-AE · Cancelled May 24, 1965 · Hudson Valley Aircraft Co Inc
- [N3291C](https://openairdocs.org/deregistered/N3291C-1963-09-16.md): Beech E35 · S/N D-3958 · Cancelled Sep 16, 1963 · Larsen Marven O
- [N33533](https://openairdocs.org/deregistered/N33533-1959-09-15.md): Piper J5C · S/N 5-1391 · Cancelled Sep 15, 1959 · Legrand Lord
- [N4529M](https://openairdocs.org/deregistered/N4529M-1949-06-16.md): Piper PA-11 · S/N 11-33 · Cancelled Jun 16, 1949 · Built 1947 · Roosa Elmber H
- [N4276M](https://openairdocs.org/deregistered/N4276M-1948-06-17.md): Piper PA-12 · S/N 12-3204 · Cancelled Jun 17, 1948 · Exported to China · Built 1947 · Hudson Valley Aircraft Co Inc
- [N7148](https://openairdocs.org/deregistered/N7148-1933-01-11.md): Standard J-1 · S/N 101311 SUB · Cancelled Jan 11, 1933 · Leach Fred E
- [N1014](https://openairdocs.org/deregistered/N1014-1930-04-04.md): Swallow SWALLOW · S/N 851 · Cancelled Apr 4, 1930 · Monroe Roy D
- [N3389](https://openairdocs.org/deregistered/N3389-1929-07-28.md): Swallow SWALLOW · S/N 873 · Cancelled Jul 28, 1929 · Smith Richard B

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

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