# Registered aircraft: La Crescenta, CA

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

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

- [N1122W](https://openairdocs.org/aircraft/N1122W.md): Globe GC-1B · S/N 1234 · Built 1946 · Wittman Dennis K
- [N168NL](https://openairdocs.org/aircraft/N168NL.md): Beech 35-C33A · S/N CE-45 · Built 1966 · Lakeside Views LLC
- [N1QS](https://openairdocs.org/aircraft/N1QS.md): Cessna 172M · S/N 17265177 · Built 1975 · Universal Investment Group LLC Trustee
- [N2752Q](https://openairdocs.org/aircraft/N2752Q.md): Cessna 182K · S/N 18257952 · Built 1967 · Anspaugh Bruce E Trustee
- [N33314](https://openairdocs.org/aircraft/N33314.md): Haroutioun Harry Artsvelian VANS RV-14A · S/N 140379 · Socal Educational Projects LLC
- [N4184Q](https://openairdocs.org/aircraft/N4184Q.md): Cessna 310N · S/N 310N-0084 · Bluesky Airline LLC
- [N50868](https://openairdocs.org/aircraft/N50868.md): Cessna 150J · S/N 15069608 · Built 1968 · Krekacs Gabor
- [N5424J](https://openairdocs.org/aircraft/N5424J.md): Cessna 172N · S/N 17273788 · Built 1980 · Fusano Lisa A
- [N6003M](https://openairdocs.org/aircraft/N6003M.md): Stemme S-10 · S/N 10-15 · Built 1991 · Maheas-Smith Richard
- [N6038W](https://openairdocs.org/aircraft/N6038W.md): Beech 58 · S/N TH-1025 · Built 1979 · Didden Gary E
- [N622DX](https://openairdocs.org/aircraft/N622DX.md): Mooney M20J · S/N 24-0851 · Built 1979 · Chang Daniel H
- [N7379S](https://openairdocs.org/aircraft/N7379S.md): Cessna 182P · S/N 18265170 · Built 1976 · 818 Flyers LLC
- [N75596](https://openairdocs.org/aircraft/N75596.md): Cessna 172N · S/N 17267837 · Built 1976 · Christian Charles R
- [N79478](https://openairdocs.org/aircraft/N79478.md): Cessna 172K · S/N 17258121 · Fusano Lisa A
- [N91689](https://openairdocs.org/aircraft/N91689.md): North American NAVION · S/N NAV4431 · Built 1946 · Young Kurt P

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

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