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 USAA2009073091956Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 328, RBL 33. REPAIRED FLOORBEAM T-CAP AT BS 328, RBL 33 IAW B737 SRM 53-10-51.SDR CALA2009072900401Floorbeam · corrodedFLOORBEAM AT STA 986.5 BETWEEN BL 0 AND LBL 46 HAS CORROSION AT FASTENER HOLES (6 EACH). SPLICED IN NEW UPPER T-CHORD OF FLOORBEAM FROM LBL 3 TO LBL 50 AND MODIFIED INTERCOSTAL AT LBL 32 PER ECRA 5311-01460.SDR USAA2009091192482Floorbeam · corrodedSAL - Q6 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON TRANSVERSE BEAM UPPER FLANGE AT BS 947.5 BETWEEN LBL 40.75 TO RBL 39.75. REPAIRED TRANSVERSE BEAM UPPER FLANGE AT BS 947.5 BETWEEN LBL 40.75 TO RBL 39.75 IAW US AIRWAYS EA 132573.SDR ASAA0976265Floorbeam · corrodedCORROSION ON FLOORBEAM STA 986.5, CORROSION ON UPPER SURFACE OF TOP CHORD RBL 43. REPAIRED UPPER FLOORBEAM TOP CHORD AT BS 986.5.SDR FDEA200907272770Floorbeam · corrodedBS 1661 RBL 55 TOP OF FLOORBEAM FOUND CORRODED. EVALUATE AND REPAIR. REPAIRED FLOORBEAM AT BS 1661 RBL 55 IAW PTF STA ENGRG EA NR 757- 5361-08-E0277 REV. -, CORROSION ON FLOORBEAM UPPER CHORD AT STA 1661 RBL 58.22 AFFECTING INSTALLATION OF STIFFENER AND SHSDR USAA2009082692257Floorbeam · corrodedSAL - Q6 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 328 BETWEEN BL-0 TO RBL 37. REPAIRED FLOORBEAM AT BS 328 BETWEEN BL-0 TO RBL 37 IAW B737 SRM 51-40-02.SDR A6WA200940455Crossbeam · crackedLOWER RADIUS OF CROSSBEAM AT FS 280.00, LBL 9.00, WL 72.00 IS CRACKED. REPAIR CARRIED OUT IAW REO 601R-53-11-171. (K)SDR SWAA094808Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 740A, BETWEEN LBL 43 TO LBL 45.5. REMOVED AND REPLACED BEAM PER EA.SDR SWAA094797Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 662, RBL 24.5. REPAIRED WEB PER ER.SDR SWAA094796Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 745A, LBL 45.5. REPAIRED BEAM PER ER.SDR USAA2009091192481Floorbeam · corrodedSAL - Q6 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON TRANSVERSE BEAM LOWER SIDE UPPER FLANGE AT BS 986 BETWEEN LBL 34 TO RBL 21. REPAIRED TRANSVERSE BEAM LOWER SIDE UPPER FLANGE AT BS 986 BETWEEN LBL 34 TO RBL 21 IAW US AIRWAYS EA 132589.SDR LR7A2009080400091Floorbeam · corrodedDURING SCHEDULED C-8 CHECK IAW JOB CARD HST5325, FOUND UNDERDECK FLOORBEAM WITH STRESS CORROSION AT FS245E, LBL45. REPAIRED IAW SMP583 CHAPTER 51-60 AND 51-70.SDR AALA20090727AFW01Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 325 RIGHT BUTTLINE 36. REMOVED CORROSION AND INSTALLED PART REINFORCEMENT REPAIR STRAP UNDER ENGINEERING AUTHORIZATION 767-006777 AND SRM 51.SDR AALA20090727AFW02Floorbeam · corrodedCORROSION AT STATION 347 FLOORBEAM. REPAIRED STRAP BETWEEN RIGHT BUTTLINE 29 AND RIGHT BUTTLINE 58 UNDER EA 006778. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR IPXA09M57076Floorbeam · dentedINSPECTION TYPE:1C TRANSFERRED FROM LP 061825 ITEM 2 REF D402822 - MAIN DECK FLOORBEAM LOWER FLANGE DENTED AT STA 979. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND REPAIR ANGLES IAW UPS EO MD11-5310-33894-B AND SAA EA 011-5310-01-A1941.SDR IPXA09M57075Floorbeam · dentedINSPECTION TYPE:1C TRANSFERRED FROM LP 061825 ITEM 1 REFD402821- MAIN DECK FLOORBEAM LOWER FLANGE DENTED AT STA 939 REF EOMD11-5310-33894-A. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND REPAIR ANGLES IAW UPS EO MD11-5310-33894-B AND SAA EA 011-5SDR USAA2009080492010Floorbeam · corrodedMCN - C22 - MAJOR REPAIR - CORROSION ON EXISTING REPAIR ON UPPER SURFACE OF FLOORBEAM AT BS 967, WL 208.1, LBL 42. REMOVED EXISTING REPAIR AND INSTALLED NEW REPAIR IAW B737 SRM 53-00-51-2R2.SDR USAA2009072491909Floorbeam · corrodedBFM - C2 - MAJOR REPAIR - CORROSION ON PREVIOUS REPAIR OF FLOORBEAM FRAME CAP AT BS 350, BL 0. REMOVED PREVIOUS REPAIR, FABRICATED AND INSTALLED NEW FLOORBEAM IAW B757 SRM 53-00-51, 51-40-02, & US AIRWAYS TYPICAL REPAIR 53-15-01.SDR SWAA094702Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707.5 TO BS 708.5, LBL 24.5. REPAIRED BEAM PER ER.SDR SWAA094686Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 663, LBL 24.5. REPAIRED BEAM PER SRM.SDR FDEA200907222696Floorbeam · corrodedSTA 1320, RBL 24.75, WL 207.1, FLOORBEAM TOP FLANGE FOUND CORRODED. REPAIR CARRIED OUT IAW SRM 53-00-51, FIG 201. REV 96 AND EA F-5310-129614. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA200907212689Floorbeam · noneMCD FLOORBEAM T-CHORD EXISTING REPAIR AT STA 324 FROM RBL 42, RBL 58, COMPLY WITH ATTACHMENT "B" OF EO F-5100-7-5001, P1. COMPLIED WITH ATTACHMENT "B" OF EO NR F-5100-7-5001, PT1. PREVIOUSLY INSTALLED REPAIR ON MCD FLOORBEAM T-CHORD AT STA 324, RBL42-RBL58, SDR USAA2009080492011Floorbeam · corrodedMCN - C22 - MAJOR REPAIR - CORROSION ON EXISTING REPAIR LOWER SURFACE OF TRANSVERSE FLOORBEAM AT BS 986.5, WL 204.1, LBL 43. REMOVED EXISTING REPAIR AND INSTALLED NEW TEE ANGLE REPAIR IAW B737 SRM 53-00-51-00-2R2.SDR ASOA200900815Floorbeam · corruptedCARGO BAY FLOORBEAM AT LBL 27 IS CORRODED AROUND FLOORBOARD ATTACH FLANGES FROM FS 574 TO FS 621. REMOVED FLOORBEAM CAP IAW SRM 51-42-06, 51-42-21. INSTALLED NUT PLATES IAW SRM 51-40-11 AND 51-42-06. INSTALLED FLOORBEAM CAP PER SRM 51-42-21 AND 51-42-34. SDR ASOA200900814Attach Fitting · crackedFS 280 FLOORBEAM ATTACHMENT CLIP IS CRACKED AT OUTBOARD SIDE OF RBL 9. REMOVED CRACKED CLIP IAW SRM 51-42-21. FABRICATED NEW CLIP FROM 2024-T42 .050 (S6144-13) IAW PREVIOUS REPAIR 601R-53-11-926 REV A AND INSTALLED IAW SRM 51-42-21.SDR UALA2009072102157Floorbeam · crackedFLOOR BEAM AT STA 246, MID-CHORD CRACKED AT LBL 17 INBOARD OF CABLE RUN AGE2B, BEST VIEWED FROM AFT SIDE. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED CHORD AND FABRICATED A NEW MID CHORD SECTION AND REPAIR ANGLES AND INSTALLED.SDR FDEA200907212687Floorbeam · corrodedFWD CABIN FLOORBEAM UPPER SURFACE AT BS 377, LBL 61, HAS SURFACE CORROSION. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS PER SRM 53-00-51, DETAIL 3, FIG. 101. CUT OUT DAMAGED AREA AND REMOVED PREVIOUS REPAIR OF UPPER TEE CHORD, BS 377, LBL 70SDR AALA20090721TUL21Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR AALA20090721TUL20Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR AALA20090721TUL19Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED STRAP AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR AALA20090721TUL17Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED CORROSION AND INSTALLED REPAIR PER SRM 53-00-51-2R AND AARD 53-00-00.SDR AALA20090721TUL16Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED CORROSION AND INSTALLED REPAIR PER SRM 53-00-51-2R.SDR DU4R2009388Floorbeam · gougedGOUGE IN FLOORBEAM BETWEEN BS 639 AND BS 663.75 BL 25R.SDR USAA2009081092071Floorbeam · corrodedMAJOR REPAIR - NR 6148584 - LEVEL 2 GALVANIC CORROSION ON CABIN FLOOR BEAM BETWEEN FR67 + 17 TO FR69 + 5, Y1165. REPLACED CABIN FLOOR BEAM BETWEEN FR67 + 17 TO FR69 + 5, Y1165 IAW SRM 51-72-11.SDR USAA2009081092070Floorbeam · corrodedMAJOR REPAIR - NR 6148585 - LEVEL 2 FILIFORM CORROSION ON CABIN FLOOR BEAM BETWEEN FR66 + 5 TO FR67 + 17, Y1195. REPLACED CABIN FLOOR BEAM BETWEEN FR66 + 5 TO FR67 + 17, Y1195 IAW A320 SRM 51-72-11.SDR USAA2009080492014Floorbeam · corrodedSAL - S-02 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 +5 INCHES TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 +5 INCHES TO FR70, -Y765 IAW A320 SRM 51-72-11.SDR USAA2009080492013Floorbeam · corrodedSAL - S-02 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66 + 5 INCHES, -Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR66 + 5 INCHES, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2009073091953Floorbeam · corrodedSAL - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR67 +17 TO FR69 +5, Y1165. REPLACED FLOORBEAM AT FR67 +17 TO FR69 +5, Y1165 IAW A320 SRM 51-72-11.SDR USAA2009072791926Floorbeam · corrodedCLT - Q-2 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM T-CAP AT BS 312, RBL 36 & RBL 8. REPLACED FLOORBEAM T-CAP AT BS 312, RBL 38 & LBL 20 IAW B737 SRM 53-10-51.SDR CALA2009072000375Floorbeam · corrodedFLOOR FRAME STA 986-5, BL 0 TO RBL 30 HAS CORROSION AT SEVERAL FASTENER HOLES 6 EACH. FABRICATED AND INSTALLED REPAIRED PARTS PER SRM 53-00-51, REPAIR-1.SDR USAA2009073191972Floorbeam · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 344, LBL 10. REPAIRED FLOORBEAM T-CAP AT BS 344, LBL 10 IAW B737 SRM 53-10-51.SDR QXEA2009072000542Floorbeam · corrodedBS 280 FLOORBEAM IS CORRODED ON TOP OF AFT FLANGE FROM APPROX RBL 12 TO LBL 28. CORROSION FOUND TO BE OUT OF LIMITS. FABRICATED AFT AND FWD DOUBLER AS PER REO 670-53-11-047. REMOVED FLOORBEAM AND INTERCOSTAL. CLEANED PRIMED AND PAINTED LOWER WEB NO CORSDR UALA2009072002123Floorbeam · damagedMAIN CABIN FLOORBEAM STA 246 WEB CRACKED AT LBL 11.5. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF WEB. FABRICATED FILLER AND 2 EA DOUBLERS AND INSTALLED.SDR IPXA09656835Stiffener · crackedINSPECTION TYPE:C MAIN EQUIPMENT CENTER STA 246 FLOORBEAM STIFFENER FOUND CRACK AT LBL 40, CRACK LENGTH 1.25 INCH. MAIN EQUIPMENT CTR STA 246 LBL 40 FLOORBEAM STIFFENER REPAIRED PER SRM 53-10-51-2R4 FIG 201 REV 44. THIS CLASSIFIED AS MAJOR REPAIR WITH MATERISDR IPXA09656788Fitting · crackedINSPECTION TYPE:C MAIN EQUIPMENT CENTER STA 246 FLOORBEAM CLIP FOUND CRACK AT RBL 10, CRACK LENGTH 1.75 INCH. MAIN EQUIPMENT CENTER STA 246 RBL 10 FLOORBEAM CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 44.SDR IPXA09656787Fitting · crackedINSPECTION TYPE:C MAIN EQUIPMENT CENTER STA 246 FLOORBEAM CLIP FOUND CRACK AT LBL 50, CRACK LENGTH 1 INCH. MAIN EQUIPMENT CENTER STA 246 LBL 50 FLOORBEAM CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 44.SDR IPXA09656786Floorbeam · crackedINSPECTION TYPE:C MAIN EQUIPMENT CENTER STA 246 FLOORBEAM ANGLE FOUND CRACK AT LBL 25, CRACK LENGTH 075 INCH. MAIN EQUIPMENT CENTER STA 246 LBL 25 FLOORBEAM ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 44.SDR USAA2009083192300Gusset · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON GUSSET ON OUTBOARD SIDE OF FLOORBEAM AT BS 927, LBL 24.75. REPLACED FLOORBEAM GUSSET AT BS 927, LBL 24.75 IAW B737 SRM 51-40-02.SDR AALA20090721TUL33Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED PER ENGINEERING AUTHORIZATION 737-53-006736 AND SRM 53-00-51-2R.SDR MZZA2009071700095Floorbeam · corrodedFLIGHT COMPARTMENT FLOOR STRUCTURE FOUND CORROSION ON SURFACES OF FLOORBEAM BS 270 FROM LBL10 OT RBL 10. REPAIR CARRIED OUT IAW EC/RA 5311-01456.REFER TO ATTACHED FORM 44.0008.FOR SEQUENCE OF OPERATION. REFER TO L/P 0975566 FOR NDT INSPECTION.
Back to JASC 5315