# Cancelled registrations: Ukiah, CA

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

Cancelled aircraft registrations in Ukiah, CA.

- [N583JD](https://openairdocs.org/deregistered/N583JD-2023-04-01.md): DJI INSPIRE 1 · S/N W13DCB25020399 · Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Fuller Kirk R
- [N369CZ](https://openairdocs.org/deregistered/N369CZ-2020-05-29.md): Teeters William S COZY · S/N 1517 · Cancelled May 29, 2020 · Registration expired, pending cancellation · Andronaco Gregory
- [N8342J](https://openairdocs.org/deregistered/N8342J-2019-04-29.md): Robinson Helicopter R22 BETA · S/N 2671 · Cancelled Apr 29, 2019 · Exported to Australia · Built 1997 · Parks Leasing Inc
- [N25570](https://openairdocs.org/deregistered/N25570-2018-02-09.md): Commonwealth REARWIN 9000-L · S/N 659-D · Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1940 · Freese James R
- [N123ST](https://openairdocs.org/deregistered/N123ST-2018-02-08.md): ST Clair R C LANCAIR 360 · S/N 32 · Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1992 · Jahnke Lionel G
- [N91HV](https://openairdocs.org/deregistered/N91HV-2018-01-29.md): Beech D55 · S/N TE-663 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1968 · Baker Douglas Daniel
- [N79115](https://openairdocs.org/deregistered/N79115-2018-01-24.md): Corcoran TG-1A · S/N 2-15 · Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Freese James R
- [N4130D](https://openairdocs.org/deregistered/N4130D-2018-01-19.md): Piper PA-32R-301T · S/N 3257059 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1998 · Gypsy Flyer Inc
- [N4317M](https://openairdocs.org/deregistered/N4317M-2018-01-19.md): Scheibe BERGFALKE II · S/N 175 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Freese James R
- [N9561Y](https://openairdocs.org/deregistered/N9561Y-2017-10-19.md): Cessna T210N · S/N 21064548 · Cancelled Oct 19, 2017 · Exported to Mexico · Built 1981 · Willoughby Michelle C Myrenne
- [N858BH](https://openairdocs.org/deregistered/N858BH-2017-04-18.md): Hanley Brett A BH 701 · S/N 001 · Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 2007 · Balletto Ryan A
- [N4946Q](https://openairdocs.org/deregistered/N4946Q-2014-12-17.md): Cessna A188B · S/N 18802681T · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1976 · Baker Beverage Inc
- [N28HL](https://openairdocs.org/deregistered/N28HL-2013-10-31.md): Long Harry W HLS-02X · S/N HLS-001 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1994 · Jahnke L G
- [N177RK](https://openairdocs.org/deregistered/N177RK-2013-09-12.md): Kircher Robert KR-1 · S/N 3895 · Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1980 · Kircher Robert C
- [N4325K](https://openairdocs.org/deregistered/N4325K-2013-08-14.md): Ryan NAVION A · S/N NAV-4-1325 · Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1948 · Lovaas Michael D
- [N89408](https://openairdocs.org/deregistered/N89408-2013-06-07.md): Cessna 140 · S/N 8440 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Bishop Nicholas E
- [N63949](https://openairdocs.org/deregistered/N63949-2013-04-29.md): Piper PA-18-150 · S/N 18-8009028 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1979 · Peters James Robert
- [N24711](https://openairdocs.org/deregistered/N24711-2012-09-10.md): Rogers MINI-COUPE · S/N MC-128 · Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1987 · Darrow Howard L
- [N10650](https://openairdocs.org/deregistered/N10650-2012-07-19.md): Baker Mcmillen G-3 · S/N G3 · Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Built 1931 · Freese James R
- [N254C](https://openairdocs.org/deregistered/N254C-2011-05-17.md): Stinson 108-2 · S/N 1083254 · Cancelled May 17, 2011 · Revoked, pending cancellation · Built 1947 · Bell Guilford H
- [N23498](https://openairdocs.org/deregistered/N23498-2009-07-14.md): Cessna 150H · S/N 15068991 · Cancelled Jul 14, 2009 · Registration revoked · Built 1968 · Mcchesney Arthur C
- [N57GJ](https://openairdocs.org/deregistered/N57GJ-2007-05-02.md): Jahnke Lionel Gordon ADVENTURER · S/N 1969 · Cancelled May 2, 2007 · Triennial form not returned · Jahnke Lionel G
- [N29603](https://openairdocs.org/deregistered/N29603-2007-03-13.md): Cessna 210L · S/N 21059870 · Cancelled Mar 13, 2007 · Exported to Australia · Built 1973 · Alpha Analytical Laboratories Inc
- [N139EH](https://openairdocs.org/deregistered/N139EH-1998-12-23.md): S N I A S AS350D ASTAR · S/N 1411 · Cancelled Dec 23, 1998 · Exported to Canada · L W Winter Helicopters Inc
- [N59613](https://openairdocs.org/deregistered/N59613-1994-01-28.md): Bell 206B · S/N 1502 · Cancelled Jan 28, 1994 · Triennial form not returned · Smith Helicopter Inc
- [N77322](https://openairdocs.org/deregistered/N77322-1983-05-23.md): Cessna 140 · S/N 11764 · Cancelled May 23, 1983 · Berry Donald L
- [N5609A](https://openairdocs.org/deregistered/N5609A-1982-12-11.md): Cessna 172 · S/N 28209 · Cancelled Dec 11, 1982 · Rohlfing Theodore P
- [N272TS](https://openairdocs.org/deregistered/N272TS-1980-03-17.md): Aero Commander 680 · S/N 680E-624-250 · Cancelled Mar 17, 1980 · Exported to Colombia · Pruden Howard L Et Al
- [N2868L](https://openairdocs.org/deregistered/N2868L-1977-07-11.md): Cessna 172H · S/N 17256068 · Cancelled Jul 11, 1977 · Skyhawks Flying Club
- [N97249](https://openairdocs.org/deregistered/N97249-1976-05-28.md): Stinson 108 · S/N 108-249 · Cancelled May 28, 1976 · Teague Richard E
- [N246Z](https://openairdocs.org/deregistered/N246Z-1975-08-05.md): Piper PA-23-160 · S/N 23-1861 · Cancelled Aug 5, 1975 · Berkland William L
- [N8983N](https://openairdocs.org/deregistered/N8983N-1975-04-18.md): Piper PA-32-300 · S/N 32-40952 · Cancelled Apr 18, 1975 · Exported to South Africa · Norton George L
- [N57207](https://openairdocs.org/deregistered/N57207-1974-09-18.md): Boeing D75N1 · S/N 75-3952 · Cancelled Sep 18, 1974 · Ace Aerial Service
- [N4228V](https://openairdocs.org/deregistered/N4228V-1974-04-23.md): Cessna 170 · S/N 18584 · Cancelled Apr 23, 1974 · Built 1948 · Butts Harold
- [N9063F](https://openairdocs.org/deregistered/N9063F-1973-03-02.md): Hughes 369HS · S/N 110271S · Cancelled Mar 2, 1973 · Al Thrasher Equipment Corp
- [N4664F](https://openairdocs.org/deregistered/N4664F-1972-07-12.md): Cessna P206A · S/N P206-0264 · Cancelled Jul 12, 1972 · Smith Martin P
- [N4146T](https://openairdocs.org/deregistered/N4146T-1971-01-12.md): Cessna 320D · S/N 320D0046 · Cancelled Jan 12, 1971 · F M Crawford Lumber Inc
- [N2353L](https://openairdocs.org/deregistered/N2353L-1970-07-16.md): Beech 23 · S/N M-191 · Cancelled Jul 16, 1970 · Beamer Sid
- [N91479](https://openairdocs.org/deregistered/N91479-1970-06-17.md): North American NAVION · S/N NAV4115 · Cancelled Jun 17, 1970 · Enzler M J
- [N6484B](https://openairdocs.org/deregistered/N6484B-1965-05-20.md): Cessna 172 · S/N 29684 · Cancelled May 20, 1965 · H J Jeffers

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

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