# Cancelled registrations: Lake City, AR

A list on [Lake City, AR](https://openairdocs.org/faa-place/AR/Lake%20City.md).

Cancelled aircraft registrations in Lake City, AR.

- [N108DA](https://openairdocs.org/deregistered/N108DA-2020-12-05.md): Bell 47G-2 · S/N 2474 · Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1960 · Curtis Fletcher D
- [N9877Y](https://openairdocs.org/deregistered/N9877Y-2018-02-12.md): Champion 7KC · S/N 7KC-2 · Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1961 · Spencer Louella
- [N4483Q](https://openairdocs.org/deregistered/N4483Q-2014-12-17.md): Cessna A188B · S/N 18800883 · Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1972 · Haggenmacher Scott
- [N273HQ](https://openairdocs.org/deregistered/N273HQ-2014-11-26.md): Crosby Harold CHALLENGER II · S/N CH20393R0958 · Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1993 · Hutcheson Jason J
- [N5192N](https://openairdocs.org/deregistered/N5192N-2013-07-29.md): Beggs Ricky CHALLENGER 2 · S/N CH2 0491 G 0681 · Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1992
- [N97166](https://openairdocs.org/deregistered/N97166-2013-07-16.md): Stinson 108 · S/N 108-166 · Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1946
- [N56CH](https://openairdocs.org/deregistered/N56CH-2013-07-15.md): Hites P.D.Q.-2 · S/N 1-44 · Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1978
- [N8041V](https://openairdocs.org/deregistered/N8041V-2013-05-13.md): Cessna A188 · S/N 188-0291 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1967 · Wood Ronald C DBA
- [N78MH](https://openairdocs.org/deregistered/N78MH-2013-02-26.md): Air Tractor AT-301 · S/N 301-0008 · Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1975
- [N7526Z](https://openairdocs.org/deregistered/N7526Z-2013-02-21.md): Piper PA-25-235 · S/N 25-3568 · Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1965
- [N12044](https://openairdocs.org/deregistered/N12044-2012-08-30.md): Volmer Amphibian A · S/N RS0-1 · Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1965
- [N2494V](https://openairdocs.org/deregistered/N2494V-2012-08-21.md): Cessna 140 · S/N 14763 · Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1948
- [N2253F](https://openairdocs.org/deregistered/N2253F-2012-08-13.md): Nord 3202 · S/N 13 · Cancelled Aug 13, 2012 · Sale reported, canceled
- [N2254B](https://openairdocs.org/deregistered/N2254B-2012-08-13.md): Nord 3202 · S/N 58 · Cancelled Aug 13, 2012 · Sale reported, canceled
- [N1030C](https://openairdocs.org/deregistered/N1030C-2012-05-11.md): Haggenmacher Coleman W BENSEN GYROCOPTER · S/N 2 · Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1980 · Haggenmacher Coleman W
- [N91233](https://openairdocs.org/deregistered/N91233-2009-09-15.md): Cessna A188B · S/N 18802033T · Cancelled Sep 15, 2009 · Registration revoked · Built 1975 · Harmon Jay
- [N972TB](https://openairdocs.org/deregistered/N972TB-2004-06-02.md): Bowman Jim JR VP-2 · S/N 001 · Cancelled Jun 2, 2004 · Triennial form not returned · Bowman Jim Jr
- [N8910Q](https://openairdocs.org/deregistered/N8910Q-1997-05-21.md): Aero Commander S2R · S/N 1580R · Cancelled May 21, 1997 · Triennial form not returned · Jay Harmon Inc
- [N8036F](https://openairdocs.org/deregistered/N8036F-1991-10-28.md): Cessna 150F · S/N 15064136 · Cancelled Oct 28, 1991 · Triennial form not returned · Wright Lonnie
- [N4655Y](https://openairdocs.org/deregistered/N4655Y-1981-01-19.md): Piper PA-25-235 · S/N 25-4376 · Cancelled Jan 19, 1981 · Exported to Mexico · Built 1967 · Harmon Jay DBA Jay Harmon Flying Service
- [N8048G](https://openairdocs.org/deregistered/N8048G-1976-10-07.md): Cessna A188B · S/N 18801224T · Cancelled Oct 7, 1976 · Exported to Canada · Harmon Jay H

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

This list as a web page: https://openairdocs.org/faa-place/AR/Lake%20City/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.