# Registered aircraft: Smith Miniplane DSA-1

A list on [Smith Miniplane DSA-1](https://openairdocs.org/model/smith-miniplane-dsa-1.md).

Aircraft of this model in the FAA registry, by N-number.

- [N1475](https://openairdocs.org/aircraft/N1475.md): Magee Richard A · Virden, IL · Built 1970 · S/N 41
- [N147H](https://openairdocs.org/aircraft/N147H.md): Leroy Philippe G · Willcox, AZ · Built 1964 · S/N DH41
- [N1711](https://openairdocs.org/aircraft/N1711.md): Burgess Mark W · Greene, ME · S/N 1
- [N179VP](https://openairdocs.org/aircraft/N179VP.md): Bas Part Sales LLC · Greeley, CO · S/N 1
- [N25P](https://openairdocs.org/aircraft/N25P.md): Williamson Tracy C · Texarkana, TX · S/N HCP-2
- [N341S](https://openairdocs.org/aircraft/N341S.md): Rebr Holdings LLC · Hernando, FL · S/N 1939
- [N391Y](https://openairdocs.org/aircraft/N391Y.md): Ball Charles D · Ocala, FL · Built 1965 · S/N 1
- [N3986](https://openairdocs.org/aircraft/N3986.md): Harter James A · Centerville, OH · Built 1975 · S/N OBT-1
- [N4756G](https://openairdocs.org/aircraft/N4756G.md): Oliver Randy M · Limerick, ME · Built 1973 · S/N G-1
- [N4843](https://openairdocs.org/aircraft/N4843.md): Burke Timothy E · Temple, TX · S/N RWW-1
- [N5166](https://openairdocs.org/aircraft/N5166.md): Becker James J · Oconomowoc, WI · Built 1969 · S/N JB-1
- [N5167](https://openairdocs.org/aircraft/N5167.md): Bares Maurice G · Youngsville, LA · Built 1970 · S/N DSA-1-100
- [N558A](https://openairdocs.org/aircraft/N558A.md): Galindo Don R Jr · Walnut Grove, CA · Built 1963 · S/N SL-1
- [N559A](https://openairdocs.org/aircraft/N559A.md): Stewart Emmerson C Jr · Waynesville, OH · Built 1963 · S/N FD-1
- [N791J](https://openairdocs.org/aircraft/N791J.md): Wilson Cliff · Harrison, ID · S/N 633747
- [N79E](https://openairdocs.org/aircraft/N79E.md): Heyrman Larry L · New Franken, WI · Built 1963 · S/N ABEE-1
- [N7JH](https://openairdocs.org/aircraft/N7JH.md): Hultsch Kevin · Lockport, IL · Built 1978 · S/N JH-1
- [N91271](https://openairdocs.org/aircraft/N91271.md): Morrow David R · Maynardville, TN · Built 1965 · S/N BF1001
- [N931Z](https://openairdocs.org/aircraft/N931Z.md): Mason Fred B · Waterford, OH · Built 1968 · S/N SE-1

## The whole list in SQL

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

```sql
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('83501K9', '835010A', '835010D', '835010U', '835010Z', '83501L5', '83501LD', '83501LV', '83501N7', '83501S1', '83501SV', '83501V4', '83501VD', '83501VG', '83501VP', '83501XJ', '83501YM', '83501Z3', '835010P', '835010R', '83501LK', '83501LW', '83501M1', '83501MF', '83501MR', '83501NX', '83501P3', '83501Q4', '83501Q9', '83501QD', '83501QJ', '83501QP', '83501RP', '83501RV', '83501RX', '83501RY', '83501S3', '83501SF', '83501SR', '83501ST', '83501T7', '83501TB', '83501U8', '83501UH', '83501UT', '83501UZ', '83501V9', '83501VJ', '83501VZ', '83501W5', '83501WK', '83501WV', '83501X1', '83501X4', '83501XM', '83501YB', '83501YS', '83501ZA', '83501ZH', '83501ZT')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/smith-miniplane-dsa-1/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.