# Cancelled registrations: Cerritos, CA

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

Cancelled aircraft registrations in Cerritos, CA.

- [N3423F](https://openairdocs.org/deregistered/N3423F-2019-08-12.md): Cessna T210H · S/N T210-0373 · Cancelled Aug 12, 2019 · Sale reported, canceled
- [N651UG](https://openairdocs.org/deregistered/N651UG-2019-05-04.md): DJI PHANTOM 3 PROFESSION · S/N P78DCH10033608 · Cancelled May 4, 2019 · Sale reported, pending cancellation
- [N838BZ](https://openairdocs.org/deregistered/N838BZ-2019-03-23.md): DJI PHANTOM 3 PROFESSION · S/N P76DCE12010657 · Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Hanaford Chris R
- [N48271](https://openairdocs.org/deregistered/N48271-2018-06-26.md): Cessna 152 · S/N 15283316 · Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1979
- [N94708](https://openairdocs.org/deregistered/N94708-2018-03-15.md): Engineering & Research 415-CD · S/N 4819 · Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1947 · Hathaway William M Jr
- [N813MK](https://openairdocs.org/deregistered/N813MK-2018-02-23.md): Gulfstream Aerospace G-1159A · S/N 407 · Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1983 · Hidacane Air LLC
- [N732MJ](https://openairdocs.org/deregistered/N732MJ-2014-11-17.md): Cessna T210M · S/N 21061617 · Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1976 · Sobol Thomas J
- [N3826J](https://openairdocs.org/deregistered/N3826J-2014-10-02.md): Cessna 150G · S/N 15065126 · Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1966 · Little Paul
- [N14699](https://openairdocs.org/deregistered/N14699-2014-09-05.md): Bellanca 17-31ATC · S/N 74-31092 · Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1974 · Marsalis Ronald E
- [N66C](https://openairdocs.org/deregistered/N66C-2013-10-18.md): Riley D-16 · S/N TTN-42 · Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1951 · Kinney David Earl
- [N181CC](https://openairdocs.org/deregistered/N181CC-2013-05-28.md): Schweizer 269C · S/N S1751 · Cancelled May 28, 2013 · Exported to Russia · Built 1997 · Southern California Aerial Services Inc
- [N8091H](https://openairdocs.org/deregistered/N8091H-2013-05-13.md): Piper PA-28-161 · S/N 28-8016075 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1979 · Salerno Albert
- [N56WP](https://openairdocs.org/deregistered/N56WP-2013-04-22.md): Powers Willis F RAND KR-2 · S/N 3332 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1979 · Powers Willis F
- [N4443J](https://openairdocs.org/deregistered/N4443J-2013-03-11.md): Piper PA-28-140 · S/N 28-22848 · Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1967 · Navarro Raul Diaz Luis
- [N49216](https://openairdocs.org/deregistered/N49216-2012-12-18.md): Cessna 152 · S/N 15281198 · Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1977 · Moceri Mark R
- [N24492](https://openairdocs.org/deregistered/N24492-2012-08-14.md): Cessna 152 · S/N 15280286 · Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1977
- [N4386U](https://openairdocs.org/deregistered/N4386U-2011-03-24.md): Cessna 150D · S/N 15060386 · Cancelled Mar 24, 2011 · Registration pending, pending cancellation · Built 1964
- [N2884S](https://openairdocs.org/deregistered/N2884S-1993-03-12.md): Piper PA-28-161 · S/N 287916509 · Cancelled Mar 12, 1993 · Triennial form not returned · Leach Bruce G
- [N22141](https://openairdocs.org/deregistered/N22141-1991-09-06.md): Cessna 150H · S/N 15068089 · Cancelled Sep 6, 1991 · Exported to Sri Lanka · Hoar Franklin D
- [N8081E](https://openairdocs.org/deregistered/N8081E-1990-12-12.md): Navion NAVION A · S/N NAV41753 · Cancelled Dec 12, 1990 · Second triennial mailing, no response · Hansen Linda L
- [N7692S](https://openairdocs.org/deregistered/N7692S-1984-12-21.md): Bellanca 7KCAB · S/N 583-76 · Cancelled Dec 21, 1984 · Mcdowell William W
- [N2781M](https://openairdocs.org/deregistered/N2781M-1982-02-25.md): Piper PA-32-300 · S/N 32-7840055 · Cancelled Feb 25, 1982 · Built 1977 · De Jong Lloyd L
- [N3092J](https://openairdocs.org/deregistered/N3092J-1981-12-18.md): Cessna 150E · S/N 15061192 · Cancelled Dec 18, 1981 · Built 1965 · Heath Dennis J Et Al
- [N4150B](https://openairdocs.org/deregistered/N4150B-1977-11-15.md): Aero Commander 520 · S/N 520-55 · Cancelled Nov 15, 1977 · Claus Leslie V
- [N1538J](https://openairdocs.org/deregistered/N1538J-1975-09-26.md): Piper PA-28-140 · S/N 2823939 · Cancelled Sep 26, 1975 · Built 1967 · Halwax Howard & Shirley

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

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