# Registered aircraft: Bridgewater, MA

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

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

- [N172SJ](https://openairdocs.org/aircraft/N172SJ.md): Cessna 172R · S/N 17280291 · Built 1997 · Commonwealth Of Massachusetts
- [N2108H](https://openairdocs.org/aircraft/N2108H.md): Piper PA-28-236 · S/N 28-7911053 · Wise Charles
- [N223BW](https://openairdocs.org/aircraft/N223BW.md): Cessna 172R · S/N 17280950 · Built 2000 · Bridgewater State University
- [N3443H](https://openairdocs.org/aircraft/N3443H.md): Engineering & Research 415-C · S/N 4068 · Built 1947 · Pereira Ronaldo
- [N407BW](https://openairdocs.org/aircraft/N407BW.md): Cessna 172R · S/N 17280937 · Built 2000 · Bridgewater State University
- [N468RV](https://openairdocs.org/aircraft/N468RV.md): Draper William M RV-8 · S/N 82148 · Built 2011 · Draper William M
- [N5422Q](https://openairdocs.org/aircraft/N5422Q.md): Mandeville Richard RV 4 · S/N 111 · Built 1989 · Mandeville James R
- [N571BW](https://openairdocs.org/aircraft/N571BW.md): Cessna 172S · S/N 172S9738 · Built 2004 · Bridgewater State University
- [N572BW](https://openairdocs.org/aircraft/N572BW.md): Cessna 172S · S/N 172S9426 · Built 2003 · Bridgewater State University
- [N574BW](https://openairdocs.org/aircraft/N574BW.md): Cessna 172R · S/N 17280948 · Built 2000 · Bridge State University
- [N578BW](https://openairdocs.org/aircraft/N578BW.md): Cessna 172R · S/N 17280522 · Built 1998 · Bridgewater State University
- [N579BW](https://openairdocs.org/aircraft/N579BW.md): Cessna 172R · S/N 17280944 · Built 2000 · Bridgewater State University
- [N715BW](https://openairdocs.org/aircraft/N715BW.md): Cessna 172R · S/N 17280941 · Built 2000 · Bridgewater State University
- [N721SA](https://openairdocs.org/aircraft/N721SA.md): Cessna 172R · S/N 17280239 · Built 1997 · Commonwealth Of Massachusetts
- [N760BW](https://openairdocs.org/aircraft/N760BW.md): Cessna 172R · S/N 17280775 · Built 1999 · Bridgewater State University
- [N829BW](https://openairdocs.org/aircraft/N829BW.md): Cessna 172R · S/N 17280951 · Built 2000 · Bridgewater State University
- [N895AG](https://openairdocs.org/aircraft/N895AG.md): Flight Of Four RV-6 · S/N 25235 · Built 2010 · Proffetty Stephen D

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

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