# Registered aircraft: Mammoth Lakes, CA

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

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

- [N201YV](https://openairdocs.org/aircraft/N201YV.md): Mooney M20J · S/N 24-0528 · Built 1978 · May Richard B
- [N207RP](https://openairdocs.org/aircraft/N207RP.md): Mooney M20K · S/N 25-2009 · Allen Brent H
- [N247CP](https://openairdocs.org/aircraft/N247CP.md): Cirrus Design SR22 · S/N 3166 · Built 2008 · Tl Sierra Properties LLC
- [N29138](https://openairdocs.org/aircraft/N29138.md): Cessna T210L · S/N 21059815 · Built 1973 · Allen Brent H
- [N29508](https://openairdocs.org/aircraft/N29508.md): Taylorcraft BL-65 · S/N 2351 · Built 1940 · Jacob Trevor
- [N3327T](https://openairdocs.org/aircraft/N3327T.md): Cessna 177 · S/N 17700627 · Friedl Robert Stephen Jr
- [N376PD](https://openairdocs.org/aircraft/N376PD.md): Lancair LC41-550FG · S/N 41018 · Built 2004 · Striplin Donald B
- [N4611W](https://openairdocs.org/aircraft/N4611W.md): Rockwell International 112TC · S/N 13101 · Phillips James E
- [N4916L](https://openairdocs.org/aircraft/N4916L.md): Piper PA-28-180 · S/N 28-4281 · Built 1967 · Ml Monkeybar Inc
- [N5764S](https://openairdocs.org/aircraft/N5764S.md): Mooney M20K · S/N 25-0831 · Built 1984 · Alianza Development Inc
- [N6421Q](https://openairdocs.org/aircraft/N6421Q.md): Mooney M20F · S/N 670500 · Built 1967 · Shine Christopher A
- [N6752X](https://openairdocs.org/aircraft/N6752X.md): Beech 58P · S/N TJ-276 · Built 1980 · Iyer Vijay
- [N67DL](https://openairdocs.org/aircraft/N67DL.md): Piper PA-28-140 · S/N 28-25605 · Mcarthur Narik D
- [N761YS](https://openairdocs.org/aircraft/N761YS.md): Cessna T210M · S/N 21062630 · Built 1978 · Thompson Gary P
- [N79DS](https://openairdocs.org/aircraft/N79DS.md): Beech B36TC · S/N EA-326 · Built 1982 · Bonanza Air Ventures LLC
- [N87CZ](https://openairdocs.org/aircraft/N87CZ.md): Dahl/Hintz/Ehlis COZY · S/N 104 · Built 1988 · Scotese Attilio G
- [N92020](https://openairdocs.org/aircraft/N92020.md): Cessna 182M · S/N 18260006 · Built 1969 · Domaille Dennis C
- [N9246M](https://openairdocs.org/aircraft/N9246M.md): Piper PA 46-350P · S/N 4622149 · Built 1993 · Shenkirsch Consulting Inc
- [N9555X](https://openairdocs.org/aircraft/N9555X.md): Cessna 182P · S/N 18263495 · Built 1974 · Walker Scott

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

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