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 QXEA2011072200556Frame · corrodedFRAME X116.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .044. CONFIRMED CRACK FREE CONDITION. BLEND IS WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CORRSDR QXEA2011072200555Frame · corrodedFRAME X156.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS IS .046". CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLEND IS WITHIN LIMITS OF RD 8/4-53-2344. ALSDR SWAA115247Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115244Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 188, WL 208. REPAIRED FRAME IAW SRM.SDR FDEA201107202852Frame Splice · crackedCABIN FRAME SPLICE AT BS 930, STR 14R HAS CRACK INDICATING AT SPLICE. CUT OUT DAMAGED AREA IAW SRM 53-10-4 FIG 1. FABRICATED REPAIR PARTS IAW SRM 53-10 4 FIG 1. INSTALLED REPAIR PARTS IAW SRM 51-30-2 AND 53-10-4 FIG 1SDR FDEA201107202828Frame · dentedCABIN BS 1681 L11L FRAME FOUND DENTED. DENT REPAIRED AS PER SRM 53-00-07 FIG 201 REV 47. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV 112. INITIAL INSPECTION AT 14,500 CYCLE AND REPETITIVE INSPECTION AT 9,500 CYCLE USING HFEC METHOD.SDR QXEA2011072200577Frame · corrodedFRAME X281.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW SRM 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .043". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITSDR QXEA2011072200571Frame · corrodedFRAME X136.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .045". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHISDR QXEA2011072200570Frame · corrodedFRAME X32.400 LOWER FLANGE HAVE CORROSION BETWEEN STRINGERS 29P AND 31P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS MEASURED .039". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WISDR QXEA2011072200569Frame · corrodedFRAME X32.400 LOWER FLANGE HAVE CORROSION BETWEEN STRINGERS 29S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .040". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHINSDR QXEA2011072200568Frame · corrodedFRAME X32.400 LOWER FLANGE HAVE CORROSION BETWEEN STRINGERS 28S AND 29S. BLENDED CORROSION IAW Q400 RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .038". CONFIRMED CRACK FREE CONDITION REF Q400 NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREASDR QXEA2011072200567Frame · corrodedFRAME X1.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 28S AND 29S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS MEASURED .044". CONFIRMED CRACK FREE CONDITION REF NTM 51-00-02-250-801 AND 51-00-01-250-801. BLENDED AREA IS WITHINSDR QXEA2011072200548Frame · corrodedFRAME X49.500 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW SRM 51-21-00-00-01. FOUND FLANGES TO BE WITHIN LIMITS PER RD 8/4-53-2344. TREATED,PRIMED AND PAINTED PER RD 8/4-53-2344.SDR QXEA201107220547Frame · corrodedFRAME X49.500 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW SRM 51-21-00-00-01. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. TREATED,PRIMED AND PAINTED IAW RD 8/4-53-2344SDR AALA20110720TUL05Frame · cracked1510 CANT FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER SRM 53-01-00 AND 53-14-04.SDR SWAA115226Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA115219Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME ANGLE CORRODED AT BS 807, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115218Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 25R TO STR 26R. RREMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115217Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, STR 25R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115215Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115212Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115210Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115209Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME IAW DWG AND SRM.SDR SWAA115208Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 27L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115206Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201107202842Frame · gougedMDCC FRAME 28 HAS 2 GOUGES, .100" BETWEEN STR L17 AND L18. FABRICATED AND INSTALLED 1EA REPAIR PLATE AND 1 EA BRIDGE IAW SRM 51-40-21 AND COMPLIED WITH EA6-5310-145643.SDR FDEA201107202839Frame · dentedBS 500 FRAME DENTED BTWN STR 24R-25R AT UPPER FLANGE. FOUND AREA DENTED AND OUT OF LIMITS IAW SRM 53-10-1 FIGURE 1. TRIMMED OUT DAMAGE, FABRICATED REPAIR FILLER AND REPAIR DOUBLER SPLICE AND INSTALLED IAW EA 7-5310-152426.SDR ABXA2011071972Failsafe · corrodedLT FAILSAFE STRAP AND "T" FITTING CORRODED. REMOVED AND REPLACED FAILSAFE STRAP AND "T" FITTING IAW REAB693-59386-MR.SDR FDEA201107192815Frame · damagedRT FRAME BS 783.95, SECOND AND THIRD HOLE ABOVE FLOOR HAVE DOUBLE DRILLED HOLES. REPAIRED RIGHT HAND FRAME BS 783.95 IAW EA 7-5310-152422.SDR UIEA2011071900428Frame · crackedDURING C4/A6 CHECK, INSP DETECTED 2 EACH CRACKS ON THE RT SIDE , BS 320 FRAME AT S-15R CUTOUT. THE FIRST CRACK IS FOUND ON THE WEB LAYER ONLY AND IS APPROX 2 IN LONG RUNNING INBD AND DOWNWARD. THE SECOND CRACK IS ALSO ON THE WEB LAYER ONLY AND IS APPROX 0.50 SDR FDEA201107192811Spar · crackedCENTER TANK REAR SPAR UPPER WEB BL 0 TO LBL 2 HAS UT SHEAR WAVE CRACK INDICATION AND BL 0 TO RBL HAS HFEC CRACK INDICATION. STOP DRILLED HOLES AT CENTER TANK REAR SPAR UPPER WEB LBL 0-2 AND RBL 0-2 IAW SRM 51-10-1. LOCATED AND DRILLED HOLES AT REPAIR KIT AND SDR UIEA2011071900418Frame · crackedDURING INSPECTION, DETECTED 2 EACH CRACK ON THE RT SIDE , BS 380 FRAME AS SHOWN IN FIG 1. THE FIRST CRACK IS FOUND ON THE WEB LAYER ONLY AND IS APPROX 0.5 INCH LONG RUNNING INBD AND UPDWARD. THE SECOND CRACK IS ALSO ON THE WEB LAYER ONLY AND IS APPROX 0.125 ISDR UALA2011072003696Seal · damagedCAPT SLIDING WINDOW LEAKING AT 5 O'CLOCK POSITION. WHEN PRESSING ON GLASS NOISE PITCH CHANGES. REPLACED CAPT NR 2 WINDOW PRESSURE SEAL. APPLIED SEALANT PER MM. SEALANT APPLICATION IS CF PER MM. A/C PRESSURIZED TO 4 PSID. NO SQUEAL.SDR QXEA2011072200554Frame · corrodedFRAME X71.200 LOWER FLANGE HAVE CORROSION BETWEEN STRINGER 29S & 32S. BLENDED CORROSION IAW RD 8/4-53-2344. HFEC CONFIRMED CRACK FREE REF NTM, 51-00-02-250-801 UT REMAINING THICKNESS MEASURED .040" IN REF NTM 51-00-01-250-801. FOUND TO BE WITHIN LIMITS OF RSDR QXEA2011072200551Frame · corrodedFRAME X116.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. BLENDED CORROSION REF RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED,PRIMED AND PAINTED ISDR QXEA2011072200550Frame · corrodedFRAME X71.200 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. BLENDED CORROSION REF RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED AND PAINTED PSDR QXEA201107220549Frame · corrodedFRAME X71.200 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 29S AND 32S. BLENDED CORROSION REF RD 8/4-53-2344. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED,PRIMED AND PAINTED IAW RD 8/4-53-2344.SDR QXEA2011072200545Frame · corrodedFRAME X19.400 LOWER FLANGE HAS CORROSION BETWEEN STRINGER 30P AND 32P. REMOVED CORROSION FROM AFFECTED AREAS IAW SRM 51-21-00-00-02. FOUND TO BE WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED IAW RD 8/4-53-2344.SDR QXEA2011072200544Frame · corrodedFRAME X19.400 LOWER FLANGE HAS CORROSION BETWEEN STRINGER 28S AND 29S. REMOVED CORROSION FROM AFFECTED AREAS IAW SRM 51-21-00-00-02. FOUND TO BE WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED IAW RD 8/4-53-2344.SDR CA110726010Frame · crackedFRAME CRACKED, AT STRINGER 9, ALONG SKIN FLANGE BEND RADIUS. CRACKED APPROX 2.5 INCHES ALONG BEND.SDR CA110726009Frame · crackedFRAME CRACKED. CRACK IS TYPICAL THROUGH PEAR SHAPED LIGHTNING HOLE IN FRAME.SDR UIEA2011071800443Frame · crackedDURING THE ACCOMPLISHMENT OF EO 4753B324, REV B (SB 747-53A2450, REV 6, AD 2010-20-08). ONE FASTENER HOLE ON THE FRAME STRAP (PN 65B01849-26) WAS FOUND WITH A 0.0625 INCH CRACK EXTENDING IN THE AFT DIRECTION AS SEEN IN THE REF /2/ RS R53-62-37168 REV A. IN ASDR FDEA201107182784Frame · damagedAFT PIT BS1130 FRAME UPPER FLANGE HAS TRIPLE DRILLED HOLE BETWEEN STR 27L AND 28L. CUT OUT DAMAGED AREA IAW SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR IAW SRM 51-40-3 FIG 1. INSTALLED FRAME REPAIR IAW SRM 51-30-2 AND 51-40-3 FIG 1.SDR UALA2011071903651Frame · corrodedCORROSION ON FRAME ANGLE AT STATION 996 STR R16. MAJOR REPAIR ACCOMPLISHED: REPLACED FAIL SAFE CHORD AT FRAME STA 996, STR 16R IAW SRM ON NR 2806N00336.SDR USAA2011072500033Support · corrodedC11 CHECK - LEVEL 2 GALVANIC CORROSION ON FRAME SUPPORT BETWEEN FR69 TO FR70, -Y1732, -Z240. REPLACED FRAME SUPPORT BETWEEN FR69 TO FR70, -Y1732, -Z240 IAW A320 SRM 51-42-11.SDR SWAA115173Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 887, STR 1. REPAIRED FRAME PER SRM.SDR QXEA2011072000527Frame · corrodedC2 - FRAME X301.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S &33.. BLENDED OUT CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SRM 51-21-10-02-01, 51-25-10-02-01, 51-SDR QXEA2011072000526Frame · corrodedC2 - FRAME FLANGE AT STA 584.5 RT STR 31-32 HAS CORROSION. BLENDED OUT CORROSION IAW MFG RD 8/4-53-2344. REMAINING THICKNESS WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SRM 51-21-10-02-01, 51-25-10-02-01, 51-25-05-02-01 ANSDR QXEA2011072000525Frame · corrodedC2 - FRAME FLANGE AT STA 509.5 LT STR 31-32 HAS CORROSION. BLENDED OUT CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SRM 51-21-10-02-01, 51-25-10-02-01, 51-25-05-02-01 AND 51SDR QXEA2011072000524Frame · corrodedC2 - FRAME FLANGE AT STA 509.5 RT STR 32 -33 HAS CORROSION. BLENDED OUT CORROSION IAW BOMBARDIER RD 8/4-53-2344. REMAINING THICKNESS WITHIN LIMITS OF RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SRM 51-21-10-02-01, 51-25-10-02-01, 51-25-05-
Back to JASC 5311