# Cancelled registrations: Williams, CA

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

Cancelled aircraft registrations in Williams, CA.

- [N1465C](https://openairdocs.org/deregistered/N1465C-2020-07-10.md): Piper PA-18A-135 · S/N 18-2664 · Cancelled Jul 10, 2020 · Revoked, canceled · Built 1953 · Caldwell Byron C
- [N26928](https://openairdocs.org/deregistered/N26928-2018-07-26.md): Piper J3C-65 · S/N 4274 · Cancelled Jul 26, 2018 · Revoked, canceled · Built 1940 · Caldwell Byron
- [N2087S](https://openairdocs.org/deregistered/N2087S-2017-07-18.md): Bell UH-1B · S/N 63-8512 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1963 · Jones Aviation Inc
- [N62587](https://openairdocs.org/deregistered/N62587-2017-04-18.md): WSK PZL Mielec M-18A · S/N 1Z026-08 · Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Charter Aviation Inc
- [N2760](https://openairdocs.org/deregistered/N2760-2014-09-25.md): Piper PA-23-250 · S/N 27-2014 · Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1962 · Petray Raymond
- [N8568X](https://openairdocs.org/deregistered/N8568X-2013-05-14.md): Cessna P172D · S/N P17257168 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1963 · Lagrande Dennis E
- [N57282](https://openairdocs.org/deregistered/N57282-2012-09-25.md): Consolidated Vultee BT-13A · S/N 1692 · Cancelled Sep 25, 2012 · Sale reported, pending cancellation · Built 1941
- [N731KS](https://openairdocs.org/deregistered/N731KS-2009-03-04.md): Schleicher ASK-23 · S/N 23023 · Cancelled Mar 4, 2009 · Exported to Japan · Built 1985 · Mayes Brett R
- [N70LE](https://openairdocs.org/deregistered/N70LE-2007-03-30.md): Centrair 101D · S/N 101D0519 · Cancelled Mar 30, 2007 · Exported to Argentina · Built 1987 · Mayes Brett R
- [N4011Y](https://openairdocs.org/deregistered/N4011Y-2003-09-04.md): Ayres S2R-600 · S/N 2539R · Cancelled Sep 4, 2003 · Triennial form not returned · Built 1979 · Charter Aviation Inc
- [N4216X](https://openairdocs.org/deregistered/N4216X-2000-03-23.md): Rockwell International S-2R · S/N 1973R · Cancelled Mar 23, 2000 · Triennial form not returned · Caldwell Robert B
- [N673U](https://openairdocs.org/deregistered/N673U-1997-04-21.md): Grumman G-164A · S/N 412 · Cancelled Apr 21, 1997 · Triennial form not returned · Charter Aviation Inc
- [N9182Z](https://openairdocs.org/deregistered/N9182Z-1996-06-03.md): Boeing PT-17 · S/N 752735 · Cancelled Jun 3, 1996 · Exported to Australia
- [N4969X](https://openairdocs.org/deregistered/N4969X-1993-11-30.md): Rockwell International S-2R · S/N 5014R · Cancelled Nov 30, 1993 · Exported to Australia · Caldwell Flying Service Inc
- [N62791](https://openairdocs.org/deregistered/N62791-1961-04-04.md): Consolidated Vultee BT-13A · S/N 8275 · Cancelled Apr 4, 1961 · Sherwood Legrande C Or Doris
- [N67847](https://openairdocs.org/deregistered/N67847-1955-10-13.md): Boeing B75N1 · S/N 75-7215 · Cancelled Oct 13, 1955 · Dalton Robert L
- [N68802](https://openairdocs.org/deregistered/N68802-1955-10-13.md): Boeing A75N1 · S/N 75-6998 · Cancelled Oct 13, 1955 · Built 1947 · Dalton Robert L
- [N63511](https://openairdocs.org/deregistered/N63511-1955-10-12.md): Boeing A75N1 · S/N 75-4799 · Cancelled Oct 12, 1955 · Dalton Robert L
- [N53821](https://openairdocs.org/deregistered/N53821-1951-02-13.md): Fairchild M-62A · S/N T43-5378 · Cancelled Feb 13, 1951 · Abel William
- [N53419](https://openairdocs.org/deregistered/N53419-1946-08-23.md): Boeing PT-17 · S/N 75-2068 · Cancelled Aug 23, 1946 · Built 1945 · Dalton Bros Flying Service

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

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