{"current_page":1,"data":[{"id":10269279,"change_date":"2025-11-22 21:50:00","inspection_id":"86393362","dot_number":"1383179","report_state":"NY","report_number":"0L07001025","insp_date":"2025-11-20 00:00:00","insp_start_time":"1638","insp_end_time":"1712","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":"2025-11-22 21:50:00","post_acc_ind":"N","gross_comb_veh_wt":"79200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2575128","transaction_code":"A","transaction_date":"2025-11-22 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2025-11-22 21:50:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-22 21:50:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-25T10:32:21.000000Z","updated_at":"2025-11-26T10:31:40.000000Z","inspection_violations":[{"id":17161881,"change_date":"2025-11-22 21:50:00","inspection_id":"86393362","insp_violation_id":"270236721","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"210214429","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H927L12N88","created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"39021TB2DOT"},{"id":17161882,"change_date":"2025-11-22 21:50:00","inspection_id":"86393362","insp_violation_id":"270236722","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210214429","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H927L12MQ1","created_at":"2025-11-25T10:34:04.000000Z","updated_at":"2025-11-26T10:38:23.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":17138380,"change_date":"2025-11-22 21:50:00","inspection_id":"86393362","insp_unit_id":"210214429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STERLING T","insp_unit_company":"G104","insp_unit_license":"40062NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2FZHAZCV75AN92541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:38.000000Z","updated_at":"2025-11-26T10:02:07.000000Z"}]},{"id":9691710,"change_date":"2025-09-16 21:39:00","inspection_id":"85786006","dot_number":"1383179","report_state":"NY","report_number":"0L92000475","insp_date":"2025-09-09 00:00:00","insp_start_time":"1542","insp_end_time":"1557","registration_date":null,"region":"ED","ci_status_code":"C","location":"00096W","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":"2025-09-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"79200","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":"2279795","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:57.000000Z","updated_at":"2025-09-23T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16042875,"change_date":"2025-09-16 21:39:00","inspection_id":"85786006","insp_unit_id":"208971775","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STERLING T","insp_unit_company":null,"insp_unit_license":"40062NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2FZHAZCV75AN92541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:38.000000Z","updated_at":"2025-09-20T09:45:14.000000Z"}]},{"id":9539263,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","dot_number":"1383179","report_state":"CT","report_number":"3078003582","insp_date":"2025-08-28 00:00:00","insp_start_time":"1258","insp_end_time":"1359","registration_date":"2025-09-16 00:00:00","region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","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":null,"final_status_date":"2025-08-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"373","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"750475","transaction_code":"C","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2025-08-29 21:39:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-29 21:39:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:21.000000Z","updated_at":"2025-09-23T10:00:12.000000Z","inspection_violations":[{"id":15894303,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","insp_violation_id":"268713701","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208968958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:14.000000Z","updated_at":"2025-09-20T10:15:12.000000Z","normalized_code":"39021TB2DOT"},{"id":15894304,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","insp_violation_id":"268713702","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208968958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:14.000000Z","updated_at":"2025-09-20T10:15:12.000000Z","normalized_code":"39021TB1MC"},{"id":15894305,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","insp_violation_id":"268713703","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208968958","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:14.000000Z","updated_at":"2025-09-20T10:15:12.000000Z","normalized_code":"39617CPI"},{"id":15894306,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","insp_violation_id":"268713704","seq_no":"4","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"208968958","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:14.000000Z","updated_at":"2025-09-20T10:15:12.000000Z","normalized_code":"39395A4EEUS"},{"id":15894307,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","insp_violation_id":"268713705","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208968958","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:14.000000Z","updated_at":"2025-09-20T10:15:12.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":16039785,"change_date":"2025-09-16 21:39:00","inspection_id":"85626156","insp_unit_id":"208968958","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BX47343","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3FRNF75C69V196064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:37.000000Z","updated_at":"2025-09-20T09:45:05.000000Z"}]},{"id":7022090,"change_date":"2024-10-23 21:41:00","inspection_id":"82974318","dot_number":"1383179","report_state":"NY","report_number":"0L07000707","insp_date":"2024-10-22 00:00:00","insp_start_time":"1648","insp_end_time":"1732","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YAPHANK 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":"2024-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","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":"972322","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2024-10-23 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-23 21:41:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:36.000000Z","updated_at":"2025-03-17T20:42:36.000000Z","inspection_violations":[{"id":10959409,"change_date":"2024-10-23 21:41:00","inspection_id":"82974318","insp_violation_id":"262504369","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"203539788","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:07.000000Z","updated_at":"2025-03-17T21:59:07.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":11325472,"change_date":"2024-10-23 21:41:00","inspection_id":"82974318","insp_unit_id":"203539788","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"CT110","insp_unit_license":"19598MC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTSCAAM7XH676175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:17.000000Z","updated_at":"2025-03-17T23:40:17.000000Z"}]},{"id":7067212,"change_date":"2024-10-29 21:41:00","inspection_id":"83022084","dot_number":"1383179","report_state":"NY","report_number":"0L92000209","insp_date":"2024-10-22 00:00:00","insp_start_time":"1646","insp_end_time":"1719","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YAPHANK 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-10-29 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":"995757","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:26.000000Z","updated_at":"2025-03-17T20:43:26.000000Z","inspection_violations":[{"id":11032138,"change_date":"2024-10-29 21:41:00","inspection_id":"83022084","insp_violation_id":"262603842","seq_no":"1","part_no":"393","part_no_section":"47A-BCFSHE","insp_viol_unit":"1","insp_unit_id":"203628390","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA29JM1VXV","created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"39347ABCFSHE"},{"id":11032139,"change_date":"2024-10-29 21:41:00","inspection_id":"83022084","insp_violation_id":"262603843","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"203628390","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA29JM1VRQ","created_at":"2025-03-17T21:59:30.000000Z","updated_at":"2025-03-17T21:59:30.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":11397962,"change_date":"2024-10-29 21:41:00","inspection_id":"83022084","insp_unit_id":"203628390","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"31875ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTJTSKMX8H637744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:01.000000Z","updated_at":"2025-03-17T23:41:01.000000Z"}]},{"id":6777777,"change_date":"2024-09-20 21:42:00","inspection_id":"82714448","dot_number":"1383179","report_state":"NY","report_number":"SPL0157210","insp_date":"2024-09-19 00:00:00","insp_start_time":"0730","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","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":"N","pen_cen_match":null,"final_status_date":"2024-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"79200","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":"2951766","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2024-09-20 21:42:00","snet_input_date":"2024-09-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-20 21:42:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:23.000000Z","updated_at":"2025-03-17T20:37:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10929617,"change_date":"2024-09-20 21:42:00","inspection_id":"82714448","insp_unit_id":"203046165","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STER","insp_unit_company":null,"insp_unit_license":"40062NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2FZHAZCV75AN92541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:12.000000Z","updated_at":"2025-03-17T23:36:12.000000Z"}]},{"id":6777828,"change_date":"2024-09-20 21:42:00","inspection_id":"82714503","dot_number":"1383179","report_state":"NY","report_number":"SPD0226525","insp_date":"2024-09-18 00:00:00","insp_start_time":"0907","insp_end_time":"0924","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LOOKS GREAT SERVICE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2951834","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2024-09-20 21:42:00","snet_input_date":"2024-09-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-20 21:42:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:23.000000Z","updated_at":"2025-03-17T20:37:23.000000Z","inspection_violations":[{"id":10556737,"change_date":"2024-09-20 21:42:00","inspection_id":"82714503","insp_violation_id":"261943569","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"203046246","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":10929684,"change_date":"2024-09-20 21:42:00","inspection_id":"82714503","insp_unit_id":"203046246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"34837NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4B16267004548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:12.000000Z","updated_at":"2025-03-17T23:36:12.000000Z"}]},{"id":5993640,"change_date":"2024-06-14 21:40:00","inspection_id":"81875520","dot_number":"1383179","report_state":"NY","report_number":"SPL0200319","insp_date":"2024-06-13 00:00:00","insp_start_time":"1540","insp_end_time":"1555","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":"2024-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2930311","transaction_code":"A","transaction_date":"2024-06-14 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:29.000000Z","updated_at":"2025-03-17T20:21:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9653555,"change_date":"2024-06-14 21:40:00","inspection_id":"81875520","insp_unit_id":"201398200","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"96011ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCL40XXMD763286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:02.000000Z","updated_at":"2025-03-17T23:23:02.000000Z"}]},{"id":6043577,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","dot_number":"1383179","report_state":"NY","report_number":"0L08000641","insp_date":"2024-06-11 00:00:00","insp_start_time":"1710","insp_end_time":"1803","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HAUPPAUGE 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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"588926","transaction_code":"A","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2024-06-21 21:38:00","snet_input_date":"2024-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-21 21:38:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:35.000000Z","updated_at":"2025-03-17T20:22:35.000000Z","inspection_violations":[{"id":9374643,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_violation_id":"260225561","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201519489","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3939A"},{"id":9374644,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_violation_id":"260225562","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"201519488","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"39360C"},{"id":9374645,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_violation_id":"260225563","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201519488","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3963A1"},{"id":9374646,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_violation_id":"260225564","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201519489","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3939A"},{"id":9374647,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_violation_id":"260225565","seq_no":"5","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"201519488","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":9733885,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_unit_id":"201519488","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"34837NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4B16267004548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:50.000000Z","updated_at":"2025-03-17T23:23:50.000000Z"},{"id":9733886,"change_date":"2024-06-21 21:38:00","inspection_id":"81929463","insp_unit_id":"201519489","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"RAYCO TRAILER","insp_unit_license":"CB26578","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1R9091224DW210013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:50.000000Z","updated_at":"2025-03-17T23:23:50.000000Z"}]},{"id":5697984,"change_date":"2024-05-08 21:42:00","inspection_id":"81554676","dot_number":"1383179","report_state":"NY","report_number":"SPL0164943","insp_date":"2024-05-07 00:00:00","insp_start_time":"1107","insp_end_time":"1154","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","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":"N","pen_cen_match":null,"final_status_date":"2024-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2922439","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2024-05-08 21:42:00","snet_input_date":"2024-05-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-08 21:42:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:32.000000Z","updated_at":"2025-03-17T20:15:32.000000Z","inspection_violations":[{"id":8814328,"change_date":"2024-05-08 21:42:00","inspection_id":"81554676","insp_violation_id":"259380626","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200787045","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9177406,"change_date":"2024-05-08 21:42:00","inspection_id":"81554676","insp_unit_id":"200787045","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"96011ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPCL40XXMD763286","insp_unit_decal":"Y","insp_unit_decal_number":"34017911","created_at":"2025-03-17T23:18:25.000000Z","updated_at":"2025-03-17T23:18:25.000000Z"}]},{"id":4067390,"change_date":"2023-09-27 21:41:00","inspection_id":"79767724","dot_number":"1383179","report_state":"NY","report_number":"SPL0156108","insp_date":"2023-09-19 00:00:00","insp_start_time":"0751","insp_end_time":"0818","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"2873318","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:11.000000Z","updated_at":"2025-03-17T19:43:11.000000Z","inspection_violations":[{"id":6297954,"change_date":"2023-09-27 21:41:00","inspection_id":"79767724","insp_violation_id":"255513874","seq_no":"1","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"197263768","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:21.000000Z","updated_at":"2025-03-17T21:36:21.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":6539578,"change_date":"2023-09-27 21:41:00","inspection_id":"79767724","insp_unit_id":"197263768","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82456NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W166G7K00940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:52.000000Z","updated_at":"2025-03-17T22:54:52.000000Z"}]},{"id":3819951,"change_date":"2023-08-24 21:40:00","inspection_id":"79492066","dot_number":"1383179","report_state":"NY","report_number":"SP3T200458","insp_date":"2023-08-23 00:00:00","insp_start_time":"1340","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445B","location_desc":"LAFAYETTE (SB)","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LOOKS GREAT SERVICES","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-08-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2861766","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2023-08-24 21:40:00","snet_input_date":"2023-08-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-24 21:40:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:07.000000Z","updated_at":"2025-03-17T19:38:07.000000Z","inspection_violations":[{"id":5896475,"change_date":"2023-08-24 21:40:00","inspection_id":"79492066","insp_violation_id":"254852219","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:26.000000Z","updated_at":"2025-03-17T21:34:26.000000Z","normalized_code":"3922"},{"id":5896476,"change_date":"2023-08-24 21:40:00","inspection_id":"79492066","insp_violation_id":"254852220","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196702830","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0H3L7HB","created_at":"2025-03-17T21:34:26.000000Z","updated_at":"2025-03-17T21:34:26.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6141610,"change_date":"2023-08-24 21:40:00","inspection_id":"79492066","insp_unit_id":"196702830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"32138ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWFD2PHNZ1179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:36.000000Z","updated_at":"2025-03-17T22:51:36.000000Z"}]},{"id":2384913,"change_date":"2023-02-16 21:41:00","inspection_id":"77871822","dot_number":"1383179","report_state":"NY","report_number":"0L91000015","insp_date":"2023-02-14 00:00:00","insp_start_time":"1520","insp_end_time":"1653","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ISLANDIA PARK AND RIDE","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2799357","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2023-02-16 21:41:00","snet_input_date":"2023-02-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-16 21:41:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"200E 2ND STREET #28","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:42.000000Z","updated_at":"2025-03-17T19:10:42.000000Z","inspection_violations":[{"id":3672346,"change_date":"2023-02-16 21:41:00","inspection_id":"77871822","insp_violation_id":"251173430","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H926GFBL4W","created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39216A"},{"id":3672347,"change_date":"2023-02-16 21:41:00","inspection_id":"77871822","insp_violation_id":"251173431","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H926GFBLG7","created_at":"2025-03-17T21:24:18.000000Z","updated_at":"2025-03-17T21:24:18.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":3837404,"change_date":"2023-02-16 21:41:00","inspection_id":"77871822","insp_unit_id":"193430673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"34838NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5B16777300561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"},{"id":3837405,"change_date":"2023-02-16 21:41:00","inspection_id":"77871822","insp_unit_id":"193430674","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CB26578","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1R9091224DW210013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"}]},{"id":1712844,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","dot_number":"1383179","report_state":"NY","report_number":"0L08002980","insp_date":"2022-10-26 00:00:00","insp_start_time":"1732","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":"00421R","location_desc":"ISLIP *","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-11-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"11","oos_total":"8","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2767170","transaction_code":"A","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2022-11-10 21:38:00","snet_input_date":"2022-11-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-10 21:38:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"200E 2ND STREET #28","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:13.000000Z","updated_at":"2025-03-17T18:58:13.000000Z","inspection_violations":[{"id":2685228,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535192","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"38323A2"},{"id":2685229,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535193","seq_no":"2","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BF5439420","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"393209D"},{"id":2685230,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535194","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BF5439431","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39343"},{"id":2685231,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535195","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"3939A"},{"id":2685232,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535196","seq_no":"5","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BF5439442","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39381"},{"id":2685233,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535197","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BF5439464","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39347A"},{"id":2685234,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535198","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BF5439453","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39348A"},{"id":2685235,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535199","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39348A"},{"id":2685236,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535200","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BF5439475","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"3963A1"},{"id":2685237,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535201","seq_no":"10","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"BF5439486","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39343"},{"id":2685238,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_violation_id":"249535202","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191895564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BF5439490","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2755427,"change_date":"2022-11-10 21:38:00","inspection_id":"77103158","insp_unit_id":"191895564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"19598MC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTSCAAM7XH676175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:52.000000Z","updated_at":"2025-03-17T22:25:52.000000Z"}]},{"id":528622,"change_date":"2022-06-02 21:41:00","inspection_id":"75723194","dot_number":"1383179","report_state":"NY","report_number":"0L65000753","insp_date":"2022-06-01 00:00:00","insp_start_time":"1441","insp_end_time":"1558","registration_date":null,"region":"ET","ci_status_code":"C","location":"02900","location_desc":"N BROADWAY","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-02 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"18000","viol_total":"2","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":"2713097","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":"M","census_search_date":"2022-06-02 21:41:00","snet_input_date":"2022-06-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-02 21:41:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"200E 2ND STREET #28","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:03.000000Z","updated_at":"2025-03-17T18:37:03.000000Z","inspection_violations":[{"id":834961,"change_date":"2022-06-02 21:41:00","inspection_id":"75723194","insp_violation_id":"246205610","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189028295","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"3963A1"},{"id":834962,"change_date":"2022-06-02 21:41:00","inspection_id":"75723194","insp_violation_id":"246205611","seq_no":"2","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:10:57.000000Z","updated_at":"2025-03-17T21:10:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":850519,"change_date":"2022-06-02 21:41:00","inspection_id":"75723194","insp_unit_id":"189028295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"30160KA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GDE4C3225F514022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:27.000000Z","updated_at":"2025-03-17T22:13:27.000000Z"}]},{"id":97230,"change_date":"2023-12-11 21:40:00","inspection_id":"75206916","dot_number":"1383179","report_state":"NY","report_number":"1021000479","insp_date":"2022-04-01 00:00:00","insp_start_time":"0925","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"00078","location_desc":"COMMACK SCPD INSPECTION SITE","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2691239","transaction_code":"C","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01383179","upload_search_indicator":null,"census_search_date":"2023-12-11 21:40:00","snet_input_date":"2022-04-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"LOOKS GREAT SERVICE INC","insp_carrier_street":"140 WEST10TH STREET","insp_carrier_city":"HUNTINGTON STATION","insp_carrier_state":"NY","insp_carrier_zip_code":"11746","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:11.000000Z","updated_at":"2025-03-17T18:29:11.000000Z","inspection_violations":[{"id":143871,"change_date":"2023-12-11 21:40:00","inspection_id":"75206916","insp_violation_id":"256809821","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198435915","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":157186,"change_date":"2023-12-11 21:40:00","inspection_id":"75206916","insp_unit_id":"198435915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"40027NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTWNAZT29J130497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:11.000000Z","updated_at":"2025-03-17T22:09:11.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1383179\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1383179\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1383179\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1383179\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}