Custer, SD
Registered aircraft · 45
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'CUSTER' 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 = 'CUSTER' 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.
N11XXBellanca 7GCAA · S/N 245-72N1639KLuscombe 8E · S/N 4366N1957ZBell 206-L4 · S/N 52109N2077HErcoupe 415-D · S/N 2700N22JWWinter Jack W WINTER VLMR AMP VJ22 · S/N 855N234JNEiriavion PIK 20E · S/N 20229N2840MPiper PA-28-181 · S/N 28-7890272N284MXHamby Scott KOLB TWNSTR MARK III · S/N M3X04-3-00063N303Stinson 108 · S/N 108-536N3382MPiper PA-12 · S/N 12-2229N3540FCessna 182J · S/N 18257540N3726HErcoupe 415-C · S/N 4351N389BWPiper PA-32R-301 · S/N 3246033N405KDUltramagic S A N-250 · S/N 250/110N440DRRobinson Helicopter R44 II · S/N 12818N441DRRobinson Helicopter R44 II · S/N 10375N443DRRobinson Helicopter R44 II · S/N 13451N4592JJohn Oconnell MUTT CUB · S/N 1N492TWBalony Kubicek Spol Sro BB37Z · S/N 1353N5003EHead Balloons AX9-118 · S/N 474N5069BAerostar International S81A · S/N S81A-3016N516YKTalos Drones T60X · S/N 2104F7EZW255P001N9BHN5254MAerostar International S-77A · S/N S77A-3032N525PSArbc Inc DBA Lindstrand 105A · S/N 5792N5292MAerostar International WEST 1 · S/N S46A0001N5314DWest Kay ANN WEST-2 · S/N 001N5314ZAerostar International S-57A · S/N S57A-3233N5315JWest Kay ANN WEST-2 · S/N 003N54JWBurkhart Grob G-109B · S/N 6376N605KDArbc Inc DBA Lindstrand 260A · S/N 5770N61669Golden Circle Air T-BIRD · S/N 2746104N620AACirrus Design SR22T · S/N 2118N6319SAerostar International RAVEN S49A · S/N S49A-3006N644VBRobinson Helicopter R44 II · S/N 13978N7245KPiper PA-18 · S/N 18-140N73WFCirrus Design SR22 · S/N 1816N747PMCessna 182M · S/N 18259564N748GHelicopteres Guimbal CABRI G2 · S/N 1319N8096GJagr Joseph AVIAT SOLO · S/N 001N87361Engineering & Research 415-C · S/N 534N9100XAerostar International RAVEN S57-A · S/N S57A-3157N9139VAerostar International RX-7 · S/N RX7-3329N9145YStinson 108-2 · S/N 108-3302N91KBeech V35B · S/N D-9764N99284Engineering & Research ERCOUPE 415-D · S/N 1907
Back to Custer, SD