# Registered aircraft: Diamond Bar, CA

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

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

- [N114MM](https://openairdocs.org/aircraft/N114MM.md): Rockwell International 114 · S/N 14380 · Schwabenbauer Theodore J
- [N1207U](https://openairdocs.org/aircraft/N1207U.md): Cessna 172M · S/N 17266906 · Kasakoff Lloyd
- [N172FT](https://openairdocs.org/aircraft/N172FT.md): Cessna 172N · S/N 17270486 · Airlink California LLC
- [N1963N](https://openairdocs.org/aircraft/N1963N.md): Gulfstream Aerospace GIV-X (G450) · S/N 4268 · Built 2012 · Water Force One LLC
- [N202GE](https://openairdocs.org/aircraft/N202GE.md): Mooney M20C · S/N 2896 · Built 1964 · St Amant Mark S
- [N33UU](https://openairdocs.org/aircraft/N33UU.md): Rolladen-Schneider OHG LS3-A · S/N 3444 · Built 1980 · Gallego Javier
- [N40451](https://openairdocs.org/aircraft/N40451.md): Piper PA-28-161 · S/N 28-7816015 · Built 1977 · Gallego Javier
- [N4313J](https://openairdocs.org/aircraft/N4313J.md): Piper PA-28-140 · S/N 28-22686 · Paul Eric S
- [N47323](https://openairdocs.org/aircraft/N47323.md): Piper PA-28-161 · S/N 28-7816058 · Built 1977 · Danaha Jerry E
- [N574CZ](https://openairdocs.org/aircraft/N574CZ.md): Bernard K Siu CZ1100 · S/N 1 · Built 2016 · Siu Bernard K
- [N63NB](https://openairdocs.org/aircraft/N63NB.md): Gulfstream Aerospace GVII-G600 · S/N 73040 · Built 2020 · Water Force One LLC
- [N63NW](https://openairdocs.org/aircraft/N63NW.md): Gulfstream Aerospace GVII-G600 · S/N 73182 · Built 2025 · Water Force One LLC
- [N6LL](https://openairdocs.org/aircraft/N6LL.md): Mooney M20K · S/N 25-0698 · Kasakoff Lloyd
- [N7244B](https://openairdocs.org/aircraft/N7244B.md): Beech J35 · S/N D-5612 · Built 1958 · Rech Jack R
- [N7244P](https://openairdocs.org/aircraft/N7244P.md): Piper PA-24-250 · S/N 24-2418 · Built 1961 · Paden Stanley R
- [N9005P](https://openairdocs.org/aircraft/N9005P.md): Piper PA-24-260 · S/N 24-4466 · Kasakoff Lloyd
- [N9332M](https://openairdocs.org/aircraft/N9332M.md): Mooney M20E · S/N 1264 · Kasakoff Lloyd

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

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