{"current_page":1,"data":[{"id":11906141,"change_date":"2026-05-14 21:42:00","inspection_id":"87845181","dot_number":"3245834","report_state":"LA","report_number":"LAQAS02314","insp_date":"2026-05-13 00:00:00","insp_start_time":"0906","insp_end_time":"0931","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"DES ALLEMANDS LA","county_code_state":"LA","county_code":null,"insp_level_id":"1","service_center":"SH","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-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"59000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3320907","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:50.000000Z","updated_at":"2026-05-25T09:30:59.000000Z","inspection_violations":[{"id":20710932,"change_date":"2026-05-14 21:42:00","inspection_id":"87845181","insp_violation_id":"274251266","seq_no":"1","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213546698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:50.000000Z","updated_at":"2026-05-25T09:42:47.000000Z","normalized_code":"39353BB"},{"id":20710933,"change_date":"2026-05-14 21:42:00","inspection_id":"87845181","insp_violation_id":"274251267","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213546698","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:12:50.000000Z","updated_at":"2026-05-25T09:42:47.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":20698785,"change_date":"2026-05-14 21:42:00","inspection_id":"87845181","insp_unit_id":"213546698","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"5","insp_unit_license":"Z577854","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X0JJ181033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:44.000000Z","updated_at":"2026-05-25T09:03:22.000000Z"}]},{"id":9436669,"change_date":"2025-08-18 21:39:00","inspection_id":"85518104","dot_number":"3245834","report_state":"LA","report_number":"LAQAS01905","insp_date":"2025-08-14 00:00:00","insp_start_time":"0817","insp_end_time":"0855","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HOUMA LA","county_code_state":"LA","county_code":null,"insp_level_id":"1","service_center":"SH","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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"2144856","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":null,"census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:45.000000Z","updated_at":"2025-08-23T10:45:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15558746,"change_date":"2025-08-18 21:39:00","inspection_id":"85518104","insp_unit_id":"208444236","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"4","insp_unit_license":"Z537339","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3BKZLP0X5PF231675","insp_unit_decal":"Y","insp_unit_decal_number":"35481024","created_at":"2025-08-21T09:45:38.000000Z","updated_at":"2025-08-22T09:45:43.000000Z"}]},{"id":8848414,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","dot_number":"3245834","report_state":"LA","report_number":"LARVS00220","insp_date":"2025-06-04 00:00:00","insp_start_time":"0911","insp_end_time":"0958","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VACHERIE LA","county_code_state":"LA","county_code":null,"insp_level_id":"1","service_center":"SH","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-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"6","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":"1842199","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":null,"census_search_date":"2025-06-09 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-09 21:41:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:27.000000Z","updated_at":"2025-06-14T10:00:27.000000Z","inspection_violations":[{"id":14172572,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_violation_id":"266733155","seq_no":"6","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"207286033","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:44.000000Z","updated_at":"2025-06-13T10:17:13.000000Z","normalized_code":"3939ALBL"},{"id":14172573,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_violation_id":"266733156","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207286033","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:44.000000Z","updated_at":"2025-06-13T10:17:13.000000Z","normalized_code":"39347E"},{"id":14172574,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_violation_id":"266733157","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207286033","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:44.000000Z","updated_at":"2025-06-13T10:17:13.000000Z","normalized_code":"3939ALIL"},{"id":14172575,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_violation_id":"266733158","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207286033","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:44.000000Z","updated_at":"2025-06-13T10:17:13.000000Z","normalized_code":"39353BB"},{"id":14172576,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_violation_id":"266733159","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"207286033","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:44.000000Z","updated_at":"2025-06-13T10:17:13.000000Z","normalized_code":"3939ALCL"},{"id":14172577,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_violation_id":"266733160","seq_no":"5","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"207286033","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-12T10:15:44.000000Z","updated_at":"2025-06-13T10:17:13.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":14489523,"change_date":"2025-06-09 21:41:00","inspection_id":"84897981","insp_unit_id":"207286033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"2","insp_unit_license":"C979518","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL70X3GJ123377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:30.000000Z","updated_at":"2025-06-13T09:45:30.000000Z"}]},{"id":8447871,"change_date":"2025-04-23 21:41:00","inspection_id":"84475345","dot_number":"3245834","report_state":"LA","report_number":"LAPTS00045","insp_date":"2025-04-22 00:00:00","insp_start_time":"1128","insp_end_time":"1225","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LULING LA","county_code_state":"LA","county_code":null,"insp_level_id":"1","service_center":"SH","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-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77740","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":"1634067","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:22.000000Z","updated_at":"2025-04-27T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13721702,"change_date":"2025-04-23 21:41:00","inspection_id":"84475345","insp_unit_id":"206450167","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"4","insp_unit_license":"Z537339","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3BKZLP0X5PF231675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:11:03.000000Z","updated_at":"2025-04-27T09:57:52.000000Z"}]},{"id":8295414,"change_date":"2025-04-09 21:40:00","inspection_id":"84314674","dot_number":"3245834","report_state":"LA","report_number":"LASCS00040","insp_date":"2025-04-04 00:00:00","insp_start_time":"1323","insp_end_time":"1350","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"DONALDSONVILLE LA","county_code_state":"LA","county_code":"007","insp_level_id":"1","service_center":"SH","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-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","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":"1555360","transaction_code":"C","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":null,"census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:01.000000Z","updated_at":"2025-04-14T10:22:06.000000Z","inspection_violations":[{"id":13101765,"change_date":"2025-04-09 21:40:00","inspection_id":"84314674","insp_violation_id":"265507628","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206211971","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-11T10:44:31.000000Z","updated_at":"2025-04-12T10:33:05.000000Z","normalized_code":"39375A3TAOL"},{"id":13101766,"change_date":"2025-04-09 21:40:00","inspection_id":"84314674","insp_violation_id":"265507629","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"206211971","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:44:31.000000Z","updated_at":"2025-04-12T10:33:05.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":13501183,"change_date":"2025-04-09 21:40:00","inspection_id":"84314674","insp_unit_id":"206211971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"103","insp_unit_license":"C786405","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X3LJ426572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-12T10:02:21.000000Z","updated_at":"2025-04-13T09:49:45.000000Z"}]},{"id":6596139,"change_date":"2024-08-29 21:42:00","inspection_id":"82521225","dot_number":"3245834","report_state":"LA","report_number":"LARI000992","insp_date":"2024-08-28 00:00:00","insp_start_time":"1005","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"089","insp_level_id":"2","service_center":"SH","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":null,"final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1217611","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:42.000000Z","updated_at":"2025-03-17T20:33:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10634077,"change_date":"2024-08-29 21:42:00","inspection_id":"82521225","insp_unit_id":"202653599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"Z577854","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X0JJ181033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":6782557,"change_date":"2024-09-20 21:43:00","inspection_id":"82719847","dot_number":"3245834","report_state":"TX","report_number":"6XR99DLG2C","insp_date":"2024-08-13 00:00:00","insp_start_time":"0950","insp_end_time":"1044","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN BRAZORIA CO. (486-5","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YELLOW FIN","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":null,"final_status_date":"2024-09-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"9382343","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2024-09-20 21:43:00","snet_input_date":"2024-08-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1079396","created_at":"2025-03-17T20:37:42.000000Z","updated_at":"2025-03-17T20:37:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10937456,"change_date":"2024-09-20 21:43:00","inspection_id":"82719847","insp_unit_id":"203057481","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"Z537339","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3BKZLP0X5PF231675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":5948808,"change_date":"2024-06-10 21:43:00","inspection_id":"81826875","dot_number":"3245834","report_state":"LA","report_number":"LAQA001201","insp_date":"2024-06-07 00:00:00","insp_start_time":"1340","insp_end_time":"1352","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"2","service_center":"SH","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":"2024-06-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1205736","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2024-06-10 21:43:00","snet_input_date":"2024-06-10 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-06-10 21:43:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:40.000000Z","updated_at":"2025-03-17T20:20:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9581737,"change_date":"2024-06-10 21:43:00","inspection_id":"81826875","insp_unit_id":"201307571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"103","insp_unit_license":"C786405","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X3LJ426572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:22.000000Z","updated_at":"2025-03-17T23:22:22.000000Z"}]},{"id":5663270,"change_date":"2024-05-03 21:38:00","inspection_id":"81516867","dot_number":"3245834","report_state":"LA","report_number":"LALL007899","insp_date":"2024-05-02 00:00:00","insp_start_time":"0919","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"3","service_center":"SH","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":"2024-05-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1201775","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2024-05-03 21:38:00","snet_input_date":"2024-05-03 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-05-03 21:38:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:03.000000Z","updated_at":"2025-03-17T20:15:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9121313,"change_date":"2024-05-03 21:38:00","inspection_id":"81516867","insp_unit_id":"200715049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"Z537339","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3BKZLP0X5PF231675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:53.000000Z","updated_at":"2025-03-17T23:17:53.000000Z"}]},{"id":5389489,"change_date":"2024-03-28 21:41:00","inspection_id":"81217999","dot_number":"3245834","report_state":"LA","report_number":"LAIH000466","insp_date":"2024-03-27 00:00:00","insp_start_time":"1415","insp_end_time":"1426","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"2","service_center":"SH","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":"2024-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1198087","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2024-03-28 21:41:00","snet_input_date":"2024-03-28 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-03-28 21:41:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:27.000000Z","updated_at":"2025-03-17T20:09:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8679955,"change_date":"2024-03-28 21:41:00","inspection_id":"81217999","insp_unit_id":"200134892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"N\/A","insp_unit_license":"Z537339","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"3BKZLP0X5PF231675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:42.000000Z","updated_at":"2025-03-17T23:13:42.000000Z"}]},{"id":4080423,"change_date":"2023-09-28 21:40:00","inspection_id":"79782291","dot_number":"3245834","report_state":"LA","report_number":"LANI002405","insp_date":"2023-09-25 00:00:00","insp_start_time":"0637","insp_end_time":"0648","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"1181887","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2023-09-28 21:40:00","snet_input_date":"2023-09-28 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-09-28 21:40:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:35.000000Z","updated_at":"2025-03-17T19:43:35.000000Z","inspection_violations":[{"id":6316199,"change_date":"2023-09-28 21:40:00","inspection_id":"79782291","insp_violation_id":"255543712","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197291913","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:27.000000Z","updated_at":"2025-03-17T21:36:27.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6560226,"change_date":"2023-09-28 21:40:00","inspection_id":"79782291","insp_unit_id":"197291913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"C979518","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL70X3GJ123377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:04.000000Z","updated_at":"2025-03-17T22:55:04.000000Z"}]},{"id":3831345,"change_date":"2023-08-25 21:41:00","inspection_id":"79504972","dot_number":"3245834","report_state":"LA","report_number":"LAIB004455","insp_date":"2023-08-11 00:00:00","insp_start_time":"0835","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"1","service_center":"SH","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":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1177255","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":null,"census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-22 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:32.000000Z","updated_at":"2025-03-17T19:38:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6159921,"change_date":"2023-08-25 21:41:00","inspection_id":"79504972","insp_unit_id":"196728908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"C786405","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X3LJ426572","insp_unit_decal":"Y","insp_unit_decal_number":"33067286","created_at":"2025-03-17T22:51:44.000000Z","updated_at":"2025-03-17T22:51:44.000000Z"}]},{"id":3160942,"change_date":"2023-06-06 21:44:00","inspection_id":"78752001","dot_number":"3245834","report_state":"LA","report_number":"LANI002259","insp_date":"2023-05-26 00:00:00","insp_start_time":"1155","insp_end_time":"1206","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"3","service_center":"SH","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":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1169781","transaction_code":"C","transaction_date":"2023-06-06 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2023-05-30 21:41:00","snet_input_date":"2023-05-30 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-05-30 21:41:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:41.000000Z","updated_at":"2025-03-17T19:25:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5083626,"change_date":"2023-06-06 21:44:00","inspection_id":"78752001","insp_unit_id":"195340231","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"C786405","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X3LJ426572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:03.000000Z","updated_at":"2025-03-17T22:43:03.000000Z"}]},{"id":3149978,"change_date":"2023-05-26 21:39:00","inspection_id":"78739612","dot_number":"3245834","report_state":"LA","report_number":"LAQA000309","insp_date":"2023-05-25 00:00:00","insp_start_time":"1720","insp_end_time":"1739","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1169592","transaction_code":"A","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2023-05-26 21:39:00","snet_input_date":"2023-05-26 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-05-26 21:39:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:21.000000Z","updated_at":"2025-03-17T19:25:21.000000Z","inspection_violations":[{"id":4850704,"change_date":"2023-05-26 21:39:00","inspection_id":"78739612","insp_violation_id":"253102686","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:34.000000Z","updated_at":"2025-03-17T21:29:34.000000Z","normalized_code":"38351A"},{"id":4850705,"change_date":"2023-05-26 21:39:00","inspection_id":"78739612","insp_violation_id":"253102687","seq_no":"2","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:34.000000Z","updated_at":"2025-03-17T21:29:34.000000Z","normalized_code":"3903E"},{"id":4850706,"change_date":"2023-05-26 21:39:00","inspection_id":"78739612","insp_violation_id":"253102688","seq_no":"3","part_no":"391","part_no_section":"45(b)","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:29:34.000000Z","updated_at":"2025-03-17T21:29:34.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":5065783,"change_date":"2023-05-26 21:39:00","inspection_id":"78739612","insp_unit_id":"195161707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"C528656","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKDLU0X26J136080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:56.000000Z","updated_at":"2025-03-17T22:42:56.000000Z"}]},{"id":2974642,"change_date":"2023-05-11 21:41:00","inspection_id":"78542059","dot_number":"3245834","report_state":"LA","report_number":"LAQA000222","insp_date":"2023-05-04 00:00:00","insp_start_time":"0830","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1167599","transaction_code":"C","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2023-05-05 21:42:00","snet_input_date":"2023-05-05 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-05-05 21:42:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:53.000000Z","updated_at":"2025-03-17T19:21:53.000000Z","inspection_violations":[{"id":4565872,"change_date":"2023-05-11 21:41:00","inspection_id":"78542059","insp_violation_id":"252767794","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194873585","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"3939A"},{"id":4565873,"change_date":"2023-05-11 21:41:00","inspection_id":"78542059","insp_violation_id":"252767795","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194873585","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"39375A3"},{"id":4565874,"change_date":"2023-05-11 21:41:00","inspection_id":"78542059","insp_violation_id":"252767796","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194873585","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4785636,"change_date":"2023-05-11 21:41:00","inspection_id":"78542059","insp_unit_id":"194873585","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"C528656","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKDLU0X26J136080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:44.000000Z","updated_at":"2025-03-17T22:40:44.000000Z"}]},{"id":980194,"change_date":"2022-08-08 21:39:00","inspection_id":"76254454","dot_number":"3245834","report_state":"LA","report_number":"LANI001923","insp_date":"2022-08-05 00:00:00","insp_start_time":"1028","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"093","insp_level_id":"2","service_center":"SH","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-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"67000","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":"1139566","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2022-08-08 21:39:00","snet_input_date":"2022-08-08 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-08-08 21:39:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:03.000000Z","updated_at":"2025-03-17T18:45:03.000000Z","inspection_violations":[{"id":1546022,"change_date":"2022-08-08 21:39:00","inspection_id":"76254454","insp_violation_id":"247561964","seq_no":"1","part_no":"393","part_no_section":"86(b)(1)","insp_viol_unit":"1","insp_unit_id":"190174008","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39386B1"}],"inspection_per_units":[{"id":1577196,"change_date":"2022-08-08 21:39:00","inspection_id":"76254454","insp_unit_id":"190174008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"C979518","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL70X3GJ123377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:56.000000Z","updated_at":"2025-03-17T22:17:56.000000Z"}]},{"id":693886,"change_date":"2022-06-27 21:40:00","inspection_id":"75919284","dot_number":"3245834","report_state":"LA","report_number":"LANI001891","insp_date":"2022-06-23 00:00:00","insp_start_time":"0709","insp_end_time":"0721","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"093","insp_level_id":"3","service_center":"SH","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":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135971","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-27 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:51.000000Z","updated_at":"2025-03-17T18:39:51.000000Z","inspection_violations":[{"id":1091054,"change_date":"2022-06-27 21:40:00","inspection_id":"75919284","insp_violation_id":"246721546","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1114378,"change_date":"2022-06-27 21:40:00","inspection_id":"75919284","insp_unit_id":"189462996","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"C786405","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X3LJ426572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:03.000000Z","updated_at":"2025-03-17T22:15:03.000000Z"}]},{"id":625319,"change_date":"2022-06-21 21:41:00","inspection_id":"75838338","dot_number":"3245834","report_state":"LA","report_number":"LAOL000719","insp_date":"2022-06-09 00:00:00","insp_start_time":"0944","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"051","insp_level_id":"2","service_center":"SH","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":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"1134862","transaction_code":"C","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2022-06-21 21:41:00","snet_input_date":"2022-06-16 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-06-16 21:42:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:47.000000Z","updated_at":"2025-03-17T18:38:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1004920,"change_date":"2022-06-21 21:41:00","inspection_id":"75838338","insp_unit_id":"189370765","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"C979518","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL70X3GJ123377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:22.000000Z","updated_at":"2025-03-17T22:14:22.000000Z"}]},{"id":232991,"change_date":"2022-05-04 21:41:00","inspection_id":"75370777","dot_number":"3245834","report_state":"LA","report_number":"LALZ004318","insp_date":"2022-04-19 00:00:00","insp_start_time":"0800","insp_end_time":"0831","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"089","insp_level_id":"1","service_center":"SH","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":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1128718","transaction_code":"C","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03245834","upload_search_indicator":"M","census_search_date":"2022-04-22 21:42:00","snet_input_date":"2022-04-22 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-04-22 21:42:00","insp_carrier_name":"YELLOWFIN WASTE AND ENVIRONMENTAL LLC","insp_carrier_street":"403 SAINT MARY ST","insp_carrier_city":"THIBODAUX","insp_carrier_state":"LA","insp_carrier_zip_code":"70301-2641","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:35.000000Z","updated_at":"2025-03-17T18:31:35.000000Z","inspection_violations":[{"id":358250,"change_date":"2022-05-04 21:41:00","inspection_id":"75370777","insp_violation_id":"245567043","seq_no":"1","part_no":"393","part_no_section":"134","insp_viol_unit":"1","insp_unit_id":"188498059","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"393134"}],"inspection_per_units":[{"id":377528,"change_date":"2022-05-04 21:41:00","inspection_id":"75370777","insp_unit_id":"188498059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"C786405","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1NKZL40X3LJ426572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:32.000000Z","updated_at":"2025-03-17T22:10:32.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3245834\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3245834\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3245834\/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\/3245834\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}