FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

260 rows where City = "Houston"

View and edit SQL

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

Registration_Number

State

City

  • Houston · 260
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
56   2019-01-07 Khan Umer 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
59   2019-01-08 AlRumaih Saleh I. 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
60   2019-01-08 Bayounis Abdulrahman 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
440   2018-03-13 Hirai Toshinaga 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
612   2019-04-12 Koyama Isao 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
614   2019-04-12 McKisick Sheridan 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
622   2019-04-15 Burki Sajjad 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
655   2013-04-23 Sanders Keith 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
665   2019-04-24 Irshad Faisal 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
666   2019-04-24 Zaman Khan Qamar 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
770   2019-05-02 Khan Ali Asim 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
867   2019-05-19 Ettinger Brian 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
868   2019-05-19 Payne Stephen 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
933   2019-05-28 Fleming Joseph 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
955   2019-05-30 Wheeler Brandon 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1183   2019-07-15 Kasraie Saghar Erica 6682 6682 2019-05-19 Linden Government Solutions, LLC 5120 Woodway Drive Suite 5004 Houston TX 77056
1686   2019-10-01 Shioiri Emi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1777   2019-10-16 Sakurauchi Masahiro 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1895   2017-10-30 Nakagawa Naoto 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
1981   2016-11-14 Abul-Hamayel B.A. 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
2089   2018-11-27 Alghamdi Adel Misfer 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
2292   2019-12-20 Alshammari Mohammad S. 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
2446 1977-01-01 1971-11-04 Welch William F. 2287 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
2756 2011-01-01 2001-11-06 Durnerin Veronique M. 5481 5481 2001-11-06 OIC Services, Inc. 12337 Jones Road Suite 301 Houston TX 77070
2997 1979-01-04 1974-07-30 Busse Alvin R. 2408 2408 1973-02-21 A.R. Busse & Associates, Inc. 1333 West Loop, South Suite 1230 Houston TX 77027
3039 2001-01-04 2001-02-14 Iwano Hiroshi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3096 2018-01-05 2015-04-22 Kurokawa Junji 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
3287 1987-01-09 1986-08-27 Takamura Taketoshi 3878 3878 1986-08-27 Klein Partnership 1201 Louisiana Suite 3426 Houston TX 77002-5213
3412 1987-01-12 1986-03-19 Jones B. Calvin 3800 3800 1986-03-19 Jones, B. Calvin 3000 South Post Oak Suite 100 Houston TX 77056
3463 2005-01-13 2004-03-26 Feldhaus Stephen M. 5615 5615 2004-03-26 Fulbright & Jaworski, LLP 1301 McKinney Suite 5100 Houston TX 77010-3095
4067 1983-01-24 1978-01-19 Mouffok Lahouari 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4068 1983-01-24 1978-04-05 Mir Omar 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4069 1983-01-24 1978-12-22 Mapes William R. , Jr. 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4676 1981-01-31 1981-01-22 Kara Abdelhamid 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4679 1981-01-31 1980-07-21 Berkane Abdelghani 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
4755 1990-01-31 1989-05-12 Sharr Seth L. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
4883 1997-01-31 1995-07-21 Rosenberg Richelle A. 5037 5037 1995-07-21 Carlberg & Associates, Inc. 2800 Post Oak Boulevard Suite 3400 Houston TX 77056-6106
4905 1999-01-31 1990-05-14 Woelfel Frank R. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
5837 1980-02-06 1978-04-05 Benbrahim Mohamed 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
5966 1980-02-08 1980-02-08 Baker W. Randolph 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5967 1980-02-08 1978-07-06 Babb Terry M. 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5968 1980-02-08 1978-07-06 Henderson Claudine L. 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5969 1980-02-08 1978-07-06 Henderson H. Dale 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
5970 1980-02-08 1978-07-06 McElwain William E. 2926 2926 1978-07-06 Dale Henderson, Inc. 2200 North Loop West Suite 100 Houston TX 77018
6134 1990-02-10 1988-12-02 Nakata Yutaka 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
6450 2014-02-14 2013-04-23 Shimada Aki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
7491 1994-02-28 1992-03-11 Ellis Rodney G. 4630 4630 1992-03-11 Solar & Ellis, L.L.P. 1331 Lamar Suite 1550 Houston TX 77010
7492 1994-02-28 1992-03-11 Solar J. Michael 4630 4630 1992-03-11 Solar & Ellis, L.L.P. 1331 Lamar Suite 1550 Houston TX 77010
7715 2007-02-28 2007-12-28 McNabb Stephen M. 5842 5842 2007-12-28 Fulbright & Jaworski, LLP 1301 McKinney #5100 Fulbright Tower Houston TX 77010-3095
7843 2019-02-28 2017-10-30 Uchida Kaori 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
8119 1979-03-01 1977-02-17 Brahimi Abdelhamid 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8138 1984-03-01 1980-09-19 Jones B. Calvin 3150 3150 1980-09-19 Jones, B. Calvin 3000 South Post Oak Suite 100 Houston TX 77056
8504 1976-03-05 1975-01-24 Stovall James T. , III 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8507 1976-03-05 1971-12-17 Guellal Cherif 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
8782 1974-03-08 1971-11-04 Bresenhan Karoline 2287 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
8945 1982-03-11 1979-05-18 Suganuma Koki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9056 2004-03-12 2001-08-13 Kobara Makoto 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9094 1992-03-13 1989-08-07 Oishi Shintaro 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9365 1996-03-16 1992-10-29 Nemoto Hiroyuki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
9441 1990-03-17 1990-03-19 Al-Eady Mohammed A. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9442 1990-03-17 1990-03-19 Al-Isa Abdulla I. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9443 1990-03-17 1990-03-19 Al-Mulhim Ibrahim A. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9444 1990-03-17 1990-03-19 Al-Qamarah Ali H. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9445 1990-03-17 1990-03-19 Al-Umairy Abdul Rahman A. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
9910 1994-03-23 1992-01-24 Campos Marc A. 4609 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
9911 1994-03-23 1992-01-24 Campos Tony 4609 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
10048 1995-03-25 1992-05-19 Sato Yoshiki 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10189 2013-03-27 2008-11-03 Kimura Makoto 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10466 2004-03-30 2002-06-14 Ozawa Jingo 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
10769 1981-03-31 1980-04-01 Bousselham Mohammed 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
10770 1981-03-31 1980-04-01 Rerbal Mohammed 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
10774 1981-03-31 1980-07-21 Rahali Mohamed L. 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
10882 1989-03-31 1988-10-13 Schultz Thomas Q. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
10898 1990-03-31 1987-09-29 Doll David M. 4044 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
10899 1990-03-31 1987-09-29 Graham Michael 4044 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
10900 1990-03-31 1987-09-29 Graham Patrick Harold 4044 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
10901 1990-03-31 1987-09-29 LeGaye Daniel E. 4044 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
10902 1990-03-31 1987-09-29 Loder Barry Charles 4044 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
10903 1990-03-31 1987-09-29 Trevino Daniel K. , III 4044 4044 1987-09-29 Bankers Capital Management, Inc. 601 Milam 6901 Texas Commerce Tower Houston TX 77002
11068 1998-03-31 1996-10-21 Russell Burnell J. 5134 5134 1996-10-26 Oceans International Corporation 5005 Mitchelldale Suite 121 Houston TX 77092
11304 2009-03-31 2009-01-23 Zimmerman Bruce V. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
11454 2016-03-31 2014-04-25 Maeda Shinobu 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
11707 2010-04-01 2006-05-09 Kurita Kaoru 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
11789 2008-04-02 1999-07-14 Bosch David D. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
12489 1981-04-15 1981-01-22 Belhadj Ali 2298 2298 1971-12-17 Sonatrach, Inc. Post Office Box 27041   Houston TX 77027
12745 2007-04-17 2003-08-01 Nakamizo Takashi 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
12929 1988-04-21 1984-10-11 Suess Gerhard-Philipp 3619 3619 1984-10-11 German State of Rheinland-Pfalz Commercial Office 1800 West Loop, South Suite 1510 Houston TX 77027
12930 1988-04-21 1984-10-11 de Boer Kurt W. 3619 3619 1984-10-11 German State of Rheinland-Pfalz Commercial Office 1800 West Loop, South Suite 1510 Houston TX 77027
13230 1982-04-27 1981-10-02 Barton Richard 2287 2287 1971-11-04 Bozell & Jacobs, Inc. 2 Allen Center Suite 2000 Houston TX 77002
13296 1989-04-28 1981-01-07 Alexe Gheorghe 3149 3149 1980-09-19 Romanian Trade Promotion Office, Houston 515 Tallowood Road Suite 20 Houston TX 77024
13340 2006-04-28 2002-12-10 Tokita Setsuko 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
13410 2001-04-29 1997-06-16 Iida Akimasa 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
13507 1970-04-30 1969-04-30 Davis John 2131 2131 1969-04-30 Aylin Advertising Agency, Inc. 2737 Buffalo Speedway   Houston TX 77006
13508 1970-04-30 1969-04-30 Molinello Alexander 2131 2131 1969-04-30 Aylin Advertising Agency, Inc. 2737 Buffalo Speedway   Houston TX 77006
13629 1989-04-30 1989-07-17 Bell Diana C. 3878 3878 1986-08-27 Klein Partnership 1201 Louisiana Suite 3426 Houston TX 77002-5213
13630 1989-04-30 1986-08-29 Kullnigg Juergen 3410 3410 1982-09-20 Austrian Trade Commission in the U.S., Houston 1300 Post Oak Boulevard Suite 1700 Houston TX 77056
14495 1993-05-03 1992-01-24 Maldonado Betti 4609 4609 1992-01-24 Campos Communications, Inc. 816 Ralfallen   Houston TX 77008
14976 1991-05-12 1989-08-07 Kikuoka Eiji 2277 2277 1971-09-20 JETRO, Houston 1221 McKinney Street Suite 4141 Houston TX 77010
15552 1990-05-20 1990-05-21 Al-Farea M.A. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002
15553 1990-05-20 1990-05-21 Al-Ramadan Mousa S. 4184 4184 1988-10-13 Saudi Refining, Inc. One Allen Center 500 Dallas Street Houston TX 77002

Next page

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)
);
Powered by Datasette · Query took 415.588ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history