# Cancelled registrations: Willits, CA

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

Cancelled aircraft registrations in Willits, CA.

- [N4441E](https://openairdocs.org/deregistered/N4441E-2019-09-06.md): Aeronca 11CC · S/N 11CC-222 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Madsen Michael T
- [N4488J](https://openairdocs.org/deregistered/N4488J-2019-09-06.md): Piper PA-28-140 · S/N 28-22906 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1967 · Patton Jon O
- [N62834](https://openairdocs.org/deregistered/N62834-2018-02-20.md): Boeing A75N1(PT17) · S/N 75-533 · Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1940 · Bowen David R
- [N9633](https://openairdocs.org/deregistered/N9633-2018-02-12.md): Boeing A75N1(PT17) · S/N 75-2195 · Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1941 · Bowen David R
- [N6373M](https://openairdocs.org/deregistered/N6373M-2018-01-05.md): Stinson 108-3 · S/N 108-4373 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1948 · Madsen Robert C
- [N90021](https://openairdocs.org/deregistered/N90021-2017-02-04.md): Cessna 140 · S/N 9079 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Lawrence Dale W
- [N5336Q](https://openairdocs.org/deregistered/N5336Q-2014-10-27.md): Cessna 150L · S/N 15073236 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1972 · Shigitaka Kamita
- [N79577](https://openairdocs.org/deregistered/N79577-2013-08-28.md): Boeing A75N1(PT17) · S/N 75-7373 · Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1943 · Bowne David
- [N4784Q](https://openairdocs.org/deregistered/N4784Q-2013-08-15.md): Cessna A188B · S/N 18802526T · Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1976 · Bowen David R DBA
- [N702U](https://openairdocs.org/deregistered/N702U-2012-12-10.md): Quicksilver MX SPRINT II · S/N 0642 · Cancelled Dec 10, 2012 · Sale reported, canceled · Built 2005
- [N8400T](https://openairdocs.org/deregistered/N8400T-2007-02-13.md): Cessna 182B · S/N 52300 · Cancelled Feb 13, 2007 · Triennial form not returned · Built 1959 · Manning Robert L
- [N897TW](https://openairdocs.org/deregistered/N897TW-2004-10-15.md): Cessna 172S · S/N 172S8978 · Cancelled Oct 15, 2004 · Built 2001 · Warburton Edward A
- [N28145](https://openairdocs.org/deregistered/N28145-2002-07-30.md): Bellanca 17-30A · S/N 80-30986 · Cancelled Jul 30, 2002 · Built 1980 · Little Lake Pharmacy Inc DBA
- [N22GR](https://openairdocs.org/deregistered/N22GR-1995-10-10.md): Mcculloch J-2 · S/N 028 · Cancelled Oct 10, 1995 · Triennial form not returned · Redman Gerald R
- [N222GR](https://openairdocs.org/deregistered/N222GR-1994-12-21.md): Mcculloch J-2 · S/N 047 · Cancelled Dec 21, 1994 · Triennial form not returned · Aero Design And Sales Ltd
- [N24237](https://openairdocs.org/deregistered/N24237-1992-03-03.md): Cessna 152 · S/N 15280167 · Cancelled Mar 3, 1992 · Triennial form not returned · Warburton Edward A
- [N313RW](https://openairdocs.org/deregistered/N313RW-1991-03-25.md): Weston Randy E ROTORWAY-EXEC · S/N REW13 · Cancelled Mar 25, 1991 · Triennial form not returned · Weston Randy E
- [N7055M](https://openairdocs.org/deregistered/N7055M-1972-05-10.md): Cessna 175 · S/N 55355 · Cancelled May 10, 1972 · Pullian William E
- [N5735P](https://openairdocs.org/deregistered/N5735P-1971-12-14.md): Piper PA-24-250 · S/N 24-810 · Cancelled Dec 14, 1971 · Padula Elmer A
- [N3248Z](https://openairdocs.org/deregistered/N3248Z-1965-05-22.md): Piper PA-22-150 · S/N 227196 · Cancelled May 22, 1965 · Built 1960 · Logging Heavner John M
- [N6050D](https://openairdocs.org/deregistered/N6050D-1965-05-13.md): Piper PA-22-150 · S/N 22-4703 · Cancelled May 13, 1965 · Heavner John M Logging DBA John Heavner
- [N1365B](https://openairdocs.org/deregistered/N1365B-1963-01-31.md): Luscombe 8E · S/N 5992 · Cancelled Jan 31, 1963 · Crawford William
- [N3822P](https://openairdocs.org/deregistered/N3822P-1957-08-08.md): Piper PA-22 · S/N 22-3512 · Cancelled Aug 8, 1957 · Built 1956 · York Don And/Or York Fay
- [N23232](https://openairdocs.org/deregistered/N23232-1952-03-18.md): Piper J3C-65 · S/N 3001 · Cancelled Mar 18, 1952 · Built 1939 · Crothers Harold F
- [N9565A](https://openairdocs.org/deregistered/N9565A-1952-02-06.md): Cessna 170A · S/N 19126 · Cancelled Feb 6, 1952 · A B Heavner Logging And Lumber Sales

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

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