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 ASAA0440075Floorbeam · corrodedGYR - FOUND AFT GALLEY AREA STATION 947.5 FLOORBEAM HAS CORROSION AT FASTENER HOLES LBL 16 TO RBL 16. REPAIRED FLOORBEAM. (M)SDR SWIA200413055Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION CARGO PIT; FLOORBEAM ANGLE IS CRACKED; FS 621.00 RBL 38.0. REPAIRED IAW CRJ REO 601R-53-61-117 REV. A, RII 53-401.SDR 2004UALA00222Floorbeam · corrodedFLOORBEAM BETWEEN FR 19-20 IS CORRODED LBL 6. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM.SDR 2004UALA00221Floorbeam · corrodedCABIN FLOOR FRAME SUPPORT AT FR 12.24 CORRODED AT RIGHT O/B AREA. MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME.SDR CALA0400227Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM UPPER FLANGE CORRODED AT STA 344, LBL 10. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-10-51, FIGURE 206.SDR CALA0400225Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM UPPER FLANGE CORRODED AT STA 328, WL 208. A NEW FLOORBEAM SECTION WAS INSTALLED IAW SRM 53-10-51.SDR F3LA200400031Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED AFT CABIN FLOORBEAM AT STA 986 CORRODED. CORROSION ON FLOORBEAM TOP FLANGE FOUND TO BE OUT OF LIMITS PER SRM 53-60-31. REMOVED FLOORBEAM UPPER FLANGE, FABRICATED REPAIR T-CAP, ALODINED, PRIMED, PAINTED AND INSTALLED REPASDR ASOA04370Floorbeam · corrodedDURING C-CHECK, CORROSION BEYOND LIMITS WAS FOUND ON THE FLOORBEAM AT FRAME 36 NEAR THE SERVICE DOOR. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM IAW SRM 51-25-01. AIRCRAFT WAS RELEASED FROM C-CHECK ON MARCH 21, 2004.SDR ASOA04371Floorbeam · corrodedDURING C-CHECK INSPECTION, THE FLOORBEAMS AT FRAMES 38 AND 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAMS IAW SRM51-25-01. AIRCRAFT WAS RELEASED FROM C-CHECK ON MARCH 21, 2004.SDR ASO2004F00007Floorbeam · corrodedDURING C-CHECK, CORROSION BEYOND LIMITS WAS FOUND ON THE FLOORBEAM AT FRAME 36 NEAR THE SERVICE DOOR. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM IAW SRM. AIRCRAFT WAS RELEASED FORM C-CHECK ON MARCH 21, 2004. (ASOA04370)SDR ASO2004F00006Floorbeam · corrodedDURING C-CHECK INSPECTION, THE FLOORBEAMS AT FRAMES 38 AND 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAMS IAW SRM. AIRCRAFT WAS RELEASED FROM C-CHECK ON MARCH 21,2004. (ASOA04371)SDR SWAA040721Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CAP CORRODED AT BS 986.5, LBL 5 TO RBL 5. REPAIRED BEAM PER T1-453-037.SDR 04067630Floorbeam · corrodedDURING HEAVY INSPECTION LEVEL 2 CORROSION WAS IDENTIFIED AT FUSELAGE STATION 280 BETWEEN LBL 7 AND RBL 7 ON THE FORWARD FLOORBEAM ANGLE. A NEW FLOOR SUPPORT WAS FABRICATED AND INSTALLED. AIRCRAFT WILL BE RETURNED TO SERVICE UPON INSPECTION COMPLETION.SDR ASAA0410112Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORROSION AT AFT PIT FLOORBEAM AT STATION 847. REPAIR IAW SRM. (M)SDR 04068630Floorbeam · crackedDURING HEAVY INSPECTION FLOOR SUPPORT LOWER FRAME AT STATION 280 RBL 11 AND RBL 14 WAS FOUND CRACKED. THE FRAME WAS REPAIRED AND AIRCRAFT WILL BE RETURNED TO SERVICE UPON INSPECTION COMPLETION.SDR 04066630AFloorbeam · corrodedDURING HEAVY INSPECTION LEVEL 2 A CRACK WAS FOUND ON THE FLOORBEAM STRUCTURE AT FUSELAGE STATION 280 LBL 12. THE ANGLE WAS REPLACED AND AIRCRAFT WILL BE RETURNED TO SERVICE UPON INSPECTION COMPLETION.SDR 04066630Floorbeam · corrodedDURING HEAVY INSPECTION LEVEL 2 CORROSION WAS IDENTIFIED AROUND THE FLOOR SUPPORT ANGLE HOLES AT FUSELAGE STATION 280 LBL AND RBL 3. THE ANGLE WAS REPAIRED AND AIRCRAFT WILL BE RETURNED TO SERVICE UPON INSPECTION COMPLETION.SDR CALA0400217Floorbeam · corrodedINSPECTION FOUND UPPER FLANGE OF MAIN CABIN FLOORBEAM CORRODED AROUND THREE FLOORBOARD ATTACH HOLES AT STA 312, RBL 36. A REPAIR STRAP DOUBLER WAS INSTALLED IAW SRM 53-00-51.SDR SWAA040694Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER SURFACES CORRODED AT BS 344, LBL 10 TO LBL 65, BS 328, RBL 15 TO RBL 50, AND BS 312, LBL 8 TO RBL 49. REPAIRED FLOORBEAMS PER SRM.SDR ASAA0440069Floorbeam · corrodedGYR - FOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM PER SRM. (M)SDR C2XA04SH142Floorbeam · corrodedSHV - DURING C-CHECK, THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A FILLER/SHIM REPAIR IAW EMB 145 SRM 53-21-10, FIG 201, SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IXXA0400042SFloorbeam · corrodedDURING ROUTINE C-CHECK INSPECTION RT WING CENTER SECTION UPPER FLOORBEAM FLANGE CORRODED, STA. 980.000 RBL 10 INCHES. REPAIR ARE ACCOMPLISHED, PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG. 1, REMOVED CORROSION FROM UPPER FLOORBEAM FLANGE, STA 980.000 RBL. 10 INCHSDR IXXA0400038SFloorbeam · corrodedDURING ROUTINE C-CHECK INSPECTION RT WING CTR FLOORBEAM FLANGE, STA 798.000 LBL 10 IAW DC8 SRM 51-1-8 PG 17-18, IAW DC8 SRM 53-2-0 PG 2M. REMOVED DAMAGED SECTION AND FABRICATED (7075-T651 0.250) IAW DC8 SRM 51-1-21 FIG 1. PERFORMED NDT INSP, CLEANED, TREATEDSDR ASAA0440072Floorbeam · corrodedGYR - FOUND AFT GALLEY AREA, CORROSION ON STATION 967 FLOORBEAM LBL 28 AND RBL 18. REPAIRED FLOORBEAM AT STATION 967, LBL 28, RBL 18 TO LBL 27 WITHIN LIMITS. (M)SDR AWXA200400327Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM AT BS 344, LBL 11, WL 208. MAINTENANCE CUT OUT DAMAGE ON UPPER SURFACE OF FLOORBEAM AT BS 344, LBL 11; FABRICATED A FILLER AND 2 REPAIR ANGLES; INSTALLED REPAIR PARTS IAWSDR AWXA200400321Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON UPPER CHORD OF FLOORBEAM AT BS 328, RBL 27 TO RBL 50, WL 208. MAINTENANCE REMOVED DAMAGED SECTION FLOORBEAM UPPER CHORD AT BS 328, FROM RBL 27 TO RBL 50. FABRICATED 5 REPAIR ANGLES AND NEW REPLACESDR F3LA200400027Floorbeam · damagedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM DAMAGE UNDER PHENOLIC BLOCK AT STA 986, LBL 45. REMOVED DAMAGED FLOORBEAM, LOCATED HOLES FOR NEW FLOORBEAM AND INSTALLED NEW BEAM PER SRM 51-40-02.SDR F3LA200400024Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 950, RBL 26 TO RBL 49, WL 208 CORRODED AT FLOORBOARD HOLES. FABRICATED AND INSTALLED REPLACEMENT FLOORBEAM PER SRM 53-60-51 AND 51-10-02.SDR F3LA200400022Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED AFT GALLEY FLOORBEAM WEB CORRODED AT STA 986.5, LBL 42. FABRICATED AND INSTALLED REPLACEMENT WEB PER SRM 53-60-51, 51-40-02, MM 51-21-41 AND BOLD DRAWING 65-46812.SDR F3LA200400021Floor Support · corrodedDURING C-7 CHECK, INSPECTION REPORTED FLOOR SUPPORT CORRODED AT NUT PLATE HOLES, RBL 51, STA 947 TO STA 967, WL 208. REPLACED FLOOR SUPPORT PER SRM 51-40-2 AND 53-60-51.SDR F3LA200400020Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED AFT FLOORBEAM AT STA 947 CORRODED ALONG GOUGE 20 INCHES EITHER SIDE OF CENTER LINE. REPLACED T-CAP PER EA B3-53R-10330 AND SRM 51-40-02.SDR F3LA200400017Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED AFT GALLEY FLOORBEAM CORRODED ON WEB AND UNDER GALLEY ATTACH POINT, RT SIDE, STA 986, RBL 42. BLENDED CORROSION ON WEB AND FOUND TO BE OUT OF LIMITS PER SRM 53-60-51. REMOVED DAMAGED SHEAR WEB AND COMMON SUPPORT ANGLES PSDR AWXA200400320Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 1.5 INCH CRACK WAS FOUND IN CENTER FLOORBEAM UPPER CHORD AT BS 663.75, LBL 7. MAINTENANCE REMOVED DAMAGED SECTION CENTER FLOORBEAM UPPER CHORD AT BS 663.75, LBL 7. FABRICATED 2 REPAIR ANGLES AND 3 STRAPS; INSTALLED RESDR SWAA040659Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 3 EA LONGITUDINAL FLOORBEAMS CRACKED AT LBL 26, BS 708, BL 0, BS 710, AND RBL 25, BS 712. REPAIRED BEAMS PER ER.SDR SIMA200407902Stringer · gougedABI - DURING AN MBV INSPECTION THE STRINGER AT SL 1501 AFT OF FRAME 363, WAS FOUND TO BE GOUGED. REMOVED DAMAGED AREA AND PERFORMED AN EDDY CURRENT INSPECTION WITH NO DEFECTS NOTED. FABRICATED A REPAIR DOUBLER FOR REPAIR. REPAIR DONE IAW SAAB SRM, 72LKS 307SDR ASAA0440050Floorbeam · corrodedCYR - AFT CARGO PIT FLOORBEAM HAS CORROSION TOPSIDE WHERE FLOORPANEL SPLICE STRAP CROSSES, AFT OF 727F, LBL 16 TO RBL 16. REPAIRED AFT PIT FLOORBEAM AT STATION 727F, RBL 16. (M)SDR UPS04842155Floorbeam · corrodedINSPECTION TYPE:C1 AFT ACCESSORY COMPT AT STA 1580 LBL B7 FLOORBEAM HAS CORROSION DOT (A5 619). REMOVED CORROSION IAW DC8 SRM 51-1-8, OUT OF LIMITS IAW DC8 SRM 53-2-0. FABRICATED ANGLE REPAIR IAW DAC TR 53-124, ALODINED AND PRIMED IAW DC8 SRM 51-1-8 AND INSTSDR USAA040060Floorbeam · corrodedTOP OF FLOORBEAM, STA 287, RBL 26, RBL53 CORROSION (3 AREAS). INSTALLED CAP IN FLOORBEAM IAW SRM 53-00-51, FIG 201.SDR SWAA040633Shear Web · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR WEB CORRODED BETWEEN RT BS 400 AND RT BS 420, ABOVE AND BELOW FLOOR LEVEL. REPAIRED SHEAR WEB PER SRM.SDR USAA040034Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 1.1 INCH BY 1.0 INCH, THREE BLOWN OUT HOLES, AFT LEFT FRAME 68-70, +Y 1292, Z=0. CORROSION LEVEL 2, TASK/CARD NR JA-260-53500. DEFECTIVE PART REPLACED WITH IDENT PART NR PER SRM 53-00-14, PAGE 106, FIG 102. (M)SDR SWIA200413041Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION, FS 280 RIGHT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED. ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21, 51-23-00 & RII 53-401.SDR SWAA040636Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 294.5, LBL 45.6. REPAIRED FLOORBEAM SECTION PER SRM.SDR SWAA040630Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 52 TO RBL 52, WL 208. REPAIRED FLOORBEAM SECTION PER SRM.SDR C2XA04SH115Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A FILLER/SHIM REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA040616Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAMS UPPER CHORD CRACKED AT BS 664, BL 0, WL 208, BS 727A, RBL 45.5, WL 208. REPAIRED CHORDS PER ER.SDR SWAA040615Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708, LBL 25, WL 203, BS 947, LBL 52, WL 208. REPAIRED WEB PER ER.SDR C2XA04SH112Floorbeam · corrodedDURING C CHECK THE LT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM/FILLER REPAIR IAW EMB 145 SRM 53-21-10, FIG 201, SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH111Floorbeam · corrodedDURING C CHECK THE GALLEY CENTER FLOORBEAM FROM FRAME 16-24 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH109Floorbeam · corrodedDURING C CHECK THE CENTER FLOORBEAM FROM FRAME 18 TO FRAME 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0440044Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM AT FS 294.5 UPPER T-CAP UPPER SURFACE HAS SEVERAL AREAS OF CORROSION FROM LBL 24 TO RBL 50. REPAIRED UPPER CHORD AT STATION 294.5 FROM LBL 24 TO RBL 50. (M)
Back to JASC 5315