# Cancelled registrations: National City, CA

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

Cancelled aircraft registrations in National City, CA.

- [N9565E](https://openairdocs.org/deregistered/N9565E-2020-07-10.md): Aeronca 11AC · S/N 11AC1202 · Cancelled Jul 10, 2020 · Revoked, canceled · Built 1946 · Gerry Alvin F
- [N53971](https://openairdocs.org/deregistered/N53971-2020-01-24.md): Fairchild M-62A · S/N T421405 · Cancelled Jan 24, 2020 · Revoked, canceled · Built 1942 · Price Dorman E
- [N26326](https://openairdocs.org/deregistered/N26326-2019-11-15.md): Aeronca 50-L · S/N L7930 · Cancelled Nov 15, 2019 · Revoked, canceled · Built 1940 · Andreas Paul
- [N1736N](https://openairdocs.org/deregistered/N1736N-2017-10-28.md): Cessna 120 · S/N 11980 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Theilacker Raymond A Jr
- [N2978H](https://openairdocs.org/deregistered/N2978H-2013-06-18.md): Forney 415-C · S/N 3603 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1946 · Adona Salvador F
- [N3246W](https://openairdocs.org/deregistered/N3246W-2013-04-01.md): Hunsberger Robert E VOLMER VJ-24W · S/N 20 · Cancelled Apr 1, 2013 · Sale reported, canceled
- [N4662F](https://openairdocs.org/deregistered/N4662F-2012-08-22.md): Cessna P206A · S/N P206-0262 · Cancelled Aug 22, 2012 · Sale reported, pending cancellation · Built 1966
- [N2552G](https://openairdocs.org/deregistered/N2552G-1999-05-10.md): Champion 7KCAB · S/N 62 · Cancelled May 10, 1999 · Exported to Mexico · Bearden Flight Training Inc
- [N55863](https://openairdocs.org/deregistered/N55863-1994-09-29.md): Rodriguez Elias G KR-1 · S/N 2234 · Cancelled Sep 29, 1994 · Triennial form not returned · Rodruguez Elias G
- [N6568L](https://openairdocs.org/deregistered/N6568L-1979-06-29.md): Piper PA-31-310 · S/N 31-492 · Cancelled Jun 29, 1979 · Exported to Canada · Western Manufacturing Co
- [N6818V](https://openairdocs.org/deregistered/N6818V-1977-07-12.md): Aerostar Acft Corp Of Texas M20C · S/N 20-0001 · Cancelled Jul 12, 1977 · Herdman Raymond G
- [N38100](https://openairdocs.org/deregistered/N38100-1976-08-23.md): Baker KR-1 SPORTSTER · S/N 1722-B · Cancelled Aug 23, 1976 · Built 1975 · Baker Frank
- [N2829U](https://openairdocs.org/deregistered/N2829U-1974-11-08.md): Cessna 172D · S/N 17250429 · Cancelled Nov 8, 1974 · Exported to Mexico · Modesto Ardilla J
- [N7831C](https://openairdocs.org/deregistered/N7831C-1974-04-22.md): Main Air RAPIER · S/N 1 · Cancelled Apr 22, 1974 · Hernandez Frank P
- [N4633A](https://openairdocs.org/deregistered/N4633A-1973-02-12.md): Cessna 180 · S/N 32231 · Cancelled Feb 12, 1973 · Exported to Mexico · Built 1956 · Wade Edward T
- [N352L](https://openairdocs.org/deregistered/N352L-1971-09-27.md): Strahan Special Z · S/N HFM-1 · Cancelled Sep 27, 1971 · John D Houston
- [N27K](https://openairdocs.org/deregistered/N27K-1970-11-23.md): Modified Bensen GYRO-GLIDER · S/N M6-1 · Cancelled Nov 23, 1970 · Stephens Donald R
- [N48956](https://openairdocs.org/deregistered/N48956-1955-10-24.md): Aeronca 0-58B · S/N 058B-1822 · Cancelled Oct 24, 1955 · Gerald E Zigler
- [N9330E](https://openairdocs.org/deregistered/N9330E-1955-03-15.md): Aeronca 11AC · S/N 11AC-968 · Cancelled Mar 15, 1955 · Built 1946 · Scott Ray Mcl
- [N4716E](https://openairdocs.org/deregistered/N4716E-1954-02-25.md): Aeronca 7EC · S/N 7EC-60 · Cancelled Feb 25, 1954 · South Bay Airport Co
- [N1977E](https://openairdocs.org/deregistered/N1977E-1950-06-27.md): Aeronca 7AC · S/N 7AC-5544 · Cancelled Jun 27, 1950 · South Bay Airport Co
- [N137W](https://openairdocs.org/deregistered/N137W-1941-08-15.md): California D-1-K (CUB) · S/N 2 · Cancelled Aug 15, 1941 · Madison Carlyle Christian
- [N16028](https://openairdocs.org/deregistered/N16028-1936-08-08.md): Van Bezel G · S/N 100 · Cancelled Aug 8, 1936 · Built 1931
- [N40S](https://openairdocs.org/deregistered/N40S-undated.md): Smith K/Hoff D/Yelton J Etal EL BURRO · S/N 101 · Cancellation date not recorded · K H Smith

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

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