{"current_page":1,"data":[{"id":11775866,"change_date":"2026-04-29 21:39:00","inspection_id":"87706868","dot_number":"354815","report_state":"NY","report_number":"SPA3051502","insp_date":"2026-04-22 00:00:00","insp_start_time":"1117","insp_end_time":"1133","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ALBION NY","county_code_state":"NY","county_code":"073","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN MILLS FOODS","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-29 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":"3227991","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2026-04-29 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:39:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-02T09:40:56.000000Z","updated_at":"2026-05-10T09:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21337339,"change_date":null,"inspection_id":"87706868","insp_unit_id":"sms-backfill-789361812-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":null,"insp_unit_decal_number":"36370961","created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11715974,"change_date":"2026-04-22 21:38:00","inspection_id":"87643203","dot_number":"354815","report_state":"NY","report_number":"SPA3021498","insp_date":"2026-04-15 00:00:00","insp_start_time":"1110","insp_end_time":"1129","registration_date":null,"region":"ED","ci_status_code":"C","location":"40647R","location_desc":"CORFU NY","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"J. MILLS DISTRIBUTING CO","shipping_paper_number":"479174","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-22 21:38: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":"3192544","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2026-04-22 21:38:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-22 21:38:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:38:56.000000Z","updated_at":"2026-05-03T09:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20724554,"change_date":null,"inspection_id":"87643203","insp_unit_id":"sms-backfill-788788827-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PXB5065","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMMN9SS082859","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":11660950,"change_date":"2026-04-16 21:40:00","inspection_id":"87590994","dot_number":"354815","report_state":"NY","report_number":"SPE4010106","insp_date":"2026-04-09 00:00:00","insp_start_time":"1021","insp_end_time":"1037","registration_date":null,"region":"ED","ci_status_code":"C","location":"40714W","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN MILLS","shipping_paper_number":"8672","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-16 21:40: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":"3164290","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:53.000000Z","updated_at":"2026-04-27T09:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20723671,"change_date":null,"inspection_id":"87590994","insp_unit_id":"sms-backfill-788318946-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWZ9805","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN9RL662338","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":11575297,"change_date":"2026-04-06 21:37:00","inspection_id":"87499443","dot_number":"354815","report_state":"PA","report_number":"E130609690","insp_date":"2026-04-06 00:00:00","insp_start_time":"0929","insp_end_time":"0945","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GREENFIELD TOWNSHIP PA","county_code_state":"PA","county_code":"049","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-06 21:37: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":"3120090","transaction_code":"A","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-04-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"NY","created_at":"2026-04-09T09:49:08.000000Z","updated_at":"2026-04-17T09:37:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19838910,"change_date":"2026-04-06 21:37:00","inspection_id":"87499443","insp_unit_id":"212561957","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"2522815","insp_unit_license":"PXB0845","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMMN5SS082860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:43:00.000000Z","updated_at":"2026-04-15T09:09:59.000000Z"}]},{"id":9313606,"change_date":"2025-10-29 21:40:00","inspection_id":"85388647","dot_number":"354815","report_state":"NY","report_number":"D507101757","insp_date":"2025-08-01 00:00:00","insp_start_time":"1003","insp_end_time":"1030","registration_date":"2025-10-29 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BUFFALO NY","county_code_state":"NY","county_code":"029","insp_level_id":"1","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":"2025-08-02 21:33: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2076703","transaction_code":"C","transaction_date":"2025-08-02 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-08-02 21:33:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-02 21:33:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-06T10:43:39.000000Z","updated_at":"2025-11-02T11:00:20.000000Z","inspection_violations":[{"id":16659506,"change_date":"2025-10-29 21:40:00","inspection_id":"85388647","insp_violation_id":"269585142","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TT42KM6JT3","created_at":"2025-11-01T10:17:40.000000Z","updated_at":"2025-11-02T11:15:28.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":16722445,"change_date":"2025-10-29 21:40:00","inspection_id":"85388647","insp_unit_id":"209710825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"EAGLE INTE","insp_unit_company":"2422080","insp_unit_license":"PWZ8797","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN7RL662337","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-11-01T09:46:57.000000Z","updated_at":"2025-11-02T10:45:28.000000Z"}]},{"id":8860198,"change_date":"2025-06-10 21:40:00","inspection_id":"84910490","dot_number":"354815","report_state":"NY","report_number":"D507901468","insp_date":"2025-06-10 00:00:00","insp_start_time":"1046","insp_end_time":"1106","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LOCKPORT NY","county_code_state":"NY","county_code":"063","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":"U","pen_cen_match":"I","final_status_date":"2025-06-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1846025","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-06-10 21:40:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-10 21:40:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:43.000000Z","updated_at":"2025-06-14T10:00:43.000000Z","inspection_violations":[{"id":14192600,"change_date":"2025-06-10 21:40:00","inspection_id":"84910490","insp_violation_id":"266757470","seq_no":"1","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"207308676","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-13T10:16:46.000000Z","updated_at":"2025-06-14T10:15:39.000000Z","normalized_code":"3963A1F"}],"inspection_per_units":[{"id":14509445,"change_date":"2025-06-10 21:40:00","inspection_id":"84910490","insp_unit_id":"207308676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PWZ9805","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN9RL662338","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:41.000000Z","updated_at":"2025-06-14T09:45:26.000000Z"}]},{"id":8390909,"change_date":"2025-04-16 21:41:00","inspection_id":"84415288","dot_number":"354815","report_state":"NY","report_number":"D507901308","insp_date":"2025-04-11 00:00:00","insp_start_time":"1016","insp_end_time":"1031","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MAYVILLE NY","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":"U","pen_cen_match":"I","final_status_date":"2025-04-16 21:41: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":"1603383","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:19:17.000000Z","updated_at":"2025-04-20T10:24:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13620585,"change_date":"2025-04-16 21:41:00","inspection_id":"84415288","insp_unit_id":"206340708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PXB0845","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMMN5SS082860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:06:46.000000Z","updated_at":"2025-04-20T09:56:26.000000Z"}]},{"id":8273066,"change_date":"2025-04-02 21:41:00","inspection_id":"84291259","dot_number":"354815","report_state":"NY","report_number":"5L42000655","insp_date":"2025-03-31 00:00:00","insp_start_time":"1424","insp_end_time":"1501","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GENESEO NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","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":"2025-04-02 21:41: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1544261","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-03-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:36.000000Z","updated_at":"2025-04-06T10:23:36.000000Z","inspection_violations":[{"id":13001929,"change_date":"2025-04-02 21:41:00","inspection_id":"84291259","insp_violation_id":"265393036","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"206113733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-04T11:02:42.000000Z","updated_at":"2025-04-05T10:37:16.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":13391685,"change_date":"2025-04-02 21:41:00","inspection_id":"84291259","insp_unit_id":"206113733","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"122221","insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:07:55.000000Z","updated_at":"2025-04-06T09:54:59.000000Z"}]},{"id":8273166,"change_date":"2025-04-02 21:41:00","inspection_id":"84291361","dot_number":"354815","report_state":"NY","report_number":"D507801349","insp_date":"2025-03-28 00:00:00","insp_start_time":"0911","insp_end_time":"0936","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SILVER CREEK NY","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":"U","pen_cen_match":"I","final_status_date":"2025-04-02 21:41: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":"1544353","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:36.000000Z","updated_at":"2025-04-06T10:23:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13391826,"change_date":"2025-04-02 21:41:00","inspection_id":"84291361","insp_unit_id":"206113888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"2522815","insp_unit_license":"PXB0845","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMMN5SS082860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:07:55.000000Z","updated_at":"2025-04-06T09:55:01.000000Z"}]},{"id":8040855,"change_date":"2025-03-06 21:39:00","inspection_id":"84046681","dot_number":"354815","report_state":"NY","report_number":"SPT3080468","insp_date":"2025-02-27 00:00:00","insp_start_time":"1040","insp_end_time":"1057","registration_date":null,"region":"ES","ci_status_code":"C","location":"30876M","location_desc":"WATERLOO NY","county_code_state":"NY","county_code":"099","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":"2025-03-06 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":"1435048","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-03-06 21:39:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:21.000000Z","updated_at":"2025-03-17T21:05:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12981594,"change_date":"2025-03-06 21:39:00","inspection_id":"84046681","insp_unit_id":"205653437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"081","insp_unit_license":"PWZ9805","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMMN9RL662338","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:25.000000Z","updated_at":"2025-03-17T23:58:25.000000Z"}]},{"id":7942069,"change_date":"2025-02-24 21:39:00","inspection_id":"83943012","dot_number":"354815","report_state":"NY","report_number":"D507801246","insp_date":"2025-02-20 00:00:00","insp_start_time":"1350","insp_end_time":"1425","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BUFFALO NY","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":"U","pen_cen_match":"I","final_status_date":"2025-02-24 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":"1394481","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-02-24 21:39:00","snet_input_date":"2025-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-24 21:39:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:13.000000Z","updated_at":"2025-03-17T21:03:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12820846,"change_date":"2025-02-24 21:39:00","inspection_id":"83943012","insp_unit_id":"205463072","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"022925","insp_unit_license":"PWL9960","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACXFC0LDMD1424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:39.000000Z","updated_at":"2025-03-17T23:56:39.000000Z"}]},{"id":7691264,"change_date":"2025-01-23 21:38:00","inspection_id":"83679541","dot_number":"354815","report_state":"NY","report_number":"D306100872","insp_date":"2025-01-23 00:00:00","insp_start_time":"1001","insp_end_time":"1040","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"VAN ETTEN NY","county_code_state":"NY","county_code":"015","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":"U","pen_cen_match":"I","final_status_date":"2025-01-23 21:38: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1279791","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2025-01-23 21:38:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-23 21:38:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:54.000000Z","updated_at":"2025-03-17T20:57:54.000000Z","inspection_violations":[{"id":12017914,"change_date":"2025-01-23 21:38:00","inspection_id":"83679541","insp_violation_id":"264138900","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204971205","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:32.000000Z","updated_at":"2025-03-17T22:04:32.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":12410989,"change_date":"2025-01-23 21:38:00","inspection_id":"83679541","insp_unit_id":"204971205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"122221","insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:58.000000Z","updated_at":"2025-03-17T23:51:58.000000Z"}]},{"id":7291781,"change_date":"2024-11-27 21:39:00","inspection_id":"83259806","dot_number":"354815","report_state":"NY","report_number":"D507101099","insp_date":"2024-11-26 00:00:00","insp_start_time":"1113","insp_end_time":"1133","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BUFFALO NY","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":"U","pen_cen_match":"I","final_status_date":"2024-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099537","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:10.000000Z","updated_at":"2025-03-17T20:48:10.000000Z","inspection_violations":[{"id":11401710,"change_date":"2024-11-27 21:39:00","inspection_id":"83259806","insp_violation_id":"263122201","seq_no":"1","part_no":"393","part_no_section":"47A-BCFSBD-SA","insp_viol_unit":"1","insp_unit_id":"204082165","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39347ABCFSBDSA"},{"id":11401711,"change_date":"2024-11-27 21:39:00","inspection_id":"83259806","insp_violation_id":"263122202","seq_no":"2","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"204082165","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":11762046,"change_date":"2024-11-27 21:39:00","inspection_id":"83259806","insp_unit_id":"204082165","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"925","insp_unit_license":"PWL9960","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXFC0LDMD1424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:55.000000Z","updated_at":"2025-03-17T23:44:55.000000Z"}]},{"id":5826846,"change_date":"2024-05-23 21:41:00","inspection_id":"81694528","dot_number":"354815","report_state":"NY","report_number":"SPD0292160","insp_date":"2024-05-22 00:00:00","insp_start_time":"1201","insp_end_time":"1222","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN MILLS DISTRIBUTING CO INC","shipping_paper_number":"01324851","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2925870","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:15.000000Z","updated_at":"2025-03-17T20:18:15.000000Z","inspection_violations":[{"id":9028241,"change_date":"2024-05-23 21:41:00","inspection_id":"81694528","insp_violation_id":"259692317","seq_no":"1","part_no":"390","part_no_section":"21(e)","insp_viol_unit":"1","insp_unit_id":"201052565","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"39021E"},{"id":9028242,"change_date":"2024-05-23 21:41:00","inspection_id":"81694528","insp_violation_id":"259692318","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201052565","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9384127,"change_date":"2024-05-23 21:41:00","inspection_id":"81694528","insp_unit_id":"201052565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2422080","insp_unit_license":"PWZ8797","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN7RL662337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:24.000000Z","updated_at":"2025-03-17T23:20:24.000000Z"}]},{"id":5212842,"change_date":"2024-03-05 21:40:00","inspection_id":"81025313","dot_number":"354815","report_state":"NY","report_number":"SPE0321558","insp_date":"2024-03-04 00:00:00","insp_start_time":"0944","insp_end_time":"1008","registration_date":null,"region":"ET","ci_status_code":"C","location":"30494","location_desc":"T\/MACEDON","county_code_state":"NY","county_code":"117","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"J MILLS","shipping_paper_number":"390002","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-05 21:40: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":"2910723","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2024-03-05 21:40:00","snet_input_date":"2024-03-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-05 21:40:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:46.000000Z","updated_at":"2025-03-17T20:05:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8393730,"change_date":"2024-03-05 21:40:00","inspection_id":"81025313","insp_unit_id":"199757061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"722679","insp_unit_license":"PWD5484","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVACXDT7HHH6364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:02.000000Z","updated_at":"2025-03-17T23:11:02.000000Z"}]},{"id":5085796,"change_date":"2024-02-20 21:41:00","inspection_id":"80887119","dot_number":"354815","report_state":"NY","report_number":"SPE0340556","insp_date":"2024-02-19 00:00:00","insp_start_time":"1328","insp_end_time":"1353","registration_date":null,"region":"ET","ci_status_code":"C","location":"40320","location_desc":"GENESEO","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CROSBY'S","shipping_paper_number":"388552","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2908242","transaction_code":"A","transaction_date":"2024-02-19 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:27.000000Z","updated_at":"2025-03-17T20:03:27.000000Z","inspection_violations":[{"id":7840396,"change_date":"2024-02-20 21:41:00","inspection_id":"80887119","insp_violation_id":"257918297","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199494730","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39378"},{"id":7840397,"change_date":"2024-02-20 21:41:00","inspection_id":"80887119","insp_violation_id":"257918298","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199494730","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8187423,"change_date":"2024-02-20 21:41:00","inspection_id":"80887119","insp_unit_id":"199494730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"221","insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:12.000000Z","updated_at":"2025-03-17T23:09:12.000000Z"}]},{"id":4995679,"change_date":"2024-02-07 21:40:00","inspection_id":"80788600","dot_number":"354815","report_state":"NY","report_number":"D507800313","insp_date":"2024-02-05 00:00:00","insp_start_time":"1232","insp_end_time":"1315","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"VARYSBURG NY","county_code_state":"NY","county_code":"121","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":"2024-02-07 21:40: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":"226011","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2024-02-07 21:40:00","snet_input_date":"2024-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-07 21:40:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8040705,"change_date":"2024-02-07 21:40:00","inspection_id":"80788600","insp_unit_id":"199306837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"122223","insp_unit_license":"PWN9512","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN3ML816664","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4900578,"change_date":"2024-01-25 21:44:00","inspection_id":"80684479","dot_number":"354815","report_state":"NY","report_number":"SPE0302351","insp_date":"2024-01-16 00:00:00","insp_start_time":"1336","insp_end_time":"1351","registration_date":null,"region":"ET","ci_status_code":"C","location":"40930","location_desc":"YORK","county_code_state":"NY","county_code":"051","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":"N","pen_cen_match":null,"final_status_date":"2024-01-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2901895","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2024-01-25 21:44:00","snet_input_date":"2024-01-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-25 21:44:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:59.000000Z","updated_at":"2025-03-17T19:59:59.000000Z","inspection_violations":[{"id":7550728,"change_date":"2024-01-25 21:44:00","inspection_id":"80684479","insp_violation_id":"257491983","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:25.000000Z","updated_at":"2025-03-17T21:42:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7885410,"change_date":"2024-01-25 21:44:00","inspection_id":"80684479","insp_unit_id":"199105796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"122223","insp_unit_license":"PWN9512","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN3ML816664","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:29.000000Z","updated_at":"2025-03-17T23:06:29.000000Z"}]},{"id":4628331,"change_date":"2023-12-14 21:42:00","inspection_id":"80386926","dot_number":"354815","report_state":"NY","report_number":"SPE0321290","insp_date":"2023-12-13 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"40714","location_desc":"T\/RIGA","county_code_state":"NY","county_code":"055","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MILLS","shipping_paper_number":"38018","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-12-14 21:42: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":"2893331","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2023-12-14 21:42:00","snet_input_date":"2023-12-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-14 21:42:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:33.000000Z","updated_at":"2025-03-17T19:54:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7444016,"change_date":"2023-12-14 21:42:00","inspection_id":"80386926","insp_unit_id":"198501426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PWG2986","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACXFC0JDJV0774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:34.000000Z","updated_at":"2025-03-17T23:02:34.000000Z"}]},{"id":4608089,"change_date":"2023-12-12 21:41:00","inspection_id":"80364689","dot_number":"354815","report_state":"NY","report_number":"D507900185","insp_date":"2023-12-11 00:00:00","insp_start_time":"0816","insp_end_time":"0843","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LOCKPORT NY","county_code_state":"NY","county_code":"063","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":"2023-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","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":"126457","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2023-12-12 21:41:00","snet_input_date":"2023-12-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-12 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:11.000000Z","updated_at":"2025-03-17T19:54:11.000000Z","inspection_violations":[{"id":7125479,"change_date":"2023-12-12 21:41:00","inspection_id":"80364689","insp_violation_id":"256832818","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"198458419","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:26.000000Z","updated_at":"2025-03-17T21:40:26.000000Z","normalized_code":"3939ALIL"},{"id":7125480,"change_date":"2023-12-12 21:41:00","inspection_id":"80364689","insp_violation_id":"256832819","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"198458419","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:26.000000Z","updated_at":"2025-03-17T21:40:26.000000Z","normalized_code":"3939ALSML"},{"id":7125481,"change_date":"2023-12-12 21:41:00","inspection_id":"80364689","insp_violation_id":"256832820","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"198458419","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:26.000000Z","updated_at":"2025-03-17T21:40:26.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":7412023,"change_date":"2023-12-12 21:41:00","inspection_id":"80364689","insp_unit_id":"198458419","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PVZ2715","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACXDT7FDGM8919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:18.000000Z","updated_at":"2025-03-17T23:02:18.000000Z"}]},{"id":4503205,"change_date":"2023-11-28 21:41:00","inspection_id":"80249299","dot_number":"354815","report_state":"NY","report_number":"M603600010","insp_date":"2023-11-28 00:00:00","insp_start_time":"0905","insp_end_time":"0925","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BUFFALO NY","county_code_state":"NY","county_code":"029","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":"2023-11-28 21:41: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":"109400","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-11-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:10.000000Z","updated_at":"2025-03-17T19:52:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7242708,"change_date":"2023-11-28 21:41:00","inspection_id":"80249299","insp_unit_id":"198232205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"122222","insp_unit_license":"PWN9607","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN5ML770142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4280064,"change_date":"2023-10-25 21:41:00","inspection_id":"80003058","dot_number":"354815","report_state":"NY","report_number":"SPG0215040","insp_date":"2023-10-18 00:00:00","insp_start_time":"1105","insp_end_time":"1124","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117A","location_desc":"CAMPBELL (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN MILLS","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-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2882096","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:49.000000Z","updated_at":"2025-03-17T19:47:49.000000Z","inspection_violations":[{"id":6620832,"change_date":"2023-10-25 21:41:00","inspection_id":"80003058","insp_violation_id":"256031918","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"197736275","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:55.000000Z","updated_at":"2025-03-17T21:37:55.000000Z","normalized_code":"39348A"},{"id":6620833,"change_date":"2023-10-25 21:41:00","inspection_id":"80003058","insp_violation_id":"256031919","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197736275","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:55.000000Z","updated_at":"2025-03-17T21:37:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6883311,"change_date":"2023-10-25 21:41:00","inspection_id":"80003058","insp_unit_id":"197736275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PWD5484","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVACXDT7HHHX6364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:42.000000Z","updated_at":"2025-03-17T22:57:42.000000Z"}]},{"id":4200289,"change_date":"2023-10-16 21:42:00","inspection_id":"79914885","dot_number":"354815","report_state":"NY","report_number":"SPA0350394","insp_date":"2023-10-12 00:00:00","insp_start_time":"0909","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"40310","location_desc":"SR 104 PARKING AREA GAINES","county_code_state":"NY","county_code":"073","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MILLS","shipping_paper_number":"00373288","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-10-16 21:42: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":"2878745","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2023-10-16 21:42:00","snet_input_date":"2023-10-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-16 21:42:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:12.000000Z","updated_at":"2025-03-17T19:46:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6754735,"change_date":"2023-10-16 21:42:00","inspection_id":"79914885","insp_unit_id":"197562749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"477","insp_unit_license":"PWG2986","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACXFC0JDJV0774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:37.000000Z","updated_at":"2025-03-17T22:56:37.000000Z"}]},{"id":3605642,"change_date":"2023-07-27 21:40:00","inspection_id":"79252568","dot_number":"354815","report_state":"NY","report_number":"0510024622","insp_date":"2023-07-26 00:00:00","insp_start_time":"0821","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"42048","location_desc":"ROCHESTER","county_code_state":"NY","county_code":"055","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":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2851977","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[{"id":5559912,"change_date":"2023-07-27 21:40:00","inspection_id":"79252568","insp_violation_id":"254307838","seq_no":"1","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"196219413","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"393207C"}],"inspection_per_units":[{"id":5797209,"change_date":"2023-07-27 21:40:00","inspection_id":"79252568","insp_unit_id":"196219413","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"477","insp_unit_license":"PWG2986","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACXFC0JDJV0774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3481478,"change_date":"2023-07-11 21:42:00","inspection_id":"79113485","dot_number":"354815","report_state":"PA","report_number":"E951319137","insp_date":"2023-07-10 00:00:00","insp_start_time":"1337","insp_end_time":"1409","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"361606","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-11 21:42: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":"2363741","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-07-10 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:02.000000Z","updated_at":"2025-03-17T19:32:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5598440,"change_date":"2023-07-11 21:42:00","inspection_id":"79113485","insp_unit_id":"195940482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"722680","insp_unit_license":"PWD5485","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVACXDT9HHHX6365","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:11.000000Z","updated_at":"2025-03-17T22:47:11.000000Z"}]},{"id":3340069,"change_date":"2023-06-22 21:41:00","inspection_id":"78954359","dot_number":"354815","report_state":"NY","report_number":"SPA0275259","insp_date":"2023-06-07 00:00:00","insp_start_time":"1430","insp_end_time":"1446","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","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":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:41: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":"2839274","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:18.000000Z","updated_at":"2025-03-17T19:29:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5369516,"change_date":"2023-06-22 21:41:00","inspection_id":"78954359","insp_unit_id":"195617895","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"122221","insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:21.000000Z","updated_at":"2025-03-17T22:45:21.000000Z"}]},{"id":2805537,"change_date":"2023-04-14 21:41:00","inspection_id":"78350451","dot_number":"354815","report_state":"NY","report_number":"SPD0224899","insp_date":"2023-04-11 00:00:00","insp_start_time":"1109","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"30849","location_desc":"VAN BUREN (EXIT 39)","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN MILLS DISTRIBUTING CO INC","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-04-14 21:41: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":"2815887","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":null,"census_search_date":"2023-04-14 21:41:00","snet_input_date":"2023-04-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-14 21:41:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:29.000000Z","updated_at":"2025-03-17T19:18:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4515096,"change_date":"2023-04-14 21:41:00","inspection_id":"78350451","insp_unit_id":"194388161","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"477","insp_unit_license":"PWG2986","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACXFC0JDJV774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:36.000000Z","updated_at":"2025-03-17T22:38:36.000000Z"}]},{"id":2549541,"change_date":"2023-03-10 21:40:00","inspection_id":"78058916","dot_number":"354815","report_state":"NY","report_number":"SPA0304462","insp_date":"2023-02-22 00:00:00","insp_start_time":"1407","insp_end_time":"1424","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","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-03-10 21:40: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":"2805366","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":"00354815","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":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","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":4103606,"change_date":"2023-03-10 21:40:00","inspection_id":"78058916","insp_unit_id":"193805522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"122221","insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":1411237,"change_date":"2022-09-30 21:39:00","inspection_id":"76755821","dot_number":"354815","report_state":"NY","report_number":"SPE0215568","insp_date":"2022-09-29 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504A","location_desc":"MANCHESTER","county_code_state":"NY","county_code":"069","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":"N","pen_cen_match":null,"final_status_date":"2022-09-30 21:39: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":"2754585","transaction_code":"A","transaction_date":"2022-09-30 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2022-09-30 21:39:00","snet_input_date":"2022-09-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-30 21:39:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:42.000000Z","updated_at":"2025-03-17T18:52:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2271794,"change_date":"2022-09-30 21:39:00","inspection_id":"76755821","insp_unit_id":"191198699","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PVZ2715","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALACWDT9EDFX9997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:33.000000Z","updated_at":"2025-03-17T22:22:33.000000Z"}]},{"id":1003523,"change_date":"2022-08-10 21:39:00","inspection_id":"76281434","dot_number":"354815","report_state":"NY","report_number":"SPT0365054","insp_date":"2022-08-09 00:00:00","insp_start_time":"1335","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"50370","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":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2737371","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2022-08-10 21:39:00","snet_input_date":"2022-08-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:24.000000Z","updated_at":"2025-03-17T18:45:24.000000Z","inspection_violations":[{"id":1580713,"change_date":"2022-08-10 21:39:00","inspection_id":"76281434","insp_violation_id":"247620645","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190228075","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:28.000000Z","updated_at":"2025-03-17T21:14:28.000000Z","normalized_code":"39345B2"},{"id":1580714,"change_date":"2022-08-10 21:39:00","inspection_id":"76281434","insp_violation_id":"247620646","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190228075","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:28.000000Z","updated_at":"2025-03-17T21:14:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1614331,"change_date":"2022-08-10 21:39:00","inspection_id":"76281434","insp_unit_id":"190228075","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"522859","insp_unit_license":"PVY2035","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAMMMMN1FL508391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:09.000000Z","updated_at":"2025-03-17T22:18:09.000000Z"}]},{"id":334416,"change_date":"2022-05-06 21:38:00","inspection_id":"75491893","dot_number":"354815","report_state":"NY","report_number":"SPE0282136","insp_date":"2022-05-05 00:00:00","insp_start_time":"1345","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"30841","location_desc":"TYRE","county_code_state":"NY","county_code":"099","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"J MILLS DISTRIBUTING","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-06 21:38: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":"2703855","transaction_code":"A","transaction_date":"2022-05-06 00:00:00","upload_date":"2022-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00354815","upload_search_indicator":"M","census_search_date":"2022-05-06 21:38:00","snet_input_date":"2022-05-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-06 21:38:00","insp_carrier_name":"JOHN MILLS DISTRIBUTING CO INC","insp_carrier_street":"3360 BENZING RD","insp_carrier_city":"ORCHARD PARK","insp_carrier_state":"NY","insp_carrier_zip_code":"14127","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:21.000000Z","updated_at":"2025-03-17T18:33:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":540909,"change_date":"2022-05-06 21:38:00","inspection_id":"75491893","insp_unit_id":"188542040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"122221","insp_unit_license":"PWN9720","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMMN2ML751967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:32.000000Z","updated_at":"2025-03-17T22:11:32.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/354815\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/354815\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/354815\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/354815\/inspections","per_page":100,"prev_page_url":null,"to":31,"total":31}