{"current_page":1,"data":[{"id":11774422,"change_date":"2026-04-28 21:40:00","inspection_id":"87705370","dot_number":"3410850","report_state":"CA","report_number":"UE03004846","insp_date":"2026-04-27 00:00:00","insp_start_time":"2000","insp_end_time":"2030","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16266421","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2026-04-28 21:40:00","snet_input_date":"2026-04-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-28 21:40:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:36.000000Z","updated_at":"2026-05-09T09:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20484011,"change_date":"2026-04-28 21:40:00","inspection_id":"87705370","insp_unit_id":"213277046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:21:06.000000Z","updated_at":"2026-05-09T09:04:22.000000Z"},{"id":20484012,"change_date":"2026-04-28 21:40:00","inspection_id":"87705370","insp_unit_id":"213277047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:21:06.000000Z","updated_at":"2026-05-09T09:04:22.000000Z"}]},{"id":11747023,"change_date":"2026-04-24 21:42:00","inspection_id":"87676560","dot_number":"3410850","report_state":"CA","report_number":"UE4K000174","insp_date":"2026-04-23 00:00:00","insp_start_time":"1330","insp_end_time":"1355","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"CHRISMAN RD AT VALPICO RD","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BASALITE","shipping_paper_number":"78085341","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","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":"16261501","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2026-04-24 21:42:00","snet_input_date":"2026-04-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-24 21:42:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"564970","created_at":"2026-04-27T09:42:40.000000Z","updated_at":"2026-05-05T09:32:02.000000Z","inspection_violations":[{"id":20424433,"change_date":"2026-04-24 21:42:00","inspection_id":"87676560","insp_violation_id":"273851862","seq_no":"1","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"213222882","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:33.000000Z","normalized_code":"39395A4EENA"},{"id":20424434,"change_date":"2026-04-24 21:42:00","inspection_id":"87676560","insp_violation_id":"273851863","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213222882","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:33.000000Z","normalized_code":"39378AWS"},{"id":20424435,"change_date":"2026-04-24 21:42:00","inspection_id":"87676560","insp_violation_id":"273851864","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213222883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:33.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":20438879,"change_date":"2026-04-24 21:42:00","inspection_id":"87676560","insp_unit_id":"213222882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"41123","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:45.000000Z","updated_at":"2026-05-05T09:05:08.000000Z"},{"id":20438880,"change_date":"2026-04-24 21:42:00","inspection_id":"87676560","insp_unit_id":"213222883","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"23090","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:45.000000Z","updated_at":"2026-05-05T09:05:08.000000Z"}]},{"id":11714761,"change_date":"2026-04-21 21:39:00","inspection_id":"87641934","dot_number":"3410850","report_state":"CA","report_number":"UCOM001374","insp_date":"2026-04-20 00:00:00","insp_start_time":"0925","insp_end_time":"0955","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"16257476","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:38:35.000000Z","updated_at":"2026-05-02T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20385781,"change_date":"2026-04-21 21:39:00","inspection_id":"87641934","insp_unit_id":"213148824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:15:20.000000Z","updated_at":"2026-05-02T09:04:21.000000Z"},{"id":20385782,"change_date":"2026-04-21 21:39:00","inspection_id":"87641934","insp_unit_id":"213148825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:15:20.000000Z","updated_at":"2026-05-02T09:04:21.000000Z"}]},{"id":11492762,"change_date":"2026-03-26 21:40:00","inspection_id":"87412531","dot_number":"3410850","report_state":"CA","report_number":"UE2C006551","insp_date":"2026-03-25 00:00:00","insp_start_time":"2000","insp_end_time":"2030","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16224618","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:23.000000Z","updated_at":"2026-04-06T09:34:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19687496,"change_date":"2026-03-26 21:40:00","inspection_id":"87412531","insp_unit_id":"212366737","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:16.000000Z"},{"id":19687497,"change_date":"2026-03-26 21:40:00","inspection_id":"87412531","insp_unit_id":"212366738","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X VAN","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:07.000000Z","updated_at":"2026-04-06T09:14:16.000000Z"}]},{"id":10462968,"change_date":"2025-12-17 21:39:00","inspection_id":"86595945","dot_number":"3410850","report_state":"CA","report_number":"UCOM001092","insp_date":"2025-12-15 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"16099471","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2025-12-17 21:39:00","snet_input_date":"2025-12-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:48.000000Z","updated_at":"2025-12-28T10:31:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17510366,"change_date":"2025-12-17 21:39:00","inspection_id":"86595945","insp_unit_id":"210672221","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:52.000000Z","updated_at":"2025-12-28T10:01:16.000000Z"},{"id":17510367,"change_date":"2025-12-17 21:39:00","inspection_id":"86595945","insp_unit_id":"210672222","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:52.000000Z","updated_at":"2025-12-28T10:01:16.000000Z"}]},{"id":10413564,"change_date":"2025-12-11 21:45:00","inspection_id":"86544404","dot_number":"3410850","report_state":"CA","report_number":"NC7K010560","insp_date":"2025-12-10 00:00:00","insp_start_time":"1106","insp_end_time":"1141","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-11 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16090958","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2025-12-11 21:45:00","snet_input_date":"2025-12-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-11 21:45:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:55.000000Z","updated_at":"2025-12-15T10:31:39.000000Z","inspection_violations":[{"id":17456264,"change_date":"2025-12-11 21:45:00","inspection_id":"86544404","insp_violation_id":"270635126","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"DA767683","created_at":"2025-12-14T10:32:51.000000Z","updated_at":"2025-12-15T10:33:10.000000Z","normalized_code":"39141APC"},{"id":17456265,"change_date":"2025-12-11 21:45:00","inspection_id":"86544404","insp_violation_id":"270635127","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"210563706","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:51.000000Z","updated_at":"2025-12-15T10:33:10.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":17456266,"change_date":"2025-12-11 21:45:00","inspection_id":"86544404","insp_violation_id":"270635128","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210563707","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:51.000000Z","updated_at":"2025-12-15T10:33:10.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17416216,"change_date":"2025-12-11 21:45:00","inspection_id":"86544404","insp_unit_id":"210563707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"12\/FB 2X","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:06.000000Z","updated_at":"2025-12-15T10:02:10.000000Z"},{"id":17416215,"change_date":"2025-12-11 21:45:00","inspection_id":"86544404","insp_unit_id":"210563706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10\/WHT 3X","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:06.000000Z","updated_at":"2025-12-15T10:02:10.000000Z"}]},{"id":8455285,"change_date":"2025-04-23 21:41:00","inspection_id":"84483177","dot_number":"3410850","report_state":"CA","report_number":"UCUF004223","insp_date":"2025-04-21 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15792592","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"564970","created_at":"2025-04-26T10:28:51.000000Z","updated_at":"2025-04-27T10:33:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13733567,"change_date":"2025-04-23 21:41:00","inspection_id":"84483177","insp_unit_id":"206464202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI.3X.TT","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"Y","insp_unit_decal_number":"35062827","created_at":"2025-04-26T10:20:06.000000Z","updated_at":"2025-04-27T10:11:51.000000Z"}]},{"id":8407105,"change_date":"2025-04-17 21:42:00","inspection_id":"84432366","dot_number":"3410850","report_state":"CA","report_number":"NFDT000830","insp_date":"2025-04-16 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15784993","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-20T10:28:44.000000Z","updated_at":"2025-04-21T10:24:36.000000Z","inspection_violations":[{"id":13264032,"change_date":"2025-04-17 21:42:00","inspection_id":"84432366","insp_violation_id":"265691675","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206372372","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA513449","created_at":"2025-04-20T11:02:39.000000Z","updated_at":"2025-04-20T11:12:54.000000Z","normalized_code":"39347E"},{"id":13264033,"change_date":"2025-04-17 21:42:00","inspection_id":"84432366","insp_violation_id":"265691676","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"206372372","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:02:39.000000Z","updated_at":"2025-04-20T11:12:54.000000Z","normalized_code":"39353BB"},{"id":13264034,"change_date":"2025-04-17 21:42:00","inspection_id":"84432366","insp_violation_id":"265691677","seq_no":"3","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"2","insp_unit_id":"206372373","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:02:39.000000Z","updated_at":"2025-04-20T11:12:54.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":13648761,"change_date":"2025-04-17 21:42:00","inspection_id":"84432366","insp_unit_id":"206372372","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:18:49.000000Z","updated_at":"2025-04-21T10:07:56.000000Z"},{"id":13648762,"change_date":"2025-04-17 21:42:00","inspection_id":"84432366","insp_unit_id":"206372373","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X FB","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:18:49.000000Z","updated_at":"2025-04-21T10:07:56.000000Z"}]},{"id":7454772,"change_date":"2024-12-18 21:42:00","inspection_id":"83431205","dot_number":"3410850","report_state":"CA","report_number":"UFYK000226","insp_date":"2024-12-17 00:00:00","insp_start_time":"1119","insp_end_time":"1138","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15633814","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2024-12-18 21:42:00","snet_input_date":"2024-12-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-18 21:42:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:34.000000Z","updated_at":"2025-03-17T20:51:34.000000Z","inspection_violations":[{"id":11650566,"change_date":"2024-12-18 21:42:00","inspection_id":"83431205","insp_violation_id":"263560537","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"204467046","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA389663","created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":12026582,"change_date":"2024-12-18 21:42:00","inspection_id":"83431205","insp_unit_id":"204467045","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"},{"id":12026583,"change_date":"2024-12-18 21:42:00","inspection_id":"83431205","insp_unit_id":"204467046","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":null,"insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:49.000000Z","updated_at":"2025-03-17T23:47:49.000000Z"}]},{"id":5648127,"change_date":"2024-05-01 21:43:00","inspection_id":"81500440","dot_number":"3410850","report_state":"CA","report_number":"NA5N007143","insp_date":"2024-04-30 00:00:00","insp_start_time":"1203","insp_end_time":"1247","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15344058","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9097639,"change_date":"2024-05-01 21:43:00","inspection_id":"81500440","insp_unit_id":"200682106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"Y","insp_unit_decal_number":"33811741","created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"},{"id":9097640,"change_date":"2024-05-01 21:43:00","inspection_id":"81500440","insp_unit_id":"200682107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X FB","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"Y","insp_unit_decal_number":"33811742","created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":5602632,"change_date":"2024-04-25 21:43:00","inspection_id":"81450774","dot_number":"3410850","report_state":"CA","report_number":"NEYV000471","insp_date":"2024-04-24 00:00:00","insp_start_time":"1430","insp_end_time":"1500","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15334921","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[{"id":8662770,"change_date":"2024-04-25 21:43:00","inspection_id":"81450774","insp_violation_id":"259155877","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200587399","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA513263","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9024565,"change_date":"2024-04-25 21:43:00","inspection_id":"81450774","insp_unit_id":"200587399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X \/ WHT","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"},{"id":9024566,"change_date":"2024-04-25 21:43:00","inspection_id":"81450774","insp_unit_id":"200587400","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X \/ FB","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":2041218,"change_date":"2022-12-29 21:40:00","inspection_id":"77478986","dot_number":"3410850","report_state":"CA","report_number":"NC7K006724","insp_date":"2022-12-28 00:00:00","insp_start_time":"1220","insp_end_time":"1243","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14725542","transaction_code":"A","transaction_date":"2022-12-28 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2022-12-29 21:40:00","snet_input_date":"2022-12-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:20.000000Z","updated_at":"2025-03-17T19:04:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3283867,"change_date":"2022-12-29 21:40:00","inspection_id":"77478986","insp_unit_id":"192639715","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10\/WHT 3X","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:30.000000Z","updated_at":"2025-03-17T22:29:30.000000Z"},{"id":3283868,"change_date":"2022-12-29 21:40:00","inspection_id":"77478986","insp_unit_id":"192639716","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"12\/FB 2X","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:30.000000Z","updated_at":"2025-03-17T22:29:30.000000Z"}]},{"id":1827407,"change_date":"2022-11-28 21:42:00","inspection_id":"77234670","dot_number":"3410850","report_state":"CA","report_number":"UBGJ004369","insp_date":"2022-11-23 00:00:00","insp_start_time":"2123","insp_end_time":"2206","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE PLATFORM","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14684875","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2022-11-28 21:42:00","snet_input_date":"2022-11-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-28 21:42:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:20.000000Z","updated_at":"2025-03-17T19:00:20.000000Z","inspection_violations":[{"id":2854813,"change_date":"2022-11-28 21:42:00","inspection_id":"77234670","insp_violation_id":"249815252","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192156427","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA392076","created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2940209,"change_date":"2022-11-28 21:42:00","inspection_id":"77234670","insp_unit_id":"192156427","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#10\/WHT","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:08.000000Z","updated_at":"2025-03-17T22:27:08.000000Z"},{"id":2940210,"change_date":"2022-11-28 21:42:00","inspection_id":"77234670","insp_unit_id":"192156428","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"3X\/VAN","insp_unit_license":"4RW5308","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5323KL016938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:08.000000Z","updated_at":"2025-03-17T22:27:08.000000Z"}]},{"id":57596,"change_date":"2022-03-28 21:41:00","inspection_id":"75158757","dot_number":"3410850","report_state":"CA","report_number":"NDN6005281","insp_date":"2022-03-23 00:00:00","insp_start_time":"0818","insp_end_time":"0848","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14359944","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03410850","upload_search_indicator":null,"census_search_date":"2022-03-28 21:41:00","snet_input_date":"2022-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"A AGUILAR TRUCKING LLC","insp_carrier_street":"486 DEBRA LEE CT","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:29.000000Z","updated_at":"2025-03-17T18:28:29.000000Z","inspection_violations":[{"id":82960,"change_date":"2022-03-28 21:41:00","inspection_id":"75158757","insp_violation_id":"244822387","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"187861579","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW699376","created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":93555,"change_date":"2022-03-28 21:41:00","inspection_id":"75158757","insp_unit_id":"187861578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9F55157","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR7BSBA9550","insp_unit_decal":"Y","insp_unit_decal_number":"30783214","created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"},{"id":93556,"change_date":"2022-03-28 21:41:00","inspection_id":"75158757","insp_unit_id":"187861579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"2X FB","insp_unit_license":"4FE4738","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1E1H6X28XVRD23090","insp_unit_decal":"Y","insp_unit_decal_number":"30783215","created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3410850\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3410850\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3410850\/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\/3410850\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}