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

180 rows where City = "Philadelphia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

City 1

  • Philadelphia · 180 ✖
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
2086 2086   2022-11-12 Mach George Edward James Unique Solution Advisors 7191 2022-11-12 Unique Solution Advisors 2531 West Girard Avenue Unit 3 Philadelphia PA 19130
3092 3092 1967-01-04 1960-01-07 Friedmann Rochelle Friedmann Radio Broadcasting & Advertising Company 1304 1959-12-07 Friedmann Radio Broadcasting & Advertising Company 1105 Friendship Street   Philadelphia PA 19111
3093 3093 1967-01-04 1964-09-21 Berensmann Hanns-Peter Friedmann Radio Broadcasting & Advertising Company 1304 1959-12-07 Friedmann Radio Broadcasting & Advertising Company 1105 Friendship Street   Philadelphia PA 19111
3130 3130 1999-01-04 1989-02-17 Heath Charles S. Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Eight Penn Center 19th Floor, Suite 1950 Philadelphia PA 19103
3167 3167 1983-01-05 1978-07-06 Gray Jerome Compton Advertising, Inc. 2925 1978-07-06 Compton Advertising, Inc. 1819 John F. Kennedy Boulevard   Philadelphia PA 19103
3168 3168 1983-01-05 1978-07-06 Gray Thelma Compton Advertising, Inc. 2925 1978-07-06 Compton Advertising, Inc. 1819 John F. Kennedy Boulevard   Philadelphia PA 19103
3169 3169 1983-01-05 1978-07-06 Gruver C. Robert Compton Advertising, Inc. 2925 1978-07-06 Compton Advertising, Inc. 1819 John F. Kennedy Boulevard   Philadelphia PA 19103
3748 3748 1999-01-15 1996-07-01 Milano Karen J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
4025 4025 1973-01-19 1972-04-13 Richmond Curt Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
4842 4842 1962-01-31 1958-08-25 Freedman Jean Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
6137 6137 2023-02-05 2011-02-15 Bokhari Raza Bokhari, Raza 6018 2011-02-15 Bokhari, Raza 1717 Arch Street 39th Floor Philadelphia PA 19103
6972 6972 1983-02-16 1981-09-23 Sommers Allen Sommers/Rosen, Inc. 3276 1981-09-23 Sommers/Rosen, Inc. 1405 Locust Street   Philadelphia PA 19102
7386 7386 1995-02-23 1994-05-06 Helfrich Jacqueline Anne Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
7486 7486 1960-02-25 1959-10-14 Graczyk Ludwik Polish-American Travel Service 1262 1959-08-28 Polish-American Travel Service 2714 East Allegheny Avenue   Philadelphia PA  
7635 7635 1999-02-26 1997-01-16 Horan Michael F. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
8056 8056 2001-02-28 1998-10-30 Berge Pauline C. Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Eight Penn Center 19th Floor, Suite 1950 Philadelphia PA 19103
8193 8193 2015-02-28 2015-02-09 Feldman Dennis Ceisler Media & Issue Advocacy, LLC 6266 2014-12-19 Ceisler Media & Issue Advocacy, LLC 1525 Locust Street, 6th Floor   Philadelphia PA 19102
8708 8708 1996-03-01 1995-06-19 Ryan M. Martha Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
8876 8876 2000-03-02 1997-07-11 Butler R. Mark Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
9150 9150 1998-03-06 1994-12-22 Zartarian Stephen K. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
9394 9394 1981-03-09 1979-03-30 Berger Danierl David Berger, P.A. 3009 1979-03-30 David Berger, P.A. 1622 Locust Street   Philadelphia PA 19103
9395 9395 1981-03-09 1979-03-30 Berger David David Berger, P.A. 3009 1979-03-30 David Berger, P.A. 1622 Locust Street   Philadelphia PA 19103
9779 9779 1964-03-15 1959-12-07 Schmitt Albert Richard Friedmann Radio Broadcasting & Advertising Company 1304 1959-12-07 Friedmann Radio Broadcasting & Advertising Company 1105 Friendship Street   Philadelphia PA 19111
10276 10276 2008-03-20 2005-10-28 Persia Dana Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
10356 10356 2005-03-21 2004-03-25 Allmayer Bernard Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
10407 10407 2001-03-22 2000-12-18 Myers Laurence Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
10426 10426 1960-03-23 1948-02-16 Bellia Harry J. Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10427 10427 1960-03-23 1948-02-16 Freedman David Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10428 10428 1960-03-23 1948-02-16 Rifkin Maurice Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10429 10429 1960-03-23 1958-03-20 Kachnykewych Taras Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10430 10430 1960-03-23 1958-04-16 Freedman Jean Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10431 10431 1960-03-23 1958-04-16 Rifkin Lillian Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10432 10432 1960-03-23 1958-04-16 Rohatynskyj Peter Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10433 10433 1960-03-23 1958-04-16 Rosenberg Israel Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10434 10434 1960-03-23 1957-06-24 Adomonis John Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10435 10435 1960-03-23 1957-06-24 Biloskursky Mike Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10436 10436 1960-03-23 1957-06-24 Juodvalkis Anastasia Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10437 10437 1960-03-23 1957-06-24 Juodvalkis S.P. Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10438 10438 1960-03-23 1957-06-24 Kuczewski Thaddeus Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10439 10439 1960-03-23 1957-06-24 Lyons Norman Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10582 10582 2000-03-24 1997-07-07 Finamore Andrea J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
10733 10733 1978-03-27 1975-01-29 Daccarett Edward Jamaica Tourist Board, Philadelphia 2556 1975-01-29 Jamaica Tourist Board, Philadelphia 2 Penn Center Plaza Suite 1604 Philadelphia PA 19102
14651 14651 1999-04-30 1995-06-19 Cohen Barry Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
15597 15597 1995-05-05 1994-05-06 Vittolino Salvatore P. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
16363 16363 2008-05-16 2003-05-02 Rancourt Karolyn T. Rancourt, Karolyn T. 5559 2003-05-02 Rancourt, Karolyn T. 1648 South Orkney Street   Philadelphia PA 19148
16673 16673 2014-05-21 2013-12-12 Brandsdorfer Louis AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
17350 17350 2014-05-30 2013-06-20 Yarrow Steven AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
18238 18238 1976-06-01 1976-01-17 Adams Wayne W. Public Relations, Ltd. 2709 1976-07-17 Public Relations, Ltd. 3 Parkway   Philadelphia PA 19102
18239 18239 1976-06-01 1976-01-17 Rubin Lawrence D. Public Relations, Ltd. 2709 1976-07-17 Public Relations, Ltd. 3 Parkway   Philadelphia PA 19102
18240 18240 1976-06-01 1976-01-17 Weiner Warren Public Relations, Ltd. 2709 1976-07-17 Public Relations, Ltd. 3 Parkway   Philadelphia PA 19102
18593 18593 2010-06-03 2004-03-25 Peretz Michael Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
19131 19131 2009-06-12 2009-03-13 Hill James Duane Morris Government Affairs, LLC 5918 2009-03-13 Duane Morris Government Affairs, LLC 30 South 17th Street   Philadelphia PA 19103
19309 19309 1966-06-15 1958-08-25 Weresh Wasyl Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19322 19322 1971-06-15 1958-08-25 Kuczewski Thaddeus Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19502 19502 2000-06-16 1999-06-29 Dzwill Eileen Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
19551 19551 1977-06-17 1975-06-06 Lawrence Gordon G. Spiro & Associates, Inc. 2545 1974-11-04 Spiro & Associates, Inc. Chestnut East Building 841 Chestnut Street Philadelphia PA 19107
19552 19552 1977-06-17 1974-11-04 Sherman Martin Spiro & Associates, Inc. 2545 1974-11-04 Spiro & Associates, Inc. Chestnut East Building 841 Chestnut Street Philadelphia PA 19107
19629 19629 1999-06-18 1994-12-22 Vaughan-Gowen Deborah Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
19757 19757 2014-06-20 2013-12-12 Gentieu Valerie AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
19776 19776 1988-06-21 1971-05-20 Yamanov Peter Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19777 19777 1988-06-21 1978-08-21 Yamonov Elisabeth Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19778 19778 1988-06-21 1958-08-25 Rifkin Lillian K. Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19779 19779 1988-06-21 1958-08-25 Rifkin Maurice Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19780 19780 1988-06-21 1958-08-25 Rohatynskyj Peter Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19781 19781 1988-06-21 1973-11-01 Schmidt Mary M. Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
20140 20140 2015-06-26 2015-05-18 Moga Katelyn M. Ceisler Media & Issue Advocacy, LLC 6266 2014-12-19 Ceisler Media & Issue Advocacy, LLC 1525 Locust Street, 6th Floor   Philadelphia PA 19102
21172 21172 2000-06-30 1999-06-29 Masse Jennifer J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21185 21185 2001-06-30 1996-01-02 Cintron Ana M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21186 21186 2001-06-30 2000-01-10 Spratlin Jon Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21187 21187 2001-06-30 1997-01-16 Placido Peter A. , Jr. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21194 21194 2001-06-30 1994-05-06 Brandsdorfer Louis Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21195 21195 2001-06-30 1994-05-06 Evans John M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21196 21196 2001-06-30 1994-05-06 Hennessy Brian J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21197 21197 2001-06-30 1994-05-06 Kneisel William J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21198 21198 2001-06-30 1994-05-06 Lefton Al Paul , Jr. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21199 21199 2001-06-30 1994-05-06 Nunez Nurisell Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21200 21200 2001-06-30 1994-05-06 Orr John H. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21201 21201 2001-06-30 1994-05-06 Peretz Michael Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21202 21202 2001-06-30 1994-05-06 Russakoff Claire C. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21203 21203 2001-06-30 1994-05-06 Scanlon Raymond D. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21204 21204 2001-06-30 1994-05-06 Sharkey Darlene M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21205 21205 2001-06-30 1994-05-06 Spross Theresa Marie Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21206 21206 2001-06-30 1994-05-06 Waters David Bruce Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21207 21207 2001-06-30 1994-05-06 Yarrow Steven E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21210 21210 2001-06-30 2001-06-12 Fong Mary Ann Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21211 21211 2001-06-30 1995-06-19 Talbot James E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
21230 21230 2001-06-30 1998-12-21 Ditton Jill Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
23102 23102 2005-07-15 2004-03-25 Kneisel William J. Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
23542 23542 1998-07-21 1994-10-04 Coote Marian K. Florence Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Eight Penn Center 19th Floor, Suite 1950 Philadelphia PA 19103
23634 23634 1965-07-23 1964-07-24 Dilks Walter Howard , Jr. Dilworth, Paxson, Kalish, Kohn & Dilks 1775 1964-07-24 Dilworth, Paxson, Kalish, Kohn & Dilks 2635 Fidelity-Philadelphia Trust Building Philadelphia PA 19109
23736 23736 1999-07-23 1997-01-16 Michaud Anne E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
24796 24796 2001-07-31 1999-10-28 Muldowney Laura C. Gallagher, John J. 5336 1999-10-28 Gallagher, John J. 1760 Market Street Suite 1100 Philadelphia PA 19103
25019 25019 2014-07-31 2011-05-24 Orr John H. AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
25032 25032 2014-07-31 2013-06-20 Foster Stephanie A. AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
25033 25033 2014-07-31 2013-06-20 Talbot James B. AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
25056 25056 2014-07-31 2013-12-12 Waters D. Bruce AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
25576 25576 1966-08-02 1965-12-06 Rosenfeld Lawrence Mark Kenneth G. Smith & Associates, Inc. 1943 1965-12-06 Kenneth G. Smith & Associates, Inc. 1428 South Penn Square   Philadelphia PA 19102
25577 25577 1966-08-02 1965-12-06 Smith Kenneth G. , Sr. Kenneth G. Smith & Associates, Inc. 1943 1965-12-06 Kenneth G. Smith & Associates, Inc. 1428 South Penn Square   Philadelphia PA 19102
27382 27382 1996-08-28 1995-06-19 LaBranche Angelique Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
28163 28163 2000-08-31 1999-10-28 Leventant Williams Gallagher, John J. 5336 1999-10-28 Gallagher, John J. 1760 Market Street Suite 1100 Philadelphia PA 19103

Next page

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