# Cancelled registrations: New Haven, CT

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

Cancelled aircraft registrations in New Haven, CT.

- [N607SY](https://openairdocs.org/deregistered/N607SY-2019-05-01.md): 3D Robotics SOLO · S/N S1115605732 · Cancelled May 1, 2019 · Registration expired, pending cancellation · Frick Reed
- [N1319V](https://openairdocs.org/deregistered/N1319V-2017-10-28.md): Aeronca 7BCM · S/N 7BCM-415 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1947 · Cap
- [N1734P](https://openairdocs.org/deregistered/N1734P-2017-10-28.md): Piper PA-22-150 · S/N 22-2524 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1954 · Guilford Flying Club Inc
- [N3294J](https://openairdocs.org/deregistered/N3294J-2014-12-17.md): Cessna 150G · S/N 15065994 · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1966 · Dowd Timothy W
- [N602CH](https://openairdocs.org/deregistered/N602CH-2013-09-30.md): Snyder James C CHALLENGER II · S/N CH20291R0646 · Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1992 · Snyder James C
- [N66554](https://openairdocs.org/deregistered/N66554-2013-04-30.md): Boeing E75 · S/N 75-8238 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Grelle Richard P DBA
- [N59947](https://openairdocs.org/deregistered/N59947-2013-04-25.md): Boeing B75N1 · S/N 75-3372 · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1949 · Grelle Richard DBA
- [N54760](https://openairdocs.org/deregistered/N54760-2013-04-19.md): Piper PA-23-250 · S/N 27-7554072 · Cancelled Apr 19, 2013 · Registration expired, pending cancellation · Built 1975 · Tomko Robert
- [N223SP](https://openairdocs.org/deregistered/N223SP-2012-08-30.md): Piper PA-38-112 · S/N 38-79A0339 · Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1978 · Charisma Aviation Ltd
- [N335CR](https://openairdocs.org/deregistered/N335CR-2008-04-08.md): Dag Associates SHA-GLASAIR RG · S/N 538 · Cancelled Apr 8, 2008 · Exported to Canada · Built 1987 · Byrd Cameron A
- [N5189P](https://openairdocs.org/deregistered/N5189P-1994-01-13.md): Cessna 152 · S/N 15284891 · Cancelled Jan 13, 1994 · Exported to Morocco · Childs Edward C
- [N50165](https://openairdocs.org/deregistered/N50165-1992-08-12.md): Cessna 150H · S/N 15069104 · Cancelled Aug 12, 1992 · Canalori Edward S
- [N3983A](https://openairdocs.org/deregistered/N3983A-1983-12-08.md): Fairchild M-62A-3 · S/N FT-670 · Cancelled Dec 8, 1983 · Built 1956 · Lufberry Flying Club Inc
- [N62895](https://openairdocs.org/deregistered/N62895-1980-08-06.md): Piper PA-31-350 · S/N 31-7652153 · Cancelled Aug 6, 1980 · Exported to Canada · New Haven Airways Inc
- [N2600C](https://openairdocs.org/deregistered/N2600C-1978-05-09.md): Piper PA-23-250 · S/N 27-3690 · Cancelled May 9, 1978 · Exported to Canada · New Haen Airways Inc
- [N54845](https://openairdocs.org/deregistered/N54845-1978-01-27.md): Piper PA-23-250 (6PCLM) · S/N 277554144 · Cancelled Jan 27, 1978 · Exported to Denmark · New Haven Airways Inc
- [N222AE](https://openairdocs.org/deregistered/N222AE-1976-11-16.md): Piper PA-31-350 · S/N 31-7305061 · Cancelled Nov 16, 1976 · Exported to Canada · Built 1973 · New Haven Airways Inc
- [N5884Y](https://openairdocs.org/deregistered/N5884Y-1976-03-08.md): Piper PA-23-250 (6PCLM) · S/N 27-3036 · Cancelled Mar 8, 1976 · Exported to Canada · New Haven Airways Inc
- [N5569Y](https://openairdocs.org/deregistered/N5569Y-1974-01-08.md): Piper PA-23-250 · S/N 272672 · Cancelled Jan 8, 1974 · New Haven Airways Inc
- [N555H](https://openairdocs.org/deregistered/N555H-1973-10-18.md): Grumman F8F-2 · S/N 121589 · Cancelled Oct 18, 1973 · Hanson Norwood Russell
- [N4767](https://openairdocs.org/deregistered/N4767-1971-08-24.md): Bucker Jungmeister BU133L · S/N 2001 · Cancelled Aug 24, 1971 · Gillette Gilbert A
- [N5604Y](https://openairdocs.org/deregistered/N5604Y-1970-06-26.md): Piper PA-23-250 · S/N 27-2712 · Cancelled Jun 26, 1970 · New Haven Airways Inc
- [N9640W](https://openairdocs.org/deregistered/N9640W-1968-07-29.md): Piper PA-28-140 · S/N 28-23099 · Cancelled Jul 29, 1968 · Built 1967 · New Haven Airways Inc
- [N80584](https://openairdocs.org/deregistered/N80584-1965-06-08.md): Globe GC-1A · S/N 87 · Cancelled Jun 8, 1965 · Defosche Alfred
- [N1313V](https://openairdocs.org/deregistered/N1313V-1965-05-18.md): Piper J3C-65 · S/N 11330 · Cancelled May 18, 1965 · Connecticut Wing Civil Air Patrol Inc
- [N49688](https://openairdocs.org/deregistered/N49688-1952-10-03.md): Piper J3C-65 · S/N 10980 · Cancelled Oct 3, 1952 · Usher Aviation Inc
- [N26403](https://openairdocs.org/deregistered/N26403-1952-05-05.md): Stinson 10 · S/N 7591 · Cancelled May 5, 1952 · Built 1940 · New Haven Squadron Civil Air Patrol
- [N1892V](https://openairdocs.org/deregistered/N1892V-1950-04-26.md): Cessna 140 · S/N 14072 · Cancelled Apr 26, 1950 · Brush Charles F
- [N51880](https://openairdocs.org/deregistered/N51880-1950-02-14.md): Boeing A75N1 · S/N 75-4594 · Cancelled Feb 14, 1950 · Built 1945 · Swanson W J
- [N89845](https://openairdocs.org/deregistered/N89845-1949-01-26.md): Cessna 120 · S/N 8894 · Cancelled Jan 26, 1949 · Aero Industries Corp
- [N15879](https://openairdocs.org/deregistered/N15879-1948-04-20.md): Porterfield 35-70 · S/N 179 · Cancelled Apr 20, 1948 · Messrs Warren F
- [N15021](https://openairdocs.org/deregistered/N15021-1948-04-13.md): Beech D17S · S/N 4880 · Cancelled Apr 13, 1948 · Built 1935 · Sportair Corp
- [N51740](https://openairdocs.org/deregistered/N51740-1948-02-03.md): Fairchild M-62A · S/N T42-1653 · Cancelled Feb 3, 1948 · Aero Industries Corp
- [N17181](https://openairdocs.org/deregistered/N17181-1942-01-13.md): Stinson SR-9C · S/N 5164 · Cancelled Jan 13, 1942 · Harry Lesnow
- [N10794](https://openairdocs.org/deregistered/N10794-1935-08-27.md): Bellanca CH400 SKYROCKET · S/N 621 · Cancelled Aug 27, 1935 · Exported to Philippines · Built 1931 · Light Richard U
- [N8481](https://openairdocs.org/deregistered/N8481-1932-10-14.md): Stinson SM-2AA · S/N 1075 · Cancelled Oct 14, 1932 · Petro Sol Corporation
- [N985M](https://openairdocs.org/deregistered/N985M-1932-03-29.md): Schreck Fba 310 · S/N 5 · Cancelled Mar 29, 1932 · Built 1931 · Gross R E/Gross C S
- [N2066](https://openairdocs.org/deregistered/N2066-1929-07-03.md): Naval Aircraft Factory CURTIS MF FLYNG BOAT · S/N 5525 · Cancelled Jul 3, 1929 · Built 1919 · New Haven Air Terminal Inc
- [N6594](https://openairdocs.org/deregistered/N6594-1929-04-26.md): Kreider-Reisner CHALLENGER · S/N 168 · Cancelled Apr 26, 1929 · Goodrich Aircraft Corp

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

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