{"current_page":1,"data":[{"id":11292214,"change_date":"2026-03-04 21:41:00","inspection_id":"87207501","dot_number":"3461557","report_state":"CA","report_number":"UEED003553","insp_date":"2026-03-03 00:00:00","insp_start_time":"0740","insp_end_time":"0844","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"WB JWO EDEN CANYON","county_code_state":"CA","county_code":"001","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-04 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":"16194004","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2026-03-04 21:41:00","snet_input_date":"2026-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-04 21:41:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APT 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2026-03-07T10:39:17.000000Z","updated_at":"2026-03-15T09:31:30.000000Z","inspection_violations":[{"id":18989594,"change_date":"2026-03-04 21:41:00","inspection_id":"87207501","insp_violation_id":"272206444","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211975565","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:58:04.000000Z","updated_at":"2026-03-15T09:42:56.000000Z","normalized_code":"3922SLLSR"},{"id":18989595,"change_date":"2026-03-04 21:41:00","inspection_id":"87207501","insp_violation_id":"272206445","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"211975565","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ST52503","created_at":"2026-03-07T10:58:04.000000Z","updated_at":"2026-03-15T09:42:56.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":19313855,"change_date":"2026-03-04 21:41:00","inspection_id":"87207501","insp_unit_id":"211975565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:51.000000Z","updated_at":"2026-03-15T09:06:45.000000Z"}]},{"id":9659214,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","dot_number":"3461557","report_state":"CA","report_number":"NEVK001937","insp_date":"2025-09-10 00:00:00","insp_start_time":"1713","insp_end_time":"1753","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":"2025-09-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"6","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15977163","transaction_code":"C","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2025-09-11 21:42:00","snet_input_date":"2025-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APTO 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-09-13T10:48:07.000000Z","updated_at":"2025-09-16T10:48:31.000000Z","inspection_violations":[{"id":15851738,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_violation_id":"268666980","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208926322","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:40.000000Z","normalized_code":"3922SLLSR"},{"id":15851739,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_violation_id":"268666981","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"208926322","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:40.000000Z","normalized_code":"39345B2BHTD"},{"id":15851740,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_violation_id":"268666982","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"208926322","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:40.000000Z","normalized_code":"39345B2BHTD"},{"id":15851741,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_violation_id":"268666983","seq_no":"4","part_no":"390","part_no_section":"3E3-MC","insp_viol_unit":"1","insp_unit_id":"208926322","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:40.000000Z","normalized_code":"3903E3MC"},{"id":15851742,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_violation_id":"268666984","seq_no":"5","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"208926322","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA673913","created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:40.000000Z","normalized_code":"3939ALTSI"},{"id":15851743,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_violation_id":"268666985","seq_no":"6","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"208926322","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:13.000000Z","updated_at":"2025-09-16T10:51:40.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":15999831,"change_date":"2025-09-12 21:50:00","inspection_id":"85751607","insp_unit_id":"208926322","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/BOX","insp_unit_license":"34311D4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:02.000000Z","updated_at":"2025-09-16T09:56:26.000000Z"}]},{"id":9657528,"change_date":"2025-09-12 21:50:00","inspection_id":"85740500","dot_number":"3461557","report_state":"CA","report_number":"UGHP999746","insp_date":"2025-09-05 00:00:00","insp_start_time":"0905","insp_end_time":"0935","registration_date":null,"region":"PT","ci_status_code":"C","location":"9330","location_desc":"E\/OF SR-35","county_code_state":"CA","county_code":"081","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-09-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15973780","transaction_code":"C","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2025-09-10 21:41:00","snet_input_date":"2025-09-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-10 21:41:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APTO 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-13T10:48:05.000000Z","updated_at":"2025-09-16T10:48:25.000000Z","inspection_violations":[{"id":15850831,"change_date":"2025-09-12 21:50:00","inspection_id":"85740500","insp_violation_id":"268665083","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:10.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"38323A2LCDLN"},{"id":15850832,"change_date":"2025-09-12 21:50:00","inspection_id":"85740500","insp_violation_id":"268665084","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"1","insp_unit_id":"208923994","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SB87346","created_at":"2025-09-14T11:58:10.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"3922SLLDL"},{"id":15850833,"change_date":"2025-09-12 21:50:00","inspection_id":"85740500","insp_violation_id":"268665085","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"208923994","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:10.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15850834,"change_date":"2025-09-12 21:50:00","inspection_id":"85740500","insp_violation_id":"268665086","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"208923994","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:58:10.000000Z","updated_at":"2025-09-16T10:51:36.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":15998041,"change_date":"2025-09-12 21:50:00","inspection_id":"85740500","insp_unit_id":"208923994","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:01.000000Z","updated_at":"2025-09-16T09:56:20.000000Z"}]},{"id":7705988,"change_date":"2025-01-24 21:40:00","inspection_id":"83694982","dot_number":"3461557","report_state":"CA","report_number":"UE03003744","insp_date":"2025-01-23 00:00:00","insp_start_time":"0804","insp_end_time":"0833","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","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-01-24 21:40: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":"15676954","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APTO 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:17.000000Z","updated_at":"2025-03-17T20:58:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12434926,"change_date":"2025-01-24 21:40:00","inspection_id":"83694982","insp_unit_id":"205000786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2AX","insp_unit_license":"85612L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"}]},{"id":7678859,"change_date":"2025-01-21 21:40:00","inspection_id":"83666579","dot_number":"3461557","report_state":"CA","report_number":"UE5U004016","insp_date":"2025-01-21 00:00:00","insp_start_time":"0803","insp_end_time":"0844","registration_date":null,"region":"PT","ci_status_code":"C","location":"888","location_desc":"S\/B I-5 SANTA NELLA SCALES","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15672779","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APTO 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:30.000000Z","updated_at":"2025-03-17T20:57:30.000000Z","inspection_violations":[{"id":11998940,"change_date":"2025-01-21 21:40:00","inspection_id":"83666579","insp_violation_id":"264114443","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204947380","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3922SLLEQP"},{"id":11998941,"change_date":"2025-01-21 21:40:00","inspection_id":"83666579","insp_violation_id":"264114444","seq_no":"2","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"204947380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":12390857,"change_date":"2025-01-21 21:40:00","inspection_id":"83666579","insp_unit_id":"204947380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:45.000000Z","updated_at":"2025-03-17T23:51:45.000000Z"}]},{"id":7687272,"change_date":"2025-01-22 21:40:00","inspection_id":"83675368","dot_number":"3461557","report_state":"CA","report_number":"UC2Q002857","insp_date":"2025-01-17 00:00:00","insp_start_time":"0719","insp_end_time":"0734","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"NORTH FRONT EB W\/GREENVILLE","county_code_state":"CA","county_code":"001","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-01-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15673829","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2025-01-22 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-22 21:40:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APTO 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:57:53.000000Z","updated_at":"2025-03-17T20:57:53.000000Z","inspection_violations":[{"id":12011567,"change_date":"2025-01-22 21:40:00","inspection_id":"83675368","insp_violation_id":"264131603","seq_no":"1","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"1","insp_unit_id":"204963958","insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RJ76772","created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"39111B5LNCDLNVL"}],"inspection_per_units":[{"id":12404464,"change_date":"2025-01-22 21:40:00","inspection_id":"83675368","insp_unit_id":"204963958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X BX WHT","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:52.000000Z","updated_at":"2025-03-17T23:51:52.000000Z"}]},{"id":6983171,"change_date":"2024-10-17 21:42:00","inspection_id":"82932919","dot_number":"3461557","report_state":"CA","report_number":"UCUF003852","insp_date":"2024-10-13 00:00:00","insp_start_time":"0745","insp_end_time":"0815","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15559481","transaction_code":"A","transaction_date":"2024-10-13 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-10-17 21:42:00","snet_input_date":"2024-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-17 21:42:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"24545 ONEIL AVE APTO 208","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:41:46.000000Z","updated_at":"2025-03-17T20:41:46.000000Z","inspection_violations":[{"id":10893467,"change_date":"2024-10-17 21:42:00","inspection_id":"82932919","insp_violation_id":"262412191","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203460947","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 514293","created_at":"2025-03-17T21:58:49.000000Z","updated_at":"2025-03-17T21:58:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11263231,"change_date":"2024-10-17 21:42:00","inspection_id":"82932919","insp_unit_id":"203460947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHI.2X.BXVN","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"Y","insp_unit_decal_number":"34470514","created_at":"2025-03-17T23:39:34.000000Z","updated_at":"2025-03-17T23:39:34.000000Z"}]},{"id":6856277,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","dot_number":"3461557","report_state":"CA","report_number":"NE7S003721","insp_date":"2024-09-27 00:00:00","insp_start_time":"1549","insp_end_time":"1618","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":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539527","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27934 MANON AVE APT 0 B","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[{"id":10678571,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_violation_id":"262111831","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203201950","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"39345B2"},{"id":10678572,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_violation_id":"262111832","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203201950","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"39345B2"},{"id":10678573,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_violation_id":"262111833","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203201950","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"39345B2"},{"id":10678574,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_violation_id":"262111834","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203201950","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"3922"},{"id":10678575,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_violation_id":"262111835","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203201950","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"3922"},{"id":10678576,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_violation_id":"262111836","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203201950","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11056713,"change_date":"2024-09-30 21:41:00","inspection_id":"82797936","insp_unit_id":"203201950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"85612L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6233928,"change_date":"2024-07-16 21:44:00","inspection_id":"82134078","dot_number":"3461557","report_state":"CA","report_number":"NE28004903","insp_date":"2024-07-10 00:00:00","insp_start_time":"1609","insp_end_time":"1641","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-16 21:44: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":"15441609","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-07-16 21:44:00","snet_input_date":"2024-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-16 21:44:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27934 MANON AVE APT 0 B","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:26:14.000000Z","updated_at":"2025-03-17T20:26:14.000000Z","inspection_violations":[{"id":9684455,"change_date":"2024-07-16 21:44:00","inspection_id":"82134078","insp_violation_id":"260678218","seq_no":"1","part_no":"393","part_no_section":"45(a)","insp_viol_unit":"1","insp_unit_id":"201916655","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"39345A"},{"id":9684456,"change_date":"2024-07-16 21:44:00","inspection_id":"82134078","insp_violation_id":"260678219","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201916655","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10044179,"change_date":"2024-07-16 21:44:00","inspection_id":"82134078","insp_unit_id":"201916655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT 2X","insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:03.000000Z","updated_at":"2025-03-17T23:27:03.000000Z"}]},{"id":6049646,"change_date":"2024-06-21 21:40:00","inspection_id":"81935947","dot_number":"3461557","report_state":"CA","report_number":"NF8R000039","insp_date":"2024-06-20 00:00:00","insp_start_time":"1450","insp_end_time":"1539","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15414861","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-06-21 21:40:00","snet_input_date":"2024-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-21 21:40:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27934 MANON AVE APT 0 B","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:22:37.000000Z","updated_at":"2025-03-17T20:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9743615,"change_date":"2024-06-21 21:40:00","inspection_id":"81935947","insp_unit_id":"201534429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3 \/ YLW","insp_unit_license":"85612L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"Y","insp_unit_decal_number":"33879616","created_at":"2025-03-17T23:23:56.000000Z","updated_at":"2025-03-17T23:23:56.000000Z"}]},{"id":5861107,"change_date":"2024-05-28 21:44:00","inspection_id":"81731385","dot_number":"3461557","report_state":"CA","report_number":"UCD5000045","insp_date":"2024-05-25 00:00:00","insp_start_time":"1410","insp_end_time":"1440","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":"2024-05-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15379030","transaction_code":"A","transaction_date":"2024-05-25 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-05-28 21:44:00","snet_input_date":"2024-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-28 21:44:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27934 MANON AVE APT 0 B","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:02.000000Z","updated_at":"2025-03-17T20:19:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9439932,"change_date":"2024-05-28 21:44:00","inspection_id":"81731385","insp_unit_id":"201123214","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/2AX","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"Y","insp_unit_decal_number":"33816121","created_at":"2025-03-17T23:20:55.000000Z","updated_at":"2025-03-17T23:20:55.000000Z"}]},{"id":5659029,"change_date":"2024-05-02 21:43:00","inspection_id":"81512308","dot_number":"3461557","report_state":"CA","report_number":"NCAT004128","insp_date":"2024-05-01 00:00:00","insp_start_time":"1606","insp_end_time":"1617","registration_date":null,"region":"PT","ci_status_code":"C","location":"285","location_desc":"YUBA-SUTTER AREA","county_code_state":"CA","county_code":"101","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COL AND SAL TRUCKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15344620","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27934 MANON AVE APT 0 B","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:14:45.000000Z","updated_at":"2025-03-17T20:14:45.000000Z","inspection_violations":[{"id":8754055,"change_date":"2024-05-02 21:43:00","inspection_id":"81512308","insp_violation_id":"259291683","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200705887","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9114903,"change_date":"2024-05-02 21:43:00","inspection_id":"81512308","insp_unit_id":"200705887","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE 2XL","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:48.000000Z","updated_at":"2025-03-17T23:17:48.000000Z"}]},{"id":5625669,"change_date":"2024-04-29 21:44:00","inspection_id":"81476150","dot_number":"3461557","report_state":"CA","report_number":"NCNG007691","insp_date":"2024-04-24 00:00:00","insp_start_time":"1437","insp_end_time":"1448","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15338038","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-04-29 21:44:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-29 21:44:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27934 MANON AVE APT 0 B","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94544","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:14:16.000000Z","updated_at":"2025-03-17T20:14:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9062016,"change_date":"2024-04-29 21:44:00","inspection_id":"81476150","insp_unit_id":"200636057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:19.000000Z","updated_at":"2025-03-17T23:17:19.000000Z"}]},{"id":5228881,"change_date":"2024-03-06 21:40:00","inspection_id":"81042782","dot_number":"3461557","report_state":"CA","report_number":"ND6S006781","insp_date":"2024-03-05 00:00:00","insp_start_time":"1226","insp_end_time":"1250","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-06 21:40: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":"15270542","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:06:13.000000Z","updated_at":"2025-03-17T20:06:13.000000Z","inspection_violations":[{"id":8062031,"change_date":"2024-03-06 21:40:00","inspection_id":"81042782","insp_violation_id":"258248872","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199793119","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":8420114,"change_date":"2024-03-06 21:40:00","inspection_id":"81042782","insp_unit_id":"199793119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"Y","insp_unit_decal_number":"33521527","created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"}]},{"id":5158358,"change_date":"2024-02-28 21:42:00","inspection_id":"80966279","dot_number":"3461557","report_state":"CA","report_number":"NADV006258","insp_date":"2024-02-23 00:00:00","insp_start_time":"1716","insp_end_time":"1736","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":"2024-02-28 21:42: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":"15261467","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:36.000000Z","updated_at":"2025-03-17T20:04:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8305691,"change_date":"2024-02-28 21:42:00","inspection_id":"80966279","insp_unit_id":"199650083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"YELLOW 2X V","insp_unit_license":"85612L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"Y","insp_unit_decal_number":"33573795","created_at":"2025-03-17T23:10:17.000000Z","updated_at":"2025-03-17T23:10:17.000000Z"}]},{"id":4905398,"change_date":"2024-01-25 21:44:00","inspection_id":"80689712","dot_number":"3461557","report_state":"CA","report_number":"NEKW001707","insp_date":"2024-01-24 00:00:00","insp_start_time":"1103","insp_end_time":"1122","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15213336","transaction_code":"A","transaction_date":"2024-01-24 00:00:00","upload_date":"2024-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-01-25 21:44:00","snet_input_date":"2024-01-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"27495 MANON AVE APT 7","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T20:00:01.000000Z","updated_at":"2025-03-17T20:00:01.000000Z","inspection_violations":[{"id":7558081,"change_date":"2024-01-25 21:44:00","inspection_id":"80689712","insp_violation_id":"257504527","seq_no":"1","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":7893516,"change_date":"2024-01-25 21:44:00","inspection_id":"80689712","insp_unit_id":"199117216","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT 2X","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:32.000000Z","updated_at":"2025-03-17T23:06:32.000000Z"}]},{"id":5163200,"change_date":"2024-02-28 21:43:00","inspection_id":"80971303","dot_number":"3461557","report_state":"CA","report_number":"NDMK004969","insp_date":"2024-01-18 00:00:00","insp_start_time":"0806","insp_end_time":"0818","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:43: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":"15253528","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:56.000000Z","updated_at":"2025-03-17T20:04:56.000000Z","inspection_violations":[{"id":7960306,"change_date":"2024-02-28 21:43:00","inspection_id":"80971303","insp_violation_id":"258100474","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199657921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:29.000000Z","updated_at":"2025-03-17T21:44:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8313032,"change_date":"2024-02-28 21:43:00","inspection_id":"80971303","insp_unit_id":"199657921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"85612L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:20.000000Z","updated_at":"2025-03-17T23:10:20.000000Z"}]},{"id":4623671,"change_date":"2023-12-13 21:42:00","inspection_id":"80381928","dot_number":"3461557","report_state":"CA","report_number":"N8MC007773","insp_date":"2023-12-07 00:00:00","insp_start_time":"1041","insp_end_time":"1102","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-13 21:42: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":"15165254","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-12-13 21:42:00","snet_input_date":"2023-12-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-13 21:42:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:31.000000Z","updated_at":"2025-03-17T19:54:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7436857,"change_date":"2023-12-13 21:42:00","inspection_id":"80381928","insp_unit_id":"198493027","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"YELLOW","insp_unit_license":"85612L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML3FL040596","insp_unit_decal":"Y","insp_unit_decal_number":"33271172","created_at":"2025-03-17T23:02:31.000000Z","updated_at":"2025-03-17T23:02:31.000000Z"}]},{"id":3850925,"change_date":"2023-08-28 21:43:00","inspection_id":"79526963","dot_number":"3461557","report_state":"CA","report_number":"NE28003729","insp_date":"2023-08-23 00:00:00","insp_start_time":"1740","insp_end_time":"1807","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15038916","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-08-28 21:43:00","snet_input_date":"2023-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[{"id":5949195,"change_date":"2023-08-28 21:43:00","inspection_id":"79526963","insp_violation_id":"254936283","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6191737,"change_date":"2023-08-28 21:43:00","inspection_id":"79526963","insp_unit_id":"196772480","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT 2X","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"Y","insp_unit_decal_number":"32849152","created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"}]},{"id":3781777,"change_date":"2023-08-18 21:42:00","inspection_id":"79449515","dot_number":"3461557","report_state":"CA","report_number":"NBH6004840","insp_date":"2023-08-17 00:00:00","insp_start_time":"0824","insp_end_time":"0841","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"15027561","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6080712,"change_date":"2023-08-18 21:42:00","inspection_id":"79449515","insp_unit_id":"196619268","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"Y","insp_unit_decal_number":"32846906","created_at":"2025-03-17T22:51:06.000000Z","updated_at":"2025-03-17T22:51:06.000000Z"}]},{"id":3773345,"change_date":"2023-08-17 21:44:00","inspection_id":"79440031","dot_number":"3461557","report_state":"CA","report_number":"NDMK004732","insp_date":"2023-08-16 00:00:00","insp_start_time":"0717","insp_end_time":"0728","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15025418","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6066733,"change_date":"2023-08-17 21:44:00","inspection_id":"79440031","insp_unit_id":"196599958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3658025,"change_date":"2023-08-02 21:42:00","inspection_id":"79311234","dot_number":"3461557","report_state":"CA","report_number":"UDAJ001881","insp_date":"2023-08-02 00:00:00","insp_start_time":"1025","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"130","location_desc":"COTTONWOOD I.F. TO I-5 N\/B","county_code_state":"CA","county_code":"103","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":"2023-08-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15006059","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-08-02 21:42:00","snet_input_date":"2023-08-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-02 21:42:00","insp_carrier_name":"COL AND SAL TRUCKING INC","insp_carrier_street":"1303 A ST","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:59.000000Z","updated_at":"2025-03-17T19:34:59.000000Z","inspection_violations":[{"id":5639765,"change_date":"2023-08-02 21:42:00","inspection_id":"79311234","insp_violation_id":"254435218","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196336433","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CE035527","created_at":"2025-03-17T21:33:07.000000Z","updated_at":"2025-03-17T21:33:07.000000Z","normalized_code":"39021TB"},{"id":5639766,"change_date":"2023-08-02 21:42:00","inspection_id":"79311234","insp_violation_id":"254435219","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196336433","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CE035527","created_at":"2025-03-17T21:33:07.000000Z","updated_at":"2025-03-17T21:33:07.000000Z","normalized_code":"39021TA"},{"id":5639767,"change_date":"2023-08-02 21:42:00","inspection_id":"79311234","insp_violation_id":"254435220","seq_no":"3","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:07.000000Z","updated_at":"2025-03-17T21:33:07.000000Z","normalized_code":"3958K2"},{"id":5639768,"change_date":"2023-08-02 21:42:00","inspection_id":"79311234","insp_violation_id":"254435221","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196336433","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:07.000000Z","updated_at":"2025-03-17T21:33:07.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5881828,"change_date":"2023-08-02 21:42:00","inspection_id":"79311234","insp_unit_id":"196336433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57098X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JT5E4S55205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"}]},{"id":3657150,"change_date":"2023-08-02 21:42:00","inspection_id":"79310300","dot_number":"3461557","report_state":"CA","report_number":"NCZ3005454","insp_date":"2023-08-01 00:00:00","insp_start_time":"0755","insp_end_time":"0810","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15004388","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-08-02 21:42:00","snet_input_date":"2023-08-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-02 21:42:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T19:34:58.000000Z","updated_at":"2025-03-17T19:34:58.000000Z","inspection_violations":[{"id":5639179,"change_date":"2023-08-02 21:42:00","inspection_id":"79310300","insp_violation_id":"254434558","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196335093","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:07.000000Z","updated_at":"2025-03-17T21:33:07.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":5880624,"change_date":"2023-08-02 21:42:00","inspection_id":"79310300","insp_unit_id":"196335093","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57098X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JT5E4S55205","insp_unit_decal":"Y","insp_unit_decal_number":"32847890","created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"}]},{"id":3252497,"change_date":"2023-06-09 21:41:00","inspection_id":"78855468","dot_number":"3461557","report_state":"CA","report_number":"NBH6004577","insp_date":"2023-06-07 00:00:00","insp_start_time":"0756","insp_end_time":"0825","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-09 21:41: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":"14935710","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-06-09 21:41:00","snet_input_date":"2023-06-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-09 21:41:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:21.000000Z","updated_at":"2025-03-17T19:27:21.000000Z","inspection_violations":[{"id":5015955,"change_date":"2023-06-09 21:41:00","inspection_id":"78855468","insp_violation_id":"253419215","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195424783","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5231074,"change_date":"2023-06-09 21:41:00","inspection_id":"78855468","insp_unit_id":"195424783","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:14.000000Z","updated_at":"2025-03-17T22:44:14.000000Z"}]},{"id":3006204,"change_date":"2023-05-09 21:43:00","inspection_id":"78577667","dot_number":"3461557","report_state":"CA","report_number":"NBIJ004041","insp_date":"2023-05-03 00:00:00","insp_start_time":"0743","insp_end_time":"0816","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 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":"14892599","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-05-09 21:43:00","snet_input_date":"2023-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T19:22:36.000000Z","updated_at":"2025-03-17T19:22:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4837130,"change_date":"2023-05-09 21:43:00","inspection_id":"78577667","insp_unit_id":"194843089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57098X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JT5E4S55205","insp_unit_decal":"Y","insp_unit_decal_number":"32463750","created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"}]},{"id":3008049,"change_date":"2023-05-09 21:43:00","inspection_id":"78579660","dot_number":"3461557","report_state":"CA","report_number":"UDK7002280","insp_date":"2023-05-03 00:00:00","insp_start_time":"1950","insp_end_time":"2005","registration_date":null,"region":"PT","ci_status_code":"C","location":"360","location_desc":"SANTA ROSA","county_code_state":"CA","county_code":"097","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14892784","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-05-09 21:43:00","snet_input_date":"2023-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4839927,"change_date":"2023-05-09 21:43:00","inspection_id":"78579660","insp_unit_id":"194846215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X BOX","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"}]},{"id":2866557,"change_date":"2023-04-21 21:41:00","inspection_id":"78419533","dot_number":"3461557","report_state":"CA","report_number":"UBZ9000943","insp_date":"2023-04-20 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"350","location_desc":"MILLER CREEK RD N\/O LUCAS VLY","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":"2023-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"14868045","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-04-21 21:41:00","snet_input_date":"2023-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-21 21:41:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:40.000000Z","updated_at":"2025-03-17T19:19:40.000000Z","inspection_violations":[{"id":4400284,"change_date":"2023-04-21 21:41:00","inspection_id":"78419533","insp_violation_id":"252380217","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:35.000000Z","updated_at":"2025-03-17T21:27:35.000000Z","normalized_code":"3922"},{"id":4400285,"change_date":"2023-04-21 21:41:00","inspection_id":"78419533","insp_violation_id":"252380218","seq_no":"2","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"194529192","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:35.000000Z","updated_at":"2025-03-17T21:27:35.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":4612246,"change_date":"2023-04-21 21:41:00","inspection_id":"78419533","insp_unit_id":"194529192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"57098X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNJ8JT5E4S55205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:23.000000Z","updated_at":"2025-03-17T22:39:23.000000Z"}]},{"id":2690927,"change_date":"2023-03-29 21:42:00","inspection_id":"78220412","dot_number":"3461557","report_state":"CA","report_number":"UE74001510","insp_date":"2023-03-15 00:00:00","insp_start_time":"1815","insp_end_time":"1843","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-29 21:42: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":"14838429","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-03-29 21:42:00","snet_input_date":"2023-03-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4332192,"change_date":"2023-03-29 21:42:00","inspection_id":"78220412","insp_unit_id":"194132743","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"82404D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNC6JM6A4S50581","insp_unit_decal":"Y","insp_unit_decal_number":"32139024","created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2471945,"change_date":"2023-02-28 21:41:00","inspection_id":"77970774","dot_number":"3461557","report_state":"CA","report_number":"NCZ3004752","insp_date":"2023-02-23 00:00:00","insp_start_time":"0640","insp_end_time":"0654","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14800400","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-02-28 21:41:00","snet_input_date":"2023-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-28 21:41:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"32138546","created_at":"2025-03-17T19:12:09.000000Z","updated_at":"2025-03-17T19:12:09.000000Z","inspection_violations":[{"id":3805352,"change_date":"2023-02-28 21:41:00","inspection_id":"77970774","insp_violation_id":"251395905","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193631048","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":3978551,"change_date":"2023-02-28 21:41:00","inspection_id":"77970774","insp_unit_id":"193631048","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"Y","insp_unit_decal_number":"32138547","created_at":"2025-03-17T22:34:29.000000Z","updated_at":"2025-03-17T22:34:29.000000Z"}]},{"id":2308317,"change_date":"2023-02-06 21:42:00","inspection_id":"77784216","dot_number":"3461557","report_state":"CA","report_number":"NBH6004098","insp_date":"2023-02-02 00:00:00","insp_start_time":"0756","insp_end_time":"0816","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:42: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":"14769229","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-02-06 21:42:00","snet_input_date":"2023-02-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-06 21:42:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:14.000000Z","updated_at":"2025-03-17T19:09:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3715767,"change_date":"2023-02-06 21:42:00","inspection_id":"77784216","insp_unit_id":"193257517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"Y","insp_unit_decal_number":"32135865","created_at":"2025-03-17T22:32:37.000000Z","updated_at":"2025-03-17T22:32:37.000000Z"}]},{"id":2173930,"change_date":"2023-01-18 21:40:00","inspection_id":"77631223","dot_number":"3461557","report_state":"CA","report_number":"UCTU001443","insp_date":"2023-01-14 00:00:00","insp_start_time":"1315","insp_end_time":"1326","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"14746118","transaction_code":"A","transaction_date":"2023-01-14 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-01-18 21:40:00","snet_input_date":"2023-01-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:38.000000Z","updated_at":"2025-03-17T19:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3499096,"change_date":"2023-01-18 21:40:00","inspection_id":"77631223","insp_unit_id":"192940311","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"WHT2X","insp_unit_license":"82404D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNC6JM6A4S50581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:05.000000Z","updated_at":"2025-03-17T22:31:05.000000Z"}]},{"id":2172335,"change_date":"2023-01-18 21:40:00","inspection_id":"77629507","dot_number":"3461557","report_state":"CA","report_number":"NBH6004010","insp_date":"2023-01-10 00:00:00","insp_start_time":"0807","insp_end_time":"0826","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"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":"2023-01-18 21:40: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":"14744172","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2023-01-18 21:40:00","snet_input_date":"2023-01-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:38.000000Z","updated_at":"2025-03-17T19:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3496571,"change_date":"2023-01-18 21:40:00","inspection_id":"77629507","insp_unit_id":"192937499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:05.000000Z","updated_at":"2025-03-17T22:31:05.000000Z"}]},{"id":1811747,"change_date":"2022-11-23 21:40:00","inspection_id":"77216811","dot_number":"3461557","report_state":"CA","report_number":"UE7D000639","insp_date":"2022-11-23 00:00:00","insp_start_time":"0830","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"ANTELOPE E\/B","county_code_state":"CA","county_code":"067","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-11-23 21:40: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":"14684236","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:00.000000Z","updated_at":"2025-03-17T19:00:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2914284,"change_date":"2022-11-23 21:40:00","inspection_id":"77216811","insp_unit_id":"192121471","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"80679M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMMM3FL182455","insp_unit_decal":"Y","insp_unit_decal_number":"31814888","created_at":"2025-03-17T22:26:56.000000Z","updated_at":"2025-03-17T22:26:56.000000Z"}]},{"id":1140618,"change_date":"2022-08-25 21:43:00","inspection_id":"76441631","dot_number":"3461557","report_state":"CA","report_number":"UDBL001262","insp_date":"2022-08-23 00:00:00","insp_start_time":"1230","insp_end_time":"1302","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF (E\/B I-580)","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-08-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14565674","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2022-08-25 21:43:00","snet_input_date":"2022-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-25 21:43:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"569124","created_at":"2025-03-17T18:47:52.000000Z","updated_at":"2025-03-17T18:47:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1834329,"change_date":"2022-08-25 21:43:00","inspection_id":"76441631","insp_unit_id":"190555274","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XWHT","insp_unit_license":"36570K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W162F7001950","insp_unit_decal":"Y","insp_unit_decal_number":"31476409","created_at":"2025-03-17T22:19:37.000000Z","updated_at":"2025-03-17T22:19:37.000000Z"}]},{"id":1001466,"change_date":"2022-08-09 21:41:00","inspection_id":"76279116","dot_number":"3461557","report_state":"CA","report_number":"NAYO004576","insp_date":"2022-07-14 00:00:00","insp_start_time":"1115","insp_end_time":"1127","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-08-09 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":"14540484","transaction_code":"A","transaction_date":"2022-07-14 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03461557","upload_search_indicator":null,"census_search_date":"2022-08-09 21:41:00","snet_input_date":"2022-07-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"COL&SAL TRUCKING INC","insp_carrier_street":"1725 B ST APTO 21","insp_carrier_city":"HAYWARD","insp_carrier_state":"CA","insp_carrier_zip_code":"94541","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:24.000000Z","updated_at":"2025-03-17T18:45:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1611349,"change_date":"2022-08-09 21:41:00","inspection_id":"76279116","insp_unit_id":"190224007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"WHT","insp_unit_license":"82404D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5PVNC6JM6A4S50581","insp_unit_decal":"Y","insp_unit_decal_number":"31539122","created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3461557\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3461557\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3461557\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3461557\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}