JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 LR7A05072Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT & RT FS 337E WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LT & RT FS 337E WL 162 BL 68.SDR LR7A05071Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 250 WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LT FS 250 WL 162 BL 68.SDR LR7A05070Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 305 WL 175 BL 77. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LT FS 305 WL 175 BL 77.SDR LR7A05069Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT & RT FS 290 WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LT & RT FS 290 WL 162 BL 68.SDR LR7A05068Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RT FS 255E WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, RT FS 255E WL 162 BL 68.SDR LR7A05067Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 324E WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LT FS 324E WL 162 BL 68.SDR LR7A05066Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RT FS 687 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, RT FS 687 WL 162 BL 68.SDR LR7A05065Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT & RT FS 677 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, LT & RT FS 677 WL 162 BL 68.SDR LR7A05064Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT & RIGHT FS 667 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, LT & RT FS 667 WL 162 BL 68.SDR LR7A05063Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT & RIGHT FS 657 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, LT & RT FS 657 WL 162 BL 68.SDR LR7A05062Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RIGHT FS 647 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, RIGHT FS 647 WL 162 BL 68.SDR LR7A05061Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT & RT FS 637 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, LEFT & RIGHT FS 637 WL 162 BL 68.SDR LR7A05060Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT & RIGHT FS 627 WL 162 BL 68. FRAME REPAIRED IAW R05-009-03, LAC MEA 382-53-05-045, LT & RT FS 627 WL 162 BL 68.SDR LR7A05058Frame · crackedDURING SCHEDULED C-6 CHECK PER JOB CARD HC2701 CRACK FOUND AT RIGHT AFT FUSELAGE FS 858 UPPER RING SEGMENT EDGE, RBL 61, WL 280. REPAIR CARRIED OUT IAW SMP583 FIG 53-50-05, FS 858.SDR LR7A05056Frame · corrodedDURING SCHEDULED C-6 CHECK NR 2001 ACCOMPLISHMENT FOUND LT RING SEGMENT CORRODED FS 757E AT WL 140-146, AND NUMEROUS EXCESS HOLES AT WL 160. REPAIR CARRIED OUT IAW SMP583 CHP 51-140-23, FS 757E WL 140-146.SDR LR7A05054Frame · corrodedDURING SCHEDULED C-6 CHECK PER JOB CARD HC5313 FOUND CABIN RING SEGMENT CORRODED AT FS 397 WL 140-146 BL 63R. REPAIR CARRIED OUT IAW SMP583 CHP 51-140, RIGHT FS 397.SDR LR7A05044Frame · damagedDURING SCHEDULED C-6 CHECK PER JOB CARD HC5315 CARGO COMPT RING SEGMENT FOUND NUMEROUS EXCESS HOLES AND PATCH REPAIR AT FS 752E LT CABIN; WL 140-200 & WL 200-265. RING SEGMENT REPLACED IAW SMP583 CHP 51-60 & 51-70 FS 752E WL 146-200 & 200-265 LHS.SDR LR7A05043Frame · damagedDURING SCHEDULED C-6 CHECK PER JOB CARD HC5315 CARGO COMPT RING SEGMENT FOUND NUMEROUS EXCESS HOLES AT CABIN FS 752E; RT WL 140-200 AND WL 200-265. RING SEGMENT REPLACED IAW SMP583 CHP 51-60 & 51-70 FS 752E WL 140-200 & 200-265 RHS.SDR SWAA051276Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER BOEING S/B.SDR 05FDEA01169Frame · corrodedCORROSION ON FRAME BS 700 LBL 13 WL 148. REPAIRED BS 700 FRAME, LBL 13, WL 148 PER SRM 53-10-4.SDR CALA0500135Frame · crackedMAIN CABIN STA 616L FRAME INNER CHORD CRACKED. INSTALLED FRAME PER ECRA 5311-01158.SDR SWAA051267Frame · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE FRAME ASSY AT BS 500, FROM STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA051266Frame · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE LOWER FRAME AT BS 1088, FROM LBL 13 TO RBL 15. REPAIRED FRAME PER BFG ER.SDR CALA0500134Frame · damagedFRAME 967 DAMAGED AT GROUND STUD ATTACH POINT BETWEEN STRINGERS. INSTALLED FRAME PER SRM 53-00-07, FIG 202SDR DHL2005741576Frame · corrodedFRAME CORRODED AT STA 1166 AT STR 29R. FRAME AT BS 1166 FROM STR 25L-STR 25R IS CORRODED BEYOND ALLOWABLE LIMITS. CUT OUT DAMAGE SECTION FROM 25L- STR 25R IAW B727 SRM 53-10-4 FIG 13. FABRICATED NEW SECTION FROM 25L TO 25R 76 BY 10 IN. 7075-T6 .063 PO NR 509SDR C1HA200596009Frame · corrodedFUSELAGE INTERIOR STA 312 LOWER LT HORIZONTAL WALKBEAM, AND FRAME CORRODED (GENERATING ITEM C53-111-03-02) FUSELAGE INTERIOR STA 304 - LOWER LT FRAME HAS CORROSION. REPAIRED CHORD PER CAEO 727-5316-02 AND SRM 53-10-4 FIG 7.SDR UIEA200500068Frame · crackedNOSE WHEEL WELL STRUCTURE ON INTERIOR OF FUSELAGE CHORD CRACKED AT BS 340, WL 200, LBL 10. REPAIRED IAW MFG MM. (K)SDR ASAA0590098Frame · misdrilledPAE - DURING C-CHECK, FOUND FRAME HAS DOUBLE DRILLED HOLES AT BS 727. REPAIRED IAW SRM 51-70-11. (M)SDR DHL2005741513Frame · bentFRAME BENT AT FUSELAGE STA 700 STR 24R. CUT OUT DAMAGED AREA DIM 2.250 IAW B727 SRM 51-10-1 FIG 1. FABBED ANGLE REPAIR FROM 7075-T6 .063 PO NR 900489 DIM 11 X 3 INCHES. FABBED SHIM FROM 7075-T6 .100 PO NR 9911586 DIM 11 X 1 INCHES. FABBED FILLER FROM 7075-SDR DHL2005364001Frame · damagedFRAME 47 REPAIR RSA FROM AIRBUS IS INTERIM FOR 6 MONTH REF RAS/AS/0114/2004 MSI 05574. REPAIR DESIGN APPROVAL SHEET REF RAS/AS/0114/2004 ISSUE B DATE 12/10/04 INTERIM LIMIT NONE THIS CLEARS MSI 05574.SDR 05FDEA01101Frame · corrodedIN A/C BAY, FRAME 47 AFT SIDE FROM STGR40R TO 47R HAS CORROSION. REMOVED AND REINSTALLED FASTENERS IAW A310 SRM 51-40-21. REMOVED CORROSION IAW A310-200 SRM 51-74-10. ROTOTESTED HOLES AND CLEARED DEFECTS IAW A310 NTM 51-10-01. ALL WORK WAS PERFORMED AND SDR 05FDEA01063Frame · corrodedCORROSION ON FRAME IN RT WHEEL WELL AFT OF FRAME 47 ON DIAGONAL FRAME. REMOVED CORROSION AND REPROTECTED SURFACE IAW A310-200 SRM 51-74-10 AND 51-23-10. MATERIAL LOSS WITHIN LIMITS PER FEDEX EA 6-5310-87818.SDR DHL2005741534Frame · bentFRAME BENT AT FS 660 STR 24R. FOUND DENT TO BE OUT OF LIMITS ON STA 660 STR 24R IAW B727 SRM 53-10-1 FIG1. CUT OUT AREA OF FRAME DIM 1 X 8 IAW B727 SRM 51-40-3 FIG 1. FABRICATED ANGLE REPAIR FROM 7075 T6 .071 SIZE 16 X 3 PO NR 900573 AND FILLER FROM 7075 T6SDR DHL2005741527Frame · bentBENT FRAME AT STA 500 STR 25R. CUT OUT DAMAGED AREA DIM 3 INCHES BY 1/8 INCHES ON FRAME STA 500 STR 25R IAW B727 SRM 51-10-1. FABRICATED REPAIR ANGLE FROM 7075T6 .063 SIZE 13 3/8 INCHES BY 3 1/8 INCHES PO NR 9001660 IAW B727 SRM 51-40-3 FIG1. TREATED AND PRSDR DHL2005741526Frame · bentFRAME BENT AT FUSE STA 680 STR 24R. FOUND DENT TO BE OUT OF LIMITS ON STA 680 STR 24R IAW B727 SRM 53-10-1 FIG 1 SIZE 2 INCHES BY 2 1/2 INCHES CUTOUT FABRICATED ANGLE REPAIR FROM 7075T6 .071 SIZE 12 INCHES BY 3 INCHES PO NR 900573 IAW B727 SRM 51-40-3 FIG 1. SDR SWAA051206Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EA FUSELAGE BELT FRAME CRACKS AT INBOARD LOWER ATTACH CASTINGS, BS 616, LBL 64 & RBL 64. REPAIRED FRAMES PER SRM AND BOEING SB.SDR 05FDEA01058Strap · chafedMAIN DECK CARGO, AT STA 1030 AND 1050 STR 6L, LINER FRAME ASSY HAS CHAFED INTO THE FRAME STRAP'S AND HARDWARE. GOUGE OUT OF LIMITS IAW BOEING SRM 53-10-1. REMOVED AND REPLACED STRAP IAW BOEING SRM 51-30-2.SDR SWAA051173Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 188, LBL 29, WL 208. REPAIRED FRAME PER SRM.SDR SWAA051168Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA CRACKS AT FUSELAGE FRAME, BS 727, BETWEEN STR 14L & STR 16L. REPAIRED FRAME PER PAE ER.SDR COMA0560269Frame · crackedLEFT HAND 621.00 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR SWAA051157Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051156Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9L. REPAIRED FRAME PER SRM.SDR PIDA200500006Frame · crackedTWO CRACKS AT RIVET HOLE IN BS 867 FRAME AT STR 9 RT. REPAIRED PER SRM 53-00-07.SDR PIDA200500004Frame · crackedTWO CRACKS IN BS 787 FRAME AT RIVET HOLE AT STR 9RT. REPAIRED PER SRM 53-00-07.SDR PIDA200500008Frame · crackedTWO CRACKS IN BS 827 FRAME AT STR 9 LT. REPAIRED PER SRM 53-00-07.SDR PIDA200500007Frame · crackedTWO CRACKS IN BS 787 FRAME AT STR 9 LT. REPAIRED PER SRM 53-00-07.SDR PIDA200500009Frame · crackedTWO CRACKS IN BS 867 FRAME AT STR 9LT. REPAIRED PER SRM 53-00-07.SDR PIDA200500005Frame · crackedTWO CRACKS IN BS 827 FRAME AT STR 9RT. REPAIRED PER SRM 53-00-07.SDR DHL2005741556Frame · bentAFT CARGO STA 1030 AT STR 24 RIGHT BENT FRAME. FRAME OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1. CUT OUT DAMAGE AREA DIMS 1.125 X 1.5 INCH AND FABRICATED REPAIR DOUBLER FROM MAT USED 7075-T6 .080 PO 90002012 AND DIMS 9.25 X 4 INCH IAW B727 SRM 51-40-3 FIG 1 & SDR DHL2005741555Frame · bentAFT CARGO STA 1010 AT STR 24 FRAME BENT RIGHT. FRAME OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1. CUT OUT DAMAGE AREA DIMS 1.5 X 1.5 INCH AND FABRICATED REPAIR DOUBLER FROM MAT USED 7075-T6 .071 PO 9002118 AND DIMS 14 X 14 INCH IAW B727 SRM 51-40-3 FIG 1 & MAT
Back to JASC 5311