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 SWIA200514781Buttstrap · corrodedPILOT SIDE OUTBOARD BUTTSTRAP IS CORRODED IN SEVERAL AREAS. ITEM FOUND AT C-CHECK INSPECTION. REPLACED BUTTSTRAP IAW EMB 120 SRM 51-40-02.SDR SWIA200514772Floorbeam · corrodedFLOOR SUPPORT ANGLE CORRODED AT FRAME 38 RT SIDE. (ITEM FOUND AT C-CHECK INSPECTION.) FLOOR SUPPORT REPLACED IAW EMB 120 SRM 51-40-02.SDR 2005UALA00126Floorbeam · corrodedFLOORBEAM UPPER CAP IS CORRODED AT STA 365, RBL 16-73. SUPPLEMENTAL DATA UPDATE TYPICAL FLOORBEAM CORROSION DAMAGE. MAJOR REPAIR ACCOMPLISHED. REPAIRED USING NEW T-CAP SECTION AND SPLICE ANGLES.SDR SWAA050354Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM ZEE CHORD AT BS 270, FROM LBL 7 TO RBL 8, CORRODED. REMOVED AND REPLACED ZEE CHORD PER SRM.SDR SWAA050353Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 294, FROM RBL 37 TO RBL 54, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR SWAA050350Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 294, FROM LBL 35 TO LBL 49, CORRODED. REPAIRED FLOORBEAM SECTION PER EA.SDR SWAA050345Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967, FROM LBL 27 TO RBL 27, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA050331Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 967, RBL 18, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR AWXA200500220Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM Y765 AT FR 16. MAINTENANCE CUT OUT DAMAGED SECTION OF FLOOR SUPPORT BEAM Y765 AT FR 16; FABRICATED A NEW SECTION OF BEAM AND A SPLICE REPAIR; INSTALLED REPAIR PARTS ISDR AWXA200500219Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM Y1292 AT FR 16. MAINTENANCE CUT OUT DAMAGED SECTION OF FLOOR SUPPORT BEAM Y1292 AT FR 16; FABRICATED A NEW SECTION OF BEAM AND SPLICE REPAIR; INSTALLED REPAIR PARTS ISDR AWXA200500212Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK CORROSION WAS FOUND ON FLOORBEAM Y520 AT FR 16. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM Y520 FROM FR 12 TO FR 16; FABRICATED A NEW REPLACEMENT SECTION OF BEAM PER DWG D53112825; INSTALLED REPAIR PART IAW A320 SSDR AWXA200500210Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM -Y1292 AT FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y1292 FROM FR 68 TO FR 70; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472040; INSTALLED REPAIR PART IAW A320 SRSDR 2005UALA00124Floorbeam · corrodedCABIN FLOORBEAM STA 365 HAS CORROSION RBL 3 TO RBL 26 UPPER T-CAP. SUPPLEMENTAL DATA UPDATE DAMAGE CAUSED BY TYPICAL FLOORBEAM CORROSION. MAJOR REPAIR ACCOMPLISHED. DAMAGE TO THE T-CAP REMOVED. T-CAP REPLACEMENT SECTION FABRICATED AND INSTALLED USING SPLICSDR 2005UALA00122Floorbeam · damagedFLOORBEAM T-CAP IS DAMAGED AT STA 1640, BL-0 TO RBL 61. SUPPLEMENTAL DATA UPDATE EXISTING REPAIR REQUIRED MODIFICATION. ORIGINAL DAMAGE CAUSED BY TYPICAL FLOORBEAM CORROSION. MAJOR REPAIR ACCOMPLISHED. REMOVED EXISTING REPAIR AND INSTALLED NEW T-CAP SECTIOSDR AWXA200500207Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 AT FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 FROM FR 68 TO FR 70; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM PER DWG D53472040; INSTALLED REPAIR PART IASDR AWXA200500206Seat Track · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 AT FR 66+3 INCHES. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 FROM FR 66 TO FR 69; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM PER DWG D53472090; INSTALLED REPAISDR AWXA200500205Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM -Y765 AT FR 66. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y765 AT FR 66; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM PER DWG D53472090; INSTALLED REPAIR PART IAW A320 SRM SDR AWXA200500203Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM -Y1292 AT FR 66+8 INCHES. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y1292 FROM FR 66 TO FR 68; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM PER DWG D53472040; INSTALLED REPSDR ASOA05188Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FS 36, STRINGER 14L AND 14R AND FRAME 39, STRINGER 14L AND 14R WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FRAME 36, STRINGER 14L AND 14R IAW SRM 51-25-01. (M)SDR ASOA05187Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FRAME 38/40 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANANCE REMOVED AND REPLACED THE FLOORBEAMS AT FRAME 38/40 IAW SRM 51-25-01. (M)SDR 2005UALA00119Floorbeam · corrodedFWD CABIN FLOORBEAM HAS CORROSION AROUND FASTENERS AT STA 324, RBL 51 TO RBL 52, BEAM UPPER CAP. DAMAGE DUE TO CORROSION. MAJOR REPAIR ACCOMPLISHED. DAMAGE WAS BLENDED. ANGLE REPAIR WAS INSTALLED.SDR SWIA200514886Bracket · crackedCRACKED BRACKET FS 461 RBL 10 BELOW FLOOR. (ITEM FOUND AT C-CHECK INSPECTION.) BRACKET INSTALLED IAW SRM 53-41-43, 51-42-06 AND 51-42-21.SDR SWIA200514885Floorbeam · crackedCRACKED ANGLE AT FS 499 LBL 10 UNDER FLOORBOARD. (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED NEW ANGLE PER SRM 51-23-00 AND 51-42-21.SDR USAA050259Floorbeam · corrodedBFM - FOUND RAIL CORRODED 3 INCH BY 2 INCH BY .030 INCH DEEP, FRAME 14, -Y953 MAIN CABIN FLOOR. REMOVED AND REPLACED FLOORBEAM PER SRM 53-11-15. (M)SDR SWIA200514578Floorbeam · crackedMAIN FUSELAGE FLOORBEAM AT RBL 9.0 ATTACH ANGLES CRACKED AT FS 280.00. ITEM FOUND AT C-CHECK INSPECTION. ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-25-16, 51-23-00.SDR SWIA200514577Floorbeam · crackedMAIN FUSELAGE FLOORBEAM AT LBL 9.0 HAS OUTBOARD ATTACH ANGLE CRACKED AT FS 280.00. ITEM FOUND AT C-CHECK INSPECTION. ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-25-16, 51-23-00.SDR UPS05243890Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 680 LBL 56 FOUND ON REMOVAL OF FLOOR PANELS FOR DOOR SILL INSPECTION. REPAIR CARRIED OUT IAW SRM 51-10-2, 53-10-8, 51-20-4 AND AAAE EO 2005-01 0-004 UPS ENGINEERING FILE NR 727-53-20183.SDR SWAA050296Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 328, BETWEEN RBL 54 TO RBL 59, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA050293Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 947, LBL 20, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR 05FDEA00210Floorbeam · crackedMDDC FLOORBEAM AT FR37 LT SIDE CRACKED AT VERTICAL STIFFENER, FWD SIDE. REPAIRED FLOORBEAM BY INSTALLATION OF REPAIR ANGLES IAW A310-200 SRM 53-10-15 FIG 201, SH2.SDR SWAA050283Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT RIGHT BS 616, CRACKED. REPAIRED FLOORBEAM CHORD PER ER.SDR SWAA050281Floorbeam · crackedDURING SPV, FOUND 2 EACH CRACKS ON FLOORBEAM WEB BETWEEN BS 188 TO BS 196, AT LBL 30 AND RBL 30. REMOVED AND REPLACED WEB SECTIONS PER SRM.SDR SWAA050267Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH LONGITUDINAL FLOORBEAMS CRACKED AT BS 727A +18, BETWEEN RBL 23 AND RBL 48. REPAIRED FLOORBEAMS PER ER.SDR ABXA050028Floorbeam · corrodedFLOORBEAM CORRODED ON LOWER FLANGE STA 1013 AT CARGO DOOR UPLATCH BRACKET. REPAIRED IAW DC-9 SSRM K07411.SDR 2005UALA00106Floorbeam · corrodedCABIN FLOORBEAM HAS CORROSION REMOVAL BEYOND LIMITS AT STA 967 LBL 18. INSTALLED STRAP REPAIR.SDR SWIA200514576Floorbeam · crackedCARGO COMPARTMENT FLOOR SUPPORT ANGLE CRACKED AT FS 621.00 RLB 42.0. ITEM FOUND AT C-CHECK INSPECTION. SUPPORT ANGLE REPAIRED IAW CRJ REO 601R-53-61-117 REV "B'.SDR 05FDEA00196Floorbeam · corrodedMCD, STA 480, RBL 24.50 TO BL 0.00, FLOORBEAM HAS CORROSION. REMOVED CORROSION IAW SRM 53-10-1 FIG 4, PAGE 19, ORIG MATERIAL .140 AFTER REWORK .085 FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED AREA IAW SRM 53-10-8. MATERIAL ID AS BAC 1518-338 7075-T6 511 FABBSDR CALA0500028Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1322 UNDER RT LAV, RBL 20. THE CORRODED SECTION OF FLOORBEAM WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 79A.SDR SWAA050242Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND 2 EACH FLOORBEAMS CRACKED AND CORRODED BETWEEN BS 947 AND BS 986, LBL 53 AND RBL 48. REMOVED AND REPLACED FLOORBEAM SECTIONS PER ER.SDR F3LA200500004Floorbeam · brokenDURING C-7 CHECK, INSPECTION REPORTED FLOORBEAM AND WEB BROKEN AT STA 685 FROM LT FRAME TO SEAT TRACK BEAM. REPLACED L STUB FRAME PER SRM 51-40-02 AND 51-10-02.SDR USAA050153Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, FR 66 (Y765). INSTALLED REPAIR ANGLES IAW EA 96224. (M)SDR C2XA05SH005Floor Support · corrodedSHV - DURING C-CHECK, THE CENTER OMEGA BEAM FS 17-23 IS CORRODED. MAINTENANCE REMOVED AND REPLACED CENTER OMEGA BEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA050204Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM ZEE CHORD AT BS 270, BETWEEN LBL 11 AND RBL 11, CORRODED. REMOVED AND REPLACED ZEE CHORD PER SRM.SDR COMA0560087Floorbeam · corrodedFLOORBEAM AT RBL 27 CORRODED BEYOND LIMITS AT FS 559.00 + 32 - FS 574.00. REPAIRED IAW CRJ SRM 51-42-22, 51-21-11, 51-42-21, 51-42-13, 51-42-10.SDR AWXA200500331Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON FLOORBEAM T-CAP AT BS 986, LBL 44, WL 208. MAINTENANCE CUT OUT DAMAGE IN FLOORBEAM T-CAP AT BS 986, FROM BL 0 TO LBL 50; FABRICATED A NEW REPLACEMENT SECTION OF T-CAP, AND 2 EACH SUPPORT ANGLES & SSDR AWXA200500181Strap · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .75 INCH CRACK WAS FOUND IN STRAP LOCATED ON LOWER SIDE OF FLOORBEAM AT BS 314, LBL 11. MAINTENANCE STOP DRILLED CRACK ON STRAP; PERFORMED AN HFEC INSPECTION TO VERIFY CRACK CONTAINED; FABRICATED A REPAIR PLATE PER DWGSDR AWXA200500173Strap · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .125 INCH CRACK WAS FOUND IN STRAP LOCATED ON LOWER SIDE OF FLOORBEAM AT BS 314, BL -0-. MAINTENANCE STOP DRILLED CRACK ON STRAP; PERFORMED AN HFEC INSPECTION TO VERIFY CRACK CONTAINED; FABRICATED A REPAIR PLATE PER DWSDR AWXA200500171Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .5 INCH CRACK WAS FOUND IN ANGLE ON FORWARD SIDE OF FLOORBEAM AT BS 328, LBL 26. MAINTENANCE REMOVED CRACKED ANGLE AT BS 328, LBL 26; FABRICATED A NEW REPLACEMENT ANGLE PER DWG 65-45812; INSTALLED REPAIR PART IAW B737SDR AWXA200500333Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON FLOORBEAM T-CAP AT BS 1016, RBL 5, WL 208. MAINTENANCE CUT OUT DAMAGE IN FLOORBEAM T-CAP AT BS 1016, RBL 5; FABRICATED A 3 EACH REPAIR PLATES AND A FILLER; INSTALLED REPAIR PARTS IAW B737-300 SRM 5SDR AWXA200500295Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND LOWER SURFACE OF TRANVERSE FLOORBEAM T-CAP AT BS 986, BETWEEN RBL 40 AND RBL 44, WL 208. MAINTENANCE REMOVED CORRODED FLOORBEAM T-CAP AT BS 986 FROM RBL 0 TO RBL 50; FABRICATED A NEW REPLACEMENT SECTI
Back to JASC 5315