# Earlier aircraft under this name: Alston Gilbert

A list on [Alston Gilbert](https://openairdocs.org/faa-owner/ALSTON%20GILBERT.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N9200A](https://openairdocs.org/deregistered/N9200A-1993-01-13.md): Reeves James PJ-260 · S/N JR-2 · Cancelled Jan 13, 1993 · Administratively canceled · Reeves James I, Hernando, MS
- [N8488J](https://openairdocs.org/deregistered/N8488J-1985-01-22.md): Hopkins Jimmy D B-8M · S/N 407-62-3840 · Cancelled Jan 22, 1985 · Administratively canceled · Walton Byron E, Memphis, TN
- [N4257Y](https://openairdocs.org/deregistered/N4257Y-1984-12-06.md): Clark Joe BENSEN B-8M · S/N 1 · Cancelled Dec 6, 1984 · Administratively canceled · Clark Joe, Warner Robins, GA
- [N2558C](https://openairdocs.org/deregistered/N2558C-1984-11-05.md): Piper PA-38-112 · S/N 38-79A0229 · Cancelled Nov 5, 1984 · Administratively canceled · Bear Creek Aviation, Hampton, GA
- [N13398](https://openairdocs.org/deregistered/N13398-1984-07-03.md): Linch Kenneth T LINCH DUCE · S/N 473 · Cancelled Jul 3, 1984 · Administratively canceled · Linch Kenneth T, Nevada City, CA
- [N302F](https://openairdocs.org/deregistered/N302F-1984-03-10.md): Beech TC-45H · S/N AF-95 · Cancelled Mar 10, 1984 · Administratively canceled · Whaley Gerald, Hammondsport, NY
- [N13626](https://openairdocs.org/deregistered/N13626-1984-02-22.md): Fairchild C-119F · S/N 10836 · Cancelled Feb 22, 1984 · Administratively canceled · Supra International Inc, Fairbanks, AK
- [N83AX](https://openairdocs.org/deregistered/N83AX-1984-01-21.md): Catto Craig C CATTO ACRO X · S/N AX1 · Cancelled Jan 21, 1984 · Administratively canceled · Catto Craig C, Mokelumne Hill, CA
- [N9817U](https://openairdocs.org/deregistered/N9817U-1983-12-07.md): Grumman American Avn. AA-5A · S/N AA5A-0217 · Cancelled Dec 7, 1983 · Administratively canceled · Kelley Roger J, Sunland, CA
- [N231PY](https://openairdocs.org/deregistered/N231PY-1983-11-29.md): Mooney M20K · S/N 25-0350 · Cancelled Nov 29, 1983 · Administratively canceled · Miller Jean A, Austin, TX
- [N1335F](https://openairdocs.org/deregistered/N1335F-1983-11-23.md): Holsclaw Francis E SCORPION II/133 · S/N 949 · Cancelled Nov 23, 1983 · Administratively canceled · Holsclaw Francis E, Loomis, CA
- [N844TA](https://openairdocs.org/deregistered/N844TA-1983-05-21.md): Douglas DC-6 · S/N 44421 · Cancelled May 21, 1983 · Administratively canceled · Miami Air Lease Inc, Miami, FL
- [N445F](https://openairdocs.org/deregistered/N445F-1983-03-09.md): Dassault/Sud FAN JET FALCON SER F · S/N 441 · Cancelled Mar 9, 1983 · Administratively canceled · Falcon Jet Corporation, Teterboro, NJ
- [N9936B](https://openairdocs.org/deregistered/N9936B-1983-01-29.md): Cessna 172RG · S/N 172RG1086 · Cancelled Jan 29, 1983 · Administratively canceled · Transair Inc, Vacaville, CA
- [N1828R](https://openairdocs.org/deregistered/N1828R-1982-09-16.md): Cessna A185F · S/N 18502543 · Cancelled Sep 16, 1982 · Administratively canceled · Kelly Dennis J, Anchorage, AK
- [N14486](https://openairdocs.org/deregistered/N14486-1982-04-15.md): Wagner ROTORCRAFT · S/N 1129 · Cancelled Apr 15, 1982 · Administratively canceled · Riemer Earl M, Chicago, IL

## 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_name = 'ALSTON GILBERT' OR list_contains(d.other_registrant_names, 'ALSTON GILBERT')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/ALSTON%20GILBERT/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.
