# Cancelled registrations: Kailua, HI

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

Cancelled aircraft registrations in Kailua, HI.

- [N22967](https://openairdocs.org/deregistered/N22967-2024-03-09.md): Cessna A150M · S/N A-150-0718 · Cancelled Mar 9, 2024 · Registration pending, canceled · Built 1977
- [N988DS](https://openairdocs.org/deregistered/N988DS-2023-04-01.md): DJI PHANTOM 2 VISION · S/N PH-645498856 · Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Hudson Jacob V Jr
- [N660SS](https://openairdocs.org/deregistered/N660SS-2019-10-05.md): DJI PHANTOM 3 PROFESSION · S/N P76DCK13A26085 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Story David J
- [N823DS](https://openairdocs.org/deregistered/N823DS-2019-07-10.md): DJI PHANTOM 3 PROFESSION · S/N P76DCG10016064 · Cancelled Jul 10, 2019 · Registration expired, pending cancellation · Story David J
- [N80918](https://openairdocs.org/deregistered/N80918-2019-02-25.md): Bell 206B · S/N 2687 · Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Built 1979 · Gebhard Jeffrey T
- [N78346](https://openairdocs.org/deregistered/N78346-2018-12-21.md): Cessna 172K · S/N 17257577 · Cancelled Dec 21, 2018 · Exported to Taiwan · Built 1968 · Ague Curtis M
- [N8528P](https://openairdocs.org/deregistered/N8528P-2018-03-08.md): Piper PA-24-400 · S/N 26-108 · Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1965 · Arava Inc
- [N252AK](https://openairdocs.org/deregistered/N252AK-2018-01-12.md): Krucker Mfg SIGNET · S/N PWG 110 · Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Godwin Philip W
- [N255AK](https://openairdocs.org/deregistered/N255AK-2018-01-12.md): Krucker Mfg SIGNET · S/N PWG 111 · Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Godwin Philip W
- [N7624R](https://openairdocs.org/deregistered/N7624R-2017-02-04.md): Beech A23-24 · S/N MA-347 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Newcomb Stanley
- [N101YK](https://openairdocs.org/deregistered/N101YK-2016-08-11.md): Piper PA-34-200T · S/N 347770370 · Cancelled Aug 11, 2016 · Third renewal notice · Built 1977 · Benzair Inc
- [N4343G](https://openairdocs.org/deregistered/N4343G-2015-05-05.md): Purington David CHALLENGER II · S/N CH2 0989-0454 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Purington David L
- [N21PK](https://openairdocs.org/deregistered/N21PK-2014-12-02.md): Beech B24R · S/N MC-305 · Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1974 · Neff Carl E
- [N3921J](https://openairdocs.org/deregistered/N3921J-2014-10-06.md): Cessna 150G · S/N 15065221 · Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1966 · Guy Carolann G
- [N7049L](https://openairdocs.org/deregistered/N7049L-2013-10-21.md): Cessna 310K · S/N 310K0149 · Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1966 · Wardair Aviation Inc
- [N8119L](https://openairdocs.org/deregistered/N8119L-2013-09-19.md): Cessna A150L · S/N A1500495 · Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1974 · Guy Carolann Gretchen
- [N62075](https://openairdocs.org/deregistered/N62075-2013-08-05.md): Piper J5C · S/N 5-1420 · Cancelled Aug 5, 2013 · Revoked, canceled · Built 1946 · Whittinghill Robert S
- [N658T](https://openairdocs.org/deregistered/N658T-2013-06-07.md): Beech 95 · S/N TD-54 · Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1958
- [N701SW](https://openairdocs.org/deregistered/N701SW-2013-06-07.md): Piper PA-22-150 · S/N 22-4256 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1956 · Stodghill Robert
- [N8502T](https://openairdocs.org/deregistered/N8502T-2013-05-14.md): Cessna 182C · S/N 52402 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1960 · Black Byron E
- [N5281Y](https://openairdocs.org/deregistered/N5281Y-2013-04-08.md): Piper PA-23-250 · S/N 27-2332 · Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1963 · Shipley Yoshiko
- [N5249Y](https://openairdocs.org/deregistered/N5249Y-2013-04-02.md): Piper PA-23-250 · S/N 27-2304 · Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1963 · Shipley Yoshiko
- [N3733H](https://openairdocs.org/deregistered/N3733H-2012-11-09.md): Ercoupe 415-C · S/N 4358 · Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1946 · G T Air Inc
- [N6926](https://openairdocs.org/deregistered/N6926-2012-10-15.md): Rodewald BD-5B · S/N 120 · Cancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1973
- [N62704](https://openairdocs.org/deregistered/N62704-2012-10-04.md): Piper PA-23-250 · S/N 27-7654160 · Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1976
- [N5614V](https://openairdocs.org/deregistered/N5614V-2012-09-24.md): Stinson L-5E · S/N 44-18149 · Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1945 · Whittinghill Robert S
- [N66GK](https://openairdocs.org/deregistered/N66GK-2012-06-12.md): Cessna 150D · S/N 15060683 · Cancelled Jun 12, 2012 · Sale reported, canceled · Built 1964
- [N54TA](https://openairdocs.org/deregistered/N54TA-1996-08-27.md): Aviat PITTS S-2B · S/N 5271 · Cancelled Aug 27, 1996 · Triennial form not returned · Tsunami Aviation Hawaii Inc
- [N1458D](https://openairdocs.org/deregistered/N1458D-1981-03-12.md): Cessna 170A · S/N 20142 · Cancelled Mar 12, 1981 · Black Byron E
- [N774FC](https://openairdocs.org/deregistered/N774FC-1972-02-04.md): Piper PA-28-140 · S/N 28-23336 · Cancelled Feb 4, 1972 · Kane Robert W
- [N7345T](https://openairdocs.org/deregistered/N7345T-1960-08-31.md): Cessna 172A · S/N 46945 · Cancelled Aug 31, 1960 · Hoffman Robert
- [N97293](https://openairdocs.org/deregistered/N97293-1949-08-19-108-293-9230404.md): Stinson 108-1 · S/N 108-293 · Cancelled Aug 19, 1949 · Island Aviation Ltd
- [N86155](https://openairdocs.org/deregistered/N86155-1949-05-13.md): Aeronca 11AC · S/N 11AC-585 · Cancelled May 13, 1949 · Built 1946 · Island Aviation Ltd

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

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