{"current_page":1,"data":[{"id":12694216,"change_date":"2026-08-11 21:41:00","inspection_id":"88668454","dot_number":"287351","report_state":"PA","report_number":"B328622333","insp_date":"2026-08-11 00:00:00","insp_start_time":"1515","insp_end_time":"1545","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"107980","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":"3959273","transaction_code":"A","transaction_date":"2026-08-11 00:00:00","upload_date":"2026-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-08-11 21:41:00","snet_input_date":"2026-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-11 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-08-14T09:40:47.000000Z","updated_at":"2026-08-22T09:33:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22112424,"change_date":"2026-08-11 21:41:00","inspection_id":"88668454","insp_unit_id":"215096371","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3283569","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV9JLJN7590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-19T09:06:21.000000Z","updated_at":"2026-08-22T09:02:44.000000Z"},{"id":22112425,"change_date":"2026-08-11 21:41:00","inspection_id":"88668454","insp_unit_id":"215096372","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PF55427","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K5SJ265088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-19T09:06:21.000000Z","updated_at":"2026-08-22T09:02:44.000000Z"}]},{"id":12694268,"change_date":"2026-08-12 21:42:00","inspection_id":"88668506","dot_number":"287351","report_state":"PA","report_number":"D319622310","insp_date":"2026-08-11 00:00:00","insp_start_time":"1231","insp_end_time":"1319","registration_date":"2026-08-12 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"CRANBERRY TWP PA","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"3959304","transaction_code":"C","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-08-11 21:41:00","snet_input_date":"2026-08-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-11 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-08-14T09:40:47.000000Z","updated_at":"2026-08-23T09:30:09.000000Z","inspection_violations":[{"id":22167721,"change_date":"2026-08-12 21:42:00","inspection_id":"88668506","insp_violation_id":"276067065","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"215102078","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-19T09:47:55.000000Z","updated_at":"2026-08-23T09:39:39.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":22112444,"change_date":"2026-08-12 21:42:00","inspection_id":"88668506","insp_unit_id":"215102078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"138011","insp_unit_license":"2778995","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY0KM001246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-19T09:06:59.000000Z","updated_at":"2026-08-23T09:01:10.000000Z"},{"id":22112445,"change_date":"2026-08-12 21:42:00","inspection_id":"88668506","insp_unit_id":"215102079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"257223","insp_unit_license":"PG74036","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"2H3V382K3SJ518442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-19T09:06:59.000000Z","updated_at":"2026-08-23T09:01:10.000000Z"}]},{"id":12459003,"change_date":"2026-07-15 21:42:00","inspection_id":"88419486","dot_number":"287351","report_state":"PA","report_number":"C712619619","insp_date":"2026-07-15 00:00:00","insp_start_time":"1130","insp_end_time":"1150","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TIONESTA TOWNSHIP PA","county_code_state":"PA","county_code":"053","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"3761813","transaction_code":"A","transaction_date":"2026-07-15 00:00:00","upload_date":"2026-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-07-15 21:42:00","snet_input_date":"2026-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-15 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-07-18T09:40:58.000000Z","updated_at":"2026-07-26T09:31:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22087707,"change_date":null,"inspection_id":"88419486","insp_unit_id":"sms-backfill-795775374-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2240699","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV5SSWC5450","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-08-17T03:29:46.000000Z","updated_at":"2026-08-17T03:29:46.000000Z"},{"id":22089582,"change_date":null,"inspection_id":"88419486","insp_unit_id":"sms-backfill-795775374-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"P962481","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162810H5000331","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-08-17T03:29:46.000000Z","updated_at":"2026-08-17T03:29:46.000000Z"}]},{"id":12230608,"change_date":"2026-06-19 21:38:00","inspection_id":"88188045","dot_number":"287351","report_state":"NY","report_number":"SPA3051640","insp_date":"2026-06-12 00:00:00","insp_start_time":"0959","insp_end_time":"1004","registration_date":null,"region":"ED","ci_status_code":"C","location":"50263M","location_desc":"BEMUS POINT NY","county_code_state":"NY","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"LENA,S PIZZA","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-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","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":"3577659","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-22T09:41:18.000000Z","updated_at":"2026-06-30T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21524442,"change_date":null,"inspection_id":"88188045","insp_unit_id":"sms-backfill-793692405-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2240700","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3FLGN3902","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21531817,"change_date":null,"inspection_id":"88188045","insp_unit_id":"sms-backfill-793692405-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"PH37764","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A5618MB304370","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12101592,"change_date":"2026-06-04 21:46:00","inspection_id":"88046105","dot_number":"287351","report_state":"PA","report_number":"E948615585","insp_date":"2026-06-04 00:00:00","insp_start_time":"1338","insp_end_time":"1410","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HARRISON TOWNSHIP PA","county_code_state":"PA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","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-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"3470782","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-06-07T09:40:59.000000Z","updated_at":"2026-06-16T09:32:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21527447,"change_date":null,"inspection_id":"88046105","insp_unit_id":"sms-backfill-792414945-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":null,"insp_unit_license":"3283545","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003393","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21531007,"change_date":null,"inspection_id":"88046105","insp_unit_id":"sms-backfill-792414945-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P812533","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA5617FB709140","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11959848,"change_date":"2026-05-19 21:40:00","inspection_id":"87895927","dot_number":"287351","report_state":"PA","report_number":"1009613991","insp_date":"2026-05-19 00:00:00","insp_start_time":"0433","insp_end_time":"0500","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FALLOWFIELD TOWNSHIP PA","county_code_state":"PA","county_code":"125","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":"0636921","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-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"3359142","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-05-22T09:41:08.000000Z","updated_at":"2026-05-30T09:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528911,"change_date":null,"inspection_id":"87895927","insp_unit_id":"sms-backfill-791063343-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3627003","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV5RSVH5434","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21532428,"change_date":null,"inspection_id":"87895927","insp_unit_id":"sms-backfill-791063343-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PF55428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K7SJ265089","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11895973,"change_date":"2026-05-13 21:42:00","inspection_id":"87834434","dot_number":"287351","report_state":"PA","report_number":"1010613341","insp_date":"2026-05-13 00:00:00","insp_start_time":"0441","insp_end_time":"0537","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FALLOWFIELD TOWNSHIP PA","county_code_state":"PA","county_code":"125","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"0636434","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-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"3313352","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-05-15T12:26:53.000000Z","updated_at":"2026-05-24T09:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21338588,"change_date":null,"inspection_id":"87834434","insp_unit_id":"sms-backfill-790509906-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3627003","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV5RSVH5434","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"},{"id":21343054,"change_date":null,"inspection_id":"87834434","insp_unit_id":"sms-backfill-790509906-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"PF55428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K7SJ265089","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11884129,"change_date":"2026-07-28 21:41:00","inspection_id":"87821917","dot_number":"287351","report_state":"PA","report_number":"D105613209","insp_date":"2026-05-12 00:00:00","insp_start_time":"0540","insp_end_time":"0635","registration_date":"2026-07-28 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"CRANBERRY TWP PA","county_code_state":"PA","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"0636379","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-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3305329","transaction_code":"C","transaction_date":"2026-07-28 00:00:00","upload_date":"2026-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-05-14T12:39:27.000000Z","updated_at":"2026-08-08T09:30:13.000000Z","inspection_violations":[{"id":21387963,"change_date":null,"inspection_id":"87821917","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"39141AMCPVI"},{"id":21387964,"change_date":null,"inspection_id":"87821917","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":21338486,"change_date":null,"inspection_id":"87821917","insp_unit_id":"sms-backfill-790397253-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3481269","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV4GLHB3313","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"},{"id":21342938,"change_date":null,"inspection_id":"87821917","insp_unit_id":"sms-backfill-790397253-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"PG88629","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163826G5000542","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11892664,"change_date":"2026-05-13 21:41:00","inspection_id":"87830925","dot_number":"287351","report_state":"PA","report_number":"A403613234","insp_date":"2026-05-12 00:00:00","insp_start_time":"1452","insp_end_time":"1607","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SALEM TOWNSHIP PA","county_code_state":"PA","county_code":"129","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3310623","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-05-15T12:26:48.000000Z","updated_at":"2026-05-24T09:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21338537,"change_date":null,"inspection_id":"87830925","insp_unit_id":"sms-backfill-790478325-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3786605","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD1PDUC4555","insp_unit_decal":null,"insp_unit_decal_number":"36365471","created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11662339,"change_date":"2026-04-16 21:40:00","inspection_id":"87592489","dot_number":"287351","report_state":"PA","report_number":"T903610636","insp_date":"2026-04-16 00:00:00","insp_start_time":"1042","insp_end_time":"1100","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEW STANTON BORO PA","county_code_state":"PA","county_code":"129","insp_level_id":"3","service_center":"EA","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":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15740","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":"3167439","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-04-27T09:31:03.000000Z","updated_at":"2026-04-27T09:31:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20724224,"change_date":null,"inspection_id":"87592489","insp_unit_id":"sms-backfill-788332401-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":null,"insp_unit_license":"2778994","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY0KM001232","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11650228,"change_date":"2026-04-15 21:38:00","inspection_id":"87579789","dot_number":"287351","report_state":"PA","report_number":"B304610438","insp_date":"2026-04-14 00:00:00","insp_start_time":"1630","insp_end_time":"1710","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"COLLIER TOWNSHIP PA","county_code_state":"PA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"123280","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":"3159128","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-04-26T09:30:17.000000Z","updated_at":"2026-04-26T09:30:17.000000Z","inspection_violations":[{"id":20732274,"change_date":null,"inspection_id":"87579789","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20723432,"change_date":null,"inspection_id":"87579789","insp_unit_id":"sms-backfill-788218101-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3627014","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV6RDVH5460","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"},{"id":20729233,"change_date":null,"inspection_id":"87579789","insp_unit_id":"sms-backfill-788218101-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"PG74499","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162811L5000654","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11650199,"change_date":"2026-04-15 21:38:00","inspection_id":"87579757","dot_number":"287351","report_state":"PA","report_number":"D128610421","insp_date":"2026-04-14 00:00:00","insp_start_time":"1310","insp_end_time":"1355","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CRANBERRY TWP PA","county_code_state":"PA","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3159149","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"PA","created_at":"2026-04-26T09:30:17.000000Z","updated_at":"2026-04-26T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20726601,"change_date":null,"inspection_id":"87579757","insp_unit_id":"sms-backfill-788217813-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3786605","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD1PDUC4555","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11569860,"change_date":"2026-04-05 21:33:00","inspection_id":"87493658","dot_number":"287351","report_state":"MD","report_number":"0313C00777","insp_date":"2026-04-03 00:00:00","insp_start_time":"0848","insp_end_time":"0907","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FRIENDSVILLE MD","county_code_state":"MD","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"399944965","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-04-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"3115117","transaction_code":"A","transaction_date":"2026-04-04 00:00:00","upload_date":"2026-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-04-05 21:33:00","snet_input_date":"2026-04-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-05 21:33:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-08T09:50:25.000000Z","updated_at":"2026-04-16T09:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20726015,"change_date":null,"inspection_id":"87493658","insp_unit_id":"sms-backfill-787442922-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283742","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY9PM003400","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"},{"id":20728953,"change_date":null,"inspection_id":"87493658","insp_unit_id":"sms-backfill-787442922-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"P426891","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162816G5000588","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11502526,"change_date":"2026-06-29 21:42:00","inspection_id":"87422679","dot_number":"287351","report_state":"PA","report_number":"XL00094838","insp_date":"2026-03-21 00:00:00","insp_start_time":"1305","insp_end_time":"1355","registration_date":"2026-06-29 00:00:00","region":"ED","ci_status_code":"C","location":"999","location_desc":"PA","county_code_state":"PA","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"REY AZTECA INC.","shipping_paper_number":"399930858","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":"U","pen_cen_match":"I","final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3647991","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"SYSCO LEASING LLC","insp_carrier_street":"4000 W 62ND ST","insp_carrier_city":"INDIANAPOLIS","insp_carrier_state":"IN","insp_carrier_zip_code":"46268","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:47.000000Z","updated_at":"2026-07-10T09:30:04.000000Z","inspection_violations":[{"id":20730718,"change_date":null,"inspection_id":"87422679","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39347E"},{"id":20730719,"change_date":null,"inspection_id":"87422679","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39395A1"},{"id":20730720,"change_date":null,"inspection_id":"87422679","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":20725048,"change_date":null,"inspection_id":"87422679","insp_unit_id":"sms-backfill-786804111-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2987227","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV8ELFU2311","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"},{"id":20727894,"change_date":null,"inspection_id":"87422679","insp_unit_id":"sms-backfill-786804111-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PG88629","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163826G5000542","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11150587,"change_date":"2026-02-24 21:39:00","inspection_id":"87065188","dot_number":"287351","report_state":"PA","report_number":"G201604826","insp_date":"2026-02-17 00:00:00","insp_start_time":"0545","insp_end_time":"0630","registration_date":"2026-02-24 00:00:00","region":"ES","ci_status_code":"C","location":"999","location_desc":"PA","county_code_state":"PA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"0629849","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":"U","pen_cen_match":"I","final_status_date":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"2926365","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-20T10:37:50.000000Z","updated_at":"2026-03-07T10:30:05.000000Z","inspection_violations":[{"id":19147093,"change_date":null,"inspection_id":"87065188","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"39311A1LCL"},{"id":19147094,"change_date":null,"inspection_id":"87065188","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":19455233,"change_date":null,"inspection_id":"87065188","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"","insp_unit_company":null,"insp_unit_license":"3539581","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV4PDUP1975","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19458232,"change_date":null,"inspection_id":"87065188","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P945644","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"0","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":11168228,"change_date":"2026-02-19 21:39:00","inspection_id":"87083827","dot_number":"287351","report_state":"PA","report_number":"C124000556","insp_date":"2026-02-17 00:00:00","insp_start_time":"0849","insp_end_time":"0919","registration_date":null,"region":"ES","ci_status_code":"C","location":"PUC150","location_desc":"TYRONE PA","county_code_state":"PA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":"02172026","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-02-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"2903599","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-02-19 21:39:00","snet_input_date":"2026-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-19 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:37:45.000000Z","updated_at":"2026-03-02T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19455570,"change_date":null,"inspection_id":"87083827","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3539578","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV9PDUP1972","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19458600,"change_date":null,"inspection_id":"87083827","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P945645","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A5618MB304370","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10792513,"change_date":"2026-01-16 21:40:00","inspection_id":"86818697","dot_number":"287351","report_state":"PA","report_number":"D415601513","insp_date":"2026-01-15 00:00:00","insp_start_time":"1239","insp_end_time":"1302","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","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":"2026-01-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2569179","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-01-16 21:40:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2026-01-16 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:59.000000Z","updated_at":"2026-01-27T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090510,"change_date":null,"inspection_id":"86818697","insp_unit_id":"1","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3786605","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD1PDUC4555","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10797096,"change_date":"2026-01-17 21:34:00","inspection_id":"86823513","dot_number":"287351","report_state":"PA","report_number":"C144000005","insp_date":"2026-01-15 00:00:00","insp_start_time":"1432","insp_end_time":"1459","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"COAL CENTER PA","county_code_state":"PA","county_code":"125","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"180059","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-17 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2780707","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-01-17 21:34:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-17 21:34:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-20T10:36:48.000000Z","updated_at":"2026-01-28T10:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090886,"change_date":null,"inspection_id":"86823513","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2488397","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVHCYCY2HHJC7324","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10827256,"change_date":"2026-01-21 21:38:00","inspection_id":"86855114","dot_number":"287351","report_state":"PA","report_number":"E910601372","insp_date":"2026-01-13 00:00:00","insp_start_time":"0800","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"413","location_desc":"SR22 WEST WHEATFIELD TOWNSHIP-","county_code_state":"PA","county_code":"063","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO LEASING LLC","shipping_paper_number":"0627397","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2570189","transaction_code":"A","transaction_date":"2026-01-21 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-01-21 21:38:00","snet_input_date":"2026-01-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2026-01-21 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-24T10:36:55.000000Z","updated_at":"2026-02-01T10:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19088346,"change_date":null,"inspection_id":"86855114","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283545","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003393","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19091662,"change_date":null,"inspection_id":"86855114","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PC93630","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA561XFB709312","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10644429,"change_date":"2026-01-15 21:40:00","inspection_id":"86785975","dot_number":"287351","report_state":"NY","report_number":"SPA3031138","insp_date":"2026-01-07 00:00:00","insp_start_time":"1200","insp_end_time":"1216","registration_date":"2026-01-14 00:00:00","region":"ES","ci_status_code":"C","location":"50699A","location_desc":"RANDOLPH NY","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","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-01-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"82700","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":"2761334","transaction_code":"C","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2026-01-14 21:39:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-14 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-17T10:36:17.000000Z","updated_at":"2026-01-26T10:30:06.000000Z","inspection_violations":[{"id":18744419,"change_date":null,"inspection_id":"86785975","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-23T04:17:42.000000Z","updated_at":"2026-02-23T04:17:42.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":19093369,"change_date":null,"inspection_id":"86785975","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"P962584","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526172811E5000332","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19086525,"change_date":null,"inspection_id":"86785975","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802423","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM001973","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10309659,"change_date":"2025-11-30 21:33:00","inspection_id":"86435908","dot_number":"287351","report_state":"PA","report_number":"E909532914","insp_date":"2025-11-25 00:00:00","insp_start_time":"1354","insp_end_time":"1449","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I-80 E 118 FEET WEST OF UNN","county_code_state":"PA","county_code":"085","insp_level_id":"3","service_center":"EA","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":"2025-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2558070","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-11-30 21:33:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-11-30 21:33:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-03T10:30:24.000000Z","updated_at":"2025-12-04T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18750772,"change_date":null,"inspection_id":"86435908","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561429","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5KM001050","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10009180,"change_date":"2025-10-22 21:39:00","inspection_id":"86119792","dot_number":"287351","report_state":"PA","report_number":"E948529470","insp_date":"2025-10-21 00:00:00","insp_start_time":"1445","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON ALLEGHENY VALLEY EXPY 525 F","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2550373","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-10-22 21:39:00","snet_input_date":"2025-10-21 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-10-22 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-25T10:01:41.000000Z","updated_at":"2025-10-26T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18669109,"change_date":null,"inspection_id":"86119792","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283764","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY4PM003403","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18831144,"change_date":null,"inspection_id":"86119792","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"P962361","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162813G5000533","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10002769,"change_date":"2025-10-22 21:38:00","inspection_id":"86113023","dot_number":"287351","report_state":"NY","report_number":"SPA3030956","insp_date":"2025-10-15 00:00:00","insp_start_time":"1521","insp_end_time":"1536","registration_date":null,"region":"ED","ci_status_code":"C","location":"50370M","location_desc":"IRVING NY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","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":"2025-10-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"77699","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":"2441676","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-10-22 21:38:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-22 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-25T10:01:21.000000Z","updated_at":"2025-10-26T10:00:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18746975,"change_date":null,"inspection_id":"86113023","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802367","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM001974","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18831184,"change_date":null,"inspection_id":"86113023","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PF74037","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162810R5000427","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9911778,"change_date":"2025-10-10 21:40:00","inspection_id":"86016710","dot_number":"287351","report_state":"PA","report_number":"E948528241","insp_date":"2025-10-09 00:00:00","insp_start_time":"1303","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON ALLEGHENY VALLEY EXPY 555 F","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"4013","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-10-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"2548101","transaction_code":"A","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-09 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:10.000000Z","updated_at":"2025-10-14T10:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18745682,"change_date":null,"inspection_id":"86016710","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283545","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY5PM003393","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18829731,"change_date":null,"inspection_id":"86016710","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PB24745","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526172815E5000334","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9641997,"change_date":"2025-09-10 21:40:00","inspection_id":"85733614","dot_number":"287351","report_state":"WV","report_number":"PSC1431240","insp_date":"2025-08-27 00:00:00","insp_start_time":"0655","insp_end_time":"0725","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MORGANTOWN WV","county_code_state":"WV","county_code":"061","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MURIALES RESTAURANT","shipping_paper_number":"617604","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","viol_total":"2","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":"2246942","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:34.000000Z","updated_at":"2025-09-13T10:47:34.000000Z","inspection_violations":[{"id":18477184,"change_date":null,"inspection_id":"85733614","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":18742334,"change_date":null,"inspection_id":"85733614","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"P962361","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV8ELFU2311","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9506250,"change_date":"2025-09-04 21:40:00","inspection_id":"85591324","dot_number":"287351","report_state":"NY","report_number":"SPA4040080","insp_date":"2025-08-20 00:00:00","insp_start_time":"0652","insp_end_time":"0712","registration_date":"2025-09-04 00:00:00","region":"ED","ci_status_code":"C","location":"50263M","location_desc":"BEMUS POINT NY","county_code_state":"NY","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"399717809","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-08-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2178136","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-08-26 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-26 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:52.000000Z","updated_at":"2025-09-10T10:45:18.000000Z","inspection_violations":[{"id":18476298,"change_date":null,"inspection_id":"85591324","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18741659,"change_date":null,"inspection_id":"85591324","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561429","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5KM001050","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18825531,"change_date":null,"inspection_id":"85591324","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"PB84587","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162811P5000076","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9506486,"change_date":"2025-09-09 21:40:00","inspection_id":"85591574","dot_number":"287351","report_state":"NY","report_number":"SPE3060993","insp_date":"2025-08-20 00:00:00","insp_start_time":"0709","insp_end_time":"0740","registration_date":"2025-08-20 00:00:00","region":"ED","ci_status_code":"C","location":"50263M","location_desc":"BEMUS POINT NY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"3004","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":"2025-08-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2178200","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-08-26 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-26 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:52.000000Z","updated_at":"2025-09-13T10:46:21.000000Z","inspection_violations":[{"id":18476876,"change_date":null,"inspection_id":"85591574","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALLPL"},{"id":18476877,"change_date":null,"inspection_id":"85591574","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":18742120,"change_date":null,"inspection_id":"85591574","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":null,"insp_unit_license":"2802336","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4ND4JJ1YN240962","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18826034,"change_date":null,"inspection_id":"85591574","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"P490385","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162818G5000530","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9250292,"change_date":"2025-08-27 21:40:00","inspection_id":"85322072","dot_number":"287351","report_state":"PA","report_number":"XL00087977","insp_date":"2025-07-24 00:00:00","insp_start_time":"0950","insp_end_time":"1050","registration_date":"2025-08-26 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"660 WASHINGTON RD","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","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":"2025-07-25 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"77700","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":"2532452","transaction_code":"C","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:22.000000Z","updated_at":"2025-09-06T10:41:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18659954,"change_date":null,"inspection_id":"85322072","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3283586","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV1ELFU2313","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18821264,"change_date":null,"inspection_id":"85322072","insp_unit_id":"2","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"HKID","insp_unit_company":null,"insp_unit_license":"PB84789","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526262811P5000440","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9104426,"change_date":"2025-07-09 21:43:00","inspection_id":"85168652","dot_number":"287351","report_state":"PA","report_number":"1005518992","insp_date":"2025-07-08 00:00:00","insp_start_time":"1156","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"466","location_desc":"SR 79 SB LONE PINE WEIGH STATI","county_code_state":"PA","county_code":"125","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2528450","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:29.000000Z","updated_at":"2025-07-14T10:46:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18658240,"change_date":null,"inspection_id":"85168652","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2488397","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVHCYCY2HHJC7324","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9104477,"change_date":"2025-07-09 21:43:00","inspection_id":"85168704","dot_number":"287351","report_state":"PA","report_number":"B325518983","insp_date":"2025-07-08 00:00:00","insp_start_time":"1500","insp_end_time":"1546","registration_date":null,"region":"ET","ci_status_code":"C","location":"434","location_desc":"SR 79 NB AT BRIDGEVILLE REST A","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","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":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2528467","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:29.000000Z","updated_at":"2025-07-14T10:46:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18658241,"change_date":null,"inspection_id":"85168704","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2488710","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV2JLJN7589","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18819403,"change_date":null,"inspection_id":"85168704","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PF55427","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K5SJ265088","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9104533,"change_date":"2025-07-10 21:39:00","inspection_id":"85168762","dot_number":"287351","report_state":"PA","report_number":"E130518909","insp_date":"2025-07-08 00:00:00","insp_start_time":"1305","insp_end_time":"1340","registration_date":"2025-07-10 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON PITTSBURGH AVE AT ITS INTER","county_code_state":"PA","county_code":"049","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"0614119","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-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"2528525","transaction_code":"C","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:29.000000Z","updated_at":"2025-07-14T10:46:45.000000Z","inspection_violations":[{"id":18459796,"change_date":null,"inspection_id":"85168762","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":18658301,"change_date":null,"inspection_id":"85168762","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802308","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY0LM001975","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18819468,"change_date":null,"inspection_id":"85168762","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"P744557","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163824J5000952","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9045983,"change_date":"2025-07-02 21:39:00","inspection_id":"85106975","dot_number":"287351","report_state":"NY","report_number":"SPA3070299","insp_date":"2025-06-25 00:00:00","insp_start_time":"1257","insp_end_time":"1319","registration_date":null,"region":"ED","ci_status_code":"C","location":"50263M","location_desc":"BEMUS POINT NY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO FOODS","shipping_paper_number":"ROUTE 3003","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":"2025-07-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58740","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":"1939761","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-07-02 21:39:00","snet_input_date":"2025-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:12.000000Z","updated_at":"2025-07-07T10:07:12.000000Z","inspection_violations":[{"id":18458690,"change_date":null,"inspection_id":"85106975","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":18735108,"change_date":null,"inspection_id":"85106975","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802367","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9LM001974","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18818635,"change_date":null,"inspection_id":"85106975","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDRON","insp_unit_company":null,"insp_unit_license":"PG26576","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162819G5000536","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8924520,"change_date":"2025-06-18 21:40:00","inspection_id":"84978812","dot_number":"287351","report_state":"NY","report_number":"SPA3030586","insp_date":"2025-06-11 00:00:00","insp_start_time":"1452","insp_end_time":"1506","registration_date":null,"region":"ED","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","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":"2025-06-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"1877710","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-06-18 21:40:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-18 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-22T10:00:54.000000Z","updated_at":"2025-06-22T10:00:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18733651,"change_date":null,"inspection_id":"84978812","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802423","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7LM001973","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18817072,"change_date":null,"inspection_id":"84978812","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PG74192","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162815H5000485","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8405782,"change_date":"2025-04-17 21:42:00","inspection_id":"84430971","dot_number":"287351","report_state":"PA","report_number":"A316510632","insp_date":"2025-04-16 00:00:00","insp_start_time":"1240","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"411","location_desc":"R119 SB AT HOLIDAY LN CENTER T","county_code_state":"PA","county_code":"063","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2509400","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-16 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:28:39.000000Z","updated_at":"2025-04-21T10:24:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18726736,"change_date":null,"inspection_id":"84430971","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3786605","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD1PDUC4555","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8325484,"change_date":"2025-04-09 21:40:00","inspection_id":"84346249","dot_number":"287351","report_state":"NY","report_number":"SPT3050632","insp_date":"2025-04-02 00:00:00","insp_start_time":"1539","insp_end_time":"1605","registration_date":null,"region":"ED","ci_status_code":"C","location":"50263M","location_desc":"BEMUS POINT NY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1570538","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-04-09 21:40:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-09 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-12T10:24:00.000000Z","updated_at":"2025-04-14T10:22:47.000000Z","inspection_violations":[{"id":18446027,"change_date":null,"inspection_id":"84346249","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"51A-LCDLRSWD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38351ALCDLRSWD"},{"id":18446028,"change_date":null,"inspection_id":"84346249","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":18725752,"change_date":null,"inspection_id":"84346249","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283741","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003396","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18808365,"change_date":null,"inspection_id":"84346249","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"PB24724","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162810J5000951","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8174367,"change_date":"2025-03-21 21:39:00","inspection_id":"84187207","dot_number":"287351","report_state":"PA","report_number":"M481000059","insp_date":"2025-03-19 00:00:00","insp_start_time":"0850","insp_end_time":"0931","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH VERSAILLES PA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"627497","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-03-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"1496296","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-03-21 21:39:00","snet_input_date":"2025-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:30.000000Z","updated_at":"2025-03-25T10:09:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18646120,"change_date":null,"inspection_id":"84187207","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"25614118","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY3KM001063","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18806349,"change_date":null,"inspection_id":"84187207","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"PG26706","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163828J5000954","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8155670,"change_date":"2025-03-19 21:41:00","inspection_id":"84167575","dot_number":"287351","report_state":"PA","report_number":"D107507730","insp_date":"2025-03-18 00:00:00","insp_start_time":"1140","insp_end_time":"1157","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO FOODS","shipping_paper_number":"399571674","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2503063","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:34:12.000000Z","updated_at":"2025-03-23T10:48:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18723500,"change_date":null,"inspection_id":"84167575","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2561437","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVHCYFE5KHKH5203","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8155987,"change_date":"2025-03-19 21:41:00","inspection_id":"84167902","dot_number":"287351","report_state":"PA","report_number":"E130507724","insp_date":"2025-03-18 00:00:00","insp_start_time":"1405","insp_end_time":"1431","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON PITTSBURGH AVE AT ITS INTER","county_code_state":"PA","county_code":"049","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2502200","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:34:36.000000Z","updated_at":"2025-03-23T10:48:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18723510,"change_date":null,"inspection_id":"84167902","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"P962517","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7622GB711058","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":20420972,"change_date":null,"inspection_id":"84167902","insp_unit_id":"sms-backfill-757511118-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P962517","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7622GB711058","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-04-27T03:16:39.000000Z","updated_at":"2026-04-27T03:16:39.000000Z"}]},{"id":8090942,"change_date":"2025-03-12 21:40:00","inspection_id":"84099409","dot_number":"287351","report_state":"NY","report_number":"SPA3011058","insp_date":"2025-03-05 00:00:00","insp_start_time":"1427","insp_end_time":"1436","registration_date":null,"region":"ES","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","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":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"82700","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":"1459038","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:17.000000Z","updated_at":"2025-03-17T21:06:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18644866,"change_date":null,"inspection_id":"84099409","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283741","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003396","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18804949,"change_date":null,"inspection_id":"84099409","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PB24914","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162817G5000535","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7988769,"change_date":"2025-02-28 21:41:00","inspection_id":"83991927","dot_number":"287351","report_state":"OH","report_number":"0616000036","insp_date":"2025-02-25 00:00:00","insp_start_time":"1335","insp_end_time":"1411","registration_date":null,"region":"ES","ci_status_code":"C","location":"04","location_desc":"HUBBARD OH","county_code_state":"OH","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIR","shipping_paper_number":"10022135","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":"2025-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1410023","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:04.000000Z","updated_at":"2025-03-17T21:04:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18721251,"change_date":null,"inspection_id":"83991927","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802454","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY3LM001971","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18803433,"change_date":null,"inspection_id":"83991927","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P426539","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7624GB711062","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7895871,"change_date":"2025-02-27 21:41:00","inspection_id":"83894585","dot_number":"287351","report_state":"PA","report_number":"B319504350","insp_date":"2025-02-12 00:00:00","insp_start_time":"1320","insp_end_time":"1400","registration_date":"2025-02-27 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I376 E 0 FEET NORTH OF I376","county_code_state":"PA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"2497397","transaction_code":"C","transaction_date":"2025-02-16 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-12 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[{"id":18439019,"change_date":null,"inspection_id":"83894585","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"87A-FPLR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39387AFPLR"}],"inspection_per_units":[{"id":18642375,"change_date":null,"inspection_id":"83894585","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2987227","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV8ELFU2311","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18802075,"change_date":null,"inspection_id":"83894585","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PG26706","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163828J5000954","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7784893,"change_date":"2025-02-04 21:40:00","inspection_id":"83778099","dot_number":"287351","report_state":"PA","report_number":"B208503470","insp_date":"2025-02-03 00:00:00","insp_start_time":"1550","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON MON FAYETTE EXPY 76 FEET NO","county_code_state":"PA","county_code":"125","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"399531785","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"2495154","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-02-04 21:40:00","snet_input_date":"2025-02-03 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-02-04 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:54.000000Z","updated_at":"2025-03-17T20:59:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18640967,"change_date":null,"inspection_id":"83778099","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2962630","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV5ELFU2315","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18800545,"change_date":null,"inspection_id":"83778099","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"PF74037","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162810R5000427","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7749929,"change_date":"2025-02-03 21:39:00","inspection_id":"83741152","dot_number":"287351","report_state":"PA","report_number":"XL00080777","insp_date":"2025-01-29 00:00:00","insp_start_time":"1642","insp_end_time":"1719","registration_date":"2025-01-31 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"LLOYD AVE AT MARY ST","county_code_state":"PA","county_code":"129","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO LEASING LLC DBA SYSCO PGH LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2494451","transaction_code":"C","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:08.000000Z","updated_at":"2025-03-17T20:59:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18640506,"change_date":null,"inspection_id":"83741152","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802365","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY2LM001976","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18800057,"change_date":null,"inspection_id":"83741152","insp_unit_id":"2","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PF74037","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162810R5000427","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7640432,"change_date":"2025-01-16 21:41:00","inspection_id":"83626190","dot_number":"287351","report_state":"PA","report_number":"1005501663","insp_date":"2025-01-16 00:00:00","insp_start_time":"0423","insp_end_time":"0501","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON MON FAYETTE EXPY 35.1 MM","county_code_state":"PA","county_code":"125","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"399513678","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"415000","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":"2491507","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-16 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:58.000000Z","updated_at":"2025-03-17T20:56:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18638993,"change_date":null,"inspection_id":"83626190","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3627003","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV5RSVH5434","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18798386,"change_date":null,"inspection_id":"83626190","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PC93505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52616382XP5000091","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7640606,"change_date":"2025-01-16 21:41:00","inspection_id":"83626372","dot_number":"287351","report_state":"PA","report_number":"B325501529","insp_date":"2025-01-15 00:00:00","insp_start_time":"1635","insp_end_time":"1650","registration_date":null,"region":"ET","ci_status_code":"C","location":"434","location_desc":"SR 79 NB AT BRIDGEVILLE REST A","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","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":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2491207","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:58.000000Z","updated_at":"2025-03-17T20:56:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18638996,"change_date":null,"inspection_id":"83626372","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3283569","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV9JLJN7590","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18798387,"change_date":null,"inspection_id":"83626372","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PF55427","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K5SJ265088","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7641128,"change_date":"2025-01-16 21:41:00","inspection_id":"83626919","dot_number":"287351","report_state":"PA","report_number":"D107501415","insp_date":"2025-01-14 00:00:00","insp_start_time":"1138","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","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":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"2490718","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-14 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:59.000000Z","updated_at":"2025-03-17T20:56:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18639004,"change_date":null,"inspection_id":"83626919","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9KM001049","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18798399,"change_date":null,"inspection_id":"83626919","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MAXO","insp_unit_company":null,"insp_unit_license":"PF55427","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K5SJ265088","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7437473,"change_date":"2024-12-17 21:39:00","inspection_id":"83413095","dot_number":"287351","report_state":"NY","report_number":"D507005455","insp_date":"2024-12-17 00:00:00","insp_start_time":"0922","insp_end_time":"0937","registration_date":null,"region":"ES","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1166846","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-12-17 21:39:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-17 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:11.000000Z","updated_at":"2025-03-17T20:51:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18713769,"change_date":null,"inspection_id":"83413095","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561429","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5KM001050","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18795190,"change_date":null,"inspection_id":"83413095","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PB84588","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162813P5000077","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7286385,"change_date":"2024-11-26 21:41:00","inspection_id":"83254075","dot_number":"287351","report_state":"PA","report_number":"M697000138","insp_date":"2024-11-25 00:00:00","insp_start_time":"1329","insp_end_time":"1343","registration_date":null,"region":"TT","ci_status_code":"C","location":"02414","location_desc":"I-79 N BRIDGEVILLE REST AREA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2024-11-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2480689","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-11-26 21:41:00","snet_input_date":"2024-11-25 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-11-26 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:08.000000Z","updated_at":"2025-03-17T20:48:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18711691,"change_date":null,"inspection_id":"83254075","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3786605","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFD1PDUC4555","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7265987,"change_date":"2024-11-23 21:33:00","inspection_id":"83232471","dot_number":"287351","report_state":"PA","report_number":"M696000041","insp_date":"2024-11-22 00:00:00","insp_start_time":"0517","insp_end_time":"0553","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PITTSBURGH PA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","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":"2024-11-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1085306","transaction_code":"A","transaction_date":"2024-11-23 00:00:00","upload_date":"2024-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-11-23 21:33:00","snet_input_date":"2024-11-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-23 21:33:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:42.000000Z","updated_at":"2025-03-17T20:47:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18633826,"change_date":null,"inspection_id":"83232471","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"AH19771","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1FVACXDTXDHBR5175","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7298739,"change_date":"2024-11-28 21:34:00","inspection_id":"83267209","dot_number":"287351","report_state":"NY","report_number":"SPA3050168","insp_date":"2024-11-21 00:00:00","insp_start_time":"1437","insp_end_time":"1456","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALLEGANY NY","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"98658","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-28 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103314","transaction_code":"A","transaction_date":"2024-11-28 00:00:00","upload_date":"2024-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-11-28 21:34:00","snet_input_date":"2024-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-28 21:34:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:12.000000Z","updated_at":"2025-03-17T20:48:12.000000Z","inspection_violations":[{"id":18429701,"change_date":null,"inspection_id":"83267209","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":18711858,"change_date":null,"inspection_id":"83267209","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561419","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY8KM001043","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18793088,"change_date":null,"inspection_id":"83267209","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"PG26576","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162819G5000536","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7014834,"change_date":"2024-10-22 21:41:00","inspection_id":"82966583","dot_number":"287351","report_state":"PA","report_number":"XL00077554","insp_date":"2024-10-21 00:00:00","insp_start_time":"1252","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"S MAIN ST @ W SECOND ST","county_code_state":"PA","county_code":"129","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ARA LAUREL HIGHLAND","shipping_paper_number":"059646","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"159401","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":"2473870","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-21 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18707977,"change_date":null,"inspection_id":"82966583","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3431807","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY7PM003394","insp_unit_decal":null,"insp_unit_decal_number":"34566564","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18788875,"change_date":null,"inspection_id":"82966583","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PB24724","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162810J5000951","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6809883,"change_date":"2024-09-24 21:42:00","inspection_id":"82748839","dot_number":"287351","report_state":"PA","report_number":"1005426320","insp_date":"2024-09-19 00:00:00","insp_start_time":"1046","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON ALICIA RD, IN FRONT OF AMER","county_code_state":"PA","county_code":"051","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"2468928","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[{"id":18420996,"change_date":null,"inspection_id":"82748839","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2T","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922T"}],"inspection_per_units":[{"id":18627474,"change_date":null,"inspection_id":"82748839","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2488397","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVHCYCY2HHJC7324","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6628295,"change_date":"2024-09-03 21:41:00","inspection_id":"82555397","dot_number":"287351","report_state":"NY","report_number":"SPA0341237","insp_date":"2024-08-29 00:00:00","insp_start_time":"1359","insp_end_time":"1434","registration_date":null,"region":"ET","ci_status_code":"C","location":"50011","location_desc":"TOWN OF ALLEGANY","county_code_state":"NY","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO PITTSBURG LLC","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-09-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2948074","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2024-09-03 21:41:00","snet_input_date":"2024-09-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-03 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:27.000000Z","updated_at":"2025-03-17T20:34:27.000000Z","inspection_violations":[{"id":18417777,"change_date":null,"inspection_id":"82555397","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":18702690,"change_date":null,"inspection_id":"82555397","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY9KM001049","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18783129,"change_date":null,"inspection_id":"82555397","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"P426857","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162814G5000587","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6302885,"change_date":"2024-07-25 21:42:00","inspection_id":"82207894","dot_number":"287351","report_state":"PA","report_number":"M696000015","insp_date":"2024-07-23 00:00:00","insp_start_time":"0529","insp_end_time":"0554","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PITTSBURGH PA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","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":"2024-07-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"683446","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-07-25 21:42:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-25 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:48.000000Z","updated_at":"2025-03-17T20:27:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18620656,"change_date":null,"inspection_id":"82207894","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"2240677","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV1FLGN3901","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18778376,"change_date":null,"inspection_id":"82207894","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"P962631","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"526162815L5000656","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6283877,"change_date":"2024-07-23 21:41:00","inspection_id":"82187596","dot_number":"287351","report_state":"WV","report_number":"PSC0910253","insp_date":"2024-07-19 00:00:00","insp_start_time":"1155","insp_end_time":"1217","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BURNSVILLE  WV","county_code_state":"WV","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"5015","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"678515","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-07-23 21:41:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-23 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:22.000000Z","updated_at":"2025-03-17T20:27:22.000000Z","inspection_violations":[{"id":18411199,"change_date":null,"inspection_id":"82187596","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":18620370,"change_date":null,"inspection_id":"82187596","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802366","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY5LM001972","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18778055,"change_date":null,"inspection_id":"82187596","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PB24914","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162817G5000535","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6159848,"change_date":"2024-07-08 21:41:00","inspection_id":"82054438","dot_number":"287351","report_state":"PA","report_number":"C125000298","insp_date":"2024-06-20 00:00:00","insp_start_time":"1415","insp_end_time":"1445","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WAYNESBURG PA","county_code_state":"PA","county_code":"059","insp_level_id":"3","service_center":"EA","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":"2024-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"633744","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-07-08 21:41:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-08 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:39.000000Z","updated_at":"2025-03-17T20:24:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18696374,"change_date":null,"inspection_id":"82054438","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802454","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY3LM001971","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18776208,"change_date":null,"inspection_id":"82054438","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P962517","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA7622GB711058","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5996607,"change_date":"2024-06-14 21:40:00","inspection_id":"81878780","dot_number":"287351","report_state":"PA","report_number":"B306416508","insp_date":"2024-06-13 00:00:00","insp_start_time":"1804","insp_end_time":"1831","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I79 N 429 FEET NORTH OF UNN","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2450275","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:30.000000Z","updated_at":"2025-03-17T20:21:30.000000Z","inspection_violations":[{"id":18405821,"change_date":null,"inspection_id":"81878780","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":18694122,"change_date":null,"inspection_id":"81878780","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2779068","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY7KM001244","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18773696,"change_date":null,"inspection_id":"81878780","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"PF55428","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V382K7SJ265089","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5965712,"change_date":"2024-06-11 21:42:00","inspection_id":"81845248","dot_number":"287351","report_state":"PA","report_number":"E951416286","insp_date":"2024-06-10 00:00:00","insp_start_time":"1131","insp_end_time":"1204","registration_date":null,"region":"ET","ci_status_code":"C","location":"443","location_desc":"SR0290\/BAYFRONT CONNECTOR WEST","county_code_state":"PA","county_code":"049","insp_level_id":"2","service_center":"EA","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-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"2449269","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-06-11 21:42:00","snet_input_date":"2024-06-10 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-06-11 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:03.000000Z","updated_at":"2025-03-17T20:21:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18615847,"change_date":null,"inspection_id":"81845248","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2802365","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY2LM001976","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18773133,"change_date":null,"inspection_id":"81845248","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P945644","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A5611MB304369","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5769284,"change_date":"2024-05-16 21:41:00","inspection_id":"81632036","dot_number":"287351","report_state":"PA","report_number":"E948413625","insp_date":"2024-05-15 00:00:00","insp_start_time":"0655","insp_end_time":"0745","registration_date":"2024-05-16 00:00:00","region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2442056","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:06.000000Z","updated_at":"2025-03-17T20:17:06.000000Z","inspection_violations":[{"id":18401102,"change_date":null,"inspection_id":"81632036","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":18613052,"change_date":null,"inspection_id":"81632036","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3216052","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDVXELFU2312","insp_unit_decal":null,"insp_unit_decal_number":"33931536","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18770043,"change_date":null,"inspection_id":"81632036","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"P426857","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162814G5000587","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5757220,"change_date":"2024-05-15 21:43:00","inspection_id":"81619005","dot_number":"287351","report_state":"PA","report_number":"B447413538","insp_date":"2024-05-14 00:00:00","insp_start_time":"1439","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"I79 N- KIRBY WELCOME CENTER","county_code_state":"PA","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"0585186","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"99700","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":"2441224","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:44.000000Z","updated_at":"2025-03-17T20:16:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18612868,"change_date":null,"inspection_id":"81619005","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3627003","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV3RSVH5433","insp_unit_decal":null,"insp_unit_decal_number":"33931271","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18769847,"change_date":null,"inspection_id":"81619005","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"KIDR","insp_unit_company":null,"insp_unit_license":"PC93505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52616382XP5000091","insp_unit_decal":null,"insp_unit_decal_number":"33931273","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5799037,"change_date":"2024-05-21 21:45:00","inspection_id":"81663921","dot_number":"287351","report_state":"PA","report_number":"M711000030","insp_date":"2024-05-02 00:00:00","insp_start_time":"1153","insp_end_time":"1224","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ELIZABETH PA","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-21 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","viol_total":"2","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":"497857","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-05-21 21:45:00","snet_input_date":"2024-05-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-21 21:45:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:33.000000Z","updated_at":"2025-03-17T20:17:33.000000Z","inspection_violations":[{"id":18401766,"change_date":null,"inspection_id":"81663921","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18613474,"change_date":null,"inspection_id":"81663921","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3539579","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKBHTDV7SSVN1811","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18770538,"change_date":null,"inspection_id":"81663921","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VT HACKNEY","insp_unit_company":null,"insp_unit_license":"PC93505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52616382XP5000091","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5483714,"change_date":"2024-04-10 21:42:00","inspection_id":"81321462","dot_number":"287351","report_state":"PA","report_number":"M424001335","insp_date":"2024-04-10 00:00:00","insp_start_time":"1050","insp_end_time":"1104","registration_date":null,"region":"ET","ci_status_code":"C","location":"02470","location_desc":"MOSSIDE BOULEVARD","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","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":"Y","pen_cen_match":"I","final_status_date":"2024-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"2432414","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-10 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:30.000000Z","updated_at":"2025-03-17T20:11:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18686550,"change_date":null,"inspection_id":"81321462","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2240700","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV3FLGN3902","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18765646,"change_date":null,"inspection_id":"81321462","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"PB84587","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526162811P5000076","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5397236,"change_date":"2024-03-29 21:38:00","inspection_id":"81226426","dot_number":"287351","report_state":"NY","report_number":"SPA0294743","insp_date":"2024-03-26 00:00:00","insp_start_time":"0728","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"50263","location_desc":"BEMUS POINT REST AREA","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"399218089","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-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2914015","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:30.000000Z","updated_at":"2025-03-17T20:09:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18685372,"change_date":null,"inspection_id":"81226426","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"3283741","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN3AY0PM003396","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18764348,"change_date":null,"inspection_id":"81226426","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"P379168","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"52617281XE5000331","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5125293,"change_date":"2024-05-16 21:41:00","inspection_id":"80930262","dot_number":"287351","report_state":"PA","report_number":"C131000136","insp_date":"2024-02-23 00:00:00","insp_start_time":"1040","insp_end_time":"1125","registration_date":"2024-05-16 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"BRIDGEVILLE REST AREA I 79 N","county_code_state":"PA","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2024-02-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2422754","transaction_code":"C","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-02-23 21:41:00","snet_input_date":"2024-02-23 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-02-23 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:11.000000Z","updated_at":"2025-03-17T20:04:11.000000Z","inspection_violations":[{"id":18388356,"change_date":null,"inspection_id":"80930262","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A1-NPH","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39141A1NPH"},{"id":18388357,"change_date":null,"inspection_id":"80930262","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":18603818,"change_date":null,"inspection_id":"80930262","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3283756","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWDUXEHFS9922","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5115684,"change_date":"2024-02-22 21:43:00","inspection_id":"80919745","dot_number":"287351","report_state":"PA","report_number":"B320405220","insp_date":"2024-02-21 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I79 N AT MM 67","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","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-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"2422053","transaction_code":"A","transaction_date":"2024-02-21 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-21 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18681451,"change_date":null,"inspection_id":"80919745","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"2561419","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1M1AN2AY8KM001043","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18759923,"change_date":null,"inspection_id":"80919745","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"PT392A6","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"1GRAA7622AB704926","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4944329,"change_date":"2024-01-31 21:42:00","inspection_id":"80732340","dot_number":"287351","report_state":"PA","report_number":"M175001280","insp_date":"2024-01-26 00:00:00","insp_start_time":"0854","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"02416","location_desc":"900 BLOCK CASTLE SHANNON BLVD","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"1167471","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":"Y","pen_cen_match":"I","final_status_date":"2024-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80379","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2416227","transaction_code":"A","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2024-01-31 21:42:00","snet_input_date":"2024-01-26 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:48.000000Z","updated_at":"2025-03-17T20:00:48.000000Z","inspection_violations":[{"id":18384787,"change_date":null,"inspection_id":"80732340","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"51A-NSIN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38351ANSIN"},{"id":18384788,"change_date":null,"inspection_id":"80732340","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":18601131,"change_date":null,"inspection_id":"80732340","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3431823","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUBGBDV9ELFU2317","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18757072,"change_date":null,"inspection_id":"80732340","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"P744539","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"526163828J5000954","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4665910,"change_date":"2023-12-19 21:41:00","inspection_id":"80428219","dot_number":"287351","report_state":"PA","report_number":"M664000144","insp_date":"2023-12-15 00:00:00","insp_start_time":"1350","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"02108","location_desc":"BABCOCK BLVD @ WILDWOOD RD","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2023-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"2406367","transaction_code":"A","transaction_date":"2023-12-15 00:00:00","upload_date":"2023-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-12-19 21:41:00","snet_input_date":"2023-12-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-12-19 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:22.000000Z","updated_at":"2025-03-17T19:55:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4483264,"change_date":"2024-01-18 21:45:00","inspection_id":"80227473","dot_number":"287351","report_state":"PA","report_number":"M217000599","insp_date":"2023-11-20 00:00:00","insp_start_time":"1135","insp_end_time":"1158","registration_date":"2024-01-18 00:00:00","region":"ET","ci_status_code":"C","location":"02407","location_desc":"CLIFTON","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-11-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2399860","transaction_code":"C","transaction_date":"2023-11-20 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-11-22 21:39:00","snet_input_date":"2023-11-22 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-22 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:47.000000Z","updated_at":"2025-03-17T19:51:47.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4175453,"change_date":"2023-10-12 21:42:00","inspection_id":"79887507","dot_number":"287351","report_state":"PA","report_number":"A312328397","insp_date":"2023-10-10 00:00:00","insp_start_time":"1715","insp_end_time":"1740","registration_date":"2023-10-12 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ROUTE 422 HWY E NEAR OLD MILL","county_code_state":"PA","county_code":"063","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"2387351","transaction_code":"C","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-10-11 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-10-11 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:30.000000Z","updated_at":"2025-03-17T19:45:30.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4025610,"change_date":"2023-10-13 21:41:00","inspection_id":"79721184","dot_number":"287351","report_state":"PA","report_number":"D208326347","insp_date":"2023-09-20 00:00:00","insp_start_time":"0515","insp_end_time":"0549","registration_date":"2023-10-13 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"BENJAMIN FRANKLIN HWY MEASURIN","county_code_state":"PA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"136700","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":"2381911","transaction_code":"C","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-09-21 21:41:00","snet_input_date":"2023-09-20 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-09-21 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:23.000000Z","updated_at":"2025-03-17T19:42:23.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3861126,"change_date":"2023-10-12 21:42:00","inspection_id":"79538396","dot_number":"287351","report_state":"PA","report_number":"M424001298","insp_date":"2023-08-28 00:00:00","insp_start_time":"1730","insp_end_time":"1818","registration_date":"2023-10-12 00:00:00","region":"ET","ci_status_code":"C","location":"02424","location_desc":"PARK STREET","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"228614","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":"Y","pen_cen_match":"I","final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"2377094","transaction_code":"C","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:19.000000Z","updated_at":"2025-03-17T19:39:19.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3762975,"change_date":"2023-08-17 21:42:00","inspection_id":"79428345","dot_number":"287351","report_state":"WV","report_number":"4748001263","insp_date":"2023-08-17 00:00:00","insp_start_time":"0931","insp_end_time":"0954","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NORTON","county_code_state":"WV","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"65700","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"534961","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-08-17 21:42:00","snet_input_date":"2023-08-17 00:00:00","source_office":"1WVS001","mcmis_add_date":"2023-08-17 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:15.000000Z","updated_at":"2025-03-17T19:37:15.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3770304,"change_date":"2023-08-17 21:44:00","inspection_id":"79436733","dot_number":"287351","report_state":"PA","report_number":"E948322786","insp_date":"2023-08-15 00:00:00","insp_start_time":"1300","insp_end_time":"1323","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2373522","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:17.000000Z","updated_at":"2025-03-17T19:37:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3770437,"change_date":"2023-08-17 21:44:00","inspection_id":"79436886","dot_number":"287351","report_state":"PA","report_number":"D609322735","insp_date":"2023-08-15 00:00:00","insp_start_time":"1431","insp_end_time":"1456","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"2","service_center":"EA","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":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2373396","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-15 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:17.000000Z","updated_at":"2025-03-17T19:37:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3725013,"change_date":"2023-08-11 21:39:00","inspection_id":"79386324","dot_number":"287351","report_state":"PA","report_number":"D227322239","insp_date":"2023-08-10 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"PA28 N MEASURING 277 FEET SOUT","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ROCKAFELLAS","shipping_paper_number":"009","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2372558","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3702020,"change_date":"2023-08-09 21:42:00","inspection_id":"79360639","dot_number":"287351","report_state":"NY","report_number":"SPA0334081","insp_date":"2023-08-08 00:00:00","insp_start_time":"1546","insp_end_time":"1617","registration_date":null,"region":"ET","ci_status_code":"C","location":"50370B","location_desc":"HANOVER 2","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"82700","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":"2856428","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-08-09 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-09 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:05.000000Z","updated_at":"2025-03-17T19:36:05.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3623444,"change_date":"2023-07-28 21:42:00","inspection_id":"79272626","dot_number":"287351","report_state":"PA","report_number":"M672100090","insp_date":"2023-07-27 00:00:00","insp_start_time":"1051","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MARKET ST \/ THIRD AVE","county_code_state":"PA","county_code":"123","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","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":"Y","pen_cen_match":"I","final_status_date":"2023-07-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"2369439","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3573351,"change_date":"2023-07-24 21:41:00","inspection_id":"79216434","dot_number":"287351","report_state":"NY","report_number":"SPA0340288","insp_date":"2023-07-20 00:00:00","insp_start_time":"1329","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"60212","location_desc":"T\/CUBA","county_code_state":"NY","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO PITTSBURG LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"2849973","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:34.000000Z","updated_at":"2025-03-17T19:33:34.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3262949,"change_date":"2023-06-14 21:41:00","inspection_id":"78867317","dot_number":"287351","report_state":"PA","report_number":"E964315394","insp_date":"2023-06-02 00:00:00","insp_start_time":"1219","insp_end_time":"1432","registration_date":"2023-06-14 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"COZY INN CUT OFF MEASURING 198","county_code_state":"PA","county_code":"129","insp_level_id":"1","service_center":"EA","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":"2023-06-12 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"93000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2355203","transaction_code":"C","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-06-12 21:40:00","snet_input_date":"2023-06-02 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-06-12 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:41.000000Z","updated_at":"2025-03-17T19:27:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3134072,"change_date":"2023-05-24 21:41:00","inspection_id":"78721805","dot_number":"287351","report_state":"PA","report_number":"M544000082","insp_date":"2023-05-23 00:00:00","insp_start_time":"1015","insp_end_time":"1042","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"51 @ LIME","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2023-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2350851","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2658098,"change_date":"2023-04-12 21:41:00","inspection_id":"78182418","dot_number":"287351","report_state":"PA","report_number":"C063002622","insp_date":"2023-03-23 00:00:00","insp_start_time":"1030","insp_end_time":"1143","registration_date":"2023-04-11 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"INTERSECTION OF SR119 & SR436","county_code_state":"PA","county_code":"065","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0559033","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":"I","final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"3","hazmat_oos_total":"0","snet_sequence_id":"2331373","transaction_code":"C","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-23 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:35.000000Z","updated_at":"2025-03-17T19:15:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2549598,"change_date":"2023-03-10 21:40:00","inspection_id":"78058981","dot_number":"287351","report_state":"NY","report_number":"0510024169","insp_date":"2023-03-09 00:00:00","insp_start_time":"1331","insp_end_time":"1353","registration_date":null,"region":"ET","ci_status_code":"C","location":"50011M","location_desc":"ALLEGANY REST AREA (WB)","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SYSCO","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":"I","final_status_date":"2023-03-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73700","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":"2804958","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2023-03-10 21:40:00","snet_input_date":"2023-03-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-10 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2080327,"change_date":"2023-01-06 21:38:00","inspection_id":"77523559","dot_number":"287351","report_state":"NY","report_number":"SPA0333579","insp_date":"2023-01-05 00:00:00","insp_start_time":"0736","insp_end_time":"0809","registration_date":null,"region":"ET","ci_status_code":"C","location":"50263","location_desc":"ELLERY OVERLOOK","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":"0554327","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"64700","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":"2786065","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2023-01-06 21:38:00","snet_input_date":"2023-01-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-06 21:38:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:05.000000Z","updated_at":"2025-03-17T19:05:05.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2198968,"change_date":"2023-01-23 21:41:00","inspection_id":"77659864","dot_number":"287351","report_state":"NY","report_number":"SPE0310487","insp_date":"2023-01-05 00:00:00","insp_start_time":"1320","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"50263","location_desc":"ELLERY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26730","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":"2791339","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2023-01-23 21:41:00","snet_input_date":"2023-01-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-23 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:00.000000Z","updated_at":"2025-03-17T19:07:00.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2071906,"change_date":"2023-01-05 21:39:00","inspection_id":"77513925","dot_number":"287351","report_state":"NY","report_number":"SPA0257752","insp_date":"2023-01-04 00:00:00","insp_start_time":"0930","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"50263","location_desc":"ELLERY","county_code_state":"NY","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYSCO PITTSBURGH LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"74700","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":"2785080","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2023-01-05 21:39:00","snet_input_date":"2023-01-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-05 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:46.000000Z","updated_at":"2025-03-17T19:04:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2067973,"change_date":"2023-01-04 21:40:00","inspection_id":"77509580","dot_number":"287351","report_state":"PA","report_number":"C410300337","insp_date":"2023-01-03 00:00:00","insp_start_time":"1445","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ROUTE 1830 MEASURING 160 FEET","county_code_state":"PA","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2312200","transaction_code":"A","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-01-04 21:40:00","snet_input_date":"2023-01-03 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-01-04 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:44.000000Z","updated_at":"2025-03-17T19:04:44.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1997890,"change_date":"2022-12-28 21:40:00","inspection_id":"77429781","dot_number":"287351","report_state":"PA","report_number":"C208235405","insp_date":"2022-12-20 00:00:00","insp_start_time":"0657","insp_end_time":"0722","registration_date":"2022-12-28 00:00:00","region":"ET","ci_status_code":"C","location":"015","location_desc":"I-80 WB MM 56 BEAVER TWP - WEI","county_code_state":"PA","county_code":"031","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2309344","transaction_code":"C","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-12-21 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-12-21 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:22.000000Z","updated_at":"2025-03-17T19:03:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2297910,"change_date":"2023-02-03 21:41:00","inspection_id":"77772563","dot_number":"287351","report_state":"PA","report_number":"D3BB235402","insp_date":"2022-12-13 00:00:00","insp_start_time":"2354","insp_end_time":"0108","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON LEESBURG GROVE CITY RD AT I","county_code_state":"PA","county_code":"085","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"1","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"5","oos_total":"4","driver_viol_total":"5","driver_oos_total":"4","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2320308","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2023-02-03 21:41:00","snet_input_date":"2022-12-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-02-03 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:55.000000Z","updated_at":"2025-03-17T19:08:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1810152,"change_date":"2022-11-23 21:40:00","inspection_id":"77215088","dot_number":"287351","report_state":"PA","report_number":"M461000825","insp_date":"2022-11-19 00:00:00","insp_start_time":"1013","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"02214","location_desc":"HOME DRIVE","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SYSCO","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":"Y","pen_cen_match":"I","final_status_date":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"2301927","transaction_code":"A","transaction_date":"2022-11-19 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-20 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:59.000000Z","updated_at":"2025-03-17T18:59:59.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1774005,"change_date":"2022-11-23 21:40:00","inspection_id":"77173413","dot_number":"287351","report_state":"PA","report_number":"E905232121","insp_date":"2022-11-17 00:00:00","insp_start_time":"0955","insp_end_time":"1025","registration_date":"2022-11-23 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"MAIN ST  BELLWOOD","county_code_state":"PA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"LOCAL DELIVERIE","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":"2022-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2301596","transaction_code":"C","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-11-18 21:39:00","snet_input_date":"2022-11-17 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-11-18 21:39:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:19.000000Z","updated_at":"2025-03-17T18:59:19.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1639299,"change_date":"2022-10-31 21:41:00","inspection_id":"77019026","dot_number":"287351","report_state":"PA","report_number":"M131000642","insp_date":"2022-10-28 00:00:00","insp_start_time":"0837","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"02454","location_desc":"CLAIRTON BLVD AT DENNY DR","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"2296547","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-10-31 21:41:00","snet_input_date":"2022-10-28 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-10-31 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:43.000000Z","updated_at":"2025-03-17T18:56:43.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1407181,"change_date":"2022-09-29 21:41:00","inspection_id":"76751265","dot_number":"287351","report_state":"PA","report_number":"F306227132","insp_date":"2022-09-28 00:00:00","insp_start_time":"1230","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"E ALLEGANY AVE MEASURING 199 F","county_code_state":"PA","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"DRIFTWOOD SALOON AND GRILL","shipping_paper_number":"0548299","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-09-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"89690","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":"2289342","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-09-29 21:41:00","snet_input_date":"2022-09-28 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-09-29 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:41.000000Z","updated_at":"2025-03-17T18:52:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1328988,"change_date":"2022-09-22 21:40:00","inspection_id":"76660336","dot_number":"287351","report_state":"PA","report_number":"E956226358","insp_date":"2022-09-20 00:00:00","insp_start_time":"0425","insp_end_time":"0507","registration_date":"2022-09-22 00:00:00","region":"ET","ci_status_code":"C","location":"078","location_desc":"I79 SB MM 80.5 CRANBERRY TWP -","county_code_state":"PA","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2286683","transaction_code":"C","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-09-20 21:42:00","snet_input_date":"2022-09-20 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-09-20 21:42:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:13.000000Z","updated_at":"2025-03-17T18:51:13.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1285125,"change_date":"2022-09-14 21:40:00","inspection_id":"76608983","dot_number":"287351","report_state":"OH","report_number":"3285015388","insp_date":"2022-09-14 00:00:00","insp_start_time":"0724","insp_end_time":"0744","registration_date":null,"region":"ET","ci_status_code":"C","location":"08122","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MANY","shipping_paper_number":"YES","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":"I","final_status_date":"2022-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1616139","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-14 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:27.000000Z","updated_at":"2025-03-17T18:50:27.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":916463,"change_date":"2022-08-16 21:39:00","inspection_id":"76180112","dot_number":"287351","report_state":"PA","report_number":"B117220807","insp_date":"2022-07-27 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":"2022-08-16 00:00:00","region":"ET","ci_status_code":"C","location":"434","location_desc":"SR 79 NB AT BRIDGEVILLE REST A","county_code_state":"PA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"S2KOBJOWNR","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":"2022-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2274260","transaction_code":"C","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-07-28 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:45.000000Z","updated_at":"2025-03-17T18:43:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":916535,"change_date":"2022-07-28 21:40:00","inspection_id":"76180188","dot_number":"287351","report_state":"PA","report_number":"C609220823","insp_date":"2022-07-27 00:00:00","insp_start_time":"0540","insp_end_time":"0556","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"FRONT ST MEASURING 57 FEET EAS","county_code_state":"PA","county_code":"047","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"544105","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-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","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":"2274167","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-07-28 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:45.000000Z","updated_at":"2025-03-17T18:43:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":916762,"change_date":"2022-07-28 21:40:00","inspection_id":"76180443","dot_number":"287351","report_state":"PA","report_number":"E930220839","insp_date":"2022-07-27 00:00:00","insp_start_time":"1055","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"434","location_desc":"SR 79 NB AT BRIDGEVILLE REST A","county_code_state":"PA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"3013","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":"2022-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"102700","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":"2274274","transaction_code":"A","transaction_date":"2022-07-27 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-07-28 21:40:00","snet_input_date":"2022-07-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:45.000000Z","updated_at":"2025-03-17T18:43:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":716110,"change_date":"2022-06-29 21:41:00","inspection_id":"75945523","dot_number":"287351","report_state":"NY","report_number":"SPA0314290","insp_date":"2022-06-28 00:00:00","insp_start_time":"1438","insp_end_time":"1458","registration_date":null,"region":"ET","ci_status_code":"C","location":"50361A","location_desc":"HAMBURG (EXIT 57)","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","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":"2022-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77700","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2720981","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":"M","census_search_date":"2022-06-29 21:41:00","snet_input_date":"2022-06-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-29 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:13.000000Z","updated_at":"2025-03-17T18:40:13.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":448850,"change_date":"2022-05-20 21:41:00","inspection_id":"75628145","dot_number":"287351","report_state":"PA","report_number":"D130213920","insp_date":"2022-05-19 00:00:00","insp_start_time":"1258","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"I79 NB MM 80 CRANBERRY TWP - N","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","shipping_paper_number":"539896","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":"2022-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2257114","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:37.000000Z","updated_at":"2025-03-17T18:35:37.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":423261,"change_date":"2022-05-18 21:44:00","inspection_id":"75597947","dot_number":"287351","report_state":"PA","report_number":"D218213706","insp_date":"2022-05-17 00:00:00","insp_start_time":"0450","insp_end_time":"0542","registration_date":null,"region":"ET","ci_status_code":"C","location":"078","location_desc":"I79 SB MM 80.5 CRANBERRY TWP -","county_code_state":"PA","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYSCO","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":"2022-05-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2254736","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00287351","upload_search_indicator":null,"census_search_date":"2022-05-18 21:44:00","snet_input_date":"2022-05-17 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-05-18 21:44:00","insp_carrier_name":"SYSCO PITTSBURGH LLC","insp_carrier_street":"ONE WHITNEY DRIVE","insp_carrier_city":"HARMONY","insp_carrier_state":"PA","insp_carrier_zip_code":"16037","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:07.000000Z","updated_at":"2025-03-17T18:35:07.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/287351\/inspections?page=1","from":1,"last_page":2,"last_page_url":"https:\/\/searchcarriers.com\/company\/287351\/inspections?page=2","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/287351\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/287351\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/287351\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/287351\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/287351\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":104}