{"current_page":1,"data":[{"id":10817612,"change_date":"2026-01-20 21:41:00","inspection_id":"86845036","dot_number":"1851983","report_state":"CA","report_number":"NBH0009723","insp_date":"2026-01-15 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-20 21:41: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":"16135608","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2026-01-20 21:41:00","snet_input_date":"2026-01-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-20 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:31.000000Z","updated_at":"2026-01-31T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18166444,"change_date":"2026-01-20 21:41:00","inspection_id":"86845036","insp_unit_id":"211194618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"44016V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"Y","insp_unit_decal_number":"35892266","created_at":"2026-01-24T10:08:27.000000Z","updated_at":"2026-01-31T10:03:53.000000Z"}]},{"id":10629834,"change_date":"2026-01-12 21:39:00","inspection_id":"86770659","dot_number":"1851983","report_state":"CA","report_number":"NE5Z004760","insp_date":"2026-01-09 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-12 21:39: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":"1","hazmat_oos_total":"0","snet_sequence_id":"16125537","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2026-01-12 21:39:00","snet_input_date":"2026-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-12 21:39:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-15T10:37:07.000000Z","updated_at":"2026-01-23T10:30:55.000000Z","inspection_violations":[{"id":17876952,"change_date":"2026-01-12 21:39:00","inspection_id":"86770659","insp_violation_id":"271152921","seq_no":"1","part_no":"177","part_no_section":"840A1-HMHC","insp_viol_unit":"1","insp_unit_id":"211039075","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-15T10:43:34.000000Z","updated_at":"2026-01-23T10:31:54.000000Z","normalized_code":"177840A1HMHC"}],"inspection_per_units":[{"id":17825746,"change_date":"2026-01-12 21:39:00","inspection_id":"86770659","insp_unit_id":"211039075","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT\/","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"Y","insp_unit_decal_number":"35894130","created_at":"2026-01-15T10:09:26.000000Z","updated_at":"2026-01-24T10:01:23.000000Z"}]},{"id":10185150,"change_date":"2025-11-12 21:42:00","inspection_id":"86305132","dot_number":"1851983","report_state":"CA","report_number":"UEO4000380","insp_date":"2025-11-10 00:00:00","insp_start_time":"0840","insp_end_time":"0854","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","viol_total":"1","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":"16055910","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2025-11-12 21:42:00","snet_input_date":"2025-11-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-12 21:42:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-11-15T10:30:56.000000Z","updated_at":"2025-11-16T10:31:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16963591,"change_date":"2025-11-12 21:42:00","inspection_id":"86305132","insp_unit_id":"209992915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2AX\/WHT","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"Y","insp_unit_decal_number":"35620676","created_at":"2025-11-15T10:00:47.000000Z","updated_at":"2025-11-16T10:02:12.000000Z"}]},{"id":8385786,"change_date":"2025-04-15 21:41:00","inspection_id":"84409836","dot_number":"1851983","report_state":"CA","report_number":"NDLY009045","insp_date":"2025-04-14 00:00:00","insp_start_time":"0843","insp_end_time":"0858","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APCO","shipping_paper_number":"N\/A","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-15 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":"15780966","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-04-18T10:26:49.000000Z","updated_at":"2025-04-19T10:18:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13611021,"change_date":"2025-04-15 21:41:00","inspection_id":"84409836","insp_unit_id":"206331350","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X UTL WHT","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:18:00.000000Z","updated_at":"2025-04-19T10:06:24.000000Z"}]},{"id":8373417,"change_date":"2025-04-14 21:41:00","inspection_id":"84396865","dot_number":"1851983","report_state":"CA","report_number":"NCNY007766","insp_date":"2025-04-10 00:00:00","insp_start_time":"0915","insp_end_time":"1028","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"2025-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"15779309","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2025-04-14 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-04-17T10:05:45.000000Z","updated_at":"2025-04-18T10:24:22.000000Z","inspection_violations":[{"id":13197917,"change_date":"2025-04-14 21:41:00","inspection_id":"84396865","insp_violation_id":"265616818","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"206307977","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:31:38.000000Z","updated_at":"2025-04-18T10:50:05.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":13589389,"change_date":"2025-04-14 21:41:00","inspection_id":"84396865","insp_unit_id":"206307977","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X\/WHT","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T10:00:23.000000Z","updated_at":"2025-04-18T10:06:19.000000Z"}]},{"id":6603919,"change_date":"2024-08-29 21:44:00","inspection_id":"82529433","dot_number":"1851983","report_state":"CA","report_number":"NDLY008253","insp_date":"2024-08-27 00:00:00","insp_start_time":"0833","insp_end_time":"0842","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APCO","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":"2024-08-29 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15501249","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-08-29 21:44:00","snet_input_date":"2024-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-29 21:44:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:34:02.000000Z","updated_at":"2025-03-17T20:34:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10647214,"change_date":"2024-08-29 21:44:00","inspection_id":"82529433","insp_unit_id":"202669963","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT","insp_unit_license":"63233T1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWW36Y75EB55710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:16.000000Z","updated_at":"2025-03-17T23:33:16.000000Z"}]},{"id":6434166,"change_date":"2024-08-09 21:38:00","inspection_id":"82348377","dot_number":"1851983","report_state":"CA","report_number":"NCNY007048","insp_date":"2024-08-08 00:00:00","insp_start_time":"0809","insp_end_time":"0831","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":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"15476978","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9992278,"change_date":"2024-08-09 21:38:00","inspection_id":"82348377","insp_violation_id":"261118377","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"1","insp_unit_id":"202324514","insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":10369778,"change_date":"2024-08-09 21:38:00","inspection_id":"82348377","insp_unit_id":"202324514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"63233T1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWW36Y75EB55710","insp_unit_decal":"Y","insp_unit_decal_number":"34166718","created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"}]},{"id":6145330,"change_date":"2024-07-03 21:40:00","inspection_id":"82038917","dot_number":"1851983","report_state":"CA","report_number":"NC20007086","insp_date":"2024-07-02 00:00:00","insp_start_time":"0809","insp_end_time":"0819","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40: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":"15429375","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:24:35.000000Z","updated_at":"2025-03-17T20:24:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9898952,"change_date":"2024-07-03 21:40:00","inspection_id":"82038917","insp_unit_id":"201732933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X\/WHT","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"Y","insp_unit_decal_number":"34166277","created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":5899919,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","dot_number":"1851983","report_state":"CA","report_number":"NCNK007500","insp_date":"2024-05-31 00:00:00","insp_start_time":"0826","insp_end_time":"0854","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APCO ETTNER INC","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":"2024-06-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15388353","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-06-03 21:43:00","snet_input_date":"2024-05-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-03 21:43:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:19:31.000000Z","updated_at":"2025-03-17T20:19:31.000000Z","inspection_violations":[{"id":9149547,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","insp_violation_id":"259874143","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201206938","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3939A"},{"id":9149548,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","insp_violation_id":"259874144","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201206938","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39395A"},{"id":9149549,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","insp_violation_id":"259874145","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201206938","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3939A"},{"id":9149550,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","insp_violation_id":"259874146","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201206938","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3939A"},{"id":9149551,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","insp_violation_id":"259874147","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"201206938","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9502846,"change_date":"2024-06-03 21:43:00","inspection_id":"81773756","insp_unit_id":"201206938","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT\/08","insp_unit_license":"8R31518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBJC33678F162024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"}]},{"id":5870887,"change_date":"2024-05-29 21:41:00","inspection_id":"81741974","dot_number":"1851983","report_state":"CA","report_number":"NCNY006829","insp_date":"2024-05-28 00:00:00","insp_start_time":"0752","insp_end_time":"0817","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-29 21:41: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":"15382282","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:19:05.000000Z","updated_at":"2025-03-17T20:19:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9455636,"change_date":"2024-05-29 21:41:00","inspection_id":"81741974","insp_unit_id":"201143374","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"44016V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"Y","insp_unit_decal_number":"33820236","created_at":"2025-03-17T23:21:06.000000Z","updated_at":"2025-03-17T23:21:06.000000Z"}]},{"id":5782215,"change_date":"2024-05-17 21:41:00","inspection_id":"81645881","dot_number":"1851983","report_state":"CA","report_number":"UD54000297","insp_date":"2024-05-16 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"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":"2024-05-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","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":"15368125","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-05-17 21:41:00","snet_input_date":"2024-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-17 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:17:27.000000Z","updated_at":"2025-03-17T20:17:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9313108,"change_date":"2024-05-17 21:41:00","inspection_id":"81645881","insp_unit_id":"200961661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"63233T1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWW36Y75EB55710","insp_unit_decal":"Y","insp_unit_decal_number":"33822907","created_at":"2025-03-17T23:19:42.000000Z","updated_at":"2025-03-17T23:19:42.000000Z"}]},{"id":5568485,"change_date":"2024-04-22 21:41:00","inspection_id":"81413704","dot_number":"1851983","report_state":"CA","report_number":"NCNY006738","insp_date":"2024-04-18 00:00:00","insp_start_time":"0814","insp_end_time":"0833","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-22 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":"15329081","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-04-22 21:41:00","snet_input_date":"2024-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-22 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:13:08.000000Z","updated_at":"2025-03-17T20:13:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8969905,"change_date":"2024-04-22 21:41:00","inspection_id":"81413704","insp_unit_id":"200515508","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2X\/WHT","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"Y","insp_unit_decal_number":"33820117","created_at":"2025-03-17T23:16:27.000000Z","updated_at":"2025-03-17T23:16:27.000000Z"}]},{"id":5290310,"change_date":"2024-03-14 21:42:00","inspection_id":"81110018","dot_number":"1851983","report_state":"CA","report_number":"NC20006574","insp_date":"2024-03-13 00:00:00","insp_start_time":"0923","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:42: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":"15280809","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8519457,"change_date":"2024-03-14 21:42:00","inspection_id":"81110018","insp_unit_id":"199923566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"44016V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"Y","insp_unit_decal_number":"33534680","created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":5290389,"change_date":"2024-03-14 21:42:00","inspection_id":"81110100","dot_number":"1851983","report_state":"CA","report_number":"NBH0007599","insp_date":"2024-03-13 00:00:00","insp_start_time":"0819","insp_end_time":"0948","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1","hazmat_oos_total":"1","snet_sequence_id":"15282095","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[{"id":8158843,"change_date":"2024-03-14 21:42:00","inspection_id":"81110100","insp_violation_id":"258395624","seq_no":"1","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"199923696","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"KW79467","created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"177834A"},{"id":8158844,"change_date":"2024-03-14 21:42:00","inspection_id":"81110100","insp_violation_id":"258395625","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":"KW79467","created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8519574,"change_date":"2024-03-14 21:42:00","inspection_id":"81110100","insp_unit_id":"199923696","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT","insp_unit_license":"44016V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":5246995,"change_date":"2024-03-08 21:40:00","inspection_id":"81062798","dot_number":"1851983","report_state":"CA","report_number":"NCNY006585","insp_date":"2024-03-07 00:00:00","insp_start_time":"0910","insp_end_time":"0931","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15273730","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-03-08 21:40:00","snet_input_date":"2024-03-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-08 21:40:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:06:40.000000Z","updated_at":"2025-03-17T20:06:40.000000Z","inspection_violations":[{"id":8091738,"change_date":"2024-03-08 21:40:00","inspection_id":"81062798","insp_violation_id":"258291044","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199829637","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3922"},{"id":8091739,"change_date":"2024-03-08 21:40:00","inspection_id":"81062798","insp_violation_id":"258291045","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199829637","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3922"},{"id":8091740,"change_date":"2024-03-08 21:40:00","inspection_id":"81062798","insp_violation_id":"258291046","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199829637","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3922"},{"id":8091741,"change_date":"2024-03-08 21:40:00","inspection_id":"81062798","insp_violation_id":"258291047","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199829637","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:45:06.000000Z","updated_at":"2025-03-17T21:45:06.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":8449028,"change_date":"2024-03-08 21:40:00","inspection_id":"81062798","insp_unit_id":"199829637","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"48533H3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:33.000000Z","updated_at":"2025-03-17T23:11:33.000000Z"}]},{"id":5094438,"change_date":"2024-02-20 21:43:00","inspection_id":"80896541","dot_number":"1851983","report_state":"CA","report_number":"UD2M002248","insp_date":"2024-02-20 00:00:00","insp_start_time":"0842","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK  REST AREA","county_code_state":"CA","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":"NONE SEEN","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-02-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15243658","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-02-20 21:43:00","snet_input_date":"2024-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-20 21:43:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"324150","created_at":"2025-03-17T20:03:30.000000Z","updated_at":"2025-03-17T20:03:30.000000Z","inspection_violations":[{"id":7855977,"change_date":"2024-02-20 21:43:00","inspection_id":"80896541","insp_violation_id":"257939407","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199512627","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3922"},{"id":7855978,"change_date":"2024-02-20 21:43:00","inspection_id":"80896541","insp_violation_id":"257939408","seq_no":"2","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"LB17176","created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"39111B5"},{"id":7855979,"change_date":"2024-02-20 21:43:00","inspection_id":"80896541","insp_violation_id":"257939409","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199512627","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LB17177","created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8201945,"change_date":"2024-02-20 21:43:00","inspection_id":"80896541","insp_unit_id":"199512627","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"48533H3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:20.000000Z","updated_at":"2025-03-17T23:09:20.000000Z"}]},{"id":4768358,"change_date":"2024-01-04 21:48:00","inspection_id":"80539834","dot_number":"1851983","report_state":"CA","report_number":"NBH0007294","insp_date":"2024-01-02 00:00:00","insp_start_time":"0856","insp_end_time":"1104","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-04 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15188765","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2024-01-04 21:48:00","snet_input_date":"2024-01-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-04 21:48:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"324150","created_at":"2025-03-17T19:57:15.000000Z","updated_at":"2025-03-17T19:57:15.000000Z","inspection_violations":[{"id":7358455,"change_date":"2024-01-04 21:48:00","inspection_id":"80539834","insp_violation_id":"257197354","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198824238","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"3922"},{"id":7358456,"change_date":"2024-01-04 21:48:00","inspection_id":"80539834","insp_violation_id":"257197355","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198824238","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"3939A"},{"id":7358457,"change_date":"2024-01-04 21:48:00","inspection_id":"80539834","insp_violation_id":"257197356","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198824238","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA247840","created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7670986,"change_date":"2024-01-04 21:48:00","inspection_id":"80539834","insp_unit_id":"198824238","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"WHT","insp_unit_license":"63232T1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJC33U37F194909","insp_unit_decal":"Y","insp_unit_decal_number":"33533365","created_at":"2025-03-17T23:04:34.000000Z","updated_at":"2025-03-17T23:04:34.000000Z"}]},{"id":4554082,"change_date":"2023-12-04 21:42:00","inspection_id":"80305425","dot_number":"1851983","report_state":"CA","report_number":"UBVF003446","insp_date":"2023-12-04 00:00:00","insp_start_time":"0750","insp_end_time":"0811","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-04 21:42: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":"15154754","transaction_code":"A","transaction_date":"2023-12-04 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2023-12-04 21:42:00","snet_input_date":"2023-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-04 21:42:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"324150","created_at":"2025-03-17T19:53:01.000000Z","updated_at":"2025-03-17T19:53:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7324615,"change_date":"2023-12-04 21:42:00","inspection_id":"80305425","insp_unit_id":"198341797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT UTIL","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"Y","insp_unit_decal_number":"33226322","created_at":"2025-03-17T23:01:31.000000Z","updated_at":"2025-03-17T23:01:31.000000Z"}]},{"id":2547975,"change_date":"2023-03-09 21:43:00","inspection_id":"78057192","dot_number":"1851983","report_state":"CA","report_number":"UBVF002729","insp_date":"2023-03-09 00:00:00","insp_start_time":"0830","insp_end_time":"0908","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:43: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":"14814227","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2023-03-09 21:43:00","snet_input_date":"2023-03-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-09 21:43:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"324150","created_at":"2025-03-17T19:13:41.000000Z","updated_at":"2025-03-17T19:13:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4101332,"change_date":"2023-03-09 21:43:00","inspection_id":"78057192","insp_unit_id":"193802560","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"WHT UTIL","insp_unit_license":"82132L3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GB4WSEY2NF212840","insp_unit_decal":"Y","insp_unit_decal_number":"32168394","created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":1907294,"change_date":"2022-12-08 21:41:00","inspection_id":"77325678","dot_number":"1851983","report_state":"CA","report_number":"NCNY004808","insp_date":"2022-12-07 00:00:00","insp_start_time":"0750","insp_end_time":"0809","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11500","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":"14700400","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:51.000000Z","updated_at":"2025-03-17T19:01:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3069739,"change_date":"2022-12-08 21:41:00","inspection_id":"77325678","insp_unit_id":"192339626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2X\/WHT","insp_unit_license":"63232T1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GDJC33U37F194909","insp_unit_decal":"Y","insp_unit_decal_number":"31839419","created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"}]},{"id":1619860,"change_date":"2022-10-27 21:42:00","inspection_id":"76996640","dot_number":"1851983","report_state":"CA","report_number":"UBFW000761","insp_date":"2022-10-27 00:00:00","insp_start_time":"1020","insp_end_time":"1104","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":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-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"27025","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14653294","transaction_code":"A","transaction_date":"2022-10-27 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2022-10-27 21:42:00","snet_input_date":"2022-10-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-27 21:42:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"324150","created_at":"2025-03-17T18:56:21.000000Z","updated_at":"2025-03-17T18:56:21.000000Z","inspection_violations":[{"id":2544276,"change_date":"2022-10-27 21:42:00","inspection_id":"76996640","insp_violation_id":"249300354","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"7H8P0007J","created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"38323A2"},{"id":2544277,"change_date":"2022-10-27 21:42:00","inspection_id":"76996640","insp_violation_id":"249300355","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191685869","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"7H8P0007J","created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3922"},{"id":2544278,"change_date":"2022-10-27 21:42:00","inspection_id":"76996640","insp_violation_id":"249300356","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191685869","insp_violation_category_id":"30","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":"3922"}],"inspection_per_units":[{"id":2606320,"change_date":"2022-10-27 21:42:00","inspection_id":"76996640","insp_unit_id":"191685869","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"DUALLY","insp_unit_license":"04848H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GC4K0EY1HF209492","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":2606321,"change_date":"2022-10-27 21:42:00","inspection_id":"76996640","insp_unit_id":"191685870","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"CBTRL","insp_unit_company":"UTIL","insp_unit_license":"4TX4444","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4JUBD12277N025629","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":1619132,"change_date":"2022-10-27 21:42:00","inspection_id":"76995830","dot_number":"1851983","report_state":"CA","report_number":"UEBY001382","insp_date":"2022-10-26 00:00:00","insp_start_time":"0745","insp_end_time":"0823","registration_date":null,"region":"PT","ci_status_code":"C","location":"9410","location_desc":"FRESNO, CA","county_code_state":"CA","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-10-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"11400","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":"14651071","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":"01851983","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":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"324150","created_at":"2025-03-17T18:56:21.000000Z","updated_at":"2025-03-17T18:56:21.000000Z","inspection_violations":[{"id":2543461,"change_date":"2022-10-27 21:42:00","inspection_id":"76995830","insp_violation_id":"249299326","seq_no":"1","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"1","insp_unit_id":"191684618","insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LV13946","created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"39216B"},{"id":2543462,"change_date":"2022-10-27 21:42:00","inspection_id":"76995830","insp_violation_id":"249299327","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191684618","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LV13948","created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2605232,"change_date":"2022-10-27 21:42:00","inspection_id":"76995830","insp_unit_id":"191684618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"8R31518","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GBJC33678F162024","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":1104891,"change_date":"2022-08-22 21:43:00","inspection_id":"76400048","dot_number":"1851983","report_state":"CA","report_number":"N8OL005760","insp_date":"2022-08-19 00:00:00","insp_start_time":"0836","insp_end_time":"0853","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APCO ETTNER","shipping_paper_number":"0","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 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":"14559409","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01851983","upload_search_indicator":null,"census_search_date":"2022-08-22 21:43:00","snet_input_date":"2022-08-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"APCO ETTNER INC","insp_carrier_street":"5588  NORTH  PALM AVENUE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93704","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"324150","created_at":"2025-03-17T18:47:13.000000Z","updated_at":"2025-03-17T18:47:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1777559,"change_date":"2022-08-22 21:43:00","inspection_id":"76400048","insp_unit_id":"190471739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT UTIL TR","insp_unit_license":"48533H3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT8CEA66472","insp_unit_decal":"Y","insp_unit_decal_number":"31490137","created_at":"2025-03-17T22:19:14.000000Z","updated_at":"2025-03-17T22:19:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1851983\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1851983\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1851983\/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\/1851983\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}