{"current_page":1,"data":[{"id":12380326,"change_date":"2026-07-08 21:40:00","inspection_id":"88343194","dot_number":"2928559","report_state":"CA","report_number":"UFRF001578","insp_date":"2026-07-06 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"PD","ci_status_code":"C","location":"880","location_desc":"CA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","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":"3705906","transaction_code":"A","transaction_date":"2026-07-08 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2026-07-08 21:40:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:40:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312-6280","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2026-07-11T09:39:27.000000Z","updated_at":"2026-07-19T09:30:31.000000Z","inspection_violations":[{"id":21544576,"change_date":"2026-07-08 21:40:00","inspection_id":"88343194","insp_violation_id":"275349388","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"214489797","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-07-11T09:56:31.000000Z","updated_at":"2026-07-19T09:42:04.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":21497594,"change_date":"2026-07-08 21:40:00","inspection_id":"88343194","insp_unit_id":"214489796","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TR-17","insp_unit_license":"9F54729","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZDP9X9HJ158142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:21.000000Z","updated_at":"2026-07-19T09:01:40.000000Z"},{"id":21497595,"change_date":"2026-07-08 21:40:00","inspection_id":"88343194","insp_unit_id":"214489797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"TL-2","insp_unit_license":"4GT1917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PTF71TJ9J9012046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:21.000000Z","updated_at":"2026-07-19T09:01:40.000000Z"}]},{"id":12274476,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","dot_number":"2928559","report_state":"CA","report_number":"UHA2000426","insp_date":"2026-06-24 00:00:00","insp_start_time":"0941","insp_end_time":"1017","registration_date":null,"region":"PD","ci_status_code":"C","location":"9495","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"3612914","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2026-06-25 21:50:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:50:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312-6280","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:35.000000Z","updated_at":"2026-07-06T09:31:41.000000Z","inspection_violations":[{"id":21365577,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","insp_violation_id":"275114230","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214273968","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:15.000000Z","updated_at":"2026-07-06T09:46:02.000000Z","normalized_code":"3922SLLSR"},{"id":21365578,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","insp_violation_id":"275114231","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214273968","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:15.000000Z","updated_at":"2026-07-06T09:46:02.000000Z","normalized_code":"3922SLLSR"},{"id":21365579,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","insp_violation_id":"275114232","seq_no":"3","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"214273969","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:15.000000Z","updated_at":"2026-07-06T09:46:02.000000Z","normalized_code":"39311A1LLPL"},{"id":21365580,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","insp_violation_id":"275114233","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214273969","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-28T09:56:15.000000Z","updated_at":"2026-07-06T09:46:02.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":21314003,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","insp_unit_id":"214273968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9H09847","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV6GSHN6699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:05.000000Z","updated_at":"2026-07-06T09:03:20.000000Z"},{"id":21314004,"change_date":"2026-06-25 21:50:00","inspection_id":"88233931","insp_unit_id":"214273969","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"4PK1818","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1R9ESB509SL008082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:05.000000Z","updated_at":"2026-07-06T09:03:20.000000Z"}]},{"id":12097189,"change_date":"2026-06-04 21:45:00","inspection_id":"88041417","dot_number":"2928559","report_state":"CA","report_number":"UEQG004156","insp_date":"2026-06-03 00:00:00","insp_start_time":"1310","insp_end_time":"1341","registration_date":null,"region":"PS","ci_status_code":"C","location":"426","location_desc":"CA","county_code_state":"CA","county_code":"029","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":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"127350","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":"3461295","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312-6280","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2026-06-07T09:40:52.000000Z","updated_at":"2026-06-16T09:31:29.000000Z","inspection_violations":[{"id":21052847,"change_date":"2026-06-04 21:45:00","inspection_id":"88041417","insp_violation_id":"274694153","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RW44598","created_at":"2026-06-07T10:00:55.000000Z","updated_at":"2026-06-16T09:46:02.000000Z","normalized_code":"3922SLLS2"},{"id":21052848,"change_date":"2026-06-04 21:45:00","inspection_id":"88041417","insp_violation_id":"274694154","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213912657","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:55.000000Z","updated_at":"2026-06-16T09:46:02.000000Z","normalized_code":"3922SLLSR"},{"id":21052849,"change_date":"2026-06-04 21:45:00","inspection_id":"88041417","insp_violation_id":"274694155","seq_no":"3","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"213912658","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:55.000000Z","updated_at":"2026-06-16T09:46:02.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":21019901,"change_date":"2026-06-04 21:45:00","inspection_id":"88041417","insp_unit_id":"213912657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TR-3","insp_unit_license":"9F15309","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZDP9X4FJ439438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:01.000000Z","updated_at":"2026-06-16T09:03:29.000000Z"},{"id":21019902,"change_date":"2026-06-04 21:45:00","inspection_id":"88041417","insp_unit_id":"213912658","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZO","insp_unit_company":"BD-1","insp_unit_license":"4PK1816","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4B9BKDK24HH054431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:01.000000Z","updated_at":"2026-06-16T09:03:29.000000Z"}]},{"id":10828143,"change_date":"2026-01-21 21:38:00","inspection_id":"86856023","dot_number":"2928559","report_state":"CA","report_number":"UD8G000774","insp_date":"2026-01-19 00:00:00","insp_start_time":"0505","insp_end_time":"0551","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CJ MIRANDA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16138222","transaction_code":"A","transaction_date":"2026-01-19 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2026-01-21 21:38:00","snet_input_date":"2026-01-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-21 21:38:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2026-01-24T10:36:56.000000Z","updated_at":"2026-02-01T10:30:48.000000Z","inspection_violations":[{"id":18102061,"change_date":"2026-01-21 21:38:00","inspection_id":"86856023","insp_violation_id":"271344463","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"211218332","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK16079","created_at":"2026-01-24T10:43:13.000000Z","updated_at":"2026-02-01T10:37:20.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":18187201,"change_date":"2026-01-21 21:38:00","inspection_id":"86856023","insp_unit_id":"211218332","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLCO","insp_unit_company":"306\/WHT","insp_unit_license":"1WE7052","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1A9ES3023WC411004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:41.000000Z","updated_at":"2026-02-01T10:03:24.000000Z"},{"id":18187202,"change_date":"2026-01-21 21:38:00","inspection_id":"86856023","insp_unit_id":"211218333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17\/WHT","insp_unit_license":"9F54729","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZDP9X9HJ158142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:41.000000Z","updated_at":"2026-02-01T10:03:24.000000Z"}]},{"id":10323272,"change_date":"2025-12-01 21:39:00","inspection_id":"86450017","dot_number":"2928559","report_state":"CA","report_number":"NF4W000693","insp_date":"2025-11-26 00:00:00","insp_start_time":"0444","insp_end_time":"0503","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CJ MIRANDA","shipping_paper_number":"01","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-12-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"16076104","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2025-12-01 21:39:00","snet_input_date":"2025-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-01 21:39:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0491957","created_at":"2025-12-04T10:30:45.000000Z","updated_at":"2025-12-05T10:31:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17240017,"change_date":"2025-12-01 21:39:00","inspection_id":"86450017","insp_unit_id":"210340610","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TR17","insp_unit_license":"9F54729","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZDP9X9HJ158142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:47.000000Z","updated_at":"2025-12-05T10:02:08.000000Z"},{"id":17240018,"change_date":"2025-12-01 21:39:00","inspection_id":"86450017","insp_unit_id":"210340611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BTM","insp_unit_company":"ED3","insp_unit_license":"4SL4791","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1R9ESB5055L008066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:47.000000Z","updated_at":"2025-12-05T10:02:08.000000Z"}]},{"id":9147557,"change_date":"2025-07-14 21:41:00","inspection_id":"85214106","dot_number":"2928559","report_state":"CA","report_number":"UESX003153","insp_date":"2025-07-14 00:00:00","insp_start_time":"0712","insp_end_time":"0745","registration_date":null,"region":"PT","ci_status_code":"C","location":"426","location_desc":"OLD RIVER N\/B, AT COPUS","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WEST VALLEY CONSTRUCTION","shipping_paper_number":"12104407","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-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15897255","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-07-18T10:45:52.000000Z","updated_at":"2025-07-18T10:45:52.000000Z","inspection_violations":[{"id":14755319,"change_date":"2025-07-14 21:41:00","inspection_id":"85214106","insp_violation_id":"267401102","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD23079","created_at":"2025-07-17T10:47:23.000000Z","updated_at":"2025-07-18T10:47:55.000000Z","normalized_code":"39216AD"},{"id":14755320,"change_date":"2025-07-14 21:41:00","inspection_id":"85214106","insp_violation_id":"267401103","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"207867889","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-17T10:47:23.000000Z","updated_at":"2025-07-18T10:47:55.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15022217,"change_date":"2025-07-14 21:41:00","inspection_id":"85214106","insp_unit_id":"207867888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TR-19","insp_unit_license":"9E78209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGPDV7CDBN1800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:37.000000Z","updated_at":"2025-07-18T09:46:27.000000Z"},{"id":15022218,"change_date":"2025-07-14 21:41:00","inspection_id":"85214106","insp_unit_id":"207867889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"4TA7051","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4B9BKDG28LH054983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:37.000000Z","updated_at":"2025-07-18T09:46:27.000000Z"}]},{"id":9016954,"change_date":"2025-06-27 21:39:00","inspection_id":"85076409","dot_number":"2928559","report_state":"CA","report_number":"UFJK001041","insp_date":"2025-06-27 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"PT","ci_status_code":"C","location":"740","location_desc":"SR-46 LUCY BROWN SCALE","county_code_state":"CA","county_code":"079","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15879002","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-06-30T10:01:26.000000Z","updated_at":"2025-07-03T10:00:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14788469,"change_date":"2025-06-27 21:39:00","inspection_id":"85076409","insp_unit_id":"207613750","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TR17","insp_unit_license":"9F54729","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZDP9X9HJ158142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:41.000000Z","updated_at":"2025-07-01T09:50:05.000000Z"},{"id":14788470,"change_date":"2025-06-27 21:39:00","inspection_id":"85076409","insp_unit_id":"207613751","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"596","insp_unit_license":"4PL8882","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"48XFF3924H1010888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:41.000000Z","updated_at":"2025-07-01T09:50:05.000000Z"}]},{"id":8692947,"change_date":"2025-05-20 21:41:00","inspection_id":"84733321","dot_number":"2928559","report_state":"CA","report_number":"NDE9007631","insp_date":"2025-05-12 00:00:00","insp_start_time":"0641","insp_end_time":"0713","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15828368","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-05-23T10:04:32.000000Z","updated_at":"2025-05-24T10:06:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14203518,"change_date":"2025-05-20 21:41:00","inspection_id":"84733321","insp_unit_id":"206974808","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TR-19","insp_unit_license":"9E78209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGPDV7CDBN1800","insp_unit_decal":"Y","insp_unit_decal_number":"35067871","created_at":"2025-05-23T09:49:22.000000Z","updated_at":"2025-05-24T09:52:10.000000Z"},{"id":14203519,"change_date":"2025-05-20 21:41:00","inspection_id":"84733321","insp_unit_id":"206974809","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"TL-6","insp_unit_license":"4PK1815","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TKA04428YM053274","insp_unit_decal":"Y","insp_unit_decal_number":"35067872","created_at":"2025-05-23T09:49:22.000000Z","updated_at":"2025-05-24T09:52:10.000000Z"}]},{"id":7985490,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","dot_number":"2928559","report_state":"CA","report_number":"UFGN003688","insp_date":"2025-02-27 00:00:00","insp_start_time":"1134","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD AREA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN","shipping_paper_number":"15060024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15720594","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2025-02-27 21:42:00","snet_input_date":"2025-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-27 21:42:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[{"id":12477823,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_violation_id":"264749962","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NY002FX","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3922SLLEQP"},{"id":12477824,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_violation_id":"264749963","seq_no":"2","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NY002FX","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3922SLLTCD"},{"id":12477825,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_violation_id":"264749964","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205548115","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NY002FY","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3922SLLSR"},{"id":12477826,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_violation_id":"264749965","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205548115","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3922SLLEQP"},{"id":12477827,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_violation_id":"264749966","seq_no":"5","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"205548115","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NY002FY","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3939ALFTSI"},{"id":12477828,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_violation_id":"264749967","seq_no":"6","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"2","insp_unit_id":"205548116","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NY002FY","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3939ALTSIR"}],"inspection_per_units":[{"id":12891484,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_unit_id":"205548115","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9E78209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGPDV7CDBN1800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"},{"id":12891485,"change_date":"2025-02-27 21:42:00","inspection_id":"83988453","insp_unit_id":"205548116","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"4TA7051","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4B9BKDG28LH054983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"}]},{"id":7373931,"change_date":"2024-12-09 21:42:00","inspection_id":"83346400","dot_number":"2928559","report_state":"CA","report_number":"ND6D006365","insp_date":"2024-12-04 00:00:00","insp_start_time":"0455","insp_end_time":"0529","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MIRANDA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15621251","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2024-12-09 21:42:00","snet_input_date":"2024-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-09 21:42:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11521355,"change_date":"2024-12-09 21:42:00","inspection_id":"83346400","insp_violation_id":"263346032","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204282622","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLSR"},{"id":11521356,"change_date":"2024-12-09 21:42:00","inspection_id":"83346400","insp_violation_id":"263346033","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"2","insp_unit_id":"204282623","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":11895509,"change_date":"2024-12-09 21:42:00","inspection_id":"83346400","insp_unit_id":"204282622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TR14","insp_unit_license":"9F01404","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV6CSBM1176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"},{"id":11895510,"change_date":"2024-12-09 21:42:00","inspection_id":"83346400","insp_unit_id":"204282623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BTM","insp_unit_company":"ED3","insp_unit_license":"4SL4791","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1R9ESB5055L008066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:22.000000Z","updated_at":"2025-03-17T23:46:22.000000Z"}]},{"id":3506815,"change_date":"2023-07-13 21:43:00","inspection_id":"79141751","dot_number":"2928559","report_state":"CA","report_number":"UBG2998802","insp_date":"2023-07-13 00:00:00","insp_start_time":"0739","insp_end_time":"0755","registration_date":null,"region":"PT","ci_status_code":"C","location":"9480","location_desc":"VISALIA","county_code_state":"CA","county_code":"107","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":"2023-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14980774","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":"02928559","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK COURT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[{"id":5406905,"change_date":"2023-07-13 21:43:00","inspection_id":"79141751","insp_violation_id":"254057269","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":"MD93193","created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3922"},{"id":5406906,"change_date":"2023-07-13 21:43:00","inspection_id":"79141751","insp_violation_id":"254057270","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3922"},{"id":5406907,"change_date":"2023-07-13 21:43:00","inspection_id":"79141751","insp_violation_id":"254057271","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195996884","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5638891,"change_date":"2023-07-13 21:43:00","inspection_id":"79141751","insp_unit_id":"195996884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TR-17","insp_unit_license":"9F54729","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZDP9X9HJ158142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"},{"id":5638892,"change_date":"2023-07-13 21:43:00","inspection_id":"79141751","insp_unit_id":"195996885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WECO","insp_unit_company":"ED-1","insp_unit_license":"4RL7491","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W91032241W172702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":1358682,"change_date":"2022-09-23 21:38:00","inspection_id":"76694866","dot_number":"2928559","report_state":"CA","report_number":"NCVL004489","insp_date":"2022-09-22 00:00:00","insp_start_time":"0712","insp_end_time":"0738","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WASTE CONNECTION CHIQUITA CANYON","shipping_paper_number":"NH100821","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14607086","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-09-23 21:38:00","snet_input_date":"2022-09-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-23 21:38:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-03-17T18:51:40.000000Z","updated_at":"2025-03-17T18:51:40.000000Z","inspection_violations":[{"id":2150623,"change_date":"2022-09-23 21:38:00","inspection_id":"76694866","insp_violation_id":"248624382","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"191077462","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"39021TA"},{"id":2150624,"change_date":"2022-09-23 21:38:00","inspection_id":"76694866","insp_violation_id":"248624383","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191077463","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:16:49.000000Z","updated_at":"2025-03-17T21:16:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2187761,"change_date":"2022-09-23 21:38:00","inspection_id":"76694866","insp_unit_id":"191077462","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TR-15","insp_unit_license":"9G05224","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV8DSBU6767","insp_unit_decal":"Y","insp_unit_decal_number":"31501263","created_at":"2025-03-17T22:21:58.000000Z","updated_at":"2025-03-17T22:21:58.000000Z"},{"id":2187762,"change_date":"2022-09-23 21:38:00","inspection_id":"76694866","insp_unit_id":"191077463","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LTT","insp_unit_company":"V10","insp_unit_license":"1WE1563","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1L9AT422XVG223236","insp_unit_decal":"Y","insp_unit_decal_number":"31501264","created_at":"2025-03-17T22:21:58.000000Z","updated_at":"2025-03-17T22:21:58.000000Z"}]},{"id":1151556,"change_date":"2022-08-26 21:41:00","inspection_id":"76454447","dot_number":"2928559","report_state":"CA","report_number":"UEQG001044","insp_date":"2022-08-26 00:00:00","insp_start_time":"0840","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"7TH STANDARD E\/O SR-43","county_code_state":"CA","county_code":"029","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"14567548","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-08-26 21:41:00","snet_input_date":"2022-08-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-26 21:41:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0491957","created_at":"2025-03-17T18:47:56.000000Z","updated_at":"2025-03-17T18:47:56.000000Z","inspection_violations":[{"id":1825942,"change_date":"2022-08-26 21:41:00","inspection_id":"76454447","insp_violation_id":"248045830","seq_no":"1","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"190579441","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"39343A"}],"inspection_per_units":[{"id":1851603,"change_date":"2022-08-26 21:41:00","inspection_id":"76454447","insp_unit_id":"190579441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"CR-6","insp_unit_license":"12462W2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3FRXF7FJ6FV533057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:45.000000Z","updated_at":"2025-03-17T22:19:45.000000Z"}]},{"id":783052,"change_date":"2022-07-08 21:41:00","inspection_id":"76023695","dot_number":"2928559","report_state":"CA","report_number":"NEDJ000238","insp_date":"2022-07-06 00:00:00","insp_start_time":"0556","insp_end_time":"0621","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CJ MIRANDA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"14495673","transaction_code":"A","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-03-17T18:41:33.000000Z","updated_at":"2025-03-17T18:41:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1259924,"change_date":"2022-07-08 21:41:00","inspection_id":"76023695","insp_unit_id":"189685183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"TR-16","insp_unit_license":"9G05431","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXKD267032","insp_unit_decal":"Y","insp_unit_decal_number":"31497433","created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"},{"id":1259925,"change_date":"2022-07-08 21:41:00","inspection_id":"76023695","insp_unit_id":"189685184","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"GENA","insp_unit_company":"SS-621","insp_unit_license":"SE574230","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"SS62112418220207","insp_unit_decal":"Y","insp_unit_decal_number":"31497434","created_at":"2025-03-17T22:15:55.000000Z","updated_at":"2025-03-17T22:15:55.000000Z"}]},{"id":713457,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","dot_number":"2928559","report_state":"CA","report_number":"NCVL004116","insp_date":"2022-06-23 00:00:00","insp_start_time":"0901","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GILLIBRAND CO., INC.","shipping_paper_number":"003982","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14486831","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-06-28 21:43:00","snet_input_date":"2022-06-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-28 21:43:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-03-17T18:40:12.000000Z","updated_at":"2025-03-17T18:40:12.000000Z","inspection_violations":[{"id":1122315,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_violation_id":"246779788","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"189511883","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA235508","created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"393100B"},{"id":1122316,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_violation_id":"246779789","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189511883","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA235508","created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"3963A1"},{"id":1122317,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_violation_id":"246779790","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189511883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"39347E"},{"id":1122318,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_violation_id":"246779791","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189511883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"39347E"},{"id":1122319,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_violation_id":"246779792","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189511883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"39347E"},{"id":1122320,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_violation_id":"246779793","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189511883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":1146861,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_unit_id":"189511882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TR-13","insp_unit_license":"9F01405","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGEDV2CSBK6741","insp_unit_decal":"Y","insp_unit_decal_number":"31116966","created_at":"2025-03-17T22:15:15.000000Z","updated_at":"2025-03-17T22:15:15.000000Z"},{"id":1146862,"change_date":"2022-06-28 21:43:00","inspection_id":"75942483","insp_unit_id":"189511883","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"TL-2","insp_unit_license":"4GT1917","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PTF71TJ9J9012046","insp_unit_decal":"Y","insp_unit_decal_number":"31116969","created_at":"2025-03-17T22:15:15.000000Z","updated_at":"2025-03-17T22:15:15.000000Z"}]},{"id":439598,"change_date":"2022-05-19 21:42:00","inspection_id":"75617097","dot_number":"2928559","report_state":"CA","report_number":"UEQG000797","insp_date":"2022-05-18 00:00:00","insp_start_time":"1350","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"420","location_desc":"KERN COUNTY FAIRGROUNDS","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14436295","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-05-19 21:42:00","snet_input_date":"2022-05-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0491957","created_at":"2025-03-17T18:35:12.000000Z","updated_at":"2025-03-17T18:35:12.000000Z","inspection_violations":[{"id":694103,"change_date":"2022-05-19 21:42:00","inspection_id":"75617097","insp_violation_id":"245941610","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"188805941","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:10:15.000000Z","updated_at":"2025-03-17T21:10:15.000000Z","normalized_code":"39360D"},{"id":694104,"change_date":"2022-05-19 21:42:00","inspection_id":"75617097","insp_violation_id":"245941611","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188805941","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2025-03-17T21:10:15.000000Z","updated_at":"2025-03-17T21:10:15.000000Z","normalized_code":"3939A"},{"id":694105,"change_date":"2022-05-19 21:42:00","inspection_id":"75617097","insp_violation_id":"245941612","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"188805941","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2025-03-17T21:10:15.000000Z","updated_at":"2025-03-17T21:10:15.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":708813,"change_date":"2022-05-19 21:42:00","inspection_id":"75617097","insp_unit_id":"188805941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"CR-7","insp_unit_license":"47841X2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHM7X7FM440782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:33.000000Z","updated_at":"2025-03-17T22:12:33.000000Z"}]},{"id":452016,"change_date":"2022-05-20 21:42:00","inspection_id":"75631905","dot_number":"2928559","report_state":"CA","report_number":"ND6B003635","insp_date":"2022-05-17 00:00:00","insp_start_time":"1138","insp_end_time":"1213","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMBOY","shipping_paper_number":"6627122","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14437874","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-05-20 21:42:00","snet_input_date":"2022-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-20 21:42:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"491957","created_at":"2025-03-17T18:35:39.000000Z","updated_at":"2025-03-17T18:35:39.000000Z","inspection_violations":[{"id":716987,"change_date":"2022-05-20 21:42:00","inspection_id":"75631905","insp_violation_id":"245978577","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188834605","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:22.000000Z","updated_at":"2025-03-17T21:10:22.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":728699,"change_date":"2022-05-20 21:42:00","inspection_id":"75631905","insp_unit_id":"188834605","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"TR-16","insp_unit_license":"9G05431","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXKD267032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:40.000000Z","updated_at":"2025-03-17T22:12:40.000000Z"},{"id":728700,"change_date":"2022-05-20 21:42:00","inspection_id":"75631905","insp_unit_id":"188834606","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STEPH","insp_unit_company":"S1","insp_unit_license":"4KM6646","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1S9AL15B28H474242","insp_unit_decal":"Y","insp_unit_decal_number":"31196655","created_at":"2025-03-17T22:12:40.000000Z","updated_at":"2025-03-17T22:12:40.000000Z"}]},{"id":93406,"change_date":"2022-04-01 21:40:00","inspection_id":"75202269","dot_number":"2928559","report_state":"CA","report_number":"UEW2000763","insp_date":"2022-03-30 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"SR-58 E\/OF US-395","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MACPHERSON OIL CO","shipping_paper_number":"29429","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14367421","transaction_code":"A","transaction_date":"2022-04-01 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02928559","upload_search_indicator":null,"census_search_date":"2022-04-01 21:40:00","snet_input_date":"2022-03-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-01 21:40:00","insp_carrier_name":"C J MIRANDA INC","insp_carrier_street":"8749 OAK BROOK CT","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93312","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0491957","created_at":"2025-03-17T18:29:10.000000Z","updated_at":"2025-03-17T18:29:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":151575,"change_date":"2022-04-01 21:40:00","inspection_id":"75202269","insp_unit_id":"187950594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"TR16","insp_unit_license":"9G05431","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXKD267032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"},{"id":151576,"change_date":"2022-04-01 21:40:00","inspection_id":"75202269","insp_unit_id":"187950595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STEPH","insp_unit_company":"S1","insp_unit_license":"4KM6646","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1S9AL15B28H474242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2928559\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2928559\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2928559\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2928559\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}