# Registered aircraft: Marstons Mills, MA

A list on [Marstons Mills, MA](https://openairdocs.org/faa-place/MA/Marstons%20Mills.md).

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

- [N174CS](https://openairdocs.org/aircraft/N174CS.md): Schanche Carsten H RV-7A · S/N 70876 · Built 2012 · Schanche Carsten H
- [N262M](https://openairdocs.org/aircraft/N262M.md): Cessna 172N · S/N 17268356 · Built 1976 · Gordon Bruce
- [N29364](https://openairdocs.org/aircraft/N29364.md): Waco UPF-7 · S/N 5391 · Built 1940 · Mills Air Service Inc
- [N3116A](https://openairdocs.org/aircraft/N3116A.md): Cessna 170B · S/N 25760 · Built 1953 · Schanche Carsten H
- [N3447M](https://openairdocs.org/aircraft/N3447M.md): Piper PA-12 · S/N 12-2065 · Registration pending · Built 1947
- [N3782M](https://openairdocs.org/aircraft/N3782M.md): Piper PA-12 · S/N 12-2712 · Mills Air Service Inc
- [N3896D](https://openairdocs.org/aircraft/N3896D.md): Cessna 182A · S/N 34596 · Built 1957 · Mills Air Service Inc
- [N4005Z](https://openairdocs.org/aircraft/N4005Z.md): Piper PA-18-150 · S/N 18-7956 · Built 1963 · Mills Air Service Inc
- [N4103M](https://openairdocs.org/aircraft/N4103M.md): Piper PA-12 · S/N 12-3000 · Built 1947 · Mills Air Service Inc
- [N4921D](https://openairdocs.org/aircraft/N4921D.md): Cessna 182A · S/N 51021 · Built 1958 · Mills Air Service Inc
- [N50606](https://openairdocs.org/aircraft/N50606.md): Cessna 150J · S/N 15069429 · Built 1968 · Siderwicz Christopher J
- [N60010](https://openairdocs.org/aircraft/N60010.md): Cessna T-50 · S/N 3968 · Built 1943 · Siderwicz Christopher J
- [N61981](https://openairdocs.org/aircraft/N61981.md): Douglas DC3A · S/N 2216 · Built 1940 · Siderwicz Christopher J
- [N6377M](https://openairdocs.org/aircraft/N6377M.md): Waco YMF · S/N F50016 · Built 1988 · Mills Air Service Inc
- [N738HJ](https://openairdocs.org/aircraft/N738HJ.md): Cessna 172N · S/N 17269987 · Built 1977 · Mcnamara Patrick J
- [N755MA](https://openairdocs.org/aircraft/N755MA.md): Piper J-3 · S/N 15785 · Mills Air Service Inc
- [N756TR](https://openairdocs.org/aircraft/N756TR.md): Cessna R182 · S/N R18201153 · Built 1979 · Sawyer Charles W
- [N82DM](https://openairdocs.org/aircraft/N82DM.md): Avions Mudry ET Cie CAP 10B · S/N 88 · Built 1978 · Perry Timothy W
- [N86DG](https://openairdocs.org/aircraft/N86DG.md): Glaser-Dirks Flugzeugbau DG-100G · S/N E-47 G-26 · Built 1980 · Charlton Arthur R

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

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