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 SWAA050948Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FUSELAGE FRAME WEB AT BS 847, RBL 20, WL 160. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050941Beltframe · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELTFRAME WEB CRACKED AT BS 847, BETWEEN STR 25R TO STR 26R. REPAIRED WEB PER SRM.SDR SWAA050940Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, BELOW RT CREASE BEAM WEB. REPAIRED FRAME PER TYPICAL REPAIR.SDR SWAA050935Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, BELOW LT CREASE BEAM WEB. REPAIRED FRAME PER TYPICAL REPAIR.SDR VTZA200500022Frame · crackedRT FS 718 FRAME CRACKED AT 1 INCH IN LENGTH CRACK IN RADIUS.SDR 05FDEA00665Frame · corrodedA/C COMPARTMENT FRAME 42, 5 O'CLOCK POSITION FRAME IS CORRODED. REMOVED CORROSION AND REPAIRED FR 42 AT 5 O'CLOCK POSITION IAW EA 6-5310-87135.SDR 05FDEA00663Frame · misdrilledFOUND STUB FRAME BS 985 RT SIDE TO BE MISDRILLED AND CRACKED AT TWO SHEAR TIE LOCATIONS. REMOVED AND REPLACED STUB FRAME AT BS 985 PER SRM 51-30-02.SDR SWAA050914Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER PAE ER.SDR 72300121Frame · corrodedA 1 X 16 INCH AREA OF CORROSION ON CHORD.SDR 72300120Frame · corrodedA 1 X 5 INCH AREA OF CORROSION ON CHORD.SDR SWAA050917Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELT FRAME CORRODED AT BS 787, LBL 51.5. REPAIRED FRAME PER SWA EA.SDR SWAA050911Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65, WL 201. REPAIRED FRAME PER PAE ER.SDR DHL2005805590Frame · crackedMAIN CARGO COMPT "Z" FRAME INBD FLANGE CRACKED 2.000 STA 80.000 L-20.5R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2 SHEET 2, 6 TR NR 53-110, SRM 53-4-1 FIG 40. REMOVED FASTENERS IAW SRM 51-1-20D PAGE 21, SRM 51-1-21 PAGE 1. TRIMMED OUT DAMAGSDR SWAA050890Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER PAE ER.SDR SWAA050889Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER PAE ER.SDR SWAA050888Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE CHORD CRACKED AT BS 727, RBL 30. REPAIRED CHORD PER PAE ER.SDR SWAA050887Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA050884Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 64, WL 202. REPAIRED FRAME PER PAE ER.SDR SWAA050883Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R. REPAIRED FRAME PER PAE ER.SDR ABXA050077Frame · corrodedAFT LOWER SECTION OF FRAME CORRODED FS 503, LONGERON 29 LEFT TO LONGERON 29 RIGHT. REPAIRED FRAME IAW DC-9 SRM 53-03.SDR DHL2005805565Frame · misdrilledMAIN CARGO COMPT L-12L HOLES (8EA) MISDRILLED BETWEEN FRAME STA 520.000 AND FRAME STA 540.000 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-15-05 EO AST 050216 DATE 03-02-05. PERFORMED DETAILED VISUAL INSPECTION NO CRACK FOUND. CLEANED,SDR 05FDEA00627Frame · crackedREF. SNRM# N00525 MAIN CABIN FRAME 37 CLS ADAPTER -Y040 IS GOUGED AND CRACKED (BETWEEN SEAT TRACK 2 AND 3 LT). REMOVED AND REPLACED CLS ADAPTER PER A310 SRM 51-72-10 TREATED, PRIMED AND TOP COATED AREA AND FASTENERS PER A310-200 SRM 51-75-10.SDR SWAA050870Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT CUTOUT FRAME CRACKED AT BS 490, RBL 37, WL 158. REPAIRED FRAME PER PAE ER.SDR COMA0560192Frame · crackedRIGHT HAND 621.00 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR COMA0560189Frame · crackedLEFT HAND 621.00 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR 05FDEA00611Frame · damagedDURING INSPECTION FOUND AT STA 1701 FROM STR 45 RT TO 45 LT RETAINER WITH CORROSION. REMOVED CORROSION ON RETAINER PER SRM 51-21-01. PERFORMED CHECK LIMITS; THE MATERIAL REMOVED IS WITHIN LIMITS PER SRM 53-00-01. PROTECTED AREA PER SRM 51-21-01. (OPEN)SDR DHL2005740548Frame · damagedREMOVED PREVIOUS REPAIR FUSELAGE FRAME BS 580 STR 16R AND 17R IAW B727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MAT USED 7075T6 .071 PO 9001737 DEM 6" BY 5" IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. ALODINED AND PRIMED AREA AND PART IAW B727 SRM 51-40-2.SDR DHL2005805553Frame · wornMAIN CARGO COMPT FRAME WORN, STA 700.000 L-8 L-9R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-04-05, EO AST 050217 DATE 03-03-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. CLEANED, TREATED AND PRIMED MISDRILLED HOLES AREASDR DHL2005805544Frame · misdrilledMAIN CARGO COMPT L-ANGLE FRAME HOLES (2EA) MISDRILLED, STA 920.000 BETWEEN L-12 AND L-13R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 02-28-05, EO AST 050206 DATE 02-24-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. FABRICATESDR DHL2005805549Frame · misdrilledMAIN CARGO COMPT. "Z" FRAME INBD FLANGE HOLES (2EA) MISDRILLED STA 980.000 L-12 - L-13L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 02-25-05, EO NR AST050202 DATE 02-17-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. CLEANED, SDR DHL2005805587Frame · misdrilledMAIN CARGO COMPT FRAME INBD FLANGE (1EA) MISDRILLED HOLE STA 1460.000 L-17R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-04-05 EO NR AST 050217 DATED 03-03-05. PERFORMED DETAIL VISUAL INSP. NO CRACK FOUND. CLEANED, TREATED AND PRIMEDSDR DHL2005805591Frame · misdrilledMAIN CARGO COMPT "Z" FRAME INBD FLANGE (4EA) MISDRILLED HOLES AND WEAR AT STA 80.000 BETWEEN L-14R AND L-17R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FA FORM 8110-3 DATED 03-15-05, EO NR AST 050219 DATED 03-07-05. PERFORMED DETAIL VISUAL INSP. NO CRACK FOSDR DHL2005805586Frame · crackedMAIN CARGO COMPT FRAME SUPPORT ANGLE CRACKED AT STA 700.000 L-10R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-14-05 EO NR AST 050222 DATE 03-09-05. REMOVED DAMAGED SUPPORT ANGLE IAW SRM 51-1-21 PG 1. PERFORMED DETAILED VISUAL INSPECTISDR DHL2005805594Frame · misdrilledMAIN CARGO COMPT "Z" FRAME INBD FLANGE HOLES (2EA) MISDRILLED AT STA 1100.000 L-8R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-04-05 EO NR AST 050213 DATE 03-02-05. PERFORMED DETAILED VISUAL INSPECTION TO AREA. NO CRACK FOUND. FABRICSDR DHL2005805596Frame · crackedMAIN CARGO COMPT FRAME (1EA) ANGLE CRACKED STA 480.000 L-8R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-14-05 EO NR AST 050222 DATED 03-09-05. REMOVED CRACKED SUPPORT ANGLE IAW SRM 51-1-21 PG 1. PERFORMED DETAIL VISUAL INSP. NO CRACSDR DHL2005805592Frame · misdrilledMAIN CARGO COMPT FRAME HOLE MISDRILLED 0.1875 STA 902.000 L-12 L-13L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 02-25-05 EO NR AST 050210 DATE 02-21-05. PERFORMED NDT INSPECTION (DETAILED). NO CRACK FOUND. CLEANED, TREATED AND PRIMED MSDR DHL2005805681Frame · misdrilledMAIN CABIN INTERIOR "Z" FRAME INBD FLANGE HOLE MISDRILLED STA 1000.000 L-6R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 02-25-05 EO NR AST 050204 DATE 02-18-05. PERFORMED NDT INSPECTION TO AREA IAW NDT SPM PART 06-10-01-001. FABRICATED RSDR DHL2005805684Frame · misdrilledMAIN CARGO COMPT FRAME HOLE (1EA) MISDRILLED 0.1875 STA 700.000 L-11 L-12L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 02-25-05 EO NR AST 050210 DATE 02-21-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. CLEANED, TREATED AND PSDR DHL2005805540Frame · misdrilledMAIN CARGO COMPT FRAME MISDRILLED HOLES VERTICAL FLANGE (STA 100.000-1560.000, BETWEEN L-19L AND L-19R) (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-16-05, EO NR AST 050223 DATED 02-24-05. PERFORMED DETAIL VISUAL INSP. NO CRACK FOUND.SDR DHL2005805534Frame · misdrilledMAIN CARGO COMPT FRAME HOLES (2EA) MISDRILLED 0.15625, STA 920.000 L-12L L-13L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FORM 8110-3 DATE 02-28-05, EO NR AST050206 DATE 02-24-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. FABRICATED NEW CLIP (ASDR DHL2005805563Frame · misdrilledMAIN CARGO COMPT FRAME MISDRILLED HOLE AT STA 702.000 L-11L TO L-12L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 02-25-05, EO AST 050202 DATED 02-17-05. PERFORMED DETAIL VISUAL INSPECTION NO CRACK FOUND. CLEANED, TREATED AND PRIMED MISDSDR DHL2005805564Frame · misdrilledMAIN CARGO COMPT FRAME MISDRILLED HOLE AT STA 702.000 L-12L TO L-13L 1EA (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 02-25-05, EO AST 050202 DATED 02-17-05. PERFORMED DETAIL VISUAL INSPECTION NO CRACK FOUND. CLEANED, TREATED AND PRIMED SDR DHL2005805562Frame · misdrilledMAIN CARGO COMPT CLIP FRAME HOLES (3EA) MISDRILLED AT STA 960.000 L-13R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-13-05, EO AST 050220 DATE 03-08-05. REMOVED DAMAGED CLIP IAW SRM 51-1-21 PAGE 1. PERFORMED DETAILED VISUAL INSPECTION.SDR DHL2005805603Frame · misdrilledMAIN CARGO COMPT FRAME HOLE MISDRILLED STA 660.000 BETWEEN L-12 AND L-13L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-15-05 EO AST 050211 DATE 02-24-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. CLEANED, TREATED AND PRIMESDR DHL2005805620Frame · misdrilledMAIN CARGO COMPT FRAME INBOARD FLANGE (1EA) MISDRILLED HOLE AT STA 1140.000 L-6R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-04-05 EO AST 050217 DATED 03-03-05. PERFORMED DETAIL VISUAL INSPECTION NO CRACK FOUND. PERFORMED CLEANING, TSDR DHL2005805679Frame · misdrilledMAIN CARGO COMPT FRAME HOLES (4EA) MISDRILLED 0.1875, STA 902.000 L-9 L-10L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-09-05 EO AST 050208 DATE 02-21-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. FABRICATED DOUBLER STRAPSDR DHL2005805632Frame · misdrilledMAIN CARGO COMPT INBOARD FLANGE Z-FRAME (1) HOLE MISDRILLED AT STA 340.000 L-8 L-9R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-04-05 EO AST 050217 DATE 03-03-05. PERFORMED NDT INSPECTION (DETAILED). NO CRACK FOUND. CLEANED, TREATED SDR DHL2005805682Frame · misdrilledMAIN CARGO COMPT FRAME HOLES (4EA) MISDRILLED STA 902.000 L-10R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 02-25-05 EO AST 050207 DATE 02-19-05. FABRICATED DOUBLER STRAP (AL7075T6 0.250) IAW EO AST 050207. PERFORMED DETAILED VISUAL INSPSDR DHL2005805598Frame · misdrilledMAIN CARGO COMPT FRAME MISDRILLED HOLE OF 0.15625 AT STA 880.000 L-12L TO L-13L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 02-25-05 EO NR AST 050202 DATED 02-17-05. PERFORMED DETAIL VISUAL INSP. NO CRACK FOUND. CLEANED, TREATED AND PRSDR DHL2005805561Frame · misdrilledMAIN CARGO COMPT FRAME WORN STA 460.000, L-10R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-04-05, EO NR AST 050217 DATE 03-03-05. PERFORMED DETAILED VISUAL INSPECTION. NO CRACK FOUND. CLEANED, TREATED AND PRIMED MISDRILLED HOLES AREA
Back to JASC 5311