{"current_page":1,"data":[{"id":12079461,"change_date":"2026-06-02 21:41:00","inspection_id":"88022145","dot_number":"1593734","report_state":"CA","report_number":"NAQG008495","insp_date":"2026-05-26 00:00:00","insp_start_time":"1300","insp_end_time":"1345","registration_date":null,"region":"PS","ci_status_code":"C","location":"626","location_desc":"CA","county_code_state":"CA","county_code":"025","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3452205","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:30.000000Z","updated_at":"2026-06-13T09:31:49.000000Z","inspection_violations":[{"id":21018540,"change_date":"2026-06-02 21:41:00","inspection_id":"88022145","insp_violation_id":"274648882","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213875665","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:26.000000Z","updated_at":"2026-06-13T09:44:04.000000Z","normalized_code":"39353BB"},{"id":21018541,"change_date":"2026-06-02 21:41:00","inspection_id":"88022145","insp_violation_id":"274648883","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213875664","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:26.000000Z","updated_at":"2026-06-13T09:44:04.000000Z","normalized_code":"39395A4EEUS"},{"id":21018539,"change_date":"2026-06-02 21:41:00","inspection_id":"88022145","insp_violation_id":"274648881","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213875665","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:26.000000Z","updated_at":"2026-06-13T09:44:04.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":20990861,"change_date":"2026-06-02 21:41:00","inspection_id":"88022145","insp_unit_id":"213875664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/3X","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"Y","insp_unit_decal_number":"36227656","created_at":"2026-06-06T09:17:29.000000Z","updated_at":"2026-06-13T09:03:14.000000Z"},{"id":20990862,"change_date":"2026-06-02 21:41:00","inspection_id":"88022145","insp_unit_id":"213875665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KALY","insp_unit_company":null,"insp_unit_license":"4JN4530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DDKF4823Y1000046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:29.000000Z","updated_at":"2026-06-13T09:03:14.000000Z"}]},{"id":12009591,"change_date":"2026-05-25 21:34:00","inspection_id":"87948579","dot_number":"1593734","report_state":"CA","report_number":"NA2H010828","insp_date":"2026-05-19 00:00:00","insp_start_time":"1006","insp_end_time":"1046","registration_date":null,"region":"PS","ci_status_code":"C","location":"626","location_desc":"CA","county_code_state":"CA","county_code":"025","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-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"3396621","transaction_code":"A","transaction_date":"2026-05-25 00:00:00","upload_date":"2026-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2026-05-25 21:34:00","snet_input_date":"2026-05-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-25 21:34:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-28T09:39:22.000000Z","updated_at":"2026-06-06T09:30:20.000000Z","inspection_violations":[{"id":20895458,"change_date":"2026-05-25 21:34:00","inspection_id":"87948579","insp_violation_id":"274480855","seq_no":"1","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"213735923","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:32.000000Z","updated_at":"2026-06-06T09:41:26.000000Z","normalized_code":"39311BCSSRR"}],"inspection_per_units":[{"id":20876388,"change_date":"2026-05-25 21:34:00","inspection_id":"87948579","insp_unit_id":"213735922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU\/206\/3X","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"36228012","created_at":"2026-05-28T09:16:46.000000Z","updated_at":"2026-06-06T09:01:33.000000Z"},{"id":20876389,"change_date":"2026-05-25 21:34:00","inspection_id":"87948579","insp_unit_id":"213735923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"BLU\/106\/2X","insp_unit_license":"4CP5242","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C3S1568766","insp_unit_decal":"Y","insp_unit_decal_number":"36228013","created_at":"2026-05-28T09:16:46.000000Z","updated_at":"2026-06-06T09:01:33.000000Z"}]},{"id":11952507,"change_date":"2026-05-18 21:40:00","inspection_id":"87888262","dot_number":"1593734","report_state":"US","report_number":"2049001533","insp_date":"2026-05-12 00:00:00","insp_start_time":"1537","insp_end_time":"1605","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IVEMSA","shipping_paper_number":"CTLI-00134","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3356507","transaction_code":"A","transaction_date":"2026-05-18 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2026-05-18 21:40:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-18 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:10.000000Z","updated_at":"2026-05-29T09:31:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20783106,"change_date":"2026-05-18 21:40:00","inspection_id":"87888262","insp_unit_id":"213623694","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN\/205\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:36.000000Z","updated_at":"2026-05-29T09:03:13.000000Z"},{"id":20783107,"change_date":"2026-05-18 21:40:00","inspection_id":"87888262","insp_unit_id":"213623695","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"BLU\/ 302","insp_unit_license":"4JL5037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y2SL237173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:36.000000Z","updated_at":"2026-05-29T09:03:13.000000Z"}]},{"id":11924644,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","dot_number":"1593734","report_state":"CA","report_number":"NDGS013303","insp_date":"2026-05-06 00:00:00","insp_start_time":"1430","insp_end_time":"1510","registration_date":null,"region":"PS","ci_status_code":"C","location":"626","location_desc":"CA","county_code_state":"CA","county_code":"025","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-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3329386","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:27.000000Z","updated_at":"2026-05-26T09:30:57.000000Z","inspection_violations":[{"id":20742601,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","insp_violation_id":"274281733","seq_no":"1","part_no":"393","part_no_section":"201A-FRBFC","insp_viol_unit":"2","insp_unit_id":"213572255","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:43.000000Z","updated_at":"2026-05-26T09:43:41.000000Z","normalized_code":"393201AFRBFC"},{"id":20742602,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","insp_violation_id":"274281734","seq_no":"2","part_no":"393","part_no_section":"75A1-TBSP","insp_viol_unit":"2","insp_unit_id":"213572255","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:43.000000Z","updated_at":"2026-05-26T09:43:41.000000Z","normalized_code":"39375A1TBSP"},{"id":20742603,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","insp_violation_id":"274281735","seq_no":"3","part_no":"393","part_no_section":"207F-SASMD","insp_viol_unit":"1","insp_unit_id":"213572254","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-18T10:00:43.000000Z","updated_at":"2026-05-26T09:43:41.000000Z","normalized_code":"393207FSASMD"},{"id":20742604,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","insp_violation_id":"274281736","seq_no":"4","part_no":"393","part_no_section":"11A1-LTNRV","insp_viol_unit":"1","insp_unit_id":"213572254","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:43.000000Z","updated_at":"2026-05-26T09:43:41.000000Z","normalized_code":"39311A1LTNRV"}],"inspection_per_units":[{"id":20738241,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","insp_unit_id":"213572254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED# 207","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:37.000000Z","updated_at":"2026-05-26T09:03:04.000000Z"},{"id":20738242,"change_date":"2026-05-15 21:44:00","inspection_id":"87858978","insp_unit_id":"213572255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT# 301","insp_unit_license":"4JF4731","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y3SL315816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:37.000000Z","updated_at":"2026-05-26T09:03:04.000000Z"}]},{"id":10795146,"change_date":"2026-01-16 21:40:00","inspection_id":"86821412","dot_number":"1593734","report_state":"CA","report_number":"UDRH000016","insp_date":"2026-01-14 00:00:00","insp_start_time":"1955","insp_end_time":"2025","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-01-16 21:40: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":"16133614","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-16 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:37:01.000000Z","updated_at":"2026-01-27T10:31:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18124274,"change_date":"2026-01-16 21:40:00","inspection_id":"86821412","insp_unit_id":"211143705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"Y","insp_unit_decal_number":"35916828","created_at":"2026-01-19T10:09:31.000000Z","updated_at":"2026-01-27T10:01:14.000000Z"}]},{"id":10794980,"change_date":"2026-01-16 21:40:00","inspection_id":"86821245","dot_number":"1593734","report_state":"CA","report_number":"NFQE000203","insp_date":"2026-01-13 00:00:00","insp_start_time":"1843","insp_end_time":"1912","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO ENFORCEMENT FACILITY","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ACTION GYPSUM SUPPLY WEST LP","shipping_paper_number":"FAEMX16643","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16133682","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-16 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:37:01.000000Z","updated_at":"2026-01-27T10:31:05.000000Z","inspection_violations":[{"id":18038956,"change_date":"2026-01-16 21:40:00","inspection_id":"86821245","insp_violation_id":"271265952","seq_no":"1","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"211143424","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:45.000000Z","updated_at":"2026-01-27T10:31:50.000000Z","normalized_code":"393207ASTBW"}],"inspection_per_units":[{"id":18124012,"change_date":"2026-01-16 21:40:00","inspection_id":"86821245","insp_unit_id":"211143424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/X3\/\/207","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:31.000000Z","updated_at":"2026-01-27T10:01:13.000000Z"},{"id":18124013,"change_date":"2026-01-16 21:40:00","inspection_id":"86821245","insp_unit_id":"211143425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"ALUMN\/X2","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"Y","insp_unit_decal_number":"35916820","created_at":"2026-01-19T10:09:31.000000Z","updated_at":"2026-01-27T10:01:13.000000Z"}]},{"id":10782628,"change_date":"2026-01-15 21:41:00","inspection_id":"86808407","dot_number":"1593734","report_state":"CA","report_number":"NB4B011488","insp_date":"2026-01-12 00:00:00","insp_start_time":"1231","insp_end_time":"1250","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO EF","county_code_state":"CA","county_code":"025","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-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"16131845","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:30.000000Z","updated_at":"2026-01-26T10:31:14.000000Z","inspection_violations":[{"id":18017714,"change_date":"2026-01-15 21:41:00","inspection_id":"86808407","insp_violation_id":"271240641","seq_no":"1","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"211118992","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:04:49.000000Z","updated_at":"2026-01-26T10:32:06.000000Z","normalized_code":"3965BHWSL"},{"id":18017715,"change_date":"2026-01-15 21:41:00","inspection_id":"86808407","insp_violation_id":"271240642","seq_no":"2","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"211118992","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:04:49.000000Z","updated_at":"2026-01-26T10:32:06.000000Z","normalized_code":"393207ASTBW"}],"inspection_per_units":[{"id":18102414,"change_date":"2026-01-15 21:41:00","inspection_id":"86808407","insp_unit_id":"211118992","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:43.000000Z","updated_at":"2026-01-26T10:01:26.000000Z"}]},{"id":10613879,"change_date":"2026-01-09 21:39:00","inspection_id":"86753882","dot_number":"1593734","report_state":"CA","report_number":"NFQV000252","insp_date":"2026-01-06 00:00:00","insp_start_time":"1425","insp_end_time":"1438","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLOSE THE LOOP GROUP USA INC","shipping_paper_number":"CTLPT-00102","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-01-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16123569","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-09 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:50.000000Z","updated_at":"2026-01-20T10:30:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17795148,"change_date":"2026-01-09 21:39:00","inspection_id":"86753882","insp_unit_id":"211005948","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 3X","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:50.000000Z","updated_at":"2026-01-20T10:01:06.000000Z"},{"id":17795149,"change_date":"2026-01-09 21:39:00","inspection_id":"86753882","insp_unit_id":"211005949","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT 2X","insp_unit_license":"4JF4731","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y3SL315816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:50.000000Z","updated_at":"2026-01-20T10:01:06.000000Z"}]},{"id":10197786,"change_date":"2025-11-14 21:40:00","inspection_id":"86318456","dot_number":"1593734","report_state":"US","report_number":"2049001010","insp_date":"2025-11-13 00:00:00","insp_start_time":"1015","insp_end_time":"1102","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2541084","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:23.000000Z","updated_at":"2025-11-18T10:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16987679,"change_date":"2025-11-14 21:40:00","inspection_id":"86318456","insp_unit_id":"210022474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN\/205\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"35741254","created_at":"2025-11-17T10:01:19.000000Z","updated_at":"2025-11-18T10:00:55.000000Z"},{"id":16987680,"change_date":"2025-11-14 21:40:00","inspection_id":"86318456","insp_unit_id":"210022475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"302","insp_unit_license":"4JL5037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y2SL237173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:19.000000Z","updated_at":"2025-11-18T10:00:55.000000Z"}]},{"id":9948338,"change_date":"2025-10-15 21:39:00","inspection_id":"86055812","dot_number":"1593734","report_state":"US","report_number":"1943001426","insp_date":"2025-10-14 00:00:00","insp_start_time":"1303","insp_end_time":"1339","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"3","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":"2416722","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:54.000000Z","updated_at":"2025-10-19T10:00:46.000000Z","inspection_violations":[{"id":16426860,"change_date":"2025-10-15 21:39:00","inspection_id":"86055812","insp_violation_id":"269313861","seq_no":"1","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"209482013","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:01.000000Z","updated_at":"2025-10-19T10:16:23.000000Z","normalized_code":"3963A1OAL"},{"id":16426861,"change_date":"2025-10-15 21:39:00","inspection_id":"86055812","insp_violation_id":"269313862","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209482013","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CHP DA663423","created_at":"2025-10-18T10:18:01.000000Z","updated_at":"2025-10-19T10:16:23.000000Z","normalized_code":"39360C"},{"id":16426862,"change_date":"2025-10-15 21:39:00","inspection_id":"86055812","insp_violation_id":"269313863","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209482013","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:01.000000Z","updated_at":"2025-10-19T10:16:23.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":16515492,"change_date":"2025-10-15 21:39:00","inspection_id":"86055812","insp_unit_id":"209482013","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN\/205\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:12.000000Z","updated_at":"2025-10-19T09:45:58.000000Z"},{"id":16515493,"change_date":"2025-10-15 21:39:00","inspection_id":"86055812","insp_unit_id":"209482014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"302","insp_unit_license":"4JL5037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y2SL237173","insp_unit_decal":"Y","insp_unit_decal_number":"35741020","created_at":"2025-10-18T09:47:12.000000Z","updated_at":"2025-10-19T09:45:58.000000Z"}]},{"id":9898219,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","dot_number":"1593734","report_state":"US","report_number":"2049000856","insp_date":"2025-10-08 00:00:00","insp_start_time":"0827","insp_end_time":"0930","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2388857","transaction_code":"A","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-10-09 21:40:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-09 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:01:55.000000Z","updated_at":"2025-10-13T10:00:59.000000Z","inspection_violations":[{"id":16327698,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_violation_id":"269203936","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209384413","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:30.000000Z","updated_at":"2025-10-13T10:16:37.000000Z","normalized_code":"3965BL"},{"id":16327699,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_violation_id":"269203937","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"209384413","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CHPRN41836","created_at":"2025-10-12T10:17:30.000000Z","updated_at":"2025-10-13T10:16:37.000000Z","normalized_code":"39345DB"},{"id":16327700,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_violation_id":"269203938","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209384413","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CHPRN41836","created_at":"2025-10-12T10:17:30.000000Z","updated_at":"2025-10-13T10:16:37.000000Z","normalized_code":"39375A3TAOL"},{"id":16327701,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_violation_id":"269203939","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"209384414","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CHPRN41836","created_at":"2025-10-12T10:17:30.000000Z","updated_at":"2025-10-13T10:16:37.000000Z","normalized_code":"39375A3TAOL"},{"id":16327702,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_violation_id":"269203940","seq_no":"5","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"209384413","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CHPRN41836","created_at":"2025-10-12T10:17:30.000000Z","updated_at":"2025-10-13T10:16:37.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":16424506,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_unit_id":"209384413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN\/205\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:18.000000Z","updated_at":"2025-10-13T09:46:07.000000Z"},{"id":16424507,"change_date":"2025-10-09 21:40:00","inspection_id":"86002538","insp_unit_id":"209384414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"WHT\/2X","insp_unit_license":"4JF4731","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y3SL315816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:18.000000Z","updated_at":"2025-10-13T09:46:07.000000Z"}]},{"id":9869957,"change_date":"2025-10-06 21:41:00","inspection_id":"85972919","dot_number":"1593734","report_state":"CA","report_number":"NB4B011017","insp_date":"2025-10-02 00:00:00","insp_start_time":"1209","insp_end_time":"1230","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO EF","county_code_state":"CA","county_code":"025","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-10-06 21:41: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":"16007136","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:58.000000Z","updated_at":"2025-10-10T10:01:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16371534,"change_date":"2025-10-06 21:41:00","inspection_id":"85972919","insp_unit_id":"209327857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLUE","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"35634817","created_at":"2025-10-09T09:45:54.000000Z","updated_at":"2025-10-10T09:47:14.000000Z"}]},{"id":9761450,"change_date":"2025-09-23 21:43:00","inspection_id":"85858884","dot_number":"1593734","report_state":"CA","report_number":"UDR3002580","insp_date":"2025-09-22 00:00:00","insp_start_time":"1700","insp_end_time":"1725","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"CALEXICO EAST PORT OF ENTRY","county_code_state":"CA","county_code":"025","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-09-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"15991401","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:52.000000Z","updated_at":"2025-09-26T10:00:59.000000Z","inspection_violations":[{"id":16041227,"change_date":"2025-09-23 21:43:00","inspection_id":"85858884","insp_violation_id":"268881771","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"209109891","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA663352","created_at":"2025-09-26T10:17:00.000000Z","updated_at":"2025-09-27T10:16:42.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":16169875,"change_date":"2025-09-23 21:43:00","inspection_id":"85858884","insp_unit_id":"209109891","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"16480","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:12.000000Z","updated_at":"2025-09-27T09:46:13.000000Z"}]},{"id":9623924,"change_date":"2025-09-08 21:39:00","inspection_id":"85714682","dot_number":"1593734","report_state":"CA","report_number":"NA2H009756","insp_date":"2025-09-04 00:00:00","insp_start_time":"1424","insp_end_time":"1452","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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":"2025-09-08 21:39: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":"15970682","transaction_code":"A","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-08 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:46:14.000000Z","updated_at":"2025-09-11T10:46:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15896526,"change_date":"2025-09-08 21:39:00","inspection_id":"85714682","insp_unit_id":"208811570","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN\/205\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:44.000000Z","updated_at":"2025-09-12T10:47:26.000000Z"}]},{"id":9349163,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","dot_number":"1593734","report_state":"AZ","report_number":"6575002028","insp_date":"2025-08-05 00:00:00","insp_start_time":"1340","insp_end_time":"1430","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"GILA BEND AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"2900 W LINCOLN ST","shipping_paper_number":"M080009","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"7","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":"2094607","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:30.000000Z","updated_at":"2025-08-12T10:42:30.000000Z","inspection_violations":[{"id":15182484,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883939","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208275630","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"39617CPI"},{"id":15182485,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883940","seq_no":"2","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"208275631","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"39311BCSLRR"},{"id":15182486,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883941","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"208275631","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"3939ALSML"},{"id":15182487,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883942","seq_no":"4","part_no":"393","part_no_section":"104F1-C","insp_viol_unit":"2","insp_unit_id":"208275631","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"393104F1C"},{"id":15182488,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883943","seq_no":"5","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"208275631","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"393104BC"},{"id":15182489,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883944","seq_no":"6","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-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"39524"},{"id":15182490,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_violation_id":"267883945","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208275631","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:32.000000Z","updated_at":"2025-08-11T10:43:59.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15401326,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_unit_id":"208275630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:17.000000Z","updated_at":"2025-08-11T09:45:21.000000Z"},{"id":15401327,"change_date":"2025-08-07 21:39:00","inspection_id":"85426087","insp_unit_id":"208275631","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"102","insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:17.000000Z","updated_at":"2025-08-11T09:45:21.000000Z"}]},{"id":9082697,"change_date":"2025-07-07 21:40:00","inspection_id":"85145785","dot_number":"1593734","report_state":"CA","report_number":"NDGS011911","insp_date":"2025-06-26 00:00:00","insp_start_time":"1615","insp_end_time":"1645","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA MX","shipping_paper_number":"21862242613","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"15887126","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:39.000000Z","updated_at":"2025-07-11T10:44:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14904957,"change_date":"2025-07-07 21:40:00","inspection_id":"85145785","insp_unit_id":"207739396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GREN#205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"35084215","created_at":"2025-07-10T09:45:28.000000Z","updated_at":"2025-07-11T09:46:21.000000Z"},{"id":14904958,"change_date":"2025-07-07 21:40:00","inspection_id":"85145785","insp_unit_id":"207739397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"FB 102","insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:28.000000Z","updated_at":"2025-07-11T09:46:21.000000Z"}]},{"id":8663686,"change_date":"2025-05-16 21:43:00","inspection_id":"84702419","dot_number":"1593734","report_state":"CA","report_number":"NAQG007467","insp_date":"2025-05-14 00:00:00","insp_start_time":"1819","insp_end_time":"1827","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ROOFING WHOLESALE","shipping_paper_number":"21862205560","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-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15824217","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-16 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:35.000000Z","updated_at":"2025-05-20T10:06:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14151343,"change_date":"2025-05-16 21:43:00","inspection_id":"84702419","insp_unit_id":"206918248","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED\/3X\/","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-19T09:50:44.000000Z","updated_at":"2025-05-20T09:52:39.000000Z"},{"id":14151344,"change_date":"2025-05-16 21:43:00","inspection_id":"84702419","insp_unit_id":"206918249","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"BLK\/2X","insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"Y","insp_unit_decal_number":"35083517","created_at":"2025-05-19T09:50:44.000000Z","updated_at":"2025-05-20T09:52:39.000000Z"}]},{"id":8396477,"change_date":"2025-04-16 21:41:00","inspection_id":"84421074","dot_number":"1593734","report_state":"CA","report_number":"NABI008302","insp_date":"2025-04-15 00:00:00","insp_start_time":"1340","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","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-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15783006","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":"343802","created_at":"2025-04-19T10:19:39.000000Z","updated_at":"2025-04-20T10:26:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13629725,"change_date":"2025-04-16 21:41:00","inspection_id":"84421074","insp_unit_id":"206351577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"Y","insp_unit_decal_number":"35085899","created_at":"2025-04-19T10:12:25.000000Z","updated_at":"2025-04-20T10:05:35.000000Z"},{"id":13629726,"change_date":"2025-04-16 21:41:00","inspection_id":"84421074","insp_unit_id":"206351578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"BK","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"Y","insp_unit_decal_number":"35085900","created_at":"2025-04-19T10:12:25.000000Z","updated_at":"2025-04-20T10:05:35.000000Z"}]},{"id":8207739,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","dot_number":"1593734","report_state":"AZ","report_number":"7112000162","insp_date":"2025-03-21 00:00:00","insp_start_time":"1014","insp_end_time":"1145","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"GOODYEAR AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142350","viol_total":"4","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":"1513753","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-29T10:21:03.000000Z","updated_at":"2025-03-30T10:34:31.000000Z","inspection_violations":[{"id":12873770,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","insp_violation_id":"265248472","seq_no":"1","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:53:17.000000Z","updated_at":"2025-03-29T10:32:17.000000Z","normalized_code":"3958E1PC"},{"id":12873771,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","insp_violation_id":"265248473","seq_no":"2","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:53:17.000000Z","updated_at":"2025-03-29T10:32:17.000000Z","normalized_code":"39282DUMT"},{"id":12873772,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","insp_violation_id":"265248474","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205984823","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:53:17.000000Z","updated_at":"2025-03-29T10:32:17.000000Z","normalized_code":"39617CPI"},{"id":12873773,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","insp_violation_id":"265248475","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"205984824","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:53:17.000000Z","updated_at":"2025-03-29T10:32:17.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":13272132,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","insp_unit_id":"205984824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHAP","insp_unit_company":"110","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:58.000000Z","updated_at":"2025-03-30T09:56:47.000000Z"},{"id":13272131,"change_date":"2025-03-26 21:40:00","inspection_id":"84222964","insp_unit_id":"205984823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"207","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:58.000000Z","updated_at":"2025-03-30T09:56:47.000000Z"}]},{"id":8124019,"change_date":"2025-03-14 21:41:00","inspection_id":"84134210","dot_number":"1593734","report_state":"CA","report_number":"ND3G006425","insp_date":"2025-03-13 00:00:00","insp_start_time":"1145","insp_end_time":"1240","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"INGETECNOS","shipping_paper_number":"00136580","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15740904","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-14 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":"343802","created_at":"2025-03-17T21:07:04.000000Z","updated_at":"2025-03-17T21:07:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13117081,"change_date":"2025-03-14 21:41:00","inspection_id":"84134210","insp_unit_id":"205816601","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"207\/RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-18T00:00:01.000000Z","updated_at":"2025-03-18T00:00:01.000000Z"},{"id":13117082,"change_date":"2025-03-14 21:41:00","inspection_id":"84134210","insp_unit_id":"205816602","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHAM","insp_unit_company":"2X\/BLACK","insp_unit_license":"4PK3367","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"TC12179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-18T00:00:01.000000Z","updated_at":"2025-03-18T00:00:01.000000Z"}]},{"id":7964361,"change_date":"2025-02-26 21:41:00","inspection_id":"83966319","dot_number":"1593734","report_state":"US","report_number":"1303001532","insp_date":"2025-02-25 00:00:00","insp_start_time":"1009","insp_end_time":"1027","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DRACO TRUCKING","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":"2025-02-26 21:41: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":"1403246","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-02-26 21:41:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:37.000000Z","updated_at":"2025-03-17T21:03:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12857095,"change_date":"2025-02-26 21:41:00","inspection_id":"83966319","insp_unit_id":"205506232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"BLU\/206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:01.000000Z","updated_at":"2025-03-17T23:57:01.000000Z"}]},{"id":7756287,"change_date":"2025-01-31 21:40:00","inspection_id":"83747861","dot_number":"1593734","report_state":"US","report_number":"1945001668","insp_date":"2025-01-29 00:00:00","insp_start_time":"1723","insp_end_time":"1758","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INTL SCAFFOLDING TOOL","shipping_paper_number":"DTAQ21862083355","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1309248","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:11.000000Z","updated_at":"2025-03-17T20:59:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12516973,"change_date":"2025-01-31 21:40:00","inspection_id":"83747861","insp_unit_id":"205098478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"34936962","created_at":"2025-03-17T23:53:11.000000Z","updated_at":"2025-03-17T23:53:11.000000Z"},{"id":12516974,"change_date":"2025-01-31 21:40:00","inspection_id":"83747861","insp_unit_id":"205098479","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KALYN CO.","insp_unit_company":"BLK\/105","insp_unit_license":"4JN4530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DDKF4823Y1000046","insp_unit_decal":"Y","insp_unit_decal_number":"34936963","created_at":"2025-03-17T23:53:11.000000Z","updated_at":"2025-03-17T23:53:11.000000Z"}]},{"id":7712697,"change_date":"2025-01-27 21:39:00","inspection_id":"83702035","dot_number":"1593734","report_state":"US","report_number":"1945001645","insp_date":"2025-01-22 00:00:00","insp_start_time":"1750","insp_end_time":"1837","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LW SUPPLY","shipping_paper_number":"DTAQ21862075633","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","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":"1292089","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-01-27 21:39:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-27 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:19.000000Z","updated_at":"2025-03-17T20:58:19.000000Z","inspection_violations":[{"id":12050335,"change_date":"2025-01-27 21:39:00","inspection_id":"83702035","insp_violation_id":"264182189","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"205013192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"39345DB"},{"id":12050336,"change_date":"2025-01-27 21:39:00","inspection_id":"83702035","insp_violation_id":"264182190","seq_no":"2","part_no":"395","part_no_section":"30B2-ELDDFC24","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:04:45.000000Z","updated_at":"2025-03-17T22:04:45.000000Z","normalized_code":"39530B2ELDDFC24"}],"inspection_per_units":[{"id":12446170,"change_date":"2025-01-27 21:39:00","inspection_id":"83702035","insp_unit_id":"205013192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:21.000000Z","updated_at":"2025-03-17T23:52:21.000000Z"},{"id":12446171,"change_date":"2025-01-27 21:39:00","inspection_id":"83702035","insp_unit_id":"205013193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KALYN CO.","insp_unit_company":"BLK\/105","insp_unit_license":"4JN4530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DDKF4823Y1000046","insp_unit_decal":"Y","insp_unit_decal_number":"34936940","created_at":"2025-03-17T23:52:21.000000Z","updated_at":"2025-03-17T23:52:21.000000Z"}]},{"id":7666572,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","dot_number":"1593734","report_state":"AZ","report_number":"6575001397","insp_date":"2025-01-17 00:00:00","insp_start_time":"0834","insp_end_time":"0930","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZYUMA","location_desc":"YUMA AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA","shipping_paper_number":"8518428","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142350","viol_total":"5","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":"1270959","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:26.000000Z","updated_at":"2025-03-17T20:57:26.000000Z","inspection_violations":[{"id":11979170,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_violation_id":"264090457","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204924485","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39617CPI"},{"id":11979171,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_violation_id":"264090458","seq_no":"2","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:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39524"},{"id":11979172,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_violation_id":"264090459","seq_no":"3","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"204924486","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39311BCSLRR"},{"id":11979173,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_violation_id":"264090460","seq_no":"4","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"204924485","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3939ALBL"},{"id":11979174,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_violation_id":"264090461","seq_no":"5","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"2","insp_unit_id":"204924486","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39347D2BLTBD"}],"inspection_per_units":[{"id":12371006,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_unit_id":"204924485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"206-BLU","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"34940237","created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"},{"id":12371007,"change_date":"2025-01-21 21:39:00","inspection_id":"83653737","insp_unit_id":"204924486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHAPERALLE","insp_unit_company":"110\/FLTBD","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"}]},{"id":7358611,"change_date":"2024-12-06 21:44:00","inspection_id":"83330251","dot_number":"1593734","report_state":"CA","report_number":"NDRG006722","insp_date":"2024-12-03 00:00:00","insp_start_time":"1427","insp_end_time":"1446","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-12-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15619355","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-06 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:26.000000Z","updated_at":"2025-03-17T20:49:26.000000Z","inspection_violations":[{"id":11499375,"change_date":"2024-12-06 21:44:00","inspection_id":"83330251","insp_violation_id":"263305751","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204244321","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11870167,"change_date":"2024-12-06 21:44:00","inspection_id":"83330251","insp_unit_id":"204244321","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:06.000000Z","updated_at":"2025-03-17T23:46:06.000000Z"}]},{"id":7120315,"change_date":"2024-11-04 21:41:00","inspection_id":"83078443","dot_number":"1593734","report_state":"CA","report_number":"UEDZ001021","insp_date":"2024-11-03 00:00:00","insp_start_time":"1855","insp_end_time":"1936","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA","shipping_paper_number":"8494715","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15582153","transaction_code":"A","transaction_date":"2024-11-03 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:37.000000Z","updated_at":"2025-03-17T20:44:37.000000Z","inspection_violations":[{"id":11119890,"change_date":"2024-11-04 21:41:00","inspection_id":"83078443","insp_violation_id":"262726088","seq_no":"1","part_no":"395","part_no_section":"24C2II-ELDTN","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-17T21:59:55.000000Z","updated_at":"2025-03-17T21:59:55.000000Z","normalized_code":"39524C2IIELDTN"},{"id":11119891,"change_date":"2024-11-04 21:41:00","inspection_id":"83078443","insp_violation_id":"262726089","seq_no":"2","part_no":"395","part_no_section":"24C2III-ELDSDN","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-17T21:59:55.000000Z","updated_at":"2025-03-17T21:59:55.000000Z","normalized_code":"39524C2IIIELDSDN"}],"inspection_per_units":[{"id":11484101,"change_date":"2024-11-04 21:41:00","inspection_id":"83078443","insp_unit_id":"203734639","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN\/205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:58.000000Z","updated_at":"2025-03-17T23:41:58.000000Z"},{"id":11484102,"change_date":"2024-11-04 21:41:00","inspection_id":"83078443","insp_unit_id":"203734640","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KALY","insp_unit_company":"BLK\/105","insp_unit_license":"4JN4530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DDKF4823Y1000046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:58.000000Z","updated_at":"2025-03-17T23:41:58.000000Z"}]},{"id":6958782,"change_date":"2024-10-15 21:42:00","inspection_id":"82906964","dot_number":"1593734","report_state":"US","report_number":"1303001287","insp_date":"2024-10-14 00:00:00","insp_start_time":"0835","insp_end_time":"0904","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DRACO TRUCKING","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":"2024-10-15 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":"947252","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:04.000000Z","updated_at":"2025-03-17T20:41:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11223851,"change_date":"2024-10-15 21:42:00","inspection_id":"82906964","insp_unit_id":"203408468","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"BLU\/206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"34620157","created_at":"2025-03-17T23:39:11.000000Z","updated_at":"2025-03-17T23:39:11.000000Z"}]},{"id":6393756,"change_date":"2024-08-05 21:43:00","inspection_id":"82305163","dot_number":"1593734","report_state":"CA","report_number":"NA2H008274","insp_date":"2024-07-30 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-08-05 21:43: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":"15470092","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:31.000000Z","updated_at":"2025-03-17T20:29:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10304326,"change_date":"2024-08-05 21:43:00","inspection_id":"82305163","insp_unit_id":"202242197","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU\/206\/3X","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"34182602","created_at":"2025-03-17T23:29:45.000000Z","updated_at":"2025-03-17T23:29:45.000000Z"}]},{"id":6395272,"change_date":"2024-08-05 21:43:00","inspection_id":"82306712","dot_number":"1593734","report_state":"CA","report_number":"UC6J002133","insp_date":"2024-07-24 00:00:00","insp_start_time":"1050","insp_end_time":"1110","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-05 21:43: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":"15469736","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:32.000000Z","updated_at":"2025-03-17T20:29:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10306550,"change_date":"2024-08-05 21:43:00","inspection_id":"82306712","insp_unit_id":"202244543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XT","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:49.000000Z","updated_at":"2025-03-17T23:29:49.000000Z"}]},{"id":6179433,"change_date":"2024-07-09 21:44:00","inspection_id":"82075657","dot_number":"1593734","report_state":"CA","report_number":"NB4B008872","insp_date":"2024-07-01 00:00:00","insp_start_time":"0942","insp_end_time":"0953","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO EF","county_code_state":"CA","county_code":"025","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-07-09 21:44: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":"15432720","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-09 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:04.000000Z","updated_at":"2025-03-17T20:25:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9954713,"change_date":"2024-07-09 21:44:00","inspection_id":"82075657","insp_unit_id":"201804341","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":6078132,"change_date":"2024-06-26 21:42:00","inspection_id":"81966658","dot_number":"1593734","report_state":"AZ","report_number":"XC42400107","insp_date":"2024-06-20 00:00:00","insp_start_time":"1846","insp_end_time":"1917","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"YUMA AZ","county_code_state":"AZ","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LW SUPPLY","shipping_paper_number":"DTAQ21861896203","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":"2024-06-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"601426","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2024-06-26 21:42:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-26 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:02.000000Z","updated_at":"2025-03-17T20:23:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9789837,"change_date":"2024-06-26 21:42:00","inspection_id":"81966658","insp_unit_id":"201594014","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:22.000000Z","updated_at":"2025-03-17T23:24:22.000000Z"},{"id":9789838,"change_date":"2024-06-26 21:42:00","inspection_id":"81966658","insp_unit_id":"201594015","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHAPERALLE","insp_unit_company":"110\/FLTBD","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:22.000000Z","updated_at":"2025-03-17T23:24:22.000000Z"}]},{"id":6064342,"change_date":"2024-06-24 21:43:00","inspection_id":"81951905","dot_number":"1593734","report_state":"CA","report_number":"NAS9009150","insp_date":"2024-06-19 00:00:00","insp_start_time":"1015","insp_end_time":"1021","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-24 21:43: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":"15416145","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-24 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:57.000000Z","updated_at":"2025-03-17T20:22:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9767676,"change_date":"2024-06-24 21:43:00","inspection_id":"81951905","insp_unit_id":"201564762","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN 205 3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:10.000000Z","updated_at":"2025-03-17T23:24:10.000000Z"}]},{"id":5530412,"change_date":"2024-04-17 21:41:00","inspection_id":"81372252","dot_number":"1593734","report_state":"US","report_number":"1303000959","insp_date":"2024-04-13 00:00:00","insp_start_time":"1015","insp_end_time":"1047","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FANOSA","shipping_paper_number":"FAEMX10241","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"405683","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2024-04-17 21:41:00","snet_input_date":"2024-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-17 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:21.000000Z","updated_at":"2025-03-17T20:12:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8908442,"change_date":"2024-04-17 21:41:00","inspection_id":"81372252","insp_unit_id":"200437461","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"GRN#205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"33934197","created_at":"2025-03-17T23:15:53.000000Z","updated_at":"2025-03-17T23:15:53.000000Z"},{"id":8908443,"change_date":"2024-04-17 21:41:00","inspection_id":"81372252","insp_unit_id":"200437462","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHAP","insp_unit_company":"ALU","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"Y","insp_unit_decal_number":"33934198","created_at":"2025-03-17T23:15:53.000000Z","updated_at":"2025-03-17T23:15:53.000000Z"}]},{"id":5463926,"change_date":"2024-04-08 21:44:00","inspection_id":"81299311","dot_number":"1593734","report_state":"CA","report_number":"NDRG005555","insp_date":"2024-04-05 00:00:00","insp_start_time":"1537","insp_end_time":"1547","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-08 21:44: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":"15310472","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:08.000000Z","updated_at":"2025-03-17T20:11:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8801235,"change_date":"2024-04-08 21:44:00","inspection_id":"81299311","insp_unit_id":"200296711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"}]},{"id":4957714,"change_date":"2024-02-01 21:44:00","inspection_id":"80747071","dot_number":"1593734","report_state":"CA","report_number":"NDGS009111","insp_date":"2024-01-25 00:00:00","insp_start_time":"1625","insp_end_time":"1650","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA","shipping_paper_number":"839384","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-02-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15222571","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-01 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7978856,"change_date":"2024-02-01 21:44:00","inspection_id":"80747071","insp_unit_id":"199228777","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN#205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"33554187","created_at":"2025-03-17T23:07:18.000000Z","updated_at":"2025-03-17T23:07:18.000000Z"},{"id":7978857,"change_date":"2024-02-01 21:44:00","inspection_id":"80747071","insp_unit_id":"199228778","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"BLK FB#103","insp_unit_license":"4HG3215","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1L01B5328X1137122","insp_unit_decal":"Y","insp_unit_decal_number":"33554188","created_at":"2025-03-17T23:07:18.000000Z","updated_at":"2025-03-17T23:07:18.000000Z"}]},{"id":4852459,"change_date":"2024-01-17 21:44:00","inspection_id":"80631783","dot_number":"1593734","report_state":"CA","report_number":"ND6V005874","insp_date":"2024-01-16 00:00:00","insp_start_time":"1140","insp_end_time":"1207","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","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-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15202270","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:51.000000Z","updated_at":"2025-03-17T19:58:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7807416,"change_date":"2024-01-17 21:44:00","inspection_id":"80631783","insp_unit_id":"199002678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"19451\/RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"Y","insp_unit_decal_number":"33563104","created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"},{"id":7807417,"change_date":"2024-01-17 21:44:00","inspection_id":"80631783","insp_unit_id":"199002679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHAP","insp_unit_company":"ALU","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"Y","insp_unit_decal_number":"33563105","created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"}]},{"id":4817916,"change_date":"2024-01-11 21:47:00","inspection_id":"80594139","dot_number":"1593734","report_state":"CA","report_number":"N8L2005125","insp_date":"2024-01-08 00:00:00","insp_start_time":"0842","insp_end_time":"0857","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-01-11 21:47: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":"15197675","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-11 21:47:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:04.000000Z","updated_at":"2025-03-17T19:58:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7751632,"change_date":"2024-01-11 21:47:00","inspection_id":"80594139","insp_unit_id":"198930570","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"206\/BLU","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:17.000000Z","updated_at":"2025-03-17T23:05:17.000000Z"}]},{"id":4726751,"change_date":"2024-01-02 21:44:00","inspection_id":"80494540","dot_number":"1593734","report_state":"NV","report_number":"7513019712","insp_date":"2023-12-27 00:00:00","insp_start_time":"1632","insp_end_time":"1650","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"ROADSIDE","county_code_state":"NV","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHAMPION RECYCLING","shipping_paper_number":"104091","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-02 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"753110","transaction_code":"C","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":"M","census_search_date":"2024-01-02 21:44:00","snet_input_date":"2023-12-27 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"DRACO TRUCKING","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:31.000000Z","updated_at":"2025-03-17T19:56:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7603398,"change_date":"2024-01-02 21:44:00","inspection_id":"80494540","insp_unit_id":"198769740","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"},{"id":7603399,"change_date":"2024-01-02 21:44:00","inspection_id":"80494540","insp_unit_id":"198769741","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KALY","insp_unit_company":null,"insp_unit_license":"4JN4530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C1KR112425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"}]},{"id":4345943,"change_date":"2023-11-02 21:43:00","inspection_id":"80075868","dot_number":"1593734","report_state":"CA","report_number":"NDRG004834","insp_date":"2023-10-30 00:00:00","insp_start_time":"1800","insp_end_time":"1815","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CELESTICA DE MEXICALI SA DE CV","shipping_paper_number":"1107419","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-11-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15121143","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-02 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:06.000000Z","updated_at":"2025-03-17T19:49:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6989387,"change_date":"2023-11-02 21:43:00","inspection_id":"80075868","insp_unit_id":"197888577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:39.000000Z","updated_at":"2025-03-17T22:58:39.000000Z"},{"id":6989388,"change_date":"2023-11-02 21:43:00","inspection_id":"80075868","insp_unit_id":"197888578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"BLK","insp_unit_license":"4CP5242","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C3S1568766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:39.000000Z","updated_at":"2025-03-17T22:58:39.000000Z"}]},{"id":4167193,"change_date":"2023-10-10 21:42:00","inspection_id":"79878419","dot_number":"1593734","report_state":"CA","report_number":"NAS9008373","insp_date":"2023-10-06 00:00:00","insp_start_time":"1006","insp_end_time":"1016","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-10 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":"15090868","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6701190,"change_date":"2023-10-10 21:42:00","inspection_id":"79878419","insp_unit_id":"197488052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT 203 3X","insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","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":4128293,"change_date":"2023-10-04 21:41:00","inspection_id":"79835450","dot_number":"1593734","report_state":"CA","report_number":"N8L2004784","insp_date":"2023-09-26 00:00:00","insp_start_time":"1246","insp_end_time":"1309","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15084304","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:27.000000Z","updated_at":"2025-03-17T19:44:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6637859,"change_date":"2023-10-04 21:41:00","inspection_id":"79835450","insp_unit_id":"197404028","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"207\/RED","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"Y","insp_unit_decal_number":"32894836","created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"},{"id":6637860,"change_date":"2023-10-04 21:41:00","inspection_id":"79835450","insp_unit_id":"197404029","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHPL","insp_unit_company":"110\/FLTBD","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"Y","insp_unit_decal_number":"32894837","created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"}]},{"id":3998949,"change_date":"2023-09-19 21:39:00","inspection_id":"79691474","dot_number":"1593734","report_state":"US","report_number":"1303000455","insp_date":"2023-09-16 00:00:00","insp_start_time":"1254","insp_end_time":"1321","registration_date":null,"region":"PD","ci_status_code":"C","location":"626","location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ITS BAJA MEXICO","shipping_paper_number":"242","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":"2023-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"1","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":"55117","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2023-09-19 21:39:00","snet_input_date":"2023-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-19 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:41.000000Z","updated_at":"2025-03-17T19:41:41.000000Z","inspection_violations":[{"id":6186833,"change_date":"2023-09-19 21:39:00","inspection_id":"79691474","insp_violation_id":"255336727","seq_no":"1","part_no":"393","part_no_section":"110B2I-C","insp_viol_unit":"2","insp_unit_id":"197112791","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CHP DA272599","created_at":"2025-03-17T21:35:53.000000Z","updated_at":"2025-03-17T21:35:53.000000Z","normalized_code":"393110B2IC"}],"inspection_per_units":[{"id":6430243,"change_date":"2023-09-19 21:39:00","inspection_id":"79691474","insp_unit_id":"197112790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:00.000000Z","updated_at":"2025-03-17T22:54:00.000000Z"},{"id":6430244,"change_date":"2023-09-19 21:39:00","inspection_id":"79691474","insp_unit_id":"197112791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"4CP5242","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C3S1568766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:00.000000Z","updated_at":"2025-03-17T22:54:00.000000Z"}]},{"id":3998889,"change_date":"2023-09-19 21:39:00","inspection_id":"79691411","dot_number":"1593734","report_state":"US","report_number":"1303000447","insp_date":"2023-09-14 00:00:00","insp_start_time":"1631","insp_end_time":"1648","registration_date":null,"region":"PD","ci_status_code":"C","location":"626","location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA","shipping_paper_number":"FAEMX7856","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":"2023-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"55133","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2023-09-19 21:39:00","snet_input_date":"2023-09-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-19 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:41.000000Z","updated_at":"2025-03-17T19:41:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6430138,"change_date":"2023-09-19 21:39:00","inspection_id":"79691411","insp_unit_id":"197112675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:00.000000Z","updated_at":"2025-03-17T22:54:00.000000Z"},{"id":6430139,"change_date":"2023-09-19 21:39:00","inspection_id":"79691411","insp_unit_id":"197112676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":null,"insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:00.000000Z","updated_at":"2025-03-17T22:54:00.000000Z"}]},{"id":3978228,"change_date":"2023-09-14 21:42:00","inspection_id":"79668625","dot_number":"1593734","report_state":"CA","report_number":"NB4B007452","insp_date":"2023-09-07 00:00:00","insp_start_time":"1741","insp_end_time":"1752","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO EF","county_code_state":"CA","county_code":"025","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-09-14 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":"15061041","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-14 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:15.000000Z","updated_at":"2025-03-17T19:41:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6397047,"change_date":"2023-09-14 21:42:00","inspection_id":"79668625","insp_unit_id":"197067138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLUE","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"}]},{"id":3872802,"change_date":"2023-08-30 21:45:00","inspection_id":"79551320","dot_number":"1593734","report_state":"CA","report_number":"NB4B007391","insp_date":"2023-08-28 00:00:00","insp_start_time":"1400","insp_end_time":"1410","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO EF","county_code_state":"CA","county_code":"025","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-30 21:45: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":"15044194","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-30 21:45:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:23.000000Z","updated_at":"2025-03-17T19:39:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6226402,"change_date":"2023-08-30 21:45:00","inspection_id":"79551320","insp_unit_id":"196828938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/203","insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"Y","insp_unit_decal_number":"32894464","created_at":"2025-03-17T22:52:19.000000Z","updated_at":"2025-03-17T22:52:19.000000Z"}]},{"id":3807217,"change_date":"2023-08-22 21:44:00","inspection_id":"79477996","dot_number":"1593734","report_state":"CA","report_number":"NDGS008173","insp_date":"2023-08-18 00:00:00","insp_start_time":"1820","insp_end_time":"1835","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA","shipping_paper_number":"21861582589","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-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15031198","transaction_code":"A","transaction_date":"2023-08-18 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-22 21:44:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:03.000000Z","updated_at":"2025-03-17T19:38:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6121621,"change_date":"2023-08-22 21:44:00","inspection_id":"79477996","insp_unit_id":"196675271","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU#206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:26.000000Z","updated_at":"2025-03-17T22:51:26.000000Z"},{"id":6121622,"change_date":"2023-08-22 21:44:00","inspection_id":"79477996","insp_unit_id":"196675272","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"FB#103","insp_unit_license":"4HG3215","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1L01B5328X1137122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:26.000000Z","updated_at":"2025-03-17T22:51:26.000000Z"}]},{"id":3667606,"change_date":"2023-08-03 21:41:00","inspection_id":"79322285","dot_number":"1593734","report_state":"CA","report_number":"NDGS008031","insp_date":"2023-07-27 00:00:00","insp_start_time":"1840","insp_end_time":"1855","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA MX","shipping_paper_number":"2186156079","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15006155","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-03 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:17.000000Z","updated_at":"2025-03-17T19:35:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5896817,"change_date":"2023-08-03 21:41:00","inspection_id":"79322285","insp_unit_id":"196357850","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU#206","insp_unit_license":"YP191287","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:34.000000Z","updated_at":"2025-03-17T22:49:34.000000Z"},{"id":5896818,"change_date":"2023-08-03 21:41:00","inspection_id":"79322285","insp_unit_id":"196357851","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"FB #109","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:34.000000Z","updated_at":"2025-03-17T22:49:34.000000Z"}]},{"id":3414794,"change_date":"2023-06-30 21:40:00","inspection_id":"79038383","dot_number":"1593734","report_state":"NV","report_number":"7513019360","insp_date":"2023-06-29 00:00:00","insp_start_time":"1258","insp_end_time":"1310","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"ROADSIDE","county_code_state":"NV","county_code":"003","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-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"740451","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-29 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"DRACO TRUCKING","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:36.000000Z","updated_at":"2025-03-17T19:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5490404,"change_date":"2023-06-30 21:40:00","inspection_id":"79038383","insp_unit_id":"195785473","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"},{"id":5490405,"change_date":"2023-06-30 21:40:00","inspection_id":"79038383","insp_unit_id":"195785474","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":3289518,"change_date":"2023-06-15 21:41:00","inspection_id":"78897344","dot_number":"1593734","report_state":"US","report_number":"1303000158","insp_date":"2023-06-13 00:00:00","insp_start_time":"1620","insp_end_time":"1639","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CELESTICALLC","shipping_paper_number":"MP2305102","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":"2023-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"23344","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2023-06-15 21:41:00","snet_input_date":"2023-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-15 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:09.000000Z","updated_at":"2025-03-17T19:28:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5288778,"change_date":"2023-06-15 21:41:00","inspection_id":"78897344","insp_unit_id":"195507415","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:40.000000Z","updated_at":"2025-03-17T22:44:40.000000Z"},{"id":5288779,"change_date":"2023-06-15 21:41:00","inspection_id":"78897344","insp_unit_id":"195507416","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"4CP5242","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"13N1482C3S1568766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:40.000000Z","updated_at":"2025-03-17T22:44:40.000000Z"}]},{"id":3203005,"change_date":"2023-06-02 21:41:00","inspection_id":"78799807","dot_number":"1593734","report_state":"AZ","report_number":"0222010058","insp_date":"2023-06-01 00:00:00","insp_start_time":"1400","insp_end_time":"1435","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"WESTBOUNDF","county_code_state":"AZ","county_code":"027","insp_level_id":"3","service_center":"WE","census_source_id":"4","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":"I","final_status_date":"2023-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1817592","transaction_code":"A","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-02 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-06-02 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:27.000000Z","updated_at":"2025-03-17T19:26:27.000000Z","inspection_violations":[{"id":4934344,"change_date":"2023-06-02 21:41:00","inspection_id":"78799807","insp_violation_id":"253241579","seq_no":"1","part_no":"395","part_no_section":"22(h)(1)","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-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"39522H1"},{"id":4934345,"change_date":"2023-06-02 21:41:00","inspection_id":"78799807","insp_violation_id":"253241580","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:57.000000Z","updated_at":"2025-03-17T21:29:57.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":5151723,"change_date":"2023-06-02 21:41:00","inspection_id":"78799807","insp_unit_id":"195283677","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLUE\/206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"},{"id":5151724,"change_date":"2023-06-02 21:41:00","inspection_id":"78799807","insp_unit_id":"195283678","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"BLK\/102","insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"}]},{"id":3172578,"change_date":"2023-05-30 21:43:00","inspection_id":"78765245","dot_number":"1593734","report_state":"CA","report_number":"NDGS007627","insp_date":"2023-05-23 00:00:00","insp_start_time":"1800","insp_end_time":"1830","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA MX","shipping_paper_number":"21861513951","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14921936","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:45.000000Z","updated_at":"2025-03-17T19:25:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5103359,"change_date":"2023-05-30 21:43:00","inspection_id":"78765245","insp_unit_id":"195214046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"RED#207","insp_unit_license":"YP86988","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X5KJ225451","insp_unit_decal":"Y","insp_unit_decal_number":"32521735","created_at":"2025-03-17T22:43:13.000000Z","updated_at":"2025-03-17T22:43:13.000000Z"},{"id":5103360,"change_date":"2023-05-30 21:43:00","inspection_id":"78765245","insp_unit_id":"195214047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"SILV FB#109","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"Y","insp_unit_decal_number":"32521736","created_at":"2025-03-17T22:43:13.000000Z","updated_at":"2025-03-17T22:43:13.000000Z"}]},{"id":2890228,"change_date":"2023-04-25 21:40:00","inspection_id":"78446513","dot_number":"1593734","report_state":"CA","report_number":"NB4B006761","insp_date":"2023-04-19 00:00:00","insp_start_time":"1825","insp_end_time":"1836","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO ENFORCEMENT FACILITY","county_code_state":"CA","county_code":"025","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-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14873953","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4650602,"change_date":"2023-04-25 21:40:00","inspection_id":"78446513","insp_unit_id":"194581483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN\/205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"32521044","created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"},{"id":4650603,"change_date":"2023-04-25 21:40:00","inspection_id":"78446513","insp_unit_id":"194581484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHPL","insp_unit_company":"FB\/110","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"}]},{"id":2833833,"change_date":"2023-04-18 21:42:00","inspection_id":"78382566","dot_number":"1593734","report_state":"CA","report_number":"NDGS007408","insp_date":"2023-04-13 00:00:00","insp_start_time":"1700","insp_end_time":"1730","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA MX","shipping_paper_number":"21861475123","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-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14862836","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:56.000000Z","updated_at":"2025-03-17T19:18:56.000000Z","inspection_violations":[{"id":4348268,"change_date":"2023-04-18 21:42:00","inspection_id":"78382566","insp_violation_id":"252298175","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194458593","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3963A1"},{"id":4348269,"change_date":"2023-04-18 21:42:00","inspection_id":"78382566","insp_violation_id":"252298176","seq_no":"2","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"194458593","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39347A"},{"id":4348270,"change_date":"2023-04-18 21:42:00","inspection_id":"78382566","insp_violation_id":"252298177","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194458593","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":4561455,"change_date":"2023-04-18 21:42:00","inspection_id":"78382566","insp_unit_id":"194458593","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN#205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"},{"id":4561456,"change_date":"2023-04-18 21:42:00","inspection_id":"78382566","insp_unit_id":"194458594","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHPL","insp_unit_company":"FB#110","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"}]},{"id":2618575,"change_date":"2023-03-20 21:41:00","inspection_id":"78137744","dot_number":"1593734","report_state":"CA","report_number":"NAS9007180","insp_date":"2023-03-15 00:00:00","insp_start_time":"1900","insp_end_time":"1909","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA SA DE  CV","shipping_paper_number":"FAEMX5796","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-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14824515","transaction_code":"A","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:54.000000Z","updated_at":"2025-03-17T19:14:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4215598,"change_date":"2023-03-20 21:41:00","inspection_id":"78137744","insp_unit_id":"193966961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN 205 3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"},{"id":4215599,"change_date":"2023-03-20 21:41:00","inspection_id":"78137744","insp_unit_id":"193966962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"FB 109 2X","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"}]},{"id":2518513,"change_date":"2023-03-06 21:41:00","inspection_id":"78023834","dot_number":"1593734","report_state":"CA","report_number":"NDGS007164","insp_date":"2023-02-27 00:00:00","insp_start_time":"1600","insp_end_time":"1615","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA MX","shipping_paper_number":"21861401965","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-03-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14807035","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-06 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:59.000000Z","updated_at":"2025-03-17T19:12:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4053858,"change_date":"2023-03-06 21:41:00","inspection_id":"78023834","insp_unit_id":"193735728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN#205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"},{"id":4053859,"change_date":"2023-03-06 21:41:00","inspection_id":"78023834","insp_unit_id":"193735729","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"FB#102","insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:03.000000Z","updated_at":"2025-03-17T22:35:03.000000Z"}]},{"id":2382326,"change_date":"2023-02-15 21:39:00","inspection_id":"77868914","dot_number":"1593734","report_state":"CA","report_number":"N8L2003875","insp_date":"2023-02-13 00:00:00","insp_start_time":"0709","insp_end_time":"0728","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-15 21:39: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":"14786739","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-15 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:41.000000Z","updated_at":"2025-03-17T19:10:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3833679,"change_date":"2023-02-15 21:39:00","inspection_id":"77868914","insp_unit_id":"193423872","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"206\/BLU","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"32185639","created_at":"2025-03-17T22:33:27.000000Z","updated_at":"2025-03-17T22:33:27.000000Z"}]},{"id":2196662,"change_date":"2023-01-20 21:42:00","inspection_id":"77657291","dot_number":"1593734","report_state":"CA","report_number":"NDGS006885","insp_date":"2023-01-10 00:00:00","insp_start_time":"1615","insp_end_time":"1645","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA MX","shipping_paper_number":"000623244","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-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14748871","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-20 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:00.000000Z","updated_at":"2025-03-17T19:07:00.000000Z","inspection_violations":[{"id":3393663,"change_date":"2023-01-20 21:42:00","inspection_id":"77657291","insp_violation_id":"250701487","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"192992666","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JS68449","created_at":"2025-03-17T21:23:02.000000Z","updated_at":"2025-03-17T21:23:02.000000Z","normalized_code":"393207A"},{"id":3393664,"change_date":"2023-01-20 21:42:00","inspection_id":"77657291","insp_violation_id":"250701488","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192992666","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA448913","created_at":"2025-03-17T21:23:02.000000Z","updated_at":"2025-03-17T21:23:02.000000Z","normalized_code":"3963A1"},{"id":3393665,"change_date":"2023-01-20 21:42:00","inspection_id":"77657291","insp_violation_id":"250701489","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"192992666","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA448912","created_at":"2025-03-17T21:23:02.000000Z","updated_at":"2025-03-17T21:23:02.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":3535650,"change_date":"2023-01-20 21:42:00","inspection_id":"77657291","insp_unit_id":"192992666","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU#206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:22.000000Z","updated_at":"2025-03-17T22:31:22.000000Z"},{"id":3535651,"change_date":"2023-01-20 21:42:00","inspection_id":"77657291","insp_unit_id":"192992667","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"FB#109","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"Y","insp_unit_decal_number":"32185346","created_at":"2025-03-17T22:31:22.000000Z","updated_at":"2025-03-17T22:31:22.000000Z"}]},{"id":2088260,"change_date":"2023-01-06 21:39:00","inspection_id":"77532758","dot_number":"1593734","report_state":"CA","report_number":"NDRG003798","insp_date":"2023-01-05 00:00:00","insp_start_time":"1350","insp_end_time":"1411","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"14730715","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:07.000000Z","updated_at":"2025-03-17T19:05:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3359930,"change_date":"2023-01-06 21:39:00","inspection_id":"77532758","insp_unit_id":"192746471","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT","insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"Y","insp_unit_decal_number":"32203034","created_at":"2025-03-17T22:30:03.000000Z","updated_at":"2025-03-17T22:30:03.000000Z"},{"id":3359931,"change_date":"2023-01-06 21:39:00","inspection_id":"77532758","insp_unit_id":"192746472","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHPL","insp_unit_company":"ALU","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:03.000000Z","updated_at":"2025-03-17T22:30:03.000000Z"}]},{"id":2088319,"change_date":"2023-01-06 21:39:00","inspection_id":"77532823","dot_number":"1593734","report_state":"CA","report_number":"NDM1004660","insp_date":"2023-01-05 00:00:00","insp_start_time":"1223","insp_end_time":"1255","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14730506","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":"343802","created_at":"2025-03-17T19:05:07.000000Z","updated_at":"2025-03-17T19:05:07.000000Z","inspection_violations":[{"id":3232455,"change_date":"2023-01-06 21:39:00","inspection_id":"77532823","insp_violation_id":"250438432","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192746592","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39345B2"},{"id":3232456,"change_date":"2023-01-06 21:39:00","inspection_id":"77532823","insp_violation_id":"250438433","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"192746593","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39375A3"},{"id":3232457,"change_date":"2023-01-06 21:39:00","inspection_id":"77532823","insp_violation_id":"250438434","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"192746593","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":3360040,"change_date":"2023-01-06 21:39:00","inspection_id":"77532823","insp_unit_id":"192746592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/203","insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:04.000000Z","updated_at":"2025-03-17T22:30:04.000000Z"},{"id":3360041,"change_date":"2023-01-06 21:39:00","inspection_id":"77532823","insp_unit_id":"192746593","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"ALU\/10","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:04.000000Z","updated_at":"2025-03-17T22:30:04.000000Z"}]},{"id":1737598,"change_date":"2022-11-14 21:43:00","inspection_id":"77131536","dot_number":"1593734","report_state":"CA","report_number":"UD64002270","insp_date":"2022-11-13 00:00:00","insp_start_time":"1850","insp_end_time":"1938","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":"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-11-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14672670","transaction_code":"A","transaction_date":"2022-11-13 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-14 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:36.000000Z","updated_at":"2025-03-17T18:58:36.000000Z","inspection_violations":[{"id":2721167,"change_date":"2022-11-14 21:43:00","inspection_id":"77131536","insp_violation_id":"249592995","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191950137","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KD06122","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"3922"},{"id":2721168,"change_date":"2022-11-14 21:43:00","inspection_id":"77131536","insp_violation_id":"249592996","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191950136","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2795841,"change_date":"2022-11-14 21:43:00","inspection_id":"77131536","insp_unit_id":"191950136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"205\/GRN","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:08.000000Z","updated_at":"2025-03-17T22:26:08.000000Z"},{"id":2795842,"change_date":"2022-11-14 21:43:00","inspection_id":"77131536","insp_unit_id":"191950137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":"107\/BLK FB","insp_unit_license":"4PK3367","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"TC12179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:08.000000Z","updated_at":"2025-03-17T22:26:08.000000Z"}]},{"id":1476905,"change_date":"2022-10-10 21:35:00","inspection_id":"76831861","dot_number":"1593734","report_state":"CA","report_number":"NB4B005710","insp_date":"2022-10-05 00:00:00","insp_start_time":"1852","insp_end_time":"1902","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO","county_code_state":"CA","county_code":"025","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":"2022-10-10 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14627466","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-10 21:35:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:49.000000Z","updated_at":"2025-03-17T18:53:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2378232,"change_date":"2022-10-10 21:35:00","inspection_id":"76831861","insp_unit_id":"191352764","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:17.000000Z","updated_at":"2025-03-17T22:23:17.000000Z"},{"id":2378233,"change_date":"2022-10-10 21:35:00","inspection_id":"76831861","insp_unit_id":"191352765","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:17.000000Z","updated_at":"2025-03-17T22:23:17.000000Z"}]},{"id":1477135,"change_date":"2022-10-10 21:35:00","inspection_id":"76832108","dot_number":"1593734","report_state":"CA","report_number":"NDGS006378","insp_date":"2022-10-05 00:00:00","insp_start_time":"1645","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA","shipping_paper_number":"21861266589","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-10 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14627152","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-10 21:35:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:49.000000Z","updated_at":"2025-03-17T18:53:49.000000Z","inspection_violations":[{"id":2326661,"change_date":"2022-10-10 21:35:00","inspection_id":"76832108","insp_violation_id":"248926070","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191353114","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JS 67630","created_at":"2025-03-17T21:17:41.000000Z","updated_at":"2025-03-17T21:17:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2378551,"change_date":"2022-10-10 21:35:00","inspection_id":"76832108","insp_unit_id":"191353113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN#205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:17.000000Z","updated_at":"2025-03-17T22:23:17.000000Z"},{"id":2378552,"change_date":"2022-10-10 21:35:00","inspection_id":"76832108","insp_unit_id":"191353114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"FB \/RED","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:17.000000Z","updated_at":"2025-03-17T22:23:17.000000Z"}]},{"id":1392219,"change_date":"2022-09-28 21:41:00","inspection_id":"76733553","dot_number":"1593734","report_state":"CA","report_number":"N9RG004346","insp_date":"2022-09-26 00:00:00","insp_start_time":"0735","insp_end_time":"0745","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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":"2022-09-28 21:41: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":"14613265","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-28 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:21.000000Z","updated_at":"2025-03-17T18:52:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2242207,"change_date":"2022-09-28 21:41:00","inspection_id":"76733553","insp_unit_id":"191157669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:20.000000Z","updated_at":"2025-03-17T22:22:20.000000Z"}]},{"id":1309327,"change_date":"2022-09-16 21:41:00","inspection_id":"76637449","dot_number":"1593734","report_state":"CA","report_number":"UBYG000942","insp_date":"2022-09-05 00:00:00","insp_start_time":"1330","insp_end_time":"1350","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-16 21:41: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":"14597373","transaction_code":"A","transaction_date":"2022-09-05 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:50.000000Z","updated_at":"2025-03-17T18:50:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2107704,"change_date":"2022-09-16 21:41:00","inspection_id":"76637449","insp_unit_id":"190958882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT\/3X","insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":2262091,"change_date":"2023-01-31 21:42:00","inspection_id":"77731724","dot_number":"1593734","report_state":"US","report_number":"1671005454","insp_date":"2022-07-27 00:00:00","insp_start_time":"1907","insp_end_time":"1907","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FANOSA SA DE CV","shipping_paper_number":"FAEMX3849","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":"2023-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"95100","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":"335","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":"2023-01-31 21:42:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-01-31 21:42:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:27.000000Z","updated_at":"2025-03-17T19:08:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3641183,"change_date":"2023-01-31 21:42:00","inspection_id":"77731724","insp_unit_id":"193143675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"WP94869","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG3ALAV1080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"},{"id":3641184,"change_date":"2023-01-31 21:42:00","inspection_id":"77731724","insp_unit_id":"193143676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"}]},{"id":887959,"change_date":"2022-07-25 21:40:00","inspection_id":"76146204","dot_number":"1593734","report_state":"CA","report_number":"NB4B005212","insp_date":"2022-07-11 00:00:00","insp_start_time":"1702","insp_end_time":"1713","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"3734","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-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14519068","transaction_code":"A","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-25 21:40:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:22.000000Z","updated_at":"2025-03-17T18:43:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1429725,"change_date":"2022-07-25 21:40:00","inspection_id":"76146204","insp_unit_id":"189951901","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLUE\/206","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:58.000000Z","updated_at":"2025-03-17T22:16:58.000000Z"},{"id":1429726,"change_date":"2022-07-25 21:40:00","inspection_id":"76146204","insp_unit_id":"189951902","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"BLK\/102","insp_unit_license":"4DL2142","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2482SA436203","insp_unit_decal":"Y","insp_unit_decal_number":"31521118","created_at":"2025-03-17T22:16:58.000000Z","updated_at":"2025-03-17T22:16:58.000000Z"}]},{"id":844328,"change_date":"2022-07-18 21:43:00","inspection_id":"76095307","dot_number":"1593734","report_state":"CA","report_number":"UCYG000920","insp_date":"2022-07-04 00:00:00","insp_start_time":"1329","insp_end_time":"1339","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO","county_code_state":"CA","county_code":"025","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-07-18 21:43: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":"14509721","transaction_code":"A","transaction_date":"2022-07-04 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-18 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:39.000000Z","updated_at":"2025-03-17T18:42:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1359113,"change_date":"2022-07-18 21:43:00","inspection_id":"76095307","insp_unit_id":"189844260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN \/ 3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:32.000000Z","updated_at":"2025-03-17T22:16:32.000000Z"}]},{"id":675040,"change_date":"2022-06-22 21:41:00","inspection_id":"75897051","dot_number":"1593734","report_state":"CA","report_number":"NB4B005044","insp_date":"2022-06-15 00:00:00","insp_start_time":"1916","insp_end_time":"1928","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"3606","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14479516","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-22 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:33.000000Z","updated_at":"2025-03-17T18:39:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1085051,"change_date":"2022-06-22 21:41:00","inspection_id":"75897051","insp_unit_id":"189415752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN\/205","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:53.000000Z","updated_at":"2025-03-17T22:14:53.000000Z"},{"id":1085052,"change_date":"2022-06-22 21:41:00","inspection_id":"75897051","insp_unit_id":"189415753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAYD","insp_unit_company":"FB","insp_unit_license":"4JN4530","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5DDKF4823Y1000046","insp_unit_decal":"Y","insp_unit_decal_number":"31160066","created_at":"2025-03-17T22:14:53.000000Z","updated_at":"2025-03-17T22:14:53.000000Z"}]},{"id":675428,"change_date":"2022-06-22 21:41:00","inspection_id":"75897476","dot_number":"1593734","report_state":"CA","report_number":"N9RG003950","insp_date":"2022-06-13 00:00:00","insp_start_time":"0723","insp_end_time":"0744","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-22 21:41: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":"14478460","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-22 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:33.000000Z","updated_at":"2025-03-17T18:39:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1085644,"change_date":"2022-06-22 21:41:00","inspection_id":"75897476","insp_unit_id":"189416439","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU\/206\/3X","insp_unit_license":"YP19187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLBG6GSHK9480","insp_unit_decal":"Y","insp_unit_decal_number":"31159972","created_at":"2025-03-17T22:14:53.000000Z","updated_at":"2025-03-17T22:14:53.000000Z"}]},{"id":464832,"change_date":"2022-05-23 21:43:00","inspection_id":"75647325","dot_number":"1593734","report_state":"CA","report_number":"NAQG003589","insp_date":"2022-05-19 00:00:00","insp_start_time":"1518","insp_end_time":"1532","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14438756","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-23 21:43:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:56.000000Z","updated_at":"2025-03-17T18:35:56.000000Z","inspection_violations":[{"id":736855,"change_date":"2022-05-23 21:43:00","inspection_id":"75647325","insp_violation_id":"246020331","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"188868438","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":749083,"change_date":"2022-05-23 21:43:00","inspection_id":"75647325","insp_unit_id":"188868437","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"},{"id":749084,"change_date":"2022-05-23 21:43:00","inspection_id":"75647325","insp_unit_id":"188868438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHPL","insp_unit_company":"ALUM\/2X","insp_unit_license":"4SY4953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1C92D53238M949659","insp_unit_decal":"Y","insp_unit_decal_number":"31159679","created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"}]},{"id":150896,"change_date":"2022-04-11 21:41:00","inspection_id":"75272891","dot_number":"1593734","report_state":"CA","report_number":"NA2H004714","insp_date":"2022-04-08 00:00:00","insp_start_time":"1253","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14380842","transaction_code":"A","transaction_date":"2022-04-08 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01593734","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"ALEJANDRO G MENDEZ","insp_carrier_street":"227 SAN FELIPE DRIVE","insp_carrier_city":"IMPERIAL","insp_carrier_state":"CA","insp_carrier_zip_code":"92251","insp_colonia":null,"docket_number":"589657","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:10.000000Z","updated_at":"2025-03-17T18:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":244832,"change_date":"2022-04-11 21:41:00","inspection_id":"75272891","insp_unit_id":"188093757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN\/205\/3X","insp_unit_license":"XP17759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLBG4CSBL2825","insp_unit_decal":"Y","insp_unit_decal_number":"31158690","created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"},{"id":244833,"change_date":"2022-04-11 21:41:00","inspection_id":"75272891","insp_unit_id":"188093758","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"RED\/109\/2X","insp_unit_license":"4RA6511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE5320451075568","insp_unit_decal":"Y","insp_unit_decal_number":"31158691","created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1593734\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1593734\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1593734\/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\/1593734\/inspections","per_page":100,"prev_page_url":null,"to":71,"total":71}