# Registered aircraft: Mount Shasta, CA

A list on [Mount Shasta, CA](https://openairdocs.org/faa-place/CA/Mount%20Shasta.md).

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

- [N143JH](https://openairdocs.org/aircraft/N143JH.md): Aeropro CZ EUROFOX LSA · S/N 21106 · Built 2006 · Hinojosa David M
- [N17NT](https://openairdocs.org/aircraft/N17NT.md): Valentin TAIFUN 17E · S/N 1046 · Ireland Robert C
- [N21711](https://openairdocs.org/aircraft/N21711.md): Cessna 172M · S/N 17263992 · Williams Roger P III Trustee
- [N22PM](https://openairdocs.org/aircraft/N22PM.md): Berkshire Mfg. CONCEPT 70 · S/N 9 · Ireland Robert C
- [N2575G](https://openairdocs.org/aircraft/N2575G.md): Cessna 182B · S/N 51875 · Built 1959 · Altes Matt
- [N36VU](https://openairdocs.org/aircraft/N36VU.md): Raytheon A36 · S/N E-3449 · Built 2002 · Thomas Gary F
- [N476MS](https://openairdocs.org/aircraft/N476MS.md): Cessna 150M · S/N 15077515 · Brooks Duane T Trustee
- [N5752B](https://openairdocs.org/aircraft/N5752B.md): Cessna 182 · S/N 33752 · Built 1956 · Wallace Thad Joseph
- [N6084E](https://openairdocs.org/aircraft/N6084E.md): Beech K35 · S/N D-6097 · Built 1959 · Margart Geoffrey W
- [N6370W](https://openairdocs.org/aircraft/N6370W.md): Piper PA-28-140 · S/N 28-20431 · Built 1964 · Peterson Lawrence T
- [N661DD](https://openairdocs.org/aircraft/N661DD.md): Cessna 150H · S/N 15067508 · Hanisko Thomas F
- [N7128E](https://openairdocs.org/aircraft/N7128E.md): Cessna 182B · S/N 52128 · First renewal notice · Built 1959 · Schlumpberger Charles P
- [N75513](https://openairdocs.org/aircraft/N75513.md): Cessna 172N · S/N 17267773 · Built 1976 · Baird David J
- [N8000K](https://openairdocs.org/aircraft/N8000K.md): Stinson 108-2 · S/N 108-3000 · Gudgel Shannon L
- [N989JB](https://openairdocs.org/aircraft/N989JB.md): Bigham Jack L MONTANA COYOTE · S/N 9810 · Built 1998 · Altes Matthew C
- [N994JB](https://openairdocs.org/aircraft/N994JB.md): Cessna T182T · S/N T18208680 · Built 2007 · Eddy Peter J

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

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