{"current_page":1,"data":[{"id":11637038,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","dot_number":"2228721","report_state":"CA","report_number":"UGWF000196","insp_date":"2026-04-13 00:00:00","insp_start_time":"0938","insp_end_time":"1017","registration_date":null,"region":"PT","ci_status_code":"C","location":"9440","location_desc":"HANFORD AREA","county_code_state":"CA","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"8","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16244369","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-24T09:31:42.000000Z","updated_at":"2026-04-24T09:31:42.000000Z","inspection_violations":[{"id":20200843,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577315","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3922SLLSR"},{"id":20200844,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577316","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3939ALSML"},{"id":20200845,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577317","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3939ALTSI"},{"id":20200846,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577318","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3939ALCL"},{"id":20200847,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577319","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3939ALSLI"},{"id":20200848,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577320","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3939ALLPL"},{"id":20200849,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577321","seq_no":"7","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":"SD49883","created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3958A1HOSP"},{"id":20200850,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_violation_id":"273577322","seq_no":"8","part_no":"393","part_no_section":"9B-LIL","insp_viol_unit":"1","insp_unit_id":"212996127","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:44:38.000000Z","updated_at":"2026-04-24T09:44:38.000000Z","normalized_code":"3939BLIL"}],"inspection_per_units":[{"id":20240789,"change_date":"2026-04-13 21:38:00","inspection_id":"87565888","insp_unit_id":"212996127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X WHT","insp_unit_license":"20621J4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRNBL0SG525730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:04:39.000000Z","updated_at":"2026-04-24T09:04:39.000000Z"}]},{"id":11430515,"change_date":"2026-03-20 21:40:00","inspection_id":"87346752","dot_number":"2228721","report_state":"CA","report_number":"UHA2000229","insp_date":"2026-03-20 00:00:00","insp_start_time":"0909","insp_end_time":"0949","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"E CENTRAL AVE WO S WILLLOW AVE","county_code_state":"CA","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39990","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16217189","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:42.000000Z","updated_at":"2026-03-31T09:31:46.000000Z","inspection_violations":[{"id":19284769,"change_date":"2026-03-20 21:40:00","inspection_id":"87346752","insp_violation_id":"272532689","seq_no":"1","part_no":"392","part_no_section":"71A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"005P000HQ","created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"39271AD"},{"id":19284770,"change_date":"2026-03-20 21:40:00","inspection_id":"87346752","insp_violation_id":"272532690","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"00P5000HQ","created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"38323A2LCDLN"},{"id":19284771,"change_date":"2026-03-20 21:40:00","inspection_id":"87346752","insp_violation_id":"272532691","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"212247600","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":19581527,"change_date":"2026-03-20 21:40:00","inspection_id":"87346752","insp_unit_id":"212247599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"21386C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3NG114641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:08.000000Z","updated_at":"2026-03-31T09:12:34.000000Z"},{"id":19581528,"change_date":"2026-03-20 21:40:00","inspection_id":"87346752","insp_unit_id":"212247600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIRE","insp_unit_company":null,"insp_unit_license":"4PN4129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5R8GF4028MM079902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:08.000000Z","updated_at":"2026-03-31T09:12:34.000000Z"}]},{"id":11430528,"change_date":"2026-03-20 21:40:00","inspection_id":"87346765","dot_number":"2228721","report_state":"CA","report_number":"UHA2000231","insp_date":"2026-03-20 00:00:00","insp_start_time":"1040","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"E CENTRAL AVE WO S WILLOW AVE","county_code_state":"CA","county_code":"019","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16217602","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:42.000000Z","updated_at":"2026-03-31T09:31:46.000000Z","inspection_violations":[{"id":19284789,"change_date":"2026-03-20 21:40:00","inspection_id":"87346765","insp_violation_id":"272532711","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212247620","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"3922SLLSR"},{"id":19284790,"change_date":"2026-03-20 21:40:00","inspection_id":"87346765","insp_violation_id":"272532712","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212247620","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"39395A4EEUS"},{"id":19284791,"change_date":"2026-03-20 21:40:00","inspection_id":"87346765","insp_violation_id":"272532713","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"212247620","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"39395A1"},{"id":19284792,"change_date":"2026-03-20 21:40:00","inspection_id":"87346765","insp_violation_id":"272532714","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"212247620","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:57.000000Z","updated_at":"2026-03-31T09:51:23.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":19581547,"change_date":"2026-03-20 21:40:00","inspection_id":"87346765","insp_unit_id":"212247620","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"85068C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRLL6NG339272","insp_unit_decal":"Y","insp_unit_decal_number":"35900802","created_at":"2026-03-23T09:30:08.000000Z","updated_at":"2026-03-31T09:12:34.000000Z"}]},{"id":9974295,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","dot_number":"2228721","report_state":"CA","report_number":"UG2G001206","insp_date":"2025-10-17 00:00:00","insp_start_time":"1035","insp_end_time":"1133","registration_date":null,"region":"PT","ci_status_code":"C","location":"495","location_desc":"5 POINTS","county_code_state":"CA","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"9","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16022312","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-10-20T10:01:57.000000Z","updated_at":"2025-10-21T10:01:03.000000Z","inspection_violations":[{"id":16476229,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373863","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"SD16448","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"38323A2LCDLN"},{"id":16476230,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373864","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209533270","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD16449","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"3922SLLSR"},{"id":16476231,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373865","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209533270","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"3922SLLSR"},{"id":16476232,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373866","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209533270","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"3922SLLSR"},{"id":16476233,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373867","seq_no":"5","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"209533270","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD16449","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"3922SLL"},{"id":16476234,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373868","seq_no":"6","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209533270","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"39395A1"},{"id":16476235,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373869","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209533270","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"39395F"},{"id":16476236,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373870","seq_no":"8","part_no":"393","part_no_section":"110B2I-C","insp_viol_unit":"2","insp_unit_id":"209533271","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"393110B2IC"},{"id":16476237,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_violation_id":"269373871","seq_no":"9","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"209533271","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2025-10-20T10:18:05.000000Z","updated_at":"2025-10-21T10:16:54.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":16561166,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_unit_id":"209533270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X GRY","insp_unit_license":"84896J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3NG114641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:09.000000Z","updated_at":"2025-10-21T09:46:29.000000Z"},{"id":16561167,"change_date":"2025-10-17 21:39:00","inspection_id":"86083065","insp_unit_id":"209533271","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS","insp_unit_company":"2X BLK FB","insp_unit_license":"4WD8845","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7HCGF2524PB039367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:09.000000Z","updated_at":"2025-10-21T09:46:29.000000Z"}]},{"id":8762244,"change_date":"2025-09-24 21:42:00","inspection_id":"84806655","dot_number":"2228721","report_state":"CA","report_number":"UG2G000993","insp_date":"2025-05-28 00:00:00","insp_start_time":"1109","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"495","location_desc":"COALINGA","county_code_state":"CA","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15839357","transaction_code":"C","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-05-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-28 21:44:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-05-31T10:01:42.000000Z","updated_at":"2025-09-28T10:00:35.000000Z","inspection_violations":[{"id":16055714,"change_date":"2025-09-24 21:42:00","inspection_id":"84806655","insp_violation_id":"268910153","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"209134965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-09-27T10:17:03.000000Z","updated_at":"2025-09-28T10:15:55.000000Z","normalized_code":"3939ALSLI"},{"id":16055715,"change_date":"2025-09-24 21:42:00","inspection_id":"84806655","insp_violation_id":"268910154","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"209134965","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RW62615","created_at":"2025-09-27T10:17:03.000000Z","updated_at":"2025-09-28T10:15:55.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":16183485,"change_date":"2025-09-24 21:42:00","inspection_id":"84806655","insp_unit_id":"209134965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X STK BED","insp_unit_license":"3787732","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3C7WRMBL7RG224487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:22.000000Z","updated_at":"2025-09-29T09:46:02.000000Z"}]},{"id":8610799,"change_date":"2025-05-12 21:41:00","inspection_id":"84646875","dot_number":"2228721","report_state":"CA","report_number":"ND7N009500","insp_date":"2025-05-08 00:00:00","insp_start_time":"2007","insp_end_time":"2109","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15815025","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2025-05-12 21:41:00","snet_input_date":"2025-05-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-12 21:41:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-05-15T10:01:24.000000Z","updated_at":"2025-05-17T10:06:45.000000Z","inspection_violations":[{"id":13686143,"change_date":"2025-05-12 21:41:00","inspection_id":"84646875","insp_violation_id":"266175991","seq_no":"1","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RK90678","created_at":"2025-05-15T10:24:40.000000Z","updated_at":"2025-05-16T10:31:59.000000Z","normalized_code":"39141A"},{"id":13686144,"change_date":"2025-05-12 21:41:00","inspection_id":"84646875","insp_violation_id":"266175992","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK90678","created_at":"2025-05-15T10:24:40.000000Z","updated_at":"2025-05-16T10:31:59.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":14057393,"change_date":"2025-05-12 21:41:00","inspection_id":"84646875","insp_unit_id":"206816985","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"11551370","insp_unit_license":"3730322","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FDRF3H67NED43149","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:26.000000Z","updated_at":"2025-05-16T09:52:23.000000Z"},{"id":14057394,"change_date":"2025-05-12 21:41:00","inspection_id":"84646875","insp_unit_id":"206816986","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGI","insp_unit_company":"2X GRN","insp_unit_license":"4VL2676","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B9SB1426NS252293","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:26.000000Z","updated_at":"2025-05-16T09:52:23.000000Z"}]},{"id":8268752,"change_date":"2025-04-01 21:41:00","inspection_id":"84286649","dot_number":"2228721","report_state":"CA","report_number":"UBFW002539","insp_date":"2025-03-31 00:00:00","insp_start_time":"1335","insp_end_time":"1414","registration_date":null,"region":"PT","ci_status_code":"C","location":"440","location_desc":"HANFORD AREA","county_code_state":"CA","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"15761875","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2025-04-01 21:41:00","snet_input_date":"2025-03-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-01 21:41:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-04-04T10:21:35.000000Z","updated_at":"2025-04-06T10:22:15.000000Z","inspection_violations":[{"id":12992051,"change_date":"2025-04-01 21:41:00","inspection_id":"84286649","insp_violation_id":"265384645","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"206105759","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BK93745","created_at":"2025-04-04T10:55:37.000000Z","updated_at":"2025-04-04T11:04:14.000000Z","normalized_code":"39021TB1MC"},{"id":12992052,"change_date":"2025-04-01 21:41:00","inspection_id":"84286649","insp_violation_id":"265384646","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"206105759","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BK93745","created_at":"2025-04-04T10:55:37.000000Z","updated_at":"2025-04-04T11:04:14.000000Z","normalized_code":"3922SLLTL"},{"id":12992053,"change_date":"2025-04-01 21:41:00","inspection_id":"84286649","insp_violation_id":"265384647","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"206105760","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2025-04-04T10:55:37.000000Z","updated_at":"2025-04-04T11:04:14.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":13382896,"change_date":"2025-04-01 21:41:00","inspection_id":"84286649","insp_unit_id":"206105759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X UTIL","insp_unit_license":"NONE","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL3NG114641","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-04T10:14:13.000000Z","updated_at":"2025-04-05T10:05:08.000000Z"},{"id":13382897,"change_date":"2025-04-01 21:41:00","inspection_id":"84286649","insp_unit_id":"206105760","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGW","insp_unit_company":"1X TANK","insp_unit_license":"4WP6883","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B9SB1211RS252170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-04T10:14:13.000000Z","updated_at":"2025-04-05T10:05:08.000000Z"}]},{"id":8101029,"change_date":"2025-03-12 21:41:00","inspection_id":"84110002","dot_number":"2228721","report_state":"CA","report_number":"NF8B001284","insp_date":"2025-03-11 00:00:00","insp_start_time":"1716","insp_end_time":"1801","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":"BROOKSCO EXPEDITING LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26300","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":"15737227","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2025-03-12 21:41:00","snet_input_date":"2025-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-12 21:41:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-03-17T21:06:49.000000Z","updated_at":"2025-03-17T21:06:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13079739,"change_date":"2025-03-12 21:41:00","inspection_id":"84110002","insp_unit_id":"205768811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT","insp_unit_license":"79254X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3ML0PG625388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:34.000000Z","updated_at":"2025-03-17T23:59:34.000000Z"},{"id":13079740,"change_date":"2025-03-12 21:41:00","inspection_id":"84110002","insp_unit_id":"205768812","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGI","insp_unit_company":"TNK\/BT\/86","insp_unit_license":"DZ03A13","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B9SB1429RS25228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:34.000000Z","updated_at":"2025-03-17T23:59:34.000000Z"}]},{"id":7913367,"change_date":"2025-02-19 21:41:00","inspection_id":"83912884","dot_number":"2228721","report_state":"CA","report_number":"NDLY008870","insp_date":"2025-02-18 00:00:00","insp_start_time":"1343","insp_end_time":"1410","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":"WAGNER AG","shipping_paper_number":"250143","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"15708293","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12773726,"change_date":"2025-02-19 21:41:00","inspection_id":"83912884","insp_unit_id":"205408106","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHT","insp_unit_license":"85068C4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRLL6NG339272","insp_unit_decal":"Y","insp_unit_decal_number":"34781866","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"},{"id":12773727,"change_date":"2025-02-19 21:41:00","inspection_id":"83912884","insp_unit_id":"205408107","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGI","insp_unit_company":"BT86\/GRN","insp_unit_license":"DZ03A13","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1B9SB1429RS25228","insp_unit_decal":"Y","insp_unit_decal_number":"34781867","created_at":"2025-03-17T23:56:06.000000Z","updated_at":"2025-03-17T23:56:06.000000Z"}]},{"id":7341045,"change_date":"2024-12-04 21:42:00","inspection_id":"83311713","dot_number":"2228721","report_state":"CA","report_number":"NC20007438","insp_date":"2024-12-03 00:00:00","insp_start_time":"1340","insp_end_time":"1415","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"38290","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":"15617345","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[{"id":11476214,"change_date":"2024-12-04 21:42:00","inspection_id":"83311713","insp_violation_id":"263245044","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"204192247","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA249159","created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11842163,"change_date":"2024-12-04 21:42:00","inspection_id":"83311713","insp_unit_id":"204192246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X\/WHT","insp_unit_license":"79254X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3ML0PG625388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11842164,"change_date":"2024-12-04 21:42:00","inspection_id":"83311713","insp_unit_id":"204192247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXE","insp_unit_company":"2X\/FB BLK","insp_unit_license":"4PN4129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5R8GF4028MM079902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7341349,"change_date":"2024-12-04 21:42:00","inspection_id":"83312031","dot_number":"2228721","report_state":"CA","report_number":"ND7N008898","insp_date":"2024-12-03 00:00:00","insp_start_time":"1524","insp_end_time":"1534","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"38290","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":"15616884","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2024-12-04 21:42:00","snet_input_date":"2024-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-04 21:42:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11842568,"change_date":"2024-12-04 21:42:00","inspection_id":"83312031","insp_unit_id":"204192688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X WHT","insp_unit_license":"79254X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3ML0PG625388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11842569,"change_date":"2024-12-04 21:42:00","inspection_id":"83312031","insp_unit_id":"204192689","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTRLR","insp_unit_company":"2X BLK","insp_unit_license":"4PN4129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5R8GF4028MM079902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7139190,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","dot_number":"2228721","report_state":"CA","report_number":"UBGO004507","insp_date":"2024-11-05 00:00:00","insp_start_time":"1235","insp_end_time":"1303","registration_date":null,"region":"PT","ci_status_code":"C","location":"440","location_desc":"HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39990","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15584680","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2024-11-06 21:41:00","snet_input_date":"2024-11-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-06 21:41:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"625626","created_at":"2025-03-17T20:44:43.000000Z","updated_at":"2025-03-17T20:44:43.000000Z","inspection_violations":[{"id":11151685,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_violation_id":"262770222","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203771810","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059956","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLSR"},{"id":11151686,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_violation_id":"262770223","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"203771810","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39395A4EEUS"},{"id":11151687,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_violation_id":"262770224","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"203771810","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLL"},{"id":11151688,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_violation_id":"262770225","seq_no":"4","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"1","insp_unit_id":"203771810","insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3958A1HOSP"},{"id":11151689,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_violation_id":"262770226","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"203771809","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11514502,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_unit_id":"203771809","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTRLR","insp_unit_company":null,"insp_unit_license":"4PN4129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5R8GF4028MM079902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:17.000000Z","updated_at":"2025-03-17T23:42:17.000000Z"},{"id":11514503,"change_date":"2024-11-06 21:41:00","inspection_id":"83098367","insp_unit_id":"203771810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"3","insp_unit_license":"EP18755","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRLL6NG339272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:17.000000Z","updated_at":"2025-03-17T23:42:17.000000Z"}]},{"id":6603059,"change_date":"2024-08-29 21:43:00","inspection_id":"82528560","dot_number":"2228721","report_state":"CA","report_number":"NC20007232","insp_date":"2024-08-27 00:00:00","insp_start_time":"0854","insp_end_time":"0946","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"38200","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":"15500641","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:02.000000Z","updated_at":"2025-03-17T20:34:02.000000Z","inspection_violations":[{"id":10269007,"change_date":"2024-08-29 21:43:00","inspection_id":"82528560","insp_violation_id":"261510223","seq_no":"1","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"202668627","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:55:43.000000Z","updated_at":"2025-03-17T21:55:43.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":10645930,"change_date":"2024-08-29 21:43:00","inspection_id":"82528560","insp_unit_id":"202668626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X\/WHT","insp_unit_license":"79254X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3ML0PG625388","insp_unit_decal":"Y","insp_unit_decal_number":"34166400","created_at":"2025-03-17T23:33:16.000000Z","updated_at":"2025-03-17T23:33:16.000000Z"},{"id":10645931,"change_date":"2024-08-29 21:43:00","inspection_id":"82528560","insp_unit_id":"202668627","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"210\/FB BLK","insp_unit_license":"4UM5703","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3821N6159881","insp_unit_decal":"Y","insp_unit_decal_number":"34166401","created_at":"2025-03-17T23:33:16.000000Z","updated_at":"2025-03-17T23:33:16.000000Z"}]},{"id":4828786,"change_date":"2024-01-12 21:44:00","inspection_id":"80605970","dot_number":"2228721","report_state":"CA","report_number":"UBVF003561","insp_date":"2024-01-12 00:00:00","insp_start_time":"0850","insp_end_time":"0915","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":"LOCK SEED","shipping_paper_number":"40026","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"15198820","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2024-01-12 21:44:00","snet_input_date":"2024-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-12 21:44:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:26.000000Z","updated_at":"2025-03-17T19:58:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7768972,"change_date":"2024-01-12 21:44:00","inspection_id":"80605970","insp_unit_id":"198952200","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT DUALLY","insp_unit_license":"EP18755","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRLL6NG339272","insp_unit_decal":"Y","insp_unit_decal_number":"33537326","created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"},{"id":7768973,"change_date":"2024-01-12 21:44:00","inspection_id":"80605970","insp_unit_id":"198952201","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TEXAS","insp_unit_company":"FLTBD BLK","insp_unit_license":"A7B941","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"7HCGF2524PB039367","insp_unit_decal":"Y","insp_unit_decal_number":"33537327","created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"}]},{"id":4189153,"change_date":"2023-10-12 21:42:00","inspection_id":"79902626","dot_number":"2228721","report_state":"CA","report_number":"NBH0007000","insp_date":"2023-10-10 00:00:00","insp_start_time":"1238","insp_end_time":"1318","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"38200","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":"15093981","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2023-10-12 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-12 21:42:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"625626","created_at":"2025-03-17T19:45:51.000000Z","updated_at":"2025-03-17T19:45:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6737010,"change_date":"2023-10-12 21:42:00","inspection_id":"79902626","insp_unit_id":"197537688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT","insp_unit_license":"78211R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63R3NLXNG421130","insp_unit_decal":"Y","insp_unit_decal_number":"33227217","created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"},{"id":6737011,"change_date":"2023-10-12 21:42:00","inspection_id":"79902626","insp_unit_id":"197537689","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"BLK","insp_unit_license":"TEMP","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16V3F3825P6282540","insp_unit_decal":"Y","insp_unit_decal_number":"33227218","created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":3326163,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","dot_number":"2228721","report_state":"UT","report_number":"23DT000287","insp_date":"2023-06-15 00:00:00","insp_start_time":"1032","insp_end_time":"1140","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GARDEN CITY","county_code_state":"UT","county_code":"033","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRINSCO","shipping_paper_number":"PKS0003088","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39990","viol_total":"5","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"886366","transaction_code":"C","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02228721","upload_search_indicator":null,"census_search_date":"2023-06-20 21:41:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"BROOKSCO EXPEDITING LLC","insp_carrier_street":"389 N LINCOLN AVE","insp_carrier_city":"DINUBA","insp_carrier_state":"CA","insp_carrier_zip_code":"93618","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:54.000000Z","updated_at":"2025-03-17T19:28:54.000000Z","inspection_violations":[{"id":5129648,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_violation_id":"253874776","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"C181688342","created_at":"2025-03-17T21:30:50.000000Z","updated_at":"2025-03-17T21:30:50.000000Z","normalized_code":"3922"},{"id":5129649,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_violation_id":"253874777","seq_no":"2","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:50.000000Z","updated_at":"2025-03-17T21:30:50.000000Z","normalized_code":"39530B1"},{"id":5129650,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_violation_id":"253874778","seq_no":"3","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:50.000000Z","updated_at":"2025-03-17T21:30:50.000000Z","normalized_code":"3958"},{"id":5129651,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_violation_id":"253874779","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:50.000000Z","updated_at":"2025-03-17T21:30:50.000000Z","normalized_code":"3958E1"},{"id":5129652,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_violation_id":"253874780","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195835037","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:50.000000Z","updated_at":"2025-03-17T21:30:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5347415,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_unit_id":"195835037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"01","insp_unit_license":"EP18755","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRLL6NG339272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:11.000000Z","updated_at":"2025-03-17T22:45:11.000000Z"},{"id":5347416,"change_date":"2023-07-05 21:42:00","inspection_id":"78938891","insp_unit_id":"195835038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXE","insp_unit_company":null,"insp_unit_license":"4PN4129","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5R8GF4028MM079902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:11.000000Z","updated_at":"2025-03-17T22:45:11.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2228721\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2228721\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2228721\/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\/2228721\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}