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 AALA20110807TUL01Frame · corrodedAFT CARGO HAS CORROSION ON FRAME 1322 NEAR LONGERON 30. CUT OUT CORRODED FRAME ABOVE LONGERON 28 RIGHT TO LONGERON 28 LEFT. SPLICED IN NEW SECTION OF FRAME PER SRM 53-03-00 FIGURE 2A.SDR ASAA11410305Frame · crackedFOUND CRACKED AT PSU MOUNT BRACKET FS 480 BETWEEN STRINGERS 8R + 9R. ACCOMPLISHED FRAME REPAIR IAW EA AD20062609 400 53 123.SDR ASAA11410304Frame · crackedFRAME CRACKED AT PSU MOUNT BRACKET AT FS 747 BETWEEN STRINGERS 8R + 9R. ACCOMPLISHED FRAME REPAIR IAW EA AD20062609 400 53 123.SDR ASAA11410302Frame · crackedCABIN FRAME CRACKED AT PSU ATTACH BRACKET AT FS 400 BETWEEN STRINGER 8L + 9L. ACCOMLISHED FRAME REPAIR IAW EA 20062609 400 53 123.SDR ASAA1140300Frame · crackedFRAME CRACKED AT PSU MOUNT BRACKET BETWEEN 8R+9R. ACCOMPLISHED FRAME REAPIR IAW EA AD 20062609 100 52 123.SDR USAA2011080800012Frame · crackedRON CHECK - FUSELAGE FRAME CRACKED AT WIRE PENETRATION HOLE AT BS 500B BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT WIRE PENETRATION HOLE AT BS 500B BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA115632Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 616, STR 17R. REPAIRED FRAME IAW EA.SDR ASOA201101446Frame · corrodedFRAME CORRODED AT FS319.70, STR 26R. REMOVED FRAME LOWER SECTION IAW SRM 51-42-06 & 51-42-21. DRILLED NEW SECTION OF FRAME & INSTALLED IAW SRM 51-42-06.SDR ASOA201101445Frame · corrodedCORROSION AT FRAME FS 333 STR 26 & 27R. REMOVED CORROSION, FRAME FOUND TO BE WITHIN ALLOWABLE DAMAGE LIMITS SRM 53-00-00.SDR ASOA201101444Frame · corrodedCORROSION AT FS 310, STR 26R AT FRAME. R & R FS310 FRAME LOWER SECTION IAW SRM 51-42-06 & 51-42-21.SDR ASOA201101443Frame · corrodedCORROSION AT FS 349, STR 26L & 27 ON FRAME. REMOVED CORROSION IAW SRM 51-21-06 FRAME FOUND TO BE WITHIN ALLOWABLE LIMITS IAW SRM 53-00-00.SDR FDEA201108043098Frame · misrepairedREPAIR AT BS 1240 BETWEEN S25L AND 26L DOES NOT CONFORM CURRENT S/F CONFIGURATION ACCOMPLISHED EA F 5310-152610. FUSELAGE EXISTING FRAME REPAIR REPLACEMENT AT BS 1240 AND S24L-S26L. MAJOR REPAIR.SDR USAA2011083100029Frame · crackedQ5 CHECK - CRACK ON FUSELAGE FRAME AT BS 500A BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 500A BETWEEN S8L TO S9L IAW EA 103250.SDR USAA2011083100030Frame · crackedQ5 CHECK - .25 INCH CRACK IN FRAME AT BS 727B, BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 727B, BETWEEN S8R TO S9R IAW EA 103250.SDR USAA2011083100028Frame · crackedQ5 CHECK - .25 INCH CRACK ON FRAME AT BS 727B, BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 727B, BETWEEN S8L TO S9L IAW EA 103250.SDR ABXA2011080384Failsafe · corrodedRT FAILSAFE STRAP CORRODED. REMOVED AND REPLACED RT FAILSAFE STRAP IAW REA B653-59389-MR.SDR FDEA201108033087Frame · misrepairedFRAME REPAIR AT STA 1200, S27R DOES NOT CONFORM TO CURRENT SRM S/F CONFIGURATION. ACCOMPLISHED EA F-5310-147708.SDR USAA2011081900028Frame · crackedQ3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500F BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R IAW B737 SRM 53-00-07, REPAIR 13.SDR USAA2011081900022Frame · crackedQ3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500G, S13L. REPAIRED FUSELAGE FRAME AT BS500G, S13L IAW EA 103214.SDR ASOA201101441Frame · crackedFS 718 FRAME CRACKED AT S10L. PERFORMED EDDY CURRENT INSP OF FS 718 FRAME SUSPECTED AREA AT STR 10L IAW NDTM 51-20-06. NO INDICATIONS NOTED AT THIS TIME.SDR UIEA2011080300417Frame · chafedINSPECTION VISUALLY FOUND CHAFING DAMAGE ON FRAME PN 65B04600-7 AT STA 1980 AND COMMON TO STRINGERS 22R AND 23 R. THIS WAS DOCUMENTED ON NRC 51305. (THE DAMAGE WAS REPAIRED BY BLENDING OUT THE CHAFE MARKS. THE BLENDED AREAS WERE HFEC INSPECTED TO ENSURE CRACKSDR UALA2011080304035Frame · corrodedCORROSION ON FRAME AT BS 1460 INBD OF STR 28R & BETWEEN STR 29R - 28L. ACCOMPLISHED PERMANENT REPAIR PER EA PD57-53-166 AND EVA 81175.SDR UALA2011080304029Frame · damagedSTA 300 AT STR 4L HAS DAMAGE. MAJOR REPAIR WAS ACCOMPLISHED ON DOUBLE DRILLED HOLE STA 300 AT STR 4L BY TRIMMING OUT THE DAMAGE AND INSTALLING A FILLER AND A REPAIR DOUBLER REF EVA-81116A. REPAIR WAS ACCOMPLISHED AND INSPECTED.SDR UALA2011080304028Frame · dentedDENT IN FRAME AT STATION 1520 BETWEEN STR 25 AND 26L. ACCOMPLISHED ON TASK CARD 3025N00411 DENT IN FRAME AT STATION 1520 BETWEEN STR 25 & 26 L.SDR COEA2011080307816Frame · corrodedHEAVY CK COE / MAJOR REPAIR: FRAME 28D IS CORRODED ON THE AFT SIDE STR 21L-21R LOWER FLANGE AND WEB AT BL 0. REPAIR PER STRUCTURAL REPAIR INSTRUCTIONS FROM ATR AND SRM.SDR SWAA115604Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA115598Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 727B, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA115597Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA115595Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 380, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA115588Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR USAA2011080400001Frame · crackedFRAME INSPECTION - WHILE PERFORMING CARD E2B53003 IN FORWARD CARGO BAY FOUND FRAME 500B LEFT CRACKED BETWEEN S20L TO S21L, WL180, LBL60. VERIFIED BY HFEC INSPECTION. REPAIRED FUSELAGE FRAME 500B BETWEEN S20L TO S21L, WL 180, LBL 60 IAW B737 SRM 53-00-07 REPASDR FDEA201108033086Frame · gougedMAIN DECK FRAME STA 1280, RT, BETWEEN S11-12R, DEEP GOUGE IN FRAME FLANGE. REMOVED GOUGE ON FRAME STA 1280 BETWEEN S-11R TO S-12R IAW SRM 51-10-02. ORIGINAL THICKNESS .071, REMAINING THICKNESS .011. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07 FIG 101, DETAILSDR ASAA11410327Frame · crackedLT FRAME 520 CRACKED AT FORMER A/C BRACKET ATTACHMENT HOLE. REPAIRED FRAME IAW ASA EA 20062609 400 53 122 AND ASA DWG A5310052688.SDR ASAA11410249Frame · crackedRT FRAME 500A CRACKED AT FORMER AC BRACKET ATTACHMENT HOLE. REPAIRED FRAM IAW ASA EA AD 2006 2609 400 52 122 AND ASA DWG A5310025688.SDR ASAA11410248Frame · crackedRT FRAME 400 CRACKED AT FORMER ATTACHMENT HOLE FOR AC BRACKET. REPAIRED FRAME IAW ASA EA AD 2006 2609 400 53 122 AND ASA DWG 5310025688.SDR ASAA11410247Frame · crackedLT FRAME 500D CRACKED AT FORMER AC BRACKET ATTACHMENT HOLE. REPAIRED FRAME IAW ASA EA AD 2006 2609 400 53 122 AND ASA DWG A5310025688.SDR ASAA11410246Frame · crackedFRAME 500C CRACKED AT LT FORMER AC BRACKET ATTACHEMENT HOLE. REPAIRED FRAME IAW ASA EA AD 2006 2609 400 53 122 AND ASA DWG A531025688.SDR ASAA11410245Frame · crackedFRAME 440 CRACKED AT FORMER AC BRACKET ATTACHMENT HOLE. REPAIRED FRAM IAW ASA EA 14486 AND ASA DWG A5310025688.SDR ASAA11410244Frame · crackedRT FRAME 480 CRACKED AT FORMER AC BRACKET ATTACHMENT HOLE. REPAIRED FRAME IAW ASA EA AD 2006 2609 400 53 122 AND ASA DWG A5310025688.SDR CHQA201100336Frame · crackedDURING INSPECTION, A CRACK WAS FOUND ON FRAME 10 AT THE COCKPIT LEFT DIRECT-VISION WINDOW CUTOUT. MAINTENANCE REPLACED THE LEFT FRAME 10 SECTION AT THE COCKPIT LEFT DIRECT-VISION WINDOW CUTOUT IN ACCORDANCE WITH SRM 51-40-02.SDR CHQA201100325Frame · crackedDURING INSPECTION, CHANNEL FRAME 10 WAS FOUND TO BE CRACKED AT THE COCKPIT RIGHT DIRECT-VISION WINDOW CUTOUT. MAINTENANCE REPLACED CHANNEL FRAME 10, RIGHT SIDE IN ACCORDANCE WITH SRM 51-40-02.SDR FDEA201108023192Frame · corrodedFRAME AT STA 1645 (FWD OF L-4 DOOR) HAS CORROSION ON LOWER END WL 210 INBD FLANGE LT SIDE LBL 55.SDR FDEA201108023182Frame · corrodedFRAME AT BS 1645, LOWER END HAS CORROSION AT WL 210 INBD FLANGE RBL 55.SDR UIEA2011080200427Frame · crackedDURING C4/A6 CHECK, DETECTED 6 EA CRACKS ON THE FRAME STRAP FASTENER HOLES; 2 EA CRACKS ON THE FWD INNER CHORD FASTENER HOLES; 3 EA CRACKS ON THE AFT INNER CHORD FASTNER HOLES AND 2 EA CRACKS ON THE DOOR REVEAL PANEL FASTENER HOLES. THE DETAIL OF THE CRACK FISDR UIEA2011080200422Frame · crackedDURING C4/A6 CHECK, INSPECTION DETECTED 2 EA CRACKS, APPROX 0.50 INCH LONG RUNNING INBD AND 1.8 INCHES LONG RUNNING OTBD AT S-23L CUTOUT AND ANOTHER CRACK APPROX 0.50 INCH LONG, RUNNING INBD AT S-24AL CUTOUT ON THE LT SIDE, BS 380 FRAME.SDR UALA2011080304023Frame · corrodedCORROSION ON FRAME AT STA 1680 29L - 29R. MAJOR REPAIR ACCOMPLISHED: REPAIRED FRAME AT STA 1680 STR 29L - 29R PER EA PD57-53-159 AND EVA 81158.SDR COEA2011080205816Frame · damagedHEAVY CK COE / MAJOR REPAIR: FRAME 24 HAS 3 DRILL STARTS AND SCRATCHES BLENDED ON FORWARD SIDE BETWEEN STR 2AL - 3L. REPAIR PER STRUCTURAL REPAIR INSTRUCTIONS FROM ATR.SDR COEA2011080204816Frame · damagedHEAVY CK / COE / MAJOR REPAIR: FRAME 20 HAS OVERSIZED AND OUT OF ROUND HOLE IN FRAME TIE NEAR STR13L. REPAIR PER STRUCTURAL REPAIR INSTRUCTION FROM ATR.SDR SWAA115576Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA115573Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.
Back to JASC 5311