Semantic search
citation_inspection
2 rows where hash_id = "7f1484f703800b0f"
This data as json, CSV (advanced)
The facility's registration expired 09/01/23. The facility representative stated that they were not aware of the expiration date. A current and active registration is necessary to transport regulated species to be in compliance with the Animal Welfare Act and Regulations. Each carrier or handler who handles covered animals shall ensure they are registered with USDA by completing and filing a properly executed form and that the registration is updated every 3 years by the completion and filing of a new registration form. Airwaybill # 001-79932204 shows that one (1) Live dog, a Golden Retriever, age 8 weeks, was shipped on 10/12/2023 on flight # 2463 from Chicago O’ Hare International Airport to Sacramento International Airport. At approximately 1330 hours on October 12, 2023, a GAT cargo employee was observed handling the above-mentioned dog. No regulated activities may be conducted until a USDA registration is obtained.
| rowid | 40 |
| desc | Requirements and procedures. |
| web_siteName | GENERAL AVIATION TERMINAL, INC. |
| kind | |
| Incident hash_id | 7f1484f703800b0f |
| web_inspectionDate | 2023-10-12 |
| code | 2.25(a) |
| repeat | 1 |
| pdf_insp_type | FOCUSED INSPECTION |
| pdf_animals_total | 1.0 |
| web_certType | Class H - Intermediate Handler |
| pdf_customer_id | 31.0 |
| pdf_customer_name | General Aviation Terminal Inc |
| pdf_customer_addr | 8400 AIRPORT BLVD WEST RAMP RD MOBILE, AL 36608 |
| customer_state | AL |
| pdf_site_id | SMF |
| doccloud_url | https://www.documentcloud.org/documents/24358025-aphis-inspection-ins-0000913256 |
| lat | 30.6800208 |
| lng | -88.24911399999999 |
At the cargo office for General Aviation Terminal, two cats had been accepted for transport on waybill # 173-07836920, on a flight bound for Honolulu. The shipment date on the waybill was 04/10/2023. APHIS form 7001 was signed by the issuing veterinarian on 3/29/2023. There are twelve (12) days between the veterinarian health certificate and the waybill. Intermediate handlers must ensure that the Health Certificate issued by a licensed veterinarian is in accordance with paragraph (a) referencing article (2.78 (a)(1) and is issued on a specified date which shall not be more than 10 days from the initial issuance of the Health Certificate This inspection and exit interview were conducted in the cargo area with the cargo handler. Additional Inspectors: KATHARINE FRANK, VETERINARY MEDICAL OFFICER n
| rowid | 41 |
| desc | Health certification and identification. |
| web_siteName | GENERAL AVIATION TERMINAL, INC. |
| kind | |
| Incident hash_id | 7f1484f703800b0f |
| web_inspectionDate | 2023-10-12 |
| code | 2.78(c) |
| repeat | 1 |
| pdf_insp_type | FOCUSED INSPECTION |
| pdf_animals_total | 1.0 |
| web_certType | Class H - Intermediate Handler |
| pdf_customer_id | 31.0 |
| pdf_customer_name | General Aviation Terminal Inc |
| pdf_customer_addr | 8400 AIRPORT BLVD WEST RAMP RD MOBILE, AL 36608 |
| customer_state | AL |
| pdf_site_id | SMF |
| doccloud_url | https://www.documentcloud.org/documents/24358025-aphis-inspection-ins-0000913256 |
| lat | 30.6800208 |
| lng | -88.24911399999999 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "citation_inspection" ( [rowid] INTEGER PRIMARY KEY, [narrative] TEXT, [desc] TEXT, [web_siteName] TEXT, [kind] TEXT, [hash_id] TEXT REFERENCES [inspections]([hash_id]), [web_inspectionDate] TEXT, [code] TEXT, [repeat] INTEGER, [pdf_insp_type] TEXT, [pdf_animals_total] FLOAT, [web_certType] TEXT, [pdf_customer_id] FLOAT, [pdf_customer_name] TEXT, [pdf_customer_addr] TEXT, [customer_state] TEXT, [pdf_site_id] TEXT, [doccloud_url] TEXT , lat double precision, lng double precision);