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