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 COMA0060175Floorbeam · corrodedTOP OF FLOORBEAM CAP LBL9 AT FS 280.0 TO FS 355.0 CORROSION FOUND TO BE OUT OF LIMITS. REPAIRED TO FLOORBEAM CAP IAW REO 601R-53-00-027.SDR COMA0060174Floorbeam · corrodedTOP OF FLOORBEAM CAP RBL 27 AT FS 280 TO 355 CORRODED BEYOND LIMITS. REPAIRED TOP FLOORBEAM CAP ON RBL 27 BETWEEN FS 280 TO 355 IAW CANADAIR REO 601R-53-00-027.SDR CALA0000178Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 1640, LBL 28 TO LBL 34. THE AREA WAS REPAIRED IAW ECRA 5321-01082.SDR CALA0000160Floorbeam · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT FS 200, BL 0 TO LBL 14. THE FLOOR SUPPORT WAS REMOVED AND A NEW ONE WAS INSTALLED IAW SRM 51-10-1, 51-10-3, AND 51-30-5.SDR CALA0000159Floorbeam · wornINSPECTION FOUND CABIN FLOORBEAM LOWER FLANGE WORN AT STA 1193 IN AFT CARGO COMPARTMENT. A REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 86.SDR 0000566740Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON MAIN DECK TRACK UPPER CHORD, HORIZONTAL FLANGE. REPAIRED PER EA67-173701.SDR RRXA003408Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE MAIN CABIN FLOOR BEAM AT FS 879.3 AND RBL 48, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SRM 51-1-20D AND 51-1-SDR RRXA000957Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 620, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL EXISITING HOLES, FABRICASDR RRXA000513Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FLOORBEAM AT STA 340 AND BL 0. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW FAA DER APPROVED ENGINEERING SKETCH SK 831-97SDR RRXA000512Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FLOORBEAM AT STA 879 AND BL 48 RIGHT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW FAA DER APPROVED ENGINEERING SKETCH SKSDR USAA0218Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A 1 INCH AREA OF CORROSION AT STATION 344, LBL 9 FLOORBEAM. CORROSION LEVEL 1. INSTALLED FILLER AND REPAIR ANGLE PER SRM 53-10-9. (M)SDR USAA0219Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION AROUND SCREW HOLES STATION 947.5 FROM LBL 17 - RBL 17 FLOORBEAM. CORROSION LEVEL 1. INSTALLED NEW T-CAP PER SRM 53-10-9, TR 53-10-05A, AND EA 66592. (M)SDR USAA0220Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A 1 INCH AREA OF CORROSION STATION 312, LBL 11 AND BL 0 FLOORBEAM T-CAP. CORROSION LEVEL 2. REPLACED T-CAP PER SRM 53-10-0 FIG 5 AND IAW 51-10-9 FIG 5. (M)SDR USAA0225Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A 46 INCH AREA OF CORROSION FLOORBEAM 986.5 BETWEEN BBL 0 - RBL 46. CORROSION LEVEL 1. TASK NR C53-107-02. REPLACED T-CAP PER TR 53-60-01 REV A. (M)SDR USAA0226Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A 2 INCH AREA OF CORROSION FLOORBEAM 986.5 LBL 17. CORROSION LEVEL 1. TASK NR C53-107-02. REPLACED T-CAP PER TR 53-60-01 REV A. (M)SDR USAA0227Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND PATCHES OF CORROSION WITHIN 34 INCHES STATION 986.5 BETWEEN LBL 17 AND RBL 17 FLOORBEAM. CORROSION LEVEL 1. TASK NR C53-107-02. REPLACED T-CAP PER TR 53-60-01 REV A. (M)SDR USAA0205Floorbeam · crackedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND SIX .5 INCH CRACKS BL 0 LONGITUDINAL FLOORBEAM WEB LOWER FASTENERS STATION 707 TO 715. REPAIRED NEW SECTION PER TR 57-10-05. (M)SDR 20000329SH013Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON TOP OF FLOORBEAM (CENTER SECTION) BS 360. (X)SDR 20000329SH012Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LOWER CHORD, UPPER/LOWER SURFACES OF BS 1130 FLOORBEAM. (X)SDR 20000329SH011Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LOWER CHORD, UPPER/LOWER SURFACES OF BS 1070 FLOORBEAM (RBL 44-LBL 44). (X)SDR TWAA0003008Floorbeam · corrodedDURING CHECK-C MAINTENANCE, AFT CABIN FOUND CUTOUT IN MEMBRANE APPROXIMATELY 5 INCHES SQUARE INVOLVING A LIGHTENING HOLE OTBD OF NUMBER 1 TRACK, LT STA 1283 TO 1286. INSTALLED MEMBRANE DOUBLER PER SRM 53-05, FIG 96 SHEET 3.SDR TWAA0003007Floorbeam · corrodedDURING CHECK-C MAINTENANCE, FOUND AFT CABIN STA 1307 FLOOR LEVEL LT SIDE, ALL THE WAY OTBD, AN OLD REPAIR WAS FULL OF CORROSION. REMOVED CORROSION PER SPM 6-80-01. MADE FILLER 0.025 7075-T6. INSTALLED MEMBRANE DOUBLER PER SRM 53-05, SHEET 3 FIG 96.SDR TWAA0003006Floorbeam · crackedDURING CHECK-C MAINTENANCE, FOUND CRACK IN AFT CABIN MEMBRANE, LEFT STA APPROX 1295, 2 INCHES INBD OF SIDEWALL, FLOOR LEVEL. REMOVED CORROSION PER SPM 6-80-01. INSTALLED MEMBRANE DOUBLER PER SRM 53-05, SHEET 3.SDR TWAA0003005Floorbeam · corrodedDURING CHECK-C MAINT IN THE AFT CABIN, AN OLD REPAIR INSTALLED WITH BLIND FASTENERS WAS ALSO SHOWING CORROSION ON LT STA 1287. REPAIR WAS INSTALLED EXTENDING FROM SIDEWALL INBOARD. REMOVED REPAIR. REMOVED CORROSION PER SRM 6-80-01. INSTALLED MEMBRANE DOUBLSDR TWAA0003004Floorbeam · crackedDURING CHECK-C MAINTENANCE, IN THE CABIN FOUND A CRACKED MEMBRANE APPROX STA 1295, FLOOR LEVEL STRINGER 18L. INSTALLED MEMBRANE DOUBLER PER SRM 53-05, FIG 96 SHEET 3.SDR RRXA001665Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE AFT LWR CARGO COMPT. TOP OF FLOORBEAM AT STA 1040, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED SDR RRXA000963Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT. TOP OF FLOORBEAM AT STA 420, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL DISCREPANT HOLES, FABRISDR RRXA000960Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT. TOP OF FLOORBEAM AT STA 480, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICASDR RRXA001528Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS MISDRILLED HOLES IN THE CABIN FLOOR AT STA 834 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLER FROM SDR UPS00831736Floorbeam · corrodedINSPECTION TYPE:C123, CORROSION ON SKIN AT FS 920L BELOW CUSP OVERWING CABIN AREA. REPLACED CORRODED SECTION OF FLOORBEAM WITH NEW IAW REO G-07058.SDR TWAA0002905Floorbeam · corrodedDURING CHECK-C MAINTENANCE, THE CABIN FLOOR SUPPORT WAS CORRODED AT STA 1110 TO 1130, AT LBL 12 INCHES. MADE NEW FLOOR SUPPORT FROM 7075-T6 PER TWA S/N 56-1850. PRIMED AND INSTALLED PER SRM 51-30-2.SDR SWAA000271Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 294.5, BL 0 TO RBL 5. REPAIRED BEAM PER SRM.SDR TWAA0002706Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON MEMBRANE BETWEEN STA 870 AND 889. INSTALLED ALUMINUM ALOY REPAIR PER SRM 53-01, PAGE 9. TREATED, PRIMED, AND PAINTED REPAIRED PER 51-10-03. REINSTALLED REMOVED CASTING.SDR TWAA0002705Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON MEMBRANE, LT SIDE BETWEEN STA 851 AND 870. TREATED, PRIMED AND PAINTED ALL AREAS WORKED PER 51-10-03. INSTALLED ALUMINUM ALLOY REPAIR PER SRM 53-01 PAGE 9.SDR UPS00231902Floorbeam · corrodedINSPECTION TYPE:C, APPROXIMATE FS 600 FLOORBEAM LBL 10 FORWARD LOWER CHORD SECTION HAS CORROSION. REMOVED CORROSION AND INSTALLED REPAIR IN ACCORDANCE WITH AVITAS ENGINEERING REPAIR ORDER AVHM-101RO-1A AND UPS ENGINEERING FILE NR 727-53 -2229.SDR UPS00231901Floorbeam · corrodedINSPECTION TYPE:C APPROXIMATE FS 600 FLOORBEAM RBL 18 FORWARD LOWER CHORD SECTION HAS CORROSION. REMOVED CORROSION, REPAIRED ANGLES IAW AVITAS ENGINEERING REPAIR ORDER NR AVHM-101RO-1A AND UPS ENGINEERING FILE NR 727-53-2229.SDR QXEA0000491Floorbeam · crackedPDX - FUSELAGE FLOORBEAM 620L HAD A CRACKED VERTICAL SUPPORT ANGLE AT OUTBOARD FLANGE OF BEAM, UNDERSIDE AT FRAME 4175. REPLACED IAW FOKKER SRM 51-31-01.SDR USAA000194Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 11 INCHES, STATION 947 FROM RBL 6 - LBL 5 FLOOR LEVEL. INSTALLED NEW T-CAP AND ANGLE PER SRM 53-00-51. (M)SDR RRXA001519Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS MISDRILLED HOLES IN THE CABIN FLOORBEAM AT STA 822 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLER FRSDR RRXA000818Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE AFT UPPER CARGO COMPT TOP OF FLOORBEAM AT STA 1420, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED STSDR USAA000193Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 7 INCHES, STATION 328, BETWEEN LBL 26 AND 33 FLOOR LEVEL. INSTALLED NEW SECTION/SPLICE PER TR 53-10-13. CORROSION LEVEL 1. (M)SDR TWAA0002704Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND LIGHT CORROSION ON TOP OF FLOOR WEB, LBL 44 IN TO 56 IN, STA 160 TO 200. REMOVED CORROSION AND PRIMED AREA PER SRM 51-10-3.SDR RRXA001529Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE CABIN FLOORBEAM AT STA 742 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLERS WITSDR UPS00231891Floorbeam · crackedINSPECTION TYPE:C, CABIN FS 870 UPPER FLANGE CRACKED IN UPPER RADIUS WHERE IT CONNECTS TO VERTICAL WEB RBL 43-RBL 47 FLOORBEAM UPPER CHORD. REPAIRED IAW WITH AVITAS ENGINEERING REPAIR ORDER NR AVHM-100RO-1 AND UPS EO FILE NR 727-53-2224. REMOVED ASSOCIATED PASDR TWAA0002703Floorbeam · corrodedDURING OP 16 MAINT CHECK, THE AFT CARGO COMPT LT FLOOR SUPPORT STRAP AT LBL 17 WAS CORRODED BEYOND LIMITS FROM STA 756 TO 927. INSTALLED NEW STRAP PER SRM 51-30 AND SRM 51-10-4 FASTENER CODE.SDR 0000842293Floorbeam · corrodedDURING ''H'' CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD. REPAIRED PER EA22-170760.SDR RRXA000961Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT. TOP OF FLOORBEAM AT STA 460, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. PLUGGED EXISITING HOLES, FABRICATED DOUBLERS FRSDR RRXA001524Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS MISDRILLED HOLES IN THE CABIN FLOORBEAM AT STA 717 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLER FSDR RRXA001522Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE CABIN FLOOR BEAM AT STA 781 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLER FROMSDR RRXA000509Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FLOORBEAM AT STA 660 AND BL 40 LEFT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW FAA DER ENGINEERING SKETCH SK 831-008.
Back to JASC 5315