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 RAAA99B2019Floorbeam · corrodedDURING SCHEDULED C CHECK, FOUND FLOORBEAM UPPER CHORD FORWARD FLANGE LOWER SURFACE CORRODED AT BS 500 AND LBL 55. INSTALLED REPAIR IAW SRM 53-10-08 M54-306.SDR CALA9900299Floorbeam · corrodedINSPECTION FOUND TOP OF FLOORBEAM CORRODED AT STA 967, RBL 4. THE CORRODED AREA WAS REPAIRED IAW SRM 53-10-51.SDR CALA9900297Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 294 FROM LBL 32 TO LBL 51. A NEW SECTION OF FLOORBEAM WAS INSTALLED IAW SRM 53-10-51.SDR AT9900268Floorbeam · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND POPPED RIVETS AT LOWER CAP OF FLOORBEAM AT BS 965 RBL 19 TO 23 CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIRED ANGLE IAW DC-9 SRM 53-01 AND RES NR 99685.SDR AALA994048Floorbeam · corrodedAFW - FLOORBEAM AT STA 385 RBL 34 HAD CORROSION BLENDED TOP AND LOWER SURFACE BEYOND SRM LIMITS. BLENDED CORROSION FROM FLOORBOARD HOLES. ALODINED AND PRIMED. TST: 26,387 HOURS. CYCLES: 4,095. (X)SDR CALA9900267Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1640, LBL 52 TO RBL 54. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-01, PAGE 209 TO 213 AND ECRA 5321-01039.SDR AWXA9900158Floorbeam · corrodedFLOORBEAM 986.5 REQUIRES REPAIR SPLICES IAW AWA ER 3-53-1529 DUE TO CORROSION ON T-CAP. FABRICATED T-CHORDS AND REPAIRED ANGLES PER AWA ER 3-53-1529 INSTRUCTIONS, 986.5 FLOORBEAM T-CAP REPLACED RT BL TO LT BL ALL INCLUSIVE SPLICE.SDR UPS99829143Floorbeam · misdrilledINSPECTION TYPE-C3, FS 1660 FLOORBEAM AT RBL 45 HAS DOUBLE DRILLED HOLES. REPAIRED FLOORBEAM IAW DH SK808-353.SDR RRXA991258Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOORBEAM AT STA 580, BL 45 RIGHT, DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER ANGLE IAW FAA APPROVED JOSSAIR, COSDR RRXA991183Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN TOP OF W/W UNDER FLOOR BETWEEN STA 902 AND STA 920 AT BL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW EAF-MSDR GTIA9900928Floorbeam · corrodedMHV - TWO FLOORBEAM CORROSION REPAIRS REQUIRE REPLACEMENT TO ACCOMMODATE LAV FLOOR STRUCTURE MODERATE. REMOVED TWO EXISTING REPAIRS FABRICATED REPAIR ANGLE FROM 7075-T6 EXTRUSION NR S415615 CUST ORDER NR 12401 PO 30196 AND FILLERS FROM 7075T6.125 PO 62571 IAWSDR RRXA991182Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN INT UNDER FLOOR PLANK TOP OF MLG W/W AT STA 980, BL 45 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED FITTING IAW DC8 SRM 53-SDR RRXA991181Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN INT UNDER FLOOR PLANK TOP OF MLG W/W BETWEEN STA 879 TO STA 902 AT BL 69 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPASDR RRXA991180Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN INT UNDER FLOOR PLANK TOP OF MLG W/W BETWEEN STA 857 AND STA 879 AT BL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUSDR P5CA9900496Floorbeam · corrodedLEVEL 1 CORROSION FOUND ON FLOORBEAM AT BS 1580 LBL 82 TO 96. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 1.SDR P5CA9900495Floorbeam · corrodedLEVEL 1 CORROSION FOUND ON FLOORBEAM AT MAIN DECK BS 1580 LBL 34 TO 75. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 1.SDR P5CA9900494Floorbeam · corrodedLEVEL 1 CORROSION ON FLOORBEAM MAIN DECK BS 1580 LBL 9. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 1.SDR SWAA990510Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER T CHORD CRACKED AT BS 663 BL 0. REPAIRED PER SWA RA NR 1-357-0648.SDR RRXA991223Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1300 AND STA 1430 AT BL 4 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLERS IAW DC8 SRMSDR CALA9900249Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP CORRODED AROUND FASTENER HOLES AT STA 344 FROM RBL 12 TO LBL 15. REPLACED BEAM IAW SRM 53-10-51.SDR AT9900284Floorbeam · crackedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FORWARD PIT BOTTOM OF FLOORBEAM WITH PREVIOUS REPAIR GOUGED, DENTED AND APPEARS TO HAVE A CRACK RUNNING TOWARDS CENTER OF BEAM AT BS 389. CUT OUT DAMAGE AREA, HFEC VERIFIED NO FURTHER CRACKS IN THE AREA. FABRICSDR SWAA990506Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK ON FLOORBEAM AROUND NET TIE DOWN HOLE, BS 787 RBL 14. REPAIRED PER SRM.SDR SWAA990505Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM AROUND SCREW HOLE, BS 727 RBL 8. REPAIRED PER SRM.SDR RRXA991178Floor Beam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TOP SIDE OF PRESSURE WEB AND FLOOR BEAM JOINT AT STA 920, BL 67 RIGHT.. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAWSDR RRXA991177Floor Beam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, TOP SIDE OF PRESSURE WEB AND FLOOR BEAM JOINT AT STA 940, BL 67 RIGHT.. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAWSDR UPS99829116Floorbeam · corrodedINSPECTION TYPE-C3, FLOORBEAM HAS HEAVY CORROSION ON THE UPPER FLANGE AT FS 1300, LBL 48. REPAIRED FLOORBEAM IAW DH SK808-870.SDR UPS99829105Floorbeam · corrodedINSPECTION TYPE:C3 FS 1580 AT LBL 48, THE FLOORBEAM UPPER FLANGE IS CORRODED BEYOND LIMITS. REPAIRED FLOORBEAM IAW DH SK808-839.SDR UPS99829059Floorbeam · corrodedINSPECTION TYPE-C123, STA 1300 AT RBL 36, THE FLOORBEAM HAS HEAVY CORROSION. REPAIRED AREA IAW DH SK 808-576.SDR RRXA991203Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 730 AND BL 54 RIGHT, WL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 51-1-8 PAGESDR CALA9900244Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP CORRODED AT STA 312 FROM LBL 10 TO RBL 10. THE CORRODED SECTION WAS REMOVED AND FILLER AND DOUBLERS WERE INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR ABXA9900261Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM CORRODED AT STATION 370 AND BL 0 TO LBL 17. REPAIRED FLOORBEAM IAW ABX REA D953-27043.SDR AALA994047Floorbeam · corrodedAFW - FLOORBEAM AT STA 325 RBL 34 HAD CORROSION BLENDED. FLOORBEAM AT STA 325 RBL 34 HAD CORROSION BLENDED, TOP AND LOWER SURFACE. TST: 26,387 HOURS. CYCLES: 4,095. (X)SDR RRXA991275Floor Board · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, FLOORBOARD, 1-1/2 AT STA 1520, BL 22 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 FIG 10 PGS 3SDR MZZA99072Floorbeam · corrodedTNN - DURING D-CHECK INSPECTION ON AIRCRAFT AT AIR ASIA, IG CORROSION WAS FOUND ON NR 6A GALLEY FLOORBEAM BETWEEN RBL 32 AND RBL 44 AT BS 1130. THE CORROSION WAS REMOVED AND REPAIRED PER SRM 53-10-08 AND 51-10-02. (M)SDR USAA99293Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION AT STATION 773 RBL 3, 1 INCH BY 1 INCH AT NUTPLATE HOLES OF FLOOR SUPPORT. REPAIRED PER TR 53-10-06. (M)SDR USAA990295Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 8 INCH AREA OF CORROSION AT BS 747 RBBL 13.8 FLOORBEAM. INSTALLED TIE DOWN TRACK PER SRM 53-00-53 FIG 202. (M)SDR USAA990294Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION AT BSL 859 LBL 3 FLOORBEAM. INSTALLED DOUBLER PER TR 53-10-06. (M)SDR USAA990292Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION AT STATION 312 AND 328 LBL 11 FLOOR SUPPORT. REPAIRED PER SRM 51-10-2. (M)SDR USAA990138Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION .5 BY .5 INCH AT BS 967 RBL 18 FLOORBEAM, CORROSION TASK NR C53-107-02. INSTALLED 'T' CAP WITH REPAIR ANGLES PER TR 53-10-05. (M)SDR USAA990137Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION .5 BY .5 INCH AT BS 947 LBL 15 RBL 15 AROUND NUT PLATE HOLES FLOORBEAM. CORROSION TASK NR C53-107-02. INSTALLED 'T' CAP WITH REPAIR ANGLES PER SRM 53-00-5 FIG 202. (M)SDR TWAA9903906Support · corrodedDURING OP 16 MAINT CHECK, FOUND FLOOR SUPPORT CORRODED TOP AND BOTTOM SIDES AT STA 160 TO 200, RBL 44 IN. REPLACED PART PER SPM 6-70-1 AR 2 FROM STA 160 TO 200.SDR UPS99829028Floorbeam · corrodedINSPECTION TYPE-C1, STA 1700 FLOORBEAM IS CORRODED OUT OF LIMITS AT LBL 24. REPAIRED AREA IAW DHC SK 811-528.SDR UPS99229091Floorbeam · corrodedINSPECTION TYPE:C CORROSION (C53-113-01.00-01) ON CARGO FLOOR SUPPORT BS 575, LBL 15 WL 156. FABRICATED REPAIR PARTS PER SRM 53-10-5 AND INSTALLED PER SRM 53-10-5.SDR RRXA991207Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 1480 AND BL 34 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC8 SRM 53-2-3 PAGES 39/40 FIG 1SDR RRXA991206Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1420 AND STA 1460 AT BL 6 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC8 SRM 53-2-3 PSDR RRXA991205Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 880, BL 35 RIGHT AND WL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC8 SRM 53-2-3 PAGES 39/40SDR RRXA991204Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 640 AND BL 28 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 51-1-8 PG 1, 53-2SDR RRXA991202Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 730 AND STA 760 AT BL 36 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 5SDR RRXA991201Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 717 AND STA 730 AT BL 36 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABARICATED AND INSTALLED DOUBLER IAW DC8 SRM 52-2-3 SDR RRXA991200Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANT AT STA 720 AND BL 20 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 FIG 10 PGS
Back to JASC 5315