{"current_page":1,"data":[{"id":11734036,"change_date":"2026-04-23 21:39:00","inspection_id":"87662444","dot_number":"3846413","report_state":"TX","report_number":"V262327637","insp_date":"2026-04-20 00:00:00","insp_start_time":"0900","insp_end_time":"0913","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 NB IH35 SB","county_code_state":"TX","county_code":"283","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INTERNATIONAL BRIDGE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9929345","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-04-23 21:39:00","snet_input_date":"2026-04-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-23 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-04-27T09:41:42.000000Z","updated_at":"2026-05-04T09:31:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20417464,"change_date":"2026-04-23 21:39:00","inspection_id":"87662444","insp_unit_id":"213188452","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"180","insp_unit_license":"FS5532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR9FN530600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:17.000000Z","updated_at":"2026-05-04T09:04:33.000000Z"},{"id":20417465,"change_date":"2026-04-23 21:39:00","inspection_id":"87662444","insp_unit_id":"213188453","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"84509","insp_unit_license":"AT2398","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4027KL084509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:17.000000Z","updated_at":"2026-05-04T09:04:33.000000Z"}]},{"id":11490182,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","dot_number":"3846413","report_state":"TX","report_number":"V262282329","insp_date":"2026-03-24 00:00:00","insp_start_time":"0700","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59 NB REST","county_code_state":"TX","county_code":"283","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GUERRA TRANSPORTATION 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":"2026-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9896582","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-03-29T09:54:19.000000Z","updated_at":"2026-04-06T09:33:55.000000Z","inspection_violations":[{"id":19399647,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_violation_id":"272667660","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"212361862","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:34.000000Z","updated_at":"2026-04-06T09:55:08.000000Z","normalized_code":"39330"},{"id":19399648,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_violation_id":"272667661","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212361863","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:34.000000Z","updated_at":"2026-04-06T09:55:08.000000Z","normalized_code":"39347E"},{"id":19399649,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_violation_id":"272667662","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212361863","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:34.000000Z","updated_at":"2026-04-06T09:55:08.000000Z","normalized_code":"39347E"},{"id":19399650,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_violation_id":"272667663","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212361863","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:34.000000Z","updated_at":"2026-04-06T09:55:08.000000Z","normalized_code":"39347E"},{"id":19399651,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_violation_id":"272667664","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"212361863","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:34.000000Z","updated_at":"2026-04-06T09:55:08.000000Z","normalized_code":"39353B"},{"id":19399652,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_violation_id":"272667665","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"212361863","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-29T10:23:34.000000Z","updated_at":"2026-04-06T09:55:08.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":19683148,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_unit_id":"212361862","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"09","insp_unit_license":"LR3667","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDZAPR0LN099195","insp_unit_decal":"Y","insp_unit_decal_number":"35969592","created_at":"2026-03-29T09:51:04.000000Z","updated_at":"2026-04-06T09:13:11.000000Z"},{"id":19683149,"change_date":"2026-03-26 21:40:00","inspection_id":"87409863","insp_unit_id":"212361863","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"84905","insp_unit_license":"185B678","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3M9KS4022LL084905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:04.000000Z","updated_at":"2026-04-06T09:13:11.000000Z"}]},{"id":11478491,"change_date":"2026-03-25 21:40:00","inspection_id":"87397517","dot_number":"3846413","report_state":"TX","report_number":"V262282879","insp_date":"2026-03-23 00:00:00","insp_start_time":"1430","insp_end_time":"1508","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 NB IH35 NB","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GB STRINGING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9895770","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-03-28T09:44:50.000000Z","updated_at":"2026-04-05T09:32:47.000000Z","inspection_violations":[{"id":19376483,"change_date":"2026-03-25 21:40:00","inspection_id":"87397517","insp_violation_id":"272640046","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212337290","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:02.000000Z","updated_at":"2026-04-05T10:01:46.000000Z","normalized_code":"3939"},{"id":19376484,"change_date":"2026-03-25 21:40:00","inspection_id":"87397517","insp_violation_id":"272640047","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"212337290","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-28T10:12:02.000000Z","updated_at":"2026-04-05T10:01:46.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":19661565,"change_date":"2026-03-25 21:40:00","inspection_id":"87397517","insp_unit_id":"212337290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10641","insp_unit_license":"MX2221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6CK17PX35551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:01.000000Z","updated_at":"2026-04-05T09:19:10.000000Z"},{"id":19661566,"change_date":"2026-03-25 21:40:00","inspection_id":"87397517","insp_unit_id":"212337291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXI","insp_unit_company":"414","insp_unit_license":"AW7039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4025KL084623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:01.000000Z","updated_at":"2026-04-05T09:19:10.000000Z"}]},{"id":11408798,"change_date":"2026-03-18 21:38:00","inspection_id":"87324178","dot_number":"3846413","report_state":"TX","report_number":"V262259064","insp_date":"2026-03-15 00:00:00","insp_start_time":"1007","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-35 NB MILE MARKER","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GUERRA TRANSPORTATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9888363","transaction_code":"A","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-03-18 21:38:00","snet_input_date":"2026-03-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-18 21:38:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-03-21T09:47:03.000000Z","updated_at":"2026-03-29T09:32:18.000000Z","inspection_violations":[{"id":19238197,"change_date":"2026-03-18 21:38:00","inspection_id":"87324178","insp_violation_id":"272481466","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"212204684","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:47.000000Z","updated_at":"2026-03-29T09:58:22.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":19541891,"change_date":"2026-03-18 21:38:00","inspection_id":"87324178","insp_unit_id":"212204684","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10641","insp_unit_license":"MX2221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6CK17PX35551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:23.000000Z","updated_at":"2026-03-29T09:18:58.000000Z"},{"id":19541892,"change_date":"2026-03-18 21:38:00","inspection_id":"87324178","insp_unit_id":"212204685","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"414","insp_unit_license":"AW7039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4025KL084623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:23.000000Z","updated_at":"2026-03-29T09:18:59.000000Z"}]},{"id":11239388,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","dot_number":"3846413","report_state":"TX","report_number":"V262160006","insp_date":"2026-02-17 00:00:00","insp_start_time":"1233","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 NB MM 59","county_code_state":"TX","county_code":"283","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9861956","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-03-01T10:39:03.000000Z","updated_at":"2026-03-09T09:31:57.000000Z","inspection_violations":[{"id":18872786,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063344","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"211859371","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"39345B2UV"},{"id":18872787,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063345","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"211859372","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"39345B2UV"},{"id":18872788,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063346","seq_no":"3","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"211859371","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"39345DLPC"},{"id":18872789,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063347","seq_no":"4","part_no":"393","part_no_section":"50C","insp_viol_unit":"1","insp_unit_id":"211859371","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"39350C"},{"id":18872790,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063348","seq_no":"5","part_no":"393","part_no_section":"75A2","insp_viol_unit":"1","insp_unit_id":"211859371","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"39375A2"},{"id":18872791,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063349","seq_no":"6","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"211859372","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"39375C"},{"id":18872792,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063350","seq_no":"7","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"211859372","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"3963A1"},{"id":18872793,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_violation_id":"272063351","seq_no":"8","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"211859371","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:56:54.000000Z","updated_at":"2026-03-09T09:45:58.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":19213274,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_unit_id":"211859371","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10641","insp_unit_license":"MX2221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6CK17PX35551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:46.000000Z","updated_at":"2026-03-09T09:09:50.000000Z"},{"id":19213275,"change_date":"2026-02-26 21:41:00","inspection_id":"87152019","insp_unit_id":"211859372","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXI","insp_unit_company":"414","insp_unit_license":"AW7039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4025KL084623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:46.000000Z","updated_at":"2026-03-09T09:09:50.000000Z"}]},{"id":11151988,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","dot_number":"3846413","report_state":"TX","report_number":"V262172037","insp_date":"2026-02-15 00:00:00","insp_start_time":"1013","insp_end_time":"1102","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GUERRA TRANSPORT","shipping_paper_number":"5003470","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9853868","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-02-20T10:37:51.000000Z","updated_at":"2026-02-28T10:31:01.000000Z","inspection_violations":[{"id":18688134,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","insp_violation_id":"271849740","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"211667971","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:53.000000Z","updated_at":"2026-02-28T10:41:40.000000Z","normalized_code":"39345B2UV"},{"id":18688135,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","insp_violation_id":"271849741","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:53.000000Z","updated_at":"2026-02-28T10:41:40.000000Z","normalized_code":"3922W"},{"id":18688136,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","insp_violation_id":"271849742","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:53.000000Z","updated_at":"2026-02-28T10:41:40.000000Z","normalized_code":"3922W"},{"id":18688137,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","insp_violation_id":"271849743","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:53.000000Z","updated_at":"2026-02-28T10:41:40.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":19025540,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","insp_unit_id":"211667971","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10641","insp_unit_license":"MX2221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6CK17PX35551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:32.000000Z","updated_at":"2026-02-28T10:04:03.000000Z"},{"id":19025541,"change_date":"2026-02-17 21:39:00","inspection_id":"87066656","insp_unit_id":"211667972","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"414","insp_unit_license":"AW7039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4025KL084623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:32.000000Z","updated_at":"2026-02-28T10:04:03.000000Z"}]},{"id":11085179,"change_date":"2026-02-09 21:39:00","inspection_id":"86996529","dot_number":"3846413","report_state":"TX","report_number":"V262214919","insp_date":"2026-02-05 00:00:00","insp_start_time":"1705","insp_end_time":"1756","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16205  US83","county_code_state":"TX","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SIGNAL PEAK SILICA OF CARRIZO","shipping_paper_number":"SCS26170387","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9842566","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-02-09 21:39:00","snet_input_date":"2026-02-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-09 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-02-12T10:37:04.000000Z","updated_at":"2026-02-20T10:30:57.000000Z","inspection_violations":[{"id":18556971,"change_date":"2026-02-09 21:39:00","inspection_id":"86996529","insp_violation_id":"271685631","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211523435","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:35.000000Z","updated_at":"2026-02-20T10:39:41.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18902859,"change_date":"2026-02-09 21:39:00","inspection_id":"86996529","insp_unit_id":"211523435","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"18","insp_unit_license":"FZ5450","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSKZAPR5KN390863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:39.000000Z","updated_at":"2026-02-20T10:04:05.000000Z"},{"id":18902860,"change_date":"2026-02-09 21:39:00","inspection_id":"86996529","insp_unit_id":"211523436","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"516","insp_unit_license":"AX1212","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4021LL084765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:39.000000Z","updated_at":"2026-02-20T10:04:05.000000Z"}]},{"id":11120650,"change_date":"2026-02-12 21:41:00","inspection_id":"87033706","dot_number":"3846413","report_state":"TX","report_number":"V262201850","insp_date":"2026-02-05 00:00:00","insp_start_time":"1320","insp_end_time":"1354","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 MP 359","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GUERRA TRANSPORTATION 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":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9848107","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-02-15T10:38:50.000000Z","updated_at":"2026-02-23T10:31:07.000000Z","inspection_violations":[{"id":18625364,"change_date":"2026-02-12 21:41:00","inspection_id":"87033706","insp_violation_id":"271769625","seq_no":"1","part_no":"393","part_no_section":"45DCUV","insp_viol_unit":"1","insp_unit_id":"211598075","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:28.000000Z","updated_at":"2026-02-23T10:40:06.000000Z","normalized_code":"39345DCUV"},{"id":18625365,"change_date":"2026-02-12 21:41:00","inspection_id":"87033706","insp_violation_id":"271769626","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211598076","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-15T10:55:28.000000Z","updated_at":"2026-02-23T10:40:06.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18967031,"change_date":"2026-02-12 21:41:00","inspection_id":"87033706","insp_unit_id":"211598075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"FV4108","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYAP9X0EJ386854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:11.000000Z","updated_at":"2026-02-23T10:03:40.000000Z"},{"id":18967032,"change_date":"2026-02-12 21:41:00","inspection_id":"87033706","insp_unit_id":"211598076","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"84905","insp_unit_license":"185B678","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3M9KS4022LL084905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:11.000000Z","updated_at":"2026-02-23T10:03:40.000000Z"}]},{"id":10848117,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","dot_number":"3846413","report_state":"TX","report_number":"V262188200","insp_date":"2026-01-22 00:00:00","insp_start_time":"1759","insp_end_time":"1855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16205  US83 MM 652","county_code_state":"TX","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SIGNAL PEAK SILICA OF CARRIZO","shipping_paper_number":"SCS26168048","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","viol_total":"6","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9829658","transaction_code":"A","transaction_date":"2026-01-23 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-01-23 21:39:00","snet_input_date":"2026-01-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-23 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-01-26T10:37:34.000000Z","updated_at":"2026-02-03T10:30:41.000000Z","inspection_violations":[{"id":18146394,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_violation_id":"271399299","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"211265020","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:34.000000Z","updated_at":"2026-02-04T10:36:10.000000Z","normalized_code":"39378"},{"id":18146395,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_violation_id":"271399300","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:34.000000Z","updated_at":"2026-02-04T10:36:10.000000Z","normalized_code":"3922W"},{"id":18146396,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_violation_id":"271399301","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:34.000000Z","updated_at":"2026-02-04T10:36:10.000000Z","normalized_code":"3922W"},{"id":18146397,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_violation_id":"271399302","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:34.000000Z","updated_at":"2026-02-04T10:36:10.000000Z","normalized_code":"3922W"},{"id":18146398,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_violation_id":"271399303","seq_no":"5","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:34.000000Z","updated_at":"2026-02-04T10:36:10.000000Z","normalized_code":"3922W"},{"id":18146399,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_violation_id":"271399304","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211265020","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-26T10:43:34.000000Z","updated_at":"2026-02-04T10:36:10.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18226856,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_unit_id":"211265020","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"01","insp_unit_license":"FS2744","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR8FN530586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:09:56.000000Z","updated_at":"2026-02-03T10:03:04.000000Z"},{"id":18226857,"change_date":"2026-01-23 21:39:00","inspection_id":"86876967","insp_unit_id":"211265021","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"84905","insp_unit_license":"185B678","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3M9KS4022LL084905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:09:56.000000Z","updated_at":"2026-02-03T10:03:04.000000Z"}]},{"id":10862416,"change_date":"2026-01-26 21:37:00","inspection_id":"86892071","dot_number":"3846413","report_state":"TX","report_number":"V262188187","insp_date":"2026-01-19 00:00:00","insp_start_time":"2135","insp_end_time":"2217","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5880  US83","county_code_state":"TX","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SIGNAL PEAK SILICA OF CARRIZO","shipping_paper_number":"SCS26167534","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9830066","transaction_code":"A","transaction_date":"2026-01-26 00:00:00","upload_date":"2026-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-01-26 21:37:00","snet_input_date":"2026-01-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-26 21:37:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-01-29T10:36:08.000000Z","updated_at":"2026-02-06T10:30:29.000000Z","inspection_violations":[{"id":18173506,"change_date":"2026-01-26 21:37:00","inspection_id":"86892071","insp_violation_id":"271433819","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211296236","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-29T10:41:24.000000Z","updated_at":"2026-02-06T10:36:20.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18252995,"change_date":"2026-01-26 21:37:00","inspection_id":"86892071","insp_unit_id":"211296236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"MX2221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6CK17PX35551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-29T10:07:39.000000Z","updated_at":"2026-02-06T10:02:50.000000Z"},{"id":18252996,"change_date":"2026-01-26 21:37:00","inspection_id":"86892071","insp_unit_id":"211296237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"414","insp_unit_license":"AW7039","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4025KL084623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-29T10:07:39.000000Z","updated_at":"2026-02-06T10:02:50.000000Z"}]},{"id":10182154,"change_date":"2025-11-12 21:41:00","inspection_id":"86302060","dot_number":"3846413","report_state":"TX","report_number":"V252099075","insp_date":"2025-11-05 00:00:00","insp_start_time":"0935","insp_end_time":"1008","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1215  TX18","county_code_state":"TX","county_code":"495","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VISTA PROPPANTS","shipping_paper_number":"251105052","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9755821","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-11-15T10:30:53.000000Z","updated_at":"2025-11-16T10:31:20.000000Z","inspection_violations":[{"id":16914276,"change_date":"2025-11-12 21:41:00","inspection_id":"86302060","insp_violation_id":"269909131","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"209987728","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-15T10:31:22.000000Z","updated_at":"2025-11-16T10:32:43.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":16958705,"change_date":"2025-11-12 21:41:00","inspection_id":"86302060","insp_unit_id":"209987728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"MX2221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJA6CK17PX35551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:44.000000Z","updated_at":"2025-11-16T10:01:50.000000Z"},{"id":16958706,"change_date":"2025-11-12 21:41:00","inspection_id":"86302060","insp_unit_id":"209987729","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXI","insp_unit_company":"13976888","insp_unit_license":"DQ8403","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3M9KS4023RL084470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:44.000000Z","updated_at":"2025-11-16T10:01:50.000000Z"}]},{"id":9869176,"change_date":"2025-12-23 21:39:00","inspection_id":"85972105","dot_number":"3846413","report_state":"TX","report_number":"V252037601","insp_date":"2025-10-02 00:00:00","insp_start_time":"0500","insp_end_time":"0520","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A401","location_desc":"IH35 SB SAN MARCOS SCALE","county_code_state":"TX","county_code":"209","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GUERRA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9715922","transaction_code":"C","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-10-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-10-09T10:00:57.000000Z","updated_at":"2026-01-03T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17596815,"change_date":"2025-12-23 21:39:00","inspection_id":"85972105","insp_unit_id":"210784623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"6","insp_unit_license":"LR3667","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDZAPR0LN099195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:32.000000Z","updated_at":"2026-01-03T10:00:53.000000Z"}]},{"id":9708908,"change_date":"2025-09-17 21:41:00","inspection_id":"85804153","dot_number":"3846413","report_state":"TX","report_number":"V252016027","insp_date":"2025-09-16 00:00:00","insp_start_time":"1044","insp_end_time":"1117","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 302 WESTBOUND TUR","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COVIA","shipping_paper_number":"507343","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":"2025-09-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9699459","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2025-09-17 21:41:00","snet_input_date":"2025-09-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-17 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-09-23T10:01:51.000000Z","updated_at":"2025-09-23T10:01:51.000000Z","inspection_violations":[{"id":15934739,"change_date":"2025-09-17 21:41:00","inspection_id":"85804153","insp_violation_id":"268761743","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"209006585","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:33.000000Z","updated_at":"2025-09-22T10:16:53.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16073644,"change_date":"2025-09-17 21:41:00","inspection_id":"85804153","insp_unit_id":"209006585","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"FV4108","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYAP9X0EJ386854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:51.000000Z","updated_at":"2025-09-21T09:45:39.000000Z"},{"id":16073645,"change_date":"2025-09-17 21:41:00","inspection_id":"85804153","insp_unit_id":"209006586","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":"14000471","insp_unit_license":"DQ8439","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TDH39029RB180838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:51.000000Z","updated_at":"2025-09-21T09:45:39.000000Z"}]},{"id":8922216,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","dot_number":"3846413","report_state":"TX","report_number":"766E9DUE1X","insp_date":"2025-06-12 00:00:00","insp_start_time":"1403","insp_end_time":"1511","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0385 IN ECTOR CO. (338-370)","county_code_state":"TX","county_code":"135","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"OXY","shipping_paper_number":"7517035","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-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"76684","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9608748","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"915 PINECREST DR","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-06-20T10:00:58.000000Z","updated_at":"2025-06-22T10:00:45.000000Z","inspection_violations":[{"id":14313081,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895856","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207431444","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"39378"},{"id":14313082,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895857","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207431444","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"39378"},{"id":14313083,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895858","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207431444","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"3939"},{"id":14313084,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895859","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207431444","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"39395A"},{"id":14313085,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895860","seq_no":"5","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"3928"},{"id":14313086,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895861","seq_no":"6","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"207431444","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"3963A1B"},{"id":14313087,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_violation_id":"266895862","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207431444","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:43.000000Z","updated_at":"2025-06-21T10:17:53.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14620736,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_unit_id":"207431444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"777","insp_unit_license":"50588","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYAP9X0EJ386854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:07.000000Z","updated_at":"2025-06-22T09:46:01.000000Z"},{"id":14620737,"change_date":"2025-06-17 21:41:00","inspection_id":"84976405","insp_unit_id":"207431445","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"13657033","insp_unit_license":"CF8025","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1S95C4327KG724884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:07.000000Z","updated_at":"2025-06-22T09:46:01.000000Z"}]},{"id":8704204,"change_date":"2025-05-21 21:42:00","inspection_id":"84745270","dot_number":"3846413","report_state":"TX","report_number":"V251869884","insp_date":"2025-05-16 00:00:00","insp_start_time":"1324","insp_end_time":"1353","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US87 SB AT FRAZIER R","county_code_state":"TX","county_code":"227","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GUERRA TRANSPORTATION","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-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9586324","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"915 PINECREST DR","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-05-24T10:04:31.000000Z","updated_at":"2025-05-25T10:07:00.000000Z","inspection_violations":[{"id":13874198,"change_date":"2025-05-21 21:42:00","inspection_id":"84745270","insp_violation_id":"266386939","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"206996474","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-24T10:28:25.000000Z","updated_at":"2025-05-25T10:26:27.000000Z","normalized_code":"39345"},{"id":13874199,"change_date":"2025-05-21 21:42:00","inspection_id":"84745270","insp_violation_id":"266386940","seq_no":"2","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"206996475","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:25.000000Z","updated_at":"2025-05-25T10:26:27.000000Z","normalized_code":"39375A1"},{"id":13874200,"change_date":"2025-05-21 21:42:00","inspection_id":"84745270","insp_violation_id":"266386941","seq_no":"3","part_no":"396","part_no_section":"3A1BL","insp_viol_unit":"1","insp_unit_id":"206996474","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-24T10:28:25.000000Z","updated_at":"2025-05-25T10:26:27.000000Z","normalized_code":"3963A1BL"}],"inspection_per_units":[{"id":14223841,"change_date":"2025-05-21 21:42:00","inspection_id":"84745270","insp_unit_id":"206996474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"18","insp_unit_license":"FS5532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR9FN530600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:55.000000Z","updated_at":"2025-05-25T09:52:47.000000Z"},{"id":14223842,"change_date":"2025-05-21 21:42:00","inspection_id":"84745270","insp_unit_id":"206996475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"1803","insp_unit_license":"CE5122","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M91H432XJA211300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:55.000000Z","updated_at":"2025-05-25T09:52:47.000000Z"}]},{"id":11978416,"change_date":"2026-05-20 21:41:00","inspection_id":"87915573","dot_number":"3846413","report_state":"TX","report_number":"V251592833","insp_date":"2025-05-13 00:00:00","insp_start_time":"0945","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX349","county_code_state":"TX","county_code":"317","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GUERRA TRANSPORTATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9962585","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2026-05-20 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"130 HIGHWAY STREET APT 4","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2026-05-23T09:43:04.000000Z","updated_at":"2026-06-01T09:31:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20825243,"change_date":"2026-05-20 21:41:00","inspection_id":"87915573","insp_unit_id":"213674879","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"09","insp_unit_license":"7812F16","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR0LN099195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:44.000000Z","updated_at":"2026-06-01T09:04:07.000000Z"},{"id":20825244,"change_date":"2026-05-20 21:41:00","inspection_id":"87915573","insp_unit_id":"213674880","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TIMP","insp_unit_company":"14041536","insp_unit_license":"BW8968","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1TDH39028RB182466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:44.000000Z","updated_at":"2026-06-01T09:04:07.000000Z"}]},{"id":7728022,"change_date":"2025-01-28 21:39:00","inspection_id":"83718084","dot_number":"3846413","report_state":"TX","report_number":"V251750278","insp_date":"2025-01-23 00:00:00","insp_start_time":"1438","insp_end_time":"1506","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 349  MM 285","county_code_state":"TX","county_code":"461","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALPINE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"9485746","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":"03846413","upload_search_indicator":"M","census_search_date":"2025-01-28 21:39:00","snet_input_date":"2025-01-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-28 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"915 PINECREST DR","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-03-17T20:58:41.000000Z","updated_at":"2025-03-17T20:58:41.000000Z","inspection_violations":[{"id":12075457,"change_date":"2025-01-28 21:39:00","inspection_id":"83718084","insp_violation_id":"264216928","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205044132","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":"39311TL"},{"id":12075458,"change_date":"2025-01-28 21:39:00","inspection_id":"83718084","insp_violation_id":"264216929","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"205044133","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":"3939"},{"id":12075459,"change_date":"2025-01-28 21:39:00","inspection_id":"83718084","insp_violation_id":"264216930","seq_no":"3","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205044132","insp_violation_category_id":"30","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":"3963A1"}],"inspection_per_units":[{"id":12470892,"change_date":"2025-01-28 21:39:00","inspection_id":"83718084","insp_unit_id":"205044132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"180","insp_unit_license":"FS5532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR9FN530600","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":12470893,"change_date":"2025-01-28 21:39:00","inspection_id":"83718084","insp_unit_id":"205044133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"13022508","insp_unit_license":"CD4148","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M91H4327JA211321","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":5064570,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","dot_number":"3846413","report_state":"TX","report_number":"6SD89DBFY0","insp_date":"2024-02-01 00:00:00","insp_start_time":"0746","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  CLINTON DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CEMENT COMPANY","shipping_paper_number":"720742675","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-02-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"123820","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":"9197637","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2024-02-15 21:43:00","snet_input_date":"2024-02-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-15 21:43:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"915 PINECREST DR","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-03-17T20:03:04.000000Z","updated_at":"2025-03-17T20:03:04.000000Z","inspection_violations":[{"id":7806537,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","insp_violation_id":"257870056","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199451243","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"3939A"},{"id":7806538,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","insp_violation_id":"257870057","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199451244","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"3939A"},{"id":7806539,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","insp_violation_id":"257870058","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199451243","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"3965B"},{"id":7806540,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","insp_violation_id":"257870059","seq_no":"4","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"199451243","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"39355C1"}],"inspection_per_units":[{"id":8152754,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","insp_unit_id":"199451243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"FS5532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR9FN530600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"},{"id":8152755,"change_date":"2024-02-15 21:43:00","inspection_id":"80863957","insp_unit_id":"199451244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"159B150","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKP04224BW023701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"}]},{"id":1964597,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","dot_number":"3846413","report_state":"TX","report_number":"6GTA0HYWP8","insp_date":"2022-12-12 00:00:00","insp_start_time":"1005","insp_end_time":"1038","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0464 IN WARD CO. (346-352)","county_code_state":"TX","county_code":"475","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COVIA","shipping_paper_number":"22481463","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8853187","transaction_code":"A","transaction_date":"2022-12-16 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2022-12-16 21:40:00","snet_input_date":"2022-12-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"5810 FONTENELL DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-03-17T19:02:55.000000Z","updated_at":"2025-03-17T19:02:55.000000Z","inspection_violations":[{"id":3051527,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250145999","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"39141A"},{"id":3051528,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146000","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3963A1"},{"id":3051529,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146001","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3965B"},{"id":3051530,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146002","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"39311"},{"id":3051531,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146003","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"39311"},{"id":3051532,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146004","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3939A"},{"id":3051533,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146005","seq_no":"7","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"39319"},{"id":3051534,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_violation_id":"250146006","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192468102","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3161119,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_unit_id":"192468102","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"18","insp_unit_license":"FS5532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR9FN530600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:39.000000Z","updated_at":"2025-03-17T22:28:39.000000Z"},{"id":3161120,"change_date":"2022-12-16 21:40:00","inspection_id":"77391815","insp_unit_id":"192468103","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"HULK II","insp_unit_license":"AQ5166","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3E9G148H9PT034044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:39.000000Z","updated_at":"2025-03-17T22:28:39.000000Z"}]},{"id":723193,"change_date":"2022-07-20 21:41:00","inspection_id":"75953943","dot_number":"3846413","report_state":"TX","report_number":"6C0E0AGAAI","insp_date":"2022-06-22 00:00:00","insp_start_time":"1424","insp_end_time":"1456","registration_date":"2022-07-20 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0302 IN WINKLER CO. (210-24","county_code_state":"TX","county_code":"495","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"8698858","transaction_code":"C","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03846413","upload_search_indicator":"M","census_search_date":"2022-06-29 21:42:00","snet_input_date":"2022-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-29 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"915 PINECREST DR","insp_carrier_city":"STORM LAKE","insp_carrier_state":"IA","insp_carrier_zip_code":"50588","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1030832","created_at":"2025-03-17T18:40:30.000000Z","updated_at":"2025-03-17T18:40:30.000000Z","inspection_violations":[{"id":1138891,"change_date":"2022-07-20 21:41:00","inspection_id":"75953943","insp_violation_id":"247215686","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189881676","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:18.000000Z","updated_at":"2025-03-17T21:12:18.000000Z","normalized_code":"3939A"},{"id":1138892,"change_date":"2022-07-20 21:41:00","inspection_id":"75953943","insp_violation_id":"247215687","seq_no":"2","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"189881676","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:18.000000Z","updated_at":"2025-03-17T21:12:18.000000Z","normalized_code":"39375A1"},{"id":1138893,"change_date":"2022-07-20 21:41:00","inspection_id":"75953943","insp_violation_id":"247215688","seq_no":"3","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"189881676","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:18.000000Z","updated_at":"2025-03-17T21:12:18.000000Z","normalized_code":"393203"}],"inspection_per_units":[{"id":1162488,"change_date":"2022-07-20 21:41:00","inspection_id":"75953943","insp_unit_id":"189881676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"BOER","insp_unit_company":"18","insp_unit_license":"FS5532","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDJAPR9FN530600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:20.000000Z","updated_at":"2025-03-17T22:15:20.000000Z"},{"id":1162489,"change_date":"2022-07-20 21:41:00","inspection_id":"75953943","insp_unit_id":"189881677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"13119749","insp_unit_license":"AJ9925","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M91H432XKA211377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:20.000000Z","updated_at":"2025-03-17T22:15:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3846413\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3846413\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3846413\/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\/3846413\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}