# Cancelled registrations: Dublin, CA

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

Cancelled aircraft registrations in Dublin, CA.

- [N97WP](https://openairdocs.org/deregistered/N97WP-2021-01-30.md): Prince William F LONG EZ · S/N 827 · Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Stiehr David R
- [N8644T](https://openairdocs.org/deregistered/N8644T-2019-04-22.md): Cessna 182C · S/N 52544 · Cancelled Apr 22, 2019 · First renewal notice · Built 1960 · Muetterties Eric J
- [N6227G](https://openairdocs.org/deregistered/N6227G-2018-09-14.md): Cessna 150K · S/N 15071727 · Cancelled Sep 14, 2018 · Registration expired, pending cancellation · Built 1970 · Simmons David P
- [N8949A](https://openairdocs.org/deregistered/N8949A-2017-09-08.md): Beech C35 · S/N D-2703 · Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1951 · Jackson Stephen Trustee
- [N6111R](https://openairdocs.org/deregistered/N6111R-2017-07-07.md): Cessna 172RG · S/N 172RG0085 · Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1979 · Anvari Abdolreza
- [N99348](https://openairdocs.org/deregistered/N99348-2017-06-19.md): Cessna 172P · S/N 17276437 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1985 · Anvari Abdolreza
- [N30097](https://openairdocs.org/deregistered/N30097-2017-05-22.md): Cessna 177 · S/N 17701058 · Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1968 · Greenlee Michelle B
- [N99DM](https://openairdocs.org/deregistered/N99DM-2013-06-04.md): Piper PA-38-112 · S/N 38-78A0487 · Cancelled Jun 4, 2013 · Third renewal notice · Built 1978 · Rivair LLC
- [N214KS](https://openairdocs.org/deregistered/N214KS-2009-10-01.md): Hill Kenneth D EUROPA XS · S/N A214 · Cancelled Oct 1, 2009 · Triennial form not returned · Built 2005 · Lighthouse Christian Supply Inc
- [N9122A](https://openairdocs.org/deregistered/N9122A-2009-09-18.md): Patmont MITCHELL WING B-10 · S/N PA6MWSC1 · Cancelled Sep 18, 2009 · Registration revoked · Patmont Steven J
- [N84EZ](https://openairdocs.org/deregistered/N84EZ-2004-07-01.md): Johnson Rowland R VARIEZE · S/N 2075 · Cancelled Jul 1, 2004 · Triennial form not returned · Johnson Rowland R
- [N9332Z](https://openairdocs.org/deregistered/N9332Z-1991-05-23.md): Cessna TU206G · S/N U20606398 · Cancelled May 23, 1991 · Tn Cattle Co Inc
- [N64196](https://openairdocs.org/deregistered/N64196-1984-05-07.md): Cessna 172P · S/N 17275532 · Cancelled May 7, 1984 · Shetterly Grover L
- [N24BD](https://openairdocs.org/deregistered/N24BD-1984-04-06.md): Defreeze KR-2 · S/N KR22099 · Cancelled Apr 6, 1984 · Administratively canceled · Defreze William E
- [N667PL](https://openairdocs.org/deregistered/N667PL-1976-05-26.md): Cessna 182M · S/N 18259680 · Cancelled May 26, 1976 · Landeck Olof
- [N6454G](https://openairdocs.org/deregistered/N6454G-1971-04-30.md): Cessna 150K · S/N 150-71954 · Cancelled Apr 30, 1971 · Built 1970 · C & C Air

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

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