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 SWAA032436Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 1016, WL 208, RBL 5. REPAIRED FLOORBEAM PER SRM.SDR C2XA03TY188Doubler · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE RIGHT HAND GALLEY FLOORBEAM DOUBLER AT FRAME 20 AND 22. MAINTENANCE REMOVED AND REPLACED THE DOUBLER IAW EMB SRM 51-30-01, 51-40-02 AND CPM 51-21-04, 05, 06. THE AIRCRAFT WILL BE RELEASED UPON COMSDR C2XA03SH429Floorbeam · corrodedSHV- DURING C-CHECK, THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA032431Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 774, LBL 3, LBL 8, LBL 13, LBL 18, RBL 8, AND RBL 3. REPAIRED BEAM PER SWA EA.SDR 03FDEA01861Floorbeam · corrodedCORROSION AROUND SEVERAL NUT PLATE HOLES IN LONGITUDINAL FLOORBEAM, LBL 25, WL 208, BS 760 - 850.SDR 03FDEA01862Floorbeam · corrodedCORROSION BS 400 FLOORBEAM TOP CHORD CORRODED, LBL 6 TO LBL 10, WL 208.SDR 03FDEA01866Floorbeam · corrodedCORROSION WHILE WORKING CARD N01362, FOUND CORROSION ON FLOORBEAM STA 312 RBL 14 WL 208.SDR AWXA200301369Floorbeam · corrodedDURING C-21 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF UPPER T-CAP REPAIR AT BS 986.5, RBL 0.5 TO RBL 45. MAINTENANCE REMOVED UPPER T-CAP REPAIR AT BS 986.5, LBL 11 TO RBL 51; FABRICATED A NEW REPLACEMENT T-CAP; INSTALLED REPAIR PART IAW B737-200SDR USAA030257Floorbeam · corrodedFOUND BEAM CORRODED 3 CM BY 2.2 CM CORRODED THROUGH STRUCTURE, FRAME 66 AT LAV'S AFT INBOARD ATTACHMENT + Y80 CM. DEFECTIVE PART REPLACED WITH IDENT PART NR PER SRM 51-42-11 AND 51-72-11. CORROSION LEVEL 1, TASK NR JA-160-53500. (M)SDR SWAA032405Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND 2 EA FLOORBEAM UPPER CHORDS CORRODED AT BS 987, RBL 43, WL 208, AND BS 1016, RBL 36, WL 208. REPAIRED FLOORBEAMS PER SRM.SDR SWIA200312655Floorbeam · crackedFS 280 LEFT FLOORBEAM LBL 9.0 I/B AND O/B ATTACH ANGLES CRACKED. REPLACED ANGLES IAW CRJ SRM 51-40-11 & RII 53-401. P/N: 601R31113-57.SDR SWIA200312654Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 O/B ATTACH ANGLE CRACKED. REPLACED ANGLE IAW CRJ SRM 51-40-11 & RII 53-401. P/N: 601R31113-58.SDR SWAA032417Floorbeam · severedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER T-CHORD SEVERED AT BS 660, BL-0, WL 207. REPAIRED PER SWA EA.SDR USAA030258Floorbeam · corrodedFOUND CORROSION ON BEAM 1.9 INCH BY 1.3 INCH BY .050 INCH DEEP, FRAME 64 INBOARD OF -Y1114 CABIN FLOOR SUPPORT. CORROSION LEVEL 2 TASK NR JA 260-53500. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR PER SRM 51-42-11 AND 51-72-11. (M)SDR 03FDEA01836Floorbeam · corrodedCORROSION (C53-224-01, 3) FLOORBEAM BS 1030, LBL 9, WL 208. CORROSION ON FLOORBEAM BS 1030, LBL 9, WL 208 FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1. REPAIRED FLOORBEAM BS 1030, LBL 9, WL 208 IAW SRM 53-10-8 FIG 8.SDR 03FDEA01823Floorbeam · corrodedCORROSION (C53-111-01, 3) LWR CHORD OF FLOORBEAM BS 1110, RBL 38, WL 201. *S/D* REMOVED CORROSION AREA 1.5 X 3 X .029 INCH DEEP FROM ORIGINAL .150 FOUND OUT OF LIMITS PER SRM 53-10-1 FIG 4. REPAIRED LWR CHORD OF FLOORBEAM BS 1110 RBL 38 WL 201 PER SRM 53-SDR 03FDEA01826Floorbeam · corrodedCORROSION (C53-224-01, 3) FLOORBEAM BS 1050, LBL 27, WL 208. BLENDED CORROSION ON TOP CHORD OF FLOORBEAM IN A 1 X 1 X .029 INCH FOUND TO BE OUT OF LIMITS PER SRM 53-10-1 FIG 4. REMOVED TOP OF CHORD FROM LBL 19 TO 30.5 AND INSTALLED REPAIR PER SRM 53-10-8 FIGSDR 03FDEA01827Floorbeam · corrodedCORROSION WHILE WORKING N01449 FOUND CORROSION ON TOP SURFACE OF UPPER CHORD OF FLOORBEAM BS 1070 RBL 23 WL 208.SDR 03FDEA01824Floorbeam · corrodedCORROSION ON LOWER SECTION OF FLOORBEAM BS 1070, LBL 1-42, WL 201. REMOVED CORROSION LOWER SECTION OF FLOORBEAM BS 1070, LBL 1-42, WL 201 (14 AREAS) 1 X 1 X NO MORE THAN .018 FROM ORIGINAL .150 EXCEPT AREAS AT LBL 28 .208 REMOVED AND LBL 38 .082 REMOVED. SDR USAA030217Floorbeam · wornFOUND FLOORBEAM WORN 1 INCH BY 1 INCH, STATION 780, LBL 18 FWD SIDE OF T-CAP. REPAIR ANGLE FABRICATED AND INSTALLED PER EA 94780. (M)SDR 2003UALA00804Floorbeam · corrodedSTA 986 RBL 28 CABIN FLOORBEAM T-CAP HAS CORROSION ON UPPER SURFACE. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND ANGLE DOUBLER REPAIR.SDR SWAA032372Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER STRUCTURE CORRODED AT BS 328, WL 208, RBL 50. REPAIRED FLOORBEAM PER SRM.SDR CALA0300610Floorbeam · corrodedCABIN FLOORBEAM (BS 312) TOP CHORD CORRODED AT FASTENER HOLES. INSTALLED NEW FLOORBEAM UPPER CHORD IAW SRM 53-10-51.SDR C2XA03SH416Floorbeam · corrodedSHV- DURING C-CHECK THE LT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH415Floorbeam · corrodedDURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH413Floorbeam · corrodedSHV-DURING C-CHECK THE LT CENTER OMEGA BEAM WAS FOUND TO BE CORRODED FROM FRAME 22-23 AND FRAME 24-25. MAINTENANCE REMOVED DAMAGED AREAS AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR GAIA03157STFloorbeam · crackedDURNG C-CHECK INSPECTION FOUND COCKPIT FLOORBEAM ANGLES CRACKED AT BS 258, ONE AT LBL 4, ONE AT LBL 8. REF FASI N/R NR 61888, REPLACED BOTH CRACKED ANGLES PER B727 SRM 53-10 2 FIG 1. (M)SDR GAIA03152STFloorbeam · corrodedDURING C-CHECK INSPECTION FOUND CABIN FLOORBEAM CORRODED BS 1070 BETWEEN RBL 48 AND RBL 60. REF FASI N/R NR 61850, CUTOUT DAMAGE AND INSTALLED REPAIR PER B727 SRM 53-10-8 FIG 3. (M)SDR GAIA03126STStringer · crackedDURING C-CHECK INSPECTION FOUND STRINGER 15 LT CRACKED AT BS 720B PLUS 10. REF FASI N/R NR 61424, INSTALLED DOUBLER REPAIR PER B727 SRM 53-10-5 FIG 5. (M)SDR 03FDEA01882Floorbeam · corrodedCORROSION AROUND SEVERAL NUT PLATE HOLES IN LONG FLOORBEAM LBL 25, WL 208, BS 760-850.SDR 0302013251Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT BS 1292 FRAME 66. REPAIRED PER EA 32-195731.SDR AWXA200301370Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-21 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF UPPER T-CAP REPAIR AT BS 967, RBL 10 TO RBL 48. MAINTENANCE REMOVED UPPER T-CAP REPAIR AT BS 967, RBL 10 TO RBL 48; FABRICATED A NEW REPLACEMENT T-CAP; INSTALLED REPAIR PSDR AWXA200301364Floorbeam · corrodedDURING C-21 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER AFT LEG AT BS 947 FROM RBL 5 TO LBL 53. MAINTENANCE CUT OUT DAMAGED FLOORBEAM UPPER AFT LEG AT BS 947 FROM RBL 5 TO LBL 53; FABRICATED A FILLER AND 2 EACH REPAIR ANGLES; INSTASDR C2XA03SH408Floorbeam · corrodedSHV- DURING C-CHECK THE CENTER OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-22-10 FIGURE 203 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR EIA2003154Floorbeam · damagedEXISTING REPAIR AT UPPER DECK FLOORBEAM UPPER CHORD STA. 520 LBL 12- LBL 32 REWORK PER EIA ENGINEERING. REMOVED EXISTING REPAIR, NDT AREA, FABBED AND INSTALLED NEW REPAIR IAW ECRA 479-53-182-2.SDR SWIA200312511Floorbeam · crackedFS 280 RT FLOORBEAM RBL 9.0 IB AND OB ATTACH ANGLES CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED ANGLES IAW CRJ SRM 51-40-11. P/N: 601R31113-58SDR SWIA200312510Floorbeam · crackedFS 280 LT FLOORBEAM LBL 9.0 IB AND OB ATTACH ANGLES CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED ANGLES IAW CRJ SRM 51-40-11. P/N: 601R31113-57SDR EIA2003155Floorbeam · misrepairedEXISTING REPAIR FOUND AT UPPER DECK FLOORBEAM UPPER STA. 440 RBL 7.5 TO RBL 27 REPLACED IAW EIA ENGINEERING. REMOVED EXISTING REPAIR, NDT AREA, FABBED AND INSTALLED NEW REPAIR IAW ECRA 479-53-182-2.SDR SIMA200329703Floorbeam · corrodedDURING AN MBV INSPECTION, FOUND CORROSION ON LEFT FLOORBEAM, PREV REPAIR, AT FRAME 20. REMOVED PREVIOUS REPAIR, CORROSION LIMITED TO UPPER DOUBLER ANGLE OF PREVIOUS REPAIR. FABRICATED A DOUBLER ANGLE. REPAIR DONE IAW EMB 145, SRM 145/1142 REV 23, CHAPTER 53-SDR GTIA030872Floorbeam · corrodedFOUND CABIN FLOORBEAM, IN MID PIT, CHAFING AND CORRODED. FABRICATED REPAIR PARTS. INSTALLED REPAIR PARTS. (M)SDR EIA2003129Floorbeam · crackedBS. 340 RT UPPERDECK FLOORBEAM UPPER CHORD TO FRAME INTERFACE CRACKED AT 2ND IB HOLE. REMOVED DAMAGED, NDT AREA, FABBED AND INSTALLED REPAIR IAW ECRA 482-53-160-1.SDR EIA2003142Floorbeam · crackedUPPER DECK FLOORBEAM WEB AT BS 440 RBL CRACKED, RBL 66 CORROSION, RBL 40 CRACKED, RBL 55 CRACKED. UPPER DECK FLOORBEAM WEB BS 440, RBL 8 TO RBL 72 REPLACED IAW ECRA 482-53-191-2SDR SWAA032308Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, WL 208, RBL 59. REPAIRED FLOORBEAM UPPER CHORD PER SRM.SDR 032936542Floor Support · crackedDURING HEAVY INSPECTION THE FLOOR SUPPORT ANGLE AT FS 621 BL 41 WAS FOUND CRACKED.SDR C2XA03TY185Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE CENTER FLOORBEAM CAP AT FRAME 61 WAS FOUND TO BE CORRODED AROUND SEVERAL NUT PLATES. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM CAP IAW EMB SRM 51-40-02. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA03TY183Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE LEFT HAND FLOORBEAM AT FRAME 18 WAS FOUND TO BE CORRODED IN SEVERAL AREAS. MAINTENANCE ACCOMPLISHED A BLEND OUT REPAIR IAW EMB SRM 53-21-10 AND CPM 51-21-04, 05 AND 06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECSDR SWAA032287Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 771, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA032302Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 773, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR C2XA03SH398Floorbeam · corrodedDURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2003UALA00783Floorbeam · crackedCABIN FLOORBEAM WEB CRACKED STATION 1439, LBL 25. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND ANGLE DOUBLER.
Back to JASC 5315