# Registered aircraft: Somerton, AZ

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

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

- [N14WT](https://openairdocs.org/aircraft/N14WT.md): Airborne Windsports PTY EDGE XT-912-L · S/N XT-912-0319 · Registration pending · Built 2009
- [N1545G](https://openairdocs.org/aircraft/N1545G.md): Cessna T210G · S/N T210-0208 · Built 1966 · Saltzer Eric R
- [N2034J](https://openairdocs.org/aircraft/N2034J.md): Cessna T188C · S/N T18803339T · Built 1978 · Md Aero LLC
- [N2180D](https://openairdocs.org/aircraft/N2180D.md): Beech D35 · S/N D-3548 · Built 1953 · Kent James
- [N399F](https://openairdocs.org/aircraft/N399F.md): Cessna 180 · S/N 31478 · Built 1955 · Fieldgrove Matt L
- [N415CM](https://openairdocs.org/aircraft/N415CM.md): Engineering & Research ERCOUPE 415-CD · S/N 4259 · Built 1947 · Fieldgrove Matt
- [N4172V](https://openairdocs.org/aircraft/N4172V.md): Cessna 170 · S/N 18505 · Built 1948 · Md Aero LLC
- [N4223V](https://openairdocs.org/aircraft/N4223V.md): Cessna 170 · S/N 18579 · Built 1948 · Mcdermotts Letsfly LLC
- [N44127](https://openairdocs.org/aircraft/N44127.md): Taylorcraft BC12-D · S/N 9927 · Built 1946 · Saltzer Eric R
- [N55939](https://openairdocs.org/aircraft/N55939.md): Stinson VULTEE V-77 · S/N 77-257 · Fieldgrove Matt
- [N5988M](https://openairdocs.org/aircraft/N5988M.md): Cessna 421B · S/N 421B0231 · Built 1972 · Saltzer Eric
- [N60742](https://openairdocs.org/aircraft/N60742.md): Cessna 150J · S/N 15070539 · Built 1969 · Greene Daniel W
- [N6682Y](https://openairdocs.org/aircraft/N6682Y.md): Piper PA-23-250 · S/N 27-4003 · Built 1968 · Mcdermott James R
- [N67DV](https://openairdocs.org/aircraft/N67DV.md): Cessna 180B · S/N 50359 · Arizona Airplay LLC
- [N6918M](https://openairdocs.org/aircraft/N6918M.md): Stinson 108-3 · S/N 108-4918 · Built 1948 · Md Aero LLC
- [N737JH](https://openairdocs.org/aircraft/N737JH.md): Cessna 172N · S/N 17269449 · Built 1977 · Mcdermotts Letsfly LLC
- [N757JK](https://openairdocs.org/aircraft/N757JK.md): Cessna 152 · S/N 15279775 · Built 1977 · Mcdermotts Letsfly LLC
- [N7598T](https://openairdocs.org/aircraft/N7598T.md): Cessna 172A · S/N 47198 · Fieldgrove Matt L
- [N7769E](https://openairdocs.org/aircraft/N7769E.md): Cessna 150 · S/N 17569 · Built 1959 · Fieldgrove Matt
- [N7HW](https://openairdocs.org/aircraft/N7HW.md): Piper PA-23-250 · S/N 27-3718 · Built 1967 · Altieri Frank J
- [N8084W](https://openairdocs.org/aircraft/N8084W.md): Piper PA-28-180 · S/N 28-2174 · Built 1965 · Fieldgrove Matt L
- [N88778](https://openairdocs.org/aircraft/N88778.md): Cessna R172E · S/N R172-0128 · Hubbard Austin L
- [N9391W](https://openairdocs.org/aircraft/N9391W.md): Piper PA-28-235 · S/N 28-11087 · Nunez Jesus

## 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 = 'AZ' AND g.registrant_city = 'SOMERTON'
ORDER BY g.n_number
```

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