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 SIMA200213803Floorbeam · corrodedABI - DURING AN IMBV MAINTENANCE, FOUND CORROSION ON GALLEY RIGHT FLOORBEAM, THREE AREAS, BETWEEN FRAMES 20 AND 23. REMOVED CORROSION BY BLENDING. NDT PERFORMED, NO DEFECTS. FABRICATED THREE REPAIR DOUBLERS, REPAIR DONE IAW EMB GST-1491/02, AND STANDARD SRMSDR 2002UALA00873Floorbeam · corrodedCABIN FLOORBEAM UPPER T-CAP CORRODED AT STATION 324 FROM 35 RBL TO 60 RBL AT STRINGER 17R. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW T-CAP FROM LBL 7 TO RBL 70.SDR C2XA02TY091Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION, CORROSION WAS FOUND ON THA LEFT OMEGA BEAM AT FRAME 20. MAINTENANCE CUT OUT THE CORRODED AREA, FABRICATED ANGLES, SHIMS AND FILLER, THEN INSTALLED. IAW EMB-145-SRM-53-21-10 AND 51-40-02. THE REPAIR WAS SATISFACTORY AND THESDR AALA20020784Floorbeam · wornTUL - FOUND DEEP WORN AREA IN BOTTOM OF CABIN FLOORBEAM AT STATION 389 BL 0. REMOVED DAMAGED AREA. INSTALLED ANGLE DOUBLER FILLER AND WEAR STRIP, CLEANED AND TREATED AND PRIMED PER AARD 53-20-00-21. (M)SDR SIMA200213805Floorbeam · corrodedDURING AN IMBV MAINTENANCE FOUND CORROSION ON LEFT HAND OMEGA BEAM BETWEEN FRAMES 20 AND 23. REMOVED CORROSION BY BLENDING. FABRICATED A REPAIR DOUBLER REPAIR DONE IAW SRM.SDR AWXA200200468Floorbeam · corrodedYVR - MAJOR REPAIR - DURING C-16 INSPECTION, CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM AT BS 312, BL 0, RBL 8, AND RBL 11. MAINTENANCE CUT OUT DAMAGED AREA OF FLOORBEAM T-CHORD AT BS 312, BL 0, RBL 8, AND RBL 11; FABRICATED REPAIR ANGLES, AND STIFSDR 2002UALA00869Floorbeam · corrodedCABIN FLOORBEAM STATION 1680 CAP RBL 53 TO LBL 54 CORRODED. MAJOR REPAIR ACCOMPLISHED. CABIN FLOORBEAM CAP STRAP REPAIR INSTALLED.SDR 200200259Floorbeam · corrodedCORROSION WAS FOUND ON THE BS 380 FLOORBEAM UPPER CHORD LBL 9 TO LBL 28. THE FLOORBEAM WAS REPAIRED BY REMOVING THE DAMAGED SECTION OF UPPER CHORD AND SPLICING IN A NEW SECTION BETWEEN LBL 28 AND LBL 9.2 PER BOEING DRAWING 14100044 SHEET 4 AND ECRA 470-53-133SDR 200200258Floorbeam · corrodedCORROSION WAS FOUND ON THE BS 400 FLOORBEAM UPPER FORWARD CHORD AT RBL 35. ALSO AN EXISTING REPAIR WAS FOUND COMMON TO THE FORWARD UPPER CHORD AT RBL 40. THE CORROSION WAS REMOVED BY TRIMMING AWAY THE HORIZONTAL FLANGE OF THE CHORD. THE EXISTING REPAIR WAS SDR C2XA02TY089Floorbeam · corrodedTYS DURING A SCHEDULED 1C/2C INSPECTION THE TOP CAP AT FRAME 17-18 WAS CORRODED. MAINTENANCE REMOVED THE CORROSION AND BLENDED THE AREA, REPLACED THREE RIVET'S, ALODINE, PRIMED AND PAINTED IAW EMB 145 SRM 51-40-02, 51-10-02, 51-21-04-05-06. ALL WORK WAS ACCSDR ASOA02277Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE UPPER FLOORBEAM WAS FOUND CORRODED AT FRAME 36, FROM THE RIGHT TO THE LEFT SIDE OF THE FUSELAGE. MAINTENANCE REPAIRED THE CORRODED FLOORBEAM IAW ASA EO 72-53-0131. THIS EO REF FAA FORM 8110-3, REPORT NR 02-041, WHICH INCSDR UPS02438413Floorbeam · crackedINSPECTION TYPE:C AFT CARGO - BS 1660-1680 LBL 20-40 FLOORBEAM SURFACE WEB FOUND CRACKED. AFT CARGO - BS 1660-1680 LBL 20-40 FLOORBEAM SURFACE WEB REPAIRED AS PER SRM 51-40-02 FIG 1.SDR 2002UALA00852Frame · corrodedAFT PIT FRAME STATION 1500 RBL 15 CORRODED. MAJOR REPAIR ACCOMPLISHED.REPAIR DOUBLER INSTALLED ON FRAME 1500.SDR 2002UALA00850Intercostal · crackedCABIN FLOOR INTERCOSTAL AT STATION 357 RBL 25" STRINGER 17R IS CRACKED OUT AROUND NUTPLATE HOLE. MAJOR REPAIR ACCOMPLISHED.INSTALLED NEW U- CHANNEL INTERCOSTAL BETWEEN STATION 345 AND 365.SDR 2002UALA00845Floorbeam · corrodedCABIN FLOORBEAM TOP FLANGE CORRODED BODY STATION 1640, RBL 44 THROUGH RBL 62. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE REPAIR.SDR AALA20020627Floorbeam · corrodedTUL - FOUND TOP OF FRAME 1640 FROM LEFT SIDE TO RIGHT HAS NUMEROUS AREAS OF HEAVY CORROSION UNDER NUT CLIPS. INSTALLED FABRICATED FLOORBEAM CAP AND ASSOCIATED PARTS PER SRM 51-10-010. (M)SDR AWXA200200473Web · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK 5 EACH CRACKS WERE FOUND AT RIVET HOLES ON LOWER ROW OF FLOOR BEAM INTERCOASTAL WEB RBL 25, BS 706 TO BS 713. MAINTENANCE CUTOUT DAMAGED AREA OF WEB FROM BS 706 TO BS 713, RBL 25; PERFORMED HFEC INSPECTION OF CUTOUT TO VESDR UPS02438459Floorbeam · corrodedINSPECTION TYPE:C COCKPIT - FLOORBEAM FOUND CORRODED. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPAIR REFER TO SRM FIG 53-10-07 FIG 23.SDR AWXA200200440Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A CRACK WAS FOUND AT FASTENER HOLE ON UPPER CHORD FLANGE AT BS 727B-1, RBL 44. MAINTENANCE REMOVED DAMAGED SECTION. FABRICATED A FILLER, REPAIR STRAPS, AND A SHIM. INSTALLED REPAIR PARTS IAW AWA ER 03-5310-02141-KB2A.SDR AALA20020626Floorbeam · corrodedTUL - FOUND FLOOR FRAME BL 600L, CORROSION TOP SURFACE, STATION 3845-4610. INSTALLED NEW FLOOR FRAME AT BL 600L, STATION 3845-4610, PER 53-30-02=SR01. (M)SDR SIMA200213011Floorbeam · corrodedABI - DURING INSPECTION, FOUND FORWARD DIGITAL CORRODED AT RIVETS AND NUTPLATE BETWEEN FRAME 16 AND 18. REMOVED CORROSION BY CUT OUT. REPAIRED IAW EMB 145, SRM 145/1142, CHAPTER 53 REV 17 53-21-10, AND STANDARD SRM PRACTICES. (M) (M)SDR UPS02438402Floorbeam · corrodedINSPECTION TYPE:C COCKPIT- FLOORBEAM FOUND CORRODED. CORROSION REMOVED IAW SRM 51-10-01. BLEND OUT NOT WITHIN SRM 53-10-01 FIG 1 LIMITS, FOR REPAIR REF SRM FIG 53-10-07 FIG 23.SDR SWAA020974Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS727A PLUS 18, WL 208 AT LBL 47. REPAIRED FLOORBEAM PER BFG ER.SDR 2002UALA00841Floorbeam · corrodedBODY STATION 852 LBL 55 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00840Floorbeam · corrodedBODY STATION 1219 LBL 30 T-CAP CORRODED UNDER NUT PLATES. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00835Floorbeam · corrodedCABIN FLOORBEAM 1681 RBL 12 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP AND ANGLE REPAIRS WITH FILLER.SDR 2002UALA00831Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP STATION 1640, RBL 51 CORRODED. MAJOR REPAIR ACCOMPLISHED. STRAP REPAIR INSTALLED.SDR 2002FA0000726Floorbeam · corroded(FLOORBEAM) FOUND DURING (D) CHECK INSPECTION. CORROSION AT STA 920. 63 INCHES LEFT OF CENTER, FLOORBEAM.SDR 2002UALA00825Floorbeam · gougedCABIN FLOORBEAM STATION 1420 TOP SURFACE HAS GOUGES AROUND FASTENER HOLES, LBL 18 TO RBL 5 AT WL 208. MAJOR REPAIR ACCOMPLISHED. INSTALLED REINFORCEMENT STRAPS.SDR 2002UALA00807Floorbeam · damagedDAMAGE FOUND FORWARD CABIN STATION 277 RBL 53 UPPER FLOORBEAM HOLE. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR SIMA200214819Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING. LEFT OMEGA BEAM CORRODED AT FRAME 20. BLENDED AND TREATED CORROSION IAW EMB GST-1472/02. (M)SDR 2002UALA00790Crease Beam · corrodedMID CABIN CREASE BEAM HAS EXCESSIVE MATERIAL LOSS AT BODY STATION 1408 RBL71. MAJOR REPAIR ACCOMPLISHED.REPLACED CREASE BEAM.SDR SIMA200212157Floorbeam · corrodedABI - DURING AN MBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON GALLEY RIGHT BEAM AT FRAME 19. REMOVED CORROSION BY BLENDING. PERFORMED AN NDT INSPECTION OF THE AREA AND FOUND NO REJECTABLE INDICATIONS. REPAIRED IAW EMB GST-1348/02, AND STANDARD SRM PRACTICESDR SIMA200212160Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON FORWARD DIGITAL. REMOVED CORROSION BY CUT OUT. PERFORMED AN NDT INSPECTION OF THE AREA AND FOUND NO REJECTABLE INDICATIONS. REPAIRED IAW EMB145 SRM 145/1142, CHAPTER 53, REV 17, 53-21-10, AND SSDR AT0200063Floorbeam · corrodedAFT CARGO COMPARTMENT OVERHEAD FLOORBEAM HAS CORROSION INDICATION AND BLUE WATER STAINS AT APPROX BS 965 ABOVE PULLEYS. INSTALLED NEW ANGLE AT FLOORBEAM BS 965 FROM RBL 5 TO RBL 55.SDR 2002UALA00786Flange · wornAFT PIT FRAME FLANGE AFT SIDE LIP WORN, 2 EACH AREAS FROM FASTENERS STA 1520 BETWEEN STRINGER 22R AND 23R. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.L-ANGLE DOUBLER INSTALLED.SDR 2002UALA00785Floorbeam · corrodedCABIN FLOORBEAM IS CORRODED AT STA 1640, RBL 50 TO RBL 60. MAJOR REPAIR ACCOMPLISHED. SPLICED IN A NEW FLOORBEAM CAP.SDR 2002F00679Floorbeam · crackedAT C-CHECK, FOUND 1 AND .5 INCH CRACK AT RIGHT FORWARD FLOORBEAM UPPER CHORD, AT STATION 312 RBL 13. (M)SDR 2002UALA00784Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT BODY STATION 345, RBL 36. MAJOR REPAIR ACCOMPLISHED. DAMAGED AREA CUT OUT RBL 34.5 - 37 FORWARD FLANGE ONLY. NESTED DOUBLE ANGLE AND STRAP APPLIED TO FLOORBEAM, RBL 31-41.SDR 2002F00582Floorbeam · corrodedAT C-CHECK, FOUND CORROSION ON AFT CARGO COMPARTMENT FLOORBEAM STATION 950E RBL 27, FORWARD SIDE. (M)SDR C1HA200283011Floorbeam · corrodedFLOORBEAM IS CORRODED AT STA 380 RBL 55.SDR 2002UALA00757Floorbeam · corrodedCABIN STATION 987 FLOORBEAM CAP CORROSION REMOVAL BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. ACCOMPLISHED SPLICE REPAIR.SDR SIMA200212149Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING, CORROSION GALLEY CENTRAL BEAM GUSSET. BLENDED CORROSION, PERFORMED NDT, RESTORED SURFACE PROTECTION IAW EMB CPM 51-21-04, 51-21-05, 51-21-06. (M)SDR SIMA200212150Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, CORROSION ON FORWARD DIGITAL. BLENDED CORROSION PERFORMED NDT, RESTORED SURFACE PROTECTION IAW EMB CPM 51-21-04, 51-21-05, 51-21-06. (M)SDR SIMA200212151Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, CORROSION FOUND ON AFT DIGITAL. BLENDED, PERFORMED NDT, RESTORED SURFACE PROTECTION. (M)SDR C1HA200283008Floorbeam · corrodedFLOORBEAM STA 1130 IS CORRODED ON TOP SIDE OF UPPER FLANGE AT 2 EA FASTENER LOCATIONS LBL 44 & LBL 25.SDR TSAA0253131Floorbeam · crackedFOUND CRACKS AT BL 0 FLOOR BEAM AT BS 663 AND BETWEEN BS 700-717 WEB. REMOVED AND DISCARDED A SECTION OF THE WEB AND DOUBLER CONTAINING THE CRACKS. FABRICATED ALL REPAIR PARTS. INSTALLED SPLICE ANGLES AND STRAPS WITH NUT PLATES. COMPLETED INSTALLATION OF RSDR UPS02438302Floorbeam · crackedINSPECTION TYPE:C LT BS 340 UPPER DECK FLOORBEAM ONE EACH FASTENER HOLE CRACK REVEALED AT UPPER CHORD LAYER THROUGH THICKNESS. U/D BS 340 FLOORBEAM UPPER CHORD PARTIALLY REPLACED FROM LBL 35 TO LT MOST O/B IAW HAECO RS R-53-15-34801 AND DWG 141U0044 SHEET 2 FSDR DHL2002726517Floorbeam · corrodedDURING C CHECK, BS 930 FLOORBEAM IS EXFOLIATED ON THE AFT SIDE OF THE BEAM AT THE INTERSECTION WITH THE BS 930 LT FORGING LBL 62, WL 203. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW B-727 SRM 53-10-2 FIG 8 SHEET 3 DETAIL III. FABRICATED REPAIR PART IAW SDR MWEA020271Fitting · brokenCENTER CARGO AY FLOOR BEAM AT STATION 731 HAS A BROKEN FITTING AT AIRCRAFT CENTER LINE. -- REMOVED AND REPLACED FITTING.
Back to JASC 5315