FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

59 rows where State = "SC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
79 79   2019-01-10 Shin Woojin 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
108 108   2020-01-14 Metz Craig H. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
119 119   2020-01-17 Ott Laura O'Neill 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
151 151   2019-01-24 Sullivan III Daniel J. 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
152 152   2019-01-24 Tarpenning Kory 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
153 153   2019-01-24 Terry Benjamin Scott 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
154 154   2019-01-24 Terry Katherine Payne 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
171 171   2021-01-26 Hardwick John 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
174 174   2021-01-26 Straughn Gerald 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
320 320   2019-02-11 Craven Richard James 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
685 685   2009-04-10 Cox Christine M. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
758 758   2015-04-23 Klink Ron 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
1383 1383   2014-08-21 Basnayake Vinoda 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
1384 1384   2014-08-21 Cushing Christopher T. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
1385 1385   2019-08-21 Ott Christopher A. 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
1446 1446   2019-09-05 Moran James P. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
3555 3555 1991-01-16 1981-03-23 Capps Milton Ferebee 3191 3191 1981-01-22 Cook, J. Crawford Post Office Box 50485   Columbia SC 29250
4638 4638 1986-01-31 1981-08-13 Capps Milton Ferebee 3260 3260 1981-07-16 Cook Ruef, Inc. Post Office Box 50485   Columbia SC 29250
5119 5119 2015-01-31 2014-02-27 Clarke Britton 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
6321 6321 2019-02-13 2017-11-16 Quam David 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
7637 7637 1999-02-28 1993-08-18 Dumeunier Willy 4864 4864 1993-08-18 FN Manufacturing, Inc. 797 Clemson Road P.O. Box 24257 Columbia SC 29224
8427 8427 2021-03-01 2014-09-08 Crowe Robert B. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
9295 9295 2014-03-14 2013-04-22 Spear Christopher 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
11967 11967 1981-04-02 1978-03-20 Cook J. Crawford 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
11968 11968 1981-04-02 1978-04-05 Capps Milton Ferebee 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
12646 12646 1994-04-14 1989-10-13 Brett Timothy Andrew 4037 4037 1987-09-15 Michelin North America, Inc. 1 Parkway, South   Greenville SC 29615
13667 13667 2016-04-29 2015-04-23 Nardelli Michael 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
14332 14332 2013-04-30 2009-04-10 Sullivan Thomas M. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
14772 14772 1990-05-02 1978-05-18 Buttram Jack E. 3588 3588 1984-05-18 Jack E. Buttram Company, Inc. 1212 Haywood Road Suite 400 Greenville SC 29615
14773 14773 1990-05-02 1978-05-18 Sewell Richard A. 3588 3588 1984-05-18 Jack E. Buttram Company, Inc. 1212 Haywood Road Suite 400 Greenville SC 29615
22646 22646 2019-07-22 2018-11-06 Kelly Brian L. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
24744 24744 1994-08-05 1994-05-12 Buttram Jack E. 4913 4913 1994-05-12 Jack E. Buttram & Company 100 Tower Drive Suite 10 Greenville SC 29607
26492 26492 1999-08-30 1997-08-04 Parker Jack E. , Jr. 5193 5193 1997-08-04 West Indies Communications Group, Ltd. 180 East Bay Street Suite 200 Charleston SC 29401
26493 26493 1999-08-30 1997-08-04 Scrantom Timothy D. 5193 5193 1997-08-04 West Indies Communications Group, Ltd. 180 East Bay Street Suite 200 Charleston SC 29401
27255 27255 2010-08-31 2009-04-10 Wilkins Robert Whitley 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
27363 27363 2019-08-31 2009-04-10 Wilkins David Horton 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
27367 27367 2019-08-31 2017-05-22 Meyers Justin 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
28231 28231 1978-09-11 1978-05-09 Clarkson A. C. , Jr. 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
28670 28670 1985-09-18 1985-11-29 Low James P. 3577 3577 1984-04-27 Pretty III, George H. 555 North Pleasantburg Drive Park Central, Suite 330 Greenville SC 29607
28671 28671 1985-09-18 1985-11-29 Sammis John C. 3577 3577 1984-04-27 Pretty III, George H. 555 North Pleasantburg Drive Park Central, Suite 330 Greenville SC 29607
29300 29300 1978-09-28 1978-09-28 Lunan Sally T. 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
29301 29301 1978-09-28 1978-09-28 Monroe Betty M. 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
29302 29302 1978-09-28 1978-09-28 Ruef Leland C. 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
29303 29303 1978-09-28 1978-09-28 Spann William F. 2869 2869 1978-03-20 J. Crawford Cook, Inc. Post Office Box 50485   Columbia SC 29250
30856 30856 2016-10-04 2010-11-15 Meyers Justin 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
31271 31271 1982-10-13 1981-11-25 Buttram Jack E. 3309 3309 1981-11-25 Jack E. Buttram Company, Inc. 38 Valerie Drive   Greenville SC 29615
31272 31272 1982-10-13 1981-11-25 Buttram Kerry G. 3309 3309 1981-11-25 Jack E. Buttram Company, Inc. 38 Valerie Drive   Greenville SC 29615
31273 31273 1982-10-13 1981-11-25 Dobbs Donald R. 3309 3309 1981-11-25 Jack E. Buttram Company, Inc. 38 Valerie Drive   Greenville SC 29615
31274 31274 1982-10-13 1981-11-25 Sewell Richard A. 3309 3309 1981-11-25 Jack E. Buttram Company, Inc. 38 Valerie Drive   Greenville SC 29615
32218 32218 1980-10-27 1978-05-09 Ruef Leland C. 2898 2898 1978-05-09 Cook, Ruef, Spann & Weiser, Inc. Post Office Box 5845   Columbia SC 29250
32219 32219 1980-10-27 1978-05-09 Spann William F. 2898 2898 1978-05-09 Cook, Ruef, Spann & Weiser, Inc. Post Office Box 5845   Columbia SC 29250
32972 32972 2001-10-31 2001-10-17 Abraham Nathaniel 5463 5463 2001-10-17 Abraham, Nathaniel Sr., 2346 (A&B) Two Notch Road   Columbia SC 29203
34625 34625 2019-11-21 2017-09-01 Garrett Eulice Brandon 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
36513 36513 1990-12-12 1985-09-18 Pretty George H. , II 3733 3733 1985-09-18 Leatherwood, Walker, Todd & Mann Spartan Centre 101 West St. John Street #302 Spartanburg SC 29301
36565 36565 1989-12-13 1985-06-17 Abu-Fadil Magda 3260 3260 1981-07-16 Cook Ruef, Inc. Post Office Box 50485   Columbia SC 29250
36888 36888 1998-12-17 1993-08-18 Ritter James H. 4864 4864 1993-08-18 FN Manufacturing, Inc. 797 Clemson Road P.O. Box 24257 Columbia SC 29224
38723 38723 1987-12-31 1985-06-21 Koelemay J. Douglas 3260 3260 1981-07-16 Cook Ruef, Inc. Post Office Box 50485   Columbia SC 29250
39219 39219 1995-12-31 1987-09-15 Morton James Carnes , Jr. 4037 4037 1987-09-15 Michelin North America, Inc. 1 Parkway, South   Greenville SC 29615
39360 39360 1997-12-31 1997-08-04 Reed Daniel M. 5193 5193 1997-08-04 West Indies Communications Group, Ltd. 180 East Bay Street Suite 200 Charleston SC 29401

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY(Registration_Number) REFERENCES FARA_All_Registrants(Registration_Number)
);