# Registered aircraft: Glastonbury, CT

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

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

- [N13922](https://openairdocs.org/aircraft/N13922.md): Armando Dave 162F · S/N 7079 · Cooke Douglas G
- [N15EX](https://openairdocs.org/aircraft/N15EX.md): Barnard S/Stancil D L GLASTAR · S/N 5496 · Rich David R
- [N1972R](https://openairdocs.org/aircraft/N1972R.md): DJI Innovations INSPIRE 1 · S/N W13DCC23020137 · Rodriguez Samuel A
- [N214BR](https://openairdocs.org/aircraft/N214BR.md): Cirrus Design SR22 · S/N 2318 · Built 2007 · Baba Daniel
- [N3190Q](https://openairdocs.org/aircraft/N3190Q.md): Cessna 182K · S/N 18258190 · Built 1967 · Hilton John C
- [N4117F](https://openairdocs.org/aircraft/N4117F.md): Piper PA-28-181 · S/N 28-7790004 · Built 1976 · Made U Look Promotions LLC
- [N429HC](https://openairdocs.org/aircraft/N429HC.md): Bell Helicopter Textron Canada 429 · S/N 57019 · Built 2010 · Delta Jet Ltd
- [N46511](https://openairdocs.org/aircraft/N46511.md): Cessna 172K · S/N 17257315 · Built 1969 · Connecticut Valley Flyers Inc
- [N5010S](https://openairdocs.org/aircraft/N5010S.md): Piper PA-28R-200 · S/N 28R-35735 · Built 1970 · Aeroflyte LLC
- [N524HF](https://openairdocs.org/aircraft/N524HF.md): Cessna 152 · S/N 15283436 · Ba Group LLC
- [N682BH](https://openairdocs.org/aircraft/N682BH.md): Bell Helicopter Textron Canada 206B · S/N 4682 · Built 2009 · Ba Group LLC
- [N697SH](https://openairdocs.org/aircraft/N697SH.md): Linker Howard W SONEX · S/N 0697 · Built 2004 · Linker Howard W
- [N784BD](https://openairdocs.org/aircraft/N784BD.md): DJI PHANTOM 3 PROFESSION · S/N P76DCH29A21061 · Dsign Digital Media LLC
- [N8644F](https://openairdocs.org/aircraft/N8644F.md): Hughes 269C · S/N 770619 · Built 1977 · Bemer Aviation Inc
- [N8768B](https://openairdocs.org/aircraft/N8768B.md): Mcmurray David C SEAREY · S/N MK011 · Registration pending · Built 1997
- [N89AP](https://openairdocs.org/aircraft/N89AP.md): Bell 206B · S/N 975 · Built 1973 · Blue Dasher Aviation LLC
- [N9127D](https://openairdocs.org/aircraft/N9127D.md): Mooney M20J · S/N 24-3190 · Depasquale Chad E
- [N9132F](https://openairdocs.org/aircraft/N9132F.md): Hughes 369HS · S/N 230446S · Built 1973 · Horizon Aviation LLC
- [N946M](https://openairdocs.org/aircraft/N946M.md): Bell 206B · S/N 3646 · Built 1982 · Bemer Aviation Inc
- [N998EC](https://openairdocs.org/aircraft/N998EC.md): Mooney M20K · S/N 25-2020 · Built 1998 · Cooper Andrew P
- [N99ND](https://openairdocs.org/aircraft/N99ND.md): Schleicher ASW-19B · S/N 19357 · Hermann Mark A

## 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 = 'GLASTONBURY'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/CT/Glastonbury/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
