List of all foreign principals (active and terminated)

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

32 rows where Registration_Number = 3988

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

City

  • - 32
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
75   Bureau of Foreign Trade, Ministry of Economic Affairs, Government of the Republic of China (BOFT) 1987-06-23 TAIWAN 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Washington     DC  
2270 1993-02-12 Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. 1990-11-06 MEXICO 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Mexico City        
2293 1992-02-13 Aerospatiale Helicopter Corporation 1990-03-15 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Grand Prairie     TX  
2294 1992-02-13 Dassault Industries, Parent Corporation of Falcon Jet 1991-06-28 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd.          
2295 1992-02-13 Falcon Jet Corporation, a Subsidiary of Dassault Industries 1992-03-18 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Paramus     NJ  
2296 1992-02-13 MBB Helicopter Corporation 1990-06-27 GERMANY 3988 3988 1987-05-28 Crowell & Moring International, Ltd. West Chester     PA  
2298 1992-02-13 Turbomeca Engine Corporation 1990-03-15 FRANCE 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Grand Prairie     TX  
2352 1996-02-14 Manufacturers' Association of Israel 1995-08-25 ISRAEL 3988 3988 1987-05-28 Crowell & Moring International, Ltd. TelAviv        
4763 1991-04-04 Samsung Electronics Company, Ltd. 1989-01-19 KOREA, SOUTH 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Seoul        
5045 2002-04-15 Government of the Philippines 2001-07-16 PHILIPPINES 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Office of the Executive Secretary Malacanang Palace Manila        
5225 1992-04-23 Pliana, Inc. 1991-02-13 MEXICO 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Greensboro     NC  
5483 1998-04-29 Asia Pacific Economic Cooperation of the Philippines, Inc. 1996-08-09 PHILIPPINES 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Manila        
5485 1998-04-29 Government of the Republic of the Philippines Department of Trade and Industry 1996-03-14 PHILIPPINES 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Manila        
5681 1997-04-30 Government of the Republic of Korea 1996-09-19 KOREA, SOUTH 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Kyungki-do        
5698 1999-04-30 Asia Pacific Economic Cooperation Business Advisory Council Malaysia (ABAC Malaysia) 1998-10-29 MALAYSIA 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Kuala Lumpur        
5702 1999-04-30 New Zealand Fishing Industry Board/ Fishing Industry Inspection & Certification Council 1993-04-08 NEW ZEALAND 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Wellington        
6041 1992-05-05 Taiwan Association of Machinery Industry 1991-02-13 TAIWAN 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Taipei        
6303 1995-05-16 Singapore Trade Development Board 1988-05-27 SINGAPORE 3988 3988 1987-05-28 Crowell & Moring International, Ltd.          
6404 1987-05-22 Manufacturers' Association of Israel 1987-05-28 ISRAEL 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Tel-Aviv        
7093 1995-06-01 Negev Phosphates, Ltd. (NPL) 1991-08-29 ISRAEL 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Ashdod        
7785 1990-06-28 Wacker Siltronic Corporation 1987-06-10 GERMANY, FEDERAL REPUBLIC OF 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Portland     OR  
7787 1993-06-28 Multilec, S.A. de C.V. 1991-06-28 MEXICO 3988 3988 1987-05-28 Crowell & Moring International, Ltd.          
7788 1993-06-28 Pulsar Internacional, S.A. de C.V. 1991-03-26 MEXICO 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Garza Garcia        
8169 1994-06-30 P.T. Perkebunan, III 1994-10-07 INDONESIA 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Sumatra        
11006 1999-09-08 Pacific Dunlop, Ltd./Pacific Brands 1995-06-29 AUSTRALIA 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Melbourne        
13101 1998-11-01 Ministry of Trade, Government of Indonesia 1994-01-13 INDONESIA 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Jakarta        
13161 1987-11-03 Ministry of Industry & Trade of the Government of Israel 1987-10-13 ISRAEL 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Jerusalem        
13237 1990-11-06 Industrial Research & Development Corporation, Ltd. 1987-11-12 ISRAEL 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Rehovot        
13773 1990-11-29 United Nations Conference on Trade & Development (UNCTAD) 1988-07-26 INTERNATIONAL 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Geneva        
14749 1989-12-22 Government of Thailand 1989-01-12 THAILAND 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Bangkok        
14788 1992-12-23 Jose Luis Alberro, Inc. 1991-07-19 MEXICO 3988 3988 1987-05-28 Crowell & Moring International, Ltd.          
16033 2006-12-31 Korea International Trade Association (formerly: Korean Foreign Trade Association) 1988-04-06 KOREA, SOUTH 3988 3988 1987-05-28 Crowell & Moring International, Ltd. Washington     DC  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_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)
);