# Registered aircraft: Newcastle, CA

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

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

- [N1559R](https://openairdocs.org/aircraft/N1559R.md): Grumman American Avn. AA-5B · S/N AA5B-0059 · Built 1975 · Moore Kira G
- [N16222](https://openairdocs.org/aircraft/N16222.md): Cessna 150L · S/N 15073554 · Built 1972 · Thumser Douglas Francis
- [N29MK](https://openairdocs.org/aircraft/N29MK.md): Koblis Martin H BABY ACE D · S/N 1 · Built 1986 · Nelson Gregory J
- [N3187C](https://openairdocs.org/aircraft/N3187C.md): Cessna 180 · S/N 30986 · Built 1954 · Hemm Colby L
- [N3961T](https://openairdocs.org/aircraft/N3961T.md): Piper PA-28R-180 · S/N 28R-30306 · Built 1967 · Martin Noah R
- [N44WT](https://openairdocs.org/aircraft/N44WT.md): Timmons W S/Timmons N A VANS RV 6A · S/N 23178 · Built 2002 · Moore Arlon A
- [N52156](https://openairdocs.org/aircraft/N52156.md): Cessna 177RG · S/N 177RG1180 · Built 1977 · Rbl Missions LLC
- [N5463D](https://openairdocs.org/aircraft/N5463D.md): Beech H35 · S/N D-4959 · Built 1957 · Blanco Austin
- [N5926D](https://openairdocs.org/aircraft/N5926D.md): Piper PA-22-150 · S/N 22-4589 · Built 1956 · Toste Greg
- [N7380W](https://openairdocs.org/aircraft/N7380W.md): Piper PA-28-180 · S/N 28-1263 · Built 1963 · Rohlfes David M
- [N7398L](https://openairdocs.org/aircraft/N7398L.md): Cessna A152 · S/N A1520815 · Built 1978 · Nelson Gregory J
- [N7684F](https://openairdocs.org/aircraft/N7684F.md): Piper PA-28-151 · S/N 28-7715238 · Lettunich Mitchell C
- [N7954G](https://openairdocs.org/aircraft/N7954G.md): Cessna 172L · S/N 17259654 · Built 1970 · No Squawks LLC
- [N8134Q](https://openairdocs.org/aircraft/N8134Q.md): Cessna 414 · S/N 414-0034 · Built 1969 · Paul Morrill Excavating Inc
- [N8392D](https://openairdocs.org/aircraft/N8392D.md): Beech J35 · S/N D-5519 · Built 1958 · Thumser Douglas F
- [N8450S](https://openairdocs.org/aircraft/N8450S.md): Piper PA-28-181 · S/N 28-8290043 · Built 1981 · Kyle Steven L
- [N95DR](https://openairdocs.org/aircraft/N95DR.md): Ross Dan G RV8A · S/N 82434 · Built 2010 · Ross Dan G
- [N96BW](https://openairdocs.org/aircraft/N96BW.md): Jones R C/Spratford W KITFOX III · S/N 1209 · Built 1996 · Hunter Kinerly E N

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

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