# Registered aircraft: Sterling, MA

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

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

- [N1024C](https://openairdocs.org/aircraft/N1024C.md): Mooney M20J · S/N 24-1113 · Larsen Johannes
- [N1156S](https://openairdocs.org/aircraft/N1156S.md): Schweizer SGS 1-34 · S/N 56 · Built 1971 · Greater Boston Soaring Club
- [N1538L](https://openairdocs.org/aircraft/N1538L.md): Arbc Inc DBA Lindstrand 77A · S/N 5346 · Built 2006 · Martel Robert P
- [N166P](https://openairdocs.org/aircraft/N166P.md): Beech F33A · S/N CE-1560 · Built 1991 · Froggatt Richard H
- [N1675R](https://openairdocs.org/aircraft/N1675R.md): Ronald S Cassidy 1675R · S/N 001 · Built 2022 · Stodolski Mark D
- [N1977Y](https://openairdocs.org/aircraft/N1977Y.md): Mooney M20E · S/N 264 · Built 1964 · Trychon Stephen A
- [N233GB](https://openairdocs.org/aircraft/N233GB.md): Schweizer SGS 2-33B · S/N 60 · Mit Soaring Association Inc
- [N289BA](https://openairdocs.org/aircraft/N289BA.md): Let L 33 SOLO · S/N 940315 · Built 1996 · Mit Soaring Association Inc
- [N305RH](https://openairdocs.org/aircraft/N305RH.md): Cessna 305F · S/N 612956 · Built 1962 · Greater Boston Soaring Club Inc
- [N33917](https://openairdocs.org/aircraft/N33917.md): Schweizer SGS 1-26E · S/N 637 · Built 1975 · Greater Boston Soaring Club Inc
- [N373BA](https://openairdocs.org/aircraft/N373BA.md): Let L-23 SUPER BLANIK · S/N 008713 · Built 2000 · Greater Boston Soring Club
- [N39JF](https://openairdocs.org/aircraft/N39JF.md): Dg-Flugzeugbau LS 10-S · S/N L10-013 · Built 2009 · Orsini Thomas P
- [N421GB](https://openairdocs.org/aircraft/N421GB.md): Alexander Schleicher ASK 21 · S/N 21937 · Built 2016 · Greater Boston Soaring Club Inc
- [N5309Y](https://openairdocs.org/aircraft/N5309Y.md): Cameron Balloons O-77 · S/N 6178 · Built 2001 · Stodolski Mark D
- [N5785U](https://openairdocs.org/aircraft/N5785U.md): Piper PA-28-140 · S/N 28-26609 · Built 1970 · Zanino James A
- [N64TE](https://openairdocs.org/aircraft/N64TE.md): Arbc Inc DBA Lindstrand 90A · S/N 5574 · Built 2015 · Stodolski Mark D
- [N721RC](https://openairdocs.org/aircraft/N721RC.md): Alexander Schleicher ASK 21 · S/N 21930 · Built 2015 · Greater Boston Soaring Club Inc
- [N7587E](https://openairdocs.org/aircraft/N7587E.md): Champion 7GC · S/N 7GC-19 · Built 1958 · Broderick William E
- [N9129Q](https://openairdocs.org/aircraft/N9129Q.md): Beech G33 · S/N CD-1261 · Built 1971 · Froggatt Richard H
- [N91LG](https://openairdocs.org/aircraft/N91LG.md): Cirrus Design SR22T · S/N 9112 · Built 2023 · Sterling Aviation LLC
- [N9716P](https://openairdocs.org/aircraft/N9716P.md): Piper PA-25-235 · S/N 25-7556032 · Built 1975 · Greater Boston Soaring Club
- [N9809P](https://openairdocs.org/aircraft/N9809P.md): Piper PA-25-235 · S/N 25-7556123 · Built 1975 · Mit Soaring Association Inc
- [N9814A](https://openairdocs.org/aircraft/N9814A.md): Schleicher ASW-19 · S/N 19199 · Built 1978 · Greaterboston Soaring Club Inc
- [N996CB](https://openairdocs.org/aircraft/N996CB.md): Cassidy Ronald 2490 · S/N 101 · Built 2012 · Martel Robert P

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

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