# Registered aircraft: Claremont, CA

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

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

- [N103BH](https://openairdocs.org/aircraft/N103BH.md): David Lenart BEARHAWK COMPANION · S/N 3C-5C/6C-1613C · Built 2021 · Beck Randy R
- [N20124](https://openairdocs.org/aircraft/N20124.md): Cessna 177B · S/N 17702631 · Built 1977 · Cerven Bohuslav Bo
- [N2617R](https://openairdocs.org/aircraft/N2617R.md): Cessna 182K · S/N 18258317 · Built 1967 · Fener Seth M
- [N26X](https://openairdocs.org/aircraft/N26X.md): Rolladen-Schneider LS-3 · S/N 3002 · Built 1977 · Cangahuala Laureano A
- [N3823R](https://openairdocs.org/aircraft/N3823R.md): Cessna 172H · S/N 17255323 · Built 1966 · Electra-Vision Advertising Corp
- [N4122H](https://openairdocs.org/aircraft/N4122H.md): Mooney M20J · S/N 24-0645 · Built 1978 · Beck Randy R
- [N4355W](https://openairdocs.org/aircraft/N4355W.md): Beech B24R · S/N MC-271 · Built 1974 · Frieson Steven B
- [N44AB](https://openairdocs.org/aircraft/N44AB.md): Mooney M20F · S/N 22-1196 · Built 1975 · Anthony Ronald W
- [N44RZ](https://openairdocs.org/aircraft/N44RZ.md): Laister Sailplane Products LP-49 · S/N K-44 · Strengell Eric P
- [N46302](https://openairdocs.org/aircraft/N46302.md): Cessna 172M · S/N 17264181 · Built 1974 · Jones Lehman M
- [N4658G](https://openairdocs.org/aircraft/N4658G.md): Cessna 172N · S/N 17273284 · First renewal notice · Global Aviators Academy Inc
- [N6151R](https://openairdocs.org/aircraft/N6151R.md): Cessna T210F · S/N T210-0051 · Built 1965 · Path Barney H DBA
- [N6426V](https://openairdocs.org/aircraft/N6426V.md): Cessna 172RG · S/N 172RG0687 · Global Aviators Academy Inc
- [N6817P](https://openairdocs.org/aircraft/N6817P.md): Piper PA-24-180 · S/N 24-1950 · Plummer Seth
- [N6832W](https://openairdocs.org/aircraft/N6832W.md): Piper PA-28-140 · S/N 28-20973 · Litchfield Bobby Lee
- [N69149](https://openairdocs.org/aircraft/N69149.md): Cessna 152 · S/N 15282514 · Built 1978 · Joyner Carol M
- [N737SK](https://openairdocs.org/aircraft/N737SK.md): Cessna 172N · S/N 17269638 · Global Aviators Academy Inc
- [N7642G](https://openairdocs.org/aircraft/N7642G.md): Cessna 172L · S/N 17259342 · Built 1970 · Air Petunia
- [N82525](https://openairdocs.org/aircraft/N82525.md): Piper PA-28RT-201T · S/N 28R-8231068 · Built 1982 · Bravo Zulu Aero LLC
- [N8435Y](https://openairdocs.org/aircraft/N8435Y.md): Piper PA-30 · S/N 30-1595 · Global Aviators Academy Inc
- [N854R](https://openairdocs.org/aircraft/N854R.md): Beech 35-33 · S/N CD-7 · Built 1959 · Wiencek Stephen John
- [N9387V](https://openairdocs.org/aircraft/N9387V.md): Mooney M20F · S/N 700018 · Built 1969 · Pabst Erik R
- [N9559Z](https://openairdocs.org/aircraft/N9559Z.md): Ryan NAVION A · S/N NAV-4-1320 · Built 1948 · Kanakis Nicholas G

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

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