FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
187 rows where Registration_Number = 2621
This data as json, CSV (advanced)
These facets timed out: Registrant_Name
Foreign_Principal_Name 13
- - 168
- SOCIETE NATIONALE D'ETUDE ET DE CONSTRUCTION DE MOTEURS 4
- ARIANESPACE, S.A. 2
- SOCIETE NATIONALE DES POUDRES ET EXPLOSIFS 2
- SOCIETE NATIONALE INDUSTRIELLE AEROSPATIALE 2
- THOMSON-CSF, DIVISION SYSTEMS ELECTRONIQUE 2
- AIRBUS INDUSTRIE 1
- DIRECTEUR DES RELATIONS INTERNATIONALES DE LA DELEGATION 1
- GOVERNMENT OF MOROCCO 1
- KRAUSS-MAFFEI, A.G. 1
- SOCIETE MTE 1
- SOFREAVIA 1
- UNION DE TRANSPORTS AERIENS 1
Document_Type 6
- Short-Form 118
- Supplemental Statement 37
- Exhibit AB 19
- Amendment 11
- Exhibit C 1
- Registration Statement 1
Foreign_Principal_Country 4
- - 168
- FRANCE 17
- GERMANY FEDERAL REPUBLIC OF 1
- MOROCCO 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
333 | 333 | 1976-01-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | KRAUSS-MAFFEI, A.G. | GERMANY FEDERAL REPUBLIC OF | https://efile.fara.gov/docs/2621-Exhibit-AB-19760101-D01OOG03.pdf | |
1527 | 1527 | 1990-01-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | SANDRA K. MEREDITH | Available-FARA-Public-Office | ||
5976 | 5976 | 1977-01-18 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DANA B. ORWICK | Available-FARA-Public-Office | ||
7134 | 7134 | 1986-01-24 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ERNEST R. WARNER, JR. | Available-FARA-Public-Office | ||
7135 | 7135 | 1986-01-24 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LLOYD T. PRESLAR | Available-FARA-Public-Office | ||
7136 | 7136 | 1986-01-24 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | VIRGINIA A. LAMPLEY | Available-FARA-Public-Office | ||
7611 | 7611 | 1976-01-26 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | CHARLES E. GOODELL | Available-FARA-Public-Office | ||
7612 | 7612 | 1976-01-26 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DONALD G. AGGER | Available-FARA-Public-Office | ||
7833 | 7833 | 1977-01-27 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | WILLIAM A. REYNOLDS | Available-FARA-Public-Office | ||
8104 | 8104 | 1976-01-28 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | HAROLD L. SPRINGER | Available-FARA-Public-Office | ||
8105 | 8105 | 1976-01-28 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | HUGH J. GOWNLEY | Available-FARA-Public-Office | ||
8106 | 8106 | 1976-01-28 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | THOMAS T. SCAMBOS | Available-FARA-Public-Office | ||
11184 | 11184 | 1983-02-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOCIETE NATIONALE DES POUDRES ET EXPLOSIFS | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19830201-D01REZ03.pdf | |
11361 | 11361 | 1985-02-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOCIETE NATIONALE D'ETUDE ET DE CONSTRUCTION DE MOTEURS | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19850201-D01RGE03.pdf | |
15794 | 15794 | 1979-02-12 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | WILLIAM WEITZEN | Available-FARA-Public-Office | ||
16172 | 16172 | 1979-02-14 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | THEA ROSSI BARRON | Available-FARA-Public-Office | ||
16671 | 16671 | 1979-02-16 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | EDWARD C. MAEDER | Available-FARA-Public-Office | ||
16672 | 16672 | 1979-02-16 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | M. ALAN WOODS | Available-FARA-Public-Office | ||
18624 | 18624 | 1983-02-25 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ERNEST R. WARNER, JR. | Available-FARA-Public-Office | ||
18625 | 18625 | 1983-02-25 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LLOYD PRESLAR | Available-FARA-Public-Office | ||
20871 | 20871 | 1976-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LEON J. ZIMMERMAN | Available-FARA-Public-Office | ||
20923 | 20923 | 1977-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Amendment | https://efile.fara.gov/docs/2621-Amendment-19770301-D01P3V03.pdf | |||
21054 | 21054 | 1979-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | M. ALAN WOODS | Available-FARA-Public-Office | ||
21132 | 21132 | 1980-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ERNEST R. WARNER, JR. | Available-FARA-Public-Office | ||
21368 | 21368 | 1983-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | MYER RASHISH | Available-FARA-Public-Office | ||
21572 | 21572 | 1985-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Amendment | https://efile.fara.gov/docs/2621-Amendment-19850301-D01RG603.pdf | |||
21573 | 21573 | 1985-03-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | SAMUEL J. AGGER | Available-FARA-Public-Office | ||
26353 | 26353 | 1987-03-09 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DAVID L. MAHAN | Available-FARA-Public-Office | ||
26354 | 26354 | 1987-03-09 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DAVID L. MAHAN | Available-FARA-Public-Office | ||
32028 | 32028 | 1979-03-30 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | JOHN R. REILLY | Available-FARA-Public-Office | ||
33889 | 33889 | 1976-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOCIETE MTE | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19760401-D01W7403.pdf | |
33890 | 33890 | 1976-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | RICHARD AURELIO | Available-FARA-Public-Office | ||
33891 | 33891 | 1976-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19760401-D01W5A03.pdf | |||
33941 | 33941 | 1977-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19770401-D01P0Q03.pdf | |||
33987 | 33987 | 1978-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19780401-D01QMU03.pdf | |||
34046 | 34046 | 1979-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Amendment | https://efile.fara.gov/docs/2621-Amendment-19790401-D01QIL03.pdf | |||
34047 | 34047 | 1979-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19790401-D01Q4A03.pdf | |||
34112 | 34112 | 1980-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19800401-D01RXQ03.pdf | |||
34184 | 34184 | 1981-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DAVID L. MAHAN | Available-FARA-Public-Office | ||
34185 | 34185 | 1981-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19810401-D01RRW03.pdf | |||
34256 | 34256 | 1982-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19820401-D01RM703.pdf | |||
34332 | 34332 | 1983-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19830401-D01RBH03.pdf | |||
34428 | 34428 | 1984-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19840401-D01R1703.pdf | |||
34515 | 34515 | 1985-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | ARIANESPACE, S.A. | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19850401-D01QQR03.pdf | |
34516 | 34516 | 1985-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19850401-D01PR403.pdf | |||
34593 | 34593 | 1986-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19860401-D01PZN03.pdf | |||
34744 | 34744 | 1987-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOCIETE NATIONALE D'ETUDE ET DE CONSTRUCTION DE MOTEURS | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19870401-D01PVB03.pdf | |
34745 | 34745 | 1987-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19870401-D01NX403.pdf | |||
34886 | 34886 | 1988-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | JACK EDWARDS | Available-FARA-Public-Office | ||
34887 | 34887 | 1988-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19880401-D01P6203.pdf | |||
35044 | 35044 | 1989-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19890401-D01PFT03.pdf | |||
35226 | 35226 | 1990-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19900401-D01PJ703.pdf | |||
35460 | 35460 | 1991-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19910401-D01XR503.pdf | |||
35949 | 35949 | 1992-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19920401-D01U0O03.pdf | |||
36510 | 36510 | 1993-04-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19930401-D01WNY03.pdf | |||
41904 | 41904 | 1976-04-22 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DONALD G. AGGER | Available-FARA-Public-Office | ||
41905 | 41905 | 1976-04-22 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | THOMAS H. FLOYD, JR. | Available-FARA-Public-Office | ||
42148 | 42148 | 1985-04-23 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ERNEST R. WARNER, JR. | Available-FARA-Public-Office | ||
42149 | 42149 | 1985-04-23 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | THOMAS H. FLOYD, JR. | Available-FARA-Public-Office | ||
42596 | 42596 | 1989-04-25 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | SANDRA K. MEREDITH | Available-FARA-Public-Office | ||
42597 | 42597 | 1989-04-25 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | SANDRA K. MEREDITH | Available-FARA-Public-Office | ||
43530 | 43530 | 1994-04-28 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Supplemental Statement | https://efile.fara.gov/docs/2621-Supplemental-Statement-19940428-DRVICY95.pdf | |||
45761 | 45761 | 1978-05-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Amendment | https://efile.fara.gov/docs/2621-Amendment-19780501-D01QQB03.pdf | |||
45762 | 45762 | 1978-05-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | MYER RASHISH | Available-FARA-Public-Office | ||
45991 | 45991 | 1982-05-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | HOWARD GOLDBERG | Available-FARA-Public-Office | ||
46265 | 46265 | 1985-05-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | ARIANESPACE, S.A. | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19850501-D01PUG03.pdf | |
46795 | 46795 | 1989-05-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ANDREW C. A. JAMPOLER | Available-FARA-Public-Office | ||
53093 | 53093 | 1986-05-19 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | KENT MONTAVON | Available-FARA-Public-Office | ||
53094 | 53094 | 1986-05-19 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | PAUL C. SETZE | Available-FARA-Public-Office | ||
58065 | 58065 | 1976-06-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | WILLIAM WEITZEN | Available-FARA-Public-Office | ||
58314 | 58314 | 1979-06-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOFREAVIA | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19790601-D01Q3M03.pdf | |
58315 | 58315 | 1979-06-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | CHARLES E. GOODELL | Available-FARA-Public-Office | ||
58608 | 58608 | 1982-06-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | DIRECTEUR DES RELATIONS INTERNATIONALES DE LA DELEGATION | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19820601-D01RWH03.pdf | |
58716 | 58716 | 1983-06-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOCIETE NATIONALE D'ETUDE ET DE CONSTRUCTION DE MOTEURS | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19830601-D01R9403.pdf | |
63498 | 63498 | 1983-06-08 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | HUGH J. GOWNLEY | Available-FARA-Public-Office | ||
63499 | 63499 | 1983-06-08 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LLOYD PRESLAR | Available-FARA-Public-Office | ||
63744 | 63744 | 1983-06-09 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ERNEST R. WARNER, JR. | Available-FARA-Public-Office | ||
63745 | 63745 | 1983-06-09 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | RICHARD L. KLASS | Available-FARA-Public-Office | ||
64007 | 64007 | 1983-06-10 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DONALD G. AGGER | Available-FARA-Public-Office | ||
64008 | 64008 | 1983-06-10 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | HOWARD S. GOLDBERG | Available-FARA-Public-Office | ||
64293 | 64293 | 1982-06-11 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DONALD G. AGGER | Available-FARA-Public-Office | ||
64294 | 64294 | 1982-06-11 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | M. ALAN WOODS | Available-FARA-Public-Office | ||
64295 | 64295 | 1982-06-11 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | RICHARD L. KLASS | Available-FARA-Public-Office | ||
64296 | 64296 | 1982-06-11 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | SEYMOUR N. ROSS | Available-FARA-Public-Office | ||
66199 | 66199 | 1983-06-20 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | CHARLES E. GOODELL | Available-FARA-Public-Office | ||
70773 | 70773 | 1976-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | ANDREW K. OPENCHOWSKI | Available-FARA-Public-Office | ||
70812 | 70812 | 1977-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | AIRBUS INDUSTRIE | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19770701-D01OJ503.pdf | |
70861 | 70861 | 1978-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Amendment | https://efile.fara.gov/docs/2621-Amendment-19780701-D01QMM03.pdf | |||
70907 | 70907 | 1979-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | UNION DE TRANSPORTS AERIENS | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19790701-D01QBR03.pdf | |
71148 | 71148 | 1983-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LESLIE ALLAN JANKA | Available-FARA-Public-Office | ||
71219 | 71219 | 1984-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | THOMSON-CSF, DIVISION SYSTEMS ELECTRONIQUE | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19840701-D01R0F03.pdf | |
71220 | 71220 | 1984-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LLOYD T. PRESLAR | Available-FARA-Public-Office | ||
71974 | 71974 | 1990-07-01 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | POWELL A. MOORE | Available-FARA-Public-Office | ||
73707 | 73707 | 1989-07-03 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Exhibit AB | SOCIETE NATIONALE DES POUDRES ET EXPLOSIFS | FRANCE | https://efile.fara.gov/docs/2621-Exhibit-AB-19890703-D01PEY03.pdf | |
73708 | 73708 | 1989-07-03 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LLOYD T. PRESLAR | Available-FARA-Public-Office | ||
73709 | 73709 | 1989-07-03 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | SAMUEL J. AGGER | Available-FARA-Public-Office | ||
73903 | 73903 | 1979-07-05 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | CHARLES E. GOODELL | Available-FARA-Public-Office | ||
73904 | 73904 | 1979-07-05 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | DONALD G. AGGER | Available-FARA-Public-Office | ||
73905 | 73905 | 1979-07-05 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | HOWARD S. GOLDBERG | Available-FARA-Public-Office | ||
73906 | 73906 | 1979-07-05 | DGA INTERNATIONAL, INC. | DGA International, Inc. 2621 | Short-Form | LLOYD T. PRESLAR | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
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]) );