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 QXEA2012012600113Frame · corrodedFRAME 32.4 FORWARD SIDE IS CORRODED STR 33. ACFT IS DOWN FOR C-CHECK.SDR QXEA2012012600112Frame · corrodedFRAME 18.25 HAS CORROSION ON THE UPPER AND LOWER FLANGES AND THE WEB STR 33-32S. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED BLENDS CRACK FREE REF NTM 51-00-01-250-801-PT6. FOUND BLENDS TO BE WITHIN LIMITS IAW RD 8/4-53-4SDR QXEA2012012600111Frame · corrodedFRAME-18.25 UPPER FLANGE IS CORRODED STR 31P-33. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED BLENDED AREA CRACK FREE REF NTM 51-00-01-250-801 PT 6. FOUND FLANGE TO BE WITHIN LIMITS IAW RD 8/4-53-4302. COMPLIED WITH RD 8/4-53-SDR QXEA2012012600092Frame · corrodedFORWARD SIDE OF FRAME 18.25 IS CORRODED STR 31P-30P. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED BLENDED AREA CRACK FREE REF NTM 51-00-01-250-801, PT6. FOUND WITHIN LIMITS IAW RD 8/4-53-4302. ALODINED, PRIMED AND PAINTED SDR QXEA2012012500045Frame · corrodedFRAME 547 FLANGES ARE CORRODED STR 25S-23S. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION FROM FLANGES IAW RD 8/4-53-2344. PERFORMED HFEC AND UT THICKNESS CHECKS IAW NDTM PT 1, 51-00-06-910-801 AND 51-00-04-910-801. MATERIAL LOSS WITHIN LIMITS IAW RD 8/4-53-SDR QXEA2012012500044Frame · corrodedFRAME 529.5 FLANGES ARE CORRODED STR 31P-33. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED HFEC OF BLENDED AREA FOR CRACKS REF NDTM PT1 51-00-06-910-801. NO CRACKS NOTED. PERFORMED UT THICKNESS CHECK OF BLENDED AREA IAW NDTM PTSDR QXEA2012012500040Frame · corrodedFRAME 341 FLANGES ARE CORRODED STR 32S-31S. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .046" CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801 PT 4 AND 51-00-06-910-801 PT 1. FOUND TO BE WITHIN LIMITS IAW RD 8/4-5SDR QXEA2012012500039Frame · corrodedFRAME 301 FLANGES ARE CORRODED STR 32S-28P. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED UT THICKNESS CHECK IAW NDTM PT 1, 51-00-04-910-801. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801 PT1. MATERIAL LOSS WITHIN LIMITS RD 8/4SDR QXEA2012012500035Frame · corrodedFRAME 258.5 FLANGE IS CORRODED STR 28P-29P. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED UT THICKNESS CHECK IAW NDTM PT 1, 51-00-04-910-801. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND WITHIN LIMITS SDR QXEA2012012500031Frame · corrodedFRAME 176 FLANGES ARE CORRODED STR 30P-32S. ACFT IS DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801, PT 4 AND 51-00-06-910-801 . MATERIAL LOSS FOUND WITHIN LIMITS IAW RD 8/4-53-2344. TREATED AND RESTORESDR QXEA2012012500025Frame · corrodedFRAME 94.8 FLANGES ARE CORRODED STR 23P-25P. ACFT DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-02-250-801, PT 4 AND 51-00-06-910-801. FRAME DOUBLER FOUND TO BE OUT OF LIMITS IAW SRM 51-21-00-00-02. INSTALL SERSDR QXEA2012012500024Frame · corrodedFRAME 94.8 FLANGE IS CORRODED STR 29P-30P. ACFT DOWN FOR C-CHECK. REMOVED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .040, CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 PT4 AND 51-00-06-910-801. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2SDR DALA1203250674Frame · dentedDURING MAINTENANCE VISIT FRAME AT BS 1420 BETWEEN STRINGERS 25 AND 27 LT WAS FOUND TO BE DENTED. (DAMAGE EXCEEDS ALLOWABLE LIMITS IAW B757-200 SRM 53-00-01 FIG 101. - NO DENTS ALLOWED IN FRAME FLANGE). FRAME TO BE REPAIRED IAW B757-200SRM 53-00-07 FIG 20A DESDR DALA1203240674Frame · dentedDURING MAINTENANCE VISIT FRAME AT BS 1440 BETWEEN STRINGERS 26 AND 27 LT WAS FOUND TO BE DENTED. (DAMAGE EXCEEDS ALLOWABLE LIMITS IAW B757-200 SRM 53-00-07 FIG 101. - NO DENTS ALLOWED IN FRAME FLANGE.) FRAME TO BE REPAIRED IAW B757-200 SRM 53-00-01 FIG 201 DSDR DALA1203220674Frame · dentedDURING MAINTENANCE VISIT FRAME AT BS 1520 BETWEEN STRINGERS 26-27 LT WAS FOUND TO BE DENTED. (DAMAGE EXCEEDS ALLOWABLE LIMITS. IAW B757-200 SRM 53-00-07 FIG 101- NO DENTS ALLOWED IN FRAME FLANGE.) FRAME TO BE REPAIRED IAW B757-200 SRM 53-00-07 FIG 201 DETAILSDR SWAA120531Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 1006, BETWEEN STR 20R TO STR 22R. REPAIRED FRAME IAW EO.SDR SWAA120529Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA120521Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME SUPPORT ANGLE CRACKED AT BS 328, STR 20L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA120506Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SRM.SDR DALA1203230674Frame · dentedDURING MAINTENANCE VISIT FRAME AT BS 1480 BETWEEN STRINGERS S5-27 LT WAS FOUND TO BE DENTED. (DAMAGE EXCEEDS ALLOWABLE LIMITS IAW B757-200 SRM 53-00-07 FIG 101. NO DENTS ALLOWED IN FRAME FLANGE) FRAME TO BE REPAIRED IAW B757-200 SRM FIG 201 DETAIL I. CAUSE OSDR DALA1203210674Frame · dentedDURING MAINTENANCE VISIT FRAME AT BS 1500 BETWEEN STRINGERS 26 AND 27 LT WAS FOUND TO BE DENTED. DAMAGE EXCEEDS ALLOWABLE LIMITS IAW B757 SRM 53-00-07 FIG 101. NO DENTS ALLOWED IN FRAME FLANGE. FRAME TO BE REPAIRED IAW B757-200 SRM 53-00-07 FIGURE 201 DETASDR DALA1203200674Frame · dentedDURING MAINTENANCE VISIT FRAME AT BS 1340 BETWEEN STRINGERS 26R AND S7R WAS FOUND TO BE DENTED. DAMAGE EXCEEDS ALLOWABLE LIMITS IAW B757-200 SRM 53-00-07 FIG 101 - NO DENTS ALLOWED IN FRAME FLANGE. FRAME TO BE REPAIRED IAW B757 SRM 53-00-01 FIGURE 201 DETAILSDR USAA2012012300031Frame · crackedRON CHECK - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S21R TO S22R. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S21R TO S22R IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA2012021301383Frame · corrodedAFT CARGO BAY FRAME CORRODED AT BS 787, STR 25L. REMOVED AND REPLACED FRAME IAW SRM.SDR CHQA201200024Frame · crackedDURING INSPECTION, A CRACK WAS FOUND ON FRAME 23 UNDER THE SERVICE DOOR AFT SILL BETWEEN STRINGER 15R AND 16R. FRAME 23 UNDER THE SERVICE DOOR AFT SILL WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-00933.SDR SWAA2012020901274Frame · corrodedFRAME CORRODED AT BS 867 BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR USAA2012020800011Frame · crackedFPBH/CDFI VISIT - CRACK IN FRAME INNER CHORD AT BS 616, WL 200.1, BBL 64.85. REPLACED FRAME INNER CHORD AT BS 616, WL 200.1, BBL 64.85 IAW EA 201736.SDR AALA20120120TUL07Frame · damagedFRAME STATION 947 LEFT TO RIGHT BUTTLINE 58 DAMAGED. SPLICE REPAIR DONE PER 53-70-51-2R 5.SDR AALA20120120TUL06Frame · damagedFRAME STATION 927 LEFT BUTTLINE 5 DAMAGED. SPLICE REPAIR DONE PER 53-70-51-2R 4.SDR ASOA201200233Frame · corrodedFS 364.00 BELLY FWD EDGE OF AVIONICS DOOR CUT OUT, TEE FITTING ANGLE CORRODED ON FORWARD SIDE FROM STRINGER 25L TO 25R BOTH LEGS OF ANGLE. REMOVED CORROSION FROM ANGLES IAW SRM 51-21-06. REMOVED AND REPLACED ANGLES IAW SRM 51-42-06.SDR FDEA201201200278Frame Splice · gougedAFT LWR CARGO COMP FRAME AT STA 1480 HAS 2 EA GOUGE MARKS ON SPLICE DOUBLER UPPER SURFACE BETWEEN STRINGER S24-25R. R & R WITH FABRICATED DOUBLER IAW SRM 51-40-02. REV 104. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201201200277Frame · gougedAFT LWR CARGO COMP, FRAME AT BS 1480, HAS 1EA GOUGE MARK ON SPLICE DOUBLER UPPER SURFACE BETWEEN STRINGERS S23 & 24R. R & R WITH FABRICATED DOUBLER IAW SRM 51-40-02 REV 104. REPAIR IS CLASSIFIED AS MAJOR.SDR JR2R2012012000059Frame · corrodedFRAME BS 1031 CORRODED BETWEEN STRINGER 25R AND 26R. REPAIRED IAW RO CRJ7-53-0513.SDR SWAA2012021501458Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME IAW ER & EA.SDR SWAA2012021401430Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW ER & EA.SDR SWAA2012021301363Frame · corrodedFRAME CORRODED AT BS 867 BETWEEN, ST 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012021301362Frame · corrodedFRAME CORRODED AT BS 827, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER EO AND EA.SDR SWAA2012021301361Frame · corrodedFRAME CORRODED AT BS 827 BETWEEN, ST 27L TO STR 27R. REMOVED AND REPLACED FRAME PER EO AND EA.SDR SWAA2012021301360Frame · corrodedFRAME CORRODED AT BS 827, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED FRAME IAW EO AND EA.SDR ASAA12410968Frame · crackedREF T/C AD20090206 400 53 1 WIRE PENETRATION HOLE INSPECTION STATION 500C RT SIDE 1.04 INCH HOLE IS CRACKED. REPAIRED IAW SRM 53 00 07 REPAIR 13.SDR SWAA2012020901272Frame · corrodedCORROSION ON FRAME LOCATED BS 727C BETWEEN, STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR CHQA201200029Frame · crackedDURING INSPECTION, THE COCKPIT LEFT (PN: 145-02409-001) AND RIGHT (PN: 145-02409-002) FRAME 10 WERE FOUND TO BE CRACKED. THE COCKPIT LEFT AND RIGHT FRAME 10 WERE REPLACED IN ACCORDANCE WITH SRM 51-40-02.SDR ASAA12410971Frame · crackedREF T/C AD20090206 400 53 1 WIRE PENETRATION HOLE INSPECTION STATION 500C RT SIDE 1.04 IN HOLE IS CRACKED. REPAIRED IAW SRM 53 00 07 REPAIR 13.SDR ASAA12410970Frame · crackedREF T/C AD 20090206 400 53 1 WIRE PENETRATON HOLE INSPECTION STATION 500B RT SIDE .500 HOLE HAS A CRACK. REPAIRED FRAME REF SRM 53 00 07 REPAIR 13 EA 400 53EA 07274 AND IS COMPLETED.SDR ASAA12410969Frame · crackedREF T/C AD 20090206 400 53 1 WIRE PENETRATON HOLE INSPECTION STATION 500B RT SIDE .500 HOLE HAS A CRACK. REPAIRED FRAME REF SRM 53 00 07 REPAIR 13. EA 400 53EA 07274 AND IS COMPLETED.SDR DALA1202580196Failsafe · crackedCRACK FOUND IN RMLG FAILSAFE DURING ULTRA-SONIC INSPECTION PER SI 01-086393-12AD. REPAIRED PER ERA 499436-14AD.SDR SWAA120452Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120451Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA201201195Frame · crackedCRACK INDICATION WAS FOUND IN THE FRAME BTW STR 20R AND STR 21R BS 520. REPAIRED FRAME IAW SRM.SDR DALA1204499020Frame · corrodedAFT CARGO AREA STA 1271 R24 TO L24 FRAME STRUCTURE CORRODED.
Back to JASC 5311