{"current_page":1,"data":[{"id":12659642,"change_date":"2026-08-07 21:40:00","inspection_id":"88632160","dot_number":"1637233","report_state":"NY","report_number":"SPL3090112","insp_date":"2026-07-31 00:00:00","insp_start_time":"1237","insp_end_time":"1256","registration_date":"2026-08-04 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"DEER PARK NY","county_code_state":"NY","county_code":"103","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":"2026-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","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":"3929409","transaction_code":"A","transaction_date":"2026-08-06 00:00:00","upload_date":"2026-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-08-07 21:40:00","snet_input_date":"2026-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-07 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-11T09:41:57.000000Z","updated_at":"2026-08-18T09:30:16.000000Z","inspection_violations":[{"id":22040731,"change_date":"2026-08-07 21:40:00","inspection_id":"88632160","insp_violation_id":"275985526","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"215030514","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-10T10:01:38.000000Z","updated_at":"2026-08-19T09:39:25.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":21973891,"change_date":"2026-08-07 21:40:00","inspection_id":"88632160","insp_unit_id":"215030514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"NAC139","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZCXG119MGLY2756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-10T09:19:26.000000Z","updated_at":"2026-08-18T09:01:15.000000Z"}]},{"id":12414327,"change_date":"2026-07-10 21:41:00","inspection_id":"88372511","dot_number":"1637233","report_state":"NY","report_number":"D306002300","insp_date":"2026-07-09 00:00:00","insp_start_time":"0832","insp_end_time":"0849","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DRYDEN NY","county_code_state":"NY","county_code":null,"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":"2026-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16001","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":"3724699","transaction_code":"A","transaction_date":"2026-07-10 00:00:00","upload_date":"2026-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-07-10 21:41:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-10 21:41:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","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-21T09:30:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21566101,"change_date":"2026-07-10 21:41:00","inspection_id":"88372511","insp_unit_id":"214543794","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"NAC145","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W161N7K02950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:20.000000Z","updated_at":"2026-07-21T09:03:03.000000Z"}]},{"id":12314220,"change_date":"2026-06-29 21:42:00","inspection_id":"88271911","dot_number":"1637233","report_state":"NY","report_number":"0L12900077","insp_date":"2026-06-23 00:00:00","insp_start_time":"1454","insp_end_time":"1540","registration_date":"2026-06-26 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"ISLANDIA NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3647619","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:39.000000Z","updated_at":"2026-07-10T09:31:23.000000Z","inspection_violations":[{"id":21430118,"change_date":"2026-06-29 21:42:00","inspection_id":"88271911","insp_violation_id":"275198637","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214353090","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-02T10:00:55.000000Z","updated_at":"2026-07-10T09:42:53.000000Z","normalized_code":"39395F"},{"id":21430119,"change_date":"2026-06-29 21:42:00","inspection_id":"88271911","insp_violation_id":"275198638","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-02T10:00:55.000000Z","updated_at":"2026-07-10T09:42:53.000000Z","normalized_code":"39111B2Q"}],"inspection_per_units":[{"id":21387640,"change_date":"2026-06-29 21:42:00","inspection_id":"88271911","insp_unit_id":"214353090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MI\/FU","insp_unit_company":"136","insp_unit_license":"NAC136","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG116KGKK1487","insp_unit_decal":"Y","insp_unit_decal_number":"REPORT","created_at":"2026-07-02T09:17:37.000000Z","updated_at":"2026-07-10T09:02:40.000000Z"}]},{"id":12111646,"change_date":"2026-07-01 21:41:00","inspection_id":"88056573","dot_number":"1637233","report_state":"NY","report_number":"0L61001349","insp_date":"2026-06-02 00:00:00","insp_start_time":"1306","insp_end_time":"1336","registration_date":"2026-07-01 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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":"2026-06-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3477415","transaction_code":"C","transaction_date":"2026-06-05 00:00:00","upload_date":"2026-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-06-06 21:37:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-06 21:37:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-09T09:40:44.000000Z","updated_at":"2026-07-13T09:30:14.000000Z","inspection_violations":[{"id":21079233,"change_date":"2026-07-01 21:41:00","inspection_id":"88056573","insp_violation_id":"275245588","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T09:59:53.000000Z","updated_at":"2026-07-13T09:41:02.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":21043420,"change_date":"2026-07-01 21:41:00","inspection_id":"88056573","insp_unit_id":"214389761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"NAC140","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZCXG110MGLY2757","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-09T09:17:12.000000Z","updated_at":"2026-07-13T09:01:11.000000Z"}]},{"id":11959598,"change_date":"2026-05-19 21:40:00","inspection_id":"87895664","dot_number":"1637233","report_state":"NY","report_number":"SPF3030858","insp_date":"2026-05-12 00:00:00","insp_start_time":"1115","insp_end_time":"1140","registration_date":null,"region":"ED","ci_status_code":"C","location":"90718M","location_desc":"LIVINGSTON MANOR NY","county_code_state":"NY","county_code":"105","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3357781","transaction_code":"A","transaction_date":"2026-05-18 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:08.000000Z","updated_at":"2026-05-30T09:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20794932,"change_date":"2026-05-19 21:40:00","inspection_id":"87895664","insp_unit_id":"213638279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"NAC138","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:34.000000Z","updated_at":"2026-05-30T09:02:24.000000Z"}]},{"id":11728686,"change_date":"2026-04-23 21:39:00","inspection_id":"87656599","dot_number":"1637233","report_state":"NY","report_number":"0L12100408","insp_date":"2026-04-17 00:00:00","insp_start_time":"0721","insp_end_time":"0737","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BETHPAGE NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","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":"3201117","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-04-23 21:39:00","snet_input_date":"2026-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-23 21:39:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:56.000000Z","updated_at":"2026-05-04T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20408329,"change_date":"2026-04-23 21:39:00","inspection_id":"87656599","insp_unit_id":"213175847","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":"139","insp_unit_license":"NAC139","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZCXG119MGLY2756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:19:09.000000Z","updated_at":"2026-05-04T09:03:21.000000Z"}]},{"id":11157908,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","dot_number":"1637233","report_state":"NY","report_number":"SPT3150282","insp_date":"2026-02-12 00:00:00","insp_start_time":"0606","insp_end_time":"0641","registration_date":"2026-02-17 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"NEW ROCHELLE NY","county_code_state":"NY","county_code":"119","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":"2026-02-18 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2900877","transaction_code":"C","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-02-18 21:37:00","snet_input_date":"2026-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-18 21:37:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-21T10:37:49.000000Z","updated_at":"2026-03-02T10:30:06.000000Z","inspection_violations":[{"id":18719517,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","insp_violation_id":"271883402","seq_no":"1","part_no":"392","part_no_section":"9AA2-OA","insp_viol_unit":"1","insp_unit_id":"211697221","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-22T10:53:04.000000Z","updated_at":"2026-03-02T10:40:13.000000Z","normalized_code":"3929AA2OA"},{"id":18719518,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","insp_violation_id":"271883403","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"211697221","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:04.000000Z","updated_at":"2026-03-02T10:40:13.000000Z","normalized_code":"3939AHLLH"},{"id":18719519,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","insp_violation_id":"271883404","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211697221","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:04.000000Z","updated_at":"2026-03-02T10:40:13.000000Z","normalized_code":"39360C"},{"id":18719520,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","insp_violation_id":"271883405","seq_no":"4","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211697221","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:04.000000Z","updated_at":"2026-03-02T10:40:13.000000Z","normalized_code":"3922SLLUCR"},{"id":18719521,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","insp_violation_id":"271883406","seq_no":"5","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"211697221","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:04.000000Z","updated_at":"2026-03-02T10:40:13.000000Z","normalized_code":"39019TG"}],"inspection_per_units":[{"id":19053426,"change_date":"2026-02-19 21:39:00","inspection_id":"87072921","insp_unit_id":"211697221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"NAC138","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:19.000000Z","updated_at":"2026-03-02T10:02:31.000000Z"}]},{"id":11080290,"change_date":"2026-02-20 21:38:00","inspection_id":"86991450","dot_number":"1637233","report_state":"NY","report_number":"0L10300170","insp_date":"2026-02-09 00:00:00","insp_start_time":"0725","insp_end_time":"0825","registration_date":"2026-02-19 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"MERRICK NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17600","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":"2864001","transaction_code":"C","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:56.000000Z","updated_at":"2026-03-03T10:30:05.000000Z","inspection_violations":[{"id":18746710,"change_date":"2026-02-20 21:38:00","inspection_id":"86991450","insp_violation_id":"271915201","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211727937","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310L9NNT1","created_at":"2026-02-23T10:52:56.000000Z","updated_at":"2026-03-03T10:39:30.000000Z","normalized_code":"3939ALIL"},{"id":18746711,"change_date":"2026-02-20 21:38:00","inspection_id":"86991450","insp_violation_id":"271915202","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211727937","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310L9NP1X","created_at":"2026-02-23T10:52:56.000000Z","updated_at":"2026-03-03T10:39:30.000000Z","normalized_code":"3939ALHLI"},{"id":18746709,"change_date":"2026-02-20 21:38:00","inspection_id":"86991450","insp_violation_id":"271915200","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"211727937","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310L9NN6L","created_at":"2026-02-23T10:52:56.000000Z","updated_at":"2026-03-03T10:39:30.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":19095388,"change_date":"2026-02-20 21:38:00","inspection_id":"86991450","insp_unit_id":"211727937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"NAC119","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBE4C1174F503051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-23T10:13:20.000000Z","updated_at":"2026-03-03T10:03:20.000000Z"}]},{"id":11091438,"change_date":"2026-02-18 21:38:00","inspection_id":"87003025","dot_number":"1637233","report_state":"NY","report_number":"0L07001090","insp_date":"2026-02-05 00:00:00","insp_start_time":"1226","insp_end_time":"1324","registration_date":"2026-02-17 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"MEDFORD NY","county_code_state":"NY","county_code":"103","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":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2867794","transaction_code":"C","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:50.000000Z","updated_at":"2026-03-01T10:30:14.000000Z","inspection_violations":[{"id":18702892,"change_date":"2026-02-18 21:38:00","inspection_id":"87003025","insp_violation_id":"271867187","seq_no":"1","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"211681998","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H927L98K2Z","created_at":"2026-02-21T10:53:29.000000Z","updated_at":"2026-03-01T10:39:36.000000Z","normalized_code":"39019TG"},{"id":18702893,"change_date":"2026-02-18 21:38:00","inspection_id":"87003025","insp_violation_id":"271867188","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"211681998","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H927L98JVS","created_at":"2026-02-21T10:53:29.000000Z","updated_at":"2026-03-01T10:39:36.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":18702894,"change_date":"2026-02-18 21:38:00","inspection_id":"87003025","insp_violation_id":"271867189","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211681998","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H927L98JBJ","created_at":"2026-02-21T10:53:29.000000Z","updated_at":"2026-03-01T10:39:36.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19036358,"change_date":"2026-02-18 21:38:00","inspection_id":"87003025","insp_unit_id":"211681998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"NAC132","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B1HS807739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:13:57.000000Z","updated_at":"2026-03-01T10:02:47.000000Z"}]},{"id":10873656,"change_date":"2026-01-28 21:37:00","inspection_id":"86903805","dot_number":"1637233","report_state":"NY","report_number":"SPL3041037","insp_date":"2026-01-22 00:00:00","insp_start_time":"0702","insp_end_time":"0718","registration_date":null,"region":"ES","ci_status_code":"C","location":"00096E","location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","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-28 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"2820483","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2026-01-28 21:37:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-28 21:37:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-31T10:36:25.000000Z","updated_at":"2026-02-08T10:31:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18274957,"change_date":"2026-01-28 21:37:00","inspection_id":"86903805","insp_unit_id":"211319686","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"145","insp_unit_license":"NAC145","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W161N7K02950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:10:59.000000Z","updated_at":"2026-02-08T10:04:25.000000Z"}]},{"id":10039412,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","dot_number":"1637233","report_state":"NY","report_number":"0L95002037","insp_date":"2025-10-20 00:00:00","insp_start_time":"0732","insp_end_time":"0826","registration_date":"2025-10-30 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-26 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","viol_total":"5","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":"2461557","transaction_code":"C","transaction_date":"2025-10-26 00:00:00","upload_date":"2025-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-10-26 21:34:00","snet_input_date":"2025-10-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-26 21:34:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-29T10:00:28.000000Z","updated_at":"2025-11-04T11:00:04.000000Z","inspection_violations":[{"id":16705763,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","insp_violation_id":"269639556","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209760257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310KWQ8P3","created_at":"2025-11-03T11:17:25.000000Z","updated_at":"2025-11-04T11:15:06.000000Z","normalized_code":"3939ALIL"},{"id":16705764,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","insp_violation_id":"269639557","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209760257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310KWQ8JV","created_at":"2025-11-03T11:17:25.000000Z","updated_at":"2025-11-04T11:15:06.000000Z","normalized_code":"3939ALCL"},{"id":16705765,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","insp_violation_id":"269639558","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"209760257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310KWQ885","created_at":"2025-11-03T11:17:25.000000Z","updated_at":"2025-11-04T11:15:06.000000Z","normalized_code":"3939ALLPL"},{"id":16705766,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","insp_violation_id":"269639559","seq_no":"4","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"209760257","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310KWQ900","created_at":"2025-11-03T11:17:25.000000Z","updated_at":"2025-11-04T11:15:06.000000Z","normalized_code":"39019TG"},{"id":16705767,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","insp_violation_id":"269639560","seq_no":"5","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"209760257","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K310KWQ9C2","created_at":"2025-11-03T11:17:25.000000Z","updated_at":"2025-11-04T11:15:06.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":16767555,"change_date":"2025-10-31 21:39:00","inspection_id":"86151568","insp_unit_id":"209760257","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":"142","insp_unit_license":"86917NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG111KGKG3657","insp_unit_decal":"Y","insp_unit_decal_number":"35750957","created_at":"2025-11-03T10:47:07.000000Z","updated_at":"2025-11-04T10:45:06.000000Z"}]},{"id":9578399,"change_date":"2025-09-24 21:41:00","inspection_id":"85667203","dot_number":"1637233","report_state":"NY","report_number":"EPO0100104","insp_date":"2025-08-20 00:00:00","insp_start_time":"0715","insp_end_time":"0757","registration_date":"2025-09-02 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"BROOKLYN NY","county_code_state":"NY","county_code":"047","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2214368","transaction_code":"C","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-09-03 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-03 21:39:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:19.000000Z","updated_at":"2025-09-28T10:00:06.000000Z","inspection_violations":[{"id":16043150,"change_date":"2025-09-24 21:41:00","inspection_id":"85667203","insp_violation_id":"268883201","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"209111260","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:48.000000Z","updated_at":"2025-09-28T10:15:09.000000Z","normalized_code":"3922SLLUCR"},{"id":16043151,"change_date":"2025-09-24 21:41:00","inspection_id":"85667203","insp_violation_id":"268883202","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:48.000000Z","updated_at":"2025-09-28T10:15:09.000000Z","normalized_code":"39141APC"},{"id":16043152,"change_date":"2025-09-24 21:41:00","inspection_id":"85667203","insp_violation_id":"268883203","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209111260","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:48.000000Z","updated_at":"2025-09-28T10:15:09.000000Z","normalized_code":"3939ALHLI"},{"id":16043153,"change_date":"2025-09-24 21:41:00","inspection_id":"85667203","insp_violation_id":"268883204","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209111260","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:48.000000Z","updated_at":"2025-09-28T10:15:09.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":16171367,"change_date":"2025-09-24 21:41:00","inspection_id":"85667203","insp_unit_id":"209111260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"74842MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG116KGKK1487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:16.000000Z","updated_at":"2025-09-29T09:45:05.000000Z"}]},{"id":8479475,"change_date":"2025-04-30 21:50:00","inspection_id":"84508427","dot_number":"1637233","report_state":"CT","report_number":"3031A00395","insp_date":"2025-04-29 00:00:00","insp_start_time":"0947","insp_end_time":"0954","registration_date":"2025-04-30 00:00:00","region":"ET","ci_status_code":"C","location":"152SN","location_desc":"WATERFORD SCALE N\/B","county_code_state":"CT","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN ADVISORY","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":"2025-04-29 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738713","transaction_code":"C","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-04-29 21:47:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-29 21:47:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-02T10:25:25.000000Z","updated_at":"2025-05-04T10:32:59.000000Z","inspection_violations":[{"id":13441000,"change_date":"2025-04-30 21:50:00","inspection_id":"84508427","insp_violation_id":"265891724","seq_no":"1","part_no":"383","part_no_section":"91A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:04:19.000000Z","updated_at":"2025-05-03T10:47:09.000000Z","normalized_code":"38391ALCDL"},{"id":13441001,"change_date":"2025-04-30 21:50:00","inspection_id":"84508427","insp_violation_id":"265891725","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"1","insp_unit_id":"206543598","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V133495-0","created_at":"2025-05-02T11:04:19.000000Z","updated_at":"2025-05-03T10:47:09.000000Z","normalized_code":"3922SLLEWG1"},{"id":13441002,"change_date":"2025-04-30 21:50:00","inspection_id":"84508427","insp_violation_id":"265891726","seq_no":"3","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"206543598","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:04:19.000000Z","updated_at":"2025-05-03T10:47:09.000000Z","normalized_code":"39311A1LCHL"}],"inspection_per_units":[{"id":13808494,"change_date":"2025-04-30 21:50:00","inspection_id":"84508427","insp_unit_id":"206543598","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"43687NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:08:57.000000Z","updated_at":"2025-05-04T09:48:35.000000Z"}]},{"id":8504844,"change_date":"2025-04-30 21:51:00","inspection_id":"84535376","dot_number":"1637233","report_state":"NY","report_number":"SPL3010489","insp_date":"2025-04-23 00:00:00","insp_start_time":"1303","insp_end_time":"1322","registration_date":null,"region":"ED","ci_status_code":"C","location":"00411P","location_desc":"MELVILLE NY","county_code_state":"NY","county_code":"103","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-30 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"1661233","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-04-30 21:51:00","snet_input_date":"2025-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:51:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-02T13:50:04.000000Z","updated_at":"2025-05-04T10:36:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13822955,"change_date":"2025-04-30 21:51:00","inspection_id":"84535376","insp_unit_id":"206559327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"39071MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B5GS811498","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:17:21.000000Z","updated_at":"2025-05-04T09:58:54.000000Z"}]},{"id":8434785,"change_date":"2025-04-22 21:40:00","inspection_id":"84461542","dot_number":"1637233","report_state":"NY","report_number":"D507101485","insp_date":"2025-04-21 00:00:00","insp_start_time":"0909","insp_end_time":"0934","registration_date":null,"region":"ED","ci_status_code":"C","location":"60056M","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","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-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"1625401","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-04-22 21:40:00","snet_input_date":"2025-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:26:22.000000Z","updated_at":"2025-04-26T10:26:22.000000Z","inspection_violations":[{"id":13318082,"change_date":"2025-04-22 21:40:00","inspection_id":"84461542","insp_violation_id":"265752225","seq_no":"1","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"206424581","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:44:25.000000Z","updated_at":"2025-04-25T10:51:17.000000Z","normalized_code":"39367C7VF"}],"inspection_per_units":[{"id":13697175,"change_date":"2025-04-22 21:40:00","inspection_id":"84461542","insp_unit_id":"206424581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"150","insp_unit_license":"79267ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FK4PDD09927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:04:22.000000Z","updated_at":"2025-04-26T09:49:55.000000Z"}]},{"id":8277629,"change_date":"2025-04-02 21:41:00","inspection_id":"84296135","dot_number":"1637233","report_state":"PA","report_number":"E927509152","insp_date":"2025-04-01 00:00:00","insp_start_time":"1125","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"I476 OFF RAMP @ PENNDOT","county_code_state":"PA","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN ADVISORY","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2505852","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13399258,"change_date":"2025-04-02 21:41:00","inspection_id":"84296135","insp_unit_id":"206123112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"43687NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:13:27.000000Z","updated_at":"2025-04-06T10:01:27.000000Z"}]},{"id":8006787,"change_date":"2025-03-03 21:38:00","inspection_id":"84010898","dot_number":"1637233","report_state":"NY","report_number":"SPD3070455","insp_date":"2025-02-25 00:00:00","insp_start_time":"0724","insp_end_time":"0746","registration_date":null,"region":"ES","ci_status_code":"C","location":"00096E","location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN ADVISORY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14990","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":"1423564","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-03-03 21:38:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-03 21:38:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:29.000000Z","updated_at":"2025-03-17T21:04:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12926417,"change_date":"2025-03-03 21:38:00","inspection_id":"84010898","insp_unit_id":"205589016","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"70939MB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZAC1DV5DCFH5734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:47.000000Z","updated_at":"2025-03-17T23:57:47.000000Z"}]},{"id":7903038,"change_date":"2025-02-19 21:40:00","inspection_id":"83902063","dot_number":"1637233","report_state":"GA","report_number":"1417000722","insp_date":"2025-02-12 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"ES","ci_status_code":"C","location":"267","location_desc":"RINGGOLD GA","county_code_state":"GA","county_code":"047","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NORTHERN ADVISORY","shipping_paper_number":"DONATION LOCATI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1376454","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:20.000000Z","updated_at":"2025-03-17T21:02:20.000000Z","inspection_violations":[{"id":12349466,"change_date":"2025-02-19 21:40:00","inspection_id":"83902063","insp_violation_id":"264581970","seq_no":"1","part_no":"392","part_no_section":"9AA2-OA","insp_viol_unit":"1","insp_unit_id":"205387649","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3929AA2OA"}],"inspection_per_units":[{"id":12756918,"change_date":"2025-02-19 21:40:00","inspection_id":"83902063","insp_unit_id":"205387649","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"VIN-4667","insp_unit_license":"GDD370","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNV8JT7J4S54667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"}]},{"id":7774749,"change_date":"2025-02-03 21:39:00","inspection_id":"83767427","dot_number":"1637233","report_state":"PA","report_number":"E923503011","insp_date":"2025-01-30 00:00:00","insp_start_time":"1345","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":"459","location_desc":"SR 492 AT I-81 NB OFFRAMP - NE","county_code_state":"PA","county_code":"115","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"2494790","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12547507,"change_date":"2025-02-03 21:39:00","inspection_id":"83767427","insp_unit_id":"205134263","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"150","insp_unit_license":"79267ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FK4PDD09927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":7553960,"change_date":"2025-01-06 21:39:00","inspection_id":"83535405","dot_number":"1637233","report_state":"NY","report_number":"D012101628","insp_date":"2025-01-06 00:00:00","insp_start_time":"0830","insp_end_time":"0849","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"COMMACK NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","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":"1220456","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[{"id":11807559,"change_date":"2025-01-06 21:39:00","inspection_id":"83535405","insp_violation_id":"263767981","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"39141AMCPC"},{"id":11807560,"change_date":"2025-01-06 21:39:00","inspection_id":"83535405","insp_violation_id":"263767982","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"204662556","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3939ALCL"},{"id":11807561,"change_date":"2025-01-06 21:39:00","inspection_id":"83535405","insp_violation_id":"263767983","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204662556","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:32.000000Z","updated_at":"2025-03-17T22:03:32.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":12188266,"change_date":"2025-01-06 21:39:00","inspection_id":"83535405","insp_unit_id":"204662556","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":"140","insp_unit_license":"18999NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZCXG110MGLY2757","insp_unit_decal":"Y","insp_unit_decal_number":"34945160","created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7086974,"change_date":"2024-10-31 21:41:00","inspection_id":"83043032","dot_number":"1637233","report_state":"NY","report_number":"0L88010243","insp_date":"2024-10-25 00:00:00","insp_start_time":"1108","insp_end_time":"1126","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OCEANSIDE NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","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":"1002418","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2024-10-31 21:41:00","snet_input_date":"2024-10-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-31 21:41:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:51.000000Z","updated_at":"2025-03-17T20:43:51.000000Z","inspection_violations":[{"id":11065330,"change_date":"2024-10-31 21:41:00","inspection_id":"83043032","insp_violation_id":"262650464","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":11429718,"change_date":"2024-10-31 21:41:00","inspection_id":"83043032","insp_unit_id":"203668164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"86917NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG111KGKG3657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:20.000000Z","updated_at":"2025-03-17T23:41:20.000000Z"}]},{"id":6732434,"change_date":"2024-09-16 21:42:00","inspection_id":"82666052","dot_number":"1637233","report_state":"NY","report_number":"D012101227","insp_date":"2024-09-16 00:00:00","insp_start_time":"0825","insp_end_time":"0846","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GREENLAWN NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"851643","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2024-09-16 21:42:00","snet_input_date":"2024-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-16 21:42:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:32.000000Z","updated_at":"2025-03-17T20:36:32.000000Z","inspection_violations":[{"id":10482738,"change_date":"2024-09-16 21:42:00","inspection_id":"82666052","insp_violation_id":"261815203","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:47.000000Z","updated_at":"2025-03-17T21:56:47.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10856100,"change_date":"2024-09-16 21:42:00","inspection_id":"82666052","insp_unit_id":"202935310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"145","insp_unit_license":"24634NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W161N7K02950","insp_unit_decal":"Y","insp_unit_decal_number":"34338648","created_at":"2025-03-17T23:35:28.000000Z","updated_at":"2025-03-17T23:35:28.000000Z"}]},{"id":6162535,"change_date":"2024-07-08 21:42:00","inspection_id":"82057355","dot_number":"1637233","report_state":"NY","report_number":"SPT0560641","insp_date":"2024-07-03 00:00:00","insp_start_time":"0844","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":"12001B","location_desc":"ALBANY (EXIT 23)","county_code_state":"NY","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2934716","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":"M","census_search_date":"2024-07-08 21:42:00","snet_input_date":"2024-07-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:58.000000Z","updated_at":"2025-03-17T20:24:58.000000Z","inspection_violations":[{"id":9565580,"change_date":"2024-07-08 21:42:00","inspection_id":"82057355","insp_violation_id":"260503954","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4J75LSL","created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39216A"},{"id":9565581,"change_date":"2024-07-08 21:42:00","inspection_id":"82057355","insp_violation_id":"260503955","seq_no":"2","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3958A"},{"id":9565582,"change_date":"2024-07-08 21:42:00","inspection_id":"82057355","insp_violation_id":"260503956","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201766706","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"},{"id":9565583,"change_date":"2024-07-08 21:42:00","inspection_id":"82057355","insp_violation_id":"260503957","seq_no":"4","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"201766706","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"999"}],"inspection_per_units":[{"id":9926844,"change_date":"2024-07-08 21:42:00","inspection_id":"82057355","insp_unit_id":"201766706","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"66963NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:54.000000Z","updated_at":"2025-03-17T23:25:54.000000Z"}]},{"id":5882773,"change_date":"2024-05-31 21:38:00","inspection_id":"81754775","dot_number":"1637233","report_state":"NY","report_number":"D012100834","insp_date":"2024-05-28 00:00:00","insp_start_time":"0833","insp_end_time":"0850","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FARMINGVILLE NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-31 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","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":"529066","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2024-05-31 21:38:00","snet_input_date":"2024-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-31 21:38:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:25.000000Z","updated_at":"2025-03-17T20:19:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9474858,"change_date":"2024-05-31 21:38:00","inspection_id":"81754775","insp_unit_id":"201168854","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"74870MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG11XKGKT7627","insp_unit_decal":"Y","insp_unit_decal_number":"34016616","created_at":"2025-03-17T23:21:16.000000Z","updated_at":"2025-03-17T23:21:16.000000Z"}]},{"id":5630725,"change_date":"2024-04-30 21:41:00","inspection_id":"81481539","dot_number":"1637233","report_state":"NY","report_number":"0L61000641","insp_date":"2024-04-24 00:00:00","insp_start_time":"1150","insp_end_time":"1239","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17995","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":"439167","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:18.000000Z","updated_at":"2025-03-17T20:14:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9069977,"change_date":"2024-04-30 21:41:00","inspection_id":"81481539","insp_unit_id":"200645297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"18998NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZCXG119MGLY2756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:22.000000Z","updated_at":"2025-03-17T23:17:22.000000Z"}]},{"id":5403237,"change_date":"2024-03-30 21:32:00","inspection_id":"81232948","dot_number":"1637233","report_state":"NY","report_number":"D012100619","insp_date":"2024-03-29 00:00:00","insp_start_time":"1248","insp_end_time":"1312","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GARDEN CITY NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-30 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"14497","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":"356709","transaction_code":"A","transaction_date":"2024-03-30 00:00:00","upload_date":"2024-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2024-03-30 21:32:00","snet_input_date":"2024-03-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-30 21:32:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:50.000000Z","updated_at":"2025-03-17T20:09:50.000000Z","inspection_violations":[{"id":8338746,"change_date":"2024-03-30 21:32:00","inspection_id":"81232948","insp_violation_id":"258666711","seq_no":"1","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"200164780","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39019B2"},{"id":8338747,"change_date":"2024-03-30 21:32:00","inspection_id":"81232948","insp_violation_id":"258666712","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"200164780","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":8702224,"change_date":"2024-03-30 21:32:00","inspection_id":"81232948","insp_unit_id":"200164780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"148","insp_unit_license":"69982ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDXE4FN2PDD23071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:56.000000Z","updated_at":"2025-03-17T23:13:56.000000Z"}]},{"id":4569776,"change_date":"2023-12-06 21:42:00","inspection_id":"80322687","dot_number":"1637233","report_state":"TN","report_number":"TCBD000494","insp_date":"2023-12-05 00:00:00","insp_start_time":"0905","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"COFFEE COUNTY SCALES","county_code_state":"TN","county_code":"031","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","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-12-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1694895","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2023-12-06 21:42:00","snet_input_date":"2023-12-06 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:24.000000Z","updated_at":"2025-03-17T19:53:24.000000Z","inspection_violations":[{"id":7068542,"change_date":"2023-12-06 21:42:00","inspection_id":"80322687","insp_violation_id":"256742561","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":7349773,"change_date":"2023-12-06 21:42:00","inspection_id":"80322687","insp_unit_id":"198375020","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"GDD370","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"5PVNV8JT7J4S54667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:44.000000Z","updated_at":"2025-03-17T23:01:44.000000Z"}]},{"id":4597562,"change_date":"2023-12-11 21:40:00","inspection_id":"80353150","dot_number":"1637233","report_state":"NY","report_number":"SPL0135466","insp_date":"2023-12-05 00:00:00","insp_start_time":"1300","insp_end_time":"1316","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","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":"2892129","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2023-12-11 21:40:00","snet_input_date":"2023-12-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-11 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:50.000000Z","updated_at":"2025-03-17T19:53:50.000000Z","inspection_violations":[{"id":7110624,"change_date":"2023-12-11 21:40:00","inspection_id":"80353150","insp_violation_id":"256809756","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198435864","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1HGNXWF","created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7394500,"change_date":"2023-12-11 21:40:00","inspection_id":"80353150","insp_unit_id":"198435864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITS","insp_unit_company":"137","insp_unit_license":"74870MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG11XKGKT7627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:08.000000Z","updated_at":"2025-03-17T23:02:08.000000Z"}]},{"id":4469169,"change_date":"2023-11-21 21:39:00","inspection_id":"80212016","dot_number":"1637233","report_state":"NY","report_number":"0L10100085","insp_date":"2023-11-21 00:00:00","insp_start_time":"0711","insp_end_time":"0734","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WANTAGH NY","county_code_state":"NY","county_code":"059","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":"2023-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","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":"103588","transaction_code":"A","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2023-11-21 21:39:00","snet_input_date":"2023-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-21 21:39:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:25.000000Z","updated_at":"2025-03-17T19:51:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7187571,"change_date":"2023-11-21 21:39:00","inspection_id":"80212016","insp_unit_id":"198157504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITSUBISHI","insp_unit_company":null,"insp_unit_license":"74870MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG11XKGKT7627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:22.000000Z","updated_at":"2025-03-17T23:00:22.000000Z"}]},{"id":4019429,"change_date":"2023-09-21 21:40:00","inspection_id":"79714197","dot_number":"1637233","report_state":"NY","report_number":"SPWL081273","insp_date":"2023-09-20 00:00:00","insp_start_time":"1407","insp_end_time":"1428","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","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":"2871029","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":"M","census_search_date":"2023-09-21 21:40:00","snet_input_date":"2023-09-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-21 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:05.000000Z","updated_at":"2025-03-17T19:42:05.000000Z","inspection_violations":[{"id":6221698,"change_date":"2023-09-21 21:40:00","inspection_id":"79714197","insp_violation_id":"255390931","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":"8H6KW5J","created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6462767,"change_date":"2023-09-21 21:40:00","inspection_id":"79714197","insp_unit_id":"197157233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITS","insp_unit_company":"142","insp_unit_license":"86917NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG111KGKG3657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:15.000000Z","updated_at":"2025-03-17T22:54:15.000000Z"}]},{"id":3637603,"change_date":"2023-08-01 21:41:00","inspection_id":"79288444","dot_number":"1637233","report_state":"CT","report_number":"3076002511","insp_date":"2023-08-01 00:00:00","insp_start_time":"0739","insp_end_time":"0811","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"682124","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2023-08-01 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:37.000000Z","updated_at":"2025-03-17T19:34:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5848860,"change_date":"2023-08-01 21:41:00","inspection_id":"79288444","insp_unit_id":"196290616","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"66963NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:10.000000Z","updated_at":"2025-03-17T22:49:10.000000Z"}]},{"id":3483259,"change_date":"2023-07-25 21:40:00","inspection_id":"79115485","dot_number":"1637233","report_state":"CT","report_number":"0691000017","insp_date":"2023-07-12 00:00:00","insp_start_time":"0844","insp_end_time":"0920","registration_date":"2023-07-25 00:00:00","region":"ET","ci_status_code":"C","location":"152","location_desc":"WATERFORD","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHERN","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-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"680157","transaction_code":"C","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2023-07-12 21:40:00","snet_input_date":"2023-07-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:02.000000Z","updated_at":"2025-03-17T19:32:02.000000Z","inspection_violations":[{"id":5372270,"change_date":"2023-07-25 21:40:00","inspection_id":"79115485","insp_violation_id":"254251550","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:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5372271,"change_date":"2023-07-25 21:40:00","inspection_id":"79115485","insp_violation_id":"254251551","seq_no":"2","part_no":"392","part_no_section":"2","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-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5372272,"change_date":"2023-07-25 21:40:00","inspection_id":"79115485","insp_violation_id":"254251552","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196171441","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5372273,"change_date":"2023-07-25 21:40:00","inspection_id":"79115485","insp_violation_id":"254251553","seq_no":"4","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":5601368,"change_date":"2023-07-25 21:40:00","inspection_id":"79115485","insp_unit_id":"196171441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"66963NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"}]},{"id":3206363,"change_date":"2023-06-05 21:41:00","inspection_id":"78803508","dot_number":"1637233","report_state":"US","report_number":"1695000010","insp_date":"2023-05-17 00:00:00","insp_start_time":"0950","insp_end_time":"1034","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WYOMINGRI","county_code_state":"RI","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"20140","transaction_code":"A","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2023-06-05 21:41:00","snet_input_date":"2023-05-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-05 21:41:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:28.000000Z","updated_at":"2025-03-17T19:26:28.000000Z","inspection_violations":[{"id":4940414,"change_date":"2023-06-05 21:41:00","inspection_id":"78803508","insp_violation_id":"253266807","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195302541","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"39347E"},{"id":4940415,"change_date":"2023-06-05 21:41:00","inspection_id":"78803508","insp_violation_id":"253266808","seq_no":"2","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"195302541","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"39019TG"}],"inspection_per_units":[{"id":5157051,"change_date":"2023-06-05 21:41:00","inspection_id":"78803508","insp_unit_id":"195302541","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"66963","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:38.000000Z","updated_at":"2025-03-17T22:43:38.000000Z"}]},{"id":1311188,"change_date":"2022-09-19 21:39:00","inspection_id":"76639588","dot_number":"1637233","report_state":"NY","report_number":"SPWL021484","insp_date":"2022-09-16 00:00:00","insp_start_time":"1415","insp_end_time":"1436","registration_date":null,"region":"ET","ci_status_code":"C","location":"01185","location_desc":"MERRICK","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15995","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":"2750385","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":"M","census_search_date":"2022-09-19 21:39:00","snet_input_date":"2022-09-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:51.000000Z","updated_at":"2025-03-17T18:50:51.000000Z","inspection_violations":[{"id":2076466,"change_date":"2022-09-19 21:39:00","inspection_id":"76639588","insp_violation_id":"248491370","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190962806","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"3939A"},{"id":2076467,"change_date":"2022-09-19 21:39:00","inspection_id":"76639588","insp_violation_id":"248491371","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190962806","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"39395A"},{"id":2076468,"change_date":"2022-09-19 21:39:00","inspection_id":"76639588","insp_violation_id":"248491372","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190962806","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":2110607,"change_date":"2022-09-19 21:39:00","inspection_id":"76639588","insp_unit_id":"190962806","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MITS","insp_unit_company":"136","insp_unit_license":"74842MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4UZBVG116KGKK1487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:29.000000Z","updated_at":"2025-03-17T22:21:29.000000Z"}]},{"id":520452,"change_date":"2022-06-08 21:40:00","inspection_id":"75713517","dot_number":"1637233","report_state":"CT","report_number":"3025000715","insp_date":"2022-06-01 00:00:00","insp_start_time":"0717","insp_end_time":"0740","registration_date":"2022-06-08 00:00:00","region":"ET","ci_status_code":"C","location":"057","location_desc":"GREENWICH","county_code_state":"CT","county_code":"001","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":"2022-06-01 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"645488","transaction_code":"C","transaction_date":"2022-06-01 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":null,"census_search_date":"2022-06-01 21:49:00","snet_input_date":"2022-06-01 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-01 21:49:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:00.000000Z","updated_at":"2025-03-17T18:37:00.000000Z","inspection_violations":[{"id":823043,"change_date":"2022-06-08 21:40:00","inspection_id":"75713517","insp_violation_id":"246291005","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:56.000000Z","updated_at":"2025-03-17T21:10:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":837565,"change_date":"2022-06-08 21:40:00","inspection_id":"75713517","insp_unit_id":"189105464","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"138","insp_unit_license":"66963NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT8GHHD2975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"}]},{"id":184162,"change_date":"2022-06-22 21:40:00","inspection_id":"75312619","dot_number":"1637233","report_state":"RI","report_number":"00DD000029","insp_date":"2022-04-14 00:00:00","insp_start_time":"0801","insp_end_time":"0838","registration_date":"2022-04-22 00:00:00","region":"ET","ci_status_code":"C","location":"27","location_desc":"RT 95N @ EXIT 15 (JEFFERSON BL","county_code_state":"RI","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"NORTHERN ADVISORY CORP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"76396","transaction_code":"C","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01637233","upload_search_indicator":"M","census_search_date":"2022-04-15 21:37:00","snet_input_date":"2022-04-15 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"NORTHERN ADVISORY","insp_carrier_street":"2 WILSON BLVD","insp_carrier_city":"CENTRAL ISLIP","insp_carrier_state":"NY","insp_carrier_zip_code":"11722","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:50.000000Z","updated_at":"2025-03-17T18:30:50.000000Z","inspection_violations":[{"id":280744,"change_date":"2022-06-22 21:40:00","inspection_id":"75312619","insp_violation_id":"246642708","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189396415","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":298155,"change_date":"2022-06-22 21:40:00","inspection_id":"75312619","insp_unit_id":"189396415","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"144","insp_unit_license":"1DU897","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FC3E4KK7NDC12835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:59.000000Z","updated_at":"2025-03-17T22:09:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1637233\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1637233\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1637233\/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\/1637233\/inspections","per_page":100,"prev_page_url":null,"to":36,"total":36}