{"current_page":1,"data":[{"id":11376249,"change_date":"2026-03-14 21:33:00","inspection_id":"87290154","dot_number":"3983317","report_state":"US","report_number":"1301001951","insp_date":"2025-12-13 00:00:00","insp_start_time":"1554","insp_end_time":"1641","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TRANSPORTES AVS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"47200","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":"3006015","transaction_code":"A","transaction_date":"2026-03-14 00:00:00","upload_date":"2026-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2026-03-14 21:33:00","snet_input_date":"2025-12-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-14 21:33:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"5336 E CALLE VISTA DE COLORES","insp_carrier_city":"TUCSON","insp_carrier_state":"AZ","insp_carrier_zip_code":"85711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-17T09:38:33.000000Z","updated_at":"2026-03-25T09:30:30.000000Z","inspection_violations":[{"id":19171245,"change_date":"2026-03-14 21:33:00","inspection_id":"87290154","insp_violation_id":"272403774","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212135409","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-17T09:55:52.000000Z","updated_at":"2026-03-25T09:42:11.000000Z","normalized_code":"39347E"},{"id":19171246,"change_date":"2026-03-14 21:33:00","inspection_id":"87290154","insp_violation_id":"272403775","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"212135409","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-17T09:55:52.000000Z","updated_at":"2026-03-25T09:42:11.000000Z","normalized_code":"39345B2BAIR"},{"id":19171247,"change_date":"2026-03-14 21:33:00","inspection_id":"87290154","insp_violation_id":"272403776","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212135409","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-17T09:55:52.000000Z","updated_at":"2026-03-25T09:42:11.000000Z","normalized_code":"39347E"},{"id":19171248,"change_date":"2026-03-14 21:33:00","inspection_id":"87290154","insp_violation_id":"272403777","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"212135409","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-17T09:55:52.000000Z","updated_at":"2026-03-25T09:42:11.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":19479216,"change_date":"2026-03-14 21:33:00","inspection_id":"87290154","insp_unit_id":"212135409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"07","insp_unit_license":"AL29837","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKAA49X1BJ287360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-17T09:14:10.000000Z","updated_at":"2026-03-25T09:03:47.000000Z"}]},{"id":11142274,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","dot_number":"3983317","report_state":"US","report_number":"1257002278","insp_date":"2025-12-08 00:00:00","insp_start_time":"1726","insp_end_time":"1907","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MINSA COMERCIAL SA DE CV","shipping_paper_number":"8NV00520482","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":"2026-02-16 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"112200","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2893930","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2026-02-16 21:35:00","snet_input_date":"2025-12-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-16 21:35:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"5336 E CALLE VISTA DE COLORES","insp_carrier_city":"TUCSON","insp_carrier_state":"AZ","insp_carrier_zip_code":"85711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-19T10:37:12.000000Z","updated_at":"2026-02-27T10:30:24.000000Z","inspection_violations":[{"id":18667990,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_violation_id":"271822574","seq_no":"1","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"211645138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-19T10:51:18.000000Z","updated_at":"2026-02-27T10:39:00.000000Z","normalized_code":"3963A1ALBV"},{"id":18667991,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_violation_id":"271822575","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"211645138","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-19T10:51:18.000000Z","updated_at":"2026-02-27T10:39:00.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":18667992,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_violation_id":"271822576","seq_no":"3","part_no":"396","part_no_section":"3A1-TFCV","insp_viol_unit":"1","insp_unit_id":"211645138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-19T10:51:18.000000Z","updated_at":"2026-02-27T10:39:00.000000Z","normalized_code":"3963A1TFCV"},{"id":18667993,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_violation_id":"271822577","seq_no":"4","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"1","insp_unit_id":"211645138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-19T10:51:18.000000Z","updated_at":"2026-02-27T10:39:00.000000Z","normalized_code":"39348ABMBCBD"},{"id":18667994,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_violation_id":"271822578","seq_no":"5","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"211645139","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-19T10:51:18.000000Z","updated_at":"2026-02-27T10:39:00.000000Z","normalized_code":"39375A3TAOL"},{"id":18667995,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_violation_id":"271822579","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"211645139","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-19T10:51:18.000000Z","updated_at":"2026-02-27T10:39:00.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":19007188,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_unit_id":"211645139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":"AVS2004","insp_unit_license":"85UN5Z","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2MN01JAH081003941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:52.000000Z","updated_at":"2026-02-27T10:02:42.000000Z"},{"id":19007187,"change_date":"2026-02-16 21:35:00","inspection_id":"87056361","insp_unit_id":"211645138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"07","insp_unit_license":"AL29837","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKAA49X1BJ287360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:52.000000Z","updated_at":"2026-02-27T10:02:42.000000Z"}]},{"id":10269408,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","dot_number":"3983317","report_state":"US","report_number":"1410002114","insp_date":"2025-11-22 00:00:00","insp_start_time":"1413","insp_end_time":"1512","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TRANSPORTES AVS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-22 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"2575289","transaction_code":"A","transaction_date":"2025-11-22 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2025-11-22 21:50:00","snet_input_date":"2025-11-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-22 21:50:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-25T10:32:21.000000Z","updated_at":"2025-11-26T10:31:41.000000Z","inspection_violations":[{"id":17162061,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_violation_id":"270236939","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210214683","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"39347E"},{"id":17162062,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_violation_id":"270236940","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210214684","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"3939ALIL"},{"id":17162063,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_violation_id":"270236941","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"210214683","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"39353BB"},{"id":17162064,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_violation_id":"270236942","seq_no":"4","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"210214684","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"39355EB"},{"id":17162065,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_violation_id":"270236943","seq_no":"5","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"210214684","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"39311BCSRIGRR"},{"id":17162066,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_violation_id":"270236944","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"210214684","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":17138601,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_unit_id":"210214683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"9","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:38.000000Z","updated_at":"2025-11-26T10:02:08.000000Z"},{"id":17138602,"change_date":"2025-11-22 21:50:00","inspection_id":"86393496","insp_unit_id":"210214684","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"53733","insp_unit_license":"863WN3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1GRAA0624CJ533452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:38.000000Z","updated_at":"2025-11-26T10:02:08.000000Z"}]},{"id":10274228,"change_date":"2025-11-24 21:38:00","inspection_id":"86398603","dot_number":"3983317","report_state":"US","report_number":"1248001780","insp_date":"2025-11-01 00:00:00","insp_start_time":"1545","insp_end_time":"1621","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YOREME CORTES Y PROCESOS","shipping_paper_number":"BST-0313941-8","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-11-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2580543","transaction_code":"A","transaction_date":"2025-11-23 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2025-11-24 21:38:00","snet_input_date":"2025-11-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-24 21:38:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:31.000000Z","updated_at":"2025-11-28T10:30:20.000000Z","inspection_violations":[{"id":17172796,"change_date":"2025-11-24 21:38:00","inspection_id":"86398603","insp_violation_id":"270247422","seq_no":"1","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:46.000000Z","updated_at":"2025-11-28T10:30:40.000000Z","normalized_code":"3958K2HOSP"}],"inspection_per_units":[{"id":17147495,"change_date":"2025-11-24 21:38:00","inspection_id":"86398603","insp_unit_id":"210223536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"9","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:29.000000Z","updated_at":"2025-11-28T10:00:20.000000Z"},{"id":17147496,"change_date":"2025-11-24 21:38:00","inspection_id":"86398603","insp_unit_id":"210223537","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"KBA23","insp_unit_license":"86UJ7L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532W38L098999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:29.000000Z","updated_at":"2025-11-28T10:00:20.000000Z"}]},{"id":10039700,"change_date":"2025-10-26 21:34:00","inspection_id":"86151870","dot_number":"3983317","report_state":"US","report_number":"0989001485","insp_date":"2025-10-21 00:00:00","insp_start_time":"1618","insp_end_time":"1741","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AVALOS PRODUCE","shipping_paper_number":"91890440448","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-10-26 21:34: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2461797","transaction_code":"A","transaction_date":"2025-10-26 00:00:00","upload_date":"2025-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2025-10-26 21:34:00","snet_input_date":"2025-10-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-26 21:34:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-29T10:00:28.000000Z","updated_at":"2025-10-30T10:00:22.000000Z","inspection_violations":[{"id":16607827,"change_date":"2025-10-26 21:34:00","inspection_id":"86151870","insp_violation_id":"269524225","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"209661921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:48.000000Z","updated_at":"2025-10-30T10:15:33.000000Z","normalized_code":"39311A1CSLRR"},{"id":16607828,"change_date":"2025-10-26 21:34:00","inspection_id":"86151870","insp_violation_id":"269524226","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"209661921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:48.000000Z","updated_at":"2025-10-30T10:15:33.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":16679569,"change_date":"2025-10-26 21:34:00","inspection_id":"86151870","insp_unit_id":"209661920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAILMOBIL","insp_unit_company":"AVS2004","insp_unit_license":"85UN5Z","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2MN01JAH081003941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-29T09:45:41.000000Z","updated_at":"2025-10-30T09:45:31.000000Z"},{"id":16679570,"change_date":"2025-10-26 21:34:00","inspection_id":"86151870","insp_unit_id":"209661921","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"07","insp_unit_license":"AL29837","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKAA49X1BJ287360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-29T09:45:41.000000Z","updated_at":"2025-10-30T09:45:31.000000Z"}]},{"id":9750882,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","dot_number":"3983317","report_state":"US","report_number":"1410001920","insp_date":"2025-09-18 00:00:00","insp_start_time":"1503","insp_end_time":"1627","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MINSA COMERCIAL","shipping_paper_number":"8NV00511796","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-09-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2312680","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2025-09-23 21:42:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-23 21:42:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:41.000000Z","updated_at":"2025-09-26T10:00:21.000000Z","inspection_violations":[{"id":16023699,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858727","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209089067","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"39347E"},{"id":16023700,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858728","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209089067","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"39345B2BAIR"},{"id":16023701,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858729","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"209089068","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"3939ALIL"},{"id":16023702,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858730","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"209089067","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"39353BB"},{"id":16023703,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858731","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209089068","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"39345B2BAIR"},{"id":16023704,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858732","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209089068","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"39345B2BAIR"},{"id":16023705,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_violation_id":"268858733","seq_no":"7","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"209089067","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:39.000000Z","updated_at":"2025-09-27T10:15:42.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":16152233,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_unit_id":"209089067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"9","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:02.000000Z","updated_at":"2025-09-27T09:45:22.000000Z"},{"id":16152234,"change_date":"2025-09-23 21:42:00","inspection_id":"85848084","insp_unit_id":"209089068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"AVS2006","insp_unit_license":"A1A34Y","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1JJV532D0EL881777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:02.000000Z","updated_at":"2025-09-27T09:45:22.000000Z"}]},{"id":9259459,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","dot_number":"3983317","report_state":"US","report_number":"1248001511","insp_date":"2025-07-07 00:00:00","insp_start_time":"1516","insp_end_time":"1654","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MOLINERA DE MEXICO","shipping_paper_number":"NDH-0040293-2","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-07-27 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2049128","transaction_code":"A","transaction_date":"2025-07-27 00:00:00","upload_date":"2025-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2025-07-27 21:33:00","snet_input_date":"2025-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-27 21:33:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:31.000000Z","updated_at":"2025-07-31T10:00:18.000000Z","inspection_violations":[{"id":14997664,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","insp_violation_id":"267678596","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208101605","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-30T10:41:22.000000Z","updated_at":"2025-07-31T10:43:03.000000Z","normalized_code":"39617CPI"},{"id":14997665,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","insp_violation_id":"267678597","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"208101605","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-30T10:41:22.000000Z","updated_at":"2025-07-31T10:43:03.000000Z","normalized_code":"3939ALSLIWR"},{"id":14997666,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","insp_violation_id":"267678598","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208101604","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-30T10:41:22.000000Z","updated_at":"2025-07-31T10:43:03.000000Z","normalized_code":"39345DB"},{"id":14997667,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","insp_violation_id":"267678599","seq_no":"4","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208101605","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-30T10:41:22.000000Z","updated_at":"2025-07-31T10:43:03.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":15238753,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","insp_unit_id":"208101604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"9","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-30T09:45:33.000000Z","updated_at":"2025-08-01T09:45:23.000000Z"},{"id":15238754,"change_date":"2025-07-27 21:33:00","inspection_id":"85331720","insp_unit_id":"208101605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AVS2005","insp_unit_license":"AJA1JX","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3H3V532C6ET013168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-30T09:45:33.000000Z","updated_at":"2025-08-01T09:45:23.000000Z"}]},{"id":8773557,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","dot_number":"3983317","report_state":"US","report_number":"1257001771","insp_date":"2025-05-29 00:00:00","insp_start_time":"1533","insp_end_time":"1722","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MINSA COMERCIAL SA DE CV","shipping_paper_number":"8NV00498671","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-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"12","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":"1797652","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:01.000000Z","updated_at":"2025-06-04T10:01:01.000000Z","inspection_violations":[{"id":14022756,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562652","seq_no":"1","part_no":"390","part_no_section":"21TB3-OPERBY","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39021TB3OPERBY"},{"id":14022757,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562653","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39111B2Q"},{"id":14022758,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562654","seq_no":"3","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":14022759,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562655","seq_no":"4","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":14022760,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562656","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39345B2BAIR"},{"id":14022761,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562657","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39345B2BAIR"},{"id":14022762,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562658","seq_no":"7","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39345B2BHTD"},{"id":14022763,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562659","seq_no":"8","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39345DB"},{"id":14022764,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562660","seq_no":"9","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"207139643","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39355EB"},{"id":14022765,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562661","seq_no":"11","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"3963A1BALR"},{"id":14022766,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562662","seq_no":"12","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207139642","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"3965BL"},{"id":14022767,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_violation_id":"266562663","seq_no":"10","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"207139643","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:16:56.000000Z","updated_at":"2025-06-03T10:16:43.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14354402,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_unit_id":"207139642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"9","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:16.000000Z","updated_at":"2025-06-03T09:45:12.000000Z"},{"id":14354403,"change_date":"2025-05-30 21:40:00","inspection_id":"84818635","insp_unit_id":"207139643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"SM5305","insp_unit_license":"60UJ7L","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1GRAA06229D435723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:16.000000Z","updated_at":"2025-06-03T09:45:12.000000Z"}]},{"id":6521499,"change_date":"2024-08-21 21:41:00","inspection_id":"82441539","dot_number":"3983317","report_state":"US","report_number":"0989000701","insp_date":"2024-08-20 00:00:00","insp_start_time":"1305","insp_end_time":"1429","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"766190","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2024-08-21 21:41:00","snet_input_date":"2024-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-21 21:41:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:19.000000Z","updated_at":"2025-03-17T20:32:19.000000Z","inspection_violations":[{"id":10132109,"change_date":"2024-08-21 21:41:00","inspection_id":"82441539","insp_violation_id":"261312567","seq_no":"1","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"202500265","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3969D2"},{"id":10132110,"change_date":"2024-08-21 21:41:00","inspection_id":"82441539","insp_violation_id":"261312568","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202500265","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39395F"},{"id":10132111,"change_date":"2024-08-21 21:41:00","inspection_id":"82441539","insp_violation_id":"261312569","seq_no":"3","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"202500265","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39378A"}],"inspection_per_units":[{"id":10513135,"change_date":"2024-08-21 21:41:00","inspection_id":"82441539","insp_unit_id":"202500265","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"08","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"Y","insp_unit_decal_number":"34381414","created_at":"2025-03-17T23:31:53.000000Z","updated_at":"2025-03-17T23:31:53.000000Z"}]},{"id":6497740,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","dot_number":"3983317","report_state":"US","report_number":"1180000674","insp_date":"2024-08-15 00:00:00","insp_start_time":"1352","insp_end_time":"1547","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"15","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":"754620","transaction_code":"C","transaction_date":"2024-08-18 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:37.000000Z","updated_at":"2025-07-27T10:41:16.000000Z","inspection_violations":[{"id":14913296,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591381","seq_no":"1","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39522H1ELDNUM"},{"id":14913297,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591382","seq_no":"2","part_no":"395","part_no_section":"22H2-ELDNISDT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39522H2ELDNISDT"},{"id":14913298,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591383","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39378AWS"},{"id":14913299,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591384","seq_no":"4","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39311A1CSURR"},{"id":14913300,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591385","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39345DB"},{"id":14913301,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591386","seq_no":"6","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39522GELDMFV"},{"id":14913302,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591387","seq_no":"7","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"393207ASTCB"},{"id":14913303,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591388","seq_no":"8","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"3965BL"},{"id":14913304,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591389","seq_no":"9","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"208028605","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39348ABMBCBD"},{"id":14913305,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591390","seq_no":"10","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208028605","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39375A3TAOL"},{"id":14913306,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591391","seq_no":"11","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208028605","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39355EB"},{"id":14913307,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591392","seq_no":"12","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":14913308,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591393","seq_no":"13","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39395F"},{"id":14913309,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591394","seq_no":"14","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208028604","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39617CPI"},{"id":14913310,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_violation_id":"267591395","seq_no":"15","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-26T10:43:08.000000Z","updated_at":"2025-07-27T10:42:11.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":15163289,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_unit_id":"208028604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"08","insp_unit_license":"AM24221","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKYD49X9GJ488341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:11.000000Z"},{"id":15163290,"change_date":"2025-07-23 21:41:00","inspection_id":"82416271","insp_unit_id":"208028605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"RCM5332","insp_unit_license":"3EA7HV","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3H3V532C0CT080085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:20.000000Z","updated_at":"2025-07-27T09:45:11.000000Z"}]},{"id":5354880,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","dot_number":"3983317","report_state":"AZ","report_number":"7254000160","insp_date":"2024-03-18 00:00:00","insp_start_time":"1349","insp_end_time":"1440","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"TUCSON AZ","county_code_state":"AZ","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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":"U","pen_cen_match":"I","final_status_date":"2024-03-24 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"340769","transaction_code":"A","transaction_date":"2024-03-24 00:00:00","upload_date":"2024-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2024-03-24 21:32:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-24 21:32:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:42.000000Z","updated_at":"2025-03-17T20:08:42.000000Z","inspection_violations":[{"id":8261845,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548153","seq_no":"1","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":8261846,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548154","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39111B2Q"},{"id":8261847,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548155","seq_no":"3","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39282DUMT"},{"id":8261848,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548156","seq_no":"4","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"200057813","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39311A1CSLRR"},{"id":8261849,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548157","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"200057813","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39378AWS"},{"id":8261850,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548158","seq_no":"6","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39522GELDMFV"},{"id":8261851,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548159","seq_no":"7","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"39522H1ELDNUM"},{"id":8261852,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_violation_id":"258548160","seq_no":"8","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:00.000000Z","updated_at":"2025-03-17T21:46:00.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":8623564,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_unit_id":"200057813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"7","insp_unit_license":"AL29837","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKAA49X1BJ287360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:12.000000Z","updated_at":"2025-03-17T23:13:12.000000Z"},{"id":8623565,"change_date":"2024-03-24 21:32:00","inspection_id":"81180465","insp_unit_id":"200057814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"AVS15","insp_unit_license":"53UH8S","insp_unit_license_state":"SO","insp_unit_vehicle_id_number":"1JJV532W15L933865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:12.000000Z","updated_at":"2025-03-17T23:13:12.000000Z"}]},{"id":5174726,"change_date":"2024-02-29 21:47:00","inspection_id":"80983740","dot_number":"3983317","report_state":"US","report_number":"1296000545","insp_date":"2024-02-28 00:00:00","insp_start_time":"1352","insp_end_time":"1448","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AVALOSPRODUCE","shipping_paper_number":"91890343469","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-02-29 21:47: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"281101","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2024-02-29 21:47:00","snet_input_date":"2024-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-29 21:47:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:59.000000Z","updated_at":"2025-03-17T20:04:59.000000Z","inspection_violations":[{"id":7975533,"change_date":"2024-02-29 21:47:00","inspection_id":"80983740","insp_violation_id":"258120079","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"199679261","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:31.000000Z","updated_at":"2025-03-17T21:44:31.000000Z","normalized_code":"39311A1CSLRR"},{"id":7975534,"change_date":"2024-02-29 21:47:00","inspection_id":"80983740","insp_violation_id":"258120080","seq_no":"2","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"2","insp_unit_id":"199679262","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:31.000000Z","updated_at":"2025-03-17T21:44:31.000000Z","normalized_code":"393201AFRCLS"}],"inspection_per_units":[{"id":8331685,"change_date":"2024-02-29 21:47:00","inspection_id":"80983740","insp_unit_id":"199679261","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"07","insp_unit_license":"AL29837","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKAA49X1BJ287360","insp_unit_decal":"Y","insp_unit_decal_number":"33742028","created_at":"2025-03-17T23:10:30.000000Z","updated_at":"2025-03-17T23:10:30.000000Z"},{"id":8331686,"change_date":"2024-02-29 21:47:00","inspection_id":"80983740","insp_unit_id":"199679262","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"AVS12","insp_unit_license":"55UH8S","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532WX4L886737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:30.000000Z","updated_at":"2025-03-17T23:10:30.000000Z"}]},{"id":5220728,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","dot_number":"3983317","report_state":"US","report_number":"1409000592","insp_date":"2024-01-20 00:00:00","insp_start_time":"1050","insp_end_time":"1212","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AVALOS PRODUCE","shipping_paper_number":"91890334815","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-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"295186","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2024-03-06 21:39:00","snet_input_date":"2024-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-06 21:39:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:10.000000Z","updated_at":"2025-03-17T20:06:10.000000Z","inspection_violations":[{"id":8047081,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_violation_id":"258223672","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"199774130","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39617CPI"},{"id":8047082,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_violation_id":"258223673","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"199774130","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39355EB"},{"id":8047083,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_violation_id":"258223674","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"199774129","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3922SLLUCR"},{"id":8047084,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_violation_id":"258223675","seq_no":"4","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"2","insp_unit_id":"199774130","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3969D2FTF"},{"id":8047085,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_violation_id":"258223676","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"199774130","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":8406885,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_unit_id":"199774129","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"59496","insp_unit_license":"3JA65M","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKDD49X99J259496","insp_unit_decal":"Y","insp_unit_decal_number":"33742916","created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"},{"id":8406886,"change_date":"2024-03-06 21:39:00","inspection_id":"81033873","insp_unit_id":"199774130","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"AVS13","insp_unit_license":"8SU148A","insp_unit_license_state":"SO","insp_unit_vehicle_id_number":"1JJV532W55L907902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"}]},{"id":4862628,"change_date":"2024-01-19 21:43:00","inspection_id":"80642971","dot_number":"3983317","report_state":"AZ","report_number":"XC76640012","insp_date":"2024-01-11 00:00:00","insp_start_time":"1050","insp_end_time":"1124","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZNOGP","location_desc":"NOGALES AZ","county_code_state":"AZ","county_code":"023","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AVALOS PRODUCE","shipping_paper_number":"918-9033212-4","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-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"1","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":"184493","transaction_code":"A","transaction_date":"2024-01-19 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2024-01-19 21:43:00","snet_input_date":"2024-01-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-19 21:43:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:12.000000Z","updated_at":"2025-03-17T19:59:12.000000Z","inspection_violations":[{"id":7495435,"change_date":"2024-01-19 21:43:00","inspection_id":"80642971","insp_violation_id":"257407019","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"199023717","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":7823610,"change_date":"2024-01-19 21:43:00","inspection_id":"80642971","insp_unit_id":"199023716","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"59486","insp_unit_license":"3JA65M","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKDD49X99J259496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:54.000000Z","updated_at":"2025-03-17T23:05:54.000000Z"},{"id":7823611,"change_date":"2024-01-19 21:43:00","inspection_id":"80642971","insp_unit_id":"199023717","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"AVS10","insp_unit_license":"65UF3V","insp_unit_license_state":"SO","insp_unit_vehicle_id_number":"1UYVS2533XU799808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:54.000000Z","updated_at":"2025-03-17T23:05:54.000000Z"}]},{"id":3987738,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","dot_number":"3983317","report_state":"US","report_number":"1257000421","insp_date":"2023-09-13 00:00:00","insp_start_time":"1133","insp_end_time":"1251","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"NOGALESAZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AVALOS PRODUCE","shipping_paper_number":"91890300063","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-16 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"6","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":"54310","transaction_code":"A","transaction_date":"2023-09-16 00:00:00","upload_date":"2023-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2023-09-16 21:30:00","snet_input_date":"2023-09-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-16 21:30:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[{"id":6169017,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_violation_id":"255308961","seq_no":"1","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"197088717","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":6169018,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_violation_id":"255308962","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"197088718","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"39355EB"},{"id":6169019,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_violation_id":"255308963","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197088717","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"39360C"},{"id":6169020,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_violation_id":"255308964","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"197088717","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"39395A1"},{"id":6169021,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_violation_id":"255308965","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"197088718","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3939ALIL"},{"id":6169022,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_violation_id":"255308966","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"197088717","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":6412102,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_unit_id":"197088717","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA65M","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKDD49X99J259496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"},{"id":6412103,"change_date":"2023-09-16 21:30:00","inspection_id":"79679137","insp_unit_id":"197088718","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"8SU148A","insp_unit_license_state":"SO","insp_unit_vehicle_id_number":"1JJV532W55L907902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"}]},{"id":3626130,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","dot_number":"3983317","report_state":"US","report_number":"1296000146","insp_date":"2023-07-26 00:00:00","insp_start_time":"1155","insp_end_time":"1230","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"NOGALESAZ","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-07-29 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"35836","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2023-07-29 21:30:00","snet_input_date":"2023-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-29 21:30:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[{"id":5592126,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_violation_id":"254359142","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"196264885","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39395A4EEUS"},{"id":5592127,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_violation_id":"254359143","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"196264885","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39311A1CSLRR"},{"id":5592128,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_violation_id":"254359144","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"196264885","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3922SLLUCR"},{"id":5592129,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_violation_id":"254359145","seq_no":"4","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"196264885","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39345B2B"},{"id":5592130,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_violation_id":"254359146","seq_no":"5","part_no":"393","part_no_section":"47C-BSAMBD","insp_viol_unit":"1","insp_unit_id":"196264885","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"39347CBSAMBD"},{"id":5592131,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_violation_id":"254359147","seq_no":"6","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"196264885","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:32:55.000000Z","updated_at":"2025-03-17T21:32:55.000000Z","normalized_code":"3963A1TAOCV"}],"inspection_per_units":[{"id":5830155,"change_date":"2023-07-29 21:30:00","inspection_id":"79275596","insp_unit_id":"196264885","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"03AY2U","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKAA49X1BJ287360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3174186,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","dot_number":"3983317","report_state":"US","report_number":"1185000004","insp_date":"2023-05-23 00:00:00","insp_start_time":"1457","insp_end_time":"1554","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"NOGALESAZ","county_code_state":"AZ","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"STESAN PRODUCE LLC","shipping_paper_number":"NPP00094568","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-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"19287","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2023-05-31 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-05-31 21:41:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:45.000000Z","updated_at":"2025-03-17T19:25:45.000000Z","inspection_violations":[{"id":4891648,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","insp_violation_id":"253167172","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"195217415","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39355EB"},{"id":4891649,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","insp_violation_id":"253167173","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195217414","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39360C"},{"id":4891650,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","insp_violation_id":"253167174","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"195217415","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3939ALLPL"},{"id":4891651,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","insp_violation_id":"253167175","seq_no":"4","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"195217415","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":5106019,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","insp_unit_id":"195217414","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"3JA65M","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKDD49X99J259496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"},{"id":5106020,"change_date":"2023-05-31 21:41:00","inspection_id":"78767005","insp_unit_id":"195217415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"56UD9C","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS24814U263836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"}]},{"id":2933396,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","dot_number":"3983317","report_state":"US","report_number":"1410011233","insp_date":"2023-04-21 00:00:00","insp_start_time":"0951","insp_end_time":"1102","registration_date":null,"region":"MT","ci_status_code":"C","location":"NOGAL","location_desc":"US CUSTOMS-NOGALES","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA ERAB","shipping_paper_number":"BST02692144","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 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"436294","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-01 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-05-01 21:40:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303-3415","insp_colonia":null,"docket_number":"1492103","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:56.000000Z","updated_at":"2025-03-17T19:20:56.000000Z","inspection_violations":[{"id":4503205,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545622","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194680226","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"3965B"},{"id":4503206,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545623","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194680226","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"39347E"},{"id":4503207,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545624","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194680226","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"39353B"},{"id":4503208,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545625","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194680226","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"3963A1"},{"id":4503209,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545626","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194680226","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"3922"},{"id":4503210,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545627","seq_no":"6","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"194680226","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"3969D2"},{"id":4503211,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545628","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194680227","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"3963A1"},{"id":4503212,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_violation_id":"252545629","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"194680227","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:00.000000Z","updated_at":"2025-03-17T21:28:00.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4719825,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_unit_id":"194680226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"59496","insp_unit_license":"3JA65M","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKDD49X99J259496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:11.000000Z","updated_at":"2025-03-17T22:40:11.000000Z"},{"id":4719826,"change_date":"2023-05-01 21:40:00","inspection_id":"78495426","insp_unit_id":"194680227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"AVS14","insp_unit_license":"3SU446A","insp_unit_license_state":"SO","insp_unit_vehicle_id_number":"1JJV532W15L907962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:11.000000Z","updated_at":"2025-03-17T22:40:11.000000Z"}]},{"id":2927342,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","dot_number":"3983317","report_state":"US","report_number":"1409011447","insp_date":"2023-04-19 00:00:00","insp_start_time":"1450","insp_end_time":"1604","registration_date":null,"region":"MT","ci_status_code":"C","location":"NOGAL","location_desc":"U.S CUSTOMS NOGALES","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"AGRICOLA HORTYAQUI","shipping_paper_number":"BSI0588524","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":"115000","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"436063","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2023-05-01 10:45:00","snet_input_date":"2023-04-28 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-05-01 10:45:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303-3415","insp_colonia":null,"docket_number":"0","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":4494557,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528597","seq_no":"1","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39111B2"},{"id":4494558,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528598","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194663960","insp_violation_category_id":"16","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":"39345D"},{"id":4494559,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528599","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194663960","insp_violation_category_id":"16","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"},{"id":4494560,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528600","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194663960","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":"3922"},{"id":4494561,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528601","seq_no":"5","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194663961","insp_violation_category_id":"16","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":"39355E"},{"id":4494562,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528602","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194663961","insp_violation_category_id":"23","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":"39375C"},{"id":4494563,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528603","seq_no":"7","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"194663961","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"393207A"},{"id":4494564,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528604","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"194663961","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39345B2"},{"id":4494565,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_violation_id":"252528605","seq_no":"9","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"2","insp_unit_id":"194663961","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":"3969D2"}],"inspection_per_units":[{"id":4709864,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_unit_id":"194663960","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"59496","insp_unit_license":"3JA65M","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKDD49X99J259496","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":4709865,"change_date":"2023-05-01 10:45:00","inspection_id":"78488507","insp_unit_id":"194663961","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"AVS09","insp_unit_license":"56UD9C","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1UYVS24814U263836","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":2369962,"change_date":"2023-02-14 21:41:00","inspection_id":"77854599","dot_number":"3983317","report_state":"US","report_number":"1409011294","insp_date":"2023-02-10 00:00:00","insp_start_time":"0850","insp_end_time":"1004","registration_date":null,"region":"MT","ci_status_code":"C","location":"NOGAL","location_desc":"U.S CUSTOMS NOGALES","county_code_state":"AZ","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"434083","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03983317","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-13 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"TRANSPORTES AVS LLC","insp_carrier_street":"7839 W TUCKEY LN","insp_carrier_city":"GLENDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85303-3415","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3649618,"change_date":"2023-02-14 21:41:00","inspection_id":"77854599","insp_violation_id":"251132052","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193395904","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39395F"},{"id":3649619,"change_date":"2023-02-14 21:41:00","inspection_id":"77854599","insp_violation_id":"251132053","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193395904","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3963A1"},{"id":3649620,"change_date":"2023-02-14 21:41:00","inspection_id":"77854599","insp_violation_id":"251132054","seq_no":"3","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"1","insp_unit_id":"193395904","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"387303B4"}],"inspection_per_units":[{"id":3813678,"change_date":"2023-02-14 21:41:00","inspection_id":"77854599","insp_unit_id":"193395904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"77715NP","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1XKADB9X56J107623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3983317\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3983317\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3983317\/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\/3983317\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}