# Cancelled registrations: Rosemead, CA

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

Cancelled aircraft registrations in Rosemead, CA.

- [N31SB](https://openairdocs.org/deregistered/N31SB-2023-08-16.md): Bailey Sam KR1 · S/N THREE · Cancelled Aug 16, 2023 · Registration pending, canceled · Built 1999
- [N7410X](https://openairdocs.org/deregistered/N7410X-2013-07-29.md): Cessna 172B · S/N 17247910 · Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1960
- [N9985L](https://openairdocs.org/deregistered/N9985L-2013-05-31.md): Grumman American Avn. AA-1B · S/N AA1B-0285 · Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1973 · Martel Gregary G
- [N5534D](https://openairdocs.org/deregistered/N5534D-2013-04-22.md): Cessna 172N · S/N 17272594 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1979 · Curry Rex
- [N6631B](https://openairdocs.org/deregistered/N6631B-2013-02-13.md): Cessna 310B · S/N 35731 · Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1958
- [N6110K](https://openairdocs.org/deregistered/N6110K-1995-08-09.md): Cessna 150M · S/N 15077531 · Cancelled Aug 9, 1995 · Dahl Jeffery D
- [N9058Y](https://openairdocs.org/deregistered/N9058Y-1993-04-07.md): Cessna 120 · S/N 10246 · Cancelled Apr 7, 1993
- [N5165P](https://openairdocs.org/deregistered/N5165P-1992-10-28.md): Piper PA-24-250 · S/N 24181 · Cancelled Oct 28, 1992 · Triennial form not returned · Bonilla Roberto L
- [N5985F](https://openairdocs.org/deregistered/N5985F-1983-11-04.md): Piper PA-28-140 · S/N 28-7725072 · Cancelled Nov 4, 1983 · Plut David R
- [N7480S](https://openairdocs.org/deregistered/N7480S-1971-10-13.md): Smith AEROSTAR 601 · S/N 61-0047-92 · Cancelled Oct 13, 1971 · R E I Industries Inc
- [N8949K](https://openairdocs.org/deregistered/N8949K-1971-04-19.md): Universal Stinson 108-1 · S/N 108-1949 · Cancelled Apr 19, 1971 · Exported to Canada · Richardson Byron E Or Genevieve A Richardson
- [N6507C](https://openairdocs.org/deregistered/N6507C-1962-09-10.md): Fletcher FU-24A · S/N 102 · Cancelled Sep 10, 1962 · Exported to New Zealand · Fletcher Aviation Corp
- [N6505C](https://openairdocs.org/deregistered/N6505C-1957-01-07.md): Fletcher FU-24 · S/N 1 · Cancelled Jan 7, 1957 · Exported to New Zealand · Fletcher Aviation Corp
- [N33648](https://openairdocs.org/deregistered/N33648-1956-02-20.md): North American P-51A · S/N 22110 · Cancelled Feb 20, 1956 · Hardwick Jack B
- [N4831N](https://openairdocs.org/deregistered/N4831N-1956-02-15.md): North American P-51C · S/N 42103730 · Cancelled Feb 15, 1956 · Hardwick Jack B
- [N90609](https://openairdocs.org/deregistered/N90609-1956-01-04.md): Fletcher FD-25A · S/N 2 · Cancelled Jan 4, 1956 · Fletcher Aviation Corp
- [N4637V](https://openairdocs.org/deregistered/N4637V-1955-10-26.md): Douglas A-26B · S/N 322314 · Cancelled Oct 26, 1955 · Hardwick Aircraft Co
- [N4638V](https://openairdocs.org/deregistered/N4638V-1955-10-26.md): North American AT-6A · S/N 88-13715 · Cancelled Oct 26, 1955 · Hardwick Aircraft Co
- [N4643V](https://openairdocs.org/deregistered/N4643V-1955-10-26.md): North American AT-6A · S/N 4116474 · Cancelled Oct 26, 1955 · Hardwick Aircraft Co
- [N4645V](https://openairdocs.org/deregistered/N4645V-1955-10-26.md): North American AT-6A · S/N 42-12438 · Cancelled Oct 26, 1955 · Hardwick Aircraft Co
- [N4644V](https://openairdocs.org/deregistered/N4644V-1955-05-20.md): North American AT-6A · S/N 41-16501 · Cancelled May 20, 1955 · Hardwick Aircraft Co
- [N63261](https://openairdocs.org/deregistered/N63261-1955-05-19.md): Consolidated Vultee BT-13A · S/N 7984 · Cancelled May 19, 1955 · Scannell Claude L
- [N18165](https://openairdocs.org/deregistered/N18165-1955-01-18.md): Babcock Aircrft LC-13-A · S/N 603 · Cancelled Jan 18, 1955 · Bartlett Wilbur E Trustee
- [N9108K](https://openairdocs.org/deregistered/N9108K-1949-08-30.md): Stinson 108-1 · S/N 108-2108 · Cancelled Aug 30, 1949 · Heasley Flying Service
- [N37277](https://openairdocs.org/deregistered/N37277-1949-01-05.md): Interstate S-1A · S/N 120 · Cancelled Jan 5, 1949 · Robert P Heasley
- [N278Y](https://openairdocs.org/deregistered/N278Y-1948-07-08.md): Luscombe PHANTOM 1 · S/N 104 · Cancelled Jul 8, 1948 · Built 1935 · Heasley Flying Service
- [N53400](https://openairdocs.org/deregistered/N53400-1948-02-18.md): Boeing D75N1 · S/N 75-3949 · Cancelled Feb 18, 1948 · Exported to Mexico · Built 1942 · Mcculloh Ben
- [N34820](https://openairdocs.org/deregistered/N34820-1947-09-22.md): Rearwin 8135T · S/N 877 · Cancelled Sep 22, 1947 · Built 1941 · Johnson Lyle Francis
- [N13078](https://openairdocs.org/deregistered/N13078-1936-09-20.md): Aeronca C-3 · S/N A-242 · Cancelled Sep 20, 1936 · Wells R E
- [N67509](https://openairdocs.org/deregistered/N67509-undated.md): Cessna UC-78B · S/N 4746 · Cancellation date not recorded · Heasley Flying Service

## 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 = 'ROSEMEAD'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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