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 SWIA201127924Frame · corrodedC-CHECK, FS 574 FRAME CORRODED FROM STRINGER 26L TO 26R. REPLACED FS574 FRAME PER SRM.SDR AALA20110918TUL04Beltframe · crackedBELLFRAME 1418 CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER ON 1418 LONGERON 2 LEFT FRAME REPAIRED PER SRM 53-03-00 FIGURE 31A.SDR TX9Y20110920001Frame · noneDURING PERFORMING THE INSP OF FUSLAGE-TAIL SECTION BS 2598 BULKHEAD FWD & AFT INNER CHORD IAW SB 747-53A2427, R5, AN EXISTING REPAIR ANGLE SIMILAR WITH SRM 53-10-04, FIGURE 72 COMMON TO AFT INNER CHORD LT SIDE ONLY AT WL 320 WAS FOUND INTERFERE THE INSP PERFORSDR FDEA201109174005Frame · dentedFOUND FRAME UPPER FLANGE DENTED, BS 1500. FRAME REPAIRED IAW SRM 53-00-07, REPAIR 5 AND EA F-5310-153443 AND F-5310-153444.SDR SWAA116647Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR UALA2011091905044Frame · dentedAFT CARGO COMPARTMENT BS 1620 BETWEEN STR 26L AND STR 25L FRAME IS DENTED. MAJOR REPAIR ACCOMPLISHED. TRIMMED OUT DAMAGE ON FRAME FLANGE AND FABRICATED A REPAIR DOUBLER PER SRM, REPAIR 5, DETAIL III, AND INSTALLED PER SRM ON NON ROUTINE 24207.SDR AALA20110916TUL06Frame · crackedAFT ACCS- 1485 CANT FRAME CRACKED BELOW RIGHT AIRSTAIR ACTUATOR BRACKET. ACCOMPLISHED SPLICE REPAIR AT STATION 1485 RIGHT PER AARD 53-10-00-33.SDR ASOA201101745Frame · corrodedFRAME 379, BETWEEN STR 22 & 23R UNDER DCU NR 2 HAS CORROSION.SDR SWAA116621Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA116620Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR UALA2011091605013Frame · corrodedAFT CARGO STA 1620 FRAME AT BL 0 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REMOVED CORRODED SECTION OF FRAME BETWEEN STR 29R TO STR 30. FABRICATED A REPAIR DOUBLER AND STRINGER CLIPS, PER BAC DWG 140N2005, AND REPLACED 2 SHEAR TIES PER TIMCO REO G14040, REV ASDR ASOA201101795Frame · crackedBS 280 FRAME APPEARS TO BE CRACKED AFT LOWER SIDE NEAR LBL9.00. COMPLIED WITH ECTC REO 601R-53-11-171.SDR NSVA2011231Frame · corrodedCORROSION ON FWD FUSELAGE BOTTOM FRAME WEB AT STA 225.0 REF MESABA MM-409 # 404552 TD# 350-53-11-61.SDR AALA20110915TUL09Frame · corrodedFRAME AT STATION 1380 BETWEEN STRINGERS 27 AND 28 RIGHT CORRODED. INSTALLED REPAIR DOUBLER PER SRM 51-70-11-0G FIGURE 1.SDR SWAA116631Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA116630Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA116629Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA116628Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA116627Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SIMA201125903Frame · damagedDURING MAINTENANCE BASE VISIT FOUND A MIS-DRILLED HOLE AT END OF FRAME 66, UPPER FLANGE WHERE IT ATTACHES TO CARGO DOOR LOWER SILL AND FLOOR SUPPORT ANGLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. THE CORRECTIVE ACTION INFORMATION IS PENDING.SDR IPXA11569447Frame · dentedINSPECTION TYPE: C, FORWARD CARGO BAY AT BODY STA 820 AND BETWEEN STR 23L AND 24L, FUSELAGE FRAME INBD FLANGE HAS DENT. REMOVED DAMAGE AND REPAIRED IAW SRM 53-00-07-2R5. FABRICATED REPAIR ANGLE AND HEAT TREATED TO T6 IAW SRM 53-00-07-2R5 DETAIL II. ORIGINALSDR FDEA201109143883Frame · misrepairedFUSELAGE FRAME STA 740 AT S30, MISREPAIRED. REMOVED AND REPLACED FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR IPXA1569368Frame · dentedINSPECTION TYPE:C-CK, FORWARD CARGO PIT AT BODY STA 800 AND BETWEEN STR 22R AND 23R , FUSELAGE FRAME INBD FLANGE HAS DENT. REMOVED DAMAGE AND REPAIRED STA 800 FRAME BETWEEN STR 22R AND 23R IAW SRM 53-00-07-2R5 FABRICATED -1 REPAIR ANGLE FROM 7075-0 .071 AND HSDR IPXA1569367Frame · dentedINSPECTION TYPE:C-CHECK, FORWARD CARGO PIT AT BODY STA 680 FRAME AND BETWEEN STRINGER 25R A ND 24R, FUSELAGE FRAME INBD FLANGE HAS DENT. REMOVED DAMAGE AND REPAIRED STA 680 FRAME BETWEEN STR 25R AND 24R IAW SRM 53-00-07-2R5. FABRICATED-3 REPAIR ANGLE FROM 707SDR USAA2011091600015Frame · crackedFRAME HOLE INSP VISIT - FUSELAGE FRAME CRACKED AT BS500G, S20R. REPAIRED FUSELAGE FRAME AT BS500G, S20R B737 SRM 53-00-07 REPAIR 13.SDR USAA2011091600014Frame · crackedFRAME HOLE INSP VISIT - FUSELAGE FRAME CRACKED AT BS 500G, S20R. REPAIRED FUSELAGE FRAME AT BS500G, S20R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011091600013Frame · crackedFRAME HOLE INSP VISIT - FUSELAGE FRAME CRACKED AT BS 500D, S20L. REPAIRED FUSELAGE FRAME AT BS500D, S20L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011091600012Frame · crackedFRAME HOLE INSP VISIT - FUSELAGE FRAME CRACKED AT BS 500C, S20R. REPAIRED FUSELAGE FRAME AT BS500C, S20R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011091600011Frame · crackedFRAME HOLE INSP VISIT - FUSELAGE FRAME CRACKED AT BS 500B, S20RL. REPAIRED FUSELAGE FRAME AT BS500B, S20RL IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011091600010Frame · crackedFRAME HOLE INSP VISIT - FUSELAGE FRAME CRACKED AT BS 500B, S20L. REPAIRED FUSELAGE FRAME AT BS500B, S20L IAW B737 SRM 53-00-07 REPAIR 13.SDR ASOA201101734Frame · corrodedFRAME AT FS 605 IS CORRODED BETWEEN S25L & 25R. REMOVED FRAME SECTION IAW SRM 51-42-06 AND SRM 51-42-21. INSTALLED NEW FRAME IAW SRM 51-42-06 AND 51-42-21.SDR COEA2011091401900Frame · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: DISCREPANCY: FRAME 24 FWD SIDE OF FRAME BETWEEN STR 19L & 20L HAS LEVEL 2 CORROSION. FABRICATED AND INSTALLED DOUBLER AND INTERCOSTAL PER SRM.SDR SWAA116539Frame · corrodedDURING SCHEDULED SPV CHECK FOUND, FRAME CORRODED AT BS 947, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW EA.SDR FDEA201109133869Frame · misrepairedFRAME AT BS 1540 , MISREPAIRED. R & R FRAME STA 1540, STR 23R - 23L IAW SRM 51-40-02. MAJOR REPAIR.SDR FDEA201109133859Frame · misrepairedFUSELAGE FRAME STA 760 AT S30 MISREPAIRED. R & R FUSELAGE FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR ASOA201101728Frame · corrodedFRAME 310 IS CORRODED BETWEEN STGR 27 AND 26R. REPLACED FRAME SECTOR IAW SRM 51-40-11, 51-42-06, AND 51-42-21.SDR ASOA201101727Frame · corrodedFRAME 319.70 CORRODED BETWEEN S26 AND 27R. REMOVED CORROSION, REMOVED 0.002" OF MATERIAL IAW SRM 51-21-06, SRM 51-42-06.SDR ASOA201101725Frame · corrodedFRAME 379, BETWEEN S22-23R UNDER DCU NR2 HAS CORROSION. BLEND OUT CORROSION ON FRAME. REMOVED 0.004" MATERIAL FROM 0.050" ORIGINAL THICKNESS OF FRAME MATERIAL AND REMAINING 0.046"" MATERIAL, WITHIN LIMITED ALLOWANCES IAW SRM 51-21-06. INSTALLED FRAME IAW SSDR AALA20110913TUL05Frame · corrodedCORROSION ON AFT SIDE OF FRAME, STATION 1231, LONGERON 29 LEFT AND RIGHT. ACCOMPLISHED REPAIR PER AARD 53-10-00-17.SDR UALA2011091404965Doubler · dentedAFT CARGO COMPARTMENT, BS 1500 AND STR 26L, FRAME DOUBLER IS DENTED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED FRAME DOUBLER AND FABRICATED A NEW REPAIR DOUBLER PER SRM, REPAIR 5, AND INSTALLED PER SRM ON NON ROUTINE 24194.SDR UALA2011091404964Frame · dentedAFT CARGO COMPARTMENT, BS 1540, STR 26R FRAME IS DENTED ON INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED. TRIMMED OUT DAMAGE ON FRAME INBOARD FLANGE AND FABRICATED A NEW REPAIR DOUBLER ANGLE AND INSTALLED PER SRM, REPAIR 5 AND SRM ON NON ROUTINE 24195.SDR UALA2011091404962Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT BS 1600, STR 25L TO STR 26L. MAJOR REPAIR ACCOMPLISHED. REMOVED DENTED FRAME SPLICE & FABRICATED A NEW REPAIR DOUBLER PER SRM, REPAIR 5 AND INSTALLED PER SRM ON NON ROUTINE 24336.SDR SWAA116521Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727A, WL 208. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201109133862Frame · misrepairedFUSELAGE FRAME, BS 1420 BETWEEN S24-26L MISREPAIRED. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIRSDR UIEA2011091300511Frame · crackedBS 400, S23R FRAME CRACKED. CRACK AREA STOP DRILLED AND REPAIRED IAW HX RS R53-12-37208, REV A.SDR UIEA2011091300503Frame · crackedBS 2598 BULKHEAD OUTER CHORD AREA WL 274, 1 FASTENER HOLE CRACKED AT FRAME SUPPORT FIG (LT BS 2598, BULKHEAD OUTER CHORD WL 274 CRACKED FASTENER HOLE REPAIRED IAW HX RS 53-13-37213, REV A.)SDR UIEA2011091300500Frame · crackedBS 1254 FRAME INNER CHORD FASTENER HOLE CRACK 0.040 IN LENGTH. CRACKED SEGMENT CUT OFF AND REPAIRED IAW HX RS R53-42-37204, REV A AND EO 4753B419, PART 1.SDR UIEA2011091300496Frame · crackedBS 2231, S26R FRAME AFT INNER CHORD CRACK APPROX 1" LONG ON VERT FLANGE. CRACKED AREA TRIMMED OFF AND REPARIED IAW HX RS R53-62-37218, REV A.SDR UIEA2011091300495Frame · crackedBS 2231, S26R, FRAME WEB CRACK APPROX 1" LONG ON FWD INNER CHORD VERT FLANGE. CRACK AREA TRIMMER OFF AND REPAIRED IAW HX RS R53-62=37218, REV A AND WORK DETAILS REF TO NRC NO 50399.SDR NSVA2011434001Frame · crackedFRAME 294 RBL 18.5 CRACKED AT TOP RIVET. COMPLETED REPAIR IAW TD 340-53-12-08.
Back to JASC 5311