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 SWIA200516310Floorbeam · crackedFS 280.00 AT RBL 9 , I/B FLOORBEAM ATTACH ANGLE IS CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ SRM 51-22-00, 51-42-21, 51-41-01, -51-21-11, 51-40-11 PARA 4.SDR 05FDEA04208Floorbeam · dentedFOUND CARGO FLOORBEAM DENTED AT BS 587 LBL 8 WL 156. REMOVED AND FABRICATED CARGO FLOORBEAM AT BS 565-610, LBL 8, W/L 156 USING BAC1517-1507 PER SRM 51-40-3 AND INSTALLED PER SRM 51-30-2.SDR 05FDEA04205Floorbeam · corrodedFOUND CORROSION C53-111-01 (3) ON FLOORBEAM LOWER FLANGE BS 950D BBL0-LBL44 WL 201. REPAIRED FLOORBEAM LOWER FLANGE BS 950D, BL 0 LBL 44, WL 201 PER SRM 53-10-8, 51-10- 2.SDR C2XA05TY060Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION, CORROSION WAS FOUND ON FLOORBEAM AT CARBON FIBER CROSS BEAM AT FRAME 20. MAINTENANCE REMOVED THE ANGLE AND DAMAGED AREA FROM THE LEFT OMEGA BEAM, FABRICATED NEW REPAIR PIECES, ALODINED, PRIMED AND INSTALLED IAW EMB145XR SRMSDR 05FDEA04209Floorbeam · corrodedFOUND FLOORBEAM UPPER CHORD CORRODED, BS 1130 , RBL 50, WL 208. REPAIRED FLOORBEAM UPPER CHORD PER FEDEX EA 7-5310-96828A.SDR ASOA051159Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM, AT FS 38 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FLOORBEAM, AT FS 38, IAW ASA EO 72-53-0205. (M)SDR USAA051477Floorbeam · corrodedFOUND FLOORBEAM UPPER T CAP CORRODED, BS 328; LBL 60. FAB`D AND INSTALLED NEW T-CAP SECT REPAIR SPLICE IAW 53-10-51, FIG 201, DEFECT SIZE: 1/2" BY 1/2" CORRODED AREAS AROUND CLIP NUT HOLES.SDR USAA051473Floorbeam · corrodedFOUND CORROSION STA 986.5 BELOW TO BL45. REMOVED DAMAGED FABRICATED NEW T CAP AND INSTALLED ON FLOORBEAM IAW 53-10-05, DEFECT SIZE: .5 INCH AREAS OF CORROSION AROUND CLIP NUT HOLES 38 INCHES IN LENGTH.SDR CALA0500431Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT BS 325, LBL 55. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW SRM 53-00-51 FIGURE 201, REPAIR 2.SDR CALA0500430Floorbeam · corrodedINSPECTION FOUND THE FLOORBEAM CORRODED AT BS 303, LBL 27 TO LBL 31. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW SRM 53-00-51, FIGURE 201, REPAIR 2.SDR 05FDEA04184Floorbeam · corrodedREWORK OF FEDEX SNRM N00773 DUE TO IMPROPER SRM REPAIR APPLICABILITY MAIN DECK FLOORBEAM CORRODED ON TOP TWO PLACES AT STA BS 312 BETWEEN LBL 4 AND LBL 20. REMOVED IMPROPER REPAIR IAW B727 SRM 51-30-2. FABRICATED REPAIR ANGLES AND TEE CAP SECTION IAW B727 SRSDR 05FDEA04183Floorbeam · corrodedAFT PIT MAIN DECK FLOORBEAM HAS CORROSION STA BS 1130 LBL67.0 REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW B727 SRM 51-10-6 AND 53-10-1. FABRICATED REPAIR PARTS IAW B727 SRM 53-10-8 FIGURE 10. ALODINED AND PRIMED REPAIR PARTS IAW B727 SRM 51-10-2.INSDR 05FDEA04176Floorbeam · corrodedMAIN CABIN FLOORBEAM HAS CORROSION AT FASTENER HOLES AT STA BS1130 BETWEEN RBL14 AND RBL40. REPAIRED OUT OF LIMTS SECTION OF STA BS 1130 FLOORBEAM IAW SRM 53-10-8 FIGURE 10. ALODINED AND PRIMED BARE METAL AREAS IAW SRM 51-10-2. INSTALLED REPAIR WITH WET SDR 05FDEA04175Floorbeam · corrodedFORWARD CARGO COMPARTMENT STA BS 620 BOTTOM SURFACE OF FLOORBEAM UPPER TEE CAP HAS CORROSION AROUND SCREW HOLES LBL50 TO RBL50. REMOVED DAMAGED SECTION OF TEE CAP AT STA BS 620 BETWEEN LBL45 AND RT CUSP. FABRICATED NEW TEE CAP, SPLICES, SHIMS: ALODINED ANDSDR 05FDEA04174Floorbeam · corrodedAFT PIT MAIN DECK FLOORBEAM HAS CORROSION AT FASTENER CLIP AT STA, BS 950F, LBL21.0. REMOVED CORROSION IAW SRM 51-10-6 AND FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1 FIGURE 4. REMOVED AND REPLACED FLOORBEAM UPPER TEE CAP SECTION FROM LBL8 TO LBL70 IAW STANDSDR 05FDEA04158Floorbeam · gougedCORROSION BS 304, WL 280, LBL 14 GOUGE ON TOP FLANGE, FLOORBEAM. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-30-2 AND SRM 51-10-2.SDR 05FDEA04155Floorbeam · corrodedCABIN FLOORBEAM UPPER TEE CAP CORRODED AT STA BS 344 BETWEEN LBL24 AND RBL24. CUT OUT CORRODED SECTION OF TEE CAP FROM LBL45 TO RBL24 IAW SRM 53-10-8 FIGURE 9. FABRICATED NEW TEE SECTION AND SPLICE ANGLES IAW SRM 53-10-8 FIGURE 9. ALODINED AND PRIMED REPASDR 05FDEA04152Floorbeam · gougedMAIN DECK TOP SIDE OF FLOORBEAM GOUGED AT STA BS680 LBL47 TO LBL57. REMOVED DAMAGED, FABRICATED REPAIR ANGLES FROM 17-7PH CRES STEEL .063 INCH, FABRICATED FILLER AND INSTALLED REPAIR ANGLES AND FILLER IAW SRM SR27-53-034 REV E. INSTALLED SEAT TRACK AT LBL65SDR USAA051467Floorbeam · corrodedSTA 986.5 LBL 8 TO EXTREME RT END. MAJOR REPAIR, REMOVED DAMAGED T-CAP, INSTALLED NEW REPAIRED PART IAW SRM 53-60-01 REV A. DEFECT SIZE: 1 INCH.SDR USAA051454Floorbeam · corrodedUPPER FLANGE STA 986.5 - LBL 30 CORRODED. MAJOR REPAIR, INSTALLED FLOORBEAM UPPER CHORD REPAIR IAW SRM 53-60-51 FIG 201, DEFECT SIZE: .250.SDR USAA051458Floorbeam · corrodedFLOORBEAM AT STA 344 BL 0 TO LBL 25 CORRODED. MAJOR REPAIR, BLENDED AREA, ALODINED AND PAINTED IAW SRM 53-10-51, DEFECT SIZE: .250 INCH.SDR 05FDEA04148Floorbeam · chafedFOUND CENTER CARGO DOOR WAY CEILING AREA STA 1721, X=-98 MAIN DECK FLOORBEAM LOWER SIDE FOUND CHAFED. REPAIR CARRIED OUT AT CENTER CARGO DOOR WAY CEILING AREA AT STA 1721, X=-98 MAIN DECK FLOOR BEAM LOWER SIDE AS PER FEDEX EA 1-5310-90708, TITLE: "FUSELAGESDR SWAA053872Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 744A, RBL 26.5. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA053871Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOORBEAM CORRODED AT BS 260, LBL 6 TO RBL 11, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA053863Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 665, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR DHL2005803537Floorbeam · misdrilledWING CTR SECTION FLOORBEAM HOLES (2EA) MISDRILLED, STA 834.500 RBL 32" RBL 37.750 (MAIN CARGO COMPT.) PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 11-28-05, DWG NR AA33-53-R06 REV IR DATE 11-16-05. REMOVED FASTENERS IAW SRM 51-1-21. TRIMMED OUT DAMAGED SESDR DHL2005803534Floorbeam · misdrilledWING CTR SECTION FLOORBEAM HOLES (2EA) MISDRILLED STA 960.000 LBL 9.625 INCH, LBL 15.250 INCH(MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 11-30-05 DWG AA33-53-R05 REV JR DATE 11-22-05. DRILLED MISDRILLED HOLES (2EA) TO 0.250 INCH AND 0.290 ISDR DHL2005803539Floorbeam · misdrilledITEM REF NR 038741: WING CTR SECTION FLOORBEAM HOLE MISDRILLED STA 980.000 RBL 93750 (MAIN CARGO COMPT.) (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 11/28/05, DWG AA33-53-R07 REV IR DATE 11/11/05. REMOVED FASTENERS IAW SRM 51-1-21. TRIMMED SDR DHL2005803522Floorbeam · misdrilledITEM REF. NR. 039049: MAIN CARGO COMPT. WING CTR SECTION FLOORBEAM UPPER FLANGE HOLE MISDRILLED STA 940.000 LBL 32.500 INCH (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 11/28/05, DWG AA33-53-R08 REV JR DATE 11/18/05. REMOVED FASTENERS IAW SRSDR AWXA200501575Floorbeam · corrodedDURING BC-4 CHECK DISCOVERED CORROSION ON THE FLOORBEAM LOCATED AT FR 16 AND Y254. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-11-14 PAGE 109, FIG 104. MAINTENANCE CUT OUT DAMAGED AREA IAW SRM 53-11-14. FABRICATED ANGLES AND SUPPOSDR 05FDEA04073Floorbeam · corrodedFOUND MAIN DECK FLOORBEAM HAS CORROSION AT STA BS 720A BETWEEN RBL4 AND RBL20. CLEANED AREA IAW B727 SRM 51-10-6, AND FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. REMOVED DAMAGED UPPER CHORD IAW B727 SRM 53-10-8 FIGURE 4. FABRICATED UPPER CHORD, SUPPORSDR 05FDEA04076Floorbeam · damagedDISCREPANCY IN THE AFT WASTE TANK AREA BULKHEAD STA 2007 FOUND NEW SECTION OF FLOOR T-CAP ANGLE Z-19 LENGTH 35" FROM X75 TO X 40 AND JUNCTION SPLICE. PERFORMED A GVI OF REPAIR IAW SRM 53-40-00 FIG 16 VOL 1 AND FOUND IN COMPLIANCE WITH CRITERIA REQUEST BY EO NSDR USAA051450Floorbeam · corrodedFOUND FLOORBEAM CORRODED, Y-1732 FROM 65-66. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11, DEFECT SIZE: 3" X 20".SDR USAA051449Floorbeam · corrodedLOCATION: BEAM Y1160 FRAME 67-68 ACTION: DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-43-00, 53-41-04; TASK JA-260-53500 DEFECT SIZE: 3" X 16"SDR USAA051447Floorbeam · corrodedLOCATION: BEAM Y1160 FR 68 ACTION: DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-43-00, 53-41-04; CORR TASK 260-53500-002 DEFECT SIZE: 3" X 20"SDR 05FDEA04054Floorbeam · nonePREVIOUS REPAIRS ON MAIN DECK CARGO FLOORBEAMS AT FS 34, FS 35, AND FS 36, RT OF CENTER, NEEDS EVALUATION FOR MAJOR/MINOR CLASSIFICATION AND APPROVED REPAIR DATA. EVALUATION DETERMINED REPAIRS TO BE IAW EA 6-5310-29466. NO FURTHER ACTION REQUIRED. MINOR REPSDR 05FDEA04051Repair · unknownPREVIOUS REPAIRS INSTALLED ON MAIN CARGO DECK FLOORBEAM AT FS 37 30" LEFT OF CENTER, NEEDS EVALUATION FOR MAJOR/MINOR CLASSIFICATION AND APPROVED REPAIR DATA. PREVIOUS REPAIRS INSTALLED ON EA 6-5310-48685 AND EA 6-5321-50489. NO FURTHER ACTION REQUIRED. WORSDR USAA051439Floorbeam · corrodedFOUND CORROSION MAIN CABIN STA 312 RBL 21 FLOORBEAM UPPER CORD; CORROSION TASK C53-107-02. REMOVED AND REPLACED FLOORBEAM UPPER CORD AND L ANGLES AND INSTALLED SHIMS IAW SRM 53-10-5, DEFECT SIZE:SDR USAA051435Floorbeam · corrodedFOUND CORROSION MAIN DECK STA 344, LBL 0; CORROSION LEVEL 1; TASK C53-107-02. FABRICATED REPAIR PARTS, INSTALLED REPAIR FILLER AND ANGLES PER SRM 53-10-51, 51-40-02, DEFECT SIZE: 2.50"L BY 1.10"W BY .031"D.SDR USAA051423Floorbeam · corrodedLT Y765; CORR. LEVEL 1; TASK J220-53500. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM 53-11-14, DEFECT SIZE: 1 INCH X 1INCH X 1INCH.SDR USAA051427Floorbeam · corrodedPAX FLOORBEAM AT Y765, FR 16, LT, REMOVED AND REPLACED FLOORBEAM; DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM 51-72-11; CORR. LEVEL 1, DEFECT SIZE: 1 SQ. IN.SDR USAA051428Floorbeam · corrodedPAX FLOORBEAM AT Y503, FR 14-16, REMOVED AND REPLACED FLOORBEAM IAW SRM 51-72-11; CORR. LEVEL 1; TASK JA-220-53500 DEFECT SIZE: 2 SQ. IN.SDR USAA051429Floorbeam · corrodedFLOORBEAM Y254 AT FR 21, DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM 51-72-11, DEFECT SIZE: 1 INCH DIA.SDR USAA051430Floorbeam · corrodedY765 BETWEEN FR 67-68 ON PAX COMPARTMENT FLOORBEAM REMOVED AND REPLACED FLOORBEAM IAW SRM 51-72-11; CORR. LEVEL 1; TASK JA-260-53500 DEFECT SIZE: 2 SQ. IN.SDR ASAA0540680Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED IAW ASA EA 5310-02524. (M)SDR SWIA200516325Floorbeam · crackedFS 280 RBL 9 INNER AND OUTER FLOORBEAM ANGLES CRACKED, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW CLIPS AT FS 280 RBL 9 INNER AND OUTER FLOOR SUPPORT ANGLES IAW REO 601R-53-11-136.SDR SWIA200516324Floorbeam · crackedFS 280 LBL 9 INNER AND OUTER FLOORBEAM ANGLES CRACKED, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW INNER FLOOR SPORT ANGLE AT FS 280.0 LBL9 IAW REO 601R F53-11-136.SDR ABXA060035Floorbeam · corrodedMAIN CABIN, STA 880, RIGHT BUTT LINE 63, FLOORBEAM LOWER CHORD, FORWARD SIDE CORRODED. REPAIRED FLOORBEAM STA 880, RIGHT BUTT LINE 63 IAW REA D853-52566MR.SDR CALA0500425Floorbeam · corrodedINSPECTION FOUND THE FLOORBEAM AFT FLANGE CORRODED AT STA 947, RBL 4 TO RBL 12. A STRAP REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR CALA0500424Floorbeam · corrodedINSPECTION FOUND FLOORBEAM FORWARD FLANGE CORRODED AT STA 947, RBL 10.5, S18R. REPAIRED IAW SRM 53-60-51.
Back to JASC 5315