New Underwood, SD

Registered aircraft · 29

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1005NAir Tractor AT-401 · S/N 401-0692Built 1988 · Madsen Travis EN19247Cessna 150L · S/N 15074271Built 1973 · Madsen Dalton EN2213VCessna 140 · S/N 14444Built 1948 · Hackens Donald GN2438VCessna 140 · S/N 14688Built 1948 · Madsen James EN24502Piper J3L · S/N 3221Built 1939 · Puckett Trevor WN323GLDJI AGRAS T40 · S/N 64TBL5M002002PHughes Kelly HN3390NPiper J3C-65 · S/N 22592Built 1946 · Hackens Donald GN3744APiper PA-22 · S/N 22-1987Built 1954 · Phillips Mark WN3782EAeronca 7AC · S/N 7AC-7065Built 1947 · Olson David AN4106LCessna 172G · S/N 17254175Built 1966 · Hackens Bryan JayN42751Piper J3C-65 · S/N 15056Built 1945 · Madsen James EN43835Taylorcraft BC12-D · S/N 7494Built 1946 · Puckett Trevor WN5655JMaule M-6-235 · S/N 7462CSale reported, pending cancellationBuilt 1984N6120ZPiper PA-25 · S/N 25-140Built 1960 · H & H Ag Aviation IncN6196ZPiper PA-25 · S/N 25-230Built 1960 · H&H Ag-Aviation IncN6447ZPiper PA-25 · S/N 25-607Built 1961 · H&H Ag Aviation IncN657CAPiper PA-28-140 · S/N 28-22371Built 1966 · Olson David AN8584PPiper PA-24-260 · S/N 24-4041Built 1964 · Hackens Donald GN8585DPiper PA-18A 150 · S/N 18-6244Built 1957 · Madsen Travis EN88024Eagle EAGLE DW-1 · S/N DW-1-0021-81Built 1981 · Madsen Travis EN8802YEagle EAGLE DW-1 · S/N DW-1-0019-81Built 1981 · Madsen Travis EN8802ZEagle EAGLE DW-1 · S/N DW-1-1002081Built 1981 · Madsen Travis EN8803REagle EAGLE DW-1 · S/N DW-1-0024-81Built 1981 · Madsen Travis EN8806KEagle EAGLE DW-1 · S/N DW-1-0041-81Built 1981 · Madsen Travis EN8806LEagle EAGLE DW-1 · S/N DW-1-0042-81Built 1981 · Madsen Travis EN8807ZEagle Aircraft Co.-Bellanca EAGLE DW-1 · S/N DW-1-0049-81Built 1981 · Madsen Travis EN89903Cessna 140 · S/N 8948Built 1946 · Covey Zachary JN9101XCessna 182D · S/N 18253501Built 1961 · Madsen Travis EN9510PPiper PA-24-260 · S/N 24-5028Built 1972 · Madsen Travis E
Back to New Underwood, SD