# Cancelled registrations: Brookings, SD

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

Cancelled aircraft registrations in Brookings, SD.

- [N6807N](https://openairdocs.org/deregistered/N6807N-2021-08-17.md): Mooney M20C · S/N 680106 · Cancelled Aug 17, 2021 · Built 1968 · Koep Evan T
- [N49TF](https://openairdocs.org/deregistered/N49TF-2018-12-04.md): Lewis Donald R KR-2 · S/N DRL1 · Cancelled Dec 4, 2018 · Registration expired, pending cancellation · Built 1987 · Nelson Dustin E
- [N921RP](https://openairdocs.org/deregistered/N921RP-2018-08-10.md): Pruss Richard S KITFOX IV · S/N 1589 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1991 · Telkamp Randy R
- [N75448](https://openairdocs.org/deregistered/N75448-2018-01-26.md): Quicksilver MXII · S/N PDG 101748 · Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1984 · Gillespie Paul D
- [N461DA](https://openairdocs.org/deregistered/N461DA-2017-07-12.md): Cessna T337D · S/N 337-1186 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1969 · South Dakota State University
- [N63656](https://openairdocs.org/deregistered/N63656-2014-11-12.md): Consolidated Vultee BT-13A · S/N 2972 · Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1941 · Beulke David A
- [N61KC](https://openairdocs.org/deregistered/N61KC-2013-06-12.md): Nelson Michael AIR COMMAND 532 · S/N 61 · Cancelled Jun 12, 2013 · Sale reported, canceled
- [N100DN](https://openairdocs.org/deregistered/N100DN-2013-06-07.md): Nelson Davis S AMERICAN EAGLET · S/N 63 · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Nelson David S
- [N6333L](https://openairdocs.org/deregistered/N6333L-2013-04-29.md): American AA-1B · S/N AA1B-0033 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1972 · Moen Galyn P
- [N7227V](https://openairdocs.org/deregistered/N7227V-2013-02-20.md): Aero Commander CALLAIR A-9 · S/N 1264 · Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1968
- [N4601Y](https://openairdocs.org/deregistered/N4601Y-2012-12-07.md): Piper PA-25-235 · S/N 25-4293 · Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1967 · Lentsch Aerial Spraying
- [N6240](https://openairdocs.org/deregistered/N6240-2012-06-12.md): Bell OH-13E · S/N 511-4127 · Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Brookings Civil Defense
- [N4535P](https://openairdocs.org/deregistered/N4535P-2000-03-31.md): Grumman American Avn. AA-5B · S/N AA5B1271 · Cancelled Mar 31, 2000 · Aerosports Unlimited Inc
- [N541SD](https://openairdocs.org/deregistered/N541SD-1993-04-28.md): S Dakota ST Univ SORD-1A · S/N D15430 · Cancelled Apr 28, 1993 · Triennial form not returned · South Dakota State University
- [N201SD](https://openairdocs.org/deregistered/N201SD-1993-02-04.md): South Dakota State University KOLB ULTRASTAR · S/N D13470 · Cancelled Feb 4, 1993
- [N93528](https://openairdocs.org/deregistered/N93528-1974-09-26.md): Ercoupe 415-C · S/N 851 · Cancelled Sep 26, 1974 · Pavlick Anthony L
- [N1941V](https://openairdocs.org/deregistered/N1941V-1973-05-10.md): Cessna 140 · S/N 14147 · Cancelled May 10, 1973 · Exported to Canada · Johnson Thomas D
- [N28451](https://openairdocs.org/deregistered/N28451-1969-04-30.md): Luscombe 8A · S/N 1318 · Cancelled Apr 30, 1969 · Exported to Canada · Cooper Jim A
- [N1066E](https://openairdocs.org/deregistered/N1066E-1964-12-03.md): Aeronca 7AC · S/N 7AC-4617 · Cancelled Dec 3, 1964 · South Dakota State College
- [N9528K](https://openairdocs.org/deregistered/N9528K-1964-12-03.md): Stinson 108-2 · S/N 108-2528 · Cancelled Dec 3, 1964 · Fred Kellogg
- [N81697](https://openairdocs.org/deregistered/N81697-1959-04-13.md): Aeronca 7AC · S/N 7AC-316 · Cancelled Apr 13, 1959 · Exported to Canada · Built 1945 · Battig Marvin
- [N82317](https://openairdocs.org/deregistered/N82317-1954-12-09.md): Aeronca 7AC · S/N 7AC-945 · Cancelled Dec 9, 1954 · Built 1946 · Shearer Hubet E
- [N96928](https://openairdocs.org/deregistered/N96928-1950-01-18.md): Taylorcraft BC12-D · S/N 9228 · Cancelled Jan 18, 1950 · Built 1946 · Nelson Alvin V
- [N21047](https://openairdocs.org/deregistered/N21047-1944-04-01.md): Aeronca KCA · S/N KCA-28 · Cancelled Apr 1, 1944 · Snyder Bert R & Bert C Gednalske

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

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