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 CH1A200395023Floorbeam · corrodedFLOORBEAM AT BS 312 HAS CORROSION AROUND FASTENER HOLES BETWEEN RBL 12 TO LBL 62.SDR AALA20030433Floorbeam · corrodedTUL - FOUND TOP OF FLOORBEAM CORRODED AT STATION 1640. REMOVED DAMAGED SECTION OF BEAM. INSTALLED NEW SECTION PER SRM 51-70. (M)SDR ASOA03152Floorbeam · crackedDURING A C-CHECK IN MCN, THE FORWARD ATTACHING ANGLE ON THE RIGHT SIDE FLOORBEAM BELOW THE COCKPIT DOOR WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE FORWARD ATTACHING ANGLE ON THE RIGHT SIDE FLOORBEAM BELOW THE COCKPIT DOORSDR USAA030038Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY .75 INCH, STATION 1640 LBL 40, RBL 30 UPPER SURFACE. FULL REPLACEMENT OF UPPER STRUCTURE, ADDED WEIGHT OF REPAIR 4.3 LBS PER TR 53-15-01. (M)SDR AWXA200300474Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-15 CHECK A 4 1/2 INCH CRACK WAS FOUND ON LONGITUDINAL FLOOR BEAM RBL 45.5, RUNNING FROM BS 673 TO BS 677, INBOARD SIDE AT ATTACHMENT TO WHEEL WELL CEILING. MAINTENANCE STOP DRILLED CRACK AND PERFORMED HFEC INSPECTION TO VERIFY THESDR CH1A200395029Floorbeam · corrodedCORROSION FOUND ON CABIN FLOORBEAM AT LBL 45 & LBL 55 AT BS 1075SDR CH1A200395027Floorbeam · corrodedCORROSION FOUND ON CABIN FLOORBEAM AT LBL 12 BS 1070 TO BS 1090.SDR CH1A2003017Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM LBL 45 TO LBL 62 AT BS 1067.SDR CH1A200395028Floorbeam · corrodedCORROSION FOUND ON BS 1090 FLOORBEAM UPPER STRUCTURE AT LBL 12.SDR AUS20030463Floorbeam · corroded(AUS) FORWARD FUSELAGE FLOORBEAMS CONTAINED EXFOLIATION CORROSION IN AREA BELOW THE FORWARD CABIN FLOOR PANELS. CORROSION WAS PRESENT AT SEVERAL FASTENER HOLES ON EACH OF THE FOUR FLOORBEAMS ATBL600L, BL600R AND BL 1127R. SUSPECT CAUSED BY GALLEY SPILLAGES.SDR C2XA03SH095Butt Strap · corrodedDURING C CHECK LAVORATORY'S FLOORBEAMS UPPER SURFACE WHERE FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND REPLACED THE AFFECTED BUTTSTRAPS IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR SWAA030784Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 767 PLUS 3, LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR C2XA03SH088Floorbeam · corrodedDURING C CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH084Floorbeam · corrodedSHV-DURING C CHECK LEFT HAND OMEGA BEAM BETWEEN FRAMES 14 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED OMEGA BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA0300179Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER FLANGE AT STA 294.5, RBL 35-50. REPAIRED FLOORBEAM IAW SRM 53-10-51.SDR CALA0300177Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 20 TO RBL 4. REPAIRED IAW SRM 53-10-51.SDR CALA0300176Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED THROUGH FASTENERS AND SHIM AT STA 986.5, RBL 48. THE CORRODED SECTION WAS REMOVED AND A REPAIR WAS INSTALLED IAW ECRA 5310-03851.SDR AWXA200300407Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-1732, FORWARD SIDE OF FR 66. MAINTENANCE REMOVED CORROSION ON UPPER SURFACE OF FLOORBEAM Y-1732, AND DOOR SILL FITTING FORWARD SIDE OF FR 66; MATERIAL LOSS FOUSDR AWXA200300402Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-81 FROM FORWARD SIDE OF FR 18 TO FR 20. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED FLOORBEAM Y-81 FROM FORWARD SIDE OFSDR AWXA200300401Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-1292, FORWARD AND AFT SIDE OF FR 67. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED FLOORBEAM Y-1292, FORWARD AND AFT SIDESDR AWXA200300400Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK FILIFORM CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-1292, FORWARD AND AFT SIDE OF FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED FLOORBEAM Y-1292, FORWARD AND AFT SIDESDR AWXA200300399Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-1292, FORWARD SIDE OF FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED FLOORBEAM Y-1292, FORWARD SIDE OF FR 68 TO SDR AWXA200300391Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-1292 FROM AFT SIDE OF FR 66 TO AFT SIDE OF FR 67. MAINTENANCE REMOVED CORROSION ON UPPER SURFACE OF FLOORBEAM Y-1292 AT FR 66 TO FR 67 AND FOUND MATERIAL LOSDR AWXA200300390Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-765 AT FR 16. MAINTENANCE REMOVED CORROSION ON UPPER SURFACE OF FLOORBEAM Y-765 AT FR 16 AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. CUT OUT DAMAGED SECTISDR AWXA200300372Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM SUPPORT ANGLE BS 405, RBL 26-47. MAINTENANCE REMOVED DAMAGED FLOORBEAM SUPPORT ANGLE BS 405, RBL 26-47; FABRICATED A NEW REPLACEMENT SUPPORT ANGLE; INSTALLED REPAIR PART IAW BSDR CALA0300166Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 1016, LBL 30. REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR SIMA200309605Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON THE LEFT FLOORBEAM BETWEEN FRAMES 24 AND 25. REMOVED CORROSION BY PERFORMING A 4.5 INCH CUTOUT. FABRICATED A DOUBLER ANGLE, FILLER AND TWO SHIMS. REPAIR DONE IAW EMB 145 SRM 145/1142 REV 20, 53-21-10, AND SDR 03FDEA00364Floorbeam · corrodedCORROSION ON BS 344 FLOORBEAM LBL 55 - RBL 15 WL 208. REMOVED CORROSION ON UPPER CHORD OF FLOORBEAM BS 344 LBL 55 - RBL 15, WL 208 MAX REMOVAL 1 X 1 X 0.030 INCH ORIGINAL THICKNESS 0.090 OUT OF LIMITS IAW SRM 51-10-6 &7 SRM 53-10-1. ACCOMPLSDR 03FDEA00365Floorbeam · corrodedCORROSION ON BS 680 FLOORBEAM, LBL 5 TO LBL 43, WL 208. REMOVED CORROSION, BS 680 FLOORBEAM UPPER CHORD AT NUTPLATE LOCATIONS LBL 5 TO LBL 43. ORIGINAL THICKNESS OF .130 MAX DEPTH OF REMOVAL LBL 27-29 FOUND TO BE .032. OUT OF LIMITS PER B727 SRM 53-SDR CALA0300164Floorbeam · corrodedINSPECTION FOUND TOP SURFACE OF TOP CAP OF LATERAL FLOORBEAM AT STA 1016 CORRODED AT LT SIDE AREA UNDER LAV TANK. REPAIRED IAW ECRA 5310-03851.SDR 03FDEA00361Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1070 RBL 1 RBL 44, WL 201 AT FASTENER HOLES. REMOVED CORROSION ON LOWER FLOORBEAM BS 1070 RBL 1-44 AT FASTENER HOLES. ORIGINAL THICKNESS .130 REMOVED .010 MAX MATERIAL IN A 1 X 1 AREA RBL 1-RBL 26 & RBL 31-44 IN LIMITSSDR 03FDEA00362Floorbeam · corrodedCORROSION ON FLOORBEAM, STA 620, RBL 11, WL 208 (FASTENER HOLE). REMOVED CORROSION ON FLOORBEAM BS 620 RBL 11 WL 208 IN AN AREA OF 1 X 1 X .019 FOUND TO BE OUT OF LIMITS CUT OUT DAMAGE FABRICATED REPAIR PARTS DRILLED, ALODINED, PRIMED AND INSSDR 03FDEA00370Floorbeam · corrodedCORROSION ON UPR FLANGE OF FLOORBEAM BS 910 RBL 55 WL 208 LWR SURFACE AT NUT PLATE HOLE.SDR SWIA200311948Floorbeam · crackedFS 589 AND 605 FLOOR TRANSVERSE BEAMS LEFT SIDE ATTACH ANGLES CRACKED. FOUND DURING C CHECK INSPECTION. AFT ANGLE AT FS 605 REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00. FORWARD ANGLE AT FS 589 REPLACED IAW CRJ SRM 51-40-11, 51-40-06, 51-42-2SDR SWIA200311947Floorbeam · crackedFS 589.00 FLOORBEAM LEFT SIDE CRACKED BETWEEN LBL 42.5 AND 45.0. FOUND DURING C-CHECK INSPECTION. NDT-HFEC CARRIED OUT IAW NDTM PART 1 51-20-01. NO CRACKS NOTED. REPAIRED DAMAGE IAW CRJ REO 601R-53-61-694 REV NC. CARGO DOOR CLEARANCES CHECKED IAW CRJ AMM SDR SWIA200311941Floorbeam · crackedFOUND FS 280 BL 9.0 LEFT AND RIGHT FLOORBEAM ANGLES CRACKED. FOUND DURING C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 41-42-21 AND 51-23-00.SDR CALA0300156Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT BS 312 AND 320, R-1 DOOR THRESHOLD. REPAIRED WITH REPLACEMENT PART IAW SRM 51-40-02.SDR AWXA200300423Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y-919 AT FORWARD SIDE OF FR 66. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE WITHIN ALLOWABLE LIMITS PER AWA ER 26-5341-03105-SS1; TREATED, PRIMEDSDR AWXA200300389Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM Y-512 ON FORWARD SIDE OF FR 66 TO FR 66 + 127MM. MAINTENANCE BLENDED OUT CORROSION ON UPPER SURFACE OF FLOORBEAM Y-512, FORWARD SIDE OF FR 66; PERFORMED 10 X SDR AWXA200300385Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF RAIL Y-503, BETWEEN FR 14 AND FR 16. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED CORRODED RAIL Y-503, BETWEEN FR 14 AND FR 16. FABSDR AWXA200300366Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y189, AFT SIDE OF FR 20. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED FLOORBEAM TRACK Y189, FR 20; FABRICATED A NEW REPLACESDR CALA0300150Floorbeam · corrodedINSPECTION FOUND PASSENGER CABIN FLOORBEAM CORRODED AT BS 294.5, LBL 20 TO RBL 23. THE UPPER FLOORBEAM WAS REPLACED IAW SRM 53-10-51, FIGURE 205.SDR DHL2003741519Floorbeam · crackedDURING (C) CHECK, FUSELAGE INTERIOR FLOORBEAMS BS 640 AND BS 660 SPLICE PLATE TO MCD LWR. BEAMS ARE CRACKED 2 EACH NDT CONFIRMED.CA: 1) REMOVED FWD. PIT LT UPPER SIDEWALL GILLINER SUPPORTS FROM BS 580 TO 680. REMOVED LWR JAMB WEB ANGLE LWR EDGE FOR WEB REMSDR SWAA030681Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 767, RBL 8 TO LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR DL757030290Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 FLOORBEAM WAS FOUND WITH SEVERAL AREAS OF CORROSION. THE UPPER CAP WAS TRIMMED OFF TO REMOVE ALL DAMAGE. A NEW SECTION OF CAP WAS FABRICATED FROM ALUMINUM EXTRUSION AND INSTALLED PER ER/A 384541-14, REV A.SDR C2XA038TYFloorbeam · gougedDURING A SCHEDULED 3C INSPECTION, A GOUGE WAS DISCOVERED IN THE FLOORBEAM LOCATED JUST AFT OF THE LAV. BULKHEAD, RT SIDE. THE RT FLOORBEAM TOP CAP WAS REMOVED AND REPLACED IAW THE EMB 135/145 SRM 51-70-02. ACFT. WAS RELEASED FOR SERVICE FOLLOWING THE COMPLETIOSDR ASAA0310204Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 540-727B, LT BUTTOCK LINE 45 CORRODED. REMOVED DAMAGE AND REPAIRED IAW EA. (M)SDR ASAA0310184Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 663-727, LT BUTTOCK ONE 25 CORRODED. REMOVED AND REPLACED FLOORBEAM IAW SRM. (M)SDR ASAA0310187Floorbeam · corrodedOKC - DURING D-CHECK, FOUND FLOORBEAM AT BS 540, LEFT BUTTOCK LINE 25, LEFT BUTTOCK LINE 45 CORRODED. REMOVED AND REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0310192Floorbeam · corrodedOKC - DURING D-CHECK, FOUND FLOORBEAM TOPCAP AT BS 328, STRINGER 62L-62R CORRODED. FABRICATED AND INSTALLED NEW FLOORBEAM TOPCAP PER SRM. (M)
Back to JASC 5315