{"current_page":1,"data":[{"id":12091160,"change_date":"2026-06-04 21:45:00","inspection_id":"88035004","dot_number":"3796705","report_state":"CA","report_number":"NCTX008884","insp_date":"2026-06-02 00:00:00","insp_start_time":"2047","insp_end_time":"2155","registration_date":null,"region":"PS","ci_status_code":"C","location":"131","location_desc":"CA","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"19998","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":"3458684","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2026-06-07T09:40:41.000000Z","updated_at":"2026-06-16T09:30:31.000000Z","inspection_violations":[{"id":21041854,"change_date":"2026-06-04 21:45:00","inspection_id":"88035004","insp_violation_id":"274681233","seq_no":"1","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213901956","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RT06375","created_at":"2026-06-07T10:00:32.000000Z","updated_at":"2026-06-16T09:44:28.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":21010194,"change_date":"2026-06-04 21:45:00","inspection_id":"88035004","insp_unit_id":"213901955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"X2 GRY","insp_unit_license":"34984P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3CL2DG564509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:39.000000Z","updated_at":"2026-06-16T09:01:43.000000Z"},{"id":21010195,"change_date":"2026-06-04 21:45:00","inspection_id":"88035004","insp_unit_id":"213901956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"STDK\/BLK","insp_unit_license":"4VC8182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:39.000000Z","updated_at":"2026-06-16T09:01:43.000000Z"}]},{"id":11987538,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","dot_number":"3796705","report_state":"CA","report_number":"UERM000918","insp_date":"2026-05-21 00:00:00","insp_start_time":"0810","insp_end_time":"0905","registration_date":null,"region":"PS","ci_status_code":"C","location":"880","location_desc":"CA","county_code_state":"CA","county_code":"059","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"11","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3380530","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2026-05-22 08:07:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2026-05-25T09:41:04.000000Z","updated_at":"2026-06-02T09:31:24.000000Z","inspection_violations":[{"id":20853956,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426527","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3922SLLTCD"},{"id":20853957,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426528","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39111B2Q"},{"id":20853958,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426529","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213692157","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3922SLLSR"},{"id":20853959,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426530","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213692157","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3939ALCL"},{"id":20853960,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426531","seq_no":"5","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213692157","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3922SLLEQP"},{"id":20853961,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426532","seq_no":"6","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"213692157","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39395A4EENA"},{"id":20853962,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426533","seq_no":"7","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"213692157","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3939AHLLH"},{"id":20853963,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426534","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"213692158","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3922SLLSR"},{"id":20853964,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426535","seq_no":"9","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213692158","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"3963A1BOS"},{"id":20853965,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426536","seq_no":"10","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213692158","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39343DB"},{"id":20853966,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_violation_id":"274426537","seq_no":"11","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"213692158","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-25T10:02:03.000000Z","updated_at":"2026-06-02T09:42:09.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":20840029,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_unit_id":"213692157","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHI","insp_unit_license":"34392C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL1EG182436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:52.000000Z","updated_at":"2026-06-02T09:03:54.000000Z"},{"id":20840030,"change_date":"2026-05-22 08:07:00","inspection_id":"87925167","insp_unit_id":"213692158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"FLTBD","insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:52.000000Z","updated_at":"2026-06-02T09:03:54.000000Z"}]},{"id":11292288,"change_date":"2026-03-04 21:41:00","inspection_id":"87207578","dot_number":"3796705","report_state":"CA","report_number":"UEGX002596","insp_date":"2026-03-04 00:00:00","insp_start_time":"1250","insp_end_time":"1320","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"I-80 E\/B JEO CORDELIA SCALES","county_code_state":"CA","county_code":"095","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16194003","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2026-03-04 21:41:00","snet_input_date":"2026-03-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-04 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2026-03-07T10:39:17.000000Z","updated_at":"2026-03-15T09:31:31.000000Z","inspection_violations":[{"id":18989665,"change_date":"2026-03-04 21:41:00","inspection_id":"87207578","insp_violation_id":"272206534","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-07T10:58:04.000000Z","updated_at":"2026-03-15T09:42:57.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":19313975,"change_date":"2026-03-04 21:41:00","inspection_id":"87207578","insp_unit_id":"211975705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:51.000000Z","updated_at":"2026-03-15T09:06:46.000000Z"},{"id":19313976,"change_date":"2026-03-04 21:41:00","inspection_id":"87207578","insp_unit_id":"211975706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:51.000000Z","updated_at":"2026-03-15T09:06:46.000000Z"}]},{"id":10621317,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","dot_number":"3796705","report_state":"WA","report_number":"2101000678","insp_date":"2026-01-07 00:00:00","insp_start_time":"1434","insp_end_time":"1515","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC77","location_desc":"KELSO WA","county_code_state":"WA","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LX HAUSYS AMERICA INC","shipping_paper_number":"WA27-20260107-0","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-01-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21690","viol_total":"7","oos_total":"4","driver_viol_total":"6","driver_oos_total":"4","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2752178","transaction_code":"A","transaction_date":"2026-01-11 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2026-01-12 21:38:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-12 21:38:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-15T10:36:52.000000Z","updated_at":"2026-01-23T10:30:14.000000Z","inspection_violations":[{"id":17859754,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132030","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"211019492","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3922SLLIRP"},{"id":17859755,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132031","seq_no":"2","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3953A1HOSPD"},{"id":17859756,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132032","seq_no":"3","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3953A1HOSPD"},{"id":17859757,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132033","seq_no":"4","part_no":"395","part_no_section":"3A2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3953A2HOSPD"},{"id":17859758,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132034","seq_no":"5","part_no":"395","part_no_section":"3A2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3953A2HOSPD"},{"id":17859759,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132035","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":17859760,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_violation_id":"271132036","seq_no":"7","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:42:40.000000Z","updated_at":"2026-01-23T10:30:25.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":17808596,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_unit_id":"211019492","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"68252R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3DL7DG584351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:45.000000Z","updated_at":"2026-01-24T10:00:31.000000Z"},{"id":17808597,"change_date":"2026-01-12 21:38:00","inspection_id":"86761735","insp_unit_id":"211019493","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4WA3592","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F412XN6161807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:45.000000Z","updated_at":"2026-01-24T10:00:31.000000Z"}]},{"id":10116528,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","dot_number":"3796705","report_state":"OR","report_number":"AP44090513","insp_date":"2025-11-04 00:00:00","insp_start_time":"1134","insp_end_time":"1215","registration_date":null,"region":"PS","ci_status_code":"C","location":"09-06","location_desc":"BEND OR","county_code_state":"OR","county_code":"017","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ACM","shipping_paper_number":"11320251220","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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22290","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2501028","transaction_code":"C","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-11-04 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-04 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:43.000000Z","updated_at":"2025-11-10T10:30:10.000000Z","inspection_violations":[{"id":16807903,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_violation_id":"269775126","seq_no":"2","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:32.000000Z","updated_at":"2025-11-10T10:30:20.000000Z","normalized_code":"3953A1HOSPD"},{"id":16807904,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_violation_id":"269775127","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:32.000000Z","updated_at":"2025-11-10T10:30:20.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":16807905,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_violation_id":"269775128","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209876274","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:32.000000Z","updated_at":"2025-11-10T10:30:20.000000Z","normalized_code":"39617CPI"},{"id":16807906,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_violation_id":"269775129","seq_no":"5","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209876273","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:32.000000Z","updated_at":"2025-11-10T10:30:20.000000Z","normalized_code":"39395F"},{"id":16807907,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_violation_id":"269775130","seq_no":"6","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"209876274","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-09T10:32:32.000000Z","updated_at":"2025-11-10T10:30:20.000000Z","normalized_code":"39343DBMA"},{"id":16807908,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_violation_id":"269775131","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209876273","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:32.000000Z","updated_at":"2025-11-10T10:30:20.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16863466,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_unit_id":"209876273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"42550N1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3GL0DG616262","insp_unit_decal":"Y","insp_unit_decal_number":"35770529","created_at":"2025-11-09T10:01:46.000000Z","updated_at":"2025-11-10T10:00:11.000000Z"},{"id":16863467,"change_date":"2025-11-06 21:39:00","inspection_id":"86232879","insp_unit_id":"209876274","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4VC8182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:46.000000Z","updated_at":"2025-11-10T10:00:11.000000Z"}]},{"id":9493658,"change_date":"2025-08-25 21:39:00","inspection_id":"85577986","dot_number":"3796705","report_state":"WA","report_number":"2101000496","insp_date":"2025-08-20 00:00:00","insp_start_time":"1421","insp_end_time":"1441","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"KELSO WA","county_code_state":"WA","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"31268","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":"U","pen_cen_match":"I","final_status_date":"2025-08-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2172233","transaction_code":"A","transaction_date":"2025-08-24 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-08-25 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-25 21:39:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:33.000000Z","updated_at":"2025-08-29T10:42:33.000000Z","inspection_violations":[{"id":15478879,"change_date":"2025-08-25 21:39:00","inspection_id":"85577986","insp_violation_id":"268217382","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5A0089256","created_at":"2025-08-28T10:43:49.000000Z","updated_at":"2025-09-05T10:47:50.000000Z","normalized_code":"3922SLLTCD"},{"id":15478880,"change_date":"2025-08-25 21:39:00","inspection_id":"85577986","insp_violation_id":"268217383","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"208556801","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:43:49.000000Z","updated_at":"2025-09-05T10:47:50.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":15662605,"change_date":"2025-08-25 21:39:00","inspection_id":"85577986","insp_unit_id":"208556801","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"34392C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL1EG182436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:27.000000Z","updated_at":"2025-08-29T09:45:17.000000Z"},{"id":15662606,"change_date":"2025-08-25 21:39:00","inspection_id":"85577986","insp_unit_id":"208556802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:27.000000Z","updated_at":"2025-08-29T09:45:17.000000Z"}]},{"id":9279644,"change_date":"2025-07-29 21:40:00","inspection_id":"85352922","dot_number":"3796705","report_state":"CA","report_number":"NEID003372","insp_date":"2025-07-28 00:00:00","insp_start_time":"1928","insp_end_time":"1952","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21699","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":"15917923","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-07-29 21:40:00","snet_input_date":"2025-07-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-29 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-08-01T10:42:11.000000Z","updated_at":"2025-08-04T10:00:56.000000Z","inspection_violations":[{"id":15042382,"change_date":"2025-07-29 21:40:00","inspection_id":"85352922","insp_violation_id":"267728472","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"208142654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:31.000000Z","updated_at":"2025-08-02T10:43:13.000000Z","normalized_code":"3939ALSML"},{"id":15042383,"change_date":"2025-07-29 21:40:00","inspection_id":"85352922","insp_violation_id":"267728473","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208142654","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:31.000000Z","updated_at":"2025-08-02T10:43:13.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15276683,"change_date":"2025-07-29 21:40:00","inspection_id":"85352922","insp_unit_id":"208142653","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"SILVERX2","insp_unit_license":"68252R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3DL7DG584351","insp_unit_decal":"Y","insp_unit_decal_number":"35338520","created_at":"2025-08-01T09:45:50.000000Z","updated_at":"2025-08-02T09:46:11.000000Z"},{"id":15276684,"change_date":"2025-07-29 21:40:00","inspection_id":"85352922","insp_unit_id":"208142654","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"BLACKX2","insp_unit_license":"4UV4734","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3822N6178035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:50.000000Z","updated_at":"2025-08-02T09:46:11.000000Z"}]},{"id":8638316,"change_date":"2025-05-15 21:42:00","inspection_id":"84675724","dot_number":"3796705","report_state":"WA","report_number":"2103000973","insp_date":"2025-05-13 00:00:00","insp_start_time":"1030","insp_end_time":"1109","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PINKYS","shipping_paper_number":"24356","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":"2025-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"1729484","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-05-15 21:42:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-15 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:03:38.000000Z","updated_at":"2025-05-19T10:03:57.000000Z","inspection_violations":[{"id":13738278,"change_date":"2025-05-15 21:42:00","inspection_id":"84675724","insp_violation_id":"266234756","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"206869162","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:28:53.000000Z","updated_at":"2025-05-19T10:20:36.000000Z","normalized_code":"3922SLLIFTA"},{"id":13738279,"change_date":"2025-05-15 21:42:00","inspection_id":"84675724","insp_violation_id":"266234757","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"206869162","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:28:53.000000Z","updated_at":"2025-05-19T10:20:36.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":14105796,"change_date":"2025-05-15 21:42:00","inspection_id":"84675724","insp_unit_id":"206869162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"26","insp_unit_license":"67452X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL5KG524207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:49:47.000000Z","updated_at":"2025-05-19T09:49:03.000000Z"},{"id":14105797,"change_date":"2025-05-15 21:42:00","inspection_id":"84675724","insp_unit_id":"206869163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:49:47.000000Z","updated_at":"2025-05-19T09:49:03.000000Z"}]},{"id":8455313,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","dot_number":"3796705","report_state":"CA","report_number":"UESQ004886","insp_date":"2025-04-22 00:00:00","insp_start_time":"1500","insp_end_time":"1540","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"SB 99 N OF WOODBRIDGE RD","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TESCO CONTROLS","shipping_paper_number":"37335X4","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15791045","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-04-26T10:28:51.000000Z","updated_at":"2025-04-27T10:33:34.000000Z","inspection_violations":[{"id":13361603,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_violation_id":"265801433","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206464255","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:15:23.000000Z","updated_at":"2025-04-26T10:58:38.000000Z","normalized_code":"3922SLLSR"},{"id":13361604,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_violation_id":"265801434","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206464255","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:15:23.000000Z","updated_at":"2025-04-26T10:58:38.000000Z","normalized_code":"39021TB2DOT"},{"id":13361605,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_violation_id":"265801435","seq_no":"3","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"206464255","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:15:23.000000Z","updated_at":"2025-04-26T10:58:38.000000Z","normalized_code":"39021TCMC"},{"id":13361606,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_violation_id":"265801436","seq_no":"4","part_no":"395","part_no_section":"8F5-HOSM","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-04-25T11:15:23.000000Z","updated_at":"2025-04-26T10:58:38.000000Z","normalized_code":"3958F5HOSM"},{"id":13361607,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_violation_id":"265801437","seq_no":"5","part_no":"395","part_no_section":"8D11-HOSF","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-04-25T11:15:23.000000Z","updated_at":"2025-04-26T10:58:38.000000Z","normalized_code":"3958D11HOSF"}],"inspection_per_units":[{"id":13733609,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_unit_id":"206464255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:20:06.000000Z","updated_at":"2025-04-27T10:11:52.000000Z"},{"id":13733610,"change_date":"2025-04-23 21:41:00","inspection_id":"84483210","insp_unit_id":"206464256","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGTX","insp_unit_company":null,"insp_unit_license":"4VC8182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:20:06.000000Z","updated_at":"2025-04-27T10:11:52.000000Z"}]},{"id":8446688,"change_date":"2025-04-23 21:40:00","inspection_id":"84474215","dot_number":"3796705","report_state":"WA","report_number":"2129000608","insp_date":"2025-04-21 00:00:00","insp_start_time":"1535","insp_end_time":"1550","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"VANCOUVER WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED RENTALS","shipping_paper_number":"6125604","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":"U","pen_cen_match":"I","final_status_date":"2025-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67497","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":"1632530","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-04-23 21:40:00","snet_input_date":"2025-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-23 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:53.000000Z","updated_at":"2025-04-27T10:29:14.000000Z","inspection_violations":[{"id":13342392,"change_date":"2025-04-23 21:40:00","inspection_id":"84474215","insp_violation_id":"265779477","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:01:51.000000Z","updated_at":"2025-04-26T10:40:38.000000Z","normalized_code":"3922SLLTCD"},{"id":13342393,"change_date":"2025-04-23 21:40:00","inspection_id":"84474215","insp_violation_id":"265779478","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"206447637","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:01:51.000000Z","updated_at":"2025-04-26T10:40:38.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":13718566,"change_date":"2025-04-23 21:40:00","inspection_id":"84474215","insp_unit_id":"206447638","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4UV4734","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3822N6178035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:08:38.000000Z","updated_at":"2025-04-27T09:54:38.000000Z"},{"id":13718565,"change_date":"2025-04-23 21:40:00","inspection_id":"84474215","insp_unit_id":"206447637","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"68252R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3DL7DG584351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:08:38.000000Z","updated_at":"2025-04-27T09:54:38.000000Z"}]},{"id":8374130,"change_date":"2025-04-14 21:41:00","inspection_id":"84397601","dot_number":"3796705","report_state":"CA","report_number":"NDLY009034","insp_date":"2025-04-11 00:00:00","insp_start_time":"0832","insp_end_time":"0841","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ESQUIVEL","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"15777267","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-04-14 21:41:00","snet_input_date":"2025-04-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-04-17T10:05:48.000000Z","updated_at":"2025-04-18T10:24:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13590475,"change_date":"2025-04-14 21:41:00","inspection_id":"84397601","insp_unit_id":"206309155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHT","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T10:01:15.000000Z","updated_at":"2025-04-18T10:07:18.000000Z"},{"id":13590476,"change_date":"2025-04-14 21:41:00","inspection_id":"84397601","insp_unit_id":"206309156","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":"BLK","insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T10:01:15.000000Z","updated_at":"2025-04-18T10:07:18.000000Z"}]},{"id":8374459,"change_date":"2025-04-14 21:41:00","inspection_id":"84397941","dot_number":"3796705","report_state":"CA","report_number":"NDKW007699","insp_date":"2025-04-02 00:00:00","insp_start_time":"1625","insp_end_time":"1650","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"15779580","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-04-14 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-04-17T10:05:50.000000Z","updated_at":"2025-04-18T10:24:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13590998,"change_date":"2025-04-14 21:41:00","inspection_id":"84397941","insp_unit_id":"206309717","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X\/ WHT","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"Y","insp_unit_decal_number":"35058028","created_at":"2025-04-17T10:01:35.000000Z","updated_at":"2025-04-18T10:07:48.000000Z"},{"id":13590999,"change_date":"2025-04-14 21:41:00","inspection_id":"84397941","insp_unit_id":"206309718","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T10:01:35.000000Z","updated_at":"2025-04-18T10:07:48.000000Z"}]},{"id":8048466,"change_date":"2025-03-06 21:40:00","inspection_id":"84054636","dot_number":"3796705","report_state":"CA","report_number":"NE5Z003772","insp_date":"2025-03-05 00:00:00","insp_start_time":"0930","insp_end_time":"1117","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PULSETX","shipping_paper_number":"M496301","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-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23900","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":"15729440","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-03-06 21:40:00","snet_input_date":"2025-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-06 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T21:05:24.000000Z","updated_at":"2025-03-17T21:05:24.000000Z","inspection_violations":[{"id":12578685,"change_date":"2025-03-06 21:40:00","inspection_id":"84054636","insp_violation_id":"264879608","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205668840","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:28.000000Z","updated_at":"2025-03-17T22:07:28.000000Z","normalized_code":"3922SLLSR"},{"id":12578686,"change_date":"2025-03-06 21:40:00","inspection_id":"84054636","insp_violation_id":"264879609","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205668840","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:28.000000Z","updated_at":"2025-03-17T22:07:28.000000Z","normalized_code":"3922SLLSR"},{"id":12578687,"change_date":"2025-03-06 21:40:00","inspection_id":"84054636","insp_violation_id":"264879610","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"205668840","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:28.000000Z","updated_at":"2025-03-17T22:07:28.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":12994026,"change_date":"2025-03-06 21:40:00","inspection_id":"84054636","insp_unit_id":"205668840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT\/01","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:32.000000Z","updated_at":"2025-03-17T23:58:32.000000Z"},{"id":12994027,"change_date":"2025-03-06 21:40:00","inspection_id":"84054636","insp_unit_id":"205668841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATP","insp_unit_company":"BLK\/01","insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:32.000000Z","updated_at":"2025-03-17T23:58:32.000000Z"}]},{"id":7997669,"change_date":"2025-02-28 21:42:00","inspection_id":"84001230","dot_number":"3796705","report_state":"CA","report_number":"UDFU003966","insp_date":"2025-02-27 00:00:00","insp_start_time":"0818","insp_end_time":"0907","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"HORNBROOK AG STATION","county_code_state":"CA","county_code":"093","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":"2025-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15721646","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-02-28 21:42:00","snet_input_date":"2025-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-28 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:07.000000Z","updated_at":"2025-03-17T21:04:07.000000Z","inspection_violations":[{"id":12495837,"change_date":"2025-02-28 21:42:00","inspection_id":"84001230","insp_violation_id":"264773422","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205571668","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RC 47530","created_at":"2025-03-17T22:07:03.000000Z","updated_at":"2025-03-17T22:07:03.000000Z","normalized_code":"3922SLLSR"},{"id":12495838,"change_date":"2025-02-28 21:42:00","inspection_id":"84001230","insp_violation_id":"264773423","seq_no":"2","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"205571669","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:03.000000Z","updated_at":"2025-03-17T22:07:03.000000Z","normalized_code":"3963A1HCM"}],"inspection_per_units":[{"id":12911295,"change_date":"2025-02-28 21:42:00","inspection_id":"84001230","insp_unit_id":"205571668","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"},{"id":12911296,"change_date":"2025-02-28 21:42:00","inspection_id":"84001230","insp_unit_id":"205571669","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":7900885,"change_date":"2025-02-18 21:40:00","inspection_id":"83899789","dot_number":"3796705","report_state":"CA","report_number":"ND6S007984","insp_date":"2025-02-12 00:00:00","insp_start_time":"1127","insp_end_time":"1153","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"W\/B ANTELOPE SCALES","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"15707591","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T21:02:20.000000Z","updated_at":"2025-03-17T21:02:20.000000Z","inspection_violations":[{"id":12346360,"change_date":"2025-02-18 21:40:00","inspection_id":"83899789","insp_violation_id":"264577696","seq_no":"1","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"205383463","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3963A1F"}],"inspection_per_units":[{"id":12753415,"change_date":"2025-02-18 21:40:00","inspection_id":"83899789","insp_unit_id":"205383463","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"},{"id":12753416,"change_date":"2025-02-18 21:40:00","inspection_id":"83899789","insp_unit_id":"205383464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7853154,"change_date":"2025-02-12 21:39:00","inspection_id":"83849803","dot_number":"3796705","report_state":"NV","report_number":"7301028610","insp_date":"2025-02-11 00:00:00","insp_start_time":"1549","insp_end_time":"1606","registration_date":"2025-02-12 00:00:00","region":"PT","ci_status_code":"C","location":"2","location_desc":"CHECK SITE - GARSON","county_code_state":"NV","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPRINGWOOD INDUSTRIAL","shipping_paper_number":"8118865","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-02-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"786674","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":"M","census_search_date":"2025-02-12 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"4NVS001","mcmis_add_date":"2025-02-12 21:39:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:12.000000Z","updated_at":"2025-03-17T21:01:12.000000Z","inspection_violations":[{"id":12272804,"change_date":"2025-02-12 21:39:00","inspection_id":"83849803","insp_violation_id":"264483310","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205291352","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39617CPI"},{"id":12272805,"change_date":"2025-02-12 21:39:00","inspection_id":"83849803","insp_violation_id":"264483311","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"205291352","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12674628,"change_date":"2025-02-12 21:39:00","inspection_id":"83849803","insp_unit_id":"205291352","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:59.000000Z","updated_at":"2025-03-17T23:54:59.000000Z"},{"id":12674629,"change_date":"2025-02-12 21:39:00","inspection_id":"83849803","insp_unit_id":"205291353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR","insp_unit_company":"1","insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:59.000000Z","updated_at":"2025-03-17T23:54:59.000000Z"}]},{"id":7655410,"change_date":"2025-01-17 21:40:00","inspection_id":"83641885","dot_number":"3796705","report_state":"CA","report_number":"UDXH000744","insp_date":"2025-01-17 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"I-80 E\/B WEST OF TOLL PLAZA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23999","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":"15668885","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-01-17 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-17 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"3796705","created_at":"2025-03-17T20:57:03.000000Z","updated_at":"2025-03-17T20:57:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12352603,"change_date":"2025-01-17 21:40:00","inspection_id":"83641885","insp_unit_id":"204903750","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2 AXLE\/WHT","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:19.000000Z","updated_at":"2025-03-17T23:51:19.000000Z"},{"id":12352604,"change_date":"2025-01-17 21:40:00","inspection_id":"83641885","insp_unit_id":"204903751","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:19.000000Z","updated_at":"2025-03-17T23:51:19.000000Z"}]},{"id":7586890,"change_date":"2025-01-09 21:41:00","inspection_id":"83569967","dot_number":"3796705","report_state":"CA","report_number":"UDYB000207","insp_date":"2025-01-08 00:00:00","insp_start_time":"1915","insp_end_time":"1957","registration_date":null,"region":"PT","ci_status_code":"C","location":"130","location_desc":"NB I-5 SOF BOWMAN RD","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WESTLAKE STONE","shipping_paper_number":"10375267","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-01-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23940","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15655111","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2025-01-09 21:41:00","snet_input_date":"2025-01-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-09 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:41.000000Z","updated_at":"2025-03-17T20:55:41.000000Z","inspection_violations":[{"id":11860872,"change_date":"2025-01-09 21:41:00","inspection_id":"83569967","insp_violation_id":"263850157","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RC11639","created_at":"2025-03-17T22:03:49.000000Z","updated_at":"2025-03-17T22:03:49.000000Z","normalized_code":"3922SLLTCD"},{"id":11860873,"change_date":"2025-01-09 21:41:00","inspection_id":"83569967","insp_violation_id":"263850158","seq_no":"2","part_no":"395","part_no_section":"24D-ELDPT","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:03:49.000000Z","updated_at":"2025-03-17T22:03:49.000000Z","normalized_code":"39524DELDPT"},{"id":11860874,"change_date":"2025-01-09 21:41:00","inspection_id":"83569967","insp_violation_id":"263850159","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"204736132","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:49.000000Z","updated_at":"2025-03-17T22:03:49.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12241655,"change_date":"2025-01-09 21:41:00","inspection_id":"83569967","insp_unit_id":"204736131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"67452X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL5KG524207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:08.000000Z","updated_at":"2025-03-17T23:50:08.000000Z"},{"id":12241656,"change_date":"2025-01-09 21:41:00","inspection_id":"83569967","insp_unit_id":"204736132","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGTX","insp_unit_company":null,"insp_unit_license":"4VC8182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:08.000000Z","updated_at":"2025-03-17T23:50:08.000000Z"}]},{"id":7511428,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","dot_number":"3796705","report_state":"CA","report_number":"UDR4005268","insp_date":"2024-12-16 00:00:00","insp_start_time":"1245","insp_end_time":"1255","registration_date":null,"region":"PT","ci_status_code":"C","location":"150","location_desc":"UKIAH AREA - RIDGEWOOD SCALE","county_code_state":"CA","county_code":"045","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23900","viol_total":"11","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15643823","transaction_code":"A","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-12-27 21:38:00","snet_input_date":"2024-12-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:52:42.000000Z","updated_at":"2025-03-17T20:52:42.000000Z","inspection_violations":[{"id":11740074,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678517","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3922SLLEQP"},{"id":11740075,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678518","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39021TB2DOT"},{"id":11740076,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678519","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RS92385","created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"38323A2LCDLN"},{"id":11740077,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678520","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"204577365","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3922SLLSR"},{"id":11740078,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678521","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3922SLLSR"},{"id":11740079,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678522","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3922SLLSR"},{"id":11740080,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678523","seq_no":"7","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3922SLLEQP"},{"id":11740081,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678524","seq_no":"8","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39311A1LIL"},{"id":11740082,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678525","seq_no":"9","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"204577365","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39343DB"},{"id":11740083,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678526","seq_no":"10","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"2","insp_unit_id":"204577365","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39311A1LCL"},{"id":11740084,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_violation_id":"263678527","seq_no":"11","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"204577364","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA556820","created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":12118024,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_unit_id":"204577364","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"28158W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRML3JG201097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:47.000000Z","updated_at":"2025-03-17T23:48:47.000000Z"},{"id":12118025,"change_date":"2024-12-27 21:38:00","inspection_id":"83490748","insp_unit_id":"204577365","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:47.000000Z","updated_at":"2025-03-17T23:48:47.000000Z"}]},{"id":7289703,"change_date":"2024-11-27 21:39:00","inspection_id":"83257563","dot_number":"3796705","report_state":"WA","report_number":"X887002015","insp_date":"2024-11-25 00:00:00","insp_start_time":"1415","insp_end_time":"1545","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC77","location_desc":"KELSO WA","county_code_state":"WA","county_code":"015","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PCI SCAFFOLD","shipping_paper_number":"11-25-2024","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-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22300","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":"1098037","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:09.000000Z","updated_at":"2025-03-17T20:48:09.000000Z","inspection_violations":[{"id":11398198,"change_date":"2024-11-27 21:39:00","inspection_id":"83257563","insp_violation_id":"263117166","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"204077695","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:20.000000Z","updated_at":"2025-03-17T22:01:20.000000Z","normalized_code":"3922SLLIRP"},{"id":11398199,"change_date":"2024-11-27 21:39:00","inspection_id":"83257563","insp_violation_id":"263117167","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204077695","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:20.000000Z","updated_at":"2025-03-17T22:01:20.000000Z","normalized_code":"39617CPI"},{"id":11398200,"change_date":"2024-11-27 21:39:00","inspection_id":"83257563","insp_violation_id":"263117168","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204077696","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:20.000000Z","updated_at":"2025-03-17T22:01:20.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":11758619,"change_date":"2024-11-27 21:39:00","inspection_id":"83257563","insp_unit_id":"204077695","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"2","insp_unit_license":"09971Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3GL4RG242360","insp_unit_decal":"Y","insp_unit_decal_number":"34647395","created_at":"2025-03-17T23:44:52.000000Z","updated_at":"2025-03-17T23:44:52.000000Z"},{"id":11758620,"change_date":"2024-11-27 21:39:00","inspection_id":"83257563","insp_unit_id":"204077696","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PLATT TRAI","insp_unit_company":null,"insp_unit_license":"4VC8139","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7XA1F3020RB000464","insp_unit_decal":"Y","insp_unit_decal_number":"34647396","created_at":"2025-03-17T23:44:52.000000Z","updated_at":"2025-03-17T23:44:52.000000Z"}]},{"id":7263762,"change_date":"2024-11-22 21:41:00","inspection_id":"83230133","dot_number":"3796705","report_state":"CA","report_number":"NDUP006472","insp_date":"2024-11-07 00:00:00","insp_start_time":"1224","insp_end_time":"1258","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23999","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":"15602841","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:47:41.000000Z","updated_at":"2025-03-17T20:47:41.000000Z","inspection_violations":[{"id":11355595,"change_date":"2024-11-22 21:41:00","inspection_id":"83230133","insp_violation_id":"263053148","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204020688","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:08.000000Z","updated_at":"2025-03-17T22:01:08.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":11716390,"change_date":"2024-11-22 21:41:00","inspection_id":"83230133","insp_unit_id":"204020688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X WHITE","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"Y","insp_unit_decal_number":"34474323","created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"},{"id":11716391,"change_date":"2024-11-22 21:41:00","inspection_id":"83230133","insp_unit_id":"204020689","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"2X","insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:26.000000Z","updated_at":"2025-03-17T23:44:26.000000Z"}]},{"id":7072648,"change_date":"2024-10-29 21:42:00","inspection_id":"83027901","dot_number":"3796705","report_state":"NV","report_number":"7301028331","insp_date":"2024-10-28 00:00:00","insp_start_time":"1321","insp_end_time":"1339","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"SR439 \/ 4 ST","county_code_state":"NV","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RESIDENCE ON MAIN","shipping_paper_number":"245465","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19990","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"778556","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-28 00:00:00","source_office":"4NVS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:27.000000Z","updated_at":"2025-03-17T20:43:27.000000Z","inspection_violations":[{"id":11039724,"change_date":"2024-10-29 21:42:00","inspection_id":"83027901","insp_violation_id":"262615729","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"203639697","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"39021TB2DOT"},{"id":11039725,"change_date":"2024-10-29 21:42:00","inspection_id":"83027901","insp_violation_id":"262615730","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"203639697","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"3922SLL"},{"id":11039726,"change_date":"2024-10-29 21:42:00","inspection_id":"83027901","insp_violation_id":"262615731","seq_no":"1","part_no":"395","part_no_section":"8D5-HOSF","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:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"3958D5HOSF"}],"inspection_per_units":[{"id":11406511,"change_date":"2024-10-29 21:42:00","inspection_id":"83027901","insp_unit_id":"203639697","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1","insp_unit_license":"56212Z3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2GC4YNEY9R1202133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"},{"id":11406512,"change_date":"2024-10-29 21:42:00","inspection_id":"83027901","insp_unit_id":"203639698","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"1","insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":6886122,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","dot_number":"3796705","report_state":"CA","report_number":"UECE006461","insp_date":"2024-10-03 00:00:00","insp_start_time":"1130","insp_end_time":"1155","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"I-80 W\/B ANTELOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LITHIA AUTO STORES","shipping_paper_number":"2597796","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15544638","transaction_code":"A","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-10-03 21:43:00","snet_input_date":"2024-10-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-03 21:43:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:39:48.000000Z","updated_at":"2025-03-17T20:39:48.000000Z","inspection_violations":[{"id":10727229,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","insp_violation_id":"262180752","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203263373","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"3922"},{"id":10727230,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","insp_violation_id":"262180753","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"3922"},{"id":10727231,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","insp_violation_id":"262180754","seq_no":"3","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"203263373","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"39367C7V"},{"id":10727232,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","insp_violation_id":"262180755","seq_no":"4","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":11105603,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","insp_unit_id":"203263373","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:00.000000Z","updated_at":"2025-03-17T23:38:00.000000Z"},{"id":11105604,"change_date":"2024-10-03 21:43:00","inspection_id":"82829653","insp_unit_id":"203263374","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GAT","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:00.000000Z","updated_at":"2025-03-17T23:38:00.000000Z"}]},{"id":6693416,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","dot_number":"3796705","report_state":"CA","report_number":"UBZU003882","insp_date":"2024-09-09 00:00:00","insp_start_time":"1045","insp_end_time":"1150","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15516595","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-09-10 21:40:00","snet_input_date":"2024-09-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-10 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:35:41.000000Z","updated_at":"2025-03-17T20:35:41.000000Z","inspection_violations":[{"id":10419653,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_violation_id":"261726797","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202856797","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ37209","created_at":"2025-03-17T21:56:26.000000Z","updated_at":"2025-03-17T21:56:26.000000Z","normalized_code":"3922"},{"id":10419654,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_violation_id":"261726798","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"202856797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ37209","created_at":"2025-03-17T21:56:26.000000Z","updated_at":"2025-03-17T21:56:26.000000Z","normalized_code":"39360D"},{"id":10419655,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_violation_id":"261726799","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202856797","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:26.000000Z","updated_at":"2025-03-17T21:56:26.000000Z","normalized_code":"3922"},{"id":10419656,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_violation_id":"261726800","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202856797","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:26.000000Z","updated_at":"2025-03-17T21:56:26.000000Z","normalized_code":"39360C"},{"id":10419657,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_violation_id":"261726801","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202856797","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:26.000000Z","updated_at":"2025-03-17T21:56:26.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10792617,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_unit_id":"202856797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"},{"id":10792618,"change_date":"2024-09-10 21:40:00","inspection_id":"82624623","insp_unit_id":"202856798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"}]},{"id":6653520,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","dot_number":"3796705","report_state":"WA","report_number":"X775000219","insp_date":"2024-08-29 00:00:00","insp_start_time":"0923","insp_end_time":"1045","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DRAGON JACKET","shipping_paper_number":"GPO102216","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-09-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"8","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":"818040","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-09-05 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-05 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:52.000000Z","updated_at":"2025-03-17T20:34:52.000000Z","inspection_violations":[{"id":10354302,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627941","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"202771213","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4A0144110","created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39348A"},{"id":10354303,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627942","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202771212","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39617C"},{"id":10354304,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627943","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202771213","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39617C"},{"id":10354305,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627944","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202771212","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39395F"},{"id":10354306,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627945","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202771212","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"3922"},{"id":10354307,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627946","seq_no":"6","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"1","insp_unit_id":"202771212","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39343D"},{"id":10354308,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627947","seq_no":"7","part_no":"395","part_no_section":"8(e)(1)","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-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"3958E1"},{"id":10354309,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_violation_id":"261627948","seq_no":"8","part_no":"395","part_no_section":"8(e)(1)","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-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10727470,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_unit_id":"202771212","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"28158W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRML3JG201097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:05.000000Z","updated_at":"2025-03-17T23:34:05.000000Z"},{"id":10727471,"change_date":"2024-09-05 21:42:00","inspection_id":"82582180","insp_unit_id":"202771213","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:05.000000Z","updated_at":"2025-03-17T23:34:05.000000Z"}]},{"id":6520878,"change_date":"2024-08-21 21:41:00","inspection_id":"82440881","dot_number":"3796705","report_state":"AZ","report_number":"XE55030279","insp_date":"2024-08-14 00:00:00","insp_start_time":"0646","insp_end_time":"0713","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"LITTLEFIELD AZ","county_code_state":"AZ","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ABC SUPPLY","shipping_paper_number":"4776939","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":"U","pen_cen_match":"I","final_status_date":"2024-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"765391","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-08-21 21:41:00","snet_input_date":"2024-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-21 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:18.000000Z","updated_at":"2025-03-17T20:32:18.000000Z","inspection_violations":[{"id":10130809,"change_date":"2024-08-21 21:41:00","inspection_id":"82440881","insp_violation_id":"261311032","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202499179","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3922"},{"id":10130810,"change_date":"2024-08-21 21:41:00","inspection_id":"82440881","insp_violation_id":"261311033","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39141A"},{"id":10130811,"change_date":"2024-08-21 21:41:00","inspection_id":"82440881","insp_violation_id":"261311034","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10512143,"change_date":"2024-08-21 21:41:00","inspection_id":"82440881","insp_unit_id":"202499179","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:53.000000Z","updated_at":"2025-03-17T23:31:53.000000Z"},{"id":10512144,"change_date":"2024-08-21 21:41:00","inspection_id":"82440881","insp_unit_id":"202499180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4VK4660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F412XN6161807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:53.000000Z","updated_at":"2025-03-17T23:31:53.000000Z"}]},{"id":6251847,"change_date":"2024-07-18 21:41:00","inspection_id":"82153425","dot_number":"3796705","report_state":"CA","report_number":"N9PI008020","insp_date":"2024-07-15 00:00:00","insp_start_time":"2003","insp_end_time":"2019","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25499","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":"15443623","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:26:38.000000Z","updated_at":"2025-03-17T20:26:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10073430,"change_date":"2024-07-18 21:41:00","inspection_id":"82153425","insp_unit_id":"201954288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHT 01","insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"},{"id":10073431,"change_date":"2024-07-18 21:41:00","inspection_id":"82153425","insp_unit_id":"201954289","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"FB TRL","insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":5989216,"change_date":"2024-06-13 21:43:00","inspection_id":"81870736","dot_number":"3796705","report_state":"CA","report_number":"ND7N008066","insp_date":"2024-06-11 00:00:00","insp_start_time":"1737","insp_end_time":"1752","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"21340","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":"15400763","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-06-13 21:43:00","snet_input_date":"2024-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:43:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:28.000000Z","updated_at":"2025-03-17T20:21:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9646856,"change_date":"2024-06-13 21:43:00","inspection_id":"81870736","insp_unit_id":"201389955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X WHT","insp_unit_license":"CN34B87","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2GC4YNEY9R1202133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"},{"id":9646857,"change_date":"2024-06-13 21:43:00","inspection_id":"81870736","insp_unit_id":"201389956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2X BLK","insp_unit_license":"4VW9463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"}]},{"id":5958441,"change_date":"2024-06-11 21:41:00","inspection_id":"81837167","dot_number":"3796705","report_state":"WA","report_number":"X775000181","insp_date":"2024-06-10 00:00:00","insp_start_time":"1115","insp_end_time":"1148","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","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-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21246","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":"559675","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-06-11 21:41:00","snet_input_date":"2024-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-11 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:43.000000Z","updated_at":"2025-03-17T20:20:43.000000Z","inspection_violations":[{"id":9243609,"change_date":"2024-06-11 21:41:00","inspection_id":"81837167","insp_violation_id":"260010454","seq_no":"1","part_no":"395","part_no_section":"30(b)(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:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"39530B1"},{"id":9243610,"change_date":"2024-06-11 21:41:00","inspection_id":"81837167","insp_violation_id":"260010455","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"3922"},{"id":9243611,"change_date":"2024-06-11 21:41:00","inspection_id":"81837167","insp_violation_id":"260010456","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","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-17T21:50:44.000000Z","updated_at":"2025-03-17T21:50:44.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":9597532,"change_date":"2024-06-11 21:41:00","inspection_id":"81837167","insp_unit_id":"201326723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"8039716","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2GC4YNEY9R1202133","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:32.000000Z","updated_at":"2025-03-17T23:22:32.000000Z"},{"id":9597533,"change_date":"2024-06-11 21:41:00","inspection_id":"81837167","insp_unit_id":"201326724","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"4VW946","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F4421R6314642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:32.000000Z","updated_at":"2025-03-17T23:22:32.000000Z"}]},{"id":5988437,"change_date":"2024-06-13 21:42:00","inspection_id":"81869926","dot_number":"3796705","report_state":"CA","report_number":"NCZ3006797","insp_date":"2024-05-31 00:00:00","insp_start_time":"1209","insp_end_time":"1232","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"15401762","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-05-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"61655","created_at":"2025-03-17T20:21:28.000000Z","updated_at":"2025-03-17T20:21:28.000000Z","inspection_violations":[{"id":9290695,"change_date":"2024-06-13 21:42:00","inspection_id":"81869926","insp_violation_id":"260079256","seq_no":"1","part_no":"395","part_no_section":"24(d)","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:50:57.000000Z","updated_at":"2025-03-17T21:50:57.000000Z","normalized_code":"39524D"},{"id":9290696,"change_date":"2024-06-13 21:42:00","inspection_id":"81869926","insp_violation_id":"260079257","seq_no":"2","part_no":"395","part_no_section":"22(h)(2)","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:50:57.000000Z","updated_at":"2025-03-17T21:50:57.000000Z","normalized_code":"39522H2"}],"inspection_per_units":[{"id":9645725,"change_date":"2024-06-13 21:42:00","inspection_id":"81869926","insp_unit_id":"201388735","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"Y","insp_unit_decal_number":"33817634","created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"},{"id":9645726,"change_date":"2024-06-13 21:42:00","inspection_id":"81869926","insp_unit_id":"201388736","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"Y","insp_unit_decal_number":"33817635","created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"}]},{"id":5871253,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","dot_number":"3796705","report_state":"CA","report_number":"UG4W001446","insp_date":"2024-05-28 00:00:00","insp_start_time":"1208","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"201","location_desc":"ANTELOPE E\/B","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DIAMOND METALS","shipping_paper_number":"371097","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"20","oos_total":"1","driver_viol_total":"16","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15381755","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:19:05.000000Z","updated_at":"2025-03-17T20:19:05.000000Z","inspection_violations":[{"id":9103980,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800451","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201144019","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9103981,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800452","seq_no":"2","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"201144019","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39360E"},{"id":9103982,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800453","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201144019","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3922"},{"id":9103983,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800454","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"201144019","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3969D2"},{"id":9103984,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800455","seq_no":"5","part_no":"383","part_no_section":"91(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"38391A"},{"id":9103985,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800456","seq_no":"6","part_no":"395","part_no_section":"24(c)(2)(iii)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39524C2III"},{"id":9103986,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800457","seq_no":"7","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3953A2"},{"id":9103987,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800458","seq_no":"8","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3953A2"},{"id":9103988,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800459","seq_no":"9","part_no":"395","part_no_section":"24(c)(2)(iii)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39524C2III"},{"id":9103989,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800460","seq_no":"10","part_no":"395","part_no_section":"24(c)(2)(iii)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39524C2III"},{"id":9103990,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800461","seq_no":"11","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"3953A3I"},{"id":9103991,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800462","seq_no":"12","part_no":"395","part_no_section":"24(c)(2)(iii)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39524C2III"},{"id":9103992,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800463","seq_no":"13","part_no":"395","part_no_section":"24(c)(2)(iii)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39524C2III"},{"id":9103993,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800464","seq_no":"14","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"},{"id":9103994,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800465","seq_no":"15","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"},{"id":9103995,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800466","seq_no":"16","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"},{"id":9103996,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800467","seq_no":"17","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"},{"id":9103997,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800468","seq_no":"18","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"},{"id":9103998,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800469","seq_no":"19","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"},{"id":9103999,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_violation_id":"259800470","seq_no":"20","part_no":"395","part_no_section":"30(b)(1)","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:50:01.000000Z","updated_at":"2025-03-17T21:50:01.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":9456213,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_unit_id":"201144019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"05","insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:06.000000Z","updated_at":"2025-03-17T23:21:06.000000Z"},{"id":9456214,"change_date":"2024-05-29 21:41:00","inspection_id":"81742369","insp_unit_id":"201144020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":"05","insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:06.000000Z","updated_at":"2025-03-17T23:21:06.000000Z"}]},{"id":5888453,"change_date":"2024-05-31 21:39:00","inspection_id":"81760996","dot_number":"3796705","report_state":"CA","report_number":"NCNG007772","insp_date":"2024-05-23 00:00:00","insp_start_time":"1553","insp_end_time":"1704","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLERF EQUIPMENT","shipping_paper_number":"281345","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22290","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15384868","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:19:27.000000Z","updated_at":"2025-03-17T20:19:27.000000Z","inspection_violations":[{"id":9129827,"change_date":"2024-05-31 21:39:00","inspection_id":"81760996","insp_violation_id":"259842705","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201182019","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3922"},{"id":9129828,"change_date":"2024-05-31 21:39:00","inspection_id":"81760996","insp_violation_id":"259842706","seq_no":"2","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"201182019","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39343D"},{"id":9129829,"change_date":"2024-05-31 21:39:00","inspection_id":"81760996","insp_violation_id":"259842707","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201182018","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9484003,"change_date":"2024-05-31 21:39:00","inspection_id":"81760996","insp_unit_id":"201182018","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"09971Y3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3GL4RG242360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:23.000000Z","updated_at":"2025-03-17T23:21:23.000000Z"},{"id":9484004,"change_date":"2024-05-31 21:39:00","inspection_id":"81760996","insp_unit_id":"201182019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"4UG8038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:23.000000Z","updated_at":"2025-03-17T23:21:23.000000Z"}]},{"id":5797817,"change_date":"2024-05-20 21:43:00","inspection_id":"81662609","dot_number":"3796705","report_state":"CA","report_number":"UD7O002367","insp_date":"2024-05-19 00:00:00","insp_start_time":"1835","insp_end_time":"1852","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"35990","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":"15370501","transaction_code":"A","transaction_date":"2024-05-19 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-05-20 21:43:00","snet_input_date":"2024-05-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-20 21:43:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:17:33.000000Z","updated_at":"2025-03-17T20:17:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9338281,"change_date":"2024-05-20 21:43:00","inspection_id":"81662609","insp_unit_id":"200993031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2XL\/WHI","insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"Y","insp_unit_decal_number":"33822732","created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"},{"id":9338282,"change_date":"2024-05-20 21:43:00","inspection_id":"81662609","insp_unit_id":"200993032","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":"2XL\/ BLK","insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"}]},{"id":5760391,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","dot_number":"3796705","report_state":"CA","report_number":"UDAJ002323","insp_date":"2024-05-14 00:00:00","insp_start_time":"1220","insp_end_time":"1330","registration_date":null,"region":"PT","ci_status_code":"C","location":"130","location_desc":"I-5 N\/B COOTONWOOD SCALES","county_code_state":"CA","county_code":"103","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":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"8","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15363711","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:03.000000Z","updated_at":"2025-03-17T20:17:03.000000Z","inspection_violations":[{"id":8916332,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531215","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8916333,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531216","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8916334,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531217","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"200916576","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39021TA"},{"id":8916335,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531218","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200916576","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8916336,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531219","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200916576","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8916337,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531220","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200916576","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MR51866","created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8916338,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531221","seq_no":"7","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"MR51866","created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"38323A2"},{"id":8916339,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_violation_id":"259531222","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9278125,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_unit_id":"200916576","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"},{"id":9278126,"change_date":"2024-05-15 21:44:00","inspection_id":"81622340","insp_unit_id":"200916577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"}]},{"id":5714743,"change_date":"2024-05-09 21:43:00","inspection_id":"81572830","dot_number":"3796705","report_state":"CA","report_number":"UCCC002781","insp_date":"2024-05-09 00:00:00","insp_start_time":"1103","insp_end_time":"1118","registration_date":null,"region":"PT","ci_status_code":"C","location":"240","location_desc":"GRIDLEY,CA","county_code_state":"CA","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"23490","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":"15356056","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-05-09 21:43:00","snet_input_date":"2024-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-09 21:43:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:55.000000Z","updated_at":"2025-03-17T20:15:55.000000Z","inspection_violations":[{"id":8842459,"change_date":"2024-05-09 21:43:00","inspection_id":"81572830","insp_violation_id":"259422211","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200822377","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9204615,"change_date":"2024-05-09 21:43:00","inspection_id":"81572830","insp_unit_id":"200822377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:38.000000Z","updated_at":"2025-03-17T23:18:38.000000Z"},{"id":9204616,"change_date":"2024-05-09 21:43:00","inspection_id":"81572830","insp_unit_id":"200822378","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:38.000000Z","updated_at":"2025-03-17T23:18:38.000000Z"}]},{"id":5736287,"change_date":"2024-05-14 21:41:00","inspection_id":"81596204","dot_number":"3796705","report_state":"AZ","report_number":"E970200128","insp_date":"2024-05-08 00:00:00","insp_start_time":"0934","insp_end_time":"1023","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZEREB","location_desc":"EHRENBERG AZ","county_code_state":"AZ","county_code":"012","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HERC RENTALS","shipping_paper_number":"46960230LN","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-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"478104","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-05-14 21:41:00","snet_input_date":"2024-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-14 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:20.000000Z","updated_at":"2025-03-17T20:16:20.000000Z","inspection_violations":[{"id":8878639,"change_date":"2024-05-14 21:41:00","inspection_id":"81596204","insp_violation_id":"259477467","seq_no":"1","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-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39524"},{"id":8878640,"change_date":"2024-05-14 21:41:00","inspection_id":"81596204","insp_violation_id":"259477468","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-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39524"},{"id":8878641,"change_date":"2024-05-14 21:41:00","inspection_id":"81596204","insp_violation_id":"259477469","seq_no":"3","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-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39524"}],"inspection_per_units":[{"id":9239222,"change_date":"2024-05-14 21:41:00","inspection_id":"81596204","insp_unit_id":"200867985","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:58.000000Z","updated_at":"2025-03-17T23:18:58.000000Z"},{"id":9239223,"change_date":"2024-05-14 21:41:00","inspection_id":"81596204","insp_unit_id":"200867986","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:58.000000Z","updated_at":"2025-03-17T23:18:58.000000Z"}]},{"id":5507859,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","dot_number":"3796705","report_state":"WA","report_number":"X761000350","insp_date":"2024-04-12 00:00:00","insp_start_time":"1129","insp_end_time":"1310","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC77","location_desc":"KELSO WA","county_code_state":"WA","county_code":"015","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FLEETGENIUS PACIFIC NW","shipping_paper_number":"8251351","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-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"10","oos_total":"4","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"398667","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-04-15 21:40:00","snet_input_date":"2024-04-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-15 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:56.000000Z","updated_at":"2025-03-17T20:11:56.000000Z","inspection_violations":[{"id":8509484,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923431","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200389805","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3963A1"},{"id":8509485,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923432","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200389804","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3963A1"},{"id":8509486,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923433","seq_no":"3","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"38323A2"},{"id":8509487,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923434","seq_no":"4","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"200389804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39021TB1"},{"id":8509488,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923435","seq_no":"5","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"200389804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39021TB2"},{"id":8509489,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923436","seq_no":"6","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39111B2"},{"id":8509490,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923437","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200389804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"},{"id":8509491,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923438","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200389804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"},{"id":8509492,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923439","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"},{"id":8509493,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_violation_id":"258923440","seq_no":"10","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"4A0296994","created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":8872399,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_unit_id":"200389804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"96922W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRGL2JG330315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:32.000000Z","updated_at":"2025-03-17T23:15:32.000000Z"},{"id":8872400,"change_date":"2024-04-15 21:40:00","inspection_id":"81347613","insp_unit_id":"200389805","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:32.000000Z","updated_at":"2025-03-17T23:15:32.000000Z"}]},{"id":5401607,"change_date":"2024-03-29 21:38:00","inspection_id":"81231194","dot_number":"3796705","report_state":"CA","report_number":"NDZM003317","insp_date":"2024-03-11 00:00:00","insp_start_time":"0852","insp_end_time":"0952","registration_date":null,"region":"PT","ci_status_code":"C","location":"325","location_desc":"107 ENTRADA CIR AMERICANCANYON","county_code_state":"CA","county_code":"055","insp_level_id":"5","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-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21600","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":"15300568","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[{"id":8336703,"change_date":"2024-03-29 21:38:00","inspection_id":"81231194","insp_violation_id":"258663147","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"200160947","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"393205C"},{"id":8336704,"change_date":"2024-03-29 21:38:00","inspection_id":"81231194","insp_violation_id":"258663148","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"200160948","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"393205C"},{"id":8336705,"change_date":"2024-03-29 21:38:00","inspection_id":"81231194","insp_violation_id":"258663149","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"200160948","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":8699768,"change_date":"2024-03-29 21:38:00","inspection_id":"81231194","insp_unit_id":"200160947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"02","insp_unit_license":"68252R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3DL7DG584351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8699769,"change_date":"2024-03-29 21:38:00","inspection_id":"81231194","insp_unit_id":"200160948","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"02","insp_unit_license":"4UG8038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":5401608,"change_date":"2024-03-29 21:38:00","inspection_id":"81231195","dot_number":"3796705","report_state":"CA","report_number":"NDZM003318","insp_date":"2024-03-11 00:00:00","insp_start_time":"0955","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"325","location_desc":"107 ENTRADA CIR AMERICANCANYON","county_code_state":"CA","county_code":"055","insp_level_id":"5","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-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","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":"15300163","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[{"id":8336706,"change_date":"2024-03-29 21:38:00","inspection_id":"81231195","insp_violation_id":"258663150","seq_no":"1","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"200160949","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39347D"}],"inspection_per_units":[{"id":8699770,"change_date":"2024-03-29 21:38:00","inspection_id":"81231195","insp_unit_id":"200160949","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"01","insp_unit_license":"9586953","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8699771,"change_date":"2024-03-29 21:38:00","inspection_id":"81231195","insp_unit_id":"200160950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"01","insp_unit_license":"4UG5451","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4Z1GF4029NS006037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":5401609,"change_date":"2024-03-29 21:38:00","inspection_id":"81231196","dot_number":"3796705","report_state":"CA","report_number":"NDZM003319","insp_date":"2024-03-11 00:00:00","insp_start_time":"1102","insp_end_time":"1135","registration_date":null,"region":"PT","ci_status_code":"C","location":"325","location_desc":"107 ENTRADE CIR AMERICANCANYON","county_code_state":"CA","county_code":"055","insp_level_id":"5","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-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"15300139","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"1050 NAPA RD","insp_carrier_city":"SONOMA","insp_carrier_state":"CA","insp_carrier_zip_code":"95476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"611655","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8699772,"change_date":"2024-03-29 21:38:00","inspection_id":"81231196","insp_unit_id":"200160951","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"03","insp_unit_license":"67452X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL5KG524207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":4453527,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","dot_number":"3796705","report_state":"NV","report_number":"7143020409","insp_date":"2023-11-14 00:00:00","insp_start_time":"0849","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"MOGUL, NV","county_code_state":"NV","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"D03-6298471","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-11-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"750466","transaction_code":"C","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":"M","census_search_date":"2023-11-17 21:41:00","snet_input_date":"2023-11-14 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-11-17 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"107 ENTRADA CIR","insp_carrier_city":"AMERICAN CYN","insp_carrier_state":"CA","insp_carrier_zip_code":"94503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:05.000000Z","updated_at":"2025-03-17T19:51:05.000000Z","inspection_violations":[{"id":6893411,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492627","seq_no":"1","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39111B2"},{"id":6893412,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492628","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198148398","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3922"},{"id":6893413,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492629","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198148398","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"3922"},{"id":6893414,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492630","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198148398","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39395A"},{"id":6893415,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492631","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198148398","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39375A3"},{"id":6893416,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492632","seq_no":"6","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"198148399","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"393104F3"},{"id":6893417,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_violation_id":"256492633","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"198148399","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:14.000000Z","updated_at":"2025-03-17T21:39:14.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7162111,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_unit_id":"198148398","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL5KG524207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:08.000000Z","updated_at":"2025-03-17T23:00:08.000000Z"},{"id":7162112,"change_date":"2023-11-20 21:40:00","inspection_id":"80194854","insp_unit_id":"198148399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ICON","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:08.000000Z","updated_at":"2025-03-17T23:00:08.000000Z"}]},{"id":3825495,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","dot_number":"3796705","report_state":"NV","report_number":"7468019536","insp_date":"2023-08-23 00:00:00","insp_start_time":"2200","insp_end_time":"2220","registration_date":"2023-09-07 00:00:00","region":"PT","ci_status_code":"C","location":"3","location_desc":"OSINO CHECKSITE","county_code_state":"NV","county_code":"007","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRAZIER","shipping_paper_number":"71031","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"2","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"744485","transaction_code":"C","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":"M","census_search_date":"2023-08-24 21:41:00","snet_input_date":"2023-08-23 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-08-24 21:41:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"107 ENTRADA CIR","insp_carrier_city":"AMERICAN CYN","insp_carrier_state":"CA","insp_carrier_zip_code":"94503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:30.000000Z","updated_at":"2025-03-17T19:38:30.000000Z","inspection_violations":[{"id":5906492,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_violation_id":"255142409","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X02690761","created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3922"},{"id":5906493,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_violation_id":"255142410","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3958A1"},{"id":5906494,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_violation_id":"255142411","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39141A"},{"id":5906495,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_violation_id":"255142412","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196950514","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3922"},{"id":5906496,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_violation_id":"255142413","seq_no":"5","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"196950515","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3929A1"},{"id":5906497,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_violation_id":"255142414","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196950514","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6150828,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_unit_id":"196950514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"95869S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3MG640380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"},{"id":6150829,"change_date":"2023-09-07 21:41:00","inspection_id":"79498442","insp_unit_id":"196950515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MPCT","insp_unit_company":null,"insp_unit_license":"4VJ1597","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4M9BG4022N1144367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"}]},{"id":3133064,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","dot_number":"3796705","report_state":"UT","report_number":"23XQ000150","insp_date":"2023-05-23 00:00:00","insp_start_time":"0845","insp_end_time":"0959","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"FILLMORE SOUTH EXIT","county_code_state":"UT","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ERIKS NORTH AMERICA","shipping_paper_number":"RS25599291","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"15","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"883753","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2023-05-24 21:40:00","snet_input_date":"2023-05-23 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-05-24 21:40:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"107 ENTRADA CIR","insp_carrier_city":"AMERICAN CYN","insp_carrier_state":"CA","insp_carrier_zip_code":"94503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4822657,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057017","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3958A1"},{"id":4822658,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057018","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39141A"},{"id":4822659,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057019","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195124616","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39617C"},{"id":4822660,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057020","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195124616","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"},{"id":4822661,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057021","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195124616","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39311"},{"id":4822662,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057022","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195124616","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3939A"},{"id":4822663,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057023","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"195124616","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39348A"},{"id":4822664,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057024","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195124616","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3963A1"},{"id":4822665,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057025","seq_no":"9","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39021TC"},{"id":4822666,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057026","seq_no":"10","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3969D2"},{"id":4822667,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057027","seq_no":"11","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39360D"},{"id":4822668,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057028","seq_no":"12","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39395A"},{"id":4822669,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057029","seq_no":"13","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39395F"},{"id":4822670,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057030","seq_no":"14","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39341"},{"id":4822671,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_violation_id":"253057031","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195124615","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5039321,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_unit_id":"195124615","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"02632A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63D3HLXCG137200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:43.000000Z","updated_at":"2025-03-17T22:42:43.000000Z"},{"id":5039322,"change_date":"2023-05-24 21:40:00","inspection_id":"78720664","insp_unit_id":"195124616","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:43.000000Z","updated_at":"2025-03-17T22:42:43.000000Z"}]},{"id":2526885,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","dot_number":"3796705","report_state":"UT","report_number":"23FO000145","insp_date":"2023-03-07 00:00:00","insp_start_time":"0721","insp_end_time":"0845","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"I-15 NB MP 33","county_code_state":"UT","county_code":"053","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SANITUBE","shipping_paper_number":"2045026","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":"Y","pen_cen_match":null,"final_status_date":"2023-03-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"23200","viol_total":"11","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"875693","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":null,"census_search_date":"2023-03-07 21:42:00","snet_input_date":"2023-03-07 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-03-07 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"107 ENTRADA CIR","insp_carrier_city":"AMERICAN CYN","insp_carrier_state":"CA","insp_carrier_zip_code":"94503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[{"id":3885266,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528674","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193755419","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39021TB"},{"id":3885267,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528675","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"193755419","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39360D"},{"id":3885268,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528676","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193755419","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39378"},{"id":3885269,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528677","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193755419","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39617C"},{"id":3885270,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528678","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193755419","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39395A"},{"id":3885271,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528679","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193755419","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39395F"},{"id":3885272,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528680","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193755420","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39617C"},{"id":3885273,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528681","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193755420","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39348A"},{"id":3885274,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528682","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193755420","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3963A1"},{"id":3885275,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528683","seq_no":"10","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3958A1"},{"id":3885276,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_violation_id":"251528684","seq_no":"11","part_no":"395","part_no_section":"22(h)(4)","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:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":4067510,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_unit_id":"193755419","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"384","insp_unit_license":"58151R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FT8W3AT7BEA99384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"},{"id":4067511,"change_date":"2023-03-07 21:42:00","inspection_id":"78033345","insp_unit_id":"193755420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"970","insp_unit_license":"4TS4595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7PE3H4024MS000970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"}]},{"id":966972,"change_date":"2022-08-09 21:41:00","inspection_id":"76239213","dot_number":"3796705","report_state":"NV","report_number":"7137182303","insp_date":"2022-08-03 00:00:00","insp_start_time":"2010","insp_end_time":"2045","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"IR15@SR146","county_code_state":"NV","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNSTATE EQUIP","shipping_paper_number":"594727","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21900","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":"718173","transaction_code":"C","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03796705","upload_search_indicator":"M","census_search_date":"2022-08-04 21:42:00","snet_input_date":"2022-08-03 00:00:00","source_office":"4NVS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"ESQUIVEL TRANSPORTATION LLC","insp_carrier_street":"107 ENTRADA CIR","insp_carrier_city":"AMERICAN CYN","insp_carrier_state":"CA","insp_carrier_zip_code":"94503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:45.000000Z","updated_at":"2025-03-17T18:44:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1556155,"change_date":"2022-08-09 21:41:00","inspection_id":"76239213","insp_unit_id":"190216466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"02632A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63D3HLXCG137200","insp_unit_decal":"Y","insp_unit_decal_number":"31746220","created_at":"2025-03-17T22:17:48.000000Z","updated_at":"2025-03-17T22:17:48.000000Z"},{"id":1556156,"change_date":"2022-08-09 21:41:00","inspection_id":"76239213","insp_unit_id":"190216467","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"4UG8038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3820N6123227","insp_unit_decal":"Y","insp_unit_decal_number":"31746221","created_at":"2025-03-17T22:17:48.000000Z","updated_at":"2025-03-17T22:17:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3796705\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3796705\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3796705\/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\/3796705\/inspections","per_page":100,"prev_page_url":null,"to":45,"total":45}