{"current_page":1,"data":[{"id":12733563,"change_date":"2026-08-14 21:41:00","inspection_id":"88703809","dot_number":"357103","report_state":"CA","report_number":"UG0K006150","insp_date":"2026-08-14 00:00:00","insp_start_time":"1510","insp_end_time":"1530","registration_date":null,"region":"PD","ci_status_code":"C","location":"135","location_desc":"CA","county_code_state":"CA","county_code":"089","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3988455","transaction_code":"A","transaction_date":"2026-08-14 00:00:00","upload_date":"2026-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2026-08-14 21:41:00","snet_input_date":"2026-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-14 21:41:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-17T09:40:13.000000Z","updated_at":"2026-08-20T09:37:51.000000Z","inspection_violations":[{"id":22166659,"change_date":"2026-08-14 21:41:00","inspection_id":"88703809","insp_violation_id":"276138788","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":"SS01164","created_at":"2026-08-17T09:58:47.000000Z","updated_at":"2026-08-20T09:52:33.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":22103279,"change_date":"2026-08-14 21:41:00","inspection_id":"88703809","insp_unit_id":"215162752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":null,"insp_unit_license":"3991398","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:26.000000Z","updated_at":"2026-08-20T09:12:05.000000Z"},{"id":22103280,"change_date":"2026-08-14 21:41:00","inspection_id":"88703809","insp_unit_id":"215162753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"PE35562","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:26.000000Z","updated_at":"2026-08-20T09:12:05.000000Z"}]},{"id":11649747,"change_date":"2026-04-15 21:38:00","inspection_id":"87579271","dot_number":"357103","report_state":"CO","report_number":"0721190414","insp_date":"2026-04-13 00:00:00","insp_start_time":"1138","insp_end_time":"1240","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"PARKER CO","county_code_state":"CO","county_code":"035","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LML ENTERPRISES LTD","shipping_paper_number":"349464","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-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"3157960","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:13.000000Z","updated_at":"2026-04-26T09:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20264317,"change_date":"2026-04-15 21:38:00","inspection_id":"87579271","insp_unit_id":"213021887","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"355","insp_unit_license":"2593579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ263446","insp_unit_decal":"Y","insp_unit_decal_number":"36380964","created_at":"2026-04-26T09:02:28.000000Z","updated_at":"2026-04-26T09:02:28.000000Z"},{"id":20264318,"change_date":"2026-04-15 21:38:00","inspection_id":"87579271","insp_unit_id":"213021888","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"233","insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"Y","insp_unit_decal_number":"36380965","created_at":"2026-04-26T09:02:28.000000Z","updated_at":"2026-04-26T09:02:28.000000Z"}]},{"id":11502068,"change_date":"2026-03-27 21:40:00","inspection_id":"87422207","dot_number":"357103","report_state":"NV","report_number":"7233029457","insp_date":"2026-03-11 00:00:00","insp_start_time":"1725","insp_end_time":"1745","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"SLOAN CHECKSITE","county_code_state":"NV","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCED PIANO","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":"2026-03-27 21:40: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":"811193","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-11 00:00:00","source_office":"4NVS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:46.000000Z","updated_at":"2026-04-07T09:32:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19704584,"change_date":"2026-03-27 21:40:00","inspection_id":"87422207","insp_unit_id":"212387363","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"353","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:27.000000Z","updated_at":"2026-04-07T09:09:06.000000Z"},{"id":19704585,"change_date":"2026-03-27 21:40:00","inspection_id":"87422207","insp_unit_id":"212387364","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"PE35562","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:27.000000Z","updated_at":"2026-04-07T09:09:06.000000Z"}]},{"id":11327408,"change_date":"2026-03-09 21:37:00","inspection_id":"87244351","dot_number":"357103","report_state":"CA","report_number":"NETE003759","insp_date":"2026-03-07 00:00:00","insp_start_time":"1351","insp_end_time":"1401","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MULTIPLE","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-09 21:37: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":"16200830","transaction_code":"A","transaction_date":"2026-03-07 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-09 21:37:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-12T09:40:31.000000Z","updated_at":"2026-03-20T09:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19381393,"change_date":"2026-03-09 21:37:00","inspection_id":"87244351","insp_unit_id":"212049813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLK\/353","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:10.000000Z","updated_at":"2026-03-20T09:04:12.000000Z"},{"id":19381394,"change_date":"2026-03-09 21:37:00","inspection_id":"87244351","insp_unit_id":"212049814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/227","insp_unit_license":"PE35562","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:10.000000Z","updated_at":"2026-03-20T09:04:12.000000Z"}]},{"id":11074450,"change_date":"2026-02-07 21:33:00","inspection_id":"86985252","dot_number":"357103","report_state":"IN","report_number":"9877000054","insp_date":"2026-02-02 00:00:00","insp_start_time":"2139","insp_end_time":"2219","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROCHESTER IN","county_code_state":"IN","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BARRETT DISTRIBUTION CENTER","shipping_paper_number":"59222264-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-07 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"2857892","transaction_code":"A","transaction_date":"2026-02-07 00:00:00","upload_date":"2026-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2026-02-07 21:33:00","snet_input_date":"2026-02-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-07 21:33:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-10T10:37:28.000000Z","updated_at":"2026-02-18T10:30:19.000000Z","inspection_violations":[{"id":18536391,"change_date":"2026-02-07 21:33:00","inspection_id":"86985252","insp_violation_id":"271658512","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":"2026-02-10T10:51:15.000000Z","updated_at":"2026-02-18T10:37:49.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18882843,"change_date":"2026-02-07 21:33:00","inspection_id":"86985252","insp_unit_id":"211499146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"355","insp_unit_license":"2593579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ263446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-10T10:14:30.000000Z","updated_at":"2026-02-18T10:02:52.000000Z"},{"id":18882844,"change_date":"2026-02-07 21:33:00","inspection_id":"86985252","insp_unit_id":"211499147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"1","insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-10T10:14:30.000000Z","updated_at":"2026-02-18T10:02:52.000000Z"}]},{"id":10784999,"change_date":"2026-01-16 21:39:00","inspection_id":"86810839","dot_number":"357103","report_state":"AZ","report_number":"6868000470","insp_date":"2026-01-14 00:00:00","insp_start_time":"0920","insp_end_time":"1010","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZBWLW","location_desc":"TONOPAH AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SCHIMMEL PIANO CORP","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"2773680","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:51.000000Z","updated_at":"2026-01-27T10:30:11.000000Z","inspection_violations":[{"id":18022450,"change_date":"2026-01-16 21:39:00","inspection_id":"86810839","insp_violation_id":"271244534","seq_no":"1","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:14.000000Z","updated_at":"2026-01-27T10:30:21.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":18107326,"change_date":"2026-01-16 21:39:00","inspection_id":"86810839","insp_unit_id":"211123361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"355","insp_unit_license":"2593579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ263446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:20.000000Z","updated_at":"2026-01-27T10:00:13.000000Z"},{"id":18107327,"change_date":"2026-01-16 21:39:00","inspection_id":"86810839","insp_unit_id":"211123362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"UNIT 233","insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:20.000000Z","updated_at":"2026-01-27T10:00:13.000000Z"}]},{"id":9942925,"change_date":"2025-10-14 21:42:00","inspection_id":"86050087","dot_number":"357103","report_state":"CA","report_number":"NCRM008138","insp_date":"2025-10-08 00:00:00","insp_start_time":"1730","insp_end_time":"1745","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLASSIC PIANO'S","shipping_paper_number":"MULTIPLE","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-10-14 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":"16018235","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-14 21:42:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:54.000000Z","updated_at":"2025-10-18T10:01:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16504432,"change_date":"2025-10-14 21:42:00","inspection_id":"86050087","insp_unit_id":"209471905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":"354\/BLK","insp_unit_license":"3365305","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ261937","insp_unit_decal":"Y","insp_unit_decal_number":"35607760","created_at":"2025-10-17T09:46:58.000000Z","updated_at":"2025-10-18T09:46:52.000000Z"},{"id":16504433,"change_date":"2025-10-14 21:42:00","inspection_id":"86050087","insp_unit_id":"209471906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"234\/WHT","insp_unit_license":"P797346","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2531L7077102","insp_unit_decal":"Y","insp_unit_decal_number":"35607761","created_at":"2025-10-17T09:46:58.000000Z","updated_at":"2025-10-18T09:46:52.000000Z"}]},{"id":9233980,"change_date":"2025-07-24 21:40:00","inspection_id":"85305013","dot_number":"357103","report_state":"MO","report_number":"W044000830","insp_date":"2025-07-24 00:00:00","insp_start_time":"1033","insp_end_time":"1113","registration_date":null,"region":"CD","ci_status_code":"C","location":"G1W","location_desc":"WILLOW SPRINGS MO","county_code_state":"MO","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2036912","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:49.000000Z","updated_at":"2025-07-30T10:00:31.000000Z","inspection_violations":[{"id":14948951,"change_date":"2025-07-24 21:40:00","inspection_id":"85305013","insp_violation_id":"267622041","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208052713","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:05.000000Z","updated_at":"2025-07-28T10:48:22.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":15193785,"change_date":"2025-07-24 21:40:00","inspection_id":"85305013","insp_unit_id":"208052713","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"355","insp_unit_license":"2593579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ263446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:28.000000Z","updated_at":"2025-07-28T09:45:39.000000Z"},{"id":15193786,"change_date":"2025-07-24 21:40:00","inspection_id":"85305013","insp_unit_id":"208052714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"UNIT 233","insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:28.000000Z","updated_at":"2025-07-28T09:45:39.000000Z"}]},{"id":8705748,"change_date":"2025-05-21 21:42:00","inspection_id":"84746856","dot_number":"357103","report_state":"CA","report_number":"ND7X006697","insp_date":"2025-05-20 00:00:00","insp_start_time":"1825","insp_end_time":"1836","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD CVEF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLASSIC PIANOS","shipping_paper_number":"6428721","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-05-21 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":"15829381","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:36.000000Z","updated_at":"2025-05-25T10:07:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14226381,"change_date":"2025-05-21 21:42:00","inspection_id":"84746856","insp_unit_id":"206999525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":"354\/BLK","insp_unit_license":"3365305","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ261937","insp_unit_decal":"Y","insp_unit_decal_number":"35050686","created_at":"2025-05-24T09:50:01.000000Z","updated_at":"2025-05-25T09:53:21.000000Z"},{"id":14226382,"change_date":"2025-05-21 21:42:00","inspection_id":"84746856","insp_unit_id":"206999526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"234\/WHI","insp_unit_license":"P797346","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2531L7077102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:50:01.000000Z","updated_at":"2025-05-25T09:53:21.000000Z"}]},{"id":8079837,"change_date":"2025-03-11 21:40:00","inspection_id":"84087782","dot_number":"357103","report_state":"OR","report_number":"AP90260645","insp_date":"2025-03-11 00:00:00","insp_start_time":"1210","insp_end_time":"1250","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NORTHWEST ROUTE","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-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1457374","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:54.000000Z","updated_at":"2025-03-17T21:05:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13045506,"change_date":"2025-03-11 21:40:00","inspection_id":"84087782","insp_unit_id":"205727672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"353","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"Y","insp_unit_decal_number":"34956584","created_at":"2025-03-17T23:59:14.000000Z","updated_at":"2025-03-17T23:59:14.000000Z"},{"id":13045507,"change_date":"2025-03-11 21:40:00","inspection_id":"84087782","insp_unit_id":"205727673","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"227","insp_unit_license":"PE35562","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"Y","insp_unit_decal_number":"34956585","created_at":"2025-03-17T23:59:14.000000Z","updated_at":"2025-03-17T23:59:14.000000Z"}]},{"id":7899482,"change_date":"2025-02-18 21:40:00","inspection_id":"83898336","dot_number":"357103","report_state":"CA","report_number":"UECE006908","insp_date":"2025-02-15 00:00:00","insp_start_time":"1020","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"I-5 S\/B NOF LAGUNA","county_code_state":"CA","county_code":"067","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":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15705644","transaction_code":"A","transaction_date":"2025-02-15 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[{"id":12344688,"change_date":"2025-02-18 21:40:00","inspection_id":"83898336","insp_violation_id":"264575857","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":"ECITE","created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3922SLLS3"},{"id":12344689,"change_date":"2025-02-18 21:40:00","inspection_id":"83898336","insp_violation_id":"264575858","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205381116","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12751196,"change_date":"2025-02-18 21:40:00","inspection_id":"83898336","insp_unit_id":"205381116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"},{"id":12751197,"change_date":"2025-02-18 21:40:00","inspection_id":"83898336","insp_unit_id":"205381117","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"PE35562","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7502366,"change_date":"2024-12-26 21:37:00","inspection_id":"83481305","dot_number":"357103","report_state":"CA","report_number":"ND9N003766","insp_date":"2024-12-23 00:00:00","insp_start_time":"1020","insp_end_time":"1044","registration_date":null,"region":"PT","ci_status_code":"C","location":"883","location_desc":"CAJON NORTHBOUND SCALES","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15642714","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-26 21:37:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:39.000000Z","updated_at":"2025-03-17T20:52:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12103055,"change_date":"2024-12-26 21:37:00","inspection_id":"83481305","insp_unit_id":"204559771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"353\/BLK","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"Y","insp_unit_decal_number":"34524758","created_at":"2025-03-17T23:48:37.000000Z","updated_at":"2025-03-17T23:48:37.000000Z"}]},{"id":7455612,"change_date":"2024-12-19 21:40:00","inspection_id":"83432089","dot_number":"357103","report_state":"UT","report_number":"25DZ001111","insp_date":"2024-12-17 00:00:00","insp_start_time":"0848","insp_end_time":"0927","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"PROVO UT","county_code_state":"UT","county_code":"049","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WALTER PIANO TRANSPORT","shipping_paper_number":"38694","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-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"81800","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":"1171746","transaction_code":"A","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2024-12-19 21:40:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-19 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:35.000000Z","updated_at":"2025-03-17T20:51:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12027948,"change_date":"2024-12-19 21:40:00","inspection_id":"83432089","insp_unit_id":"204468658","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"345","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYDP9X4FJ432730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"},{"id":12027949,"change_date":"2024-12-19 21:40:00","inspection_id":"83432089","insp_unit_id":"204468659","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"PE35562","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"}]},{"id":6316344,"change_date":"2024-07-25 21:44:00","inspection_id":"82222295","dot_number":"357103","report_state":"CA","report_number":"UD3Z004003","insp_date":"2024-07-24 00:00:00","insp_start_time":"1741","insp_end_time":"1811","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLASSIC PIANOS","shipping_paper_number":"6329705","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-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15456761","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-25 21:44:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[{"id":9807878,"change_date":"2024-07-25 21:44:00","inspection_id":"82222295","insp_violation_id":"260855834","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202083693","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"3922"},{"id":9807879,"change_date":"2024-07-25 21:44:00","inspection_id":"82222295","insp_violation_id":"260855835","seq_no":"2","part_no":"395","part_no_section":"24(c)(2)(i)","insp_viol_unit":"1","insp_unit_id":"202083692","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39524C2I"},{"id":9807880,"change_date":"2024-07-25 21:44:00","inspection_id":"82222295","insp_violation_id":"260855836","seq_no":"3","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"202083692","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:27.000000Z","updated_at":"2025-03-17T21:53:27.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":10177491,"change_date":"2024-07-25 21:44:00","inspection_id":"82222295","insp_unit_id":"202083692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"354 BLK","insp_unit_license":"3365305","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ261937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"},{"id":10177492,"change_date":"2024-07-25 21:44:00","inspection_id":"82222295","insp_unit_id":"202083693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"P797346","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2531L7077102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"}]},{"id":4868564,"change_date":"2024-01-19 21:44:00","inspection_id":"80649576","dot_number":"357103","report_state":"CA","report_number":"NBEV005122","insp_date":"2024-01-18 00:00:00","insp_start_time":"0836","insp_end_time":"0859","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WALTER PIANO TRANSPORT","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-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15206468","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:14.000000Z","updated_at":"2025-03-17T19:59:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7833384,"change_date":"2024-01-19 21:44:00","inspection_id":"80649576","insp_unit_id":"199037470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"355","insp_unit_license":"2593579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ263446","insp_unit_decal":"Y","insp_unit_decal_number":"33539516","created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"},{"id":7833385,"change_date":"2024-01-19 21:44:00","inspection_id":"80649576","insp_unit_id":"199037471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"Y","insp_unit_decal_number":"33539517","created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"}]},{"id":4231285,"change_date":"2023-10-18 21:42:00","inspection_id":"79949062","dot_number":"357103","report_state":"CA","report_number":"ND7X004850","insp_date":"2023-10-17 00:00:00","insp_start_time":"1802","insp_end_time":"1816","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":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-10-18 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":"15100053","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-18 21:42:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:38.000000Z","updated_at":"2025-03-17T19:46:38.000000Z","inspection_violations":[{"id":6551541,"change_date":"2023-10-18 21:42:00","inspection_id":"79949062","insp_violation_id":"255921778","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"197632044","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":6805013,"change_date":"2023-10-18 21:42:00","inspection_id":"79949062","insp_unit_id":"197632044","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"354\/BLK","insp_unit_license":"3365305","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ261937","insp_unit_decal":"Y","insp_unit_decal_number":"33191304","created_at":"2025-03-17T22:57:03.000000Z","updated_at":"2025-03-17T22:57:03.000000Z"},{"id":6805014,"change_date":"2023-10-18 21:42:00","inspection_id":"79949062","insp_unit_id":"197632045","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"234\/WHT","insp_unit_license":"P797346","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2531L7077102","insp_unit_decal":"Y","insp_unit_decal_number":"33191305","created_at":"2025-03-17T22:57:03.000000Z","updated_at":"2025-03-17T22:57:03.000000Z"}]},{"id":3978936,"change_date":"2023-09-14 21:42:00","inspection_id":"79669375","dot_number":"357103","report_state":"CA","report_number":"UCL5003884","insp_date":"2023-09-13 00:00:00","insp_start_time":"1808","insp_end_time":"1821","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":"YAMAHA","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-09-14 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":"15060871","transaction_code":"A","transaction_date":"2023-09-13 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-14 21:42:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:15.000000Z","updated_at":"2025-03-17T19:41:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6398122,"change_date":"2023-09-14 21:42:00","inspection_id":"79669375","insp_unit_id":"197068327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"354\/BLK","insp_unit_license":"3365305","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ261937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"},{"id":6398123,"change_date":"2023-09-14 21:42:00","inspection_id":"79669375","insp_unit_id":"197068328","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"234\/WHT","insp_unit_license":"P797346","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2531L7077102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"}]},{"id":3617363,"change_date":"2023-07-28 21:40:00","inspection_id":"79265736","dot_number":"357103","report_state":"MS","report_number":"6606171161","insp_date":"2023-07-26 00:00:00","insp_start_time":"1354","insp_end_time":"1423","registration_date":null,"region":"CT","ci_status_code":"C","location":"23","location_desc":"HANCOCK COUNTY","county_code_state":"MS","county_code":"045","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"WALTER PIANO","shipping_paper_number":"BUDYOUNG2023-07","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-07-28 21:40: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":"1038628","transaction_code":"A","transaction_date":"2023-07-26 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-07-28 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:16.000000Z","updated_at":"2025-03-17T19:34:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5815664,"change_date":"2023-07-28 21:40:00","inspection_id":"79265736","insp_unit_id":"196244938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"351","insp_unit_license":"2952263","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3LJ429781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:55.000000Z","updated_at":"2025-03-17T22:48:55.000000Z"},{"id":5815665,"change_date":"2023-07-28 21:40:00","inspection_id":"79265736","insp_unit_id":"196244939","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"229","insp_unit_license":"P880419","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25318G508903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:55.000000Z","updated_at":"2025-03-17T22:48:55.000000Z"}]},{"id":2800808,"change_date":"2023-04-13 21:43:00","inspection_id":"78345188","dot_number":"357103","report_state":"UT","report_number":"23JE000312","insp_date":"2023-04-12 00:00:00","insp_start_time":"1628","insp_end_time":"1652","registration_date":null,"region":"MT","ci_status_code":"C","location":"51","location_desc":"ST GEORGE PORT OF ENTRY NORTHB","county_code_state":"UT","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"879605","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-12 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:28.000000Z","updated_at":"2025-03-17T19:18:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4507908,"change_date":"2023-04-13 21:43:00","inspection_id":"78345188","insp_unit_id":"194378705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"353","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"},{"id":4507909,"change_date":"2023-04-13 21:43:00","inspection_id":"78345188","insp_unit_id":"194378706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"227","insp_unit_license":"P718949","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":2926023,"change_date":"2023-05-01 10:44:00","inspection_id":"78487085","dot_number":"357103","report_state":"NM","report_number":"1348N2LNLC","insp_date":"2023-04-03 00:00:00","insp_start_time":"1837","insp_end_time":"1857","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WALTER PIANO TRANSPORT INC","shipping_paper_number":"L1906918","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-05-01 10:44:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1999435","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":"2023-05-01 10:44:00","snet_input_date":"2023-04-29 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-05-01 10:44:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"30688 QUAIL POINTE DR","insp_carrier_city":"GRANGER","insp_carrier_state":"IN","insp_carrier_zip_code":"46530","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:53.000000Z","updated_at":"2025-03-17T19:20:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4707592,"change_date":"2023-05-01 10:44:00","inspection_id":"78487085","insp_unit_id":"194661353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT 352","insp_unit_license":"2953364","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ216514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"},{"id":4707593,"change_date":"2023-05-01 10:44:00","inspection_id":"78487085","insp_unit_id":"194661354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UNIT 233","insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"}]},{"id":1886073,"change_date":"2022-12-06 21:41:00","inspection_id":"77301742","dot_number":"357103","report_state":"CA","report_number":"UDMC001907","insp_date":"2022-12-05 00:00:00","insp_start_time":"1315","insp_end_time":"1345","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"VICTORVILLE CHP AREA","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"CHECK","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-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14697398","transaction_code":"A","transaction_date":"2022-12-05 00:00:00","upload_date":"2022-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-06 21:41:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:28.000000Z","updated_at":"2025-03-17T19:01:28.000000Z","inspection_violations":[{"id":2934982,"change_date":"2022-12-06 21:41:00","inspection_id":"77301742","insp_violation_id":"249956598","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:20:58.000000Z","updated_at":"2025-03-17T21:20:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3035487,"change_date":"2022-12-06 21:41:00","inspection_id":"77301742","insp_unit_id":"192293533","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"KEN","insp_unit_company":"353","insp_unit_license":"1210467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X5PJ216515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:48.000000Z","updated_at":"2025-03-17T22:27:48.000000Z"},{"id":3035488,"change_date":"2022-12-06 21:41:00","inspection_id":"77301742","insp_unit_id":"192293534","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X BOX","insp_unit_license":"P718949","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:48.000000Z","updated_at":"2025-03-17T22:27:48.000000Z"}]},{"id":1545372,"change_date":"2022-10-18 21:40:00","inspection_id":"76910800","dot_number":"357103","report_state":"CA","report_number":"NBED004121","insp_date":"2022-10-18 00:00:00","insp_start_time":"0716","insp_end_time":"0739","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WALTER PIANO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14640022","transaction_code":"A","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:11.000000Z","updated_at":"2025-03-17T18:55:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2487126,"change_date":"2022-10-18 21:40:00","inspection_id":"76910800","insp_unit_id":"191509745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"352 BLK","insp_unit_license":"2953364","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X3PJ216514","insp_unit_decal":"Y","insp_unit_decal_number":"31865025","created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"},{"id":2487127,"change_date":"2022-10-18 21:40:00","inspection_id":"76910800","insp_unit_id":"191509746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"233 WHT","insp_unit_license":"P797345","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS253XL7077101","insp_unit_decal":"Y","insp_unit_decal_number":"31865026","created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"}]},{"id":1497477,"change_date":"2022-10-12 21:41:00","inspection_id":"76855836","dot_number":"357103","report_state":"IN","report_number":"8989000139","insp_date":"2022-10-07 00:00:00","insp_start_time":"1750","insp_end_time":"1813","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 1050 N MACY","county_code_state":"IN","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"WALTER PIANO TRANSPORT CO","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":"2022-10-12 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":"2153819","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-11 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:10.000000Z","updated_at":"2025-03-17T18:54:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2410074,"change_date":"2022-10-12 21:41:00","inspection_id":"76855836","insp_unit_id":"191400786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"350","insp_unit_license":"2594206","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X2JJ199194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:32.000000Z","updated_at":"2025-03-17T22:23:32.000000Z"},{"id":2410075,"change_date":"2022-10-12 21:41:00","inspection_id":"76855836","insp_unit_id":"191400787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P880419","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25318G508903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:32.000000Z","updated_at":"2025-03-17T22:23:32.000000Z"}]},{"id":704035,"change_date":"2022-06-27 21:41:00","inspection_id":"75931378","dot_number":"357103","report_state":"CA","report_number":"ND7X003319","insp_date":"2022-06-21 00:00:00","insp_start_time":"1737","insp_end_time":"1753","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD CVEF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 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":"14484326","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:09.000000Z","updated_at":"2025-03-17T18:40:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1131848,"change_date":"2022-06-27 21:41:00","inspection_id":"75931378","insp_unit_id":"189488436","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"346\/BLK","insp_unit_license":"1055926","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X9GJ129877","insp_unit_decal":"Y","insp_unit_decal_number":"31080749","created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"},{"id":1131849,"change_date":"2022-06-27 21:41:00","inspection_id":"75931378","insp_unit_id":"189488437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"234\/WHT","insp_unit_license":"P7973346","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2531L7077102","insp_unit_decal":"Y","insp_unit_decal_number":"31080750","created_at":"2025-03-17T22:15:09.000000Z","updated_at":"2025-03-17T22:15:09.000000Z"}]},{"id":215641,"change_date":"2022-04-20 21:43:00","inspection_id":"75350297","dot_number":"357103","report_state":"UT","report_number":"22GK000249","insp_date":"2022-04-19 00:00:00","insp_start_time":"1310","insp_end_time":"1340","registration_date":null,"region":"MT","ci_status_code":"C","location":"ST G","location_desc":"ST GEORGE PORT OF ENTRY NB","county_code_state":"UT","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"844109","transaction_code":"A","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00357103","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-19 00:00:00","source_office":"4UTS001","mcmis_add_date":"2022-04-20 21:43:00","insp_carrier_name":"WALTER PIANO TRANSPORT INC","insp_carrier_street":"2135 INDUSTRIAL PARKWAY","insp_carrier_city":"ELKHART","insp_carrier_state":"IN","insp_carrier_zip_code":"46516","insp_colonia":null,"docket_number":"223057","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:15.000000Z","updated_at":"2025-03-17T18:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":350109,"change_date":"2022-04-20 21:43:00","inspection_id":"75350297","insp_unit_id":"188252155","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"348","insp_unit_license":"2593579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1XKYD49X9JJ199192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:17.000000Z","updated_at":"2025-03-17T22:10:17.000000Z"},{"id":350110,"change_date":"2022-04-20 21:43:00","inspection_id":"75350297","insp_unit_id":"188252156","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"227","insp_unit_license":"P718949","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS25368G508802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:17.000000Z","updated_at":"2025-03-17T22:10:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/357103\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/357103\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/357103\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/357103\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}