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 COMA0010376Buttstrap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131-01Z THE FORWARD LH FLOOR SUPPORT BUTTSTRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL MANUAL STANDARD PRACTICES.SDR COMA0010375Buttstrap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131/132-01Z THE FORWARD CENTER FLOOR SUPPORT BUTTSTRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT #1671-1, REV. 1, 1-28-97.SDR COMA0010398Sill · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 151-01Z THE LT FLOOR SUPPORT SILL WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010397Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 132-01Z THE RT FLOOR SUPPORT T-SECTION WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010392Buttstrap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 161-01Z THE CARGO COMPARTMENT ENTRY THRESHOLD BUTTSTRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3661-3, IR, 6-12-00.SDR COMA0010391Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-122-01I THE RT FLOOR PROP AT FRAME 13 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3647-1, IR, 5-3-00.SDR COMA0010390Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121-01I THE LT FLOOR PROP AT FRAME 12 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3647-1, IR, 5-3-00.SDR COMA0010388Sill · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 164-01Z THE RT FLOOR SUPPORT SILL WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010387Sill · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 162-01Z THE RT FLOOR SUPPORT SILL WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010386Crossbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 152-01Z THE RT FLOOR SUPPORT CROSSBEAM WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010385Crossbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 151-01Z THE LT FLOOR SUPPORT CROSSBEAM WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010384Crossbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 145-01Z THE LT FLOOR SUPPORT CROSSBEAM WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010383Sill · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 141-01Z THE LT FLOOR SUPPORT SILL WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010381Buttstrap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 141-01Z THE LT FLOOR SUPPORT BUTTSTRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL PRACTICES.SDR COMA0010380Buttstrap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131/132-01Z THE CENTER FLOOR SUPPORT BUTTSTRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010379T-Section · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 132-01Z THE RT FLOOR SUPPORT T-SECTION AT FRAME 16 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL PRACTICES.SDR COMA0010378Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131-01Z THE LT FLOOR SUPPORT T-SECTION AT FRAME 16 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR SCNA00387Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OF LIMITS ON THE FLOORBEAM AT STA 344 RBL 12 THROUGH 24. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SECTION IAW B727 SRM 511001 AND 531008. FABRICATED NEW FLOORBEAM REPAIR FROM BAC 15061451SDR SCNA00385Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE FLOORBEAM AT STA 380, BL 0 THROUGH RBL 24. REMOVED CORROSION IAW B727 SRM 511006. FABRICATED 1 TEE CAP FROM BAC 14902785, 1 ANGLE FROM BAC 14902831, 1 STRAP FORM BAC 15123353, AND 1SDR SCNA00384Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE FLOORBEAM AT STA 360, LBL 24 THROUGH RBL 12. REMOVED CORROSION IAW B727 SRM 511006. FABRICATED NEW REPAIR PARTS FROM BAC 1505100617, BAC 14902785, BAC 14902831, BAC 15123353 AND BACSDR SCNA00383Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON THE FLOORBEAM AT STA 440, BL 0 - RBL 12. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SECTION, FABRICATED 1 EACH T-CAP FROM BAC 1505100617, 1 ANGLE FROM BAC 14902785, 1 ANGLE SDR TWAA0017901Floor Panel · corrodedDURING CHECK-C MAINT, FOUND CORROSION AT BOTTOM OF CABIN FLOOR MEMBRANE, STA 1163, LBL 5 INCHES. REMOVED CORROSION PER SPM 6-80-01. INSTALLED REPAIR PER SRM 53-01-18. PAINTED PER SRM 51-10-03. INSTALLED FASTENERS PER SRM 51-30-05.SDR CALA0001723Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND NUT PLATE UNDER LT AFT LAV AT STA 1338. A REPAIR WAS INSTALLED IAW ECRA 5305-01051.SDR USAA001918Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, STATION 986.5, LBL 7 - LBL 31. CORROSION LEVEL 1 C 53-107-02. REMOVED AND REPLACED T-CAP PER TR 53-60-01. (M)SDR P2EA00401Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOORBEAM UPPER FLANGE AT BS 294.5 BETWEEN RBL 10-12 WL 208.5 WITH CORROSION. CONFIRMED CORROSION OUT OF LIMITS AT BS 294.5 BETWEEN RBL 10-12 WL 208.5 ON 11/20/00. (M)SDR P2EA00402Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOORBEAM UPPER FLANGE AT BS 328 BETWEEN RBL 10.75-49 WL 208.5 WITH CORROSION. CONFIRMED CORROSION OUT OF LIMITS AT BS 328 BETWEEN RBL 10.75-49 ON 11/20/00. (M)SDR P2EA00428Floorbeam · corrodedDURING Q CHECK, FORND CABIN FLOOR BEAM UPPER FLANGE AT BS 328 BETWEEN RBL 10.75-49WL 208.5 WITH CORROSION OUT O LIMITS L/40.00W/2.00 D/0.040. REPAIRED CABIN FLOOR BEAM UPPER FLANGE.SDR P2EA00430Floorbeam · corrodedDURING Q CHECK, FOUND CABIN FLOOR BEAM UPPER FLANGE AT BS 294.5 BETWEEN RBL 10,12 WL 208.5 CONFIRMED CORROSION OUT OF LIMITS ON 11/20/00 L/40.00 W/2.00 D/0.074. REPAIRED CABIN FLOOR BEAM UPPER FLANGE.SDR P2EA00429Floorbeam · corrodedDURING Q CHECK, FOUND PASSENGER CABIN FLOOR BEAM, UPPER FLANGE AT BS 334 RBL 11 TO LBL 56 WL 208.5 WITH CORROSION. OUT OF LIMITS11/15/00 L/67.00 W/2.00 D/0.025. REPAIRED PASSENGER CABIN FLOOR BEAM UPPER FLANGE.SDR P2EA00421Web · crackedDURING Q CHECK, FOUND THE CABIN FLOOR BEEM WEB AT BS 312 RBL 1 WL 207 WITH CRACK L/0.50 W/0.005. REPAIRED THE CABIN FLOOR BEEM WEB AT BS 312 RBL 1 WL207.SDR P2EA00375Floorbeam · crackedSJO - DURING Q-CHECK, FOUND THE CABIN FLOORBEAM AT BS 312 RBL 1 WL 207 WITH CRACK. (M)SDR P2EA00385Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN FLOORBEAM UPPER FLANGE AT BS 344 RBL 11 TO LBL 56 WL 208.5 WITH CORROSION. DISCOVERED TO BE OUT OF LIMITS 11/15/00. (M)SDR P2EA00374Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOOR BEAM UPPER FLANGE AT BS 294.5 BETWEEN RBL 12 AND RBL 45 WL 208.5 WITH CORROSION OUT OF LIMITS. L = 40.00 INCHES. W = 2.00 INCHES. D = 0.074 INCH. REPAIRED THE CABIN FLOOR BEAM UPPER FLANGE AT BS 294.5 BETWEEN RBLSDR USAA001911Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 4 INCHES, BL 0 LONGITUDINAL UPPER CHORD WEB WL 208, STATION 663. REMOVED DAMAGE INSTALLED DOUBLER PER SRM 51-10-02. (M)SDR CALA0001715Floorbeam · corrodedINSPECTION FOUND NUT PLATE AND FASTENER HOLE OF LT AFT CABIN FLOORBEAM CORRODED AT STA 1309, LBL 24. REPAIR ANGLES AND FILLER WERE INSTALLED IAW SRM 53-05, FIGURE 20A.SDR CALA0001713Floorbeam · corrodedINSPECTION FOUND LT AFT LAV FLOORBEAM CORRODED AT FASTENER HOLE, STA 1322, LBL 40. A REPAIR ANGLE WAS INSTALLED IAW SRM 51-30-3 AND 53-05, FIGURE 20A.SDR RRXA003674Flange · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE LOWER SIDE OF TOP FLANGE OF FLOOR SUPORT AT CLIP NUTS AT STA Y=1745 AND RBL 23, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FSDR USAA001910Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY 2 INCH, STATION 324, RBL 49-51 FORWARD EDGE T-CAP. CORROSION LEVEL 1. REPAIRED PER EA 68412. (M)SDR USAA001908Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH, BS 669, RBL 24 LONGITUDINAL UPPER CHORD. REPAIRED DOUBLER AND U-CHANNEL PER EA 68275. (M)SDR USAA001907Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH, BS 665, RBL 24 UPPER CHORD. REPAIRED DOUBLER AND U-CHANNEL PER EA 68275. (M)SDR USAA001906Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .5 INCH, BS 663, RBL 24 UPPER CHORD. REPAIRED DOUBLERS AND U-CHANNEL PER EA 68275. (M)SDR SWAA002271Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 11 - RBL 56. REPAIRED FLOORBEAM PER SRM.SDR SWAA002285Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT B/B FLOORBEAM CORRODED AT BS 770, RBL 7 & LBL 3. REPAIRED FLOORBEAM PER RA 1-A53-2021.SDR SWAA002283Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS CORRODED AT BS 344, RBL 12 - LBL 57 & BS 328, LBL 12 - RBL 56. REPAIRED FLOORBEAMS PER SRM.SDR CALA0001704Floorbeam · corrodedINSPECTION FOUND UPPER CHORD OF FLOORBEAM CORRODED AT STA 986. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03851, REV A.SDR USAA001883Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 3 INCHES, BL 0 STATION 312 CABIN FLOORBEAM LBL 18 - RBL 18. INSTALLED SPLICE ANGLES EPR SRM 52-10-51. (M)SDR USAA001884Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY 1 INCH, STATION 947 FROM LBL 12 THROUGH RBL 12 TOP SURFACE. INSTALLED NEW SECTION PER TR 53-60-02 REV A. (M)SDR AT0100039Floorbeam · corrodedFOUND FLOOR SUPPORT BEAM AT BS 996 RBL 55-21 CORRODED BEYOND LIMITS. REPLACED FLOORBEAM CAP IAW 51-10-04, 51-30-02, AND 53-01 FIG 1.SDR USAA001886Floorbeam · corrodedCLT - FOUND FLOORBEAM TOP FLANGE CORRODED 1 INCH, STATION 1640, LBL 15 TO RBL 36, WL 208. CORROSION LEVEL 1. INSTALLED FABRICATED T-CAP PER SRM 53-00-51 AND TR 53-15-01. (M)SDR USAA001905Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH, 360 AND RBBL 53. INSTALLED REPAIR DOUBLER PER EA 68400. (M)
Back to JASC 5315