{"current_page":1,"data":[{"id":12432448,"change_date":"2026-07-13 21:39:00","inspection_id":"88391515","dot_number":"2400757","report_state":"NY","report_number":"SPB3022092","insp_date":"2026-07-07 00:00:00","insp_start_time":"0839","insp_end_time":"0856","registration_date":null,"region":"ED","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCDONALDS","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-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"3739360","transaction_code":"A","transaction_date":"2026-07-13 00:00:00","upload_date":"2026-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-07-13 21:39:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-13 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-16T09:40:27.000000Z","updated_at":"2026-07-24T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21596717,"change_date":"2026-07-13 21:39:00","inspection_id":"88391515","insp_unit_id":"214580755","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5418","insp_unit_license":"25712PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1PN310941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:16:55.000000Z","updated_at":"2026-07-24T09:01:54.000000Z"},{"id":21596718,"change_date":"2026-07-13 21:39:00","inspection_id":"88391515","insp_unit_id":"214580756","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSF6450","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532S6353002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:16:55.000000Z","updated_at":"2026-07-24T09:01:54.000000Z"}]},{"id":12254511,"change_date":"2026-06-23 21:38:00","inspection_id":"88213007","dot_number":"2400757","report_state":"NY","report_number":"SPC3061337","insp_date":"2026-06-16 00:00:00","insp_start_time":"1048","insp_end_time":"1110","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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":"U","pen_cen_match":"I","final_status_date":"2026-06-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"3597120","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-06-23 21:38:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-23 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-26T09:40:41.000000Z","updated_at":"2026-07-04T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21280472,"change_date":"2026-06-23 21:38:00","inspection_id":"88213007","insp_unit_id":"214232766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5418","insp_unit_license":"25712PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1PN310941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:16:59.000000Z","updated_at":"2026-07-05T09:03:09.000000Z"},{"id":21280473,"change_date":"2026-06-23 21:38:00","inspection_id":"88213007","insp_unit_id":"214232767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"532523","insp_unit_license":"TSG7232","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GR1A0620TB812598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:16:59.000000Z","updated_at":"2026-07-05T09:03:09.000000Z"}]},{"id":11992226,"change_date":"2026-05-22 21:38:00","inspection_id":"87930135","dot_number":"2400757","report_state":"NY","report_number":"SPE3021328","insp_date":"2026-05-15 00:00:00","insp_start_time":"1248","insp_end_time":"1322","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BERGEN NY","county_code_state":"NY","county_code":"037","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE ANDERSON DUBOSE COMPANY","shipping_paper_number":"ROUTE F 659","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-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"3381916","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:10.000000Z","updated_at":"2026-06-02T09:31:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20847870,"change_date":"2026-05-22 21:38:00","inspection_id":"87930135","insp_unit_id":"213702372","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"469921","insp_unit_license":"3568858","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EHXSN671282","insp_unit_decal":"Y","insp_unit_decal_number":"36371329","created_at":"2026-05-25T09:19:11.000000Z","updated_at":"2026-06-02T09:04:55.000000Z"},{"id":20847871,"change_date":"2026-05-22 21:38:00","inspection_id":"87930135","insp_unit_id":"213702373","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"532522","insp_unit_license":"TSG7230","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GR1A0629TB812597","insp_unit_decal":"Y","insp_unit_decal_number":"36371330","created_at":"2026-05-25T09:19:11.000000Z","updated_at":"2026-06-02T09:04:55.000000Z"}]},{"id":11893243,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","dot_number":"2400757","report_state":"NY","report_number":"D507802389","insp_date":"2026-05-07 00:00:00","insp_start_time":"1645","insp_end_time":"1752","registration_date":"2026-05-12 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"GENEVA NY","county_code_state":"NY","county_code":"069","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":"2026-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3311037","transaction_code":"C","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-05-13 21:41:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:49.000000Z","updated_at":"2026-05-25T09:30:21.000000Z","inspection_violations":[{"id":20687254,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","insp_violation_id":"274243155","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"213540144","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:48.000000Z","updated_at":"2026-05-25T09:41:50.000000Z","normalized_code":"39345B2BAIR"},{"id":20687255,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","insp_violation_id":"274243156","seq_no":"2","part_no":"393","part_no_section":"47B-BMBCBD","insp_viol_unit":"2","insp_unit_id":"213540144","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:48.000000Z","updated_at":"2026-05-25T09:41:50.000000Z","normalized_code":"39347BBMBCBD"},{"id":20687256,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","insp_violation_id":"274243157","seq_no":"3","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"213540144","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:48.000000Z","updated_at":"2026-05-25T09:41:50.000000Z","normalized_code":"39348ABMBCBD"},{"id":20687257,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","insp_violation_id":"274243158","seq_no":"4","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"213540144","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:58:48.000000Z","updated_at":"2026-05-25T09:41:50.000000Z","normalized_code":"39348ABMBCBD"}],"inspection_per_units":[{"id":20678019,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","insp_unit_id":"213540144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407003","insp_unit_license":"TSE1496","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6579902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:26.000000Z","updated_at":"2026-05-25T09:02:26.000000Z"},{"id":20678018,"change_date":"2026-05-14 21:42:00","inspection_id":"87831532","insp_unit_id":"213540143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"469921","insp_unit_license":"3568858","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EHXSN671282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:13:26.000000Z","updated_at":"2026-05-25T09:02:26.000000Z"}]},{"id":11786523,"change_date":"2026-04-30 21:40:00","inspection_id":"87718044","dot_number":"2400757","report_state":"NY","report_number":"SPC3051599","insp_date":"2026-04-23 00:00:00","insp_start_time":"0916","insp_end_time":"0930","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585W","location_desc":"OWEGO NY","county_code_state":"NY","county_code":"107","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADR NY DIST 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-04-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"3233052","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-04-30 21:40:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-30 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:45.000000Z","updated_at":"2026-05-11T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20503752,"change_date":"2026-04-30 21:40:00","inspection_id":"87718044","insp_unit_id":"213301030","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8406196","insp_unit_license":"TSC5085","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530L6081602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:22.000000Z","updated_at":"2026-05-11T09:02:14.000000Z"},{"id":20503751,"change_date":"2026-04-30 21:40:00","inspection_id":"87718044","insp_unit_id":"213301029","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"469982","insp_unit_license":"3906768","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH8SN670096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:22.000000Z","updated_at":"2026-05-11T09:02:14.000000Z"}]},{"id":11435808,"change_date":"2026-03-22 21:34:00","inspection_id":"87352400","dot_number":"2400757","report_state":"NY","report_number":"D306001993","insp_date":"2026-03-16 00:00:00","insp_start_time":"0825","insp_end_time":"0848","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585W","location_desc":"OWEGO NY","county_code_state":"NY","county_code":"107","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-03-22 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"3037877","transaction_code":"A","transaction_date":"2026-03-22 00:00:00","upload_date":"2026-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-03-22 21:34:00","snet_input_date":"2026-03-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-22 21:34:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-25T09:41:24.000000Z","updated_at":"2026-04-02T09:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19590605,"change_date":"2026-03-22 21:34:00","inspection_id":"87352400","insp_unit_id":"212257401","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"469921","insp_unit_license":"3568858","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EHXSN671282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-25T09:18:17.000000Z","updated_at":"2026-04-02T09:04:09.000000Z"},{"id":19590606,"change_date":"2026-03-22 21:34:00","inspection_id":"87352400","insp_unit_id":"212257402","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"TSF7220","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539L6081601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-25T09:18:17.000000Z","updated_at":"2026-04-02T09:04:09.000000Z"}]},{"id":11262648,"change_date":"2026-03-02 21:37:00","inspection_id":"87176514","dot_number":"2400757","report_state":"NY","report_number":"D305401369","insp_date":"2026-02-27 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"ES","ci_status_code":"C","location":"30223A","location_desc":"EAST SYRACUSE NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"THE ANDERSON DUBOSE COMPANY","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":"U","pen_cen_match":"I","final_status_date":"2026-03-02 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2950211","transaction_code":"A","transaction_date":"2026-03-01 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-03-02 21:37:00","snet_input_date":"2026-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-02 21:37:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:38:50.000000Z","updated_at":"2026-03-13T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19258100,"change_date":"2026-03-02 21:37:00","inspection_id":"87176514","insp_unit_id":"211910901","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"486258","insp_unit_license":"3757445","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH1SN670554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:39.000000Z","updated_at":"2026-03-13T09:04:58.000000Z"},{"id":19258101,"change_date":"2026-03-02 21:37:00","inspection_id":"87176514","insp_unit_id":"211910902","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"532517","insp_unit_license":"TSG7227","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1GR1A0621TB812593","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:39.000000Z","updated_at":"2026-03-13T09:04:58.000000Z"}]},{"id":10622742,"change_date":"2026-01-12 21:38:00","inspection_id":"86763241","dot_number":"2400757","report_state":"NY","report_number":"SPD3081511","insp_date":"2026-01-06 00:00:00","insp_start_time":"0740","insp_end_time":"0755","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","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-01-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2753429","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-01-12 21:38:00","snet_input_date":"2026-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-12 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-15T10:36:53.000000Z","updated_at":"2026-01-23T10:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17811035,"change_date":"2026-01-12 21:38:00","inspection_id":"86763241","insp_unit_id":"211022168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5367","insp_unit_license":"82887PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN269947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:50.000000Z","updated_at":"2026-01-24T10:00:40.000000Z"},{"id":17811036,"change_date":"2026-01-12 21:38:00","inspection_id":"86763241","insp_unit_id":"211022169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSF6450","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532S6353002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:50.000000Z","updated_at":"2026-01-24T10:00:40.000000Z"}]},{"id":10631790,"change_date":"2026-01-13 21:39:00","inspection_id":"86772685","dot_number":"2400757","report_state":"NY","report_number":"SPD3021463","insp_date":"2026-01-06 00:00:00","insp_start_time":"0950","insp_end_time":"1003","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADR NY DIST 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-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"2756153","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:35:58.000000Z","updated_at":"2026-01-24T10:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17831963,"change_date":"2026-01-13 21:39:00","inspection_id":"86772685","insp_unit_id":"211042814","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"4651","insp_unit_license":"30156PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH4PN617827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:34.000000Z","updated_at":"2026-01-24T10:01:45.000000Z"},{"id":17831964,"change_date":"2026-01-13 21:39:00","inspection_id":"86772685","insp_unit_id":"211042815","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8110080","insp_unit_license":"TSE8465","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2535R6094001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:34.000000Z","updated_at":"2026-01-24T10:01:45.000000Z"}]},{"id":10404875,"change_date":"2025-12-11 21:44:00","inspection_id":"86535281","dot_number":"2400757","report_state":"NY","report_number":"SPE3090918","insp_date":"2025-12-04 00:00:00","insp_start_time":"1322","insp_end_time":"1340","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"COLONIE NY","county_code_state":"NY","county_code":"001","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-12-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2641302","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-12-11 21:44:00","snet_input_date":"2025-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-11 21:44:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:39.000000Z","updated_at":"2025-12-15T10:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17401248,"change_date":"2025-12-11 21:44:00","inspection_id":"86535281","insp_unit_id":"210541583","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:53.000000Z","updated_at":"2025-12-15T10:00:40.000000Z"},{"id":17401249,"change_date":"2025-12-11 21:44:00","inspection_id":"86535281","insp_unit_id":"210541584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8400240","insp_unit_license":"TSC9933","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532N6564902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:01:53.000000Z","updated_at":"2025-12-15T10:00:40.000000Z"}]},{"id":10382973,"change_date":"2026-01-02 21:35:00","inspection_id":"86512378","dot_number":"2400757","report_state":"NY","report_number":"SPC3051187","insp_date":"2025-12-02 00:00:00","insp_start_time":"1024","insp_end_time":"1052","registration_date":"2026-01-01 00:00:00","region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ANDERSONDUBOSE COMPANY","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-12-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"2632112","transaction_code":"C","transaction_date":"2025-12-08 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-12-09 21:38:00","snet_input_date":"2025-12-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-09 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-12T10:31:27.000000Z","updated_at":"2026-01-13T10:30:06.000000Z","inspection_violations":[{"id":17725889,"change_date":"2026-01-02 21:35:00","inspection_id":"86512378","insp_violation_id":"270983824","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"210882186","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:36:55.000000Z","updated_at":"2026-01-13T10:30:17.000000Z","normalized_code":"39021TB1MC"},{"id":17725890,"change_date":"2026-01-02 21:35:00","inspection_id":"86512378","insp_violation_id":"270983825","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210882186","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:36:55.000000Z","updated_at":"2026-01-13T10:30:17.000000Z","normalized_code":"39345B2BAIR"},{"id":17725891,"change_date":"2026-01-02 21:35:00","inspection_id":"86512378","insp_violation_id":"270983826","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"210882186","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:36:55.000000Z","updated_at":"2026-01-13T10:30:17.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":17679386,"change_date":"2026-01-02 21:35:00","inspection_id":"86512378","insp_unit_id":"210882186","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5418","insp_unit_license":"25712PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1PN310941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:01.000000Z","updated_at":"2026-01-13T10:00:08.000000Z"},{"id":17679387,"change_date":"2026-01-02 21:35:00","inspection_id":"86512378","insp_unit_id":"210882187","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8400240","insp_unit_license":"TSC9933","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532N6564902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:01.000000Z","updated_at":"2026-01-13T10:00:08.000000Z"}]},{"id":10382616,"change_date":"2025-12-09 21:38:00","inspection_id":"86512005","dot_number":"2400757","report_state":"NY","report_number":"SPD3061298","insp_date":"2025-12-02 00:00:00","insp_start_time":"0952","insp_end_time":"1020","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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-12-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2631178","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-12-09 21:38:00","snet_input_date":"2025-12-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-09 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-12T10:31:26.000000Z","updated_at":"2025-12-13T10:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17356876,"change_date":"2025-12-09 21:38:00","inspection_id":"86512005","insp_unit_id":"210487799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:22.000000Z","updated_at":"2025-12-13T10:00:09.000000Z"},{"id":17356877,"change_date":"2025-12-09 21:38:00","inspection_id":"86512005","insp_unit_id":"210487800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSE8465","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2535R6094001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:22.000000Z","updated_at":"2025-12-13T10:00:09.000000Z"}]},{"id":10274729,"change_date":"2025-11-24 21:38:00","inspection_id":"86399138","dot_number":"2400757","report_state":"NY","report_number":"D305401120","insp_date":"2025-11-20 00:00:00","insp_start_time":"0850","insp_end_time":"0905","registration_date":null,"region":"ES","ci_status_code":"C","location":"20026","location_desc":"TABERG NY","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"THE ANDERSON DUBOSE COMPANY","shipping_paper_number":"ELECTRONIC","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-11-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2580647","transaction_code":"A","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-11-24 21:38:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-24 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:31.000000Z","updated_at":"2025-11-28T10:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17148310,"change_date":"2025-11-24 21:38:00","inspection_id":"86399138","insp_unit_id":"210224426","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5367","insp_unit_license":"82887PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN269947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:30.000000Z","updated_at":"2025-11-28T10:00:23.000000Z"},{"id":17148311,"change_date":"2025-11-24 21:38:00","inspection_id":"86399138","insp_unit_id":"210224427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407004","insp_unit_license":"TSE1497","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532N6579903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:30.000000Z","updated_at":"2025-11-28T10:00:23.000000Z"}]},{"id":10159563,"change_date":"2025-11-10 21:38:00","inspection_id":"86278220","dot_number":"2400757","report_state":"NY","report_number":"SPT3081161","insp_date":"2025-11-03 00:00:00","insp_start_time":"1131","insp_end_time":"1152","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HENRIETTA NY","county_code_state":"NY","county_code":"055","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":"2025-11-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2522856","transaction_code":"A","transaction_date":"2025-11-09 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-11-10 21:38:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-10 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:28.000000Z","updated_at":"2025-11-14T10:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16914761,"change_date":"2025-11-10 21:38:00","inspection_id":"86278220","insp_unit_id":"209930884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5368","insp_unit_license":"44734PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN269948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:31.000000Z","updated_at":"2025-11-14T10:00:14.000000Z"},{"id":16914762,"change_date":"2025-11-10 21:38:00","inspection_id":"86278220","insp_unit_id":"209930885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8405153","insp_unit_license":"TSF3418","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2533K6640302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:31.000000Z","updated_at":"2025-11-14T10:00:14.000000Z"}]},{"id":9702258,"change_date":"2025-09-17 21:40:00","inspection_id":"85796938","dot_number":"2400757","report_state":"NY","report_number":"D507005906","insp_date":"2025-09-16 00:00:00","insp_start_time":"1114","insp_end_time":"1127","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2287308","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:40.000000Z","updated_at":"2025-09-23T10:01:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16062157,"change_date":"2025-09-17 21:40:00","inspection_id":"85796938","insp_unit_id":"208992760","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"4649","insp_unit_license":"36837PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH2PN617857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:46.000000Z","updated_at":"2025-09-21T09:45:17.000000Z"},{"id":16062158,"change_date":"2025-09-17 21:40:00","inspection_id":"85796938","insp_unit_id":"208992761","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"8405157","insp_unit_license":"TSE1403","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539K6640403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:46.000000Z","updated_at":"2025-09-21T09:45:17.000000Z"}]},{"id":9601675,"change_date":"2025-09-05 21:39:00","inspection_id":"85691492","dot_number":"2400757","report_state":"NY","report_number":"5L49000078","insp_date":"2025-09-02 00:00:00","insp_start_time":"1739","insp_end_time":"1745","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GENEVA NY","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":"U","pen_cen_match":"I","final_status_date":"2025-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2225757","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:44.000000Z","updated_at":"2025-09-10T10:45:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15854872,"change_date":"2025-09-05 21:39:00","inspection_id":"85691492","insp_unit_id":"208765717","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5367","insp_unit_license":"82887PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN269947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:26.000000Z","updated_at":"2025-09-10T09:46:26.000000Z"},{"id":15854873,"change_date":"2025-09-05 21:39:00","inspection_id":"85691492","insp_unit_id":"208765718","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407004","insp_unit_license":"TSE1497","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532N6579903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:26.000000Z","updated_at":"2025-09-10T09:46:26.000000Z"}]},{"id":9210913,"change_date":"2025-08-21 21:40:00","inspection_id":"85280538","dot_number":"2400757","report_state":"NY","report_number":"SPE3080678","insp_date":"2025-07-15 00:00:00","insp_start_time":"1245","insp_end_time":"1313","registration_date":"2025-07-17 00:00:00","region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"2023341","transaction_code":"C","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-07-22 21:41:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:44.000000Z","updated_at":"2025-08-25T10:42:37.000000Z","inspection_violations":[{"id":15419870,"change_date":"2025-08-21 21:40:00","inspection_id":"85280538","insp_violation_id":"268153002","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"208501863","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-24T10:48:19.000000Z","updated_at":"2025-08-25T10:43:37.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":15610702,"change_date":"2025-08-21 21:40:00","inspection_id":"85280538","insp_unit_id":"208501862","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"4649","insp_unit_license":"36837PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH2PN617857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:33.000000Z","updated_at":"2025-08-25T09:45:08.000000Z"},{"id":15610703,"change_date":"2025-08-21 21:40:00","inspection_id":"85280538","insp_unit_id":"208501863","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSC5086","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532L6081603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:33.000000Z","updated_at":"2025-08-25T09:45:08.000000Z"}]},{"id":9200235,"change_date":"2025-07-21 21:40:00","inspection_id":"85269351","dot_number":"2400757","report_state":"NY","report_number":"SPC3050761","insp_date":"2025-07-14 00:00:00","insp_start_time":"1349","insp_end_time":"1405","registration_date":null,"region":"ED","ci_status_code":"C","location":"90473S","location_desc":"LISLE NY","county_code_state":"NY","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADR NY DIST LLC","shipping_paper_number":"226","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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2019518","transaction_code":"A","transaction_date":"2025-07-20 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-07-21 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-21 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:16.000000Z","updated_at":"2025-07-25T10:45:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15122283,"change_date":"2025-07-21 21:40:00","inspection_id":"85269351","insp_unit_id":"207973957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5334","insp_unit_license":"24074PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EHXLN266917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:29.000000Z","updated_at":"2025-07-25T09:45:28.000000Z"},{"id":15122284,"change_date":"2025-07-21 21:40:00","inspection_id":"85269351","insp_unit_id":"207973958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407002","insp_unit_license":"TSE1495","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539N6579901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:29.000000Z","updated_at":"2025-07-25T09:45:28.000000Z"}]},{"id":9108421,"change_date":"2025-10-07 21:40:00","inspection_id":"85172826","dot_number":"2400757","report_state":"NY","report_number":"SPT3040996","insp_date":"2025-07-03 00:00:00","insp_start_time":"1401","insp_end_time":"1422","registration_date":"2025-07-10 00:00:00","region":"ED","ci_status_code":"C","location":"50164M","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":"ANDERSON DUBOSE","shipping_paper_number":"ROUTE 527","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-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1970825","transaction_code":"C","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-07-10 21:38:00","snet_input_date":"2025-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-10 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:40.000000Z","updated_at":"2025-10-11T10:00:05.000000Z","inspection_violations":[{"id":16267029,"change_date":"2025-10-07 21:40:00","inspection_id":"85172826","insp_violation_id":"269143333","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209337143","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:07.000000Z","updated_at":"2025-10-11T10:15:09.000000Z","normalized_code":"3922SLLSR"},{"id":16267030,"change_date":"2025-10-07 21:40:00","inspection_id":"85172826","insp_violation_id":"269143334","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209337143","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:07.000000Z","updated_at":"2025-10-11T10:15:09.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":16375329,"change_date":"2025-10-07 21:40:00","inspection_id":"85172826","insp_unit_id":"209337143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:35.000000Z","updated_at":"2025-10-11T09:45:07.000000Z"},{"id":16375330,"change_date":"2025-10-07 21:40:00","inspection_id":"85172826","insp_unit_id":"209337144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSF8505","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6564901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:35.000000Z","updated_at":"2025-10-11T09:45:07.000000Z"}]},{"id":8685670,"change_date":"2025-05-20 21:40:00","inspection_id":"84725685","dot_number":"2400757","report_state":"NY","report_number":"SPE3020545","insp_date":"2025-05-13 00:00:00","insp_start_time":"1116","insp_end_time":"1132","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354S","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1752837","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-05-20 21:40:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-20 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:03:32.000000Z","updated_at":"2025-05-24T10:04:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14189476,"change_date":"2025-05-20 21:40:00","inspection_id":"84725685","insp_unit_id":"206959348","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5367","insp_unit_license":"82887PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN269947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:42.000000Z","updated_at":"2025-05-24T09:49:27.000000Z"},{"id":14189477,"change_date":"2025-05-20 21:40:00","inspection_id":"84725685","insp_unit_id":"206959349","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8707541","insp_unit_license":"TSF6449","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530S6353001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:42.000000Z","updated_at":"2025-05-24T09:49:27.000000Z"}]},{"id":8554753,"change_date":"2025-05-06 21:39:00","inspection_id":"84588066","dot_number":"2400757","report_state":"NY","report_number":"SPD3080657","insp_date":"2025-04-29 00:00:00","insp_start_time":"1219","insp_end_time":"1235","registration_date":null,"region":"ED","ci_status_code":"C","location":"60117M","location_desc":"CAMPBELL NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCDONALDS","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-05-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1688884","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-05-06 21:39:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-06 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:25:19.000000Z","updated_at":"2025-05-10T10:50:00.000000Z","inspection_violations":[{"id":13557839,"change_date":"2025-05-06 21:39:00","inspection_id":"84588066","insp_violation_id":"266023432","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"206656641","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T10:51:01.000000Z","updated_at":"2025-05-09T10:56:35.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":13913446,"change_date":"2025-05-06 21:39:00","inspection_id":"84588066","insp_unit_id":"206656641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5335","insp_unit_license":"81591PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN266918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:07:18.000000Z","updated_at":"2025-05-10T09:52:56.000000Z"},{"id":13913447,"change_date":"2025-05-06 21:39:00","inspection_id":"84588066","insp_unit_id":"206656642","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407006","insp_unit_license":"TSE1499","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2536N6579905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:07:18.000000Z","updated_at":"2025-05-10T09:52:56.000000Z"}]},{"id":8402188,"change_date":"2025-04-17 21:41:00","inspection_id":"84427180","dot_number":"2400757","report_state":"NY","report_number":"D507801430","insp_date":"2025-04-17 00:00:00","insp_start_time":"1118","insp_end_time":"1157","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MOUNT MORRIS NY","county_code_state":"NY","county_code":"051","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-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1609483","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:57.000000Z","updated_at":"2025-04-21T10:22:27.000000Z","inspection_violations":[{"id":13253859,"change_date":"2025-04-17 21:41:00","inspection_id":"84427180","insp_violation_id":"265679925","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"206362205","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-20T10:55:30.000000Z","updated_at":"2025-04-20T11:02:15.000000Z","normalized_code":"3939ALSLIWR"},{"id":13253860,"change_date":"2025-04-17 21:41:00","inspection_id":"84427180","insp_violation_id":"265679926","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"206362204","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:55:30.000000Z","updated_at":"2025-04-20T11:02:15.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":13639585,"change_date":"2025-04-17 21:41:00","inspection_id":"84427180","insp_unit_id":"206362204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5364","insp_unit_license":"82884PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH6LN269944","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:11:37.000000Z","updated_at":"2025-04-21T09:57:09.000000Z"},{"id":13639586,"change_date":"2025-04-17 21:41:00","inspection_id":"84427180","insp_unit_id":"206362205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8707541","insp_unit_license":"TSF6449","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530S6353001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:11:37.000000Z","updated_at":"2025-04-21T09:57:09.000000Z"}]},{"id":8398373,"change_date":"2025-04-17 21:41:00","inspection_id":"84423054","dot_number":"2400757","report_state":"NY","report_number":"SPD3010738","insp_date":"2025-04-10 00:00:00","insp_start_time":"0934","insp_end_time":"0950","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADR NY DIST 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-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"1605338","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:38.000000Z","updated_at":"2025-04-21T10:20:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13633350,"change_date":"2025-04-17 21:41:00","inspection_id":"84423054","insp_unit_id":"206354990","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"4649","insp_unit_license":"36837PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH2PN617857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:07:17.000000Z","updated_at":"2025-04-21T09:51:02.000000Z"},{"id":13633351,"change_date":"2025-04-17 21:41:00","inspection_id":"84423054","insp_unit_id":"206354991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSE8466","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2537R6094002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:07:17.000000Z","updated_at":"2025-04-21T09:51:02.000000Z"}]},{"id":8377264,"change_date":"2025-04-15 21:40:00","inspection_id":"84400887","dot_number":"2400757","report_state":"NY","report_number":"SPD3060610","insp_date":"2025-04-08 00:00:00","insp_start_time":"1254","insp_end_time":"1305","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","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-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"1595719","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-04-15 21:40:00","snet_input_date":"2025-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-15 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:25:42.000000Z","updated_at":"2025-04-19T10:14:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13595674,"change_date":"2025-04-15 21:40:00","inspection_id":"84400887","insp_unit_id":"206314524","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5418","insp_unit_license":"25712PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1PN310941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:07:23.000000Z","updated_at":"2025-04-19T09:51:07.000000Z"},{"id":13595675,"change_date":"2025-04-15 21:40:00","inspection_id":"84400887","insp_unit_id":"206314525","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8400239","insp_unit_license":"TSF8505","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6564901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:07:23.000000Z","updated_at":"2025-04-19T09:51:07.000000Z"}]},{"id":8130647,"change_date":"2025-03-17 21:40:00","inspection_id":"84141285","dot_number":"2400757","report_state":"NY","report_number":"SPE3060455","insp_date":"2025-03-10 00:00:00","insp_start_time":"1102","insp_end_time":"1117","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1479030","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-03-17 21:40:00","snet_input_date":"2025-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:17:43.000000Z","updated_at":"2025-03-21T10:17:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13130013,"change_date":"2025-03-17 21:40:00","inspection_id":"84141285","insp_unit_id":"205829132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5369","insp_unit_license":"82889PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH5LN269949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:51:26.000000Z","updated_at":"2025-03-21T09:59:28.000000Z"},{"id":13130014,"change_date":"2025-03-17 21:40:00","inspection_id":"84141285","insp_unit_id":"205829133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"6196","insp_unit_license":"TSC5085","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530L6081602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:51:26.000000Z","updated_at":"2025-03-21T09:59:28.000000Z"}]},{"id":8067003,"change_date":"2025-03-10 21:38:00","inspection_id":"84074279","dot_number":"2400757","report_state":"NY","report_number":"SPE3090259","insp_date":"2025-03-03 00:00:00","insp_start_time":"1129","insp_end_time":"1145","registration_date":null,"region":"ES","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1450655","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:50.000000Z","updated_at":"2025-03-17T21:05:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13025186,"change_date":"2025-03-10 21:38:00","inspection_id":"84074279","insp_unit_id":"205703908","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5335","insp_unit_license":"81591PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN266918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:58.000000Z","updated_at":"2025-03-17T23:58:58.000000Z"},{"id":13025187,"change_date":"2025-03-10 21:38:00","inspection_id":"84074279","insp_unit_id":"205703909","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"8405152","insp_unit_license":"TSC1153","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2531K6640301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:58.000000Z","updated_at":"2025-03-17T23:58:58.000000Z"}]},{"id":7962348,"change_date":"2025-02-26 21:41:00","inspection_id":"83964176","dot_number":"2400757","report_state":"NY","report_number":"SPA3070081","insp_date":"2025-02-20 00:00:00","insp_start_time":"0813","insp_end_time":"0834","registration_date":null,"region":"ES","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":"MCDONALDS","shipping_paper_number":"1087621","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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1399908","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-02-26 21:41:00","snet_input_date":"2025-02-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-03-17T21:03:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12853666,"change_date":"2025-02-26 21:41:00","inspection_id":"83964176","insp_unit_id":"205501964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"41931PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH6LN266915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"},{"id":12853667,"change_date":"2025-02-26 21:41:00","inspection_id":"83964176","insp_unit_id":"205501965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"TSF3108","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2534K6640406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"}]},{"id":7962354,"change_date":"2025-02-26 21:41:00","inspection_id":"83964182","dot_number":"2400757","report_state":"NY","report_number":"SPC3020504","insp_date":"2025-02-19 00:00:00","insp_start_time":"0911","insp_end_time":"0940","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ANDERSON","shipping_paper_number":"1087567","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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1399988","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-02-26 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-03-17T21:03:36.000000Z","inspection_violations":[{"id":12442673,"change_date":"2025-02-26 21:41:00","inspection_id":"83964182","insp_violation_id":"264703154","seq_no":"1","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"2","insp_unit_id":"205501976","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:49.000000Z","updated_at":"2025-03-17T22:06:49.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":12853677,"change_date":"2025-02-26 21:41:00","inspection_id":"83964182","insp_unit_id":"205501975","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5333","insp_unit_license":"81590PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH8LN266916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"},{"id":12853678,"change_date":"2025-02-26 21:41:00","inspection_id":"83964182","insp_unit_id":"205501976","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"8405156","insp_unit_license":"TSE4812","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2537K6640402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"}]},{"id":7825947,"change_date":"2025-02-10 21:39:00","inspection_id":"83821243","dot_number":"2400757","report_state":"NY","report_number":"SPD3050475","insp_date":"2025-02-03 00:00:00","insp_start_time":"0918","insp_end_time":"0940","registration_date":null,"region":"ES","ci_status_code":"C","location":"20026","location_desc":"TABERG NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ANDERSON DUBOSE","shipping_paper_number":"216","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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1344689","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-02-10 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-10 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:45.000000Z","updated_at":"2025-03-17T21:00:45.000000Z","inspection_violations":[{"id":12229930,"change_date":"2025-02-10 21:39:00","inspection_id":"83821243","insp_violation_id":"264426974","seq_no":"1","part_no":"393","part_no_section":"41-BNPB-SPR","insp_viol_unit":"2","insp_unit_id":"205238639","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:40.000000Z","updated_at":"2025-03-17T22:05:40.000000Z","normalized_code":"39341BNPBSPR"}],"inspection_per_units":[{"id":12630099,"change_date":"2025-02-10 21:39:00","inspection_id":"83821243","insp_unit_id":"205238638","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:33.000000Z","updated_at":"2025-03-17T23:54:33.000000Z"},{"id":12630100,"change_date":"2025-02-10 21:39:00","inspection_id":"83821243","insp_unit_id":"205238639","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"8400239","insp_unit_license":"TSF8505","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6564901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:33.000000Z","updated_at":"2025-03-17T23:54:33.000000Z"}]},{"id":7612569,"change_date":"2025-01-14 21:54:00","inspection_id":"83597042","dot_number":"2400757","report_state":"NY","report_number":"SPB3050201","insp_date":"2025-01-07 00:00:00","insp_start_time":"1140","insp_end_time":"1216","registration_date":null,"region":"ES","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADR NY  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":"U","pen_cen_match":"I","final_status_date":"2025-01-14 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"121500","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":"1245323","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2025-01-14 21:54:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:54:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12283323,"change_date":"2025-01-14 21:54:00","inspection_id":"83597042","insp_unit_id":"204813279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5419","insp_unit_license":"26268PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3PN310942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"},{"id":12283324,"change_date":"2025-01-14 21:54:00","inspection_id":"83597042","insp_unit_id":"204813280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407003","insp_unit_license":"TSE1496","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6579902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7009322,"change_date":"2024-10-22 21:40:00","inspection_id":"82960707","dot_number":"2400757","report_state":"NY","report_number":"SPD3010220","insp_date":"2024-10-15 00:00:00","insp_start_time":"0854","insp_end_time":"0910","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ADR NY DIST 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":"2024-10-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23000","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":"968928","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2024-10-22 21:40:00","snet_input_date":"2024-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-22 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:16.000000Z","updated_at":"2025-03-17T20:42:16.000000Z","inspection_violations":[{"id":10936126,"change_date":"2024-10-22 21:40:00","inspection_id":"82960707","insp_violation_id":"262472247","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"203514341","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D32JL8DF7","created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":11305436,"change_date":"2024-10-22 21:40:00","inspection_id":"82960707","insp_unit_id":"203514341","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"PLH3394","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWM1NH849476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:04.000000Z","updated_at":"2025-03-17T23:40:04.000000Z"}]},{"id":6936733,"change_date":"2024-10-11 21:39:00","inspection_id":"82883550","dot_number":"2400757","report_state":"NY","report_number":"SPD3050091","insp_date":"2024-10-04 00:00:00","insp_start_time":"0948","insp_end_time":"1007","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","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-10-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"934650","transaction_code":"A","transaction_date":"2024-10-11 00:00:00","upload_date":"2024-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2024-10-11 21:39:00","snet_input_date":"2024-10-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-11 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:41.000000Z","updated_at":"2025-03-17T20:40:41.000000Z","inspection_violations":[{"id":10813320,"change_date":"2024-10-11 21:39:00","inspection_id":"82883550","insp_violation_id":"262300131","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"203365631","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":11187719,"change_date":"2024-10-11 21:39:00","inspection_id":"82883550","insp_unit_id":"203365631","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5419","insp_unit_license":"26268PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3PN310942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"},{"id":11187720,"change_date":"2024-10-11 21:39:00","inspection_id":"82883550","insp_unit_id":"203365632","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"8707541","insp_unit_license":"TSF6449","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530S6353001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"}]},{"id":6678075,"change_date":"2024-09-09 21:40:00","inspection_id":"82608366","dot_number":"2400757","report_state":"NY","report_number":"SPD0310006","insp_date":"2024-09-03 00:00:00","insp_start_time":"1201","insp_end_time":"1222","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2949606","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:17.000000Z","updated_at":"2025-03-17T20:35:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10767106,"change_date":"2024-09-09 21:40:00","inspection_id":"82608366","insp_unit_id":"202822081","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5332","insp_unit_license":"41931PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH6LN266915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"},{"id":10767107,"change_date":"2024-09-09 21:40:00","inspection_id":"82608366","insp_unit_id":"202822082","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405152","insp_unit_license":"TSC1153","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2531K6640301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"}]},{"id":6429722,"change_date":"2024-08-09 21:38:00","inspection_id":"82343676","dot_number":"2400757","report_state":"NY","report_number":"SPE0274771","insp_date":"2024-08-06 00:00:00","insp_start_time":"1223","insp_end_time":"1242","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (SB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","shipping_paper_number":"5364","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"2944056","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:18.000000Z","updated_at":"2025-03-17T20:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10362476,"change_date":"2024-08-09 21:38:00","inspection_id":"82343676","insp_unit_id":"202315359","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4649","insp_unit_license":"36837PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH2PN617857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"},{"id":10362477,"change_date":"2024-08-09 21:38:00","inspection_id":"82343676","insp_unit_id":"202315360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405156","insp_unit_license":"TSE4812","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2537K6640402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"}]},{"id":6325461,"change_date":"2024-07-28 21:33:00","inspection_id":"82232026","dot_number":"2400757","report_state":"NY","report_number":"D306100273","insp_date":"2024-07-22 00:00:00","insp_start_time":"1034","insp_end_time":"1133","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BATH NY","county_code_state":"NY","county_code":"101","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":"2024-07-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"690041","transaction_code":"A","transaction_date":"2024-07-27 00:00:00","upload_date":"2024-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2024-07-28 21:33:00","snet_input_date":"2024-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-28 21:33:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:14.000000Z","updated_at":"2025-03-17T20:28:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10192490,"change_date":"2024-07-28 21:33:00","inspection_id":"82232026","insp_unit_id":"202103598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5419","insp_unit_license":"26268PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3PN310942","insp_unit_decal":"Y","insp_unit_decal_number":"34335820","created_at":"2025-03-17T23:28:34.000000Z","updated_at":"2025-03-17T23:28:34.000000Z"},{"id":10192491,"change_date":"2024-07-28 21:33:00","inspection_id":"82232026","insp_unit_id":"202103599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407004","insp_unit_license":"TSE1497","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532N6579903","insp_unit_decal":"Y","insp_unit_decal_number":"34335821","created_at":"2025-03-17T23:28:34.000000Z","updated_at":"2025-03-17T23:28:34.000000Z"}]},{"id":6285198,"change_date":"2024-07-23 21:41:00","inspection_id":"82189025","dot_number":"2400757","report_state":"NY","report_number":"SPD0216500","insp_date":"2024-07-19 00:00:00","insp_start_time":"1210","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALD'S","shipping_paper_number":"RT 340","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-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"2939016","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":"02400757","upload_search_indicator":"M","census_search_date":"2024-07-23 21:41:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-23 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","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":[],"inspection_per_units":[{"id":10126781,"change_date":"2024-07-23 21:41:00","inspection_id":"82189025","insp_unit_id":"202019742","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5418","insp_unit_license":"25712PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1PN310941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:55.000000Z","updated_at":"2025-03-17T23:27:55.000000Z"},{"id":10126782,"change_date":"2024-07-23 21:41:00","inspection_id":"82189025","insp_unit_id":"202019743","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSF6449","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530S6353001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:55.000000Z","updated_at":"2025-03-17T23:27:55.000000Z"}]},{"id":6114178,"change_date":"2024-07-01 21:43:00","inspection_id":"82005416","dot_number":"2400757","report_state":"NY","report_number":"D507100735","insp_date":"2024-07-01 00:00:00","insp_start_time":"1102","insp_end_time":"1127","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-07-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"617484","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2024-07-01 21:43:00","snet_input_date":"2024-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-01 21:43:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:48.000000Z","updated_at":"2025-03-17T20:23:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9848442,"change_date":"2024-07-01 21:43:00","inspection_id":"82005416","insp_unit_id":"201670162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5366","insp_unit_license":"29733PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EHXLN269946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:01.000000Z","updated_at":"2025-03-17T23:25:01.000000Z"},{"id":9848443,"change_date":"2024-07-01 21:43:00","inspection_id":"82005416","insp_unit_id":"201670163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8407003","insp_unit_license":"8407003","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6579902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:01.000000Z","updated_at":"2025-03-17T23:25:01.000000Z"}]},{"id":6070954,"change_date":"2024-06-25 21:42:00","inspection_id":"81958971","dot_number":"2400757","report_state":"NY","report_number":"SPE0330488","insp_date":"2024-06-18 00:00:00","insp_start_time":"1233","insp_end_time":"1327","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","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-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2932367","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2024-06-25 21:42:00","snet_input_date":"2024-06-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:59.000000Z","updated_at":"2025-03-17T20:22:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9777946,"change_date":"2024-06-25 21:42:00","inspection_id":"81958971","insp_unit_id":"201577254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5335","insp_unit_license":"81591PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN266918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"},{"id":9777947,"change_date":"2024-06-25 21:42:00","inspection_id":"81958971","insp_unit_id":"201577255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"6198","insp_unit_license":"TSC5084","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539L6081601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:16.000000Z","updated_at":"2025-03-17T23:24:16.000000Z"}]},{"id":5615033,"change_date":"2024-04-29 21:42:00","inspection_id":"81464415","dot_number":"2400757","report_state":"NY","report_number":"D305800705","insp_date":"2024-04-25 00:00:00","insp_start_time":"1146","insp_end_time":"1237","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-04-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"435526","transaction_code":"A","transaction_date":"2024-04-28 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2024-04-29 21:42:00","snet_input_date":"2024-04-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-29 21:42:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:55.000000Z","updated_at":"2025-03-17T20:13:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9045116,"change_date":"2024-04-29 21:42:00","inspection_id":"81464415","insp_unit_id":"200613379","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"8406198","insp_unit_license":"TSC5084","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539L6081601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"},{"id":9045117,"change_date":"2024-04-29 21:42:00","inspection_id":"81464415","insp_unit_id":"200613380","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"5564","insp_unit_license":"10719PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH8LN269945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:11.000000Z","updated_at":"2025-03-17T23:17:11.000000Z"}]},{"id":5086173,"change_date":"2024-02-20 21:41:00","inspection_id":"80887523","dot_number":"2400757","report_state":"NY","report_number":"SPC0159628","insp_date":"2024-02-13 00:00:00","insp_start_time":"1013","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE ANDERSON- DUBOSE COMPANY","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"2908302","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","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":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DRIVE","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","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":7840937,"change_date":"2024-02-20 21:41:00","inspection_id":"80887523","insp_violation_id":"257918943","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199495398","insp_violation_category_id":"20","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":"39311"}],"inspection_per_units":[{"id":8188008,"change_date":"2024-02-20 21:41:00","inspection_id":"80887523","insp_unit_id":"199495398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5334","insp_unit_license":"24074PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EHXLN266917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:13.000000Z","updated_at":"2025-03-17T23:09:13.000000Z"},{"id":8188009,"change_date":"2024-02-20 21:41:00","inspection_id":"80887523","insp_unit_id":"199495399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405158","insp_unit_license":"TSC1796","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530K6640404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:13.000000Z","updated_at":"2025-03-17T23:09:13.000000Z"}]},{"id":5038674,"change_date":"2024-02-13 21:41:00","inspection_id":"80835627","dot_number":"2400757","report_state":"NY","report_number":"SPT0442123","insp_date":"2024-02-09 00:00:00","insp_start_time":"1533","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"40388A","location_desc":"HENRIETTA (EXIT 46)","county_code_state":"NY","county_code":"055","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"660","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-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2906398","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2024-02-13 21:41:00","snet_input_date":"2024-02-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-13 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:26.000000Z","updated_at":"2025-03-17T20:02:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8110708,"change_date":"2024-02-13 21:41:00","inspection_id":"80835627","insp_unit_id":"199396971","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:30.000000Z","updated_at":"2025-03-17T23:08:30.000000Z"},{"id":8110709,"change_date":"2024-02-13 21:41:00","inspection_id":"80835627","insp_unit_id":"199396972","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSC7333","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530M6398202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:30.000000Z","updated_at":"2025-03-17T23:08:30.000000Z"}]},{"id":4835442,"change_date":"2024-01-16 21:44:00","inspection_id":"80613354","dot_number":"2400757","report_state":"NY","report_number":"SPD0271917","insp_date":"2024-01-09 00:00:00","insp_start_time":"0758","insp_end_time":"0836","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"THE ANDERSON- DUBOSE COMPANY","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-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2900077","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[{"id":7455964,"change_date":"2024-01-16 21:44:00","inspection_id":"80613354","insp_violation_id":"257345029","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198964954","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39311"},{"id":7455965,"change_date":"2024-01-16 21:44:00","inspection_id":"80613354","insp_violation_id":"257345030","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198964955","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7779469,"change_date":"2024-01-16 21:44:00","inspection_id":"80613354","insp_unit_id":"198964954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5419","insp_unit_license":"26268PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3PN310942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:31.000000Z","updated_at":"2025-03-17T23:05:31.000000Z"},{"id":7779470,"change_date":"2024-01-16 21:44:00","inspection_id":"80613354","insp_unit_id":"198964955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02339","insp_unit_license":"TSC9934","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530N6564901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:31.000000Z","updated_at":"2025-03-17T23:05:31.000000Z"}]},{"id":4618014,"change_date":"2023-12-13 21:42:00","inspection_id":"80375640","dot_number":"2400757","report_state":"NY","report_number":"SPD0261786","insp_date":"2023-12-12 00:00:00","insp_start_time":"1150","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445B","location_desc":"LAFAYETTE (SB)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","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-12-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2892585","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2023-12-13 21:42:00","snet_input_date":"2023-12-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-13 21:42:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:14.000000Z","updated_at":"2025-03-17T19:54:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7427739,"change_date":"2023-12-13 21:42:00","inspection_id":"80375640","insp_unit_id":"198480705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4648","insp_unit_license":"30366PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AN4GY6PM038053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:26.000000Z","updated_at":"2025-03-17T23:02:26.000000Z"},{"id":7427740,"change_date":"2023-12-13 21:42:00","inspection_id":"80375640","insp_unit_id":"198480706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSE4812","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2537K6640402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:26.000000Z","updated_at":"2025-03-17T23:02:26.000000Z"}]},{"id":4330115,"change_date":"2023-11-01 21:43:00","inspection_id":"80058441","dot_number":"2400757","report_state":"NY","report_number":"SPT0441757","insp_date":"2023-10-30 00:00:00","insp_start_time":"1201","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":"30841R","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":null,"shipping_paper_number":"211","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-11-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121250","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":"2883451","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:44.000000Z","updated_at":"2025-03-17T19:48:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6963598,"change_date":"2023-11-01 21:43:00","inspection_id":"80058441","insp_unit_id":"197849479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5369","insp_unit_license":"82889PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH5LN269949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"},{"id":6963599,"change_date":"2023-11-01 21:43:00","inspection_id":"80058441","insp_unit_id":"197849480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"158","insp_unit_license":"TSC1796","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530K6640404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"}]},{"id":4169981,"change_date":"2023-10-11 21:40:00","inspection_id":"79881442","dot_number":"2400757","report_state":"NY","report_number":"0322004824","insp_date":"2023-10-10 00:00:00","insp_start_time":"1130","insp_end_time":"1152","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2877016","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DRIVE","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:28.000000Z","updated_at":"2025-03-17T19:45:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6705378,"change_date":"2023-10-11 21:40:00","inspection_id":"79881442","insp_unit_id":"197493149","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5334","insp_unit_license":"24074PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EHXLN266917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:14.000000Z","updated_at":"2025-03-17T22:56:14.000000Z"},{"id":6705379,"change_date":"2023-10-11 21:40:00","inspection_id":"79881442","insp_unit_id":"197493150","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405159","insp_unit_license":"TSE4882","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532K6640405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:14.000000Z","updated_at":"2025-03-17T22:56:14.000000Z"}]},{"id":4067263,"change_date":"2023-09-27 21:41:00","inspection_id":"79767587","dot_number":"2400757","report_state":"NY","report_number":"MC90000022","insp_date":"2023-09-26 00:00:00","insp_start_time":"0925","insp_end_time":"1013","registration_date":null,"region":"ET","ci_status_code":"C","location":"30223M","location_desc":"DEWITT EXIT 35 TANDEM LOT","county_code_state":"NY","county_code":"067","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"THE ANDERSON- DUBOSE COMPANY","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-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2873378","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:11.000000Z","updated_at":"2025-03-17T19:43:11.000000Z","inspection_violations":[{"id":6297655,"change_date":"2023-09-27 21:41:00","inspection_id":"79767587","insp_violation_id":"255513530","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197263574","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"3939A"},{"id":6297656,"change_date":"2023-09-27 21:41:00","inspection_id":"79767587","insp_violation_id":"255513531","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"197263575","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":6539403,"change_date":"2023-09-27 21:41:00","inspection_id":"79767587","insp_unit_id":"197263574","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"Y","insp_unit_decal_number":"33074838","created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"},{"id":6539404,"change_date":"2023-09-27 21:41:00","inspection_id":"79767587","insp_unit_id":"197263575","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8404097","insp_unit_license":"TSB6708","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2536HM936001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"}]},{"id":3290802,"change_date":"2023-06-15 21:42:00","inspection_id":"78898797","dot_number":"2400757","report_state":"NY","report_number":"SPE0320681","insp_date":"2023-06-14 00:00:00","insp_start_time":"0854","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504","location_desc":"T\/MANCHESTER","county_code_state":"NY","county_code":"069","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-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2836581","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2023-06-15 21:42:00","snet_input_date":"2023-06-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:09.000000Z","updated_at":"2025-03-17T19:28:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5290568,"change_date":"2023-06-15 21:42:00","inspection_id":"78898797","insp_unit_id":"195510124","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5336","insp_unit_license":"81589PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN266919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:42.000000Z","updated_at":"2025-03-17T22:44:42.000000Z"},{"id":5290569,"change_date":"2023-06-15 21:42:00","inspection_id":"78898797","insp_unit_id":"195510125","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSE1403","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539K6640403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:42.000000Z","updated_at":"2025-03-17T22:44:42.000000Z"}]},{"id":3175455,"change_date":"2023-05-31 21:41:00","inspection_id":"78768430","dot_number":"2400757","report_state":"NY","report_number":"SPE0273708","insp_date":"2023-05-30 00:00:00","insp_start_time":"1509","insp_end_time":"1530","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","shipping_paper_number":"361","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-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2830711","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":null,"census_search_date":"2023-05-31 21:41:00","snet_input_date":"2023-05-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-31 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DRIVE","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:46.000000Z","updated_at":"2025-03-17T19:25:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5107726,"change_date":"2023-05-31 21:41:00","inspection_id":"78768430","insp_unit_id":"195219857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5333","insp_unit_license":"81590PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH8LN266916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"},{"id":5107727,"change_date":"2023-05-31 21:41:00","inspection_id":"78768430","insp_unit_id":"195219858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405154","insp_unit_license":"TSE1405","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2535K6640303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:15.000000Z","updated_at":"2025-03-17T22:43:15.000000Z"}]},{"id":3158654,"change_date":"2023-05-30 21:41:00","inspection_id":"78749352","dot_number":"2400757","report_state":"NY","report_number":"SPT0384876","insp_date":"2023-05-29 00:00:00","insp_start_time":"0934","insp_end_time":"0957","registration_date":null,"region":"ET","ci_status_code":"C","location":"50152","location_desc":"DEPEW (EXIT 49)","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":"2023-05-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2829937","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2023-05-30 21:41:00","snet_input_date":"2023-05-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-30 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:24.000000Z","updated_at":"2025-03-17T19:25:24.000000Z","inspection_violations":[{"id":4865546,"change_date":"2023-05-30 21:41:00","inspection_id":"78749352","insp_violation_id":"253125370","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195180407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:39.000000Z","updated_at":"2025-03-17T21:29:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5079779,"change_date":"2023-05-30 21:41:00","inspection_id":"78749352","insp_unit_id":"195180406","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5368","insp_unit_license":"82888PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN269948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:01.000000Z","updated_at":"2025-03-17T22:43:01.000000Z"},{"id":5079780,"change_date":"2023-05-30 21:41:00","inspection_id":"78749352","insp_unit_id":"195180407","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8404096","insp_unit_license":"TSB6709","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2488HM935901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:01.000000Z","updated_at":"2025-03-17T22:43:01.000000Z"}]},{"id":2961191,"change_date":"2023-05-04 21:40:00","inspection_id":"78526523","dot_number":"2400757","report_state":"NY","report_number":"SPD0290835","insp_date":"2023-05-02 00:00:00","insp_start_time":"0844","insp_end_time":"0903","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","shipping_paper_number":"1048074","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-05-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2821969","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2023-05-04 21:40:00","snet_input_date":"2023-05-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-04 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:49.000000Z","updated_at":"2025-03-17T19:21:49.000000Z","inspection_violations":[{"id":4545236,"change_date":"2023-05-04 21:40:00","inspection_id":"78526523","insp_violation_id":"252612896","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4764557,"change_date":"2023-05-04 21:40:00","inspection_id":"78526523","insp_unit_id":"194740864","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4611","insp_unit_license":"76783PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AN4GY0LM010761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:33.000000Z","updated_at":"2025-03-17T22:40:33.000000Z"},{"id":4764558,"change_date":"2023-05-04 21:40:00","inspection_id":"78526523","insp_unit_id":"194740865","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSC5086","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532L6081603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:33.000000Z","updated_at":"2025-03-17T22:40:33.000000Z"}]},{"id":2621329,"change_date":"2023-03-21 21:41:00","inspection_id":"78140794","dot_number":"2400757","report_state":"NY","report_number":"SPD0261073","insp_date":"2023-03-20 00:00:00","insp_start_time":"0931","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"30862","location_desc":"VOLNEY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2808146","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2023-03-21 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:08.000000Z","updated_at":"2025-03-17T19:15:08.000000Z","inspection_violations":[{"id":4031002,"change_date":"2023-03-21 21:41:00","inspection_id":"78140794","insp_violation_id":"251772282","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"193972093","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":4219473,"change_date":"2023-03-21 21:41:00","inspection_id":"78140794","insp_unit_id":"193972093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5335","insp_unit_license":"81591PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN266918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"},{"id":4219474,"change_date":"2023-03-21 21:41:00","inspection_id":"78140794","insp_unit_id":"193972094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSE1403","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2539K6640403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:15.000000Z","updated_at":"2025-03-17T22:36:15.000000Z"}]},{"id":2013316,"change_date":"2022-12-27 21:39:00","inspection_id":"77447201","dot_number":"2400757","report_state":"NY","report_number":"SPD0290431","insp_date":"2022-12-22 00:00:00","insp_start_time":"0955","insp_end_time":"1013","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","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-12-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2783226","transaction_code":"A","transaction_date":"2022-12-27 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-12-27 21:39:00","snet_input_date":"2022-12-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-27 21:39:00","insp_carrier_name":"THE ANDERSON- DUBOSE COMPANY","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:42.000000Z","updated_at":"2025-03-17T19:03:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3238939,"change_date":"2022-12-27 21:39:00","inspection_id":"77447201","insp_unit_id":"192576229","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5369","insp_unit_license":"82889PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH5LN269949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"},{"id":3238940,"change_date":"2022-12-27 21:39:00","inspection_id":"77447201","insp_unit_id":"192576230","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSC2457","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2534K6640406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"}]},{"id":1750566,"change_date":"2022-11-16 21:40:00","inspection_id":"77146262","dot_number":"2400757","report_state":"NY","report_number":"SPT0333973","insp_date":"2022-11-14 00:00:00","insp_start_time":"0423","insp_end_time":"0455","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895R","location_desc":"WESTMORELAND (EXIT 32)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","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-11-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2768668","transaction_code":"A","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-11-16 21:40:00","snet_input_date":"2022-11-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-16 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:56.000000Z","updated_at":"2025-03-17T18:58:56.000000Z","inspection_violations":[{"id":2741736,"change_date":"2022-11-16 21:40:00","inspection_id":"77146262","insp_violation_id":"249625660","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191978803","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:55.000000Z","updated_at":"2025-03-17T21:19:55.000000Z","normalized_code":"39311"},{"id":2741737,"change_date":"2022-11-16 21:40:00","inspection_id":"77146262","insp_violation_id":"249625661","seq_no":"2","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"191978803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:55.000000Z","updated_at":"2025-03-17T21:19:55.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":2816437,"change_date":"2022-11-16 21:40:00","inspection_id":"77146262","insp_unit_id":"191978802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSC1155","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2533K6640302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:16.000000Z","updated_at":"2025-03-17T22:26:16.000000Z"},{"id":2816438,"change_date":"2022-11-16 21:40:00","inspection_id":"77146262","insp_unit_id":"191978803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5368","insp_unit_license":"82888PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN269948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:16.000000Z","updated_at":"2025-03-17T22:26:16.000000Z"}]},{"id":1724173,"change_date":"2022-11-14 21:41:00","inspection_id":"77116187","dot_number":"2400757","report_state":"NY","report_number":"0518000760","insp_date":"2022-11-10 00:00:00","insp_start_time":"1240","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2767349","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[{"id":2700774,"change_date":"2022-11-14 21:41:00","inspection_id":"77116187","insp_violation_id":"249560394","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"191920143","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39345B2"},{"id":2700775,"change_date":"2022-11-14 21:41:00","inspection_id":"77116187","insp_violation_id":"249560395","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191920144","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2773561,"change_date":"2022-11-14 21:41:00","inspection_id":"77116187","insp_unit_id":"191920143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4594","insp_unit_license":"72360PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AN4GY9KM008361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"},{"id":2773562,"change_date":"2022-11-14 21:41:00","inspection_id":"77116187","insp_unit_id":"191920144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405158","insp_unit_license":"TSC1796","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530K6640404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":1654958,"change_date":"2022-11-02 21:39:00","inspection_id":"77036714","dot_number":"2400757","report_state":"NY","report_number":"0321004957","insp_date":"2022-11-01 00:00:00","insp_start_time":"0910","insp_end_time":"0933","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382M","location_desc":"HASTINGS REST AREA (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-11-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23000","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":"2765105","transaction_code":"A","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-11-02 21:39:00","snet_input_date":"2022-11-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-02 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:05.000000Z","updated_at":"2025-03-17T18:57:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2662624,"change_date":"2022-11-02 21:39:00","inspection_id":"77036714","insp_unit_id":"191764702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"8406978","insp_unit_license":"PLH3394","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTKSSWM1NH849476","insp_unit_decal":"Y","insp_unit_decal_number":"32009657","created_at":"2025-03-17T22:25:15.000000Z","updated_at":"2025-03-17T22:25:15.000000Z"}]},{"id":1547345,"change_date":"2022-10-19 21:40:00","inspection_id":"76913036","dot_number":"2400757","report_state":"NY","report_number":"0326000530","insp_date":"2022-10-18 00:00:00","insp_start_time":"1300","insp_end_time":"1321","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585M","location_desc":"NICHOLS REST AREA (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"THE ANDERSON- DUBOSE COMPANY","shipping_paper_number":"1034871","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-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2760479","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-10-19 21:40:00","snet_input_date":"2022-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-19 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:12.000000Z","updated_at":"2025-03-17T18:55:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2489923,"change_date":"2022-10-19 21:40:00","inspection_id":"76913036","insp_unit_id":"191513358","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5335","insp_unit_license":"81591PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN266918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"},{"id":2489924,"change_date":"2022-10-19 21:40:00","inspection_id":"76913036","insp_unit_id":"191513359","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8406197","insp_unit_license":"TSC5086","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532L6081603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"}]},{"id":1299900,"change_date":"2022-09-16 21:40:00","inspection_id":"76626473","dot_number":"2400757","report_state":"NY","report_number":"SPE0199926","insp_date":"2022-09-15 00:00:00","insp_start_time":"1047","insp_end_time":"1117","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","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-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2749739","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-09-16 21:40:00","snet_input_date":"2022-09-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:31.000000Z","updated_at":"2025-03-17T18:50:31.000000Z","inspection_violations":[{"id":2056852,"change_date":"2022-09-16 21:40:00","inspection_id":"76626473","insp_violation_id":"248456778","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"190935170","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"39375A"},{"id":2056853,"change_date":"2022-09-16 21:40:00","inspection_id":"76626473","insp_violation_id":"248456779","seq_no":"2","part_no":"390","part_no_section":"21(e)","insp_viol_unit":"1","insp_unit_id":"190935170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"39021E"},{"id":2056854,"change_date":"2022-09-16 21:40:00","inspection_id":"76626473","insp_violation_id":"248456780","seq_no":"3","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:24.000000Z","updated_at":"2025-03-17T21:16:24.000000Z","normalized_code":"39522H2"}],"inspection_per_units":[{"id":2092337,"change_date":"2022-09-16 21:40:00","inspection_id":"76626473","insp_unit_id":"190935170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"78009PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AW07Y7GM077580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:21.000000Z","updated_at":"2025-03-17T22:21:21.000000Z"},{"id":2092338,"change_date":"2022-09-16 21:40:00","inspection_id":"76626473","insp_unit_id":"190935171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSB6708","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2536HM936001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:21.000000Z","updated_at":"2025-03-17T22:21:21.000000Z"}]},{"id":1121634,"change_date":"2022-08-24 21:39:00","inspection_id":"76419490","dot_number":"2400757","report_state":"NY","report_number":"SPT0530321","insp_date":"2022-08-23 00:00:00","insp_start_time":"1042","insp_end_time":"1104","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330M","location_desc":"GLEN REST AREA WB MP184","county_code_state":"NY","county_code":"057","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-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2743063","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:31.000000Z","updated_at":"2025-03-17T18:47:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1803973,"change_date":"2022-08-24 21:39:00","inspection_id":"76419490","insp_unit_id":"190508897","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5368","insp_unit_license":"82888PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH3LN269948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"},{"id":1803974,"change_date":"2022-08-24 21:39:00","inspection_id":"76419490","insp_unit_id":"190508898","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSC1153","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2531K6640301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":952824,"change_date":"2022-08-03 21:42:00","inspection_id":"76222461","dot_number":"2400757","report_state":"NY","report_number":"SPC0241100","insp_date":"2022-08-02 00:00:00","insp_start_time":"1837","insp_end_time":"1902","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585B","location_desc":"NICHOLS (WB)","county_code_state":"NY","county_code":"107","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-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2734599","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-08-03 21:42:00","snet_input_date":"2022-08-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:25.000000Z","updated_at":"2025-03-17T18:44:25.000000Z","inspection_violations":[{"id":1502738,"change_date":"2022-08-03 21:42:00","inspection_id":"76222461","insp_violation_id":"247482911","seq_no":"1","part_no":"390","part_no_section":"21(e)","insp_viol_unit":"1","insp_unit_id":"190106786","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"39021E"}],"inspection_per_units":[{"id":1532992,"change_date":"2022-08-03 21:42:00","inspection_id":"76222461","insp_unit_id":"190106786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4610","insp_unit_license":"76782PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M1AN4GY9LM010760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:39.000000Z","updated_at":"2025-03-17T22:17:39.000000Z"},{"id":1532993,"change_date":"2022-08-03 21:42:00","inspection_id":"76222461","insp_unit_id":"190106787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2102","insp_unit_license":"TQJ2242","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS253XFM207402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:39.000000Z","updated_at":"2025-03-17T22:17:39.000000Z"}]},{"id":759656,"change_date":"2022-07-06 21:41:00","inspection_id":"75996358","dot_number":"2400757","report_state":"NY","report_number":"SPB0255943","insp_date":"2022-06-28 00:00:00","insp_start_time":"1121","insp_end_time":"1208","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE REST AREA","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MC DONALDS","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-07-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2724524","transaction_code":"A","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-07-06 21:41:00","snet_input_date":"2022-07-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-06 21:41:00","insp_carrier_name":"THE ANDERSON- DUBOSE COMPANY","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:57.000000Z","updated_at":"2025-03-17T18:40:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1221501,"change_date":"2022-07-06 21:41:00","inspection_id":"75996358","insp_unit_id":"189624474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5418","insp_unit_license":"25712PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1PN310941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:42.000000Z","updated_at":"2025-03-17T22:15:42.000000Z"},{"id":1221502,"change_date":"2022-07-06 21:41:00","inspection_id":"75996358","insp_unit_id":"189624475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"159","insp_unit_license":"TSC1797","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532K6640405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:42.000000Z","updated_at":"2025-03-17T22:15:42.000000Z"}]},{"id":428419,"change_date":"2022-05-19 21:41:00","inspection_id":"75603836","dot_number":"2400757","report_state":"NY","report_number":"SPD0185316","insp_date":"2022-05-18 00:00:00","insp_start_time":"1945","insp_end_time":"2026","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","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":"N","pen_cen_match":null,"final_status_date":"2022-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2708050","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:08.000000Z","updated_at":"2025-03-17T18:35:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":690821,"change_date":"2022-05-19 21:41:00","inspection_id":"75603836","insp_unit_id":"188779745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5335","insp_unit_license":"81591PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN266918","insp_unit_decal":"Y","insp_unit_decal_number":"31444158","created_at":"2025-03-17T22:12:27.000000Z","updated_at":"2025-03-17T22:12:27.000000Z"},{"id":690822,"change_date":"2022-05-19 21:41:00","inspection_id":"75603836","insp_unit_id":"188779746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8400240","insp_unit_license":"TSC9933","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2532N6564902","insp_unit_decal":"Y","insp_unit_decal_number":"31444159","created_at":"2025-03-17T22:12:27.000000Z","updated_at":"2025-03-17T22:12:27.000000Z"}]},{"id":414066,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","dot_number":"2400757","report_state":"NY","report_number":"0519000150","insp_date":"2022-05-17 00:00:00","insp_start_time":"1209","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (SB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2706942","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:49.000000Z","updated_at":"2025-03-17T18:34:49.000000Z","inspection_violations":[{"id":648073,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864978","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188745946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":648074,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864979","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188745947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":648075,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864980","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"188745947","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39355E"},{"id":648076,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864981","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188745947","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3939A"},{"id":648077,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864982","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"188745947","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39345B2"},{"id":648078,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864983","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"188745947","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39348A"},{"id":648079,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_violation_id":"245864984","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"188745947","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":668237,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_unit_id":"188745946","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5333","insp_unit_license":"81590PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH8LN266916","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"},{"id":668238,"change_date":"2022-05-18 21:43:00","inspection_id":"75586813","insp_unit_id":"188745947","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8405156","insp_unit_license":"TSC1794","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2537K6640402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":334350,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","dot_number":"2400757","report_state":"NY","report_number":"SPE0226676","insp_date":"2022-05-05 00:00:00","insp_start_time":"1320","insp_end_time":"1355","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":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-05-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2703489","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":"02400757","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":"ADR NY DIST LLC","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","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":[{"id":524461,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","insp_violation_id":"245620625","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:31.000000Z","updated_at":"2025-03-17T21:09:31.000000Z","normalized_code":"38323A2"},{"id":524462,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","insp_violation_id":"245620626","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188541913","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:31.000000Z","updated_at":"2025-03-17T21:09:31.000000Z","normalized_code":"39378"},{"id":524463,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","insp_violation_id":"245620627","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188541913","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:31.000000Z","updated_at":"2025-03-17T21:09:31.000000Z","normalized_code":"39345B2"},{"id":524464,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","insp_violation_id":"245620628","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188541913","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:31.000000Z","updated_at":"2025-03-17T21:09:31.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":540813,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","insp_unit_id":"188541913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5365","insp_unit_license":"10719PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH8LN269945","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"},{"id":540814,"change_date":"2022-05-06 21:38:00","inspection_id":"75491809","insp_unit_id":"188541914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TSC5085","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2530L6081602","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"}]},{"id":342789,"change_date":"2022-05-09 21:40:00","inspection_id":"75501771","dot_number":"2400757","report_state":"NY","report_number":"SPG0213204","insp_date":"2022-04-19 00:00:00","insp_start_time":"1520","insp_end_time":"1540","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585A","location_desc":"NICHOLS (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCDONALDS","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":null,"final_status_date":"2022-05-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2704393","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02400757","upload_search_indicator":"M","census_search_date":"2022-05-09 21:40:00","snet_input_date":"2022-05-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-09 21:40:00","insp_carrier_name":"THE ANDERSON- DUBOSE COMPANY","insp_carrier_street":"41 COOK DR","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:37.000000Z","updated_at":"2025-03-17T18:33:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":554399,"change_date":"2022-05-09 21:40:00","inspection_id":"75501771","insp_unit_id":"188562837","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5367","insp_unit_license":"82887PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4V4WC9EH1LN269947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:36.000000Z","updated_at":"2025-03-17T22:11:36.000000Z"},{"id":554400,"change_date":"2022-05-09 21:40:00","inspection_id":"75501771","insp_unit_id":"188562838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TQJ2244","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2533FM207404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:36.000000Z","updated_at":"2025-03-17T22:11:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2400757\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2400757\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2400757\/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\/2400757\/inspections","per_page":100,"prev_page_url":null,"to":64,"total":64}