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

21 rows where license_type = "Class T - Carrier" and site_state = "Michigan" 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

  • Michigan · 21 ✖

license_type 1

  • Class T - Carrier · 21 ✖

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
34-T-0174 6015272 Avflight Services Corporation   Avflight Services Corporation - DTW - Detroit Metro Airport   Romulus Michigan 48174 Class T - Carrier     2023-06-28
34-T-0019 501870 CLARENCE BROWN   BROWNS PET TRANSPORTATION   JENISON Michigan 49428 Class T - Carrier     2018-10-18
34-T-0025 502658 DOGS ON THE GROUND TRANSPORT AND TAXI SERVICE   DOGS ON THE GROUND TRANSPORT AND TAXI SERVICE   ROYAL OAK Michigan 48073 Class T - Carrier     2018-08-13
34-T-0042 600950 Dees Transport Services LLC   Dees Transport Services LLC   Howell Michigan 48433 Class T - Carrier     2021-03-16
34-T-0084 6003256 Destiny Powers   Destiny Powers   Ray Michigan 48096 Class T - Carrier     2021-11-12
34-T-0018 501165 GWEN JOHNSON   JOHNSON PET SERVICES   ALBION Michigan 49224 Class T - Carrier     2018-10-17
34-T-0012 328929 Great Lakes Pet transportation LLC   GREAT LAKES PET TRANSPORTATION LLC   TAYLOR Michigan 48180 Class T - Carrier     2016-05-18
34-T-0020 2010 HODGINS KENNELS INC   HODGINS KENNELS INC   HOWELL Michigan 48843 Class T - Carrier     2018-09-17
34-T-0016 2018 International Animal Exchange, Inc.   INTERNATIONAL ANIMAL EXCHANGE INC   ROYAL OAK Michigan 48067 Class T - Carrier     2020-12-10
34-T-0210 333353 Jungle Frenzy LLC   Jungle Frenzy LLC   Adrian Michigan 49221 Class T - Carrier     2021-07-13
34-T-0015 500920 KRISTEN RYE   KRISTEN RYE   CLIFFORD Michigan 48727 Class T - Carrier     2018-04-18
34-T-0056 603358 Michael Goodreau   Mike's Paws and Claws Pet Limo   West Branch Michigan 48661 Class T - Carrier     2021-03-16
34-T-0024 503770 PET LIFE TRANSPORTATION LLC   PET LIFE TRANSPORTATION LLC   CLAYTON Michigan 49235 Class T - Carrier     2018-04-17
21-T-0093 26287 Royal Jordanian Airline   Royal Jordanian Airline   ROMULUS Michigan 48174 Class T - Carrier     2022-03-16
34-T-0023 502570 SAMANTHA STEWART   PUPPY STORKS   LANSING Michigan 48911 Class T - Carrier     2019-05-15
34-T-0028 504363 SHARON OWEN   SHARON OWEN   JACKSON Michigan 49202 Class T - Carrier     2019-03-19
34-T-0021 501287 Saginaw Tropical Animals LLC   JEREMIAH TIETZ   SAGINAW Michigan 48601 Class T - Carrier     2023-05-10
34-T-0048 601071 Shae Allen Powers   Shae Allen Powers   Roscommon Michigan 48653 Class T - Carrier     2021-03-17
34-T-0039 600363 Steven Peter Ippel   Steven Peter Ippel   Kentwood Michigan 49508 Class T - Carrier     2021-03-22
34-T-0156 6013774 Toni Kastanos   Toni Kastanos   Waterford Michigan 48329 Class T - Carrier     2022-09-20
34-T-0026 501558 VALERIE CLAYTON   VALERIE CLAYTON   FARMINGTON Michigan 48335 Class T - Carrier     2018-11-20

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);