OpenAirDocs.org
Piedmont, SC

Registered aircraft · 23

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 = 'SC' AND g.registrant_city = 'PIEDMONT'
  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.

N194BAPiper PA-38-112 · S/N 38-82A0063Unruly Passengers LLCN19TFRobinson Helicopter R44 II · S/N 14620Built 2023 · Summerhill Property LLCN2281GCessna 182B · S/N 51581Built 1958 · Burriss James E JrN24025Beech B19 · S/N MB-839Built 1977 · Birx Ethan SN2927YCessna 182E · S/N 18253927Built 1962 · Reynolds Nathan W JrN35609Cessna 172I · S/N 17256861Built 1968 · Unruly Passengers LLCN3607JCessna 150G · S/N 15064907Built 1966 · Smith Zachary LN381DACirrus Design SR20 · S/N 10946Built 2025 · Acla Aviation LLCN420YPLuis Portocarrero Valda EXEC 90 · S/N E32-3131H5123Ellis William EN5317BCessna 182 · S/N 33317Built 1956 · Wilson Bach MN5441BCessna 182 · S/N 33441Built 1956 · Four One Bravo LLCN5548LCessna 152 · S/N 15284350Built 1980 · Unruly Passengers LLCN569TTVans RV-12IS · S/N 121047Built 2020 · Yanniello RobertN5771RCessna 172G · S/N 17253440Built 1965 · Wilson Bach MyrlN581BCEmbraer Executive EMB-505 · S/N 50500312Built 2015 · Bear Air II LLCN62707Piper PA-23-250 · S/N 27-7654163Registration pendingBuilt 1976N668QBeech B95 · S/N TD-326Unruly Passengers LLCN734RHCessna 172N · S/N 17269051Built 1977 · Fricks Philip BN7380KCessna R172K · S/N R1722067Built 1976 · Kxp Ventures LLCN7593HPiper PA-12 · S/N 12-467Built 1946 · Fricks Philip BN830MCPiper PA-31-310 · S/N 31-830Built 1972 · Armor Packaging CorpN8422FCessna 402 · S/N 402-0270Townsend DavidN92677Cessna 182N · S/N 18260307Built 1970 · Burriss James E
Back to Piedmont, SC