SELECT INSPECTION_ID,DOT_NUMBER,REPORT_STATE,REPORT_NUMBER,INSP_DATE,INSP_START_TIME,INSP_END_TIME,REGISTRATION_DATE,REGION,CI_STATUS_CODE,LOCATION,LOCATION_DESC,COUNTY_CODE_STATE,COUNTY_CODE,INSP_LEVEL_ID,SERVICE_CENTER,CENSUS_SOURCE_ID,INSP_FACILITY,SHIPPER_NAME,SHIPPING_PAPER_NUMBER,CARGO_TANK,SNET_VERSION_NUMBER,SNET_SEARCH_DATE,ALCOHOL_CONTROL_SUB,DRUG_INTRDCTN_SEARCH,DRUG_INTRDCTN_ARRESTS,SIZE_WEIGHT_ENF,TRAFFIC_ENF,LOCAL_ENF_JURISDICTION,PEN_CEN_MATCH,FINAL_STATUS_DATE,POST_ACC_IND,GROSS_COMB_VEH_WT, VIOL_TOTAL,OOS_TOTAL,DRIVER_VIOL_TOTAL,DRIVER_OOS_TOTAL,VEHICLE_VIOL_TOTAL,VEHICLE_OOS_TOTAL,SNET_SEQUENCE_ID,TRANSACTION_CODE,TRANSACTION_DATE,UPLOAD_DATE,UPLOAD_FIRST_BYTE,UPLOAD_DOT_NUMBER,UPLOAD_SEARCH_INDICATOR,CENSUS_SEARCH_DATE,MCMIS_ADD_DATE,CHANGE_DATE,SNET_INPUT_DATE,SOURCE_OFFICE FROM carrier_inspections WHERE DOT_NUMBER=1794895 ORDER BY INSPECTION_ID DESC LIMIT 0, 10
Inspection Date 20260309 08:41 Report# NDOG007086
Inspection Id: 87254523
Report#: NDOG007086
Inspection End Date: 20260309 09:35
Inspection Status: Complete
Inspection Level: Full
Source: SafetyNet Uploaded and not changed
City: Grapevine If
Inspection State: CA
Service Center: West
Alcohol/Drug Check?: No
Drug Interdiction Arrest: 0
Size/Weight Enforcement? Yes
Total Violations: 5
Out-of-Service Violations: 3
Driver Violations: 0
Driver Out-of-Service Violations: 0
Vehicle Violations: 5
OOS Vehicle Violations: 3
Inspection Office: 4CAS001
Post Accident Inspection? No
Last Status: Added on 20260310 0000
Vehicle Information for Inspection Report# NDOG007086