# Registered aircraft: New Underwood, SD

A list on [New Underwood, SD](https://openairdocs.org/faa-place/SD/New%20Underwood.md).

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

- [N1005N](https://openairdocs.org/aircraft/N1005N.md): Air Tractor AT-401 · S/N 401-0692 · Built 1988 · Madsen Travis E
- [N19247](https://openairdocs.org/aircraft/N19247.md): Cessna 150L · S/N 15074271 · Built 1973 · Madsen Dalton E
- [N2213V](https://openairdocs.org/aircraft/N2213V.md): Cessna 140 · S/N 14444 · Built 1948 · Hackens Donald G
- [N2438V](https://openairdocs.org/aircraft/N2438V.md): Cessna 140 · S/N 14688 · Built 1948 · Madsen James E
- [N24502](https://openairdocs.org/aircraft/N24502.md): Piper J3L · S/N 3221 · Built 1939 · Puckett Trevor W
- [N323GL](https://openairdocs.org/aircraft/N323GL.md): DJI AGRAS T40 · S/N 64TBL5M002002P · Hughes Kelly H
- [N3390N](https://openairdocs.org/aircraft/N3390N.md): Piper J3C-65 · S/N 22592 · Built 1946 · Hackens Donald G
- [N3744A](https://openairdocs.org/aircraft/N3744A.md): Piper PA-22 · S/N 22-1987 · Built 1954 · Phillips Mark W
- [N3782E](https://openairdocs.org/aircraft/N3782E.md): Aeronca 7AC · S/N 7AC-7065 · Built 1947 · Olson David A
- [N4106L](https://openairdocs.org/aircraft/N4106L.md): Cessna 172G · S/N 17254175 · Built 1966 · Hackens Bryan Jay
- [N42751](https://openairdocs.org/aircraft/N42751.md): Piper J3C-65 · S/N 15056 · Built 1945 · Madsen James E
- [N43835](https://openairdocs.org/aircraft/N43835.md): Taylorcraft BC12-D · S/N 7494 · Built 1946 · Puckett Trevor W
- [N5655J](https://openairdocs.org/aircraft/N5655J.md): Maule M-6-235 · S/N 7462C · Sale reported, pending cancellation · Built 1984
- [N6120Z](https://openairdocs.org/aircraft/N6120Z.md): Piper PA-25 · S/N 25-140 · Built 1960 · H & H Ag Aviation Inc
- [N6196Z](https://openairdocs.org/aircraft/N6196Z.md): Piper PA-25 · S/N 25-230 · Built 1960 · H&H Ag-Aviation Inc
- [N6447Z](https://openairdocs.org/aircraft/N6447Z.md): Piper PA-25 · S/N 25-607 · Built 1961 · H&H Ag Aviation Inc
- [N657CA](https://openairdocs.org/aircraft/N657CA.md): Piper PA-28-140 · S/N 28-22371 · Built 1966 · Olson David A
- [N8584P](https://openairdocs.org/aircraft/N8584P.md): Piper PA-24-260 · S/N 24-4041 · Built 1964 · Hackens Donald G
- [N8585D](https://openairdocs.org/aircraft/N8585D.md): Piper PA-18A 150 · S/N 18-6244 · Built 1957 · Madsen Travis E
- [N88024](https://openairdocs.org/aircraft/N88024.md): Eagle EAGLE DW-1 · S/N DW-1-0021-81 · Built 1981 · Madsen Travis E
- [N8802Y](https://openairdocs.org/aircraft/N8802Y.md): Eagle EAGLE DW-1 · S/N DW-1-0019-81 · Built 1981 · Madsen Travis E
- [N8802Z](https://openairdocs.org/aircraft/N8802Z.md): Eagle EAGLE DW-1 · S/N DW-1-1002081 · Built 1981 · Madsen Travis E
- [N8803R](https://openairdocs.org/aircraft/N8803R.md): Eagle EAGLE DW-1 · S/N DW-1-0024-81 · Built 1981 · Madsen Travis E
- [N8806K](https://openairdocs.org/aircraft/N8806K.md): Eagle EAGLE DW-1 · S/N DW-1-0041-81 · Built 1981 · Madsen Travis E
- [N8806L](https://openairdocs.org/aircraft/N8806L.md): Eagle EAGLE DW-1 · S/N DW-1-0042-81 · Built 1981 · Madsen Travis E
- [N8807Z](https://openairdocs.org/aircraft/N8807Z.md): Eagle Aircraft Co.-Bellanca EAGLE DW-1 · S/N DW-1-0049-81 · Built 1981 · Madsen Travis E
- [N89903](https://openairdocs.org/aircraft/N89903.md): Cessna 140 · S/N 8948 · Built 1946 · Covey Zachary J
- [N9101X](https://openairdocs.org/aircraft/N9101X.md): Cessna 182D · S/N 18253501 · Built 1961 · Madsen Travis E
- [N9510P](https://openairdocs.org/aircraft/N9510P.md): Piper PA-24-260 · S/N 24-5028 · Built 1972 · Madsen Travis E

## 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 = 'NEW UNDERWOOD'
ORDER BY g.n_number
```

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