# Earlier aircraft under this name: Geological Survey

A list on [Geological Survey](https://openairdocs.org/faa-owner/GEOLOGICAL%20SURVEY.md).

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

- [N9196A](https://openairdocs.org/deregistered/N9196A-1985-02-14.md): Cessna 170A · S/N 18957 · Cancelled Feb 14, 1985 · Administratively canceled · Mcleod Albert D, Moss Point, MS
- [N9164Y](https://openairdocs.org/deregistered/N9164Y-1985-01-22.md): Piper PA-31-310 · S/N 31-217 · Cancelled Jan 22, 1985 · Administratively canceled · Turbo Sales And Leasing, Bowling Green, KY
- [N91354](https://openairdocs.org/deregistered/N91354-1984-05-26.md): Douglas B-26C · S/N 41-39468 · Cancelled May 26, 1984 · Administratively canceled · Reeder Flying Service Inc, Twin Falls, ID
- [N9155](https://openairdocs.org/deregistered/N9155-1984-05-26.md): Failing-Falconer Teal AMPHIBIAN 121 · S/N 121.199B · Cancelled May 26, 1984 · Administratively canceled · Olsen David A, Machias, ME
- [N9164M](https://openairdocs.org/deregistered/N9164M-1984-02-13.md): Cessna 182P · S/N 18264713 · Cancelled Feb 13, 1984 · Administratively canceled · Par Electrical Contractors Inc, North Kansas City, MO
- [N9200D](https://openairdocs.org/deregistered/N9200D-1984-01-10.md): Piper PA-22-160 · S/N 22-6259 · Cancelled Jan 10, 1984 · Administratively canceled · Janecek Frank H Jr, Windham, OH
- [N9153F](https://openairdocs.org/deregistered/N9153F-1983-11-23.md): Hughes 369HS · S/N 930513S · Cancelled Nov 23, 1983 · Administratively canceled · Widelitz Milton A, Los Angeles, CA
- [N9136R](https://openairdocs.org/deregistered/N9136R-1983-09-14.md): Cessna A188B · S/N 18802127T · Cancelled Sep 14, 1983 · Administratively canceled · Babcock James N, Cameron, MO
- [N9211C](https://openairdocs.org/deregistered/N9211C-1983-08-06.md): Cessna 180 · S/N 31310 · Cancelled Aug 6, 1983 · Administratively canceled · Mcwaid Russell E, Buckeye, AZ
- [N9201](https://openairdocs.org/deregistered/N9201-1983-07-20.md): Richard E Franklin JEANIES TEENIE · S/N RF013 · Cancelled Jul 20, 1983 · Administratively canceled · Dearinger Bill F, Prescott, AR
- [N9158U](https://openairdocs.org/deregistered/N9158U-1983-02-12.md): Cessna 150M · S/N 15078109 · Cancelled Feb 12, 1983 · Administratively canceled · Agape Air Inc, Durham, NH
- [N9195A](https://openairdocs.org/deregistered/N9195A-1983-02-12.md): Wagner-David VOLKSPLANE-I · S/N V12741 · Cancelled Feb 12, 1983 · Administratively canceled · Steere Joseph D, Gleneden Beach, OR
- [N9180](https://openairdocs.org/deregistered/N9180-1983-01-08.md): Schleicher AS-K13 · S/N 13178 · Cancelled Jan 8, 1983 · Administratively canceled · Adrian Soaring Club Inc, Toledo, OH
- [N9170K](https://openairdocs.org/deregistered/N9170K-1982-09-23.md): Stinson 108-1 · S/N 108-2170 · Cancelled Sep 23, 1982 · Administratively canceled · Clapp Tire Co Inc, Knoxville, TN
- [N74159](https://openairdocs.org/deregistered/N74159-1977-07-18.md): Hiller UH-12E · S/N 63-12774 · Cancelled Jul 18, 1977 · Administratively canceled · U S Dept Of Interior, Menlo Park, CA
- [N7403](https://openairdocs.org/deregistered/N7403-1976-05-27.md): Bell UH-1F · S/N 65-7961 · Cancelled May 27, 1976 · Administratively canceled · Department Of The Interior, Reston, VA
- [N91285](https://openairdocs.org/deregistered/N91285-1975-05-07.md): Dehavilland BEAVER U-6 · S/N 51-16569 · Cancelled May 7, 1975 · Administratively canceled · United States Department Of Interior, Prescott, AZ
- [N44633](https://openairdocs.org/deregistered/N44633-undated.md): Beech AT-11 · S/N 6518 · Cancellation date not recorded

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

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