# Cancelled registrations: Castro Valley, CA

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

Cancelled aircraft registrations in Castro Valley, CA.

- [N783CC](https://openairdocs.org/deregistered/N783CC-2021-10-05.md): Chattin Charles A JR PITTS S-2E · S/N 0029 · Cancelled Oct 5, 2021 · Registration expired, pending cancellation · Built 1983 · Jl Davis Enterprises Ltd Inc
- [N739FB](https://openairdocs.org/deregistered/N739FB-2019-09-06.md): 3D Robotics SOLO · S/N S111A5605970 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Brouns Thomas V B
- [N75622](https://openairdocs.org/deregistered/N75622-2019-08-20.md): Cessna 172N · S/N 17267857 · Cancelled Aug 20, 2019 · Exported to Russia · Built 1976 · Allen Lynne G
- [N2346N](https://openairdocs.org/deregistered/N2346N-2019-05-04.md): Cessna 120 · S/N 12592 · Cancelled May 4, 2019 · Revoked, canceled · Built 1947 · Reiersgaard Dean O
- [N286WA](https://openairdocs.org/deregistered/N286WA-2019-01-29.md): Brian Daniel Wiest SERENITY · S/N BDW-001 · Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Built 2013 · Wiest Brian D
- [N87247](https://openairdocs.org/deregistered/N87247-2018-06-04.md): Engineering & Research 415-C · S/N 420 · Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1946
- [N48CJ](https://openairdocs.org/deregistered/N48CJ-2015-06-01.md): Spratt John E SEAREY · S/N 1MK291C · Cancelled Jun 1, 2015 · Exported to Canada · Built 2006 · Radovich Peter Anthony Administrator
- [N50182](https://openairdocs.org/deregistered/N50182-2015-02-25.md): Goodyear FG1D · S/N 92644 · Cancelled Feb 25, 2015 · Sale reported
- [N672Q](https://openairdocs.org/deregistered/N672Q-2013-10-25.md): Beech B95 · S/N TD-341 · Cancelled Oct 25, 2013 · Revoked, canceled · Built 1960 · East Bay Builders Inc
- [N5039M](https://openairdocs.org/deregistered/N5039M-2013-10-24.md): Beech C24R · S/N MC-590 · Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1978 · Strand John
- [N6754P](https://openairdocs.org/deregistered/N6754P-2013-05-01.md): Piper PA-24-250 · S/N 24-1883 · Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1960 · Fairchild Max W
- [N5086M](https://openairdocs.org/deregistered/N5086M-2013-03-21.md): Taylorcraft BC12-D · S/N 10386 · Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1946 · Crusby John W
- [N49006](https://openairdocs.org/deregistered/N49006-2005-11-02.md): Cessna 152 · S/N 15281096 · Cancelled Nov 2, 2005 · Exported to South Africa · Built 1977 · Allen Lynne G
- [N5521L](https://openairdocs.org/deregistered/N5521L-2005-06-06.md): Cessna 152 · S/N 15284332 · Cancelled Jun 6, 2005 · Exported to South Africa · Built 1980 · Allen Lynne G
- [N9421U](https://openairdocs.org/deregistered/N9421U-1993-08-17.md): Cessna 150M · S/N 15078369 · Cancelled Aug 17, 1993 · Triennial form not returned · Mcbride Gordon D
- [N3323V](https://openairdocs.org/deregistered/N3323V-1992-07-24.md): Beech 35 · S/N D784 · Cancelled Jul 24, 1992 · Triennial form not returned · Hackler Russell W
- [N88891](https://openairdocs.org/deregistered/N88891-1977-04-27.md): Douglas C54B-DC · S/N 10505 · Cancelled Apr 27, 1977 · Guidotti David A
- [N3062C](https://openairdocs.org/deregistered/N3062C-1976-01-12.md): Beech K35 · S/N D-5734 · Cancelled Jan 12, 1976 · Butler Fred I
- [N6574B](https://openairdocs.org/deregistered/N6574B-1974-07-30.md): Mooney M20A · S/N 1244 · Cancelled Jul 30, 1974 · Savage William E
- [N7070A](https://openairdocs.org/deregistered/N7070A-1970-06-26.md): Cessna 172 · S/N 29170 · Cancelled Jun 26, 1970 · Johnson Albert
- [N3362X](https://openairdocs.org/deregistered/N3362X-1970-06-04.md): Mooney M20E · S/N 1083 · Cancelled Jun 4, 1970 · Wiles Robert J Margaret Wiles

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

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