# Cancelled registrations: King City, CA

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

Cancelled aircraft registrations in King City, CA.

- [N70812](https://openairdocs.org/deregistered/N70812-2021-10-02.md): Piper J3C-65 · S/N 17827 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1946 · Plaskett Mark G
- [N1464W](https://openairdocs.org/deregistered/N1464W-2021-08-07.md): Bell 47G-5 · S/N 7933 · Cancelled Aug 7, 2021 · Sale reported, canceled · Built 1969
- [N57448](https://openairdocs.org/deregistered/N57448-2019-11-14.md): Consolidated Vultee BT-13A · S/N 11747 · Cancelled Nov 14, 2019 · Revoked, pending cancellation · Harris Clifford R
- [N1750B](https://openairdocs.org/deregistered/N1750B-2018-08-10.md): Richard D Kirk ZENITH STOL 750 · S/N 75-8887 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Kirk Richard D
- [N58385](https://openairdocs.org/deregistered/N58385-2014-10-30.md): Boeing A75N1(PT17) · S/N 75-2988 · Cancelled Oct 30, 2014 · Registration expired, pending cancellation · Built 1942 · Plaskett Gordon W
- [N4365K](https://openairdocs.org/deregistered/N4365K-2007-10-26.md): Deer B / Reffalt D BD · S/N BD-001 · Cancelled Oct 26, 2007 · Triennial form not returned · Built 1992 · Vaquero Aero Club Inc
- [N747CC](https://openairdocs.org/deregistered/N747CC-2000-04-20.md): Cessna T210M · S/N 21061636 · Cancelled Apr 20, 2000 · B And B Aviation Inc
- [N55JP](https://openairdocs.org/deregistered/N55JP-1998-03-23.md): Chance Vought FG-1D · S/N P32823 · Cancelled Mar 23, 1998 · Exported to Switzerland · Classic Flying Machines Ltd
- [N5563R](https://openairdocs.org/deregistered/N5563R-1997-07-17.md): Cessna 172F · S/N 17253154 · Cancelled Jul 17, 1997 · Triennial form not returned · Silva Burton L
- [N33VC](https://openairdocs.org/deregistered/N33VC-1996-12-13.md): Lockheed T-33 MARK 3 · S/N 261 · Cancelled Dec 13, 1996 · Exported to United Kingdom · Classic Flying Machines Ltd
- [N5224R](https://openairdocs.org/deregistered/N5224R-1995-07-14.md): Yakovlev YAK-50 · S/N 781208 · Cancelled Jul 14, 1995 · Exported to United Kingdom · Merlin Aire Ltd
- [N6827C](https://openairdocs.org/deregistered/N6827C-1992-11-06.md): Grumman TBM-3E · S/N 91110 · Cancelled Nov 6, 1992 · Exported to New Zealand · Merlin Aire Ltd
- [N4853T](https://openairdocs.org/deregistered/N4853T-1992-06-13.md): Piper PA-28-180 · S/N 287205209 · Cancelled Jun 13, 1992 · Triennial form not returned · Morga Buttgereit Agency
- [N65N](https://openairdocs.org/deregistered/N65N-1989-06-29.md): Dehavilland DH82A · S/N 6193 · Cancelled Jun 29, 1989 · Exported to United Kingdom · Merlin Aire Tld
- [N1164E](https://openairdocs.org/deregistered/N1164E-1985-02-12.md): Bellanca 7KCAB · S/N 615-77 · Cancelled Feb 12, 1985 · Administratively canceled · Long Eugene H DBA
- [N5915R](https://openairdocs.org/deregistered/N5915R-1968-02-28.md): Cessna 172G · S/N 17253584 · Cancelled Feb 28, 1968 · E-Z Eight Inc
- [N56215](https://openairdocs.org/deregistered/N56215-1955-10-11.md): Aeronca 0-58B · S/N 13013 · Cancelled Oct 11, 1955 · King Air
- [N25002](https://openairdocs.org/deregistered/N25002-1947-05-28.md): Piper J4A · S/N 4-788 · Cancelled May 28, 1947 · Built 1939 · Berry Everett W

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

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