{"current_page":1,"data":[{"id":10781728,"change_date":"2026-01-15 21:41:00","inspection_id":"86807467","dot_number":"2083294","report_state":"TX","report_number":"7C5D9DAU11","insp_date":"2026-01-13 00:00:00","insp_start_time":"1324","insp_end_time":"1359","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0377 IN DENTON CO. (228-268","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9819048","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2026-01-18T10:45:09.000000Z","updated_at":"2026-01-26T10:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18100938,"change_date":"2026-01-15 21:41:00","inspection_id":"86807467","insp_unit_id":"211117128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:42.000000Z","updated_at":"2026-01-26T10:01:20.000000Z"}]},{"id":9605576,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","dot_number":"2083294","report_state":"TX","report_number":"V251990818","insp_date":"2025-09-03 00:00:00","insp_start_time":"0638","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"214M FM1417","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOME YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9688514","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-09-10T10:45:49.000000Z","updated_at":"2025-09-10T10:45:49.000000Z","inspection_violations":[{"id":15703876,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","insp_violation_id":"268492615","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"208773699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39311"},{"id":15703877,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","insp_violation_id":"268492616","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208773699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"3939"},{"id":15703878,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","insp_violation_id":"268492617","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208773699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"3939"},{"id":15703879,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","insp_violation_id":"268492618","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208773700","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15861292,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","insp_unit_id":"208773699","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:30.000000Z","updated_at":"2025-09-10T09:46:30.000000Z"},{"id":15861293,"change_date":"2025-09-05 21:39:00","inspection_id":"85695657","insp_unit_id":"208773700","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"7T","insp_unit_license":"496723M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121MT209539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:30.000000Z","updated_at":"2025-09-10T09:46:30.000000Z"}]},{"id":9289829,"change_date":"2025-07-30 21:41:00","inspection_id":"85363914","dot_number":"2083294","report_state":"TX","report_number":"V251949971","insp_date":"2025-07-29 00:00:00","insp_start_time":"0726","insp_end_time":"0742","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A103","location_desc":"US75 SB DENISON SCALE","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RED RIVER SAND","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9651767","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2025-07-30 21:41:00","snet_input_date":"2025-07-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-30 21:41:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-08-04T10:01:17.000000Z","updated_at":"2025-08-04T10:01:17.000000Z","inspection_violations":[{"id":15063420,"change_date":"2025-07-30 21:41:00","inspection_id":"85363914","insp_violation_id":"267752262","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"208162755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-02T10:43:48.000000Z","updated_at":"2025-08-03T10:44:32.000000Z","normalized_code":"39311"},{"id":15063421,"change_date":"2025-07-30 21:41:00","inspection_id":"85363914","insp_violation_id":"267752263","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"208162756","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-02T10:43:48.000000Z","updated_at":"2025-08-03T10:44:32.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":15295224,"change_date":"2025-07-30 21:41:00","inspection_id":"85363914","insp_unit_id":"208162755","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:29.000000Z","updated_at":"2025-08-03T09:46:07.000000Z"},{"id":15295225,"change_date":"2025-07-30 21:41:00","inspection_id":"85363914","insp_unit_id":"208162756","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"496723M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121MT209539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:29.000000Z","updated_at":"2025-08-03T09:46:07.000000Z"}]},{"id":10577870,"change_date":"2026-01-06 21:39:00","inspection_id":"86716138","dot_number":"2083294","report_state":"TX","report_number":"V251947629","insp_date":"2025-07-29 00:00:00","insp_start_time":"0726","insp_end_time":"0742","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A103","location_desc":"US75 SB DENISON SCALE","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RED RIVER SAND","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9807956","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2026-01-06 21:39:00","snet_input_date":"2025-07-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-06 21:39:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2026-01-09T10:34:30.000000Z","updated_at":"2026-01-17T10:30:41.000000Z","inspection_violations":[{"id":17776019,"change_date":"2026-01-06 21:39:00","inspection_id":"86716138","insp_violation_id":"271036375","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"210931481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:42.000000Z","updated_at":"2026-01-17T10:31:23.000000Z","normalized_code":"39311"},{"id":17776020,"change_date":"2026-01-06 21:39:00","inspection_id":"86716138","insp_violation_id":"271036376","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"210931480","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:42.000000Z","updated_at":"2026-01-17T10:31:23.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":17728155,"change_date":"2026-01-06 21:39:00","inspection_id":"86716138","insp_unit_id":"210931480","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"496723M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121MT209539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:55.000000Z","updated_at":"2026-01-17T10:00:57.000000Z"},{"id":17728156,"change_date":"2026-01-06 21:39:00","inspection_id":"86716138","insp_unit_id":"210931481","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:55.000000Z","updated_at":"2026-01-17T10:00:57.000000Z"}]},{"id":9190301,"change_date":"2025-07-18 21:40:00","inspection_id":"85258864","dot_number":"2083294","report_state":"TX","report_number":"V251937754","insp_date":"2025-07-17 00:00:00","insp_start_time":"0755","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A103","location_desc":"US75 SB DENISON SCALE","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RED RIVER SAND","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9642050","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2025-07-18 21:40:00","snet_input_date":"2025-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-18 21:40:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-07-21T10:43:37.000000Z","updated_at":"2025-07-22T10:45:20.000000Z","inspection_violations":[{"id":14846426,"change_date":"2025-07-18 21:40:00","inspection_id":"85258864","insp_violation_id":"267505030","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"207955804","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:46:22.000000Z","updated_at":"2025-07-22T10:46:45.000000Z","normalized_code":"39355E"},{"id":14846427,"change_date":"2025-07-18 21:40:00","inspection_id":"85258864","insp_violation_id":"267505031","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207955804","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:46:22.000000Z","updated_at":"2025-07-22T10:46:45.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15103858,"change_date":"2025-07-18 21:40:00","inspection_id":"85258864","insp_unit_id":"207955803","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:37.000000Z","updated_at":"2025-07-22T09:46:01.000000Z"},{"id":15103859,"change_date":"2025-07-18 21:40:00","inspection_id":"85258864","insp_unit_id":"207955804","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"496723M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121MT209539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:37.000000Z","updated_at":"2025-07-22T09:46:01.000000Z"}]},{"id":6276740,"change_date":"2024-07-22 21:42:00","inspection_id":"82180064","dot_number":"2083294","report_state":"TX","report_number":"V241486383","insp_date":"2024-07-17 00:00:00","insp_start_time":"1003","insp_end_time":"1027","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"798 US380 EB","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9332523","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2024-07-22 21:42:00","snet_input_date":"2024-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-22 21:42:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T20:27:03.000000Z","updated_at":"2025-03-17T20:27:03.000000Z","inspection_violations":[{"id":9750785,"change_date":"2024-07-22 21:42:00","inspection_id":"82180064","insp_violation_id":"260774517","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202004026","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10113385,"change_date":"2024-07-22 21:42:00","inspection_id":"82180064","insp_unit_id":"202004026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:47.000000Z","updated_at":"2025-03-17T23:27:47.000000Z"}]},{"id":5308986,"change_date":"2024-03-18 21:39:00","inspection_id":"81130507","dot_number":"2083294","report_state":"TX","report_number":"V241344095","insp_date":"2024-03-15 00:00:00","insp_start_time":"1030","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM902 NB SVC RD AT F","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"99300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9224984","transaction_code":"A","transaction_date":"2024-03-18 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2024-03-18 21:39:00","snet_input_date":"2024-03-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-18 21:39:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T20:07:53.000000Z","updated_at":"2025-03-17T20:07:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8550023,"change_date":"2024-03-18 21:39:00","inspection_id":"81130507","insp_unit_id":"199963717","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"},{"id":8550024,"change_date":"2024-03-18 21:39:00","inspection_id":"81130507","insp_unit_id":"199963718","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTS","insp_unit_company":"0","insp_unit_license":"802770K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JKDLA209RA200123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:31.000000Z","updated_at":"2025-03-17T23:12:31.000000Z"}]},{"id":4816903,"change_date":"2024-01-11 21:46:00","inspection_id":"80593054","dot_number":"2083294","report_state":"TX","report_number":"6RQD9DFZ5T","insp_date":"2024-01-09 00:00:00","insp_start_time":"1352","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0288 IN DENTON CO. (558-568","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-11 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9170479","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2024-01-11 21:46:00","snet_input_date":"2024-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:58:04.000000Z","updated_at":"2025-03-17T19:58:04.000000Z","inspection_violations":[{"id":7429136,"change_date":"2024-01-11 21:46:00","inspection_id":"80593054","insp_violation_id":"257306291","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198928033","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:52.000000Z","updated_at":"2025-03-17T21:41:52.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7749892,"change_date":"2024-01-11 21:46:00","inspection_id":"80593054","insp_unit_id":"198928033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:14.000000Z","updated_at":"2025-03-17T23:05:14.000000Z"}]},{"id":4734843,"change_date":"2024-12-06 21:44:00","inspection_id":"80503295","dot_number":"2083294","report_state":"TX","report_number":"V231268904","insp_date":"2023-12-28 00:00:00","insp_start_time":"1037","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1059 TX5 SB","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"P&K","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9162414","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:56:34.000000Z","updated_at":"2025-03-17T19:56:34.000000Z","inspection_violations":[{"id":7311189,"change_date":"2024-12-06 21:44:00","inspection_id":"80503295","insp_violation_id":"263302512","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"204241277","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"393209E"},{"id":7311190,"change_date":"2024-12-06 21:44:00","inspection_id":"80503295","insp_violation_id":"263302513","seq_no":"2","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"204241277","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"39375A1"},{"id":7311191,"change_date":"2024-12-06 21:44:00","inspection_id":"80503295","insp_violation_id":"263302514","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204241277","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":7616102,"change_date":"2024-12-06 21:44:00","inspection_id":"80503295","insp_unit_id":"204241277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"},{"id":7616103,"change_date":"2024-12-06 21:44:00","inspection_id":"80503295","insp_unit_id":"204241278","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"496723M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121MT209539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"}]},{"id":3581537,"change_date":"2023-07-24 21:42:00","inspection_id":"79225754","dot_number":"2083294","report_state":"TX","report_number":"6MR70KEM6I","insp_date":"2023-07-14 00:00:00","insp_start_time":"0720","insp_end_time":"0806","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A103","location_desc":"US 75 SOUTHBOUND DENISON","county_code_state":"TX","county_code":"181","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PIT","shipping_paper_number":"001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9034456","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:33:50.000000Z","updated_at":"2025-03-17T19:33:50.000000Z","inspection_violations":[{"id":5522116,"change_date":"2023-07-24 21:42:00","inspection_id":"79225754","insp_violation_id":"254245671","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196165895","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5759163,"change_date":"2023-07-24 21:42:00","inspection_id":"79225754","insp_unit_id":"196165895","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:27.000000Z","updated_at":"2025-03-17T22:48:27.000000Z"},{"id":5759164,"change_date":"2023-07-24 21:42:00","inspection_id":"79225754","insp_unit_id":"196165896","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"000","insp_unit_license":"488236K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121KT209523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:27.000000Z","updated_at":"2025-03-17T22:48:27.000000Z"}]},{"id":3482905,"change_date":"2023-07-11 21:42:00","inspection_id":"79115078","dot_number":"2083294","report_state":"TX","report_number":"V231050875","insp_date":"2023-06-29 00:00:00","insp_start_time":"0845","insp_end_time":"0907","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US75 SVC SB","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SITE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9026326","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-06-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:32:02.000000Z","updated_at":"2025-03-17T19:32:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5600754,"change_date":"2023-07-11 21:42:00","inspection_id":"79115078","insp_unit_id":"195943606","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"}]},{"id":3170531,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","dot_number":"2083294","report_state":"TX","report_number":"6LE90XSBWO","insp_date":"2023-05-26 00:00:00","insp_start_time":"0902","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0091 IN GRAYSON CO. (194-20","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"8","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8992149","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:25:44.000000Z","updated_at":"2025-03-17T19:25:44.000000Z","inspection_violations":[{"id":4885728,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159096","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3922"},{"id":4885722,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159090","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"195210097","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39021A"},{"id":4885723,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159091","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195210097","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3939A"},{"id":4885724,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159092","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"195210097","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39355D1"},{"id":4885725,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159093","seq_no":"5","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"195210097","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39375A"},{"id":4885726,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159094","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195210097","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3939A"},{"id":4885727,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159095","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195210097","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3922"},{"id":4885729,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_violation_id":"253159097","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5100053,"change_date":"2023-05-30 21:43:00","inspection_id":"78763041","insp_unit_id":"195210097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:12.000000Z","updated_at":"2025-03-17T22:43:12.000000Z"}]},{"id":2979712,"change_date":"2023-05-05 21:43:00","inspection_id":"78547822","dot_number":"2083294","report_state":"TX","report_number":"6KQC0XTV7T","insp_date":"2023-05-02 00:00:00","insp_start_time":"1203","insp_end_time":"1222","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8970357","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2023-05-05 21:43:00","snet_input_date":"2023-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-05 21:43:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:21:55.000000Z","updated_at":"2025-03-17T19:21:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4794266,"change_date":"2023-05-05 21:43:00","inspection_id":"78547822","insp_unit_id":"194783524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:46.000000Z","updated_at":"2025-03-17T22:40:46.000000Z"}]},{"id":2743503,"change_date":"2023-04-05 21:41:00","inspection_id":"78280445","dot_number":"2083294","report_state":"TX","report_number":"6JVC0XTV4E","insp_date":"2023-04-01 00:00:00","insp_start_time":"1200","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0121 IN GRAYSON CO. (578-61","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8947333","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T19:17:19.000000Z","updated_at":"2025-03-17T19:17:19.000000Z","inspection_violations":[{"id":4211905,"change_date":"2023-04-05 21:41:00","inspection_id":"78280445","insp_violation_id":"252070301","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"194249138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":4416361,"change_date":"2023-04-05 21:41:00","inspection_id":"78280445","insp_unit_id":"194249138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"CRY8070","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDL50X76J157500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"}]},{"id":1566563,"change_date":"2022-10-20 21:41:00","inspection_id":"76935425","dot_number":"2083294","report_state":"TX","report_number":"6FAA0XSBKX","insp_date":"2022-10-18 00:00:00","insp_start_time":"1038","insp_end_time":"1054","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN GRAYSON CO. (194-22","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RED RIVER SAND","shipping_paper_number":"121883","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8806387","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2022-10-20 21:41:00","snet_input_date":"2022-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-20 21:41:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T18:55:34.000000Z","updated_at":"2025-03-17T18:55:34.000000Z","inspection_violations":[{"id":2463890,"change_date":"2022-10-20 21:41:00","inspection_id":"76935425","insp_violation_id":"249164802","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191563155","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2521500,"change_date":"2022-10-20 21:41:00","inspection_id":"76935425","insp_unit_id":"191563155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"}]},{"id":1370882,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","dot_number":"2083294","report_state":"TX","report_number":"6EK90XTVRL","insp_date":"2022-09-22 00:00:00","insp_start_time":"0932","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A103","location_desc":"US 75 SOUTHBOUND DENISON","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PIT","shipping_paper_number":"2","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8782248","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2022-09-26 21:40:00","snet_input_date":"2022-09-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-26 21:40:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T18:51:59.000000Z","updated_at":"2025-03-17T18:51:59.000000Z","inspection_violations":[{"id":2168944,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_violation_id":"248656606","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191107205","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3939A"},{"id":2168945,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_violation_id":"248656607","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191107204","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3939A"},{"id":2168946,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_violation_id":"248656608","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191107205","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"39345"},{"id":2168947,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_violation_id":"248656609","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191107204","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3939A"},{"id":2168948,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_violation_id":"248656610","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"191107204","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"39311"},{"id":2168949,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_violation_id":"248656611","seq_no":"6","part_no":"393","part_no_section":"13(c)(1)","insp_viol_unit":"2","insp_unit_id":"191107204","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"39313C1"}],"inspection_per_units":[{"id":2207770,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_unit_id":"191107204","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"488236K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9PD3121KT209523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:07.000000Z","updated_at":"2025-03-17T22:22:07.000000Z"},{"id":2207771,"change_date":"2022-09-26 21:40:00","inspection_id":"76708886","insp_unit_id":"191107205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"2","insp_unit_license":"PNX1154","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKXAFCG4FPGR4748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:07.000000Z","updated_at":"2025-03-17T22:22:07.000000Z"}]},{"id":663972,"change_date":"2022-06-21 21:42:00","inspection_id":"75884135","dot_number":"2083294","report_state":"TX","report_number":"6BRA0VJHW1","insp_date":"2022-06-13 00:00:00","insp_start_time":"0955","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0428 IN DENTON CO. (566-590","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RAD MCCLELLAN SAND & GRAVEL L","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8689987","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02083294","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"BRAD MCCLELLAN SAND & GRAVEL LLC","insp_carrier_street":"116 BEAR ROAD","insp_carrier_city":"VAN ALYSTNE","insp_carrier_state":"TX","insp_carrier_zip_code":"75495","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0165828","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1045425,"change_date":"2022-06-21 21:42:00","inspection_id":"75884135","insp_violation_id":"246632096","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189388492","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1067349,"change_date":"2022-06-21 21:42:00","inspection_id":"75884135","insp_unit_id":"189388492","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7","insp_unit_license":"PDZ8323","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X21N555251","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2083294\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2083294\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2083294\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2083294\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}