# Cancelled registrations: New Britain, CT

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

Cancelled aircraft registrations in New Britain, CT.

- [N550QC](https://openairdocs.org/deregistered/N550QC-2018-09-13.md): Pinnacl X CHAMELEON PRO · S/N PX-CHP-0001 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Central Connecticut State University
- [N550UC](https://openairdocs.org/deregistered/N550UC-2018-09-13.md): 3D Robotics IRIS · S/N 8705 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Central Connecticut State University
- [N550WQ](https://openairdocs.org/deregistered/N550WQ-2018-09-13.md): Pinnacl X CHAMELEON · S/N PX-CH-0001 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Central Connecticut State University
- [N2317R](https://openairdocs.org/deregistered/N2317R-2013-06-07.md): Proxee Peter/Claudia P. JAY · S/N 1 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1983 · Proxee Peter J
- [N8RE](https://openairdocs.org/deregistered/N8RE-2013-03-11.md): Elmer Ralph E KR-2 · S/N 922 · Cancelled Mar 11, 2013 · Sale reported, pending cancellation
- [N2007](https://openairdocs.org/deregistered/N2007-2012-10-16.md): Mcgee BENSEN B8M · S/N 1 · Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1976 · Schultz James J
- [N76543](https://openairdocs.org/deregistered/N76543-2012-09-06.md): Cessna 140 · S/N 10979 · Cancelled Sep 6, 2012 · Revoked, canceled · Built 1946 · Dornan Weston E
- [N6574](https://openairdocs.org/deregistered/N6574-1973-09-04.md): Douglas DC-3A-S1C3G · S/N 4388 · Cancelled Sep 4, 1973 · Arute International Air Inc
- [N97515](https://openairdocs.org/deregistered/N97515-1970-07-22.md): Stinson 108 · S/N 108-515 · Cancelled Jul 22, 1970 · Built 1946 · Oskinis Bruno A/Mastrianni Alfred R
- [N51841](https://openairdocs.org/deregistered/N51841-1953-03-23.md): Fairchild M-62A · S/N T42-3554 · Cancelled Mar 23, 1953 · Built 1945 · Maranda Francis
- [N35673](https://openairdocs.org/deregistered/N35673-1952-05-15.md): Piper J3F-65 · S/N 6533 · Cancelled May 15, 1952 · Built 1941 · Martin Stanley J
- [N93315](https://openairdocs.org/deregistered/N93315-1950-12-29.md): Ercoupe 415-C · S/N 638 · Cancelled Dec 29, 1950 · Kitson Joseph
- [N93957](https://openairdocs.org/deregistered/N93957-1949-05-02.md): Ercoupe 415-C · S/N 1280 · Cancelled May 2, 1949 · Dimeo William E
- [N300H](https://openairdocs.org/deregistered/N300H-1936-11-15.md): Moth 60-GM · S/N 3-A · Cancelled Nov 15, 1936 · Schmidt Clarence J
- [N852W](https://openairdocs.org/deregistered/N852W-1936-09-01.md): Swift Leon M SWIFT MEAD PRIM GLDR · S/N 2001 · Cancelled Sep 1, 1936 · Andrews John R
- [N2827](https://openairdocs.org/deregistered/N2827-1936-03-15.md): Nelson / Driscoll FLEET WING · S/N 25 · Cancelled Mar 15, 1936 · Driscoll Benjamin B
- [N584](https://openairdocs.org/deregistered/N584-1933-04-11.md): Bellanca CH300 PACEMAKER · S/N 130 · Cancelled Apr 11, 1933 · Carey George

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

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