{"current_page":1,"data":[{"id":12480921,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","dot_number":"3321080","report_state":"CA","report_number":"UE68001369","insp_date":"2026-07-17 00:00:00","insp_start_time":"0610","insp_end_time":"0710","registration_date":null,"region":"PD","ci_status_code":"C","location":"610","location_desc":"CA","county_code_state":"CA","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"18","oos_total":"5","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"16","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3779878","transaction_code":"A","transaction_date":"2026-07-17 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2026-07-17 21:42:00","snet_input_date":"2026-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:42:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-20T09:42:47.000000Z","updated_at":"2026-07-28T09:31:22.000000Z","inspection_violations":[{"id":21728169,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575241","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SL45227","created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3922SLLS2"},{"id":21728152,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575224","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SL45228","created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3922SLLSR"},{"id":21728154,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575226","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA664515","created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":21728155,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575227","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA664515","created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":21728156,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575228","seq_no":"6","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3958A1HOSP"},{"id":21728157,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575229","seq_no":"7","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA664515","created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":21728158,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575230","seq_no":"8","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39395A1"},{"id":21728159,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575231","seq_no":"9","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39395A4EEUS"},{"id":21728160,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575232","seq_no":"10","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3922SLLEQP"},{"id":21728161,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575233","seq_no":"11","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3939ALIL"},{"id":21728162,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575234","seq_no":"12","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39343BBATV"},{"id":21728163,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575235","seq_no":"13","part_no":"396","part_no_section":"3A1-ALATR","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3963A1ALATR"},{"id":21728164,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575236","seq_no":"14","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3922SLLEQP"},{"id":21728165,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575237","seq_no":"15","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"3","insp_unit_id":"214674389","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3922SLLSR"},{"id":21728166,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575238","seq_no":"16","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"3","insp_unit_id":"214674389","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3939ALIL"},{"id":21728167,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575239","seq_no":"17","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"3","insp_unit_id":"214674389","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3939ALSML"},{"id":21728168,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575240","seq_no":"18","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"3","insp_unit_id":"214674389","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"3922SLLSR"},{"id":21728153,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_violation_id":"275575225","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"214674387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA664515","created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"39375CTAOTDLT1\/32"}],"inspection_per_units":[{"id":21677131,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_unit_id":"214674387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHITE","insp_unit_license":"9D80152","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH3CN551681","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:20.000000Z","updated_at":"2026-07-28T09:02:50.000000Z"},{"id":21677132,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_unit_id":"214674388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BROW","insp_unit_company":"WHITE","insp_unit_license":"1WF2340","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"S726470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:20.000000Z","updated_at":"2026-07-28T09:02:50.000000Z"},{"id":21677133,"change_date":"2026-07-17 21:42:00","inspection_id":"88442383","insp_unit_id":"214674389","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"RELB","insp_unit_company":"WHITE","insp_unit_license":"30898K","insp_unit_license_state":"NV","insp_unit_vehicle_id_number":"RRS808414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:20.000000Z","updated_at":"2026-07-28T09:02:50.000000Z"}]},{"id":9587066,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","dot_number":"3321080","report_state":"CA","report_number":"UESX003210","insp_date":"2025-09-02 00:00:00","insp_start_time":"1410","insp_end_time":"1511","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD AREA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"9","oos_total":"5","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15965487","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-09-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-09-06T10:43:33.000000Z","updated_at":"2025-09-10T10:45:11.000000Z","inspection_violations":[{"id":15662340,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446346","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NN00011","created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"3922SLLDL"},{"id":15662341,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446347","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"00NN00011","created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"39141APC"},{"id":15662342,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446348","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"208736938","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"39345B2BHTD"},{"id":15662343,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446349","seq_no":"4","part_no":"393","part_no_section":"205A-WRBH","insp_viol_unit":"2","insp_unit_id":"208736939","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"393205AWRBH"},{"id":15662344,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446350","seq_no":"5","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"2","insp_unit_id":"208736939","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"393205CWR"},{"id":15662345,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446351","seq_no":"6","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208736939","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"39375A3TAOL"},{"id":15662346,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446352","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208736939","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"3922SLLSR"},{"id":15662347,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446353","seq_no":"8","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"208736939","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NN00012","created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"39311BCSSRR"},{"id":15662348,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_violation_id":"268446354","seq_no":"9","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"208736939","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NN00012","created_at":"2025-09-06T10:48:21.000000Z","updated_at":"2025-09-06T10:48:21.000000Z","normalized_code":"39311BCSURR"}],"inspection_per_units":[{"id":15827019,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_unit_id":"208736938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15","insp_unit_license":"9G16329","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDR2DLFF4206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-09T09:47:40.000000Z"},{"id":15827020,"change_date":"2025-09-03 21:40:00","inspection_id":"85676024","insp_unit_id":"208736939","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"4MK3243","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WWBGB6B7YM604043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-09T09:47:40.000000Z"}]},{"id":9384164,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","dot_number":"3321080","report_state":"CA","report_number":"UGM6002170","insp_date":"2025-08-08 00:00:00","insp_start_time":"1426","insp_end_time":"1516","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"E\/B SR-223 JEO ASHE RD","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"14","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15931107","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2025-08-11 21:39:00","snet_input_date":"2025-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-11 21:39:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-08-14T10:42:32.000000Z","updated_at":"2025-08-15T10:43:30.000000Z","inspection_violations":[{"id":15250437,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961542","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208341912","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLLEQP"},{"id":15250438,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961543","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"208341912","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLL"},{"id":15250439,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961544","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208341912","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD24844","created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLLSR"},{"id":15250440,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961545","seq_no":"4","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"208341912","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD24844","created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLL"},{"id":15250441,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961546","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"208341913","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":15250442,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961547","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"208341913","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":15250443,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961548","seq_no":"7","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"208341913","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"39345DB"},{"id":15250444,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961549","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"208341913","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":15250445,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961550","seq_no":"9","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208341913","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD24845","created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLLSR"},{"id":15250446,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961551","seq_no":"10","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"3","insp_unit_id":"208341914","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":15250447,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961552","seq_no":"11","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"3","insp_unit_id":"208341914","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLLMF"},{"id":15250448,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961553","seq_no":"12","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"3","insp_unit_id":"208341914","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3939ALTSI"},{"id":15250449,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961554","seq_no":"13","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"3","insp_unit_id":"208341914","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3939ALLPL"},{"id":15250450,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_violation_id":"267961555","seq_no":"14","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"3","insp_unit_id":"208341914","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD24845","created_at":"2025-08-14T10:43:25.000000Z","updated_at":"2025-08-15T10:45:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15461972,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_unit_id":"208341912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"9E37432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV1ELFV3310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:37.000000Z","updated_at":"2025-08-15T09:46:13.000000Z"},{"id":15461973,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_unit_id":"208341913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"14","insp_unit_license":"3CG3737","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"6L92059001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:37.000000Z","updated_at":"2025-08-15T09:46:13.000000Z"},{"id":15461974,"change_date":"2025-08-11 21:39:00","inspection_id":"85462745","insp_unit_id":"208341914","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"UTIL","insp_unit_company":"14","insp_unit_license":"4CG3739","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"6L92060001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:37.000000Z","updated_at":"2025-08-15T09:46:13.000000Z"}]},{"id":9005474,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","dot_number":"3321080","report_state":"CA","report_number":"UGM6001907","insp_date":"2025-06-18 00:00:00","insp_start_time":"1349","insp_end_time":"1421","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"N\/B SR-99 JNO SR-119","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"10","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15863778","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2025-06-26 21:42:00","snet_input_date":"2025-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:42:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-06-30T10:01:13.000000Z","updated_at":"2025-06-30T10:01:13.000000Z","inspection_violations":[{"id":14474598,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079047","seq_no":"1","part_no":"392","part_no_section":"71A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD21653","created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:50.000000Z","normalized_code":"39271AD"},{"id":14474599,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079048","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207592386","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:50.000000Z","normalized_code":"3922SLLEQP"},{"id":14474600,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079049","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207592386","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD21654","created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:50.000000Z","normalized_code":"3922SLLSR"},{"id":14474601,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079050","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"1","insp_unit_id":"207592386","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:50.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":14474602,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079051","seq_no":"5","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"207592386","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:50.000000Z","normalized_code":"393203CCBP"},{"id":14474603,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079052","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"207592387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:51.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":14474604,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079053","seq_no":"7","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"207592387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:51.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":14474605,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079054","seq_no":"8","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"207592387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:51.000000Z","normalized_code":"39311BCSSRR"},{"id":14474606,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079055","seq_no":"9","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"207592387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:51.000000Z","normalized_code":"39311BCSLRR"},{"id":14474607,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_violation_id":"267079056","seq_no":"10","part_no":"393","part_no_section":"11B-CSRIGRR","insp_viol_unit":"2","insp_unit_id":"207592387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:17:03.000000Z","updated_at":"2025-06-30T10:18:51.000000Z","normalized_code":"39311BCSRIGRR"}],"inspection_per_units":[{"id":14768701,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_unit_id":"207592386","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"9E37432","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV1ELFV3310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:29.000000Z","updated_at":"2025-07-01T09:48:51.000000Z"},{"id":14768702,"change_date":"2025-06-26 21:42:00","inspection_id":"85064427","insp_unit_id":"207592387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVE","insp_unit_company":"FB5","insp_unit_license":"4VA6677","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1R1F045211K510650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:29.000000Z","updated_at":"2025-07-01T09:48:51.000000Z"}]},{"id":8749593,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","dot_number":"3321080","report_state":"CA","report_number":"UGM6001836","insp_date":"2025-05-23 00:00:00","insp_start_time":"1446","insp_end_time":"1515","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"N\/B SR-99 JSO WHITE LANE","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"8","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15837518","transaction_code":"A","transaction_date":"2025-05-23 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-05-30T10:00:40.000000Z","updated_at":"2025-05-31T10:01:15.000000Z","inspection_violations":[{"id":13966858,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501052","seq_no":"5","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"207089225","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"39343BBATV"},{"id":13966859,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501053","seq_no":"6","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207089225","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"39360C"},{"id":13966860,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501054","seq_no":"7","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"207089226","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"39311BCSSRR"},{"id":13966861,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501055","seq_no":"8","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"207089226","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"39311BCSLRR"},{"id":13966862,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501056","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ99162","created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"39216D"},{"id":13966863,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501057","seq_no":"2","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RJ99162","created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"39141AMCPVI"},{"id":13966864,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501058","seq_no":"3","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"3922SLLDL"},{"id":13966865,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_violation_id":"266501059","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207089225","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ99163","created_at":"2025-05-30T10:16:02.000000Z","updated_at":"2025-05-31T10:18:15.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":14306701,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_unit_id":"207089225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15","insp_unit_license":"9G16329","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDR2DLFF4206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:40.000000Z","updated_at":"2025-05-31T09:47:52.000000Z"},{"id":14306702,"change_date":"2025-05-27 21:39:00","inspection_id":"84793285","insp_unit_id":"207089226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"4MK3243","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WWBGB6B7YM604043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:40.000000Z","updated_at":"2025-05-31T09:47:52.000000Z"}]},{"id":8206101,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","dot_number":"3321080","report_state":"CA","report_number":"UGM6001648","insp_date":"2025-03-24 00:00:00","insp_start_time":"1418","insp_end_time":"1445","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD AREA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","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-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15753940","transaction_code":"C","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2025-03-25 21:41:00","snet_input_date":"2025-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-25 21:41:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-03-28T10:15:17.000000Z","updated_at":"2025-03-30T10:36:43.000000Z","inspection_violations":[{"id":12886061,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267636","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ94934","created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"39216D"},{"id":12886062,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267637","seq_no":"2","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"206001396","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"39343BBATV"},{"id":12886063,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267638","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206001397","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ94935","created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"3922SLLSR"},{"id":12886064,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267639","seq_no":"4","part_no":"393","part_no_section":"13D2-CSLRR","insp_viol_unit":"2","insp_unit_id":"206001397","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"39313D2CSLRR"},{"id":12886065,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267640","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"206001397","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":12886066,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267641","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"206001397","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":12886067,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_violation_id":"265267642","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206001397","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T11:00:26.000000Z","updated_at":"2025-03-29T10:42:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13285315,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_unit_id":"206001396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"9G02079","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X8GD307715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:12:35.000000Z","updated_at":"2025-03-30T10:09:26.000000Z"},{"id":13285316,"change_date":"2025-03-26 21:41:00","inspection_id":"84220685","insp_unit_id":"206001397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRMBD","insp_unit_company":null,"insp_unit_license":"1WK1522","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"FBMB8EB42J0000987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:12:35.000000Z","updated_at":"2025-03-30T10:09:26.000000Z"}]},{"id":7138364,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","dot_number":"3321080","report_state":"CA","report_number":"NBBJ998902","insp_date":"2024-11-05 00:00:00","insp_start_time":"1149","insp_end_time":"1227","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CA HAY","shipping_paper_number":"241567","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-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15584193","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2024-11-06 21:40:00","snet_input_date":"2024-11-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-06 21:40:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:43.000000Z","updated_at":"2025-03-17T20:44:43.000000Z","inspection_violations":[{"id":11150810,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_violation_id":"262769224","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"203770426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RP06438","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3939ALFTSI"},{"id":11150811,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_violation_id":"262769225","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"203770426","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39345B2BHTD"},{"id":11150812,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_violation_id":"262769226","seq_no":"3","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"203770426","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3965BHWSL"},{"id":11150813,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_violation_id":"262769227","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203770427","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39347E"},{"id":11150814,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_violation_id":"262769228","seq_no":"5","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":11513220,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_unit_id":"203770426","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01\/WHT","insp_unit_license":"9G02079","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X8GD307715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:17.000000Z","updated_at":"2025-03-17T23:42:17.000000Z"},{"id":11513221,"change_date":"2024-11-06 21:40:00","inspection_id":"83097518","insp_unit_id":"203770427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVE","insp_unit_company":"FB5\/SIL","insp_unit_license":"4VA6677","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1R1F045211K510650","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:17.000000Z","updated_at":"2025-03-17T23:42:17.000000Z"}]},{"id":4167918,"change_date":"2023-10-10 21:42:00","inspection_id":"79879185","dot_number":"3321080","report_state":"CA","report_number":"UDP0004563","insp_date":"2023-10-10 00:00:00","insp_start_time":"0600","insp_end_time":"0621","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"STOCKTON AREA","county_code_state":"CA","county_code":"077","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":"2023-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"15090654","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[{"id":6451520,"change_date":"2023-10-10 21:42:00","inspection_id":"79879185","insp_violation_id":"255759187","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197489316","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"3939A"},{"id":6451521,"change_date":"2023-10-10 21:42:00","inspection_id":"79879185","insp_violation_id":"255759188","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"197489317","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6702341,"change_date":"2023-10-10 21:42:00","inspection_id":"79879185","insp_unit_id":"197489315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/WHT","insp_unit_license":"9G16311","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV8BSB7916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:12.000000Z","updated_at":"2025-03-17T22:56:12.000000Z"},{"id":6702342,"change_date":"2023-10-10 21:42:00","inspection_id":"79879185","insp_unit_id":"197489316","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"BLK","insp_unit_license":"4BA6850","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"VVH421107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:12.000000Z","updated_at":"2025-03-17T22:56:12.000000Z"},{"id":6702343,"change_date":"2023-10-10 21:42:00","inspection_id":"79879185","insp_unit_id":"197489317","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"BLK","insp_unit_license":"4HD3785","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"VVJ456101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:12.000000Z","updated_at":"2025-03-17T22:56:12.000000Z"}]},{"id":3828916,"change_date":"2023-08-24 21:42:00","inspection_id":"79502225","dot_number":"3321080","report_state":"CA","report_number":"UBGO003672","insp_date":"2023-08-24 00:00:00","insp_start_time":"0830","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"SHAFTER","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15036077","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2023-08-24 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-24 21:42:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:31.000000Z","updated_at":"2025-03-17T19:38:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6156153,"change_date":"2023-08-24 21:42:00","inspection_id":"79502225","insp_unit_id":"196723022","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03","insp_unit_license":"9G16329","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDR2DLFF4206","insp_unit_decal":"Y","insp_unit_decal_number":"32865538","created_at":"2025-03-17T22:51:43.000000Z","updated_at":"2025-03-17T22:51:43.000000Z"}]},{"id":3493877,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","dot_number":"3321080","report_state":"CA","report_number":"NBBJ004892","insp_date":"2023-07-11 00:00:00","insp_start_time":"0832","insp_end_time":"0925","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WILDWOOD","shipping_paper_number":"172266","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-07-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"11","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14977184","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2023-07-12 21:41:00","snet_input_date":"2023-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-12 21:41:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[{"id":5388659,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027310","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39347E"},{"id":5388660,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027311","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3963A1"},{"id":5388661,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027312","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3963A1"},{"id":5388662,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027313","seq_no":"8","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"393201A"},{"id":5388663,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027314","seq_no":"9","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195967497","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39345B2"},{"id":5388664,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027315","seq_no":"10","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195967497","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39345B2"},{"id":5388665,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027316","seq_no":"11","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195967497","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3965B"},{"id":5388666,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027317","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195967497","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"},{"id":5388667,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027318","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3939A"},{"id":5388668,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027319","seq_no":"3","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39375A4"},{"id":5388669,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_violation_id":"254027320","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195967498","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5618224,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_unit_id":"195967497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"\/WHT 3X","insp_unit_license":"9G16329","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDR2DLFF4206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:20.000000Z","updated_at":"2025-03-17T22:47:20.000000Z"},{"id":5618225,"change_date":"2023-07-12 21:41:00","inspection_id":"79127395","insp_unit_id":"195967498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"\/BLK 2X F\/B","insp_unit_license":"4DS3053","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJF482F4YS693449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:20.000000Z","updated_at":"2025-03-17T22:47:20.000000Z"}]},{"id":2175136,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","dot_number":"3321080","report_state":"CA","report_number":"UE5Z004837","insp_date":"2023-01-17 00:00:00","insp_start_time":"0426","insp_end_time":"0500","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"PICO CYN AND MARRIOTT WAY","county_code_state":"CA","county_code":"037","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-01-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14742424","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2023-01-18 21:41:00","snet_input_date":"2023-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-18 21:41:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[{"id":3361832,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_violation_id":"250646757","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192942357","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LJ24993","created_at":"2025-03-17T21:22:54.000000Z","updated_at":"2025-03-17T21:22:54.000000Z","normalized_code":"3939A"},{"id":3361833,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_violation_id":"250646758","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192942357","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:54.000000Z","updated_at":"2025-03-17T21:22:54.000000Z","normalized_code":"3939A"},{"id":3361834,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_violation_id":"250646759","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192942358","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:54.000000Z","updated_at":"2025-03-17T21:22:54.000000Z","normalized_code":"39311"},{"id":3361835,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_violation_id":"250646760","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192942358","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:54.000000Z","updated_at":"2025-03-17T21:22:54.000000Z","normalized_code":"3939A"},{"id":3361836,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_violation_id":"250646761","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"DA207359","created_at":"2025-03-17T21:22:54.000000Z","updated_at":"2025-03-17T21:22:54.000000Z","normalized_code":"39141A"},{"id":3361837,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_violation_id":"250646762","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192942357","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:54.000000Z","updated_at":"2025-03-17T21:22:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3500915,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_unit_id":"192942357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"9F90522","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDV5DSBV5818","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":3500916,"change_date":"2023-01-18 21:41:00","inspection_id":"77632548","insp_unit_id":"192942358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"4MK3243","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WWBGB6B7YM604043","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":1874114,"change_date":"2022-12-05 21:40:00","inspection_id":"77288039","dot_number":"3321080","report_state":"CA","report_number":"NBP7004091","insp_date":"2022-12-02 00:00:00","insp_start_time":"1029","insp_end_time":"1039","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO CVEF N\/B","county_code_state":"CA","county_code":"111","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-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"104700","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":"14695466","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:08.000000Z","updated_at":"2025-03-17T19:01:08.000000Z","inspection_violations":[{"id":2918854,"change_date":"2022-12-05 21:40:00","inspection_id":"77288039","insp_violation_id":"249926147","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192266080","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1","created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3016618,"change_date":"2022-12-05 21:40:00","inspection_id":"77288039","insp_unit_id":"192266079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"9G16311","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV8BSB7916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"},{"id":3016619,"change_date":"2022-12-05 21:40:00","inspection_id":"77288039","insp_unit_id":"192266080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02","insp_unit_license":"4NF3577","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2489YA983316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:39.000000Z","updated_at":"2025-03-17T22:27:39.000000Z"}]},{"id":1875520,"change_date":"2022-12-05 21:40:00","inspection_id":"77289590","dot_number":"3321080","report_state":"CA","report_number":"NEDJ000831","insp_date":"2022-12-02 00:00:00","insp_start_time":"0312","insp_end_time":"0342","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"104700","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":"14695200","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03321080","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ERICA MEDRANO","insp_carrier_street":"760 KYRA AVE","insp_carrier_city":"MC FARLAND","insp_carrier_state":"CA","insp_carrier_zip_code":"93250","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"576672","created_at":"2025-03-17T19:01:08.000000Z","updated_at":"2025-03-17T19:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3018821,"change_date":"2022-12-05 21:40:00","inspection_id":"77289590","insp_unit_id":"192268599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"9G16311","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUBGBDV8BSBA7916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:40.000000Z","updated_at":"2025-03-17T22:27:40.000000Z"},{"id":3018822,"change_date":"2022-12-05 21:40:00","inspection_id":"77289590","insp_unit_id":"192268600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02","insp_unit_license":"4NF3577","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2489YA983316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:40.000000Z","updated_at":"2025-03-17T22:27:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3321080\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3321080\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3321080\/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\/3321080\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}