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 04FDEA01397Floorbeam · corrodedT-CAP CORRODED IN FORWARD PIT AT STATION 909 RBL 30. REMOVED AND REPLACED T-CAP IAW DC10 SRM 51-31-01 VOL 2.SDR C2XA04SH314Floorbeam · corrodedDURING C-CHECK THE RIGHT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 23. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 207. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0410270Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR. (M)SDR USAA040258Floorbeam · corrodedFLOORBEAM, 3.0 INCH X 2.0 INCH X .025 INCH DEEP, CORROSION, LEVEL 2; BETWEEN FR66-68, +Y762,Z240. REPLACED FLOORBEAM IAW SRM.SDR USAA040257Floorbeam · corrodedFLOORBEAM, 1.0 INCH X 1.0 INCH X .025 INCH DEEP, CORROSION, LEVEL 2; BETWEEN FRAME 64 & 66, +Y787, Z240.SDR USAA040238Floorbeam · corrodedFLOORBEAM, 1.3 INCH X 1.9 INCH X .35 INCH DEEP, CORROSION; LEVEL 2; TASK NR JA26053500, FR68, Y1300MM, Z240. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR SWIA200413467Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED. ANGLES (2) REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21, 51-23-00, AND RII 53-401.SDR COMA0460326Floorbeam · corrodedSURFACE CORROSION FOUND ON CARGO FLOORBEAM CAP LBL 27 AT FS 600 AROUND OUTBOARD NUT PLATE. REMOVED FLOORBEAM CAP LBL 27 AT FS 600 AND INSTALL NEW FLOORBEAM CAP IAW CRJ SRM 51-40-11, 51-41-02, 51-45-00, 51-42-13, 51-42-21, 51-42-06, 51-42-34.SDR C2XA04TY083Floorbeam · corrodedDURING A SCHEDULED 1C INSPECTION THE LT FLOORBEAM WAS FOUND CORRODED AT THE CARBON SUPPORT. MAINTENANCE REPAIRED THE LT FLOORBEAM, ALODINED AND PAINTED IAW EMB 135/145 SRM 53-21-10; AND CPM 51-21-04; 05; 06 ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON SDR USAA040235Floorbeam · corrodedFLOORBEAM, 1.0 INCH X 0.950 INCH X 0.055 INCH DEEP, CORROSION; LEVEL 2; TASK NR JA260535, FR 66-68, Y1200, Z240. REPLACED WITH NEW FRAME IAW SRM.SDR JRAA0520042Floorbeam · corrodedDURING A SCID INSPECTION 53-20, CORROSION WAS FOUND ON FLOORBEAM AT STA 681.0 RT SIDE AT BELTFRAME. AN AREA OF APPROX 3 INCHES X 5 INCHES ON THIS FLOORBEAM WAS FOUND CORRODED AT BELTFRAME ATTACH POINT AROUND RIVETS. THE CORROSION HAD PROGRESSED THROUGH 50 PESDR JRAA0520041Floorbeam · corrodedDURING A SCID INSPECTION 53-20, A MISSING RIVET HEAD WAS FOUND AT STA 712.0. RT SIDE AT THE FLOORBEAM TO BELTFRAME ATTACH POINT. CORROSION WAS FOUND UNDER RIVET HEAD. NO OTHER RIVETS WERE FOUND TO BE CORRODED AT THIS TIME. RIVET REPLACEMENT IN PROGRESS AT SDR CALA0400498Floorbeam · corrodedINSPECTION FOUND AFT MAIN CABIN FLOORBEAM CORRODED AT FS 986, LBL 46. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-31, FIGURE 203.SDR C1HA200492013Floorbeam · damagedSTA 1110 BL 0 FLOORBEAM UPPER TEE. REPAIR STRAPS INSTALLED.SDR C2XA04SH308Floorbeam · corrodedDURING C-CHECK, THE LEFT HAND FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH305Floorbeam · corrodedDURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAMES 20 AND 24. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR COMA0460330Floorbeam · corrodedCARGO FLOORBEAM CAP AT LBL 27 CORRODED THRU AT NUT PLATE FROM FS 589 TO 609. REMOVED AND REPLACED CARGO FLOORBEAM CAP AT LBL 27 WITH NEW SERVICEABLE CAP (P/N 601R35031-1) IAW CRJ SRM 51-42-13 AND CRJ SRM 51-42-21.SDR 35505Floorbeam · corrodedCABIN FLOORBEAM AT STA 1480 LBL 70 CORROSION OUT OF LIMITS B767 SRM 53-00-51. REPAIR REQUIRED. FLOORBEAM CORRODED BECAUSE OF LAY AREA LEAKS. LAY AREA NEEDS TO BE PROPERLY SEALED.SDR C2XA04SH292Floorbeam · corrodedDURING C CHECK THE LT OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 20 AND 23. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 AND EC 5310-01270. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0410266Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM. (M)SDR SWAA041397Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 660, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR CALA0400492Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 927, BL 0, WL 208. THE FLOORBEAM WAS REPAIRED IAW SRM 53-60-51, FIGURE 203.SDR C2XA04SH291Doubler · corrodedSHV - DURING C-CHECK THE RIGHT FLOORBEAM DOUBLER AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH290Floorbeam · corrodedDURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH288Floorbeam · corrodedDURING C-CHECK THE RIGHT HAND FLOORBEAM DOUBLER AT FRAME 22 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200400571Floorbeam · corrodedDURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 FORWARD AND AFT OF FR 67. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 AT FR 67; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472172; INSTALLED REPAIR PART IAW A319 SRM 51-42-11.SDR AWXA200400564Floorbeam · corrodedMC - MAJOR REPAIR - DURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR BEAM Y765 FORWARD OF FR 66. MAINTENANCE REMOVED CORRODED BEAM Y765 FORWARD OF FR 66; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A319 SRM 51-72-11, FIG. 101.SDR ASAA0410260Floorbeam · corrodedPAE - FOUND CORROSION ON UNDERSIDE OF UPPER CHORD AFT SIDE OF FLOORBEAM. REMOVED DAMAGE AND REPAIRED PER SRM. (M)SDR DL73S040432Floorbeam · crackedCRACKS WERE NOTED IN THE BS520 FLOORBEAM UPPER RADII WHERE THE SEAT TRACKS CROSS OVER THE BEAM. DAMAGE WAS REMOVED AND THE FLOORBEAM REPAIRED IAW ERA 089860-14.SDR COMA0460315Floorbeam · corrodedCORROSION ON CARGO FLOOR CAP AT LBL 9. REMOVED AND REPLACED FLOORBEAM CAP AT LBL 9, IAW CRJ SRM 51-42-06, 51-42-13, 51-42-21, 51-42-34.SDR C2XA04SH282Floorbeam · corrodedSHV-DURING C CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 22. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041357Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS AT BS 312, LBL 26 TO RBL 7, BS 328, RBL 42, BS 344, LBL 42.5, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTIONS PER SRM.SDR SWAA041359Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 727C + 7, LBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041355Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM AT BS 986, RBL 43, CORRODED. REPAIRED FLOORBEAM PER ER.SDR MWEA040068Floorbeam · dentedSTATION 180 FLOORBEAM IS DENTED APPROXIMATELY 4 INCHES RT OF THE AIRCRAFT CENTERLINE. FABRICATED AND INSTALLED REPAIR ANGLE.SDR 2004UALA00460Floorbeam · corrodedTOP OF FLOORBEAM CORRODED AT STA 324 AT RT CUSP. MAJOR REPAIR ACCOMPLISHED. CORROSION CAUSED FROM WET AREA OF GALLEY. FLOORBEAM REPAIR ACCOMPLISHED.SDR AALA20040575Floorbeam · crackedAFW - FLOORBEAM AT STATION 287 AT RBL 86 AT VERY OUTBOARD END HAS CRACK ON H3 FLANGE. AREA OF FLANGE CONTAINING CRACK WAS REMOVED. TWO REPAIR ANGLES MACHINED FROM 0,063 INCH 7075T6 EXTRUSION AND FILLER WERE INSTALLED WITH STAINLESS HI-LOKS.SDR AALA20040574Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 AT G1 GALLEY AREA HAS CORROSION REMOVAL ON UPPER AND LOWER SURFACES. MATERIAL REMAINING IS BEYOND SRM LIMITS. AREA IS 2 INCH BY 1 INCH AND A DEPTH OF 0.55 INCHES. REMOVED CORROSION AND VERIFIED FABRICATED REPAIR STRAP, ALODINESDR AALA20040576Floorbeam · corrodedAFW - FLOORBEAM AT STATION 325 (G1 GALLEY AREA) HAS CORROSION REMOVAL ON UPPER AND LOWER SURFACES. MATERIAL REMAINING IS BEYOND SRM LIMITS. AREA IS 1 INCH BY 1 INCH AND DEPTH IS 0.23 INCH. REMOVED CORROSION AND VERIFIED. FABRICATED REPAIR STRAP, ALODINED ASDR AALA20040577Floorbeam · brokenAFW - FLOORBEAM AT STATION 325 AT RBL 86 (VERY OUTBOARD END) BROKEN OFF, AREA IS 1 INCH SQUARE. SMOOTHED AND BLENDED BROKEN EDGE OF CHORD. TWO REPAIR ANGLES MACHINED, EXTRUSION INSTALLED. ANGLES ATTACHED WITH FLUSH HI-LOKS (UPPER FASTENER) AND PROTRUDING HISDR 2004UALA00459Floorbeam · bentFWD PIT STA 760 RBL 49 AFT FLANGE OF UPPER TEE CHORD IS BENT. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR ANGLES AND T-EXTRUSION.SDR 2004UALA00457Floorbeam · bentFWD PIT STA 840 RBL 49 FLANGE OF UPPER TEE CHORD IS BENT RBL 8 TO RBL 65. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR ANGLES & T-EXTRUSION.SDR ASAA0440120Floorbeam · corrodedGYR - FOUND BS 947.5 FLOORBEAM IS CORRODED LBL 20 TO RBL 20. REPAIRED FLOORBEAM IAW REO A00224. (M)SDR ASAA0440121Floorbeam · corrodedGYR - FOUND BS 986.5 FLOORBEAM IS CORRODED RBL 8 TO RBL 44. SPLICED IN NEW UPPER CAP OF TEE CHORD FLOORBEAM FROM RBL 8 TO RBL 53. (M)SDR CALA0400485Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 720 FROM RBL 58.2 TO LBL 58.2. REPAIRED IAW ECRA 5320-01753, SRM 51-10-02, FIGURE 12, PARAGRAPH 6 AND 51-40-02, FIGURE 3 AND 12.SDR CALA0400484Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 740 FROM RBL 9 TO LBL 4. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR C2XA04SH276Floorbeam · corrodedSHV-DURING C CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR EIA2004099Floorbeam · corrodedUPPER FLOORBEAM, CORROSION AT STA 720 RBL 84.0 WL 199 UNDER FLOOR BOARD. REMOVED FLOORBEAM AT STA 720 LBL TO RBL 15, PER B747 SRM 53-10-07.SDR CALA0400480Floorbeam · crackedINSPECTION FOUND A 1 INCH CRACK IN FLOORBEAM AT STA 540, RBL 48. THE FLOORBEAM WAS REPAIRED IAW ECRA 5331-01146.SDR C2XA04SH272Floorbeam · corrodedSHV-DURING C CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT THE COMPOSITE FIBER CROSS BEAM AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10, PAGE 213, FIGURE 201, SHEET 3. THE AIRCRAFT WAS APPRO
Back to JASC 5315