JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5315' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5315' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR FDEA201008263154Floorbeam · crackedMAIN CARGO DECK FLOOR STRUCTURE FR 54.3 BETWEEN SEAT TRACKS 2R AND 3R HAS 1 EA, .25 " CRACK IN STRUCTURE CROSSBEAM. CUT OUT DAMAGED AREA OF CROSSBEAM IAW SRM 53-10-15, FIG 204. NDT VERIFIED CRACKED AREA. REMOVED IAW NTM 51-10-08. FABBED REPAIR PART AND INSTSDR SWAA105023Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CROSS FLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 52 TO LBL 52. REPAIRED BEAM PER TI.SDR SWAA105020Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 663, LBL 24.8. REPAIRED WEB PER EA.SDR SWAA105014Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED BETWEEN BS 698 TO BS 717. REPAIRED BEAM PER SRM.SDR DALA1020515522Floorbeam · corrodedDURING "M" CHECK FOUND CORROSION ON FLOORBEAM AT BS 1640. REPAIRED IAW SRM 51-40-02 & SRM 53-00-01, FIG 201.SDR DALA1020495522Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM UPPER CHORD BS 345 BL 0 TO LBL 18. REPAIRED IAW SRM 53-00-51 REPAIR NR 5.SDR DALA1024620617Floorbeam · corrodedFLOORBEAM CORRODED STA 680, LBL 3. INSTALLED REPAIR ANGLES IAW ER/A 481634-14.SDR AALA20100922TUL09Floorbeam · corrodedCORROSION ON TOP SURFACE OF THE STATION 947 FLOORBEAM AT LEFT BUTTLINE 52. REMOVED CORROSION AND COMPLETED REPAIR PER SRM 53-70-51-2R 5 AND EA B737-53-012888.SDR USAA2010082791838Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 986, LBL 43. REPLACED FLOORBEAM AT BS 986, LBL 43 IAW TYPICAL REPAIR 53-10-05 REV B.SDR USAA2010082791837Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 986, RBL 43. REPLACED FLOORBEAM AT BS 986, RBL 43 IAW TYPICAL REPAIR 53-10-05 REV B.SDR USAA2010082791836Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 986 BETWEEN RBL 0 TO RBL 13. REPLACED FLOORBEAM AT BS 986 BETWEEN RBL 0 TO RBL 13 IAW TYPICAL REPAIR 53-10-05 REV-B.SDR USAA2010082691808Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK AROUND HOLES AFT END UPPER FLANGE INBOARD SIDE FLOORBEAM AT BS 727B & RBL 45.5. REPAIRED AFT END UPPER FLANGE INBOARD SIDE FLOORBEAM AT BS 727B & RBL 45.5 IAW EA 133037.SDR AALA20100825TUL02Floorbeam · corrodedCORROSION AROUND FASTENER HOLE ON FLOORBEAM 947 LEFT BUTTLINE 27. ACCOMPLISHED FLOORBEAM REPAIR PER SRM 53-00-51-2R-1 AND AARD 53-00-00-7.SDR AALA20100902TUL03Floorbeam · crackedFLOORBEAM AND VERTICAL STIFFENER CRACKED STATION 660 AT LEFT BUTTLINE 48. REPAIRED FLOORBEAM PER AARD 53-30-51-2 AND REPLACED VERTICAL STIFFENERS WITH SERVICEABLE PART PER SRM 51-70-00-0G.SDR AALA20100901TUL01Floorbeam · crackedFLOORBEAM AND VERTICAL STIFFENERS CRACKED AT STATION 700 AND LEFT BUTTLINE 24 AND LEFT BUTTLINE 48. REPAIRED FLOORBEAM PER AARD 53-30-51-2 AND INSTALLED SERVICEABLE STIFFENERS PER SRM 51-10-02-0G.SDR USAA2010082591793Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK AROUND HOLE AT AFT END UPPER FLANGE INBOARD SIDE OF FLOORBEAM AT BS 727B, LBL 45.5. REPAIRED AFT END UPPER FLANGE INBOARD SIDE OF FLOORBEAM AT BS 727B, LBL 45.5 IAW EA 133037.SDR CALA2010082500400Floorbeam · corrodedFLOORBEAM UPPER T-CHORD AT STA 1641 & BL 0 HAS HEAVY CORROSION MARKED. COMPLETED FLOORBEAM UPPER CHORD REPAIR REF SRM 53-00-51 REPAIR 3.SDR DALA1024630617Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT STA 377.7 LBL 47. REPAIRED IAW ER/A 481634-14.SDR UALA2012081304425Floorbeam · corrodedAFT CARGO BAY, BS 1380, RBL 10 TO 13, FLOORBEAM CORRODED. ACCOMPLISHED REPAIR PER EA PD57- 53-047 AND UAL EVA-80014.SDR GTIA1000065Floorbeam · corrodedFLOORBEAM CORROSION AT FR68-FR1292.SDR USAA2010082591792Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK AROUND HOLE AT END UPPER FLANGE INBOARD SIDE FLOORBEAM OF BS 727B & RBL 24.5. END UPPER FLANGE INBOARD SIDE FLOORBEAM OF BS 727B & RBL 24.5. REPAIRED END UPPER FLANGE INBOARD SIDE FLOORBEAM OF BS 727B & RBL 24.5 IAW EA 133037.SDR UALA2010082303097Floorbeam · corrodedAFT CARGO BAY, STA 1380, RBL 10 TO 13, FLOOR STRAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED: REPAIRED IAW EA PD57- 53-047 AND UAL EVA-80014, THE REPAIR IS MAJOR AND HAS RECEIVED APPROVAL FOR STATIC STRENGTH ONLY, A NEW FAA 8100-9 FINDING COMPLIANCE WITH CFR 25.5SDR GTIA1000063Floorbeam · corrodedFLOORBEAM CORROSION AT FR 66 ON - Y765.SDR GTIA1000062Floor Support · corrodedFLOORBEAM CORROSION BETWEEN FR65 AND FR66 ON Y1292.SDR GTIA1000061Floorbeam · corrodedFLOORBEAM CORROSION AT FR68-FR69 AND Y1292.SDR GTIA1000060Floorbeam · corrodedFLOORBEAM CORROSION AT FR68 AND Y765.SDR GTIA1000059Floorbeam · corrodedCORROSION ON FLOORBEAM AT FR 69 AND Y254.SDR GTIA1000058Floorbeam · corrodedFLOORBEAM CORROSION AT END OF SEAT TRACK FR 66 AND Y765.SDR GTIA1000056Floorbeam · corrodedFLOORBEAM CORROSION AFT END OF SEAT TRACK AT FR66 AND Y1292.SDR GTIA1000055Floorbeam · corrodedFLOORBEAM CORROSION AT FR68 BETWEEN Y765 AND Y25.SDR USAA2010091692012Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 343, BL 0. REPLACED FLOORBEAM T-CAP AT BS 343, BL 0 IAW SRM 53-10-51 & EA 97917A.SDR USAA2010082791843Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 343, BL 0. REPLACED FLOORBEAM T-CAP AT BS 343, BL 0 IAW SRM 53-10-51.SDR USAA2010082791835Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP BETWEEN BS 311 TO BS 312 & BETWEEN RBL 10 TO RBL 12. REPAIRED FLOORBEAM T-CAP BETWEEN BS 311 TO BS 312 & BETWEEN RBL 10 TO RBL 12 IAW B737 SRM 53-10-51.SDR FDEA201008213088Floorbeam · corrodedSTA 365.25 FLOORBEAM HAS CORROSION ON TOP OF BEAM AND UNDERNEATH TOP OF BEAM AT SEVERAL LOCATIONS RT OF BL 0. REMOVED CORROSION IAW SRM 51-10-02. OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL 3. REMOVED DAMAGED FROM LBL 13-RBL 68.6. FABRICATED REPAIR PARTSDR 2010FA0000876Floorbeam · corrodedCORROSION ON BULK CARGO COMPARTMENT FLOOR SUPPORT CROSS SECTION FR 59, BL 0 TO RBL 28. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. REPLACED CROSS SECTION WITH NEW PART.SDR 2010FA0000875Floorbeam · corrodedCORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT PROFILE FR 59, BL 0 TO LBL 28. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. REPLACED PROFILE WITH NEW PART.SDR 2010FA0000870Floorbeam · corrodedCORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT CROSS SECTION FR 58, LBL 28 TO RBL 28. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. REPLACED CROSS SECTION WITH NEW PART.SDR 2010FA0000863Floorbeam · corrodedCORROSION ON AFT CARGO COMPARTMENT PROFILE RBL 28, FR 56 TO FR 58. NO CORROSION REMOVAL LIMITS FOUND IN SRM. REPLACED PROFILE WITH NEW PART.SDR 2010FA0000862Floorbeam · corrodedCORROSION ON AFT CARGO COMPARTMENT PROFILE RBL 28, FR 48 TO FR 53. NO CORROSION REMOVAL LIMITS FOUND IN SRM. REPLACED PROFILE WITH NEW PART.SDR 2010FA0000861Floorbeam · corrodedCORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT CROSS SECTION AT FR 50 LBL 28 TO RBL 28. NO CORROSION REMOVAL LIMITS FOUND IN SRM. REPLACED CROSS SECTION WITH NEW PART.SDR 2010FA0000860Floorbeam · corrodedCORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT PROFILE FR 59, LBL 28 TO RBL 14. NO CORROSION REMOVAL LIMITS FOUND IN SRM. REPLACED PROFILE WITH NEW PART.SDR FDEA201008203061Floorbeam · corrodedCORROSION MAIN CABIN FLOORBEAM TOP TEE CAP BS. 380 RBL 45 TO RBL 61 CUTOUT AREA DAMAGE, DIM: 2 1/2" X 1" IAW SRM 53-10-8. FABRICATED TWO REPAIR ANGLES FROM 7075TO HEAT TREATED TO T6 CONDITION IAW FAS ENGINEERING REPORT 2-37153-801 REV A DIM: 5 1/2" X 2 5/8"SDR DALA1019935525Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM STRUCTURE AT BS 365 BL0. REPAIRED IAW SRM 53-00-51, FIG 101.SDR SWIA201024957Floorbeam · corrodedFS 280 FLOORBEAM IS CRACKED AND EXFOLIATED. (C-CHECK) REPAIRED PER SRM.SDR UHLA2010081900118Floorbeam · corrodedMAJOR REPAIR - LT CENTER FLOORBEAM CORRODED AT FRS 17-19. REMOVED DAMAGED AREAS, FABRICATED FILLER AND DOUBLER, NDT CUTOUT AND INSTALLED IAW ETD 2010-170/07407.SDR UHLA2010081900089Floorbeam · corrodedLEVEL 2 CORROSION RT CENTER FLOORBEAM AT FR 14, 16, 17. REMOVED AND REPLACED RT CENTER SEAT TRACK BEAM IAW EMB 170 SRM 51-40-02, 51-41-01, 51-43-01, 51-41-02, 51-43-03 AND 51-43-04.SDR UHLA2010081900086Floorbeam · corrodedMAJOR REPAIR - LEVEL 2 CORROSION LT CENTER FLOORBEAM AT FR 17-19. REMOVED DAMAGED AREA, FABRICATED FILLER AND DOUBLER, NDT CUTOUT, AND INSTALLED IAW EMB ETD 2010-170/07407.SDR COMA2010081950178Floorbeam · corrodedCORROSION FOUND AROUND 4 EACH NUT PLATES FS 589 - 618 LBL 27. REMOVED AND REPLACED FLOORBEAM UPPER CAP IAW CRJ SRM 51-42-21.SDR ASOA201001240Floorbeam · corrodedFLOORBEAM HAS MINOR CORROSION AROUND NUTPLATE ON ON INBD ROW OF CARGO FLOOR PANEL 281LLF. DRILLED NEW FLOORBEAM IAW SRM 51-42-21 & 51-42-06. INSTALLED FLOORBEAM CAP REF SRM 51-42-22.SDR EE4Y10351Floorbeam · corrodedDURING INSP, LOWER FUSELAGE AFT CARGO COMPARTMENT STA 1130 FLOORBEAM UPPER CHORD CORRODED.
Back to JASC 5315