# Cancelled registrations: Diamond Bar, CA

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

Cancelled aircraft registrations in Diamond Bar, CA.

- [N380A](https://openairdocs.org/deregistered/N380A-2025-02-15.md): Mooney M-18L · S/N 41 · Cancelled Feb 15, 2025 · Registration pending, canceled · Built 1949
- [N704NV](https://openairdocs.org/deregistered/N704NV-2024-06-15.md): Cessna 150M · S/N 15078751 · Cancelled Jun 15, 2024 · Sale reported, canceled · Built 1976
- [N727NQ](https://openairdocs.org/deregistered/N727NQ-2023-01-14.md): Boeing 727-200 · S/N 20600 · Cancelled Jan 14, 2023 · Sale reported, canceled
- [N3117X](https://openairdocs.org/deregistered/N3117X-2019-11-29.md): Cessna 150F · S/N 15064517 · Cancelled Nov 29, 2019 · Revoked, canceled · Built 1966 · Carson Howe Jr
- [N5528P](https://openairdocs.org/deregistered/N5528P-2018-08-22.md): Cessna 152 · S/N 15284968 · Cancelled Aug 22, 2018 · First renewal notice · Built 1981 · Griggs Bill W Jr
- [N659VR](https://openairdocs.org/deregistered/N659VR-2018-05-31.md): Robot & Vision R4 QUAD · S/N R4Q2015-102 · Cancelled May 31, 2018 · Sale reported, canceled
- [N55188](https://openairdocs.org/deregistered/N55188-2017-06-21.md): Convair BT-13B · S/N 79-1479 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Medore Dorothy
- [N79045](https://openairdocs.org/deregistered/N79045-2017-02-28.md): Convair BT-13 · S/N 6717 · Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1942 · Medore Dorothy
- [N2069T](https://openairdocs.org/deregistered/N2069T-2015-05-20.md): North American/Medore ART NA AT-6G · S/N 51-14872-1AM · Cancelled May 20, 2015 · Registration expired, pending cancellation · Twin-D-Enterprises Inc
- [N56513](https://openairdocs.org/deregistered/N56513-2015-05-06.md): Piper PA-28-140 · S/N 28-73-25646 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1973 · Bartlett Jess C
- [N3431V](https://openairdocs.org/deregistered/N3431V-2015-04-30.md): Cessna 195 · S/N 7116 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1948 · Mcafee Stephen C
- [N20674](https://openairdocs.org/deregistered/N20674-2013-07-29.md): North American/Medore ART NA AT-6G · S/N 51-14421-1AM · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Sabens Marilyn M
- [N1893R](https://openairdocs.org/deregistered/N1893R-2012-08-14.md): Raven Industries RX6 · S/N RX6-277 · Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Built 1978 · Hughes Douglas
- [N1367S](https://openairdocs.org/deregistered/N1367S-2009-06-30.md): Cessna 182P · S/N 18264930 · Cancelled Jun 30, 2009 · Registration revoked · Built 1976 · Long John R Jr
- [N2067E](https://openairdocs.org/deregistered/N2067E-2006-06-02.md): North American/Medore ART NA AT6-F · S/N 44-81648-1AM · Cancelled Jun 2, 2006 · Triennial form not returned · Medore Art
- [N2067V](https://openairdocs.org/deregistered/N2067V-2006-06-02.md): North American/Medore ART NA AT-6G · S/N 51-14373-1AM · Cancelled Jun 2, 2006 · Triennial form not returned · Medore Art
- [N20683](https://openairdocs.org/deregistered/N20683-2006-06-02.md): North American/Medore ART NA AT-6G · S/N 51-14462-1AM · Cancelled Jun 2, 2006 · Triennial form not returned · Medore Art
- [N6552R](https://openairdocs.org/deregistered/N6552R-1997-03-14.md): North American T-39A · S/N 624453 · Cancelled Mar 14, 1997 · Exported to Mexico · Wong Thomas F
- [N6976P](https://openairdocs.org/deregistered/N6976P-1997-02-06.md): Piper PA-24-250 · S/N 242119 · Cancelled Feb 6, 1997 · Triennial form not returned · Jensen Leroy H
- [N3052V](https://openairdocs.org/deregistered/N3052V-1997-01-21.md): Beech 35 · S/N D465 · Cancelled Jan 21, 1997 · Triennial form not returned · Fulmer James P
- [N8117E](https://openairdocs.org/deregistered/N8117E-1992-08-21.md): Mooney M20 · S/N 1388 · Cancelled Aug 21, 1992 · Triennial form not returned · Hoyer Karl DBA
- [N321BC](https://openairdocs.org/deregistered/N321BC-1991-06-11.md): Cessna 177B · S/N 17701446 · Cancelled Jun 11, 1991 · Triennial form not returned · Mooney Edwin D
- [N3320R](https://openairdocs.org/deregistered/N3320R-1982-07-22.md): Cessna 182L · S/N 18258620 · Cancelled Jul 22, 1982 · Testerman Ward D & Testerman Susan W
- [N7621X](https://openairdocs.org/deregistered/N7621X-1974-08-13.md): Cessna 172B · S/N 17248121 · Cancelled Aug 13, 1974 · Glatz Edward G

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'CA' AND d.registrant_city = 'DIAMOND BAR'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/CA/Diamond%20Bar/earlier

---
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.