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 RRXA000138Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 717 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000137Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 702 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000111Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 960 FROM CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000110Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 902 CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000109Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 660 CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000108Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 680 CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000107Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 702 CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000106Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 717 CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000105Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, CABIN FLOORBEAM AT STA 742 CUSP TO CUSP, NUMEROUS DRILLED HOLES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR AALA2000208Floorbeam · corrodedTUL - FOUND AFT CARGO COMPT LATERIAL FLOOR SUPPORT BEAM CORRODED THROUGH AT FRAME 60 BETWEEN ROLLER TRAYS NR 1 AND NR 2. CUT OUT CORRODED SECTION OF FLOOR SUPPORT BEAM AND SPLICED IN NEW SECTION PER SRM 53-1015. (M)SDR RRXA001631Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 580, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLSDR RRXA001630Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 600, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLSDR P2EA00045Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 259.5, WL 208 AND BETWEEN RBL 5 AND RBL 10. REPAIRED FLOORBEAM UPPER CHORD, BETWEEN RBL 10 AND LBL 29 AIW SRM 51-40-4, FIG 1. (M)SDR TWAA0001907Floorbeam · corrodedDURING OP 16 MAINT CHECK, THE CABIN STA 1251 FLOOR SUPPORT WAS CORRODED BETWEEN NUMBER 1 AND 2 SEAT TRACKS. REMOVED CORRODED FLOOR SUPPORT AND FABRICATED PART PER SPM 6-70-01, PER DOUGLAS PN 5930544-97, AND INSTALLED PER SRM 51-30-02. TREATED AND PRIMED PER SDR QXEA0000401Floorbeam · damagedPDX - FLOORBEAM BL600R LOWER FLANGE DEFORMED BETWEEN FRAMES 16060 AND 16660. REPAIRED IAW HORIZON AIR EA 4-53-970.SDR AALA2000207Floorbeam · corrodedTUL - FLOORBOARD SUPPORT FRAME CORRODED ON LOWER FORWARD LEG FORWARD SIDE STATION 256, BETWEEN SEAT TRACKS NR 2 AND NR 3. REMOVED CORROSION UNDER FLOORBOARD SUPPORT PER SRM 53-10-1. TREATED AREA, PRIMED AND PAINTED PER 51-10-3. (M)SDR DHL2000803112Floor Support · deterioratedAT C-CHECK, AFT FUSELAGE SECTION MAIN CARGO FLOOR SUPPORT ANGLE DETERIORATED STA 1710, LBL 12 TO RBL 12. REMOVED FLOOR SUPPORT ANGLE, REBUILT AND INSTALLED ANGLE IAW SRM 51-1-20 PG 9 & 10. REF: N/R 5486.SDR QXEA0000421Floorbeam · corrodedPDX - CORROSION ON TOP OF GALLEY FLOOR SUPPORT AT NUT PLATE, FRAME 3820, BL 620R. REMOVED NUT PLATE AND CORRODED TOP PLATE. REPAIRED IAW FOKKER SRM 51-31-2 AND SRM 51-10-4, PAGE 9.SDR QXEA0000419Floorbeam · corrodedPDX - CORROSION ON TOP OF FLOORBEAM 1147R, BETWEEN FRAMES 3820 AND 4175. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH B 1-2.SDR QXEA0000183Floorbeam · corrodedPDX - CORRODED FLOOR SUPPORT FLANGE AT NUT PLATE FRAME 3820, BL 430L. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH A-1.SDR DHL200071762DFloorbeam · corrodedAT D-CK, CABIN FLOATING SEAT TRACK SUPPORT NR 4 STA 850 TO 870 RBL 45 FLANGE HAS CORROSION. REMOVED AND REPLACED CABIN FLOATING SEAT TRACK SUPPORT FROM STA 850 TO 870 PER B727 SRM 51-30-2. REF: N/R 5606.SDR RRXA000965Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 540, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLSDR RRXA000959Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 500, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED MISDRILLED AND DISCREPANT HOLES, SDR RRXA000958Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 520, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED MISDRILLED HOLES, FABRICATED DOUBLSDR RRXA001527Floorbeam · crackedDURING A MAINTENANCE VISIT, FOUND A CRACKED FLOORBEAM IN THE UPPER CARGO COMPT FS 340 AND XCW 64L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED NEW ANGLES FROM 7075-T6 AND INSTALLED IAW DC-SDR 20000425SH022Floorbeam · corrodedFOUND DURING SCHEDULED C-CHECK, CABIN FLOORBEAM STA 344 WALL-TO-WALL HAS SPOTS OF CORROSION. POSSIBLY CAUSED BY LIQUID SPILLS OR DISSIMILAR METAL CONDITION. (X)SDR 20000425SH020Floorbeam · corrodedFOUND DURING SCHEDULED C-CHECK, CABIN FLOORBEAM STA 360 BL 24 TO 24 CORROSION AT ANCHOR NUT HOLES. POSSIBLY CAUSED BY LIQUID SPILLS OR DISSIMILAR METAL CONDITION. (X)SDR 20000425SH018Floorbeam · corrodedFOUND DURING SCHEDULED C-CHECK, CABIN FLOORBEAM STA 314 BL ZERO HAS CORROSION. POSSIBLY CAUSED BY LIQUID SPILLS OR DISSIMILAR METAL CONDITION. (X)SDR DHL2000717116Floorbeam · damagedAT D CHECK, PREVIOUS REPAIR AT FLOORBEAM LOWER FLANGE BS 1110 RBL 15.5 TO LBL 37. CUT OUT PREV REPAIR, INSTALLED NEW REPAIR FROM LBL 38 TO RBL 0 PER AVITAS EO 14 BY 3.5, N/R 3750.SDR DHL2000717112Floorbeam · damagedAT D CHECK, PREVIOUS REPAIR FLOORBEAM FLANGE BS 1050 LBL 75 TO RBL 24. CUT OUT LOWER FLANGE, FROM LBL 34 TO RIGHT O/B END. INSTALLED REPAIR PER AVITAS EO AVHM-097RO-1. FLANGE 100 , SPLICES 14.5 N/R3751SDR QXEA0000403Bulkhead · crackedPDX - NOSE LANDING GEAR BAY RIGHT-HAND SIDE WALL HAD TWO HORIZONTAL CRACKS APPROXIMATELY .5 INCH LONG EXTENDING THROUGH TWO RIVET HOLES IN PRESSURIZED SKIN 4 INCHES FORWARD OF FRAME 2650 TO TOP OF WALL. REPAIRED IAW HORIZON AIR EA 4-53-918.SDR DHL200071766DFloorbeam · damagedAT D-CK, BS 480 FLOORBEAM REPAIR FROM RBL 35 TO RBL 56 DOES NOT CONFORM TO THE SRM. REMOVED PREVIOUS REPAIR. INSTALLED FLOORBEAM REPAIR AT BS 480 UPPER CHORD RBL 35 TO 56 PER B727 SRM 53-10-8 FIG 1.. REF: N/R 3743.SDR DHL200071732DFloorbeam · damagedAT D-CK, FLOORBEAM STABILITY STRAP REPAIR AT BS 1040 LBL 24.75 DOES NOT CONFORM TO THE SRM. REMOVED OLD STRAP REPAIR AND INSTALLED NEW STABILITY STRAP REPAIR PER B727 SRM 53-10-8, FIG 6. REF: N/R 3744.SDR DHL200071731DFloorbeam · damagedAT D CK, FLOORBEAM STABILITY STRAP REPAIR AT BS 1040, BL 0, DOES NOT CONFORM TO THE SRM. REMOVED OLD STRAP AND REPLACED WITH STRAP FABRICATED FROM 7075T6, .040, PER B727 SRM 53-10-8 FIG 6. REF: N/R 3745.SDR RRXA000946Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 320, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL EXISTING HOLES, FABRICATED DOUSDR TWAA0002302Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON AFT CARGO COMPT FLOOR SUPPORT STA 1155 TO 1212, RBL 8. REMOVED CORROSION ON FLOOR SUPPORT. INSTALLED NEW FLOOR SUPPORT PER SPM 6-70-01 DRAWING 5936020.SDR P2EA00013Floorbeam · corrodedDURING C-CHECK, FLOORBEAM UPPER CORD CORRODED AT BS 259.5 BETWEEN LBL 15.0 INCHES AND RBL 16.0 INCHES. REPAIRED FLOORBEAM WEB AT BS 259.5 BETWEEN LBL 25 INCHES AND RBL 22 INCHES WL 208.1 IAW COOPESA EO COO-3-53-028-00 DATED 1-14-00. DOCUMENTED ON FAA FORM 81SDR P2EA00012Floorbeam · corrodedDURING C-CHECK, FLOORBEAM AT BS 259.5 BETWEEN LBL 7.0 INCHES AND RBL 10.0 INCHES, FLOORBEAM WEB HAS CORROSION. DEFECT SIZE LENGTH - 17.0 INCHES. WIDTH - 2.0 INCHES. DEPTH - 0.050 INCH. REPAIRED FLOORBEAM WEB AT BS 259.5 BETWEEN LBL 8.75 AND RBL 13.875, IAWSDR DHL200071721DFloorbeam · crackedAT D-CK, UPPER FUSELAGE FS 715, RBL 45-62 FLOOR SUPPORT IS CRACKED. REMOVED FLOOR SUPPORT PER SRM B727 SRM 51-30-2. INSTALLED NEW FLOOR SUPPORT PER B727 SRM 53-10-6. REF: N/R 4690.SDR AT0000043Floorbeam · corrodedFOUND AFT PIT CABIN FLOORBEAM HAS EXFOLIATED CORROSION AT BS 996. REMOVED FLOORBEAM UPPER CAP, FABRICATED NEW CAP ANGLE, TREATED, PRIMED AND INSTALLED NEW CAP ANGLE IAW DC9 SRM 51-30-2, 51-30-5, 53-11-3 FIGURE 11, 51-10-4, 51-30-3.SDR AALA2000375Floorbeam · corrodedTUL - STATION 1110 FLOORBEAM TOP CORRODED BL 0 - LBL 4. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER SRM 53-10-8. (M)SDR ASAA0080046Floorbeam · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON FLOORBEAM WEB AT FS 1338, RBL 35. REMOVED DAMAGED MATERIAL AND INSTALLED NEW PIECES IAW ASA EA 5310-10797. (M)SDR ASAA0080045Floorbeam · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON FLOORBEAM AT FS 1338, FROM RBL 11 TO RBL 44. REMOVED DAMAGED MATERIAL AND INSTALLED NEW PIECES IAW ASA EA 5310-01776. (M)SDR EISA2000023Floorbeam · corrodedDURING ACCOMPLISHMENT OF A ROUTINE C-CHECK, WORKCARD OF FLOORBEAM T-CAP DAMAGED AT FS 344 LBL 53 TO RBL 46. REMOVED DAMAGED FLOORBEAM UPPER T-CAP. FABRICATED REPAIR ANGLE PER SRM 53-10-8. INSTALLED PER SRM 53-10-8 MATERIAL ID BAC 1505-2922 7075-T6.(M)SDR GAIA0024Floorbeam · damagedFOUND DURING ZERO B, TRANSITION CHECK AT AVBORNE HEAVY MAINTENANCE FACILITY, DAMAGE WAS FOUND ON FLOORBEAM UPPER T CHORD AT STATION 344 FROM LBL 62.62 TO RBL 62.62. INSTALLED FLOORBEAM UPPER T CHORD REPAIR AT STATION 344 FROM LBL 62.62 TO RBL 62.62. MATERIALSDR USAA000052Floorbeam · corrodedCLT - STA 347, BL ZERO, FLOORBEAM HAS A 1 INCH BY 1 INCH AREA OF CORROSION, LEVEL 1. INSTALLED NEW SUPPORT ANGLE PER SRM 51-10-00. (X)SDR USAA000051Floorbeam · corrodedCLT - STA 365, RBL 11, 24, AND 34, FLOORBEAM HAS A 2 INCH BY 2 INCH AREA OF CORROSION, LEVEL 2. REPAIRED FILLER, ANGLES AND SHIM PER TR 53-15-02. (X)SDR USAA000050Floorbeam · corrodedCLT - FLOORBEAM 377.7, LBL 14 HAS A 1 INCH AREA OF CORROSION, LEVEL 2. INSTALLED DOUBLER PER 53-00-51 FIG 201. (X)SDR USAA000047Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, RT BUTTLINE 47, LT BUTTLINE 12. INSTALLED NEW T-CAP PER TR 53-60-1 AND EA 66459. (M)SDR UPS00831620Floor Beam · corrodedINSPECTION TYPE:C1 STA 80 RBL 50 UPPER AFT FLOOR BEAM FLANGE IS CORRODED BEYOND LIMITS. REPAIRED IAW 8110-3 APPROVED DH SK 703-301.
Back to JASC 5315