{"current_page":1,"data":[{"id":10166520,"change_date":"2025-11-10 21:40:00","inspection_id":"86285575","dot_number":"974512","report_state":"TX","report_number":"V252094934","insp_date":"2025-11-04 00:00:00","insp_start_time":"0630","insp_end_time":"0721","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSOLIDATED DISTRIBUTORS","shipping_paper_number":"52462","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-11-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9753542","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-11-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-10 21:40:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-11-13T10:30:46.000000Z","updated_at":"2025-11-14T10:31:02.000000Z","inspection_violations":[{"id":16878763,"change_date":"2025-11-10 21:40:00","inspection_id":"86285575","insp_violation_id":"269862418","seq_no":"1","part_no":"393","part_no_section":"45A-BHTBS","insp_viol_unit":"1","insp_unit_id":"209950557","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-13T10:31:13.000000Z","updated_at":"2025-11-14T10:32:02.000000Z","normalized_code":"39345ABHTBS"},{"id":16878764,"change_date":"2025-11-10 21:40:00","inspection_id":"86285575","insp_violation_id":"269862419","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"209950557","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-13T10:31:13.000000Z","updated_at":"2025-11-14T10:32:02.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":16928446,"change_date":"2025-11-10 21:40:00","inspection_id":"86285575","insp_unit_id":"209950557","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"R141274","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7FD259234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:44.000000Z","updated_at":"2025-11-14T10:01:19.000000Z"},{"id":16928447,"change_date":"2025-11-10 21:40:00","inspection_id":"86285575","insp_unit_id":"209950558","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"VG2200","insp_unit_license":"6127KD","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5V8VA532X6M602710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:44.000000Z","updated_at":"2025-11-14T10:01:19.000000Z"}]},{"id":9838764,"change_date":"2025-10-02 21:42:00","inspection_id":"85940118","dot_number":"974512","report_state":"TX","report_number":"794C9DBZ2K","insp_date":"2025-09-26 00:00:00","insp_start_time":"1214","insp_end_time":"1243","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  BARKER CYPRESS","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":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9712841","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-10-05T10:01:55.000000Z","updated_at":"2025-10-05T10:01:55.000000Z","inspection_violations":[{"id":16201114,"change_date":"2025-10-02 21:42:00","inspection_id":"85940118","insp_violation_id":"269060834","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209266423","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:41.000000Z","updated_at":"2025-10-05T10:17:41.000000Z","normalized_code":"39617C"},{"id":16201115,"change_date":"2025-10-02 21:42:00","inspection_id":"85940118","insp_violation_id":"269060835","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209266423","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:41.000000Z","updated_at":"2025-10-05T10:17:41.000000Z","normalized_code":"39378"},{"id":16201116,"change_date":"2025-10-02 21:42:00","inspection_id":"85940118","insp_violation_id":"269060836","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209266423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:41.000000Z","updated_at":"2025-10-05T10:17:41.000000Z","normalized_code":"3939"},{"id":16201117,"change_date":"2025-10-02 21:42:00","inspection_id":"85940118","insp_violation_id":"269060837","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209266423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:41.000000Z","updated_at":"2025-10-05T10:17:41.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16315324,"change_date":"2025-10-02 21:42:00","inspection_id":"85940118","insp_unit_id":"209266423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"R267417","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X2FD259271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:59.000000Z","updated_at":"2025-10-05T09:46:59.000000Z"}]},{"id":7996793,"change_date":"2025-02-28 21:42:00","inspection_id":"84000330","dot_number":"974512","report_state":"TX","report_number":"V251795671","insp_date":"2025-02-24 00:00:00","insp_start_time":"1038","insp_end_time":"1132","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"718  US77 NB","county_code_state":"TX","county_code":"149","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CONSOLIDATED DISTRIBUTORS 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":"2025-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9510112","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-28 21:42:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-03-17T21:04:07.000000Z","updated_at":"2025-03-17T21:04:07.000000Z","inspection_violations":[{"id":12494378,"change_date":"2025-02-28 21:42:00","inspection_id":"84000330","insp_violation_id":"264771774","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205570250","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:02.000000Z","updated_at":"2025-03-17T22:07:02.000000Z","normalized_code":"39311TL"},{"id":12494379,"change_date":"2025-02-28 21:42:00","inspection_id":"84000330","insp_violation_id":"264771775","seq_no":"2","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"205570250","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:02.000000Z","updated_at":"2025-03-17T22:07:02.000000Z","normalized_code":"393203C"},{"id":12494380,"change_date":"2025-02-28 21:42:00","inspection_id":"84000330","insp_violation_id":"264771776","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"205570250","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:02.000000Z","updated_at":"2025-03-17T22:07:02.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":12910002,"change_date":"2025-02-28 21:42:00","inspection_id":"84000330","insp_unit_id":"205570250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"R141274","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7FD259234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":6984372,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","dot_number":"974512","report_state":"AZ","report_number":"5564000368","insp_date":"2024-10-11 00:00:00","insp_start_time":"1028","insp_end_time":"1110","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"ELOY AZ","county_code_state":"AZ","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NIAGRARA","shipping_paper_number":"37019874","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":"U","pen_cen_match":"I","final_status_date":"2024-10-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"7","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":"957058","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":null,"census_search_date":"2024-10-18 21:41:00","snet_input_date":"2024-10-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-18 21:41:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:46.000000Z","updated_at":"2025-03-17T20:41:46.000000Z","inspection_violations":[{"id":10895478,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414810","seq_no":"1","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"203463214","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"39355C2"},{"id":10895479,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414811","seq_no":"2","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"203463214","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"39311BCSLRR"},{"id":10895480,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414812","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"203463213","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"39378AWS"},{"id":10895481,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414813","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"203463213","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"3939ALCL"},{"id":10895482,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414814","seq_no":"5","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"203463214","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"3922SLLMF"},{"id":10895483,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414815","seq_no":"6","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":10895484,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_violation_id":"262414816","seq_no":"7","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"203463214","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"39311BCSURR"}],"inspection_per_units":[{"id":11265141,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_unit_id":"203463213","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"02","insp_unit_license":"R630216","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9XXFD256331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:37.000000Z","updated_at":"2025-03-17T23:39:37.000000Z"},{"id":11265142,"change_date":"2024-10-18 21:41:00","inspection_id":"82934188","insp_unit_id":"203463214","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"VG2200","insp_unit_license":"6127KD","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5V8VA532X6M602710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:37.000000Z","updated_at":"2025-03-17T23:39:37.000000Z"}]},{"id":6905384,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","dot_number":"974512","report_state":"TX","report_number":"V241609862","insp_date":"2024-10-03 00:00:00","insp_start_time":"0918","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NIAGRA BOTTLING LLC","shipping_paper_number":"36990605","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-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9395448","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-07 21:41:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-03-17T20:40:12.000000Z","updated_at":"2025-03-17T20:40:12.000000Z","inspection_violations":[{"id":10761255,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","insp_violation_id":"262229818","seq_no":"1","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"203303610","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"393207F"},{"id":10761256,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","insp_violation_id":"262229819","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"203303610","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39345"},{"id":10761257,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","insp_violation_id":"262229820","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"203303611","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39617C"},{"id":10761258,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","insp_violation_id":"262229821","seq_no":"4","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:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11136937,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","insp_unit_id":"203303610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"R141274","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7FD259234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"},{"id":11136938,"change_date":"2024-10-07 21:41:00","inspection_id":"82850275","insp_unit_id":"203303611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UT5500","insp_unit_license":"5515JB","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534XC846804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"}]},{"id":6756791,"change_date":"2024-09-23 21:41:00","inspection_id":"82691902","dot_number":"974512","report_state":"LA","report_number":"LARF000070","insp_date":"2024-09-17 00:00:00","insp_start_time":"1351","insp_end_time":"1442","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"001","insp_level_id":"2","service_center":"SH","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2024-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1219936","transaction_code":"C","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-18 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:58.000000Z","updated_at":"2025-03-17T20:36:58.000000Z","inspection_violations":[{"id":10522532,"change_date":"2024-09-23 21:41:00","inspection_id":"82691902","insp_violation_id":"261980852","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"203080716","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39617C"},{"id":10522533,"change_date":"2024-09-23 21:41:00","inspection_id":"82691902","insp_violation_id":"261980853","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"203080716","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10895382,"change_date":"2024-09-23 21:41:00","inspection_id":"82691902","insp_unit_id":"203080715","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"02","insp_unit_license":"R630216","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9XXFD256331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:51.000000Z","updated_at":"2025-03-17T23:35:51.000000Z"},{"id":10895383,"change_date":"2024-09-23 21:41:00","inspection_id":"82691902","insp_unit_id":"203080716","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UT3241","insp_unit_license":"BF3038","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS25327P962530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:51.000000Z","updated_at":"2025-03-17T23:35:51.000000Z"}]},{"id":6623894,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","dot_number":"974512","report_state":"AZ","report_number":"7254000475","insp_date":"2024-08-27 00:00:00","insp_start_time":"1446","insp_end_time":"1555","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"TUCSON AZ","county_code_state":"AZ","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PREMIER","shipping_paper_number":"PGLT00034953","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":"U","pen_cen_match":"I","final_status_date":"2024-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","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":"808872","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":null,"census_search_date":"2024-09-03 21:40:00","snet_input_date":"2024-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-03 21:40:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:25.000000Z","updated_at":"2025-03-17T20:34:25.000000Z","inspection_violations":[{"id":10302153,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554302","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202710576","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"3922"},{"id":10302154,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554303","seq_no":"2","part_no":"393","part_no_section":"95(a)(4)","insp_viol_unit":"1","insp_unit_id":"202710576","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"39395A4"},{"id":10302155,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554304","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202710576","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"39617C"},{"id":10302156,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554305","seq_no":"4","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"39522G"},{"id":10302157,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554306","seq_no":"5","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"39524"},{"id":10302158,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554307","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202710577","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"39617C"},{"id":10302159,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_violation_id":"261554308","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202710577","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:56.000000Z","updated_at":"2025-03-17T21:55:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10679492,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_unit_id":"202710576","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"01","insp_unit_license":"R141274","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7FD259234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:34.000000Z","updated_at":"2025-03-17T23:33:34.000000Z"},{"id":10679493,"change_date":"2024-09-03 21:40:00","inspection_id":"82550668","insp_unit_id":"202710577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"ST53104","insp_unit_license":"W94444","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DW1A53291B410047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:34.000000Z","updated_at":"2025-03-17T23:33:34.000000Z"}]},{"id":6352284,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","dot_number":"974512","report_state":"AZ","report_number":"6275000417","insp_date":"2024-07-25 00:00:00","insp_start_time":"1147","insp_end_time":"1250","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"PHOENIX AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FRONTIER","shipping_paper_number":"000000","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":"U","pen_cen_match":"I","final_status_date":"2024-07-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"703097","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":null,"census_search_date":"2024-07-31 21:42:00","snet_input_date":"2024-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-31 21:42:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:42.000000Z","updated_at":"2025-03-17T20:28:42.000000Z","inspection_violations":[{"id":9862466,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","insp_violation_id":"260931688","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"202157885","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39378A"},{"id":9862467,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","insp_violation_id":"260931689","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202157886","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3922"},{"id":9862468,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","insp_violation_id":"260931690","seq_no":"3","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"202157885","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39021TB2"},{"id":9862469,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","insp_violation_id":"260931691","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202157886","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10236780,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","insp_unit_id":"202157885","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2","insp_unit_license":"R630216","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9XXFD256331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:03.000000Z","updated_at":"2025-03-17T23:29:03.000000Z"},{"id":10236781,"change_date":"2024-07-31 21:42:00","inspection_id":"82260789","insp_unit_id":"202157886","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"UT5335","insp_unit_license":"BU5004","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25369P721833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:03.000000Z","updated_at":"2025-03-17T23:29:03.000000Z"}]},{"id":6104542,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","dot_number":"974512","report_state":"TX","report_number":"V241451675","insp_date":"2024-06-27 00:00:00","insp_start_time":"1012","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSOLIDATED DISTRIBUTORS INC","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-06-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"9312709","transaction_code":"A","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-28 21:40:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-03-17T20:23:45.000000Z","updated_at":"2025-03-17T20:23:45.000000Z","inspection_violations":[{"id":9475299,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_violation_id":"260376850","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201648354","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"39345B2"},{"id":9475300,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_violation_id":"260376851","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"201648354","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"39345D"},{"id":9475301,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_violation_id":"260376852","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201648353","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"3939A"},{"id":9475302,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_violation_id":"260376853","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201648354","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"3939A"},{"id":9475303,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_violation_id":"260376854","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201648354","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:51.000000Z","updated_at":"2025-03-17T21:51:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9832475,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_unit_id":"201648353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"R267417","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X2FD259271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"},{"id":9832476,"change_date":"2024-06-28 21:40:00","inspection_id":"81995013","insp_unit_id":"201648354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"ST53104","insp_unit_license":"W94444","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DW1A53291B410047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":4399603,"change_date":"2023-11-10 21:33:00","inspection_id":"80135434","dot_number":"974512","report_state":"TX","report_number":"6Q1A9DBEYI","insp_date":"2023-11-09 00:00:00","insp_start_time":"1200","insp_end_time":"1250","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ROOMS TO GO","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-11-10 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9122863","transaction_code":"A","transaction_date":"2023-11-10 00:00:00","upload_date":"2023-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-10 21:33:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-03-17T19:49:55.000000Z","updated_at":"2025-03-17T19:49:55.000000Z","inspection_violations":[{"id":6809013,"change_date":"2023-11-10 21:33:00","inspection_id":"80135434","insp_violation_id":"256331685","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198003575","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"39311"},{"id":6809014,"change_date":"2023-11-10 21:33:00","inspection_id":"80135434","insp_violation_id":"256331686","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198003575","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"3939A"},{"id":6809015,"change_date":"2023-11-10 21:33:00","inspection_id":"80135434","insp_violation_id":"256331687","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198003575","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7075450,"change_date":"2023-11-10 21:33:00","inspection_id":"80135434","insp_unit_id":"198003575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"03","insp_unit_license":"R267417","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X2FD259271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:25.000000Z","updated_at":"2025-03-17T22:59:25.000000Z"}]},{"id":2757432,"change_date":"2023-04-07 21:38:00","inspection_id":"78296171","dot_number":"974512","report_state":"AZ","report_number":"0272004223","insp_date":"2023-04-06 00:00:00","insp_start_time":"1210","insp_end_time":"1230","registration_date":null,"region":"PT","ci_status_code":"C","location":"I10","location_desc":"INTERSTATE 10","county_code_state":"AZ","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"DELARUB LOGISTICS","shipping_paper_number":"3964-1","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":"I","final_status_date":"2023-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1807339","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-07 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:23.000000Z","updated_at":"2025-03-17T19:17:23.000000Z","inspection_violations":[{"id":4232526,"change_date":"2023-04-07 21:38:00","inspection_id":"78296171","insp_violation_id":"252104601","seq_no":"1","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"194280179","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39367C7V"}],"inspection_per_units":[{"id":4438096,"change_date":"2023-04-07 21:38:00","inspection_id":"78296171","insp_unit_id":"194280179","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"R141274","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7FD259234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"},{"id":4438097,"change_date":"2023-04-07 21:38:00","inspection_id":"78296171","insp_unit_id":"194280180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UT5335","insp_unit_license":"BU5004","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS25369P721833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"}]},{"id":2212032,"change_date":"2023-01-24 21:42:00","inspection_id":"77674656","dot_number":"974512","report_state":"FL","report_number":"2829009716","insp_date":"2023-01-19 00:00:00","insp_start_time":"1718","insp_end_time":"1741","registration_date":null,"region":"CT","ci_status_code":"C","location":"HCCM01","location_desc":"MCSAP HCC I-10 ESCAMBIA","county_code_state":"FL","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2470962","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-23 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-01-24 21:42:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"1247 W 34TH ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77018","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:22.000000Z","updated_at":"2025-03-17T19:07:22.000000Z","inspection_violations":[{"id":3416066,"change_date":"2023-01-24 21:42:00","inspection_id":"77674656","insp_violation_id":"250736308","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"000719853","created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3958A1"},{"id":3416067,"change_date":"2023-01-24 21:42:00","inspection_id":"77674656","insp_violation_id":"250736309","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000719853","created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"39141A1"},{"id":3416068,"change_date":"2023-01-24 21:42:00","inspection_id":"77674656","insp_violation_id":"250736310","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"3922"},{"id":3416069,"change_date":"2023-01-24 21:42:00","inspection_id":"77674656","insp_violation_id":"250736311","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193026123","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000719853","created_at":"2025-03-17T21:23:07.000000Z","updated_at":"2025-03-17T21:23:07.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3559886,"change_date":"2023-01-24 21:42:00","inspection_id":"77674656","insp_unit_id":"193026123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"JLY3241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FV6GJAC41HH03129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:31.000000Z","updated_at":"2025-03-17T22:31:31.000000Z"}]},{"id":1894213,"change_date":"2022-12-07 21:41:00","inspection_id":"77310894","dot_number":"974512","report_state":"TX","report_number":"6GF39DAXKD","insp_date":"2022-11-28 00:00:00","insp_start_time":"0350","insp_end_time":"0405","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":"EMSER TILE","shipping_paper_number":"2720366","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-12-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8844320","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00974512","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-07 21:41:00","insp_carrier_name":"CONSOLIDATED DISTRIBUTORS INC","insp_carrier_street":"4880 GULF FREEWAY","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77023","insp_colonia":null,"docket_number":"412351","insp_interstate":"Y","insp_carrier_state_id":"0162703","created_at":"2025-03-17T19:01:31.000000Z","updated_at":"2025-03-17T19:01:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3048630,"change_date":"2022-12-07 21:41:00","inspection_id":"77310894","insp_unit_id":"192311691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"R141274","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7FD259234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:52.000000Z","updated_at":"2025-03-17T22:27:52.000000Z"},{"id":3048631,"change_date":"2022-12-07 21:41:00","inspection_id":"77310894","insp_unit_id":"192311692","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UT5500","insp_unit_license":"5515JB","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534XC846804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:52.000000Z","updated_at":"2025-03-17T22:27:52.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/974512\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/974512\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/974512\/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\/974512\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}