Registered aircraft · 70

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

Query with 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 = 'PIERRE' ORDER BY g.n_number

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 = 'PIERRE'
  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 = 'PIERRE'
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.

N7570EChampion 7FC · S/N 7FC-262Built 1958 · Ogan Jerald N75CLBeech 58 · S/N TH-878Built 1977 · Clear LLC N773SDBeech C90A · S/N LJ1413Built 1995 · South Dakota Department Of Transportation N77JPCessna 180K · S/N 18053123Built 1979 · Dakota Aircraft Inc N79GPiper PA-30 · S/N 30-362Built 1964 · Burke Robert N804WTTrent Merkwan M24 XTREME · S/N 24245436Built 2024 · Merkway N8198CPiper PA-22-135 · S/N 22-2303Built 1954 · Lee Jesse D N8249PPiper PA-24-250 · S/N 24-3503Built 1963 · Ogan Steve G N844PBallard James R RV8 · S/N 82615Built 2007 · Hollingsworth Russell L N848ACAmerican Champion 8GCBC · S/N 643-2024Built 2024 · Ogan Michael J N8881PPiper PA-24-260 · S/N 24-4340Built 1965 · Ice Randall R N893SDAtlas South Dakota State Univ ALBATROSS · S/N T-00511South Dakota Board Of Regents N8991GCessna 340A · S/N 340A0329Built 1977 · All Trimmed Out LLC N89SDPiper PA-34-200T · S/N 34-8070089Built 1979 · State Of South Dakota N9023SBeech S35 · S/N D-7951Built 1965 · Two Wings LLC N9132PPiper PA-24-260 · S/N 24-4612Built 1966 · Ehrenfelt Linda Mae N926SDCubcrafters CC11-160 · S/N CC11-00411Built 2016 · Hollingsworth Rusty N9717PPiper PA-18-150 · S/N 18-7609001Built 1975 · Dakota Aircraft Inc N975KATextron B300 · S/N FL-975Built 2015 · South Dakota Department Of Transportation N9881UGrumman American Avn. AA-5A · S/N AA5A0281Built 1976 · Christensen Myra J Storms

Back to Pierre, SD