# Registered aircraft: Newcastle, WA

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

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

- [N136TM](https://openairdocs.org/aircraft/N136TM.md): Vans RV-12IS · S/N 12079 · Built 2019 · Tensfeldt Jon R
- [N138LS](https://openairdocs.org/aircraft/N138LS.md): Flight Design CTLS · S/N F-08-06-10 · Built 2008 · Melo Robert
- [N1394Y](https://openairdocs.org/aircraft/N1394Y.md): Piper PA-18-135 · S/N 18-3357 · Built 1953 · Ojendyk Mark R
- [N168N](https://openairdocs.org/aircraft/N168N.md): Eiriavion PIK 20B · S/N 20116 · Built 1976 · Lee Russell J
- [N180DJ](https://openairdocs.org/aircraft/N180DJ.md): Cessna 180 · S/N 31154 · Built 1954 · Huang Sophie M
- [N20789](https://openairdocs.org/aircraft/N20789.md): Cessna 172M · S/N 17263837 · Built 1974 · Johnson Laurel D
- [N3029F](https://openairdocs.org/aircraft/N3029F.md): Cessna 162 · S/N 16200098 · Built 2011 · M&L Flight Inc
- [N30864](https://openairdocs.org/aircraft/N30864.md): Piper J3C-65 · S/N 5157 · Shemwell David M
- [N52023](https://openairdocs.org/aircraft/N52023.md): Cessna 162 · S/N 16200014 · Built 2010 · M&L Flight Inc
- [N5211Y](https://openairdocs.org/aircraft/N5211Y.md): Cessna 162 · S/N 16200033 · Built 2011 · M&L Flight Inc
- [N5212Y](https://openairdocs.org/aircraft/N5212Y.md): Cessna 162 · S/N 16200037 · Built 2011 · M&L Flight Inc
- [N554K](https://openairdocs.org/aircraft/N554K.md): Beech 95-B55 (T42A) · S/N TC-1179 · Caux Brisebois Vincent
- [N55TP](https://openairdocs.org/aircraft/N55TP.md): Robinson Helicopter R44 II · S/N 11464 · Built 2006 · Myers Dwayne L
- [N7003A](https://openairdocs.org/aircraft/N7003A.md): Cessna 172 · S/N 29103 · Built 1956 · Huang Sophie M
- [N78310](https://openairdocs.org/aircraft/N78310.md): Globe GC-1B · S/N 2310 · Built 1946 · Huang Sophie M
- [N80291](https://openairdocs.org/aircraft/N80291.md): Cessna 172M · S/N 17266500 · Built 1975 · Davidson Doug W
- [N88AP](https://openairdocs.org/aircraft/N88AP.md): Piper PA-30 · S/N 30-456 · Built 1964 · Langdon Brian B
- [N9472N](https://openairdocs.org/aircraft/N9472N.md): Cessna A185F · S/N 18504363 · Built 1981 · Huang Sophie M

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

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