FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

17 rows where Registration_Number = 2817

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_Date (date)

State 1

Registration_Number 1

  • Airbus Industrie of North America, Inc. · 17 ✖

City 1

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
4302 4302 1980-01-23 1978-08-02 Landrock Gero Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
5722 5722 1980-02-01 1978-03-06 Davis James Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
5724 5724 1980-02-01 1978-07-06 Schwalm Klaus Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
5726 5726 1980-02-01 1978-08-25 Kettler Carl Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
8737 8737 1981-03-01 1979-08-27 Maund David J. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
10945 10945 1983-03-28 1982-03-02 Day Herman E. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
10946 10946 1983-03-28 1979-03-16 Smith Carolyn L. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
10947 10947 1983-03-28 1982-05-11 Landrock Gerd Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
10948 10948 1983-03-28 1978-06-05 Kieklak Michael W. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
10949 10949 1983-03-28 1978-06-12 Cocke Clyde Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
10950 10950 1983-03-28 1977-08-02 Galer Gilbert E. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
13386 13386 1980-04-15 1979-03-13 Miller Byron H. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
15347 15347 1980-05-01 1978-06-22 Krinner Otmar Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
15348 15348 1980-05-01 1977-08-26 Wards George A. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
18442 18442 1980-06-01 1978-06-27 Lee Alan Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
22131 22131 1981-07-01 1978-06-22 Browning Ross C. Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111
26353 26353 1979-08-10 1978-06-05 Huber Ken Airbus Industrie of North America, Inc. 2817 1977-08-02 Airbus Industrie of North America, Inc. 630 Fifth Avenue   New York NY 10111

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])
);