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 U2RA478DHN010Frame · corrodedMAIN CABIN STA 1640, FRAME AT STR 17R CUSP WEB HAS CORROSION.SDR SWAA111554Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR USAA2011031091012Frame · crackedCLT - Q5/QX6 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727B BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8L TO S9L IAW EA 102739.SDR USAA2011031091011Frame · crackedCLT - Q5/QX6 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727D BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 727D BETWEEN S8L TO S9L IAW EA 102739.SDR SWAA111492Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 931, STR 23L. REPAIRED FRAME PER SRM.SDR EIAA 2011022Frame · gougedINTERNAL EMPENNAGE BS 2460 LBL 31 INBOARD CHORD ON FRAME IS GOUGED UNDER ROD END THAT HOLDS APU DUCT CLAMP. FABRICATED AND INSTALLED REPAIR CHORD PER B747 SRM 51-40-04 FIG 3 PG 9-19.SDR AALA20110307TUL04Frame · wornTEMP CONTROL VALVE WEARING INTO FRAME 1380. INSTALLED DOUBLER PER AARD 53-10-00-28.SDR DALA1116136315Frame · damagedFOUND HEAT DAMAGE ON BULK CARGO LOWER LOBE FRAME WEB AT STA 2160, LBL23, AREA:1.97" X 1.38" DO THE FRAME WEB REPAIR IAW ER/A488632-14 REV ORIG INSP THRESHOLD: 20000 TOTAL FLIGHT CYCLES.SDR DALA1115979877Frame · crackedFOUND FRAME CRACK AT STA 332, STR 17R ATTACH POINT. REMOVED DAMAGE, FABRICATED REPAIR ANGLE, REPAIR PLATE, REPAIR FILLER, AND PLATE FILLER IAW SRM 53-05, FIG 4, PG 5, TREATED AND PRIMED REPAIR PARTS IAW SRM 51-10-3, PG 40, PAR 24 AND PG 15, INSTALLED REPAIR SDR DALA1115969877Frame · crackedFOUND FRAME CRACKED AT STA 275, STR 17R ATTACH POINT. REMOVED DAMAGE ON AREA AT FRAME STA 275, STR 17R IAW SRM-53-03-FIG 4, PG 5, FABRICATED REPAIR PARTS, REPAIR ANGLE, REPAIR FILLER, REPAIR PLATE IAW SRM 53-03, PG 5, FIG 4, TREATED AND PRIMED REPAIR PARTS,SDR DALA1115959877Frame · crackedFOUND FRAME CRACK AT STA 275 S17R ATTACH POINT, CORRECTED. REMOVED DAMAGE ON AREA AT FRAME STA 275, STR 17R IAW SRM-53-03, FIG 4, PG 5. FABRICATED REPAIR PARTS, REPAIR ANGLE, REPAIR FILLER, REPAIR PLATE, AND PLATE REPAIR, IAW SRM 53-03, PG 5, FIG 4, TREATED SDR FDEA201103070891Frame · damagedNOSE E/E BAY FRAME AT STA 231.25 BL 0 FOUND WITH GOUGE MARK. DAMAGED NOSE E/E BAY FRAME REPLACED BY FABRICATED FRAME IAW SRM 51-40-02, REV 102. REPAIR IS CLASSIFIED AS MAJOR.SDR USAA2011031191025Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 907 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 907 BETWEEN S8R TO S9R IAW EA 102739.SDR USAA2011030891001Frame · crackedCLT - Q5/QX-6 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 867 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 867 BETWEEN S8R TO S9R IAW EA 102739.SDR SWAA111424Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN LBL 17 TO LBL 18. REMOVED AND REPLACED FRAME PER SRM.SDR CALA2011F00107Frame · corrodedMAIN CABIN AT STN 994 ADJACENT TO R2 DOOR OPENING CIRCUMFERENTIAL FRAME CORRODED BETWEEN STRINGERS S17R AND S18R LEVEL II CORROSION NOTED.SDR USAA2011033191298Frame · crackedCLT - Q5/QX6 - CRACK ON FUSELAGE FRAME AT BS 500A BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 500A BETWEEN S8L TO S9L IAW EA 102739.SDR FDEA201103050856Frame · gougedAFT PIT FRAME AT BS 1070 UPPER FLANGE IS GOUGED ABOVE STR 27L. CUT OUT DAMAGED AREA OF FRAME BS 1070 UPPER FLANGE ABOVE STR 27L IAW SRM 51-40-3 FIG 1. FABRICATED DOUBLER IAW SRM REV 103, 51-40-3 FIG 1 AND 51-30-5. INSTALLED DOUBLER IAW SRM 51-40-3 FIG 1.SDR FDEA201103050862Frame · crackedREFER TO FEDEX E.O. 6-5310-7-5017A PART 4, EOCN A4: HFEC INSPECTION CARRIED OUT AND FOUND FASTENER HOLE "K" WITH CRACKED INDICATION AT FRAME 47RH, BETWEEN STR 24 AND STR 25 INNER CHORD. ONE (1) EACH FASTENER HOLE (HOLE K) AT RIGHT HAND FRAME 47 INNER CHORDSDR SIMA201106901Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FRAME 23 CRACKED AT RIGHT FLOOR SILL NEAR SERVICE DOOR. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 WITH DOUBLER IAW ETD2011-145/00044 AND SRM 51-40-02. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR GLBA20110308GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE CARGO DOOR AFT FUSELAGE FRAME CRACKED 1.5" IN LENGTH AT THE GAS STRUT MOUNT UPPER IB NUT PLATE, FS 509 BETWEEN STRINGERS 4L & 5L. REF SDR 20110308F. MAINTENANCE REPAIRED THE AFFECTED ASDR GLBA20110308HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE CARGO DOOR FRAME AT THE FWD GAS STRUT MOUNT CRACKED IN TWO PLACES 1.5" IN LENGTH AT FS 456 BETWEEN STRINGERS 3L & 4L. REF SDR 20110308F. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFSDR DALA1123121200Strap · crackedLT STA 955 REAR SPAR BULKHEAD FAIL SAFE STRAP FASTENER HOLE CRACK. REPAIR ACCOMPLISHED AS PER ERA 489715-14AD REV ORIG.SDR GLBA20110304HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE RH FUSELAGE FRAME CRACKED .3" IN LENGTH AT STRINGER 9AR CUTOUT AT F.S. 177. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-014. MATSDR GLBA20110304GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE RH FUSELAGE FRAME CRACKED AT STRINGER CUTOUT F.S. 183 STRINGER 9AR, .4" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-0SDR ASOA201100428Frame · corrodedFOUND CORROSION AT FS 364.00 AND BETWEEN STR 26R AND 27R. INSTALLED ORIGINAL TEFLON DOOR GUIDES ON FWD SIDE OF AVIONICS BAY DOOR OPENING PER AMM 20-21-00-910-801.SDR ASOA201100427Frame · corrodedFOUND CORROSION AT FS 364.00 AND BETWEEN STRINGER 26L AND 27L. INSTALLED ORIGINAL TEFLON DOOR GUIDES ON FWD SIDE OF AVIONICS BAY DOOR OPENING PER AMM 20-21-00-910-801.SDR SIMA201106704Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND FRAME 23 CRACKED JUST BELOW FLOOR LEVEL BETWEEN STRINGERS 15 RIGHT AND 16 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME IAW EO EM-53MR-1779. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1141919227Frame · corrodedHMV2 STA 1443 AFT SIDE OF FRAME HAS CORROSION FROM L30-L27R. REPLACED CHORD PER MD90 SRM 51-30-02.SDR USAA2011040591329Frame · crackedCLT - Q5/QX6 - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR GLBA20110303HFrame · crackedDURING A SCHEDULED ROUNTINE INSP MX FOUND THE RT SIDE WALL HEAVY ANGLE AT FS 303, CRACKED IN THE BEND RADIUS, APPROX 1" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-010. MATERIALS UTILIZED ARE INCLUDED IN SDR USAA2011033191297Frame · crackedCLT - Q5/QX6 - CRACK ON FUSELAGE FRAME AT BS 727F BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 727F BETWEEN S8R TO S9R IAW EA 102739.SDR GLBA20110303GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND THE LT HEAVY ANGLE CRACKED AT FS 303 APPROX 1" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 11-1900-53-009. MATERIALS UTILIZED ARE INCLUDED IN THE ENGINEESDR GLBA20110303FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND THE FUSELAGE FRAME CRACKED AT FS 273.25 & STR 2R, CRACKS ON INBD & OTBD SIDE OF STRINGER CUTOUT, .7", .8" & .6" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. SDR AALA20110316DWH06Frame · dentedDENT DAMAGE TO THE STATIONS 500 AND 522 FUSELAGE FRAME INNER CHORD BETWEEN STRINGERS 29 TO 31 LEFT. ACCOMPLISHED REPAIR PER EA B767-53-015336.SDR GLBA20110303JFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND THE FUSELAGE FRAME AT FS 456 CRACKED .3" IN LENGTH AT STRINGER 9AR CUTOUT. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 11-1900-53-015. MATERIALS UTILIZED ARE INCLUDSDR FDEA201103030838Gusset · crackedOVERWING LT FRAME AT BS 825, BELOW FLOOR LEVEL, GUSSET IS CRACKED AT INBD LOWER FASTENER. REMOVED GUSSET AT BS 825 LT BELOW FLOOR LEVEL IAW SRM 51-30-2, REV 103 FABRICATED GUSSET IAW EO 7-5310-7-3367, PART 9 INSTALLED GUSSET IAW EO 7-5310-7-3367, PART 9.SDR SWAA111342Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA111341Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA111335Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 28L TO BS 28R. REPAIRED FRAME PER SRM.SDR SWAA111334Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 27R TO BS 28R. REPAIRED FRAME PER SRM.SDR SWAA111333Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 25R TO BS 26R. REPAIRED FRAME PER SRM.SDR DALA1120489870Frame · crackedAFT ACCESSORY COMPARTMENT CANTED FRAME CRACKED AT L18L BEHIND PREVIOUS REPAIR. REMOVED OLD REPAIR IAW DC-9 SRM 51-30-2, 51-30-5. CUT OUT CRACKED SECTION OF WEB AT STA 1292 L18L IAW DC-9 SRM 53-03 NO CRACKS FOUND FABED, TRIMMED, DRILLED NEW DOUBLER IAW SRM 53SDR FDEA201103020824Frame · crackedAFT CARGO TA 1280 26R-25R FRAME HAS A CRACK. COMPLIED WITH E.A. F-5310-146259,8100-9 DATED MARCH 11, 2011- FIRST STAGE APPROVAL DTA 24 MONTHS. MAJOR REPAIRSDR SIMA201106301Frame · chafedDURING MX BASE VISIT, FOUND CHAFE ON FRAME 19 IN THE GALLEY BELOW STRINGER 3 RT. THE ACFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 19 IAW EO-EM-53MR-1778. THE ACFT WAS RETURNED TO SERVICE.SDR ASOA201100410Frame · corrodedCORROSION ON LEFT AND RIGHT RADIUS ON STR 27 FWD OF FRAME 349. INSTALLED NEW STR 27 SECTION AND DOUBLERS IAW SRM 53-00-03, MINOR REPAIR. REPAIRED IAW SRM 53-00-03.SDR JR2R2011030200067Frame · crackedAFT BAG BAY CUTOUT LWR SURROUND STRUT STUB FRAME AT FS 1015 CRACKED AND BENT. REMOVED AND REPLACED AFT BAG BAY DOOR LWR STUB FRAME AT FS 1015 IAW CRJ 700 SRM 51-42-06 AND 51-42-21.SDR ZZDA2011234Frame · crackedAPU ENCLOSURE RIGHT FWD FRAME, CRACKED. ACCOMPLISHED FRAME REPLACEMENT PER B717 SRM 51-41-02 AND B717 SRM 51-41-08.SDR SWAA111278Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA111263Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.
Back to JASC 5311