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 UPS05443659Floorbeam · corrodedINSPECTION TYPE:C - FLOORBEAM BS 340 LBL 11 - 39 UPPER CHORD CORRODED. REPAIR PARTS FABRICATED AS PER SRM 53-10-07 FIG 23. CORROSION BLEND OUT 0.050 X 2 X 2 INCHES EXCEED SRM LIMIT.SDR CALA0500005Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT SCREW HOLE ON FORWARD FLANGE AT STA 986.5, RBL 43 TO RBL 44. THE CORROSION WAS REMOVED AND A REPAIR STRAP WAS INSTALLED IAW SRM 53-00-51, FIGURE 203.SDR CALA0500004Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT SCREW HOLE ON FORWARD FLANGE AT STA 986.5, RBL 29. THE CORROSION WAS REMOVED AND A STRAP REPAIR WAS INSTALLED IAW SRM 53-00-51, FIGURE 203.SDR USAA050002Floorbeam · corrodedCLT- RON- FLOORBEAM, 1 INCH SQUARE CORROSION AT FRAME 16, Y765 AT ATTACH FITTING. TRIMMED OFF DAMAGE, INSTALLED REPAIR ANGLES AND FILLER IAW EA AND SRM. (K)SDR AWXA200500143Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK, EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM UPPER CHORD AT BS 967, RBL 48, WL 208. MAINTENANCE REMOVED DAMAGE ON FLOORBEAM UPPER CHORD AT BS 967, RBL 48; FABRICATED A STRAP; INSTALLED REPAIR PART IAW B737-300 SRM 53-00SDR CALA0500026Floorbeam · corrodedINSPECTION FOUND CENTER FLOORBEAM CORRODED BETWEEN STA 345 AND 365, BL 0. THE CORRODED SECTION OF FLOORBEAM WAS REPAIRED IAW SRM 51-40-03, PARAGRAPH 4 AND 7.SDR UPS05443664Floorbeam · corrodedINSPECTION TYPE:C M/D - BS 1500 RBL 38 FLOORBEAM FOUND CORRODED. FLOORBEAM REPAIR PARTS FABRICATED PER SRM 51-40-04 FIG 1. CORROSION BLEND OUT 0.050 X 1 X 1 INCH EXCEED SRM LIMIT.SDR CALA0500023Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 1640, RBL 3. THE CORROSION WAS REMOVED AND THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR USAA050191Floorbeam · corrodedPIT - FOUND UPPER CHORD CORRODED 8 INCH BY 2 INCH, STATION 312 LBL 8 TO RBL 7 FLOOR UPPER CHORD. REPLACED UPPER CHORD PER SRM 53-10-51 FIG 205. (M)SDR UPS05843876Floorbeam · crackedFLOORBEAM LOWER FWD FLANGE HAS A 4.00 INCH CRACK F/S 920 RBL 65.0. FLOORBEAM SPLICE SEGMENT REPAIRED FROM RBL 31.40 TO RBL 70.0 IAW SAA SK 868-105.SDR AWXA200500142Attach Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1 INCH CRACK WAS FOUND IN MAIN CABIN FLOORBEAM ATTACH ANGLE AT BS 328, LBL 46. MAINTENANCE REMOVED CRACKED FLOORBEAM ATTACH ANGLE AT BS 328, LBL 46; FABRICATED A NEW REPLACEMENT ANGLE PER DWG 65-45812; INSTALLED REPAISDR ASOA05011Floorbeam · corrodedDURING A C-CHECK, THE CARGO COMPARTMENT FLOORBEAM CAP STRIP AT FS 589 BETWEEN LBL 9 AND LBL 27 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE CARGO COMPARTMENT FLOOR BEAM CAP STRIP AT FS 589 BETWEEN LBL 9 AND LBL 27. (K)SDR SWAA050029Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER T-CAP AT BS 312, LBL 12 TO LBL 13, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA050028Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM WEB AT BS 617, RBL 63, CRACKED. REMOVED AND REPLACED WEB PER SRM.SDR USAA050042Floorbeam · corrodedBFM - S1 - FLOOR BEAM/SEAT TRACK, 2.0 INCH X 1.5 INCH X .040 INCH AREA, CORROSION, LEVEL 2; TASK NR JA220-53500 BET FR 19-20, Y1292, Z240. CUT OUT DAMAGE AND INSTALLED REPAIR ANGLES IAW SRM. (K)SDR SWIA200514477Floorbeam · crackedTHE 621 LOWER ANGLE CRACKED ON LEFT SIDE. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW REO 601R-53-61-117, CRJ 200 SRM 51-42-06 PG 11, 51-42-20 PG 24-28.SDR SWAA050012Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM T-CAP AT BS 344, LBL 9, CORRODED. REMOVED AND REPLACED FLOORBEAM T-CAP PER SRM.SDR SWAA050011Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 767 + 5, LBL 13, CORRODED. REPAIRED FLOORBEAM PER EA.SDR USAA050175Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH BY .5 INCH AREAS AROUND 6 NUTPLATES, FLOORBEAM STATION 967 17L-17R. TOP CP REPAIR, FLOOR EXTRUSION AND SPLICES PER TYPICAL REPAIR 53-10-05B. (M)SDR USAA050171Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 18 INCHES LONG, LBBL 8 STATION 344. CORROSION LEVEL 1. WEB MFG PER 53-00-51 FIG 202. (M)SDR USAA050173Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY .75 INCH AREA, FLOORBEAM STATION 328 RBBL 24.50 LBBL 24.50. CORROSION LEVEL 1. REMOVED CORROSION, FABRICATED STRAP REPAIR PER SRM 53-00-51 PAGE 212-215 AND 53-10-51 PAGE 114. (M)SDR USAA050024Floorbeam · corrodedPIT - FOUND CHORD AND ANGLE CORRODED AT SCREW HOLES, STATION 344 RBBL -13 TO LBBL -24. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED T-CAP, FABRICATED NEW CHORD AND ANGLE SPLICES, INSTALLED PER SRM 53-10-51. (M)SDR USAA050114Floorbeam · corrodedPIT - Q6 - FLOORBEAM, .5 INCH X .5 INCH, CORROSION; LEVEL 1; TASK NR C53-107-01; TOP SURFACE OF FLOORBEAM 20 INCH RT OF BL0, BS312; INSTALLED BEAM DOUBLER IAW SRM. (K)SDR USAA050086Floorbeam · corrodedFLOORBEAM, 1INCH X 1 INCH AREA (2 EA) CORROSION; LEVEL 1; TASK NR C53-107-01, STA 328 FROM RBBL TO IB SEAT TRACK. REMOVED CORRODED SECTION, FABRICATED NEW AND INSTALLED IAW 53-10-51. (K)SDR USAA050040Floorbeam · corrodedBFM - S1 - FLOORBEAM, 2.0 INCH X 2.0 INCH X .027 INCH, CORROSION; LEVEL 2 TASK NR JA260-53500, MAIN CABIN FLOOR, Y1292, FR 68-66, Z240. REMOVED AND REPLACED WITH NEW PART, FLOORBEAM, IAW SRM. (K)SDR USAA050039Floorbeam · corrodedBFM - S1 - FLOORBEAM, 2.0 INCH X 2.0 INCH X .036 INCH, CORROSION; LEVEL 2; TASK NR JA260-53500, MAIN CABIN FLOOR, Y1292, FR69-68, Z240. REMOVED AND REPLACED WITH NEW PART (BEAM) IAW SRM. (K)SDR USAA050034Floorbeam · corrodedBFM - S1 - FLOORBEAM, 2.0 INCH X 2.0 INCH X .050 INCH AREA, CORROSION; LEVEL 2; TASK NR JA220-53500, MAIN CABIN FLOORBEAM AT FR21, BL Y254. INSTALLED REPAIR ANGLE AND FILLER IAW SRM. (K)SDR USAA050033Floorbeam · corrodedBFM- S1 - FLOORBEAM, 2.0 INCH X 2.0 INCH X .020 INCH AREA, CORROSION; LEVEL 2; TSK NR JA 220-53500, MAIN CABIN FLOORBEAM AT FR 20, BL Y254. INSTALLED REPAIR ANGLE AND FILLER IAW SRM. (K)SDR USAA050032Floorbeam · corrodedBFM - S1 - FLOORBEAM, 1 INCHL X 1 INCH W X .03 INCH D, CORROSION; LEVEL 2; TASK NR JA260-53500, MAIN CABIN FLOOR FR 64-66, Y1292. REMOVED AND REPLACED FLOORBEAM IAW SRM. (K)SDR USAA050031Floorbeam · corrodedBFM - S1 - FLOORBEAM, 3.0 INCH L X 2.0 INCH W X .025 INCH D, CORROSION; LEVEL 2; TASK NR JA260-53500, MAIN CABIN FLOOR, FR 68-69 Y 1292. REMOVED AND REPLACED FLOORBEAM IAW SRM. (K)SDR USAA050030Floorbeam · corrodedBFM - S1 - BEAM, 1.5 INCH L X 1.5 INCH W X .035 INCH D, CORROSION; LEVEL 2; TASK NR JA260-53500, MAIN CABIN FLOOR FR 66-68, Y1292. REMOVED AND REPLACED BEAM IAW SRM. (K)SDR USAA050029Floorbeam · corrodedBFM - S1 -FLOORBEAM, 2 INCH DIA X .04 INCH DEPTH, CORROSION; LEVEL 2; TASK NR JA-260-53500, 66-65 FRAME, Y765, MAIN CABIN FLOOR. REMOVED AND REPLACED BEAM IAW SRM. (K)SDR USAA050028Floorbeam · corrodedBFM - S1 - FLOORBEAM, 1.5 INCH L X 1.5 INCH W X .027 IN D, CORROSION; LEVEL 2; TASK NR JA-260-53500, FRAME 70 TO 66 Y765. REMOVED AND REPLACED BEAM IAW SRM. (K)SDR USAA050027Floorbeam · corrodedBFM - S1 - BEAM, 2.0 INCH X 2.0 INCH W X .02 INCH D, CORROSION; LEVEL 2; TASK NR JA-260-53500, BETWEEN FRAME 69-66, Y-765 MAIN CABIN FLOOR. REMOVED AND REPLACED BEAM IAW SRM. (K)SDR ASA0440410Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM, STA 967 LBL 14-48, WL 208. REPAIRED 967 FLOORBEAM UPPER FLANGE IAW EA. (K)SDR ASA044405Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM, STA 360. REPAIRED FLOORBEAM IAW EA. (K)SDR C2XA04SH575Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 33. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW CONTINENTAL EXPRESS EC5320-01185. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASA0440373Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM. REPAIRED IAW SRM. (K)SDR SWAA043729Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 947, BS 967 & BS 987 AFT CABIN FLOORBEAMS UPPER CHORDS CORRODED. REPAIRED FLOORBEAMS PER SRM.SDR 2004UALA01262Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP CORRODED STA 1639 TO 1641, RBL 48 TO RBL 56.SDR 2004UALA01260Floorbeam · corrodedCABIN FLOORBEAM CAP AT BS 311 CORRODED AT RBL 41.SDR 2004UALA01259Floorbeam · bulgedSTATION 1681 RT AFT DECK PLATE (FLOORBEAM) BULGED AROUND FASTENER HOLE RBL 39.5 TO RBL 40.SDR 2004UALA01258Floorbeam · corrodedCABIN FLOORBEAM T-CAP AT BS 365 CORRODED FROM BL 0 TO RBL 62, NUMEROUS AREAS.SDR AWXA200500099Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK, CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 328, FROM BL "0" TO RBL 53. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM UPPER CHORD AT BS 328, FROM BL "0" TO RBL 53; FABRICATED A NEW SDR AWXA200500068Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 344 BETWEEN LBL 15 AND RBL 10. MAINTENANCE REMOVED CORRODED UPPER CHORD AT BS 344 FROM LBL 15 TO RBL 40; FABRICATED A NEW REPLACEMENT UPPER CHSDR 04FDEA03497Floorbeam · corrodedBULK CARGO COMPT FLOOR STRUCTURE FR 67 LT TO MID RT SIDE HAS MULTIPLE AREAS OF CORROSION FROM TOP SKIN TO UNDERNEATH SURFACE. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. REMOVED AND REPLACED BEAM IAW SRM 51-40-21 AT FR 67.SDR 04FDEA03496Floorbeam · corrodedBULK CARGO COMPT FLOOR STRUCT FR 67 LEFT TO MID RIGHT SIDE HAS MULTIPLE AREAS OF CORROSION FROM TOP SKIN TO UNDERNEATH SURFACE. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. REMOVED AND REPLACED BEAM IAW SRM 51-40-21 AT FR 67.SDR ASA0440374Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM. REPAIRED CORRODED FLOORBEAM. (K)SDR SWAA043718Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 294, RBL 39 TO RBL 45, WL 208. REPAIRED FLOORBEAM PER SRM.SDR AWXA200500114Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK, CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 1016, BETWEEN RBL 4 AND RBL 34, WL 208. MAINTENANCE CUTOUT DAMAGE IN FLOORBEAM UPPER CHORD AT BS 1016, FROM RBL 4 TO RBL 34; FABRICATED A NEW
Back to JASC 5315