# Registered aircraft: Piedmont, SD

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N1343W](https://openairdocs.org/aircraft/N1343W.md): Mooney M20C · S/N 2693 · Built 1964 · Infinity Aviation LLC
- [N15CP](https://openairdocs.org/aircraft/N15CP.md): Ryan NAVION A · S/N NAV-4-1243 · Built 1948 · Bedingfield John R
- [N189AA](https://openairdocs.org/aircraft/N189AA.md): Beech K35 · S/N D-6024 · Built 1959 · Jungclaus Karl F
- [N22157](https://openairdocs.org/aircraft/N22157.md): Cessna 150H · S/N 15068104 · Built 1967 · Potter Colin J
- [N2722M](https://openairdocs.org/aircraft/N2722M.md): Piper PA-12 · S/N 12-1133 · Built 1946 · Infinity Aviation LLC
- [N30EE](https://openairdocs.org/aircraft/N30EE.md): Cessna 414A · S/N 414A0443 · Built 1979 · Enterprises Aviation Inc
- [N5130T](https://openairdocs.org/aircraft/N5130T.md): Champion 7GCBC · S/N 76 · Infinity Aviation LLC
- [N5179X](https://openairdocs.org/aircraft/N5179X.md): Champion 7KCAB · S/N 189 · Built 1969 · Kor Reese W
- [N539GC](https://openairdocs.org/aircraft/N539GC.md): Aeronca 11AC · S/N 11AC-1850 · Kor Aviation LLC
- [N60895](https://openairdocs.org/aircraft/N60895.md): Cessna 150J · S/N 15070652 · Built 1969 · Donald Williamson
- [N6564P](https://openairdocs.org/aircraft/N6564P.md): Piper PA-24 · S/N 24-1686 · Built 1959 · Infinity Aviation LLC
- [N678WS](https://openairdocs.org/aircraft/N678WS.md): Piper PA-12 · S/N 12-233 · Built 1946 · Infinity Aviation LLC
- [N7265T](https://openairdocs.org/aircraft/N7265T.md): Cessna 172A · S/N 46865 · Built 1959 · Kor Aviation LLC
- [N72953](https://openairdocs.org/aircraft/N72953.md): Cessna 140 · S/N 10151 · Kor Reese W
- [N79870](https://openairdocs.org/aircraft/N79870.md): Mooney M20E · S/N 533 · Giles Aviation LLC
- [N8443R](https://openairdocs.org/aircraft/N8443R.md): Piper PA-28-140 · S/N 28-22326 · Built 1966 · Kor Aviation LLC
- [N8595Y](https://openairdocs.org/aircraft/N8595Y.md): Piper PA-30 · S/N 30-1624 · Built 1967 · Kor Reese W
- [N92637](https://openairdocs.org/aircraft/N92637.md): Piper J3C-65 · S/N 17008 · Built 1946 · Jungclaus Karl F
- [N9473S](https://openairdocs.org/aircraft/N9473S.md): Williamson Donahue J HIGHLANDER · S/N JA583-04-20 · Built 2022 · Williamson Donahue J
- [N9662M](https://openairdocs.org/aircraft/N9662M.md): Mooney M20F · S/N 670239 · Built 1966 · Potter Colin
- [N9944N](https://openairdocs.org/aircraft/N9944N.md): Cessna 180J · S/N 18052599 · Built 1975 · Jungclaus Karl F

## 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_state = 'SD' AND g.registrant_city = 'PIEDMONT'
ORDER BY g.n_number
```

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