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 ASOA200901222Floorbeam · crackedFS 280.00 TRANSVERSE FLOORBEAM CRACKED AT THE RT FLOORBEAM MEMBER AT RBL-9 AT LWR FLANGE RADIUS. CUT OUT DAMAGED AREA AND REMOVED EXISTING FASTENERS IN REPAIR AREA. REMOVED EXISTING -5 CLIP AT FS280 RBL 9 PER REO 601R-53-11-171. PERFORMED ET INSP FOLLOWED SDR ASOA200901218Floorbeam · crackedFLOORBEAM CLIP AT FS 589 AND CARGO DOOR SILL CRACKED. REMOVED AND REPLACED CLIP AT FS 589 UNDER CARGO DOOR SILL IAW SRM 51-42-06 AND 51-42-21.SDR USAA2009110493036Floorbeam · corrodedCLT - MAJOR REPAIR - Q3 CHECK - LEVEL 2 CORROSION ON FLOORBEAM "T" CAP AT BS 966, LBL 15- RBL 10. REPAIRED FLOORBEAM "T" CAP AT BS 966, LBL 15- RBL 10 IAW TYPICAL REPAIR 53-60-01.SDR NOCA06009Floorbeam · corrodedFLOORBEAM CAP CORRODED STA 347 RBL 50-57. CUT OUT FLOORBEAM CAP AT CORROSION AREA, INSTALLED FLOORBEAM REPAIR AS PER SRM 53-00-51.SDR USAA2009110292960Floorbeam · corrodedSAL - MAJOR REPAIR - BC7 CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR 67+15 INCHES TO FR 70, -Y1292. REPLACED FLOORBEAM AT FR 67+15 INCHES TO FR 70, -Y1292 IAW A320 SRM 51-72-11.SDR QXEA2009110200893Floorbeam · corrodedLT FS 280.00 BEAM CORRODED RT FS 280 BEAM CRACKED. ON FURTHER INSPECTION FOUND BOTH BEAMS CRACKED. REMOVED RT AND LT BEAMS IAW SRM 51-42-13, 51-42-21, 51-42-06, 51-40-11 AND 670-53-11-047. PERFORMED LPI IAW REO 670-53-11-047. INSTALLED NEW BEAMS IAW REO 67SDR USAA2009111693116Floorbeam · corrodedMCN - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 1681, LBL 50. REPAIRED FLOORBEAM AT BS 1681, LBL 50 IAW B757 SRM 53-00-51.SDR USAA2009110292988Floorbeam · corrodedSAL - MAJOR REPAIR - Q2 CHECK - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER FLANGE AT BS 1016, LBL 30 - RBL 30. REPAIRED FLOORBEAM UPPER FLANGE AT BS 1016, LBL 30 - RBL 30 IAW EA 132395.SDR SWAA096862Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 980, BETWEEN LBL 16 TO RBL 30. REPAIRED BEAM PER ER.SDR SWAA096831Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB PER ER.SDR SWAA096830Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, LBL 24.5. REPAIRED WEB PER SRM.SDR SWAA096810Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 666, LBL 24.5. REPAIRED BEAM PER AAR EA.SDR SWAA096784Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 709, BBL 0.07. REMOVED AND REPLACED WEB PER SI.SDR FDEA200910303738Floorbeam · damagedFLOOR BEAM AT BS 1640 REQUIRES REPLACEMENT DUE TO EXISTING REPAIRS. REMOVED FLOORBEAM AT BS 1640, LBL 63 TO RBL 63, IAW SRM 51-40-02. ANODIZED NEW FLOORBEAM IAW BAC 5019, REV. U, P.O. NR MSC0012758. FABBED NEW FLOOR BEAM FROM BAC1518-338, BATCH NR 000169230SDR DL757100346Floorbeam · corrodedCORROSION STA 1640 CTR B/L UNDER CABIN FLOOR TOP OF FRAME. ACCOMPLISHED ERA 478221-14 REV ORIG AT SAA SAT REF NON ROUTINE CARD 144319.SDR DL757100334Floorbeam · corrodedFLOOR SUPPORT UPPER ANGLE AT FSTA 760 RBL 63 HAS CORROSION. ACCOMPLISHED ERA 478217-14 REV ORIGINAL AT SAA SAT REF NON ROUTINE 139977.SDR EIAA200900120Floorbeam · damagedAFT PIT FUS BS 1820 LT BUTT LINE 2, 23 AND 26 WL 118 FLOORBEAM UPPER CHORD DING. REMOVED DAMAGE, FABBED REPAIR AND INSTALLED PER B747 SRM 51-40-04 PF 5-9 DETAIL III FIG 2.SDR DL757100316Floorbeam · corrodedMAIN CABIN FLOOR FRAME UPPER SURFACE HAS CORROSION STA 760 LBL 18 AROUND FASTENER HOLES AT AFT INBD LAV MOUNT. R & R FLOOR FRAME AT SAA SAT REF NON ROUTINE 141221.SDR DL757100308Floor Support · corrodedMAIN CABIN FLOOR SUPPORT STA 730 LBL 18 HAS CORROSION ON UPPER AT FASTENER HOLES. REPLACED FLOOR SUPPORT AT SAA SAT REF NON ROUTINE CARD 141223.SDR DL757100305Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER SURFACE HAS HEAVY CORROSION ON UPPER SURFACE STA 760 LBL 18 TO LBL 50. REMOVED AND INSTALLED NEW CABIN FLOORBEAM AT SAA SAT REF NON ROUTINE 141222.SDR GTIA0900036Floorbeam · corrodedAFT GALLEY FLOOR SUPPORT FR68 BETWEEN -Y254 AND Y254 CORRODED/REMOVED AND REPLACED FLOOR SUPPORT.SDR USAA2009112393204Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT BS 1016, WL 207, LBL 30. REPAIRED FLOORBEAM AT BS 1016, WL 207, LBL 30 IAW B737 SRM 53-00-51.SDR FDEA200910283719Floorbeam · damagedFLOORBEAM AT STA 1661, REQUIRES REPLACEMENT DUE TO EXISTING REPAIRS. REMOVED FLOORBEAM IAW SRM 51-40-02, FABED NEW FLOORBEAM BAC1518-338, IAW SRM 51-40-05. INSTALLED NEW FLOORBEAM STA 1661, RBL TO LBL 63, IAW SRM 51-40-02. CATEGORY "A" , MAJOR REPAIR.SDR DL757100314Floorbeam · corrodedMAIN CABIN FLOORBEAM AT LT STA 730 LBL 70-LB 80 HAS AREAS OF CORROSION. R & R FLOORBEAM AT SAA SAT REF NON ROUTINE 141187.SDR DL757100312Floorbeam · corrodedMAIN CABIN FLOORBEAM AT LT STA 730 LBL 20-LBL 65 HAS AREAS OF CORROSION. R & R FLOORBEAM AT SAA SAT REF NON ROUTINE 141188.SDR SWAA096947Floorbeam · crackedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM "T" CAP CRACKED AT BS 312 FWD LEG LOWER RADIUS CRACKED AT FASTENER HOLE. REMOVED AND REPLACED "T" CAP PER SRM.SDR ASAA0946909Floorbeam · corrodedFLOORBEAM AT STA 986.5 IS SHOWING SIGNS OF CORROSION UNDER FLOOR PANEL ON FORWARD SIDE OF BEAM. REPAIRED FLOORBEAM AT STA 986.2 IAW AAR EA 13619 REV 1/2 DATED 23OCT2009 AND ASA EA 400 53EA 02304 REV NEW DATED 26OCT09.SDR ASAA0946864Floorbeam · corrodedFLOORBEAM AT STA 986.5 IS CORRODED UNDER FLOOR PANEL ON FORWARD SIDE OF BEAM. REPAIRED FLOORBEAM AT STA 986.5.SDR FDEA200910273689Floorbeam · damaged2EA EXISTING HOLES IN THE FLOORBEAM UPPER CHORD AT STA 780 RBL 58 ARE ELONGATED AT BS 780 RBL 58 FLOORBEAM REPAIR WAS ACCOMPLISHED ON MAE W/C 118350441BZ2R03 AND MAE EA# 757-5335-16-F2306 REV - DATED SEPT 30, 2009.SDR FDEA200910273688Floorbeam · failed2 EA EXISTING HOLES IN THE FLOORBEAM UPPER CHORD AT STA 680 RBL 58 ARE ELONGATED AT BS 680 RBL 58 FLOORBEAM REPAIR WAS ACCOMPLISHED ON MAE MOD W/C 118350441BZ2R03 AND MAE EA# 757-5335-16-F2306.SDR USAA2009112393203Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT BS 1016, RBL 30. REPAIRED FLOORBEAM AT BS 1016, RBL 30 IAW B737 SRM 51-70-11.SDR FDEA200910263677Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 345, LBL 45, HAS AREA OF CORRORSION. REMOVED CORROSION, FABRICATED TEE CHORD STRAPS ON MAE TRAV 3 T9/806490, AND FABRICATED ANGLES ON MAE TRAV T9/806501, INSTALLED TEE CHORD, ANGLES, STRAPS REPAIR PARTS STA 345, LBL 54- RBL 37, IAWSDR SWAA096760Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707 TO BS 713, BL 0. REPAIRED WEB PER ER.SDR SWAA096753Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND CENTER BOX WING LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727, LBL 24.8. REMOVED AND REPLACED BEAM PER SRM.SDR FDEA200910263674Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 340 LBL 20 TO 27 HAS AREA OF CORROSION (OUT OF LIMITS). REMOVED FLOOR SUPPORT IAW SRM 51-40-02. FABRICATED FLOOR SUPPORT ON MAE TRAV NR T9\807944. INSTALLED FLOOR SUPPORT MCD STA 333-340, LBL 20-31 IAW SRM 51-40-02.SDR FDEA200910263673Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 340 LBL 32 TO 37 HAS AREA OF CORRODED OUT OF LIMITS. REMOVED CORROSION MCD STR STA 340 LBL 32-37 IAW SRM 51-10-02 CHECKED LIMITS. ORIG MAT THICKNESS = .032, AFTER REWORK MAT THICKNESS .018, MAT LOSS= .012 FOUND TO BE OUT OF LIMITS IAWSDR FDEA200910263672Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 340 LBL 29 TO 32 HAS AREA OF CORRODED OUT OF LIMITS. REMOVED CORROSION FROM FLOORBEAM IAW SRM 51-10-02. CHECKED LIMITS AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-04. REMOVED 4EA. NUTPLATES, 2EA. BRACKETS, AND FLOORBEAM IAW SRM 51-SDR FDEA200910263671Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 333 LBL 38 TO 44 HAS AREAS OF CORRODED OUT OF LIMITS IAW SRM 53-00-04. REMOVED FLOOR SUPPORT, BS 324-345, AND 2EA SUPPORT BRACKETS, BS 324, LBL 38 AND 40, IAW SRM 51-40-02. RECEIVED NEW FLOOR SUPPORT, BS 324-345, LBL 38-40, PN 141N51SDR QXEA2009102600839Floorbeam · corrodedDURING INSPECTION FOUND CORROSION ON SUPPORT ANGLE FOR FLOOR PANEL 141AL AT FS 280. REMOVED FLOOR PANEL SUPPORT ANGLE AT FS 280 FRAME IAW SRM 51-42-06. LOCATED FASTENER HOLES IN NEW SUPPORT ANGLE IAW SRM 51-42-06, ALODINE, PRIMED AND PAINTED IAW SRM 61-21-11SDR DL757100197Floorbeam · corrodedMAIN CABIN FS 324 RBL 51 CORROSION ON UPPER SURFACE OF FLOORBEAM. INSTALLED NEW T CHORD SECTION AND SPLICE ANGLES AT SAT SAA REF NON ROUTINE CARD 137238.SDR CALA2009110300650Floorbeam · corrodedB767-53-3-0172 STA 303 LBL 11 TO 55 FLOORBEAM UPPER CHORD FOUND SEVERAL CORRODED. BS 303 FLOORBEAM UPPER CHORD CORROSION REMOVED AS PER SRM 51-10-02, BLEND OUT AREA DEPTH 0.060" (ORG THK 0.100") WIDTH 1 INCH, LENGTH 3 INCHES OUT OF SRM 53-00-51 ALLOWABLE DAMASDR CALA2009110300649Floorbeam · corrodedB767-53-3-0172 STA 325 LBL 55 TO RBL 55 FLOORBEAM UPPER CHORD FOUND SEVERAL CORRODED. BS 325 FLOORBEAM UPPER CHORD CORROSION REMOVED AS PER SRM 51-10-02, BLEND OUT D0.035" (ORG THK 0.090") W1"L2.5" OUT OF SRM 53-00-51 ALLOWABLE DAMAGE 1 FIG 101 LIMITS & FLOORSDR UALA2009102603324Stiffener · crackedFLOORBEAM FWD FACE VERTICAL STIFFENER IS CRACKED STA 246, LBL 9. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE STIFFENER.SDR UALA2009102603323Stiffener · crackedCABIN FLOORBEAM FWD FACE VERTICAL STIFFENER CRACKED STA 246, RBL 11. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW STIFFENER.SDR IPXA09657860Angle · crackedINSPECTION TYPE:C AFT BULK CARGO STA 1562-1582 RBL 76 INCH FLOORBEAM ANGLE FOUND CRACK (CRACK LENGTH 0.25 I NCH), AFT BULK CARGO STA 1562-1582 RBL 76 FLOORBEAM ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45SDR IPXA09657858Angle · crackedINSPECTION TYPE:C AFT BULK CARGO STA 1562-1582 LBL 76 INCH FLOORBEAM ANGLE FOUND CRACK (CRACK LENGTH 0.5 INCH), AFT BULK CARGO STA 1562-1582 LBL 76 FLOORBEAM ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR IPXA09657857Angle · crackedINSPECTION TYPE:C AFT BULK CARGO STA 1562-1582 LBL 75 INCH FLOORBEAM ANGLE FOUND CRACK (CRACK LENGTH 1.375 INCH), AFT BULK CARGO STA 1562-1582 LBL 75 INCH FLOORBEAM ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR IPXA09657820Fitting · crackedINSPECTION TYPE:C MEC COMPT STA 246 RBL 10 FLOORBEAM CLIP FOUND CRACK (CRACK LENGTH 1.5 INCH). MEC COMPT STA 246 RBL 10 FLOORBEAM CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR IPXA09657816Fitting · crackedINSPECTION TYPE:C MEC COMPT STA 246 LBL 50 FLOORBEAM CLIP FOUND CRACKED CRACK 0.875 INCH. MEC COMPT STA 246 LBL 50 FLOORBEAM CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR SWIA200923503Floorbeam · crackedC-CHECK, FS 280 FLOORBEAM CRACKED AND CORRODED. REPAIRED PER REO.
Back to JASC 5315