{"current_page":1,"data":[{"id":11862147,"change_date":"2026-05-09 21:35:00","inspection_id":"87798746","dot_number":"2884678","report_state":"WA","report_number":"2168001052","insp_date":"2026-05-04 00:00:00","insp_start_time":"1357","insp_end_time":"1441","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC33","location_desc":"BOW WA","county_code_state":"WA","county_code":"057","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TREETOP INC","shipping_paper_number":"0831087","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":"2026-05-09 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","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":"3288835","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2026-05-09 21:35:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-09 21:35:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-12T09:39:31.000000Z","updated_at":"2026-05-20T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20627033,"change_date":"2026-05-09 21:35:00","inspection_id":"87798746","insp_unit_id":"213458057","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"0001","insp_unit_license":"RP26318","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH2MN600838","insp_unit_decal":"Y","insp_unit_decal_number":"36378243","created_at":"2026-05-12T09:15:42.000000Z","updated_at":"2026-05-20T09:01:57.000000Z"},{"id":20627034,"change_date":"2026-05-09 21:35:00","inspection_id":"87798746","insp_unit_id":"213458058","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"REW298","insp_unit_license":"4XB3673","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2538J6284606","insp_unit_decal":"Y","insp_unit_decal_number":"36378244","created_at":"2026-05-12T09:15:42.000000Z","updated_at":"2026-05-20T09:01:57.000000Z"}]},{"id":11727100,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","dot_number":"2884678","report_state":"WA","report_number":"2142002776","insp_date":"2026-04-18 00:00:00","insp_start_time":"1053","insp_end_time":"1220","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"2562414","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":"2026-04-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"142350","viol_total":"9","oos_total":"3","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3199143","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2026-04-23 21:38:00","snet_input_date":"2026-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-23 21:38:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:41.000000Z","updated_at":"2026-05-04T09:30:31.000000Z","inspection_violations":[{"id":20387379,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794084","seq_no":"5","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"213172959","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"39355EB"},{"id":20387380,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794085","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213172959","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"39347E"},{"id":20387381,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794086","seq_no":"7","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213172959","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"39353BB"},{"id":20387382,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794087","seq_no":"8","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":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"3922SLLED"},{"id":20387383,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794088","seq_no":"9","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213172958","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"39375A3TAOL"},{"id":20387384,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794089","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":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"3922SLLED"},{"id":20387378,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794083","seq_no":"4","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"213172959","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"393110B3C"},{"id":20387376,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794081","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213172958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"3922SLLSR"},{"id":20387377,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_violation_id":"273794082","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"213172959","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T10:00:53.000000Z","updated_at":"2026-05-04T09:42:02.000000Z","normalized_code":"393110B3C"}],"inspection_per_units":[{"id":20405718,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_unit_id":"213172958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"75","insp_unit_license":"ZP91125","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR9MSLU4626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:46.000000Z","updated_at":"2026-05-04T09:02:56.000000Z"},{"id":20405719,"change_date":"2026-04-23 21:38:00","inspection_id":"87654909","insp_unit_id":"213172959","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REITNOUER","insp_unit_company":"615","insp_unit_license":"4VB4501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1RNF53A27HR041615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:46.000000Z","updated_at":"2026-05-04T09:02:56.000000Z"}]},{"id":11141630,"change_date":"2026-02-16 21:35:00","inspection_id":"87055689","dot_number":"2884678","report_state":"MO","report_number":"W168000447","insp_date":"2026-02-16 00:00:00","insp_start_time":"0847","insp_end_time":"0933","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MONROE CITY MO","county_code_state":"MO","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DOMINION ENERGY","shipping_paper_number":"000235","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-16 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"152350","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":"2893944","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2026-02-16 21:35:00","snet_input_date":"2026-02-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-16 21:35:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-19T10:37:11.000000Z","updated_at":"2026-02-27T10:30:20.000000Z","inspection_violations":[{"id":18666453,"change_date":"2026-02-16 21:35:00","inspection_id":"87055689","insp_violation_id":"271820869","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211643938","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"--","created_at":"2026-02-19T10:51:15.000000Z","updated_at":"2026-02-27T10:38:50.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":19006099,"change_date":"2026-02-16 21:35:00","inspection_id":"87055689","insp_unit_id":"211643937","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"112","insp_unit_license":"RP12327","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJHHDR7LSLR4438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:51.000000Z","updated_at":"2026-02-27T10:02:36.000000Z"},{"id":19006100,"change_date":"2026-02-16 21:35:00","inspection_id":"87055689","insp_unit_id":"211643938","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REITNOUER","insp_unit_company":"898","insp_unit_license":"4UL2046","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1RNF48A21GR036201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:51.000000Z","updated_at":"2026-02-27T10:02:36.000000Z"}]},{"id":10886206,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","dot_number":"2884678","report_state":"CA","report_number":"ND6B006899","insp_date":"2026-01-27 00:00:00","insp_start_time":"0813","insp_end_time":"0856","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BAN","shipping_paper_number":"60867","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142350","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":"16149896","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:58.000000Z","inspection_violations":[{"id":18226357,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","insp_violation_id":"271498813","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"211350710","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"SA99921","created_at":"2026-02-01T10:47:44.000000Z","updated_at":"2026-02-10T10:39:25.000000Z","normalized_code":"3963A1BOS"},{"id":18226358,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","insp_violation_id":"271498814","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"211350710","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:44.000000Z","updated_at":"2026-02-10T10:39:25.000000Z","normalized_code":"39348ABIBD"},{"id":18226359,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","insp_violation_id":"271498815","seq_no":"3","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"2","insp_unit_id":"211350710","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:44.000000Z","updated_at":"2026-02-10T10:39:25.000000Z","normalized_code":"39347D2BLTBD"},{"id":18226360,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","insp_violation_id":"271498816","seq_no":"4","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"211350710","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:44.000000Z","updated_at":"2026-02-10T10:39:25.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":18299732,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","insp_unit_id":"211350709","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"515","insp_unit_license":"ZP75428","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7KSKC5515","insp_unit_decal":"Y","insp_unit_decal_number":"35942474","created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:12.000000Z"},{"id":18299733,"change_date":"2026-01-29 21:39:00","inspection_id":"86916881","insp_unit_id":"211350710","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":"615","insp_unit_license":"4VB4501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1RNF53A27HR041615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:13.000000Z"}]},{"id":10534401,"change_date":"2025-12-29 21:38:00","inspection_id":"86670614","dot_number":"2884678","report_state":"CA","report_number":"ND72010613","insp_date":"2025-12-21 00:00:00","insp_start_time":"1646","insp_end_time":"1724","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"THERMO KING","shipping_paper_number":"40429128","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"16107594","transaction_code":"A","transaction_date":"2025-12-21 00:00:00","upload_date":"2025-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-29 21:38:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-01T10:34:49.000000Z","updated_at":"2026-01-09T10:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17644279,"change_date":"2025-12-29 21:38:00","inspection_id":"86670614","insp_unit_id":"210840038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WH 76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"Y","insp_unit_decal_number":"35649767","created_at":"2026-01-01T10:08:50.000000Z","updated_at":"2026-01-09T10:01:22.000000Z"},{"id":17644280,"change_date":"2025-12-29 21:38:00","inspection_id":"86670614","insp_unit_id":"210840039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WH 868","insp_unit_license":"4TU8761","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1KL115868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:50.000000Z","updated_at":"2026-01-09T10:01:22.000000Z"}]},{"id":10120505,"change_date":"2025-11-04 21:41:00","inspection_id":"86237024","dot_number":"2884678","report_state":"CA","report_number":"N8TU001946","insp_date":"2025-10-28 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"250","location_desc":"SACRAMENTO","county_code_state":"CA","county_code":"067","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-11-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"16045293","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-04 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-11-07T10:31:50.000000Z","updated_at":"2025-11-08T10:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16840464,"change_date":"2025-11-04 21:41:00","inspection_id":"86237024","insp_unit_id":"209841810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"318","insp_unit_license":"YP40683","insp_unit_license_state":"AK","insp_unit_vehicle_id_number":"3AKJHHDRXLSLV7318","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:41.000000Z","updated_at":"2025-11-08T10:01:53.000000Z"},{"id":16840465,"change_date":"2025-11-04 21:41:00","inspection_id":"86237024","insp_unit_id":"209841811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4WH4982","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3UTVS2530N8605106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:41.000000Z","updated_at":"2025-11-08T10:01:53.000000Z"}]},{"id":10120506,"change_date":"2025-11-04 21:41:00","inspection_id":"86237025","dot_number":"2884678","report_state":"CA","report_number":"N8TU001947","insp_date":"2025-10-28 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"250","location_desc":"SACRAMENTO","county_code_state":"CA","county_code":"067","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-11-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","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":"16045294","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-04 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-11-07T10:31:50.000000Z","updated_at":"2025-11-08T10:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16840466,"change_date":"2025-11-04 21:41:00","inspection_id":"86237025","insp_unit_id":"209841812","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"0001","insp_unit_license":"RP26318","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2MN600838","insp_unit_decal":"Y","insp_unit_decal_number":"35610048","created_at":"2025-11-07T10:01:41.000000Z","updated_at":"2025-11-08T10:01:53.000000Z"},{"id":16840467,"change_date":"2025-11-04 21:41:00","inspection_id":"86237025","insp_unit_id":"209841813","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"642","insp_unit_license":"DQ2916","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2532N2466623","insp_unit_decal":"Y","insp_unit_decal_number":"35610049","created_at":"2025-11-07T10:01:41.000000Z","updated_at":"2025-11-08T10:01:53.000000Z"}]},{"id":10047307,"change_date":"2025-10-29 21:40:00","inspection_id":"86159943","dot_number":"2884678","report_state":"TX","report_number":"V252069705","insp_date":"2025-10-23 00:00:00","insp_start_time":"0805","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"16121  TX114 EB","county_code_state":"TX","county_code":"121","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VALOR STEEL","shipping_paper_number":"21616275","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"143200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9737499","transaction_code":"C","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"1102592","created_at":"2025-10-30T10:00:48.000000Z","updated_at":"2025-11-02T11:00:26.000000Z","inspection_violations":[{"id":16661969,"change_date":"2025-10-29 21:40:00","inspection_id":"86159943","insp_violation_id":"269598797","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209722534","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:44.000000Z","updated_at":"2025-11-02T11:15:45.000000Z","normalized_code":"39347E"},{"id":16661970,"change_date":"2025-10-29 21:40:00","inspection_id":"86159943","insp_violation_id":"269598798","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"209722534","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:44.000000Z","updated_at":"2025-11-02T11:15:45.000000Z","normalized_code":"39353B"},{"id":16661971,"change_date":"2025-10-29 21:40:00","inspection_id":"86159943","insp_violation_id":"269598799","seq_no":"3","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209722534","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:44.000000Z","updated_at":"2025-11-02T11:15:45.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":16723775,"change_date":"2025-10-29 21:40:00","inspection_id":"86159943","insp_unit_id":"209722533","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"296","insp_unit_license":"ZP09301","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ267296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:58.000000Z","updated_at":"2025-11-02T10:45:35.000000Z"},{"id":16723776,"change_date":"2025-10-29 21:40:00","inspection_id":"86159943","insp_unit_id":"209722534","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":null,"insp_unit_license":"4VB4501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1RNF53A27HR041615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:58.000000Z","updated_at":"2025-11-02T10:45:35.000000Z"}]},{"id":9789158,"change_date":"2025-09-26 21:39:00","inspection_id":"85887934","dot_number":"2884678","report_state":"IN","report_number":"5982006293","insp_date":"2025-09-25 00:00:00","insp_start_time":"0945","insp_end_time":"1012","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEW CASTLE IN","county_code_state":"IN","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ROYAL CANIN","shipping_paper_number":"8128538","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-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"2332577","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-09-26 21:39:00","snet_input_date":"2025-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-26 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:00:59.000000Z","updated_at":"2025-09-30T10:00:59.000000Z","inspection_violations":[{"id":16098529,"change_date":"2025-09-26 21:39:00","inspection_id":"85887934","insp_violation_id":"268945416","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-09-30T10:16:43.000000Z","updated_at":"2025-09-30T10:16:43.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16220695,"change_date":"2025-09-26 21:39:00","inspection_id":"85887934","insp_unit_id":"209164442","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:37.000000Z","updated_at":"2025-09-30T09:45:27.000000Z"},{"id":16220696,"change_date":"2025-09-26 21:39:00","inspection_id":"85887934","insp_unit_id":"209164443","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"868","insp_unit_license":"4TU8761","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1KL115868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:37.000000Z","updated_at":"2025-09-30T09:45:27.000000Z"}]},{"id":9710584,"change_date":"2025-09-17 21:41:00","inspection_id":"85805899","dot_number":"2884678","report_state":"CA","report_number":"UDSS003420","insp_date":"2025-09-14 00:00:00","insp_start_time":"0830","insp_end_time":"0857","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED AERONAUTICAL","shipping_paper_number":"33753390","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-09-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15984280","transaction_code":"A","transaction_date":"2025-09-14 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-17 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-09-23T10:01:55.000000Z","updated_at":"2025-09-23T10:01:55.000000Z","inspection_violations":[{"id":15937273,"change_date":"2025-09-17 21:41:00","inspection_id":"85805899","insp_violation_id":"268764576","seq_no":"1","part_no":"393","part_no_section":"70B1I-CDFWFMI-MT20","insp_viol_unit":"1","insp_unit_id":"209009493","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA235970","created_at":"2025-09-20T10:16:36.000000Z","updated_at":"2025-09-22T10:17:07.000000Z","normalized_code":"39370B1ICDFWFMIMT20"}],"inspection_per_units":[{"id":16076368,"change_date":"2025-09-17 21:41:00","inspection_id":"85805899","insp_unit_id":"209009493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"515","insp_unit_license":"ZP75428","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7KSKC5515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:53.000000Z","updated_at":"2025-09-21T09:45:44.000000Z"},{"id":16076369,"change_date":"2025-09-17 21:41:00","inspection_id":"85805899","insp_unit_id":"209009494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":"331","insp_unit_license":"4TN4510","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1RNF53A29LR051331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:53.000000Z","updated_at":"2025-09-21T09:45:44.000000Z"}]},{"id":9650535,"change_date":"2025-09-11 21:41:00","inspection_id":"85744108","dot_number":"2884678","report_state":"WA","report_number":"2059001992","insp_date":"2025-09-06 00:00:00","insp_start_time":"1945","insp_end_time":"2011","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KRAFT HEINZ COMPANY","shipping_paper_number":"2098047170","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":"2025-09-11 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":"2251435","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:54.000000Z","updated_at":"2025-09-16T10:46:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15947703,"change_date":"2025-09-11 21:41:00","inspection_id":"85744108","insp_unit_id":"208867128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"001","insp_unit_license":"RP26318","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH2MN600838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:34.000000Z","updated_at":"2025-09-15T09:53:01.000000Z"},{"id":15947704,"change_date":"2025-09-11 21:41:00","inspection_id":"85744108","insp_unit_id":"208867129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"642","insp_unit_license":"DQ2916","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2532N2466623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:34.000000Z","updated_at":"2025-09-15T09:53:01.000000Z"}]},{"id":9934577,"change_date":"2025-10-14 21:41:00","inspection_id":"86040689","dot_number":"2884678","report_state":"NV","report_number":"6058028072","insp_date":"2025-08-28 00:00:00","insp_start_time":"1455","insp_end_time":"1515","registration_date":null,"region":"PD","ci_status_code":"C","location":"3","location_desc":"NV","county_code_state":"NV","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CII","shipping_paper_number":"00765","cargo_tank":null,"hazmat_placard_req":"N","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-10-14 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":"2407125","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:33.000000Z","updated_at":"2025-10-18T10:00:27.000000Z","inspection_violations":[{"id":16396040,"change_date":"2025-10-14 21:41:00","inspection_id":"86040689","insp_violation_id":"269281488","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X03477225","created_at":"2025-10-17T10:17:12.000000Z","updated_at":"2025-10-18T10:15:44.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":16488712,"change_date":"2025-10-14 21:41:00","inspection_id":"86040689","insp_unit_id":"209453765","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"01","insp_unit_license":"ZP32040","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9TJ8KN217389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:43.000000Z","updated_at":"2025-10-18T09:45:35.000000Z"},{"id":16488713,"change_date":"2025-10-14 21:41:00","inspection_id":"86040689","insp_unit_id":"209453766","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1303","insp_unit_license":"4WF9328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D0LL174010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:43.000000Z","updated_at":"2025-10-18T09:45:35.000000Z"}]},{"id":9379462,"change_date":"2025-08-11 21:38:00","inspection_id":"85457881","dot_number":"2884678","report_state":"NM","report_number":"3862P66FCS","insp_date":"2025-08-10 00:00:00","insp_start_time":"1128","insp_end_time":"1204","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"INSIGHT LOGISTICS","shipping_paper_number":"15079272","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-08-11 21:38: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":"2208621","transaction_code":"A","transaction_date":"2025-08-10 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-11 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:27.000000Z","updated_at":"2025-08-15T10:43:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15454137,"change_date":"2025-08-11 21:38:00","inspection_id":"85457881","insp_unit_id":"208333353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT296","insp_unit_license":"ZP09301","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X6RJ267296","insp_unit_decal":"Y","insp_unit_decal_number":"35446178","created_at":"2025-08-14T09:45:33.000000Z","updated_at":"2025-08-15T09:45:46.000000Z"},{"id":15454138,"change_date":"2025-08-11 21:38:00","inspection_id":"85457881","insp_unit_id":"208333354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REIT","insp_unit_company":"UNIT615","insp_unit_license":"4VB4501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1RNF53A27HR041615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:33.000000Z","updated_at":"2025-08-15T09:45:46.000000Z"}]},{"id":8862889,"change_date":"2025-06-10 21:40:00","inspection_id":"84913413","dot_number":"2884678","report_state":"IL","report_number":"4290340032","insp_date":"2025-06-09 00:00:00","insp_start_time":"1034","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"T3","county_code_state":"IL","county_code":"063","insp_level_id":"3","service_center":"MW","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":"2025-06-10 21:40: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":"2412328","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-09 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-06-10 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:46.000000Z","updated_at":"2025-06-14T10:00:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14513778,"change_date":"2025-06-10 21:40:00","inspection_id":"84913413","insp_unit_id":"207313882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"ZP07197","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:44.000000Z","updated_at":"2025-06-14T09:45:42.000000Z"},{"id":14513779,"change_date":"2025-06-10 21:40:00","inspection_id":"84913413","insp_unit_id":"207313883","insp_unit_type_id":"12","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:44.000000Z","updated_at":"2025-06-14T09:45:42.000000Z"}]},{"id":8821560,"change_date":"2025-06-05 21:41:00","inspection_id":"84869486","dot_number":"2884678","report_state":"OH","report_number":"1721000240","insp_date":"2025-06-03 00:00:00","insp_start_time":"1300","insp_end_time":"1340","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WADSWORTH OH","county_code_state":"OH","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NEWELL BRANDS DISTRIBUTION LLC","shipping_paper_number":"538910042971603","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-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118678","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":"1823367","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:00.000000Z","updated_at":"2025-06-09T10:01:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14442551,"change_date":"2025-06-05 21:41:00","inspection_id":"84869486","insp_unit_id":"207234745","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1303","insp_unit_license":"ZP32040","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D0LL174010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:21.000000Z","updated_at":"2025-06-09T09:45:17.000000Z"},{"id":14442552,"change_date":"2025-06-05 21:41:00","inspection_id":"84869486","insp_unit_id":"207234746","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"01","insp_unit_license":"ZP32040","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9TJ8KN217389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:21.000000Z","updated_at":"2025-06-09T09:45:17.000000Z"}]},{"id":8427035,"change_date":"2025-04-21 21:40:00","inspection_id":"84453434","dot_number":"2884678","report_state":"SD","report_number":"HP80000567","insp_date":"2025-04-19 00:00:00","insp_start_time":"1434","insp_end_time":"1454","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOUNT VERNON SD","county_code_state":"SD","county_code":"035","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALASKA MARINE LINES","shipping_paper_number":"1600926","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-21 21:40: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":"1622872","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:02:53.000000Z","updated_at":"2025-04-26T10:23:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13684457,"change_date":"2025-04-21 21:40:00","inspection_id":"84453434","insp_unit_id":"206409452","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:51:42.000000Z","updated_at":"2025-04-25T09:54:30.000000Z"},{"id":13684458,"change_date":"2025-04-21 21:40:00","inspection_id":"84453434","insp_unit_id":"206409453","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"868","insp_unit_license":"4TU8761","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1KL115868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:51:42.000000Z","updated_at":"2025-04-25T09:54:30.000000Z"}]},{"id":8363066,"change_date":"2025-04-13 21:33:00","inspection_id":"84385919","dot_number":"2884678","report_state":"IN","report_number":"8632008728","insp_date":"2025-04-10 00:00:00","insp_start_time":"1332","insp_end_time":"1402","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MICHIGAN CITY IN","county_code_state":"IN","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NEW SEED","shipping_paper_number":"BL-1409","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-04-13 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1589282","transaction_code":"A","transaction_date":"2025-04-13 00:00:00","upload_date":"2025-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-04-13 21:33:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-13 21:33:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-16T10:01:20.000000Z","updated_at":"2025-04-17T10:04:35.000000Z","inspection_violations":[{"id":13175322,"change_date":"2025-04-13 21:33:00","inspection_id":"84385919","insp_violation_id":"265591145","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-04-16T10:22:22.000000Z","updated_at":"2025-04-17T10:22:11.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":13570534,"change_date":"2025-04-13 21:33:00","inspection_id":"84385919","insp_unit_id":"206287162","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"868","insp_unit_license":"4TU8761","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1KL115868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-16T09:52:36.000000Z","updated_at":"2025-04-17T09:53:00.000000Z"},{"id":13570535,"change_date":"2025-04-13 21:33:00","inspection_id":"84385919","insp_unit_id":"206287163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-16T09:52:36.000000Z","updated_at":"2025-04-17T09:53:00.000000Z"}]},{"id":8227077,"change_date":"2025-03-27 21:41:00","inspection_id":"84242724","dot_number":"2884678","report_state":"IL","report_number":"4182870327","insp_date":"2025-03-26 00:00:00","insp_start_time":"1214","insp_end_time":"1221","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LETICA CORP","shipping_paper_number":"08533154","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-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132300","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":"2393536","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-26 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:33.000000Z","updated_at":"2025-03-31T10:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13308050,"change_date":"2025-03-27 21:41:00","inspection_id":"84242724","insp_unit_id":"206024929","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"ZP32040","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9TJ8KN217389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:24:17.000000Z","updated_at":"2025-03-31T10:04:05.000000Z"},{"id":13308051,"change_date":"2025-03-27 21:41:00","inspection_id":"84242724","insp_unit_id":"206024930","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1303","insp_unit_license":"4WF9328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D0LL174010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:24:17.000000Z","updated_at":"2025-03-31T10:04:05.000000Z"}]},{"id":8218838,"change_date":"2025-03-27 21:41:00","inspection_id":"84234022","dot_number":"2884678","report_state":"AZ","report_number":"5496000753","insp_date":"2025-03-23 00:00:00","insp_start_time":"1335","insp_end_time":"1410","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"FLAGSTAFF AZ","county_code_state":"AZ","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KOCH","shipping_paper_number":"173125","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-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","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":"1518075","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:09.000000Z","updated_at":"2025-03-31T10:27:55.000000Z","inspection_violations":[{"id":12896526,"change_date":"2025-03-27 21:41:00","inspection_id":"84234022","insp_violation_id":"265273986","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-29T10:44:10.000000Z","updated_at":"2025-03-31T10:40:33.000000Z","normalized_code":"3922SLLS3"},{"id":12896527,"change_date":"2025-03-27 21:41:00","inspection_id":"84234022","insp_violation_id":"265273987","seq_no":"2","part_no":"392","part_no_section":"71A-D","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-29T10:44:10.000000Z","updated_at":"2025-03-31T10:40:33.000000Z","normalized_code":"39271AD"}],"inspection_per_units":[{"id":13294957,"change_date":"2025-03-27 21:41:00","inspection_id":"84234022","insp_unit_id":"206009454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"3","insp_unit_license":"ZP32129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ2HN988663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:13:42.000000Z","updated_at":"2025-03-31T09:51:19.000000Z"},{"id":13294958,"change_date":"2025-03-27 21:41:00","inspection_id":"84234022","insp_unit_id":"206009455","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"16","insp_unit_license":"5405889","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"7LVD5DD23ND010164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:13:42.000000Z","updated_at":"2025-03-31T09:51:19.000000Z"}]},{"id":8097438,"change_date":"2025-03-12 21:40:00","inspection_id":"84106284","dot_number":"2884678","report_state":"NV","report_number":"7035028737","insp_date":"2025-03-11 00:00:00","insp_start_time":"1525","insp_end_time":"1540","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"SLOAN CHECK SITE","county_code_state":"NV","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GREENBRIER","shipping_paper_number":"MRAC015278","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-03-12 21:40: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":"788918","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-11 00:00:00","source_office":"4NVS001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:19.000000Z","updated_at":"2025-03-17T21:06:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13073884,"change_date":"2025-03-12 21:40:00","inspection_id":"84106284","insp_unit_id":"205761951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"},{"id":13073885,"change_date":"2025-03-12 21:40:00","inspection_id":"84106284","insp_unit_id":"205761952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"}]},{"id":7929632,"change_date":"2025-02-21 21:40:00","inspection_id":"83929951","dot_number":"2884678","report_state":"KY","report_number":"CV41515479","insp_date":"2025-02-21 00:00:00","insp_start_time":"0751","insp_end_time":"0821","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LOUISVILLE","county_code_state":"KY","county_code":"111","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SH BELL","shipping_paper_number":"778750","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-21 21:40: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":"2269793","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-21 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-02-21 21:40:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:50.000000Z","updated_at":"2025-03-17T21:02:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12800282,"change_date":"2025-02-21 21:40:00","inspection_id":"83929951","insp_unit_id":"205439664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"74","insp_unit_license":"ZP07197","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:25.000000Z","updated_at":"2025-03-17T23:56:25.000000Z"},{"id":12800283,"change_date":"2025-02-21 21:40:00","inspection_id":"83929951","insp_unit_id":"205439665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"77","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:25.000000Z","updated_at":"2025-03-17T23:56:25.000000Z"}]},{"id":7632239,"change_date":"2025-01-15 21:42:00","inspection_id":"83617577","dot_number":"2884678","report_state":"CA","report_number":"UEA3000667","insp_date":"2025-01-13 00:00:00","insp_start_time":"2230","insp_end_time":"2248","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SACRAMENTO PEPSI","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":"2025-01-15 21:42: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":"15664431","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:33.000000Z","updated_at":"2025-03-17T20:56:33.000000Z","inspection_violations":[{"id":11927332,"change_date":"2025-01-15 21:42:00","inspection_id":"83617577","insp_violation_id":"264024556","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"204859130","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":12315122,"change_date":"2025-01-15 21:42:00","inspection_id":"83617577","insp_unit_id":"204859130","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"GRY","insp_unit_license":"ZP32129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ2HN988663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:56.000000Z","updated_at":"2025-03-17T23:50:56.000000Z"},{"id":12315123,"change_date":"2025-01-15 21:42:00","inspection_id":"83617577","insp_unit_id":"204859131","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"5405889","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"7LVD5DD23ND010164","insp_unit_decal":"Y","insp_unit_decal_number":"34753141","created_at":"2025-03-17T23:50:56.000000Z","updated_at":"2025-03-17T23:50:56.000000Z"}]},{"id":7512606,"change_date":"2025-01-14 21:54:00","inspection_id":"83491974","dot_number":"2884678","report_state":"OH","report_number":"1808000161","insp_date":"2024-12-26 00:00:00","insp_start_time":"0802","insp_end_time":"0849","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CANTON OH","county_code_state":"OH","county_code":"151","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-28 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"2","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":"1199617","transaction_code":"C","transaction_date":"2024-12-28 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2024-12-28 21:32:00","snet_input_date":"2024-12-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-28 21:32:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:42.000000Z","updated_at":"2025-03-17T20:52:42.000000Z","inspection_violations":[{"id":11741613,"change_date":"2025-01-14 21:54:00","inspection_id":"83491974","insp_violation_id":"263955255","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"204805512","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3939ALIL"},{"id":11741614,"change_date":"2025-01-14 21:54:00","inspection_id":"83491974","insp_violation_id":"263955256","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"204805512","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":12120024,"change_date":"2025-01-14 21:54:00","inspection_id":"83491974","insp_unit_id":"204805511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"0001","insp_unit_license":"ZP26657","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2MN600838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:50.000000Z","updated_at":"2025-03-17T23:48:50.000000Z"},{"id":12120025,"change_date":"2025-01-14 21:54:00","inspection_id":"83491974","insp_unit_id":"204805512","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"3615","insp_unit_license":"110128PT","insp_unit_license_state":"SC","insp_unit_vehicle_id_number":"1UYVS2539M7163615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:50.000000Z","updated_at":"2025-03-17T23:48:50.000000Z"}]},{"id":7447039,"change_date":"2024-12-18 21:40:00","inspection_id":"83423137","dot_number":"2884678","report_state":"SD","report_number":"5070001358","insp_date":"2024-12-18 00:00:00","insp_start_time":"1210","insp_end_time":"1308","registration_date":null,"region":"CS","ci_status_code":"C","location":"SISSTN","location_desc":"SISSETON SD","county_code_state":"SD","county_code":"109","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADM","shipping_paper_number":"778242","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-12-18 21:40: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1171153","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2024-12-18 21:40:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:32.000000Z","updated_at":"2025-03-17T20:51:32.000000Z","inspection_violations":[{"id":11637544,"change_date":"2024-12-18 21:40:00","inspection_id":"83423137","insp_violation_id":"263539661","seq_no":"1","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":"B1274713","created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":12013922,"change_date":"2024-12-18 21:40:00","inspection_id":"83423137","insp_unit_id":"204449514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"01","insp_unit_license":"ZP32040","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9TJ8KN217389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:37.000000Z","updated_at":"2025-03-17T23:47:37.000000Z"},{"id":12013923,"change_date":"2024-12-18 21:40:00","inspection_id":"83423137","insp_unit_id":"204449515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1303","insp_unit_license":"4WF9328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D0LL174010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:37.000000Z","updated_at":"2025-03-17T23:47:37.000000Z"}]},{"id":7190949,"change_date":"2024-11-14 21:40:00","inspection_id":"83153265","dot_number":"2884678","report_state":"SD","report_number":"5520002226","insp_date":"2024-11-13 00:00:00","insp_start_time":"1451","insp_end_time":"1510","registration_date":null,"region":"CS","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LOVELAND PRODUCTS INC","shipping_paper_number":"802218655","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-11-14 21:40: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":"1052904","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2024-11-14 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-14 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:01.000000Z","updated_at":"2025-03-17T20:46:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11598856,"change_date":"2024-11-14 21:40:00","inspection_id":"83153265","insp_unit_id":"203874270","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"74","insp_unit_license":"ZP07197","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:11.000000Z","updated_at":"2025-03-17T23:43:11.000000Z"},{"id":11598857,"change_date":"2024-11-14 21:40:00","inspection_id":"83153265","insp_unit_id":"203874271","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"77","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:11.000000Z","updated_at":"2025-03-17T23:43:11.000000Z"}]},{"id":7075497,"change_date":"2024-10-29 21:42:00","inspection_id":"83030858","dot_number":"2884678","report_state":"CA","report_number":"UE45000292","insp_date":"2024-10-28 00:00:00","insp_start_time":"1408","insp_end_time":"1446","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"I-80 AT GREENBACK","county_code_state":"CA","county_code":"001","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117828","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":"15575045","transaction_code":"A","transaction_date":"2024-10-28 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11411110,"change_date":"2024-10-29 21:42:00","inspection_id":"83030858","insp_unit_id":"203645163","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:10.000000Z","updated_at":"2025-03-17T23:41:10.000000Z"},{"id":11411111,"change_date":"2024-10-29 21:42:00","inspection_id":"83030858","insp_unit_id":"203645164","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:10.000000Z","updated_at":"2025-03-17T23:41:10.000000Z"}]},{"id":6453704,"change_date":"2024-08-13 21:42:00","inspection_id":"82369291","dot_number":"2884678","report_state":"AR","report_number":"7970000275","insp_date":"2024-08-13 00:00:00","insp_start_time":"1025","insp_end_time":"1045","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CHESTER AR","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"742612","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:43.000000Z","updated_at":"2025-03-17T20:30:43.000000Z","inspection_violations":[{"id":10023004,"change_date":"2024-08-13 21:42:00","inspection_id":"82369291","insp_violation_id":"261159803","seq_no":"1","part_no":"392","part_no_section":"16(a)","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:31.000000Z","updated_at":"2025-03-17T21:54:31.000000Z","normalized_code":"39216A"},{"id":10023005,"change_date":"2024-08-13 21:42:00","inspection_id":"82369291","insp_violation_id":"261159804","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202363250","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:31.000000Z","updated_at":"2025-03-17T21:54:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10402304,"change_date":"2024-08-13 21:42:00","inspection_id":"82369291","insp_unit_id":"202363250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"02","insp_unit_license":"XE605Q","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FUJGLDR8HLHF9748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"},{"id":10402305,"change_date":"2024-08-13 21:42:00","inspection_id":"82369291","insp_unit_id":"202363251","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1","insp_unit_license":"5282457","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D1LL168152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"}]},{"id":6381696,"change_date":"2024-10-15 21:42:00","inspection_id":"82292194","dot_number":"2884678","report_state":"FL","report_number":"4326000554","insp_date":"2024-07-29 00:00:00","insp_start_time":"0933","insp_end_time":"1007","registration_date":"2024-08-09 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"ALACHUA FL","county_code_state":"FL","county_code":"001","insp_level_id":"2","service_center":"SH","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":"U","pen_cen_match":"I","final_status_date":"2024-08-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"712451","transaction_code":"C","transaction_date":"2024-08-04 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2024-08-04 21:33:00","snet_input_date":"2024-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-04 21:33:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:27.000000Z","updated_at":"2025-03-17T20:29:27.000000Z","inspection_violations":[{"id":9905006,"change_date":"2024-10-15 21:42:00","inspection_id":"82292194","insp_violation_id":"262348816","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":"000817381","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9905007,"change_date":"2024-10-15 21:42:00","inspection_id":"82292194","insp_violation_id":"262348817","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203409225","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10284229,"change_date":"2024-10-15 21:42:00","inspection_id":"82292194","insp_unit_id":"203409225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"ZP07197","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:31.000000Z","updated_at":"2025-03-17T23:29:31.000000Z"},{"id":10284230,"change_date":"2024-10-15 21:42:00","inspection_id":"82292194","insp_unit_id":"203409226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D4NL347966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:31.000000Z","updated_at":"2025-03-17T23:29:31.000000Z"}]},{"id":6254634,"change_date":"2024-07-18 21:41:00","inspection_id":"82156297","dot_number":"2884678","report_state":"CA","report_number":"UE5M003770","insp_date":"2024-07-15 00:00:00","insp_start_time":"1635","insp_end_time":"1652","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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-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":"15443233","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10077649,"change_date":"2024-07-18 21:41:00","inspection_id":"82156297","insp_unit_id":"201958810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"},{"id":10077650,"change_date":"2024-07-18 21:41:00","inspection_id":"82156297","insp_unit_id":"201958811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4PA1216","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1GL914458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"}]},{"id":6161786,"change_date":"2024-07-08 21:42:00","inspection_id":"82056546","dot_number":"2884678","report_state":"MD","report_number":"2436000058","insp_date":"2024-07-08 00:00:00","insp_start_time":"0941","insp_end_time":"1013","registration_date":null,"region":"ET","ci_status_code":"C","location":"013","location_desc":"PARK & RIDE SCALE I-95 @ I-495","county_code_state":"MD","county_code":"033","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CAPSTONE LOGISTICS LLC","shipping_paper_number":"175047","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-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121250","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":"2731274","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-08 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:58.000000Z","updated_at":"2025-03-17T20:24:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9925814,"change_date":"2024-07-08 21:42:00","inspection_id":"82056546","insp_unit_id":"201765317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:54.000000Z","updated_at":"2025-03-17T23:25:54.000000Z"},{"id":9925815,"change_date":"2024-07-08 21:42:00","inspection_id":"82056546","insp_unit_id":"201765318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:54.000000Z","updated_at":"2025-03-17T23:25:54.000000Z"}]},{"id":5648547,"change_date":"2024-05-01 21:43:00","inspection_id":"81500870","dot_number":"2884678","report_state":"CA","report_number":"NDDN005163","insp_date":"2024-04-29 00:00:00","insp_start_time":"1758","insp_end_time":"1817","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SONOMA GOURMET","shipping_paper_number":"438762","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-05-01 21:43: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":"15343422","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9098195,"change_date":"2024-05-01 21:43:00","inspection_id":"81500870","insp_unit_id":"200682711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78\/WHT","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"},{"id":9098196,"change_date":"2024-05-01 21:43:00","inspection_id":"81500870","insp_unit_id":"200682712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"77\/WHT","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5541358,"change_date":"2024-04-18 21:39:00","inspection_id":"81384132","dot_number":"2884678","report_state":"SD","report_number":"5070000988","insp_date":"2024-04-18 00:00:00","insp_start_time":"1419","insp_end_time":"1456","registration_date":null,"region":"CD","ci_status_code":"C","location":"SISSTN","location_desc":"SISSETON SD","county_code_state":"SD","county_code":"109","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADM","shipping_paper_number":"541622","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-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","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":"409466","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2024-04-18 21:39:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-18 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:43.000000Z","updated_at":"2025-03-17T20:12:43.000000Z","inspection_violations":[{"id":8562442,"change_date":"2024-04-18 21:39:00","inspection_id":"81384132","insp_violation_id":"259002435","seq_no":"1","part_no":"393","part_no_section":"207(b)","insp_viol_unit":"2","insp_unit_id":"200460587","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"B1189313","created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"393207B"}],"inspection_per_units":[{"id":8926144,"change_date":"2024-04-18 21:39:00","inspection_id":"81384132","insp_unit_id":"200460586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"},{"id":8926145,"change_date":"2024-04-18 21:39:00","inspection_id":"81384132","insp_unit_id":"200460587","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"}]},{"id":5482821,"change_date":"2024-04-10 21:42:00","inspection_id":"81320432","dot_number":"2884678","report_state":"NE","report_number":"T478000576","insp_date":"2024-04-10 00:00:00","insp_start_time":"1022","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 81, 414 FEET SOUTH O","county_code_state":"NE","county_code":"119","insp_level_id":"3","service_center":"MW","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-04-10 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":"785739","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-10 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8832050,"change_date":"2024-04-10 21:42:00","inspection_id":"81320432","insp_unit_id":"200336823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"},{"id":8832051,"change_date":"2024-04-10 21:42:00","inspection_id":"81320432","insp_unit_id":"200336824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"}]},{"id":4640056,"change_date":"2023-12-15 21:38:00","inspection_id":"80399775","dot_number":"2884678","report_state":"IN","report_number":"5868001507","insp_date":"2023-12-08 00:00:00","insp_start_time":"1020","insp_end_time":"1047","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GREENFIELD IN","county_code_state":"IN","county_code":"059","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133222","transaction_code":"A","transaction_date":"2023-12-15 00:00:00","upload_date":"2023-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2023-12-15 21:38:00","snet_input_date":"2023-12-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-15 21:38:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:55.000000Z","updated_at":"2025-03-17T19:54:55.000000Z","inspection_violations":[{"id":7175146,"change_date":"2023-12-15 21:38:00","inspection_id":"80399775","insp_violation_id":"256910102","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198526678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:38.000000Z","updated_at":"2025-03-17T21:40:38.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":7462995,"change_date":"2023-12-15 21:38:00","inspection_id":"80399775","insp_unit_id":"198526678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"ZP07197","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:44.000000Z","updated_at":"2025-03-17T23:02:44.000000Z"},{"id":7462996,"change_date":"2023-12-15 21:38:00","inspection_id":"80399775","insp_unit_id":"198526679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:44.000000Z","updated_at":"2025-03-17T23:02:44.000000Z"}]},{"id":4506698,"change_date":"2023-11-28 21:41:00","inspection_id":"80253205","dot_number":"2884678","report_state":"LA","report_number":"LANZ002256","insp_date":"2023-11-27 00:00:00","insp_start_time":"1229","insp_end_time":"1248","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"061","insp_level_id":"3","service_center":"SH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-28 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":"1187487","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-28 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:11.000000Z","updated_at":"2025-03-17T19:52:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7248039,"change_date":"2023-11-28 21:41:00","inspection_id":"80253205","insp_unit_id":"198239811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"ZP09317","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ1LN216602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:52.000000Z","updated_at":"2025-03-17T23:00:52.000000Z"},{"id":7248040,"change_date":"2023-11-28 21:41:00","inspection_id":"80253205","insp_unit_id":"198239812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"01","insp_unit_license":"2574680","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D9GL920945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:52.000000Z","updated_at":"2025-03-17T23:00:52.000000Z"}]},{"id":4474421,"change_date":"2023-11-21 21:40:00","inspection_id":"80217837","dot_number":"2884678","report_state":"UT","report_number":"24TO000063","insp_date":"2023-11-20 00:00:00","insp_start_time":"1407","insp_end_time":"1452","registration_date":null,"region":"MT","ci_status_code":"C","location":"40","location_desc":"ECHO PORT OF ENTRY","county_code_state":"UT","county_code":"043","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SACHS PEANUTS","shipping_paper_number":"0021000","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-11-21 21:40: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":"902633","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-20 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:27.000000Z","updated_at":"2025-03-17T19:51:27.000000Z","inspection_violations":[{"id":6925760,"change_date":"2023-11-21 21:40:00","inspection_id":"80217837","insp_violation_id":"256516075","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"C234001894","created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7196176,"change_date":"2023-11-21 21:40:00","inspection_id":"80217837","insp_unit_id":"198169268","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:27.000000Z","updated_at":"2025-03-17T23:00:27.000000Z"},{"id":7196177,"change_date":"2023-11-21 21:40:00","inspection_id":"80217837","insp_unit_id":"198169269","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:27.000000Z","updated_at":"2025-03-17T23:00:27.000000Z"}]},{"id":4456964,"change_date":"2023-11-19 21:31:00","inspection_id":"80198578","dot_number":"2884678","report_state":"MO","report_number":"W109003983","insp_date":"2023-11-18 00:00:00","insp_start_time":"1530","insp_end_time":"1616","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"SAINT JOSEPH MO","county_code_state":"MO","county_code":"003","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SACHS PEANUTS","shipping_paper_number":"0021000","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-19 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","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":"101435","transaction_code":"A","transaction_date":"2023-11-19 00:00:00","upload_date":"2023-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2023-11-19 21:31:00","snet_input_date":"2023-11-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-19 21:31:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:06.000000Z","updated_at":"2025-03-17T19:51:06.000000Z","inspection_violations":[{"id":6898713,"change_date":"2023-11-19 21:31:00","inspection_id":"80198578","insp_violation_id":"256475030","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"198131804","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39375A3TAOL"},{"id":6898714,"change_date":"2023-11-19 21:31:00","inspection_id":"80198578","insp_violation_id":"256475031","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"198131803","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":7167625,"change_date":"2023-11-19 21:31:00","inspection_id":"80198578","insp_unit_id":"198131803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:11.000000Z","updated_at":"2025-03-17T23:00:11.000000Z"},{"id":7167626,"change_date":"2023-11-19 21:31:00","inspection_id":"80198578","insp_unit_id":"198131804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"77","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:11.000000Z","updated_at":"2025-03-17T23:00:11.000000Z"}]},{"id":4268229,"change_date":"2023-10-24 21:39:00","inspection_id":"79989973","dot_number":"2884678","report_state":"MT","report_number":"U262200052","insp_date":"2023-10-22 00:00:00","insp_start_time":"0735","insp_end_time":"0800","registration_date":null,"region":"MD","ci_status_code":"C","location":"BILLBN","location_desc":"BILLINGS MT","county_code_state":"MT","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHEESEMAN LLC","shipping_paper_number":"7976607","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-24 21:39: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":"75975","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":"2023-10-24 21:39:00","snet_input_date":"2023-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-24 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:26.000000Z","updated_at":"2025-03-17T19:47:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6864415,"change_date":"2023-10-24 21:39:00","inspection_id":"79989973","insp_unit_id":"197710893","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"Y","insp_unit_decal_number":"33420900","created_at":"2025-03-17T22:57:32.000000Z","updated_at":"2025-03-17T22:57:32.000000Z"},{"id":6864416,"change_date":"2023-10-24 21:39:00","inspection_id":"79989973","insp_unit_id":"197710894","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4ST8208","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D0LL173391","insp_unit_decal":"Y","insp_unit_decal_number":"33420901","created_at":"2025-03-17T22:57:32.000000Z","updated_at":"2025-03-17T22:57:32.000000Z"}]},{"id":4216850,"change_date":"2023-10-17 21:41:00","inspection_id":"79933189","dot_number":"2884678","report_state":"IA","report_number":"000TT4X4KQ","insp_date":"2023-10-14 00:00:00","insp_start_time":"0900","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GROSKOPF WAREHOUSE & LOGISTICS","shipping_paper_number":"GLS30937","cargo_tank":null,"hazmat_placard_req":"N","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-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117828","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1291720","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-17 21:41:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:17.000000Z","updated_at":"2025-03-17T19:46:17.000000Z","inspection_violations":[{"id":6527910,"change_date":"2023-10-17 21:41:00","inspection_id":"79933189","insp_violation_id":"255882779","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:37:28.000000Z","updated_at":"2025-03-17T21:37:28.000000Z","normalized_code":"38371H"},{"id":6527911,"change_date":"2023-10-17 21:41:00","inspection_id":"79933189","insp_violation_id":"255882780","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:28.000000Z","updated_at":"2025-03-17T21:37:28.000000Z","normalized_code":"38323A2"},{"id":6527912,"change_date":"2023-10-17 21:41:00","inspection_id":"79933189","insp_violation_id":"255882781","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197598958","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:28.000000Z","updated_at":"2025-03-17T21:37:28.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6781444,"change_date":"2023-10-17 21:41:00","inspection_id":"79933189","insp_unit_id":"197598958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"74","insp_unit_license":"YP54432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:51.000000Z","updated_at":"2025-03-17T22:56:51.000000Z"},{"id":6781445,"change_date":"2023-10-17 21:41:00","inspection_id":"79933189","insp_unit_id":"197598959","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"70","insp_unit_license":"4UU2162","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2PL378717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:51.000000Z","updated_at":"2025-03-17T22:56:51.000000Z"}]},{"id":4186016,"change_date":"2023-10-12 21:42:00","inspection_id":"79899195","dot_number":"2884678","report_state":"OR","report_number":"AAW3006980","insp_date":"2023-10-11 00:00:00","insp_start_time":"0707","insp_end_time":"0735","registration_date":null,"region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"BLUE MOUNTAIN HAY","shipping_paper_number":"M2350","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-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52320","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":"1235698","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-12 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-10-12 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"271917","created_at":"2025-03-17T19:45:50.000000Z","updated_at":"2025-03-17T19:45:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6731868,"change_date":"2023-10-12 21:42:00","inspection_id":"79899195","insp_unit_id":"197531087","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:27.000000Z","updated_at":"2025-03-17T22:56:27.000000Z"},{"id":6731869,"change_date":"2023-10-12 21:42:00","inspection_id":"79899195","insp_unit_id":"197531088","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"77","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:27.000000Z","updated_at":"2025-03-17T22:56:27.000000Z"}]},{"id":3987222,"change_date":"2023-09-15 21:41:00","inspection_id":"79678570","dot_number":"2884678","report_state":"CA","report_number":"UCVI001811","insp_date":"2023-09-14 00:00:00","insp_start_time":"1800","insp_end_time":"1846","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-15 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":"15063303","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-15 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[{"id":6167613,"change_date":"2023-09-15 21:41:00","inspection_id":"79678570","insp_violation_id":"255307351","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197087762","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6411264,"change_date":"2023-09-15 21:41:00","inspection_id":"79678570","insp_unit_id":"197087762","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AB87HV","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FUJGLDR8HLHF9748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:50.000000Z","updated_at":"2025-03-17T22:53:50.000000Z"},{"id":6411265,"change_date":"2023-09-15 21:41:00","inspection_id":"79678570","insp_unit_id":"197087763","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"5230638","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D1LL168152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:50.000000Z","updated_at":"2025-03-17T22:53:50.000000Z"}]},{"id":3997043,"change_date":"2023-09-18 21:39:00","inspection_id":"79689451","dot_number":"2884678","report_state":"CA","report_number":"NDZ5003793","insp_date":"2023-09-14 00:00:00","insp_start_time":"1628","insp_end_time":"1724","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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-09-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15063972","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-18 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T19:41:40.000000Z","updated_at":"2025-03-17T19:41:40.000000Z","inspection_violations":[{"id":6184645,"change_date":"2023-09-18 21:39:00","inspection_id":"79689451","insp_violation_id":"255333840","seq_no":"1","part_no":"393","part_no_section":"207(b)","insp_viol_unit":"2","insp_unit_id":"197109303","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA158204","created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"393207B"},{"id":6184646,"change_date":"2023-09-18 21:39:00","inspection_id":"79689451","insp_violation_id":"255333841","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197109302","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6427228,"change_date":"2023-09-18 21:39:00","inspection_id":"79689451","insp_unit_id":"197109302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"AB87HV","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1FUJGLDR8HLHF9748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:58.000000Z","updated_at":"2025-03-17T22:53:58.000000Z"},{"id":6427229,"change_date":"2023-09-18 21:39:00","inspection_id":"79689451","insp_unit_id":"197109303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"103","insp_unit_license":"5230638","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D1LL168152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:58.000000Z","updated_at":"2025-03-17T22:53:58.000000Z"}]},{"id":3867417,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","dot_number":"2884678","report_state":"SC","report_number":"N377000795","insp_date":"2023-08-29 00:00:00","insp_start_time":"1600","insp_end_time":"1634","registration_date":"2023-09-28 00:00:00","region":"ET","ci_status_code":"C","location":"108","location_desc":"I-85 SB ROADSIDE","county_code_state":"SC","county_code":"007","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"DART","shipping_paper_number":"83121081","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-08-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102942","transaction_code":"C","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-29 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-08-30 21:44:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:21.000000Z","updated_at":"2025-03-17T19:39:21.000000Z","inspection_violations":[{"id":5974457,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","insp_violation_id":"255545517","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:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"3922"},{"id":5974458,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","insp_violation_id":"255545518","seq_no":"2","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":null,"created_at":"2025-03-17T21:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"3922"},{"id":5974459,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","insp_violation_id":"255545519","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197293692","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"39617C"},{"id":5974460,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","insp_violation_id":"255545520","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197293693","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6217390,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","insp_unit_id":"197293692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:14.000000Z","updated_at":"2025-03-17T22:52:14.000000Z"},{"id":6217391,"change_date":"2023-09-28 21:41:00","inspection_id":"79545359","insp_unit_id":"197293693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:14.000000Z","updated_at":"2025-03-17T22:52:14.000000Z"}]},{"id":3919184,"change_date":"2023-09-06 21:44:00","inspection_id":"79603001","dot_number":"2884678","report_state":"CA","report_number":"NDKS007741","insp_date":"2023-08-28 00:00:00","insp_start_time":"2131","insp_end_time":"2155","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MOUNTAIN PASS CVEF","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HILEX POLY","shipping_paper_number":"0828202301","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-09-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117828","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":"15051599","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-06 21:44:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:08.000000Z","updated_at":"2025-03-17T19:40:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6302060,"change_date":"2023-09-06 21:44:00","inspection_id":"79603001","insp_unit_id":"196933920","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78\/WHT","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"Y","insp_unit_decal_number":"32932205","created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"},{"id":6302061,"change_date":"2023-09-06 21:44:00","inspection_id":"79603001","insp_unit_id":"196933921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"}]},{"id":3655602,"change_date":"2023-08-02 21:41:00","inspection_id":"79308618","dot_number":"2884678","report_state":"OR","report_number":"AAW4004905","insp_date":"2023-08-01 00:00:00","insp_start_time":"1123","insp_end_time":"1151","registration_date":null,"region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"PORT TOWNSEND, WA","shipping_paper_number":"120851","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-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","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":"1230181","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-02 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"271917","created_at":"2025-03-17T19:34:58.000000Z","updated_at":"2025-03-17T19:34:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5878047,"change_date":"2023-08-02 21:41:00","inspection_id":"79308618","insp_unit_id":"196331070","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"74","insp_unit_license":"YP54432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","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":5878048,"change_date":"2023-08-02 21:41:00","inspection_id":"79308618","insp_unit_id":"196331071","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"70","insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"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":3580996,"change_date":"2023-07-24 21:42:00","inspection_id":"79225138","dot_number":"2884678","report_state":"SD","report_number":"003B028923","insp_date":"2023-07-22 00:00:00","insp_start_time":"1235","insp_end_time":"1259","registration_date":null,"region":"CT","ci_status_code":"C","location":"JPOE","location_desc":"JEFFERSON PORT OF ENTRY","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SINOMAX EAST","shipping_paper_number":"21940","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-07-24 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":"647610","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-24 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:50.000000Z","updated_at":"2025-03-17T19:33:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5758209,"change_date":"2023-07-24 21:42:00","inspection_id":"79225138","insp_unit_id":"196164384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"},{"id":5758210,"change_date":"2023-07-24 21:42:00","inspection_id":"79225138","insp_unit_id":"196164385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"77","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL336873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"}]},{"id":3335549,"change_date":"2023-08-07 21:42:00","inspection_id":"78949401","dot_number":"2884678","report_state":"OR","report_number":"AASB002452","insp_date":"2023-06-20 00:00:00","insp_start_time":"1145","insp_end_time":"1219","registration_date":null,"region":"PT","ci_status_code":"C","location":"1604","location_desc":"JUNIPER BUTTE SB","county_code_state":"OR","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","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-06-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"1227686","transaction_code":"C","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-21 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-06-21 21:43:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"271917","created_at":"2025-03-17T19:28:57.000000Z","updated_at":"2025-03-17T19:28:57.000000Z","inspection_violations":[{"id":5142953,"change_date":"2023-08-07 21:42:00","inspection_id":"78949401","insp_violation_id":"254513659","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196406291","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5362672,"change_date":"2023-08-07 21:42:00","inspection_id":"78949401","insp_unit_id":"196406290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"Y","insp_unit_decal_number":"32704351","created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"},{"id":5362673,"change_date":"2023-08-07 21:42:00","inspection_id":"78949401","insp_unit_id":"196406291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"Y","insp_unit_decal_number":"32704352","created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":3244826,"change_date":"2023-06-08 21:42:00","inspection_id":"78846810","dot_number":"2884678","report_state":"CA","report_number":"UE5M002861","insp_date":"2023-06-02 00:00:00","insp_start_time":"1328","insp_end_time":"1342","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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":"2023-06-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14934426","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-08 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5218895,"change_date":"2023-06-08 21:42:00","inspection_id":"78846810","insp_unit_id":"195408408","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:07.000000Z","updated_at":"2025-03-17T22:44:07.000000Z"},{"id":5218896,"change_date":"2023-06-08 21:42:00","inspection_id":"78846810","insp_unit_id":"195408409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D4NL347966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:07.000000Z","updated_at":"2025-03-17T22:44:07.000000Z"}]},{"id":2844959,"change_date":"2023-04-19 21:42:00","inspection_id":"78395226","dot_number":"2884678","report_state":"CA","report_number":"NA9Q000753","insp_date":"2023-04-18 00:00:00","insp_start_time":"1015","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"3600 W.  CAPITAL","county_code_state":"CA","county_code":"113","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":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"14864768","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T19:19:15.000000Z","updated_at":"2025-03-17T19:19:15.000000Z","inspection_violations":[{"id":4366418,"change_date":"2023-04-19 21:42:00","inspection_id":"78395226","insp_violation_id":"252327676","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194482762","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:24.000000Z","updated_at":"2025-03-17T21:27:24.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4578597,"change_date":"2023-04-19 21:42:00","inspection_id":"78395226","insp_unit_id":"194482762","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"74","insp_unit_license":"YP54432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"},{"id":4578598,"change_date":"2023-04-19 21:42:00","inspection_id":"78395226","insp_unit_id":"194482763","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"77","insp_unit_license":"4UA1175","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL337895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"}]},{"id":2845505,"change_date":"2023-04-19 21:42:00","inspection_id":"78395818","dot_number":"2884678","report_state":"CA","report_number":"NA9Q000751","insp_date":"2023-04-18 00:00:00","insp_start_time":"0730","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"3600 W.  CAPITAL","county_code_state":"CA","county_code":"113","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":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14864288","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T19:19:15.000000Z","updated_at":"2025-03-17T19:19:15.000000Z","inspection_violations":[{"id":4366785,"change_date":"2023-04-19 21:42:00","inspection_id":"78395818","insp_violation_id":"252328075","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194483602","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:24.000000Z","updated_at":"2025-03-17T21:27:24.000000Z","normalized_code":"3939A"},{"id":4366786,"change_date":"2023-04-19 21:42:00","inspection_id":"78395818","insp_violation_id":"252328076","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194483602","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:24.000000Z","updated_at":"2025-03-17T21:27:24.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4579341,"change_date":"2023-04-19 21:42:00","inspection_id":"78395818","insp_unit_id":"194483602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"},{"id":4579342,"change_date":"2023-04-19 21:42:00","inspection_id":"78395818","insp_unit_id":"194483603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"57","insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"}]},{"id":2845506,"change_date":"2023-04-19 21:42:00","inspection_id":"78395819","dot_number":"2884678","report_state":"CA","report_number":"NA9Q000752","insp_date":"2023-04-18 00:00:00","insp_start_time":"0850","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"3600 W.  CAPITAL","county_code_state":"CA","county_code":"113","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":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"14864560","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T19:19:15.000000Z","updated_at":"2025-03-17T19:19:15.000000Z","inspection_violations":[{"id":4366787,"change_date":"2023-04-19 21:42:00","inspection_id":"78395819","insp_violation_id":"252328077","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194483604","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:24.000000Z","updated_at":"2025-03-17T21:27:24.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4579343,"change_date":"2023-04-19 21:42:00","inspection_id":"78395819","insp_unit_id":"194483604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"},{"id":4579344,"change_date":"2023-04-19 21:42:00","inspection_id":"78395819","insp_unit_id":"194483605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"}]},{"id":2615722,"change_date":"2023-03-20 21:41:00","inspection_id":"78134610","dot_number":"2884678","report_state":"MT","report_number":"K669000470","insp_date":"2023-03-19 00:00:00","insp_start_time":"1231","insp_end_time":"1244","registration_date":null,"region":"MT","ci_status_code":"C","location":"0669","location_desc":"BILLINGS WB INSPECTION FACILIT","county_code_state":"MT","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SMALL PET SELECT","shipping_paper_number":"392395","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18339","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":"988397","transaction_code":"A","transaction_date":"2023-03-19 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-20 00:00:00","source_office":"4MTS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:53.000000Z","updated_at":"2025-03-17T19:14:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4210973,"change_date":"2023-03-20 21:41:00","inspection_id":"78134610","insp_unit_id":"193960906","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:12.000000Z","updated_at":"2025-03-17T22:36:12.000000Z"},{"id":4210974,"change_date":"2023-03-20 21:41:00","inspection_id":"78134610","insp_unit_id":"193960907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D4NL347966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:12.000000Z","updated_at":"2025-03-17T22:36:12.000000Z"}]},{"id":2428594,"change_date":"2023-02-22 21:41:00","inspection_id":"77921716","dot_number":"2884678","report_state":"CA","report_number":"UCPQ002299","insp_date":"2023-02-20 00:00:00","insp_start_time":"0150","insp_end_time":"0205","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","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":"2023-02-22 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":"14791231","transaction_code":"A","transaction_date":"2023-02-20 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-22 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:26.000000Z","updated_at":"2025-03-17T19:11:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3908683,"change_date":"2023-02-22 21:41:00","inspection_id":"77921716","insp_unit_id":"193531571","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHT","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:59.000000Z","updated_at":"2025-03-17T22:33:59.000000Z"},{"id":3908684,"change_date":"2023-02-22 21:41:00","inspection_id":"77921716","insp_unit_id":"193531572","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT","insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:59.000000Z","updated_at":"2025-03-17T22:33:59.000000Z"}]},{"id":2326435,"change_date":"2023-02-08 21:39:00","inspection_id":"77804673","dot_number":"2884678","report_state":"OR","report_number":"AASQ007937","insp_date":"2023-02-07 00:00:00","insp_start_time":"1000","insp_end_time":"1012","registration_date":null,"region":"MT","ci_status_code":"C","location":"2306","location_desc":"FAREWELL BEND POE","county_code_state":"OR","county_code":"045","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COSTCO 0662 BURLINGTON","shipping_paper_number":"105323094","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","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":"1218434","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-08 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"271917","created_at":"2025-03-17T19:09:37.000000Z","updated_at":"2025-03-17T19:09:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3744125,"change_date":"2023-02-08 21:39:00","inspection_id":"77804673","insp_unit_id":"193296171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9ENH0MN28208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"},{"id":3744126,"change_date":"2023-02-08 21:39:00","inspection_id":"77804673","insp_unit_id":"193296172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"70","insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"}]},{"id":2326682,"change_date":"2023-02-08 21:39:00","inspection_id":"77804951","dot_number":"2884678","report_state":"WA","report_number":"W531004497","insp_date":"2023-02-07 00:00:00","insp_start_time":"1710","insp_end_time":"1747","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":"HANKOOK","shipping_paper_number":"1004465247","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-02-08 21:39: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":"2551204","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-08 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:37.000000Z","updated_at":"2025-03-17T19:09:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3744552,"change_date":"2023-02-08 21:39:00","inspection_id":"77804951","insp_unit_id":"193296752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"},{"id":3744553,"change_date":"2023-02-08 21:39:00","inspection_id":"77804951","insp_unit_id":"193296753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"}]},{"id":2217690,"change_date":"2023-01-24 21:43:00","inspection_id":"77681268","dot_number":"2884678","report_state":"WA","report_number":"W119001375","insp_date":"2023-01-23 00:00:00","insp_start_time":"0717","insp_end_time":"0736","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC07","location_desc":"SC07   FT LEWIS NORTHBOUND","county_code_state":"WA","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"TALKING RAIN KENT DC","shipping_paper_number":"37889","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":"I","final_status_date":"2023-01-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2547487","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-24 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-01-24 21:43:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:24.000000Z","updated_at":"2025-03-17T19:07:24.000000Z","inspection_violations":[{"id":3423795,"change_date":"2023-01-24 21:43:00","inspection_id":"77681268","insp_violation_id":"250750483","seq_no":"1","part_no":"395","part_no_section":"24(d)","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:23:13.000000Z","updated_at":"2025-03-17T21:23:13.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":3569451,"change_date":"2023-01-24 21:43:00","inspection_id":"77681268","insp_unit_id":"193041636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:35.000000Z","updated_at":"2025-03-17T22:31:35.000000Z"},{"id":3569452,"change_date":"2023-01-24 21:43:00","inspection_id":"77681268","insp_unit_id":"193041637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:35.000000Z","updated_at":"2025-03-17T22:31:35.000000Z"}]},{"id":2168423,"change_date":"2023-01-18 21:40:00","inspection_id":"77625191","dot_number":"2884678","report_state":"OR","report_number":"AASJ008712","insp_date":"2023-01-17 00:00:00","insp_start_time":"1010","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"0906","location_desc":"BEND - 2 MI S BEND","county_code_state":"OR","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MARS PETCARE US INC","shipping_paper_number":"16916879","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-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"1217111","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-18 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"271917","created_at":"2025-03-17T19:06:36.000000Z","updated_at":"2025-03-17T19:06:36.000000Z","inspection_violations":[{"id":3354186,"change_date":"2023-01-18 21:40:00","inspection_id":"77625191","insp_violation_id":"250636182","seq_no":"1","part_no":"395","part_no_section":"26(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:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39526B"}],"inspection_per_units":[{"id":3490203,"change_date":"2023-01-18 21:40:00","inspection_id":"77625191","insp_unit_id":"192929354","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:02.000000Z","updated_at":"2025-03-17T22:31:02.000000Z"},{"id":3490204,"change_date":"2023-01-18 21:40:00","inspection_id":"77625191","insp_unit_id":"192929355","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"70","insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:02.000000Z","updated_at":"2025-03-17T22:31:02.000000Z"}]},{"id":2182555,"change_date":"2023-01-19 21:44:00","inspection_id":"77641111","dot_number":"2884678","report_state":"NE","report_number":"0159000948","insp_date":"2023-01-15 00:00:00","insp_start_time":"1550","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":"WEB","location_desc":"WAVERLY EASTBOUND SCALES","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BEST BAY TRUCKING","shipping_paper_number":"D1052565","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-01-19 21:44: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":"751607","transaction_code":"A","transaction_date":"2023-01-15 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-17 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:55.000000Z","updated_at":"2025-03-17T19:06:55.000000Z","inspection_violations":[{"id":3371505,"change_date":"2023-01-19 21:44:00","inspection_id":"77641111","insp_violation_id":"250663657","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192960216","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EF6800819","created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3513120,"change_date":"2023-01-19 21:44:00","inspection_id":"77641111","insp_unit_id":"192960215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78","insp_unit_license":"WP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:11.000000Z","updated_at":"2025-03-17T22:31:11.000000Z"},{"id":3513121,"change_date":"2023-01-19 21:44:00","inspection_id":"77641111","insp_unit_id":"192960216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:11.000000Z","updated_at":"2025-03-17T22:31:11.000000Z"}]},{"id":2118897,"change_date":"2023-01-11 21:43:00","inspection_id":"77567989","dot_number":"2884678","report_state":"CA","report_number":"NA9Q000691","insp_date":"2023-01-04 00:00:00","insp_start_time":"0900","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"3600 W.  CAPITAL","county_code_state":"CA","county_code":"113","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":"2023-01-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"14732332","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T19:05:34.000000Z","updated_at":"2025-03-17T19:05:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3410488,"change_date":"2023-01-11 21:43:00","inspection_id":"77567989","insp_unit_id":"192819224","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"74","insp_unit_license":"YP54432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"Y","insp_unit_decal_number":"32130909","created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"},{"id":3410489,"change_date":"2023-01-11 21:43:00","inspection_id":"77567989","insp_unit_id":"192819225","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"55","insp_unit_license":"4UU2162","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D4PL378718","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"}]},{"id":2118898,"change_date":"2023-01-11 21:43:00","inspection_id":"77567990","dot_number":"2884678","report_state":"CA","report_number":"NA9Q000692","insp_date":"2023-01-04 00:00:00","insp_start_time":"1035","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"280","location_desc":"3600 W.  CAPITAL","county_code_state":"CA","county_code":"113","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":"2023-01-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"14732912","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T19:05:34.000000Z","updated_at":"2025-03-17T19:05:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3410490,"change_date":"2023-01-11 21:43:00","inspection_id":"77567990","insp_unit_id":"192819226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"Y","insp_unit_decal_number":"32130910","created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"},{"id":3410491,"change_date":"2023-01-11 21:43:00","inspection_id":"77567990","insp_unit_id":"192819227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"57","insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"}]},{"id":2058599,"change_date":"2023-01-03 21:41:00","inspection_id":"77498846","dot_number":"2884678","report_state":"WA","report_number":"W428004902","insp_date":"2022-12-30 00:00:00","insp_start_time":"0926","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC64","location_desc":"SC64   EAST SPOKANE (POE)","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AMERICAN POP CORN COMPANY","shipping_paper_number":"060715-010","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-01-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"2543167","transaction_code":"A","transaction_date":"2022-12-30 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-03 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-01-03 21:41:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6049 PARKMINSTER WAY","insp_carrier_city":"ROSEVILLE","insp_carrier_state":"CA","insp_carrier_zip_code":"95747","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:26.000000Z","updated_at":"2025-03-17T19:04:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3311856,"change_date":"2023-01-03 21:41:00","inspection_id":"77498846","insp_unit_id":"192679687","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:43.000000Z","updated_at":"2025-03-17T22:29:43.000000Z"},{"id":3311857,"change_date":"2023-01-03 21:41:00","inspection_id":"77498846","insp_unit_id":"192679688","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D4NL347966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:43.000000Z","updated_at":"2025-03-17T22:29:43.000000Z"}]},{"id":1876081,"change_date":"2022-12-05 21:40:00","inspection_id":"77290237","dot_number":"2884678","report_state":"CA","report_number":"UEH7003690","insp_date":"2022-12-02 00:00:00","insp_start_time":"1331","insp_end_time":"1350","registration_date":null,"region":"PT","ci_status_code":"C","location":"285","location_desc":"RIEGO RD","county_code_state":"CA","county_code":"101","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40: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":"14695115","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:09.000000Z","updated_at":"2025-03-17T19:01:09.000000Z","inspection_violations":[{"id":2920636,"change_date":"2022-12-05 21:40:00","inspection_id":"77290237","insp_violation_id":"249928348","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:20:57.000000Z","updated_at":"2025-03-17T21:20:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3019681,"change_date":"2022-12-05 21:40:00","inspection_id":"77290237","insp_unit_id":"192269616","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"XP91193","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ1FN924580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:40.000000Z","updated_at":"2025-03-17T22:27:40.000000Z"},{"id":3019682,"change_date":"2022-12-05 21:40:00","inspection_id":"77290237","insp_unit_id":"192269617","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"FRT","insp_unit_company":null,"insp_unit_license":"2574680","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXCY9HDJE2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:40.000000Z","updated_at":"2025-03-17T22:27:40.000000Z"}]},{"id":1225231,"change_date":"2022-09-06 21:43:00","inspection_id":"76539715","dot_number":"2884678","report_state":"CA","report_number":"UDPM000136","insp_date":"2022-09-05 00:00:00","insp_start_time":"1015","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"W\/B 80 WEST OF HIRSCHDALE","county_code_state":"CA","county_code":"057","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14581330","transaction_code":"A","transaction_date":"2022-09-05 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-06 21:43:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:19.000000Z","updated_at":"2025-03-17T18:49:19.000000Z","inspection_violations":[{"id":1940795,"change_date":"2022-09-06 21:43:00","inspection_id":"76539715","insp_violation_id":"248245697","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":null,"created_at":"2025-03-17T21:15:58.000000Z","updated_at":"2025-03-17T21:15:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1971681,"change_date":"2022-09-06 21:43:00","inspection_id":"76539715","insp_unit_id":"190753691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"76","insp_unit_license":"XP91192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0MN282086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:33.000000Z","updated_at":"2025-03-17T22:20:33.000000Z"}]},{"id":1100684,"change_date":"2022-08-23 21:42:00","inspection_id":"76395372","dot_number":"2884678","report_state":"SD","report_number":"HP09003119","insp_date":"2022-08-16 00:00:00","insp_start_time":"1602","insp_end_time":"1609","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"INTERSTATE","county_code_state":"SD","county_code":"081","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"STARBUCKS COFFEE STOCKTON CA","shipping_paper_number":"072891100552490","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"624746","transaction_code":"C","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-22 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:11.000000Z","updated_at":"2025-03-17T18:47:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1770551,"change_date":"2022-08-23 21:42:00","inspection_id":"76395372","insp_unit_id":"190498311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:11.000000Z","updated_at":"2025-03-17T22:19:11.000000Z"},{"id":1770552,"change_date":"2022-08-23 21:42:00","inspection_id":"76395372","insp_unit_id":"190498312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:11.000000Z","updated_at":"2025-03-17T22:19:11.000000Z"}]},{"id":1099482,"change_date":"2022-08-22 21:42:00","inspection_id":"76393972","dot_number":"2884678","report_state":"WI","report_number":"2734001730","insp_date":"2022-08-15 00:00:00","insp_start_time":"1442","insp_end_time":"1454","registration_date":null,"region":"CT","ci_status_code":"C","location":"S72","location_desc":"SUPERIOR SWEF","county_code_state":"WI","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SUPERIOR PACKAGING COMPANY","shipping_paper_number":"146109","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"869156","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-17 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"ALOHA PRO","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[{"id":1731661,"change_date":"2022-08-22 21:42:00","inspection_id":"76393972","insp_violation_id":"247887462","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:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":1768426,"change_date":"2022-08-22 21:42:00","inspection_id":"76393972","insp_unit_id":"190457829","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"74","insp_unit_license":"YP54432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ4PN614005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"},{"id":1768427,"change_date":"2022-08-22 21:42:00","inspection_id":"76393972","insp_unit_id":"190457830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4UA1176","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532DXNL336874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]},{"id":1019264,"change_date":"2022-08-11 21:38:00","inspection_id":"76299996","dot_number":"2884678","report_state":"UT","report_number":"22RP000215","insp_date":"2022-08-10 00:00:00","insp_start_time":"0954","insp_end_time":"1120","registration_date":null,"region":"MT","ci_status_code":"C","location":"EB","location_desc":"WENDOVER PORT OF ENTRY","county_code_state":"UT","county_code":"045","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FARMERS' RICE COOPERATIVE","shipping_paper_number":"111435","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117828","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"854584","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-10 00:00:00","source_office":"4UTS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:29.000000Z","updated_at":"2025-03-17T18:45:29.000000Z","inspection_violations":[{"id":1606009,"change_date":"2022-08-11 21:38:00","inspection_id":"76299996","insp_violation_id":"247664500","seq_no":"1","part_no":"392","part_no_section":"3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"3923"}],"inspection_per_units":[{"id":1640226,"change_date":"2022-08-11 21:38:00","inspection_id":"76299996","insp_unit_id":"190266449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"78","insp_unit_license":"YP54389","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ9PN614064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:20.000000Z","updated_at":"2025-03-17T22:18:20.000000Z"},{"id":1640227,"change_date":"2022-08-11 21:38:00","inspection_id":"76299996","insp_unit_id":"190266450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"176","insp_unit_license":"4UB2608","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D2NL347965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:20.000000Z","updated_at":"2025-03-17T22:18:20.000000Z"}]},{"id":1011887,"change_date":"2022-08-10 21:40:00","inspection_id":"76291316","dot_number":"2884678","report_state":"CA","report_number":"NDFA003929","insp_date":"2022-08-09 00:00:00","insp_start_time":"1405","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KUEHNE + NAGEL","shipping_paper_number":"10181938","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14543651","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-10 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":"486838","created_at":"2025-03-17T18:45:27.000000Z","updated_at":"2025-03-17T18:45:27.000000Z","inspection_violations":[{"id":1594117,"change_date":"2022-08-10 21:40:00","inspection_id":"76291316","insp_violation_id":"247644598","seq_no":"1","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"JV45203","created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":1628029,"change_date":"2022-08-10 21:40:00","inspection_id":"76291316","insp_unit_id":"190248537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"},{"id":1628030,"change_date":"2022-08-10 21:40:00","inspection_id":"76291316","insp_unit_id":"190248538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"70","insp_unit_license":"4UB2609","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D4NL347966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"}]},{"id":358552,"change_date":"2022-05-10 21:40:00","inspection_id":"75520529","dot_number":"2884678","report_state":"MN","report_number":"0AED000584","insp_date":"2022-05-10 00:00:00","insp_start_time":"0854","insp_end_time":"0931","registration_date":null,"region":"CT","ci_status_code":"C","location":"NODINE","location_desc":"NODINE","county_code_state":"MN","county_code":"169","insp_level_id":"3","service_center":"MW","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":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1327940","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02884678","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-10 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"ALOHA HATA PROPERTY INC","insp_carrier_street":"6414 MAUANA WAY","insp_carrier_city":"CITRUS HTS","insp_carrier_state":"CA","insp_carrier_zip_code":"95610-5009","insp_colonia":null,"docket_number":"968514","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:42.000000Z","updated_at":"2025-03-17T18:33:42.000000Z","inspection_violations":[{"id":561467,"change_date":"2022-05-10 21:40:00","inspection_id":"75520529","insp_violation_id":"245696881","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188605159","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":579797,"change_date":"2022-05-10 21:40:00","inspection_id":"75520529","insp_unit_id":"188605159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"77","insp_unit_license":"YP05501","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH7MN282134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:45.000000Z","updated_at":"2025-03-17T22:11:45.000000Z"},{"id":579798,"change_date":"2022-05-10 21:40:00","inspection_id":"75520529","insp_unit_id":"188605160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"4ST8208","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D0LL173391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:45.000000Z","updated_at":"2025-03-17T22:11:45.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/2884678\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/2884678\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/2884678\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/2884678\/inspections","per_page":100,"prev_page_url":null,"to":68,"total":68}