{"current_page":1,"data":[{"id":12117327,"change_date":"2026-06-06 21:38:00","inspection_id":"88062596","dot_number":"3597595","report_state":"CA","report_number":"NECK004359","insp_date":"2026-06-06 00:00:00","insp_start_time":"0545","insp_end_time":"0615","registration_date":null,"region":"PS","ci_status_code":"C","location":"890","location_desc":"CA","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENCORE PIANO MOVING","shipping_paper_number":"33677B3","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-06-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3483200","transaction_code":"A","transaction_date":"2026-06-06 00:00:00","upload_date":"2026-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2026-06-06 21:38:00","snet_input_date":"2026-06-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-06 21:38:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"1815 INDUSTRIAL DR #200","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95206","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2026-06-09T09:41:00.000000Z","updated_at":"2026-06-17T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21052588,"change_date":"2026-06-06 21:38:00","inspection_id":"88062596","insp_unit_id":"213951437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-09T09:17:30.000000Z","updated_at":"2026-06-17T09:02:45.000000Z"}]},{"id":10401202,"change_date":"2025-12-10 21:38:00","inspection_id":"86531461","dot_number":"3597595","report_state":"CA","report_number":"NABR009709","insp_date":"2025-12-10 00:00:00","insp_start_time":"0733","insp_end_time":"0754","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"16088474","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"1815 INDUSTRIAL DR #200","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95206","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-12-13T10:31:40.000000Z","updated_at":"2025-12-14T10:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17390801,"change_date":"2025-12-10 21:38:00","inspection_id":"86531461","insp_unit_id":"210531001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"210","insp_unit_license":"33647B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:53.000000Z","updated_at":"2025-12-14T10:01:31.000000Z"}]},{"id":9929657,"change_date":"2025-10-13 21:37:00","inspection_id":"86035544","dot_number":"3597595","report_state":"CA","report_number":"NDE9008127","insp_date":"2025-10-08 00:00:00","insp_start_time":"0919","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"LEBEC","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENCORE","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":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16015868","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-10-16T10:00:44.000000Z","updated_at":"2025-10-17T10:01:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16480363,"change_date":"2025-10-13 21:37:00","inspection_id":"86035544","insp_unit_id":"209444771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:46:02.000000Z","updated_at":"2025-10-17T09:46:22.000000Z"}]},{"id":8717001,"change_date":"2025-05-22 21:43:00","inspection_id":"84758778","dot_number":"3597595","report_state":"CA","report_number":"NC7C005029","insp_date":"2025-05-21 00:00:00","insp_start_time":"0731","insp_end_time":"0810","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"`","shipping_paper_number":"`","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15831173","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2025-05-22 21:43:00","snet_input_date":"2025-05-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-22 21:43:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-05-25T10:06:12.000000Z","updated_at":"2025-05-26T10:07:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14248658,"change_date":"2025-05-22 21:43:00","inspection_id":"84758778","insp_unit_id":"207026514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2XBOX","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"Y","insp_unit_decal_number":"35074814","created_at":"2025-05-25T09:51:07.000000Z","updated_at":"2025-05-26T09:52:29.000000Z"}]},{"id":8682279,"change_date":"2025-05-19 21:41:00","inspection_id":"84722093","dot_number":"3597595","report_state":"CA","report_number":"UBZ9001459","insp_date":"2025-05-16 00:00:00","insp_start_time":"1240","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"US101 N\/B, S\/O MILLER CK RD.","county_code_state":"CA","county_code":"041","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":"N","pen_cen_match":null,"final_status_date":"2025-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15824940","transaction_code":"A","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2025-05-19 21:41:00","snet_input_date":"2025-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-19 21:41:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-05-22T10:01:49.000000Z","updated_at":"2025-05-23T10:06:36.000000Z","inspection_violations":[{"id":13828008,"change_date":"2025-05-19 21:41:00","inspection_id":"84722093","insp_violation_id":"266334796","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":null,"created_at":"2025-05-22T10:25:15.000000Z","updated_at":"2025-05-23T10:31:41.000000Z","normalized_code":"3922SLLTCD"},{"id":13828009,"change_date":"2025-05-19 21:41:00","inspection_id":"84722093","insp_violation_id":"266334797","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206953447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW079322","created_at":"2025-05-22T10:25:15.000000Z","updated_at":"2025-05-23T10:31:41.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":14183798,"change_date":"2025-05-19 21:41:00","inspection_id":"84722093","insp_unit_id":"206953447","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"203","insp_unit_license":"97501X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W161M7300333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:27.000000Z","updated_at":"2025-05-23T09:52:00.000000Z"}]},{"id":8216498,"change_date":"2025-03-26 21:41:00","inspection_id":"84231596","dot_number":"3597595","report_state":"CA","report_number":"NC7C004853","insp_date":"2025-03-25 00:00:00","insp_start_time":"0758","insp_end_time":"0807","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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":"2025-03-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15755161","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2025-03-26 21:41:00","snet_input_date":"2025-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-26 21:41:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-29T10:22:02.000000Z","updated_at":"2025-03-30T10:37:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13289732,"change_date":"2025-03-26 21:41:00","inspection_id":"84231596","insp_unit_id":"206005287","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:15:26.000000Z","updated_at":"2025-03-30T10:13:43.000000Z"}]},{"id":8160669,"change_date":"2025-03-19 21:41:00","inspection_id":"84172743","dot_number":"3597595","report_state":"CA","report_number":"NECL002959","insp_date":"2025-03-18 00:00:00","insp_start_time":"0710","insp_end_time":"0729","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"15744130","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-03-22T10:38:21.000000Z","updated_at":"2025-03-23T10:54:48.000000Z","inspection_violations":[{"id":12776975,"change_date":"2025-03-19 21:41:00","inspection_id":"84172743","insp_violation_id":"265139048","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"205889141","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:55:45.000000Z","updated_at":"2025-03-22T11:14:33.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":13183842,"change_date":"2025-03-19 21:41:00","inspection_id":"84172743","insp_unit_id":"205889141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:11:00.000000Z","updated_at":"2025-03-23T10:09:33.000000Z"}]},{"id":6278355,"change_date":"2024-07-22 21:42:00","inspection_id":"82181712","dot_number":"3597595","report_state":"CA","report_number":"NDUF005533","insp_date":"2024-07-21 00:00:00","insp_start_time":"0839","insp_end_time":"0852","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENCORE PIANO","shipping_paper_number":"B211297M","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"15450968","transaction_code":"A","transaction_date":"2024-07-21 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2024-07-22 21:42:00","snet_input_date":"2024-07-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-22 21:42:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:04.000000Z","updated_at":"2025-03-17T20:27:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10115951,"change_date":"2024-07-22 21:42:00","inspection_id":"82181712","insp_unit_id":"202006772","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:49.000000Z","updated_at":"2025-03-17T23:27:49.000000Z"}]},{"id":6190085,"change_date":"2024-07-10 21:41:00","inspection_id":"82086978","dot_number":"3597595","report_state":"CA","report_number":"ND8Y000007","insp_date":"2024-07-10 00:00:00","insp_start_time":"0002","insp_end_time":"0027","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"15435076","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2024-07-10 21:41:00","snet_input_date":"2024-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-10 21:41:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-03-17T20:25:23.000000Z","updated_at":"2025-03-17T20:25:23.000000Z","inspection_violations":[{"id":9613194,"change_date":"2024-07-10 21:41:00","inspection_id":"82086978","insp_violation_id":"260575143","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201825919","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"3939A"},{"id":9613195,"change_date":"2024-07-10 21:41:00","inspection_id":"82086978","insp_violation_id":"260575144","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201825919","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:30.000000Z","updated_at":"2025-03-17T21:52:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9972018,"change_date":"2024-07-10 21:41:00","inspection_id":"82086978","insp_unit_id":"201825919","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"210\/WHT","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"Y","insp_unit_decal_number":"34169527","created_at":"2025-03-17T23:26:19.000000Z","updated_at":"2025-03-17T23:26:19.000000Z"}]},{"id":5860104,"change_date":"2024-05-28 21:44:00","inspection_id":"81730351","dot_number":"3597595","report_state":"CA","report_number":"ND6D005793","insp_date":"2024-05-23 00:00:00","insp_start_time":"0720","insp_end_time":"0752","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":"ENCORE PIANO","shipping_paper_number":"1318960","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15380278","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2024-05-28 21:44:00","snet_input_date":"2024-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-28 21:44:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-03-17T20:19:01.000000Z","updated_at":"2025-03-17T20:19:01.000000Z","inspection_violations":[{"id":9085532,"change_date":"2024-05-28 21:44:00","inspection_id":"81730351","insp_violation_id":"259773456","seq_no":"1","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"201121555","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KW78369","created_at":"2025-03-17T21:49:55.000000Z","updated_at":"2025-03-17T21:49:55.000000Z","normalized_code":"393201A"}],"inspection_per_units":[{"id":9438385,"change_date":"2024-05-28 21:44:00","inspection_id":"81730351","insp_unit_id":"201121555","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"}]},{"id":3892122,"change_date":"2023-09-01 21:40:00","inspection_id":"79572889","dot_number":"3597595","report_state":"CA","report_number":"NBFL004817","insp_date":"2023-08-30 00:00:00","insp_start_time":"0911","insp_end_time":"0929","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":"ENC WH","shipping_paper_number":"1304413","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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"5500","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":"15047059","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2023-09-01 21:40:00","snet_input_date":"2023-08-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-01 21:40:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-03-17T19:39:44.000000Z","updated_at":"2025-03-17T19:39:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6257563,"change_date":"2023-09-01 21:40:00","inspection_id":"79572889","insp_unit_id":"196873516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"210","insp_unit_license":"33677B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT3GDGZ9846","insp_unit_decal":"Y","insp_unit_decal_number":"32876329","created_at":"2025-03-17T22:52:34.000000Z","updated_at":"2025-03-17T22:52:34.000000Z"}]},{"id":1978609,"change_date":"2022-12-19 21:41:00","inspection_id":"77407673","dot_number":"3597595","report_state":"CA","report_number":"UCD7000144","insp_date":"2022-12-17 00:00:00","insp_start_time":"0950","insp_end_time":"0956","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"14714200","transaction_code":"A","transaction_date":"2022-12-17 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2022-12-19 21:41:00","snet_input_date":"2022-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-19 21:41:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-03-17T19:02:59.000000Z","updated_at":"2025-03-17T19:02:59.000000Z","inspection_violations":[{"id":3072560,"change_date":"2022-12-19 21:41:00","inspection_id":"77407673","insp_violation_id":"250176583","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192497435","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"3939A"},{"id":3072561,"change_date":"2022-12-19 21:41:00","inspection_id":"77407673","insp_violation_id":"250176584","seq_no":"2","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"192497435","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":3183650,"change_date":"2022-12-19 21:41:00","inspection_id":"77407673","insp_unit_id":"192497435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"207","insp_unit_license":"91972Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W163M7900092","insp_unit_decal":"Y","insp_unit_decal_number":"31826883","created_at":"2025-03-17T22:28:48.000000Z","updated_at":"2025-03-17T22:28:48.000000Z"}]},{"id":1427223,"change_date":"2022-10-03 21:41:00","inspection_id":"76774296","dot_number":"3597595","report_state":"CA","report_number":"NAYO005000","insp_date":"2022-09-27 00:00:00","insp_start_time":"1108","insp_end_time":"1151","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":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-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14618263","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2022-10-03 21:41:00","snet_input_date":"2022-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-03 21:41:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"584644","created_at":"2025-03-17T18:53:03.000000Z","updated_at":"2025-03-17T18:53:03.000000Z","inspection_violations":[{"id":2248961,"change_date":"2022-10-03 21:41:00","inspection_id":"76774296","insp_violation_id":"248797973","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191238882","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:17:19.000000Z","updated_at":"2025-03-17T21:17:19.000000Z","normalized_code":"3939A"},{"id":2248962,"change_date":"2022-10-03 21:41:00","inspection_id":"76774296","insp_violation_id":"248797974","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191238882","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:19.000000Z","updated_at":"2025-03-17T21:17:19.000000Z","normalized_code":"3922"},{"id":2248963,"change_date":"2022-10-03 21:41:00","inspection_id":"76774296","insp_violation_id":"248797975","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"191238882","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:19.000000Z","updated_at":"2025-03-17T21:17:19.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":2298325,"change_date":"2022-10-03 21:41:00","inspection_id":"76774296","insp_unit_id":"191238882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"208\/WHT","insp_unit_license":"30495A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W161M7300333","insp_unit_decal":"Y","insp_unit_decal_number":"31543491","created_at":"2025-03-17T22:22:43.000000Z","updated_at":"2025-03-17T22:22:43.000000Z"}]},{"id":477049,"change_date":"2022-05-24 21:44:00","inspection_id":"75661985","dot_number":"3597595","report_state":"CA","report_number":"NCNY004154","insp_date":"2022-05-20 00:00:00","insp_start_time":"1458","insp_end_time":"1536","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-24 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14442382","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03597595","upload_search_indicator":null,"census_search_date":"2022-05-24 21:44:00","snet_input_date":"2022-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-24 21:44:00","insp_carrier_name":"ENCORE PIANO MOVING OF NORTHERN CALIFORNIA LLC","insp_carrier_street":"4790 FRONTIER WAY STE 600","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:00.000000Z","updated_at":"2025-03-17T18:36:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":767508,"change_date":"2022-05-24 21:44:00","inspection_id":"75661985","insp_unit_id":"188896627","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5821\/WHT","insp_unit_license":"54631F3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMML1NL451577","insp_unit_decal":"Y","insp_unit_decal_number":"31129461","created_at":"2025-03-17T22:12:55.000000Z","updated_at":"2025-03-17T22:12:55.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3597595\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3597595\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3597595\/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\/3597595\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}