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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1005NAir Tractor AT-401 · S/N 401-0692N19247Cessna 150L · S/N 15074271N2213VCessna 140 · S/N 14444N2438VCessna 140 · S/N 14688N24502Piper J3L · S/N 3221N323GLDJI AGRAS T40 · S/N 64TBL5M002002PN3390NPiper J3C-65 · S/N 22592N3744APiper PA-22 · S/N 22-1987N3782EAeronca 7AC · S/N 7AC-7065N4106LCessna 172G · S/N 17254175N42751Piper J3C-65 · S/N 15056N43835Taylorcraft BC12-D · S/N 7494N5655JMaule M-6-235 · S/N 7462CSale reported, pending cancellationN6120ZPiper PA-25 · S/N 25-140N6196ZPiper PA-25 · S/N 25-230N6447ZPiper PA-25 · S/N 25-607N657CAPiper PA-28-140 · S/N 28-22371N8584PPiper PA-24-260 · S/N 24-4041N8585DPiper PA-18A 150 · S/N 18-6244N88024Eagle EAGLE DW-1 · S/N DW-1-0021-81N8802YEagle EAGLE DW-1 · S/N DW-1-0019-81N8802ZEagle EAGLE DW-1 · S/N DW-1-1002081N8803REagle EAGLE DW-1 · S/N DW-1-0024-81N8806KEagle EAGLE DW-1 · S/N DW-1-0041-81N8806LEagle EAGLE DW-1 · S/N DW-1-0042-81N8807ZEagle Aircraft Co.-Bellanca EAGLE DW-1 · S/N DW-1-0049-81N89903Cessna 140 · S/N 8948N9101XCessna 182D · S/N 18253501N9510PPiper PA-24-260 · S/N 24-5028
Back to New Underwood, SD