{"current_page":1,"data":[{"id":12364029,"change_date":"2026-07-06 21:38:00","inspection_id":"88325786","dot_number":"2937592","report_state":"NY","report_number":"SPL3011131","insp_date":"2026-06-29 00:00:00","insp_start_time":"1131","insp_end_time":"1147","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DIX HILLS NY","county_code_state":"NY","county_code":"103","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-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","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":"3688374","transaction_code":"A","transaction_date":"2026-07-05 00:00:00","upload_date":"2026-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2026-07-06 21:38:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-06 21:38:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-09T09:40:18.000000Z","updated_at":"2026-07-17T09:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21470598,"change_date":"2026-07-06 21:38:00","inspection_id":"88325786","insp_unit_id":"214457393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"19","insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-09T09:15:40.000000Z","updated_at":"2026-07-17T09:01:23.000000Z"},{"id":21470599,"change_date":"2026-07-06 21:38:00","inspection_id":"88325786","insp_unit_id":"214457394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMMIT TRA","insp_unit_company":null,"insp_unit_license":"CF37885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-09T09:15:40.000000Z","updated_at":"2026-07-17T09:01:23.000000Z"}]},{"id":11716424,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","dot_number":"2937592","report_state":"NY","report_number":"0L91001192","insp_date":"2026-04-15 00:00:00","insp_start_time":"1535","insp_end_time":"1608","registration_date":"2026-05-11 00:00:00","region":"ED","ci_status_code":"C","location":"00096N","location_desc":"PATCHOGUE 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-04-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3191501","transaction_code":"C","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2026-04-22 21:38:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-22 21:38:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:39:01.000000Z","updated_at":"2026-05-23T09:30:03.000000Z","inspection_violations":[{"id":20366472,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192355","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"213499255","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":20366470,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192353","seq_no":"3","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"213499255","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":20366471,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192354","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213499254","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H926LJMPXZ","created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"39395F"},{"id":20366473,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192356","seq_no":"6","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"213499255","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"3922SLLMF"},{"id":20366474,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192357","seq_no":"7","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"213499255","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":20366468,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192351","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213499254","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H926LJMPNZ","created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"39378AWS"},{"id":20366469,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_violation_id":"274192352","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213499254","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:57:21.000000Z","updated_at":"2026-05-23T09:43:59.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20388421,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_unit_id":"213499254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"19","insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:15:58.000000Z","updated_at":"2026-05-23T09:02:11.000000Z"},{"id":20388422,"change_date":"2026-05-12 21:39:00","inspection_id":"87643682","insp_unit_id":"213499255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMMIT TRA","insp_unit_company":null,"insp_unit_license":"CF37885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:15:58.000000Z","updated_at":"2026-05-23T09:02:11.000000Z"}]},{"id":11273759,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","dot_number":"2937592","report_state":"NY","report_number":"0L90001395","insp_date":"2026-02-26 00:00:00","insp_start_time":"1723","insp_end_time":"1753","registration_date":"2026-03-26 00:00:00","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-03 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"5","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2956180","transaction_code":"C","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2026-03-03 21:35:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-03 21:35:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-06T10:39:38.000000Z","updated_at":"2026-04-07T09:31:42.000000Z","inspection_violations":[{"id":19417662,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","insp_violation_id":"272683283","seq_no":"1","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921LCJC3W","created_at":"2026-03-30T10:20:00.000000Z","updated_at":"2026-04-07T09:46:05.000000Z","normalized_code":"3922WG"},{"id":19417663,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","insp_violation_id":"272683284","seq_no":"2","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921LCJC60","created_at":"2026-03-30T10:20:00.000000Z","updated_at":"2026-04-07T09:46:05.000000Z","normalized_code":"3922WG"},{"id":19417664,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","insp_violation_id":"272683285","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212374313","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921LCJC28","created_at":"2026-03-30T10:20:00.000000Z","updated_at":"2026-04-07T09:46:05.000000Z","normalized_code":"3922SLLSR"},{"id":19417665,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","insp_violation_id":"272683286","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"212374313","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921LCJBR1","created_at":"2026-03-30T10:20:00.000000Z","updated_at":"2026-04-07T09:46:05.000000Z","normalized_code":"3922SLLIFTA"},{"id":19417666,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","insp_violation_id":"272683287","seq_no":"5","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:00.000000Z","updated_at":"2026-04-07T09:46:05.000000Z","normalized_code":"3922WG"}],"inspection_per_units":[{"id":19688294,"change_date":"2026-03-27 21:39:00","inspection_id":"87188117","insp_unit_id":"212374313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"24","insp_unit_license":"33183ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBEX64N834522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:11.000000Z","updated_at":"2026-04-07T09:05:56.000000Z"}]},{"id":10537929,"change_date":"2026-01-20 21:39:00","inspection_id":"86674226","dot_number":"2937592","report_state":"NY","report_number":"0L73001703","insp_date":"2025-12-23 00:00:00","insp_start_time":"1440","insp_end_time":"1452","registration_date":"2026-01-17 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"BRENTWOOD NY","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-30 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"79000","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":"2708517","transaction_code":"C","transaction_date":"2025-12-30 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-12-30 21:36:00","snet_input_date":"2025-12-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-30 21:36:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-02T10:35:45.000000Z","updated_at":"2026-01-31T10:30:05.000000Z","inspection_violations":[{"id":18059760,"change_date":"2026-01-20 21:39:00","inspection_id":"86674226","insp_violation_id":"271297216","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"211170739","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-23T10:42:09.000000Z","updated_at":"2026-01-31T10:36:45.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":18143615,"change_date":"2026-01-20 21:39:00","inspection_id":"86674226","insp_unit_id":"211170739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"33183ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBEX64N834522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:12.000000Z","updated_at":"2026-01-31T10:02:20.000000Z"}]},{"id":10160319,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","dot_number":"2937592","report_state":"NY","report_number":"0L20001702","insp_date":"2025-11-08 00:00:00","insp_start_time":"0840","insp_end_time":"1052","registration_date":"2025-11-08 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"SMITHTOWN NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RAINBOW MATERIALS CORP.","shipping_paper_number":"37582","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"147540","viol_total":"9","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":"2523100","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-11-10 21:38:00","snet_input_date":"2025-11-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-10 21:38:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:31.000000Z","updated_at":"2025-11-14T10:30:16.000000Z","inspection_violations":[{"id":16865023,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839495","seq_no":"1","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209932278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRDRP","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3939ALBL"},{"id":16865024,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839496","seq_no":"2","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922WG"},{"id":16865025,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839497","seq_no":"3","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRD27","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922WG"},{"id":16865026,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839498","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209932278","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRCDB","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922SLLIFTA"},{"id":16865027,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839499","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209932278","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRCWZ","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922SLLSR"},{"id":16865028,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839500","seq_no":"6","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRDJR","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922WG"},{"id":16865029,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839501","seq_no":"7","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRDNF","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922WG"},{"id":16865030,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839502","seq_no":"8","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRD7J","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922WG"},{"id":16865031,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_violation_id":"269839503","seq_no":"9","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA25KZRDFW","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-14T10:30:31.000000Z","normalized_code":"3922WG"}],"inspection_per_units":[{"id":16916033,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_unit_id":"209932278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"15","insp_unit_license":"23493BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KJJALCK16PW75553","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:32.000000Z","updated_at":"2025-11-14T10:00:19.000000Z"},{"id":16916034,"change_date":"2025-11-10 21:38:00","inspection_id":"86279024","insp_unit_id":"209932279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENSON TRU","insp_unit_company":"D-19","insp_unit_license":"CJ20760","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5DMDAACC96M000411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:32.000000Z","updated_at":"2025-11-14T10:00:19.000000Z"}]},{"id":9994062,"change_date":"2025-11-07 21:39:00","inspection_id":"86103878","dot_number":"2937592","report_state":"NY","report_number":"0L20001671","insp_date":"2025-10-14 00:00:00","insp_start_time":"1539","insp_end_time":"1635","registration_date":"2025-11-06 00:00:00","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":"2025-10-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"176200","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2437408","transaction_code":"C","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-10-21 21:38:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-21 21:38:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-24T10:01:43.000000Z","updated_at":"2025-11-11T10:30:07.000000Z","inspection_violations":[{"id":16827187,"change_date":"2025-11-07 21:39:00","inspection_id":"86103878","insp_violation_id":"269797358","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"HA25KW453X","created_at":"2025-11-10T10:32:25.000000Z","updated_at":"2025-11-11T10:30:15.000000Z","normalized_code":"38323A2LCDLN"},{"id":16827188,"change_date":"2025-11-07 21:39:00","inspection_id":"86103878","insp_violation_id":"269797359","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":"HA25KW45V9","created_at":"2025-11-10T10:32:25.000000Z","updated_at":"2025-11-11T10:30:15.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":16880311,"change_date":"2025-11-07 21:39:00","inspection_id":"86103878","insp_unit_id":"209894955","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"04","insp_unit_license":"17766BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X4GR113723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:01:48.000000Z","updated_at":"2025-11-11T10:00:09.000000Z"},{"id":16880312,"change_date":"2025-11-07 21:39:00","inspection_id":"86103878","insp_unit_id":"209894956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"BU43365","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3046JC039958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:01:48.000000Z","updated_at":"2025-11-11T10:00:09.000000Z"}]},{"id":9775085,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","dot_number":"2937592","report_state":"NY","report_number":"0L83001029","insp_date":"2025-09-18 00:00:00","insp_start_time":"1219","insp_end_time":"1247","registration_date":"2025-10-07 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"DIX HILLS NY","county_code_state":"NY","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"175000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2322549","transaction_code":"C","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-09-25 21:40:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:40:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-28T10:00:58.000000Z","updated_at":"2025-10-11T10:00:14.000000Z","inspection_violations":[{"id":16270486,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_violation_id":"269137400","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H922KSBDXW","created_at":"2025-10-10T10:18:16.000000Z","updated_at":"2025-10-11T10:15:34.000000Z","normalized_code":"3922SLLEWG3"},{"id":16270487,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_violation_id":"269137401","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H922KSBF7X","created_at":"2025-10-10T10:18:16.000000Z","updated_at":"2025-10-11T10:15:34.000000Z","normalized_code":"3922SLLEWA3"},{"id":16270488,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_violation_id":"269137402","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H922KSBFD5","created_at":"2025-10-10T10:18:16.000000Z","updated_at":"2025-10-11T10:15:34.000000Z","normalized_code":"3922SLLEWA3"},{"id":16270489,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_violation_id":"269137403","seq_no":"4","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H922KSBFKG","created_at":"2025-10-10T10:18:16.000000Z","updated_at":"2025-10-11T10:15:34.000000Z","normalized_code":"3922WG"},{"id":16270490,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_violation_id":"269137404","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209332279","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:16.000000Z","updated_at":"2025-10-11T10:15:34.000000Z","normalized_code":"3922SLLSR"},{"id":16270491,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_violation_id":"269137405","seq_no":"6","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H922KSBFPF","created_at":"2025-10-10T10:18:16.000000Z","updated_at":"2025-10-11T10:15:34.000000Z","normalized_code":"3922WG"}],"inspection_per_units":[{"id":16377153,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_unit_id":"209332279","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"20913BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X42N583082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:40.000000Z","updated_at":"2025-10-11T09:45:21.000000Z"},{"id":16377154,"change_date":"2025-10-07 21:40:00","inspection_id":"85873128","insp_unit_id":"209332280","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"BT44338","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3042JC044350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:40.000000Z","updated_at":"2025-10-11T09:45:21.000000Z"}]},{"id":9504114,"change_date":"2025-10-07 21:40:00","inspection_id":"85589046","dot_number":"2937592","report_state":"NY","report_number":"SPL3030689","insp_date":"2025-08-19 00:00:00","insp_start_time":"0857","insp_end_time":"0912","registration_date":"2025-10-07 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":"2025-08-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2175801","transaction_code":"C","transaction_date":"2025-08-25 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-08-26 21:39:00","snet_input_date":"2025-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-26 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:49.000000Z","updated_at":"2025-10-11T10:00:09.000000Z","inspection_violations":[{"id":16268528,"change_date":"2025-10-07 21:40:00","inspection_id":"85589046","insp_violation_id":"269136655","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"209331897","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:10.000000Z","updated_at":"2025-10-11T10:15:19.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":16376186,"change_date":"2025-10-07 21:40:00","inspection_id":"85589046","insp_unit_id":"209331897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"24","insp_unit_license":"33183ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBEX64N834522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:36.000000Z","updated_at":"2025-10-11T09:45:14.000000Z"}]},{"id":8174349,"change_date":"2025-03-21 21:39:00","inspection_id":"84187188","dot_number":"2937592","report_state":"NY","report_number":"SPL4010046","insp_date":"2025-03-14 00:00:00","insp_start_time":"1246","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DEER PARK NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2025-03-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"175000","viol_total":"3","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":"1496417","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-03-21 21:39:00","snet_input_date":"2025-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:30.000000Z","updated_at":"2025-03-25T10:09:42.000000Z","inspection_violations":[{"id":12808798,"change_date":"2025-03-21 21:39:00","inspection_id":"84187188","insp_violation_id":"265175290","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S250175007","created_at":"2025-03-23T11:31:40.000000Z","updated_at":"2025-03-25T10:20:59.000000Z","normalized_code":"39216D"},{"id":12808799,"change_date":"2025-03-21 21:39:00","inspection_id":"84187188","insp_violation_id":"265175291","seq_no":"2","part_no":"383","part_no_section":"51A-SIN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"S250175008","created_at":"2025-03-23T11:31:40.000000Z","updated_at":"2025-03-25T10:20:59.000000Z","normalized_code":"38351ASIN"},{"id":12808800,"change_date":"2025-03-21 21:39:00","inspection_id":"84187188","insp_violation_id":"265175292","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205919595","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:31:40.000000Z","updated_at":"2025-03-25T10:20:59.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13211923,"change_date":"2025-03-21 21:39:00","inspection_id":"84187188","insp_unit_id":"205919595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"111","insp_unit_license":"20913BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X42N583082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:09:50.000000Z","updated_at":"2025-03-25T09:50:29.000000Z"},{"id":13211924,"change_date":"2025-03-21 21:39:00","inspection_id":"84187188","insp_unit_id":"205919596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":null,"insp_unit_license":"BT44338","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3042JC044350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:09:50.000000Z","updated_at":"2025-03-25T09:50:29.000000Z"}]},{"id":7998345,"change_date":"2025-03-01 21:34:00","inspection_id":"84001928","dot_number":"2937592","report_state":"NY","report_number":"0L48000630","insp_date":"2025-02-28 00:00:00","insp_start_time":"1205","insp_end_time":"1229","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BELLPORT NY","county_code_state":"NY","county_code":"103","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":"U","pen_cen_match":"I","final_status_date":"2025-03-01 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"197000","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":"1414396","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-03-01 21:34:00","snet_input_date":"2025-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-01 21:34:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:07.000000Z","updated_at":"2025-03-17T21:04:07.000000Z","inspection_violations":[{"id":12496762,"change_date":"2025-03-01 21:34:00","inspection_id":"84001928","insp_violation_id":"264774529","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:03.000000Z","updated_at":"2025-03-17T22:07:03.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12912390,"change_date":"2025-03-01 21:34:00","inspection_id":"84001928","insp_unit_id":"205572918","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"},{"id":12912391,"change_date":"2025-03-01 21:34:00","inspection_id":"84001928","insp_unit_id":"205572919","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMMIT TRA","insp_unit_company":null,"insp_unit_license":"CF37885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":8016947,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","dot_number":"2937592","report_state":"NY","report_number":"SPL3010417","insp_date":"2025-02-25 00:00:00","insp_start_time":"1317","insp_end_time":"1347","registration_date":null,"region":"ES","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":"2025-03-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"145400","viol_total":"4","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":"1426746","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-03-04 21:38:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-04 21:38:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:32.000000Z","updated_at":"2025-03-17T21:04:32.000000Z","inspection_violations":[{"id":12529126,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","insp_violation_id":"264813689","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"205607630","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"39355EB"},{"id":12529127,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","insp_violation_id":"264813690","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"205607630","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"393100BC"},{"id":12529128,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","insp_violation_id":"264813691","seq_no":"3","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"205607629","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"3939AHLLH"},{"id":12529129,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","insp_violation_id":"264813692","seq_no":"4","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:15.000000Z","updated_at":"2025-03-17T22:07:15.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12942816,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","insp_unit_id":"205607629","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2","insp_unit_license":"26559TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X16N896970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:58.000000Z","updated_at":"2025-03-17T23:57:58.000000Z"},{"id":12942817,"change_date":"2025-03-04 21:38:00","inspection_id":"84021493","insp_unit_id":"205607630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENSON TRU","insp_unit_company":null,"insp_unit_license":"BU49062","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5DMDSACC67M001868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:58.000000Z","updated_at":"2025-03-17T23:57:58.000000Z"}]},{"id":7838586,"change_date":"2025-02-11 21:39:00","inspection_id":"83834506","dot_number":"2937592","report_state":"NY","report_number":"SPL3070331","insp_date":"2025-02-04 00:00:00","insp_start_time":"1414","insp_end_time":"1430","registration_date":null,"region":"ES","ci_status_code":"C","location":"00412E","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":"2025-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","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":"1349216","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-02-11 21:39:00","snet_input_date":"2025-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-11 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:49.000000Z","updated_at":"2025-03-17T21:00:49.000000Z","inspection_violations":[{"id":12250359,"change_date":"2025-02-11 21:39:00","inspection_id":"83834506","insp_violation_id":"264452917","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205262576","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:46.000000Z","updated_at":"2025-03-17T22:05:46.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12650681,"change_date":"2025-02-11 21:39:00","inspection_id":"83834506","insp_unit_id":"205262576","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"},{"id":12650682,"change_date":"2025-02-11 21:39:00","inspection_id":"83834506","insp_unit_id":"205262577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMMIT TRA","insp_unit_company":null,"insp_unit_license":"CF37885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"}]},{"id":7622053,"change_date":"2025-01-15 21:41:00","inspection_id":"83606940","dot_number":"2937592","report_state":"NY","report_number":"SPL3030209","insp_date":"2025-01-08 00:00:00","insp_start_time":"1220","insp_end_time":"1235","registration_date":null,"region":"ES","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":"2025-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248740","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:30.000000Z","updated_at":"2025-03-17T20:56:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12298585,"change_date":"2025-01-15 21:41:00","inspection_id":"83606940","insp_unit_id":"204839895","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"24","insp_unit_license":"33183ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBEX64N834522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:43.000000Z","updated_at":"2025-03-17T23:50:43.000000Z"}]},{"id":7290338,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","dot_number":"2937592","report_state":"NY","report_number":"N102630743","insp_date":"2024-11-21 00:00:00","insp_start_time":"0415","insp_end_time":"1021","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BROOKLYN NY","county_code_state":"NY","county_code":"047","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-27 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"80000","viol_total":"8","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":"1095724","transaction_code":"C","transaction_date":"2024-11-26 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:10.000000Z","updated_at":"2025-11-26T10:31:05.000000Z","inspection_violations":[{"id":17135836,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203606","seq_no":"1","part_no":"393","part_no_section":"75A3-TFL","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"39375A3TFL"},{"id":17135837,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203607","seq_no":"2","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"393203CCBP"},{"id":17135838,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203608","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"3939ALHLI"},{"id":17135839,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203609","seq_no":"4","part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"393201BFR"},{"id":17135840,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203610","seq_no":"5","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"393207ASAPPAS"},{"id":17135841,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203611","seq_no":"6","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"393207ASTCB"},{"id":17135842,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203612","seq_no":"7","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"3939ALFTSI"},{"id":17135843,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_violation_id":"270203613","seq_no":"8","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"210202771","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:19.000000Z","updated_at":"2025-11-26T10:35:54.000000Z","normalized_code":"3963A1F"}],"inspection_per_units":[{"id":17128406,"change_date":"2025-11-22 21:49:00","inspection_id":"83258249","insp_unit_id":"210202771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"28975TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X2JD485693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:28.000000Z","updated_at":"2025-11-26T10:01:19.000000Z"}]},{"id":6420401,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","dot_number":"2937592","report_state":"NY","report_number":"D011901068","insp_date":"2024-08-08 00:00:00","insp_start_time":"0943","insp_end_time":"1021","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY 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":"2024-08-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"146190","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"730102","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2024-08-08 21:41:00","snet_input_date":"2024-08-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-08 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:15.000000Z","updated_at":"2025-03-17T20:30:15.000000Z","inspection_violations":[{"id":9970171,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_violation_id":"261084956","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"202295735","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2JC0ZVX","created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39360D"},{"id":9970172,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_violation_id":"261084957","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"202295735","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2JC103H","created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39355C1"},{"id":9970173,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_violation_id":"261084958","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202295736","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2JC0ZSK","created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39375C"},{"id":9970174,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_violation_id":"261084959","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202295736","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2JC0ZKW","created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39375C"},{"id":9970175,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_violation_id":"261084960","seq_no":"5","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"202295736","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2JC0ZZQ","created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39355E"},{"id":9970176,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_violation_id":"261084961","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202295736","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2JC1086","created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10347495,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_unit_id":"202295735","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"1","insp_unit_license":"28744TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X6GR113724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:13.000000Z","updated_at":"2025-03-17T23:30:13.000000Z"},{"id":10347496,"change_date":"2024-08-08 21:41:00","inspection_id":"82333719","insp_unit_id":"202295736","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST DUMP","insp_unit_company":null,"insp_unit_license":"BU49015","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1E1D3N484GR054657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:13.000000Z","updated_at":"2025-03-17T23:30:13.000000Z"}]},{"id":6227538,"change_date":"2024-07-16 21:43:00","inspection_id":"82127287","dot_number":"2937592","report_state":"NY","report_number":"SPL0135780","insp_date":"2024-07-09 00:00:00","insp_start_time":"0930","insp_end_time":"0955","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-07-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","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":"2937240","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2024-07-16 21:43:00","snet_input_date":"2024-07-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-16 21:43:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:12.000000Z","updated_at":"2025-03-17T20:26:12.000000Z","inspection_violations":[{"id":9675313,"change_date":"2024-07-16 21:43:00","inspection_id":"82127287","insp_violation_id":"260664909","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201903447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"3939A"},{"id":9675314,"change_date":"2024-07-16 21:43:00","inspection_id":"82127287","insp_violation_id":"260664910","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201903448","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"39355E"},{"id":9675315,"change_date":"2024-07-16 21:43:00","inspection_id":"82127287","insp_violation_id":"260664911","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201903448","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10033738,"change_date":"2024-07-16 21:43:00","inspection_id":"82127287","insp_unit_id":"201903447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19","insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:57.000000Z","updated_at":"2025-03-17T23:26:57.000000Z"},{"id":10033739,"change_date":"2024-07-16 21:43:00","inspection_id":"82127287","insp_unit_id":"201903448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMT","insp_unit_company":null,"insp_unit_license":"CF37885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:57.000000Z","updated_at":"2025-03-17T23:26:57.000000Z"}]},{"id":5585008,"change_date":"2024-04-24 21:41:00","inspection_id":"81431592","dot_number":"2937592","report_state":"NY","report_number":"SPD0300544","insp_date":"2024-04-23 00:00:00","insp_start_time":"0205","insp_end_time":"0225","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":"RAINBOW MATERIALS 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":"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-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","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":"2919271","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:29.000000Z","updated_at":"2025-03-17T20:13:29.000000Z","inspection_violations":[{"id":8633880,"change_date":"2024-04-24 21:41:00","inspection_id":"81431592","insp_violation_id":"259104646","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200547965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HZM3GH","created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3939A"},{"id":8633881,"change_date":"2024-04-24 21:41:00","inspection_id":"81431592","insp_violation_id":"259104647","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200547966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HZM3KK","created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3939A"},{"id":8633882,"change_date":"2024-04-24 21:41:00","inspection_id":"81431592","insp_violation_id":"259104648","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200547966","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":8996076,"change_date":"2024-04-24 21:41:00","inspection_id":"81431592","insp_unit_id":"200547965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"},{"id":8996077,"change_date":"2024-04-24 21:41:00","inspection_id":"81431592","insp_unit_id":"200547966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"CF37885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"}]},{"id":5148648,"change_date":"2024-02-28 21:41:00","inspection_id":"80955756","dot_number":"2937592","report_state":"NY","report_number":"0L73001017","insp_date":"2024-02-27 00:00:00","insp_start_time":"1527","insp_end_time":"1546","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BAY SHORE NY","county_code_state":"NY","county_code":"103","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"95530","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":"274592","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2024-02-28 21:41:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-28 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:33.000000Z","updated_at":"2025-03-17T20:04:33.000000Z","inspection_violations":[{"id":7942123,"change_date":"2024-02-28 21:41:00","inspection_id":"80955756","insp_violation_id":"258074698","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:24.000000Z","updated_at":"2025-03-17T21:44:24.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":8289954,"change_date":"2024-02-28 21:41:00","inspection_id":"80955756","insp_unit_id":"199630046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"28975TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X2JD485693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"},{"id":8289955,"change_date":"2024-02-28 21:41:00","inspection_id":"80955756","insp_unit_id":"199630047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"BU43467","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3042KC045194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"}]},{"id":5005679,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","dot_number":"2937592","report_state":"NY","report_number":"SPL0164842","insp_date":"2024-02-07 00:00:00","insp_start_time":"0641","insp_end_time":"0710","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-02-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2904922","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-02-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:00.000000Z","updated_at":"2025-03-17T20:02:00.000000Z","inspection_violations":[{"id":7711284,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","insp_violation_id":"257730731","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199327527","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"3922"},{"id":7711285,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","insp_violation_id":"257730732","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"199327528","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39355E"},{"id":7711286,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","insp_violation_id":"257730733","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199327528","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3HPGXB4","created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39375A3"},{"id":7711287,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","insp_violation_id":"257730734","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199327528","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8056658,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","insp_unit_id":"199327527","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"13","insp_unit_license":"28975TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X2JD485693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:01.000000Z","updated_at":"2025-03-17T23:08:01.000000Z"},{"id":8056659,"change_date":"2024-02-08 21:42:00","inspection_id":"80799591","insp_unit_id":"199327528","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BU43467","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3042KC045194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:01.000000Z","updated_at":"2025-03-17T23:08:01.000000Z"}]},{"id":4233891,"change_date":"2023-10-19 21:40:00","inspection_id":"79951892","dot_number":"2937592","report_state":"NY","report_number":"SPL0164598","insp_date":"2023-10-18 00:00:00","insp_start_time":"1240","insp_end_time":"1255","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":"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-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162200","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":"2880279","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-10-19 21:40:00","snet_input_date":"2023-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-19 21:40:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:39.000000Z","updated_at":"2025-03-17T19:46:39.000000Z","inspection_violations":[{"id":6555757,"change_date":"2023-10-19 21:40:00","inspection_id":"79951892","insp_violation_id":"255928488","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197637480","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6809002,"change_date":"2023-10-19 21:40:00","inspection_id":"79951892","insp_unit_id":"197637480","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"17766BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X4GR113723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:04.000000Z","updated_at":"2025-03-17T22:57:04.000000Z"},{"id":6809003,"change_date":"2023-10-19 21:40:00","inspection_id":"79951892","insp_unit_id":"197637481","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BU43365","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3046JC039958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:04.000000Z","updated_at":"2025-03-17T22:57:04.000000Z"}]},{"id":3784956,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","dot_number":"2937592","report_state":"NY","report_number":"SPD0215525","insp_date":"2023-08-15 00:00:00","insp_start_time":"1415","insp_end_time":"1450","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":"JAKE CONSTRUCTION","shipping_paper_number":"23194","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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"179200","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2860078","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2023-08-21 21:41:00","snet_input_date":"2023-08-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAYSHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:39.000000Z","updated_at":"2025-03-17T19:37:39.000000Z","inspection_violations":[{"id":5839229,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","insp_violation_id":"254760834","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196625451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1H2QQZ1","created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3939A"},{"id":5839230,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","insp_violation_id":"254760835","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196625451","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39345B2"},{"id":5839231,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","insp_violation_id":"254760836","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"196625452","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39355E"},{"id":5839232,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","insp_violation_id":"254760837","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"196625452","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6085500,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","insp_unit_id":"196625451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"16673BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X4HR162258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"},{"id":6085501,"change_date":"2023-08-21 21:41:00","inspection_id":"79452972","insp_unit_id":"196625452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BU78707","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3048HC037271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"}]},{"id":3784957,"change_date":"2023-08-21 21:41:00","inspection_id":"79452973","dot_number":"2937592","report_state":"NY","report_number":"SPD0215526","insp_date":"2023-08-15 00:00:00","insp_start_time":"1455","insp_end_time":"1528","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":"PERSI","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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"180400","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":"2860150","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2023-08-21 21:41:00","snet_input_date":"2023-08-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-21 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:39.000000Z","updated_at":"2025-03-17T19:37:39.000000Z","inspection_violations":[{"id":5839233,"change_date":"2023-08-21 21:41:00","inspection_id":"79452973","insp_violation_id":"254760838","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"196625453","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39355D3"},{"id":5839234,"change_date":"2023-08-21 21:41:00","inspection_id":"79452973","insp_violation_id":"254760839","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"196625454","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"39355E"},{"id":5839235,"change_date":"2023-08-21 21:41:00","inspection_id":"79452973","insp_violation_id":"254760840","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196625454","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:34:04.000000Z","updated_at":"2025-03-17T21:34:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6085502,"change_date":"2023-08-21 21:41:00","inspection_id":"79452973","insp_unit_id":"196625453","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"02","insp_unit_license":"26559TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X16N896970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"},{"id":6085503,"change_date":"2023-08-21 21:41:00","inspection_id":"79452973","insp_unit_id":"196625454","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"CA72982","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3349GC035099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:09.000000Z","updated_at":"2025-03-17T22:51:09.000000Z"}]},{"id":3669343,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","dot_number":"2937592","report_state":"NY","report_number":"0L35002345","insp_date":"2023-08-03 00:00:00","insp_start_time":"1457","insp_end_time":"1650","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCPD HQ YAPHANK","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"176200","viol_total":"13","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2855375","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2023-08-04 21:40:00","snet_input_date":"2023-08-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-04 21:40:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:17.000000Z","updated_at":"2025-03-17T19:35:17.000000Z","inspection_violations":[{"id":5657310,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465147","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":"HA26H1GMWD","created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"3922"},{"id":5657311,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465148","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"196361192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA26H1GPZ6","created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39355C1"},{"id":5657312,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465149","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196361192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"3963A1"},{"id":5657313,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465150","seq_no":"4","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39355C2"},{"id":5657314,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465151","seq_no":"5","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39355E"},{"id":5657315,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465152","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA26H1GP4P","created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39375C"},{"id":5657316,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465153","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA26H1GPHW","created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39375C"},{"id":5657317,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465154","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"3963A1"},{"id":5657318,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465155","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39347E"},{"id":5657319,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465156","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39353B"},{"id":5657320,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465157","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39347E"},{"id":5657321,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465158","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA26H1GPNZ","created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"39347E"},{"id":5657322,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_violation_id":"254465159","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196361193","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5899244,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_unit_id":"196361192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"28745TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X4GR113723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:35.000000Z","updated_at":"2025-03-17T22:49:35.000000Z"},{"id":5899245,"change_date":"2023-08-04 21:40:00","inspection_id":"79324166","insp_unit_id":"196361193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BU43365","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3046JC039958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:35.000000Z","updated_at":"2025-03-17T22:49:35.000000Z"}]},{"id":3605488,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","dot_number":"2937592","report_state":"NY","report_number":"NY15002548","insp_date":"2023-07-26 00:00:00","insp_start_time":"0835","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TILLARY STREET","county_code_state":"NY","county_code":"047","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2851801","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[{"id":5559601,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_violation_id":"254307461","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196219151","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455692158","created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"3922"},{"id":5559602,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_violation_id":"254307462","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196219151","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455692161","created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"3922"},{"id":5559603,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_violation_id":"254307463","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196219151","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455692175","created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"3922"},{"id":5559604,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_violation_id":"254307464","seq_no":"4","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"2","insp_unit_id":"196219152","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"39355C2"},{"id":5559605,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_violation_id":"254307465","seq_no":"5","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"2","insp_unit_id":"196219152","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"393104A"},{"id":5559606,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_violation_id":"254307466","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196219152","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:45.000000Z","updated_at":"2025-03-17T21:32:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5796973,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_unit_id":"196219151","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"},{"id":5796974,"change_date":"2023-07-27 21:40:00","inspection_id":"79252404","insp_unit_id":"196219152","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMT","insp_unit_company":null,"insp_unit_license":"BR68654","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3041G0012791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3208313,"change_date":"2023-06-05 21:42:00","inspection_id":"78805637","dot_number":"2937592","report_state":"NY","report_number":"SPWL011201","insp_date":"2023-05-31 00:00:00","insp_start_time":"0900","insp_end_time":"0958","registration_date":null,"region":"ET","ci_status_code":"C","location":"01425","location_desc":"BALDWIN","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-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"180040","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2831889","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2023-06-05 21:42:00","snet_input_date":"2023-06-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-05 21:42:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAYSHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706","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":4943509,"change_date":"2023-06-05 21:42:00","inspection_id":"78805637","insp_violation_id":"253272294","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195306493","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1GSLW0Z","created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3963A1"},{"id":4943510,"change_date":"2023-06-05 21:42:00","inspection_id":"78805637","insp_violation_id":"253272295","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"195306493","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3969D2"},{"id":4943511,"change_date":"2023-06-05 21:42:00","inspection_id":"78805637","insp_violation_id":"253272296","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195306493","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":5159724,"change_date":"2023-06-05 21:42:00","inspection_id":"78805637","insp_unit_id":"195306493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"26559TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X16N896970","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":5159725,"change_date":"2023-06-05 21:42:00","inspection_id":"78805637","insp_unit_id":"195306494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"CA72982","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3349GC035099","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":3049703,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","dot_number":"2937592","report_state":"NY","report_number":"NY18001562","insp_date":"2023-05-16 00:00:00","insp_start_time":"0645","insp_end_time":"0758","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RODNEY ST @ HOPE ST","county_code_state":"NY","county_code":"047","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2825207","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-05-16 21:41:00","snet_input_date":"2023-05-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-16 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4687257,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847440","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083634","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3922"},{"id":4687258,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847441","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083648","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39021TB"},{"id":4687259,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847442","seq_no":"3","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083651","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39355D1"},{"id":4687260,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847443","seq_no":"4","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083665","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39381"},{"id":4687261,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847444","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083679","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39345B2"},{"id":4687262,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847445","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4453083682","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3963A1"},{"id":4687263,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847446","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194942352","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4453083898","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3963A1"},{"id":4687264,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847447","seq_no":"8","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194942353","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083906","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39375C"},{"id":4687265,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_violation_id":"252847448","seq_no":"9","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"2","insp_unit_id":"194942353","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4453083910","created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"393104A"}],"inspection_per_units":[{"id":4906244,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_unit_id":"194942352","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"26559TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X16N896970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:41.000000Z","updated_at":"2025-03-17T22:41:41.000000Z"},{"id":4906245,"change_date":"2023-05-16 21:41:00","inspection_id":"78626823","insp_unit_id":"194942353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"CA72982","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3349GC035099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:41.000000Z","updated_at":"2025-03-17T22:41:41.000000Z"}]},{"id":3019060,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","dot_number":"2937592","report_state":"NY","report_number":"SPL0135043","insp_date":"2023-05-10 00:00:00","insp_start_time":"1105","insp_end_time":"1154","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-05-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"180040","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":"2824327","transaction_code":"A","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-05-11 21:41:00","snet_input_date":"2023-05-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-11 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:40.000000Z","updated_at":"2025-03-17T19:22:40.000000Z","inspection_violations":[{"id":4637467,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_violation_id":"252763561","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194870109","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"3965B"},{"id":4637468,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_violation_id":"252763562","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194870109","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"3922"},{"id":4637469,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_violation_id":"252763563","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194870109","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"39311"},{"id":4637470,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_violation_id":"252763564","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194870109","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"3922"},{"id":4637471,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_violation_id":"252763565","seq_no":"5","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194870110","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:35.000000Z","updated_at":"2025-03-17T21:28:35.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4856733,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_unit_id":"194870109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"02","insp_unit_license":"26559TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X16N896970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:17.000000Z","updated_at":"2025-03-17T22:41:17.000000Z"},{"id":4856734,"change_date":"2023-05-11 21:41:00","inspection_id":"78592099","insp_unit_id":"194870110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"CA72982","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3349GC035099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:17.000000Z","updated_at":"2025-03-17T22:41:17.000000Z"}]},{"id":2793812,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","dot_number":"2937592","report_state":"NY","report_number":"0L90000007","insp_date":"2023-04-11 00:00:00","insp_start_time":"1538","insp_end_time":"1630","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B 495 AT EXIT 66","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"71250","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2815266","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":null,"census_search_date":"2023-04-13 21:42:00","snet_input_date":"2023-04-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-13 21:42:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:06.000000Z","updated_at":"2025-03-17T19:18:06.000000Z","inspection_violations":[{"id":4286656,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193179","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GMQQ8","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286657,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193180","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GM9RIK","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286658,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193181","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GM9R4W","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286659,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193182","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GM9R9B","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286660,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193183","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GM9RD7","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286661,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193184","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GM9RHS","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286662,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193185","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H921GM9RM5","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4286663,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_violation_id":"252193186","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194360914","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4496286,"change_date":"2023-04-13 21:42:00","inspection_id":"78337136","insp_unit_id":"194360914","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"33183ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBEX64N834522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:27.000000Z","updated_at":"2025-03-17T22:38:27.000000Z"}]},{"id":2598748,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","dot_number":"2937592","report_state":"NY","report_number":"NY18001506","insp_date":"2023-03-17 00:00:00","insp_start_time":"0605","insp_end_time":"0716","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RODNEY ST @ HOPE ST","county_code_state":"NY","county_code":"047","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2807304","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-03-17 21:41:00","snet_input_date":"2023-03-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-17 21:41:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:31.000000Z","updated_at":"2025-03-17T19:14:31.000000Z","inspection_violations":[{"id":3998107,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_violation_id":"251720861","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193923353","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455749096","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"},{"id":3998108,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_violation_id":"251720862","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193923353","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455749104","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"},{"id":3998109,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_violation_id":"251720863","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193923353","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455749118","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3922"},{"id":3998110,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_violation_id":"251720864","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193923353","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455749121","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"39375C"},{"id":3998111,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_violation_id":"251720865","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193923353","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455749135","created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":4182848,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_unit_id":"193923353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28975TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X2JD485693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"},{"id":4182849,"change_date":"2023-03-17 21:41:00","inspection_id":"78115399","insp_unit_id":"193923354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BU43467","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3042KC045194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"}]},{"id":2549788,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","dot_number":"2937592","report_state":"NY","report_number":"NY18001500","insp_date":"2023-03-09 00:00:00","insp_start_time":"0842","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RODNEY ST @ HOPE ST","county_code_state":"NY","county_code":"047","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-03-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2804981","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-03-10 21:40:00","snet_input_date":"2023-03-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-10 21:40:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:42.000000Z","updated_at":"2025-03-17T19:13:42.000000Z","inspection_violations":[{"id":3921527,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586605","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193805900","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455748841","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39375C"},{"id":3921528,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586606","seq_no":"2","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"2","insp_unit_id":"193805901","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455748855","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"393104A"},{"id":3921529,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586607","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193805901","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455748869","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39347E"},{"id":3921530,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586608","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"193805901","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455748872","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39353B"},{"id":3921531,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586609","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"193805901","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455748886","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39348A"},{"id":3921532,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586610","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193805900","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4455749691","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3963A1"},{"id":3921533,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_violation_id":"251586611","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193805900","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4455749700","created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4103932,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_unit_id":"193805900","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"26559TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X16N896970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"},{"id":4103933,"change_date":"2023-03-10 21:40:00","inspection_id":"78059191","insp_unit_id":"193805901","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"CA72982","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3349GC035099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:24.000000Z","updated_at":"2025-03-17T22:35:24.000000Z"}]},{"id":2331250,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","dot_number":"2937592","report_state":"NY","report_number":"0L69000672","insp_date":"2023-02-08 00:00:00","insp_start_time":"1204","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"01427R","location_desc":"TOWN OF N. HEMPSTEAD LOT #7","county_code_state":"NY","county_code":"059","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"8","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2797258","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-02-09 21:39:00","snet_input_date":"2023-02-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:38.000000Z","updated_at":"2025-03-17T19:09:38.000000Z","inspection_violations":[{"id":3591047,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033247","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":"PW88GDNZD6","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"38323A2"},{"id":3591048,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033248","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":"Y","defect_verification_id":"3","citation_number":"PW88GDNZSJ","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39141A1"},{"id":3591049,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033249","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"193306832","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39375G"},{"id":3591050,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033250","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193306832","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88GDP00W","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"},{"id":3591051,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033251","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193306832","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88GDP080","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"},{"id":3591052,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033252","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193306832","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88GDP0GR","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"},{"id":3591053,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033253","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193306832","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88GDP100","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"},{"id":3591054,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_violation_id":"251033254","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193306832","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PW88GDP12R","created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3751540,"change_date":"2023-02-09 21:39:00","inspection_id":"77810041","insp_unit_id":"193306832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"21","insp_unit_license":"74960NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAEAV14PM58678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:52.000000Z","updated_at":"2025-03-17T22:32:52.000000Z"}]},{"id":2110998,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","dot_number":"2937592","report_state":"NY","report_number":"SPD0270665","insp_date":"2023-01-10 00:00:00","insp_start_time":"0655","insp_end_time":"0756","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":"RAINBOW MATERIALS 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":"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-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2787218","transaction_code":"A","transaction_date":"2023-01-11 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2023-01-11 21:42:00","snet_input_date":"2023-01-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:32.000000Z","updated_at":"2025-03-17T19:05:32.000000Z","inspection_violations":[{"id":3269140,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496182","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192798427","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39345B2"},{"id":3269141,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496183","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192798427","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2G9KF4V","created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39395A"},{"id":3269142,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496184","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192798427","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3922"},{"id":3269143,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496185","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192798427","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2G9KFBJ","created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3939A"},{"id":3269144,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496186","seq_no":"5","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"192798427","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39355D2"},{"id":3269145,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496187","seq_no":"6","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"192798428","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"393207A"},{"id":3269146,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496188","seq_no":"7","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"192798428","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39355E"},{"id":3269147,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_violation_id":"250496189","seq_no":"8","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192798428","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3397245,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_unit_id":"192798427","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:21.000000Z","updated_at":"2025-03-17T22:30:21.000000Z"},{"id":3397246,"change_date":"2023-01-11 21:42:00","inspection_id":"77558877","insp_unit_id":"192798428","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BR68654","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3041G0012791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:21.000000Z","updated_at":"2025-03-17T22:30:21.000000Z"}]},{"id":1992566,"change_date":"2022-12-21 21:39:00","inspection_id":"77423592","dot_number":"2937592","report_state":"NY","report_number":"0L35002249","insp_date":"2022-12-20 00:00:00","insp_start_time":"1310","insp_end_time":"1408","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SR 495 EAST EXITS 70-71","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":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2782294","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[{"id":3093400,"change_date":"2022-12-21 21:39:00","inspection_id":"77423592","insp_violation_id":"250211575","seq_no":"1","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":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39141A1"},{"id":3093401,"change_date":"2022-12-21 21:39:00","inspection_id":"77423592","insp_violation_id":"250211576","seq_no":"2","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":"HA26G7C2QG","created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"38323A2"},{"id":3093402,"change_date":"2022-12-21 21:39:00","inspection_id":"77423592","insp_violation_id":"250211577","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"192529534","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":3205539,"change_date":"2022-12-21 21:39:00","inspection_id":"77423592","insp_unit_id":"192529534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"21","insp_unit_license":"74960NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAEAV14PM58678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:57.000000Z","updated_at":"2025-03-17T22:28:57.000000Z"}]},{"id":1340333,"change_date":"2022-09-22 21:39:00","inspection_id":"76673486","dot_number":"2937592","report_state":"NY","report_number":"SPWL011071","insp_date":"2022-09-21 00:00:00","insp_start_time":"1005","insp_end_time":"1032","registration_date":null,"region":"ET","ci_status_code":"C","location":"01425","location_desc":"ROCKVILLE CENTRE","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"81793","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":"2752004","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2022-09-22 21:39:00","snet_input_date":"2022-09-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-22 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:34.000000Z","updated_at":"2025-03-17T18:51:34.000000Z","inspection_violations":[{"id":2123586,"change_date":"2022-09-22 21:39:00","inspection_id":"76673486","insp_violation_id":"248574811","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191033672","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2158182,"change_date":"2022-09-22 21:39:00","inspection_id":"76673486","insp_unit_id":"191033671","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28737TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0JD485692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:46.000000Z","updated_at":"2025-03-17T22:21:46.000000Z"},{"id":2158183,"change_date":"2022-09-22 21:39:00","inspection_id":"76673486","insp_unit_id":"191033672","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"SUMT","insp_unit_company":null,"insp_unit_license":"BU49088","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1S8AD3043G0012792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:46.000000Z","updated_at":"2025-03-17T22:21:46.000000Z"}]},{"id":1256008,"change_date":"2022-09-12 21:42:00","inspection_id":"76575179","dot_number":"2937592","report_state":"NY","report_number":"0L67000914","insp_date":"2022-09-09 00:00:00","insp_start_time":"1106","insp_end_time":"1118","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B 495 EXIT 48 PLAINVIEW","county_code_state":"NY","county_code":"059","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":"Y","pen_cen_match":"I","final_status_date":"2022-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"180320","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":"2747973","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2022-09-12 21:42:00","snet_input_date":"2022-09-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-12 21:42:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:46.000000Z","updated_at":"2025-03-17T18:49:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2021285,"change_date":"2022-09-12 21:42:00","inspection_id":"76575179","insp_unit_id":"190827836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"13","insp_unit_license":"28975TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X2JD485693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:53.000000Z","updated_at":"2025-03-17T22:20:53.000000Z"},{"id":2021286,"change_date":"2022-09-12 21:42:00","inspection_id":"76575179","insp_unit_id":"190827837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BU43467","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3042KC045194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:53.000000Z","updated_at":"2025-03-17T22:20:53.000000Z"}]},{"id":1121559,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","dot_number":"2937592","report_state":"NY","report_number":"0L45001237","insp_date":"2022-08-23 00:00:00","insp_start_time":"0900","insp_end_time":"1219","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WICKS PARK AND RIDE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"16","oos_total":"6","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"6","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2743066","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:31.000000Z","updated_at":"2025-03-17T18:47:31.000000Z","inspection_violations":[{"id":1771572,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951916","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39355C1"},{"id":1771573,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951917","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39347E"},{"id":1771574,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951918","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39353B"},{"id":1771575,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951919","seq_no":"4","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39347B"},{"id":1771576,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951920","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39345B2"},{"id":1771577,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951921","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39345B2"},{"id":1771578,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951922","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H929FSMZB5","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"},{"id":1771579,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951923","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H929FSMZZ6","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"},{"id":1771580,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951924","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H929FSN080","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"},{"id":1771581,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951925","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H929FSN04H","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"},{"id":1771582,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951926","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H929FSN0F4","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"},{"id":1771583,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951927","seq_no":"12","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39375G"},{"id":1771584,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951928","seq_no":"13","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"H929FSN0LK","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39375G"},{"id":1771585,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951929","seq_no":"14","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39375G"},{"id":1771586,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951930","seq_no":"15","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39375G"},{"id":1771587,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_violation_id":"247951931","seq_no":"16","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"190508765","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"H929FSN0VJ","created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":1803864,"change_date":"2022-08-24 21:39:00","inspection_id":"76419404","insp_unit_id":"190508765","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"21","insp_unit_license":"74960NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5KKMAEAV14PM58678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":221583,"change_date":"2022-04-21 21:40:00","inspection_id":"75357261","dot_number":"2937592","report_state":"NY","report_number":"SPL0077849","insp_date":"2022-04-01 00:00:00","insp_start_time":"1659","insp_end_time":"1717","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2697505","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02937592","upload_search_indicator":"M","census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"RAINBOW MATERIALS CORP","insp_carrier_street":"4 ONEILL AVE","insp_carrier_city":"BAY SHORE","insp_carrier_state":"NY","insp_carrier_zip_code":"11706-7407","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":359069,"change_date":"2022-04-21 21:40:00","inspection_id":"75357261","insp_unit_id":"188264648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"24","insp_unit_license":"54351ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBEX64N834522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:20.000000Z","updated_at":"2025-03-17T22:10:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2937592\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2937592\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2937592\/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\/2937592\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}