{"current_page":1,"data":[{"id":9805828,"change_date":"2025-09-29 21:39:00","inspection_id":"85905548","dot_number":"3824273","report_state":"MD","report_number":"2329C00324","insp_date":"2025-09-24 00:00:00","insp_start_time":"0705","insp_end_time":"0724","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH EAST MD","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27000","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":"2343352","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:21.000000Z","updated_at":"2025-10-03T10:00:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16253254,"change_date":"2025-09-29 21:39:00","inspection_id":"85905548","insp_unit_id":"209198517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C112167","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT7LED12829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:20.000000Z","updated_at":"2025-10-03T09:46:08.000000Z"},{"id":16253255,"change_date":"2025-09-29 21:39:00","inspection_id":"85905548","insp_unit_id":"209198518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NEW HEIGHT","insp_unit_company":null,"insp_unit_license":"T118616","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1N9EBDN17RL253983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:20.000000Z","updated_at":"2025-10-03T09:46:08.000000Z"}]},{"id":8959793,"change_date":"2025-06-23 21:40:00","inspection_id":"85016470","dot_number":"3824273","report_state":"NJ","report_number":"SPSCI01838","insp_date":"2025-06-20 00:00:00","insp_start_time":"0724","insp_end_time":"0742","registration_date":null,"region":"ET","ci_status_code":"C","location":"1710","location_desc":"295 NB MP 4","county_code_state":"NJ","county_code":"033","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1296593","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2025-06-23 21:40:00","snet_input_date":"2025-06-20 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-06-23 21:40:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:30.000000Z","updated_at":"2025-06-28T10:00:30.000000Z","inspection_violations":[{"id":14391031,"change_date":"2025-06-23 21:40:00","inspection_id":"85016470","insp_violation_id":"266984518","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-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:35.000000Z","normalized_code":"3922SLLTCD"},{"id":14391032,"change_date":"2025-06-23 21:40:00","inspection_id":"85016470","insp_violation_id":"266984519","seq_no":"2","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"207504087","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:35.000000Z","normalized_code":"3922SLLMF"},{"id":14391033,"change_date":"2025-06-23 21:40:00","inspection_id":"85016470","insp_violation_id":"266984520","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"207504087","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:35.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":14686861,"change_date":"2025-06-23 21:40:00","inspection_id":"85016470","insp_unit_id":"207504087","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C133747","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT6PED46086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:34.000000Z","updated_at":"2025-06-27T09:45:45.000000Z"}]},{"id":8683271,"change_date":"2025-05-20 21:40:00","inspection_id":"84723136","dot_number":"3824273","report_state":"MD","report_number":"0249C00197","insp_date":"2025-05-19 00:00:00","insp_start_time":"1100","insp_end_time":"1122","registration_date":null,"region":"ED","ci_status_code":"C","location":"021045","location_desc":"SALISBURY MD","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","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-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1751677","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2025-05-20 21:40:00","snet_input_date":"2025-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-20 21:40:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:03:21.000000Z","updated_at":"2025-05-24T10:03:34.000000Z","inspection_violations":[{"id":13830610,"change_date":"2025-05-20 21:40:00","inspection_id":"84723136","insp_violation_id":"266337088","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":"WARNING","created_at":"2025-05-23T10:28:38.000000Z","updated_at":"2025-05-24T10:19:06.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":14185880,"change_date":"2025-05-20 21:40:00","inspection_id":"84723136","insp_unit_id":"206955366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12","insp_unit_license":"C112167","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT7LED12829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:48:36.000000Z","updated_at":"2025-05-24T09:48:34.000000Z"}]},{"id":8509992,"change_date":"2025-06-17 21:41:00","inspection_id":"84540911","dot_number":"3824273","report_state":"MD","report_number":"2098C00463","insp_date":"2025-04-29 00:00:00","insp_start_time":"1610","insp_end_time":"1631","registration_date":"2025-06-17 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"DELMAR MD","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","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-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","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":"1666368","transaction_code":"C","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:50:58.000000Z","updated_at":"2025-06-22T10:00:14.000000Z","inspection_violations":[{"id":14299391,"change_date":"2025-06-17 21:41:00","inspection_id":"84540911","insp_violation_id":"266889956","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"207426491","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:16:56.000000Z","normalized_code":"3922SLLUCR"},{"id":14299392,"change_date":"2025-06-17 21:41:00","inspection_id":"84540911","insp_violation_id":"266889957","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207426491","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:16:56.000000Z","normalized_code":"39021TB2DOT"},{"id":14299393,"change_date":"2025-06-17 21:41:00","inspection_id":"84540911","insp_violation_id":"266889958","seq_no":"3","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":"WARNING","created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:16:56.000000Z","normalized_code":"3922SLLTCD"},{"id":14299394,"change_date":"2025-06-17 21:41:00","inspection_id":"84540911","insp_violation_id":"266889959","seq_no":"4","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"207426491","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:16:56.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":14609560,"change_date":"2025-06-17 21:41:00","inspection_id":"84540911","insp_unit_id":"207426491","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C133747","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT6PED46086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:01.000000Z","updated_at":"2025-06-22T09:45:19.000000Z"}]},{"id":7245926,"change_date":"2025-01-16 21:40:00","inspection_id":"83211304","dot_number":"3824273","report_state":"PA","report_number":"M407000039","insp_date":"2024-11-19 00:00:00","insp_start_time":"0945","insp_end_time":"1020","registration_date":"2025-01-16 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"BENSALEM PA","county_code_state":"PA","county_code":"017","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1076733","transaction_code":"C","transaction_date":"2024-11-21 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2024-11-21 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-21 21:40:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:15.000000Z","updated_at":"2025-03-17T20:47:15.000000Z","inspection_violations":[{"id":11326982,"change_date":"2025-01-16 21:40:00","inspection_id":"83211304","insp_violation_id":"264026330","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204861376","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:01.000000Z","updated_at":"2025-03-17T22:01:01.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":11687461,"change_date":"2025-01-16 21:40:00","inspection_id":"83211304","insp_unit_id":"204861376","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C112167","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT7LED12829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:08.000000Z","updated_at":"2025-03-17T23:44:08.000000Z"}]},{"id":7011027,"change_date":"2024-10-22 21:41:00","inspection_id":"82962532","dot_number":"3824273","report_state":"MD","report_number":"2098C00143","insp_date":"2024-10-22 00:00:00","insp_start_time":"0928","insp_end_time":"0950","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEWARK MD","county_code_state":"MD","county_code":"047","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"970839","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:16.000000Z","updated_at":"2025-03-17T20:42:16.000000Z","inspection_violations":[{"id":10939727,"change_date":"2024-10-22 21:41:00","inspection_id":"82962532","insp_violation_id":"262476879","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"203517816","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-03-17T21:59:02.000000Z","updated_at":"2025-03-17T21:59:02.000000Z","normalized_code":"39021TB2DOT"},{"id":10939728,"change_date":"2024-10-22 21:41:00","inspection_id":"82962532","insp_violation_id":"262476880","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"203517816","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-03-17T21:59:02.000000Z","updated_at":"2025-03-17T21:59:02.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":10939729,"change_date":"2024-10-22 21:41:00","inspection_id":"82962532","insp_violation_id":"262476881","seq_no":"3","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"203517816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-03-17T21:59:02.000000Z","updated_at":"2025-03-17T21:59:02.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":11308274,"change_date":"2024-10-22 21:41:00","inspection_id":"82962532","insp_unit_id":"203517816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3","insp_unit_license":"C133747","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT6PED46086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:05.000000Z","updated_at":"2025-03-17T23:40:05.000000Z"}]},{"id":6759302,"change_date":"2024-09-18 21:42:00","inspection_id":"82694676","dot_number":"3824273","report_state":"OH","report_number":"1532003836","insp_date":"2024-09-18 00:00:00","insp_start_time":"1103","insp_end_time":"1147","registration_date":null,"region":"ET","ci_status_code":"C","location":"09976","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"2024-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1757106","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:59.000000Z","updated_at":"2025-03-17T20:36:59.000000Z","inspection_violations":[{"id":10525192,"change_date":"2024-09-18 21:42:00","inspection_id":"82694676","insp_violation_id":"261898145","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"203008944","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39021TB"},{"id":10525193,"change_date":"2024-09-18 21:42:00","inspection_id":"82694676","insp_violation_id":"261898146","seq_no":"2","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"3958F1"},{"id":10525194,"change_date":"2024-09-18 21:42:00","inspection_id":"82694676","insp_violation_id":"261898147","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"203008944","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:59.000000Z","updated_at":"2025-03-17T21:56:59.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10899669,"change_date":"2024-09-18 21:42:00","inspection_id":"82694676","insp_unit_id":"203008944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C77761","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT3PED32128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"}]},{"id":6641824,"change_date":"2024-09-04 21:41:00","inspection_id":"82569758","dot_number":"3824273","report_state":"MD","report_number":"2329001926","insp_date":"2024-09-04 00:00:00","insp_start_time":"0728","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"042","location_desc":"CECIL COUNTY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2745116","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2024-09-04 21:41:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-09-04 21:41:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:48.000000Z","updated_at":"2025-03-17T20:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10708416,"change_date":"2024-09-04 21:41:00","inspection_id":"82569758","insp_unit_id":"202746070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C112167","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT7LED12829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:53.000000Z","updated_at":"2025-03-17T23:33:53.000000Z"}]},{"id":4158071,"change_date":"2023-11-27 21:41:00","inspection_id":"79868297","dot_number":"3824273","report_state":"MD","report_number":"2329001449","insp_date":"2023-10-09 00:00:00","insp_start_time":"0656","insp_end_time":"0717","registration_date":"2023-11-27 00:00:00","region":"ET","ci_status_code":"C","location":"042","location_desc":"CECIL COUNTY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2667698","transaction_code":"C","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-09 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:59.000000Z","updated_at":"2025-03-17T19:44:59.000000Z","inspection_violations":[{"id":6435450,"change_date":"2023-11-27 21:41:00","inspection_id":"79868297","insp_violation_id":"256550118","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198201706","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":6685808,"change_date":"2023-11-27 21:41:00","inspection_id":"79868297","insp_unit_id":"198201705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"19","insp_unit_license":"C62201","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDUF4HT8KDA05914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:04.000000Z","updated_at":"2025-03-17T22:56:04.000000Z"},{"id":6685809,"change_date":"2023-11-27 21:41:00","inspection_id":"79868297","insp_unit_id":"198201706","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"EQUI","insp_unit_company":null,"insp_unit_license":"T35400","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1N9BD1314LP253132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:04.000000Z","updated_at":"2025-03-17T22:56:04.000000Z"}]},{"id":2610348,"change_date":"2023-03-20 21:40:00","inspection_id":"78128448","dot_number":"3824273","report_state":"MD","report_number":"3181003965","insp_date":"2023-03-20 00:00:00","insp_start_time":"0636","insp_end_time":"0653","registration_date":null,"region":"ET","ci_status_code":"C","location":"012","location_desc":"I-95 SOUTHBOUND SCALE FACILITY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2618023","transaction_code":"A","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2023-03-20 21:40:00","snet_input_date":"2023-03-20 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-03-20 21:40:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:51.000000Z","updated_at":"2025-03-17T19:14:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4201958,"change_date":"2023-03-20 21:40:00","inspection_id":"78128448","insp_unit_id":"193948556","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"19","insp_unit_license":"C62201","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDUF4HT8KDA05914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:08.000000Z","updated_at":"2025-03-17T22:36:08.000000Z"}]},{"id":2538784,"change_date":"2023-03-09 21:41:00","inspection_id":"78046705","dot_number":"3824273","report_state":"MD","report_number":"3247004483","insp_date":"2023-03-09 00:00:00","insp_start_time":"1026","insp_end_time":"1046","registration_date":null,"region":"ET","ci_status_code":"C","location":"011","location_desc":"I-95 NORTHBOUND SCALE FACILITY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NO BOL#","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"2615947","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2023-03-09 21:41:00","snet_input_date":"2023-03-09 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-03-09 21:41:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:23.000000Z","updated_at":"2025-03-17T19:13:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4086406,"change_date":"2023-03-09 21:41:00","inspection_id":"78046705","insp_unit_id":"193781221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"19","insp_unit_license":"C62201","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDUF4HT8KDA05914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:18.000000Z","updated_at":"2025-03-17T22:35:18.000000Z"}]},{"id":1829269,"change_date":"2022-11-29 21:40:00","inspection_id":"77236737","dot_number":"3824273","report_state":"MD","report_number":"2151005039","insp_date":"2022-11-29 00:00:00","insp_start_time":"0928","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":"001","location_desc":"I-70 W FRIENDSHIP SCALE HOUSE","county_code_state":"MD","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2592145","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2022-11-29 21:40:00","snet_input_date":"2022-11-29 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-11-29 21:40:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:21.000000Z","updated_at":"2025-03-17T19:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2943013,"change_date":"2022-11-29 21:40:00","inspection_id":"77236737","insp_unit_id":"192159933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C112167","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FD0W5HT7LED12829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:08.000000Z","updated_at":"2025-03-17T22:27:08.000000Z"}]},{"id":1270669,"change_date":"2022-09-23 21:37:00","inspection_id":"76592156","dot_number":"3824273","report_state":"MD","report_number":"2099004364","insp_date":"2022-09-13 00:00:00","insp_start_time":"1417","insp_end_time":"1442","registration_date":"2022-09-23 00:00:00","region":"ET","ci_status_code":"C","location":"059","location_desc":"RT 50 @ VIENNA","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2571703","transaction_code":"C","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2022-09-13 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-09-13 21:40:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:07.000000Z","updated_at":"2025-03-17T18:50:07.000000Z","inspection_violations":[{"id":2012068,"change_date":"2022-09-23 21:37:00","inspection_id":"76592156","insp_violation_id":"248603425","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3922"},{"id":2012069,"change_date":"2022-09-23 21:37:00","inspection_id":"76592156","insp_violation_id":"248603426","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39141A"},{"id":2012070,"change_date":"2022-09-23 21:37:00","inspection_id":"76592156","insp_violation_id":"248603427","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191059624","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2044869,"change_date":"2022-09-23 21:37:00","inspection_id":"76592156","insp_unit_id":"191059624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C62201","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDUF4HT8KDA05914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:02.000000Z","updated_at":"2025-03-17T22:21:02.000000Z"}]},{"id":949603,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","dot_number":"3824273","report_state":"MD","report_number":"0286001123","insp_date":"2022-08-02 00:00:00","insp_start_time":"0720","insp_end_time":"0752","registration_date":null,"region":"ET","ci_status_code":"C","location":"057","location_desc":"WICOMICO COUNTY","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"2560088","transaction_code":"A","transaction_date":"2022-08-03 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2022-08-03 21:41:00","snet_input_date":"2022-08-02 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-08-03 21:41:00","insp_carrier_name":"YELLOWFIN ROOFING LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:24.000000Z","updated_at":"2025-03-17T18:44:24.000000Z","inspection_violations":[{"id":1498332,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","insp_violation_id":"247476088","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190101664","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:05.000000Z","updated_at":"2025-03-17T21:14:05.000000Z","normalized_code":"3922"},{"id":1498333,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","insp_violation_id":"247476089","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"190101664","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:05.000000Z","updated_at":"2025-03-17T21:14:05.000000Z","normalized_code":"39343"},{"id":1498334,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","insp_violation_id":"247476090","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190101665","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:05.000000Z","updated_at":"2025-03-17T21:14:05.000000Z","normalized_code":"3939A"},{"id":1498335,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","insp_violation_id":"247476091","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190101665","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6L30AD3","created_at":"2025-03-17T21:14:05.000000Z","updated_at":"2025-03-17T21:14:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1529212,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","insp_unit_id":"190101664","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"C62201","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDUF4HT8KDA05914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"},{"id":1529213,"change_date":"2022-08-03 21:41:00","inspection_id":"76218682","insp_unit_id":"190101665","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"NEWH","insp_unit_company":null,"insp_unit_license":"T41357","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1N9BD1314LP253227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"}]},{"id":752069,"change_date":"2022-07-21 21:40:00","inspection_id":"75987912","dot_number":"3824273","report_state":"PA","report_number":"XL00036636","insp_date":"2022-06-29 00:00:00","insp_start_time":"1320","insp_end_time":"1440","registration_date":"2022-07-21 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"S UNION ST MEASURING 115 FEET","county_code_state":"PA","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELLOWFIN ROOFING, LLC","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":"Y","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2268396","transaction_code":"C","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03824273","upload_search_indicator":null,"census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-06-29 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"YELLOWFIN ROOFING, LLC","insp_carrier_street":"3903 MILL CREEK RD","insp_carrier_city":"HOCKESSIN","insp_carrier_state":"DE","insp_carrier_zip_code":"19707","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:54.000000Z","updated_at":"2025-03-17T18:40:54.000000Z","inspection_violations":[{"id":1185126,"change_date":"2022-07-21 21:40:00","inspection_id":"75987912","insp_violation_id":"247237018","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39141A"},{"id":1185127,"change_date":"2022-07-21 21:40:00","inspection_id":"75987912","insp_violation_id":"247237019","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"189903423","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39021B"},{"id":1185128,"change_date":"2022-07-21 21:40:00","inspection_id":"75987912","insp_violation_id":"247237020","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189903423","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39395A"},{"id":1185129,"change_date":"2022-07-21 21:40:00","inspection_id":"75987912","insp_violation_id":"247237021","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"189903423","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":1209712,"change_date":"2022-07-21 21:40:00","inspection_id":"75987912","insp_unit_id":"189903423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"XF275971","insp_unit_license_state":"DE","insp_unit_vehicle_id_number":"1FDUF4HT8KDA05914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3824273\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3824273\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3824273\/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\/3824273\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}