facilities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
19 rows where license_type = "Class T - Carrier" and site_state = "Ohio" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31-T-0222 | 6012119 | A & L Pet Service | A & L PET SERVICE | FRESNO | Ohio | 43824 | Class T - Carrier | 2024-11-07 | ||||
| 31-T-0029 | 331994 | Air Transport International Inc. | AIR TRANSPORT INTERNATIONAL INC | WILMINGTON | Ohio | 45177 | Class T - Carrier | 2021-04-22 | ||||
| 31-T-0025 | 330087 | BARBARA WRIGHT | BARB WRIGHT | WEST SALEM | Ohio | 44287 | Class T - Carrier | 2016-01-04 | ||||
| 31-T-0076 | 600145 | BestCare Pet Transport | Heldman Logistics LLC | Ada | Ohio | 45810 | Class T - Carrier | 2021-01-22 | ||||
| 31-T-0042 | 501479 | Deeanne Hefner | DEEANNE HOSMER | BLOOMDALE | Ohio | 44817 | Class T - Carrier | 2018-03-29 | ||||
| 31-T-0211 | 601413 | Dependable Driver Solutions LLC | Dependable Driver Solutions LLC | Mentor | Ohio | 44060 | Class T - Carrier | 2025-07-29 | ||||
| 31-T-0011 | 45457 | GREG MAHLE | GREG MAHLE | MOUNT PERRY | Ohio | 43760 | Class T - Carrier | 2015-06-27 | ||||
| 31-T-0037 | 324575 | Irma Miller | IRMA MILLER | MILLERSBURG | Ohio | 44654 | Class T - Carrier | 2016-11-03 | ||||
| 31-T-0045 | 503396 | JOHN HIXON | JOHN PAUL HIXON | WAPAKONETA | Ohio | 45895 | Class T - Carrier | 2018-10-01 | ||||
| 31-T-0031 | 332534 | JULIE BINGHAM | JULIE BINGHAM | CLAYTON | Ohio | 45315 | Class T - Carrier | 2018-08-29 | ||||
| 31-T-0092 | 602160 | Jordan Castle | Jordan Castle | Ada | Ohio | 45810 | Class T - Carrier | 2021-01-22 | ||||
| 31-T-0075 | 600515 | Joseph Pittenger | Joseph Pittenger | Holland | Ohio | 43528 | Class T - Carrier | 2021-01-04 | ||||
| 31-T-0077 | 600364 | Mary Jo L Favitta | Mary Jo L Favitta | Strongsville | Ohio | 44149 | Class T - Carrier | 2021-01-07 | ||||
| 31-T-0086 | 601026 | Randolph Hester | Randolph Hester | Greenfield | Ohio | 45123 | Class T - Carrier | 2023-11-02 | ||||
| 31-T-0034 | 333175 | Regina Miller | Regina Miller | Dundee | Ohio | 44624 | Class T - Carrier | 2021-02-01 | ||||
| 31-T-0074 | 600037 | Rex L Gaylord | Rex L Gaylord | BRECKSVILLE | Ohio | 44141 | Class T - Carrier | 2021-01-07 | ||||
| 32-T-0007 | 34228 | SHUTTLE AMERICA | CINCINNATI/NORTHERN KY INTL AIRPORT | CINCINNATI | Ohio | 45275 | Class T - Carrier | 2017-02-16 | ||||
| 31-T-0019 | 327532 | TOO ZOO LOGISTICS LLC | TOO ZOO LOGISTICS LLC | OAK HARBOR | Ohio | 43449 | Class T - Carrier | 2019-05-29 | ||||
| 31-T-0090 | 601112 | Vicky Chelchowski | Vicky Chelchowski | Toledo | Ohio | 43611 | Class T - Carrier | 2021-01-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);