{"current_page":1,"data":[{"id":10062137,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","dot_number":"2377687","report_state":"NY","report_number":"SPB3110924","insp_date":"2025-10-22 00:00:00","insp_start_time":"1218","insp_end_time":"1342","registration_date":"2025-11-23 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"MALONE NY","county_code_state":"NY","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RICHARDS LOGGING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"156000","viol_total":"7","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2472287","transaction_code":"C","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":"2025-10-29 21:40:00","snet_input_date":"2025-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"DANA SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:23.000000Z","updated_at":"2025-11-28T10:30:05.000000Z","inspection_violations":[{"id":17168851,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250913","seq_no":"1","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"3922WG"},{"id":17168852,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250914","seq_no":"2","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"3922WG"},{"id":17168853,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250915","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"210226116","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"3922SLLIFTA"},{"id":17168854,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250916","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210226116","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"3922SLLSR"},{"id":17168855,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250917","seq_no":"5","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"3922WG"},{"id":17168856,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250918","seq_no":"6","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210226117","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8B10KWZDC9","created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"39375A3TAOL"},{"id":17168857,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_violation_id":"270250919","seq_no":"7","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210226116","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:39.000000Z","updated_at":"2025-11-28T10:30:13.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":17144381,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_unit_id":"210226116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"34955PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDB9X45N874130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:25.000000Z","updated_at":"2025-11-28T10:00:08.000000Z"},{"id":17144382,"change_date":"2025-11-24 21:38:00","inspection_id":"86175422","insp_unit_id":"210226117","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELOUPE","insp_unit_company":null,"insp_unit_license":"CH14206","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2D9GA4636G1004067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:25.000000Z","updated_at":"2025-11-28T10:00:08.000000Z"}]},{"id":9577162,"change_date":"2025-10-27 21:38:00","inspection_id":"85665889","dot_number":"2377687","report_state":"NY","report_number":"SPB3061250","insp_date":"2025-08-27 00:00:00","insp_start_time":"1435","insp_end_time":"1504","registration_date":"2025-10-26 00:00:00","region":"ED","ci_status_code":"C","location":"70655N","location_desc":"PERU NY","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOINTA LIME","shipping_paper_number":"40082","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-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"159000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2213022","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":"2025-09-03 21:39:00","snet_input_date":"2025-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-03 21:39:00","insp_carrier_name":"DANA SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:18.000000Z","updated_at":"2025-11-01T10:00:09.000000Z","inspection_violations":[{"id":16609225,"change_date":"2025-10-27 21:38:00","inspection_id":"85665889","insp_violation_id":"269531729","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"209667949","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-30T10:15:37.000000Z","updated_at":"2025-10-31T10:15:15.000000Z","normalized_code":"39355C1B"},{"id":16609226,"change_date":"2025-10-27 21:38:00","inspection_id":"85665889","insp_violation_id":"269531730","seq_no":"2","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"209667949","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-30T10:15:37.000000Z","updated_at":"2025-10-31T10:15:15.000000Z","normalized_code":"39355D2B"},{"id":16609227,"change_date":"2025-10-27 21:38:00","inspection_id":"85665889","insp_violation_id":"269531731","seq_no":"3","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209667950","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-30T10:15:37.000000Z","updated_at":"2025-10-31T10:15:15.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16680549,"change_date":"2025-10-27 21:38:00","inspection_id":"85665889","insp_unit_id":"209667950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL KING","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:35.000000Z","updated_at":"2025-10-31T09:45:08.000000Z"},{"id":16680548,"change_date":"2025-10-27 21:38:00","inspection_id":"85665889","insp_unit_id":"209667949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"11","insp_unit_license":"50287PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:35.000000Z","updated_at":"2025-10-31T09:45:08.000000Z"}]},{"id":8967481,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","dot_number":"2377687","report_state":"NY","report_number":"SPF3021009","insp_date":"2025-06-17 00:00:00","insp_start_time":"1105","insp_end_time":"1128","registration_date":null,"region":"ED","ci_status_code":"C","location":"70144S","location_desc":"CHAMPLAIN NY","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","viol_total":"6","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":"1905152","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":"2025-06-24 21:40:00","snet_input_date":"2025-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-24 21:40:00","insp_carrier_name":"DANA SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:46.000000Z","updated_at":"2025-06-28T10:00:46.000000Z","inspection_violations":[{"id":14408488,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_violation_id":"267002601","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"207519475","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:10.000000Z","updated_at":"2025-06-28T10:16:57.000000Z","normalized_code":"3939ALLPL"},{"id":14408489,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_violation_id":"267002602","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207519474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:10.000000Z","updated_at":"2025-06-28T10:16:57.000000Z","normalized_code":"39021TB1MC"},{"id":14408490,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_violation_id":"267002603","seq_no":"3","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"207519474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:10.000000Z","updated_at":"2025-06-28T10:16:57.000000Z","normalized_code":"39021TCMC"},{"id":14408491,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_violation_id":"267002604","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207519474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:10.000000Z","updated_at":"2025-06-28T10:16:57.000000Z","normalized_code":"3922SLLIFTA"},{"id":14408492,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_violation_id":"267002605","seq_no":"5","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"207519474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:10.000000Z","updated_at":"2025-06-28T10:16:57.000000Z","normalized_code":"3922SLLIRP"},{"id":14408493,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_violation_id":"267002606","seq_no":"6","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207519474","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:10.000000Z","updated_at":"2025-06-28T10:16:57.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":14701926,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_unit_id":"207519474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:31.000000Z","updated_at":"2025-06-28T09:45:17.000000Z"},{"id":14701927,"change_date":"2025-06-24 21:40:00","inspection_id":"85024579","insp_unit_id":"207519475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL KING","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:31.000000Z","updated_at":"2025-06-28T09:45:17.000000Z"}]},{"id":6401318,"change_date":"2024-08-06 21:43:00","inspection_id":"82313211","dot_number":"2377687","report_state":"NY","report_number":"SPG0215912","insp_date":"2024-07-23 00:00:00","insp_start_time":"0930","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","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-08-06 21:43: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":"2942736","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"DANA SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:50.000000Z","updated_at":"2025-03-17T20:29:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10316025,"change_date":"2024-08-06 21:43:00","inspection_id":"82313211","insp_unit_id":"202256447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:55.000000Z","updated_at":"2025-03-17T23:29:55.000000Z"},{"id":10316026,"change_date":"2024-08-06 21:43:00","inspection_id":"82313211","insp_unit_id":"202256448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:55.000000Z","updated_at":"2025-03-17T23:29:55.000000Z"}]},{"id":6101074,"change_date":"2024-07-09 21:43:00","inspection_id":"81991311","dot_number":"2377687","report_state":"NY","report_number":"SPL0156949","insp_date":"2024-06-26 00:00:00","insp_start_time":"1048","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","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-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2933533","transaction_code":"C","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"DANA SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[{"id":9469884,"change_date":"2024-07-09 21:43:00","inspection_id":"81991311","insp_violation_id":"260535561","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201792011","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9826734,"change_date":"2024-07-09 21:43:00","inspection_id":"81991311","insp_unit_id":"201792010","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:48.000000Z","updated_at":"2025-03-17T23:24:48.000000Z"},{"id":9826735,"change_date":"2024-07-09 21:43:00","inspection_id":"81991311","insp_unit_id":"201792011","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:48.000000Z","updated_at":"2025-03-17T23:24:48.000000Z"}]},{"id":4124606,"change_date":"2023-10-09 21:35:00","inspection_id":"79831404","dot_number":"2377687","report_state":"SC","report_number":"R373000376","insp_date":"2023-10-03 00:00:00","insp_start_time":"1815","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":"007","location_desc":"I-95 NB FLORENCE COUNTY","county_code_state":"SC","county_code":"041","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1109301","transaction_code":"C","transaction_date":"2023-10-08 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-03 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:25.000000Z","updated_at":"2025-03-17T19:44:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6631561,"change_date":"2023-10-09 21:35:00","inspection_id":"79831404","insp_unit_id":"197454365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETR","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"},{"id":6631562,"change_date":"2023-10-09 21:35:00","inspection_id":"79831404","insp_unit_id":"197454366","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"3","insp_unit_license":"5082003","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1T9AB5312EB540004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"}]},{"id":3885644,"change_date":"2023-09-01 21:39:00","inspection_id":"79565567","dot_number":"2377687","report_state":"NY","report_number":"SPB0372053","insp_date":"2023-08-28 00:00:00","insp_start_time":"0931","insp_end_time":"1012","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2864636","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:42.000000Z","updated_at":"2025-03-17T19:39:42.000000Z","inspection_violations":[{"id":6005316,"change_date":"2023-09-01 21:39:00","inspection_id":"79565567","insp_violation_id":"255037848","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196857929","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6247021,"change_date":"2023-09-01 21:39:00","inspection_id":"79565567","insp_unit_id":"196857928","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"},{"id":6247022,"change_date":"2023-09-01 21:39:00","inspection_id":"79565567","insp_unit_id":"196857929","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"}]},{"id":3576669,"change_date":"2023-08-01 21:41:00","inspection_id":"79220179","dot_number":"2377687","report_state":"OK","report_number":"PE10174801","insp_date":"2023-07-21 00:00:00","insp_start_time":"1635","insp_end_time":"1745","registration_date":"2023-07-31 00:00:00","region":"CT","ci_status_code":"C","location":"43035","location_desc":"LOVE PORT ENTRY","county_code_state":"OK","county_code":"085","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"STREET SIDE CLASSICS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"717271","transaction_code":"C","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:35.000000Z","updated_at":"2025-03-17T19:33:35.000000Z","inspection_violations":[{"id":5514497,"change_date":"2023-08-01 21:41:00","inspection_id":"79220179","insp_violation_id":"254395206","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5750645,"change_date":"2023-08-01 21:41:00","inspection_id":"79220179","insp_unit_id":"196299167","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"10","insp_unit_license":"54209ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT8W3BT4LED56758","insp_unit_decal":"Y","insp_unit_decal_number":"33124861","created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"},{"id":5750646,"change_date":"2023-08-01 21:41:00","inspection_id":"79220179","insp_unit_id":"196299168","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APPA","insp_unit_company":"1","insp_unit_license":"CE91250","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"541GC4334PM000260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"}]},{"id":3574065,"change_date":"2023-07-24 21:41:00","inspection_id":"79217216","dot_number":"2377687","report_state":"NY","report_number":"SPT0482545","insp_date":"2023-07-18 00:00:00","insp_start_time":"1236","insp_end_time":"1252","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2849472","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:34.000000Z","updated_at":"2025-03-17T19:33:34.000000Z","inspection_violations":[{"id":5511300,"change_date":"2023-07-24 21:41:00","inspection_id":"79217216","insp_violation_id":"254224386","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"196145592","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39355D1"},{"id":5511301,"change_date":"2023-07-24 21:41:00","inspection_id":"79217216","insp_violation_id":"254224387","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196145593","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5746358,"change_date":"2023-07-24 21:41:00","inspection_id":"79217216","insp_unit_id":"196145592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:21.000000Z","updated_at":"2025-03-17T22:48:21.000000Z"},{"id":5746359,"change_date":"2023-07-24 21:41:00","inspection_id":"79217216","insp_unit_id":"196145593","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:21.000000Z","updated_at":"2025-03-17T22:48:21.000000Z"}]},{"id":3466305,"change_date":"2023-07-10 21:42:00","inspection_id":"79096440","dot_number":"2377687","report_state":"NC","report_number":"0006554821","insp_date":"2023-07-10 00:00:00","insp_start_time":"1221","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION, I-95,","county_code_state":"NC","county_code":"155","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"2088212","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-07-10 21:42:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:40.000000Z","updated_at":"2025-03-17T19:31:40.000000Z","inspection_violations":[{"id":5345003,"change_date":"2023-07-10 21:42:00","inspection_id":"79096440","insp_violation_id":"253954641","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:49.000000Z","updated_at":"2025-03-17T21:31:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5573339,"change_date":"2023-07-10 21:42:00","inspection_id":"79096440","insp_unit_id":"195903319","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"54209ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT8W3BT4LED56758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:00.000000Z","updated_at":"2025-03-17T22:47:00.000000Z"},{"id":5573340,"change_date":"2023-07-10 21:42:00","inspection_id":"79096440","insp_unit_id":"195903320","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APPA","insp_unit_company":null,"insp_unit_license":"CE91250","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"541GC4334PM000260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:00.000000Z","updated_at":"2025-03-17T22:47:00.000000Z"}]},{"id":3410603,"change_date":"2023-06-30 21:40:00","inspection_id":"79033616","dot_number":"2377687","report_state":"NY","report_number":"SPT0433163","insp_date":"2023-06-27 00:00:00","insp_start_time":"0746","insp_end_time":"0813","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655M","location_desc":"VALCOUR REST AREA (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2842928","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:35.000000Z","updated_at":"2025-03-17T19:30:35.000000Z","inspection_violations":[{"id":5258340,"change_date":"2023-06-30 21:40:00","inspection_id":"79033616","insp_violation_id":"253811221","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195775888","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"39617C"},{"id":5258341,"change_date":"2023-06-30 21:40:00","inspection_id":"79033616","insp_violation_id":"253811222","seq_no":"2","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"195775888","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:23.000000Z","updated_at":"2025-03-17T21:31:23.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":5483427,"change_date":"2023-06-30 21:40:00","inspection_id":"79033616","insp_unit_id":"195775887","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"},{"id":5483428,"change_date":"2023-06-30 21:40:00","inspection_id":"79033616","insp_unit_id":"195775888","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:15.000000Z","updated_at":"2025-03-17T22:46:15.000000Z"}]},{"id":2652935,"change_date":"2023-03-24 21:40:00","inspection_id":"78176469","dot_number":"2377687","report_state":"NY","report_number":"SPG0194444","insp_date":"2023-03-23 00:00:00","insp_start_time":"1128","insp_end_time":"1148","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697","location_desc":"QUEENSBURY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"QUALITY TRANSPORT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","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":"2809970","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-24 21:40:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:33.000000Z","updated_at":"2025-03-17T19:15:33.000000Z","inspection_violations":[{"id":4078046,"change_date":"2023-03-24 21:40:00","inspection_id":"78176469","insp_violation_id":"251850343","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"194046088","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39360D"},{"id":4078047,"change_date":"2023-03-24 21:40:00","inspection_id":"78176469","insp_violation_id":"251850344","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194046088","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4270839,"change_date":"2023-03-24 21:40:00","inspection_id":"78176469","insp_unit_id":"194046088","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"54209ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT8W3BT4LED56758","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:39.000000Z","updated_at":"2025-03-17T22:36:39.000000Z"},{"id":4270840,"change_date":"2023-03-24 21:40:00","inspection_id":"78176469","insp_unit_id":"194046089","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CE91250","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"541GC4334PM000260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:39.000000Z","updated_at":"2025-03-17T22:36:39.000000Z"}]},{"id":2343076,"change_date":"2023-04-27 21:42:00","inspection_id":"77823779","dot_number":"2377687","report_state":"VT","report_number":"4300006037","insp_date":"2023-02-07 00:00:00","insp_start_time":"1102","insp_end_time":"1121","registration_date":"2023-04-26 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":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MONSTER ENERGY CO","shipping_paper_number":"369341","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-02-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"196769","transaction_code":"C","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-07 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-02-10 21:39:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:56.000000Z","updated_at":"2025-03-17T19:09:56.000000Z","inspection_violations":[{"id":3608589,"change_date":"2023-04-27 21:42:00","inspection_id":"77823779","insp_violation_id":"252474108","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3958"},{"id":3608590,"change_date":"2023-04-27 21:42:00","inspection_id":"77823779","insp_violation_id":"252474109","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194615627","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"3922"},{"id":3608591,"change_date":"2023-04-27 21:42:00","inspection_id":"77823779","insp_violation_id":"252474110","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194615627","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":3770094,"change_date":"2023-04-27 21:42:00","inspection_id":"77823779","insp_unit_id":"194615626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETER","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:01.000000Z","updated_at":"2025-03-17T22:33:01.000000Z"},{"id":3770095,"change_date":"2023-04-27 21:42:00","inspection_id":"77823779","insp_unit_id":"194615627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"249732F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532W95L907675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:01.000000Z","updated_at":"2025-03-17T22:33:01.000000Z"}]},{"id":1384386,"change_date":"2022-09-28 21:40:00","inspection_id":"76724417","dot_number":"2377687","report_state":"NY","report_number":"SPWB020830","insp_date":"2022-09-27 00:00:00","insp_start_time":"0736","insp_end_time":"0751","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SPIEGEL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","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":"2753746","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:18.000000Z","updated_at":"2025-03-17T18:52:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2229068,"change_date":"2022-09-28 21:40:00","inspection_id":"76724417","insp_unit_id":"191136907","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:15.000000Z","updated_at":"2025-03-17T22:22:15.000000Z"},{"id":2229069,"change_date":"2022-09-28 21:40:00","inspection_id":"76724417","insp_unit_id":"191136908","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:15.000000Z","updated_at":"2025-03-17T22:22:15.000000Z"}]},{"id":1431777,"change_date":"2022-10-04 21:40:00","inspection_id":"76779437","dot_number":"2377687","report_state":"NY","report_number":"SPB0332033","insp_date":"2022-09-20 00:00:00","insp_start_time":"0750","insp_end_time":"0817","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOINTA LIME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2755543","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-04 21:40:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:04.000000Z","updated_at":"2025-03-17T18:53:04.000000Z","inspection_violations":[{"id":2254141,"change_date":"2022-10-04 21:40:00","inspection_id":"76779437","insp_violation_id":"248806709","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"191247168","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"39355C1"},{"id":2254142,"change_date":"2022-10-04 21:40:00","inspection_id":"76779437","insp_violation_id":"248806710","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191247168","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":2304571,"change_date":"2022-10-04 21:40:00","inspection_id":"76779437","insp_unit_id":"191247168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"},{"id":2304572,"change_date":"2022-10-04 21:40:00","inspection_id":"76779437","insp_unit_id":"191247169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"}]},{"id":1191889,"change_date":"2022-09-01 21:40:00","inspection_id":"76500992","dot_number":"2377687","report_state":"NY","report_number":"SPWB030710","insp_date":"2022-08-31 00:00:00","insp_start_time":"1445","insp_end_time":"1504","registration_date":null,"region":"ET","ci_status_code":"C","location":"70041R","location_desc":"I87 SB AUSABLE","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68500","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":"2745308","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-01 21:40:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:38.000000Z","updated_at":"2025-03-17T18:48:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1916629,"change_date":"2022-09-01 21:40:00","inspection_id":"76500992","insp_unit_id":"190672873","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:11.000000Z","updated_at":"2025-03-17T22:20:11.000000Z"},{"id":1916630,"change_date":"2022-09-01 21:40:00","inspection_id":"76500992","insp_unit_id":"190672874","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIA","insp_unit_company":"11","insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:11.000000Z","updated_at":"2025-03-17T22:20:11.000000Z"}]},{"id":1109039,"change_date":"2022-08-23 21:41:00","inspection_id":"76404727","dot_number":"2377687","report_state":"NY","report_number":"SPWB020812","insp_date":"2022-08-22 00:00:00","insp_start_time":"0756","insp_end_time":"0812","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SPIEGEL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"68500","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":"2742652","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:14.000000Z","updated_at":"2025-03-17T18:47:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1783545,"change_date":"2022-08-23 21:41:00","inspection_id":"76404727","insp_unit_id":"190479581","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETR","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:16.000000Z","updated_at":"2025-03-17T22:19:16.000000Z"},{"id":1783546,"change_date":"2022-08-23 21:41:00","inspection_id":"76404727","insp_unit_id":"190479582","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIA","insp_unit_company":"11","insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:16.000000Z","updated_at":"2025-03-17T22:19:16.000000Z"}]},{"id":911049,"change_date":"2022-07-28 21:40:00","inspection_id":"76172981","dot_number":"2377687","report_state":"NY","report_number":"SPWB090568","insp_date":"2022-07-27 00:00:00","insp_start_time":"0955","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655B","location_desc":"PERU (SB)","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2732595","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:43.000000Z","updated_at":"2025-03-17T18:43:43.000000Z","inspection_violations":[{"id":1437044,"change_date":"2022-07-28 21:40:00","inspection_id":"76172981","insp_violation_id":"247364244","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9FPRBKK","created_at":"2025-03-17T21:13:46.000000Z","updated_at":"2025-03-17T21:13:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1466236,"change_date":"2022-07-28 21:40:00","inspection_id":"76172981","insp_unit_id":"190006951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:13.000000Z","updated_at":"2025-03-17T22:17:13.000000Z"},{"id":1466237,"change_date":"2022-07-28 21:40:00","inspection_id":"76172981","insp_unit_id":"190006952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:13.000000Z","updated_at":"2025-03-17T22:17:13.000000Z"}]},{"id":744365,"change_date":"2022-07-05 21:41:00","inspection_id":"75978752","dot_number":"2377687","report_state":"NY","report_number":"SPWB020775","insp_date":"2022-06-29 00:00:00","insp_start_time":"0843","insp_end_time":"0901","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR  SB","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SPIEGEL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2724067","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-05 21:41:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:52.000000Z","updated_at":"2025-03-17T18:40:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1196351,"change_date":"2022-07-05 21:41:00","inspection_id":"75978752","insp_unit_id":"189588836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"},{"id":1196352,"change_date":"2022-07-05 21:41:00","inspection_id":"75978752","insp_unit_id":"189588837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"86","insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"}]},{"id":635386,"change_date":"2022-06-17 21:39:00","inspection_id":"75850228","dot_number":"2377687","report_state":"NY","report_number":"SPB0284698","insp_date":"2022-06-02 00:00:00","insp_start_time":"0920","insp_end_time":"0954","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOINTA LIME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2717631","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-17 21:39:00","insp_carrier_name":"SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:50.000000Z","updated_at":"2025-03-17T18:38:50.000000Z","inspection_violations":[{"id":998929,"change_date":"2022-06-17 21:39:00","inspection_id":"75850228","insp_violation_id":"246543090","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"189314539","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39355C1"},{"id":998930,"change_date":"2022-06-17 21:39:00","inspection_id":"75850228","insp_violation_id":"246543091","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"189314539","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39021B"},{"id":998931,"change_date":"2022-06-17 21:39:00","inspection_id":"75850228","insp_violation_id":"246543092","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189314540","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2FHW9FZ","created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1021229,"change_date":"2022-06-17 21:39:00","inspection_id":"75850228","insp_unit_id":"189314539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"79555PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPFDU9X25N878415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:28.000000Z","updated_at":"2025-03-17T22:14:28.000000Z"},{"id":1021230,"change_date":"2022-06-17 21:39:00","inspection_id":"75850228","insp_unit_id":"189314540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"86","insp_unit_license":"CA36133","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TKDS3432WB053953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:28.000000Z","updated_at":"2025-03-17T22:14:28.000000Z"}]},{"id":306948,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","dot_number":"2377687","report_state":"NY","report_number":"SPB0360718","insp_date":"2022-04-27 00:00:00","insp_start_time":"1655","insp_end_time":"1834","registration_date":null,"region":"ET","ci_status_code":"C","location":"10598B","location_desc":"NORTH HUDSON (SB)","county_code_state":"NY","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NELLSON LLC","shipping_paper_number":"233224","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"10","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2702004","transaction_code":"A","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02377687","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"DANA SPIEGEL","insp_carrier_street":"804 ROUTE 11","insp_carrier_city":"CHAMPLAIN","insp_carrier_state":"NY","insp_carrier_zip_code":"12919","insp_colonia":null,"docket_number":"854337","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:56.000000Z","updated_at":"2025-03-17T18:32:56.000000Z","inspection_violations":[{"id":477537,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529518","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"188469531","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39021B"},{"id":477538,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529519","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"188469531","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39021B"},{"id":477539,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529520","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188469531","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"},{"id":477540,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529521","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"188469531","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3969D2"},{"id":477541,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529522","seq_no":"5","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"188469531","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39355D1"},{"id":477542,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529523","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188469531","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39311"},{"id":477543,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529524","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188469532","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"},{"id":477544,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529525","seq_no":"8","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"188469532","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39355D3"},{"id":477545,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529526","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188469532","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3963A1"},{"id":477546,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_violation_id":"245529527","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188469532","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":496550,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_unit_id":"188469531","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"10","insp_unit_license":"76179PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB9X33D590941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"},{"id":496551,"change_date":"2022-05-03 21:39:00","inspection_id":"75459299","insp_unit_id":"188469532","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"232994H","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B5DL748956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2377687\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2377687\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2377687\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2377687\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}