# Registered aircraft: King City, CA

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

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

- [N144RF](https://openairdocs.org/aircraft/N144RF.md): Robinson Helicopter R44 · S/N 1223 · Built 2002 · Rio Farms LLC
- [N2691B](https://openairdocs.org/aircraft/N2691B.md): Bockelman David C TEAM ROCKET F-1 · S/N 046 · Built 2005 · Prewitt Scott S
- [N42368](https://openairdocs.org/aircraft/N42368.md): Cessna 182L · S/N 18258988 · Built 1968 · Madson Chris J
- [N42PS](https://openairdocs.org/aircraft/N42PS.md): Spicer Paul E PITTS S1C · S/N 87PS · Built 1987 · Prewitt Scott S
- [N485JS](https://openairdocs.org/aircraft/N485JS.md): Scott Jerry E VANS RV-6 · S/N 23485 · Plaskett Mark G
- [N5323U](https://openairdocs.org/aircraft/N5323U.md): Cessna T210N · S/N 21064865 · Built 1984 · Rio Farms LLC
- [N532DG](https://openairdocs.org/aircraft/N532DG.md): Cessna P210N · S/N P21000829 · Built 1983 · Rio Farms LLC
- [N5358U](https://openairdocs.org/aircraft/N5358U.md): Cessna T210N · S/N 21064877 · Built 1984 · Madson Chris
- [N5756Y](https://openairdocs.org/aircraft/N5756Y.md): Piper PA-18-150 · S/N 18-8325 · Lamascus Mark S
- [N631TS](https://openairdocs.org/aircraft/N631TS.md): Cessna 550 · S/N 5500631 · Built 1990 · Lettuce Fly LLC
- [N69098](https://openairdocs.org/aircraft/N69098.md): Piper J-3 · S/N 45-4905 · Plaskett Mark G
- [N6J](https://openairdocs.org/aircraft/N6J.md): Cantrell-Pitts Special S-1C · S/N 2112 · Built 1980 · Prewitt Scott S
- [N7908B](https://openairdocs.org/aircraft/N7908B.md): Cessna 172 · S/N 29708 · Built 1957 · Francis James E
- [N831RR](https://openairdocs.org/aircraft/N831RR.md): Cessna T210R · S/N 21064994 · Built 1986 · Fresh Farms Inc
- [N9640S](https://openairdocs.org/aircraft/N9640S.md): Champion 7GCBC · S/N 6 · Built 1966 · Francis James E
- [N9704R](https://openairdocs.org/aircraft/N9704R.md): Beech M35 · S/N D-6262 · Built 1959 · Prewitt Scott S
- [N98399](https://openairdocs.org/aircraft/N98399.md): Piper J3C-65 · S/N 18586 · Built 1946 · Francis James E
- [N98780](https://openairdocs.org/aircraft/N98780.md): Piper J3C-65 · S/N 19017 · Built 1946 · Lamascus Mark S

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

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