# Registered aircraft: Smith David C

A list on [Smith David C](https://openairdocs.org/faa-owner/SMITH%20DAVID%20C.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N1472A](https://openairdocs.org/aircraft/N1472A.md): Piper PA-22 · S/N 22-379 · Built 1952 · Donnelly, ID · Co-owner with Smith Wesley P
- [N2207A](https://openairdocs.org/aircraft/N2207A.md): Piper PA-18-135 · S/N 18-1882 · Built 1951 · Brewster, WA
- [N226JK](https://openairdocs.org/aircraft/N226JK.md): Cub Crafters PA18-150 · S/N 9965CC · Built 2004 · Brewster, WA
- [N48332](https://openairdocs.org/aircraft/N48332.md): Pdps Pzl-Bielsko SZD-48-3 · S/N B-2070 · Richmond, VA
- [N633U](https://openairdocs.org/aircraft/N633U.md): Grumman G-164 · S/N 369 · Built 1965 · Brewster, WA
- [N65203](https://openairdocs.org/aircraft/N65203.md): Cessna T-50 · S/N 3124 · Built 1942 · Brewster, WA
- [N6594](https://openairdocs.org/aircraft/N6594.md): Grumman G-164A · S/N 733 · Built 1970 · Malott, WA
- [N6964K](https://openairdocs.org/aircraft/N6964K.md): Grumman Acft ENG Cor-Schweizer G-164B · S/N 529B · Built 1979 · Malott, WA
- [N70277](https://openairdocs.org/aircraft/N70277.md): Piper J3C-65 · S/N 17258 · Built 1946 · Brewster, WA
- [N7228](https://openairdocs.org/aircraft/N7228.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 903 · Built 1972 · Brewster, WA
- [N7432B](https://openairdocs.org/aircraft/N7432B.md): Champion 7EC · S/N 7EC-470 · Built 1956 · Malott, WA
- [N7470Z](https://openairdocs.org/aircraft/N7470Z.md): Piper PA-25-235 · S/N 25-3473 · Built 1965 · Malott, WA
- [N7982](https://openairdocs.org/aircraft/N7982.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 846 · First renewal notice · Built 1971 · Brewster, WA
- [N8104K](https://openairdocs.org/aircraft/N8104K.md): Gulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 565B · Malott, WA
- [N8296K](https://openairdocs.org/aircraft/N8296K.md): Gulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 650B · Brewster, WA
- [N90307](https://openairdocs.org/aircraft/N90307.md): Bell 206B II · S/N 1747 · Built 1975 · Brewster, WA

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'SMITH DAVID C' OR list_contains(g.other_registrant_names, 'SMITH DAVID C')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/SMITH%20DAVID%20C/aircraft

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.