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 UPS05444741Floorbeam · crackedLT BS 340 UPPER DECK FLOORBEAM TO FRAME FUNCTION AREA FOUND 1EA HOLE CRACK AT FLOORBEAM UPPER CHORD APPROX 0.040 IN RUNNING DOWNWARD. CRACK LENGTH 0.040 INCH. CORROSION BLEND OUT N/A. LT BS 340 UPPER DECK FLOORBEAM UPPER CHORD REPAIRED AT LBL 35 TO LT MOST SDR MALA050510Floorbeam · corrodedDURING 4K INSPECTION IN BNA FOUND FLOORBEAM AT FS 258 IS CORRODED AND HAS BEEN REPAIRED IAW SRM 53-70-30.SDR 05FDEA01628Floorbeam · corrodedCORROSION ON FLOORBEAM LBL 25 - RBL 25 BS 620. CORROSION FOUND TO BE OUT OF LIMITS REPAIRED FLOORBEAM IAW SRM 53-10-8 FIG 3SDR 05FDEA01629Floorbeam · corrodedCORROSION ON FLOORBEAM LBL 12 BS 480. FABRICATED AND INSTALLED FLOORBEAM REPAIR LBL 12, BS 480 PER SRM 53-10-08 FIG 3SDR UPS05444795Floorbeam · corrodedBS 760 LBL 65 FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.055 BY 0.5 BY 2.5 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS. FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR UPS05444789Floorbeam · corrodedBS 980 LBL 11 TO 33 FLOORBEAM CORRODED. CORROSION BLEND OUT 0.043 BY 1.0 BY 1.5 IN. EXCEED SRM 53-10-01 FIG 1 LIMITS. FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR CALA0500204Floorbeam · corrodedINSP FOUND MAIN CABIN FLOORBEAM CORRODED AT STA 986.5, LBL 14 TO LBL 43. FLOORBEAM UPPER CAP REPAIR WAS INSTALLED IAW ECRA 5310-04471.SDR CALA0500203Floorbeam · corrodedINSP FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 986.5, LBL 45 TO RBL 45. REPAIRED FLOORBEAM IAW ECRA 5310-04472.SDR PIDA20050077Floorbeam · corrodedBS 328 FLOORBEAM HAS CORROSION FROM LBL 15 TO RBL 57 AT FASTENER HOLES. SPLICED IN NEW SECTION OF FLOORBEAM T-CAP FROM LBL 35 TO RIGHT O/B END PER SRM 53-10-9.SDR PIDA20050076Floorbeam · corrodedBS 312 FLOORBEAM HAS CORROSION FROM LBL 20 TO RBL 20 AT FASTENER HOLES. REPAIRED FLOORBEAM PER SRM 53-10-9.SDR USAA050774Floorbeam · corrodedFOUND FLOORBEAM CORRODED 3 INCHES, BS 967, LBL 43. FABRICATED NEW T-CAP FOR FLOORBEAM PER SRM 53-00-51, SAME AS PREVIOUS REPAIR. (M)SDR USAA050769Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 1 INCH, AT BS 986.5, LBL 31. REMOVED AND REPLACED UPPER T-CAP OF FLOORBEAM IAW TYPICAL REPAIR 53-10-05 AND SRM 53-00-51. (M)SDR USAA050766Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY .5 INCH, BS 986.5, WL 208, RBL 24.75 TO SIDE OF BODY. CLEANED CORROSION, BLENDED, TREATED, PRIMED AND PAINTED PER SRM 53-60-51 AND IN-59-81613-2. (M)SDR ASOA05523Floorbeam · crackedDURING A C-CHECK IN MCN, THE FLOOR SUPPORT ANGLES AT FS 621 LT/RT WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FLOOR SUPPORT ANGLES AT FS 621 LT/RT IAW ASA EO 600-53-0105. (M)SDR UPS05444801Floorbeam · crackedAFT CARGO BAY BS 1800 BL 0 AND FLOORBEAM UPPER FLANGE CRACKED. CRACK LENGTH 2.5 IN. AFT CARGO BAY BS 1800 LBL 22 TO RBL 40 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2.SDR CALA0500206Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER STRUCTURE CORRODED AT BS 680, RBL 53. REPAIRED IAW SRM 53-00-51, FIGURE 201, REPAIR 3.SDR A6WA200540202Floorbeam · crackedRIGHT SIDE FLOOR SUPPORT ANGLE AT FS 621 CRACKED APPROX 1.1 INCH LONG, RBL 41.5 WL 73. REPAIRED RIGHT SIDE FLOOR SUPPORT ANGLE AT FS 621 BY CUTTING AWAY DAMAGED AREA AND INSTALLED MG REPAIR PARTS IAW BOMBARDIER REO 601R-53-61-117 REV C. (M)SDR A6WA200540204Floorbeam · crackedLT SIDE FLOOR SUPPORT ANGLE AT FS 621 CRACKED APPROX 1.1 INCH LONG LBL 41.5, WL 73. CUT AWAY DAMAGED SECTION OF ANGLE AND INSTALLED REPAIR ANGLE IAW BOMBARDIER, INC REO 601R-53-61-117 REV C. (M)SDR USAA050761Floorbeam · corrodedPIT - S2 - FLOORBEAM, 2 INCH X 2 INCH, CORROSION; FLOORBEAM FR 16Y, 22 INCH. REPLACED FLOORBEAM IAW SRM. (K)SDR USAA050759Floorbeam · corrodedPIT - S2 - FLOORBEAM, 1 INCH X 6 INCHES, CORRODED. FLOORBEAM LT SIDE AT STA 1162.5. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM AND EA. (K)SDR USAA050758Floorbeam · corrodedPIT - S2 - FLOORBEAMS, 1 INCH X 6 INCHES, CORROSION, FLOORBEAMS LT SIDE AT STA Y1292, FR C66. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM AND EA. (K)SDR USAA050757Floorbeam · corrodedPIT - S2 - FLOORBEAM, 1INCH X 6 INCHES AREA, CORROSION; NO LEVEL OR TASK, FLOORBEAM RT SIDE AT Y1162.5. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM AND EA. (K)SDR USAA050754Floorbeam · corrodedPIT - S2 - CABIN FLOORBEAM, 2 INCH X 2 INCH AREA, CORROSION; LEVEL 2; TASK JA-220-53500 CABIN FLOORBEAM AT FR 21-23 AT +Y254. REPLACED FLOORBEAM IAW SRM. (K)SDR USAA050763Floorbeam · corrodedPIT - S2 - FLOORBEAM .5 INCH AREA; CORROSION; LEVEL 2; TASK JA-260-53500, FRAME 16, Y-50. INSTALLED DOUBLED ANGLE AND FILLER IAW SRM.SDR ABXA050161Floorbeam · corrodedLOWER LEG OF FLOORBEAM WAS CORRODED ON UPPER AND LOWER SURFACE AT STA 313, BUTTLINE 38 RIGHT. REPAIRED FLOORBEAM IAW DC-9 SRM 53.SDR SWAA051736Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM UPPER CHORD CORRODED AT BS 328, BETWEEN LBL 28 & RBL 49. REPAIRED FLOORBEAM PER SRM.SDR SWAA051735Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM UPPER CHORD CORRODED AT BS 312, BETWEEN RBL 8 & RBL 35. REPAIRED FLOORBEAM PER SRM.SDR SWAA051734Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM UPPER CHORD CORRODED AT BS 294.5, BETWEEN LBL 7.5 & RBL 7.5. REPAIRED FLOORBEAM PER SRM.SDR COMA0570065Floorbeam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL 36 TO RBL 36 CORRODED ALONG UPPER AND LOWER EDGES. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER REO 670-53-11-047 REV C.SDR ASAA0510139Floorbeam · corrodedYXX - AFT CARGO PIT FLOOR SUPPORT BEAM TIE DOWN AREA AND ANCHOR NUT HOLES HAVE CORROSION AT BS 787 RBL 14. FLOORBEAM SECTION REPLACED IAW B737-200 SRM. (M)SDR ASAA0510130Floorbeam · corrodedCORROSION ON FLOORBEAM AT B-STA 727B, RBL 10-21. CORROSION REPAIRED IAW SRM. (K)SDR SWIA200515825Floorbeam · crackedFOUND FLOOR SUPPORT ANGLE AT FS 621.00 LEFT IS CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPAIR CRACKED SUPPORT ANGLE IAW CRJ REO 601R-53-61-117 REV "B".SDR SWIA200515824Floorbeam · crackedFOUND FLOORBEAM ANGLE AT FS 621.00 RT IS CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPAIRED CRACKED FLOOR SUPPORT ANGLE IAW CRJ REO 601R-53-61-117 REV "B".SDR SWIA200515823Floorbeam · crackedFOUND FS 280 AT RBL 9 O/B FLOORBEAM ATTACH ANGLE IS CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11, 51-25-01.SDR CALA0500197Floorbeam · corrodedINSPECTION FOUND UPPER CHORD OF FLOORBEAM CORRODED AT BS 720 FROM RBL 24-52. REPAIRED IAW SRM 53-00-51, FIGURE 201.SDR CALA0500192Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 14.5. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-60-51.SDR AWXA200500758Floorbeam · corrodedDURING C-13 CHECK FOUND CORROSION ON FLOORBEAM AT BS 312, WL 208, BL 12R. MAINTENANCE REMOVED CORROSION ON FLOORBEAM AT BS 312, WL 208, BL 12R AND FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-10-51-2 FIG 205. FABRICATED REPAIR ANGLES IAW BOEING 737-30SDR AWXA200500755Floorbeam · corrodedDURING C-13 CHECK, FOUND CORROSION ON FLOORBEAM STA 328, FROM BL 10R TO BL 30R. MAINTENANCE REMOVED CORROSION. FOUND CORROSION TO BE OUT OF LIMITS. REMOVED DAMAGED AREA FROM FLOORBEAM AT STA 328 IAW BOEING 7637-300 SRM 53-10-51-2 FIG 205. RECEIVED NEW UPPESDR AWXA200500733Stiffener · corrodedDURING C-13 CHECK, FOUND GALVANIC CORROSION ON FLOORBEAM STIFFENER LOCATED AT BS 325, BL 12R, WL 208. MX REMOVED CORROSION AT BS 325, BL 12R, WL 208 IAW BOEING 737-300 SRM 51-10-02 AND DETERMINED CORROSION TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-10-51-1SDR AWXA200500731Floorbeam · corrodedDURING C-13 CHECK, FOUND CORROSION ON FLOORBEAM FROM BS 986.5 TO BS 1006, WL 204, BL 16R. OUT OF LIMITS IAW BOEING 737-300 SRM 56-60-51 FIG 101. REMOVED CORRODED BEAM AT BS 986.5 TO BS 1006, WL 204, BL 16R IAW BOEING 737-300 SRM 53-60-51-1. INSTALLED NEW BESDR 2005UALA00524Floorbeam · corrodedRIGHT SIDE BS 1640 FLOORBEAM, RBL 0 - RBL 60, TOP CAP IS CORRODED. DAMAGE DUE TO CORROSION IN TYPICAL WET AREA. REMOVED CORRODED REPAIR STRAP AND INSTALLED NEW REPAIR STRAP.SDR 2005UALA00523Floorbeam · corrodedFLOORBEAM CORRODED AT STA 367, RBL 56 UPPER SURFACE. REPLACED SUPPORT 141N5161- 52 PER SRM 51-40-02.SDR 05FDEA01552Floorbeam · corrodedUPPER CARGO COMPARTMENT, FLOOR PANEL SUPPORT AT STA 1321, X= -33 TO -75 FOUND CORRODED. (PANEL 262EF AND 262LF). UPPER CARGO COMPARTMENT, FLOOR PANEL SUPPORT AT STA 1321, X= -33 TO -75 REMOVED AS PER SRM 51-35-01 VOLUME II. NEW REWORKED FLOOR PANEL SUPPORT SDR ASAA0510125Floorbeam · chafedYXX - FOUND AFT CARGO PIT FLOORBEAM HAS CORROSION ON ANCHOR NUT HOLE AFT OF BS 727B AND LBL 3. REPLACED SUPPORT BEAM. (M)SDR CALA0500190Floorbeam · corrodedINSPECTION FOUND FLOORBEAM TEE CAP CORRODED AT STA 294.5, RBL 0 TO RBL 24. A REPAIR WAS INSTALLED IAW ECRA 5321-01231.SDR 05FDEA01520Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER AFT FLANGE, BS 344, RBL 10, TO LBL 20, WL 208. *S/D* REPAIRED FLOORBEAM AT BS 344 PER FED-EX DWG SR27-53-017A.SDR SWAA051662Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 727D, BETWEEN LBL 8 TO RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR USAA050764Floorbeam · corrodedPIT - S2 - FLOOR SUPPORT ANGLE, 1 INCH X 1 INCH X .040 INCH DEEP, CORROSION; LEVEL 1; TASK JA-220-53500-004, FRAME 16, +Y65. DEFECTIVE PART REPLACED WITH IDENTICAL. (K)SDR SWAA051645Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 663, BL 0, WL 206. REPAIRED WEB PER BFG ER.SDR SWIA200515574Floorbeam · crackedFS 280 RT FLOORBEAM INBOARD AND OUTBOARD RBL 9.0 ATTACH ANGLES CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-23-00.
Back to JASC 5315