# Cancelled registrations: South Gate, CA

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

Cancelled aircraft registrations in South Gate, CA.

- [N796CC](https://openairdocs.org/deregistered/N796CC-2020-02-03.md): DJI PHANTOM 2 VISION + · S/N PH645498686 · Cancelled Feb 3, 2020 · Registration expired, pending cancellation · City Of South Gate
- [N71324](https://openairdocs.org/deregistered/N71324-2019-08-05.md): Luscombe 8A · S/N 2751 · Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Husband Kenneth L
- [N8979C](https://openairdocs.org/deregistered/N8979C-2017-02-02.md): Piper PA-22-135 · S/N 22-1559 · Cancelled Feb 2, 2017 · Revoked, pending cancellation · Built 1953 · Lowe Walter E
- [N80826](https://openairdocs.org/deregistered/N80826-1976-11-02.md): Globe GC-1B · S/N 229 · Cancelled Nov 2, 1976 · Walker John E
- [N6671M](https://openairdocs.org/deregistered/N6671M-1974-03-22.md): Stinson 108-3 · S/N 108-4671 · Cancelled Mar 22, 1974 · Santo Lincoln E
- [N2276R](https://openairdocs.org/deregistered/N2276R-1973-07-20.md): Cessna T210J · S/N T210-0426 · Cancelled Jul 20, 1973 · H H Schlitz Bookkeeping Service
- [N314M](https://openairdocs.org/deregistered/N314M-1971-05-27.md): Pitts Special S-1C · S/N SPS-1 · Cancelled May 27, 1971 · Built 1966 · Smith Malcolm P
- [N76802](https://openairdocs.org/deregistered/N76802-1971-03-03.md): Cessna 120 · S/N 11234 · Cancelled Mar 3, 1971 · Bremerthon Ellend
- [N38411](https://openairdocs.org/deregistered/N38411-1965-10-07.md): Piper J5A · S/N 962 · Cancelled Oct 7, 1965 · Luciano F Ciangura
- [N85850](https://openairdocs.org/deregistered/N85850-1956-02-23.md): Aeronca 11AC · S/N 11AC-274 · Cancelled Feb 23, 1956 · Furnish James P & Clarence N Dyson
- [N91526](https://openairdocs.org/deregistered/N91526-1955-12-12.md): North American NAVION · S/N NAV-4-122 · Cancelled Dec 12, 1955 · Built 1946 · Glick R Mario
- [N71788](https://openairdocs.org/deregistered/N71788-1955-10-24.md): Luscombe 8A · S/N 3215 · Cancelled Oct 24, 1955 · Air O Crats Flying Club
- [N1542K](https://openairdocs.org/deregistered/N1542K-1954-05-24.md): Luscombe 8E · S/N 4269 · Cancelled May 24, 1954 · Built 1946 · Lytal Jerry J
- [N12244](https://openairdocs.org/deregistered/N12244-1933-06-15.md): Mcclary Earl MCCLARY POWER GLIDER · S/N D-1 · Cancelled Jun 15, 1933 · Earl E Mcclary
- [N2486](https://openairdocs.org/deregistered/N2486-1930-05-07.md): Mcclary Earl MCCLARY POWER GLIDER · S/N 1A · Cancelled May 7, 1930 · Mcclary Earl E
- [N63157](https://openairdocs.org/deregistered/N63157-undated.md): Cessna T-50 · S/N 4363 · Cancellation date not recorded · Byars Leslie M

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

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