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 ASAA1148952Frame · crackedFRAME CRACKED AT BS 400 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148951Frame · crackedFRAME CRACKED AT BS 400 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148950Frame · crackedFRAME CRACKED AT BS 360 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11SDR ASAA1148938Frame · crackedFRAME CRACKED AT BS 500F BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148937Frame · crackedFRAME CRACKED AT BS 480 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR USAA2011012890406Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 867 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 867 BETWEEN S8L TO S9L IAW EA 102559.SDR USAA2011012890405Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 480 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 480 BETWEEN S8R TO S9R IAW EA 102559.SDR ASOA201100066Frame · corrodedFS 333.0 IS CORRODED AT STR 25 LT TO 25 RT. REMOVED DAMAGED FS 333.0 FRAME AND INSTALLED SERVICEABLE FRAME IAW SRM 51-42-06.SDR SWAA110168Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 21R. REPAIRED FRAME PER EA.SDR COEA2011011106805Frame · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: LEVEL 2 CORROSION BETWEEN 21R & 21L AT FRAME 39 (BEHIND TAIL SKID STRUCTURE)(LENGTH 4", WIDTH 1", DEPTH .080"). REPAIR PER ATR72 SRM.SDR COEA2011011104805Frame · corrodedHEAVY CK COE / MAJOR REPAIR/LEVEL 2 CORROSION: LEVEL 2 CORROSION FOUND ON FRAME 41 BETWEEN STRINGER 16R AND 17R (LENGTH 5", WIDTH 1.125", DEPTH .006"). BLENDED CORROSION ON FR41 BETWEEN STR 16-17R. WAITING FOR REPAIR INSTRUCTIONS FOR A SRI FROM ATR.SDR COEA2011011103805Frame · corrodedHEAVY CK COE LEVEL 2 CORROSION: FOUND LEVEL 2 CORROSION AT FRAME 28D STR 20L - 21L. (LENGTH: 6", WIDTH 1", DEPTH .040"). REMOVED FRAME 28D AND SPLICE. INSTALLED FRAME SEGMENT 28D FROM FACTORY SPLICE - SPLICE STR 17R AND 17L.SDR C2XA11TY004Frame · crackedTYS - FRAME 10 BELOW PILOTS DV WINDOW CRACKED. REMOVED AND REPLACED FRAME 10 BELOW PILOTS DV WINDOW.SDR FOTR2021700828Frame · damaged(FOTR) MAIN CABIN FRAME AT BS 720A BETWEEN STR 16L-17L HAS DOUBLE DRILLED HOLE. CUTOUT DAMAGED AREA, DIMENSION 1" X .75" IAW SRM 51-10-1. FABRICATED DOUBLER FROM 7075-T6 PO 90010361, .063" DIMENSION 5.8750" X 3.8750" IAW SRM 51-40-3, FIG 1. INSTALLED REPAIR PSDR FOTR/20217/00827Frame · damaged(FOTR) MAIN CABIN FRAME AT BS 700 BETWEEN STR 16L-17L HAS DOUBLE DRILLED HOLES. CUTOUT DAMAGED AREA AT BS 700 DIMENSION 1" X .8" IAW SRM 51-10-1. FABRICATED DOUBLER FROM 7075-T6 .063 PO 90010361, DIMENSION 6.8750" X 3.5" IAW SRM 51-40-3, FIG 1. INSTALLED REPAISDR FOTR/20217/00826Frame · damaged(FOTR) CABIN FRAME AT BS 680 BETWEEN STR 16L-17L HAS DOUBLE DRILLED HOLES. CUTOUT DAMAGED AREA DIMENSION 1.4" X .6" ON BS 680 BETWEEN STRINGER 16L-17L IAW SRM 51-40-3 FIGURE 1. FABRICATED REPAIR ANGLE FROM 7075-T6 .050" PO 9009353 DIMENSION 7" X 3.6" IAW SRM SDR FOTR2021700821Frame · dented(FOTR) CABIN FRAME AT BS 560 BETWEEN STR 15R-16R DENTED. CUTOUT DAMAGED AREA ON BS 560 BETWEEN STR 15R-16R, DIMENSION 1.1" X 1.1" IAW SRM 51-40-3, FIG 1. FABRICATED REPAIR ANGLE FROM 7075-T6 .071' PO 9009519, DIMENSION 6.5" X 3.5" AND REPAIR FILLER FROM 7075-SDR FOTR202170064Frame · dented(FOTR) LT FUSELAGE CABIN INTERIOR HAS FRAME DENTED AT BS 720, STR 16L. CUTOUT DAMAGED AREA ON FRAME DIMENSION 9" X .9" AT BS 720, STR 16L IAW SRM 51-10-1. FABRICATED FRAME REPAIR FROM 7075-T6 .063" PO 90010361, DIMENSION 5.5" X 17.3" IAW SRM 51-40-3, FIG 1. TSDR FOTR2021700661Frame · cracked(FOTR) REMOVED DAMAGED AREA FROM FRAME AT STR 17L DIMENSION 2.2500" X 1.5" IAW SRM 51-10-1, AND 51-30-2. FABRICATED REPAIR IAW SRM 51-40-3 FROM 7075-0 DIMENSION 9.1" X 4.1" PO 20198132. HEAT TREATED TO 7075T6 IAW FASI REPORT 2-37153-801A. FABRICATED CLIP FROSDR FOTR/20217/00381Frame · dented(FOTR) CABIN FRAME DENTED AT BS 400 BETWEEN STRINGER 5R-6R. REMOVED DAMAGED AREA OF BS 400 FRAME AT STR 5R-6R DIMENSION 2.25" X 4" IAW SRM 53-10-4 FIG 1, FABRICATED REPAIR FILLER AND 2 EACH SPLICES FROM 7075-0, .050, PO 90010501 AND HEAT TREATED TO T-6 IAW SSDR FOTR/20217/00378Frame · dented(FOTR) CABIN FRAME AT BS 380 DENTED BETWEEN STR 5R-6R, REMOVED DAMAGE AREA OF BS 380 FRAME AT STR 5R-6R, DIMENSION 15" X 4" IAW SRM 53-10-4, FIG 1. FABBRICATED REPAIR FRAME AND 2 EACH SPLICES FROM 7075-0 .050 PO 90010501 AND HEAT TREATED TO T-6 IAW SRM 53-10-0SDR FDEA201101100095Frame · dentedMAIN DECK CABIN, FRAME AT STA 1561, LONGERON 12 RT FOUND DENTED. CARRIED OUT REPAIR IAW SRM 53-00-07, FIGURE 201, REPAIR 2, REV 45. REPETIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07, FIG 201SDR FDEA201101100094Frame · dentedMAIN DECK CABIN, FRAME AT STA 1661, LONGERON 12 RT, FOUND DENTED. CARRIED OUT REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 45. REPETIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07, FIG 201, RSDR SWAA110134Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 1016, BETWEEN STR 26L TO STR 27R. REPAIRED FRAME PER EA.SDR SWAA110126Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR AALA20110126TUL15Beltframe · damagedBELLFRAME 1064 BULGED AND CRACKED AROUND FASTENER HOLE. REMOVED DAMAGED AREA TO .5 INCH DIAMETER AND INSTALLED SHANK-PLUG PER EA B737-53-015033.SDR AALA20110109TUL01Frame · damagedFRAME DAMAGED AT STATION 237 AND SEAT TRACK 5. INSTALLED DOUBLER ON FRAME PER AARD 51-60-00-05 AND SRM 53-05-00 FIGURE 20A SHEET 1.SDR SWAA110084Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT BS 492, STR 24R. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA110074Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.SDR DALA1109380178Frame · crackedCABIN STA 903 BETWEEN STR 20R AND 21R FRAME INNER CHORD CRACK. REPAIR ACCOMPLISHED IAW ER/A 487038-14AD.SDR DALA1117599223Frame · corrodedHMV2 AFT CARGO STA 1328 BETWEEN 28RT AND 26LT FRAME CORRODED. REPLACED FRAME PER SRM 51-30-02.SDR DALA1117459223Frame · corrodedHMV2 AFT CARGO STA 1344 BETWEEN 29RT AND 29LT FRAME CORRODED. REPAIR FRAME PER SRM 53-10-02.SDR DALA1109639223Frame · corrodedAFT CARGO STA 1364 BETWEEN STGR 29RT AND 29LT FRAME CORRODED. REPAIR IAW SRM 53-00-01 51-30-05.SDR DALA1109619223Frame · corrodedHMV2 AFT CARGO STA 1307 BETWEEN STGR 30 AND 28LT FRAME CORRODED. REPAIR IAW SRM 53-10-02, 51-30-05.SDR AALA20110107TUL12Frame · crackedAFT ACCESSORY FRAME CRACKED AT STATION 1418 AND LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00.SDR SWAA110097Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND L2 DOOR STUB FRAME CRACKED AT BS 955, WL 254. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR ASAA1148879Frame · damagedBS 328 FRAME SPLICE MISSING MATERIAL AT ONE OF FOUR END FASTENERS. REPAIRED FRAMES IAW ASA EA 400 53EA 04649 REV NEW DATED 26 JAN 2011.SDR AALA20110106TUL07Frame · damagedFOUND GOUGE AT FRAME 1231 LOWER FLANGE STATION 1231, LONGERON 30. BLENDED OUT GOUGE AT FRAME 1231 LOWER FLANGE STATION 1231, LONGERON 30 PER 51-10-03. TREATED AND PRIMED AREA PER SRM 51-10-03. INSTALLED J ANGLE REPAIR ON LOWER FLANGE PER AARD 53-10-00-14, SDR AALA20110106TUL05Frame · crackedLEFT CANT FRAME WEB CRACKED ABOVE LEFT LOUVER BOX AT STATION 1463. INSTALLED REPAIR DOUBLER PER EA MD80-53-014696 DATED 01/06/2011 AND SRM 53-01-4.SDR FDEA201101060059Frame · misalignedSHORT EDGE MARGIN CONDITION ON 657N3227-8 FRAME DOUBLER CHORD AT STA 680 S-4R . AT STA 680, STR 4 R , A SHORT EDGE MARGIN CONDITION EXIST ON THE 657N3227-8 FRAME DOUBLER CHORD. A REPAIR WAS ACCOMPLISHED ON STAM EA757-5332-16-F2980 REV- DATED 10/18/2010. SDR FDEA201101060049Frame · corrodedREAR FUSELAGE FRAME 85, APPROX 15 INCHES INBD OF STR 16 RT HORIZ CROSSBEAM HAS EXFOILIATION CORROSION ON LOWER FLANGE. REMOVED LEVEL 1 CORROSION. FRAME R & R IAW SRM 53-19-47 WITH FABRICATED PART REF SDR NR 11-0303.SDR DALA1109390178Frame · crackedCABIN STA 903 BEWTEEN STR 20L AND 21L FRAME INNER CHORD CRACKED. REPAIR ACCOMPLISHED IAW ER/A 487037-14AD.SDR DALA1106830198Frame · crackedCABIN STA 903, BETWEEN STR 20R AND STR 21R FRAME INNER CHORD CRACK REPAIR ACCOMPLISHED IAW ER/A 487045-14AD.SDR DALA1106820198Frame · crackedCABIN STA 903 BETWEEN STR 20L AND STR 21L FRAME INNER CHORD CRACK REPAIR ACCOMPLISHED IAW ER/A 487044-14AD.SDR ASOA201100034Frame · corrodedFS 333, FRAME IN BELLY IS CORRODED. REMOVED CORRODED FRAME FROM FS 333 IAW SRM 51-42-06 AND 51-742-21. LOCATED AND DRILLED NEW FS 333 FRAME PIN 601R32004-55 AND INSTALLED IAW SRM 51-40-11, 51-42-21 & 51-42-06.SDR DALA1101059864Frame · crackedAFT ACCESSORY COMPARTMENT STA 1339 RT SIDE AT ALIGNMENT PIN FRAME IS CRACKED. REMOVED OLD FRAME IAW SRM 51-30-2, 51-30-1. RECEIVED NEW FRAME LOCATED DRILLED AND DEBURRED NEW FRAME IAW SRM 51-30-1,51-30-2. INSTALLED NEW FRAME AT STA 1339 RT SIDE IAW SRM 51-3SDR SWAA110045Failsafe · crackedDURING SCHEDULED OTS CHECK, FOUND FAIL SAFE ANGLE CRACKED AT BS 440, STR 16L. REPAIRED ANGLE PER SRM.SDR GLBA20100105FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND A CRACK IN THE FRAME AT FS 303 IN THE BEND RADIUS, 1.1" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO10-1900-53-064 AND EO 11-1900-53-001. MATERIALS UTILIZSDR ASAA1148805Frame · crackedBS 727F RT FRAME CRACKED BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE, FABRICATED REPAIR DOUBLER AND INSTALLED REPAIR IAW ASA TASK CARD AD20062609 400 53 104.SDR ASAA1148803Frame · crackedBS 787 RT FRAME CRACKED BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE, FABRICATED REPAIR DOUBLER AND INSTALLED REPAIR IAW ASA TASK CARD AD20062609 400 53 104.
Back to JASC 5311