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 SWAA096759Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA096758Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA096756Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REMOVED AND REPLACED FRAME PER SRM.SDR KCSA091121Frame · corrodedCORROSION ON AFT LOWER SIDE OF BS 1335 FUSELAGE FRAME JUST ABOVE OVERWING LONGERON.SDR CA091113001Tube · corroded(CAN) TUBING RUSTED OUT AFT FITTING.SDR CALA2009110300654Frame · crackedB737-53-3-0740 UPPER FUSE STRUCT (INTERIOR) RT SIDE FRAME 727B CRACKED BETWEEN STRINGERS 8 (PSU HANGER BRACKET). REMOVED DAMAGED WEB & INSTALLED REPAIR ANGLES REF ECRA 5310-05032 STA 727B BETWEEN STR 8R.SDR CALA2009110300653Frame · crackedB737-53-3-0710 FRAME AT STA 440 RT SIDE CRACKED BETWEEN STRINGERS 8 (MARKED). REPAIRED CRACKED FRAME AT STA 440 RT BETWEEN STRINGERS 8R REF ECRA5310-05032.SDR USAA2009102892912Frame · crackedCLT - Q3 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 787 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009102892911Frame · crackedCLT - Q3 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 727F BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 727F BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009102892910Frame · crackedCLT - Q3 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 727D BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 727D BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009102892909Frame · crackedCLT - Q3 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 480 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009110393013Frame · crackedCLT - MAJOR REPAIR - Q3 CHECK - CRACKED FRAME AT BS 480, S8R - S9R. REPAIRED FRAME AT BS 480 S8R - S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009110393012Frame · crackedCLT - MAJOR REPAIR - Q3 CHECK - CRACKED FRAME AT BS 827, S8L - S9L. REPAIRED FRAME AT BS 827 S8L - S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009110393011Frame · crackedCLT - MAJOR REPAIR - Q3 CHECK - CRACKED FRAME AT BS 440, S8R - S9R. REPAIRED FRAME AT BS 440, S8R - S9R IAW TYPICAL REPAIR 53-10-20E.SDR CALA2009110300651Frame · crackedB737 53-3-0710 STA 400 FRAME LT SIDE CRACKED BETWEEN STRINGER NR 8 & NR 9 (MARKED) REPAIRED FRAME AT STA 400 LEFT BETWEEN STR 8 &9. REMOVED DAMAGE, FABRICATED, TREATED, PRIMED AND INSTALLED REPAIR ANGLES REF ECRA 5310-05032.SDR ZZDA2009316Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW TASK CARD 17-5310-2985.SDR ASAA0996837Frame · corrodedCORROSION ON FRAME BS 500K OUT OF LIMITS. REMOVED CORROSION AND REPAIRED FRAME.SDR ASAA0996832Frame · corrodedCORROSION ON FRAME AT BS 500K. REPAIRED FRAME.SDR GUUA94053102309ASpar · damagedREPORT: DURING BELLY SKIN REPAIR DISCOVERED RIGHT MAIN SPAR HAS TWO ELONGATED FASTENER HOLES AT FS 288.00. COLD WORK FASTENER HOLES AND INSTALLED BLIND FASTENERSSDR USAA2009102692874Frame · corrodedPIT - FPBH - MAJOR REPAIR - CORROSION ON FRAME AT BS 794, S27R. REPLACED FRAME AT BS 794, S27R IAW EA 113654 & B737 SRM 53-00-01.SDR DL757100190Frame · dentedFRAME DENTED, AFT CARGO AT STA 1380, STRINGER 26L. INSTALLED DOUBLER REPAIR ON FRAME AT SAA SAT REFERENCE N/R 137652.SDR DL757100189Frame · dentedFRAME DENTED AFT CARGO AT STA 1420 BETWEEN STRINGERS 26L AND 25L. INSTALLED DOUBLER REPAIR ON FRAME AT SAT SAA REFERENCE N/R CARD 137651.SDR AALA20091029TUL02Frame · crackedCANT FRAME STATION 1497 CRACKED AT RIGHT SIDE, LONGERON 16. INSTALLED REPAIR DOUBLER PER SRM 53-01 WITH PROVISIONS PER EA MD80-53-007851.SDR FDEA200910223647Frame Splice · damagedMAIN CABIN DECK STA 1280, STR 12 & 13, LT HAS A FRAME REPAIR SPLICE DAMAGE. REMOVED REPAIR ANGLES IAW SRM 51-40-02, RECIEVED NEW FROM FAB SHOP 2EA REPAIR ANGLES, MAE TRAV T9/805465, INSTALLED NEW REPAIR PARTS STA 1280, STR 12 & 13, LT IAW SRM 53-00-07, FIGSDR FDEA200910223646Frame Splice · damagedMAIN CABIN DECK STA 1280, STR 12 & STR 13, RT HAS FRAME REPAIR SPLICE DAMAGE. REMOVED REPAIR ANGLES, FABRICATED NEW SPLICE REPAIR ANGLES, MAE TRAV T9/805464, INSTALLED REPAIR PARTS AT STA 1280, STR 12 & 13 RT, IAW SRM 53-00-07, FIG 201, REPAIR 2. MAJOR REPAISDR USAA2009102792882Frame · corrodedBFM - C-1 - MAJOR REPAIR - CORROSION ON T-CHORD FRAME AT FR44 BETWEEN RBL 50 TO LBL 50. REPLACED T-CHORD FRAME AT FR44 BETWEEN RBL 50 TO LBL 50 IAW A330 SRM 53-35-14, 51-44-11, 51-42-11.SDR DL757100311Failsafe · corrodedFUSELAGE FAILSAFE STRAP CORRODED STA 900 RT SIDE. REPLACED FAILSAFE STRAP AT SAA SAT ON N/R 141066.SDR FDEA200910213622Frame · damagedSTA 303.9 FRAME, WEB CUTOUT AT STR 15L AND STR 16L HAVE SHARP RADIUS. ACCOMPLISHED REPAIR IAW EA NR 7-5310-135505.SDR SIMA200925402SUPFrame · misinstalledDURING MAINTENANCE INSPECTION, DISCOVERED IMPROPERLY BUCKED RIVETS FOUND ON FRAME 2 ON THE RIGHT SIDE OF THE FUSELAGE. SKIN REQUIRES REPLACEMENT FROM FRAME 1A TO 3 FOR FRAME 2 REPAIR. AIRCRAFT REMOVED FROM SERVICE. REPLACED SKIN AND FRAME 2 IN ACCORDANCE WISDR SWAA096701Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA096650Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA096649Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA096647Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096644Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER EA.SDR QXEA2009102100835Frame · corrodedFRAME CASTELLATION AT STA X94.8 BETWEEN STR 32R AND 31R IS CORRODED. REMOVED 5 RIVETS FOM, REMOVED LIGHT SURFACE CORROSION FROM AREA IAW SRM 51-21-00 PARA 1-4A(2)(B). HFEC INSPECTED BLENDED AREA FOR CRACKS AND AROUND RIVET HOLE IAW NDTM PART 6, SDR QXEA2009102100834Frame · corrodedFRAME CASTELLATION AT STA X94.8 BETWEEN STR 32R AND 33 IS CORRODED.
DRILLED AND REMOVED 3 RIVETS BETWEEN STR 32R AND 33 AT STA 94.8. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-21-00 PAR 1-4A(2)(B). HFEC INSPECTED BLENDED AREA FOR CRACKS IAW NDTM PART 6, 5SDR FDEA200910193610Frame · dentedCABIN - RT STA 1661, L-11 TO L-12 FOUND DENT. REPAIRED IAW SRM 53-00-07 FIG 201, REV 41. INITIAL INSP TO BE CARRIED OUT AT 14,500 FLIGHT CYCLES AND SUBSEQUENT REPETITIVE INSPECTIONS AT EVERY 9,500 FLIGHT CYCLES IAW SRM 53-00-07 TABLE 201, REPAIR 2 REV 41. SDR ASOA200901165Frame · crackedCRACKED FRAME AT FS 605.00 S9L. PERFORMED E/T INSP ON FS605.00 STR 9 CUT OUT IAW REO 601R-53-61-3408 AND NDT MANUAL 51-20-06 NO DEFECTS NOTED NDT REPORT ATTACHED. COMPLIED WITH FABRICATION OF REPAIR PARTS -1, -2, -3, SHIM & -4 SHIM FROM 7075-T6 & 2024-T3 P/OSDR ASOA200901158Frame · corrodedCORROSION DAMAGE IN INTERNAL MAIN AVIONICS BAY ON FS333.00 FRAME BETWEEN STRINGERS 26LT AND 26RT (MARKED). REMOVED AND REPLACED LWR 333 FRAME SECTION, IAW SR, 51-42-06 AND RESTORED FINISH TO REPAIR A023 IAW SRM 51-42-11.SDR ASOA200901225Frame · corrodedMAIN AVIONCIS COMPARTMENT FS 349, STR 27 HAS CORROSION ON FRAME.SDR ZZDA2009312Frame · corrodedAFT CARGO COMPARTMENT FUSELAGE FRAME AT FS 870, AFT SIDE HAS CORROSION AT LONGERON 30. INSTALLED REPAIR SPLICE AT AFT CARGO COMPARTMENT FUSELAGE FRAME FS 870 AT LONGERON 30 IAW B717 SRM 53-20-07 REPAIR 3 FIG 201.SDR AALA20091019TUL04Frame · crackedCRACKED FRAME AT STATION 1418 AT LONGERON 2 LEFT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER MD80 ENGINEERING AUTHORITY 53-007753.SDR AALA20091019TUL03Frame · crackedFRAME CRACKED AT STATION 1418 AT LONGERON 2 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-2 AND ENGINEERING AUTHORIZATION MD80 53-007753.SDR AALA20091016TUL02Frame · corrodedAFT CARGO FRAME HAS CORROSION IN LOWER AFT FLANGE OF STATION 1309 AT LONGERON 29 LEFT TO 29 RIGHT.SDR ASOA200901148Frame · corrodedCORROSION ON OUTER FRAME FLANGE AT FS 319 AT STR 25L-26L. CUT FLANGE/REMOVED FLANGE ON FS 319 AT STR 25L-26L IAW REO 601R-53-21-1060 & SRM 53-00-15, REPAIR 2. FABRICATED REPAIR PARTS IAW SRM 53-00-15, REPAIR 2. COMPLIED WITH EC/TC REO 601R-53-21-1060 & REO SDR ZZDA2009314Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW TASK CARD 17-5310-2990.SDR ZZDA2009313Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW TASK CARD 17-5310-2973.SDR AALA20091019TUL05Frame · corrodedAFT CARGO CORROSION IN LOWER FORWARD FLANGE OF STATION 1287 FRAME AT LONGERON 30. INSTALLED LOWER J-ANGLE REPAIR PER AARD 53-10-00-17.SDR ASOA200901143Frame · corrodedFOUND FRAME 349 LOWER SECTION TO BE CORRODED BEYOND ALLOWABLE LIMITS. REMOVED THE CORRODED LOWER SECTION OF FRAME AT FS 349, VISUALLY ENSURED THERE WAS NO UNDERLYING DAMAGE ON SKIN, LOCATED, AND DRILLED A NEW FRAME SECTION AT FS 349 IAW SRM 51-40-11. NEW FRAMSDR ASOA200901144Frame · corrodedFOUND THE FS 333 LOWER FRAME SECTION TO BE CORRODED BEYOND ALLOWABLE LIMITS.
Back to JASC 5311