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 AWXA0000339Floorbeam · corrodedC-CHECK, CORROSION LEVEL 2. FLOORBEAM AT BS 328 RBL 12 - 14 CORROSION OUT OF LIMITS. REMOVED DAMAGE IAW 737 SRM 737 SRM 53-10-51, FABRICATED PART IAW 737 SRM 53-10-51, MATERIAL FILLER 7075T6 X .063 AND .080, INSTALLED IAW 737 SRM 53-10-51 FIG 206, TREATED ASDR AWXA0000338Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1. FLOORBEAM AT BS 294.5 RBL 26 TO 54 HAS CORROSION AT FASTENER HOLES ON UPPER AND LOWER SURFACE. REMOVED DAMAGE IAW 737 SRM 53-10-51, FABRICATED PARTS IAW 737 SRM 53-10-51 PG 222, TREATED AND PRIMED IAW 737 SRM 51-20-01, MATERIAL 20SDR AWXA0000337Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1. FLOORBEAM AT BS 344 BL 0 LBL 22 HAS CORROSION ON FASTENER HOLES. REMOVED DAMAGED AREA, FABRICATED REPAIR, AND INSTALLED IAW 737 SRM 53-10-51, TREATED AND PRIMED IAW 737 SRM 51-41-02, MATERIAL 7075T6 X .120 AND 7075T6 X.080 AND .SDR USAA000737Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, RBBL 0, 9 AND 12 FLOORBEAM. INSTALLED NEW T-CAP PER SRM 53-10-57. CORROSION LEVEL 2. (M)SDR USAA000736Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 30 INCHES, STATION 328, LBL 28, AND RBL 20 - RBL 50. T-CAP REPLACEMENT PER SRM 53-10-2. (M)SDR USAA000735Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED, 1 INCH BY 8 INCH, BS 259 FLOORBEAM. INSTALLED DOUBLER AND NEW T-CAP PER TR 53-10-16 AND EA 67170. CORROSION LEVEL 2. (M)SDR QXEA0001598Floorbeam · corrodedYYC- CABIN FLOOR STRUCTURE AT FRAME 3450 TO 4175 FLOORBEAM BL 1127 RT HAS A CRACKED AND CORRODED SPOT. REPAIRED IAW FOKKER SRM 53-11-05 FIGURE 3, 51-31-01 AND 53-02-14.SDR TWAA0008806Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON FLOOR MEMBRANE AT LONGERON 18L, STA 674 TO 693 AND STA 845 TO 826. REMOVED CORROSION PER SPM 6-80-01. TREATED SURFACES PER SRM 51-10-3.SDR TWAA0008713Floorbeam · corrodedDURING CHECK-C MAINT IN AFT CABIN AT STA 965 JUST UNDER I/B RIGHT LAV WALL AT LOWER SIDE OF FLOORBEAM, FOUND SUPPORT STRAP CORRODED. INSTALLED NEW SECTION OF 9912243-52 CHORD PER ARA 16725.SDR TWAA0008712Floorbeam · corrodedDURING CHECK-C MAINT IN AFT CABIN AT LOWER FWD SIDE OF CABIN FLOORBEAM, STA 965 RBL 32 IN, HAD HEAVY CORROSION. INSTALLED DOUBLER AND STRAPS PER ARA 16725.SDR SWAA000949Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 360 FLOORBEAM UPPER SURFACE CORRODED, LBL 33 TO RBL 33. REPAIRED BEAM PER SRM.SDR USAA000726Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, STATION 344 UPPER CHORD LBL 15 TO LBL 50. REPAIRED T-CAP PER TR 53-10-13. (M)SDR QXEA0001595Floorbeam · damagedYYC- CABIN FLOOR STRUCTURE AT FRAME 3820 - 3870, FLOORBEAM BL 600 RT HAS A LOOSE ANCHOR NUT AND A BROKEN SUPPORT BRACKET. REPAIRED IAW FOKKER SRM 51-31-01 AND 53-11-05.SDR SWAA000956Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 294.5 FLOORBEAM UPPER SURFACE CORRODED AROUND NUT CLIP HOLES. REPAIRED BEAM PER SRM.SDR SWAA000943Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 312 FLOORBEAM UPPER SURFACE AFT FLANGE CORRODED, LBL 10. REPAIRED BEAM PER SRM.SDR DL73K001008Floorbeam · crackedA 2.2 INCH CRACK WAS FOUND AT RBL 24.75 IN THE VERTICAL WEB OF THE FS 520 FLOORBEAM. ADDITIONALLY, A CHANNEL ON THE AFT SIDE OF THE BEAM AT LBL 24.75 WAS FOUND TO HAVE A .5 INCH CRACK. THE CHANNEL WAS REPLACED AND THE BEAM WAS REPAIRED SIMILIAR TO THAT OF SBSDR AWXA0000327Floorbeam · corrodedC-CHECK, CORROSION OUT OF LIMITS ON T-CAP AT FS 986.5 RBL 18. REMOVED DAMAGED T CAP IAW 737 SRM 51-40-02, FABRICATED T CAP FROM BAC 1505 100617/7077, IAW 737 SRM 53-00-51, TREATED AND PRIMED IAW 737 SRM 51-20-01, INSTALLED REPAIR PARTS IAW 737 SRM 53-00-51 SDR AWXA0000324Floorbeam · corrodedC-CHECK, CORROSION LEVEL 2. CABIN FLOOR SUPPORT AT FR66, Y512 LT WL 2 CORRODED BEYOND LIMITS. FABRICATED FLOOR SUPPORT IAW DRAWING D53472094002, FPI COMPLIED IAW AIRBUS NTM 51-80--00, INSTALLED REPAIR IAW A320 SRM 51-72-11, TREATED AND PRIMED IAW A320 SRMSDR RRXA003453Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE LOWER PORTION OF FLOOR BEAM AT STA 920, X-48 TO -53 AND Z-4 TO -7, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED.SDR QXEA0001611Floorbeam · crackedYYC- WEB CRACK 30MM LONG ON UPPERSIDE OF BEAM 1 BL 85L - BL 115L. REPAIRED IAW FOKKER SRM 53-02-18 FIGURE 13 AND 51-31-01.SDR QXEA0001597Floorbeam · corrodedYYC- CABIN FLOOR STRUCTURE FRAME 4610 - 4650 FLOORBEAM BL 600 RT HAS SOME CORROSION. REPAIRED IAW FOKKER SRM 53-11-05 FIGURE 4 AND 51-31-01.SDR 0002075506Floorbeam · corrodedDURING L-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 345 BL 0-LBL 21. REPAIRED PER EA 55-82848.SDR CALA0000733Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER CAP CORRODED AT NUT PLATE AT STA 986.5. A NEW T CAP AND SPLICE REPAIR WAS INSTALLED IAW ECRA 5321-01052.SDR SWAA000931Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 986 FLOORBEAM UPPER SURFACE CORRODED, LBL 55 TO RBL 45. REPAIRED BEAM PER SRM AND ER NR 00-5156.SDR RRXA003446Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE FWD UPPER FLANGE OF FLOOR BEAM AND LOWER SIDE OF FLOOR AT STA 45-55 AND LBL15-30, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. MATERIAL LOSS WISDR RRXA003445Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE FWD UPPER FLANGE OF FLOOR BEAM AND LOWER SIDE OF FLOOR AT STA 55-57 AND LBL10 TO RBL10, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8.SDR 0002065506Floorbeam · corrodedDURING L-CHECK, FOUND CORROSION ON FLOORBEAM AT FS 345 LBL 8 TO RBL 5. REPAIRED PER EA 55-176754.SDR UPS00832777Floorbeam · crackedINSPECTION TYPE:C123 STA -23 BL 0 FLOORBEAM UPPER FLANGE IS CRACKED. REPAIRED FLOORBEAM IAW SRM 53-2-0 FIG 1B.SDR MALA000344Floorbeam · corrodedFOUND DURING C-CHECK, CORROSION AT STA 258 LBL TOP OF FLOOR SUPPORT. REFER TO CELSIUS TASK 1509. MAINTENANCE REMOVED CORRODED SUPPORT ANGLE IAW SRM 51-44-21. FABRICATED NEW ANGLE FROM 2024T-3. ALODINED, PRIMED AND TOPCOATED IAW SRM 51-20-42/43, FAY SEALED SDR COMA0010108Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121-01I, THE LT FLOOR PROP AT FRAME 13 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3647-1, REV IR, 5-3-00.SDR COMA0010109Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-122-01I, THE RT FLOOR PROP AT FRAME 13 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3647-1, REV IR, 5-3-00.SDR CALA0000724Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1156, LBL 24 - LBL 42. THE FLOORBEAM WAS REMOVED AND A NEW BEAM WAS INSTALLED IAW SRM 51-10-5, 53-14-3, FIGURE 12, 51-10-3, 51-30-2.SDR CALA0000719Floorbeam · gougedINSPECTION FOUND CABIN FLOORBEAM GOUGED IN SEVERAL PLACES AT BS 986, RBL 15 - RBL 30. A REPAIR WAS INSTALLED IAW ECRA 5360-01040.SDR CALA0000717Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED AT STA 200, RBL 0 AND RBL 18. THE FLOOR SUPPORTS WERE REMOVED AND NEW SUPPORTS WERE INSTALLED IAW SRM 51-30-2, 53-14-1, FIGURE 11, 51-10-3, AND 51-30-5.SDR L1GA200000151Floorbeam · corrodedSUB FLOOR CORRODED AT FS 160 - 200 BL 44 RIGHT.SDR L1GA200000148Floorbeam · corrodedCORROSION LOCATED AT FS 200 - 218, BL 44 - 48 RIGHT.SDR AALA20000882Floorbeam · misdrilledTUL - FOUND A 1.5 INCH DIAMETER HOLE WAS MISDRILLED IN FLOORBEAM WEB AT RIGHT STATION 280. A REPAIR DOUBLER WAS INSTALLED PER ESO 11697, DATED 5/16/00. (M)SDR ASAA0080296Floorbeam · gougedPHX - DURING 30K CHECK, FOUND GOUGES WERE ON MAIN CABIN FLOORBEAM, FS 1098, BL 0 TO LBL 14. REMOVED DAMAGED MATERIAL AND INSTALLED NEW PIECES IAW DC9 SRM 53-05, FIG 20A. (M)SDR AALA20000887Floorbeam · cutTUL - FOUND FLOORBEAM HAS DAMAGE AT STATION 218 AND RBL 13 HAS CUT MARK. BLENDED DAMAGED AREA, INSTALLED DOUBLER PER SRM 53-05 PART 1 FIG 20A. (M)SDR RRXA002646Floorbeam · damagedDURING A MAINTENANCE VISIT FOUND ELONGATED HOLES TO THE FLOORBEAM TO PLANK ATTACH POINT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW EO NR 00-047 WITH APPROVED 8110-SDR RRXA002360Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM AT STA 400 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW EO NR 00-047 WITH APSDR RRXA002206Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT THE UPPER CARGO COMPT FS 1480, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR STRAPS IAW EO SDR USAA000717Floorbeam · corrodedCLT - Q-4, FLOORBEAM HAD 3 INCH CORROSION LEVEL 1. REPLACED T-CAP PER TR 53-10-04 B. (X)SDR RRXA002496Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES TO THE FLOORBEAM SPLICE AT STA 740 X+20, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW EO NR 00-047 WITH APPROVED 811SDR RRXA002473Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 380 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW EO NR 00-047 WITH APPROSDR RRXA002471Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 340 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 51-1-21 AND EOSDR RRXA002470Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 320 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW EO NR 00-047 WITH APPROSDR RRXA002467Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 580 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 51-1-21 AND EOSDR RRXA002464Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 520 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW EO NR 00-047 WITH APPROSDR RRXA002349Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 960, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED MISDRILLED HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH A
Back to JASC 5315