OpenAirDocs.org
Sumter, SC

Registered aircraft · 31

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

N124DRCessna 340 · S/N 340-0219Built 1973 · Leventis Phil PN1546XAir Tractor AT-401 · S/N 401-0874Built 1992 · Hopkins Robert E JrN1858JRockwell International 112TC · S/N 13031Koenig Darrell LeeN199JBPiper PA-28R-200 · S/N 28R-7135100Built 1971 · Oew Aviation LLCN199WTFristrom John E RV-7A · S/N 74085Built 2019 · Radford Jeff PN20003Weatherly 620B · S/N 1552Built 1992 · Hopkins Robert E JrN265SHGulfstream Aerospace GIV-X (G450) · S/N 4290Built 2013 · Sea Hunt Boat Mfg Co IncN2730ECessna 172N · S/N 17271309Built 1978 · Oew Aviation LLCN3194XBeech 58 · S/N TH-1723Built 1994 · Autry Mark TN3506FPalmetto Electronics FLIGHTSTAR II · S/N 344Built 2002 · Rowe Jasen MN3544LGreat Lakes 2T-1A-2 · S/N 0800Built 1978 · Labounty Dana GN38345Piper J3L · S/N 6953May Richard SN420NJHonda HA-420 · S/N 42000195Built 2020 · Generational Jetsetters LLCN42HTPiper PA-31-350 · S/N 31-7852106Built 1978 · P&M Partners LLCN4517CCessna 170B · S/N 25461Built 1952 · Hainline Thomas DN4698NBoeing B75N1 · S/N 75-7940Built 1942 · Knauer Jeffrey AN4BZBombardier BD-100-1A10 · S/N 20814Built 2019 · Palmetto Construction Group III LLCN5001UCessna 172S · S/N 172S8959Built 2001 · Oew Aviation LLCN5140LDestiny 2000 · S/N 3C0409Built 2007 · Shadoan Peter DN548KDShort Kevin David COZY MARK IV · S/N 0548Built 2013 · Short Kevin DN556GGooch Lynn E RV-10 · S/N 40931Built 2012 · Gooch Joel LN58RGGibbons Robert D RV-8 · S/N 80067Gibbons Robert DN5960ACessna 172 · S/N 28560Southern Aviation Solutions LLCN619TCCessna 525 · S/N 525-0698Built 2010 · Redhawk Partners LLCN702TMCirrus Design SR20 · S/N 1649Built 2006 · Oew Aviation LLCN734XQCessna 172N · S/N 17269200Built 1977 · Sumter County Sheriffs OfficeN755CAPiper PA-32R-301 · S/N 3246021Built 1996 · Believe It Two LLCN756GBCirrus Design SR22 · S/N 2265Built 2006 · Sumter Aero Club IncN76645Cessna 140 · S/N 11085Built 1946 · Mcleod Chad HN8423PPiper PA-32-301 · S/N 32-8106086Built 1981 · Adams MarkN9234AMaule MXT-7-180A · S/N 21001CCruz Salvador A
Back to Sumter, SC