Sioux Falls, SD
Registered aircraft · 247
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 = 'SIOUX FALLS' 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 = 'SIOUX FALLS' 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.
N100RCEmbraer Executive EMB-505 · S/N 50500668N1039ABeech V35A · S/N D-9009N103TLVans RV-12 · S/N 120846N108BMTextron 680A · S/N 680A0108N108MESncan Societe Nationale De Con NORD 1000 · S/N 25N1127JRaytheon A36 · S/N E-3027N112SLAleshire T Stewart STARLITE · S/N 3495715N1167ATextron B300 · S/N FL-1167N117NTEmbraer EMB-550 · S/N 55000034N1188WNorth Wing Uum SPORT X2-A · S/N LS7008N1243NCessna T182T · S/N T18208642N1440RBeech 95-C55 · S/N TE-175N145SDEurocopter Deutschland MBB-BK 117 C-2 · S/N 9657N1460HAeronca 15AC · S/N 15AC-530N1485CCessna T182T · S/N T18208421N148FBCessna 525A · S/N 525A0148N1503ZBeech N35 · S/N D-6825N155BWTextron 525 · S/N 525-0988N155CGCessna 525 · S/N 525-0214N1562RGrumman American Avn. AA-5B · S/N AA5B-0062N158RAeropro CZ A220 · S/N 425 14N15MPCessna 560XL · S/N 560-5062N1623MCessna 182P · S/N 18264396N163TXNorth American AT-6F · S/N 121-42642N168GHRotorcraft Designs AGGRESSOR · S/N 002Sale reportedN170LMCessna 170 · S/N 18457N17703Beech A36 · S/N E-1007N180RCCessna 525C · S/N 525C0147N181PTCubcrafters CC11-160 · S/N CC11-00181N185HPBeech A36 · S/N E-1996N185MBCessna A185F · S/N 18504341N195CTRademacher Thomas L RV-14A · S/N 140789N199KKKusch Kim VANS RV-8A · S/N 81523N2008VCessna 120 · S/N 14219N208RBCessna 208B · S/N 208B5073N212MWMooney M-20G · S/N 690005N2173ECessna 182T · S/N 18281351N2187TPiper PA-28-180 · S/N 28-7205039Registration pendingN221SAAyers Steven D RV-6A · S/N 23147N22702Cessna 150H · S/N 15068459N22GNPiper PA-22-150 · S/N 22-3948N230RCCompagnie Daher TBM 700 · S/N 1299N234CTRademacher Thomas L RANS S21 · S/N 04220254N2359PPiper PA-18A · S/N 18-4245N23NELearjet 45 · S/N 539N240SDDiedrich David RAF 2000 GTX SE · S/N H2-00-11-472N2453YCessna 172D · S/N 17249753N247CLDiamond Aircraft Ind DA20-C1 · S/N C0047N2531YPiper PA-28-181 · S/N 28-8590083N25RTCessna 177RG · S/N 177RG1132
Back to Sioux Falls, SD