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 COOSDR040019Floorbeam · crackedMAIN CARGO CABIN Y, STA 1380 FLOORBEAM UPPER CAP AFT FLANGE CRACKED.SDR COMA0460483Floorbeam · crackedLBL 27.00 FLOORBEAM CAP CRACKED. REPAIRED IAW CRJ SRM 51-40-11, 51-45-00, 51-42-10, 51-25-16, 51-41-02.SDR SWAA042449Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAMS CORRODED AT BS 344, LBL 9, BS 967, RBL 5, AND BS 986-987, LBL 26 TO LBL 35. REPAIRED FLOORBEAMS PER SRM AND ERO.SDR IXXA0500012SFloorbeam · corrodedDURING A ROUTINE C-CHECK INSPECTION FOUND FLOORBEAM CORRODED AFT CARGO COMPARTMENT AT STA FS 1520.000. A MAJOR REPAIR WAS PERFORMED. REMOVED THE CORRODED AREA AND FOUND OUT OF LIMITS IAW DC8 SRM 51-1-8 PG 17, 18 AND SRM 53-2-0 PG 2P. FABRICATED FILLER ( AL SDR IXXA0500011SFloorbeam · corrodedDURING A ROUTINE C-CHECK INSPECTION RT FUSELAGE AFT CENTER SECTION FLOORBEAM CORROSION DAMAGE STA 1480.000, RBL 47. MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION IAW DC8 SRM 51-1-8 PAGES 17, 18. FOUND OUT OF LIMITS IAW DC8 SRM 53-2-0 PG 2P. REMOVED CORRODEDSDR IXXA0500010SFloorbeam · corrodedDURING ROUTINE C-CHECK INSPECTION RT FUSELAGE AFT CENTER SECTION FLOORBEAM CORRSION DAMAGE STA 1460.000, RBL 48 WAS FOUND. REMOVED CORROSION IAW DC8 SRM 51-1-1 PAGES 17, 18, FOUND OUT OF LIMITS IAW DC8 SRM 53-2-0 PGS 20. REMOVED CORRODED AREA IAW DC8 SRM 51-SDR SWAA042437Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 967 FLOORBEAM CORRODED AT RBL 28, WL 208. REPAIRED FLOORBEAM PER ERO.SDR 04FDEA02538Floorbeam · corrodedAFT PIT, FLOORBEAM CAP BEAM AT STATION 1887.0 HAS EXFOLIATION. REMOVED FLOORBEAM IAW SRM 51-33-01 VOL II. INSTALLED NEW FLOORBEAM AGA 3849-15, (FABRICATED ON NON-ROUTINE N01875) IAW DWG AGA 3849 AND SRM 51-33-01 VOL II. REFERENCE NON-ROUTINE N01814.SDR AWXA200400962Floorbeam · corrodedDURING BC-4 CHECK, GALVANIC CORROSION WAS FOUND ON BEAM Y1292 LT BETWEEN FS 67 AND FS 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 LT, FROM FS 67 TO FS 68; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200400961Floorbeam · corrodedDURING BC-4 CHECK, GALVANIC CORROSION WAS FOUND ON BEAM Y1292 LEFT BETWEEN FS 68 AND FS 69. MAINTENANCE REMOVED CORRODED BEAM Y1292 LT, FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR SWAA042382Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 727E, RBL 3 TO LBL 12, CORRODED. REPAIRED FLOORBEAM SECTION PER EA.SDR COOSDR040029Floorbeam · damagedMAIN CARGO CABIN, BS 1070, FLOORBEAM DAMAGED. REPAIRED.SDR COOSDR040027Floorbeam · corrodedMAIN CARGO CABIN, BS 1130 FLOORBEAM UPPER AND LOWER CHORD, CORRODED.SDR COOSDR040025Floorbeam · corrodedMAIN CARGO CABIN, BS 950F, WL 208 FLOORBEAM UPPER CHORD CORRODED.SDR COOSDR040024Floorbeam · corrodedMAIN CARGO CABIN BS 720A FLOORBEAM UPPER CHORD CORRODED.SDR COOSDR040013Floorbeam · corrodedMAIN CARGO CABIN AT B STA 480 FROM RBL 62 INCHES TO LBL 65 INCHES FLOORBEAM UPPER CHORD WITH CORROSION IN SEVERAL PLACES.SDR EE4Y040009Floorbeam · corrodedMAIN CARGO CABIN, AT B STA 1050 FROM LBL 63 INCHES TO RBL 56 INCHES FLOORBEAM UPPER CHORD WITH HEAVY CORROSION IN SEVERAL PLACES.SDR 2004UALA00799Floorbeam · corrodedAFT CABIN FLOORBEAM AT BS 1640 IS CORRODED RBL 18 THRU 58. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED NEW T-CAP AND REPAIR STRAPS.SDR 04FDEA02492Floorbeam · corrodedCORROSION ON FLOORBEAM BS 312 WL 208 LBL 3-47 AT FASTENER AND NUT PLATE HOLES. REMOVED CORROSION ON FLOORBEAM STA 312, W/L 208, LBL 3-47, AT FASTENER & NUT PLATE HOLES, REMOVED 5 X 2 INCH LBL 3 FROM .090. LBL 4 4 X 2 X .0015 INCH. LBL 20 6 X 2 X .005 INCH, LSDR SWIA200413928Floorbeam · crackedRT AFT FLOORBOARD ATTACHMENT ANGLE CRACKED AT RIGHT OUTBOARD AT EDGE OF FRAME 621.0. (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED ALL REPAIR PARTS IAW REO NR 601R-53-61-117.SDR SWIA200413927Floorbeam · crackedFS 280.00 ANGLES AT RBL9/LBL9 IB AND OB ARE CRACKED. (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED NEW ANGLES AT RBL9/LBL9 AT FS 280.00 IAW CRJ SRM 51-42-13, 51-42-21, 51-22-00.SDR UIEA200400144Floorbeam · crackedDURING INCORPORATION OF SB 747-53A2459, FOUND CRACK AND OR ELONGATED FASTENER HOLES COMMON TO FRAMES AND UPPER DECK FLOORBEAM UPPER CHORDS AT BS 340/360. FLOORBEAM UPPER CHORDS AND WEBS REPAIRED PER SRM. AT BS 340, STOP DRILLED AND REPAIRED FRAME WEB. OPEN SDR C2XA04TY153Floorbeam · corrodedDURING A SCHEDULED 1C INSPECTION CORROSION WAS FOUND BETWEEN FR 24 AND FR 25 ON THE LT OMEGA BEAM. MAINTENANCE CUTOUT THE CORRODED AREA, FAB A DOUBLER AND SHIMS AND REINSTALL IAW SRM 53-21-01. ALL WORK WAS ACCOMPLISHED AND WILL BE REL. UPON COMPLETION OF ALSDR SWAA042362Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 328, RBL 20 TO RBL 50, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR C2XA04SH483Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED OUT OF LIMITS AT FRAME 20 IAW EMB 145 SRM 53-21-10. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS04443092Floorbeam · crackedINSPECTION TYPE: C, LT BS 340 UPPER DECK FLOORBEAM FOUND TWO EACH FASTENER HOLES CRACKED AT FRAME WEB BS 340 LT UPPER DECK FLOORBEAM CRACKED FRAME WEB REPAIRED AS PER HX RS R53-12-35182 & UPS EO B747-5310-20986-A.SDR UPS04443091Floorbeam · crackedINSPECTION TYPE:C, RIGHT BS 340 UPPER DECK FLOORBEAM FOUND ONE FASTENER HOLE CRACKED AT FRAME WEB. FLOORBEAM REPAIRED AS PER HX RS R53-12-135182 & UPS EO B747-5310-20986-A.SDR AWXA200400986Floorbeam · corrodedDURING C-04 CHECK, GALVANIC CORROSION WAS FOUND ON BEAM Y1292 LT BETWEEN FS 66 AND FS 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 LT FROM FS 66 TO FS 68; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200400980Floorbeam · corrodedDURING C-04 CHECK, CORROSION WAS FOUND ON Y1292 RT BETWEEN FS 66 AND FS 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 RT FROM FS 66 TO FS 68; FABRICATED A NEW REPLACEMENT BEAM PER DWG 18D53472172; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200400979Floorbeam · corrodedDURING C-04 CHECK, CORROSION WAS FOUND ON BEAM Y1292 RT AT FS 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 RT FROM FS 68 TO FS 69; FABRICATED A NEW SECTION OF REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200400976Floorbeam · corrodedDURING C-04 CHECK, GALVANIC CORROSION WAS FOUND ON BEAM Y919 LT AT FS 66. MAINTENANCE REMOVED CORRODED BEAM Y919 LT AT FS 66, INSTALLED NEW REPLACEMENT BEAM IAW A320 SRM 51-72-11.SDR C2XA04SH482Floorbeam · corrodedSHV - DURING C-CHECK, THE LEFT HAND OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 24 AND 25. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM/FILLER REPAIR IAW EMB 145 SRM 53-21-10, STEP 3, FIGURE 202. THE AIRCRAFT WAS APPROVED FOR RETURN TO SESDR C2XA04SH481Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT HAND FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM/FILLER REPAIR IAW EMB 145 SRM 53-21-10, STEP 3, FIGURE 202. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 04FDEA02474Floorbeam · corrodedCORROSION IN COCKPIT AT 25G BEAM UPPER FLANGE BS 267 WL 208. REMOVED AND REPLACED G-BEAM CHORD IAW SRM 51-30-5, 51-30-2, 51-30-8.SDR C2XA04TY152Floorbeam · corrodedDURING A SCHEDULED 1C INSPECTION, THE LT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. THE CORRODED AREA WAS SUBSEQUENTLY REMOVED AND A FILLER AND DOUBLER WAS INSTALLED IAW THE EMB SRM. ACFT WAS RELEASED FOLLOWING COMPLETION OF THE 1C INSPECTION.SDR USAA040547Floorbeam · corrodedCLT - FOUND SUPPORT ANGLE CORRODED .5 INCH BY 1 INCH AREA, STATION 1663, LBL 56.5. REPAIRED PER SRM 51-10-2. (M)SDR USAA040534Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED EMINATING FROM FASTENER HOLES, UPPER T-CHORD OF FLOORBEAM, STATION 324 AT RBL 53.5, RBL 57.5 AND RBL 59.09. CUT AND REMOVED DAMAGED SECTION OF TEE CHORD, FABRICATED REPLACEMENT PARTS AND INSTALLED PER EA 95729. (M)SDR 04FDEA02455Floorbeam · corrodedCORROSION (C53-224-01, 1) FLOORBEAM STRUCTURE BS 344 LBL 31 TO LBL 58 WL 208. *S/D* REMOVED AND REPLACED UPPER FLOORBEAM CHORD AND REPAIR ANGLES AT BS 344, LBL 65-RBL 16, WL 208 IAW SRM 27-53-007.SDR SWAA042305Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CHANNEL CRACKED AT BS 540, LBL 1, WL 208. REMOVED AND REPLACED CHANNEL SECTION PER SRM.SDR DL73S040755Floorbeam · crackedTHE UPPER CAP OF THE FS 294.5 FLOORBEAM WAS FOUND CRACKED OUTBOARD OF RBL 45. THE DAMAGED SECTION OF CAP WAS CUT OUT AT RBL 28.5 AND A NEW SECTION SPLICED IN PER ER/A 092282-14.SDR MWEA040138Clip · elongatedFLOORBEAM AND ATTACHMENT CLIP AT STATION 148.50 HAS ELONGATED HOLES APPROXIMATELY 15 INCHES RT OF AIRCRAFT CENTERLINE WHERE STICK PUSHER BRACKET BOLTS UP. FABRICATED AND INSTALLED NEW CLIP.SDR USAA040538Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 1 INCH AREA, APPROX .025 INCH DEEP, FS 1640 FLOORBEAM RBL 60 AT SCREW HOLE. REMOVED DAMAGED AREA, REPLACED T-CAP PER EA 95735. (M)SDR C2XA04TY151Attach Bracket · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CABIN TO GALLEY STEP-UP PLATE. MAINTENANCE ACCOMPLISHED A BLEND OUT REPAIR IAW SRM 53-21-10 AND CPM 51-21-04,05,06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR 0401343270Floorbeam · corrodedDURING SPECIAL VISIT FOUND CORROSION ON FLOORBEAM Y1162.5 FRAME 68. REPAIRED PER EA 32-200295.SDR C2XA04SH480Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED OUT OF LIMITS IAW SRM 53-21-10. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 04FDEA02415Floorbeam · corrodedCORROSION AT FLOORBEAM BS 950D, LBL 10 DAMAGED, WL 208 (C53-224-01, 3). BLENDED AREA AND FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. CUT OUT DAMAGE AND REPAIRED FLOORBEAM PER SRM 53-10-8 FIG 3.SDR SWAA042278Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042277Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, RBL 8 TO LBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042273Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 344, LBL 28 TO RBL 1, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR 2004UALA00803Floorbeam · corrodedMAIN CABIN AT STA 365, RBL 45 TO RBL 60, FLOORBEAM HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP REPAIR.
Back to JASC 5315