# Registered aircraft: Bloomfield, CT

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N10KA](https://openairdocs.org/aircraft/N10KA.md): Kaman Aerospace K-1200 · S/N A94-0021 · Built 1997 · Kaman Aerospace Corp
- [N131KA](https://openairdocs.org/aircraft/N131KA.md): Kaman Aerospace K-1200 · S/N A94-0002 · Non-citizen corporation, flight hours not reported · Built 1993 · Kaman Aerospace Corp
- [N150FT](https://openairdocs.org/aircraft/N150FT.md): Cessna 150G · S/N 15065352 · Levine Albert E
- [N2284D](https://openairdocs.org/aircraft/N2284D.md): Fish-Edwin OSPREY-2 · S/N 1 · Built 1995 · Kellner Aaron
- [N22EJ](https://openairdocs.org/aircraft/N22EJ.md): Extra Flugzeugproduktions UND EXTRA NG · S/N NG032 · Built 2022 · Jepsen Edward G
- [N2327L](https://openairdocs.org/aircraft/N2327L.md): Liquidpiston MUGIN-3 3600 · S/N 111656583 · Liquidpiston Inc
- [N237GQ](https://openairdocs.org/aircraft/N237GQ.md): Muginuav V6000G · S/N US202204010001 · Liquidpiston Inc
- [N317NC](https://openairdocs.org/aircraft/N317NC.md): Piper PA-28R-200 · S/N 28R-7635439 · Field Daniel James
- [N3217W](https://openairdocs.org/aircraft/N3217W.md): Piper PA-32-260 · S/N 32-19 · Built 1965 · North Anthony B
- [N43FK](https://openairdocs.org/aircraft/N43FK.md): Kaman HH-43B · S/N 60-0289 · Built 1962 · Kaman Aerospace Corp
- [N58KC](https://openairdocs.org/aircraft/N58KC.md): Kaman Aerospace KA-001 · S/N 0001 · Non-citizen corporation, flight hours not reported · Kaman Aerospace Corp
- [N71KC](https://openairdocs.org/aircraft/N71KC.md): Kaman Aerospace TAV-1 · S/N KUAV-0001 · Kaman Aerospace Corp
- [N72657](https://openairdocs.org/aircraft/N72657.md): Cessna 140 · S/N 9833 · Built 1946 · Howard Austin
- [N907C](https://openairdocs.org/aircraft/N907C.md): Cirrus Design SR22 · S/N 0385 · Built 2002 · Allen Gavin Alton
- [N954TC](https://openairdocs.org/aircraft/N954TC.md): Piper PA32-301FT · S/N 3232012 · Built 2003 · Cohbro Aviation Inc
- [N95AC](https://openairdocs.org/aircraft/N95AC.md): Kodiak KODIAK 100 · S/N 100-0319 · Built 2022 · Cohbro Aviation II LLC

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'CT' AND g.registrant_city = 'BLOOMFIELD'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/CT/Bloomfield/aircraft

---
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.