{"current_page":1,"data":[{"id":12658696,"change_date":null,"inspection_id":"sms-769891743","dot_number":"4229551","report_state":"KS","report_number":"HP01763922","insp_date":"2025-08-19 00:00:00","insp_start_time":null,"insp_end_time":null,"registration_date":null,"region":null,"ci_status_code":null,"location":null,"location_desc":null,"county_code_state":"KS","county_code":null,"insp_level_id":"1","service_center":null,"census_source_id":null,"insp_facility":null,"shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":null,"snet_search_date":null,"alcohol_control_sub":null,"drug_intrdctn_search":null,"drug_intrdctn_arrests":null,"size_weight_enf":null,"traffic_enf":null,"local_enf_jurisdiction":null,"pen_cen_match":null,"final_status_date":null,"post_acc_ind":null,"gross_comb_veh_wt":null,"viol_total":"5","oos_total":"4","driver_viol_total":null,"driver_oos_total":"2","vehicle_viol_total":null,"vehicle_oos_total":"2","hazmat_viol_total":null,"hazmat_oos_total":"0","snet_sequence_id":null,"transaction_code":null,"transaction_date":null,"upload_date":null,"upload_first_byte":null,"upload_dot_number":null,"upload_search_indicator":null,"census_search_date":null,"snet_input_date":null,"source_office":null,"mcmis_add_date":null,"insp_carrier_name":null,"insp_carrier_street":null,"insp_carrier_city":null,"insp_carrier_state":null,"insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":null,"insp_interstate":null,"insp_carrier_state_id":null,"created_at":"2026-08-10T03:28:03.000000Z","updated_at":"2026-08-10T03:28:03.000000Z","inspection_violations":[{"id":22039177,"change_date":null,"inspection_id":"sms-769891743","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-08-10T03:30:53.000000Z","updated_at":"2026-08-10T03:30:53.000000Z","normalized_code":"39395A4EEUS"},{"id":22039179,"change_date":null,"inspection_id":"sms-769891743","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-08-10T03:30:53.000000Z","updated_at":"2026-08-10T03:30:53.000000Z","normalized_code":"39141AMCPVI"},{"id":22039182,"change_date":null,"inspection_id":"sms-769891743","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-08-10T03:30:53.000000Z","updated_at":"2026-08-10T03:30:53.000000Z","normalized_code":"39343DB"},{"id":22039183,"change_date":null,"inspection_id":"sms-769891743","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8F1-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-08-10T03:30:53.000000Z","updated_at":"2026-08-10T03:30:53.000000Z","normalized_code":"3958F1HOSM"},{"id":22039235,"change_date":null,"inspection_id":"sms-769891743","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-08-10T03:30:53.000000Z","updated_at":"2026-08-10T03:30:53.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":21972194,"change_date":null,"inspection_id":"sms-769891743","insp_unit_id":"sms-769891743-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"XJM9902","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GC4KTEY0SF339109","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-08-10T03:28:40.000000Z","updated_at":"2026-08-10T03:28:40.000000Z"},{"id":21972277,"change_date":null,"inspection_id":"sms-769891743","insp_unit_id":"sms-769891743-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"SOUTH","insp_unit_company":null,"insp_unit_license":"588432T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4S9GU4028RC666469","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-08-10T03:28:40.000000Z","updated_at":"2026-08-10T03:28:40.000000Z"}]},{"id":8086485,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","dot_number":"4229551","report_state":"TX","report_number":"73GF9DDM7K","insp_date":"2025-03-05 00:00:00","insp_start_time":"0955","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN JEFFERSON CO. (831-","county_code_state":"TX","county_code":"245","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C MAINTENCE REPAIR","shipping_paper_number":"HB327651","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-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23350","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":"9517804","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04229551","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"CA TURNER DISTRIBUTION LLC","insp_carrier_street":"31919 IRONWOOD DR","insp_carrier_city":"WALLER","insp_carrier_state":"TX","insp_carrier_zip_code":"77484-5612","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0772474","created_at":"2025-03-17T21:06:16.000000Z","updated_at":"2025-03-17T21:06:16.000000Z","inspection_violations":[{"id":12638708,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_violation_id":"264955083","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"205740934","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3929AA1"},{"id":12638709,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_violation_id":"264955084","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39141A"},{"id":12638710,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_violation_id":"264955085","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205740934","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39021A"},{"id":12638711,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_violation_id":"264955086","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"205740935","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3939"},{"id":12638712,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_violation_id":"264955087","seq_no":"5","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"205740935","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":13056006,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_unit_id":"205740934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"VBT6269","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FC4YNEY5RF422572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:20.000000Z","updated_at":"2025-03-17T23:59:20.000000Z"},{"id":13056007,"change_date":"2025-03-11 21:41:00","inspection_id":"84094773","insp_unit_id":"205740935","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JPFP4025LBZ53592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:20.000000Z","updated_at":"2025-03-17T23:59:20.000000Z"}]},{"id":8087150,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","dot_number":"4229551","report_state":"TX","report_number":"73HC9DDM7L","insp_date":"2025-03-05 00:00:00","insp_start_time":"0955","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN JEFFERSON CO. (831-","county_code_state":"TX","county_code":"245","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C HOUSTON","shipping_paper_number":"HB327656","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-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9518319","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04229551","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"CA TURNER DISTRIBUTION LLC","insp_carrier_street":"31919 IRONWOOD DR","insp_carrier_city":"WALLER","insp_carrier_state":"TX","insp_carrier_zip_code":"77484-5612","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0772474","created_at":"2025-03-17T21:06:16.000000Z","updated_at":"2025-03-17T21:06:16.000000Z","inspection_violations":[{"id":12640809,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","insp_violation_id":"264957496","seq_no":"1","part_no":"393","part_no_section":"75A4","insp_viol_unit":"2","insp_unit_id":"205742245","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:07:55.000000Z","updated_at":"2025-03-17T22:07:55.000000Z","normalized_code":"39375A4"},{"id":12640810,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","insp_violation_id":"264957497","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"205742245","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:55.000000Z","updated_at":"2025-03-17T22:07:55.000000Z","normalized_code":"39375C"},{"id":12640811,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","insp_violation_id":"264957498","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205742244","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:55.000000Z","updated_at":"2025-03-17T22:07:55.000000Z","normalized_code":"39021A"},{"id":12640812,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","insp_violation_id":"264957499","seq_no":"4","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"205742244","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T22:07:55.000000Z","updated_at":"2025-03-17T22:07:55.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":13057157,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","insp_unit_id":"205742244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"VKC7047","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3CU3RRHL3RG341558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:21.000000Z","updated_at":"2025-03-17T23:59:21.000000Z"},{"id":13057158,"change_date":"2025-03-11 21:41:00","inspection_id":"84095465","insp_unit_id":"205742245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"912990M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4S9GV4028RC666469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:21.000000Z","updated_at":"2025-03-17T23:59:21.000000Z"}]},{"id":7673276,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","dot_number":"4229551","report_state":"TX","report_number":"722A9DGXLQ","insp_date":"2025-01-15 00:00:00","insp_start_time":"0955","insp_end_time":"1043","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"12000 PORT RD","shipping_paper_number":"APZU4341684","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-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","viol_total":"11","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9477372","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04229551","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"CA TURNER DISTRIBUTION LLC","insp_carrier_street":"31919 IRONWOOD DR","insp_carrier_city":"WALLER","insp_carrier_state":"TX","insp_carrier_zip_code":"77484-5612","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0772474","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11988482,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102795","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"38323A2"},{"id":11988483,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102796","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39141A"},{"id":11988484,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102797","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39021A"},{"id":11988485,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102798","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922RG"},{"id":11988486,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102799","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3939"},{"id":11988487,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102800","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922RG"},{"id":11988488,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102801","seq_no":"8","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39617C"},{"id":11988489,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102802","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204937549","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922RG"},{"id":11988490,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102803","seq_no":"10","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39360D"},{"id":11988491,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102804","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204937548","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922RG"},{"id":11988492,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_violation_id":"264102805","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204937549","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12381796,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_unit_id":"204937548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"SPH4555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGLXHG776061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"},{"id":12381797,"change_date":"2025-01-21 21:40:00","inspection_id":"83660790","insp_unit_id":"204937549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"912990M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4S9GU4028RC666469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7608075,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","dot_number":"4229551","report_state":"TX","report_number":"V251717364","insp_date":"2025-01-07 00:00:00","insp_start_time":"1207","insp_end_time":"1221","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"GENERATION PKWY AT T","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TNT CONTAINERS","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-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"29200","viol_total":"13","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9472545","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04229551","upload_search_indicator":"M","census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"CA TURNER DISTRIBUTION LLC","insp_carrier_street":"31919 IRONWOOD DR","insp_carrier_city":"WALLER","insp_carrier_state":"TX","insp_carrier_zip_code":"77484-5612","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0772474","created_at":"2025-03-17T20:56:07.000000Z","updated_at":"2025-03-17T20:56:07.000000Z","inspection_violations":[{"id":11893997,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915551","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"38323A2"},{"id":11893998,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915552","seq_no":"2","part_no":"390","part_no_section":"21(c)","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39021C"},{"id":11893999,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915553","seq_no":"4","part_no":"392","part_no_section":"8","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3928"},{"id":11894000,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915554","seq_no":"5","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"204785834","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39347A"},{"id":11894001,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915555","seq_no":"6","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39395A"},{"id":11894002,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915556","seq_no":"7","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39395B"},{"id":11894003,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915557","seq_no":"8","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39617C"},{"id":11894004,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915558","seq_no":"9","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204785834","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39617C"},{"id":11894005,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915559","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"204785834","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3963A1BOS"},{"id":11894006,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915560","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204785834","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922RG"},{"id":11894007,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915561","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922RG"},{"id":11894008,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915562","seq_no":"13","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204785834","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922RG"},{"id":11894009,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_violation_id":"263915563","seq_no":"14","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"204785833","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":12276182,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_unit_id":"204785833","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"B654646","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GB4CZCL2CF141189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"},{"id":12276183,"change_date":"2025-01-13 21:46:00","inspection_id":"83592370","insp_unit_id":"204785834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"5861V86","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4S9GU4028RC666469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"}]},{"id":7261795,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","dot_number":"4229551","report_state":"TX","report_number":"V241586705","insp_date":"2024-11-19 00:00:00","insp_start_time":"1139","insp_end_time":"1234","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13735 IH10 EB SVC RD","county_code_state":"TX","county_code":"361","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CONGLOBAL INDUSTRIES","shipping_paper_number":"5314541","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-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"22","oos_total":"4","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"19","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9434265","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04229551","upload_search_indicator":"M","census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"CA TURNER DISTRIBUTION LLC","insp_carrier_street":"31919 IRONWOOD DR","insp_carrier_city":"WALLER","insp_carrier_state":"TX","insp_carrier_zip_code":"77484-5612","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0772474","created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":11353144,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050194","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39021A"},{"id":11353145,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050195","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39141A"},{"id":11353146,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050196","seq_no":"3","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3929AA1"},{"id":11353147,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050197","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39311"},{"id":11353148,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050198","seq_no":"5","part_no":"393","part_no_section":"110C","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"393110C"},{"id":11353149,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050199","seq_no":"6","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39348A"},{"id":11353150,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050200","seq_no":"7","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39348A"},{"id":11353151,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050201","seq_no":"8","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39348A"},{"id":11353152,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050202","seq_no":"9","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39348A"},{"id":11353153,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050203","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39378"},{"id":11353154,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050204","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3939"},{"id":11353155,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050205","seq_no":"12","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39395A"},{"id":11353156,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050206","seq_no":"13","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39395B"},{"id":11353157,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050207","seq_no":"14","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39395F"},{"id":11353158,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050208","seq_no":"15","part_no":"395","part_no_section":"8A-NON-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3958ANONELD"},{"id":11353159,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050209","seq_no":"16","part_no":"395","part_no_section":"8K2","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-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3958K2"},{"id":11353160,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050210","seq_no":"17","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39617C"},{"id":11353161,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050211","seq_no":"18","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"39617C"},{"id":11353162,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050212","seq_no":"19","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3963A1BOS"},{"id":11353163,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050213","seq_no":"20","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204017345","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922RG"},{"id":11353164,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050214","seq_no":"21","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922RG"},{"id":11353165,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_violation_id":"263050215","seq_no":"22","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204017344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11713341,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_unit_id":"204017344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TZH0271","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1GEC50716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"},{"id":11713342,"change_date":"2024-11-22 21:41:00","inspection_id":"83228115","insp_unit_id":"204017345","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"1J9GF4025LB253592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":5260786,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","dot_number":"4229551","report_state":"TX","report_number":"V241287883","insp_date":"2024-03-05 00:00:00","insp_start_time":"1325","insp_end_time":"1409","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"809 TX6 EB","county_code_state":"TX","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HYSUN CONTAINER","shipping_paper_number":"1390","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"4","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9219855","transaction_code":"C","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04229551","upload_search_indicator":"M","census_search_date":"2024-05-30 21:43:00","snet_input_date":"2024-03-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"CA TURNER DISTRIBUTION LLC","insp_carrier_street":"31919 IRONWOOD DR","insp_carrier_city":"WALLER","insp_carrier_state":"TX","insp_carrier_zip_code":"77484-5612","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0772474","created_at":"2025-03-17T20:07:02.000000Z","updated_at":"2025-03-17T20:07:02.000000Z","inspection_violations":[{"id":8113003,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","insp_violation_id":"259818976","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"38323A2"},{"id":8113004,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","insp_violation_id":"259818977","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"39141A"},{"id":8113005,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","insp_violation_id":"259818978","seq_no":"3","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":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"3958A1"},{"id":8113006,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","insp_violation_id":"259818979","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201160674","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8471505,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","insp_unit_id":"201160673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RXK9657","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT8NEG27255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:47.000000Z","updated_at":"2025-03-17T23:11:47.000000Z"},{"id":8471506,"change_date":"2024-05-30 21:43:00","inspection_id":"81077967","insp_unit_id":"201160674","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LDTL","insp_unit_company":null,"insp_unit_license":"383794T","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4ZEGT402XP1284901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:47.000000Z","updated_at":"2025-03-17T23:11:47.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4229551\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4229551\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4229551\/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\/4229551\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}