# Cancelled registrations: Rosamond, CA

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

Cancelled aircraft registrations in Rosamond, CA.

- [N50BW](https://openairdocs.org/deregistered/N50BW-2023-01-26.md): Piper PA-30 · S/N 30-66 · Cancelled Jan 26, 2023 · Exported to Guatemala · General Aviation Support Corp
- [N5607S](https://openairdocs.org/deregistered/N5607S-2022-09-03.md): Faussett Thomas J COZY MKIV · S/N TF002 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Blackbird Enterprises LLC DBA
- [N50547](https://openairdocs.org/deregistered/N50547-2021-09-18.md): Daniels PIETENPOL AIRCAMPER · S/N SD1 · Cancelled Sep 18, 2021 · Sale reported, canceled · Built 1978
- [N81256](https://openairdocs.org/deregistered/N81256-2021-07-03.md): Fairchild 24R-46 · S/N R46156 · Cancelled Jul 3, 2021 · Registration pending, canceled
- [N2473J](https://openairdocs.org/deregistered/N2473J-2019-10-31.md): Cessna 150G · S/N 15065573 · Cancelled Oct 31, 2019 · Exported to Mexico · Built 1966 · Irvine William G
- [N465VP](https://openairdocs.org/deregistered/N465VP-2019-05-24.md): Cessna 150L · S/N 15073959 · Cancelled May 24, 2019 · Exported to Mexico · Built 1972 · Irvine William G
- [N12DW](https://openairdocs.org/deregistered/N12DW-2019-05-04.md): Extra Flugzeugbau EA-300 · S/N 032 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1991 · Coleman Charles T
- [N5240B](https://openairdocs.org/deregistered/N5240B-2019-01-31.md): Mooney M20 · S/N 1103 · Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Built 1957 · Scaggs Ronald A
- [N2641C](https://openairdocs.org/deregistered/N2641C-2018-09-13.md): Cessna 310 · S/N 35041 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1955 · Irvine Bill
- [N6136S](https://openairdocs.org/deregistered/N6136S-2018-09-13.md): Cessna R182 · S/N R18201622 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1980 · Steffen James B
- [N8926Z](https://openairdocs.org/deregistered/N8926Z-2018-06-01.md): Cessna 310G · S/N 310G-0026 · Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1962
- [N372AW](https://openairdocs.org/deregistered/N372AW-2018-05-30.md): Bell UH-1V · S/N 70-16372 · Cancelled May 30, 2018 · Sale reported, canceled
- [N19456](https://openairdocs.org/deregistered/N19456-2018-01-11.md): Cessna C-38 · S/N 409 · Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1938 · Grimes Michael J
- [N109JP](https://openairdocs.org/deregistered/N109JP-2017-10-27.md): Payne James M AD SRG CNPTS SPIR XL · S/N 45 · Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1995 · Payne James M
- [N8028A](https://openairdocs.org/deregistered/N8028A-2017-07-10.md): Cessna 170B · S/N 20880 · Cancelled Jul 10, 2017 · Third renewal notice · Built 1952 · Hansen Eric P
- [N4329A](https://openairdocs.org/deregistered/N4329A-2015-05-13.md): Atkinson George W SOUZA SUPER BANDIT · S/N 009 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1998 · Barber Murray Wayne
- [N205LT](https://openairdocs.org/deregistered/N205LT-2015-05-08.md): Bell 206B · S/N 1459 · Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1974 · Francis William P
- [N204VC](https://openairdocs.org/deregistered/N204VC-2013-08-07.md): Bell UH-1L · S/N 157834 · Cancelled Aug 7, 2013 · Sale reported, canceled
- [N9349U](https://openairdocs.org/deregistered/N9349U-2013-07-29.md): Cessna 150M · S/N 15078298 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1976 · Baisden Vinton DBA
- [N25888](https://openairdocs.org/deregistered/N25888-2013-06-12.md): Fry-Kibler 03A RENIGADE · S/N 2 · Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1979 · Scrivner Charles L
- [N7319B](https://openairdocs.org/deregistered/N7319B-2013-05-07.md): Beech E35 · S/N D-3782 · Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1954 · Warner Aric D
- [N200AW](https://openairdocs.org/deregistered/N200AW-2012-08-22.md): Aero Commander 200D · S/N 383 · Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1967 · White David L
- [N156W](https://openairdocs.org/deregistered/N156W-2012-08-08.md): Walker SA-100 · S/N 001W · Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1969 · Pontius Jeff S
- [N74518](https://openairdocs.org/deregistered/N74518-2012-06-15.md): Mooney M20B · S/N 1829 · Cancelled Jun 15, 2012 · Built 1961 · Metzler Kevin W
- [N8514S](https://openairdocs.org/deregistered/N8514S-2009-05-19.md): Cessna 182H · S/N 18256614 · Cancelled May 19, 2009 · Triennial form not returned · Built 1965 · Wilson John K
- [N89880](https://openairdocs.org/deregistered/N89880-2007-05-29.md): Cessna 152 · S/N 15282902 · Cancelled May 29, 2007 · Exported to Philippines · Built 1978 · Loftin Scott M
- [N4472](https://openairdocs.org/deregistered/N4472-2005-07-11.md): Schleicher AS-W12 · S/N 12001 · Cancelled Jul 11, 2005 · Exported to Germany · Built 1965 · Gravance John R Jr
- [N214HV](https://openairdocs.org/deregistered/N214HV-1995-06-20.md): Bell 214B-1 · S/N 28017 · Cancelled Jun 20, 1995 · Exported to Canada · Hidden Valley Helicopters Inc
- [N101EF](https://openairdocs.org/deregistered/N101EF-1994-05-17.md): Franco Ignatius E BUCCANEER XA-430 · S/N 1 · Cancelled May 17, 1994 · Triennial form not returned · Dulla William M
- [N18GB](https://openairdocs.org/deregistered/N18GB-1992-05-13.md): Byard T-18 · S/N 281 · Cancelled May 13, 1992 · Triennial form not returned · Byard George F
- [N83FC](https://openairdocs.org/deregistered/N83FC-1980-05-13.md): Hughes Helicopters HUGHES 369D · S/N 170071D · Cancelled May 13, 1980 · Exported to New Zealand · Kofahl Jim E

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

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