# Cancelled registrations: Bloomfield, CT

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

Cancelled aircraft registrations in Bloomfield, CT.

- [N43XK](https://openairdocs.org/deregistered/N43XK-2022-10-01.md): Kaman HH-43F · S/N USAF 59-1576 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1960 · Kaman Aerospace Corp
- [N1200W](https://openairdocs.org/deregistered/N1200W-2022-01-15.md): Kaman Aerospace K-1200 · S/N A94-0056 · Cancelled Jan 15, 2022 · Exported to Canada · Built 2021 · Kaman Aerospace Corp
- [N1200Q](https://openairdocs.org/deregistered/N1200Q-2021-03-16.md): Kaman Aerospace K-1200 · S/N A94-0053 · Cancelled Mar 16, 2021 · Exported to Canada · Kaman Aerospace Corp
- [N1200T](https://openairdocs.org/deregistered/N1200T-2021-02-22.md): Kaman Aerospace K-1200 · S/N A94-0055 · Cancelled Feb 22, 2021 · Exported to Liechtenstein · Kaman Aerospace Corp
- [N12001](https://openairdocs.org/deregistered/N12001-2020-10-14.md): Kaman Aerospace K-1200 · S/N A94-0052 · Cancelled Oct 14, 2020 · Exported to China · Kaman Aerospace Corp
- [N91517](https://openairdocs.org/deregistered/N91517-2018-10-23.md): Aerostar International S-66A · S/N S66A-3054 · Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1994 · Costen William H
- [N3182T](https://openairdocs.org/deregistered/N3182T-2018-01-18.md): Kaman Aerospace K-1200 · S/N 0001 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1991 · Kaman Aerospace Corp
- [N996KA](https://openairdocs.org/deregistered/N996KA-2017-09-11.md): Kaman Aerospace K-1200 · S/N A94-0041 · Cancelled Sep 11, 2017 · Exported to Liechtenstein · Kaman Aerospace Corp
- [N994KA](https://openairdocs.org/deregistered/N994KA-2017-08-03.md): Kaman Aerospace K-1200 · S/N A94-0040 · Cancelled Aug 3, 2017 · Exported to China · Kaman Aerospace Corp
- [N4270W](https://openairdocs.org/deregistered/N4270W-2017-07-28.md): Weigt Donald A CHALLENGER II · S/N CH2-1209-LSS-0164 · Cancelled Jul 28, 2017 · Built 2009 · Weigt Donald A
- [N995KA](https://openairdocs.org/deregistered/N995KA-2017-07-17.md): Kaman Aerospace K-1200 · S/N A94-0039 · Cancelled Jul 17, 2017 · Exported to China · Built 2017 · Kaman Aerospace Corp
- [N225K](https://openairdocs.org/deregistered/N225K-2017-07-12.md): Kaman Aerospace K-225 · S/N 11 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1950 · Kaman Aerospace Corporation
- [N654KM](https://openairdocs.org/deregistered/N654KM-2015-05-15.md): Kaman K-894(A) · S/N 150160 · Cancelled May 15, 2015 · Exported to New Zealand · Kaman Aerospace Corp
- [N523KM](https://openairdocs.org/deregistered/N523KM-2015-05-14.md): Kaman K-894(A) · S/N 161914 · Cancelled May 14, 2015 · Exported to New Zealand · Built 1999 · Kaman Aerospace Corp
- [N314KM](https://openairdocs.org/deregistered/N314KM-2015-04-23.md): Kaman K-894(A) · S/N 161656 · Cancelled Apr 23, 2015 · Exported to New Zealand · Built 1999 · Kaman Aerospace Corp
- [N332KM](https://openairdocs.org/deregistered/N332KM-2015-04-23.md): Kaman Aerospace SH2-G(A) · S/N 152205 · Cancelled Apr 23, 2015 · Exported to New Zealand · Built 1999 · Kaman Aerospace Corp
- [N424KM](https://openairdocs.org/deregistered/N424KM-2015-04-23.md): Kaman K-894(A) · S/N 151329 · Cancelled Apr 23, 2015 · Exported to New Zealand · Built 1999 · Kaman Aerospace Corp
- [N165KA](https://openairdocs.org/deregistered/N165KA-2013-07-29.md): Kaman K-894(NZ) · S/N NZ05 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 2002 · Kaman Aerospace Corp
- [N55600](https://openairdocs.org/deregistered/N55600-2013-01-31.md): Raven Industries RALLY RX7 · S/N RX7-167 · Cancelled Jan 31, 2013 · Sale reported, canceled
- [N266KA](https://openairdocs.org/deregistered/N266KA-2005-06-01.md): Kaman Aerospace K-1200 · S/N A94-0036 · Cancelled Jun 1, 2005 · Exported to Japan · Built 2003 · Kaman Aerospace Corp
- [N264KA](https://openairdocs.org/deregistered/N264KA-2005-01-24.md): Kaman Aerospace K-1200 · S/N A940034 · Cancelled Jan 24, 2005 · Exported to South Korea · Kaman Aerospace Corp
- [N163KA](https://openairdocs.org/deregistered/N163KA-2003-07-02.md): Kaman Aerospace K-1200 · S/N A94-0013 · Cancelled Jul 2, 2003 · Exported to Canada · Built 1995 · Kaman Aerospace Corporation
- [N4394V](https://openairdocs.org/deregistered/N4394V-2002-10-21.md): Raven S-60A · S/N S60A-313 · Cancelled Oct 21, 2002 · Triennial form not returned · Built 1984 · Sky Endeavors Inc
- [N164KA](https://openairdocs.org/deregistered/N164KA-2002-06-11.md): Kaman Aerospace K-1200 · S/N A94-0014 · Cancelled Jun 11, 2002 · Exported to Switzerland · Kaman Aerospace Corp
- [N353KA](https://openairdocs.org/deregistered/N353KA-2002-05-14.md): Kaman K-894(NZ) · S/N NZ02 · Cancelled May 14, 2002 · Exported to New Zealand · Built 2000 · Kaman Aerospace Corp
- [N354KA](https://openairdocs.org/deregistered/N354KA-2002-01-03.md): Kaman K-894(NZ) · S/N NZ03 · Cancelled Jan 3, 2002 · Kaman Aerospace Corp
- [N352KA](https://openairdocs.org/deregistered/N352KA-2001-06-05.md): Kaman K-894(NZ) · S/N NZ01 · Cancelled Jun 5, 2001 · Exported to New Zealand · Kaman Aerospace Corp
- [N355KA](https://openairdocs.org/deregistered/N355KA-2001-06-05.md): Kaman K-894(NZ) · S/N NZ04 · Cancelled Jun 5, 2001 · Exported to New Zealand · Kaman Aerospace Corp
- [N135KA](https://openairdocs.org/deregistered/N135KA-2001-03-26.md): Kaman Aerospace K-1200 · S/N A94-0023 · Cancelled Mar 26, 2001 · Triennial form not returned · Kaman Aersopace Corp
- [N6533K](https://openairdocs.org/deregistered/N6533K-1997-10-06.md): Aerostar International S-66A · S/N S66A3018 · Cancelled Oct 6, 1997 · Triennial form not returned · Sky Endeavors Inc
- [N136KA](https://openairdocs.org/deregistered/N136KA-1997-03-17.md): Kaman Aerospace K-1200 · S/N A940008 · Cancelled Mar 17, 1997 · Exported to Switzerland · Kaman Aerospace Corporation
- [N135KA](https://openairdocs.org/deregistered/N135KA-1996-03-29.md): Kaman Aerospace K-1200 · S/N A940007 · Cancelled Mar 29, 1996 · Exported to Canada · Kaman Aerospace Corporation
- [N161KA](https://openairdocs.org/deregistered/N161KA-1995-04-17.md): Kristoferson John GLASTAR · S/N 0009 · Cancelled Apr 17, 1995 · Exported to Switzerland · Kaman Aerospace Corp
- [N4061A](https://openairdocs.org/deregistered/N4061A-1977-07-06.md): Sikorsky S-51 · S/N 51163 · Cancelled Jul 6, 1977 · Theodore D Bross Line Construction Corp
- [N6256](https://openairdocs.org/deregistered/N6256-1976-07-17.md): Kaman KSA-100 · S/N 1 · Cancelled Jul 17, 1976 · Kaman Aerospace Corp
- [N10027](https://openairdocs.org/deregistered/N10027-1971-02-12.md): Kaman HH-43B · S/N 36 · Cancelled Feb 12, 1971 · Kaman Aircraft Corp-Lessee/ Usaf-Lessor
- [N10029](https://openairdocs.org/deregistered/N10029-1971-02-12.md): Kaman K1125 · S/N 122 · Cancelled Feb 12, 1971 · Kaman Aircraft Corp
- [N74359](https://openairdocs.org/deregistered/N74359-1965-05-24.md): Bellanca 14-13-2 · S/N 1472 · Cancelled May 24, 1965 · Jospeh F Bergamini
- [N1027B](https://openairdocs.org/deregistered/N1027B-1965-05-18.md): Grumman F8F-2 · S/N 121707 · Cancelled May 18, 1965 · The Kaman Aircraft Corp
- [N1030B](https://openairdocs.org/deregistered/N1030B-1965-05-18.md): Grumman F8F-2 · S/N 121776 · Cancelled May 18, 1965 · Kaman Aircraft Corp
- [N241B](https://openairdocs.org/deregistered/N241B-1965-05-18.md): Kaman H1MK · S/N 1 · Cancelled May 18, 1965 · Kaman Aircraft Corp
- [N268B](https://openairdocs.org/deregistered/N268B-1965-05-18.md): Kaman K17 · S/N 1 · Cancelled May 18, 1965 · Kaman Aircraft Corp
- [N298B](https://openairdocs.org/deregistered/N298B-1965-05-18.md): Kaman K-600 · S/N 1 · Cancelled May 18, 1965 · Kaman Aircraft Corporation

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

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