Amusement Device Permanent [Permits for Amusement Device Permanent]

51 - 100 of 171

ADVENTURE'S PARK

Business

Active



FOREST PARK CAROUSEL

Business

Inactive


ADVENTURE'S AMUSEMENT PARK

Business

Active


ADVENTURE'S AMUSEMENT PARK

Business

Active


FUNTOPIA USA

Business

Active


LUNA PARK

Business

Inactive


FLUSHING MEADOWS PARK

Business

Inactive



LUNA PARK

Business

Active


LAND-O-FUN, INC

Business

Active


LUNA PARK

Business

Active


LUNA PARK

Business

Inactive


12TH STREET AMUSEMENTS

Business

Inactive


LUNA PARK

Business

Inactive


VICTORIAN GARDENS

Business

Inactive


LUNA PARK

Business

Active


ADVENTURE'S PARK

Business

Inactive


THUNDER RIDE

Business

Inactive


ADVENTURE'S AMUSEMENT PARK

Business

Active


DENO'S WONDER WHEEL PARK

Business

Active


SCREAM ZONE

Business

Active


VICTORIAN GARDENS

Business

Inactive


THE CYCLONE ROLLER COASTER

Business

Active



ADVENTURE'S AMUSEMENT PARK

Business

Active


ADVENTURE'S PARK

Business

Active


ADVENTURE'S AMUSEMENT PARK

Business

Active



LUNA PARK

Business

Active


VICTORIAN GARDENS

Business

Inactive


ADVENTURE'S PARK

Business

Active


NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive



CAROUSEL

Business

Active


FUN STATION USA

Business

Active


DUSTY LEE CORP.

Business

Active


ADVENTURE'S AMUSEMENT PARK

Business

Active




NY CAROUSEL ENTERTAINMENT, LLC

Business

Inactive


BRYANT PARK CORPORATION

Business

Active


ADVENTURE'S AMUSEMENT PARK

Business

Active


12TH ST. AMUSEMENT

Business

Inactive


DENO'S WONDER WHEEL PARK

Business

Inactive



SIMULATOR

Business

Inactive


CAROUSEL

Business

Inactive


LUNA PARK

Business

Active


MINI TWISTER

Business

Inactive


(default) 2 queries took 454 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Amusement +Device +Permanent)' IN BOOLEAN MODE) LIMIT 50, 505050183
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Amusement +Device +Permanent)' IN BOOLEAN MODE)11271