home / aphis

facilities

USDA APHIS-licensed animal welfare facilities including breeders, dealers, exhibitors, and research labs. 15,000+ facilities across all 50 states.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

19 rows where license_type = "Class H - Intermediate Handler" and site_state = "Illinois" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: site_city, site_zip, last_seen_date, last_seen_date (date)

site_state 1

  • Illinois · 19 ✖

license_type 1

  • Class H - Intermediate Handler · 19 ✖

status 0

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
33-H-0001 768 AARK AIR INTERNATIONAL INC   AARK AIR INTERNATIONAL, INC.   EARLVILLE Illinois 60518 Class H - Intermediate Handler     2018-01-30
58-H-0006 24 AIRCRAFT SERVICE INTERNATIONAL INC   AIRCRAFT SERVICE INTERNATIONAL, INC.   CHICAGO Illinois 60666 Class H - Intermediate Handler     2017-05-23
33-H-0009 624 AMERICAN PET MOTELS, INC.   AMERICAN PET MOTELS   PRAIRIE VIEW Illinois 60069 Class H - Intermediate Handler     2017-06-19
33-H-0027 324313 Airport Logistics Group   AIRPORT LOGISTICS GROUP INC   CHICAGO Illinois 60666 Class H - Intermediate Handler     2021-07-22
33-H-0034 507855 BLAKE ROGERS   BLAKE ROGERS   NOBLE Illinois 62868 Class H - Intermediate Handler     2020-03-03
34-H-0018 324876 GROUND SERVICES INTERNATIONAL   GROUND SERVICES INTERNATIONAL   CHICAGO Illinois 60666 Class H - Intermediate Handler     2018-07-19
84-H-0038 1643 INTEGRATED AIRLINE SERVICES INC.   INTEGRATED AIRLINE SERVICES, INC.   FRANKLIN PARK Illinois 60131 Class H - Intermediate Handler     2014-12-11
33-H-0040 6003508 Maestro Cargo International LLC   Maestro Cargo International LLC   CHICAGO Illinois 60666 Class H - Intermediate Handler     2021-07-26
33-H-0024 325667 PATTY RICH   PATTY RICH   GURNEE Illinois 60031 Class H - Intermediate Handler     2016-02-11
33-H-0026 329833 PET EMBARKING   PET EMBARKING L L C   NAPERVILLE Illinois 60540 Class H - Intermediate Handler     2014-05-05
33-H-0054 322640 Paws Around Chicago LLC   PAWS AROUND CHICAGO LLC   CHICAGO Illinois 60612 Class H - Intermediate Handler     2017-08-22
33-H-0036 506636 RANDALL MAST   RANDALL MAST   ATWOOD Illinois 61913 Class H - Intermediate Handler     2020-12-10
33-H-0003 621 ROWENS KENNELS   ROWENS KENNELS   BRIGHTON Illinois 62012 Class H - Intermediate Handler     2021-08-23
33-H-0031 505261 SARAH LIMBERS   SARAH LIMBERS   CHICAGO Illinois 60612 Class H - Intermediate Handler     2025-12-31
33-H-0028 332320 SHARPTOOTH 2-0 INC   SHARPTOOTH 2-0 INC   EVANSTON Illinois 60203 Class H - Intermediate Handler     2023-09-26
33-H-0013 1683 SHAW-SAN TRANSFER, INC.   SHAW-SAN TRANSFER, INC   MCHENRY Illinois 60050 Class H - Intermediate Handler     2017-06-26
21-H-0324 332338 SPOT TRAVEL L L C   SPOT TRAVEL L L C   CHICAGO Illinois 60666 Class H - Intermediate Handler     2015-07-09
33-H-0002 772 THE FREIGHT ESCAPE INC   THE FREIGHT ESCAPE, INC.   BENSENVILLE Illinois 60106 Class H - Intermediate Handler     2017-06-19
21-H-0016 718 WORLD COURIER, INC.   WORLD COURIER, INC.   BENSENVILLE Illinois 60106 Class H - Intermediate Handler     2017-06-19

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 31.46ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API