# Cancelled registrations: Selma, CA

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

Cancelled aircraft registrations in Selma, CA.

- [N391](https://openairdocs.org/deregistered/N391-2022-06-04.md): Beech C35 · S/N D-3049 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Dewalt Richard P
- [N6175L](https://openairdocs.org/deregistered/N6175L-2013-04-29.md): American AA-1 · S/N AA1-0375 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1970 · Holmes Thomas H
- [N3589A](https://openairdocs.org/deregistered/N3589A-2012-09-18.md): Piper PA-18A-135RESTRICTED · S/N 18-3032 · Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1954
- [N61037](https://openairdocs.org/deregistered/N61037-1999-06-30.md): Cessna 150J · S/N 15070754 · Cancelled Jun 30, 1999 · Sale reported
- [N31186](https://openairdocs.org/deregistered/N31186-1993-10-21.md): Grumman Acft ENG Cor-Schweizer G-164B · S/N 7B · Cancelled Oct 21, 1993 · Exported to Philippines · C V A Inc
- [N3523L](https://openairdocs.org/deregistered/N3523L-1992-05-18.md): Cessna 150F · S/N 15062323 · Cancelled May 18, 1992 · Triennial form not returned · Alyde Aircraft Inc
- [N4580B](https://openairdocs.org/deregistered/N4580B-1991-11-05.md): Hamm Melvin D NESMITH COUGAR I · S/N 1 · Cancelled Nov 5, 1991 · Triennial form not returned · Hamm Melvyn D
- [N53397](https://openairdocs.org/deregistered/N53397-1980-11-06.md): Boeing E75 · S/N 755628 · Cancelled Nov 6, 1980 · Cook Jack Or Charlene
- [N1717B](https://openairdocs.org/deregistered/N1717B-1980-07-01.md): Boeing B75N1 · S/N 75-6005 · Cancelled Jul 1, 1980 · Built 1942 · C V A Inc
- [N5506Y](https://openairdocs.org/deregistered/N5506Y-1978-11-24.md): Bellanca 8KCAB · S/N 42678 · Cancelled Nov 24, 1978 · Garner Frank L
- [N6242B](https://openairdocs.org/deregistered/N6242B-1976-07-14.md): Aero Commander 500 · S/N 655-15 · Cancelled Jul 14, 1976 · Marsubiam Hripsimee
- [N1922B](https://openairdocs.org/deregistered/N1922B-1974-06-26.md): Luscombe 8E · S/N 6349 · Cancelled Jun 26, 1974 · Built 1947 · Thomas Bob
- [N6373W](https://openairdocs.org/deregistered/N6373W-1971-10-06.md): Piper PA-28-140 · S/N 28-20436 · Cancelled Oct 6, 1971 · Selma Flying Service
- [N68481](https://openairdocs.org/deregistered/N68481-1965-05-22.md): Cessna T-50 · S/N 2989 · Cancelled May 22, 1965 · Norsigian John
- [N7395C](https://openairdocs.org/deregistered/N7395C-1961-09-22.md): Beech C18S · S/N 44-35538A · Cancelled Sep 22, 1961 · Exported to Mexico · Leibee Lewis G
- [N68498](https://openairdocs.org/deregistered/N68498-1955-10-27.md): Cessna T-50 · S/N 2083 · Cancelled Oct 27, 1955 · Norsigian John
- [N1255C](https://openairdocs.org/deregistered/N1255C-1955-08-11.md): Piper PA-18A-135 · S/N 18-2493 · Cancelled Aug 11, 1955 · Service Crop Dusters
- [N67457](https://openairdocs.org/deregistered/N67457-1955-04-18.md): Cessna T-50 · S/N 6180 · Cancelled Apr 18, 1955 · Glenn J E
- [N2174H](https://openairdocs.org/deregistered/N2174H-1949-06-17.md): Engineering & Research 415-C · S/N 2797 · Cancelled Jun 17, 1949 · Built 1946 · Jacobsend Ernest George
- [N88172](https://openairdocs.org/deregistered/N88172-1947-11-13.md): Piper J3C-65 · S/N 15789 · Cancelled Nov 13, 1947 · Davis Tom J
- [N10654](https://openairdocs.org/deregistered/N10654-1933-06-17.md): Selma Aero Club MEAD PRIMARY GLIDER · S/N SAC-1 · Cancelled Jun 17, 1933 · Selma Aero Club
- [N10656](https://openairdocs.org/deregistered/N10656-1933-01-10.md): Crawford Motor & Airplane Manu CRAWFORD'S GLIDER · S/N C-N-2 · Cancelled Jan 10, 1933 · Built 1931 · Norsigian John
- [N68473](https://openairdocs.org/deregistered/N68473-undated.md): Cessna T-50 · S/N 1863 · Cancellation date not recorded · Stewart Drexel

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

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