{"current_page":1,"data":[{"id":7729018,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","dot_number":"3427172","report_state":"TX","report_number":"V251767612","insp_date":"2025-01-27 00:00:00","insp_start_time":"1301","insp_end_time":"1407","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US67 AT VAN ZANDT RD","county_code_state":"TX","county_code":"425","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C & C GUERECA TRUCKING LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9485284","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2025-01-28 21:39:00","snet_input_date":"2025-01-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:58:42.000000Z","updated_at":"2025-03-17T20:58:42.000000Z","inspection_violations":[{"id":12078338,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220560","seq_no":"1","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"205046172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39311LR"},{"id":12078339,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220561","seq_no":"2","part_no":"393","part_no_section":"11S","insp_viol_unit":"2","insp_unit_id":"205046172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39311S"},{"id":12078340,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220562","seq_no":"3","part_no":"393","part_no_section":"11UR","insp_viol_unit":"2","insp_unit_id":"205046172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39311UR"},{"id":12078341,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220563","seq_no":"4","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"205046171","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39355C1"},{"id":12078342,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220564","seq_no":"5","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"205046172","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39355E"},{"id":12078343,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220565","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205046171","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39378"},{"id":12078344,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220566","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205046171","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39395F"},{"id":12078345,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220567","seq_no":"8","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205046171","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"39617C"},{"id":12078346,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_violation_id":"264220568","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205046171","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:52.000000Z","updated_at":"2025-03-17T22:04:52.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12472634,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_unit_id":"205046171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1585","insp_unit_license":"25T768M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X46D894199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:37.000000Z","updated_at":"2025-03-17T23:52:37.000000Z"},{"id":12472635,"change_date":"2025-01-28 21:39:00","inspection_id":"83719108","insp_unit_id":"205046172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"LW21-40","insp_unit_license":"BU6303","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UNSD4021NS188169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:37.000000Z","updated_at":"2025-03-17T23:52:37.000000Z"}]},{"id":7719861,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","dot_number":"3427172","report_state":"TX","report_number":"V251759738","insp_date":"2025-01-23 00:00:00","insp_start_time":"1411","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US67 NB","county_code_state":"TX","county_code":"251","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TX LIME","shipping_paper_number":"6223","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-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"92350","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":"9484204","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:58:21.000000Z","updated_at":"2025-03-17T20:58:21.000000Z","inspection_violations":[{"id":12062512,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","insp_violation_id":"264199920","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205028465","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39311TL"},{"id":12062513,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","insp_violation_id":"264199921","seq_no":"2","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"205028465","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39345B2PC"},{"id":12062514,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","insp_violation_id":"264199922","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"205028466","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39345B2UV"},{"id":12062515,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","insp_violation_id":"264199923","seq_no":"4","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"205028466","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":12457957,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","insp_unit_id":"205028465","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"939","insp_unit_license":"1M99655","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGNBG5FDGT1118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"},{"id":12457958,"change_date":"2025-01-27 21:40:00","inspection_id":"83709546","insp_unit_id":"205028466","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"939","insp_unit_license":"035C700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKD40230F1029147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"}]},{"id":7674412,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","dot_number":"3427172","report_state":"TX","report_number":"V251704470","insp_date":"2025-01-14 00:00:00","insp_start_time":"0824","insp_end_time":"0858","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"417  US183","county_code_state":"TX","county_code":"447","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN","shipping_paper_number":"54709517","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":"118000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9479171","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":"03427172","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11992200,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107082","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204939731","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39347E"},{"id":11992201,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107083","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"204939731","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39348A"},{"id":11992202,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107084","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"204939731","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39353B"},{"id":11992203,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107085","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204939730","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39360C"},{"id":11992204,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107086","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204939730","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3939"},{"id":11992205,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107087","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204939730","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3939"},{"id":11992206,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107088","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204939730","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39617C"},{"id":11992207,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107089","seq_no":"8","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"204939730","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3963A1B"},{"id":11992208,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107090","seq_no":"9","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"204939731","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3963A1BOS"},{"id":11992209,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107091","seq_no":"10","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204939730","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3922RG"},{"id":11992210,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_violation_id":"264107092","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204939731","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12383708,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_unit_id":"204939730","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1585","insp_unit_license":"68Y610V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X46D894199","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":12383709,"change_date":"2025-01-21 21:40:00","inspection_id":"83661998","insp_unit_id":"204939731","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"LW21-40","insp_unit_license":"BU6303","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UNSD4021NS188169","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":7567393,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","dot_number":"3427172","report_state":"TX","report_number":"V251730974","insp_date":"2025-01-02 00:00:00","insp_start_time":"1201","insp_end_time":"1231","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"306  TX112","county_code_state":"TX","county_code":"133","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN","shipping_paper_number":"54708242","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-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9468033","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[{"id":11830427,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802330","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"393209D"},{"id":11830428,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802331","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939"},{"id":11830429,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802332","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939H"},{"id":11830430,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802333","seq_no":"4","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939T"},{"id":11830431,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802334","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39617C"},{"id":11830432,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802335","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"204693125","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39617C"},{"id":11830433,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802336","seq_no":"7","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3963A1B"},{"id":11830434,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_violation_id":"263802337","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204693124","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12209898,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_unit_id":"204693124","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1584","insp_unit_license":"1N14803","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"},{"id":12209899,"change_date":"2025-01-07 21:40:00","inspection_id":"83549571","insp_unit_id":"204693125","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":7286855,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","dot_number":"3427172","report_state":"TX","report_number":"70AF9DSU9I","insp_date":"2024-11-12 00:00:00","insp_start_time":"1439","insp_end_time":"1518","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WIGGINS RD","county_code_state":"TX","county_code":"139","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C","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-11-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123250","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9436994","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-11-26 21:41:00","snet_input_date":"2024-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-26 21:41:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:48:08.000000Z","updated_at":"2025-03-17T20:48:08.000000Z","inspection_violations":[{"id":11392290,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109668","seq_no":"1","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"999"},{"id":11392291,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109669","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39360C"},{"id":11392292,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109670","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39378"},{"id":11392293,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109671","seq_no":"4","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"3939T"},{"id":11392294,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109672","seq_no":"5","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39375C"},{"id":11392295,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109673","seq_no":"6","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39311TL"},{"id":11392296,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109674","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204072359","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"3922RG"},{"id":11392297,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_violation_id":"263109675","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204072358","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11753937,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_unit_id":"204072358","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1584","insp_unit_license":"1N14803","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:49.000000Z","updated_at":"2025-03-17T23:44:49.000000Z"},{"id":11753938,"change_date":"2024-11-26 21:41:00","inspection_id":"83254582","insp_unit_id":"204072359","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:49.000000Z","updated_at":"2025-03-17T23:44:49.000000Z"}]},{"id":7015415,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","dot_number":"3427172","report_state":"TX","report_number":"6ZKE9DNE6F","insp_date":"2024-10-17 00:00:00","insp_start_time":"1457","insp_end_time":"1614","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN DENTON CO. (2155-246","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"23","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"21","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9407984","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-10-22 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-22 21:42:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:42:18.000000Z","updated_at":"2025-03-17T20:42:18.000000Z","inspection_violations":[{"id":10947335,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489127","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-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"38323A2"},{"id":10947336,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489128","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39360D"},{"id":10947337,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489129","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39617C"},{"id":10947338,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489130","seq_no":"4","part_no":"396","part_no_section":"3A1BL","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3963A1BL"},{"id":10947339,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489131","seq_no":"5","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39345B2UV"},{"id":10947340,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489132","seq_no":"6","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39375A3"},{"id":10947341,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489133","seq_no":"7","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3939T"},{"id":10947342,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489134","seq_no":"8","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3939TS"},{"id":10947343,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489135","seq_no":"9","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39319"},{"id":10947344,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489136","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3939"},{"id":10947345,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489137","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3939"},{"id":10947346,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489138","seq_no":"12","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39345B2UV"},{"id":10947347,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489139","seq_no":"13","part_no":"393","part_no_section":"70B1I","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39370B1I"},{"id":10947348,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489140","seq_no":"14","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"203527742","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39345B2UV"},{"id":10947349,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489141","seq_no":"15","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39617C"},{"id":10947350,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489142","seq_no":"16","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39345B2UV"},{"id":10947351,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489143","seq_no":"17","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3965BHWSLIW"},{"id":10947352,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489144","seq_no":"18","part_no":"393","part_no_section":"207A","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"393207A"},{"id":10947353,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489145","seq_no":"19","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3939"},{"id":10947354,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489146","seq_no":"20","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3939"},{"id":10947355,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489147","seq_no":"21","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39347E"},{"id":10947356,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489148","seq_no":"22","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"203527743","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39353B"},{"id":10947357,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_violation_id":"262489149","seq_no":"23","part_no":"391","part_no_section":"45B","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:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":11315208,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_unit_id":"203527742","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1938","insp_unit_license":"88S798M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AG10Y85M026230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:10.000000Z","updated_at":"2025-03-17T23:40:10.000000Z"},{"id":11315209,"change_date":"2024-10-22 21:42:00","inspection_id":"82967214","insp_unit_id":"203527743","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":null,"insp_unit_license":"BU6357","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1R9BSE5016L008474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:10.000000Z","updated_at":"2025-03-17T23:40:10.000000Z"}]},{"id":6865059,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","dot_number":"3427172","report_state":"TX","report_number":"6YZB9DNE5Q","insp_date":"2024-09-26 00:00:00","insp_start_time":"1113","insp_end_time":"1203","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN DENTON CO. (2155-246","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"17","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9390261","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-10-01 21:42:00","snet_input_date":"2024-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:39:24.000000Z","updated_at":"2025-03-17T20:39:24.000000Z","inspection_violations":[{"id":10692366,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131660","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3922"},{"id":10692367,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131661","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3922"},{"id":10692368,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131662","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39617C"},{"id":10692369,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131663","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39378"},{"id":10692370,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131664","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39311"},{"id":10692371,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131665","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3939A"},{"id":10692372,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131666","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3939A"},{"id":10692373,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131667","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39345B2"},{"id":10692374,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131668","seq_no":"9","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"393209E"},{"id":10692375,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131669","seq_no":"10","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39347D"},{"id":10692376,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131670","seq_no":"11","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39347D"},{"id":10692377,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131671","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203219904","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3963A1"},{"id":10692378,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131672","seq_no":"13","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"203219905","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39617C"},{"id":10692379,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131673","seq_no":"14","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"203219905","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39355C2"},{"id":10692380,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131674","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203219905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3939A"},{"id":10692381,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131675","seq_no":"16","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203219905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3939A"},{"id":10692382,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_violation_id":"262131676","seq_no":"17","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203219905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11070940,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_unit_id":"203219904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1534","insp_unit_license":"1N14803","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:40.000000Z","updated_at":"2025-03-17T23:37:40.000000Z"},{"id":11070941,"change_date":"2024-10-01 21:42:00","inspection_id":"82807417","insp_unit_id":"203219905","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":null,"insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:40.000000Z","updated_at":"2025-03-17T23:37:40.000000Z"}]},{"id":6008800,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","dot_number":"3427172","report_state":"TX","report_number":"6VN69DHTV1","insp_date":"2024-05-29 00:00:00","insp_start_time":"0639","insp_end_time":"0720","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0287 IN JOHNSON CO. (482-48","county_code_state":"TX","county_code":"251","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-17 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"12","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9301404","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-06-17 21:46:00","snet_input_date":"2024-05-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-17 21:46:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:21:52.000000Z","updated_at":"2025-03-17T20:21:52.000000Z","inspection_violations":[{"id":9322702,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150354","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39617C"},{"id":9322703,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150355","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201449129","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39617C"},{"id":9322704,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150356","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39378"},{"id":9322705,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150357","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39395A"},{"id":9322706,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150358","seq_no":"5","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39360C"},{"id":9322707,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150359","seq_no":"6","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39355D1"},{"id":9322708,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150360","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3939A"},{"id":9322709,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150361","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3939A"},{"id":9322710,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150362","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3939A"},{"id":9322711,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150363","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3939A"},{"id":9322712,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150364","seq_no":"11","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39311"},{"id":9322713,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_violation_id":"260150365","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201449128","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9678081,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_unit_id":"201449128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1590","insp_unit_license":"35Y414V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK35DU44371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"},{"id":9678082,"change_date":"2024-06-17 21:46:00","inspection_id":"81892048","insp_unit_id":"201449129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BU6358","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1R9BSE5056L008476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":5712616,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","dot_number":"3427172","report_state":"TX","report_number":"V241381264","insp_date":"2024-05-08 00:00:00","insp_start_time":"0718","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BLOOMDALE RD","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N. TX NATURAL SELECT","shipping_paper_number":"89687","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":"2024-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"9","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9269663","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-05-09 21:43:00","snet_input_date":"2024-05-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-09 21:43:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[{"id":8838751,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417582","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39021A"},{"id":8838752,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417583","seq_no":"2","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"2","insp_unit_id":"200818593","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39375B"},{"id":8838753,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417584","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39378"},{"id":8838754,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417585","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3939A"},{"id":8838755,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417586","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39395A"},{"id":8838756,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417587","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39395F"},{"id":8838757,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417588","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"39617C"},{"id":8838758,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417589","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200818592","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3922"},{"id":8838759,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_violation_id":"259417590","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:43.000000Z","updated_at":"2025-03-17T21:48:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9201234,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_unit_id":"200818592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1584","insp_unit_license":"37Y414V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:38.000000Z","updated_at":"2025-03-17T23:18:38.000000Z"},{"id":9201235,"change_date":"2024-05-09 21:43:00","inspection_id":"81570604","insp_unit_id":"200818593","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:38.000000Z","updated_at":"2025-03-17T23:18:38.000000Z"}]},{"id":5731952,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","dot_number":"3427172","report_state":"TX","report_number":"6UV99DLCKB","insp_date":"2024-05-01 00:00:00","insp_start_time":"0807","insp_end_time":"0932","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0380 IN COLLIN CO. (628-656","county_code_state":"TX","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C & C GUERECA TRUCKING 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":"2024-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"22","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9271040","transaction_code":"C","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-05-13 21:42:00","snet_input_date":"2024-05-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-13 21:42:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:16:19.000000Z","updated_at":"2025-03-17T20:16:19.000000Z","inspection_violations":[{"id":8871129,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527069","seq_no":"21","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39617C"},{"id":8871130,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527070","seq_no":"22","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39345"},{"id":8871131,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527071","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3963A1"},{"id":8871132,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527072","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"393207A"},{"id":8871133,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527073","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39360C"},{"id":8871134,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527074","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39375A3"},{"id":8871135,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527075","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3963A1"},{"id":8871136,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527076","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3963A1"},{"id":8871137,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527077","seq_no":"7","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39347B"},{"id":8871138,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527078","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39378"},{"id":8871139,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527079","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3922"},{"id":8871140,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527080","seq_no":"10","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39355D1"},{"id":8871141,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527081","seq_no":"11","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39355D3"},{"id":8871142,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527082","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3939A"},{"id":8871143,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527083","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3939A"},{"id":8871144,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527084","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3963A1"},{"id":8871145,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527085","seq_no":"15","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39375A1"},{"id":8871146,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527086","seq_no":"16","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39345B2"},{"id":8871147,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527087","seq_no":"17","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3963A1"},{"id":8871148,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527088","seq_no":"18","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"3922"},{"id":8871149,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527089","seq_no":"19","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"200912109","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39375A1"},{"id":8871150,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_violation_id":"259527090","seq_no":"20","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200912108","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9232245,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_unit_id":"200912108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1590","insp_unit_license":"1L53066","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK35DU44371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:55.000000Z","updated_at":"2025-03-17T23:18:55.000000Z"},{"id":9232246,"change_date":"2024-05-15 21:44:00","inspection_id":"81591615","insp_unit_id":"200912109","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BU6358","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1R9BSE5056L008476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:55.000000Z","updated_at":"2025-03-17T23:18:55.000000Z"}]},{"id":5577621,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","dot_number":"3427172","report_state":"TX","report_number":"6UHD9DLCK5","insp_date":"2024-04-17 00:00:00","insp_start_time":"1238","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FANNIN RD","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C & C GUERECA TRUCKING 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":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","viol_total":"19","oos_total":"5","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"16","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9254743","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8621300,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088119","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:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"38323A2"},{"id":8621301,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088120","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39141A"},{"id":8621302,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088121","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"3922"},{"id":8621303,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088122","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39617C"},{"id":8621304,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088123","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200534293","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39617C"},{"id":8621305,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088124","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200534293","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39375A3"},{"id":8621306,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088125","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"3922"},{"id":8621307,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088126","seq_no":"8","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200534293","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39375A3"},{"id":8621308,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088127","seq_no":"9","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39378"},{"id":8621309,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088128","seq_no":"10","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39324A"},{"id":8621310,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088129","seq_no":"11","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39345D"},{"id":8621311,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088130","seq_no":"12","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39345"},{"id":8621312,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088131","seq_no":"13","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"393203C"},{"id":8621313,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088132","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200534293","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39375A3"},{"id":8621314,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088133","seq_no":"15","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39347B"},{"id":8621315,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088134","seq_no":"16","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39355D1"},{"id":8621316,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088135","seq_no":"17","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"200534293","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"39375A1"},{"id":8621317,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088136","seq_no":"18","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"200534292","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"3929A2"},{"id":8621318,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_violation_id":"259088137","seq_no":"19","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:47.000000Z","updated_at":"2025-03-17T21:47:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8984520,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_unit_id":"200534292","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1590","insp_unit_license":"1L53066","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK35DU44371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8984521,"change_date":"2024-04-23 21:41:00","inspection_id":"81423674","insp_unit_id":"200534293","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BU6358","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1R9BSE5056L008476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5260233,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","dot_number":"3427172","report_state":"TX","report_number":"6SY99DSC6F","insp_date":"2024-02-22 00:00:00","insp_start_time":"0954","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0820 IN TARRANT CO. (0-34)","county_code_state":"TX","county_code":"439","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C GUERECA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9219116","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:07:02.000000Z","updated_at":"2025-03-17T20:07:02.000000Z","inspection_violations":[{"id":8111048,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319319","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"3963A1"},{"id":8111049,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319320","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"26","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":"39378"},{"id":8111050,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319321","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"20","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":"3939A"},{"id":8111051,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319322","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"15","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":"39347E"},{"id":8111052,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319323","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"16","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":"39353B"},{"id":8111053,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319324","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"21","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":"393209E"},{"id":8111054,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319325","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"24","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":"3965B"},{"id":8111055,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319326","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"30","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":"3963A1"},{"id":8111056,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_violation_id":"258319327","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199856893","insp_violation_category_id":"16","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":"3963A1"}],"inspection_per_units":[{"id":8470625,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_unit_id":"199856893","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1584","insp_unit_license":"1N14803","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","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":8470626,"change_date":"2024-03-11 21:44:00","inspection_id":"81077349","insp_unit_id":"199856894","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","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":4945647,"change_date":"2024-01-31 21:42:00","inspection_id":"80733821","dot_number":"3427172","report_state":"TX","report_number":"6SBC9DLCHP","insp_date":"2024-01-30 00:00:00","insp_start_time":"1209","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0543 IN COLLIN CO. (228-236","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C&C GUERECA TRUCKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9184616","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-01-31 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T20:00:48.000000Z","updated_at":"2025-03-17T20:00:48.000000Z","inspection_violations":[{"id":7617517,"change_date":"2024-01-31 21:42:00","inspection_id":"80733821","insp_violation_id":"257593072","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199202011","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"39378"},{"id":7617518,"change_date":"2024-01-31 21:42:00","inspection_id":"80733821","insp_violation_id":"257593073","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199202011","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"39617C"},{"id":7617519,"change_date":"2024-01-31 21:42:00","inspection_id":"80733821","insp_violation_id":"257593074","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199202012","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7959166,"change_date":"2024-01-31 21:42:00","inspection_id":"80733821","insp_unit_id":"199202011","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1582","insp_unit_license":"55X300V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"},{"id":7959167,"change_date":"2024-01-31 21:42:00","inspection_id":"80733821","insp_unit_id":"199202012","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"}]},{"id":4777200,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","dot_number":"3427172","report_state":"TX","report_number":"V241239180","insp_date":"2024-01-02 00:00:00","insp_start_time":"1258","insp_end_time":"1352","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US75 SB AT CR364","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RPMX","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-01-05 21:46: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":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9166720","transaction_code":"C","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2024-01-05 21:46:00","snet_input_date":"2024-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T19:57:18.000000Z","updated_at":"2025-03-17T19:57:18.000000Z","inspection_violations":[{"id":7371637,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245646","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"39355C1"},{"id":7371638,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245647","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"39360C"},{"id":7371639,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245648","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"39378"},{"id":7371640,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245649","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"3939A"},{"id":7371641,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245650","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"3939A"},{"id":7371642,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245651","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"39617C"},{"id":7371643,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_violation_id":"257245652","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198867989","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:35.000000Z","updated_at":"2025-03-17T21:41:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7685600,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_unit_id":"198867989","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1590","insp_unit_license":"1L53066","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK35DU44371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:42.000000Z","updated_at":"2025-03-17T23:04:42.000000Z"},{"id":7685601,"change_date":"2024-01-08 21:45:00","inspection_id":"80549638","insp_unit_id":"198867990","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"0","insp_unit_license":"6886KZ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"591SD4027HR156055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:42.000000Z","updated_at":"2025-03-17T23:04:42.000000Z"}]},{"id":3233839,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","dot_number":"3427172","report_state":"TX","report_number":"6LKA9DHXCM","insp_date":"2023-06-01 00:00:00","insp_start_time":"1054","insp_end_time":"1122","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0121 IN TARRANT CO. (282-30","county_code_state":"TX","county_code":"439","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-06-07 21:42: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":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8997741","transaction_code":"C","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03427172","upload_search_indicator":"M","census_search_date":"2023-06-07 21:42:00","snet_input_date":"2023-06-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"C & C GUERECA TRUCKING LLC","insp_carrier_street":"11005 ADIANA LN","insp_carrier_city":"CROWLEY","insp_carrier_state":"TX","insp_carrier_zip_code":"76036","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1053883","created_at":"2025-03-17T19:26:55.000000Z","updated_at":"2025-03-17T19:26:55.000000Z","inspection_violations":[{"id":4985263,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393772","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195404032","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39378"},{"id":4985264,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393773","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195404032","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39395A"},{"id":4985265,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393774","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195404032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39311"},{"id":4985266,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393775","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195404032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39311"},{"id":4985267,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393776","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195404032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39311"},{"id":4985268,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393777","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195404032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"},{"id":4985269,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_violation_id":"253393778","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195404033","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5201110,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_unit_id":"195404032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1N14803","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X26D657702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:00.000000Z","updated_at":"2025-03-17T22:44:00.000000Z"},{"id":5201111,"change_date":"2023-06-08 21:42:00","inspection_id":"78834529","insp_unit_id":"195404033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"BU6357","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1R9BSE5016L008474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:00.000000Z","updated_at":"2025-03-17T22:44:00.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3427172\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3427172\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3427172\/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\/3427172\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}