# Registered aircraft: Cloverdale, CA

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

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

- [N121SK](https://openairdocs.org/aircraft/N121SK.md): Mooney M20J · S/N 24-0901 · Built 1979 · Rege Robert E
- [N197CM](https://openairdocs.org/aircraft/N197CM.md): Cirrus Design SR22T · S/N 1723 · Built 2018 · Lester Labs LLC
- [N2419B](https://openairdocs.org/aircraft/N2419B.md): Temco GC-1B · S/N 3719 · Fenn Michael J
- [N28288](https://openairdocs.org/aircraft/N28288.md): Grumman American Avn. AA-5B · S/N AA5B0528 · Built 1977 · Coughlan William J
- [N2850R](https://openairdocs.org/aircraft/N2850R.md): Cessna 182K · S/N 18258450 · Built 1967 · Norcal Skydiving LLC
- [N2871U](https://openairdocs.org/aircraft/N2871U.md): Cessna 172D · S/N 17250471 · St Clair Dustin W
- [N317ST](https://openairdocs.org/aircraft/N317ST.md): Scott Stewart ZODIAC CH 640 · S/N 0092 · Built 2014 · Stewart Scott R
- [N31823](https://openairdocs.org/aircraft/N31823.md): Almquist Robert L CUBY · S/N 1164 · Rankin Bryan A
- [N442EP](https://openairdocs.org/aircraft/N442EP.md): Peterson Erik J MAVERIK · S/N PA-14 · Peterson Erik J
- [N653D](https://openairdocs.org/aircraft/N653D.md): Beech C35 · S/N D-2920 · Built 1951 · Price Gary E
- [N6864R](https://openairdocs.org/aircraft/N6864R.md): Cessna T210G · S/N T210-0264 · Built 1967 · Rankin Bryan
- [N701JV](https://openairdocs.org/aircraft/N701JV.md): Mcelheran James M CH 701 · S/N 7-6875 · Built 2012 · Gromala Ivan A
- [N750WG](https://openairdocs.org/aircraft/N750WG.md): Ivan Gromala ZENITH CH 750 STOL · S/N 75-10470 · Gromala Ivan
- [N76506](https://openairdocs.org/aircraft/N76506.md): Cessna 120 · S/N 10938 · Built 1946 · Zucker Paul A
- [N7664J](https://openairdocs.org/aircraft/N7664J.md): Piper PA-28R-180 · S/N 28R-31063 · Built 1970 · True Arrow Aviation LLC
- [N8004S](https://openairdocs.org/aircraft/N8004S.md): Cessna 150F · S/N 15061604 · Rege Bill
- [N81346](https://openairdocs.org/aircraft/N81346.md): Fairchild 24W-46 · S/N W46246 · Built 1946 · Vos Jared C
- [N8393C](https://openairdocs.org/aircraft/N8393C.md): Piper PA-28-181 · S/N 28-7690131 · Built 1976 · Andersen Robin L
- [N914AV](https://openairdocs.org/aircraft/N914AV.md): Cessna 182G · S/N 18255445 · Built 1964 · Norcal Skydiving LLC
- [N95VK](https://openairdocs.org/aircraft/N95VK.md): Kidd K/Vanvoorhis B/Krebs W VANS RV-7 · S/N 72917 · Vos Jared C

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

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