{"current_page":1,"data":[{"id":10033256,"change_date":"2025-10-24 21:40:00","inspection_id":"86145082","dot_number":"3834347","report_state":"CA","report_number":"NC3Q002557","insp_date":"2025-10-24 00:00:00","insp_start_time":"0730","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","location_desc":"788 E CHILDS AVE MERCED","county_code_state":"CA","county_code":"047","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16032291","transaction_code":"A","transaction_date":"2025-10-24 00:00:00","upload_date":"2025-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-10-24 21:40:00","snet_input_date":"2025-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-24 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1412 ANTIOCH CT","insp_carrier_city":"MERCED","insp_carrier_state":"CA","insp_carrier_zip_code":"95348","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-10-27T10:01:57.000000Z","updated_at":"2025-10-28T10:01:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16668520,"change_date":"2025-10-24 21:40:00","inspection_id":"86145082","insp_unit_id":"209650267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"Y","insp_unit_decal_number":"35623521","created_at":"2025-10-27T09:47:10.000000Z","updated_at":"2025-10-28T09:46:55.000000Z"},{"id":16668521,"change_date":"2025-10-24 21:40:00","inspection_id":"86145082","insp_unit_id":"209650268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1302","insp_unit_license":"C485177","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2539FU161805","insp_unit_decal":"Y","insp_unit_decal_number":"35623522","created_at":"2025-10-27T09:47:10.000000Z","updated_at":"2025-10-28T09:46:55.000000Z"}]},{"id":8807926,"change_date":"2025-06-03 21:41:00","inspection_id":"84855085","dot_number":"3834347","report_state":"CA","report_number":"NBAU002051","insp_date":"2025-06-02 00:00:00","insp_start_time":"1030","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"265","location_desc":"TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15845389","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-06-03 21:41:00","snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-03 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-06-06T10:01:08.000000Z","updated_at":"2025-06-07T10:00:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14416580,"change_date":"2025-06-03 21:41:00","inspection_id":"84855085","insp_unit_id":"207208396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:52.000000Z","updated_at":"2025-06-07T09:46:00.000000Z"},{"id":14416581,"change_date":"2025-06-03 21:41:00","inspection_id":"84855085","insp_unit_id":"207208397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1303","insp_unit_license":"5537219","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532BXJL049091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:52.000000Z","updated_at":"2025-06-07T09:46:00.000000Z"}]},{"id":8854984,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","dot_number":"3834347","report_state":"CA","report_number":"ND64009133","insp_date":"2025-06-02 00:00:00","insp_start_time":"0924","insp_end_time":"1019","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MT. PASS J.P.O.E. C.V.E.F.","county_code_state":"CA","county_code":"071","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"7","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15854672","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-06-09 21:41:00","snet_input_date":"2025-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-09 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:35.000000Z","updated_at":"2025-06-14T10:00:35.000000Z","inspection_violations":[{"id":14182269,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746547","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RR69277","created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"3922SLLED"},{"id":14182270,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746548","seq_no":"2","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"207299016","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"7NV80000Q","created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"3963A1F"},{"id":14182271,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746549","seq_no":"3","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"2","insp_unit_id":"207299017","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"393207ASTCB"},{"id":14182272,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746550","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"207299017","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"7MNP00019","created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"39375A3TAOL"},{"id":14182273,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746551","seq_no":"5","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207299016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"39345DB"},{"id":14182274,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746552","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"207299017","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"3939ALLPL"},{"id":14182275,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_violation_id":"266746553","seq_no":"7","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"207299017","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:57.000000Z","updated_at":"2025-06-13T10:17:57.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":14500107,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_unit_id":"207299016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHT\/1316","insp_unit_license":"ZP09248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7KN213148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:36.000000Z","updated_at":"2025-06-13T09:45:36.000000Z"},{"id":14500108,"change_date":"2025-06-09 21:41:00","inspection_id":"84904989","insp_unit_id":"207299017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT\/150","insp_unit_license":"4VR267","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B5BGL89411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:36.000000Z","updated_at":"2025-06-13T09:45:36.000000Z"}]},{"id":8646327,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","dot_number":"3834347","report_state":"WY","report_number":"PDJS000406","insp_date":"2025-05-13 00:00:00","insp_start_time":"0731","insp_end_time":"0836","registration_date":null,"region":"MT","ci_status_code":"C","location":"ML80","location_desc":"CHEYENNE I-80 POE","county_code_state":"WY","county_code":"021","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAYER BRANDS","shipping_paper_number":"SW3795815","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"7","oos_total":"0","driver_viol_total":"7","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"461054","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-05-15 21:43:00","snet_input_date":"2025-05-13 00:00:00","source_office":"4WYS001","mcmis_add_date":"2025-05-15 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:04:27.000000Z","updated_at":"2025-05-19T10:05:57.000000Z","inspection_violations":[{"id":13754638,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252803","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"39617CPI"},{"id":13754639,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252804","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"39617CPI"},{"id":13754640,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252805","seq_no":"3","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-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"39522GELDMFV"},{"id":13754641,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252806","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"3958EHOSPD"},{"id":13754642,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252807","seq_no":"5","part_no":"395","part_no_section":"8D9-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"3958D9HOSF"},{"id":13754643,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252808","seq_no":"6","part_no":"395","part_no_section":"8H-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"3958HHOSM"},{"id":13754644,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_violation_id":"266252809","seq_no":"7","part_no":"395","part_no_section":"8H-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:31:19.000000Z","updated_at":"2025-05-19T10:29:17.000000Z","normalized_code":"3958HHOSM"}],"inspection_per_units":[{"id":14120672,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_unit_id":"206885150","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"AP02","insp_unit_license":"ZP47923","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG3HN978308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:19.000000Z","updated_at":"2025-05-19T09:51:50.000000Z"},{"id":14120673,"change_date":"2025-05-15 21:43:00","inspection_id":"84684213","insp_unit_id":"206885151","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1301","insp_unit_license":"4PP7299","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B2HL961241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:19.000000Z","updated_at":"2025-05-19T09:51:50.000000Z"}]},{"id":8448935,"change_date":"2025-04-23 21:41:00","inspection_id":"84476459","dot_number":"3834347","report_state":"SD","report_number":"5810001119","insp_date":"2025-04-23 00:00:00","insp_start_time":"1109","insp_end_time":"1139","registration_date":null,"region":"MD","ci_status_code":"C","location":"TILFRD","location_desc":"TILFORD SD","county_code_state":"SD","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CMI ORCHARD","shipping_paper_number":"141933-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1635255","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:25.000000Z","updated_at":"2025-04-27T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13723429,"change_date":"2025-04-23 21:41:00","inspection_id":"84476459","insp_unit_id":"206452102","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1319","insp_unit_license":"ZP47927","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR4JSJY6109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:12:14.000000Z","updated_at":"2025-04-27T09:59:34.000000Z"},{"id":13723430,"change_date":"2025-04-23 21:41:00","inspection_id":"84476459","insp_unit_id":"206452103","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"C430793","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2535J6099512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:12:14.000000Z","updated_at":"2025-04-27T09:59:35.000000Z"}]},{"id":8089179,"change_date":"2025-03-11 21:41:00","inspection_id":"84097551","dot_number":"3834347","report_state":"CA","report_number":"NDLU007232","insp_date":"2025-03-05 00:00:00","insp_start_time":"1749","insp_end_time":"1855","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DRISCOLLS","shipping_paper_number":"OR03496632","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15734982","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:17.000000Z","updated_at":"2025-03-17T21:06:17.000000Z","inspection_violations":[{"id":12644866,"change_date":"2025-03-11 21:41:00","inspection_id":"84097551","insp_violation_id":"264962229","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"205745980","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA665584","created_at":"2025-03-17T22:07:56.000000Z","updated_at":"2025-03-17T22:07:56.000000Z","normalized_code":"39375A3TAOL"},{"id":12644867,"change_date":"2025-03-11 21:41:00","inspection_id":"84097551","insp_violation_id":"264962230","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"205745980","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:56.000000Z","updated_at":"2025-03-17T22:07:56.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":13060585,"change_date":"2025-03-11 21:41:00","inspection_id":"84097551","insp_unit_id":"205745979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":"ORNG 5911","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:24.000000Z","updated_at":"2025-03-17T23:59:24.000000Z"},{"id":13060586,"change_date":"2025-03-11 21:41:00","inspection_id":"84097551","insp_unit_id":"205745980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT 1113","insp_unit_license":"TS25","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS2536GU539242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:24.000000Z","updated_at":"2025-03-17T23:59:24.000000Z"}]},{"id":7940453,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","dot_number":"3834347","report_state":"AZ","report_number":"5617000427","insp_date":"2025-02-20 00:00:00","insp_start_time":"0915","insp_end_time":"1035","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"CASA GRANDE AZ","county_code_state":"AZ","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WEST MADISON FOODS","shipping_paper_number":"93170","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":"2025-02-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1393176","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-02-24 21:39:00","snet_input_date":"2025-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-24 21:39:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:13.000000Z","updated_at":"2025-03-17T21:03:13.000000Z","inspection_violations":[{"id":12406145,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655298","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"205459926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3939ALSML"},{"id":12406146,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655299","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3922SLLTL"},{"id":12406147,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655300","seq_no":"3","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"205459926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39311A1LIL"},{"id":12406148,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655301","seq_no":"4","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"205459926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39311BCSRIGRR"},{"id":12406149,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655302","seq_no":"5","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"205459926","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39355EB"},{"id":12406150,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655303","seq_no":"6","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205459925","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39375A3TAOL"},{"id":12406151,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655304","seq_no":"7","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205459925","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"39378AWS"},{"id":12406152,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_violation_id":"264655305","seq_no":"8","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"205459925","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:37.000000Z","updated_at":"2025-03-17T22:06:37.000000Z","normalized_code":"3939ALTSIR"}],"inspection_per_units":[{"id":12818175,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_unit_id":"205459925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1316","insp_unit_license":"ZP09248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7KN213148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:36.000000Z","updated_at":"2025-03-17T23:56:36.000000Z"},{"id":12818176,"change_date":"2025-02-24 21:39:00","inspection_id":"83941276","insp_unit_id":"205459926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"4118","insp_unit_license":"C465329","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:36.000000Z","updated_at":"2025-03-17T23:56:36.000000Z"}]},{"id":7776159,"change_date":"2025-02-03 21:40:00","inspection_id":"83768893","dot_number":"3834347","report_state":"CA","report_number":"NB7F001423","insp_date":"2025-01-31 00:00:00","insp_start_time":"1026","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"TRACY CHP AREA OFFICE","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15689487","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-02-03 21:40:00","snet_input_date":"2025-01-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-03 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[{"id":12151818,"change_date":"2025-02-03 21:40:00","inspection_id":"83768893","insp_violation_id":"264316918","seq_no":"1","part_no":"393","part_no_section":"78-WOOS","insp_viol_unit":"1","insp_unit_id":"205137765","insp_violation_category_id":"26","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39378WOOS"},{"id":12151819,"change_date":"2025-02-03 21:40:00","inspection_id":"83768893","insp_violation_id":"264316919","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205137765","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39378AWS"},{"id":12151820,"change_date":"2025-02-03 21:40:00","inspection_id":"83768893","insp_violation_id":"264316920","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"205137765","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":12549839,"change_date":"2025-02-03 21:40:00","inspection_id":"83768893","insp_unit_id":"205137765","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1318","insp_unit_license":"ZP23886","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7HLJJ8110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"},{"id":12549840,"change_date":"2025-02-03 21:40:00","inspection_id":"83768893","insp_unit_id":"205137766","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1302","insp_unit_license":"C485177","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2539FU161805","insp_unit_decal":"Y","insp_unit_decal_number":"34761176","created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":7705658,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","dot_number":"3834347","report_state":"CA","report_number":"NB7F001416","insp_date":"2025-01-23 00:00:00","insp_start_time":"1431","insp_end_time":"1512","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"TRACY CHP AREA OFFICE","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15676586","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:58:16.000000Z","updated_at":"2025-03-17T20:58:16.000000Z","inspection_violations":[{"id":12039359,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","insp_violation_id":"264169625","seq_no":"1","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"205000227","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"39343DBIPBS"},{"id":12039360,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","insp_violation_id":"264169626","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"205000227","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"39347E"},{"id":12039361,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","insp_violation_id":"264169627","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"205000227","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"3963A1BOS"},{"id":12039362,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","insp_violation_id":"264169628","seq_no":"4","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"205000226","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":12434415,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","insp_unit_id":"205000226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"Y","insp_unit_decal_number":"34761173","created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"},{"id":12434416,"change_date":"2025-01-24 21:40:00","inspection_id":"83694629","insp_unit_id":"205000227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4118","insp_unit_license":"C465329","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"}]},{"id":7723591,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","dot_number":"3834347","report_state":"AR","report_number":"4220000821","insp_date":"2025-01-23 00:00:00","insp_start_time":"1700","insp_end_time":"1820","registration_date":null,"region":"CS","ci_status_code":"C","location":"302","location_desc":"VAN BUREN AR","county_code_state":"AR","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PARKER MIGLIORINI INTERNATIONAL","shipping_paper_number":"OR-56553","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","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":"1294522","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2025-01-28 21:38:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-28 21:38:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:40.000000Z","updated_at":"2025-03-17T20:58:40.000000Z","inspection_violations":[{"id":12068099,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206346","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205034798","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"39617CPI"},{"id":12068100,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206347","seq_no":"2","part_no":"393","part_no_section":"203A-CBP","insp_viol_unit":"1","insp_unit_id":"205034798","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"393203ACBP"},{"id":12068101,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206348","seq_no":"3","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"205034798","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3963A1BALR"},{"id":12068102,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206349","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205034799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3939ALIL"},{"id":12068103,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206350","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"205034799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3939ALCL"},{"id":12068104,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206351","seq_no":"6","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"205034799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3939ALCL"},{"id":12068105,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206352","seq_no":"7","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"205034799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3939ALSML"},{"id":12068106,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206353","seq_no":"8","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"205034799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3939ALSML"},{"id":12068107,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206354","seq_no":"9","part_no":"395","part_no_section":"3A3II","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-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3953A3II"},{"id":12068108,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_violation_id":"264206355","seq_no":"10","part_no":"395","part_no_section":"32B-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"39532BELDDFR"}],"inspection_per_units":[{"id":12463749,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_unit_id":"205034798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"AP02","insp_unit_license":"YP30031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG3HN978308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:31.000000Z","updated_at":"2025-03-17T23:52:31.000000Z"},{"id":12463750,"change_date":"2025-01-28 21:38:00","inspection_id":"83713410","insp_unit_id":"205034799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1303","insp_unit_license":"4RL6778","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532BXJL049091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:31.000000Z","updated_at":"2025-03-17T23:52:31.000000Z"}]},{"id":7204065,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","dot_number":"3834347","report_state":"NM","report_number":"1844O8UKVR","insp_date":"2024-11-13 00:00:00","insp_start_time":"1535","insp_end_time":"1620","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"NARA VISA PORT OF ENTRY","county_code_state":"NM","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UNIVERSAL PURE","shipping_paper_number":"SO56965","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2128813","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-11-15 21:42:00","snet_input_date":"2024-11-15 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-11-15 21:42:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:25.000000Z","updated_at":"2025-03-17T20:46:25.000000Z","inspection_violations":[{"id":11257989,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","insp_violation_id":"262919453","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"203902633","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39355E"},{"id":11257990,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","insp_violation_id":"262919454","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"203902633","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39375C"},{"id":11257991,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","insp_violation_id":"262919455","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"203902633","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39375C"},{"id":11257992,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","insp_violation_id":"262919456","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"203902633","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:37.000000Z","updated_at":"2025-03-17T22:00:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11620105,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","insp_unit_id":"203902632","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":"UNIT 5911","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"},{"id":11620106,"change_date":"2024-11-15 21:42:00","inspection_id":"83167103","insp_unit_id":"203902633","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"UNIT 4118","insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"}]},{"id":7185401,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","dot_number":"3834347","report_state":"NE","report_number":"T370001661","insp_date":"2024-11-12 00:00:00","insp_start_time":"1927","insp_end_time":"2003","registration_date":null,"region":"CT","ci_status_code":"C","location":"5","location_desc":"HEBRON 81 SCALE","county_code_state":"NE","county_code":"169","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"02 LINCOLN","shipping_paper_number":"SO56965","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"801940","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":"M","census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:59.000000Z","updated_at":"2025-03-17T20:45:59.000000Z","inspection_violations":[{"id":11228646,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","insp_violation_id":"262875636","seq_no":"1","part_no":"392","part_no_section":"2MI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EA5604772","created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3922MI"},{"id":11228647,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","insp_violation_id":"262875637","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3922SLLEWA1"},{"id":11228648,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","insp_violation_id":"262875638","seq_no":"3","part_no":"395","part_no_section":"24D","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-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"39524D"},{"id":11228649,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","insp_violation_id":"262875639","seq_no":"4","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":11589721,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","insp_unit_id":"203863376","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5911","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:04.000000Z","updated_at":"2025-03-17T23:43:04.000000Z"},{"id":11589722,"change_date":"2024-11-13 21:40:00","inspection_id":"83147398","insp_unit_id":"203863377","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"4118","insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:04.000000Z","updated_at":"2025-03-17T23:43:04.000000Z"}]},{"id":7054733,"change_date":"2025-05-07 21:45:00","inspection_id":"83008964","dot_number":"3834347","report_state":"TN","report_number":"I023K20906","insp_date":"2024-10-25 00:00:00","insp_start_time":"0926","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":"UNK","location_desc":"INTERSTATE 24","county_code_state":"TN","county_code":"147","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M020","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-27 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1780735","transaction_code":"C","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-10-27 21:33:00","snet_input_date":"2024-10-25 00:00:00","source_office":"2TNS001","mcmis_add_date":"2024-10-27 21:33:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:03.000000Z","updated_at":"2025-05-11T10:16:40.000000Z","inspection_violations":[{"id":13598276,"change_date":"2025-05-07 21:45:00","inspection_id":"83008964","insp_violation_id":"266072907","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-09T11:22:26.000000Z","updated_at":"2025-05-10T11:37:45.000000Z","normalized_code":"3922SLLUP"}],"inspection_per_units":[{"id":13963427,"change_date":"2025-05-07 21:45:00","inspection_id":"83008964","insp_unit_id":"206710811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1313","insp_unit_license":"ZP09257","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"1FUJHHDR2KLKH4133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:39:02.000000Z","updated_at":"2025-05-11T03:27:12.000000Z"},{"id":13963428,"change_date":"2025-05-07 21:45:00","inspection_id":"83008964","insp_unit_id":"206710812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"7511","insp_unit_license":"4VR1265","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"1GR1A062XNE417524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:39:02.000000Z","updated_at":"2025-05-11T03:27:12.000000Z"}]},{"id":6840753,"change_date":"2024-09-27 21:40:00","inspection_id":"82781570","dot_number":"3834347","report_state":"CA","report_number":"NB7F001297","insp_date":"2024-09-20 00:00:00","insp_start_time":"1031","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"1777 W. LINNE RD, TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15537173","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-09-27 21:40:00","snet_input_date":"2024-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-27 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11031792,"change_date":"2024-09-27 21:40:00","inspection_id":"82781570","insp_unit_id":"203172008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1316","insp_unit_license":"ZP09248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7KN213148","insp_unit_decal":"Y","insp_unit_decal_number":"34146561","created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"},{"id":11031793,"change_date":"2024-09-27 21:40:00","inspection_id":"82781570","insp_unit_id":"203172009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4VT1797","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2357GU451512","insp_unit_decal":"Y","insp_unit_decal_number":"34146562","created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":6436452,"change_date":"2024-08-11 21:32:00","inspection_id":"82350812","dot_number":"3834347","report_state":"AZ","report_number":"XE24760423","insp_date":"2024-08-05 00:00:00","insp_start_time":"1426","insp_end_time":"1442","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZSSMW","location_desc":"SAN SIMON AZ","county_code_state":"AZ","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VANDERBILT MINERALS","shipping_paper_number":"80528162","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-08-11 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"734072","transaction_code":"A","transaction_date":"2024-08-11 00:00:00","upload_date":"2024-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-08-11 21:32:00","snet_input_date":"2024-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-11 21:32:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:20.000000Z","updated_at":"2025-03-17T20:30:20.000000Z","inspection_violations":[{"id":9995183,"change_date":"2024-08-11 21:32:00","inspection_id":"82350812","insp_violation_id":"261121844","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10373592,"change_date":"2024-08-11 21:32:00","inspection_id":"82350812","insp_unit_id":"202328715","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"ZP09249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9KN213149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:30.000000Z","updated_at":"2025-03-17T23:30:30.000000Z"},{"id":10373593,"change_date":"2024-08-11 21:32:00","inspection_id":"82350812","insp_unit_id":"202328716","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"C430793","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2535J6099512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:30.000000Z","updated_at":"2025-03-17T23:30:30.000000Z"}]},{"id":6395761,"change_date":"2024-08-05 21:43:00","inspection_id":"82307209","dot_number":"3834347","report_state":"CA","report_number":"UE2I007659","insp_date":"2024-08-04 00:00:00","insp_start_time":"1056","insp_end_time":"1117","registration_date":null,"region":"PT","ci_status_code":"C","location":"834","location_desc":"NEEDLES AREA (CA\/AZ) STATELINE","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNI-KOOL","shipping_paper_number":"321659","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15469689","transaction_code":"A","transaction_date":"2024-08-04 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-08-05 21:43:00","snet_input_date":"2024-08-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:32.000000Z","updated_at":"2025-03-17T20:29:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10307280,"change_date":"2024-08-05 21:43:00","inspection_id":"82307209","insp_unit_id":"202245309","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862\/WHT","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"Y","insp_unit_decal_number":"34211132","created_at":"2025-03-17T23:29:49.000000Z","updated_at":"2025-03-17T23:29:49.000000Z"},{"id":10307281,"change_date":"2024-08-05 21:43:00","inspection_id":"82307209","insp_unit_id":"202245310","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"87143\/WHT","insp_unit_license":"4UA2226","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW704621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:49.000000Z","updated_at":"2025-03-17T23:29:49.000000Z"}]},{"id":6372504,"change_date":"2024-08-01 21:42:00","inspection_id":"82282347","dot_number":"3834347","report_state":"CA","report_number":"UC5R002861","insp_date":"2024-07-31 00:00:00","insp_start_time":"0950","insp_end_time":"1005","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15467991","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-08-01 21:42:00","snet_input_date":"2024-07-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-01 21:42:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10269117,"change_date":"2024-08-01 21:42:00","inspection_id":"82282347","insp_unit_id":"202199493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"#1316\/WHI","insp_unit_license":"ZP09248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7KN213148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"},{"id":10269118,"change_date":"2024-08-01 21:42:00","inspection_id":"82282347","insp_unit_id":"202199494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"#28675\/WHI","insp_unit_license":"5332967","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL926181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6258872,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","dot_number":"3834347","report_state":"UT","report_number":"24SQ001403","insp_date":"2024-07-18 00:00:00","insp_start_time":"2037","insp_end_time":"2212","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT91","location_desc":"HELPER UT","county_code_state":"UT","county_code":"007","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SANDERSON FARMS","shipping_paper_number":"510119743","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"19","oos_total":"4","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"668119","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[{"id":9721971,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730500","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39345B2"},{"id":9721972,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730501","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39348A"},{"id":9721973,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730502","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39348A"},{"id":9721974,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730503","seq_no":"4","part_no":"392","part_no_section":"15","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39215"},{"id":9721975,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730504","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39345B2"},{"id":9721976,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730505","seq_no":"6","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39378A"},{"id":9721977,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730506","seq_no":"7","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3958E1"},{"id":9721978,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730507","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3963A1"},{"id":9721979,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730508","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3963A1"},{"id":9721980,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730509","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3963A1"},{"id":9721981,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730510","seq_no":"11","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39345B2"},{"id":9721982,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730511","seq_no":"12","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39345B2"},{"id":9721983,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730512","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39348A"},{"id":9721984,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730513","seq_no":"14","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39355E"},{"id":9721985,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730514","seq_no":"15","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39375A3"},{"id":9721986,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730515","seq_no":"16","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"201966390","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39375C"},{"id":9721987,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730516","seq_no":"17","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201966389","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3939A"},{"id":9721988,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730517","seq_no":"18","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3953A3I"},{"id":9721989,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_violation_id":"260730518","seq_no":"19","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10084208,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_unit_id":"201966389","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1317","insp_unit_license":"ZP30500","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR5HLHX1537","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"},{"id":10084209,"change_date":"2024-07-19 21:37:00","inspection_id":"82160747","insp_unit_id":"201966390","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"5311","insp_unit_license":"C430793","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2535J6099512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"}]},{"id":6257030,"change_date":"2024-07-18 21:41:00","inspection_id":"82158766","dot_number":"3834347","report_state":"CA","report_number":"UD7O002496","insp_date":"2024-07-16 00:00:00","insp_start_time":"2223","insp_end_time":"2229","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15447135","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10081226,"change_date":"2024-07-18 21:41:00","inspection_id":"82158766","insp_unit_id":"201962665","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1315\/WHI","insp_unit_license":"ZP09249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9KN213149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"},{"id":10081227,"change_date":"2024-07-18 21:41:00","inspection_id":"82158766","insp_unit_id":"201962666","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1303\/WHI","insp_unit_license":"4RL6778","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532BXJL049091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"}]},{"id":6257134,"change_date":"2024-07-18 21:41:00","inspection_id":"82158874","dot_number":"3834347","report_state":"CA","report_number":"UET6001472","insp_date":"2024-07-14 00:00:00","insp_start_time":"1510","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MT. PASS IF","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMERICOLD","shipping_paper_number":"19832949","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15446906","transaction_code":"A","transaction_date":"2024-07-14 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[{"id":9718788,"change_date":"2024-07-18 21:41:00","inspection_id":"82158874","insp_violation_id":"260725960","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"201962852","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RR65348","created_at":"2025-03-17T21:53:00.000000Z","updated_at":"2025-03-17T21:53:00.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":10081395,"change_date":"2024-07-18 21:41:00","inspection_id":"82158874","insp_unit_id":"201962851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHT 1316","insp_unit_license":"ZP09248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7KN213148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"},{"id":10081396,"change_date":"2024-07-18 21:41:00","inspection_id":"82158874","insp_unit_id":"201962852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT 113","insp_unit_license":"C430792","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2536J6072416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:29.000000Z","updated_at":"2025-03-17T23:27:29.000000Z"}]},{"id":5879542,"change_date":"2024-05-30 21:43:00","inspection_id":"81751327","dot_number":"3834347","report_state":"TX","report_number":"V241440573","insp_date":"2024-05-28 00:00:00","insp_start_time":"1640","insp_end_time":"1700","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 377 MM 546","county_code_state":"TX","county_code":"267","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCH BROTHERS","shipping_paper_number":"1856088","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9288768","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":"M","census_search_date":"2024-05-30 21:43:00","snet_input_date":"2024-05-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-30 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1068242","created_at":"2025-03-17T20:19:08.000000Z","updated_at":"2025-03-17T20:19:08.000000Z","inspection_violations":[{"id":9116653,"change_date":"2024-05-30 21:43:00","inspection_id":"81751327","insp_violation_id":"259821613","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"201162213","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"39311"},{"id":9116654,"change_date":"2024-05-30 21:43:00","inspection_id":"81751327","insp_violation_id":"259821614","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"201162213","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:02.000000Z","updated_at":"2025-03-17T21:50:02.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9469652,"change_date":"2024-05-30 21:43:00","inspection_id":"81751327","insp_unit_id":"201162212","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:13.000000Z","updated_at":"2025-03-17T23:21:13.000000Z"},{"id":9469653,"change_date":"2024-05-30 21:43:00","inspection_id":"81751327","insp_unit_id":"201162213","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"4118","insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:13.000000Z","updated_at":"2025-03-17T23:21:13.000000Z"}]},{"id":5860255,"change_date":"2024-05-28 21:44:00","inspection_id":"81730506","dot_number":"3834347","report_state":"CA","report_number":"NDLR004689","insp_date":"2024-05-24 00:00:00","insp_start_time":"1640","insp_end_time":"1655","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS CVEF","county_code_state":"CA","county_code":"057","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KIKKOMAN","shipping_paper_number":"055943","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15380221","transaction_code":"A","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-05-28 21:44:00","snet_input_date":"2024-05-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-28 21:44:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:01.000000Z","updated_at":"2025-03-17T20:19:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9438603,"change_date":"2024-05-28 21:44:00","inspection_id":"81730506","insp_unit_id":"201121792","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862\/WHT","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"},{"id":9438604,"change_date":"2024-05-28 21:44:00","inspection_id":"81730506","insp_unit_id":"201121793","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1313\/WHT","insp_unit_license":"4VT1797","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2357GU451512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"}]},{"id":5722420,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","dot_number":"3834347","report_state":"CA","report_number":"ND6V006244","insp_date":"2024-05-09 00:00:00","insp_start_time":"1154","insp_end_time":"1216","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15357344","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-05-10 21:39:00","snet_input_date":"2024-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-10 21:39:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T20:16:15.000000Z","updated_at":"2025-03-17T20:16:15.000000Z","inspection_violations":[{"id":8854558,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","insp_violation_id":"259443795","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200840046","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"KU57938","created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"39348A"},{"id":8854559,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","insp_violation_id":"259443796","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200840047","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA273794","created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"3922"},{"id":8854560,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","insp_violation_id":"259443797","seq_no":"3","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"200840047","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"39375A1"},{"id":8854561,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","insp_violation_id":"259443798","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200840046","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9216876,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","insp_unit_id":"200840046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5911\/ORG","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:46.000000Z","updated_at":"2025-03-17T23:18:46.000000Z"},{"id":9216877,"change_date":"2024-05-10 21:39:00","inspection_id":"81581148","insp_unit_id":"200840047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT","insp_unit_license":"4UA2226","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW704621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:46.000000Z","updated_at":"2025-03-17T23:18:46.000000Z"}]},{"id":5677465,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","dot_number":"3834347","report_state":"KS","report_number":"HP93322766","insp_date":"2024-05-01 00:00:00","insp_start_time":"1222","insp_end_time":"1407","registration_date":null,"region":"CT","ci_status_code":"C","location":"SW","location_desc":"SEWARD COUNTY - 175","county_code_state":"KS","county_code":"175","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FAMILY TREE FARMS","shipping_paper_number":"573598","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"11","oos_total":"0","driver_viol_total":"9","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1324003","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-05-06 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-05-06 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:08.000000Z","updated_at":"2025-03-17T20:15:08.000000Z","inspection_violations":[{"id":8782735,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334528","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200744254","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39617C"},{"id":8782736,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334529","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200744255","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39617C"},{"id":8782737,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334530","seq_no":"3","part_no":"392","part_no_section":"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:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"3922"},{"id":8782738,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334531","seq_no":"4","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39530B1"},{"id":8782739,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334532","seq_no":"5","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39524C2III"},{"id":8782740,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334533","seq_no":"6","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39524C2III"},{"id":8782741,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334534","seq_no":"7","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39524C2III"},{"id":8782742,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334535","seq_no":"8","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39524C2II"},{"id":8782743,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334536","seq_no":"9","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39524C2II"},{"id":8782744,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334537","seq_no":"10","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39524C2II"},{"id":8782745,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_violation_id":"259334538","seq_no":"11","part_no":"395","part_no_section":"34(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:30.000000Z","updated_at":"2025-03-17T21:48:30.000000Z","normalized_code":"39534A1"}],"inspection_per_units":[{"id":9144544,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_unit_id":"200744254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"ZP04208","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN213383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:05.000000Z","updated_at":"2025-03-17T23:18:05.000000Z"},{"id":9144545,"change_date":"2024-05-06 21:43:00","inspection_id":"81532372","insp_unit_id":"200744255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B101","insp_unit_license":"4VB1365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2532GU452308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:05.000000Z","updated_at":"2025-03-17T23:18:05.000000Z"}]},{"id":5490380,"change_date":"2024-04-11 21:41:00","inspection_id":"81328654","dot_number":"3834347","report_state":"NC","report_number":"0006638473","insp_date":"2024-04-10 00:00:00","insp_start_time":"1003","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-85 N","location_desc":"I-85 NB NEAR MM 72","county_code_state":"NC","county_code":"159","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"STARR RANCH GROWERS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2172307","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":"M","census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[{"id":8479388,"change_date":"2024-04-11 21:41:00","inspection_id":"81328654","insp_violation_id":"258880348","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","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:47:02.000000Z","updated_at":"2025-03-17T21:47:02.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":8844020,"change_date":"2024-04-11 21:41:00","inspection_id":"81328654","insp_unit_id":"200353793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"ZP09257","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR2KLKH4133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:15.000000Z","updated_at":"2025-03-17T23:15:15.000000Z"},{"id":8844021,"change_date":"2024-04-11 21:41:00","inspection_id":"81328654","insp_unit_id":"200353794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"827058","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1UYVS2535J6099512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:15.000000Z","updated_at":"2025-03-17T23:15:15.000000Z"}]},{"id":5476138,"change_date":"2024-04-11 21:40:00","inspection_id":"81312854","dot_number":"3834347","report_state":"WA","report_number":"2132000269","insp_date":"2024-04-05 00:00:00","insp_start_time":"1051","insp_end_time":"1250","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC53","location_desc":"CLE ELUM WA","county_code_state":"WA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NA","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","viol_total":"4","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":"387816","transaction_code":"C","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-04-10 21:41:00","snet_input_date":"2024-04-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-10 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:12.000000Z","updated_at":"2025-03-17T20:11:12.000000Z","inspection_violations":[{"id":8456198,"change_date":"2024-04-11 21:40:00","inspection_id":"81312854","insp_violation_id":"258875619","seq_no":"1","part_no":"382","part_no_section":"501(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:56.000000Z","updated_at":"2025-03-17T21:46:56.000000Z","normalized_code":"382501A"},{"id":8456199,"change_date":"2024-04-11 21:40:00","inspection_id":"81312854","insp_violation_id":"258875620","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4A0366552","created_at":"2025-03-17T21:46:56.000000Z","updated_at":"2025-03-17T21:46:56.000000Z","normalized_code":"3922"},{"id":8456200,"change_date":"2024-04-11 21:40:00","inspection_id":"81312854","insp_violation_id":"258875621","seq_no":"3","part_no":"395","part_no_section":"34(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:56.000000Z","updated_at":"2025-03-17T21:46:56.000000Z","normalized_code":"39534A1"},{"id":8456201,"change_date":"2024-04-11 21:40:00","inspection_id":"81312854","insp_violation_id":"258875622","seq_no":"4","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"200349553","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:56.000000Z","updated_at":"2025-03-17T21:46:56.000000Z","normalized_code":"39378A"}],"inspection_per_units":[{"id":8820984,"change_date":"2024-04-11 21:40:00","inspection_id":"81312854","insp_unit_id":"200349553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1313","insp_unit_license":"ZP09257","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR2KLKH4133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:04.000000Z","updated_at":"2025-03-17T23:15:04.000000Z"}]},{"id":5229507,"change_date":"2024-03-06 21:41:00","inspection_id":"81043446","dot_number":"3834347","report_state":"CA","report_number":"UFEP003807","insp_date":"2024-03-04 00:00:00","insp_start_time":"1330","insp_end_time":"1356","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"I-80 AT APPLEGATE","county_code_state":"CA","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15270385","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-03-06 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-06 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:13.000000Z","updated_at":"2025-03-17T20:06:13.000000Z","inspection_violations":[{"id":8062915,"change_date":"2024-03-06 21:41:00","inspection_id":"81043446","insp_violation_id":"258249910","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8421056,"change_date":"2024-03-06 21:41:00","inspection_id":"81043446","insp_unit_id":"199794142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YP30031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG3HN978308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"},{"id":8421057,"change_date":"2024-03-06 21:41:00","inspection_id":"81043446","insp_unit_id":"199794143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4UH2778","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C6JR171176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"}]},{"id":5103668,"change_date":"2024-03-06 21:40:00","inspection_id":"80906591","dot_number":"3834347","report_state":"TX","report_number":"V241326743","insp_date":"2024-02-16 00:00:00","insp_start_time":"0830","insp_end_time":"0851","registration_date":null,"region":"CT","ci_status_code":"C","location":"5A405","location_desc":"IH 40 SHAMROCK","county_code_state":"TX","county_code":"483","insp_level_id":"2","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":"Y","pen_cen_match":null,"final_status_date":"2024-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9203632","transaction_code":"C","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":"M","census_search_date":"2024-02-21 21:40:00","snet_input_date":"2024-02-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-21 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1068242","created_at":"2025-03-17T20:03:47.000000Z","updated_at":"2025-03-17T20:03:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8216655,"change_date":"2024-03-06 21:40:00","inspection_id":"80906591","insp_unit_id":"199789295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"AP02","insp_unit_license":"YP30031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG3HN978308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"},{"id":8216656,"change_date":"2024-03-06 21:40:00","inspection_id":"80906591","insp_unit_id":"199789296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"87143","insp_unit_license":"4UA2226","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW704621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"}]},{"id":5046811,"change_date":"2024-02-14 21:41:00","inspection_id":"80844551","dot_number":"3834347","report_state":"SD","report_number":"5290001391","insp_date":"2024-02-13 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"VALLEY SPRINGS SD","county_code_state":"SD","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"US FOODS","shipping_paper_number":"4175824","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","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":"241743","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-02-14 21:41:00","snet_input_date":"2024-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-14 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:44.000000Z","updated_at":"2025-03-17T20:02:44.000000Z","inspection_violations":[{"id":7777943,"change_date":"2024-02-14 21:41:00","inspection_id":"80844551","insp_violation_id":"257827252","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"199413989","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:43:34.000000Z","updated_at":"2025-03-17T21:43:34.000000Z","normalized_code":"39375A3TAOL"},{"id":7777944,"change_date":"2024-02-14 21:41:00","inspection_id":"80844551","insp_violation_id":"257827253","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"199413989","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:43:34.000000Z","updated_at":"2025-03-17T21:43:34.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":8124106,"change_date":"2024-02-14 21:41:00","inspection_id":"80844551","insp_unit_id":"199413988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"ZP09249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH9KN213149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:36.000000Z","updated_at":"2025-03-17T23:08:36.000000Z"},{"id":8124107,"change_date":"2024-02-14 21:41:00","inspection_id":"80844551","insp_unit_id":"199413989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4RL6778","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532BXJL049091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:36.000000Z","updated_at":"2025-03-17T23:08:36.000000Z"}]},{"id":5015398,"change_date":"2024-02-09 21:40:00","inspection_id":"80810252","dot_number":"3834347","report_state":"CO","report_number":"1237600069","insp_date":"2024-01-31 00:00:00","insp_start_time":"1845","insp_end_time":"1930","registration_date":null,"region":"MS","ci_status_code":"C","location":"TRDPOE","location_desc":"TRINIDAD CO","county_code_state":"CO","county_code":"071","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TAYLOR FARMS CALIFORNIA, INC.","shipping_paper_number":"1696413","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-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"231006","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2024-02-09 21:40:00","snet_input_date":"2024-01-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-09 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:03.000000Z","updated_at":"2025-03-17T20:02:03.000000Z","inspection_violations":[{"id":7726937,"change_date":"2024-02-09 21:40:00","inspection_id":"80810252","insp_violation_id":"257754048","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"199348147","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39617CPI"},{"id":7726938,"change_date":"2024-02-09 21:40:00","inspection_id":"80810252","insp_violation_id":"257754049","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"199348146","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":8072367,"change_date":"2024-02-09 21:40:00","inspection_id":"80810252","insp_unit_id":"199348146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1313","insp_unit_license":"ZP09257","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHHDR2KLKH4133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:09.000000Z","updated_at":"2025-03-17T23:08:09.000000Z"},{"id":8072368,"change_date":"2024-02-09 21:40:00","inspection_id":"80810252","insp_unit_id":"199348147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"113","insp_unit_license":"4SP8742","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536J6072416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:09.000000Z","updated_at":"2025-03-17T23:08:09.000000Z"}]},{"id":4863709,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","dot_number":"3834347","report_state":"WA","report_number":"2080000109","insp_date":"2024-01-16 00:00:00","insp_start_time":"1225","insp_end_time":"1340","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC54","location_desc":"PLYMOUTH WA","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRESHPOINT S CALIFORNIA","shipping_paper_number":"88458","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-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","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":"185561","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":"03834347","upload_search_indicator":null,"census_search_date":"2024-01-19 21:43:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-19 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","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":7497487,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","insp_violation_id":"257409782","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"199025849","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":"39355EB"},{"id":7497488,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","insp_violation_id":"257409783","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"199025849","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":"3939ALSML"},{"id":7497489,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","insp_violation_id":"257409784","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","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:42:09.000000Z","updated_at":"2025-03-17T21:42:09.000000Z","normalized_code":"38323A2LCDLN"},{"id":7497490,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","insp_violation_id":"257409785","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"199025849","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":7825359,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","insp_unit_id":"199025848","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:56.000000Z","updated_at":"2025-03-17T23:05:56.000000Z"},{"id":7825360,"change_date":"2024-01-19 21:43:00","inspection_id":"80644161","insp_unit_id":"199025849","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"5381","insp_unit_license":"259628B","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2530GU511484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:56.000000Z","updated_at":"2025-03-17T23:05:56.000000Z"}]},{"id":4703300,"change_date":"2023-12-26 21:40:00","inspection_id":"80469140","dot_number":"3834347","report_state":"AZ","report_number":"0321002031","insp_date":"2023-12-22 00:00:00","insp_start_time":"1423","insp_end_time":"1512","registration_date":null,"region":"PT","ci_status_code":"C","location":"611504","location_desc":"SR 85 MP 151 SB","county_code_state":"AZ","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1847369","transaction_code":"A","transaction_date":"2023-12-22 00:00:00","upload_date":"2023-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-12-26 21:40:00","snet_input_date":"2023-12-26 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-12-26 21:40:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:08.000000Z","updated_at":"2025-03-17T19:56:08.000000Z","inspection_violations":[{"id":7264546,"change_date":"2023-12-26 21:40:00","inspection_id":"80469140","insp_violation_id":"257050099","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"913058223356002","created_at":"2025-03-17T21:41:06.000000Z","updated_at":"2025-03-17T21:41:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7565227,"change_date":"2023-12-26 21:40:00","inspection_id":"80469140","insp_unit_id":"198666358","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1316","insp_unit_license":"ZP09248","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7KN213148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:38.000000Z","updated_at":"2025-03-17T23:03:38.000000Z"},{"id":7565228,"change_date":"2023-12-26 21:40:00","inspection_id":"80469140","insp_unit_id":"198666359","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1312","insp_unit_license":"4RT3530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2533J2315302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:38.000000Z","updated_at":"2025-03-17T23:03:38.000000Z"}]},{"id":4484951,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","dot_number":"3834347","report_state":"WA","report_number":"0813000030","insp_date":"2023-11-22 00:00:00","insp_start_time":"1345","insp_end_time":"1500","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-24 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"13","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":"106315","transaction_code":"A","transaction_date":"2023-11-24 00:00:00","upload_date":"2023-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-11-24 21:32:00","snet_input_date":"2023-11-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-24 21:32:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:47.000000Z","updated_at":"2025-03-17T19:51:47.000000Z","inspection_violations":[{"id":6941882,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541829","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"198192823","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39617CPI"},{"id":6941883,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541830","seq_no":"2","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"198192822","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"3929A2C"},{"id":6941884,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541831","seq_no":"3","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0808133A","created_at":"2025-03-17T21:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39216D"},{"id":6941885,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541832","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"198192822","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0808133B","created_at":"2025-03-17T21:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"3922SLLSR"},{"id":6941886,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541833","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"198192822","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"3939ALSLI"},{"id":6941887,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541834","seq_no":"6","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"},{"id":6941888,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541835","seq_no":"7","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"},{"id":6941889,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541836","seq_no":"8","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"198192822","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"3939ALTSIR"},{"id":6941890,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541837","seq_no":"9","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"},{"id":6941891,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541838","seq_no":"10","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"},{"id":6941892,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541839","seq_no":"11","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"},{"id":6941893,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541840","seq_no":"12","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"},{"id":6941894,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_violation_id":"256541841","seq_no":"13","part_no":"395","part_no_section":"30B1-ELDDFR","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:39:31.000000Z","updated_at":"2025-03-17T21:39:31.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":7212839,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_unit_id":"198192822","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"ZP04208","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH6KN213383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:35.000000Z","updated_at":"2025-03-17T23:00:35.000000Z"},{"id":7212840,"change_date":"2023-11-24 21:32:00","inspection_id":"80229288","insp_unit_id":"198192823","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"4SP8742","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536J6072416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:35.000000Z","updated_at":"2025-03-17T23:00:35.000000Z"}]},{"id":4434279,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","dot_number":"3834347","report_state":"WA","report_number":"W604010198","insp_date":"2023-11-07 00:00:00","insp_start_time":"1007","insp_end_time":"1139","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC75","location_desc":"SC75   GOLDENDALE","county_code_state":"WA","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CHELAN FRESH","shipping_paper_number":"5873","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116300","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2602742","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-11-15 21:42:00","snet_input_date":"2023-11-15 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-11-15 21:42:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:44.000000Z","updated_at":"2025-03-17T19:50:44.000000Z","inspection_violations":[{"id":6862872,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_violation_id":"256417534","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0685871","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6862873,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_violation_id":"256417535","seq_no":"2","part_no":"392","part_no_section":"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":"3A0685871","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6862874,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_violation_id":"256417536","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198080036","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"39360C"},{"id":6862875,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_violation_id":"256417537","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198080036","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3939A"},{"id":6862876,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_violation_id":"256417538","seq_no":"5","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"198080036","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"393203C"},{"id":6862877,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_violation_id":"256417539","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198080037","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7131190,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_unit_id":"198080036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"ZP04208","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN213383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"},{"id":7131191,"change_date":"2023-11-15 21:42:00","inspection_id":"80173692","insp_unit_id":"198080037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B101","insp_unit_license":"4VB1365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2532GU452308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"}]},{"id":4341921,"change_date":"2023-11-02 21:42:00","inspection_id":"80071478","dot_number":"3834347","report_state":"IL","report_number":"4180530593","insp_date":"2023-10-31 00:00:00","insp_start_time":"0756","insp_end_time":"0841","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I74","county_code_state":"IL","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCH BROTHERS","shipping_paper_number":"CHURCH BROTHERS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","viol_total":"2","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":"2290794","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-10-31 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"139208","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:04.000000Z","updated_at":"2025-03-17T19:49:04.000000Z","inspection_violations":[{"id":6716347,"change_date":"2023-11-02 21:42:00","inspection_id":"80071478","insp_violation_id":"256188515","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"3958E1"},{"id":6716348,"change_date":"2023-11-02 21:42:00","inspection_id":"80071478","insp_violation_id":"256188516","seq_no":"2","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"1","insp_unit_id":"197879716","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"393203E"}],"inspection_per_units":[{"id":6983026,"change_date":"2023-11-02 21:42:00","inspection_id":"80071478","insp_unit_id":"197879716","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"115","insp_unit_license":"ZP04208","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN213383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:37.000000Z","updated_at":"2025-03-17T22:58:37.000000Z"},{"id":6983027,"change_date":"2023-11-02 21:42:00","inspection_id":"80071478","insp_unit_id":"197879717","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B101","insp_unit_license":"4VB1365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2532GU452308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:37.000000Z","updated_at":"2025-03-17T22:58:37.000000Z"}]},{"id":4256918,"change_date":"2023-10-23 21:41:00","inspection_id":"79977397","dot_number":"3834347","report_state":"IL","report_number":"4004500234","insp_date":"2023-09-23 00:00:00","insp_start_time":"1602","insp_end_time":"1656","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WALMART INC","shipping_paper_number":"123456000003319","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2284513","transaction_code":"A","transaction_date":"2023-09-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-10-23 21:41:00","snet_input_date":"2023-09-23 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"139208","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:06.000000Z","updated_at":"2025-03-17T19:47:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6845812,"change_date":"2023-10-23 21:41:00","inspection_id":"79977397","insp_unit_id":"197688061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:24.000000Z","updated_at":"2025-03-17T22:57:24.000000Z"}]},{"id":3781005,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","dot_number":"3834347","report_state":"CA","report_number":"UEV6002921","insp_date":"2023-08-16 00:00:00","insp_start_time":"0620","insp_end_time":"0715","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"BASELINE\/WATT AVE","county_code_state":"CA","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NATURAL BRANDS INC","shipping_paper_number":"914498","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15028234","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"606149","created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[{"id":5833778,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_violation_id":"254753123","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3922"},{"id":5833779,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_violation_id":"254753124","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KS82011","created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3958E1"},{"id":5833780,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_violation_id":"254753125","seq_no":"3","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39524C2III"},{"id":5833781,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_violation_id":"254753126","seq_no":"4","part_no":"395","part_no_section":"22(h)(2)","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-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39522H2"},{"id":5833782,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_violation_id":"254753127","seq_no":"5","part_no":"395","part_no_section":"32(b)","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-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39532B"}],"inspection_per_units":[{"id":6079484,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_unit_id":"196617910","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5911","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:04.000000Z","updated_at":"2025-03-17T22:51:04.000000Z"},{"id":6079485,"change_date":"2023-08-18 21:42:00","inspection_id":"79448693","insp_unit_id":"196617911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4118","insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:04.000000Z","updated_at":"2025-03-17T22:51:04.000000Z"}]},{"id":3656218,"change_date":"2023-08-02 21:41:00","inspection_id":"79309298","dot_number":"3834347","report_state":"WA","report_number":"W540000735","insp_date":"2023-08-02 00:00:00","insp_start_time":"0615","insp_end_time":"0637","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"TANIMURA & ANTLE INC","shipping_paper_number":"SO21796925","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2584505","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:58.000000Z","updated_at":"2025-03-17T19:34:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5879145,"change_date":"2023-08-02 21:41:00","inspection_id":"79309298","insp_unit_id":"196332537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"},{"id":5879146,"change_date":"2023-08-02 21:41:00","inspection_id":"79309298","insp_unit_id":"196332538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B101","insp_unit_license":"4VB1365","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2532GU452308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3634251,"change_date":"2023-07-31 21:41:00","inspection_id":"79284841","dot_number":"3834347","report_state":"UT","report_number":"23FX000276","insp_date":"2023-07-30 00:00:00","insp_start_time":"1140","insp_end_time":"1225","registration_date":null,"region":"MT","ci_status_code":"C","location":"51","location_desc":"ST GEORGE PORT OF ENTRY NORTHB","county_code_state":"UT","county_code":"053","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TAYLOR FARMS","shipping_paper_number":"1642202","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"890349","transaction_code":"A","transaction_date":"2023-07-30 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-07-31 21:41:00","snet_input_date":"2023-07-30 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-07-31 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:35.000000Z","updated_at":"2025-03-17T19:34:35.000000Z","inspection_violations":[{"id":5603888,"change_date":"2023-07-31 21:41:00","inspection_id":"79284841","insp_violation_id":"254378845","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196283766","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"3922"},{"id":5603889,"change_date":"2023-07-31 21:41:00","inspection_id":"79284841","insp_violation_id":"254378846","seq_no":"2","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39524C2II"},{"id":5603890,"change_date":"2023-07-31 21:41:00","inspection_id":"79284841","insp_violation_id":"254378847","seq_no":"3","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"39524C2III"}],"inspection_per_units":[{"id":5843452,"change_date":"2023-07-31 21:41:00","inspection_id":"79284841","insp_unit_id":"196283766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"AP02","insp_unit_license":"YP30031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG3HN978308","insp_unit_decal":"Y","insp_unit_decal_number":"03304903","created_at":"2025-03-17T22:49:08.000000Z","updated_at":"2025-03-17T22:49:08.000000Z"},{"id":5843453,"change_date":"2023-07-31 21:41:00","inspection_id":"79284841","insp_unit_id":"196283767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1313","insp_unit_license":"4VH2778","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537GU451512","insp_unit_decal":"Y","insp_unit_decal_number":"03300494","created_at":"2025-03-17T22:49:08.000000Z","updated_at":"2025-03-17T22:49:08.000000Z"}]},{"id":2945615,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","dot_number":"3834347","report_state":"OR","report_number":"AAAK005653","insp_date":"2023-05-01 00:00:00","insp_start_time":"0708","insp_end_time":"0756","registration_date":"2023-05-10 00:00:00","region":"MT","ci_status_code":"C","location":"2306","location_desc":"FAREWELL BEND POE","county_code_state":"OR","county_code":"045","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"RAY FARMS","shipping_paper_number":"GA0020382","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53350","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1224112","transaction_code":"C","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"001859","created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[{"id":4522657,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_violation_id":"252752890","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194862059","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39347E"},{"id":4522658,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_violation_id":"252752891","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"194862059","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39353B"},{"id":4522659,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_violation_id":"252752892","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194862059","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39348A"},{"id":4522660,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_violation_id":"252752893","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194862059","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39348A"},{"id":4522661,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_violation_id":"252752894","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194862059","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4739667,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_unit_id":"194862058","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6862","insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:21.000000Z","updated_at":"2025-03-17T22:40:21.000000Z"},{"id":4739668,"change_date":"2023-05-10 21:42:00","inspection_id":"78509132","insp_unit_id":"194862059","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B101","insp_unit_license":"4VB1365","insp_unit_license_state":"BC","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:21.000000Z","updated_at":"2025-03-17T22:40:21.000000Z"}]},{"id":2660870,"change_date":"2023-03-24 21:41:00","inspection_id":"78185435","dot_number":"3834347","report_state":"CA","report_number":"UEX8002837","insp_date":"2023-03-22 00:00:00","insp_start_time":"1655","insp_end_time":"1715","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14831655","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:49.000000Z","updated_at":"2025-03-17T19:15:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4283964,"change_date":"2023-03-24 21:41:00","inspection_id":"78185435","insp_unit_id":"194064007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"},{"id":4283965,"change_date":"2023-03-24 21:41:00","inspection_id":"78185435","insp_unit_id":"194064008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"}]},{"id":2660333,"change_date":"2023-03-24 21:41:00","inspection_id":"78184842","dot_number":"3834347","report_state":"CA","report_number":"UE2C003391","insp_date":"2023-03-20 00:00:00","insp_start_time":"1010","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14831842","transaction_code":"A","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:49.000000Z","updated_at":"2025-03-17T19:15:49.000000Z","inspection_violations":[{"id":4089861,"change_date":"2023-03-24 21:41:00","inspection_id":"78184842","insp_violation_id":"251868778","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194063023","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA392505","created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4283117,"change_date":"2023-03-24 21:41:00","inspection_id":"78184842","insp_unit_id":"194063022","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X ORN","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"Y","insp_unit_decal_number":"32142133","created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"},{"id":4283118,"change_date":"2023-03-24 21:41:00","inspection_id":"78184842","insp_unit_id":"194063023","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2X VAN","insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"}]},{"id":2595780,"change_date":"2023-03-20 21:41:00","inspection_id":"78112029","dot_number":"3834347","report_state":"MT","report_number":"H655000421","insp_date":"2023-03-15 00:00:00","insp_start_time":"1945","insp_end_time":"2028","registration_date":"2023-03-20 00:00:00","region":"MT","ci_status_code":"C","location":"0655","location_desc":"BUTTE WB SCALE","county_code_state":"MT","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARGILL","shipping_paper_number":"176238","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"987996","transaction_code":"C","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-16 00:00:00","source_office":"4MTS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:30.000000Z","updated_at":"2025-03-17T19:14:30.000000Z","inspection_violations":[{"id":3992525,"change_date":"2023-03-20 21:41:00","inspection_id":"78112029","insp_violation_id":"251760005","seq_no":"1","part_no":"392","part_no_section":"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":"530 A169177 M","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4178130,"change_date":"2023-03-20 21:41:00","inspection_id":"78112029","insp_unit_id":"193961036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP89902","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0RJ266693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"},{"id":4178131,"change_date":"2023-03-20 21:41:00","inspection_id":"78112029","insp_unit_id":"193961037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4RP6754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0623HE701033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"}]},{"id":2596392,"change_date":"2023-03-16 21:43:00","inspection_id":"78112725","dot_number":"3834347","report_state":"UT","report_number":"23LB000148","insp_date":"2023-03-15 00:00:00","insp_start_time":"1330","insp_end_time":"1353","registration_date":null,"region":"MT","ci_status_code":"C","location":"I-80","location_desc":"I-80","county_code_state":"UT","county_code":"043","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COOLSTOR","shipping_paper_number":"S18262","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"876722","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":null,"census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-15 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:30.000000Z","updated_at":"2025-03-17T19:14:30.000000Z","inspection_violations":[{"id":3993092,"change_date":"2023-03-16 21:43:00","inspection_id":"78112725","insp_violation_id":"251712086","seq_no":"1","part_no":"392","part_no_section":"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":"C181042425","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4179258,"change_date":"2023-03-16 21:43:00","inspection_id":"78112725","insp_unit_id":"193917911","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":null,"insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"},{"id":4179259,"change_date":"2023-03-16 21:43:00","inspection_id":"78112725","insp_unit_id":"193917912","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"}]},{"id":2410473,"change_date":"2023-02-21 21:41:00","inspection_id":"77901038","dot_number":"3834347","report_state":"OK","report_number":"X311154147","insp_date":"2023-02-17 00:00:00","insp_start_time":"1148","insp_end_time":"1207","registration_date":null,"region":"CT","ci_status_code":"C","location":"044019","location_desc":"TURNER TP AND SH-33","county_code_state":"OK","county_code":"037","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"KROGER","shipping_paper_number":"1877462","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"700115","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":"M","census_search_date":"2023-02-21 21:41:00","snet_input_date":"2023-02-17 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-02-21 21:41:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"1777 W LINNE RD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:04.000000Z","updated_at":"2025-03-17T19:11:04.000000Z","inspection_violations":[{"id":3710603,"change_date":"2023-02-21 21:41:00","inspection_id":"77901038","insp_violation_id":"251238285","seq_no":"1","part_no":"392","part_no_section":"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:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3878448,"change_date":"2023-02-21 21:41:00","inspection_id":"77901038","insp_unit_id":"193490450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5911","insp_unit_license":"YP61698","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6PJ258482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:46.000000Z","updated_at":"2025-03-17T22:33:46.000000Z"},{"id":3878449,"change_date":"2023-02-21 21:41:00","inspection_id":"77901038","insp_unit_id":"193490451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"4118","insp_unit_license":"4TT1826","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA062XHW700388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:46.000000Z","updated_at":"2025-03-17T22:33:46.000000Z"}]},{"id":1084344,"change_date":"2022-08-19 21:35:00","inspection_id":"76376034","dot_number":"3834347","report_state":"AR","report_number":"559C006171","insp_date":"2022-08-19 00:00:00","insp_start_time":"0329","insp_end_time":"0348","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"DRISCOLLS","shipping_paper_number":"03050739","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-19 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1417230","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03834347","upload_search_indicator":"M","census_search_date":"2022-08-19 21:35:00","snet_input_date":"2022-08-19 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-08-19 21:35:00","insp_carrier_name":"APS BOPARAI TRANSPORT INC","insp_carrier_street":"PO BOX 1984","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95378-1984","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:52.000000Z","updated_at":"2025-03-17T18:46:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1743848,"change_date":"2022-08-19 21:35:00","inspection_id":"76376034","insp_unit_id":"190421050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"AP02","insp_unit_license":"YP30031","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EG3HN978308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:00.000000Z","updated_at":"2025-03-17T22:19:00.000000Z"},{"id":1743849,"change_date":"2022-08-19 21:35:00","inspection_id":"76376034","insp_unit_id":"190421051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1313","insp_unit_license":"4UX3274","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537GU451512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:00.000000Z","updated_at":"2025-03-17T22:19:00.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3834347\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3834347\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3834347\/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\/3834347\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}