# Cancelled registrations: Alamo, CA

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

Cancelled aircraft registrations in Alamo, CA.

- [N831F](https://openairdocs.org/deregistered/N831F-2022-09-19.md): Raytheon 58 · S/N TH-1805 · Cancelled Sep 19, 2022 · Exported to Australia · Built 1996 · Russello Gary J
- [N477E](https://openairdocs.org/deregistered/N477E-2019-03-11.md): Command-Aire 3C-3 · S/N 587 · Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Baumbach David
- [N216WA](https://openairdocs.org/deregistered/N216WA-2018-02-12.md): Cessna 421A · S/N 421A-0032 · Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1969 · George V Simon Md Jd A Professional Corp
- [N738UA](https://openairdocs.org/deregistered/N738UA-2017-07-20.md): Cessna 172N · S/N 17270237 · Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1978 · Oliver Robert F
- [N254SR](https://openairdocs.org/deregistered/N254SR-2017-06-14.md): Cirrus Design SR22 · S/N 2537 · Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 2007 · Aquatic Innovations Inc
- [N202TR](https://openairdocs.org/deregistered/N202TR-2014-12-18.md): Orlando Helicopter Airways TR-2000 · S/N 2001 · Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1997
- [N101HY](https://openairdocs.org/deregistered/N101HY-2014-12-16.md): Aviat A-1B · S/N WF0001 · Cancelled Dec 16, 2014 · Third renewal notice · Built 2005 · Booth Kevin C
- [N45374](https://openairdocs.org/deregistered/N45374-2013-08-14.md): Cessna 150M · S/N 15076884 · Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1975 · Huff Ed T
- [N74301](https://openairdocs.org/deregistered/N74301-2013-05-08.md): Bellanca 14-13-2 · S/N 1414 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1947 · Waters James Edward
- [N4497G](https://openairdocs.org/deregistered/N4497G-2013-02-20.md): Crowder Thomas W TOM CROWDER P-12 · S/N 1 · Cancelled Feb 20, 2013 · Sale reported, canceled
- [N6228E](https://openairdocs.org/deregistered/N6228E-2012-08-21.md): Cessna 172 · S/N 46328 · Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1958
- [N168E](https://openairdocs.org/deregistered/N168E-2011-10-19.md): Curtiss Wright ROBIN · S/N 76 · Cancelled Oct 19, 2011 · Registration pending, pending cancellation · Built 1929
- [N4128X](https://openairdocs.org/deregistered/N4128X-2008-06-19.md): Robinson Helicopter R44 II · S/N 12088 · Cancelled Jun 19, 2008 · Exported to Chile · Built 2008 · Focus Global LLC
- [N1830R](https://openairdocs.org/deregistered/N1830R-2000-10-27.md): Beech A36TC · S/N EA-256 · Cancelled Oct 27, 2000 · Triennial form not returned · Penland Bob L
- [N422AR](https://openairdocs.org/deregistered/N422AR-1998-06-03.md): Ryan James D RUTAN VARI-EZE · S/N JR1 · Cancelled Jun 3, 1998 · Triennial form not returned · Ryan James D
- [N402ES](https://openairdocs.org/deregistered/N402ES-1995-12-15.md): Dassault-Breguet FALCON 10 · S/N 174 · Cancelled Dec 15, 1995 · Exported to Philippines · Bolla Aircraft Corporation
- [N76SH](https://openairdocs.org/deregistered/N76SH-1992-02-25.md): Cessna 421B · S/N 421B0558 · Cancelled Feb 25, 1992 · Triennial form not returned · Tri Party Partnership
- [N9495P](https://openairdocs.org/deregistered/N9495P-1976-06-24.md): Piper PA-24-260 · S/N 24-5013 · Cancelled Jun 24, 1976 · Exported to Canada · White Richard A

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

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