# Cancelled registrations: Kerman, CA

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

Cancelled aircraft registrations in Kerman, CA.

- [N4003Z](https://openairdocs.org/deregistered/N4003Z-2015-05-14.md): Ayres S2R-T34 · S/N 6007 · Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 1979 · Mid Cal Ag Aviation Inc
- [N62311](https://openairdocs.org/deregistered/N62311-2014-11-12.md): Hickerson BENSEN B-8M · S/N HBH-2 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1975 · Hickerson Herbert B
- [N53412](https://openairdocs.org/deregistered/N53412-2014-10-27.md): Boeing A75N1(PT17) · S/N 75-2872 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1956 · Kerman Crop Dusting Inc
- [N9495R](https://openairdocs.org/deregistered/N9495R-2013-11-04.md): Snow S2C · S/N 1135-C · Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1962 · Mid Cal Ag Aviation Inc
- [N51935](https://openairdocs.org/deregistered/N51935-2013-04-01.md): Rodewald VARI-EZE · S/N 1369 · Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1978 · Williams John T
- [N4072X](https://openairdocs.org/deregistered/N4072X-2012-11-19.md): Aero Commander S2R · S/N 1915R · Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1974 · Mid Cal Ag Aviation Inc
- [N75442](https://openairdocs.org/deregistered/N75442-2012-07-09.md): Boeing A75 · S/N 75-039 · Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1937
- [N8147Z](https://openairdocs.org/deregistered/N8147Z-2011-10-21.md): Cessna 210-5 · S/N 205-0147 · Cancelled Oct 21, 2011 · Exported to Mexico · Built 1962 · Kangiser Glenn R
- [N1228C](https://openairdocs.org/deregistered/N1228C-2009-10-09.md): Piper PA-22-135 · S/N 22-1033 · Cancelled Oct 9, 2009 · Registration revoked · Built 1953 · Williams Morillas Aerial Applicators
- [N1064N](https://openairdocs.org/deregistered/N1064N-2009-06-25.md): Boeing E75 · S/N 75-5143 · Cancelled Jun 25, 2009 · Registration revoked · Built 1942 · Bufkin David F
- [N6688X](https://openairdocs.org/deregistered/N6688X-1989-04-03.md): Cessna 210A · S/N 21057688 · Cancelled Apr 3, 1989 · Exported to Colombia · Bellach Jay W
- [N40160](https://openairdocs.org/deregistered/N40160-1984-10-26.md): Ayres S2R-R3S · S/N R3S-007 · Cancelled Oct 26, 1984 · Administratively canceled · Aircraft Spray Inc
- [N4882Q](https://openairdocs.org/deregistered/N4882Q-1983-05-03.md): Cessna A188B · S/N 18802618T · Cancelled May 3, 1983 · Exported to Mexico · Bennett Thomas A
- [N4363Y](https://openairdocs.org/deregistered/N4363Y-1982-03-01.md): Piper PA-25-235 · S/N 25-4862 · Cancelled Mar 1, 1982 · Built 1969 · Williams Ag Aerial Inc
- [N7206Z](https://openairdocs.org/deregistered/N7206Z-1981-07-08.md): Piper PA-25-235 · S/N 25-3117 · Cancelled Jul 8, 1981 · Exported to Mexico · Kerman Crop Dusting Inc
- [N3454U](https://openairdocs.org/deregistered/N3454U-1981-03-13.md): Cessna 182F · S/N 18254854 · Cancelled Mar 13, 1981 · May Vernon A Et Al
- [N4528Y](https://openairdocs.org/deregistered/N4528Y-1979-03-13.md): Piper PA-25-235 · S/N 25-4179 · Cancelled Mar 13, 1979 · Exported to Mexico · Built 1967 · Kerman Crop Dusting Inc
- [N66932](https://openairdocs.org/deregistered/N66932-1971-02-03.md): Consolidated Vultee BT-13A · S/N 6457 · Cancelled Feb 3, 1971 · Robert Clarence Cardwell
- [N48942](https://openairdocs.org/deregistered/N48942-1971-01-19.md): Interstate S-1B1 · S/N 246 · Cancelled Jan 19, 1971 · Avinelis Frank E
- [N56279](https://openairdocs.org/deregistered/N56279-1955-12-02.md): Consolidated Vultee BT-13B (SNV-2) · S/N 79-1763 · Cancelled Dec 2, 1955 · Bland Russell
- [N80109](https://openairdocs.org/deregistered/N80109-1951-03-23.md): Culver V · S/N V-150 · Cancelled Mar 23, 1951 · Built 1946 · Price James R

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

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