# Registered aircraft: Fairfield, CT

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

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

- [N1376](https://openairdocs.org/aircraft/N1376.md): Mcewan M-2-153 · S/N 101 · Esser Paul H
- [N13MB](https://openairdocs.org/aircraft/N13MB.md): Andrew San Marco SUBSONEX · S/N JSX0007 · San Marco Andrew
- [N2155W](https://openairdocs.org/aircraft/N2155W.md): Mooney M20K · S/N 25-2010 · Built 1997 · Hansen Edward J
- [N222YY](https://openairdocs.org/aircraft/N222YY.md): Cirrus Design SR22 · S/N 1458 · Built 2005 · Merlin Aviation LLC
- [N285PS](https://openairdocs.org/aircraft/N285PS.md): Piper PA-32R-301T · S/N 32R-8229007 · Built 1981 · Shavinsky John E
- [N329RW](https://openairdocs.org/aircraft/N329RW.md): Piper PA32-301FT · S/N 3232073 · Built 2007 · Hansen Glenn J
- [N371WB](https://openairdocs.org/aircraft/N371WB.md): Brandt Stirling D WAIEX-B · S/N WXB0037 · Built 2020 · Brandt Stirling D
- [N3854A](https://openairdocs.org/aircraft/N3854A.md): Schweizer SGS 1-26A · S/N 15 · Built 1955 · Esser Paul H
- [N425DP](https://openairdocs.org/aircraft/N425DP.md): Piper PA-28R-201 · S/N 28R-7837174 · Built 1978 · Kuhn Alexander G
- [N4372U](https://openairdocs.org/aircraft/N4372U.md): Colyer William G PATOSTAT · S/N CYB-002 · Built 1998 · Colyer William G
- [N64AL](https://openairdocs.org/aircraft/N64AL.md): Extra Flugzeugproduktions-Und EA 300/LC · S/N LC031 · Built 2014 · Ronjon Aviation LLC
- [N675AS](https://openairdocs.org/aircraft/N675AS.md): Beech 35-B33 · S/N CD-667 · Built 1963 · San Marco Andrew
- [N703ZA](https://openairdocs.org/aircraft/N703ZA.md): Colyer William G PATOSTAT · S/N CYB-003 · Colyer William G
- [N77577](https://openairdocs.org/aircraft/N77577.md): Air Command TANDEM · S/N 012 · Built 2006 · Shimarov Sergey
- [N775SS](https://openairdocs.org/aircraft/N775SS.md): Sergey Shimarov BUSHGYRO · S/N 001 · Built 2019 · Shimarov Sergey
- [N79AH](https://openairdocs.org/aircraft/N79AH.md): Cirrus Design SR22 · S/N 4542 · Built 2017 · Bmac3 LLC
- [N821Z](https://openairdocs.org/aircraft/N821Z.md): Peres-Schreder HP-11A · S/N 21 · Built 1966 · Esser Paul H
- [N955WT](https://openairdocs.org/aircraft/N955WT.md): Cirrus Design SR22 · S/N 8775 · Built 2022 · One Bravo Papa LLC
- [N988M](https://openairdocs.org/aircraft/N988M.md): Cessna R182 · S/N R18201357 · Turecek Peter J

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

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