{"current_page":1,"data":[{"id":12727652,"change_date":"2026-08-14 21:40:00","inspection_id":"88697535","dot_number":"627478","report_state":"NY","report_number":"SPB3130696","insp_date":"2026-08-07 00:00:00","insp_start_time":"0912","insp_end_time":"0919","registration_date":"2026-08-10 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"WADDINGTON NY","county_code_state":"NY","county_code":null,"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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"3982587","transaction_code":"A","transaction_date":"2026-08-13 00:00:00","upload_date":"2026-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-08-14 21:40:00","snet_input_date":"2026-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-14 21:40:00","insp_carrier_name":"MERCER MILLING PRE-MIX COMPANY","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-17T09:40:02.000000Z","updated_at":"2026-08-18T09:38:43.000000Z","inspection_violations":[{"id":22157010,"change_date":"2026-08-14 21:40:00","inspection_id":"88697535","insp_violation_id":"276126000","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S261212144","created_at":"2026-08-17T09:58:15.000000Z","updated_at":"2026-08-18T09:54:57.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":22093673,"change_date":"2026-08-14 21:40:00","inspection_id":"88697535","insp_unit_id":"215151678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"24474BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDRXRSUW7474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:10.000000Z","updated_at":"2026-08-18T09:14:12.000000Z"},{"id":22093674,"change_date":"2026-08-14 21:40:00","inspection_id":"88697535","insp_unit_id":"215151679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P514509","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAP0622HT614931","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-17T09:16:10.000000Z","updated_at":"2026-08-18T09:14:12.000000Z"}]},{"id":12414106,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","dot_number":"627478","report_state":"NY","report_number":"D306002299","insp_date":"2026-07-08 00:00:00","insp_start_time":"1330","insp_end_time":"1419","registration_date":"2026-07-11 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SCIPIO CENTER NY","county_code_state":"NY","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCER MILLING PREMIX COMPANY","shipping_paper_number":"280370","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3724662","transaction_code":"C","transaction_date":"2026-07-10 00:00:00","upload_date":"2026-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-07-10 21:41:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-10 21:41:00","insp_carrier_name":"MERCER MILLING PRE-MIX COMPANY","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-14T09:40:33.000000Z","updated_at":"2026-07-24T09:30:11.000000Z","inspection_violations":[{"id":21607921,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_violation_id":"275467551","seq_no":"1","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"214584761","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:02.000000Z","updated_at":"2026-07-24T09:44:10.000000Z","normalized_code":"39348ABMBCBD"},{"id":21607926,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_violation_id":"275467556","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"214584761","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-14T10:00:02.000000Z","updated_at":"2026-07-24T09:44:10.000000Z","normalized_code":"3963A1BOS"},{"id":21607922,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_violation_id":"275467552","seq_no":"2","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"2","insp_unit_id":"214584761","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:02.000000Z","updated_at":"2026-07-24T09:44:10.000000Z","normalized_code":"39355C2B"},{"id":21607923,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_violation_id":"275467553","seq_no":"3","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"214584760","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:02.000000Z","updated_at":"2026-07-24T09:44:10.000000Z","normalized_code":"39021TE2IVD"},{"id":21607924,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_violation_id":"275467554","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214584760","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:02.000000Z","updated_at":"2026-07-24T09:44:10.000000Z","normalized_code":"39617CPI"},{"id":21607925,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_violation_id":"275467555","seq_no":"5","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"214584761","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:02.000000Z","updated_at":"2026-07-24T09:44:10.000000Z","normalized_code":"39348ABMBCBD"}],"inspection_per_units":[{"id":21565729,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_unit_id":"214584760","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"536731","insp_unit_license":"3229695","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDR8NSNH9096","insp_unit_decal":"Y","insp_unit_decal_number":"36697659","created_at":"2026-07-14T09:17:19.000000Z","updated_at":"2026-07-24T09:01:14.000000Z"},{"id":21565730,"change_date":"2026-07-13 21:39:00","inspection_id":"88372276","insp_unit_id":"214584761","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"874066","insp_unit_license":"PH23210","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9620LB169450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:19.000000Z","updated_at":"2026-07-24T09:01:14.000000Z"}]},{"id":12012388,"change_date":"2026-05-26 21:39:00","inspection_id":"87951502","dot_number":"627478","report_state":"NY","report_number":"SPT3101584","insp_date":"2026-05-20 00:00:00","insp_start_time":"0847","insp_end_time":"0852","registration_date":null,"region":"ED","ci_status_code":"C","location":"20854E","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCER","shipping_paper_number":"278540","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3400744","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-05-26 21:39:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-26 21:39:00","insp_carrier_name":"MERCER MILLING PRE-MIX COMPANY","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-29T09:39:50.000000Z","updated_at":"2026-06-06T09:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20881114,"change_date":"2026-05-26 21:39:00","inspection_id":"87951502","insp_unit_id":"213741536","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"876004","insp_unit_license":"95060NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2KDLG5760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:11.000000Z","updated_at":"2026-06-06T09:02:30.000000Z"}]},{"id":11626502,"change_date":"2026-04-13 21:37:00","inspection_id":"87554879","dot_number":"627478","report_state":"NY","report_number":"SPT3032065","insp_date":"2026-04-06 00:00:00","insp_start_time":"0919","insp_end_time":"0932","registration_date":null,"region":"ED","ci_status_code":"C","location":"30100M","location_desc":"WEEDSPORT NY","county_code_state":"NY","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CNY FEEDS","shipping_paper_number":"7048","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-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"3148363","transaction_code":"A","transaction_date":"2026-04-12 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-04-13 21:37:00","snet_input_date":"2026-04-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-13 21:37:00","insp_carrier_name":"MERCER MILLING PRE-MIX COMPANY","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-24T09:30:10.000000Z","updated_at":"2026-04-24T09:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20222136,"change_date":"2026-04-13 21:37:00","inspection_id":"87554879","insp_unit_id":"212974833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"974748","insp_unit_license":"31226TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR0LSLG3514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:02:23.000000Z","updated_at":"2026-04-24T09:02:23.000000Z"},{"id":20222137,"change_date":"2026-04-13 21:37:00","inspection_id":"87554879","insp_unit_id":"212974834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"874067","insp_unit_license":"PF30257","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9622LB169451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:02:23.000000Z","updated_at":"2026-04-24T09:02:23.000000Z"}]},{"id":11323339,"change_date":"2026-03-09 21:36:00","inspection_id":"87240131","dot_number":"627478","report_state":"NY","report_number":"SPD3031953","insp_date":"2026-03-03 00:00:00","insp_start_time":"0730","insp_end_time":"0748","registration_date":null,"region":"ES","ci_status_code":"C","location":"20141","location_desc":"CAZENOVIA NY","county_code_state":"NY","county_code":"053","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITHVA FARM","shipping_paper_number":"275035","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-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"2982221","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-03-09 21:36:00","snet_input_date":"2026-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-09 21:36:00","insp_carrier_name":"MERCER MILLING PRE-MIX COMPANY","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-12T09:40:21.000000Z","updated_at":"2026-03-20T09:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19373672,"change_date":"2026-03-09 21:36:00","inspection_id":"87240131","insp_unit_id":"212041182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"874067","insp_unit_license":"PF30257","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9622LB169451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:05.000000Z","updated_at":"2026-03-20T09:03:09.000000Z"},{"id":19373671,"change_date":"2026-03-09 21:36:00","inspection_id":"87240131","insp_unit_id":"212041181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"974748","insp_unit_license":"31226TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR0LSLG3514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:05.000000Z","updated_at":"2026-03-20T09:03:09.000000Z"}]},{"id":11304929,"change_date":"2026-03-06 21:41:00","inspection_id":"87220698","dot_number":"627478","report_state":"NY","report_number":"SPD3081703","insp_date":"2026-02-27 00:00:00","insp_start_time":"0922","insp_end_time":"0937","registration_date":null,"region":"ES","ci_status_code":"C","location":"70719","location_desc":"RODMAN NY","county_code_state":"NY","county_code":"045","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-06 21:41: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":"2968929","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-03-06 21:41:00","snet_input_date":"2026-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-06 21:41:00","insp_carrier_name":"MERCER MILLING PRE-MIX COMPANY","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-09T09:42:20.000000Z","updated_at":"2026-03-17T09:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19337454,"change_date":"2026-03-06 21:41:00","inspection_id":"87220698","insp_unit_id":"212000597","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"273115","insp_unit_license":"12310BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR8RDNU2631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:17.000000Z","updated_at":"2026-03-17T09:02:05.000000Z"},{"id":19337455,"change_date":"2026-03-06 21:41:00","inspection_id":"87220698","insp_unit_id":"212000598","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"303005","insp_unit_license":"P698013","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1P062XKK169819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:17.000000Z","updated_at":"2026-03-17T09:02:05.000000Z"}]},{"id":11464252,"change_date":"2026-03-24 21:40:00","inspection_id":"87382478","dot_number":"627478","report_state":"VT","report_number":"50B0002740","insp_date":"2026-01-27 00:00:00","insp_start_time":"0750","insp_end_time":"0803","registration_date":null,"region":"ES","ci_status_code":"C","location":"1107SH","location_desc":"VT","county_code_state":"VT","county_code":"021","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3059336","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-01-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:25.000000Z","updated_at":"2026-04-04T09:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19636247,"change_date":"2026-03-24 21:40:00","inspection_id":"87382478","insp_unit_id":"212307507","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"333154","insp_unit_license":"3450505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9RDUS9963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:01.000000Z","updated_at":"2026-04-04T09:04:35.000000Z"},{"id":19636248,"change_date":"2026-03-24 21:40:00","inspection_id":"87382478","insp_unit_id":"212307508","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"333153","insp_unit_license":"CD85658","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9622RB620192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:01.000000Z","updated_at":"2026-04-04T09:04:35.000000Z"}]},{"id":10803510,"change_date":"2026-01-19 21:34:00","inspection_id":"86830287","dot_number":"627478","report_state":"NY","report_number":"SPT3091337","insp_date":"2026-01-12 00:00:00","insp_start_time":"1438","insp_end_time":"1451","registration_date":null,"region":"ES","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","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":"2026-01-19 21:34: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":"2785061","transaction_code":"A","transaction_date":"2026-01-18 00:00:00","upload_date":"2026-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-01-19 21:34:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-19 21:34:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-22T10:36:01.000000Z","updated_at":"2026-01-30T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18138814,"change_date":"2026-01-19 21:34:00","inspection_id":"86830287","insp_unit_id":"211160754","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3194222","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDR8NSNR3004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:09.000000Z","updated_at":"2026-01-30T10:00:11.000000Z"},{"id":18138815,"change_date":"2026-01-19 21:34:00","inspection_id":"86830287","insp_unit_id":"211160755","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CD85658","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9622RB620192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:09.000000Z","updated_at":"2026-01-30T10:00:11.000000Z"}]},{"id":10622212,"change_date":"2026-01-12 21:38:00","inspection_id":"86762682","dot_number":"627478","report_state":"NY","report_number":"SPD3061432","insp_date":"2026-01-05 00:00:00","insp_start_time":"1144","insp_end_time":"1159","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":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2752235","transaction_code":"A","transaction_date":"2026-01-11 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2026-01-12 21:38:00","snet_input_date":"2026-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-12 21:38:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-15T10:36:52.000000Z","updated_at":"2026-01-23T10:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17810112,"change_date":"2026-01-12 21:38:00","inspection_id":"86762682","insp_unit_id":"211021169","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"876004","insp_unit_license":"95060NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2KDLG5760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:08:47.000000Z","updated_at":"2026-01-24T10:00:37.000000Z"}]},{"id":10311208,"change_date":"2025-12-01 21:38:00","inspection_id":"86437529","dot_number":"627478","report_state":"NY","report_number":"D700500502","insp_date":"2025-11-25 00:00:00","insp_start_time":"0803","insp_end_time":"0827","registration_date":null,"region":"ES","ci_status_code":"C","location":"10211","location_desc":"CROWN POINT NY","county_code_state":"NY","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCER MILLING COMPANY","shipping_paper_number":"270606","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-01 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":"2603163","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-12-01 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-01 21:38:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:24.000000Z","updated_at":"2025-12-05T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17219230,"change_date":"2025-12-01 21:38:00","inspection_id":"86437529","insp_unit_id":"210312645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"387407","insp_unit_license":"3120431","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV7NSMS8249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:27.000000Z","updated_at":"2025-12-05T10:00:21.000000Z"},{"id":17219231,"change_date":"2025-12-01 21:38:00","inspection_id":"86437529","insp_unit_id":"210312646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"330545","insp_unit_license":"P697546","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C7KR456034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:27.000000Z","updated_at":"2025-12-05T10:00:21.000000Z"}]},{"id":9781010,"change_date":"2025-10-06 21:40:00","inspection_id":"85879380","dot_number":"627478","report_state":"VT","report_number":"3500000436","insp_date":"2025-09-23 00:00:00","insp_start_time":"0750","insp_end_time":"0833","registration_date":"2025-10-02 00:00:00","region":"ET","ci_status_code":"C","location":"1107SH","location_desc":"FAIR HAVEN SCALE HOUSE","county_code_state":"VT","county_code":"021","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCER MILLING CO","shipping_paper_number":"267706","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"220646","transaction_code":"C","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-09-25 21:41:00","snet_input_date":"2025-09-23 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-09-25 21:41:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:10.000000Z","updated_at":"2025-10-10T10:00:34.000000Z","inspection_violations":[{"id":16247168,"change_date":"2025-10-06 21:40:00","inspection_id":"85879380","insp_violation_id":"269119994","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209316065","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:15:57.000000Z","updated_at":"2025-10-10T10:15:58.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16356172,"change_date":"2025-10-06 21:40:00","inspection_id":"85879380","insp_unit_id":"209316065","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FTL","insp_unit_company":"33154","insp_unit_license":"3450505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9RDUS9963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:38.000000Z","updated_at":"2025-10-10T09:45:38.000000Z"},{"id":16356173,"change_date":"2025-10-06 21:40:00","inspection_id":"85879380","insp_unit_id":"209316066","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"333153","insp_unit_license":"CD85658","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9622RB620192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:38.000000Z","updated_at":"2025-10-10T09:45:38.000000Z"}]},{"id":9690792,"change_date":"2025-09-16 21:39:00","inspection_id":"85784997","dot_number":"627478","report_state":"NY","report_number":"D103001538","insp_date":"2025-09-09 00:00:00","insp_start_time":"1200","insp_end_time":"1224","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SCHUYLER LAKE NY","county_code_state":"NY","county_code":"077","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-09-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"131000","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":"2280503","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:49.000000Z","updated_at":"2025-09-23T10:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16041427,"change_date":"2025-09-16 21:39:00","inspection_id":"85784997","insp_unit_id":"208970171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"31226TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR0LSLG3514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:37.000000Z","updated_at":"2025-09-20T09:45:11.000000Z"},{"id":16041428,"change_date":"2025-09-16 21:39:00","inspection_id":"85784997","insp_unit_id":"208970172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"874067","insp_unit_license":"PF30257","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9622LB169451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:37.000000Z","updated_at":"2025-09-20T09:45:11.000000Z"}]},{"id":9398936,"change_date":"2025-08-13 21:38:00","inspection_id":"85478281","dot_number":"627478","report_state":"NY","report_number":"SPT3080956","insp_date":"2025-08-07 00:00:00","insp_start_time":"0803","insp_end_time":"0825","registration_date":null,"region":"ED","ci_status_code":"C","location":"40055M","location_desc":"BATAVIA NY","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"265832","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-13 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":"2122677","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-08-13 21:38:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-13 21:38:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:17.000000Z","updated_at":"2025-08-17T10:00:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18661717,"change_date":null,"inspection_id":"85478281","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"17087BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR0LSMF8740","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18823136,"change_date":null,"inspection_id":"85478281","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CD85626","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629PB448865","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9328987,"change_date":"2025-08-05 21:38:00","inspection_id":"85404778","dot_number":"627478","report_state":"NY","report_number":"SPD3011095","insp_date":"2025-07-29 00:00:00","insp_start_time":"1013","insp_end_time":"1029","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HERKIMER NY","county_code_state":"NY","county_code":"043","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCER MILLING CO","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-08-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2085200","transaction_code":"A","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-08-05 21:38:00","snet_input_date":"2025-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-05 21:38:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-08T10:01:13.000000Z","updated_at":"2025-08-12T10:41:13.000000Z","inspection_violations":[{"id":18463366,"change_date":null,"inspection_id":"85404778","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BAIR"},{"id":18463367,"change_date":null,"inspection_id":"85404778","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A1-TAOBETA","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A1TAOBETA"},{"id":18463368,"change_date":null,"inspection_id":"85404778","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOLTIS"}],"inspection_per_units":[{"id":18738538,"change_date":null,"inspection_id":"85404778","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"12511BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR0LSMF8740","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18822255,"change_date":null,"inspection_id":"85404778","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CD85626","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629PB448865","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9175497,"change_date":"2025-09-30 21:39:00","inspection_id":"85243356","dot_number":"627478","report_state":"VT","report_number":"2161010554","insp_date":"2025-07-15 00:00:00","insp_start_time":"1049","insp_end_time":"1059","registration_date":"2025-09-30 00:00:00","region":"ET","ci_status_code":"C","location":"1107","location_desc":"FAIR HAVEN","county_code_state":"VT","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"218718","transaction_code":"C","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:16.000000Z","updated_at":"2025-10-04T10:00:09.000000Z","inspection_violations":[{"id":16143378,"change_date":"2025-09-30 21:39:00","inspection_id":"85243356","insp_violation_id":"269006962","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-03T10:17:41.000000Z","updated_at":"2025-10-04T10:15:18.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16264561,"change_date":"2025-09-30 21:39:00","inspection_id":"85243356","insp_unit_id":"209219739","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"692403","insp_unit_license":"3265720","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH4PN329298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-03T09:47:11.000000Z","updated_at":"2025-10-04T09:45:15.000000Z"},{"id":16264562,"change_date":"2025-09-30 21:39:00","inspection_id":"85243356","insp_unit_id":"209219740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"CD85626","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629PB448865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-03T09:47:11.000000Z","updated_at":"2025-10-04T09:45:15.000000Z"}]},{"id":9173409,"change_date":"2025-07-17 21:41:00","inspection_id":"85241110","dot_number":"627478","report_state":"NY","report_number":"SPD3011020","insp_date":"2025-07-11 00:00:00","insp_start_time":"0747","insp_end_time":"0802","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":"MERCER MILLING CO","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-17 21:41: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":"2004345","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:08.000000Z","updated_at":"2025-07-21T10:43:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18736622,"change_date":null,"inspection_id":"85241110","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"12310BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR8RDNU2631","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18820275,"change_date":null,"inspection_id":"85241110","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P698013","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1P062XKK169819","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8566726,"change_date":"2025-05-07 21:43:00","inspection_id":"84600607","dot_number":"627478","report_state":"NY","report_number":"D306101241","insp_date":"2025-05-05 00:00:00","insp_start_time":"0910","insp_end_time":"0946","registration_date":null,"region":"ED","ci_status_code":"C","location":"90633S","location_desc":"OXFORD NY","county_code_state":"NY","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WINSOR ACRES","shipping_paper_number":"261895","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-07 21:43: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1696153","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:25.000000Z","updated_at":"2025-05-11T10:11:53.000000Z","inspection_violations":[{"id":18450169,"change_date":null,"inspection_id":"84600607","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311BCSURR"},{"id":18450170,"change_date":null,"inspection_id":"84600607","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18651097,"change_date":null,"inspection_id":"84600607","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"17087BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR0LSMF8740","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18811808,"change_date":null,"inspection_id":"84600607","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CD85626","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629PB448865","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8295268,"change_date":"2025-04-04 21:40:00","inspection_id":"84314521","dot_number":"627478","report_state":"NY","report_number":"D306101117","insp_date":"2025-04-03 00:00:00","insp_start_time":"1106","insp_end_time":"1147","registration_date":null,"region":"ED","ci_status_code":"C","location":"30690M","location_desc":"PREBLE NY","county_code_state":"NY","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1555306","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:01.000000Z","updated_at":"2025-04-08T10:09:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18647577,"change_date":null,"inspection_id":"84314521","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"95060NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2KDLG5760","insp_unit_decal":null,"insp_unit_decal_number":"35216759","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7590323,"change_date":"2025-01-10 21:39:00","inspection_id":"83573616","dot_number":"627478","report_state":"NY","report_number":"D507101228","insp_date":"2025-01-08 00:00:00","insp_start_time":"0919","insp_end_time":"0930","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"VARYSBURG NY","county_code_state":"NY","county_code":"121","insp_level_id":"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-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234140","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:42.000000Z","updated_at":"2025-03-17T20:55:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18638273,"change_date":null,"inspection_id":"83573616","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"95060NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC2KDLG5760","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7123004,"change_date":"2024-11-05 21:38:00","inspection_id":"83081269","dot_number":"627478","report_state":"NY","report_number":"SPD3020425","insp_date":"2024-10-29 00:00:00","insp_start_time":"1100","insp_end_time":"1125","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GERMAN FLATS NY","county_code_state":"NY","county_code":"043","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCER MILLING CO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"3","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":"1021511","transaction_code":"A","transaction_date":"2024-11-05 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2024-11-05 21:38:00","snet_input_date":"2024-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-05 21:38:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[{"id":18426630,"change_date":null,"inspection_id":"83081269","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311A1CSLRR"},{"id":18426631,"change_date":null,"inspection_id":"83081269","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"},{"id":18426632,"change_date":null,"inspection_id":"83081269","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":18709408,"change_date":null,"inspection_id":"83081269","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"31226TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR0LSLG3514","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18790477,"change_date":null,"inspection_id":"83081269","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"PC58803","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D4RL418640","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6271473,"change_date":"2024-07-22 21:41:00","inspection_id":"82174447","dot_number":"627478","report_state":"NY","report_number":"SPD0272527","insp_date":"2024-07-19 00:00:00","insp_start_time":"1147","insp_end_time":"1203","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":"MERCER MILLING CO","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-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2938609","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2024-07-22 21:41:00","snet_input_date":"2024-07-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-22 21:41:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:01.000000Z","updated_at":"2025-03-17T20:27:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18620210,"change_date":null,"inspection_id":"82174447","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3450505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9RDUS9963","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18777881,"change_date":null,"inspection_id":"82174447","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"CD85658","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9622RB620192","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5729378,"change_date":"2024-05-13 21:41:00","inspection_id":"81588722","dot_number":"627478","report_state":"NY","report_number":"SPE0311641","insp_date":"2024-05-08 00:00:00","insp_start_time":"1240","insp_end_time":"1301","registration_date":null,"region":"ET","ci_status_code":"C","location":"30100","location_desc":"BRUTUS (EXIT 40)","county_code_state":"NY","county_code":"011","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":"2024-05-13 21:41: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":"2922881","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2024-05-13 21:41:00","snet_input_date":"2024-05-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-13 21:41:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:18.000000Z","updated_at":"2025-03-17T20:16:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18690084,"change_date":null,"inspection_id":"81588722","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"12511BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR0LSMF8740","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18769404,"change_date":null,"inspection_id":"81588722","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"CD85626","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629PB448865","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5404510,"change_date":"2024-03-31 21:32:00","inspection_id":"81234356","dot_number":"627478","report_state":"NY","report_number":"SPD1020073","insp_date":"2024-03-25 00:00:00","insp_start_time":"0855","insp_end_time":"0909","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CANASTOTA NY","county_code_state":"NY","county_code":"053","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCER MILLING 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":"2024-03-31 21:32: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":"358421","transaction_code":"A","transaction_date":"2024-03-31 00:00:00","upload_date":"2024-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2024-03-31 21:32:00","snet_input_date":"2024-03-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-31 21:32:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:50.000000Z","updated_at":"2025-03-17T20:09:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18607905,"change_date":null,"inspection_id":"81234356","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"31226TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR0LSLG3514","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18764478,"change_date":null,"inspection_id":"81234356","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"PF30257","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A622LB169451","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5025849,"change_date":"2024-02-12 21:40:00","inspection_id":"80821679","dot_number":"627478","report_state":"NY","report_number":"D507800329","insp_date":"2024-02-08 00:00:00","insp_start_time":"1238","insp_end_time":"1356","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"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":null,"shipping_paper_number":"241312","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"235093","transaction_code":"A","transaction_date":"2024-02-12 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2024-02-12 21:40:00","snet_input_date":"2024-02-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-12 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:22.000000Z","updated_at":"2025-03-17T20:02:22.000000Z","inspection_violations":[{"id":18386399,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"33A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39233AD"},{"id":18386400,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"4A-DOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3924ADOSP"},{"id":18386401,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"7A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3927AD"},{"id":18386402,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"},{"id":18386403,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39522GELDMFV"},{"id":18386404,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":18386405,"change_date":null,"inspection_id":"80821679","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18680149,"change_date":null,"inspection_id":"80821679","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"31227TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR2LSLG3515","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18758473,"change_date":null,"inspection_id":"80821679","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P868688","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9620LB169450","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5003481,"change_date":"2024-02-08 21:42:00","inspection_id":"80797167","dot_number":"627478","report_state":"NY","report_number":"D305800394","insp_date":"2024-02-07 00:00:00","insp_start_time":"1125","insp_end_time":"1235","registration_date":null,"region":"ES","ci_status_code":"C","location":"60533N","location_desc":"HIMROD NY","county_code_state":"NY","county_code":"123","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MERCER MILLING COMPANY. INC.","shipping_paper_number":"241712","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"228307","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:59.000000Z","updated_at":"2025-03-17T20:01:59.000000Z","inspection_violations":[{"id":18385960,"change_date":null,"inspection_id":"80797167","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39355EB"},{"id":18385961,"change_date":null,"inspection_id":"80797167","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOL"},{"id":18385962,"change_date":null,"inspection_id":"80797167","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9B-LCL","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939BLCL"},{"id":18385963,"change_date":null,"inspection_id":"80797167","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1-TFCV","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1TFCV"},{"id":18385959,"change_date":null,"inspection_id":"80797167","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2B","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2B"}],"inspection_per_units":[{"id":18679791,"change_date":null,"inspection_id":"80797167","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"31226TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDR0LSLG3514","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18758076,"change_date":null,"inspection_id":"80797167","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"P868689","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9622LB169451","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4996220,"change_date":"2024-02-15 21:42:00","inspection_id":"80789187","dot_number":"627478","report_state":"VT","report_number":"2161008482","insp_date":"2024-02-05 00:00:00","insp_start_time":"0757","insp_end_time":"0822","registration_date":"2024-02-14 00:00:00","region":"ET","ci_status_code":"C","location":"0114","location_desc":"ORWELL","county_code_state":"VT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCER MILLING CO","shipping_paper_number":"241521","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":null,"post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"203496","transaction_code":"C","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2024-02-12 21:40:00","snet_input_date":"2024-02-05 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-02-07 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":18385796,"change_date":null,"inspection_id":"80789187","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2WC","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":18601956,"change_date":null,"inspection_id":"80789187","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3450505","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9RDUS9963","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18757949,"change_date":null,"inspection_id":"80789187","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"CD85658","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9622RB620192","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4984557,"change_date":"2024-02-06 21:41:00","inspection_id":"80776359","dot_number":"627478","report_state":"NY","report_number":"SPD0235562","insp_date":"2024-02-02 00:00:00","insp_start_time":"0907","insp_end_time":"0922","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":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":"N","pen_cen_match":null,"final_status_date":"2024-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2904531","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2024-02-06 21:41:00","snet_input_date":"2024-02-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-06 21:41:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:36.000000Z","updated_at":"2025-03-17T20:01:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18679502,"change_date":null,"inspection_id":"80776359","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"12310BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHLDR8RDNU2631","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18757745,"change_date":null,"inspection_id":"80776359","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"P698013","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1P062XKK169819","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4627247,"change_date":"2023-12-14 21:42:00","inspection_id":"80385762","dot_number":"627478","report_state":"NY","report_number":"D305800182","insp_date":"2023-12-13 00:00:00","insp_start_time":"1132","insp_end_time":"1208","registration_date":null,"region":"ES","ci_status_code":"C","location":"60533N","location_desc":"HIMROD NY","county_code_state":"NY","county_code":"123","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"2023-12-14 21:42: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132244","transaction_code":"A","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2023-12-14 21:42:00","snet_input_date":"2023-12-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-14 21:42:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:33.000000Z","updated_at":"2025-03-17T19:54:33.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4212906,"change_date":"2023-10-17 21:41:00","inspection_id":"79928835","dot_number":"627478","report_state":"NY","report_number":"SPD0235198","insp_date":"2023-10-16 00:00:00","insp_start_time":"0950","insp_end_time":"1018","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":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-17 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":"2879518","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2023-10-17 21:41:00","snet_input_date":"2023-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-17 21:41:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:16.000000Z","updated_at":"2025-03-17T19:46:16.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4191638,"change_date":"2023-10-13 21:40:00","inspection_id":"79905333","dot_number":"627478","report_state":"NY","report_number":"SPD0291371","insp_date":"2023-10-09 00:00:00","insp_start_time":"1245","insp_end_time":"1318","registration_date":null,"region":"ET","ci_status_code":"C","location":"20253A","location_desc":"EATON","county_code_state":"NY","county_code":"053","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-10-13 21:40: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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2878321","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3442345,"change_date":"2023-07-06 21:42:00","inspection_id":"79068991","dot_number":"627478","report_state":"NY","report_number":"SPA0275430","insp_date":"2023-06-29 00:00:00","insp_start_time":"0826","insp_end_time":"0852","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2844128","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2023-07-06 21:42:00","snet_input_date":"2023-07-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-06 21:42:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:17.000000Z","updated_at":"2025-03-17T19:31:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3246213,"change_date":"2023-06-09 21:40:00","inspection_id":"78848329","dot_number":"627478","report_state":"NY","report_number":"SPWG020837","insp_date":"2023-06-07 00:00:00","insp_start_time":"1236","insp_end_time":"1257","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (SB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2834672","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":null,"census_search_date":"2023-06-09 21:40:00","snet_input_date":"2023-06-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2869017,"change_date":"2023-04-24 21:40:00","inspection_id":"78422287","dot_number":"627478","report_state":"NY","report_number":"0322004266","insp_date":"2023-04-21 00:00:00","insp_start_time":"0856","insp_end_time":"0929","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":"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":"2023-04-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2818532","transaction_code":"A","transaction_date":"2023-04-24 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2023-04-24 21:40:00","snet_input_date":"2023-04-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-24 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:41.000000Z","updated_at":"2025-03-17T19:19:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1778957,"change_date":"2022-11-21 21:40:00","inspection_id":"77179023","dot_number":"627478","report_state":"NY","report_number":"SPA0185687","insp_date":"2022-11-17 00:00:00","insp_start_time":"0900","insp_end_time":"0953","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MERCER","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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2772004","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00627478","upload_search_indicator":"M","census_search_date":"2022-11-21 21:40:00","snet_input_date":"2022-11-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-21 21:40:00","insp_carrier_name":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:21.000000Z","updated_at":"2025-03-17T18:59:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1300214,"change_date":"2022-09-16 21:40:00","inspection_id":"76626819","dot_number":"627478","report_state":"NY","report_number":"MC42003368","insp_date":"2022-09-15 00:00:00","insp_start_time":"1204","insp_end_time":"1314","registration_date":null,"region":"ET","ci_status_code":"C","location":"40045","location_desc":"V\/AVON","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2749629","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":"00627478","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":"MERCER MILLING CO","insp_carrier_street":"4698 CROSSROADS PARK","insp_carrier_city":"LIVERPOOL","insp_carrier_state":"NY","insp_carrier_zip_code":"13088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:47.000000Z","updated_at":"2025-03-17T18:50:47.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/627478\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/627478\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/627478\/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\/627478\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}