List of URLs to all registrant docs (available in PDF format)

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

39 rows where Registration_Number = 3586

View and edit SQL

Suggested facets: Date_Stamped, Short_Form_Name, Date_Stamped (date)

Foreign_Principal_Country

Registrant_Name

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
11769 1992-02-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   AEA TECHNOLOGY GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19920201-D0W07R01.pdf
41677 1984-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   SEA SERVICES, LTD. PANAMA https://efile.fara.gov/docs/3586-Exhibit-AB-19840501-D0VYHW01.pdf
41678 1984-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Registration Statement       Available-FARA-Public-Office
41774 1985-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19850501-D0VYEZ01.pdf
41867 1986-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19860501-D0VYNR01.pdf
42043 1987-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19870501-D0VY3T01.pdf
42170 1988-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19880501-D0VYB401.pdf
42320 1989-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19890501-D0VZDL01.pdf
42481 1990-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19900501-D0VY7701.pdf
42764 1991-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19910501-D0WQPO01.pdf
43223 1992-05-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19920501-D0W15501.pdf
45786 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form DEBORAH KAY WILLIAMS     Available-FARA-Public-Office
45787 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form EDWARD R. HAMBERGER     Available-FARA-Public-Office
45788 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form GREGORY STUART KAUPP     Available-FARA-Public-Office
45789 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form JAMES W. GLASSEN     Available-FARA-Public-Office
45790 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form MARTIN G. HAMBERGER     Available-FARA-Public-Office
45791 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form ROBERT MICHAEL DIAMOND     Available-FARA-Public-Office
45792 1984-05-10 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form ZEL E. LIPSEN     Available-FARA-Public-Office
54032 1989-06-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   ROLLS-ROYCE, INC. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19890601-D0VYAD01.pdf
78732 1988-08-12 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   CHELLINGWORTH & SINGER, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYDJ01.pdf
78733 1988-08-12 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   COLEBRAND, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYEJ01.pdf
78734 1988-08-12 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   MINISTRY OF DEFENCE, UNITED KINGDOM GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYDZ01.pdf
78735 1988-08-12 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   VICKERS SHIPBUILDING & ENGINEERING, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19880812-D0VYCZ01.pdf
84335 1989-09-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Amendment       https://efile.fara.gov/docs/3586-Amendment-19890901-D0VZDC01.pdf
90494 1987-09-25 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   CHELLINGWORTH & SINGER, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VY5I01.pdf
90495 1987-09-25 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   MINISTRY OF DEFENCE, UNITED KINGDOM GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VY4Y01.pdf
90496 1987-09-25 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   REPUBLIC OF PANAMA PANAMA https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VYLJ01.pdf
90497 1987-09-25 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   VICKERS SHIPBUILDING & ENGINEERING, LTD. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VYLZ01.pdf
90498 1987-09-25 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   VOSPER THORNYCROFT (UNITED KINGDOM), LTD. GREAT BRITAIN https://efile.fara.gov/docs/3586-Exhibit-AB-19870925-D0VYKR01.pdf
103702 1984-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19841101-D0VYG101.pdf
103809 1985-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19851101-D0VYPE01.pdf
103903 1986-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19861101-D0VYMK01.pdf
104114 1988-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19881101-D0VZBT01.pdf
104248 1989-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19891101-D0VY9001.pdf
104406 1990-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19901101-D0VY5Y01.pdf
104760 1991-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19911101-D0W00001.pdf
105178 1992-11-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Supplemental Statement       https://efile.fara.gov/docs/3586-Supplemental-Statement-19921101-D0W25J01.pdf
113397 1984-12-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Exhibit AB   REPUBLIC OF PANAMA PANAMA https://efile.fara.gov/docs/3586-Exhibit-AB-19841201-D0VYHG01.pdf
113398 1984-12-01 LIPSEN, WHITTEN & DIAMOND 3586 3586 Short-Form JAMIE L. WHITTEN     Available-FARA-Public-Office

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);