# Registered aircraft: Guilford, CT

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

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

- [N1041X](https://openairdocs.org/aircraft/N1041X.md): Piper PA-28-180 · S/N 28-7505199 · Built 1975 · Gyllensten Scott
- [N11528](https://openairdocs.org/aircraft/N11528.md): Cessna 150L · S/N 15075490 · Built 1973 · Streeter Derek
- [N144DJ](https://openairdocs.org/aircraft/N144DJ.md): Robinson Helicopter R44 · S/N 2467 · Built 2017 · Saybrook Offshore LLC
- [N19GJ](https://openairdocs.org/aircraft/N19GJ.md): Piper PA-28-180 · S/N 28-7405020 · Built 1973 · Jmd Aviation LLC
- [N210SQ](https://openairdocs.org/aircraft/N210SQ.md): Bradley Roderick W MURPHY RENEGADE · S/N REN 575 · Built 1995 · Bradley Roderick W
- [N320DR](https://openairdocs.org/aircraft/N320DR.md): Lancair LC42-550FG · S/N 42064 · Built 2005 · Montgomery Machine LLC
- [N411GJ](https://openairdocs.org/aircraft/N411GJ.md): Beech A36 · S/N E-2586 · Built 1990 · Guardian Jet LLC
- [N4437H](https://openairdocs.org/aircraft/N4437H.md): Mooney M20J · S/N 24-0732 · Sander Elliot G
- [N529JN](https://openairdocs.org/aircraft/N529JN.md): Lawrence W Nelson HALCYON54K · S/N 2011-54K-1 · Built 2011 · Nelson Lawrence W
- [N711BG](https://openairdocs.org/aircraft/N711BG.md): Cessna P210N · S/N P21000806 · Built 1982 · Saybrook Offshore LLC
- [N7694V](https://openairdocs.org/aircraft/N7694V.md): Cessna 177RG · S/N 177RG0904 · Built 1976 · Markowski John J
- [N790XT](https://openairdocs.org/aircraft/N790XT.md): Mark George Tower MONI · S/N 00127 · Tower Mark G
- [N8308V](https://openairdocs.org/aircraft/N8308V.md): Piper PA-32R-301T · S/N 32R-8129016 · Built 1980 · Cleary Paul D
- [N84KG](https://openairdocs.org/aircraft/N84KG.md): Maule M-5-180C · S/N 8047C · Ginz Peter M
- [N9084N](https://openairdocs.org/aircraft/N9084N.md): Piper PA-28-181 · S/N 2890164 · Rose John K
- [N90YC](https://openairdocs.org/aircraft/N90YC.md): Dassault FALCON 900EX · S/N 250 · Built 2010 · American Cruise Lines Inc
- [N933X](https://openairdocs.org/aircraft/N933X.md): Andrews Richard S III RV6-A · S/N 60515 · Built 2005 · Andrews Richard S III
- [N95967](https://openairdocs.org/aircraft/N95967.md): Cessna 182Q · S/N 18266693 · Built 1978 · Hadley Nicholas J
- [N9841G](https://openairdocs.org/aircraft/N9841G.md): Cessna 172L · S/N 17259741 · Built 1971 · Yoxall Jennifer S

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

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