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 SIMA200627703Floorbeam · corrodedSAW - DURING IMBV INSPECTION, FOUND RIGHT UPPER FLOORBEAM AT FRAME 23 IS CORRODED. REMOVED AND REPLACED FLOORBEAM, IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200627702Gusset · corrodedDURING IMBV INSPECTION, FOUND GUSSET CONNECTING RIGHT HAT BEAM TO FLOORBEAM 20 CORRODED. REMOVED AND REPLACED GUSSET, IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA060551Floorbeam · corrodedDURING CHECK IN BNA FOUND UPPER FLOOR FLANGE AT FS272 BETWEEN RBL17 AND RBL33, IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW EO NR S53108.SDR MALA060549Floorbeam · corrodedDURING CHECK IN BNA, UPPER FLOOR FLANGE, AT, FS258, RT AT BLO, IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW EO NR S53108. REF: EAMS WORK ORDER 214384 TASK 1520SDR USAA061147Floorbeam · corrodedAROUND FASTENER HOLES ON T-CAP STA 344 WBL R 10 WBL L 19 CORROSION. REPLACED SECTION OF T-CAP IAW SRM 53-10-51 REPAIR 5 LEVEL 1 C53-107-02, DEFECT SIZE: .50 INCH.SDR USAA061138Floorbeam · corrodedSTA 294.5 FLOORBEAM BETWEEN LBL 38 AND LBL 43 CORROSION. REMOVED CORRODED SECTION OF BEAM AND INSTALLED NEW SECTION IAW SRM 53-10-51 LEVEL 2 C53-107-02, DEFECT SIZE: 26 X 2.5 INCHES.SDR CALA0600343Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 4. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR TRAX200600729Floorbeam · crackedAFT ANGLE CRACKED AT FS 280 FLOORBEAM JUST OB OF RBL 9.SDR TRAX200600728Floorbeam · crackedAFT ANGLE CRACKED AT FS 280 FLOORBEAM JUST OB OF LBL 9.SDR SWAA063425Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM STABILIZER STRAP CRACKED AT BS 344, LBL 11. REMOVED AND REPLACED STABILIZER STRAP SECTION PER SRM.SDR C2XA06SH091Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 24-25. MAINTENANCE REMOVED THE DAMAGED AREA AND INSTALLED A DOUBLER REPAIR IAW EMB 145XR SRM 52-00-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA06SH090Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND INSTALLED A DOUBLER REPAIR IAW EMB 145XR SRM 53-00-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR EIA2006250Floorbeam · crackedAFT CARGO STA 1940 L BUTT LINE 33, FLOORBEAM UPPER CHORD FOUND CRACKED. REPAIRED IAW SRM 51-40-04.SDR CALA0600342Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CAP CORRODED AT STA 986, RBL 24.5 TO RBL 64. THE FLOORBEAM UPPER CHORD WAS REPAIRED IAW ECRA 5321-01392.SDR TRAX200600724Floorbeam · crackedIB FLOORBEAM TO FS 280 WEB CRACKED IB OF LBL 9 (MARKED). ALL WORK DONE IAW BOMBARDIER REO601R-53-11-926 CM20420. (CLOSED)SDR EIA2006244Floorbeam · corrodedAFT CARGO STA 1860 RB LINE 5-37 FLOORBEAM UPPER CHORD LOWER SURFACE FOUND CORROSION. CORROSION REMOVED AND RE-PROTECTED IAW SRM 51-10-01 AND 51-10-02.SDR TRAX200600715Floorbeam · corrodedETNRC 2000-56, FLOORBEAM 41 NEED TO BE REPLACED (CORROSION).SDR AWXA200601598Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM, +Y1292, FS 67 PASSENGER CABIN. MAIN CABIN FLOORBEAM, +Y1292, BETWEEN FS 67 - FS 68 REPLACED IAW A320 SRM 51-72-11. FASTENER REMOVED, AND INTALLED NEW FASTENER IAW A320 SRM 51-42-11.SDR AWXA200601597Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM +Y1292, FS 67 + 18". MAIN CABIN FLOORBEAM, +Y1292, FS 68 TO FS 69 WAS REPLACED IAW A320 SRM 51-72-11. FASTENERS REMOVED, AND INSTALLED NEW FASTENER IAW SRM 51-42-11.SDR AALA20060832Floorbeam · corrodedMCI - FLOORBEAM AT STATION 1329 TO 1351 RIGHT BUTT LINE 16 HAD CORROSION ON BOTTOM SIDE NUT PLATE AREA. REPLACED FLOOR SUPPORT AT STATION 1329 TO 1351 RIGHT BUTT LINE 16.SDR AWXA200601604Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM, -Y1292, FS 66. REPLACED FLOORBEAM -Y1292, BETWEEN FS 64 TO FS 66 IAW SRM A320 51-72-11 PAGE 1 AND SRM A320 51- 42-11 PAGE 6.SDR TRAX200600710Floorbeam · crackedRANRC 268, FLOORBEAM LBL 27 OUTBOARD AT APPROX 310 HAS CRACK PROTRUDED FROM RIVET, MARKED. CUT-OUT APPX 2IN OF DAMAGED WEB FLANGE AT LBL 27.0, FWD OF F.S. 310 IAW CRJ SRM 51-71-59. FABRICATED REPAIR ANGLE FROM 2024-T3 .040 PO 864-3-1 AND REPAIR FILLER IAW CRJSDR C2XA06SH088Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED FROM FRAME 20 TO 24. MAINTENANCE REMOVED THE DAMAGED AREA AND SPLICED IN A NEW BEAM SECTION IAW EC5320-01229. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200601599Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM, PASSENGER CABIN AROUND HOLE HARD POINT FS 14, AND +Y765. MAIN CABIN FLOORBEAM, PASSENGER CABIN, +Y765 BETWEEN FS 12 TO FS 24 WAS REPLACED IAW A320 SRM 51-72-11, AND FASTENER INSTALLED IAW A320 SRM 51-42-11.SDR USAA061136Floorbeam · corrodedSTA 967 STA 986.5 RBL 18 AND LBL 18 CORROSION. REPLACED WITH IDENTICAL PART IAW SRM 51-40-02 LEVEL 1 C53-107-02, DEFECT SIZE: 1 INCH.SDR ASAA0640934Floorbeam · corrodedFLOORBEAM UPPER CAP CORRODED AT CLIP NUT LOCATION. CORRODED FLOORBEAM UPPER CAP REPAIRED IAW SRM 53-60-51 FIG 201.SDR USAA061124Floorbeam · corrodedSTA 986 CORROSION. REMOVED AND REPLACED T-CAP IAW SRM 53-10-05B LEVEL 1 C53-107-02, DEFECT SIZE: 2 X 59 INCHES.SDR USAA061123Floorbeam · corrodedSTA 312 RBL 22 CORROSION. REPLACED T-CAP IAW SRM 53-10-51 LEVEL 2 C53-107-02, DEFECT SIZE: .5 X .25 INCH.SDR COMA0670187Floorbeam · crackedFLOOR SUPPORT BEAM AT FS 280.0 FOUND CRACKED. REPAIRED CRACKED AREA IAW COMAIR EA 70-5310-01329.SDR COMA0670191Floorbeam · corrodedFLOOR SUPPORT ANGLE CORRODED. REPLACED ANGLE IAW SRM 51-42-06.SDR AWXA200601605Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM, +Y1292, FS 66. REPLACED FLOOR BEAM, +Y1292, FS 64 TO FS 66 IAW SRM A320 51-72-11 AND SRM A320 51-42-11.SDR UIEA200600241Floorbeam · crackedDURING INSPECTION FOUND FLOORBEAM WEB CRACKED AT STA 360 RT STR 12A. FLOORBEAM WEB REPAIRED AS PER SRM 53-10-09 FIG 11 AND EO NR 4753A818.SDR EIA2006208Floorbeam · crackedMAIN DECK STA 2300, BL 0, FLOORBEAM ANGLE CRACKED. ANGLE REPLACED PER SRM 51-10-01 AND DRWG 35B06622, INSTALLED PER SRM 51-30-02.SDR AWXA200601607Floorbeam · corrodedMAJOR REPAIR - BC4 CHECK, NR 5938696. CORROSION ON MAIN CABIN FLOORBEAM, -Y1292, FR 68+1 INCH. REPLACED FLOORBEAM -Y1292, FR 67+18 INCH TO FR 69+1 IAW SRM A320 51-72-11 PAG 1 AND 51-42-11 PAG 6.SDR AWXA200601606Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM,. -Y1292, FR 67+6". REPLACED FLOORBEAM, -Y1292, 66+1" TO FS 67+18" IAW A320 SRM 51-72-11 PAGE 4 AND 51-42-11 PAGE 6.SDR 06FDEA03165Floorbeam · damagedEXISTING FLOORBEAM REPAIR AT STA 1070, RBL 10 - RBL 65, DOT NR 47. REPAIR REQUIRES MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. PREVIOUSLY INSTALLED REPAIR WAS FOUND NOT TO BE ACCOMPLISHED PER FAA APPROVED DATA. REMSDR F3LA200600116Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM (LONGERON) FWD OF FR68 AT Y1292. BLENDED OUT CORRODED AREA ON FLOORBEAM AND FOUND AREA TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG. 102. REMOVED AND REPLACED FLOORBEAM FROM FR66 TO FR68 IAW SRM 51-42SDR CALA0600337Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016, RBL 4 TO RBL 36. THE FLOORBEAM UPPER CHORD WAS REMOVED AND REPLACED IAW ECRA 5310-03851.SDR CALA0600323Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016, RBL 4 TO RBL 36. THE FLOORBEAM UPPER CHORD WAS REMOVED AND REPLACED IAW ECRA 5310-03851.SDR USAA061112Floorbeam · corrodedFOUND CORROSION AFT WET AREA FS 66 (3" AREA) TO FS 68 (2" AREA). REPLACED FLOORBEAMS WITH IDENTICAL PARTS PER SRM 51-72-11. CORROSION TASK JA-250-53500; LEVEL 1 DEFECT SIZE: 3" AND 2" AREA.SDR USAA061113Floorbeam · corrodedFOUND CORROSION FS 21 Y 254 ON FLOORBEAM. REPLACED FLOORBEAM PER SRM 51-72-11; CORROSION TASK JA-220-53500; LEVEL 1 DEFECT SIZE: 2" BY 3/4".SDR USAA061114Floorbeam · corrodedFOUND FLOORBEAM CORRODED Y1292 FS 66. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-72-11; CORROSION TASK JA-260-53500, LEVEL 1 DEFECT SIZE: 2" BY 48" BY .100.SDR USAA061115Floorbeam · corrodedFOUND FLOORBEAM CORRODED Y60 AT C 16. INSTALLED DOUBLER PER SRM 53-00-14 FIG 206; CORROSION TASK JA-220-53500; LEVEL 1 DEFECT SIZE: 3" BY 3" BY .150"SDR USAA061118Floorbeam · corrodedFOUND TOPSIDE OF FLOORBEAM CORRODED AROUND (3) NUTCLIPS -Y1292/-Y1162. REMOVED AND INSTALLED NEW BEAM PER SRM 52-72-11; CORROSION TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1" BY 1".SDR USAA061119Floorbeam · corrodedFOUND CORROSION, TOPSIDE OF BEAM (3" FWD OF FS 68) AROUND NUT PLATE. REMOVED AND INSTALLED NEW BEAM PER SRM 52-72-11; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1.25" BY 1.25".SDR USAA061120Floorbeam · corrodedAFT WET AREA FS 66-68 FLOOR SUPPORT BEAM 1292 LT SIDE AROUND NUT PLATE. DEFECTIVE PART REPLACED WITH IDENT PART; DEFECT SIZE: 3 SQ IN TOTAL.SDR F3LA200600108Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AFT OF L2 DOOR CUTOUT AT FR68 TO FR69, Y1292. FLOORBEAM WAS FOUND TO BE OUT OF LIMITS PER 53-00-14. REMOVED AND REPLACED FLOORBEAM FROM C64 TO C69 PER SRM'S 51-42-11 AND 51-44-11.SDR USAA061103Floorbeam · corrodedFOUND FLOORBEAM CORRODED, BS 700 BL 58L WL 208. FAB'D NEW T CHORD, ANGLES, TRAPS AND INSTALLED PER TYP REP 53-15-01; CORROSION TASK C53-123; LEVEL 1 DEFECT SIZE: 3.5"L BY 1"W BY .016"D.SDR USAA061100Floorbeam · corrodedFOUND FLOORBEAM CORRODED, STA 1016, RBL 3. REMOVED SURF CORROSION, INSTALLED FLANGE DOUBLER IAW SRM 53-00-51 LEVEL 2 C53-107-02, DEFECT SIZE: 1.0".SDR F3LA200600115Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM (LONGERON) JUST AFT OF FR68 AT Y1292. BLENDED CORRODED AREA ON FLOORBEAM AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG. 102. REMOVED AND REPLACED FLOORBEAM FROM FR68 TO FR69 IAW SRM 51-42-11.
Back to JASC 5315