# Cancelled registrations: Union City, CA

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

Cancelled aircraft registrations in Union City, CA.

- [N14538](https://openairdocs.org/deregistered/N14538-2023-03-04.md): Aeronca C-3 · S/N A-433 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Baumbach Gregory A
- [N996J](https://openairdocs.org/deregistered/N996J-2022-11-05.md): Curtiss JN-4 · S/N A996 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Baumbach Gregory A
- [N30TV](https://openairdocs.org/deregistered/N30TV-2021-07-09.md): Agusta A109E · S/N 11057 · Cancelled Jul 9, 2021 · Exported to Philippines · Built 1999 · Heaven'S Ark Enterprise LLC
- [N5264](https://openairdocs.org/deregistered/N5264-2020-05-23.md): Standard J-1 · S/N 2969 · Cancelled May 23, 2020 · Sale reported, canceled
- [N1686](https://openairdocs.org/deregistered/N1686-2018-03-13.md): Dehavilland GIPSY MOTH DH.60G · S/N 160 · Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Baumbach Gregory A
- [N21959](https://openairdocs.org/deregistered/N21959-2018-02-12.md): Rearwin 9000-KR · S/N 642 · Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1939 · Haley Robert J
- [N6101H](https://openairdocs.org/deregistered/N6101H-2018-02-02.md): Stearman C3-B · S/N 135 · Cancelled Feb 2, 2018 · Sale reported, pending cancellation · Built 1928
- [N6387D](https://openairdocs.org/deregistered/N6387D-2013-11-07.md): Cessna 172N · S/N 17272773 · Cancelled Nov 7, 2013 · Second renewal notice · Built 1979 · Five Rivers Flight Training LLC
- [N68404](https://openairdocs.org/deregistered/N68404-2013-05-02.md): Boeing A75N1(PT17) · S/N 75-7830 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1943 · Baumbach David J
- [N4820T](https://openairdocs.org/deregistered/N4820T-2013-04-18.md): Piper PA-28R-200 · S/N 28R-7235116 · Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1972 · Culverwell Daniel B
- [N3068P](https://openairdocs.org/deregistered/N3068P-2013-04-15.md): Piper PA-23 · S/N 23-986 · Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1957 · Stever Richard E
- [N22504](https://openairdocs.org/deregistered/N22504-2012-08-30.md): Douglas C-54E · S/N 27318 · Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1945 · Cascade Realty And Investments Co
- [N4790P](https://openairdocs.org/deregistered/N4790P-2007-08-03.md): Cessna 152 · S/N 15284818 · Cancelled Aug 3, 2007 · Exported to Philippines · Built 1980 · Bajwa Satnam
- [N828MS](https://openairdocs.org/deregistered/N828MS-2001-09-25.md): Schwabe Michael H MHS-001 · S/N 1001 · Cancelled Sep 25, 2001 · Triennial form not returned · Schwabe Michael H
- [N348PD](https://openairdocs.org/deregistered/N348PD-1994-12-23.md): Dincognito Pat B TIERRA II · S/N 3488522 · Cancelled Dec 23, 1994 · Triennial form not returned · Dincognito Pat B
- [N252AB](https://openairdocs.org/deregistered/N252AB-1994-02-25.md): Mooney M20K · S/N 251150 · Cancelled Feb 25, 1994 · Exported to Portugal · Horta Joseph M
- [N308HC](https://openairdocs.org/deregistered/N308HC-1993-08-31.md): Piper PA-34-200T · S/N 347970224 · Cancelled Aug 31, 1993 · Exported to India · Singh Harjinder
- [N6850S](https://openairdocs.org/deregistered/N6850S-1983-04-29.md): Aero Commander 680 · S/N 680-363-50 · Cancelled Apr 29, 1983 · Davids Paul Richard
- [N6551B](https://openairdocs.org/deregistered/N6551B-1980-10-03.md): Mooney M20A · S/N 1220 · Cancelled Oct 3, 1980 · Durham Ralph R
- [N8164](https://openairdocs.org/deregistered/N8164-1976-05-27.md): Chilcott-Supp JEANIES TEENIE JT-1 · S/N 101 · Cancelled May 27, 1976 · Chilcott Robert D
- [N3310F](https://openairdocs.org/deregistered/N3310F-1970-06-29.md): Cessna 177 · S/N 17700439 · Cancelled Jun 29, 1970 · Built 1967 · Kennedy Keith A

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

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