# Cancelled registrations: Barstow, CA

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

Cancelled aircraft registrations in Barstow, CA.

- [N6058B](https://openairdocs.org/deregistered/N6058B-2021-01-30.md): Cessna 182A · S/N 34058 · Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1957 · Sommerville Rex L
- [N77801](https://openairdocs.org/deregistered/N77801-2019-05-04.md): Luscombe 8A · S/N 3528 · Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1946 · Savoie Robert J
- [N8472M](https://openairdocs.org/deregistered/N8472M-2018-05-21.md): Cessna A150K · S/N A15000172 · Cancelled May 21, 2018 · Revoked, canceled · Built 1970 · Kelly Alfred M
- [N3346G](https://openairdocs.org/deregistered/N3346G-2018-03-16.md): Piper PA-19 · S/N 18-2139 · Cancelled Mar 16, 2018 · Revoked, canceled · Camp Irwin Flying Club
- [N678BD](https://openairdocs.org/deregistered/N678BD-2018-01-23.md): Depue Bill E SKY RAIDER II · S/N 052 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2007 · Depue Bill E
- [N4048D](https://openairdocs.org/deregistered/N4048D-2014-07-29.md): Cessna 182A · S/N 34748 · Cancelled Jul 29, 2014 · Built 1957 · Sommerville Rex L
- [N67084](https://openairdocs.org/deregistered/N67084-2013-05-31.md): Piper J3C-65 · S/N 8277-13 · Cancelled May 31, 2013 · Sale reported, canceled · Built 1942
- [N5664S](https://openairdocs.org/deregistered/N5664S-2013-04-22.md): Beech A23-19 · S/N MB-94 · Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1966 · Bilnoski Lloyd K
- [N54491](https://openairdocs.org/deregistered/N54491-2013-04-09.md): Gokey SCORPION II · S/N BG-1 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1978 · Gokey William J
- [N407B](https://openairdocs.org/deregistered/N407B-2013-03-07.md): Beech 35 · S/N D-1412 · Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1948
- [N16JK](https://openairdocs.org/deregistered/N16JK-2012-10-15.md): Kurpell BARNETT J-4-B GYROPL · S/N 038 · Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1977 · Kurpell Joseph J
- [N4874C](https://openairdocs.org/deregistered/N4874C-2012-08-08.md): Douglas DC-7 · S/N 44264 · Cancelled Aug 8, 2012 · Revoked, canceled · Built 1954 · Midair Incorporated
- [N3235L](https://openairdocs.org/deregistered/N3235L-2012-05-21.md): Cessna 172H · S/N 17256135 · Cancelled May 21, 2012 · Built 1967 · Riley Michael L
- [N9718C](https://openairdocs.org/deregistered/N9718C-2009-09-18.md): Lockheed 1049E/01 · S/N 4549 · Cancelled Sep 18, 2009 · Registration revoked · Built 1959 · Midair Inc
- [N10570](https://openairdocs.org/deregistered/N10570-2002-11-14.md): Howard Dixon B B-8M · S/N 1 · Cancelled Nov 14, 2002 · Second triennial mailing, no response · Howard Dixon B
- [N6538T](https://openairdocs.org/deregistered/N6538T-1995-08-16.md): Cessna 150 · S/N 17938 · Cancelled Aug 16, 1995 · Triennial form not returned · Depue Bob G
- [N2615U](https://openairdocs.org/deregistered/N2615U-1991-03-22.md): Taylor Earle L CHEROKEE II · S/N 5991 · Cancelled Mar 22, 1991 · Triennial form not returned · Taylor Earle L
- [N3670A](https://openairdocs.org/deregistered/N3670A-1982-03-12.md): Piper PA-22-135 · S/N 22-1929 · Cancelled Mar 12, 1982 · Harris Ernest M Et Al
- [N1204U](https://openairdocs.org/deregistered/N1204U-1977-11-02.md): Cessna 172M · S/N 17266903 · Cancelled Nov 2, 1977 · Paul R Spickler
- [N8152N](https://openairdocs.org/deregistered/N8152N-1976-12-10.md): Piper PA-28-140 · S/N 28-25346 · Cancelled Dec 10, 1976 · Edwards Gilbert S
- [N4876C](https://openairdocs.org/deregistered/N4876C-1975-10-06.md): Douglas DC-7 · S/N 44680 · Cancelled Oct 6, 1975 · Midair Inc
- [N4877C](https://openairdocs.org/deregistered/N4877C-1975-10-06.md): Douglas DC-7 · S/N 44681 · Cancelled Oct 6, 1975 · Midair Inc
- [N4878C](https://openairdocs.org/deregistered/N4878C-1975-10-06.md): Douglas DC-7 · S/N 44682 · Cancelled Oct 6, 1975 · Midair Incorporated
- [N4881C](https://openairdocs.org/deregistered/N4881C-1975-10-06.md): Douglas DC-7 · S/N 44435 · Cancelled Oct 6, 1975 · Midair Inc
- [N4884C](https://openairdocs.org/deregistered/N4884C-1975-10-06.md): Douglas DC-7 · S/N 45313 · Cancelled Oct 6, 1975 · Midair Incorporated
- [N4886C](https://openairdocs.org/deregistered/N4886C-1975-10-06.md): Douglas DC-7 · S/N 45350 · Cancelled Oct 6, 1975 · Midair Incorporated
- [N5402V](https://openairdocs.org/deregistered/N5402V-1975-01-20.md): Lockheed 1049H-82 · S/N 4842 · Cancelled Jan 20, 1975 · Midair Inc
- [N5403V](https://openairdocs.org/deregistered/N5403V-1975-01-20.md): Lockheed 1049H · S/N 4844 · Cancelled Jan 20, 1975 · Midair Inc
- [N1006C](https://openairdocs.org/deregistered/N1006C-1975-01-17.md): Lockheed 1049H-82 · S/N 4802 · Cancelled Jan 17, 1975 · Midair Inc
- [N1008C](https://openairdocs.org/deregistered/N1008C-1975-01-17.md): Lockheed 1049H-82 · S/N 4806 · Cancelled Jan 17, 1975 · Midair Inc
- [N37208](https://openairdocs.org/deregistered/N37208-1971-02-05.md): Interstate S-1A · S/N 50 · Cancelled Feb 5, 1971 · Built 1941 · Hill Kenneth Etal
- [N6722C](https://openairdocs.org/deregistered/N6722C-1970-09-24.md): Navion L-17B · S/N 48-1040 · Cancelled Sep 24, 1970 · United States Army
- [N792B](https://openairdocs.org/deregistered/N792B-1970-06-25.md): Beech A35 · S/N D-1804 · Cancelled Jun 25, 1970 · Moore James T
- [N66480](https://openairdocs.org/deregistered/N66480-1970-06-18.md): Howard DGA-15P · S/N 29489 · Cancelled Jun 18, 1970 · Warren C Hiffel
- [N83750](https://openairdocs.org/deregistered/N83750-1970-06-12.md): Aeronca 7AC · S/N 7AC-2428 · Cancelled Jun 12, 1970 · Taylor Dean D
- [N9509K](https://openairdocs.org/deregistered/N9509K-1965-05-26.md): Stinson 108-2 · S/N 108-2509 · Cancelled May 26, 1965 · Waldon Ivan O
- [N9140A](https://openairdocs.org/deregistered/N9140A-1953-01-07.md): Cessna 170A · S/N 18901 · Cancelled Jan 7, 1953 · B & H Auto Sales
- [N414W](https://openairdocs.org/deregistered/N414W-1935-10-27.md): Travel Air 12-Q · S/N 12Q-2027 · Cancelled Oct 27, 1935 · Russell E Riley
- [N3885](https://openairdocs.org/deregistered/N3885-1928-07-23.md): American Eagle A-1 · S/N 88 · Cancelled Jul 23, 1928 · Bauer And Slaton

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

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