FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "New York" and Registrant_Name = "Airbus Industrie of North America, Inc."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- NY 17
Registration_Number 1
Registrant_Name 1
- Airbus Industrie of North America, Inc. · 17 ✖
City 1
- New York · 17 ✖
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
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]) );