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

17 rows where license_type = "Class T - Carrier" and site_state = "Pennsylvania" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: customer_number, legal_name, site_name, site_city, site_zip, last_seen_date, last_seen_date (date)

site_state 1

  • Pennsylvania · 17 ✖

license_type 1

  • Class T - Carrier · 17 ✖

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
23-T-0030 335699 BRIAN EVAN FULLER   BRIAN FULLER   CHELTENHAM Pennsylvania 19012 Class T - Carrier     2017-01-20
23-T-0029 500428 Conodoguinet Creek Kennel LLC   Conodoguinet Creek Kennel LLC   Newburg Pennsylvania 17240 Class T - Carrier     2022-07-11
23-T-0207 334970 Greenfield Puppies   Greenfield Puppies   LANCASTER Pennsylvania 17602 Class T - Carrier     2024-09-11
23-T-0035 334970 Greenfield Puppies   Greenfield Puppies   LANCASTER Pennsylvania 17602 Class T - Carrier     2019-05-20
23-T-0033 500915 JEFFREY TORRES   ON MY WAY HOME TRANSPORTS   KINGSLEY Pennsylvania 18826 Class T - Carrier     2017-04-13
23-T-0192 6015739 Jared Binder   Jared Binder   Nazareth Pennsylvania 18064 Class T - Carrier     2023-10-02
23-T-0255 6020122 Jon Coover   Jon Coover   Lancaster Pennsylvania 17601 Class T - Carrier     2024-05-09
23-T-0026 332444 KEY COURIER LOGISTICS LLC   EVAN BLOCK   SCHNECKSVILLE Pennsylvania 18078 Class T - Carrier     2016-11-03
23-T-0028 326664 MIKE ZLOTNICK   MIKE ZLOTNICK   CHELTENHAM Pennsylvania 19012 Class T - Carrier     2017-01-20
23-T-0027 334524 PET TRANSPORTER GUYS L.L.C.   PET TRANSPORTER GUYS LLC   GOULDSBORO Pennsylvania 18424 Class T - Carrier     2016-11-18
23-T-0042 506114 PETS ON THE MOVE LLC   PETS ON THE MOVE LLC   YORK Pennsylvania 17402 Class T - Carrier     2019-06-17
23-T-0032 500955 PILGRIMS PROMISE   DANIEL MC CAUGHAN   EXTON Pennsylvania 19341 Class T - Carrier     2018-02-20
23-T-0024 331990 PITTSBURGH AVIATION ANIMAL RESCUE TEAM   PITTSBURGH AVIATION ANIMAL RESCUE TEAM   WEST MIFFLIN Pennsylvania 15122 Class T - Carrier     2015-03-26
23-T-0053 508652 PUPPY EXPRESS LLC   PUPPY EXPRESS LLC   NEW HOLLAND Pennsylvania 17557 Class T - Carrier     2020-10-14
23-T-0025 331669 SYDNEY ROPP   SYDNEY ROPP   EAST EARL Pennsylvania 17519 Class T - Carrier     2019-08-08
23-T-0273 6021652 Sharon Schuler   Sharon Schuler   Ronks Pennsylvania 17572 Class T - Carrier     2024-05-29
23-T-0022 330477 TRAVELING FRIENDS TRANSIT LLC   TRAVELING FRIENDS TRANSIT LLC   EASTON Pennsylvania 18045 Class T - Carrier     2016-11-15

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 473.214ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API