facilities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where license_type = "Class H - Intermediate Handler" and site_state = "New York" sorted by legal_name
This data as json, CSV (advanced)
Suggested facets: site_city, site_zip, last_seen_date, last_seen_date (date)
| cert_number | customer_number | legal_name ▼ | dba_name | site_name | site_address | site_city | site_state | site_zip | license_type | status | first_seen_date | last_seen_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21-H-0019 | 747 | ANIMALS AWAY | ANIMALS AWAY | PECONIC | New York | 11958 | Class H - Intermediate Handler | 2021-03-02 | ||||
| 21-H-0326 | 500996 | ARK IMPORT EXPORT CENTER LLC | THE ARK AT JFK | JAMAICA | New York | 11430 | Class H - Intermediate Handler | 2023-08-28 | ||||
| 21-H-0338 | 600815 | ASAK SOLUTIONS LLC | ASAK Solutions LLC | JAMAICA | New York | 11430 | Class H - Intermediate Handler | 2022-02-16 | ||||
| 21-H-0310 | 15566 | AmbuVet LLC | AMBUVET L L C | JACKSON HGTS | New York | 11372 | Class H - Intermediate Handler | 2021-02-16 | ||||
| 21-H-0328 | 504100 | Delex Air Cargo LLC | DELEX AIR CARGO LLC | JAMAICA | New York | 11430 | Class H - Intermediate Handler | 2021-12-22 | ||||
| 21-H-0332 | 507482 | HELENS PET TRANSPORT LLC | HELENS PET TRANSPORT LLC | FREEPORT | New York | 11520 | Class H - Intermediate Handler | 2021-02-16 | ||||
| 58-H-0105 | 906 | JETSTREAM GROUND SERVICES INC | LAGUARDIA AIRPORT | FLUSHING | New York | 11371 | Class H - Intermediate Handler | 2020-01-15 | ||||
| 21-H-0322 | 323617 | Jeff Taylor | JEFF TAYLOR | DUNDEE | New York | 14837 | Class H - Intermediate Handler | 2016-07-19 | ||||
| 21-H-0320 | 328295 | MARKEN L L P | MARKEN L L P | UNIONDALE | New York | 11434 | Class H - Intermediate Handler | 2014-11-13 | ||||
| 21-H-0022 | 757 | MOBILE AIR TRANSPORT INC | MOBILE AIR TRANSPORT | LATHAM | New York | 12110 | Class H - Intermediate Handler | 2014-06-25 | ||||
| 21-H-0325 | 43282 | MSN Air Service Inc | MSN AIR SERVICE INC | JAMAICA | New York | 11430 | Class H - Intermediate Handler | 2023-09-26 | ||||
| 21-H-0313 | 21467 | Mersant International Ltd | JOSEPH SANTARELLI JR | JAMAICA | New York | 11434 | Class H - Intermediate Handler | 2021-01-26 | ||||
| 21-H-0366 | 6014186 | Natalie J Muka | Natalie Joy Muka | Cortland | New York | 13045 | Class H - Intermediate Handler | 2023-06-27 | ||||
| 21-H-0306 | 426 | PET ENTERPRISES TOTAL SERVICES, INC. | WILLOW PET HOTEL/ANIMAL TRAVEL AGENCY | DEER PARK | New York | 11729 | Class H - Intermediate Handler | 2021-01-11 | ||||
| 21-H-0015 | 510 | VETPORT ANIMAL HOSPITAL INC | VETPORT ANIMAL HOSPITAL | JAMAICA | New York | 11430 | Class H - Intermediate Handler | 2016-05-19 | ||||
| 21-H-0323 | 332294 | We're Pretty Darn Quick Delivery Service | WE'RE PRETTY DARN QUICK DELIVERY SERVICE | ROCHESTER | New York | 14624 | Class H - Intermediate Handler | 2018-05-17 | ||||
| 21-H-0003 | 425 | World Wide Pet Transport Corporation | World Wide Pet Transport Corporation | Glen Head | New York | 11545 | Class H - Intermediate Handler | 2020-12-07 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE facilities (
cert_number TEXT PRIMARY KEY,
customer_number TEXT,
legal_name TEXT,
dba_name TEXT,
site_name TEXT,
site_address TEXT,
site_city TEXT,
site_state TEXT,
site_zip TEXT,
license_type TEXT,
status TEXT,
first_seen_date TEXT,
last_seen_date TEXT
);
CREATE INDEX idx_facilities_state ON facilities(site_state);
CREATE INDEX idx_facilities_type ON facilities(license_type);
CREATE INDEX idx_facilities_name ON facilities(legal_name);