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 AALA200810534Floorbeam · crackedFLOORBOARD SUPPORT CRACKED UNDER BOARD C-14 STATION 1060. INSTALLED A SERVICEABLE SUPPORT PER SRM 51-01.SDR ASOA200801691Floorbeam · corrodedCORROSION FOUND FS 517 TO FS 533 LBL 9 FLOOR BEAM CAP. BLENDED CORROSION ON FLOORBEAM CAP FS517 - FS533 LBL9 PERCRJ 700 SRM 51-21-06. LBL9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R-00391 FOR THE REMOVAL AND REPLACEMENT OF LBLSDR ASOA200801690Floorbeam · corrodedCORROSION ON FS 501 TO FS 517 ON LBL FLOORBEAM. BLENDED OUT CORROSION ON FLOORBEAM CAP FS 501 - FS517 LBL9 PER CRJ 700 SRM 51-21-06. LBL9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R-00391 FOR THE REMOVAL AND REPLACEMENT OF LBL9SDR USAA2008120992198Floorbeam · corrodedPIT - C6 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT -Y1292, FR20. REPLACED FLOORBEAM AT -Y1292, FR20 IAW A319 SRM 51-72-11.SDR USAA2008120992197Floorbeam · corrodedPIT - C6 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT -Y1292, FR16. REPLACED FLOORBEAM AT -Y1292, FR16 IAW A319 SRM 51-72-11.SDR CALA2008120801130Floorbeam · corrodedCABIN FLOORBEAM AT STATION 328 REQUIRES A SINGLE FLANGE REPAIR, AFT SIDE FROM RBL 28 TO RBL 38 DUE TO CORROSION. REPAIRED AFT FLOORBEAM FLANGE IAW B737 SRM 53-00-51 AND MODIFIED INTERCOSTAL AT RBL 24 IAW ECRA-5321-01590.SDR USAA2008121692241Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 986.5, LBL 45 TO RBL 45. REPAIRED FLOORBEAM T-CAP AT BS 986.5, LBL 45 TO RBL 45 IAW US AIRWAYS TYPICAL REPAIR 53-60-01.SDR ASAA0874014Floorbeam · corrodedCORROSION ON FLOORBEAM BS 986.5 RBL 30 TO LBL 30 WL 208. FLOORBEAM WAS BLENDED OUT OF LIMITS RBL 30 LBL 30 AND SO UPPER CHORD WAS R&R BS 986.5 WL 208.SDR SWAA086897Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 1. REPAIRED BEAM PER SRM.SDR ASOA200801683Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 AT FS 708.00. COMPLIED WITH (BLENDING, NDT, AND FINISH RESTORATION) OF REO 670-52-00-172 ON FLOOR SUPPORT BEAM LOCATED AT FS 708, LBL9, WL73 REFER TO ATTACHED M-234 FOR WORK ACCOMPLISHED. BLENDED FLOORBEAM CAP LBL 9 FS 7SDR ASOA200801682Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 661.00 AND FS 677.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS 661.00 & FS 677.00 IAW CRJ 700 SRM 51-21-06. LBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R-00395 FOR BEAM REPLACEMESDR ASOA200801681Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 645.00 AND FS 661.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS 645.00 & FS 661.00 IAW CRJ 700 SRM 51-21-06. LBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMITS CORROSION. REFER TO W/O 105591 N/R-00395 FOR BEAM REPLACESDR ASOA200801680Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 629.00 AND FS 645.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS629.00 & FS645.00 IAW CRJ 700 SRM 51-21-06. LBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R-00395 FOR BEAM REPLACEMESDR ASOA200801679Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 613.00 AND FS 629.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS613.00 & FS629.00 IAW CRJ 700 SRM 51-21-06. LBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION . REFER TO W/O 105591 N/R-00395 FOR BEAM REPLACEMENSDR ASOA200801678Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 597.00 AND FS 613.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS597.00 & FS613.00 IAW CRJ 700 SRM 51-21-06. LBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R-00395 FOR BEAM REPLACEMENSDR ASOA200801677Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 581.00 AND FS 597.00. LBL 9 FLOORBEAM REPLACED BETWEEN FS 572.00 & 686. WORK DONE IAW CRJ 700 SRM 51-21-06, CRJ 700 SRM 51-11-00. LBL 9 FLOOR BEAM REPLACED REFER TO W/O 105591 N/R-00401 FOR WORK ACCOMPLISHED SDR ASOA200801675Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 565.00 AND FS 581.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS565.00 & 581.00 IAW CRJ 700 SRM 51-21-06.
FWD & AFT LBL9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R-00391 + N/R-0039SDR ASOA200801674Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 533.00 AND FS 549.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS533.00 & FS549.00 IAW CRJ 700 SRM 51-21-06. LBL 9 FLOOR BEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591 N/R -00391 FOR BEAM REPLACEMSDR ASOA200801673Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT LBL 9 BETWEEN FS 469.00 AND FS 485.00. REMOVED AND REPLACED FLOORBEAM AT FS 477 TO 573 PER REO 670-53-00-172 REV A, CRJ 700 SRM 51-21-06, CRJ 700 SRM 51-11-00, REO 670-53-00-029, CRJ 700 NDTM 51-20-006, CRJ 700 51-40-11, CRJ 700SDR ASOA200801672Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT RBL 9 BETWEEN FS 485.00 AND FS 501.00. FLOORBEAM RBL 9 FS 485 THRU 565 REMOVED AND REPLACED PER REO 670-53-00-172, REO 670-53-00-029, CRJ 700 SRM 51-21-06, CRJ 700 SRM 51-11-00, CRJ 700 NDTM 51-20-006, REO 670-53-31-124.SDR ASOA200801671Floorbeam · corrodedFLOOR SUPPORT CAP HAS CORROSION AT LBL 9 BETWEEN FS 485.00 AND FS 501.00. BLENDED FLOORBEAM CAP LBL 9 BETWEEN FS485.00 & FS501.00 IAW CRJ 700 SRM 51-21-06. REQUIRES THICKNESS CHECK. LBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFER TO W/O 105591SDR ASOA200801670Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AT RBL 9 BETWEEN FS 517.00 AND FS 533.00. BLENDED CORROSION ON FLOORBEAM CAP ON RBL 9 BETWEEN FS 517.00 & FS 533.00 IAW CRJ 700 SRM 51-21-06. REQUIRES THICKNESS CHECK. RBL 9 FLOORBEAM REPLACED DUE TO OUT OF LIMIT CORROSION. REFESDR CALA2008120801129Floorbeam · corrodedB757-53-3-0448 FLOORBEAM AT STATION 1640 HEAVILY CORRODED. REMOVED DAMAGED SECTION OF UPPER T-CHORD, FABRICATED AND INSTALLED REPAIR SECTION PER SRM 53-00-01 FIG 201, REPAIR 3.SDR DHLA2009743532Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 328, WL 208, AT RBL 44. REMOVED, FABRICATED, AND REPLACED FLOORBEAM UPPER CHORD IAW SRM 51-10-1 AND 51-30-2.SDR USAA2008121692240Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 967, RBL 4. REPAIRED FLOORBEAM T-CAP AT BS 967, RBL 4 IAW US AIRWAYS TYPICAL REPAIR 53-10-05B.SDR USAA2008122492318Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - NR 6138920 - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2008122492317Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - NR 6131422 - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 TO FR70, -Y465. REPLACED FLOORBEAM BETWEEN FR67 TO FR70, -Y465 IAW A320 SRM 51-72-11.SDR USAA2008121992280Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR12 TO FR20, -Y1292. REPLACED FLOORBEAM BETWEEN FR12 TO FR20, -Y1292 IAW SRM 51-74-00.SDR USAA2008121792248Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR66, Y1292. REPLACED FLOORBEAM AT FR66, Y1292 IAW SRM 51-72-11.SDR USAA2008121592229Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 4.5 INCHES TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 + 4.5 INCHES TO FR70, -Y765 IAW A320 SRM 51-72-11.SDR USAA2008121592228Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66 +4.5 INCHES, -Y765. REPLACED FLOORBEAM BETWEEN FR64 TO FR66 +4.5 INCHES, -Y765 IAW A320 SRM 51-72-11.SDR USAA2008120992203Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM VERTICAL STIFFENER AT BS 328, LBL 45. REPAIRED FLOORBEAM VERTICAL STIFFENER AT BS 328, LBL 45 IAW B737 SRM 51-30-01 & BOEING DRAWING 65-45812.SDR SWAA086869Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM TEE CAP CORRODED AT BS 986, BETWEEN LBL 2 TO RBL 16. REPAIRED BEAM PER SRM.SDR FDEA200812045082Floorbeam · corrodedSTA 1166 FLOORBEAM, LOWER FLANGE CORRODED RBL 53-57 AT ADEL CLAMP. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE, FABRICATED, TRIMMED, TREATED, PRIMED AND INSTALLED REPAIR PARTS. REFERENCE SRM 53-10-8/ FIG 8. THIS IS CLASSIFIED AS A MAJOR REPSDR SWAA086855Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM VERTICAL WEB CRACKED AT BS 707, LBL 25. REPAIRED BEAM PER PAE ER.SDR SWAA086843Floorbeam · corrodedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM UPPER CAP CORROED AT BS 986, LBL 5. REPAIRED BEAM PER SRM.SDR CALA2008120501127Floorbeam · corrodedCABIN - STA 325 LBL 25 - LBL 54 FLOOR SUPPORT FOUND CORRODED. CABIN STA 325 LBL 18 - LBL 59 FLOOR SUPPORT BEAM REPAIRED PER SRM 53-00-51, FIG 201, REPAIR 1 AND HFEC NO CRACK FOUND.SDR FDEA200812045081Floorbeam · corrodedMAIN DECK FLOOR BS 1176.5 CHORD HAS CORROSION ON UPPER FWD FLANGE AND INSIDE FASTENER HOLES FROM RBL 1 TO 24. REPLACED CHORD REF SRM 51-30-02, THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR SWIA200820767Floorbeam · crackedDURING C-CHECK, FS 280 FLOORBEAM CRACKED AT LBL13. REPAIRED PER REO.SDR AALA200810526Floorbeam · crackedVERTICAL FLOORBEAM SUPPORT CRACKED STATION 927 UNDER SEAT TRACK NUMBER 2. INSTALLED A SERVICABLE SUPPORT.SDR UALA2008120306738Floorbeam · corrodedBEAM 165 HAS 2EA HOLE CORRODED. REMOVED BEAM 165 AND TRANSFERRED BRACKETS TO NEW BEAM. JOINED BEAM BS 200 TO 165. INSTALLED BEAM 165 IN ACFT.SDR USAA2008120592188Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON FLOORBEAM AT FR 65 AND FR 66, -Y480. REPLACED FLOORBEAM AT FR 64 AND FR 67, BETWEEN -Y465 AND -Y480 IAW A319 SRM 51-72-11.SDR SWAA086801Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM TEE CAP CORRODED AT BS 986, BETWEEN RBL 28 TO RBL 40. REPAIRED TEE CAP PER SRM.SDR FDEA200812035065Floorbeam · corrodedMAIN DECK FLOORBEAM LWR FLANGE IS CORRODED BS 1166, RBL 10-42, WL 200. REMOVED CORROSION FROM LOWER CHORD, ORIGINAL TEE .125 REMAINING .110. REMOVED .015 OUT OF LIMITS, REMOVED DAMAGED AREA, FABRICATED REPAIR PIECES, ALODINED, PRIMED AND INSTALLED REPAIR PIESDR FDEA200812035059Floorbeam · corrodedEXISTING REPAIR WAS FOUND ON CABIN FLOORBEAM UPPER CHORD AT BS 365.25 BETWEEN RBL 18 AND RBL 54. TO EVALUATE AND REPAIR AS REQUIRED. EXISTING REPAIR EVALUATED AS PER EO F-5100-7-5001 PT1 AND FOUND REPAIR WAS PREVIOUSLY ACCOMPLISHED LIMITED REPAIR NR RS/75SDR CALA2008120301123Floorbeam · corrodedSTA 986.5 FLOORBEAM HAS CORROSION AT FASTENER HOLES LOCATED AT LBL 4 AND AT RBL 4 FWD FLANGE. REPAIRED FLOORBEAM 986.5 PER SRM 53-0051.SDR SWIA200820769Floorbeam · crackedDURING C-CHECK, FS280 FLOORBEAM CRACKED RIGHT SIDE. REPAIRED PER REO.SDR AALA200820091Floorbeam · corrodedFLOORBEAM CORRODED, REPAIRED FLOORBEAM IAW SRM 53-0-51.SDR AALA200820090Floorbeam · corrodedFLOORBEAM CORRODED, REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR ASOA200801605Floorbeam · corrodedLT 280 FLOORBEAM, UPPER SURFACE HAS MINOR CORROSION. REMOVED SURFACE CORROSION ON LT 280 FLOORBEAM, UPPER SURFACE PER SRM 51-12-00. PERFORMED UT THICKNESS MEASUREMENT OF BLEND AREA ON LEFT 280 FLOORBEAM IAW NDTM 51-20-004.
Back to JASC 5315