# Earlier aircraft under this name: Foglia Michael

A list on [Foglia Michael](https://openairdocs.org/faa-owner/FOGLIA%20MICHAEL.md).

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

- [N29HT](https://openairdocs.org/deregistered/N29HT-1984-10-26.md): Cessna 340A · S/N 340A0515 · Cancelled Oct 26, 1984 · Administratively canceled · Kanter Joel M, Kentfield, CA
- [N27028](https://openairdocs.org/deregistered/N27028-1984-10-25.md): Balloon Works FIREFLY 6B · S/N 6642 · Cancelled Oct 25, 1984 · Administratively canceled · Garvin Steven C, Muscatine, IA
- [N2702V](https://openairdocs.org/deregistered/N2702V-1984-10-03.md): Cessna 177RG · S/N 177RG0662 · Cancelled Oct 3, 1984 · Administratively canceled · Elliott Arthur Robert, Dallas, TX
- [N2741J](https://openairdocs.org/deregistered/N2741J-1984-07-24.md): Cessna A150M · S/N A1500579 · Cancelled Jul 24, 1984 · Administratively canceled · Roosevelt Roads Navy Flying Club, Ceiba, PR
- [N26506](https://openairdocs.org/deregistered/N26506-1984-07-11.md): Cessna 402C · S/N 402C0340 · Cancelled Jul 11, 1984 · Administratively canceled · Creagh James G, Mckeesport, PA
- [N27670](https://openairdocs.org/deregistered/N27670-1984-07-11.md): Bell 206B · S/N 2756 · Cancelled Jul 11, 1984 · Administratively canceled · Ronson Aviation Inc, Trenton, NJ
- [N2879](https://openairdocs.org/deregistered/N2879-1984-07-11.md): Satterfield VOLKSPLANE · S/N DS-1 · Cancelled Jul 11, 1984 · Administratively canceled · Reed Jacky O, Crossville, TN
- [N2754Z](https://openairdocs.org/deregistered/N2754Z-1984-07-06.md): Bellanca 8KCAB · S/N 369-78 · Cancelled Jul 6, 1984 · Administratively canceled · Zimmerman Victoria, Troy, OH
- [N275WD](https://openairdocs.org/deregistered/N275WD-1984-07-03.md): Story WD-6 · S/N 2 · Cancelled Jul 3, 1984 · Administratively canceled · Miller C E Ptnr, Portland, OR
- [N2894N](https://openairdocs.org/deregistered/N2894N-1984-07-03.md): Piper PA-28-181 · S/N 28-7990536 · Cancelled Jul 3, 1984 · Administratively canceled · Bartlett Theo F Md, Lake Havaso City, AZ
- [N2677R](https://openairdocs.org/deregistered/N2677R-1984-03-27.md): Cessna 182K · S/N 18258377 · Cancelled Mar 27, 1984 · Administratively canceled · North American Aerodynamics Inc, Flemington, NJ
- [N2795Q](https://openairdocs.org/deregistered/N2795Q-1984-03-27.md): Cessna A185F · S/N 18503531 · Cancelled Mar 27, 1984 · Administratively canceled · Missionary Aviation Fellowship, Redlands, CA
- [N2827A](https://openairdocs.org/deregistered/N2827A-1984-03-27.md): Cessna 180 · S/N 30027 · Cancelled Mar 27, 1984 · Administratively canceled · Baim V R, Anchorage, AK
- [N2834J](https://openairdocs.org/deregistered/N2834J-1984-03-14.md): Cessna T188C · S/N T18803528T · Cancelled Mar 14, 1984 · Administratively canceled · Morgan Boyd J, Belgrade, MT
- [N28714](https://openairdocs.org/deregistered/N28714-1984-03-07.md): Boeing 707-331B · S/N 18408 · Cancelled Mar 7, 1984 · Administratively canceled · Trans World Airlines Inc, New York, NY
- [N85JK](https://openairdocs.org/deregistered/N85JK-1984-03-07.md): Cessna 340A · S/N 340A0700 · Cancelled Mar 7, 1984 · Administratively canceled · Goodman Melvyn J, Chicago, IL
- [N2889U](https://openairdocs.org/deregistered/N2889U-1984-01-21.md): Cessna 172D · S/N 17250489 · Cancelled Jan 21, 1984 · Administratively canceled · Mc Guire And Son, Seymour, TX
- [N2711Q](https://openairdocs.org/deregistered/N2711Q-1983-11-23.md): Cessna 182K · S/N 18257911 · Cancelled Nov 23, 1983 · Administratively canceled · Timberlane Lumber Company, Eugene, OR
- [N280F](https://openairdocs.org/deregistered/N280F-1978-01-26.md): Lockheed 188A · S/N 1076 · Cancelled Jan 26, 1978 · Administratively canceled · Integrity Aircraft Sales Inc, Pompano Beach, FL
- [N2788D](https://openairdocs.org/deregistered/N2788D-1977-12-07.md): Cessna 170B · S/N 25330 · Cancelled Dec 7, 1977 · Administratively canceled · Jecklin Donald L, Peosta, IA

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

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