# Registered aircraft: Alta Loma, CA

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

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

- [N20051](https://openairdocs.org/aircraft/N20051.md): Cessna 172M · S/N 17260963 · Built 1972 · Hayek Pierre N
- [N201DQ](https://openairdocs.org/aircraft/N201DQ.md): Mooney M20J · S/N 24-0091 · Built 1977 · Brande Lewis
- [N213TJ](https://openairdocs.org/aircraft/N213TJ.md): Newsome Timothy S BEARHAWK · S/N 2B-3B/4B-1437B · Built 2020 · Newsome Timothy S
- [N213TP](https://openairdocs.org/aircraft/N213TP.md): Newsome Timothy S RV-7 · S/N 71897 · Built 2014 · Newsome Timothy S
- [N2229W](https://openairdocs.org/aircraft/N2229W.md): Piper PA-28-236 · S/N 28-8111084 · Built 1981 · Cook Arlyn L
- [N2796D](https://openairdocs.org/aircraft/N2796D.md): Cessna 170B · S/N 25338 · Built 1952 · France Gregory G
- [N3144J](https://openairdocs.org/aircraft/N3144J.md): Cessna 150G · S/N 15065844 · Built 1966 · Chaffey Union Junior College District
- [N3796R](https://openairdocs.org/aircraft/N3796R.md): Cessna 172H · S/N 17255596 · Schapiro Alan R
- [N4838K](https://openairdocs.org/aircraft/N4838K.md): Cessna P210N · S/N P21000341 · Built 1979 · Commercial Tenant Improvement Corp
- [N614BD](https://openairdocs.org/aircraft/N614BD.md): Balloon Works FIREFLY 8B · S/N F8B-496 · Graham Keith P
- [N622RM](https://openairdocs.org/aircraft/N622RM.md): Cirrus Design SR22T · S/N 9797 · Built 2024 · Mountain Avenue Bees Inc
- [N6278U](https://openairdocs.org/aircraft/N6278U.md): Mooney M20C · S/N 2117 · Built 1962 · Harney Michael E
- [N72528](https://openairdocs.org/aircraft/N72528.md): Balloon Works FIREFLY 7-15 · S/N F7-1097 · Graham Keith P
- [N73864](https://openairdocs.org/aircraft/N73864.md): Cessna 172N · S/N 17267729 · Built 1976 · Martz Richard W
- [N74196](https://openairdocs.org/aircraft/N74196.md): Balloon Works FIREFLY 7 · S/N F7-285 · Graham Keith P
- [N75964](https://openairdocs.org/aircraft/N75964.md): North American SNJ-4 · S/N 88-9830 · Built 1943 · Nightingale William T
- [N797CX](https://openairdocs.org/aircraft/N797CX.md): Cessna 750 · S/N 750-0297 · Built 2009 · Fmat Inc
- [N808FL](https://openairdocs.org/aircraft/N808FL.md): Brand Richard J FLAME LILY · S/N SHEKARI-0010-516 · Built 2001 · Brand Richard Jr
- [N8572M](https://openairdocs.org/aircraft/N8572M.md): Beech P35 · S/N D-7217 · Signor Jeff R
- [N94157](https://openairdocs.org/aircraft/N94157.md): Engineering & Research ERCOUPE 415-C · S/N 1480 · Built 1946 · Coles Nathan A
- [N942V](https://openairdocs.org/aircraft/N942V.md): Beech A36 · S/N E-715 · Endeavor Enterprises LLC

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

This list as a web page: https://openairdocs.org/faa-place/CA/Alta%20Loma/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, except the copies of manufacturers’ service documents, which belong to their rights holders.