{"current_page":1,"data":[{"id":12482593,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","dot_number":"4345143","report_state":"CA","report_number":"NEZF004617","insp_date":"2026-07-16 00:00:00","insp_start_time":"0854","insp_end_time":"1002","registration_date":null,"region":"PD","ci_status_code":"C","location":"147","location_desc":"CA","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BELLEVUE ICE CREAM PLANT","shipping_paper_number":"123456000552733","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":"U","pen_cen_match":"I","final_status_date":"2026-07-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3780104","transaction_code":"A","transaction_date":"2026-07-17 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2026-07-17 21:43:00","snet_input_date":"2026-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:43:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-20T09:42:51.000000Z","updated_at":"2026-07-28T09:31:35.000000Z","inspection_violations":[{"id":21730819,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_violation_id":"275579646","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"214678036","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:44.000000Z","updated_at":"2026-07-28T09:44:00.000000Z","normalized_code":"39345DB"},{"id":21730820,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_violation_id":"275579647","seq_no":"4","part_no":"393","part_no_section":"207F-SLAS","insp_viol_unit":"1","insp_unit_id":"214678036","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RC54645","created_at":"2026-07-20T10:08:44.000000Z","updated_at":"2026-07-28T09:44:00.000000Z","normalized_code":"393207FSLAS"},{"id":21730821,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_violation_id":"275579648","seq_no":"5","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:44.000000Z","updated_at":"2026-07-28T09:44:00.000000Z","normalized_code":"3958A1HOSP"},{"id":21730822,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_violation_id":"275579649","seq_no":"6","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:44.000000Z","updated_at":"2026-07-28T09:44:00.000000Z","normalized_code":"39524DELDPT"},{"id":21730823,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_violation_id":"275579650","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"214678036","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:44.000000Z","updated_at":"2026-07-28T09:44:00.000000Z","normalized_code":"3963A1BALAC"},{"id":21730824,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_violation_id":"275579651","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"214678036","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA710300","created_at":"2026-07-20T10:08:44.000000Z","updated_at":"2026-07-28T09:44:00.000000Z","normalized_code":"3963A1BALR"}],"inspection_per_units":[{"id":21679918,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_unit_id":"214678036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5575\/WHT","insp_unit_license":"ZP92799","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:27.000000Z","updated_at":"2026-07-28T09:03:14.000000Z"},{"id":21679919,"change_date":"2026-07-17 21:43:00","inspection_id":"88444152","insp_unit_id":"214678037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"54131\/WHT","insp_unit_license":"4TH8292","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539M2208162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:27.000000Z","updated_at":"2026-07-28T09:03:14.000000Z"}]},{"id":12480865,"change_date":"2026-07-17 21:42:00","inspection_id":"88442324","dot_number":"4345143","report_state":"CA","report_number":"N9PH007558","insp_date":"2026-07-16 00:00:00","insp_start_time":"1605","insp_end_time":"1623","registration_date":null,"region":"PD","ci_status_code":"C","location":"147","location_desc":"CA","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BELLEVUE ICE CREAM PLANT","shipping_paper_number":"123456000552733","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":"U","pen_cen_match":"I","final_status_date":"2026-07-17 21:42: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":"3780142","transaction_code":"A","transaction_date":"2026-07-17 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2026-07-17 21:42:00","snet_input_date":"2026-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:42:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-20T09:42:47.000000Z","updated_at":"2026-07-28T09:31:17.000000Z","inspection_violations":[{"id":21728068,"change_date":"2026-07-17 21:42:00","inspection_id":"88442324","insp_violation_id":"275575127","seq_no":"1","part_no":"393","part_no_section":"207F-SLAS","insp_viol_unit":"1","insp_unit_id":"214674281","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:26.000000Z","updated_at":"2026-07-28T09:43:23.000000Z","normalized_code":"393207FSLAS"}],"inspection_per_units":[{"id":21677034,"change_date":"2026-07-17 21:42:00","inspection_id":"88442324","insp_unit_id":"214674281","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5575\/WHT","insp_unit_license":"ZP92799","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:20.000000Z","updated_at":"2026-07-28T09:02:50.000000Z"},{"id":21677035,"change_date":"2026-07-17 21:42:00","inspection_id":"88442324","insp_unit_id":"214674282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"54131\/WHT","insp_unit_license":"4TH8292","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2539M2208162","insp_unit_decal":"Y","insp_unit_decal_number":"36509439","created_at":"2026-07-20T09:21:20.000000Z","updated_at":"2026-07-28T09:02:50.000000Z"}]},{"id":12225366,"change_date":"2026-06-18 21:42:00","inspection_id":"88183335","dot_number":"4345143","report_state":"CA","report_number":"NDCH001991","insp_date":"2026-06-15 00:00:00","insp_start_time":"0729","insp_end_time":"0829","registration_date":null,"region":"PS","ci_status_code":"C","location":"265","location_desc":"CA","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","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":"3574153","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"654608","created_at":"2026-06-21T09:43:42.000000Z","updated_at":"2026-06-29T09:31:21.000000Z","inspection_violations":[{"id":21277792,"change_date":"2026-06-18 21:42:00","inspection_id":"88183335","insp_violation_id":"274999005","seq_no":"1","part_no":"393","part_no_section":"209E-SPSRLF","insp_viol_unit":"1","insp_unit_id":"214177731","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:13.000000Z","updated_at":"2026-06-29T09:43:21.000000Z","normalized_code":"393209ESPSRLF"},{"id":21277793,"change_date":"2026-06-18 21:42:00","inspection_id":"88183335","insp_violation_id":"274999006","seq_no":"2","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"214177731","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:13.000000Z","updated_at":"2026-06-29T09:43:21.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":21231427,"change_date":"2026-06-18 21:42:00","inspection_id":"88183335","insp_unit_id":"214177731","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLK","insp_unit_company":"5575","insp_unit_license":"ZP92799","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:34.000000Z","updated_at":"2026-06-29T09:02:23.000000Z"}]},{"id":10881580,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","dot_number":"4345143","report_state":"OR","report_number":"AW40800261","insp_date":"2026-01-28 00:00:00","insp_start_time":"1704","insp_end_time":"1829","registration_date":null,"region":"PS","ci_status_code":"C","location":"18-07","location_desc":"KLAMATH FALLS OR","county_code_state":"OR","county_code":"035","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TYSON FRESH MEATS","shipping_paper_number":"OR14016","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2823968","transaction_code":"C","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2026-01-29 21:38:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-29 21:38:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:55.000000Z","updated_at":"2026-02-20T10:30:06.000000Z","inspection_violations":[{"id":18543696,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","insp_violation_id":"271671733","seq_no":"1","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"211510128","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:09.000000Z","updated_at":"2026-02-20T10:38:02.000000Z","normalized_code":"3963A1OAL"},{"id":18543697,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","insp_violation_id":"271671734","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211510128","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:09.000000Z","updated_at":"2026-02-20T10:38:02.000000Z","normalized_code":"39378AWS"},{"id":18543698,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","insp_violation_id":"271671735","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:09.000000Z","updated_at":"2026-02-20T10:38:03.000000Z","normalized_code":"3958A1HOSP"},{"id":18543699,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","insp_violation_id":"271671736","seq_no":"4","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-12T10:50:09.000000Z","updated_at":"2026-02-20T10:38:03.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":18888848,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","insp_unit_id":"211510128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"557\/WHT","insp_unit_license":"ZP46547","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:30.000000Z","updated_at":"2026-02-20T10:02:45.000000Z"},{"id":18888849,"change_date":"2026-02-09 21:38:00","inspection_id":"86912071","insp_unit_id":"211510129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"TL54176","insp_unit_license":"4WV9282","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2533N2685817","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:30.000000Z","updated_at":"2026-02-20T10:02:45.000000Z"}]},{"id":10462813,"change_date":"2025-12-17 21:39:00","inspection_id":"86595789","dot_number":"4345143","report_state":"CA","report_number":"NFAC001783","insp_date":"2025-12-13 00:00:00","insp_start_time":"0748","insp_end_time":"0807","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CPC INTERNATIONAL","shipping_paper_number":"866565-0","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-17 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":"16099959","transaction_code":"A","transaction_date":"2025-12-13 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-12-17 21:39:00","snet_input_date":"2025-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:48.000000Z","updated_at":"2025-12-28T10:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17510126,"change_date":"2025-12-17 21:39:00","inspection_id":"86595789","insp_unit_id":"210671967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"557\/WHT","insp_unit_license":"ZP46547","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:52.000000Z","updated_at":"2025-12-28T10:01:15.000000Z"},{"id":17510127,"change_date":"2025-12-17 21:39:00","inspection_id":"86595789","insp_unit_id":"210671968","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"54143\/WHT","insp_unit_license":"4TL7276","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534M2422623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:52.000000Z","updated_at":"2025-12-28T10:01:15.000000Z"}]},{"id":10166960,"change_date":"2025-11-10 21:40:00","inspection_id":"86286026","dot_number":"4345143","report_state":"CA","report_number":"NETE003082","insp_date":"2025-11-02 00:00:00","insp_start_time":"1346","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TYSON FOODS","shipping_paper_number":"032L31006","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16053335","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-11-10 21:40:00","snet_input_date":"2025-11-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-10 21:40:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:46.000000Z","updated_at":"2025-11-14T10:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16929178,"change_date":"2025-11-10 21:40:00","inspection_id":"86286026","insp_unit_id":"209951328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHT\/05","insp_unit_license":"ZP46546","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2JN891966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:45.000000Z","updated_at":"2025-11-14T10:01:22.000000Z"},{"id":16929179,"change_date":"2025-11-10 21:40:00","inspection_id":"86286026","insp_unit_id":"209951329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/54143","insp_unit_license":"4TL7276","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534M2422623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:45.000000Z","updated_at":"2025-11-14T10:01:22.000000Z"}]},{"id":10059981,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","dot_number":"4345143","report_state":"CA","report_number":"UDQ3002282","insp_date":"2025-10-28 00:00:00","insp_start_time":"0942","insp_end_time":"1029","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"NEWMAN","county_code_state":"CA","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ORGANICGIRL","shipping_paper_number":"S0649412","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"20","oos_total":"0","driver_viol_total":"14","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16036280","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-10-28 21:40:00","snet_input_date":"2025-10-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-28 21:40:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"654608","created_at":"2025-11-01T10:02:08.000000Z","updated_at":"2025-11-01T10:02:08.000000Z","inspection_violations":[{"id":16655090,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577460","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00NF0004X","created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3922SLLS3"},{"id":16655091,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577461","seq_no":"2","part_no":"395","part_no_section":"8D2-HOSF","insp_viol_unit":"1","insp_unit_id":"209704708","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D2HOSF"},{"id":16655092,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577462","seq_no":"3","part_no":"395","part_no_section":"8D2-HOSF","insp_viol_unit":"1","insp_unit_id":"209704708","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D2HOSF"},{"id":16655093,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577463","seq_no":"4","part_no":"395","part_no_section":"8D2-HOSF","insp_viol_unit":"1","insp_unit_id":"209704708","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D2HOSF"},{"id":16655094,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577464","seq_no":"5","part_no":"395","part_no_section":"8D2-HOSF","insp_viol_unit":"1","insp_unit_id":"209704708","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D2HOSF"},{"id":16655095,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577465","seq_no":"6","part_no":"395","part_no_section":"8D2-HOSF","insp_viol_unit":"1","insp_unit_id":"209704708","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D2HOSF"},{"id":16655096,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577466","seq_no":"7","part_no":"395","part_no_section":"8D2-HOSF","insp_viol_unit":"1","insp_unit_id":"209704708","insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D2HOSF"},{"id":16655097,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577467","seq_no":"8","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":16655098,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577468","seq_no":"9","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":16655099,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577469","seq_no":"10","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":16655100,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577470","seq_no":"11","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":16655101,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577471","seq_no":"12","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":16655102,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577472","seq_no":"13","part_no":"395","part_no_section":"30B2-ELDDFC24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"39530B2ELDDFC24"},{"id":16655103,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577473","seq_no":"14","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"},{"id":16655104,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577474","seq_no":"15","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"},{"id":16655105,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577475","seq_no":"16","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:17.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"},{"id":16655106,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577476","seq_no":"17","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:18.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"},{"id":16655107,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577477","seq_no":"18","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:18.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"},{"id":16655108,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577478","seq_no":"19","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:18.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"},{"id":16655109,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_violation_id":"269577479","seq_no":"20","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:18.000000Z","updated_at":"2025-11-01T10:17:31.000000Z","normalized_code":"3958D11HOSF"}],"inspection_per_units":[{"id":16719085,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_unit_id":"209704709","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5462","insp_unit_license":"4NM1620","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536FU182868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:18.000000Z","updated_at":"2025-11-01T09:46:53.000000Z"},{"id":16719084,"change_date":"2025-10-28 21:40:00","inspection_id":"86173283","insp_unit_id":"209704708","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5575","insp_unit_license":"ZP46547","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:18.000000Z","updated_at":"2025-11-01T09:46:53.000000Z"}]},{"id":9525411,"change_date":"2025-08-27 21:40:00","inspection_id":"85611325","dot_number":"4345143","report_state":"CA","report_number":"NFAC001238","insp_date":"2025-08-23 00:00:00","insp_start_time":"0743","insp_end_time":"0809","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TYSON","shipping_paper_number":"32J21037","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-08-27 21:40: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":"15956011","transaction_code":"A","transaction_date":"2025-08-23 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-08-27 21:40:00","snet_input_date":"2025-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-27 21:40:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:26.000000Z","updated_at":"2025-09-06T10:41:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15720597,"change_date":"2025-08-27 21:40:00","inspection_id":"85611325","insp_unit_id":"208620239","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5575\/WHT","insp_unit_license":"ZP46547","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EHXJN995475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:42.000000Z","updated_at":"2025-09-09T09:46:18.000000Z"},{"id":15720598,"change_date":"2025-08-27 21:40:00","inspection_id":"85611325","insp_unit_id":"208620240","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5481\/WHT","insp_unit_license":"4WS6888","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2531GU580832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:42.000000Z","updated_at":"2025-09-09T09:46:18.000000Z"}]},{"id":8903574,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","dot_number":"4345143","report_state":"WA","report_number":"2130001314","insp_date":"2025-06-10 00:00:00","insp_start_time":"1415","insp_end_time":"1550","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC55","location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-15 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"16","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":"1865902","transaction_code":"A","transaction_date":"2025-06-14 00:00:00","upload_date":"2025-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-06-15 21:32:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-15 21:32:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-18T10:00:16.000000Z","updated_at":"2025-06-19T10:00:05.000000Z","inspection_violations":[{"id":14274061,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851925","seq_no":"3","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"207394492","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39311A1CSLRR"},{"id":14274062,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851926","seq_no":"4","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"207394493","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39355EB"},{"id":14274063,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851927","seq_no":"5","part_no":"392","part_no_section":"71B-MC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39271BMC"},{"id":14274064,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851928","seq_no":"6","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207394492","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39378AWS"},{"id":14274065,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851929","seq_no":"7","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39530B1ELDDFR"},{"id":14274066,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851930","seq_no":"8","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39530B1ELDDFR"},{"id":14274067,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851931","seq_no":"9","part_no":"392","part_no_section":"71A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5A0551891","created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39271AD"},{"id":14274068,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851932","seq_no":"10","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39530B1ELDDFR"},{"id":14274069,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851933","seq_no":"11","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39524"},{"id":14274070,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851934","seq_no":"12","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"3958EHOSPD"},{"id":14274071,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851935","seq_no":"13","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39530B1ELDDFR"},{"id":14274072,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851936","seq_no":"14","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"3958EHOSPD"},{"id":14274073,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851937","seq_no":"15","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"3958EHOSPD"},{"id":14274074,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851938","seq_no":"16","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"3958EHOSPD"},{"id":14274075,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851939","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207394492","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39395A4EEUS"},{"id":14274076,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_violation_id":"266851940","seq_no":"2","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-18T10:15:28.000000Z","updated_at":"2025-06-19T10:15:03.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":14586696,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_unit_id":"207394492","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"ZP46546","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2JN891966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-18T09:45:22.000000Z","updated_at":"2025-06-19T09:45:03.000000Z"},{"id":14586697,"change_date":"2025-06-15 21:32:00","inspection_id":"84956601","insp_unit_id":"207394493","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"5472","insp_unit_license":"4NY3661","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2533GU505016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-18T09:45:22.000000Z","updated_at":"2025-06-19T09:45:03.000000Z"}]},{"id":8783413,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","dot_number":"4345143","report_state":"CA","report_number":"NEZF002207","insp_date":"2025-05-27 00:00:00","insp_start_time":"1247","insp_end_time":"1340","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15842210","transaction_code":"A","transaction_date":"2025-05-27 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-05-30 21:41:00","snet_input_date":"2025-05-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-30 21:41:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:12.000000Z","updated_at":"2025-06-04T10:01:12.000000Z","inspection_violations":[{"id":14041927,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_violation_id":"266586659","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"207159019","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:29.000000Z","updated_at":"2025-06-03T10:18:07.000000Z","normalized_code":"3939ALFTSI"},{"id":14041928,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_violation_id":"266586660","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207159019","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:29.000000Z","updated_at":"2025-06-03T10:18:07.000000Z","normalized_code":"39360C"},{"id":14041929,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_violation_id":"266586661","seq_no":"3","part_no":"395","part_no_section":"8D5-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:29.000000Z","updated_at":"2025-06-03T10:18:07.000000Z","normalized_code":"3958D5HOSF"},{"id":14041930,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_violation_id":"266586662","seq_no":"4","part_no":"393","part_no_section":"207B-AALPME","insp_viol_unit":"2","insp_unit_id":"207159020","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:29.000000Z","updated_at":"2025-06-03T10:18:07.000000Z","normalized_code":"393207BAALPME"},{"id":14041931,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_violation_id":"266586663","seq_no":"5","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"RC53056","created_at":"2025-06-02T10:17:29.000000Z","updated_at":"2025-06-03T10:18:07.000000Z","normalized_code":"3958A1HOSP"},{"id":14041932,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_violation_id":"266586664","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:29.000000Z","updated_at":"2025-06-03T10:18:07.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":14371053,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_unit_id":"207159019","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"05\/WHT","insp_unit_license":"ZP46546","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2JN891966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:26.000000Z","updated_at":"2025-06-03T09:46:17.000000Z"},{"id":14371054,"change_date":"2025-05-30 21:41:00","inspection_id":"84829086","insp_unit_id":"207159020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"54100\/WHT","insp_unit_license":"4RR6246","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537J2140813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:26.000000Z","updated_at":"2025-06-03T09:46:17.000000Z"}]},{"id":8748180,"change_date":"2025-05-27 21:39:00","inspection_id":"84791811","dot_number":"4345143","report_state":"CA","report_number":"UD34001081","insp_date":"2025-05-26 00:00:00","insp_start_time":"1140","insp_end_time":"1210","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WINCO","shipping_paper_number":"25-012429","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15836218","transaction_code":"A","transaction_date":"2025-05-26 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04345143","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"AERO FREIGHT INC","insp_carrier_street":"4770 WEST LN UNIT 2202","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95210","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:38.000000Z","updated_at":"2025-05-31T10:01:10.000000Z","inspection_violations":[{"id":13965158,"change_date":"2025-05-27 21:39:00","inspection_id":"84791811","insp_violation_id":"266499080","seq_no":"1","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":"RC33599","created_at":"2025-05-30T10:15:59.000000Z","updated_at":"2025-05-31T10:18:07.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":14304508,"change_date":"2025-05-27 21:39:00","inspection_id":"84791811","insp_unit_id":"207086894","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"05\/WHI","insp_unit_license":"ZP46546","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2JN891966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:39.000000Z","updated_at":"2025-05-31T09:47:44.000000Z"},{"id":14304509,"change_date":"2025-05-27 21:39:00","inspection_id":"84791811","insp_unit_id":"207086895","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"54100\/WHI","insp_unit_license":"4RR6246","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537J2140813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:39.000000Z","updated_at":"2025-05-31T09:47:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4345143\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4345143\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4345143\/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\/4345143\/inspections","per_page":100,"prev_page_url":null,"to":11,"total":11}