# Registered aircraft: Crestline, CA

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

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

- [N101YT](https://openairdocs.org/aircraft/N101YT.md): Piper PA-28-235 · S/N 28-7310080 · Built 1973 · Jagt Terrence L
- [N10593](https://openairdocs.org/aircraft/N10593.md): Piper L-21A · S/N 18-893 · Built 1958 · Jones Thomas E
- [N11732](https://openairdocs.org/aircraft/N11732.md): Cessna 150L · S/N 15075598 · Built 1974 · Lewis Nathan Alan
- [N119WG](https://openairdocs.org/aircraft/N119WG.md): Agusta A119 · S/N 14502 · Built 2005 · High Performance Helicopters Corp
- [N21EX](https://openairdocs.org/aircraft/N21EX.md): Extra Flugzeugbau EA-300 · S/N 044 · Built 1993 · Jones Thomas E
- [N331DA](https://openairdocs.org/aircraft/N331DA.md): Kearbey Robert E QUICKSILVER MXLII · S/N RAS19 · Bonham Brett A
- [N3772K](https://openairdocs.org/aircraft/N3772K.md): Globe GC-1B · S/N 1465 · Sale reported · Built 1946
- [N430ST](https://openairdocs.org/aircraft/N430ST.md): Bell 430 · S/N 49071 · Built 2000 · High Performance Helicopters Corp
- [N430W](https://openairdocs.org/aircraft/N430W.md): Bell 430 · S/N 49086 · Built 2001 · 430w LLC
- [N4472](https://openairdocs.org/aircraft/N4472.md): Sikorsky EH-60A · S/N 85-24472 · High Performance Helicopters Corp
- [N513PF](https://openairdocs.org/aircraft/N513PF.md): Wsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0513 · Freeland Pete L
- [N5835P](https://openairdocs.org/aircraft/N5835P.md): Piper PA-24-250 · S/N 24-916 · Loya Francisco
- [N6757S](https://openairdocs.org/aircraft/N6757S.md): Cessna 150H · S/N 15067557 · Loya Francisco
- [N7094C](https://openairdocs.org/aircraft/N7094C.md): Robinson Helicopter R44 II · S/N 14041 · Built 2017 · Eternity Helicopters LLC
- [N7894T](https://openairdocs.org/aircraft/N7894T.md): Cessna 172A · S/N 47494 · Built 1960 · Griggs Howard D
- [N8286](https://openairdocs.org/aircraft/N8286.md): Sikorsky UH-60A · S/N 79-23286 · Built 1979 · High Performance Helicopters Corp
- [N847SP](https://openairdocs.org/aircraft/N847SP.md): Piper PA-24-400 · S/N 26-48 · Built 1964 · Rothschild Joel S
- [N874](https://openairdocs.org/aircraft/N874.md): Bell UH-1H · S/N 65-12874 · Built 1965 · High Performance Helicopters Corp
- [N966X](https://openairdocs.org/aircraft/N966X.md): Bell Helicopter Textron 212 · S/N 30966 · Built 1979 · Bh212966 LLC

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

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