{"current_page":1,"data":[{"id":12751134,"change_date":"2026-08-18 21:41:00","inspection_id":"88722696","dot_number":"2721186","report_state":"CA","report_number":"NDKW009672","insp_date":"2026-08-12 00:00:00","insp_start_time":"1805","insp_end_time":"1825","registration_date":null,"region":"PD","ci_status_code":"C","location":"366","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-08-18 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":"4008602","transaction_code":"A","transaction_date":"2026-08-18 00:00:00","upload_date":"2026-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-08-18 21:41:00","snet_input_date":"2026-08-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-18 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-08-22T09:39:20.000000Z","updated_at":"2026-08-29T09:30:30.000000Z","inspection_violations":[{"id":22196833,"change_date":"2026-08-18 21:41:00","inspection_id":"88722696","insp_violation_id":"276176547","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"215197626","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC12457","created_at":"2026-08-22T09:56:42.000000Z","updated_at":"2026-08-29T09:40:36.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":22134043,"change_date":"2026-08-18 21:41:00","inspection_id":"88722696","insp_unit_id":"215197626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23  WHT","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-21T09:15:29.000000Z","updated_at":"2026-08-29T09:01:37.000000Z"}]},{"id":12178514,"change_date":"2026-06-13 21:34:00","inspection_id":"88133636","dot_number":"2721186","report_state":"CA","report_number":"NEID004005","insp_date":"2026-06-08 00:00:00","insp_start_time":"1715","insp_end_time":"1735","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:34: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":"3533628","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-06-13 21:34:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:34:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-06-16T09:43:45.000000Z","updated_at":"2026-06-24T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21153751,"change_date":"2026-06-13 21:34:00","inspection_id":"88133636","insp_unit_id":"214084195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"36186948","created_at":"2026-06-16T09:20:56.000000Z","updated_at":"2026-06-24T09:00:52.000000Z"}]},{"id":12126577,"change_date":"2026-06-09 10:49:00","inspection_id":"88072398","dot_number":"2721186","report_state":"CA","report_number":"NFO0000183","insp_date":"2026-06-03 00:00:00","insp_start_time":"1302","insp_end_time":"1334","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-06-09 10:49:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3493000","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-06-09 10:49:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 10:49:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-06-12T09:39:47.000000Z","updated_at":"2026-06-20T09:31:12.000000Z","inspection_violations":[{"id":21104696,"change_date":"2026-06-09 10:49:00","inspection_id":"88072398","insp_violation_id":"274761842","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"213968883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:58:10.000000Z","updated_at":"2026-06-19T09:44:15.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":21068711,"change_date":"2026-06-09 10:49:00","inspection_id":"88072398","insp_unit_id":"213968883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:09.000000Z","updated_at":"2026-06-20T09:02:30.000000Z"}]},{"id":12036017,"change_date":"2026-05-28 21:41:00","inspection_id":"87976349","dot_number":"2721186","report_state":"CA","report_number":"NBH6007957","insp_date":"2026-05-26 00:00:00","insp_start_time":"1121","insp_end_time":"1201","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-28 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":"3415579","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-06-01T09:39:50.000000Z","updated_at":"2026-06-08T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20920113,"change_date":"2026-05-28 21:41:00","inspection_id":"87976349","insp_unit_id":"213789210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:01.000000Z","updated_at":"2026-06-08T09:02:07.000000Z"}]},{"id":11937865,"change_date":"2026-05-16 21:37:00","inspection_id":"87872809","dot_number":"2721186","report_state":"CA","report_number":"ND4P009627","insp_date":"2026-05-12 00:00:00","insp_start_time":"1715","insp_end_time":"1738","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-16 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3339200","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-05-16 21:37:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-16 21:37:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-05-19T09:41:10.000000Z","updated_at":"2026-05-27T09:30:22.000000Z","inspection_violations":[{"id":20764256,"change_date":"2026-05-16 21:37:00","inspection_id":"87872809","insp_violation_id":"274309814","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213596657","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-19T10:01:39.000000Z","updated_at":"2026-05-27T09:40:21.000000Z","normalized_code":"3922SLLSR"},{"id":20764257,"change_date":"2026-05-16 21:37:00","inspection_id":"87872809","insp_violation_id":"274309815","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213596657","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-19T10:01:39.000000Z","updated_at":"2026-05-27T09:40:21.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":20759308,"change_date":"2026-05-16 21:37:00","inspection_id":"87872809","insp_unit_id":"213596657","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23\/WHT","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-19T09:20:02.000000Z","updated_at":"2026-05-27T09:02:39.000000Z"}]},{"id":11669271,"change_date":"2026-04-16 21:41:00","inspection_id":"87599683","dot_number":"2721186","report_state":"CA","report_number":"NE28006641","insp_date":"2026-04-13 00:00:00","insp_start_time":"1818","insp_end_time":"1836","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":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"16248012","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-04-27T09:32:07.000000Z","updated_at":"2026-04-27T09:32:07.000000Z","inspection_violations":[{"id":20267931,"change_date":"2026-04-16 21:41:00","inspection_id":"87599683","insp_violation_id":"273656307","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"213060680","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:44.000000Z","updated_at":"2026-04-27T09:45:44.000000Z","normalized_code":"39311A1LHLM"},{"id":20267932,"change_date":"2026-04-16 21:41:00","inspection_id":"87599683","insp_violation_id":"273656308","seq_no":"2","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"213060680","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:44.000000Z","updated_at":"2026-04-27T09:45:44.000000Z","normalized_code":"39311A1LCL"}],"inspection_per_units":[{"id":20298653,"change_date":"2026-04-16 21:41:00","inspection_id":"87599683","insp_unit_id":"213060680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:36.000000Z","updated_at":"2026-04-27T09:05:36.000000Z"}]},{"id":11301454,"change_date":"2026-03-05 21:40:00","inspection_id":"87217203","dot_number":"2721186","report_state":"CA","report_number":"NATH005635","insp_date":"2026-03-03 00:00:00","insp_start_time":"1241","insp_end_time":"1310","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":"2026-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16194600","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-03-05 21:40:00","snet_input_date":"2026-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-05 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-03-08T09:44:16.000000Z","updated_at":"2026-03-16T09:31:09.000000Z","inspection_violations":[{"id":19010950,"change_date":"2026-03-05 21:40:00","inspection_id":"87217203","insp_violation_id":"272230382","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211994684","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-08T10:08:52.000000Z","updated_at":"2026-03-16T09:41:53.000000Z","normalized_code":"3939ALHLI"},{"id":19010951,"change_date":"2026-03-05 21:40:00","inspection_id":"87217203","insp_violation_id":"272230383","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"211994684","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-08T10:08:52.000000Z","updated_at":"2026-03-16T09:41:53.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":19331737,"change_date":"2026-03-05 21:40:00","inspection_id":"87217203","insp_unit_id":"211994684","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:20.000000Z","updated_at":"2026-03-16T09:04:23.000000Z"}]},{"id":11208975,"change_date":"2026-02-23 21:39:00","inspection_id":"87120168","dot_number":"2721186","report_state":"CA","report_number":"UD3C001510","insp_date":"2026-02-16 00:00:00","insp_start_time":"1625","insp_end_time":"1650","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25955","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":"16178085","transaction_code":"A","transaction_date":"2026-02-16 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-02-23 21:39:00","snet_input_date":"2026-02-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-23 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-02-26T10:37:03.000000Z","updated_at":"2026-03-06T10:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19140757,"change_date":"2026-02-23 21:39:00","inspection_id":"87120168","insp_unit_id":"211776061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-26T10:12:18.000000Z","updated_at":"2026-03-06T10:04:00.000000Z"}]},{"id":11098492,"change_date":"2026-02-10 21:39:00","inspection_id":"87010440","dot_number":"2721186","report_state":"CA","report_number":"NDZ5006386","insp_date":"2026-02-03 00:00:00","insp_start_time":"1749","insp_end_time":"1820","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":"2026-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25990","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":"16164464","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2026-02-10 21:39:00","snet_input_date":"2026-02-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-10 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2026-02-13T10:37:57.000000Z","updated_at":"2026-02-21T10:31:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18926444,"change_date":"2026-02-10 21:39:00","inspection_id":"87010440","insp_unit_id":"211550247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"35879956","created_at":"2026-02-13T10:15:42.000000Z","updated_at":"2026-02-21T10:04:05.000000Z"}]},{"id":10325798,"change_date":"2025-12-01 21:40:00","inspection_id":"86452614","dot_number":"2721186","report_state":"CA","report_number":"UFHG000074","insp_date":"2025-11-15 00:00:00","insp_start_time":"1845","insp_end_time":"1925","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":"2025-12-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16074473","transaction_code":"A","transaction_date":"2025-11-15 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-12-01 21:40:00","snet_input_date":"2025-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-12-04T10:30:48.000000Z","updated_at":"2025-12-05T10:32:00.000000Z","inspection_violations":[{"id":17270238,"change_date":"2025-12-01 21:40:00","inspection_id":"86452614","insp_violation_id":"270381363","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"210344756","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC12140","created_at":"2025-12-04T10:31:17.000000Z","updated_at":"2025-12-05T10:32:41.000000Z","normalized_code":"3939ALSML"},{"id":17270239,"change_date":"2025-12-01 21:40:00","inspection_id":"86452614","insp_violation_id":"270381364","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210344756","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC12140","created_at":"2025-12-04T10:31:17.000000Z","updated_at":"2025-12-05T10:32:41.000000Z","normalized_code":"3939ALCL"},{"id":17270240,"change_date":"2025-12-01 21:40:00","inspection_id":"86452614","insp_violation_id":"270381365","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"210344756","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:31:17.000000Z","updated_at":"2025-12-05T10:32:41.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":17243959,"change_date":"2025-12-01 21:40:00","inspection_id":"86452614","insp_unit_id":"210344756","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:50.000000Z","updated_at":"2025-12-05T10:02:29.000000Z"}]},{"id":10184573,"change_date":"2025-11-12 21:41:00","inspection_id":"86304536","dot_number":"2721186","report_state":"CA","report_number":"UD4G004151","insp_date":"2025-11-10 00:00:00","insp_start_time":"0750","insp_end_time":"0820","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":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25996","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16053844","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-11-15T10:30:55.000000Z","updated_at":"2025-11-16T10:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16962688,"change_date":"2025-11-12 21:41:00","inspection_id":"86304536","insp_unit_id":"209991960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:47.000000Z","updated_at":"2025-11-16T10:02:08.000000Z"}]},{"id":10151727,"change_date":"2025-11-07 21:40:00","inspection_id":"86269906","dot_number":"2721186","report_state":"CA","report_number":"NDKW008503","insp_date":"2025-11-03 00:00:00","insp_start_time":"1702","insp_end_time":"1727","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":"2025-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"16048213","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-11-10T10:31:48.000000Z","updated_at":"2025-11-11T10:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16900534,"change_date":"2025-11-07 21:40:00","inspection_id":"86269906","insp_unit_id":"209915759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23\/ WHT","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"35617888","created_at":"2025-11-10T10:02:20.000000Z","updated_at":"2025-11-11T10:01:39.000000Z"}]},{"id":9503388,"change_date":"2025-08-25 21:40:00","inspection_id":"85588318","dot_number":"2721186","report_state":"CA","report_number":"UE9B003257","insp_date":"2025-08-16 00:00:00","insp_start_time":"1226","insp_end_time":"1303","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15949996","transaction_code":"A","transaction_date":"2025-08-17 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-08-29T10:42:48.000000Z","updated_at":"2025-08-29T10:42:48.000000Z","inspection_violations":[{"id":15498310,"change_date":"2025-08-25 21:40:00","inspection_id":"85588318","insp_violation_id":"268241681","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"208576591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC11008","created_at":"2025-08-28T10:44:18.000000Z","updated_at":"2025-09-05T10:49:22.000000Z","normalized_code":"39311A1LHLM"}],"inspection_per_units":[{"id":15679962,"change_date":"2025-08-25 21:40:00","inspection_id":"85588318","insp_unit_id":"208576591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:41.000000Z","updated_at":"2025-08-29T09:46:30.000000Z"}]},{"id":9404894,"change_date":"2025-08-13 21:39:00","inspection_id":"85484554","dot_number":"2721186","report_state":"CA","report_number":"ND4P008705","insp_date":"2025-08-05 00:00:00","insp_start_time":"1829","insp_end_time":"1852","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":"2025-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15936341","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-08-13 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-08-16T10:01:26.000000Z","updated_at":"2025-08-17T10:00:54.000000Z","inspection_violations":[{"id":15295331,"change_date":"2025-08-13 21:39:00","inspection_id":"85484554","insp_violation_id":"268012565","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208383382","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:16.000000Z","updated_at":"2025-08-17T10:44:45.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15500485,"change_date":"2025-08-13 21:39:00","inspection_id":"85484554","insp_unit_id":"208383382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"35339478","created_at":"2025-08-16T09:46:41.000000Z","updated_at":"2025-08-17T09:46:05.000000Z"}]},{"id":9144957,"change_date":"2025-07-14 21:41:00","inspection_id":"85211470","dot_number":"2721186","report_state":"CA","report_number":"NDUP007272","insp_date":"2025-07-09 00:00:00","insp_start_time":"0804","insp_end_time":"0843","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","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":"2025-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15896446","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-07-18T10:45:50.000000Z","updated_at":"2025-07-18T10:45:50.000000Z","inspection_violations":[{"id":14752788,"change_date":"2025-07-14 21:41:00","inspection_id":"85211470","insp_violation_id":"267398437","seq_no":"1","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"207863146","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:20.000000Z","updated_at":"2025-07-18T10:47:44.000000Z","normalized_code":"393203BCBP"}],"inspection_per_units":[{"id":15017657,"change_date":"2025-07-14 21:41:00","inspection_id":"85211470","insp_unit_id":"207863146","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"#22 2XBOXTK","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"Y","insp_unit_decal_number":"35338950","created_at":"2025-07-17T09:45:34.000000Z","updated_at":"2025-07-18T09:46:12.000000Z"}]},{"id":8888713,"change_date":"2025-06-12 21:42:00","inspection_id":"84940634","dot_number":"2721186","report_state":"CA","report_number":"UD3C001069","insp_date":"2025-06-03 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"E\/B CORDELIA CVEF","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":"2025-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15857957","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-06-12 21:42:00","snet_input_date":"2025-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-12 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-06-15T10:01:14.000000Z","updated_at":"2025-06-16T10:00:59.000000Z","inspection_violations":[{"id":14246847,"change_date":"2025-06-12 21:42:00","inspection_id":"84940634","insp_violation_id":"266820500","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207365796","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ34469","created_at":"2025-06-17T10:17:24.000000Z","updated_at":"2025-06-17T10:19:51.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":14560910,"change_date":"2025-06-12 21:42:00","inspection_id":"84940634","insp_unit_id":"207365796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:35.000000Z","updated_at":"2025-06-16T09:46:27.000000Z"}]},{"id":8620959,"change_date":"2025-05-13 21:41:00","inspection_id":"84657765","dot_number":"2721186","report_state":"CA","report_number":"ND4P008388","insp_date":"2025-05-06 00:00:00","insp_start_time":"1814","insp_end_time":"1837","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":"2025-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15816416","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-05-17T10:04:19.000000Z","updated_at":"2025-05-17T10:09:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14076354,"change_date":"2025-05-13 21:41:00","inspection_id":"84657765","insp_unit_id":"206837401","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"35060107","created_at":"2025-05-16T09:49:51.000000Z","updated_at":"2025-05-17T09:51:34.000000Z"}]},{"id":8038570,"change_date":"2025-03-05 21:40:00","inspection_id":"84044272","dot_number":"2721186","report_state":"CA","report_number":"UCVI002574","insp_date":"2025-03-03 00:00:00","insp_start_time":"1810","insp_end_time":"1831","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":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15727702","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:00.000000Z","updated_at":"2025-03-17T21:05:00.000000Z","inspection_violations":[{"id":12563139,"change_date":"2025-03-05 21:40:00","inspection_id":"84044272","insp_violation_id":"264858349","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205649080","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ37505","created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":12977751,"change_date":"2025-03-05 21:40:00","inspection_id":"84044272","insp_unit_id":"205649080","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"}]},{"id":8037780,"change_date":"2025-03-05 21:40:00","inspection_id":"84043469","dot_number":"2721186","report_state":"CA","report_number":"NDKW007564","insp_date":"2025-02-25 00:00:00","insp_start_time":"1755","insp_end_time":"1815","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":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15727802","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T21:04:59.000000Z","updated_at":"2025-03-17T21:04:59.000000Z","inspection_violations":[{"id":12562265,"change_date":"2025-03-05 21:40:00","inspection_id":"84043469","insp_violation_id":"264857404","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205647791","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:26.000000Z","updated_at":"2025-03-17T22:07:26.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":12976514,"change_date":"2025-03-05 21:40:00","inspection_id":"84043469","insp_unit_id":"205647791","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23\/ WHT","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:21.000000Z","updated_at":"2025-03-17T23:58:21.000000Z"}]},{"id":8038480,"change_date":"2025-03-05 21:40:00","inspection_id":"84044179","dot_number":"2721186","report_state":"CA","report_number":"UCV0000487","insp_date":"2025-02-24 00:00:00","insp_start_time":"1823","insp_end_time":"1839","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":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15728128","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T21:05:00.000000Z","updated_at":"2025-03-17T21:05:00.000000Z","inspection_violations":[{"id":12563026,"change_date":"2025-03-05 21:40:00","inspection_id":"84044179","insp_violation_id":"264858216","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205648933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:26.000000Z","updated_at":"2025-03-17T22:07:26.000000Z","normalized_code":"3939ALIL"},{"id":12563027,"change_date":"2025-03-05 21:40:00","inspection_id":"84044179","insp_violation_id":"264858217","seq_no":"2","part_no":"393","part_no_section":"25E-L","insp_viol_unit":"1","insp_unit_id":"205648933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:26.000000Z","updated_at":"2025-03-17T22:07:26.000000Z","normalized_code":"39325EL"}],"inspection_per_units":[{"id":12977614,"change_date":"2025-03-05 21:40:00","inspection_id":"84044179","insp_unit_id":"205648933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"34773038","created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"}]},{"id":7511074,"change_date":"2024-12-27 21:38:00","inspection_id":"83490385","dot_number":"2721186","report_state":"CA","report_number":"NEID002813","insp_date":"2024-12-26 00:00:00","insp_start_time":"1742","insp_end_time":"1800","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":"2024-12-27 21:38: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":"15643727","transaction_code":"A","transaction_date":"2024-12-26 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-12-27 21:38:00","snet_input_date":"2024-12-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:52:42.000000Z","updated_at":"2025-03-17T20:52:42.000000Z","inspection_violations":[{"id":11739690,"change_date":"2024-12-27 21:38:00","inspection_id":"83490385","insp_violation_id":"263678086","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204576760","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ33594","created_at":"2025-03-17T22:03:09.000000Z","updated_at":"2025-03-17T22:03:09.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":12117452,"change_date":"2024-12-27 21:38:00","inspection_id":"83490385","insp_unit_id":"204576760","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23\/WHITE","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:46.000000Z","updated_at":"2025-03-17T23:48:46.000000Z"}]},{"id":7304960,"change_date":"2024-11-30 21:32:00","inspection_id":"83273840","dot_number":"2721186","report_state":"CA","report_number":"NEID002744","insp_date":"2024-11-25 00:00:00","insp_start_time":"1815","insp_end_time":"1834","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":"2024-11-30 21:32: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":"15605474","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-11-30 21:32:00","snet_input_date":"2024-11-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:32:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11784004,"change_date":"2024-11-30 21:32:00","inspection_id":"83273840","insp_unit_id":"204108171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:07.000000Z","updated_at":"2025-03-17T23:45:07.000000Z"}]},{"id":7254142,"change_date":"2024-11-21 21:41:00","inspection_id":"83220008","dot_number":"2721186","report_state":"CA","report_number":"NDA2006838","insp_date":"2024-11-20 00:00:00","insp_start_time":"1857","insp_end_time":"1916","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":"2024-11-21 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":"15602163","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:47:18.000000Z","updated_at":"2025-03-17T20:47:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11700759,"change_date":"2024-11-21 21:41:00","inspection_id":"83220008","insp_unit_id":"204000857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"396510","insp_unit_license":"3118198","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC4NDMV5792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:17.000000Z","updated_at":"2025-03-17T23:44:17.000000Z"}]},{"id":7262400,"change_date":"2024-11-22 21:41:00","inspection_id":"83228736","dot_number":"2721186","report_state":"CA","report_number":"NDZ5005051","insp_date":"2024-11-08 00:00:00","insp_start_time":"1812","insp_end_time":"1831","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-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15604416","transaction_code":"A","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11714368,"change_date":"2024-11-22 21:41:00","inspection_id":"83228736","insp_unit_id":"204018527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"34474448","created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":7263680,"change_date":"2024-11-22 21:41:00","inspection_id":"83230046","dot_number":"2721186","report_state":"CA","report_number":"NEID002688","insp_date":"2024-11-07 00:00:00","insp_start_time":"1548","insp_end_time":"1610","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-11-22 21:41: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":"15602673","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:47:41.000000Z","updated_at":"2025-03-17T20:47:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11716252,"change_date":"2024-11-22 21:41:00","inspection_id":"83230046","insp_unit_id":"204020541","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"Y","insp_unit_decal_number":"34474791","created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"}]},{"id":7030628,"change_date":"2024-10-23 21:43:00","inspection_id":"82983294","dot_number":"2721186","report_state":"CA","report_number":"UCVI002292","insp_date":"2024-10-22 00:00:00","insp_start_time":"1815","insp_end_time":"1828","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15567302","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-10-23 21:43:00","snet_input_date":"2024-10-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-23 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:39.000000Z","updated_at":"2025-03-17T20:42:39.000000Z","inspection_violations":[{"id":10972614,"change_date":"2024-10-23 21:43:00","inspection_id":"82983294","insp_violation_id":"262524512","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"203557218","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJH33177","created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":11338794,"change_date":"2024-10-23 21:43:00","inspection_id":"82983294","insp_unit_id":"203557218","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:24.000000Z","updated_at":"2025-03-17T23:40:24.000000Z"}]},{"id":6915509,"change_date":"2024-10-08 21:42:00","inspection_id":"82860964","dot_number":"2721186","report_state":"CA","report_number":"UE5M003928","insp_date":"2024-10-07 00:00:00","insp_start_time":"1250","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42: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":"15548705","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[{"id":10778383,"change_date":"2024-10-08 21:42:00","inspection_id":"82860964","insp_violation_id":"262253201","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203323675","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ33138","created_at":"2025-03-17T21:58:10.000000Z","updated_at":"2025-03-17T21:58:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11153271,"change_date":"2024-10-08 21:42:00","inspection_id":"82860964","insp_unit_id":"203323675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:30.000000Z","updated_at":"2025-03-17T23:38:30.000000Z"}]},{"id":6684523,"change_date":"2024-09-09 21:41:00","inspection_id":"82615156","dot_number":"2721186","report_state":"CA","report_number":"NDZ5004824","insp_date":"2024-09-06 00:00:00","insp_start_time":"1825","insp_end_time":"1901","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-09-09 21:41: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":"15515473","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-09-09 21:41:00","snet_input_date":"2024-09-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-09 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:35:38.000000Z","updated_at":"2025-03-17T20:35:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10778037,"change_date":"2024-09-09 21:41:00","inspection_id":"82615156","insp_unit_id":"202835344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"34212899","created_at":"2025-03-17T23:34:35.000000Z","updated_at":"2025-03-17T23:34:35.000000Z"}]},{"id":6371766,"change_date":"2024-08-01 21:41:00","inspection_id":"82281589","dot_number":"2721186","report_state":"CA","report_number":"NBH6005803","insp_date":"2024-07-31 00:00:00","insp_start_time":"1231","insp_end_time":"1241","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-01 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":"15466848","transaction_code":"A","transaction_date":"2024-07-31 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-07-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[{"id":9892185,"change_date":"2024-08-01 21:41:00","inspection_id":"82281589","insp_violation_id":"260975181","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202198302","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10267977,"change_date":"2024-08-01 21:41:00","inspection_id":"82281589","insp_unit_id":"202198302","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6040898,"change_date":"2024-06-20 21:44:00","inspection_id":"81926625","dot_number":"2721186","report_state":"CA","report_number":"NBH6005677","insp_date":"2024-06-19 00:00:00","insp_start_time":"1308","insp_end_time":"1324","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":"2024-06-20 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15412138","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-06-20 21:44:00","snet_input_date":"2024-06-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-20 21:44:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:22:34.000000Z","updated_at":"2025-03-17T20:22:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9729623,"change_date":"2024-06-20 21:44:00","inspection_id":"81926625","insp_unit_id":"201514646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"Y","insp_unit_decal_number":"33817935","created_at":"2025-03-17T23:23:47.000000Z","updated_at":"2025-03-17T23:23:47.000000Z"}]},{"id":6022137,"change_date":"2024-06-18 21:43:00","inspection_id":"81906264","dot_number":"2721186","report_state":"CA","report_number":"NF37000332","insp_date":"2024-06-17 00:00:00","insp_start_time":"1256","insp_end_time":"1319","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-06-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15407908","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-06-18 21:43:00","snet_input_date":"2024-06-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-18 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:22:13.000000Z","updated_at":"2025-03-17T20:22:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9699530,"change_date":"2024-06-18 21:43:00","inspection_id":"81906264","insp_unit_id":"201476361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"23","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"33817411","created_at":"2025-03-17T23:23:30.000000Z","updated_at":"2025-03-17T23:23:30.000000Z"}]},{"id":5988097,"change_date":"2024-06-13 21:42:00","inspection_id":"81869575","dot_number":"2721186","report_state":"CA","report_number":"NBH6005659","insp_date":"2024-06-12 00:00:00","insp_start_time":"1308","insp_end_time":"1323","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-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":"15402257","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:21:28.000000Z","updated_at":"2025-03-17T20:21:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9645217,"change_date":"2024-06-13 21:42:00","inspection_id":"81869575","insp_unit_id":"201388186","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"}]},{"id":5837930,"change_date":"2024-05-24 21:39:00","inspection_id":"81706493","dot_number":"2721186","report_state":"CA","report_number":"UD1D000337","insp_date":"2024-05-18 00:00:00","insp_start_time":"1855","insp_end_time":"1907","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-24 21:39: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":"15377434","transaction_code":"A","transaction_date":"2024-05-18 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-05-24 21:39:00","snet_input_date":"2024-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-24 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:19.000000Z","updated_at":"2025-03-17T20:18:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9402126,"change_date":"2024-05-24 21:39:00","inspection_id":"81706493","insp_unit_id":"201075995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:35.000000Z","updated_at":"2025-03-17T23:20:35.000000Z"}]},{"id":5838032,"change_date":"2024-05-24 21:39:00","inspection_id":"81706597","dot_number":"2721186","report_state":"CA","report_number":"UF73002004","insp_date":"2024-05-18 00:00:00","insp_start_time":"1333","insp_end_time":"1345","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15377278","transaction_code":"A","transaction_date":"2024-05-18 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-05-24 21:39:00","snet_input_date":"2024-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-24 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:18:19.000000Z","updated_at":"2025-03-17T20:18:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9402274,"change_date":"2024-05-24 21:39:00","inspection_id":"81706597","insp_unit_id":"201076157","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:35.000000Z","updated_at":"2025-03-17T23:20:35.000000Z"}]},{"id":5682162,"change_date":"2024-05-06 21:44:00","inspection_id":"81537356","dot_number":"2721186","report_state":"CA","report_number":"UEEE002322","insp_date":"2024-05-04 00:00:00","insp_start_time":"1800","insp_end_time":"1822","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-05-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15348628","transaction_code":"A","transaction_date":"2024-05-04 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-05-06 21:44:00","snet_input_date":"2024-05-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-06 21:44:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:15:27.000000Z","updated_at":"2025-03-17T20:15:27.000000Z","inspection_violations":[{"id":8791242,"change_date":"2024-05-06 21:44:00","inspection_id":"81537356","insp_violation_id":"259346893","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200753866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA587722","created_at":"2025-03-17T21:48:31.000000Z","updated_at":"2025-03-17T21:48:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9152010,"change_date":"2024-05-06 21:44:00","inspection_id":"81537356","insp_unit_id":"200753866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:10.000000Z","updated_at":"2025-03-17T23:18:10.000000Z"}]},{"id":5637792,"change_date":"2024-04-30 21:42:00","inspection_id":"81489156","dot_number":"2721186","report_state":"CA","report_number":"UEEE002232","insp_date":"2024-03-23 00:00:00","insp_start_time":"1741","insp_end_time":"1747","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-30 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":"15340118","transaction_code":"A","transaction_date":"2024-03-23 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:14:20.000000Z","updated_at":"2025-03-17T20:14:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9081276,"change_date":"2024-04-30 21:42:00","inspection_id":"81489156","insp_unit_id":"200660473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"}]},{"id":5269769,"change_date":"2024-03-12 21:39:00","inspection_id":"81087658","dot_number":"2721186","report_state":"CA","report_number":"NC3S008006","insp_date":"2024-03-11 00:00:00","insp_start_time":"1320","insp_end_time":"1350","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-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15277781","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-03-12 21:39:00","snet_input_date":"2024-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-12 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:07:05.000000Z","updated_at":"2025-03-17T20:07:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8486137,"change_date":"2024-03-12 21:39:00","inspection_id":"81087658","insp_unit_id":"199877766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"WHT","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"Y","insp_unit_decal_number":"33522249","created_at":"2025-03-17T23:11:55.000000Z","updated_at":"2025-03-17T23:11:55.000000Z"}]},{"id":5207889,"change_date":"2024-03-04 21:42:00","inspection_id":"81019982","dot_number":"2721186","report_state":"CA","report_number":"NEID001985","insp_date":"2024-02-28 00:00:00","insp_start_time":"1630","insp_end_time":"1655","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-04 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":"15267016","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-03-04 21:42:00","snet_input_date":"2024-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-04 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:05:45.000000Z","updated_at":"2025-03-17T20:05:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8385834,"change_date":"2024-03-04 21:42:00","inspection_id":"81019982","insp_unit_id":"199747968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FTL","insp_unit_company":"396510","insp_unit_license":"3118198","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC4NDMV5792","insp_unit_decal":"Y","insp_unit_decal_number":"33520612","created_at":"2025-03-17T23:10:59.000000Z","updated_at":"2025-03-17T23:10:59.000000Z"}]},{"id":4925017,"change_date":"2024-01-29 21:40:00","inspection_id":"80711055","dot_number":"2721186","report_state":"CA","report_number":"UEEE002132","insp_date":"2024-01-27 00:00:00","insp_start_time":"1750","insp_end_time":"1817","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-01-29 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":"15215952","transaction_code":"A","transaction_date":"2024-01-27 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-01-29 21:40:00","snet_input_date":"2024-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-29 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:00:26.000000Z","updated_at":"2025-03-17T20:00:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7925635,"change_date":"2024-01-29 21:40:00","inspection_id":"80711055","insp_unit_id":"199158159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"33520977","created_at":"2025-03-17T23:06:51.000000Z","updated_at":"2025-03-17T23:06:51.000000Z"}]},{"id":4861633,"change_date":"2024-01-18 21:45:00","inspection_id":"80641860","dot_number":"2721186","report_state":"CA","report_number":"NE1M004771","insp_date":"2024-01-17 00:00:00","insp_start_time":"1021","insp_end_time":"1043","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":"2024-01-18 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15205060","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:59:11.000000Z","updated_at":"2025-03-17T19:59:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7822046,"change_date":"2024-01-18 21:45:00","inspection_id":"80641860","insp_unit_id":"199021891","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2XWHTBX","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:54.000000Z","updated_at":"2025-03-17T23:05:54.000000Z"}]},{"id":4844363,"change_date":"2024-01-16 21:45:00","inspection_id":"80622956","dot_number":"2721186","report_state":"CA","report_number":"UEH7005105","insp_date":"2024-01-16 00:00:00","insp_start_time":"0931","insp_end_time":"0943","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"FRENCH RD","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-16 21:45: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":"15201667","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:58:48.000000Z","updated_at":"2025-03-17T19:58:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7794231,"change_date":"2024-01-16 21:45:00","inspection_id":"80622956","insp_unit_id":"198984360","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:39.000000Z","updated_at":"2025-03-17T23:05:39.000000Z"}]},{"id":5163744,"change_date":"2024-02-28 21:43:00","inspection_id":"80971869","dot_number":"2721186","report_state":"CA","report_number":"NE28004285","insp_date":"2024-01-11 00:00:00","insp_start_time":"1647","insp_end_time":"1658","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":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15249536","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-01-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T20:04:56.000000Z","updated_at":"2025-03-17T20:04:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8313912,"change_date":"2024-02-28 21:43:00","inspection_id":"80971869","insp_unit_id":"199658869","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"WHT 2X","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","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":4614741,"change_date":"2023-12-12 21:42:00","inspection_id":"80372069","dot_number":"2721186","report_state":"CA","report_number":"UCVI001945","insp_date":"2023-12-11 00:00:00","insp_start_time":"1840","insp_end_time":"1854","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-12 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":"15164181","transaction_code":"A","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-12-12 21:42:00","snet_input_date":"2023-12-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-12 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:13.000000Z","updated_at":"2025-03-17T19:54:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7422661,"change_date":"2023-12-12 21:42:00","inspection_id":"80372069","insp_unit_id":"198474594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:23.000000Z","updated_at":"2025-03-17T23:02:23.000000Z"}]},{"id":4645805,"change_date":"2023-12-15 21:39:00","inspection_id":"80406102","dot_number":"2721186","report_state":"CA","report_number":"UD1D000065","insp_date":"2023-12-09 00:00:00","insp_start_time":"1804","insp_end_time":"1823","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15169798","transaction_code":"A","transaction_date":"2023-12-09 00:00:00","upload_date":"2023-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-12-15 21:39:00","snet_input_date":"2023-12-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-15 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:54:56.000000Z","updated_at":"2025-03-17T19:54:56.000000Z","inspection_violations":[{"id":7182870,"change_date":"2023-12-15 21:39:00","inspection_id":"80406102","insp_violation_id":"256922888","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA158245","created_at":"2025-03-17T21:40:43.000000Z","updated_at":"2025-03-17T21:40:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7471963,"change_date":"2023-12-15 21:39:00","inspection_id":"80406102","insp_unit_id":"198538676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2X WHT","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:49.000000Z","updated_at":"2025-03-17T23:02:49.000000Z"}]},{"id":4416194,"change_date":"2023-11-13 21:43:00","inspection_id":"80153725","dot_number":"2721186","report_state":"CA","report_number":"UECE005343","insp_date":"2023-11-10 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"ELDER CREEK EOF FLORIN PERKINS","county_code_state":"CA","county_code":"067","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15132831","transaction_code":"A","transaction_date":"2023-11-10 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-11-13 21:43:00","snet_input_date":"2023-11-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-13 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:50:20.000000Z","updated_at":"2025-03-17T19:50:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7102365,"change_date":"2023-11-13 21:43:00","inspection_id":"80153725","insp_unit_id":"198039857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"}]},{"id":4266915,"change_date":"2023-10-23 21:43:00","inspection_id":"79988551","dot_number":"2721186","report_state":"CA","report_number":"UF73001678","insp_date":"2023-10-14 00:00:00","insp_start_time":"1245","insp_end_time":"1257","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15105963","transaction_code":"A","transaction_date":"2023-10-14 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-10-23 21:43:00","snet_input_date":"2023-10-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-23 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:47:26.000000Z","updated_at":"2025-03-17T19:47:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6862267,"change_date":"2023-10-23 21:43:00","inspection_id":"79988551","insp_unit_id":"197708467","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:32.000000Z","updated_at":"2025-03-17T22:57:32.000000Z"}]},{"id":4209279,"change_date":"2023-10-16 21:43:00","inspection_id":"79924915","dot_number":"2721186","report_state":"CA","report_number":"ND6S006247","insp_date":"2023-10-03 00:00:00","insp_start_time":"1234","insp_end_time":"1258","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-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15096396","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:46:14.000000Z","updated_at":"2025-03-17T19:46:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6769347,"change_date":"2023-10-16 21:43:00","inspection_id":"79924915","insp_unit_id":"197583178","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"33203135","created_at":"2025-03-17T22:56:44.000000Z","updated_at":"2025-03-17T22:56:44.000000Z"}]},{"id":4087200,"change_date":"2023-09-28 21:42:00","inspection_id":"79789786","dot_number":"2721186","report_state":"CA","report_number":"NDZ5003836","insp_date":"2023-09-26 00:00:00","insp_start_time":"1750","insp_end_time":"1837","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-28 21:42: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":"15078020","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-09-28 21:42:00","snet_input_date":"2023-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-28 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:43:37.000000Z","updated_at":"2025-03-17T19:43:37.000000Z","inspection_violations":[{"id":6326608,"change_date":"2023-09-28 21:42:00","inspection_id":"79789786","insp_violation_id":"255561839","seq_no":"1","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"197308919","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":6571336,"change_date":"2023-09-28 21:42:00","inspection_id":"79789786","insp_unit_id":"197308919","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"336685","insp_unit_license":"2844694","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML7LL139566","insp_unit_decal":"Y","insp_unit_decal_number":"32851012","created_at":"2025-03-17T22:55:09.000000Z","updated_at":"2025-03-17T22:55:09.000000Z"}]},{"id":3862273,"change_date":"2023-08-29 21:43:00","inspection_id":"79539604","dot_number":"2721186","report_state":"CA","report_number":"UEEE001820","insp_date":"2023-08-28 00:00:00","insp_start_time":"1745","insp_end_time":"1753","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 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":"15042371","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-08-29 21:43:00","snet_input_date":"2023-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-29 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:20.000000Z","updated_at":"2025-03-17T19:39:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6209651,"change_date":"2023-08-29 21:43:00","inspection_id":"79539604","insp_unit_id":"196797824","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:09.000000Z","updated_at":"2025-03-17T22:52:09.000000Z"}]},{"id":3741005,"change_date":"2023-08-14 21:43:00","inspection_id":"79404098","dot_number":"2721186","report_state":"CA","report_number":"NDZ5003663","insp_date":"2023-08-10 00:00:00","insp_start_time":"1639","insp_end_time":"1715","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-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"15017966","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-08-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:36:51.000000Z","updated_at":"2025-03-17T19:36:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6015364,"change_date":"2023-08-14 21:43:00","inspection_id":"79404098","insp_unit_id":"196526248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"WHT","insp_unit_license":"43380T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"Y","insp_unit_decal_number":"32848217","created_at":"2025-03-17T22:50:34.000000Z","updated_at":"2025-03-17T22:50:34.000000Z"}]},{"id":3690000,"change_date":"2023-08-07 21:43:00","inspection_id":"79347426","dot_number":"2721186","report_state":"CA","report_number":"NCNG006698","insp_date":"2023-07-28 00:00:00","insp_start_time":"1848","insp_end_time":"1910","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":"BRAMBILA RECYCLING","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-08-07 21:43: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":"15009721","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-08-07 21:43:00","snet_input_date":"2023-07-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-07 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:35:41.000000Z","updated_at":"2025-03-17T19:35:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5932996,"change_date":"2023-08-07 21:43:00","inspection_id":"79347426","insp_unit_id":"196411936","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"265069","insp_unit_license":"3404613","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML3RL574495","insp_unit_decal":"Y","insp_unit_decal_number":"32846653","created_at":"2025-03-17T22:49:52.000000Z","updated_at":"2025-03-17T22:49:52.000000Z"}]},{"id":3279486,"change_date":"2023-06-13 21:43:00","inspection_id":"78886055","dot_number":"2721186","report_state":"CA","report_number":"UD2D000393","insp_date":"2023-06-12 00:00:00","insp_start_time":"1730","insp_end_time":"1736","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-13 21:43: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":"14941004","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-06-13 21:43:00","snet_input_date":"2023-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-13 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:46.000000Z","updated_at":"2025-03-17T19:27:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5273138,"change_date":"2023-06-13 21:43:00","inspection_id":"78886055","insp_unit_id":"195485031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:34.000000Z","updated_at":"2025-03-17T22:44:34.000000Z"}]},{"id":3196715,"change_date":"2023-06-01 21:43:00","inspection_id":"78792701","dot_number":"2721186","report_state":"CA","report_number":"UF73001412","insp_date":"2023-05-27 00:00:00","insp_start_time":"1757","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":"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-06-01 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":"14926785","transaction_code":"A","transaction_date":"2023-05-27 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-06-01 21:43:00","snet_input_date":"2023-05-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:26:08.000000Z","updated_at":"2025-03-17T19:26:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5141899,"change_date":"2023-06-01 21:43:00","inspection_id":"78792701","insp_unit_id":"195269207","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:31.000000Z","updated_at":"2025-03-17T22:43:31.000000Z"}]},{"id":3127563,"change_date":"2023-05-23 21:43:00","inspection_id":"78714351","dot_number":"2721186","report_state":"CA","report_number":"UEEE001611","insp_date":"2023-05-20 00:00:00","insp_start_time":"1920","insp_end_time":"1927","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 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":"14914459","transaction_code":"A","transaction_date":"2023-05-20 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:57.000000Z","updated_at":"2025-03-17T19:24:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5030549,"change_date":"2023-05-23 21:43:00","inspection_id":"78714351","insp_unit_id":"195111835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:40.000000Z","updated_at":"2025-03-17T22:42:40.000000Z"}]},{"id":3006867,"change_date":"2023-05-09 21:43:00","inspection_id":"78578367","dot_number":"2721186","report_state":"CA","report_number":"NDKW005107","insp_date":"2023-05-03 00:00:00","insp_start_time":"1812","insp_end_time":"1840","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":"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":"14892673","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","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":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:22:36.000000Z","updated_at":"2025-03-17T19:22:36.000000Z","inspection_violations":[{"id":4619551,"change_date":"2023-05-09 21:43:00","inspection_id":"78578367","insp_violation_id":"252733401","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194844197","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4838139,"change_date":"2023-05-09 21:43:00","inspection_id":"78578367","insp_unit_id":"194844197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"32463097","created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"}]},{"id":2958556,"change_date":"2023-05-03 21:42:00","inspection_id":"78523632","dot_number":"2721186","report_state":"CA","report_number":"NE28003326","insp_date":"2023-05-01 00:00:00","insp_start_time":"1805","insp_end_time":"1830","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-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"14884846","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-05-03 21:42:00","snet_input_date":"2023-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:21:26.000000Z","updated_at":"2025-03-17T19:21:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4760763,"change_date":"2023-05-03 21:42:00","inspection_id":"78523632","insp_unit_id":"194735526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"WHT 2X","insp_unit_license":"CP04L89","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA7NS002697","insp_unit_decal":"Y","insp_unit_decal_number":"32462281","created_at":"2025-03-17T22:40:32.000000Z","updated_at":"2025-03-17T22:40:32.000000Z"}]},{"id":2277511,"change_date":"2023-02-01 21:41:00","inspection_id":"77749244","dot_number":"2721186","report_state":"CA","report_number":"NDA2004549","insp_date":"2023-01-25 00:00:00","insp_start_time":"1445","insp_end_time":"1503","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-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"14765250","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-02-01 21:41:00","snet_input_date":"2023-01-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-01 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:08:32.000000Z","updated_at":"2025-03-17T19:08:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3666595,"change_date":"2023-02-01 21:41:00","inspection_id":"77749244","insp_unit_id":"193181930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"WHT 2X","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"32136140","created_at":"2025-03-17T22:32:17.000000Z","updated_at":"2025-03-17T22:32:17.000000Z"}]},{"id":2175472,"change_date":"2023-01-18 21:41:00","inspection_id":"77632923","dot_number":"2721186","report_state":"CA","report_number":"UE5M002567","insp_date":"2023-01-12 00:00:00","insp_start_time":"1525","insp_end_time":"1540","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"14743495","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-01-18 21:41:00","snet_input_date":"2023-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:41:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3501389,"change_date":"2023-01-18 21:41:00","inspection_id":"77632923","insp_unit_id":"192942906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":2122605,"change_date":"2023-01-11 21:43:00","inspection_id":"77572013","dot_number":"2721186","report_state":"CA","report_number":"UD2D000290","insp_date":"2023-01-09 00:00:00","insp_start_time":"1814","insp_end_time":"1820","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-11 21:43: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":"14733789","transaction_code":"A","transaction_date":"2023-01-09 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:50.000000Z","updated_at":"2025-03-17T19:05:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3416395,"change_date":"2023-01-11 21:43:00","inspection_id":"77572013","insp_unit_id":"192825870","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41625M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:30.000000Z","updated_at":"2025-03-17T22:30:30.000000Z"}]},{"id":2119728,"change_date":"2023-01-11 21:43:00","inspection_id":"77568891","dot_number":"2721186","report_state":"CA","report_number":"ND4P005080","insp_date":"2023-01-06 00:00:00","insp_start_time":"1711","insp_end_time":"1734","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-01-11 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":"14731846","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:05:34.000000Z","updated_at":"2025-03-17T19:05:34.000000Z","inspection_violations":[{"id":3282352,"change_date":"2023-01-11 21:43:00","inspection_id":"77568891","insp_violation_id":"250519258","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192820637","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:33.000000Z","updated_at":"2025-03-17T21:22:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3411744,"change_date":"2023-01-11 21:43:00","inspection_id":"77568891","insp_unit_id":"192820637","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147845","insp_unit_license":"67058X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT6GDHN1079","insp_unit_decal":"Y","insp_unit_decal_number":"32136309","created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"}]},{"id":2120145,"change_date":"2023-01-11 21:43:00","inspection_id":"77569337","dot_number":"2721186","report_state":"CA","report_number":"NDA2004471","insp_date":"2022-12-29 00:00:00","insp_start_time":"1740","insp_end_time":"1754","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-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"14732273","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2022-12-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T19:05:50.000000Z","updated_at":"2025-03-17T19:05:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3412414,"change_date":"2023-01-11 21:43:00","inspection_id":"77569337","insp_unit_id":"192821384","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"WHT 2X","insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"}]},{"id":1417617,"change_date":"2022-09-30 21:40:00","inspection_id":"76763191","dot_number":"2721186","report_state":"CA","report_number":"NCZ3004077","insp_date":"2022-09-29 00:00:00","insp_start_time":"1154","insp_end_time":"1211","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":"2022-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"14616834","transaction_code":"A","transaction_date":"2022-09-29 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-09-30 21:40:00","snet_input_date":"2022-09-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-30 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:52:44.000000Z","updated_at":"2025-03-17T18:52:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2282080,"change_date":"2022-09-30 21:40:00","inspection_id":"76763191","insp_unit_id":"191214087","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"31474597","created_at":"2025-03-17T22:22:37.000000Z","updated_at":"2025-03-17T22:22:37.000000Z"}]},{"id":1382375,"change_date":"2022-09-27 21:40:00","inspection_id":"76722117","dot_number":"2721186","report_state":"CA","report_number":"UDK7001799","insp_date":"2022-09-24 00:00:00","insp_start_time":"1140","insp_end_time":"1155","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-27 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":"14610810","transaction_code":"A","transaction_date":"2022-09-24 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-09-27 21:40:00","snet_input_date":"2022-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:52:18.000000Z","updated_at":"2025-03-17T18:52:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2226196,"change_date":"2022-09-27 21:40:00","inspection_id":"76722117","insp_unit_id":"191133061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147845","insp_unit_license":"67058X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT6GDHN1079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:14.000000Z","updated_at":"2025-03-17T22:22:14.000000Z"}]},{"id":1330163,"change_date":"2022-09-20 21:42:00","inspection_id":"76661702","dot_number":"2721186","report_state":"CA","report_number":"NB7O004646","insp_date":"2022-09-19 00:00:00","insp_start_time":"1816","insp_end_time":"1846","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"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":"2022-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14601433","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-09-20 21:42:00","snet_input_date":"2022-09-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-20 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:51:14.000000Z","updated_at":"2025-03-17T18:51:14.000000Z","inspection_violations":[{"id":2105570,"change_date":"2022-09-20 21:42:00","inspection_id":"76661702","insp_violation_id":"248543738","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191009189","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"3939A"},{"id":2105571,"change_date":"2022-09-20 21:42:00","inspection_id":"76661702","insp_violation_id":"248543739","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191009189","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"3939A"},{"id":2105572,"change_date":"2022-09-20 21:42:00","inspection_id":"76661702","insp_violation_id":"248543740","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"191009189","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":2141622,"change_date":"2022-09-20 21:42:00","inspection_id":"76661702","insp_unit_id":"191009189","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147845","insp_unit_license":"67058X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT6GDHN1079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:40.000000Z","updated_at":"2025-03-17T22:21:40.000000Z"}]},{"id":1243416,"change_date":"2022-09-08 21:39:00","inspection_id":"76560775","dot_number":"2721186","report_state":"CA","report_number":"NB7O004604","insp_date":"2022-09-07 00:00:00","insp_start_time":"1437","insp_end_time":"1516","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":"2022-09-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14585838","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-09-08 21:39:00","snet_input_date":"2022-09-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-08 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:49:41.000000Z","updated_at":"2025-03-17T18:49:41.000000Z","inspection_violations":[{"id":1969408,"change_date":"2022-09-08 21:39:00","inspection_id":"76560775","insp_violation_id":"248296425","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190797914","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3939A"},{"id":1969409,"change_date":"2022-09-08 21:39:00","inspection_id":"76560775","insp_violation_id":"248296426","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190797914","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2001129,"change_date":"2022-09-08 21:39:00","inspection_id":"76560775","insp_unit_id":"190797914","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"147845","insp_unit_license":"67058X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDT6GDHN1079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:46.000000Z","updated_at":"2025-03-17T22:20:46.000000Z"}]},{"id":1189322,"change_date":"2022-08-31 21:43:00","inspection_id":"76498028","dot_number":"2721186","report_state":"CA","report_number":"UDK7001737","insp_date":"2022-08-24 00:00:00","insp_start_time":"1645","insp_end_time":"1700","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-31 21:43: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":"14576026","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-08-31 21:43:00","snet_input_date":"2022-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:48:37.000000Z","updated_at":"2025-03-17T18:48:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1912961,"change_date":"2022-08-31 21:43:00","inspection_id":"76498028","insp_unit_id":"190667966","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:09.000000Z","updated_at":"2025-03-17T22:20:09.000000Z"}]},{"id":713637,"change_date":"2022-06-28 21:43:00","inspection_id":"75942694","dot_number":"2721186","report_state":"CA","report_number":"NEID000101","insp_date":"2022-06-24 00:00:00","insp_start_time":"1835","insp_end_time":"1900","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":"2022-06-28 21:43: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":"14486451","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-06-28 21:43:00","snet_input_date":"2022-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-28 21:43:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:40:12.000000Z","updated_at":"2025-03-17T18:40:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1147153,"change_date":"2022-06-28 21:43:00","inspection_id":"75942694","insp_unit_id":"189512244","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"41626M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M2MDBAA3PS007804","insp_unit_decal":"Y","insp_unit_decal_number":"31098394","created_at":"2025-03-17T22:15:15.000000Z","updated_at":"2025-03-17T22:15:15.000000Z"}]},{"id":333036,"change_date":"2022-05-05 21:42:00","inspection_id":"75490322","dot_number":"2721186","report_state":"CA","report_number":"UBVN001404","insp_date":"2022-05-04 00:00:00","insp_start_time":"1841","insp_end_time":"1856","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14414931","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-05-05 21:42:00","snet_input_date":"2022-05-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-05 21:42:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:33:21.000000Z","updated_at":"2025-03-17T18:33:21.000000Z","inspection_violations":[{"id":522911,"change_date":"2022-05-05 21:42:00","inspection_id":"75490322","insp_violation_id":"245618626","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188539631","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:31.000000Z","updated_at":"2025-03-17T21:09:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":538863,"change_date":"2022-05-05 21:42:00","inspection_id":"75490322","insp_unit_id":"188539631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"V325NF","insp_unit_license_state":"UT","insp_unit_vehicle_id_number":"3ALACWFC5LDLN5780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:30.000000Z","updated_at":"2025-03-17T22:11:30.000000Z"}]},{"id":168780,"change_date":"2022-04-13 21:40:00","inspection_id":"75294282","dot_number":"2721186","report_state":"CA","report_number":"ND6S003788","insp_date":"2022-04-12 00:00:00","insp_start_time":"1027","insp_end_time":"1047","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":"2022-04-13 21:40: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":"14384713","transaction_code":"A","transaction_date":"2022-04-12 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:30:29.000000Z","updated_at":"2025-03-17T18:30:29.000000Z","inspection_violations":[{"id":254869,"change_date":"2022-04-13 21:40:00","inspection_id":"75294282","insp_violation_id":"245140178","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188138464","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:12.000000Z","updated_at":"2025-03-17T21:08:12.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":273645,"change_date":"2022-04-13 21:40:00","inspection_id":"75294282","insp_unit_id":"188138464","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"V325NF","insp_unit_license_state":"UT","insp_unit_vehicle_id_number":"3ALACWFC5LDLN5780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:51.000000Z","updated_at":"2025-03-17T22:09:51.000000Z"}]},{"id":132531,"change_date":"2022-04-07 21:39:00","inspection_id":"75250935","dot_number":"2721186","report_state":"CA","report_number":"NC3S004600","insp_date":"2022-04-06 00:00:00","insp_start_time":"1640","insp_end_time":"1705","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":"2022-04-07 21:39: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":"14376222","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02721186","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"FELIPE D BRAMBILA","insp_carrier_street":"5221 GORDON DR","insp_carrier_city":"SACRAMENTO","insp_carrier_state":"CA","insp_carrier_zip_code":"95824","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"423308","created_at":"2025-03-17T18:29:50.000000Z","updated_at":"2025-03-17T18:29:50.000000Z","inspection_violations":[{"id":196434,"change_date":"2022-04-07 21:39:00","inspection_id":"75250935","insp_violation_id":"245038011","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188050669","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":214758,"change_date":"2022-04-07 21:39:00","inspection_id":"75250935","insp_unit_id":"188050669","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"339478","insp_unit_license":"V325NF","insp_unit_license_state":"UT","insp_unit_vehicle_id_number":"3ALACWFC5LDLN5780","insp_unit_decal":"Y","insp_unit_decal_number":"31094671","created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2721186\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2721186\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2721186\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2721186\/inspections","per_page":100,"prev_page_url":null,"to":70,"total":70}