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 QXEA2011122701436Frame · corrodedFRAME 71.2 FLANGE IS CORRODED STR 31S TO 32S. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED AND PAINTED IAW 51-21-10-02-01SDR QXEA2011122701435Frame · corrodedFRAME 236 FLANGE IS CORRODED STR 31P TO 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED IAW 51-21-10-02-01, 51-25-10-02SDR QXEA2011122701431Frame · corrodedFRAME 301, FLANGE IS CORRODED STR 32P TO 33. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED AND PAINTED IAW 51-21-10-02-01,SDR QXEA2011122701430Frame · corrodedFRAME 301, FLANGE IS CORRODED STR 32S TO 31S. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED AND PAINTED IAW 51-21-10-02-01SDR QXEA2011122701429Frame · corrodedFRAME 664.5, FLANGE IS CORRODED STR 23P TO 24P. REMOVED CORROSION IAW SRM 51-21-00-00-01. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. TREATED, PRIMED AND PAINTED IAW RD 8/4-53-2344.SDR CALA2011122300822Frame · crackedSUPPORT TASK RT CABIN AREA CRACK FOUND AT FRAME STA 400 AND BEETWEN STR 8 AND 9 BY FRAME RADIUS PER EA 5310-04716 REV C. REPAIRED PER ECRA 5310-05431, SEE WORKED ACCOMPLISH FORM FORM 44.0008 ATTACHED.SDR AALA20120113TUL02Beltframe · crackedBELTFRAME CRACKED AT STATION 440R AFT SIDE AT INBOARD ATTACH BRACKET RIVET HOLE. INSTALLED DOUBLER PER ECO J1159AD.SDR FDEA201112215404Frame · chafedAFT LWR CARGO COMP, FRAME AT BS 1520 UPPER SURFACE CHAFED BETWEEN STRINGER 22 & 23R. REPAIR CARRIED OUT ON FRAME AT STA 1520 BETWEEN S-22R AND S-23R IAW EA F-5310-153485. REPAIR IS CLASSIFIED AS MAJOR.SDR USAA2012010500021Frame · crackedQ6 CHECK - CRACK IN FUSELAGE FRAME AT BS500G, S21L. REPAIRED FRAME AT BS 500G, S21L IAW B737 SRM 53-00-07-2R REPAIR 13.SDR SWAA118743Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND CORROSION ON FRAME TEAR-STRAP AFT CARGO, BS 727E, STR 27L AND 27R. REMOVED AND REPLACED CORRODED PART PER SRM.SDR COEA2011122146801Frame · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: FRAME 24 HAS CORROSION BETWEEN STR 19-20R FORWARD SIDE (LENGTH 6", WIDTH 2", DEPTH .011"). REMOVED CORROSION, FABRICATED AND INSTALLED DOUBLER IAW ATR72 SRM.SDR AALA20111221TUL05Beltframe · crackedBELL FRAME CRACKED STATION 400 RIGHT. INSTALLED FRAME REPAIR DOUBLER PER J1159AD.SDR AALA20111221TUL03Beltframe · crackedCABIN BELLFRAME CRACKED AT OVERHEAD BIN ATTACH BRACKET. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD.SDR FDEA201112215410Frame · corrodedAFTER REMOVAL OF FLOOR SUPPORT AT STA 1500, RBL 2.50 FOUND CORROSION ON FRAME IN AFT CARGO PIT. REMOVED CORROSION AT FRAME IAW SRM 51-10-02. BLENDED AREA. ORIGINAL MATERIAL .063, MATERIAL LOSS .033, MATERIAL REMAINING .030. FOUND OUT OF LIMITS IAW SRM 53-SDR A6WA201240107Frame · dented2ND FRAME INSIDE AEB COMPARTMENT- FWD FROM THE AEB DOOR CUT OUT IS DENTED AT ABOUT 5:00 POSITION. CUTOUT DAMAGED SECTION OF FRAME AND FABRICATED NEW PARTS IAW REO 601R-53-61-4333.SDR DALA1204769018Window Frame · scratchedSCRATCHES ON AFT LOWER CORNER OF RT WINDOW BELT FRAME BTW STA Y=1193 TO Y=1212 ALSO ON STA Y=1212 TO 1231. SCRATCHES REWORK IAW DC9/MD80 SRM 53-05 FIG 111. REWORK AS STATED AS H1 WILL CONTINUE SERVICE IN AS-IS COND, BUT WITH RESTRICTIONS STATED ON ERA 498184SDR DALA1204759018Frame · scratchedSCRATCH ON FWD LOWER CORNER OF RT WINDOW BELT FRAME BTW STA Y=693 AND Y=712. HFEC PERFROME IAW NDT SPM 06-10-01.001 NO CRACKS FOUND. REWORK STATED AS 'G' WILL CONTINUE SERVICE IN AS-IS COND BUT WITH RESTRICTIONS STATED ON ERA 498184-14 REV-ORIG.SDR FDEA201112205374Frame · damagedAFT LWR CARGO COMP, AFTER REMOVAL OF FASTENERS FOUND FRAME BS 1380 HAS ELONGATED HOLE BETWEEN STR 25 & 26R. REPAIR CARRIED OUT IAW EA F-5310-157117. REPAIR IS CLASSIFIED AS MAJOR.SDR QXEA2011122801442Frame · damagedFRAME 258.5 UPPER FLANGE IS DAMAGED STR 26P TO 27P. REMOVED DAMAGE TO FRAME IAW SRM 51-14-00-02-01. CONFIRMED AREA CRACK FREE REF 51-00-02-250-801 AND 51-00-01-250-801. FRAME FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-4195. ALODINED, PRIMED AND APPLIED ALUMINSDR QXEA2011122701434Frame · corrodedFRAME 258.5, FLANGE IS CORRODED STR 29S TO 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED AND PAINTED IAW 51-21-10-02-SDR QXEA2011122701433Frame · corrodedFRAME 258.5, FLANGE IS CORRODED STR 29P TO 30P. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED AND PAINTED IAW 51-21-10-02-SDR AALA20111220TUL01Frame · cracked1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00.SDR CALA2011122000816Frame · corrodedFWD CARGO BIN LEFT SIDE FRAME CORRODED JUST O/B OF LEFT Z-CHANNEL STA 500D STR 25L. REMOVED AND REPLACED DAMAGED / CORRODED FRAME SECTION AT STA 500 D STR 25L AREA WITH FABRICATED CHANNEL AND REPAIR SPLICE. ALL PARTIAL WORK NOTED. SEE ATTACHED FORM 44.0008 SDR SWAA118601Failsafe · corrodedDURING SCHEDULED 20Y CHECK, FOUND FAIL-SAFE CHORD CORRODED AT BS 747, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED CHORD IAW SRM.SDR FDEA201112205389Frame · misrepairedFRAME BS 800 BETWEEN S28L TO S28R MISREPAIRED. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR AALA20120118TUL15Beltframe · crackedSTATION 500C RIGHT BELLFRAME CRACKED AT AIR-CONDITIONER RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR AALA20120118TUL14Beltframe · crackedSTATION 500A RIGHT BELLFRAME CRACKED AT AIR-CONDITIONER RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR AALA20120118TUL13Beltframe · crackedSTATION 480 RIGHT BELLFRAME CRACKED AT AIR-CONDITIONER RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR AALA20120118TUL12Beltframe · crackedSTATION 400 LEFT BELLFRAME CRACKED AT AIR-CONDITIONER RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR AALA20111219TUL03Beltframe · crackedSTATION 400 RIGHT BELLFRAME CRACKED AT AIR-CONDITIONER. INSTALLED REPAIR DOUBLER PER ECO J1159AD.SDR QXEA2011122701432Frame · corrodedFRAME 281, FLANGE IS CORRODED STR 31P TO 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. TREATED, PRIMED AND PAINTED IAW 51-21-10-02-01SDR QXEA2011122701428Frame · corrodedFRAME 32.4 FLANGES ARE CORRODED STR 30S TO 28S. REMOVED CORROSION IAW SRM 51-21-00-00-02. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD8/4-53-2344. ALODINED AND PRIMED IAW RD 8/4-53-2344. RESTORED SURFACE PROTECTION REF SRM 51-21-10-02-01, 51-25-10-02-01,SDR QXEA2011122101419Frame · corrodedDURING C-CHECK, UPON REMOVAL OF NVS CIRCUIT BREAKER BOX MOUNT TRAY FOUND FRAME 258.5 FLANGE CORRODED STR 31P-32P. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE IN BLEND AREA REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDS FOUND WITHIN LIMSDR QXEA2011122301424Frame · corrodedFRAME 32.4 FLANGES AND VERTICAL SURFACE ARE CORRODED STR 33 TO 30P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .037, CONFIRMED CRACK FREE REF 51-00-02-250-801 AND 51-00-01-250-801. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53SDR SWAA118588Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616. REPAIRED CHORD IAW EA.SDR SWAA118571Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA118565Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 540, STR 27R. REPAIRED FRAME PER EA.SDR SWAA118552Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND LT FRAME INNER CHORD CRACKED AT BS 616. REPAIRED CHORD PER EA.SDR SWAA118551Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, STR 17R. REPAIRED CHORD IAW EA.SDR SWAA118548Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA118540Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME IAW EA.SDR FDEA201112195362Frame · chafedFRAME AT BS 1280, STR 13 - 14R CHAFED. REPAIRED IAW SRM 53-00-07, REPAIR 3, FIG 201, REV.104. REPAIR CLASSIFIED AS MAJOR.SDR SWAA118507Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 492.4. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA118506Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 20R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA118505Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727A, STR 17R. REPAIRED FRAME IAW DWG.SDR AALA20111217TUL04Frame · crackedCRACK IN MAIN FRAME AT STATION 395 AND LEFT BUTTLINE 24. PERMANENT REPAIR ACCOMPLISHED PER EA B757-53-020928.SDR USAA2011122000009Frame · crackedCDFI VISIT - CRACK ON FUSELAGE FRAME AT BF500F BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BF500F BETWEEN S20L TO S21L IAW B737 SRM 53-00-07, REPAIR 13.SDR AALA20111216TUL06Beltframe · crackedSTATION 380 BELLFRAME CRACKED AT INBOARD ATTACH RIVET FOR LEFT AIR CONDITIONING RAIL BRACKET. INSTALLED REPAIR ANGLES ON FRAME STATION 380 LEFT PER ECO J1159AD.SDR TRBA2011353001Frame · crackedDURING MX BASE VISIT FOUND THE RT SIDE FRAME NR 25 CRACKED. THE ACFT WAS REMOVED FROM SERVICE. PERFORM TEMPORARY REPAIR OF FRAME NR 25 IAW E2-3200-065 ITEM PLACED ON TDMI CHECK EVERY 200FH AUT 3993204A4 UNTIL PERMANENT REPAIR AT 700FH AUT 3993204A5 ACCOMPLISSDR ASOA201200056Frame · corrodedGROUND WIRE STUD AT FS 333, S26R CORRODED. REMOVED AND REPLACED FRAME IAW SRM 51-42-06.
Back to JASC 5311