{"current_page":1,"data":[{"id":12446187,"change_date":"2026-07-14 21:41:00","inspection_id":"88405945","dot_number":"2950933","report_state":"CA","report_number":"UGWF000397","insp_date":"2026-07-14 00:00:00","insp_start_time":"0914","insp_end_time":"0935","registration_date":null,"region":"PD","ci_status_code":"C","location":"9440","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3749122","transaction_code":"A","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2026-07-14 21:41:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-14 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662-3659","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2026-07-17T09:41:14.000000Z","updated_at":"2026-07-25T09:31:10.000000Z","inspection_violations":[{"id":21668628,"change_date":"2026-07-14 21:41:00","inspection_id":"88405945","insp_violation_id":"275497369","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:03:59.000000Z","updated_at":"2026-07-25T09:43:53.000000Z","normalized_code":"3922SLLCP"},{"id":21668629,"change_date":"2026-07-14 21:41:00","inspection_id":"88405945","insp_violation_id":"275497370","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":"SD50238","created_at":"2026-07-17T10:03:59.000000Z","updated_at":"2026-07-25T09:43:53.000000Z","normalized_code":"3922SLLDL"},{"id":21668630,"change_date":"2026-07-14 21:41:00","inspection_id":"88405945","insp_violation_id":"275497371","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214608260","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:03:59.000000Z","updated_at":"2026-07-25T09:43:53.000000Z","normalized_code":"39395A4EEUS"},{"id":21668631,"change_date":"2026-07-14 21:41:00","inspection_id":"88405945","insp_violation_id":"275497372","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214608260","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:03:59.000000Z","updated_at":"2026-07-25T09:43:53.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21619283,"change_date":"2026-07-14 21:41:00","inspection_id":"88405945","insp_unit_id":"214608260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"3707944","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GB4YSEY6RF304551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:18.000000Z","updated_at":"2026-07-25T09:02:54.000000Z"}]},{"id":12082292,"change_date":"2026-06-03 21:35:00","inspection_id":"88025068","dot_number":"2950933","report_state":"CA","report_number":"UGWF000318","insp_date":"2026-06-02 00:00:00","insp_start_time":"1238","insp_end_time":"1303","registration_date":null,"region":"PS","ci_status_code":"C","location":"9440","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-06-03 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3452933","transaction_code":"A","transaction_date":"2026-06-03 00:00:00","upload_date":"2026-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2026-06-03 21:35:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-03 21:35:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662-3659","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:38.000000Z","updated_at":"2026-06-15T09:30:05.000000Z","inspection_violations":[{"id":21025724,"change_date":"2026-06-03 21:35:00","inspection_id":"88025068","insp_violation_id":"274660207","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213883459","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:54.000000Z","updated_at":"2026-06-15T09:41:50.000000Z","normalized_code":"39395A4EEUS"},{"id":21025725,"change_date":"2026-06-03 21:35:00","inspection_id":"88025068","insp_violation_id":"274660208","seq_no":"3","part_no":"392","part_no_section":"16B-DPASS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:54.000000Z","updated_at":"2026-06-15T09:41:50.000000Z","normalized_code":"39216BDPASS"},{"id":21025723,"change_date":"2026-06-03 21:35:00","inspection_id":"88025068","insp_violation_id":"274660206","seq_no":"1","part_no":"392","part_no_section":"9A3","insp_viol_unit":"1","insp_unit_id":"213883459","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:54.000000Z","updated_at":"2026-06-15T09:41:50.000000Z","normalized_code":"3929A3"}],"inspection_per_units":[{"id":20995595,"change_date":"2026-06-03 21:35:00","inspection_id":"88025068","insp_unit_id":"213883459","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"4060784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GB4YSEY6RF213425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:43.000000Z","updated_at":"2026-06-15T09:01:13.000000Z"}]},{"id":11303631,"change_date":"2026-03-05 21:41:00","inspection_id":"87219447","dot_number":"2950933","report_state":"CA","report_number":"UGWF000124","insp_date":"2026-03-05 00:00:00","insp_start_time":"0709","insp_end_time":"0730","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16194710","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2026-03-05 21:41:00","snet_input_date":"2026-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-05 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:20.000000Z","updated_at":"2026-03-16T09:31:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19335153,"change_date":"2026-03-05 21:41:00","inspection_id":"87219447","insp_unit_id":"211998312","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X  \/ WHT","insp_unit_license":"3707944","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GB4YSEY6RF304551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:22.000000Z","updated_at":"2026-03-16T09:06:04.000000Z"}]},{"id":10354105,"change_date":"2025-12-04 21:38:00","inspection_id":"86482117","dot_number":"2950933","report_state":"CA","report_number":"UGWF000085","insp_date":"2025-12-03 00:00:00","insp_start_time":"1428","insp_end_time":"1455","registration_date":null,"region":"PT","ci_status_code":"C","location":"9481","location_desc":"AVE 152 W\/O ROAD 176","county_code_state":"CA","county_code":"107","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"13999","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":"16083144","transaction_code":"A","transaction_date":"2025-12-03 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2025-12-04 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-04 21:38:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-07T10:31:48.000000Z","updated_at":"2025-12-08T10:31:25.000000Z","inspection_violations":[{"id":17332246,"change_date":"2025-12-04 21:38:00","inspection_id":"86482117","insp_violation_id":"270472576","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210424497","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-12-07T10:32:26.000000Z","updated_at":"2025-12-08T10:32:15.000000Z","normalized_code":"39360D"},{"id":17332247,"change_date":"2025-12-04 21:38:00","inspection_id":"86482117","insp_violation_id":"270472577","seq_no":"2","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"210424497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-12-07T10:32:26.000000Z","updated_at":"2025-12-08T10:32:15.000000Z","normalized_code":"39021TELCMVINFO"}],"inspection_per_units":[{"id":17303194,"change_date":"2025-12-04 21:38:00","inspection_id":"86482117","insp_unit_id":"210424497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT \/ UTI","insp_unit_license":"3713704","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GB4YSEY9RF304690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:37.000000Z","updated_at":"2025-12-08T10:01:39.000000Z"}]},{"id":9514332,"change_date":"2025-08-26 21:41:00","inspection_id":"85599695","dot_number":"2950933","report_state":"CA","report_number":"UBGO004967","insp_date":"2025-08-25 00:00:00","insp_start_time":"1045","insp_end_time":"1104","registration_date":null,"region":"PT","ci_status_code":"C","location":"440","location_desc":"HANFORD","county_code_state":"CA","county_code":"031","insp_level_id":"4","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":"2025-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59459","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":"15952563","transaction_code":"A","transaction_date":"2025-08-25 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2025-08-26 21:41:00","snet_input_date":"2025-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-26 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-08-29T10:43:10.000000Z","updated_at":"2025-09-05T10:46:58.000000Z","inspection_violations":[{"id":15522384,"change_date":"2025-08-26 21:41:00","inspection_id":"85599695","insp_violation_id":"268269104","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208598302","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:01.000000Z","updated_at":"2025-09-05T10:50:01.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":15700229,"change_date":"2025-08-26 21:41:00","inspection_id":"85599695","insp_unit_id":"208598302","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"58729H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLJ0X3KM244128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:45.000000Z","updated_at":"2025-09-05T09:46:25.000000Z"}]},{"id":8682192,"change_date":"2025-05-19 21:41:00","inspection_id":"84722003","dot_number":"2950933","report_state":"CA","report_number":"UEQX001121","insp_date":"2025-05-16 00:00:00","insp_start_time":"0820","insp_end_time":"0855","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"FRESNO AREA","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":"N\/A","cargo_tank":"OTH","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":"2025-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2","hazmat_oos_total":"0","snet_sequence_id":"15824630","transaction_code":"A","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2025-05-19 21:41:00","snet_input_date":"2025-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-19 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-05-22T10:01:48.000000Z","updated_at":"2025-05-23T10:06:35.000000Z","inspection_violations":[{"id":13827906,"change_date":"2025-05-19 21:41:00","inspection_id":"84722003","insp_violation_id":"266334677","seq_no":"1","part_no":"177","part_no_section":"817E2-HMHC","insp_viol_unit":"1","insp_unit_id":"206953304","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:25:15.000000Z","updated_at":"2025-05-23T10:31:32.000000Z","normalized_code":"177817E2HMHC"},{"id":13827907,"change_date":"2025-05-19 21:41:00","inspection_id":"84722003","insp_violation_id":"266334678","seq_no":"2","part_no":"177","part_no_section":"801-HMHCNP","insp_viol_unit":"1","insp_unit_id":"206953304","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:25:15.000000Z","updated_at":"2025-05-23T10:31:32.000000Z","normalized_code":"177801HMHCNP"}],"inspection_per_units":[{"id":14183668,"change_date":"2025-05-19 21:41:00","inspection_id":"84722003","insp_unit_id":"206953304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"51285M2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ0X6JM474250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:27.000000Z","updated_at":"2025-05-23T09:51:59.000000Z"}]},{"id":7752678,"change_date":"2025-01-30 21:41:00","inspection_id":"83743996","dot_number":"2950933","report_state":"CA","report_number":"UG2G000815","insp_date":"2025-01-29 00:00:00","insp_start_time":"1607","insp_end_time":"1620","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"FOWLER","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-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"15684511","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:59:09.000000Z","updated_at":"2025-03-17T20:59:09.000000Z","inspection_violations":[{"id":12113769,"change_date":"2025-01-30 21:41:00","inspection_id":"83743996","insp_violation_id":"264267036","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"205091331","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA560115","created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3922SLL"},{"id":12113770,"change_date":"2025-01-30 21:41:00","inspection_id":"83743996","insp_violation_id":"264267037","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205091331","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":12511003,"change_date":"2025-01-30 21:41:00","inspection_id":"83743996","insp_unit_id":"205091331","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"HSR046","insp_unit_license":"96840B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G63LEE07041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:07.000000Z","updated_at":"2025-03-17T23:53:07.000000Z"}]},{"id":6694241,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","dot_number":"2950933","report_state":"HI","report_number":"BP16003172","insp_date":"2024-09-06 00:00:00","insp_start_time":"0934","insp_end_time":"1001","registration_date":null,"region":"HS","ci_status_code":"C","location":"108","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"832916","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-09-11 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-11 21:40:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662-3659","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:41.000000Z","updated_at":"2025-03-17T20:35:41.000000Z","inspection_violations":[{"id":10420868,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728513","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202858380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"3939A"},{"id":10420869,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728514","seq_no":"1","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"202858380","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"39021TB1"},{"id":10420870,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728515","seq_no":"2","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"202858380","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"39021TB2"},{"id":10420871,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728516","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202858380","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"3922"},{"id":10420872,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728517","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202858380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"3939A"},{"id":10420873,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728518","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"39141A"},{"id":10420874,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_violation_id":"261728519","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202858380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10793925,"change_date":"2024-09-11 21:40:00","inspection_id":"82625483","insp_unit_id":"202858380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7291","insp_unit_license":"542TWG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDUF4GT9HEC66425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"}]},{"id":6123223,"change_date":"2024-07-01 21:45:00","inspection_id":"82015029","dot_number":"2950933","report_state":"CA","report_number":"UBGO004291","insp_date":"2024-07-01 00:00:00","insp_start_time":"0635","insp_end_time":"0700","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":"OTH","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-01 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"15424916","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-07-01 21:45:00","snet_input_date":"2024-07-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-01 21:45:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:24:10.000000Z","updated_at":"2025-03-17T20:24:10.000000Z","inspection_violations":[{"id":9507387,"change_date":"2024-07-01 21:45:00","inspection_id":"82015029","insp_violation_id":"260421515","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK66010","created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"39216A"},{"id":9507388,"change_date":"2024-07-01 21:45:00","inspection_id":"82015029","insp_violation_id":"260421516","seq_no":"2","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"201687709","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"172516C6"},{"id":9507389,"change_date":"2024-07-01 21:45:00","inspection_id":"82015029","insp_violation_id":"260421517","seq_no":"3","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"201687709","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"177817E"},{"id":9507390,"change_date":"2024-07-01 21:45:00","inspection_id":"82015029","insp_violation_id":"260421518","seq_no":"4","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"201687709","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"177817E"}],"inspection_per_units":[{"id":9862972,"change_date":"2024-07-01 21:45:00","inspection_id":"82015029","insp_unit_id":"201687709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"003","insp_unit_license":"73107E2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HM7X3HM318505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:11.000000Z","updated_at":"2025-03-17T23:25:11.000000Z"}]},{"id":6066006,"change_date":"2024-06-24 21:43:00","inspection_id":"81953625","dot_number":"2950933","report_state":"CA","report_number":"UG7E000707","insp_date":"2024-06-22 00:00:00","insp_start_time":"0847","insp_end_time":"0859","registration_date":null,"region":"PT","ci_status_code":"C","location":"480","location_desc":"TULARE AREA","county_code_state":"CA","county_code":"107","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"15416817","transaction_code":"A","transaction_date":"2024-06-22 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-06-24 21:43:00","snet_input_date":"2024-06-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-24 21:43:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:58.000000Z","updated_at":"2025-03-17T20:22:58.000000Z","inspection_violations":[{"id":9411446,"change_date":"2024-06-24 21:43:00","inspection_id":"81953625","insp_violation_id":"260281804","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MV10565","created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9770205,"change_date":"2024-06-24 21:43:00","inspection_id":"81953625","insp_unit_id":"201567472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"34688D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G61LEE89481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:13.000000Z","updated_at":"2025-03-17T23:24:13.000000Z"}]},{"id":5954912,"change_date":"2024-06-10 21:44:00","inspection_id":"81833345","dot_number":"2950933","report_state":"CA","report_number":"UBAY003130","insp_date":"2024-06-10 00:00:00","insp_start_time":"1105","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"FRESNO AREA","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":"NON","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-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"15396623","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-06-10 21:44:00","snet_input_date":"2024-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-10 21:44:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:20:42.000000Z","updated_at":"2025-03-17T20:20:42.000000Z","inspection_violations":[{"id":9238113,"change_date":"2024-06-10 21:44:00","inspection_id":"81833345","insp_violation_id":"260003240","seq_no":"1","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"201320008","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:39.000000Z","updated_at":"2025-03-17T21:50:39.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":9591890,"change_date":"2024-06-10 21:44:00","inspection_id":"81833345","insp_unit_id":"201320008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"65","insp_unit_license":"53295A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ0X0LM675483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:29.000000Z","updated_at":"2025-03-17T23:22:29.000000Z"}]},{"id":5812844,"change_date":"2024-05-21 21:48:00","inspection_id":"81679354","dot_number":"2950933","report_state":"CA","report_number":"UBGO004194","insp_date":"2024-05-20 00:00:00","insp_start_time":"1550","insp_end_time":"1610","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-21 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"15372383","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-05-21 21:48:00","snet_input_date":"2024-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-21 21:48:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:17:54.000000Z","updated_at":"2025-03-17T20:17:54.000000Z","inspection_violations":[{"id":9005073,"change_date":"2024-05-21 21:48:00","inspection_id":"81679354","insp_violation_id":"259658608","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201024342","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059856","created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9361920,"change_date":"2024-05-21 21:48:00","inspection_id":"81679354","insp_unit_id":"201024342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"HSR082","insp_unit_license":"83874C3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G6XLEE89480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:12.000000Z","updated_at":"2025-03-17T23:20:12.000000Z"}]},{"id":5734815,"change_date":"2024-05-13 21:42:00","inspection_id":"81594614","dot_number":"2950933","report_state":"CA","report_number":"UBGO004166","insp_date":"2024-05-13 00:00:00","insp_start_time":"0650","insp_end_time":"0710","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":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15359774","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-05-13 21:42:00","snet_input_date":"2024-05-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-13 21:42:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:16:19.000000Z","updated_at":"2025-03-17T20:16:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9236896,"change_date":"2024-05-13 21:42:00","inspection_id":"81594614","insp_unit_id":"200865176","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"37KM3A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVHG3DV8JHJM1847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:57.000000Z","updated_at":"2025-03-17T23:18:57.000000Z"}]},{"id":5591231,"change_date":"2024-04-24 21:43:00","inspection_id":"81438313","dot_number":"2950933","report_state":"CA","report_number":"UBAY003095","insp_date":"2024-04-23 00:00:00","insp_start_time":"1245","insp_end_time":"1310","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"FRESNO AREA","county_code_state":"CA","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"15331635","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-04-24 21:43:00","snet_input_date":"2024-04-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-24 21:43:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:13:31.000000Z","updated_at":"2025-03-17T20:13:31.000000Z","inspection_violations":[{"id":8644106,"change_date":"2024-04-24 21:43:00","inspection_id":"81438313","insp_violation_id":"259126813","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200562982","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MS53517","created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9006219,"change_date":"2024-04-24 21:43:00","inspection_id":"81438313","insp_unit_id":"200562982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"HSR119","insp_unit_license":"51298R","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3HAEKTAT8PL033721","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:48.000000Z","updated_at":"2025-03-17T23:16:48.000000Z"}]},{"id":5449932,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","dot_number":"2950933","report_state":"CA","report_number":"UBGO004090","insp_date":"2024-04-05 00:00:00","insp_start_time":"0530","insp_end_time":"0553","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-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15307908","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[{"id":8412389,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780341","seq_no":"1","part_no":"393","part_no_section":"25(e)","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39325E"},{"id":8412390,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780342","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LH89646","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3939A"},{"id":8412391,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780343","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"},{"id":8412392,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780344","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LH89646","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"},{"id":8412393,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780345","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LH89646","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39311"},{"id":8412394,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780346","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39395A"},{"id":8412395,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780347","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LH89646","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"},{"id":8412396,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780348","seq_no":"8","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"LH89645","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39141A"},{"id":8412397,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_violation_id":"258780349","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200267494","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8778442,"change_date":"2024-04-05 21:40:00","inspection_id":"81284067","insp_unit_id":"200267494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"37KM3A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVHG3DV8JHJM1847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":4512472,"change_date":"2023-11-28 21:42:00","inspection_id":"80259519","dot_number":"2950933","report_state":"CA","report_number":"UBAY002904","insp_date":"2023-11-27 00:00:00","insp_start_time":"1100","insp_end_time":"1125","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"FRESNO AREA","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":"NON","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-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15147084","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-11-28 21:42:00","snet_input_date":"2023-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-28 21:42:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:52:13.000000Z","updated_at":"2025-03-17T19:52:13.000000Z","inspection_violations":[{"id":6982569,"change_date":"2023-11-28 21:42:00","inspection_id":"80259519","insp_violation_id":"256604784","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198252268","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39395F"},{"id":6982570,"change_date":"2023-11-28 21:42:00","inspection_id":"80259519","insp_violation_id":"256604785","seq_no":"2","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"198252268","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":7257600,"change_date":"2023-11-28 21:42:00","inspection_id":"80259519","insp_unit_id":"198252268","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"65\/WHT","insp_unit_license":"53295A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ0X0LM675483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:57.000000Z","updated_at":"2025-03-17T23:00:57.000000Z"}]},{"id":3516760,"change_date":"2023-07-14 21:41:00","inspection_id":"79152859","dot_number":"2950933","report_state":"CA","report_number":"UBGO003602","insp_date":"2023-07-14 00:00:00","insp_start_time":"0800","insp_end_time":"0815","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":"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":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14982882","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:32:30.000000Z","updated_at":"2025-03-17T19:32:30.000000Z","inspection_violations":[{"id":5422721,"change_date":"2023-07-14 21:41:00","inspection_id":"79152859","insp_violation_id":"254082250","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196018563","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5654787,"change_date":"2023-07-14 21:41:00","inspection_id":"79152859","insp_unit_id":"196018563","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"CHEN","insp_unit_company":"5-003088","insp_unit_license":"3293541","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTKJPVK6NH546239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":3515059,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","dot_number":"2950933","report_state":"CA","report_number":"UBGO003598","insp_date":"2023-07-13 00:00:00","insp_start_time":"1350","insp_end_time":"1439","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"9","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14981645","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[{"id":5421442,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080687","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LC21543","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5421443,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080688","seq_no":"9","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"LC21543","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39141A"},{"id":5421444,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080689","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5421445,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080690","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5421446,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080691","seq_no":"3","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LC21544","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39021TA"},{"id":5421447,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080692","seq_no":"4","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LC21544","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39021TA"},{"id":5421448,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080693","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LC21544","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3939A"},{"id":5421449,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080694","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3939A"},{"id":5421450,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_violation_id":"254080695","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196015650","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5652196,"change_date":"2023-07-14 21:41:00","inspection_id":"79151032","insp_unit_id":"196015650","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"10350554","insp_unit_license":"22119L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHLM9X7NM136054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":3494024,"change_date":"2023-07-12 21:41:00","inspection_id":"79127549","dot_number":"2950933","report_state":"CA","report_number":"UFJ3001820","insp_date":"2023-07-10 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"440","location_desc":"1565 GLENDALE AVE","county_code_state":"CA","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"2023-07-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14976021","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-07-12 21:41:00","snet_input_date":"2023-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-12 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497374","created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5618408,"change_date":"2023-07-12 21:41:00","inspection_id":"79127549","insp_unit_id":"195967703","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"HSR043","insp_unit_license":"96851B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G63LEE20730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:20.000000Z","updated_at":"2025-03-17T22:47:20.000000Z"}]},{"id":3416909,"change_date":"2023-06-30 21:41:00","inspection_id":"79040774","dot_number":"2950933","report_state":"CA","report_number":"UBAY002677","insp_date":"2023-06-29 00:00:00","insp_start_time":"1440","insp_end_time":"1505","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"FRESNO AREA","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":"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":"2023-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10040","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14966309","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-06-30 21:41:00","snet_input_date":"2023-06-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-30 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:30:37.000000Z","updated_at":"2025-03-17T19:30:37.000000Z","inspection_violations":[{"id":5268254,"change_date":"2023-06-30 21:41:00","inspection_id":"79040774","insp_violation_id":"253829296","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"},{"id":5268255,"change_date":"2023-06-30 21:41:00","inspection_id":"79040774","insp_violation_id":"253829297","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5493702,"change_date":"2023-06-30 21:41:00","inspection_id":"79040774","insp_unit_id":"195791343","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"HSR046\/WHT","insp_unit_license":"96840B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G63LEE07041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":3308418,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","dot_number":"2950933","report_state":"CA","report_number":"UBGO003513","insp_date":"2023-06-16 00:00:00","insp_start_time":"0800","insp_end_time":"0818","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":"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":"2023-06-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14947764","transaction_code":"A","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-06-16 21:41:00","snet_input_date":"2023-06-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-16 21:41:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:28:31.000000Z","updated_at":"2025-03-17T19:28:31.000000Z","inspection_violations":[{"id":5103850,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566884","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"3922"},{"id":5103851,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566885","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059519","created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"3922"},{"id":5103852,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566886","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"3922"},{"id":5103853,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566887","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059519","created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"39311"},{"id":5103854,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566888","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"39395A"},{"id":5103855,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566889","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059519","created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"39395F"},{"id":5103856,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566890","seq_no":"7","part_no":"396","part_no_section":"13(c)","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"39613C"},{"id":5103857,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_violation_id":"253566891","seq_no":"8","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195550657","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":5318965,"change_date":"2023-06-16 21:41:00","inspection_id":"78919007","insp_unit_id":"195550657","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"HSR043","insp_unit_license":"96851B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G63LEE20730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:57.000000Z","updated_at":"2025-03-17T22:44:57.000000Z"}]},{"id":3279122,"change_date":"2023-06-13 21:43:00","inspection_id":"78885656","dot_number":"2950933","report_state":"CA","report_number":"UBGO003493","insp_date":"2023-06-13 00:00:00","insp_start_time":"1110","insp_end_time":"1125","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":"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":"2023-06-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14941689","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-06-13 21:43:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-13 21:43:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:27:46.000000Z","updated_at":"2025-03-17T19:27:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5272607,"change_date":"2023-06-13 21:43:00","inspection_id":"78885656","insp_unit_id":"195484410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"05388S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT3KED32013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:33.000000Z","updated_at":"2025-03-17T22:44:33.000000Z"}]},{"id":2310125,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","dot_number":"2950933","report_state":"CA","report_number":"UBGO003116","insp_date":"2023-02-03 00:00:00","insp_start_time":"1300","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"435","location_desc":"SELMA","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":"OTH","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-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3","hazmat_oos_total":"0","snet_sequence_id":"14771916","transaction_code":"A","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2023-02-06 21:42:00","snet_input_date":"2023-02-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-06 21:42:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T19:09:15.000000Z","updated_at":"2025-03-17T19:09:15.000000Z","inspection_violations":[{"id":3559947,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","insp_violation_id":"250982342","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193260566","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3922"},{"id":3559948,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","insp_violation_id":"250982343","seq_no":"2","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"193260566","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"172516C6"},{"id":3559949,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","insp_violation_id":"250982344","seq_no":"3","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"193260566","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"177817E"},{"id":3559950,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","insp_violation_id":"250982345","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193260566","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3922"},{"id":3559951,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","insp_violation_id":"250982346","seq_no":"5","part_no":"172","part_no_section":"602(a)","insp_viol_unit":"1","insp_unit_id":"193260566","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"172602A"}],"inspection_per_units":[{"id":3718483,"change_date":"2023-02-06 21:42:00","inspection_id":"77786165","insp_unit_id":"193260566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"065","insp_unit_license":"53259A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ0X0LM675483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:38.000000Z","updated_at":"2025-03-17T22:32:38.000000Z"}]},{"id":1663036,"change_date":"2022-11-02 21:40:00","inspection_id":"77045960","dot_number":"2950933","report_state":"CA","report_number":"UBFW000786","insp_date":"2022-11-02 00:00:00","insp_start_time":"1040","insp_end_time":"1055","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":"2022-11-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14660872","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2022-11-02 21:40:00","snet_input_date":"2022-11-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-02 21:40:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T18:57:23.000000Z","updated_at":"2025-03-17T18:57:23.000000Z","inspection_violations":[{"id":2609028,"change_date":"2022-11-02 21:40:00","inspection_id":"77045960","insp_violation_id":"249409013","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191783777","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CU055269","created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2675775,"change_date":"2022-11-02 21:40:00","inspection_id":"77045960","insp_unit_id":"191783777","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UTIL F550","insp_unit_license":"3417748","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3C7WRNBL9NG171601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:21.000000Z","updated_at":"2025-03-17T22:25:21.000000Z"}]},{"id":1619039,"change_date":"2022-10-27 21:42:00","inspection_id":"76995729","dot_number":"2950933","report_state":"CA","report_number":"UBAY002301","insp_date":"2022-10-26 00:00:00","insp_start_time":"1030","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"FRESNO AREA","county_code_state":"CA","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"14651195","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2022-10-27 21:42:00","snet_input_date":"2022-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-27 21:42:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T18:56:21.000000Z","updated_at":"2025-03-17T18:56:21.000000Z","inspection_violations":[{"id":2543371,"change_date":"2022-10-27 21:42:00","inspection_id":"76995729","insp_violation_id":"249299210","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191684467","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LV13472","created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3922"},{"id":2543372,"change_date":"2022-10-27 21:42:00","inspection_id":"76995729","insp_violation_id":"249299211","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191684467","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LV13472","created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3922"},{"id":2543373,"change_date":"2022-10-27 21:42:00","inspection_id":"76995729","insp_violation_id":"249299212","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"191684467","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":2605096,"change_date":"2022-10-27 21:42:00","inspection_id":"76995729","insp_unit_id":"191684467","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT","insp_unit_license":"83901C3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G62LEE62323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:52.000000Z","updated_at":"2025-03-17T22:24:52.000000Z"}]},{"id":1253213,"change_date":"2022-09-09 21:39:00","inspection_id":"76571991","dot_number":"2950933","report_state":"CA","report_number":"UEIN000323","insp_date":"2022-09-08 00:00:00","insp_start_time":"0655","insp_end_time":"0735","registration_date":null,"region":"PD","ci_status_code":"C","location":"435","location_desc":"CEDAR N\/O CLAYTON","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"14588084","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02950933","upload_search_indicator":null,"census_search_date":"2022-09-09 21:39:00","snet_input_date":"2022-09-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-09 21:39:00","insp_carrier_name":"DRAGADOS FLATIRON A JOINT VENTURE","insp_carrier_street":"1775 PARK ST STE 75","insp_carrier_city":"SELMA","insp_carrier_state":"CA","insp_carrier_zip_code":"93662","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"497394","created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[{"id":1984855,"change_date":"2022-09-09 21:39:00","inspection_id":"76571991","insp_violation_id":"248323661","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LV 13332","created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2017080,"change_date":"2022-09-09 21:39:00","inspection_id":"76571991","insp_unit_id":"190821529","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"76373K3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDRF3G68LEE90286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:51.000000Z","updated_at":"2025-03-17T22:20:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2950933\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2950933\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2950933\/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\/2950933\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}