Columbia, SC

Registered aircraft · 93

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

N637AVPiper PA-28-140 · S/N 28-21548Built 1966 · Scruggs Harriet JuneN6415SCessna 150H · S/N 15067215Johnson Edward AN6611MCessna 182P · S/N 18263777Built 1975 · Usda Forest Service FeppN661RRRobinson Helicopter R44 · S/N 0661Built 1999 · Helicopter Of Columbia LLCN67240Dearing T-18 · S/N 478Weems Winceslas SN6752JPiper PA-28-140 · S/N 28-24474Built 1968 · Hutchins James RN70RBCirrus Design SR20 · S/N 1653Built 2006 · Mp Morris Aviation LLCN71101Luscombe 8A · S/N 2528Built 1946 · Beasley Horace EN711BSCessna 560XL · S/N 560-6015Built 2009 · Blue Transport LLCN7245DDJI PHANTOM 3 PROFESSION · S/N P76DCF26011023State Of South CarolinaN728ZEduardo Francisco Irizarry RV 7 · S/N 72842Built 2012 · Irizarry Eduardo FN730AKCessna 182Q · S/N 18265482Built 1977 · Mcmullen Michael JN74620Grumman American Avn. AA-5B · S/N AA5B-0290Built 1976 · Columbia Flying LLCN74BYCirrus Design SR22T · S/N 0892Built 2014 · Mav & Merlin Aviation LLCN7537VCessna 177RG · S/N 177RG0834Built 1976 · Horizon Aeronautics IncN764Cessna U206F · S/N U20602672Built 1975 · Usda Forest Servic FeppN76603Cessna 140 · S/N 11043Built 1946 · Dunn Ward AN7754ECessna 150 · S/N 17554Burns Robert M IIIN8012FCessna 150F · S/N 15064112Built 1966 · Hood William TN803SCCessna 560 · S/N 560-0287Built 1995 · Strom Law Firm LLCN81612Piper PA-28-161 · S/N 28-8016270Built 1980 · Av8rlounge LLCN81CNPiper PA-34-220T · S/N 34-8133110Built 1981 · Columbia Aircraft IncN831GBBrickey Glen R JR LONG-EZ · S/N 284Dievendorf Gerry TN833EWWillie C Williams RV-7A · S/N 70158Helms Thomas SanfordN83969Aeronca 7AC/BCM CONV · S/N 7AC-2655Built 1946 · Sullivan Michael TN859EKDJI MAVIC 2 ZOOM · S/N 0M6CH8CR0A1KM7Trofatter Eric AN86THHill Stanley D THORP T-18CW · S/N 2022Weems Winceslas ScottN873LCSwellpro SPLASHDRONE 3+ · S/N 1915-SD3+-0568-V01Coleman IvyN8WLCessna U206G · S/N U20607014First renewal noticeBuilt 1985 · South Carolina Department Of Natural ResourcesN9178Roebuck ROEBUCK · S/N 67-53Built 1974 · Roebuck David LN91BJCostruzioni Aeronautiche Tecna ASTORE · S/N 042Built 2015 · Alpha Island Time Holding LLCN923WDBeech 95-B55 (T42A) · S/N TC-1786Built 1974 · Dubose W P IIIN930KGPiper PA-32R-301T · S/N 32R-8029027Griggs RogerN930PCRaytheon A36 · S/N E-3442Trust Aviation LLCN9713WPiper PA-28-140 · S/N 28-23189Built 1967 · Giles Robert LN98188Cessna 172E · S/N R1720077Usda Forest Service FeppN9853HCessna 182R · S/N 18268072Built 1982 · Miles Alexander BevansN989LABeech B200 · S/N BB-1310Built 1988 · Mha Consulting LLCN9957ACessna 170A · S/N 19317Built 1950 · Dunn Ward AN995TBeech 35-33 · S/N CD-193Built 1960 · Bowes Daniel ShaunN996PJHamilton Patricia Gilles RV-6 · S/N 23456Built 2002 · Clark James EN9997FCessna R172E · S/N R1720247Built 1967 · Usda Forest Service FeppN999MCIsrael Aircraft Industries GULFSTREAM 200 · S/N 004Built 1999 · Halen LLC
Back to Columbia, SC