# Cancelled registrations: Newark, CA

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

Cancelled aircraft registrations in Newark, CA.

- [N6387W](https://openairdocs.org/deregistered/N6387W-2023-02-04.md): Piper PA-28-140 · S/N 28-20452 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Chowdhury Ajoy A
- [N21954](https://openairdocs.org/deregistered/N21954-2019-10-25.md): Porterfield CP-50 · S/N 551 · Cancelled Oct 25, 2019 · Revoked, canceled · Built 1939 · Faria Manuel S
- [N10QR](https://openairdocs.org/deregistered/N10QR-2018-05-30.md): Aircover QR425S · S/N 0111-1 · Cancelled May 30, 2018 · Sale reported, canceled
- [N5558L](https://openairdocs.org/deregistered/N5558L-2018-05-30.md): Raven Industries RALLY RX7 · S/N RX7-139 · Cancelled May 30, 2018 · Sale reported, canceled
- [N4464U](https://openairdocs.org/deregistered/N4464U-2018-03-06.md): Cessna 150D · S/N 15060464 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1964 · Errickson David E
- [N275ZM](https://openairdocs.org/deregistered/N275ZM-2018-01-17.md): Defelici Dan ZENAIR CH701 STOL · S/N 7-9295 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 2003 · Grimes Daniel J
- [N8958U](https://openairdocs.org/deregistered/N8958U-2017-02-04.md): Cessna 150M · S/N 15078028 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Hall Charles H
- [N6423E](https://openairdocs.org/deregistered/N6423E-2014-11-12.md): Cessna 172 · S/N 46523 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1959 · Watson Phillip
- [N7758C](https://openairdocs.org/deregistered/N7758C-2013-10-24.md): Stits Playboy SA3A · S/N P-555 · Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1961 · Ricketts James W
- [N5425E](https://openairdocs.org/deregistered/N5425E-2013-07-15.md): Macica Stephen SHA GLASAIR RG · S/N 788 · Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Macica Stephen DBA
- [N6428T](https://openairdocs.org/deregistered/N6428T-2013-04-29.md): Cessna 150 · S/N 17828 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1960 · Cox John C
- [N754TC](https://openairdocs.org/deregistered/N754TC-2002-10-01.md): Thunder & Colt THUNDER AX7-77 · S/N 2348 · Cancelled Oct 1, 2002 · Exported to United Kingdom · Built 1993
- [N737GY](https://openairdocs.org/deregistered/N737GY-1991-09-20.md): Cessna 172N · S/N 17269418 · Cancelled Sep 20, 1991 · Triennial form not returned · Goar Robert H
- [N1225P](https://openairdocs.org/deregistered/N1225P-1976-05-13.md): Piper PA-23 · S/N 23-245 · Cancelled May 13, 1976 · Bizek Mervin G
- [N68243](https://openairdocs.org/deregistered/N68243-1959-09-08.md): Fairchild M-62A-3 · S/N FZ-311 · Cancelled Sep 8, 1959 · Abacherli Roy Ray
- [N57115](https://openairdocs.org/deregistered/N57115-1955-10-24.md): Fairchild M-62A · S/N T42-1435 · Cancelled Oct 24, 1955 · Detrant Peter P & John S Montero
- [N60945](https://openairdocs.org/deregistered/N60945-undated.md): Cessna 150J · S/N 15070686 · Cancellation date not recorded · Garten Gerald R

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

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