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 CALA2012082400536Frame · crackedFRAME, BS 500A CRACKED AT FASTENER HOLE. REPAIRED IAW EA 5310-04716, REV C, OP 1.SDR CALA2012082400535Frame · crackedFRAME AT BS 550A RT BETWEEN STRINGER 8R AND 9R IS CRACKED AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT BRACKET INBD ATTACH FASTENER CRACK. NOTED DURING ACCOMPLISHMENT OF STEP 4 OF EA 5310-04716, REV C, MFEC. REPAIRED IAW EA 5310-04716 REV C, OP 1.SDR HYIA08242012002Spar · damagedDURING A REGULARLY SCHEDULED MX INSPECTION, AFT CARRY THROUGH SPAR (CENTER SECTION) UPPER CAP AND CORRESPONDING WEB FLANGES WERE FOUND TO HAVE MISDRILLED DAMAGE FROM PREVIOUS REPAIR ATTEMPTS. UPON ACFT ARRIVAL IN FACILITY, A REPAIR WAS DEVELOPED IAW REPAIR DEFSDR ABXA20120823282Failsafe · crackedRIGHT FAILSAFE STRAP MID HOLE 3/16 CRACK, LWR HOLE 3/16 CRACK. TRIM OUT AND TERMINATION ACTION ACCOMPLISHED ON EA 53500014-003. DOCUMENT 47008ORD04. NO FURTHER ACTION REQUIRED, ACFT WAS GROUNDED.SDR SWAA2012090607399Strap · crackedFRAME CRACKED STRAP AT BS 992.8, BETWEEN STR STR 10L TO STR 20L. REMOVED AND REPLACED STRAP IAW EO AND EA.SDR QXEA2012082300960Frame · corrodedFRAME 584.5 HAS CORROSION BETWEEN STR 32-31P. REMOVED FASTENERS AS NEEDED AND REMOVED CORROSION IAW RD 8/4-53-2344. MIN THICKNESS NOTED .046". CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND ISDR QXEA2012082300922Frame · corrodedFRAME 116 HAS CORROSION BETWEEN STR 33 - 31S. REMOVED FASTENERS AS NECESSARY FOM IAW RD 8/4-53-2344. BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PTSDR QXEA2012082300921Frame · corrodedFRAME 116 HAS CORROSION BETWEEN STR 33-29P. REMOVED RIVETS AS NECESSARY IAW RD 8/4-53-2344. BLENDED CORROSION IAW RD 8/4-53-2344. POLISHED SURFACE IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .038", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-80SDR QXEA2012082300917Frame · corrodedFRAME BS 258 HAS CORROSION BETWEEN STR 30-27P. REMOVED RIVETS AS NECESSARY IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AFFECTED AREA CRACK FREE, MIN REMAINING THICKNESS .037" REF NTM 51-00-06-910-801 PT 1 AND 51-00-06-910-801SDR QXEA2012082300911Frame · corrodedFRAME 176 HAS CORROSION BETWEEN STR 31-29P. REMOVED FASTENERS FOM IAW RD 8/4-53-2344. CLEANED AND BLENDED OUT CORROSION IAW SRM 51-26-00-02-01 AND RD 8/4-53-2344. MIN REMAINING THICKNESS .037", CONFIRMED CRACK FREE AREA REF 51-00-04-910-801 PT 1 AND 51-00-0SDR QXEA2012082300877Frame · corrodedFRAME X156 FLANGES BETWEEN STRS 26P-33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVETS AS REQUIRED IAW SRM 51-42-05-02-01, REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. MIN REMAINING THICKNESS .037 REF SDR QXEA2012082300876Frame · corrodedFRAME X94.8 FLANGES, BETWEEN STRS 26S-29S AND 30S-33, BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVET AS NECESSARY, REMOVED CORROSION AND LOOSE PAINT IAW SRM 51-42-05-02-01, 51-21-00-00-02 AND 51-26-00-02-03. MIN REMAINING THICKNESS NOTED .037 REF NTM 51-00SDR QXEA2012082300874Frame · corrodedFRAME X683, FLANGES BETWEEN STRS 31S-31P BUBBLING PAINT/PROBABLE CORROSION. CLEANED FRAME IAW SRM 51-26-00-02-01. REMOVED RIVETS AS NECESSARY IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS FOUND WITHIN LIMITS OF RSDR QXEA2012082300884Frame · corrodedFRAME X136, FLANGES BETWEEN STRS 29S-33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVETS AS NECESSARY AND REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .036" REF NTM 51-00-04-910-801 PT 1. CONFIRMED AREA CRACK FREE RESDR UALA2012082404758Frame · crackedCABIN FRAME CRACKED BS 867 STR 8R. MAJOR REPAIR ACP'D, INSTALLED REPAIR ANGLE DOUBLERS PER MM 53-10-84 AT HMV3 ON NR11194-2000-0028. THIS REPAIR NEEDS A ONE TIME INSPECTION PER MM 53-10-84-601 BETWEEN 18000 & 24000 FROM CURRENT PTC 24573.SDR CALA2012082400534Frame · crackedFRAME BS 867 CRACKED BETWEEN STR 8R AND 9R. REPAIRED FRAME IAW EA 5310-04716, REV C, OP 1, FIG 3.SDR CALA2012082400533Frame · crackedFRAME BS 500C CRACKED BETWEEN STR 8R AND 9R. REPAIRED IAW EA 5310-04716, REV C, OP 1, FIG 3.SDR CALA2012082400532Frame · crackedFRAME BS 440 CRACKED BETWEEN STR 8R AND 9R, REPAIRED IAW EA 5310-04716, REV C, OP 1, FIG 3.SDR CALA2012082400531Frame · crackedFRAME BS 440 CRACKED BETWEEN STR 8L AND STR 9L, REPAIRED IAW EA 5310-04716, REV C, OP 1, FIG 3.SDR QXEA2012082200975Frame · corrodedFRAME X116, FLANGES BETWEEN STRS 25P-33 BUBBLING PAINT PROBABLE CORROSION. BLENDED CORROSION IAW RD 8/4-53-2344. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. CLEANED AREA IIAW SRM 51-26-00-02-01. REMOVED CORROSION IAW SRM 53-20-15-00-01. FOUND FRAME OUT OF LSDR QXEA2012082200923Frame · corrodedFRAME 136 HAS CORROSION BETWEEN STR 32-31P. REMOVED FASTENERS FOM IAW RD 8/4-53-2344. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039, CONFIRMED AFFECTED AREA CRACK FREE REF 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. FRAME IS WSDR QXEA2012082300920Frame · corrodedFRAME 94.8 HAS CORROSION BETWEEN STR 33-30P. REMOVED RIVETS AS NECESSARY IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .036", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PSDR QXEA2012082200919Frame · corrodedFRAME 19.4 HAS CORROSION AT STR 31P. REMOVED RIVETS AS NECESSARY, IAW SRM 51-42-05-02-01. CLEANED AND BLENDED OUT CORROSION IAW SRM 51-26-00-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .037", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801,SDR QXEA2012082200918Frame · corrodedFRAME 1.0 FLANGE HAS CORROSION BETWEEN STR 32-31S. REMOVED RIVETS AS REQUIRED IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. POLISHED SURFACE REF RD 8/4-53-2344. MIN REMAINING THICKNESS .046, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND SDR QXEA2012082200880Frame · corrodedFRAME X216, FLANGES BETWEEN STRS 27P-33, BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. CLEANED IAW SRM 51-26-10-02-01. CORROSION FOUND ON FLANGES AND WEB OF FRAME, REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICSDR QXEA2012082200879Frame · corrodedFRAME X216, FLANGES BETWEEN STRS 28S-31S BUBBLING PAINT PROBABLE CORROSION. CLEANED FRAME IAW SRM 51-26-10-02-01. REMOVED RIVETS AS REQUIRED IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .038 REF NTM 51-00-04-910-801SDR QXEA2012082200878Frame · corrodedFRAME X196, BETWEEN S27-28P AND 29-33P, INCLUDING WEB, BUBBLING PAINT. PROBABLE CORROSION. CLEANED AND REMOVED LOOSE PAINT IAW SRM 51-26-10-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .034, CONFIRMED AFFECTED AREA CRACK FREE RESDR QXEA2012082200895Frame · corrodedFRAME X116 FLANGES, BETWEEN STRS 27S-33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVETS AS NECESSARY, REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND INSDR QXEA2012082200887Frame · corrodedFRAME FLANGES AT STR 26S BUBBLING PAINT PROBABLE CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02. REMAINING THICKNESS .030", CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS IN LIMITS IAW RD 8/4-53-4726. ASDR CHQA20120822298Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON FRAME 65 AT LATERAL "L" AT THE CARGO DOOR THRESHOLD. FRAME 65 WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-011847 AND SRM 51-40-02.SDR QXEA2012082200861Frame · corrodedFRAME X196, FLANGES BETWEEN STRS 28S-32S, BUBBLING PAINT PROBABLE CORROSION. REMOVED RIVETS IAW SRM 51-42-05-02-01. CLEANED AND REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .036" REF NTM 51-00-04-910-801 PT 1. CONFIRMED AFFECTED AREA CSDR SWAA2012082406975Frame · crackedL1 WINDOW POST CRACKED IN TOP LEFT CORNER. REPAIRED FRAME PER EA.SDR QXEA2012082200856Frame · corrodedFRAME X176, FLANGES BETWEEN STRS 28S-33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED RESERVOIR TANK FOM IAW AMM 52-12-01-000-801 AND REMOVED RIVET TO ACCESS CORROSION IAW SRM 51-40-07-02-01. BLENDED OUT CORROSION IAW SRM 51-21-00-00-02 AND RD 8/4-53-2344. MINSDR QXEA2012082200844Frame · corrodedFRAME X32.4 AND APPROX 1 FT INBD FROM FWD PAX DOOR LONGITUDINAL CHANNEL SHOWS CORROSION. REMOVED NUTPLATE FOM IAW SRM 51-42-05-02-01, REMOVED CORROSION IAW SRM 51-21-00-00-02. CHANNEL FOUND TO BE OUT OF LIMITS IAW SRM 53-20-43-00-01 ITEM 66. REMOVED DAMAGEDSDR SPUY20120820042Frame · corrodedDURING ROUTINE C CHECK INSPECTION, LOWER NOSE COMPT - FRAME WEB CORRODED AT BS 351.2 LBL 9 RBL 18 REF NR 1292.SDR SPUY20120820038Frame · crackedDURING ROUTINE C CHECK INSPECTION, AIR CONDITIONING DISTRIBUTION BAY - FRAME HAS A 1 INCH CRACK AT BS 740 STRINGER 20 – 21L REF NR 0442.SDR SWAA2012092407886Frame · crackedFRAME CRACKED AT BS 807, RBL 19.5. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012091107510Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA2012091107509Frame · corrodedFRAME CORRODED AT BS 727E, BEWTEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR QXEA2012082100974Frame · corrodedFRAME X136, FLANGES BETWEEN STRS 26P-33 BUBBLING PAINT PROBABLE CORROSION. REMOVED FASTENERS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .037" REF NTM 51-00-04-910-801 PT 1. MATERIAL LOSS FOUND OUT OSDR AALA20120821008Frame · damagedFRAME AT STATION 231.25 RIGHT TO LEFT BUTTLINE 7 DAMAGED. INSTALLED DOUBLER REPAIR PER EA B757-53-025619.SDR QXEA2012082100854Frame · corrodedFRAME X1.0 FROM RT INBD SEAT TRACK RUNNING OTBD, MULTIPLE CORRODING FASTENERS. CLEANED AREA IAW SRM 51-26-10-02-01. REMOVED RIVETS FOM. BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .046", CONFIRMED AFFECTED AREA CRACSDR QXEA2012082100846Frame · corrodedFRAME X-18.25 FLANGES BETWEEN STRS 30P-33, BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-01. MIN REMAINING THICKNESS NOTED .038" REF NTM 51-00-04-910-801 PT 1. PERFORMED THICKNESS GRID OSDR QXEA2012082100836Frame · corrodedFRAME BS 341 FLANGES, BETWEEN STRS 31P-33 BUBBLING PAINT/PROBABLE CORROSION. CLEANED FRAME FLANGES IAW SRM 51-26-00-02-01. REMOVED PAINT IAW SRM 51-26-10-02-01. CLEANED, REMOVED RIVETS AND CORROSION IAW 51-21-00-00-02, AND 51-42-05-02-01. MIN REMAINING THICSDR DALA1248013730Frame · crackedFUSELAGE FRAME CRACKED AT BS 380 STR 8R. REPAIRED IAW ER/A 504544-14AD.SDR DALA1247413730Frame · crackedFUSELAGE FRAME CRACKED AT STATION 440 STRINGER 8R. REPAIRED IAW ERA 504544-14AD.SDR DALA1247403730Frame · crackedFUSELAGE FRAME CRACKED AT BS 400 STRINGER 8R. REPAIRED IAW ERA 504544-14AD.SDR DALA1247393730Frame · crackedFUSELAGE FRAME CRACKED AT BS 400 STRINGER 8L. REPAIRED IAW ERA 504544-14AD.SDR QXEA2012082100857Frame · corrodedFRAME X176 FLANGES BETWEEN STRS 26S-33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED RESERVOIR TANK FOM IAW AMM 52-12-01-000-801. CLEANED AREA IAW SRM 51-26-00-02-01. REMOVED FASTENERS TO ACCESS CORROSION IAW 51-40-07-02-01. REMOVED CORROSION IAW SRM 51-21-00SDR QXEA2012082000855Frame · corrodedFRAME X19.4 FLANGES BETWEEN STRS 32P-33, BUBBLING PAINT/PROBABLE CORROSION. CLEANED FLANGES IAW SRM 51-26-00-02-01. REMOVED FASTENERS AND CORROSION IAW RD 8/4-53-2344. FRAME FOUND TO BE OUT OF LIMTS IAW SRM 53-20-15-00-01. REMOVED FRAME SECTION AND INTERCOS
Back to JASC 5311