# Cancelled registrations: New Rochelle, NY

A list on [New Rochelle, NY](https://openairdocs.org/faa-place/NY/New%20Rochelle.md).

Cancelled aircraft registrations in New Rochelle, NY.

- [N33125](https://openairdocs.org/deregistered/N33125-2023-02-18.md): Piper PA-32-300 · S/N 32-7540088 · Cancelled Feb 18, 2023 · Built 1975 · Westchester Co Pol Pilots Assoc Inc
- [N1011C](https://openairdocs.org/deregistered/N1011C-2019-05-04.md): Convair 240-0 · S/N 120 · Cancelled May 4, 2019 · Revoked, canceled · Built 1948 · Faness Leasing Corporation
- [N87300](https://openairdocs.org/deregistered/N87300-2018-05-21.md): Engineering & Research ERCOUPE 415-C · S/N 473 · Cancelled May 21, 2018 · Revoked, canceled · Built 1946 · Stockbridge William D
- [N98878](https://openairdocs.org/deregistered/N98878-2017-11-21.md): Piper J3C-65 · S/N 19063 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Columbo Joseph
- [N29771](https://openairdocs.org/deregistered/N29771-2012-09-24.md): Megaro M-100 · S/N 001 · Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1973 · Megaro Anne A
- [N986T](https://openairdocs.org/deregistered/N986T-1993-04-28.md): Beech B95 · S/N TD408 · Cancelled Apr 28, 1993 · Triennial form not returned · Glatzer Industries Corp
- [N2819J](https://openairdocs.org/deregistered/N2819J-1993-04-07.md): Piper PA-28RT-201 · S/N 28R7918158 · Cancelled Apr 7, 1993
- [N4429W](https://openairdocs.org/deregistered/N4429W-1974-10-23.md): Beech 95-B55 · S/N TC-1675 · Cancelled Oct 23, 1974 · Exported to India · Built 1974 · Koszarek Joseph P
- [N4471W](https://openairdocs.org/deregistered/N4471W-1974-10-21.md): Beech 95-B55 (T42A) · S/N TC-1679 · Cancelled Oct 21, 1974 · Exported to India · Built 1974 · Koszarek Joseph P
- [N21900](https://openairdocs.org/deregistered/N21900-1955-11-21.md): Cessna T-50 · S/N 3793 · Cancelled Nov 21, 1955 · Pierce Hugh M Jr
- [N58117](https://openairdocs.org/deregistered/N58117-1954-06-30.md): Boeing A75N1 · S/N 75-2231 (41-8672) · Cancelled Jun 30, 1954 · Built 1941 · Eby Robert E
- [N213V](https://openairdocs.org/deregistered/N213V-1943-08-06.md): Bird BK · S/N 2014-02 · Cancelled Aug 6, 1943 · Built 1930 · Bullock Rosalie
- [N8051](https://openairdocs.org/deregistered/N8051-1940-12-15.md): Spartan C3-120 · S/N 77 · Cancelled Dec 15, 1940 · Built 1928 · Bruno Eugene J
- [N144E](https://openairdocs.org/deregistered/N144E-1939-03-20.md): Eaglerock A-3 · S/N 679 · Cancelled Mar 20, 1939 · Tucker Pierre Edward Gougelmann
- [N592M](https://openairdocs.org/deregistered/N592M-1938-07-29.md): Detroit SEA ROVER E-2 · S/N 3 · Cancelled Jul 29, 1938 · John Patouhas
- [N10165](https://openairdocs.org/deregistered/N10165-1938-04-15.md): Aeronca C-2 STANDARD · S/N 41 · Cancelled Apr 15, 1938 · Built 1930 · Yager Charles
- [N6140](https://openairdocs.org/deregistered/N6140-1935-06-15.md): Travel Air Mfg 2000 · S/N 638 · Cancelled Jun 15, 1935 · Patouhas John
- [N796Y](https://openairdocs.org/deregistered/N796Y-1933-02-09.md): De Simone Frank C J DE SIMONE · S/N 1001 · Cancelled Feb 9, 1933 · Frank C J Desimone
- [N1882](https://openairdocs.org/deregistered/N1882-1928-11-24.md): Curtiss Aircraft & Motor SEAGULL · S/N 7368 · Cancelled Nov 24, 1928 · Built 1927 · Atlantic Airways Inc

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

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