# Registered aircraft: Pittsfield, MA

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

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

- [N100LY](https://openairdocs.org/aircraft/N100LY.md): Piper PA-31-350 · S/N 31-8052064 · Lyon Aviation Inc
- [N116LC](https://openairdocs.org/aircraft/N116LC.md): American Legend AL11 · S/N AL-1097 · Built 2007 · Ronnies Aircraft Sales Llp
- [N12477](https://openairdocs.org/aircraft/N12477.md): Cessna 172M · S/N 17262005 · Built 1973 · South Mountain Flying Club Inc
- [N1339G](https://openairdocs.org/aircraft/N1339G.md): Cessna 310R · S/N 310R0023 · Built 1974 · Lyon Aviation Inc
- [N1624K](https://openairdocs.org/aircraft/N1624K.md): Gulfstream Aerospace G-IV · S/N 1457 · Built 2001 · 4kla LLC
- [N191N](https://openairdocs.org/aircraft/N191N.md): Dassault MYSTERE-FALCON 50 · S/N 334 · Built 2003 · Mcm Leasing LLC
- [N194DM](https://openairdocs.org/aircraft/N194DM.md): Vans RV-12 · S/N 120225 · Ronnie'S Aircraft Sales Llp
- [N215BB](https://openairdocs.org/aircraft/N215BB.md): Gulfstream Aerospace G-V · S/N 610 · Built 2000 · Bl Charter LLC
- [N234CL](https://openairdocs.org/aircraft/N234CL.md): Cirrus Design SR22T · S/N 0050 · Built 2010 · 40 Richmond LLC
- [N2842E](https://openairdocs.org/aircraft/N2842E.md): Cessna 172N · S/N 17271342 · Built 1978 · Lyon Aviation Inc
- [N456CG](https://openairdocs.org/aircraft/N456CG.md): Gates Learjet 25D · S/N 343 · Built 1981 · Ldl Aircraft Leasing LLC
- [N500LY](https://openairdocs.org/aircraft/N500LY.md): Dassault MYSTERE-FALCON 50 · S/N 323 · Built 2002 · 1380 Jets LLC
- [N5066](https://openairdocs.org/aircraft/N5066.md): Schleicher KA 6 CR · S/N 958 · Built 1961 · Markowitz Neal S
- [N555GC](https://openairdocs.org/aircraft/N555GC.md): Mooney M20F · S/N 670508 · Built 1967 · Sasakwa LLC
- [N5887N](https://openairdocs.org/aircraft/N5887N.md): Rockwell International 114A · S/N 14502 · Built 1978 · Berkshire Commander Air LLC
- [N6422F](https://openairdocs.org/aircraft/N6422F.md): Cessna 150F · S/N 15063022 · Built 1966 · Clark James H
- [N6463Q](https://openairdocs.org/aircraft/N6463Q.md): Cessna 152 · S/N 15285255 · Built 1981 · Lyon Aviation Inc
- [N7629W](https://openairdocs.org/aircraft/N7629W.md): Piper PA-28-180 · S/N 28-1596 · Mah Michael
- [N900LY](https://openairdocs.org/aircraft/N900LY.md): Gulfstream Aerospace G-V · S/N 661 · Built 2001 · 6500 LLC
- [N905GS](https://openairdocs.org/aircraft/N905GS.md): Textron 525 · S/N 525-1137 · Built 2023 · Glh Capital LLC
- [N94688](https://openairdocs.org/aircraft/N94688.md): Cessna 152 · S/N 15285765 · Built 1983 · Lyon Aviation Inc

## 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 = 'MA' AND g.registrant_city = 'PITTSFIELD'
ORDER BY g.n_number
```

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