# Registered aircraft: Willits, CA

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

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

- [N170BE](https://openairdocs.org/aircraft/N170BE.md): Cessna 170B · S/N 25752 · Smith Michael E
- [N2099X](https://openairdocs.org/aircraft/N2099X.md): Cessna 182H · S/N 18256199 · Built 1965 · Green Glen A
- [N2599D](https://openairdocs.org/aircraft/N2599D.md): Cessna 170B · S/N 20751 · Built 1952 · Smith Michael E
- [N2P](https://openairdocs.org/aircraft/N2P.md): Milton PAZMANY PL-2 · S/N 31 · Madsen Michael T
- [N35032](https://openairdocs.org/aircraft/N35032.md): Cessna 177B · S/N 17702168 · Built 1974 · Galten Banning D
- [N4222J](https://openairdocs.org/aircraft/N4222J.md): Piper PA-28-140 · S/N 28-22570 · Herrera Justin C
- [N4581H](https://openairdocs.org/aircraft/N4581H.md): Piper PA-15 · S/N 15-355 · Built 1948 · Henderson Drake S
- [N476KE](https://openairdocs.org/aircraft/N476KE.md): Cessna 182P · S/N 18264067 · Built 1975 · Trexel Paul C
- [N501DS](https://openairdocs.org/aircraft/N501DS.md): Cessna 182J · S/N 18257193 · Built 1966 · Chilson Jacob Shane
- [N5145E](https://openairdocs.org/aircraft/N5145E.md): Cessna 172N · S/N 17271735 · Sierra Pacific Aviation
- [N5265X](https://openairdocs.org/aircraft/N5265X.md): Champion 7GCBC · S/N 124 · Built 1969 · Swanton Peter K
- [N5693R](https://openairdocs.org/aircraft/N5693R.md): Enstrom Helicopter 280C · S/N 1194 · Waters Willie Frank Jr
- [N5731C](https://openairdocs.org/aircraft/N5731C.md): Cessna 170A · S/N 19685 · Built 1951 · Smith Michael E
- [N6750M](https://openairdocs.org/aircraft/N6750M.md): Cessna 182P · S/N 18263822 · Built 1975 · Herrejon Rene
- [N77881](https://openairdocs.org/aircraft/N77881.md): Luscombe 8A · S/N 3608 · Built 1946 · Ramsey Cody M
- [N8404Z](https://openairdocs.org/aircraft/N8404Z.md): Cessna 210-5 · S/N 205-0404 · Built 1963 · Smith Michael E
- [N89529](https://openairdocs.org/aircraft/N89529.md): Cessna 140 · S/N 8565 · Built 1946 · Johnson Ryan
- [N98509](https://openairdocs.org/aircraft/N98509.md): Piper J3C-65 · S/N 18712 · Built 1946 · Swanton Peter K

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

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