# Registered aircraft: Media, PA

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

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

- [N108WM](https://openairdocs.org/aircraft/N108WM.md): Piper PA-32-300 · S/N 32-7840187 · Built 1978 · Moran William J
- [N152PW](https://openairdocs.org/aircraft/N152PW.md): Acft Comp Struct Devlp & Prod PW2D GAPA D · S/N U-15 · Built 1993 · Serota Andrew
- [N1X](https://openairdocs.org/aircraft/N1X.md): Cessna 172F · S/N 17252958 · Built 1965 · Saitto Jeffrey M
- [N2011Y](https://openairdocs.org/aircraft/N2011Y.md): Flamboyant Balloons PTY AX8-85P · S/N 033 · Built 1987 · Fawthorp John W
- [N2079Q](https://openairdocs.org/aircraft/N2079Q.md): Cessna 177RG · S/N 177RG0479 · Built 1974 · Mkk Pilots LLC
- [N21287](https://openairdocs.org/aircraft/N21287.md): Taylorcraft BF-60 · S/N 1081 · Maule Susan D
- [N2719K](https://openairdocs.org/aircraft/N2719K.md): Luscombe 8A · S/N 5446 · Built 1947 · Norsworthy Cletus C
- [N32008](https://openairdocs.org/aircraft/N32008.md): Piper PA-28-180 · S/N 28-7505014 · Built 1974 · K L M Aircraft Co
- [N3344J](https://openairdocs.org/aircraft/N3344J.md): Cessna 150G · S/N 15066044 · Saitto Jeffrey M
- [N4706T](https://openairdocs.org/aircraft/N4706T.md): Maule M-4 · S/N 48 · Built 1963 · Maule Susan
- [N515AM](https://openairdocs.org/aircraft/N515AM.md): Rockwell International 695 · S/N 95008 · Built 1980 · Allen Myland Inc
- [N636BS](https://openairdocs.org/aircraft/N636BS.md): Piper PA-28-151 · S/N 28-7515207 · Built 1974 · 636bs Corp
- [N71929](https://openairdocs.org/aircraft/N71929.md): Luscombe 8A · S/N 3356 · Built 1946 · Norsworthy Cletus C
- [N722KP](https://openairdocs.org/aircraft/N722KP.md): Pilatus PC-12/47 · S/N 816 · Built 2007 · Air Sjb LLC
- [N727PD](https://openairdocs.org/aircraft/N727PD.md): Evolution REVO · S/N 000593 · Built 2013 · Goldman James L
- [N729RV](https://openairdocs.org/aircraft/N729RV.md): Jones Darwin L RV-4 · S/N 1581 · Built 2016 · Two Bag Ice LLC
- [N7685Q](https://openairdocs.org/aircraft/N7685Q.md): Cessna 310Q · S/N 310Q0464 · Strowhouer William J III
- [N8425G](https://openairdocs.org/aircraft/N8425G.md): Cessna 150 · S/N 15062525 · Built 1965 · Saitto Jeffrey M
- [N8681J](https://openairdocs.org/aircraft/N8681J.md): Cessna 150G · S/N 15066581 · Built 1967 · Saitto Jeffrey 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 = 'PA' AND g.registrant_city = 'MEDIA'
ORDER BY g.n_number
```

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