# Registered aircraft: Sonora, CA

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

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

- [N100WA](https://openairdocs.org/aircraft/N100WA.md): Cessna 172E · S/N 17251499 · Built 1964 · Alcorn Stanley R
- [N135JL](https://openairdocs.org/aircraft/N135JL.md): Beech G35 · S/N D-4419 · Built 1955 · Burhoe Aaron D
- [N17RN](https://openairdocs.org/aircraft/N17RN.md): Piper PA-28-181 · S/N 28-7790162 · Built 1976 · Ogopogo Foundation
- [N1818N](https://openairdocs.org/aircraft/N1818N.md): Cessna 120 · S/N 12062 · Built 1946 · Firth Thomas H IV
- [N2212G](https://openairdocs.org/aircraft/N2212G.md): Boeing N2S-3 · S/N 75-7525 · Built 1942 · Segerstrom William C
- [N2869Q](https://openairdocs.org/aircraft/N2869Q.md): Cessna 172L · S/N 17259869 · Built 1971 · Durnall Daniel J
- [N2923L](https://openairdocs.org/aircraft/N2923L.md): Mooney M20F · S/N 670317 · Built 1967 · Hess Daniel G
- [N2966N](https://openairdocs.org/aircraft/N2966N.md): Cessna 120 · S/N 13224 · Built 1947 · Segerstrom Erik M
- [N36425](https://openairdocs.org/aircraft/N36425.md): Taylorcraft BC-65 · S/N 3241 · Built 1941 · Hayes James R
- [N3747L](https://openairdocs.org/aircraft/N3747L.md): Cessna 172G · S/N 17253916 · Built 1965 · N3747l LLC
- [N3CM](https://openairdocs.org/aircraft/N3CM.md): Cessna T337G · S/N P337-0025 · Built 1972 · Oxbow Investments LLC
- [N3XS](https://openairdocs.org/aircraft/N3XS.md): Prill Charles CP-6 · S/N C001 · Built 1996 · Brewer Joshua Ryan
- [N40763](https://openairdocs.org/aircraft/N40763.md): Piper J3C-65 · S/N 7476 · Built 1941 · Scheftner Tonya R
- [N42484](https://openairdocs.org/aircraft/N42484.md): Cessna 182L · S/N 18259035 · Hiemstra Ralph W
- [N4315B](https://openairdocs.org/aircraft/N4315B.md): Cessna 170B · S/N 26659 · Built 1955 · Mckamey Dave S
- [N43526](https://openairdocs.org/aircraft/N43526.md): Piper PA-28R-200 · S/N 28R-7435277 · Built 1974 · Wittman Jeffrey A
- [N477BP](https://openairdocs.org/aircraft/N477BP.md): Peltola Brad H VANS RV-8 · S/N 80477 · Built 2005 · Wooden Rick D
- [N4850L](https://openairdocs.org/aircraft/N4850L.md): Piper PA-28-180 · S/N 28-4199 · Built 1967 · Upper Airway Aviation LLC
- [N5280N](https://openairdocs.org/aircraft/N5280N.md): Boeing E75 · S/N 755790 · Built 1949 · Bautista Mark S
- [N5363Q](https://openairdocs.org/aircraft/N5363Q.md): Cessna T182T · S/N T18208203 · Built 2003 · Cary Gosney Crna Inc
- [N5895D](https://openairdocs.org/aircraft/N5895D.md): Piper PA-18 · S/N 18-5404 · Built 1956 · Ogg Kevin
- [N61159](https://openairdocs.org/aircraft/N61159.md): Cessna 150J · S/N 15070847 · Built 1969 · Stenger D James Trustee
- [N6836X](https://openairdocs.org/aircraft/N6836X.md): Cessna 172A · S/N 47736 · Built 1960 · Nelson John D
- [N69Z](https://openairdocs.org/aircraft/N69Z.md): Phillips STEEN SKYBOLT · S/N 200-2 · Built 1977 · Mckamey Dave S
- [N7160L](https://openairdocs.org/aircraft/N7160L.md): Grumman American Avn. AA-5 · S/N AA5-0460 · Huntley Michael E
- [N72398](https://openairdocs.org/aircraft/N72398.md): Cessna 140 · S/N 9584 · Built 1946 · Brewer Joshua R
- [N7279B](https://openairdocs.org/aircraft/N7279B.md): Cessna 182S · S/N 18280542 · Bautista Mark S
- [N735SW](https://openairdocs.org/aircraft/N735SW.md): Cessna 182T · S/N 18281240 · Built 2003 · 5 Sierra Whiskey LLC
- [N77281](https://openairdocs.org/aircraft/N77281.md): Cessna 120 · S/N 11723 · Hiemstra Thomas R
- [N80458](https://openairdocs.org/aircraft/N80458.md): Cessna 172M · S/N 17266597 · Built 1976 · Kolpack Glenn H
- [N80SB](https://openairdocs.org/aircraft/N80SB.md): Lippert Barry M MA-5 CHARGER · S/N 0062 · Built 1980 · Brewer Renner L Jr
- [N8151A](https://openairdocs.org/aircraft/N8151A.md): Cessna 170B · S/N 25003 · Built 1952 · Hayes James R
- [N8372U](https://openairdocs.org/aircraft/N8372U.md): Piper PA-34-220T · S/N 34-8133070 · Built 1981 · Ogopogo Foundation
- [N84029](https://openairdocs.org/aircraft/N84029.md): Aeronca 7AC · S/N 7AC-2716 · Built 1946 · Chase Michael D
- [N8514Y](https://openairdocs.org/aircraft/N8514Y.md): Piper PA-30 · S/N 30-1675 · Built 1967 · Mcnally Rodney
- [N9122Z](https://openairdocs.org/aircraft/N9122Z.md): Bell 212 · S/N 30716 · Built 1975 · Intermountain Helicopter Inc
- [N97986](https://openairdocs.org/aircraft/N97986.md): Stinson 108-1 · S/N 108-986 · Built 1946 · Steinbrink Robert
- [N9934E](https://openairdocs.org/aircraft/N9934E.md): Cessna 182P · S/N 18263994 · Built 1975 · Stenger D James Trustee

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

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