# Registered aircraft: Mansfield, MA

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

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

- [N125MZ](https://openairdocs.org/aircraft/N125MZ.md): Avia Stroitel AC-5M · S/N 005 · Built 2001 · Micke Thomas Bernd
- [N135GA](https://openairdocs.org/aircraft/N135GA.md): Slingsby T67C · S/N 2102 · Built 1992 · Micke Thomas B
- [N1378X](https://openairdocs.org/aircraft/N1378X.md): Roosma-Opila LONGEZE · S/N 315 · Built 1982 · Turner Charles B
- [N13901](https://openairdocs.org/aircraft/N13901.md): Piper PA-23-250 · S/N 27-4533 · Built 1970 · Masscotte Michael
- [N2549P](https://openairdocs.org/aircraft/N2549P.md): Piper PA-22-150 · S/N 22-2913 · Built 1955 · Lyons Andrew J
- [N2586S](https://openairdocs.org/aircraft/N2586S.md): Cessna 172F · S/N 17252809 · Casey Aviation Inc
- [N32659](https://openairdocs.org/aircraft/N32659.md): Piper PA-28-151 · S/N 28-7515212 · Built 1974 · Allen Aviation LLC
- [N3321K](https://openairdocs.org/aircraft/N3321K.md): Globe GC-1B · S/N 1314 · Built 1946 · Reiff Christopher R
- [N35580](https://openairdocs.org/aircraft/N35580.md): Piper PA-31-350 · S/N 31-8052075 · Built 1980 · Aero Charter New England Inc
- [N441T](https://openairdocs.org/aircraft/N441T.md): Lunacek Ted AVID FLYER · S/N 633 · Guild Scott G
- [N4503S](https://openairdocs.org/aircraft/N4503S.md): Beech F33A · S/N CE-594 · Built 1975 · Barber Christian
- [N72740](https://openairdocs.org/aircraft/N72740.md): Cessna 140 · S/N 9919 · Built 1946 · Lyons Andrew James
- [N771SF](https://openairdocs.org/aircraft/N771SF.md): Liberty Aerospace LIBERTY XL-2 · S/N 0016 · Built 2006 · Flammini Steven
- [N8831N](https://openairdocs.org/aircraft/N8831N.md): Piper PA-28-140 · S/N 28-25682 · Built 1969 · Allen Aviation LLC
- [N9476J](https://openairdocs.org/aircraft/N9476J.md): Piper PA-28-180 · S/N 28-3592 · Built 1966 · Nery Thomas A
- [N991SW](https://openairdocs.org/aircraft/N991SW.md): Peter M Leston ZODIAC CH650 · S/N 65-10173 · Built 2024 · Leston Peter M

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

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