{"current_page":1,"data":[{"id":10639277,"change_date":"2026-01-13 21:40:00","inspection_id":"86780625","dot_number":"3925117","report_state":"TX","report_number":"7C1G9DGXBQ","insp_date":"2026-01-09 00:00:00","insp_start_time":"1604","insp_end_time":"1630","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  RED BLUFF E\/B","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAGNOLIA","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"9815641","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2026-01-13 21:40:00","snet_input_date":"2026-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-13 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2026-01-16T10:36:06.000000Z","updated_at":"2026-01-24T10:30:53.000000Z","inspection_violations":[{"id":17899170,"change_date":"2026-01-13 21:40:00","inspection_id":"86780625","insp_violation_id":"271179592","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"211060947","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:19.000000Z","updated_at":"2026-01-24T10:31:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17844649,"change_date":"2026-01-13 21:40:00","inspection_id":"86780625","insp_unit_id":"211060946","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"20","insp_unit_license":"1N80949","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD410764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:42.000000Z","updated_at":"2026-01-24T10:02:30.000000Z"},{"id":17844650,"change_date":"2026-01-13 21:40:00","inspection_id":"86780625","insp_unit_id":"211060947","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"641082","insp_unit_license":"27529TMP","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06234D406983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:42.000000Z","updated_at":"2026-01-24T10:02:30.000000Z"}]},{"id":9708501,"change_date":"2025-09-17 21:40:00","inspection_id":"85803701","dot_number":"3925117","report_state":"TX","report_number":"78G99DAO40","insp_date":"2025-09-02 00:00:00","insp_start_time":"0930","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN TRAVIS CO. (564-606","county_code_state":"TX","county_code":"453","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":"2025-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9698637","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-09-23T10:01:50.000000Z","updated_at":"2025-09-23T10:01:50.000000Z","inspection_violations":[{"id":15933195,"change_date":"2025-09-17 21:40:00","inspection_id":"85803701","insp_violation_id":"268759994","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209005681","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:31.000000Z","updated_at":"2025-09-22T10:16:44.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16072758,"change_date":"2025-09-17 21:40:00","inspection_id":"85803701","insp_unit_id":"209005681","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M18990","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDV8ASAL3644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:51.000000Z","updated_at":"2025-09-21T09:45:36.000000Z"},{"id":16072759,"change_date":"2025-09-17 21:40:00","inspection_id":"85803701","insp_unit_id":"209005682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"15671TMP","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA06234D406883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:51.000000Z","updated_at":"2025-09-21T09:45:36.000000Z"}]},{"id":9686639,"change_date":"2025-09-15 21:41:00","inspection_id":"85780653","dot_number":"3925117","report_state":"TX","report_number":"78C79DMV28","insp_date":"2025-08-29 00:00:00","insp_start_time":"0710","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4000  HWY 71","county_code_state":"TX","county_code":"453","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":"2025-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"84400","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":"9695102","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[{"id":15885328,"change_date":"2025-09-15 21:41:00","inspection_id":"85780653","insp_violation_id":"268704882","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"208962407","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"3922RG"},{"id":15885329,"change_date":"2025-09-15 21:41:00","inspection_id":"85780653","insp_violation_id":"268704883","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"2","insp_unit_id":"208962407","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39383G"},{"id":15885330,"change_date":"2025-09-15 21:41:00","inspection_id":"85780653","insp_violation_id":"268704884","seq_no":"3","part_no":"393","part_no_section":"11TL","insp_viol_unit":"2","insp_unit_id":"208962407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:00.000000Z","updated_at":"2025-09-18T10:21:00.000000Z","normalized_code":"39311TL"}],"inspection_per_units":[{"id":16032860,"change_date":"2025-09-15 21:41:00","inspection_id":"85780653","insp_unit_id":"208962406","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD410764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"},{"id":16032861,"change_date":"2025-09-15 21:41:00","inspection_id":"85780653","insp_unit_id":"208962407","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"246520","insp_unit_license":"059B914","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354G257247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"}]},{"id":8333342,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","dot_number":"3925117","report_state":"TX","report_number":"V251822322","insp_date":"2025-04-02 00:00:00","insp_start_time":"1347","insp_end_time":"1359","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8610 FISHER RD BAYTO","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C HALE EXPRESS LLC","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9544954","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2025-04-09 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-09 21:41:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-04-12T10:24:41.000000Z","updated_at":"2025-04-14T10:26:20.000000Z","inspection_violations":[{"id":13119030,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_violation_id":"265527912","seq_no":"5","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"206229831","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:56:32.000000Z","updated_at":"2025-04-12T10:49:50.000000Z","normalized_code":"3922W"},{"id":13119031,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_violation_id":"265527913","seq_no":"1","part_no":"393","part_no_section":"11RT","insp_viol_unit":"2","insp_unit_id":"206229832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:56:32.000000Z","updated_at":"2025-04-12T10:49:50.000000Z","normalized_code":"39311RT"},{"id":13119032,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_violation_id":"265527914","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206229831","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-04-11T10:56:32.000000Z","updated_at":"2025-04-12T10:49:50.000000Z","normalized_code":"39375A3"},{"id":13119033,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_violation_id":"265527915","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206229831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:56:32.000000Z","updated_at":"2025-04-12T10:49:50.000000Z","normalized_code":"3922RG"},{"id":13119034,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_violation_id":"265527916","seq_no":"4","part_no":"392","part_no_section":"2C","insp_viol_unit":"1","insp_unit_id":"206229831","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:56:32.000000Z","updated_at":"2025-04-12T10:49:50.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":13517354,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_unit_id":"206229831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"19R047N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD410764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-12T10:14:34.000000Z","updated_at":"2025-04-13T10:07:06.000000Z"},{"id":13517355,"change_date":"2025-04-09 21:41:00","inspection_id":"84354539","insp_unit_id":"206229832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"246520","insp_unit_license":"059B914","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354G257247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-12T10:14:34.000000Z","updated_at":"2025-04-13T10:07:06.000000Z"}]},{"id":7896706,"change_date":"2025-02-18 21:40:00","inspection_id":"83895466","dot_number":"3925117","report_state":"TX","report_number":"V251763651","insp_date":"2025-02-13 00:00:00","insp_start_time":"1012","insp_end_time":"1044","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 78 EB MP 518","county_code_state":"TX","county_code":"187","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PITTFB","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-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115500","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":"9500922","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[{"id":12339081,"change_date":"2025-02-18 21:40:00","inspection_id":"83895466","insp_violation_id":"264569619","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205376132","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:13.000000Z","updated_at":"2025-03-17T22:06:13.000000Z","normalized_code":"39021A"},{"id":12339082,"change_date":"2025-02-18 21:40:00","inspection_id":"83895466","insp_violation_id":"264569620","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"205376133","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:13.000000Z","updated_at":"2025-03-17T22:06:13.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12746516,"change_date":"2025-02-18 21:40:00","inspection_id":"83895466","insp_unit_id":"205376132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"0020","insp_unit_license":"16M972M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD410764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"},{"id":12746517,"change_date":"2025-02-18 21:40:00","inspection_id":"83895466","insp_unit_id":"205376133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"246530","insp_unit_license":"059B914","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354G257247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"}]},{"id":7911677,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","dot_number":"3925117","report_state":"TX","report_number":"72S69DBC8C","insp_date":"2025-02-10 00:00:00","insp_start_time":"0638","insp_end_time":"0714","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0529 IN HARRIS CO. (658-672","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C (YARD)","shipping_paper_number":"LL03037447","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-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9501992","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T21:02:23.000000Z","updated_at":"2025-03-17T21:02:23.000000Z","inspection_violations":[{"id":12359676,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595908","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205404852","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"39021A"},{"id":12359677,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595909","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205404852","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"3922RG"},{"id":12359678,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595910","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"205404853","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"3922RG"},{"id":12359679,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595911","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205404852","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"3922RG"},{"id":12359680,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595912","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"205404852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"39311"},{"id":12359681,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595913","seq_no":"7","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205404852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"39311TL"},{"id":12359682,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595914","seq_no":"8","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"205404853","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"39355E"},{"id":12359683,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_violation_id":"264595915","seq_no":"9","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"205404853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:19.000000Z","updated_at":"2025-03-17T22:06:19.000000Z","normalized_code":"39311LR"}],"inspection_per_units":[{"id":12771098,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_unit_id":"205404852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"0020","insp_unit_license":"58U947M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X8HD410764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"},{"id":12771099,"change_date":"2025-02-19 21:40:00","inspection_id":"83911121","insp_unit_id":"205404853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"246520","insp_unit_license":"059B914","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25354G257247","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7845739,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","dot_number":"3925117","report_state":"TX","report_number":"V251753235","insp_date":"2025-02-05 00:00:00","insp_start_time":"1100","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US290 WB","county_code_state":"TX","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAPEI CORP","shipping_paper_number":"25T1","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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9495749","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[{"id":12261146,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_violation_id":"264468390","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"205277109","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39375A3"},{"id":12261147,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_violation_id":"264468391","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205277108","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"3939"},{"id":12261148,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_violation_id":"264468392","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205277108","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39395F"},{"id":12261149,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_violation_id":"264468393","seq_no":"4","part_no":"395","part_no_section":"24C2I","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39524C2I"},{"id":12261150,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_violation_id":"264468394","seq_no":"5","part_no":"395","part_no_section":"24C2II","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39524C2II"},{"id":12261151,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_violation_id":"264468395","seq_no":"6","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205277108","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":12662407,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_unit_id":"205277108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0018","insp_unit_license":"1M18990","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDV8ASAL3644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"},{"id":12662408,"change_date":"2025-02-11 21:40:00","inspection_id":"83842022","insp_unit_id":"205277109","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"17","insp_unit_license":"179B886","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2534BM035801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":5713610,"change_date":"2024-05-10 21:39:00","inspection_id":"81571656","dot_number":"3925117","report_state":"TX","report_number":"V241415003","insp_date":"2024-05-07 00:00:00","insp_start_time":"0641","insp_end_time":"0727","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29   46' 36.97N","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BYK USA","shipping_paper_number":"8285330","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-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9269037","transaction_code":"C","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2024-05-09 21:43:00","snet_input_date":"2024-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-09 21:43:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T20:15:55.000000Z","updated_at":"2025-03-17T20:15:55.000000Z","inspection_violations":[{"id":8841286,"change_date":"2024-05-10 21:39:00","inspection_id":"81571656","insp_violation_id":"259441421","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200837331","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:48:48.000000Z","updated_at":"2025-03-17T21:48:48.000000Z","normalized_code":"39345"},{"id":8841287,"change_date":"2024-05-10 21:39:00","inspection_id":"81571656","insp_violation_id":"259441422","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200837331","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:48:48.000000Z","updated_at":"2025-03-17T21:48:48.000000Z","normalized_code":"3963A1"},{"id":8841288,"change_date":"2024-05-10 21:39:00","inspection_id":"81571656","insp_violation_id":"259441423","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200837331","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:48.000000Z","updated_at":"2025-03-17T21:48:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9202954,"change_date":"2024-05-10 21:39:00","inspection_id":"81571656","insp_unit_id":"200837331","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"0067","insp_unit_license":"NONE","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"4V4NC9EH7GN932665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:38.000000Z","updated_at":"2025-03-17T23:18:38.000000Z"},{"id":9202955,"change_date":"2024-05-10 21:39:00","inspection_id":"81571656","insp_unit_id":"200837332","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"241454","insp_unit_license":"410475T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532K8RS117809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:38.000000Z","updated_at":"2025-03-17T23:18:38.000000Z"}]},{"id":5227062,"change_date":"2024-03-06 21:40:00","inspection_id":"81040847","dot_number":"3925117","report_state":"TX","report_number":"6SYG9DBVL3","insp_date":"2024-02-22 00:00:00","insp_start_time":"1615","insp_end_time":"1655","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF WINDS INTL","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9216062","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T20:06:12.000000Z","updated_at":"2025-03-17T20:06:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8417314,"change_date":"2024-03-06 21:40:00","inspection_id":"81040847","insp_unit_id":"199787549","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M20501","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR49LAG2546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"},{"id":8417315,"change_date":"2024-03-06 21:40:00","inspection_id":"81040847","insp_unit_id":"199787550","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"4VT3201","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K1RS255255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"}]},{"id":3957297,"change_date":"2023-09-12 21:40:00","inspection_id":"79645429","dot_number":"3925117","report_state":"TX","report_number":"6O9G9DCQLD","insp_date":"2023-09-06 00:00:00","insp_start_time":"1625","insp_end_time":"1640","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200  MCCARTY","county_code_state":"TX","county_code":"201","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":"2023-09-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9073361","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2023-09-12 21:40:00","snet_input_date":"2023-09-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-12 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T19:40:52.000000Z","updated_at":"2025-03-17T19:40:52.000000Z","inspection_violations":[{"id":6119224,"change_date":"2023-09-12 21:40:00","inspection_id":"79645429","insp_violation_id":"255226365","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197019441","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:33.000000Z","updated_at":"2025-03-17T21:35:33.000000Z","normalized_code":"39311"},{"id":6119225,"change_date":"2023-09-12 21:40:00","inspection_id":"79645429","insp_violation_id":"255226366","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197019441","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:33.000000Z","updated_at":"2025-03-17T21:35:33.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6363256,"change_date":"2023-09-12 21:40:00","inspection_id":"79645429","insp_unit_id":"197019441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0012","insp_unit_license":"1M20501","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR49LAG2546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:26.000000Z","updated_at":"2025-03-17T22:53:26.000000Z"}]},{"id":3460180,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","dot_number":"3925117","report_state":"TX","report_number":"6MJD9DAE1Q","insp_date":"2023-07-06 00:00:00","insp_start_time":"1312","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2461  RUTLAND","county_code_state":"TX","county_code":"453","insp_level_id":"1","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":"2023-07-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"22","oos_total":"5","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"21","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9023515","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2023-07-07 21:42:00","snet_input_date":"2023-07-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-07 21:42:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T19:31:38.000000Z","updated_at":"2025-03-17T19:31:38.000000Z","inspection_violations":[{"id":5335896,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940630","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"195890963","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"393207A"},{"id":5335897,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940631","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195890963","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39311"},{"id":5335898,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940632","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195890963","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39378"},{"id":5335899,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940633","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3939A"},{"id":5335900,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940634","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3939A"},{"id":5335901,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940635","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3939A"},{"id":5335902,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940636","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3939A"},{"id":5335903,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940637","seq_no":"8","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"393203E"},{"id":5335904,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940638","seq_no":"9","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39375A"},{"id":5335905,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940639","seq_no":"10","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39375A"},{"id":5335906,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940640","seq_no":"11","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39375A3"},{"id":5335907,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940641","seq_no":"12","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39375A3"},{"id":5335908,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940642","seq_no":"13","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39375A3"},{"id":5335909,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940643","seq_no":"14","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"195890963","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"393201D"},{"id":5335910,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940644","seq_no":"15","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3958F1"},{"id":5335911,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940645","seq_no":"16","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"3963A1"},{"id":5335912,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940646","seq_no":"17","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39348A"},{"id":5335913,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940647","seq_no":"18","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39348A"},{"id":5335914,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940648","seq_no":"19","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39348A"},{"id":5335915,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940649","seq_no":"20","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195890964","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39348A"},{"id":5335916,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940650","seq_no":"21","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195890963","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39347E"},{"id":5335917,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_violation_id":"253940651","seq_no":"22","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195890963","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:45.000000Z","updated_at":"2025-03-17T21:31:45.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5564063,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_unit_id":"195890963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0022","insp_unit_license":"1M35819","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR7CSAY8642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:55.000000Z","updated_at":"2025-03-17T22:46:55.000000Z"},{"id":5564064,"change_date":"2023-07-07 21:42:00","inspection_id":"79089625","insp_unit_id":"195890964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"257426T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532K0PS493756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:55.000000Z","updated_at":"2025-03-17T22:46:55.000000Z"}]},{"id":2751899,"change_date":"2023-06-02 21:42:00","inspection_id":"78290025","dot_number":"3925117","report_state":"TX","report_number":"V231008943","insp_date":"2023-03-29 00:00:00","insp_start_time":"0740","insp_end_time":"0837","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A101","location_desc":"IH 10 EASTBOUND BROOKSHIRE","county_code_state":"TX","county_code":"473","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BYK USA INC","shipping_paper_number":"82643882","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-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8948424","transaction_code":"C","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-03-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4429496,"change_date":"2023-06-02 21:42:00","inspection_id":"78290025","insp_unit_id":"195293498","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0012","insp_unit_license":"1M20501","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR49LAG2546","insp_unit_decal":"Y","insp_unit_decal_number":"32240298","created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"},{"id":4429497,"change_date":"2023-06-02 21:42:00","inspection_id":"78290025","insp_unit_id":"195293499","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"555314","insp_unit_license":"4UX8275","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K0PS083152","insp_unit_decal":"Y","insp_unit_decal_number":"32240299","created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"}]},{"id":2484749,"change_date":"2023-03-01 21:42:00","inspection_id":"77985569","dot_number":"3925117","report_state":"TX","report_number":"6IUK9DBEQX","insp_date":"2023-02-23 00:00:00","insp_start_time":"2010","insp_end_time":"2110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C &C HALE EXPRESS LLC","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":"2023-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8917531","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":null,"census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-02-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"CHRISTOPHER LAROY HALE","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T19:12:30.000000Z","updated_at":"2025-03-17T19:12:30.000000Z","inspection_violations":[{"id":3823887,"change_date":"2023-03-01 21:42:00","inspection_id":"77985569","insp_violation_id":"251427319","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193659346","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:59.000000Z","updated_at":"2025-03-17T21:24:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3998685,"change_date":"2023-03-01 21:42:00","inspection_id":"77985569","insp_unit_id":"193659346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"66R005M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR49LAG2546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"}]},{"id":2372768,"change_date":"2023-02-14 21:42:00","inspection_id":"77858172","dot_number":"3925117","report_state":"TX","report_number":"6IGC0AKK7E","insp_date":"2023-02-09 00:00:00","insp_start_time":"1230","insp_end_time":"1331","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH 10 EASTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"STANDARD AIR CONDITIONING","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-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8904311","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":null,"census_search_date":"2023-02-14 21:42:00","snet_input_date":"2023-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-14 21:42:00","insp_carrier_name":"CHRISTOPHER LAROY HALE","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T19:10:21.000000Z","updated_at":"2025-03-17T19:10:21.000000Z","inspection_violations":[{"id":3655377,"change_date":"2023-02-14 21:42:00","inspection_id":"77858172","insp_violation_id":"251142011","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193402984","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3922"},{"id":3655378,"change_date":"2023-02-14 21:42:00","inspection_id":"77858172","insp_violation_id":"251142012","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193402985","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3922"},{"id":3655379,"change_date":"2023-02-14 21:42:00","inspection_id":"77858172","insp_violation_id":"251142013","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"193402984","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":3818460,"change_date":"2023-02-14 21:42:00","inspection_id":"77858172","insp_unit_id":"193402984","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0012","insp_unit_license":"828966G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR49LAG2546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:20.000000Z","updated_at":"2025-03-17T22:33:20.000000Z"},{"id":3818461,"change_date":"2023-02-14 21:42:00","inspection_id":"77858172","insp_unit_id":"193402985","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"PTLZ231113","insp_unit_license":"257433T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532K8PS493763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:20.000000Z","updated_at":"2025-03-17T22:33:20.000000Z"}]},{"id":2267635,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","dot_number":"3925117","report_state":"TX","report_number":"6HV80VOUIQ","insp_date":"2023-01-19 00:00:00","insp_start_time":"0745","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A101","location_desc":"IH 10 EASTBOUND BROOKSHIRE","county_code_state":"TX","county_code":"473","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BYK","shipping_paper_number":"82607458","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-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8892342","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":null,"census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"CHRISTOPHER LAROY HALE","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T19:08:29.000000Z","updated_at":"2025-03-17T19:08:29.000000Z","inspection_violations":[{"id":3498703,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","insp_violation_id":"250875840","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193159657","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3963A1"},{"id":3498704,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","insp_violation_id":"250875841","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193159657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3939A"},{"id":3498705,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","insp_violation_id":"250875842","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193159657","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39347E"},{"id":3498706,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","insp_violation_id":"250875843","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193159657","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3650385,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","insp_unit_id":"193159657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0022","insp_unit_license":"237777G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR7CSAY8642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:10.000000Z","updated_at":"2025-03-17T22:32:10.000000Z"},{"id":3650386,"change_date":"2023-01-31 21:43:00","inspection_id":"77738078","insp_unit_id":"193159658","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"561209","insp_unit_license":"298371T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1JJV532D6CL586514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:10.000000Z","updated_at":"2025-03-17T22:32:10.000000Z"}]},{"id":1534654,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","dot_number":"3925117","report_state":"TX","report_number":"6F5A0AIP08","insp_date":"2022-10-13 00:00:00","insp_start_time":"1046","insp_end_time":"1138","registration_date":"2022-11-17 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN LEE CO. (634-648)","county_code_state":"TX","county_code":"287","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8802300","transaction_code":"C","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03925117","upload_search_indicator":"M","census_search_date":"2022-10-18 21:40:00","snet_input_date":"2022-10-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-17 21:41:00","insp_carrier_name":"C&C HALE EXPRESS LLC","insp_carrier_street":"2522 BOXWOOD PARK LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77038-1597","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1039243","created_at":"2025-03-17T18:54:52.000000Z","updated_at":"2025-03-17T18:54:52.000000Z","inspection_violations":[{"id":2417536,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_violation_id":"249667215","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192016792","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"3922"},{"id":2417537,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_violation_id":"249667216","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192016792","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"39395F"},{"id":2417538,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_violation_id":"249667217","seq_no":"3","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"3928"},{"id":2417539,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_violation_id":"249667218","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"192016792","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"39345D"},{"id":2417540,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_violation_id":"249667219","seq_no":"5","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"192016793","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":2470014,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_unit_id":"192016792","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0018","insp_unit_license":"1M18990","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDV8ASAL3644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"},{"id":2470015,"change_date":"2022-11-17 21:40:00","inspection_id":"76898550","insp_unit_id":"192016793","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"08","insp_unit_license":"4TN8073","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y5SL348087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3925117\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3925117\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3925117\/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\/3925117\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}