{"current_page":1,"data":[{"id":7712360,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","dot_number":"2440106","report_state":"US","report_number":"1229001476","insp_date":"2025-01-23 00:00:00","insp_start_time":"1905","insp_end_time":"1946","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LA REALIDAD FABOSCH SA DE CV","shipping_paper_number":"PAMOAE370418988","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"5","oos_total":"5","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1291860","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":"02440106","upload_search_indicator":null,"census_search_date":"2025-01-27 21:39:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-27 21:39:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:19.000000Z","updated_at":"2025-03-17T20:58:19.000000Z","inspection_violations":[{"id":12049760,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_violation_id":"264181588","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205012631","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"39375A3TAOL"},{"id":12049761,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_violation_id":"264181589","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"205012632","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"39375A3TAOL"},{"id":12049762,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_violation_id":"264181590","seq_no":"3","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"205012632","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"3939ALSLIWR"},{"id":12049763,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_violation_id":"264181591","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205012631","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"39375A3TAOL"},{"id":12049764,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_violation_id":"264181592","seq_no":"5","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":12445644,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_unit_id":"205012631","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"03","insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:21.000000Z","updated_at":"2025-03-17T23:52:21.000000Z"},{"id":12445645,"change_date":"2025-01-27 21:39:00","inspection_id":"83701687","insp_unit_id":"205012632","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"MP06","insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:21.000000Z","updated_at":"2025-03-17T23:52:21.000000Z"}]},{"id":6354663,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","dot_number":"2440106","report_state":"US","report_number":"1476000636","insp_date":"2024-07-26 00:00:00","insp_start_time":"1031","insp_end_time":"1122","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2024-07-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"705675","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2024-07-31 21:42:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-31 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:43.000000Z","updated_at":"2025-03-17T20:28:43.000000Z","inspection_violations":[{"id":9866599,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","insp_violation_id":"260936807","seq_no":"1","part_no":"386","part_no_section":"83(a)(1)","insp_viol_unit":"1","insp_unit_id":"202162483","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"38683A1"},{"id":9866600,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","insp_violation_id":"260936808","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202162484","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3939A"},{"id":9866601,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","insp_violation_id":"260936809","seq_no":"3","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"202162483","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"39378A"},{"id":9866602,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","insp_violation_id":"260936810","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202162483","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:44.000000Z","updated_at":"2025-03-17T21:53:44.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10240661,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","insp_unit_id":"202162483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"03","insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:06.000000Z","updated_at":"2025-03-17T23:29:06.000000Z"},{"id":10240662,"change_date":"2024-07-31 21:42:00","inspection_id":"82263337","insp_unit_id":"202162484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:06.000000Z","updated_at":"2025-03-17T23:29:06.000000Z"}]},{"id":6160566,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","dot_number":"2440106","report_state":"US","report_number":"1229000987","insp_date":"2024-06-24 00:00:00","insp_start_time":"1315","insp_end_time":"1434","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"634607","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2024-07-08 21:42:00","snet_input_date":"2024-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:57.000000Z","updated_at":"2025-03-17T20:24:57.000000Z","inspection_violations":[{"id":9562228,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_violation_id":"260498734","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201762784","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39378A"},{"id":9562229,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_violation_id":"260498735","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201762784","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39345B2"},{"id":9562230,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_violation_id":"260498736","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201762784","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3963A1"},{"id":9562231,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_violation_id":"260498737","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201762784","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39353B"},{"id":9562232,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_violation_id":"260498738","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201762784","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39347E"},{"id":9562233,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_violation_id":"260498739","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201762784","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9923928,"change_date":"2024-07-08 21:42:00","inspection_id":"82055222","insp_unit_id":"201762784","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"03","insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:51.000000Z","updated_at":"2025-03-17T23:25:51.000000Z"}]},{"id":5696031,"change_date":"2024-05-08 21:41:00","inspection_id":"81552573","dot_number":"2440106","report_state":"US","report_number":"0993000726","insp_date":"2024-05-07 00:00:00","insp_start_time":"1033","insp_end_time":"1110","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2024-05-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"4","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":"464879","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2024-05-08 21:41:00","snet_input_date":"2024-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-08 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:31.000000Z","updated_at":"2025-03-17T20:15:31.000000Z","inspection_violations":[{"id":8811173,"change_date":"2024-05-08 21:41:00","inspection_id":"81552573","insp_violation_id":"259376230","seq_no":"1","part_no":"393","part_no_section":"43(b)","insp_viol_unit":"1","insp_unit_id":"200783335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39343B"},{"id":8811174,"change_date":"2024-05-08 21:41:00","inspection_id":"81552573","insp_violation_id":"259376231","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200783335","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3963A1"},{"id":8811175,"change_date":"2024-05-08 21:41:00","inspection_id":"81552573","insp_violation_id":"259376232","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200783335","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3965B"},{"id":8811176,"change_date":"2024-05-08 21:41:00","inspection_id":"81552573","insp_violation_id":"259376233","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"200783335","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9174380,"change_date":"2024-05-08 21:41:00","inspection_id":"81552573","insp_unit_id":"200783335","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"03","insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:22.000000Z","updated_at":"2025-03-17T23:18:22.000000Z"}]},{"id":5628927,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","dot_number":"2440106","report_state":"AZ","report_number":"XB69700111","insp_date":"2024-04-24 00:00:00","insp_start_time":"1516","insp_end_time":"1626","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS PORT OF ENTRY II","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LA REALIDAD FABOSCH SA DE CV","shipping_paper_number":"370404434","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":"U","pen_cen_match":"I","final_status_date":"2024-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"440769","transaction_code":"C","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:17.000000Z","updated_at":"2025-03-17T20:14:17.000000Z","inspection_violations":[{"id":8703247,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326927","seq_no":"1","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200736788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39353B"},{"id":8703248,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326928","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200736789","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39347E"},{"id":8703249,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326929","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200736788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39345D"},{"id":8703250,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326930","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200736789","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39353B"},{"id":8703251,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326931","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200736789","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3963A1"},{"id":8703252,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326932","seq_no":"6","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"200736788","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39378A"},{"id":8703253,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326933","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200736788","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39348A"},{"id":8703254,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_violation_id":"259326934","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200736789","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":9067047,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_unit_id":"200736788","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"03","insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:22.000000Z","updated_at":"2025-03-17T23:17:22.000000Z"},{"id":9067048,"change_date":"2024-05-06 21:43:00","inspection_id":"81479575","insp_unit_id":"200736789","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREWER UTI","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:22.000000Z","updated_at":"2025-03-17T23:17:22.000000Z"}]},{"id":5503605,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","dot_number":"2440106","report_state":"AZ","report_number":"XE83340086","insp_date":"2024-04-08 00:00:00","insp_start_time":"1050","insp_end_time":"1211","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAMPO AGRICOLA ESCALANTE FIGUEROA SA DE RL","shipping_paper_number":"26407994800","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":"U","pen_cen_match":"I","final_status_date":"2024-04-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"5","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":"394486","transaction_code":"C","transaction_date":"2024-04-14 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2024-04-14 21:33:00","snet_input_date":"2024-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-14 21:33:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:54.000000Z","updated_at":"2025-03-17T20:11:54.000000Z","inspection_violations":[{"id":8502233,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_violation_id":"259051366","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"200501840","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"39378A"},{"id":8502234,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_violation_id":"259051367","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200501841","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"39355E"},{"id":8502235,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_violation_id":"259051368","seq_no":"3","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"2","insp_unit_id":"200501841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"39311A1"},{"id":8502236,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_violation_id":"259051369","seq_no":"4","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"200501840","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"393207F"},{"id":8502237,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_violation_id":"259051370","seq_no":"5","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"200501840","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:13.000000Z","updated_at":"2025-03-17T21:47:13.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":8865295,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_unit_id":"200501840","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"03","insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:29.000000Z","updated_at":"2025-03-17T23:15:29.000000Z"},{"id":8865296,"change_date":"2024-04-22 21:40:00","inspection_id":"81342932","insp_unit_id":"200501841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"210","insp_unit_license":"35570A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1JJV532W6XL609796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:29.000000Z","updated_at":"2025-03-17T23:15:29.000000Z"}]},{"id":5315554,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","dot_number":"2440106","report_state":"AZ","report_number":"XB69700049","insp_date":"2024-03-13 00:00:00","insp_start_time":"1329","insp_end_time":"1426","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SARAH FARMS","shipping_paper_number":"3619","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":"U","pen_cen_match":"I","final_status_date":"2024-03-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"327265","transaction_code":"C","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2024-03-19 21:44:00","snet_input_date":"2024-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-19 21:44:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:55.000000Z","updated_at":"2025-03-17T20:07:55.000000Z","inspection_violations":[{"id":8201474,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508373","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"200020595","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39345DB"},{"id":8201475,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508374","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"200020596","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939ALIL"},{"id":8201476,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508375","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"200020596","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939ALLPL"},{"id":8201477,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508376","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"200020596","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939ALRLI"},{"id":8201478,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508377","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"200020595","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39378AWS"},{"id":8201479,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508378","seq_no":"6","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"200020596","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39375A3TAOL"},{"id":8201480,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_violation_id":"258508379","seq_no":"7","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"200020596","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":8560966,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_unit_id":"200020595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"},{"id":8560967,"change_date":"2024-03-21 21:40:00","inspection_id":"81137694","insp_unit_id":"200020596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"R36820","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1PT011NH3N9001146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"}]},{"id":4524790,"change_date":"2023-11-30 21:38:00","inspection_id":"80273115","dot_number":"2440106","report_state":"US","report_number":"1229000499","insp_date":"2023-11-29 00:00:00","insp_start_time":"1435","insp_end_time":"1518","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SQUARE ONE FARMS LLC","shipping_paper_number":"PAMONDH00268952","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"3","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":"112092","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:33.000000Z","updated_at":"2025-03-17T19:52:33.000000Z","inspection_violations":[{"id":7002109,"change_date":"2023-11-30 21:38:00","inspection_id":"80273115","insp_violation_id":"256634130","seq_no":"1","part_no":"393","part_no_section":"28-WS","insp_viol_unit":"2","insp_unit_id":"198277418","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"39328WS"},{"id":7002110,"change_date":"2023-11-30 21:38:00","inspection_id":"80273115","insp_violation_id":"256634131","seq_no":"2","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"2","insp_unit_id":"198277418","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"39345B2B"},{"id":7002111,"change_date":"2023-11-30 21:38:00","inspection_id":"80273115","insp_violation_id":"256634132","seq_no":"3","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"198277417","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:47.000000Z","updated_at":"2025-03-17T21:39:47.000000Z","normalized_code":"3963A1ALBV"}],"inspection_per_units":[{"id":7277103,"change_date":"2023-11-30 21:38:00","inspection_id":"80273115","insp_unit_id":"198277417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"},{"id":7277104,"change_date":"2023-11-30 21:38:00","inspection_id":"80273115","insp_unit_id":"198277418","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"MP06","insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"}]},{"id":4356976,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","dot_number":"2440106","report_state":"US","report_number":"1476000213","insp_date":"2023-10-27 00:00:00","insp_start_time":"0952","insp_end_time":"1034","registration_date":null,"region":"PD","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-11-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"5","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":"87415","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-11-06 21:41:00","snet_input_date":"2023-10-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-06 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:09.000000Z","updated_at":"2025-03-17T19:49:09.000000Z","inspection_violations":[{"id":6740380,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","insp_violation_id":"256225122","seq_no":"1","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"197911918","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":6740381,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","insp_violation_id":"256225123","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197911918","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"39378"},{"id":6740382,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","insp_violation_id":"256225124","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"197911918","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"39378AWS"},{"id":6740383,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","insp_violation_id":"256225125","seq_no":"4","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"197911918","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3965BL"},{"id":6740384,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","insp_violation_id":"256225126","seq_no":"5","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"197911918","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3963A1ALBV"}],"inspection_per_units":[{"id":7007234,"change_date":"2023-11-06 21:41:00","inspection_id":"80088004","insp_unit_id":"197911918","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:49.000000Z","updated_at":"2025-03-17T22:58:49.000000Z"}]},{"id":4298163,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","dot_number":"2440106","report_state":"US","report_number":"0993000370","insp_date":"2023-10-26 00:00:00","insp_start_time":"1412","insp_end_time":"1513","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"78556","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-10-27 21:42:00","snet_input_date":"2023-10-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-27 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:55.000000Z","updated_at":"2025-03-17T19:47:55.000000Z","inspection_violations":[{"id":6649662,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078268","seq_no":"1","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"393201AFRCLS"},{"id":6649663,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078269","seq_no":"2","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":6649664,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078270","seq_no":"3","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"197776110","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":6649665,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078271","seq_no":"4","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"197776110","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39343BBATV"},{"id":6649666,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078272","seq_no":"5","part_no":"393","part_no_section":"43E-BBST","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39343EBBST"},{"id":6649667,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078273","seq_no":"6","part_no":"393","part_no_section":"47A-BCFSBD","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39347ABCFSBD"},{"id":6649668,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078274","seq_no":"7","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39348ABMBCBD"},{"id":6649669,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078275","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":6649670,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078276","seq_no":"9","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197776110","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39378"},{"id":6649671,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078277","seq_no":"10","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"197776110","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"39378AWS"},{"id":6649672,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078278","seq_no":"11","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3939ALHWS"},{"id":6649673,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_violation_id":"256078279","seq_no":"12","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"197776111","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:01.000000Z","updated_at":"2025-03-17T21:38:01.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":6912748,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_unit_id":"197776110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:58.000000Z","updated_at":"2025-03-17T22:57:58.000000Z"},{"id":6912749,"change_date":"2023-10-27 21:42:00","inspection_id":"80023178","insp_unit_id":"197776111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"54994A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25315U601417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:58.000000Z","updated_at":"2025-03-17T22:57:58.000000Z"}]},{"id":4109499,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","dot_number":"2440106","report_state":"US","report_number":"0993000302","insp_date":"2023-09-29 00:00:00","insp_start_time":"1105","insp_end_time":"1142","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUIS AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"62003","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-09-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[{"id":6358992,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614257","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"197360390","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"3963A1BOS"},{"id":6358993,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614258","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197360390","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39347E"},{"id":6358994,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614259","seq_no":"3","part_no":"393","part_no_section":"75A2-TAOBB","insp_viol_unit":"1","insp_unit_id":"197360389","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39375A2TAOBB"},{"id":6358995,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614260","seq_no":"4","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"197360389","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39343BBATV"},{"id":6358996,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614261","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197360389","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39378"},{"id":6358997,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614262","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197360390","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39347E"},{"id":6358998,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614263","seq_no":"7","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"197360389","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"3965BL"},{"id":6358999,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614264","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"197360390","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":6359000,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614265","seq_no":"9","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"197360390","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":6359001,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_violation_id":"255614266","seq_no":"10","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"197360390","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:38.000000Z","updated_at":"2025-03-17T21:36:38.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":6607553,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_unit_id":"197360389","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XPAD49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"},{"id":6607554,"change_date":"2023-10-03 21:40:00","inspection_id":"79814597","insp_unit_id":"197360390","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3980062,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","dot_number":"2440106","report_state":"US","report_number":"0993000264","insp_date":"2023-09-11 00:00:00","insp_start_time":"0943","insp_end_time":"1026","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSLUS","location_desc":"SAN LUISAZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"U","pen_cen_match":"I","final_status_date":"2023-09-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"54085","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-09-15 21:39:00","snet_input_date":"2023-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-15 21:39:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:35.000000Z","updated_at":"2025-03-17T19:41:35.000000Z","inspection_violations":[{"id":6155393,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_violation_id":"255285453","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197070325","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39360C"},{"id":6155394,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_violation_id":"255285454","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"197070325","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39378AWS"},{"id":6155395,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_violation_id":"255285455","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"197070325","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3939ALHLI"},{"id":6155396,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_violation_id":"255285456","seq_no":"4","part_no":"393","part_no_section":"75A2-TAOBB","insp_viol_unit":"1","insp_unit_id":"197070325","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39375A2TAOBB"},{"id":6155397,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_violation_id":"255285457","seq_no":"5","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"197070326","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39355C2"},{"id":6155398,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_violation_id":"255285458","seq_no":"6","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"2","insp_unit_id":"197070326","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"393201AFRCLS"}],"inspection_per_units":[{"id":6399886,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_unit_id":"197070325","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:44.000000Z","updated_at":"2025-03-17T22:53:44.000000Z"},{"id":6399887,"change_date":"2023-09-15 21:39:00","inspection_id":"79670586","insp_unit_id":"197070326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"63309E","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25305U414296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:44.000000Z","updated_at":"2025-03-17T22:53:44.000000Z"}]},{"id":3642625,"change_date":"2023-08-01 21:42:00","inspection_id":"79294134","dot_number":"2440106","report_state":"AZ","report_number":"0YEV002942","insp_date":"2023-07-31 00:00:00","insp_start_time":"1520","insp_end_time":"1551","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"26407914345","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":"I","final_status_date":"2023-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"1827375","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-01 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"PO BOX 990 PMB 1462","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:54.000000Z","updated_at":"2025-03-17T19:34:54.000000Z","inspection_violations":[{"id":5616590,"change_date":"2023-08-01 21:42:00","inspection_id":"79294134","insp_violation_id":"254398409","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196301643","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"3939A"},{"id":5616591,"change_date":"2023-08-01 21:42:00","inspection_id":"79294134","insp_violation_id":"254398410","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196301643","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":5856918,"change_date":"2023-08-01 21:42:00","inspection_id":"79294134","insp_unit_id":"196301643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:15.000000Z","updated_at":"2025-03-17T22:49:15.000000Z"},{"id":5856919,"change_date":"2023-08-01 21:42:00","inspection_id":"79294134","insp_unit_id":"196301644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"63309E","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25305U414296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:15.000000Z","updated_at":"2025-03-17T22:49:15.000000Z"}]},{"id":3474401,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","dot_number":"2440106","report_state":"US","report_number":"1229000180","insp_date":"2023-07-10 00:00:00","insp_start_time":"1227","insp_end_time":"1328","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"SAN LUISAZ","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"PAMO26407910251","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"29709","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-07-11 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-11 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:43.000000Z","updated_at":"2025-03-17T19:31:43.000000Z","inspection_violations":[{"id":5356789,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","insp_violation_id":"253974432","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"195922974","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1BALAC"},{"id":5356790,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","insp_violation_id":"253974433","seq_no":"2","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"195922974","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1BALAC"},{"id":5356791,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","insp_violation_id":"253974434","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"195922974","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1BOS"},{"id":5356792,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","insp_violation_id":"253974435","seq_no":"4","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"195922974","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1BALR"}],"inspection_per_units":[{"id":5586889,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","insp_unit_id":"195922974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:06.000000Z","updated_at":"2025-03-17T22:47:06.000000Z"},{"id":5586890,"change_date":"2023-07-11 21:41:00","inspection_id":"79105485","insp_unit_id":"195922975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:06.000000Z","updated_at":"2025-03-17T22:47:06.000000Z"}]},{"id":3381324,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","dot_number":"2440106","report_state":"US","report_number":"1229000144","insp_date":"2023-06-26 00:00:00","insp_start_time":"1314","insp_end_time":"1341","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"SAN LUISAZ","county_code_state":"AZ","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"PAMO26407907984","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"26773","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:07.000000Z","updated_at":"2025-03-17T19:30:07.000000Z","inspection_violations":[{"id":5213776,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_violation_id":"253739847","seq_no":"1","part_no":"393","part_no_section":"207B-AALPME-OOS","insp_viol_unit":"2","insp_unit_id":"195710496","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"393207BAALPMEOOS"},{"id":5213777,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_violation_id":"253739848","seq_no":"2","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"2","insp_unit_id":"195710496","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39367C7VF"},{"id":5213778,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_violation_id":"253739849","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"195710496","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39375A3TAOL"},{"id":5213779,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_violation_id":"253739850","seq_no":"4","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"195710496","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3939ALTSI"},{"id":5213780,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_violation_id":"253739851","seq_no":"5","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"195710496","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":5435999,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_unit_id":"195710495","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:54.000000Z","updated_at":"2025-03-17T22:45:54.000000Z"},{"id":5436000,"change_date":"2023-06-28 21:42:00","inspection_id":"79000708","insp_unit_id":"195710496","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:54.000000Z","updated_at":"2025-03-17T22:45:54.000000Z"}]},{"id":2956408,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","dot_number":"2440106","report_state":"AZ","report_number":"OY4U000721","insp_date":"2023-05-02 00:00:00","insp_start_time":"1440","insp_end_time":"1546","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"26407898159","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":"I","final_status_date":"2023-05-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1812099","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-03 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"PO BOX 990 PMB 1462","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[{"id":4538195,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_violation_id":"252601105","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194730445","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39360C"},{"id":4538196,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_violation_id":"252601106","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194730445","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39395A"},{"id":4538197,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_violation_id":"252601107","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194730445","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"3939A"},{"id":4538198,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_violation_id":"252601108","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194730445","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39378"},{"id":4538199,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_violation_id":"252601109","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194730445","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39345D"},{"id":4538200,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_violation_id":"252601110","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194730446","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:07.000000Z","updated_at":"2025-03-17T21:28:07.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":4757204,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_unit_id":"194730445","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"},{"id":4757205,"change_date":"2023-05-03 21:42:00","inspection_id":"78521249","insp_unit_id":"194730446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"}]},{"id":2834030,"change_date":"2023-04-18 21:42:00","inspection_id":"78382779","dot_number":"2440106","report_state":"CA","report_number":"NDGS007418","insp_date":"2023-04-14 00:00:00","insp_start_time":"1600","insp_end_time":"1615","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LA PATRONA","shipping_paper_number":"00069834","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":"N","pen_cen_match":null,"final_status_date":"2023-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"588350","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":"14862432","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:56.000000Z","updated_at":"2025-03-17T19:18:56.000000Z","inspection_violations":[{"id":4348449,"change_date":"2023-04-18 21:42:00","inspection_id":"78382779","insp_violation_id":"252298387","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194458965","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4561789,"change_date":"2023-04-18 21:42:00","inspection_id":"78382779","insp_unit_id":"194458965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT#02","insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"},{"id":4561790,"change_date":"2023-04-18 21:42:00","inspection_id":"78382779","insp_unit_id":"194458966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT#MP08","insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"}]},{"id":2927126,"change_date":"2023-05-01 10:45:00","inspection_id":"78488282","dot_number":"2440106","report_state":"US","report_number":"0993022573","insp_date":"2023-04-03 00:00:00","insp_start_time":"1222","insp_end_time":"1314","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO","shipping_paper_number":"PAMO264-0788894","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-01 10:45:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"435857","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-28 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-05-01 10:45:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:54.000000Z","updated_at":"2025-03-17T19:20:54.000000Z","inspection_violations":[{"id":4493442,"change_date":"2023-05-01 10:45:00","inspection_id":"78488282","insp_violation_id":"252527354","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194663572","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39378"},{"id":4493443,"change_date":"2023-05-01 10:45:00","inspection_id":"78488282","insp_violation_id":"252527355","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194663573","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4709511,"change_date":"2023-05-01 10:45:00","inspection_id":"78488282","insp_unit_id":"194663572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"Y","insp_unit_decal_number":"32753817","created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"},{"id":4709512,"change_date":"2023-05-01 10:45:00","inspection_id":"78488282","insp_unit_id":"194663573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"}]},{"id":2604058,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","dot_number":"2440106","report_state":"US","report_number":"0993022556","insp_date":"2023-03-14 00:00:00","insp_start_time":"1121","insp_end_time":"1148","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"264-0787716-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"435126","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-17 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-03-17 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:49.000000Z","updated_at":"2025-03-17T19:14:49.000000Z","inspection_violations":[{"id":4006315,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","insp_violation_id":"251735061","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193936105","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39378"},{"id":4006316,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","insp_violation_id":"251735062","seq_no":"2","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"193936106","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39323"},{"id":4006317,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","insp_violation_id":"251735063","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193936106","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3939A"},{"id":4006318,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","insp_violation_id":"251735064","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193936106","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4191846,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","insp_unit_id":"193936105","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:03.000000Z","updated_at":"2025-03-17T22:36:03.000000Z"},{"id":4191847,"change_date":"2023-03-17 21:42:00","inspection_id":"78121498","insp_unit_id":"193936106","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:03.000000Z","updated_at":"2025-03-17T22:36:03.000000Z"}]},{"id":2544638,"change_date":"2023-03-09 21:42:00","inspection_id":"78053476","dot_number":"2440106","report_state":"US","report_number":"0993022547","insp_date":"2023-03-08 00:00:00","insp_start_time":"1624","insp_end_time":"1703","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"434807","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-09 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3913627,"change_date":"2023-03-09 21:42:00","inspection_id":"78053476","insp_violation_id":"251574270","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193794797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39360C"},{"id":3913628,"change_date":"2023-03-09 21:42:00","inspection_id":"78053476","insp_violation_id":"251574271","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193794797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39378"},{"id":3913629,"change_date":"2023-03-09 21:42:00","inspection_id":"78053476","insp_violation_id":"251574272","seq_no":"3","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"193794797","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"393209E"},{"id":3913630,"change_date":"2023-03-09 21:42:00","inspection_id":"78053476","insp_violation_id":"251574273","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193794797","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4095777,"change_date":"2023-03-09 21:42:00","inspection_id":"78053476","insp_unit_id":"193794797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:22.000000Z","updated_at":"2025-03-17T22:35:22.000000Z"}]},{"id":2414414,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","dot_number":"2440106","report_state":"US","report_number":"0993022501","insp_date":"2023-02-16 00:00:00","insp_start_time":"1236","insp_end_time":"1333","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO","shipping_paper_number":"264-078643-0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"434194","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-17 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:05.000000Z","updated_at":"2025-03-17T19:11:05.000000Z","inspection_violations":[{"id":3716498,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_violation_id":"251246753","seq_no":"1","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"193499019","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"393203"},{"id":3716499,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_violation_id":"251246754","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193499019","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"39378"},{"id":3716500,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_violation_id":"251246755","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193499019","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"39383G"},{"id":3716501,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_violation_id":"251246756","seq_no":"4","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"193499020","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"39375A2"},{"id":3716502,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_violation_id":"251246757","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193499020","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"3963A1"},{"id":3716503,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_violation_id":"251246758","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"193499020","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:30.000000Z","updated_at":"2025-03-17T21:24:30.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":3885303,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_unit_id":"193499019","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:50.000000Z","updated_at":"2025-03-17T22:33:50.000000Z"},{"id":3885304,"change_date":"2023-02-21 21:42:00","inspection_id":"77905644","insp_unit_id":"193499020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:50.000000Z","updated_at":"2025-03-17T22:33:50.000000Z"}]},{"id":2398260,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","dot_number":"2440106","report_state":"US","report_number":"1229021569","insp_date":"2023-02-15 00:00:00","insp_start_time":"1210","insp_end_time":"1240","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DE DESIERTO SA DE CV","shipping_paper_number":"PAMO2640786365","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"434166","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-16 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-02-17 21:39:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:46.000000Z","updated_at":"2025-03-17T19:10:46.000000Z","inspection_violations":[{"id":3692587,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","insp_violation_id":"251207612","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193463090","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"39378"},{"id":3692588,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","insp_violation_id":"251207613","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"193463090","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"393209E"},{"id":3692589,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","insp_violation_id":"251207614","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193463090","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"39345D"},{"id":3692590,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","insp_violation_id":"251207615","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193463091","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3859473,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","insp_unit_id":"193463090","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:38.000000Z","updated_at":"2025-03-17T22:33:38.000000Z"},{"id":3859474,"change_date":"2023-02-17 21:39:00","inspection_id":"77887019","insp_unit_id":"193463091","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:38.000000Z","updated_at":"2025-03-17T22:33:38.000000Z"}]},{"id":2296839,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","dot_number":"2440106","report_state":"AZ","report_number":"OY4U000631","insp_date":"2023-02-02 00:00:00","insp_start_time":"1416","insp_end_time":"1515","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"26407857221","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":"I","final_status_date":"2023-02-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1795693","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-03 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-02-03 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"PO BOX 990 PMB 1462","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:55.000000Z","updated_at":"2025-03-17T19:08:55.000000Z","inspection_violations":[{"id":3541257,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_violation_id":"250948800","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193225884","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39378"},{"id":3541258,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_violation_id":"250948801","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193225884","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39375A3"},{"id":3541259,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_violation_id":"250948802","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193225884","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39345D"},{"id":3541260,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_violation_id":"250948803","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193225885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39355E"},{"id":3541261,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_violation_id":"250948804","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193225885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3696898,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_unit_id":"193225884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:29.000000Z","updated_at":"2025-03-17T22:32:29.000000Z"},{"id":3696899,"change_date":"2023-02-03 21:41:00","inspection_id":"77771342","insp_unit_id":"193225885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"63309E","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25305U414296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:29.000000Z","updated_at":"2025-03-17T22:32:29.000000Z"}]},{"id":1826603,"change_date":"2022-11-28 21:42:00","inspection_id":"77233806","dot_number":"2440106","report_state":"CA","report_number":"NAS9006705","insp_date":"2022-11-08 00:00:00","insp_start_time":"0957","insp_end_time":"1033","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FIVE CROWNS INC","shipping_paper_number":"M-08,M-008","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-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14684654","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-28 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:20.000000Z","updated_at":"2025-03-17T19:00:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2938964,"change_date":"2022-11-28 21:42:00","inspection_id":"77233806","insp_unit_id":"192155043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT 02 3X","insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:06.000000Z","updated_at":"2025-03-17T22:27:06.000000Z"},{"id":2938965,"change_date":"2022-11-28 21:42:00","inspection_id":"77233806","insp_unit_id":"192155044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT 04 2X","insp_unit_license":"63309E","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25305U414296","insp_unit_decal":"Y","insp_unit_decal_number":"31872522","created_at":"2025-03-17T22:27:06.000000Z","updated_at":"2025-03-17T22:27:06.000000Z"}]},{"id":1498597,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","dot_number":"2440106","report_state":"US","report_number":"1229021318","insp_date":"2022-10-11 00:00:00","insp_start_time":"1205","insp_end_time":"1237","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"430522","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-12 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-10-12 21:42:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:11.000000Z","updated_at":"2025-03-17T18:54:11.000000Z","inspection_violations":[{"id":2357808,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_violation_id":"248983954","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191403734","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39378"},{"id":2357809,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_violation_id":"248983955","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191403734","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39345D"},{"id":2357810,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_violation_id":"248983956","seq_no":"3","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"191403734","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39375B"},{"id":2357811,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_violation_id":"248983957","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191403735","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39347E"},{"id":2357812,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_violation_id":"248983958","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191403735","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":2411998,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_unit_id":"191403734","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:32.000000Z","updated_at":"2025-03-17T22:23:32.000000Z"},{"id":2411999,"change_date":"2022-10-12 21:42:00","inspection_id":"76857162","insp_unit_id":"191403735","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:32.000000Z","updated_at":"2025-03-17T22:23:32.000000Z"}]},{"id":1305735,"change_date":"2022-09-16 21:41:00","inspection_id":"76633403","dot_number":"2440106","report_state":"AZ","report_number":"OY4U000439","insp_date":"2022-09-13 00:00:00","insp_start_time":"1524","insp_end_time":"1550","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"BARD DATE COMPANY","shipping_paper_number":"22030","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":"I","final_status_date":"2022-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1770599","transaction_code":"A","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-15 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"PO BOX 990 PMB 1462","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:49.000000Z","updated_at":"2025-03-17T18:50:49.000000Z","inspection_violations":[{"id":2066462,"change_date":"2022-09-16 21:41:00","inspection_id":"76633403","insp_violation_id":"248474159","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190949314","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"39355E"},{"id":2066463,"change_date":"2022-09-16 21:41:00","inspection_id":"76633403","insp_violation_id":"248474160","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190949314","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3939A"},{"id":2066464,"change_date":"2022-09-16 21:41:00","inspection_id":"76633403","insp_violation_id":"248474161","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"190949314","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":2101723,"change_date":"2022-09-16 21:41:00","inspection_id":"76633403","insp_unit_id":"190949313","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:25.000000Z","updated_at":"2025-03-17T22:21:25.000000Z"},{"id":2101724,"change_date":"2022-09-16 21:41:00","inspection_id":"76633403","insp_unit_id":"190949314","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"63309E","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25305U414296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:25.000000Z","updated_at":"2025-03-17T22:21:25.000000Z"}]},{"id":1208698,"change_date":"2022-09-02 21:39:00","inspection_id":"76520700","dot_number":"2440106","report_state":"CA","report_number":"NABI004684","insp_date":"2022-09-02 00:00:00","insp_start_time":"0806","insp_end_time":"0957","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESA FRESH LLC","shipping_paper_number":"6913284","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":"N","pen_cen_match":null,"final_status_date":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14580801","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1917270,"change_date":"2022-09-02 21:39:00","inspection_id":"76520700","insp_violation_id":"248206725","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190716015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3922"},{"id":1917271,"change_date":"2022-09-02 21:39:00","inspection_id":"76520700","insp_violation_id":"248206726","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190716016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1944001,"change_date":"2022-09-02 21:39:00","inspection_id":"76520700","insp_unit_id":"190716015","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT","insp_unit_license":"ZEA1B6A","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCUAPR6AC168139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"},{"id":1944002,"change_date":"2022-09-02 21:39:00","inspection_id":"76520700","insp_unit_id":"190716016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"58UL4U","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS2537AM082013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":720874,"change_date":"2022-09-13 21:41:00","inspection_id":"75951239","dot_number":"2440106","report_state":"US","report_number":"0993022031","insp_date":"2022-06-20 00:00:00","insp_start_time":"1347","insp_end_time":"1441","registration_date":"2022-09-12 00:00:00","region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"PAMO26407802383","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"426681","transaction_code":"C","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-29 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-06-29 21:41:00","insp_carrier_name":"MAC PARRA TRUCKING","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:29.000000Z","updated_at":"2025-03-17T18:40:29.000000Z","inspection_violations":[{"id":1133914,"change_date":"2022-09-13 21:41:00","inspection_id":"75951239","insp_violation_id":"248385291","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190874443","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133915,"change_date":"2022-09-13 21:41:00","inspection_id":"75951239","insp_violation_id":"248385292","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190874443","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133916,"change_date":"2022-09-13 21:41:00","inspection_id":"75951239","insp_violation_id":"248385293","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190874444","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1158731,"change_date":"2022-09-13 21:41:00","inspection_id":"75951239","insp_unit_id":"190874443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:18.000000Z","updated_at":"2025-03-17T22:15:18.000000Z"},{"id":1158732,"change_date":"2022-09-13 21:41:00","inspection_id":"75951239","insp_unit_id":"190874444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:18.000000Z","updated_at":"2025-03-17T22:15:18.000000Z"}]},{"id":699258,"change_date":"2022-07-05 21:42:00","inspection_id":"75925845","dot_number":"2440106","report_state":"AZ","report_number":"0Y52000161","insp_date":"2022-06-09 00:00:00","insp_start_time":"1325","insp_end_time":"1437","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"26407800841","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":"I","final_status_date":"2022-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"1756295","transaction_code":"C","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-27 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"PO BOX 990 PMB 1462","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:53.000000Z","updated_at":"2025-03-17T18:39:53.000000Z","inspection_violations":[{"id":1098587,"change_date":"2022-07-05 21:42:00","inspection_id":"75925845","insp_violation_id":"246890636","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189604714","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39347E"},{"id":1098588,"change_date":"2022-07-05 21:42:00","inspection_id":"75925845","insp_violation_id":"246890637","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"189604714","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":1123668,"change_date":"2022-07-05 21:42:00","inspection_id":"75925845","insp_unit_id":"189604713","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"Y","insp_unit_decal_number":"31320739","created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1123669,"change_date":"2022-07-05 21:42:00","inspection_id":"75925845","insp_unit_id":"189604714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":247755,"change_date":"2022-04-25 21:41:00","inspection_id":"75388579","dot_number":"2440106","report_state":"CA","report_number":"UBJ7000743","insp_date":"2022-04-22 00:00:00","insp_start_time":"1515","insp_end_time":"1550","registration_date":null,"region":"PT","ci_status_code":"C","location":"701","location_desc":"E\/B E\/O UNION (E) RD","county_code_state":"CA","county_code":"079","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-25 21:41: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":"14399497","transaction_code":"A","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:52.000000Z","updated_at":"2025-03-17T18:31:52.000000Z","inspection_violations":[{"id":380190,"change_date":"2022-04-25 21:41:00","inspection_id":"75388579","insp_violation_id":"245355327","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"188327384","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:08:53.000000Z","updated_at":"2025-03-17T21:08:53.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":401866,"change_date":"2022-04-25 21:41:00","inspection_id":"75388579","insp_unit_id":"188327384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"01","insp_unit_license":"1TW588","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCNAPRX6C197972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:40.000000Z","updated_at":"2025-03-17T22:10:40.000000Z"},{"id":401867,"change_date":"2022-04-25 21:41:00","inspection_id":"75388579","insp_unit_id":"188327385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"MP08","insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:40.000000Z","updated_at":"2025-03-17T22:10:40.000000Z"}]},{"id":238689,"change_date":"2022-04-22 21:46:00","inspection_id":"75377604","dot_number":"2440106","report_state":"CA","report_number":"NDRG002866","insp_date":"2022-04-21 00:00:00","insp_start_time":"1523","insp_end_time":"1543","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14397209","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-22 21:46:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:37.000000Z","updated_at":"2025-03-17T18:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":387015,"change_date":"2022-04-22 21:46:00","inspection_id":"75377604","insp_unit_id":"188304829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT","insp_unit_license":"1TW588","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCNAPRX6C197972","insp_unit_decal":"Y","insp_unit_decal_number":"31173077","created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"},{"id":387016,"change_date":"2022-04-22 21:46:00","inspection_id":"75377604","insp_unit_id":"188304830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT","insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"}]},{"id":218529,"change_date":"2022-04-20 21:45:00","inspection_id":"75353724","dot_number":"2440106","report_state":"CA","report_number":"NCWA003910","insp_date":"2022-04-18 00:00:00","insp_start_time":"1923","insp_end_time":"2005","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LA PALPA DEL DESIERTO","shipping_paper_number":"194945","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":"N","pen_cen_match":null,"final_status_date":"2022-04-20 21:45: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":"14391509","transaction_code":"A","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-20 21:45:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:16.000000Z","updated_at":"2025-03-17T18:31:16.000000Z","inspection_violations":[{"id":337087,"change_date":"2022-04-20 21:45:00","inspection_id":"75353724","insp_violation_id":"245282140","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188258967","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW923007","created_at":"2025-03-17T21:08:38.000000Z","updated_at":"2025-03-17T21:08:38.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":354637,"change_date":"2022-04-20 21:45:00","inspection_id":"75353724","insp_unit_id":"188258967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT","insp_unit_license":"1TW588","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCNAPRX6C197972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:18.000000Z","updated_at":"2025-03-17T22:10:18.000000Z"},{"id":354638,"change_date":"2022-04-20 21:45:00","inspection_id":"75353724","insp_unit_id":"188258968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT","insp_unit_license":"V83412","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1GRAA06268B703070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:18.000000Z","updated_at":"2025-03-17T22:10:18.000000Z"}]},{"id":204642,"change_date":"2022-04-19 21:43:00","inspection_id":"75337192","dot_number":"2440106","report_state":"US","report_number":"0993021879","insp_date":"2022-04-14 00:00:00","insp_start_time":"1327","insp_end_time":"1347","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"HORTICULTORA LA PALMA DEL DESIERTO","shipping_paper_number":"264-04989050","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"424470","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-18 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-04-19 21:43:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:12.000000Z","updated_at":"2025-03-17T18:31:12.000000Z","inspection_violations":[{"id":311524,"change_date":"2022-04-19 21:43:00","inspection_id":"75337192","insp_violation_id":"245235512","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188222816","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:29.000000Z","updated_at":"2025-03-17T21:08:29.000000Z","normalized_code":"3939A"},{"id":311525,"change_date":"2022-04-19 21:43:00","inspection_id":"75337192","insp_violation_id":"245235513","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188222816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:29.000000Z","updated_at":"2025-03-17T21:08:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":331598,"change_date":"2022-04-19 21:43:00","inspection_id":"75337192","insp_unit_id":"188222815","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:11.000000Z","updated_at":"2025-03-17T22:10:11.000000Z"},{"id":331599,"change_date":"2022-04-19 21:43:00","inspection_id":"75337192","insp_unit_id":"188222816","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:11.000000Z","updated_at":"2025-03-17T22:10:11.000000Z"}]},{"id":101195,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","dot_number":"2440106","report_state":"US","report_number":"0993021841","insp_date":"2022-03-30 00:00:00","insp_start_time":"1111","insp_end_time":"1208","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"PAMO26404903467","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"424073","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-31 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85364","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:26.000000Z","updated_at":"2025-03-17T18:29:26.000000Z","inspection_violations":[{"id":148986,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943140","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39378"},{"id":148987,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943141","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39378"},{"id":148988,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943142","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39355D3"},{"id":148989,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943143","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3963A1"},{"id":148990,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943144","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39395A"},{"id":148991,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943145","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"3965B"},{"id":148992,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943146","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"187968917","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39617C"},{"id":148993,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943147","seq_no":"8","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"187968917","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39355E"},{"id":148994,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943148","seq_no":"9","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"187968917","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39375A3"},{"id":148995,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943149","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39347E"},{"id":148996,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943150","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39353B"},{"id":148997,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_violation_id":"244943151","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"187968916","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":163846,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_unit_id":"187968916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT \/ 01","insp_unit_license":"1TW588","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"2HSCNAPRX6C197972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:13.000000Z","updated_at":"2025-03-17T22:09:13.000000Z"},{"id":163847,"change_date":"2022-04-04 21:40:00","inspection_id":"75211819","insp_unit_id":"187968917","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"47255H","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS25336U997268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:13.000000Z","updated_at":"2025-03-17T22:09:13.000000Z"}]},{"id":44728,"change_date":"2022-03-25 21:31:00","inspection_id":"75142417","dot_number":"2440106","report_state":"US","report_number":"1229020760","insp_date":"2022-03-22 00:00:00","insp_start_time":"1247","insp_end_time":"1323","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"LA PALAPA DEL DESIERTO SA DE CV","shipping_paper_number":"PAMO26404978871","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"423806","transaction_code":"A","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02440106","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-23 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"MACARIO PARRA","insp_carrier_street":"3621 W 22ND PL","insp_carrier_city":"SAN LUIS","insp_carrier_state":"AZ","insp_carrier_zip_code":"85349","insp_colonia":null,"docket_number":"847485","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:24.000000Z","updated_at":"2025-03-17T18:28:24.000000Z","inspection_violations":[{"id":63147,"change_date":"2022-03-25 21:31:00","inspection_id":"75142417","insp_violation_id":"244784426","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"187827073","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":72216,"change_date":"2022-03-25 21:31:00","inspection_id":"75142417","insp_unit_id":"187827072","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9TC519","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XP4D49X4DD198155","insp_unit_decal":"Y","insp_unit_decal_number":"30995673","created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"},{"id":72217,"change_date":"2022-03-25 21:31:00","inspection_id":"75142417","insp_unit_id":"187827073","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"97307F","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS253X5U510503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2440106\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2440106\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2440106\/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\/2440106\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}