{"current_page":1,"data":[{"id":12324670,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","dot_number":"2992963","report_state":"CA","report_number":"UFWH001688","insp_date":"2026-06-30 00:00:00","insp_start_time":"0749","insp_end_time":"0905","registration_date":null,"region":"PD","ci_status_code":"C","location":"850","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHEMTRADE CHEMICALS US LLC","shipping_paper_number":"439074","cargo_tank":"312","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"3654831","transaction_code":"C","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-30 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230-9000","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2026-07-03T09:41:26.000000Z","updated_at":"2026-07-18T09:30:10.000000Z","inspection_violations":[{"id":21450621,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334799","seq_no":"6","part_no":"172","part_no_section":"600C1-HMER","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"172600C1HMER"},{"id":21450622,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334800","seq_no":"7","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":"SN23276","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"39111B2Q"},{"id":21450623,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334801","seq_no":"8","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"3958A1HOSP"},{"id":21450618,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334795","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"214475705","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"39378AWS"},{"id":21450619,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334796","seq_no":"3","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"214475705","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN23277","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"39311A1CSLRR"},{"id":21450624,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334797","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"214475705","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"3922SLLEWA1"},{"id":21450620,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334798","seq_no":"5","part_no":"177","part_no_section":"823A-HMPMCM","insp_viol_unit":"2","insp_unit_id":"214475706","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"177823AHMPMCM"},{"id":21450617,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_violation_id":"275334794","seq_no":"1","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"214475705","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-03T10:02:30.000000Z","updated_at":"2026-07-18T09:42:02.000000Z","normalized_code":"39343BBATV"}],"inspection_per_units":[{"id":21405035,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_unit_id":"214475705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:04.000000Z","updated_at":"2026-07-18T09:01:11.000000Z"},{"id":21405036,"change_date":"2026-07-07 21:40:00","inspection_id":"88282793","insp_unit_id":"214475706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BBTM","insp_unit_company":"T10","insp_unit_license":"4SL3726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4BUCEC1B7SB955543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:04.000000Z","updated_at":"2026-07-18T09:01:11.000000Z"}]},{"id":11735615,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","dot_number":"2992963","report_state":"CA","report_number":"UEQX001667","insp_date":"2026-04-22 00:00:00","insp_start_time":"1833","insp_end_time":"1931","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"I-5 SCALES SANTA NELLA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHEMTRADE","shipping_paper_number":"80402848","cargo_tank":"407","hazmat_placard_req":"Y","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":"2026-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"10","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"16260871","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2026-04-23 21:40:00","snet_input_date":"2026-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-23 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2026-04-27T09:41:55.000000Z","updated_at":"2026-05-04T09:31:39.000000Z","inspection_violations":[{"id":20402649,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814701","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"213191055","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"3965BL"},{"id":20402650,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814702","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"213191055","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"3939ALRLI"},{"id":20402651,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814703","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"213191055","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"3939ALSLI"},{"id":20402652,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814704","seq_no":"4","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"213191055","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"3939ALTSIR"},{"id":20402653,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814705","seq_no":"5","part_no":"393","part_no_section":"47D2-BRMMCAD","insp_viol_unit":"1","insp_unit_id":"213191055","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"39347D2BRMMCAD"},{"id":20402654,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814706","seq_no":"6","part_no":"393","part_no_section":"11B-CSSRR","insp_viol_unit":"2","insp_unit_id":"213191056","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"39311BCSSRR"},{"id":20402655,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814707","seq_no":"7","part_no":"177","part_no_section":"801-HMHCNP","insp_viol_unit":"2","insp_unit_id":"213191056","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"177801HMHCNP"},{"id":20402656,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814708","seq_no":"8","part_no":"177","part_no_section":"801-HMHCNP","insp_viol_unit":"2","insp_unit_id":"213191056","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"177801HMHCNP"},{"id":20402657,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814709","seq_no":"9","part_no":"177","part_no_section":"801-HMHCNP","insp_viol_unit":"2","insp_unit_id":"213191056","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"177801HMHCNP"},{"id":20402658,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_violation_id":"273814710","seq_no":"10","part_no":"393","part_no_section":"70B1II-CDBL","insp_viol_unit":"2","insp_unit_id":"213191056","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:04:12.000000Z","updated_at":"2026-05-04T09:44:28.000000Z","normalized_code":"39370B1IICDBL"}],"inspection_per_units":[{"id":20419947,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_unit_id":"213191055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"9G20394","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2HJ172043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:35.000000Z","updated_at":"2026-05-04T09:04:53.000000Z"},{"id":20419948,"change_date":"2026-04-23 21:40:00","inspection_id":"87664057","insp_unit_id":"213191056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"M307","insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:35.000000Z","updated_at":"2026-05-04T09:04:53.000000Z"}]},{"id":9291079,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","dot_number":"2992963","report_state":"CA","report_number":"UFWH001209","insp_date":"2025-07-30 00:00:00","insp_start_time":"0810","insp_end_time":"0904","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"S\/B SANTA NELLA CVEF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHEM TRADE","shipping_paper_number":"80292503","cargo_tank":"407","hazmat_placard_req":"Y","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-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"107500","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":"15919867","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2025-07-30 21:41:00","snet_input_date":"2025-07-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-30 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-08-04T10:01:18.000000Z","updated_at":"2025-08-04T10:01:18.000000Z","inspection_violations":[{"id":15064863,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_violation_id":"267753864","seq_no":"2","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":"VERBAL","created_at":"2025-08-02T10:43:51.000000Z","updated_at":"2025-08-03T10:44:38.000000Z","normalized_code":"3958D11HOSF"},{"id":15064864,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_violation_id":"267753865","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208164790","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-08-02T10:43:51.000000Z","updated_at":"2025-08-03T10:44:38.000000Z","normalized_code":"3922SLLEQP"},{"id":15064865,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_violation_id":"267753866","seq_no":"4","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"208164790","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-08-02T10:43:51.000000Z","updated_at":"2025-08-03T10:44:38.000000Z","normalized_code":"39311A1CSLRR"},{"id":15064866,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_violation_id":"267753867","seq_no":"5","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"208164790","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU14092","created_at":"2025-08-02T10:43:51.000000Z","updated_at":"2025-08-03T10:44:38.000000Z","normalized_code":"3922SLLEWA1"},{"id":15064867,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_violation_id":"267753868","seq_no":"1","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":"VERBAL","created_at":"2025-08-02T10:43:51.000000Z","updated_at":"2025-08-03T10:44:39.000000Z","normalized_code":"39524DELDPT"}],"inspection_per_units":[{"id":15297118,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_unit_id":"208164790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2","insp_unit_license":"9F91333","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X1GD285072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:30.000000Z","updated_at":"2025-08-03T09:46:14.000000Z"},{"id":15297119,"change_date":"2025-07-30 21:41:00","inspection_id":"85365194","insp_unit_id":"208164791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"M307","insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:30.000000Z","updated_at":"2025-08-03T09:46:14.000000Z"}]},{"id":9383329,"change_date":"2025-08-11 21:38:00","inspection_id":"85461877","dot_number":"2992963","report_state":"CA","report_number":"NE46005205","insp_date":"2025-07-03 00:00:00","insp_start_time":"0014","insp_end_time":"0036","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JIM HICKS AND CO","shipping_paper_number":"138006","cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15932678","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-07-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-08-14T10:42:32.000000Z","updated_at":"2025-08-15T10:43:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15460579,"change_date":"2025-08-11 21:38:00","inspection_id":"85461877","insp_unit_id":"208340448","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"9G20394","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2HJ172043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:37.000000Z","updated_at":"2025-08-15T09:46:08.000000Z"},{"id":15460580,"change_date":"2025-08-11 21:38:00","inspection_id":"85461877","insp_unit_id":"208340449","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"2B","insp_unit_license":"4SK2704","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB42U5YF0B1824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:37.000000Z","updated_at":"2025-08-15T09:46:08.000000Z"}]},{"id":8347080,"change_date":"2025-04-10 21:42:00","inspection_id":"84369090","dot_number":"2992963","report_state":"CA","report_number":"UF0F002602","insp_date":"2025-04-10 00:00:00","insp_start_time":"1026","insp_end_time":"1102","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"646 W. PACHECO BLVD, LOS BANOS","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JIM HICKS & CO.","shipping_paper_number":"80243806","cargo_tank":"312","hazmat_placard_req":"Y","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-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"15775783","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2025-04-10 21:42:00","snet_input_date":"2025-04-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-10 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:44.000000Z","updated_at":"2025-04-14T10:28:44.000000Z","inspection_violations":[{"id":13143502,"change_date":"2025-04-10 21:42:00","inspection_id":"84369090","insp_violation_id":"265555885","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"206256277","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SC41513","created_at":"2025-04-12T11:03:15.000000Z","updated_at":"2025-04-13T10:57:01.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":13541665,"change_date":"2025-04-10 21:42:00","inspection_id":"84369090","insp_unit_id":"206256276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9F91333","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X1GD285072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:22:40.000000Z","updated_at":"2025-04-14T10:10:32.000000Z"},{"id":13541666,"change_date":"2025-04-10 21:42:00","inspection_id":"84369090","insp_unit_id":"206256277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BARBE","insp_unit_company":null,"insp_unit_license":"4SL3726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4BUCEC1B7SB955543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:22:40.000000Z","updated_at":"2025-04-14T10:10:32.000000Z"}]},{"id":8025916,"change_date":"2025-03-04 21:39:00","inspection_id":"84030980","dot_number":"2992963","report_state":"CA","report_number":"NCNK008553","insp_date":"2025-03-03 00:00:00","insp_start_time":"2032","insp_end_time":"2130","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":"DAVID MACIEL JR TRUCKING LLC","shipping_paper_number":"N\/A","cargo_tank":"412","hazmat_placard_req":"Y","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-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"104750","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":"1","hazmat_oos_total":"0","snet_sequence_id":"15725353","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2025-03-04 21:39:00","snet_input_date":"2025-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T21:04:55.000000Z","updated_at":"2025-03-17T21:04:55.000000Z","inspection_violations":[{"id":12543408,"change_date":"2025-03-04 21:39:00","inspection_id":"84030980","insp_violation_id":"264833292","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"205625418","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:21.000000Z","updated_at":"2025-03-17T22:07:21.000000Z","normalized_code":"39355EB"},{"id":12543409,"change_date":"2025-03-04 21:39:00","inspection_id":"84030980","insp_violation_id":"264833293","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"205625418","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA249337","created_at":"2025-03-17T22:07:21.000000Z","updated_at":"2025-03-17T22:07:21.000000Z","normalized_code":"39345B2BAIR"},{"id":12543410,"change_date":"2025-03-04 21:39:00","inspection_id":"84030980","insp_violation_id":"264833294","seq_no":"3","part_no":"172","part_no_section":"328D-HMM","insp_viol_unit":"2","insp_unit_id":"205625418","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:21.000000Z","updated_at":"2025-03-17T22:07:21.000000Z","normalized_code":"172328DHMM"}],"inspection_per_units":[{"id":12957307,"change_date":"2025-03-04 21:39:00","inspection_id":"84030980","insp_unit_id":"205625417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/3","insp_unit_license":"9G20394","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2HJ172043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:08.000000Z","updated_at":"2025-03-17T23:58:08.000000Z"},{"id":12957308,"change_date":"2025-03-04 21:39:00","inspection_id":"84030980","insp_unit_id":"205625418","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"TANK\/2B","insp_unit_license":"4SK2704","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB42U5YF0B1824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:08.000000Z","updated_at":"2025-03-17T23:58:08.000000Z"}]},{"id":8047393,"change_date":"2025-03-06 21:40:00","inspection_id":"84053547","dot_number":"2992963","report_state":"CA","report_number":"NA5N007965","insp_date":"2025-03-03 00:00:00","insp_start_time":"0755","insp_end_time":"0842","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":"CHEMTECH","shipping_paper_number":"80229740","cargo_tank":"407","hazmat_placard_req":"Y","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","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":"15728645","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2025-03-06 21:40:00","snet_input_date":"2025-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-06 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:24.000000Z","updated_at":"2025-03-17T21:05:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12992318,"change_date":"2025-03-06 21:40:00","inspection_id":"84053547","insp_unit_id":"205667072","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3 AXLE WHT","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"Y","insp_unit_decal_number":"34766476","created_at":"2025-03-17T23:58:31.000000Z","updated_at":"2025-03-17T23:58:31.000000Z"},{"id":12992319,"change_date":"2025-03-06 21:40:00","inspection_id":"84053547","insp_unit_id":"205667073","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"2 AXLE TANK","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:31.000000Z","updated_at":"2025-03-17T23:58:31.000000Z"}]},{"id":7777195,"change_date":"2025-02-03 21:40:00","inspection_id":"83769944","dot_number":"2992963","report_state":"CA","report_number":"UDM0002243","insp_date":"2025-02-03 00:00:00","insp_start_time":"0300","insp_end_time":"0320","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"30899","cargo_tank":"407","hazmat_placard_req":"Y","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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"107500","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":"15689046","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2025-02-03 21:40:00","snet_input_date":"2025-02-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-03 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12551473,"change_date":"2025-02-03 21:40:00","inspection_id":"83769944","insp_unit_id":"205139474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BRN\/1","insp_unit_license":"9E80239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0FD256367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"},{"id":12551474,"change_date":"2025-02-03 21:40:00","inspection_id":"83769944","insp_unit_id":"205139475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"M307","insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"}]},{"id":7098159,"change_date":"2024-10-31 21:43:00","inspection_id":"83054896","dot_number":"2992963","report_state":"CA","report_number":"UEX8004109","insp_date":"2024-10-29 00:00:00","insp_start_time":"0837","insp_end_time":"0903","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"EB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHEMTRADE CHEMICALS","shipping_paper_number":"80180391","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-31 21:43: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":"15579504","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-10-31 21:43:00","snet_input_date":"2024-10-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-31 21:43:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:55.000000Z","updated_at":"2025-03-17T20:43:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11447943,"change_date":"2024-10-31 21:43:00","inspection_id":"83054896","insp_unit_id":"203690214","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:33.000000Z","updated_at":"2025-03-17T23:41:33.000000Z"},{"id":11447944,"change_date":"2024-10-31 21:43:00","inspection_id":"83054896","insp_unit_id":"203690215","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:33.000000Z","updated_at":"2025-03-17T23:41:33.000000Z"}]},{"id":6811041,"change_date":"2024-09-25 21:42:00","inspection_id":"82750057","dot_number":"2992963","report_state":"CA","report_number":"NC7C004569","insp_date":"2024-09-24 00:00:00","insp_start_time":"0717","insp_end_time":"0827","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66 COMPANY","shipping_paper_number":"20185","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15532979","transaction_code":"C","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:38:13.000000Z","updated_at":"2025-03-17T20:38:13.000000Z","inspection_violations":[{"id":10606326,"change_date":"2024-09-25 21:42:00","inspection_id":"82750057","insp_violation_id":"262038020","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203132952","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"3939A"},{"id":10606327,"change_date":"2024-09-25 21:42:00","inspection_id":"82750057","insp_violation_id":"262038021","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203132951","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA206615","created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"3963A1"},{"id":10606328,"change_date":"2024-09-25 21:42:00","inspection_id":"82750057","insp_violation_id":"262038022","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203132951","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10983569,"change_date":"2024-09-25 21:42:00","inspection_id":"82750057","insp_unit_id":"203132951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/04","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:45.000000Z","updated_at":"2025-03-17T23:36:45.000000Z"},{"id":10983570,"change_date":"2024-09-25 21:42:00","inspection_id":"82750057","insp_unit_id":"203132952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"TANK\/M306","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:45.000000Z","updated_at":"2025-03-17T23:36:45.000000Z"}]},{"id":6372777,"change_date":"2024-08-01 21:42:00","inspection_id":"82282636","dot_number":"2992963","report_state":"CA","report_number":"UEBY002046","insp_date":"2024-08-01 00:00:00","insp_start_time":"0720","insp_end_time":"0745","registration_date":null,"region":"PT","ci_status_code":"C","location":"9410","location_desc":"FRESNO, CA","county_code_state":"CA","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHEMTRADE","shipping_paper_number":"80143781","cargo_tank":"312","hazmat_placard_req":"Y","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":"2024-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","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":"15468148","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-08-01 21:42:00","snet_input_date":"2024-08-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-01 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:29:07.000000Z","updated_at":"2025-03-17T20:29:07.000000Z","inspection_violations":[{"id":9893474,"change_date":"2024-08-01 21:42:00","inspection_id":"82282636","insp_violation_id":"260976570","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"202199943","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ81090","created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39360D"},{"id":9893475,"change_date":"2024-08-01 21:42:00","inspection_id":"82282636","insp_violation_id":"260976571","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"202199943","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":10269535,"change_date":"2024-08-01 21:42:00","inspection_id":"82282636","insp_unit_id":"202199943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"9E80239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0FD256367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"},{"id":10269536,"change_date":"2024-08-01 21:42:00","inspection_id":"82282636","insp_unit_id":"202199944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BARBE","insp_unit_company":null,"insp_unit_license":"4SL3726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4BUCEC1B7SB955543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6302534,"change_date":"2024-07-24 21:42:00","inspection_id":"82207524","dot_number":"2992963","report_state":"CA","report_number":"UE03003328","insp_date":"2024-07-22 00:00:00","insp_start_time":"0520","insp_end_time":"0559","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":"407","hazmat_placard_req":"Y","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-24 21:42: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":"15455385","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:48.000000Z","updated_at":"2025-03-17T20:27:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10155129,"change_date":"2024-07-24 21:42:00","inspection_id":"82207524","insp_unit_id":"202055580","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:13.000000Z","updated_at":"2025-03-17T23:28:13.000000Z"},{"id":10155130,"change_date":"2024-07-24 21:42:00","inspection_id":"82207524","insp_unit_id":"202055581","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:13.000000Z","updated_at":"2025-03-17T23:28:13.000000Z"}]},{"id":6097857,"change_date":"2024-06-28 21:40:00","inspection_id":"81987879","dot_number":"2992963","report_state":"CA","report_number":"UE2C004488","insp_date":"2024-06-24 00:00:00","insp_start_time":"0530","insp_end_time":"0610","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":"406","hazmat_placard_req":"Y","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-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15421707","transaction_code":"C","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-27 21:41:00","snet_input_date":"2024-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-27 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:25.000000Z","updated_at":"2025-03-17T20:23:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9821646,"change_date":"2024-06-28 21:40:00","inspection_id":"81987879","insp_unit_id":"201651650","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X WHT","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:45.000000Z","updated_at":"2025-03-17T23:24:45.000000Z"},{"id":9821647,"change_date":"2024-06-28 21:40:00","inspection_id":"81987879","insp_unit_id":"201651651","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"2X TANK","insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:45.000000Z","updated_at":"2025-03-17T23:24:45.000000Z"}]},{"id":5999260,"change_date":"2024-06-14 21:41:00","inspection_id":"81881575","dot_number":"2992963","report_state":"CA","report_number":"UBGJ005802","insp_date":"2024-06-13 00:00:00","insp_start_time":"0840","insp_end_time":"0911","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"407","hazmat_placard_req":"Y","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15404740","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9662455,"change_date":"2024-06-14 21:41:00","inspection_id":"81881575","insp_unit_id":"201409646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"#4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"Y","insp_unit_decal_number":"33812901","created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"},{"id":9662456,"change_date":"2024-06-14 21:41:00","inspection_id":"81881575","insp_unit_id":"201409647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"#307","insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"}]},{"id":5976915,"change_date":"2024-06-12 21:42:00","inspection_id":"81857442","dot_number":"2992963","report_state":"CA","report_number":"NBYJ001636","insp_date":"2024-06-11 00:00:00","insp_start_time":"1302","insp_end_time":"1342","registration_date":null,"region":"PD","ci_status_code":"C","location":"440\/01","location_desc":"15218 EXCELSIOR AVE HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"15399589","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[{"id":9272560,"change_date":"2024-06-12 21:42:00","inspection_id":"81857442","insp_violation_id":"260054307","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"201365743","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:51.000000Z","updated_at":"2025-03-17T21:50:51.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":9627259,"change_date":"2024-06-12 21:42:00","inspection_id":"81857442","insp_unit_id":"201365743","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:48.000000Z","updated_at":"2025-03-17T23:22:48.000000Z"},{"id":9627260,"change_date":"2024-06-12 21:42:00","inspection_id":"81857442","insp_unit_id":"201365744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"M307","insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"Y","insp_unit_decal_number":"33828786","created_at":"2025-03-17T23:22:48.000000Z","updated_at":"2025-03-17T23:22:48.000000Z"}]},{"id":5976916,"change_date":"2024-06-12 21:42:00","inspection_id":"81857443","dot_number":"2992963","report_state":"CA","report_number":"NBYJ001637","insp_date":"2024-06-11 00:00:00","insp_start_time":"1348","insp_end_time":"1433","registration_date":null,"region":"PD","ci_status_code":"C","location":"440\/01","location_desc":"15218 EXCELSIOR AVE HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"407","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-12 21:42: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":"15399620","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9627261,"change_date":"2024-06-12 21:42:00","inspection_id":"81857443","insp_unit_id":"201365745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5","insp_unit_license":"9G91746","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M1AW09Y0FM052452","insp_unit_decal":"Y","insp_unit_decal_number":"33828787","created_at":"2025-03-17T23:22:48.000000Z","updated_at":"2025-03-17T23:22:48.000000Z"},{"id":9627262,"change_date":"2024-06-12 21:42:00","inspection_id":"81857443","insp_unit_id":"201365746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"M306","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:48.000000Z","updated_at":"2025-03-17T23:22:48.000000Z"}]},{"id":5976917,"change_date":"2024-06-12 21:42:00","inspection_id":"81857444","dot_number":"2992963","report_state":"CA","report_number":"NBYJ001638","insp_date":"2024-06-11 00:00:00","insp_start_time":"1439","insp_end_time":"1508","registration_date":null,"region":"PD","ci_status_code":"C","location":"440\/01","location_desc":"15218 EXCELSIOR AVE HANFORD","county_code_state":"CA","county_code":"031","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-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"15398955","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9627263,"change_date":"2024-06-12 21:42:00","inspection_id":"81857444","insp_unit_id":"201365747","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"9G20394","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2HJ172043","insp_unit_decal":"Y","insp_unit_decal_number":"33828788","created_at":"2025-03-17T23:22:48.000000Z","updated_at":"2025-03-17T23:22:48.000000Z"}]},{"id":5922747,"change_date":"2024-06-05 21:42:00","inspection_id":"81798586","dot_number":"2992963","report_state":"CA","report_number":"NBYJ999885","insp_date":"2024-06-05 00:00:00","insp_start_time":"0802","insp_end_time":"0840","registration_date":null,"region":"PD","ci_status_code":"C","location":"440\/01","location_desc":"15218 EXCELSIOR AVE HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"15391636","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:20:13.000000Z","updated_at":"2025-03-17T20:20:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9539584,"change_date":"2024-06-05 21:42:00","inspection_id":"81798586","insp_unit_id":"201254297","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"BREN","insp_unit_company":"2B","insp_unit_license":"4SK2704","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB42U5YF0B1824","insp_unit_decal":"Y","insp_unit_decal_number":"33828775","created_at":"2025-03-17T23:21:55.000000Z","updated_at":"2025-03-17T23:21:55.000000Z"}]},{"id":5923288,"change_date":"2024-06-05 21:42:00","inspection_id":"81799145","dot_number":"2992963","report_state":"CA","report_number":"NBYJ001627","insp_date":"2024-06-05 00:00:00","insp_start_time":"0903","insp_end_time":"1021","registration_date":null,"region":"PD","ci_status_code":"C","location":"440\/01","location_desc":"15218 EXCELSIOR AVE HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"312","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115500","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":"15391393","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:20:13.000000Z","updated_at":"2025-03-17T20:20:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9540411,"change_date":"2024-06-05 21:42:00","inspection_id":"81799145","insp_unit_id":"201255193","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2","insp_unit_license":"9F91333","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X1GD285072","insp_unit_decal":"Y","insp_unit_decal_number":"03382876","created_at":"2025-03-17T23:21:58.000000Z","updated_at":"2025-03-17T23:21:58.000000Z"},{"id":9540412,"change_date":"2024-06-05 21:42:00","inspection_id":"81799145","insp_unit_id":"201255194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BARBE","insp_unit_company":"5543","insp_unit_license":"4SL3726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4BUCEC1B7SB955543","insp_unit_decal":"Y","insp_unit_decal_number":"33828777","created_at":"2025-03-17T23:21:58.000000Z","updated_at":"2025-03-17T23:21:58.000000Z"}]},{"id":5988101,"change_date":"2024-06-13 21:42:00","inspection_id":"81869579","dot_number":"2992963","report_state":"CA","report_number":"NBYJ001628","insp_date":"2024-06-05 00:00:00","insp_start_time":"1021","insp_end_time":"1145","registration_date":null,"region":"PD","ci_status_code":"C","location":"440\/01","location_desc":"15218 EXCELSIOR AVE HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"15402944","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T20:21:28.000000Z","updated_at":"2025-03-17T20:21:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9645221,"change_date":"2024-06-13 21:42:00","inspection_id":"81869579","insp_unit_id":"201388190","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"9E80239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0FD256367","insp_unit_decal":"Y","insp_unit_decal_number":"33828778","created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"},{"id":9645222,"change_date":"2024-06-13 21:42:00","inspection_id":"81869579","insp_unit_id":"201388191","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"8129","insp_unit_license":"4TM4604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB52T2WF0A8129","insp_unit_decal":"Y","insp_unit_decal_number":"33828779","created_at":"2025-03-17T23:22:59.000000Z","updated_at":"2025-03-17T23:22:59.000000Z"}]},{"id":5066232,"change_date":"2024-02-15 21:43:00","inspection_id":"80865718","dot_number":"2992963","report_state":"CA","report_number":"UE5U003381","insp_date":"2024-02-15 00:00:00","insp_start_time":"0820","insp_end_time":"0906","registration_date":null,"region":"PT","ci_status_code":"C","location":"888","location_desc":"S\/B I-5 SANTA NELLA SCALES","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":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"15239125","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-02-15 21:43:00","snet_input_date":"2024-02-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-15 21:43:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:04.000000Z","updated_at":"2025-03-17T20:03:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8155411,"change_date":"2024-02-15 21:43:00","inspection_id":"80865718","insp_unit_id":"199454324","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:57.000000Z","updated_at":"2025-03-17T23:08:57.000000Z"},{"id":8155412,"change_date":"2024-02-15 21:43:00","inspection_id":"80865718","insp_unit_id":"199454325","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:57.000000Z","updated_at":"2025-03-17T23:08:57.000000Z"}]},{"id":5044958,"change_date":"2024-02-13 21:42:00","inspection_id":"80842480","dot_number":"2992963","report_state":"CA","report_number":"UF0F002036","insp_date":"2024-02-12 00:00:00","insp_start_time":"1319","insp_end_time":"1348","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"SANTA NELLA SCALES","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHEMTRADE","shipping_paper_number":"80078883","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"15235700","transaction_code":"A","transaction_date":"2024-02-12 00:00:00","upload_date":"2024-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2024-02-13 21:42:00","snet_input_date":"2024-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-13 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:43.000000Z","updated_at":"2025-03-17T20:02:43.000000Z","inspection_violations":[{"id":7774974,"change_date":"2024-02-13 21:42:00","inspection_id":"80842480","insp_violation_id":"257823161","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199410328","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:34.000000Z","updated_at":"2025-03-17T21:43:34.000000Z","normalized_code":"3922"},{"id":7774975,"change_date":"2024-02-13 21:42:00","inspection_id":"80842480","insp_violation_id":"257823162","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"199410328","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:34.000000Z","updated_at":"2025-03-17T21:43:34.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":8121092,"change_date":"2024-02-13 21:42:00","inspection_id":"80842480","insp_unit_id":"199410328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:36.000000Z","updated_at":"2025-03-17T23:08:36.000000Z"},{"id":8121093,"change_date":"2024-02-13 21:42:00","inspection_id":"80842480","insp_unit_id":"199410329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:36.000000Z","updated_at":"2025-03-17T23:08:36.000000Z"}]},{"id":4735618,"change_date":"2023-12-29 21:40:00","inspection_id":"80504124","dot_number":"2992963","report_state":"CA","report_number":"UBGJ005367","insp_date":"2023-12-26 00:00:00","insp_start_time":"1900","insp_end_time":"1928","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":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"15183765","transaction_code":"A","transaction_date":"2023-12-26 00:00:00","upload_date":"2023-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:56:34.000000Z","updated_at":"2025-03-17T19:56:34.000000Z","inspection_violations":[{"id":7312659,"change_date":"2023-12-29 21:40:00","inspection_id":"80504124","insp_violation_id":"257123746","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198744179","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7617352,"change_date":"2023-12-29 21:40:00","inspection_id":"80504124","insp_unit_id":"198744179","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X WHT","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"},{"id":7617353,"change_date":"2023-12-29 21:40:00","inspection_id":"80504124","insp_unit_id":"198744180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"3X TNK SIL","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"}]},{"id":4149145,"change_date":"2023-10-06 21:41:00","inspection_id":"79858519","dot_number":"2992963","report_state":"CA","report_number":"UDM0001510","insp_date":"2023-10-06 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66","shipping_paper_number":null,"cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"15088354","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:44:56.000000Z","updated_at":"2025-03-17T19:44:56.000000Z","inspection_violations":[{"id":6422736,"change_date":"2023-10-06 21:41:00","inspection_id":"79858519","insp_violation_id":"255714865","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:59.000000Z","updated_at":"2025-03-17T21:36:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6671478,"change_date":"2023-10-06 21:41:00","inspection_id":"79858519","insp_unit_id":"197448161","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:57.000000Z","updated_at":"2025-03-17T22:55:57.000000Z"},{"id":6671479,"change_date":"2023-10-06 21:41:00","inspection_id":"79858519","insp_unit_id":"197448162","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:57.000000Z","updated_at":"2025-03-17T22:55:57.000000Z"}]},{"id":4051889,"change_date":"2023-09-25 21:41:00","inspection_id":"79750327","dot_number":"2992963","report_state":"CA","report_number":"UD7O001887","insp_date":"2023-09-24 00:00:00","insp_start_time":"2126","insp_end_time":"2132","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":"3","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":"2023-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15074523","transaction_code":"A","transaction_date":"2023-09-24 00:00:00","upload_date":"2023-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-09-25 21:41:00","snet_input_date":"2023-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-25 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:42:49.000000Z","updated_at":"2025-03-17T19:42:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6515251,"change_date":"2023-09-25 21:41:00","inspection_id":"79750327","insp_unit_id":"197229242","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3\/WHI","insp_unit_license":"9G20394","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2HJ172043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"},{"id":6515252,"change_date":"2023-09-25 21:41:00","inspection_id":"79750327","insp_unit_id":"197229243","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"2B\/TANK","insp_unit_license":"4SK2704","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB42U5YF0B1824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"}]},{"id":4007729,"change_date":"2023-09-19 21:41:00","inspection_id":"79701307","dot_number":"2992963","report_state":"CA","report_number":"NC7C003731","insp_date":"2023-09-18 00:00:00","insp_start_time":"0945","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66 COMPANY","shipping_paper_number":"28980","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"15066709","transaction_code":"A","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-09-19 21:41:00","snet_input_date":"2023-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-19 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:01.000000Z","updated_at":"2025-03-17T19:42:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6444554,"change_date":"2023-09-19 21:41:00","inspection_id":"79701307","insp_unit_id":"197133103","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:05.000000Z","updated_at":"2025-03-17T22:54:05.000000Z"},{"id":6444555,"change_date":"2023-09-19 21:41:00","inspection_id":"79701307","insp_unit_id":"197133104","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:05.000000Z","updated_at":"2025-03-17T22:54:05.000000Z"}]},{"id":3851791,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","dot_number":"2992963","report_state":"CA","report_number":"UD2M002038","insp_date":"2023-08-26 00:00:00","insp_start_time":"0935","insp_end_time":"1017","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"LOS BANOS AREA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHEMTRADE","shipping_paper_number":"81874425","cargo_tank":"407","hazmat_placard_req":"Y","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-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15040654","transaction_code":"A","transaction_date":"2023-08-26 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-08-28 21:43:00","snet_input_date":"2023-08-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-28 21:43:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:38:56.000000Z","updated_at":"2025-03-17T19:38:56.000000Z","inspection_violations":[{"id":5950086,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","insp_violation_id":"254937308","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196773980","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39345B2"},{"id":5950087,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","insp_violation_id":"254937309","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196773980","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39345B2"},{"id":5950088,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","insp_violation_id":"254937310","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"196773980","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"39347A"},{"id":5950089,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","insp_violation_id":"254937311","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196773980","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:48.000000Z","updated_at":"2025-03-17T21:34:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6193068,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","insp_unit_id":"196773980","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"},{"id":6193069,"change_date":"2023-08-28 21:43:00","inspection_id":"79527894","insp_unit_id":"196773981","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:02.000000Z","updated_at":"2025-03-17T22:52:02.000000Z"}]},{"id":3709894,"change_date":"2023-08-09 21:43:00","inspection_id":"79369499","dot_number":"2992963","report_state":"CA","report_number":"NDUW002825","insp_date":"2023-08-09 00:00:00","insp_start_time":"0905","insp_end_time":"0956","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66 COMPANY","shipping_paper_number":"15797","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"15014696","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-08-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:36:07.000000Z","updated_at":"2025-03-17T19:36:07.000000Z","inspection_violations":[{"id":5720481,"change_date":"2023-08-09 21:43:00","inspection_id":"79369499","insp_violation_id":"254568770","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196456449","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:31.000000Z","updated_at":"2025-03-17T21:33:31.000000Z","normalized_code":"39345B2"},{"id":5720482,"change_date":"2023-08-09 21:43:00","inspection_id":"79369499","insp_violation_id":"254568771","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196456449","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:31.000000Z","updated_at":"2025-03-17T21:33:31.000000Z","normalized_code":"39345B2"},{"id":5720483,"change_date":"2023-08-09 21:43:00","inspection_id":"79369499","insp_violation_id":"254568772","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"196456449","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:31.000000Z","updated_at":"2025-03-17T21:33:31.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":5964976,"change_date":"2023-08-09 21:43:00","inspection_id":"79369499","insp_unit_id":"196456449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5964977,"change_date":"2023-08-09 21:43:00","inspection_id":"79369499","insp_unit_id":"196456450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"M306","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3300127,"change_date":"2023-06-15 21:43:00","inspection_id":"78909498","dot_number":"2992963","report_state":"CA","report_number":"UD2M001983","insp_date":"2023-06-15 00:00:00","insp_start_time":"0510","insp_end_time":"0555","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"LOS BANOS AREA","county_code_state":"CA","county_code":"047","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHEMTRADE CHEMICALS US LLC","shipping_paper_number":"81856102","cargo_tank":"412","hazmat_placard_req":"Y","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-06-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14945246","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-06-15 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-15 21:43:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:28:29.000000Z","updated_at":"2025-03-17T19:28:29.000000Z","inspection_violations":[{"id":5089876,"change_date":"2023-06-15 21:43:00","inspection_id":"78909498","insp_violation_id":"253543459","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195532101","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3963A1"},{"id":5089877,"change_date":"2023-06-15 21:43:00","inspection_id":"78909498","insp_violation_id":"253543460","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195532102","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KV62465","created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3963A1"},{"id":5089878,"change_date":"2023-06-15 21:43:00","inspection_id":"78909498","insp_violation_id":"253543461","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195532102","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5305925,"change_date":"2023-06-15 21:43:00","inspection_id":"78909498","insp_unit_id":"195532101","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9F91333","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X1GD285072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:52.000000Z","updated_at":"2025-03-17T22:44:52.000000Z"},{"id":5305926,"change_date":"2023-06-15 21:43:00","inspection_id":"78909498","insp_unit_id":"195532102","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":null,"insp_unit_license":"4TM4604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB52T2WF0A8129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:52.000000Z","updated_at":"2025-03-17T22:44:52.000000Z"}]},{"id":3347148,"change_date":"2023-06-22 21:42:00","inspection_id":"78962395","dot_number":"2992963","report_state":"CA","report_number":"UCOB004651","insp_date":"2023-06-15 00:00:00","insp_start_time":"1131","insp_end_time":"1216","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MACIEL TRUCKING","shipping_paper_number":"81856104","cargo_tank":"312","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"110000","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":"14955794","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:20.000000Z","updated_at":"2025-03-17T19:29:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5381030,"change_date":"2023-06-22 21:42:00","inspection_id":"78962395","insp_unit_id":"195635701","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:27.000000Z","updated_at":"2025-03-17T22:45:27.000000Z"},{"id":5381031,"change_date":"2023-06-22 21:42:00","inspection_id":"78962395","insp_unit_id":"195635702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"Y","insp_unit_decal_number":"32469325","created_at":"2025-03-17T22:45:27.000000Z","updated_at":"2025-03-17T22:45:27.000000Z"}]},{"id":2949457,"change_date":"2023-05-02 21:41:00","inspection_id":"78513354","dot_number":"2992963","report_state":"CA","report_number":"UFGN002114","insp_date":"2023-05-01 00:00:00","insp_start_time":"2350","insp_end_time":"0020","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":"312","hazmat_placard_req":"Y","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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"14883076","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-05-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:23.000000Z","updated_at":"2025-03-17T19:21:23.000000Z","inspection_violations":[{"id":4527286,"change_date":"2023-05-02 21:41:00","inspection_id":"78513354","insp_violation_id":"252581603","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194714465","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4745762,"change_date":"2023-05-02 21:41:00","inspection_id":"78513354","insp_unit_id":"194714465","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"9E80239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0FD256367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"},{"id":4745763,"change_date":"2023-05-02 21:41:00","inspection_id":"78513354","insp_unit_id":"194714466","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BBTM","insp_unit_company":"5543","insp_unit_license":"4SL3726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4BUCEC1B7SB955543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:25.000000Z","updated_at":"2025-03-17T22:40:25.000000Z"}]},{"id":2890935,"change_date":"2023-04-25 21:40:00","inspection_id":"78447259","dot_number":"2992963","report_state":"CA","report_number":"NE46002560","insp_date":"2023-04-21 00:00:00","insp_start_time":"2305","insp_end_time":"2344","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DAVID MACIEL JR TRUCKING LLC","shipping_paper_number":"N\/A","cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115500","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":"14873944","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:20:05.000000Z","updated_at":"2025-03-17T19:20:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4651594,"change_date":"2023-04-25 21:40:00","inspection_id":"78447259","insp_unit_id":"194582566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2","insp_unit_license":"9F91333","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X1GD285072","insp_unit_decal":"Y","insp_unit_decal_number":"32485932","created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"},{"id":4651595,"change_date":"2023-04-25 21:40:00","inspection_id":"78447259","insp_unit_id":"194582567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"S129","insp_unit_license":"4TM4604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB52T2WF0A8129","insp_unit_decal":"Y","insp_unit_decal_number":"32485933","created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"}]},{"id":2878211,"change_date":"2023-04-24 21:42:00","inspection_id":"78432793","dot_number":"2992963","report_state":"CA","report_number":"NA5N005944","insp_date":"2023-04-20 00:00:00","insp_start_time":"0915","insp_end_time":"0948","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B 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":"CHEMTRADE","shipping_paper_number":"2854407","cargo_tank":"407","hazmat_placard_req":"Y","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-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"107500","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":"14871927","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-04-24 21:42:00","snet_input_date":"2023-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-24 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:44.000000Z","updated_at":"2025-03-17T19:19:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4631307,"change_date":"2023-04-24 21:42:00","inspection_id":"78432793","insp_unit_id":"194556034","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3X WHT","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"Y","insp_unit_decal_number":"32467889","created_at":"2025-03-17T22:39:32.000000Z","updated_at":"2025-03-17T22:39:32.000000Z"},{"id":4631308,"change_date":"2023-04-24 21:42:00","inspection_id":"78432793","insp_unit_id":"194556035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"2X TNK","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:32.000000Z","updated_at":"2025-03-17T22:39:32.000000Z"}]},{"id":2782178,"change_date":"2023-04-11 21:40:00","inspection_id":"78324146","dot_number":"2992963","report_state":"CA","report_number":"UCOB004425","insp_date":"2023-04-06 00:00:00","insp_start_time":"0748","insp_end_time":"0822","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JIM HICKS & CO","shipping_paper_number":"2839680","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"107500","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":"14852217","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2023-04-11 21:40:00","snet_input_date":"2023-04-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:02.000000Z","updated_at":"2025-03-17T19:18:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4478281,"change_date":"2023-04-11 21:40:00","inspection_id":"78324146","insp_unit_id":"194336038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"9G20394","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2HJ172043","insp_unit_decal":"Y","insp_unit_decal_number":"32468157","created_at":"2025-03-17T22:38:17.000000Z","updated_at":"2025-03-17T22:38:17.000000Z"},{"id":4478282,"change_date":"2023-04-11 21:40:00","inspection_id":"78324146","insp_unit_id":"194336039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA432XF3D50208","insp_unit_decal":"Y","insp_unit_decal_number":"32468158","created_at":"2025-03-17T22:38:17.000000Z","updated_at":"2025-03-17T22:38:17.000000Z"}]},{"id":1906974,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","dot_number":"2992963","report_state":"CA","report_number":"NAA6000274","insp_date":"2022-12-08 00:00:00","insp_start_time":"0915","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"14701580","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T19:01:50.000000Z","updated_at":"2025-03-17T19:01:50.000000Z","inspection_violations":[{"id":2967468,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_violation_id":"250006585","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192339138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"39345B2"},{"id":2967469,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_violation_id":"250006586","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192339138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3963A1"},{"id":2967470,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_violation_id":"250006587","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"192339139","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"39345B2"},{"id":2967471,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_violation_id":"250006588","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192339139","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3963A1"},{"id":2967472,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_violation_id":"250006589","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192339139","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3069302,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_unit_id":"192339138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"},{"id":3069303,"change_date":"2022-12-08 21:41:00","inspection_id":"77325337","insp_unit_id":"192339139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1306","insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"}]},{"id":1536009,"change_date":"2022-10-17 21:42:00","inspection_id":"76900075","dot_number":"2992963","report_state":"CA","report_number":"UCOB003877","insp_date":"2022-10-13 00:00:00","insp_start_time":"1409","insp_end_time":"1432","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JIM HICKS & CO","shipping_paper_number":"81793163","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"107000","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":"14636927","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2022-10-17 21:42:00","snet_input_date":"2022-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-17 21:42:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:52.000000Z","updated_at":"2025-03-17T18:54:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2472070,"change_date":"2022-10-17 21:42:00","inspection_id":"76900075","insp_unit_id":"191488085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"9G27968","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X8HJ176730","insp_unit_decal":"Y","insp_unit_decal_number":"31822426","created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"},{"id":2472071,"change_date":"2022-10-17 21:42:00","inspection_id":"76900075","insp_unit_id":"191488086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"4NJ3130","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H4RA4324F3D50205","insp_unit_decal":"Y","insp_unit_decal_number":"31822427","created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"}]},{"id":991198,"change_date":"2022-08-08 21:40:00","inspection_id":"76267182","dot_number":"2992963","report_state":"CA","report_number":"UD7O001025","insp_date":"2022-08-05 00:00:00","insp_start_time":"2135","insp_end_time":"2142","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":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14538046","transaction_code":"A","transaction_date":"2022-08-06 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T18:45:06.000000Z","updated_at":"2025-03-17T18:45:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1595296,"change_date":"2022-08-08 21:40:00","inspection_id":"76267182","insp_unit_id":"190199695","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3XL\/BLK","insp_unit_license":"9E80239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0FD256367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:03.000000Z","updated_at":"2025-03-17T22:18:03.000000Z"}]},{"id":969250,"change_date":"2022-08-04 21:43:00","inspection_id":"76241774","dot_number":"2992963","report_state":"CA","report_number":"NE46001599","insp_date":"2022-08-03 00:00:00","insp_start_time":"0005","insp_end_time":"0031","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":"412","hazmat_placard_req":"Y","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-08-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"14533446","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2022-08-04 21:43:00","snet_input_date":"2022-08-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-04 21:43:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T18:44:46.000000Z","updated_at":"2025-03-17T18:44:46.000000Z","inspection_violations":[{"id":1529570,"change_date":"2022-08-04 21:43:00","inspection_id":"76241774","insp_violation_id":"247533899","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190149056","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:14:13.000000Z","updated_at":"2025-03-17T21:14:13.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":1559808,"change_date":"2022-08-04 21:43:00","inspection_id":"76241774","insp_unit_id":"190149056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"9E80239","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0FD256367","insp_unit_decal":"Y","insp_unit_decal_number":"31498296","created_at":"2025-03-17T22:17:48.000000Z","updated_at":"2025-03-17T22:17:48.000000Z"},{"id":1559809,"change_date":"2022-08-04 21:43:00","inspection_id":"76241774","insp_unit_id":"190149057","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"8129","insp_unit_license":"4TM4604","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"10BGB52T2WF0A8129","insp_unit_decal":"Y","insp_unit_decal_number":"31498297","created_at":"2025-03-17T22:17:48.000000Z","updated_at":"2025-03-17T22:17:48.000000Z"}]},{"id":782588,"change_date":"2022-07-08 21:41:00","inspection_id":"76023183","dot_number":"2992963","report_state":"CA","report_number":"NE46001476","insp_date":"2022-07-05 00:00:00","insp_start_time":"2330","insp_end_time":"0014","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":"312","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115500","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":"1","hazmat_oos_total":"0","snet_sequence_id":"14496128","transaction_code":"A","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02992963","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"DAVID MACIEL JR TRUCKING LLC","insp_carrier_street":"15218 EXCELSIOR AVE","insp_carrier_city":"HANFORD","insp_carrier_state":"CA","insp_carrier_zip_code":"93230","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"575051","created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[{"id":1236277,"change_date":"2022-07-08 21:41:00","inspection_id":"76023183","insp_violation_id":"246986906","seq_no":"1","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"2","insp_unit_id":"189684383","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"172516C6"},{"id":1236278,"change_date":"2022-07-08 21:41:00","inspection_id":"76023183","insp_violation_id":"246986907","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189684382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1259220,"change_date":"2022-07-08 21:41:00","inspection_id":"76023183","insp_unit_id":"189684382","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2","insp_unit_license":"9F91333","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X1GD285072","insp_unit_decal":"Y","insp_unit_decal_number":"31497179","created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"},{"id":1259221,"change_date":"2022-07-08 21:41:00","inspection_id":"76023183","insp_unit_id":"189684383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BARO","insp_unit_company":"5543","insp_unit_license":"4SL3726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4BUCEC1B7SB955543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2992963\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2992963\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2992963\/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\/2992963\/inspections","per_page":100,"prev_page_url":null,"to":39,"total":39}