AIRPORT

1 - 50 of 190

Active

1st September 2005


Active

8th September 2009


Inactive

1st April 1994 - 31st December 1999


Active

9th June 2004


Active

1st November 2000


Inactive

19th March 2002 - 31st December 2004


Active

1st February 2004


Active

1st January 1987


Inactive

10th January 2002 - 8th November 2003


Inactive

22nd January 2000 - 28th September 2001


AIRPORT BUSINESS CTR

LOS ANGELES

Inactive

1st January 1997 - 15th May 2003


Active

1st January 2004


Active

16th December 2009


Inactive

10th January 2001 - 1st January 2007


Inactive

1st April 1986 - 1st January 2007


Inactive

5th December 1983 - 30th April 2018


Inactive

24th April 2001 - 31st May 2009


Active

16th August 1988


Active

1st November 2013


AIRPORT CONSULTING INC

LA SELVA BEACH

Inactive

2nd August 2004 - 1st January 2007


Inactive

23rd August 1993 - 24th August 1996


Inactive

20th June 1994 - 31st December 2000


Inactive

28th February 2008 - 31st December 2013


Active

1st February 1976


Inactive

1st March 1984 - 31st December 2000


AIRPORT ELYAD CORP

LOS ANGELES

Inactive

1st January 1997 - 31st December 1998


Inactive

19th October 2002 - 31st December 2011


Inactive

1st March 2002 - 31st December 2002


AIRPORT FILMS INC

LOS ANGELES

Inactive

16th July 2007 - 31st December 2010


Active

31st May 2017


Inactive

9th July 2004 - 1st November 2004


Inactive

1st October 1969 - 31st March 2005


Active

3rd May 2013


AIRPORT HOLDINGS LP

LOS ANGELES

Inactive

4th October 2005 - 14th April 2016


AIRPORT HOLDINGS LP

LOS ANGELES

Inactive

4th October 2005 - 14th April 2016


AIRPORT HOLDINGS LP

LOS ANGELES

Inactive

4th October 2005 - 14th April 2016


AIRPORT HOLDINGS LP

NORTH HOLLYWOOD

Active

4th October 2005


Inactive

28th February 2002 - 31st December 2002


Inactive

28th February 2002 - 31st December 2002


Inactive

15th August 1992 - 28th August 1999


Inactive

21st October 2008 - 31st December 2016


Inactive

1st June 1991 - 1st July 1997


Active

21st August 2002


Active

17th November 1987


Inactive

12th December 2003 - 31st December 2011


Inactive

21st September 2011 - 1st April 2012


Active

15th November 2003


Inactive

12th September 2005 - 28th February 2012


Inactive

1st October 2011 - 1st April 2012


Inactive

30th June 2006 - 1st June 2014


(default) 2 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`Location_Account`, `Record`.`BUSINESS_NAME`, `Record`.`DBA_NAME`, `Record`.`STREET_ADDRESS`, `Record`.`CITY`, `Record`.`ZIP_CODE`, `Record`.`LOCATION_DESCRIPTION`, `Record`.`MAILING_ADDRESS`, `Record`.`MAILING_CITY`, `Record`.`MAILING_ZIP_CODE`, `Record`.`NAICS`, `Record`.`PRIMARY_NAICS_DESCRIPTION`, `Record`.`COUNCIL_DISTRICT`, `Record`.`LOCATION_START_DATE`, `Record`.`LOCATION_END_DATE`, `Record`.`LOCATION` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+AIRPORT)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 50505010
2SELECT COUNT(*) AS `count` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+AIRPORT)' IN BOOLEAN MODE)111