FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
60 rows where State = "SC"
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 17
- Nelson Mullins Riley & Scarborough, LLP 19
- J. Crawford Cook, Inc. 7
- Barzan Aeronautical LLC 5
- Jack E. Buttram Company, Inc. 4
- SST Aerospace, LLC 4
- Cook Ruef, Inc. 3
- West Indies Communications Group, Ltd. 3
- Cook, Ruef, Spann & Weiser, Inc. 2
- Pretty III, George H. 2
- Jack E. Buttram Company, Inc. 2
- Michelin North America, Inc. 2
- FN Manufacturing, Inc. 2
- Cook, J. Crawford 1
- Leatherwood, Walker, Todd & Mann 1
- Jack E. Buttram & Company 1
- Abraham, Nathaniel Sr., 1
- Strom Public Affairs 1
Registrant_Name 16
- Nelson Mullins Riley & Scarborough, LLP 19
- J. Crawford Cook, Inc. 7
- Jack E. Buttram Company, Inc. 6
- Barzan Aeronautical LLC 5
- SST Aerospace, LLC 4
- Cook Ruef, Inc. 3
- West Indies Communications Group, Ltd. 3
- Cook, Ruef, Spann & Weiser, Inc. 2
- FN Manufacturing, Inc. 2
- Michelin North America, Inc. 2
- Pretty III, George H. 2
- Abraham, Nathaniel Sr., 1
- Cook, J. Crawford 1
- Jack E. Buttram & Company 1
- Leatherwood, Walker, Todd & Mann 1
- Strom Public Affairs 1
City 4
- Columbia 36
- Greenville 15
- Charleston 8
- Spartanburg 1
State 1
- SC · 60 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60 | 60 | 2019-01-10 | Shin | Woojin | Nelson Mullins Riley & Scarborough, LLP 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. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
117 | 117 | 2020-01-17 | Ott | Laura O'Neill | Barzan Aeronautical LLC 6635 | 2019-02-11 | Barzan Aeronautical LLC | 200 Meeting Street | Suite 305 | Charleston | SC | 29401 | |
148 | 148 | 2019-01-24 | Sullivan III | Daniel J. | SST Aerospace, LLC 6629 | 2019-01-24 | SST Aerospace, LLC | Greenville Downtown Airport/Hangar 1 | 54 Watson Aviation Road | Greenville | SC | 29607 | |
149 | 149 | 2019-01-24 | Tarpenning | Kory | SST Aerospace, LLC 6629 | 2019-01-24 | SST Aerospace, LLC | Greenville Downtown Airport/Hangar 1 | 54 Watson Aviation Road | Greenville | SC | 29607 | |
150 | 150 | 2019-01-24 | Terry | Benjamin Scott | SST Aerospace, LLC 6629 | 2019-01-24 | SST Aerospace, LLC | Greenville Downtown Airport/Hangar 1 | 54 Watson Aviation Road | Greenville | SC | 29607 | |
151 | 151 | 2019-01-24 | Terry | Katherine Payne | SST Aerospace, LLC 6629 | 2019-01-24 | SST Aerospace, LLC | Greenville Downtown Airport/Hangar 1 | 54 Watson Aviation Road | Greenville | SC | 29607 | |
167 | 167 | 2021-01-26 | Hardwick | John | Barzan Aeronautical LLC 6635 | 2019-02-11 | Barzan Aeronautical LLC | 200 Meeting Street | Suite 305 | Charleston | SC | 29401 | |
170 | 170 | 2021-01-26 | Straughn | Gerald | Barzan Aeronautical LLC 6635 | 2019-02-11 | Barzan Aeronautical LLC | 200 Meeting Street | Suite 305 | Charleston | SC | 29401 | |
322 | 322 | 2019-02-11 | Craven | Richard James | Barzan Aeronautical LLC 6635 | 2019-02-11 | Barzan Aeronautical LLC | 200 Meeting Street | Suite 305 | Charleston | SC | 29401 | |
743 | 743 | 2009-04-10 | Cox | Christine M. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
829 | 829 | 2015-04-23 | Klink | Ron | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
1519 | 1519 | 2014-08-21 | Cushing | Christopher T. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
1520 | 1520 | 2019-08-21 | Ott | Christopher A. | Barzan Aeronautical LLC 6635 | 2019-02-11 | Barzan Aeronautical LLC | 200 Meeting Street | Suite 305 | Charleston | SC | 29401 | |
1582 | 1582 | 2021-09-01 | Sellers | Bakari | Strom Public Affairs 7006 | 2021-09-01 | Strom Public Affairs | 6923 N. Trenholm Road | Columbia | SC | 29206 | ||
1596 | 1596 | 2019-09-05 | Moran | James P. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
3718 | 3718 | 1991-01-16 | 1981-03-23 | Capps | Milton Ferebee | Cook, J. Crawford 3191 | 1981-01-22 | Cook, J. Crawford | Post Office Box 50485 | Columbia | SC | 29250 | |
4814 | 4814 | 1986-01-31 | 1981-08-13 | Capps | Milton Ferebee | Cook Ruef, Inc. 3260 | 1981-07-16 | Cook Ruef, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
5295 | 5295 | 2015-01-31 | 2014-02-27 | Clarke | Britton | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
6529 | 6529 | 2019-02-13 | 2017-11-16 | Quam | David | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
7859 | 7859 | 1999-02-28 | 1993-08-18 | Dumeunier | Willy | FN Manufacturing, Inc. 4864 | 1993-08-18 | FN Manufacturing, Inc. | 797 Clemson Road | P.O. Box 24257 | Columbia | SC | 29224 |
8669 | 8669 | 2021-03-01 | 2014-09-08 | Crowe | Robert B. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
8677 | 8677 | 2022-03-01 | 2014-08-21 | Basnayake | Vinoda | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
9562 | 9562 | 2014-03-14 | 2013-04-22 | Spear | Christopher | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
12275 | 12275 | 1981-04-02 | 1978-03-20 | Cook | J. Crawford | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
12276 | 12276 | 1981-04-02 | 1978-04-05 | Capps | Milton Ferebee | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
12965 | 12965 | 1994-04-14 | 1989-10-13 | Brett | Timothy Andrew | Michelin North America, Inc. 4037 | 1987-09-15 | Michelin North America, Inc. | 1 Parkway, South | Greenville | SC | 29615 | |
14006 | 14006 | 2016-04-29 | 2015-04-23 | Nardelli | Michael | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
14672 | 14672 | 2013-04-30 | 2009-04-10 | Sullivan | Thomas M. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
15177 | 15177 | 1990-05-02 | 1978-05-18 | Buttram | Jack E. | Jack E. Buttram Company, Inc. 3588 | 1984-05-18 | Jack E. Buttram Company, Inc. | 1212 Haywood Road | Suite 400 | Greenville | SC | 29615 |
15178 | 15178 | 1990-05-02 | 1978-05-18 | Sewell | Richard A. | Jack E. Buttram Company, Inc. 3588 | 1984-05-18 | Jack E. Buttram Company, Inc. | 1212 Haywood Road | Suite 400 | Greenville | SC | 29615 |
23216 | 23216 | 2019-07-22 | 2018-11-06 | Kelly | Brian L. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
25332 | 25332 | 1994-08-05 | 1994-05-12 | Buttram | Jack E. | Jack E. Buttram & Company 4913 | 1994-05-12 | Jack E. Buttram & Company | 100 Tower Drive | Suite 10 | Greenville | SC | 29607 |
27095 | 27095 | 1999-08-30 | 1997-08-04 | Parker | Jack E. , Jr. | West Indies Communications Group, Ltd. 5193 | 1997-08-04 | West Indies Communications Group, Ltd. | 180 East Bay Street | Suite 200 | Charleston | SC | 29401 |
27096 | 27096 | 1999-08-30 | 1997-08-04 | Scrantom | Timothy D. | West Indies Communications Group, Ltd. 5193 | 1997-08-04 | West Indies Communications Group, Ltd. | 180 East Bay Street | Suite 200 | Charleston | SC | 29401 |
27861 | 27861 | 2010-08-31 | 2009-04-10 | Wilkins | Robert Whitley | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
27969 | 27969 | 2019-08-31 | 2009-04-10 | Wilkins | David Horton | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
27973 | 27973 | 2019-08-31 | 2017-05-22 | Meyers | Justin | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
28858 | 28858 | 1978-09-11 | 1978-05-09 | Clarkson | A. C. , Jr. | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
29302 | 29302 | 1985-09-18 | 1985-11-29 | Low | James P. | Pretty III, George H. 3577 | 1984-04-27 | Pretty III, George H. | 555 North Pleasantburg Drive | Park Central, Suite 330 | Greenville | SC | 29607 |
29303 | 29303 | 1985-09-18 | 1985-11-29 | Sammis | John C. | Pretty III, George H. 3577 | 1984-04-27 | Pretty III, George H. | 555 North Pleasantburg Drive | Park Central, Suite 330 | Greenville | SC | 29607 |
29938 | 29938 | 1978-09-28 | 1978-09-28 | Lunan | Sally T. | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
29939 | 29939 | 1978-09-28 | 1978-09-28 | Monroe | Betty M. | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
29940 | 29940 | 1978-09-28 | 1978-09-28 | Ruef | Leland C. | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
29941 | 29941 | 1978-09-28 | 1978-09-28 | Spann | William F. | J. Crawford Cook, Inc. 2869 | 1978-03-20 | J. Crawford Cook, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
31527 | 31527 | 2016-10-04 | 2010-11-15 | Meyers | Justin | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
31951 | 31951 | 1982-10-13 | 1981-11-25 | Buttram | Jack E. | Jack E. Buttram Company, Inc. 3309 | 1981-11-25 | Jack E. Buttram Company, Inc. | 38 Valerie Drive | Greenville | SC | 29615 | |
31952 | 31952 | 1982-10-13 | 1981-11-25 | Buttram | Kerry G. | Jack E. Buttram Company, Inc. 3309 | 1981-11-25 | Jack E. Buttram Company, Inc. | 38 Valerie Drive | Greenville | SC | 29615 | |
31953 | 31953 | 1982-10-13 | 1981-11-25 | Dobbs | Donald R. | Jack E. Buttram Company, Inc. 3309 | 1981-11-25 | Jack E. Buttram Company, Inc. | 38 Valerie Drive | Greenville | SC | 29615 | |
31954 | 31954 | 1982-10-13 | 1981-11-25 | Sewell | Richard A. | Jack E. Buttram Company, Inc. 3309 | 1981-11-25 | Jack E. Buttram Company, Inc. | 38 Valerie Drive | Greenville | SC | 29615 | |
32913 | 32913 | 1980-10-27 | 1978-05-09 | Ruef | Leland C. | Cook, Ruef, Spann & Weiser, Inc. 2898 | 1978-05-09 | Cook, Ruef, Spann & Weiser, Inc. | Post Office Box 5845 | Columbia | SC | 29250 | |
32914 | 32914 | 1980-10-27 | 1978-05-09 | Spann | William F. | Cook, Ruef, Spann & Weiser, Inc. 2898 | 1978-05-09 | Cook, Ruef, Spann & Weiser, Inc. | Post Office Box 5845 | Columbia | SC | 29250 | |
33670 | 33670 | 2001-10-31 | 2001-10-17 | Abraham | Nathaniel | Abraham, Nathaniel Sr., 5463 | 2001-10-17 | Abraham, Nathaniel Sr., | 2346 (A&B) Two Notch Road | Columbia | SC | 29203 | |
35375 | 35375 | 2019-11-21 | 2017-09-01 | Garrett | Eulice Brandon | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
37336 | 37336 | 1990-12-12 | 1985-09-18 | Pretty | George H. , II | Leatherwood, Walker, Todd & Mann 3733 | 1985-09-18 | Leatherwood, Walker, Todd & Mann | Spartan Centre | 101 West St. John Street #302 | Spartanburg | SC | 29301 |
37389 | 37389 | 1989-12-13 | 1985-06-17 | Abu-Fadil | Magda | Cook Ruef, Inc. 3260 | 1981-07-16 | Cook Ruef, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
37718 | 37718 | 1998-12-17 | 1993-08-18 | Ritter | James H. | FN Manufacturing, Inc. 4864 | 1993-08-18 | FN Manufacturing, Inc. | 797 Clemson Road | P.O. Box 24257 | Columbia | SC | 29224 |
39555 | 39555 | 1987-12-31 | 1985-06-21 | Koelemay | J. Douglas | Cook Ruef, Inc. 3260 | 1981-07-16 | Cook Ruef, Inc. | Post Office Box 50485 | Columbia | SC | 29250 | |
40051 | 40051 | 1995-12-31 | 1987-09-15 | Morton | James Carnes , Jr. | Michelin North America, Inc. 4037 | 1987-09-15 | Michelin North America, Inc. | 1 Parkway, South | Greenville | SC | 29615 | |
40192 | 40192 | 1997-12-31 | 1997-08-04 | Reed | Daniel M. | West Indies Communications Group, Ltd. 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
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]) );