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 SIMA201012703Frame · gougedDURING MAINTENANCE BASE VISIT FOUND FRAME 64 TO HAVE A TOOLING MARK BETWEEN STRINGER 6 RIGHT AND STRINGER 7 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 64 WITH DOUBLER IAW ENGINEERING ORDER EM-53MR-1534. THE AIRCRAFT WAS RETURNED TO SERVICESDR MALA100067Frame · chafedRT FUSELAGE FRAME AT STA 630.112, SL 1614 TO 1620 HAS SEVERAL CHAFED AREAS ON INBD FLANGE AFT EDGE. RT FUSELAGE FRAME STA 630.112 WAS FOUND CHAFED AT THE EDGE OF THE INNER (FREE) FLANGE. CHAFE NR1 - 9" ABOVE SL1614 IS 0.5" LONG X 0.125" DEEP, NR 2 - 12.25" ABOSDR ABXR201006250010Frame · corrodedDURING A HEAVY MX EVENT, FOUND CORROSION AT FS 1322, L28L TO L28R ON FRAME AND FRAME LOWER LEG. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS. REPAIRED FRAME IAW SRM. REMOVED DAMAGED SECTION OF FRAME FROM L29R TO L29L AND INSTALLED NEW SECTION OF FRAME IAW SRM.SDR ASAA1047955Frame · crackedFRAME CRACKED AT STA 500C. REMOVED DAMAGE AND INSTALLED NEW FRAME REPAIR.SDR ASAA1047931Frame · crackedFRAME CRACKED AT STA 500C BETWEEN 8L & 9L. REMOVED RIVET PLUGS AND CUTOUT DAMAGE INSTALLED FRAME REPAIR.SDR DHLA201000058Frame · crackedMAIN CARGO COMPT. FRAME CRACKED 1" BS 220.000 L20-21R. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2 SHEET 2,6. REMOVED FRAME SEGMENT, ANGLE & SPLICE (EXISTING) IAW SRM 51-1-20D. FABRICATED NEW FRAME SEGMENT IAW SRM 53-2-0 FIG 2, SHEET 2, SRM 53-2-0 FIG 2 SHEETSDR DLM88101115Frame · dentedDURING HMV FOUND A 1 INCH DENT AT STA 237 L-18-L ON EXISTING REPAIR. FOUND DENT IN REPAIR DOUBLER TO BE OUT OF LIMITS DUE TO CREASE. FOUND FORMER STA 237 L18L -17L DENTED AND BENT. REMOVED, OBTAINED AND INSTALLED NEW FORMER 9911524U3 IAW SRM 51-30-2, 51-30-5, SDR AALA20100504TUL10Frame · crackedTHE LEFT FRAME IS CRACKED AT STATION 400 AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER ECO J1159AC.SDR FDEA201005041452Frame · misrepairedEXISTING REPAIR (2 EACH) FOUND AT MAIN DECK FRAME STA 535 BETWEEN LONGERON 20 LT AND LONGERON 26 LT. EXISTING REPAIR (2 EACH) AT MAIN DECK FRAME STA 535 BETWEEN LONGERON 20 LT AND LONGERON 26 LT EVALUATED AND FOUND NOT IAW SRM. STA 535 MAIN DECK FRAME BETWEESDR SWAA102589Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO BAY FRAME CORRODED AT BS 727E, BETWEEN STR 23L TO STR 27R. REPAIRED FRAME PER SRM.SDR SIMA201012506Frame · gougedDURING MAINTENANCE BASE VISIT FOUND RIGHT FRAME 64 HAS TOOLING MARKS BEYOND MANUAL LIMITS. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED RIGHT FRAME 64 IAW EO-EM-53MR-1523. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR AALA20100506TUL23Frame · crackedTHE FRAME AT STATION 480 RIGHT IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER J1159AC CARD 0005 NON ROUTINE 1340796 IN DWMS.SDR AALA20100505TUL10Frame · crackedTHE RIGHT FRAME AT STATION 480 AT AIR CONDITION RAIL BRACKET INBOARD HOLE IS CRACKED. REPAIRED PER ECO J1159AC CARD 0005.SDR AALA20100505TUL09Frame · crackedTHE RIGHT FRAME AT STATION 400 IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER J1159AC CARD 0005.SDR AALA20100505TUL07Frame · crackedTHE RIGHT FRAME AT STATION 727 IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER J1159AC CARD 0005.SDR AALA20100504TUL11Frame · crackedSTATION 500C RIGHT FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD HOLE. REPAIRED PER TASK CARD J1159_0005-/002.SDR AALA20100503TUL07Frame · crackedTHE RIGHT FUSELAGE FRAME IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE AT STATION 500C REPAIRED PER ENGINEERING CHANGE ORDER J1159AC.SDR SWAA102579Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT PIT, DOOR STUB FRAME CORRODED AT BS 992.5, BETWEEN STR 17R TO STR 20R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA102573Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO BAY FRAME CORRODED AT BS 727E, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA102553Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, LBL 65. REPAIRED FRAME PER SRM.SDR FDEA201005021428Frame · unknownCABIN FUSELAGE INTERIOR FRAME WITH EXISTING REPAIR DOUBLER AT STA 1140, BETWEEN STRINGER S-1L TO S-3L. CABIN MAIN FRAME AT STA 1140, S-6L TO S-6R REPAIRED IAW SRM 53-00-07 REPAIR 1, REV. 99. INITIAL INSP THRESHOLD AT 50,000 FLIGHT CYCLES AND AN INTERVAL INSPSDR FDEA201005021427Frame · unknownCABIN FUSELAGE INTERIOR FRAME WITH EXISTING REPAIR DOUBLER AT STA 1120, BETWEEN STRINGERS S-1L TO S-3L. CABIN MAIN FRAME AT STA 1120, S-7L TO S-4R REPAIRED IAW SRM 53-00-07 REPAIR 1, REV. 99. INITIAL INSPECTION THRESHOLD AT 50,000 FLIGHT CYCLSES AND AN INTSDR SWAA102511Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 420, STR 1. REPAIRED FRAME PER SRM.SDR SWAA102483Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR UIEA201000149Frame · damagedDURING C-CHECK AND INSPECTION IAW EO 4753A521, ADDITIONAL DAMAGE WAS FOUND IN THE BS 2231 FRAME INNER CHORD AT S-25R. THE DAMAGE WAS TRIMMED OUT AND REPAIRED IAW NRC 745 AND SRM 53-10-04, FIGURE 115 (SEE FIG 1, 2 AND 3). NOTE: THIS EO REPLACED EO 4753A521. TESDR CALA2010050400184Frame · crackedFRAME STA 360 CRACKED BETWEEN STR 8L&9L AT A/C OUTLET EXTRUSION ATTACHMENT REPAIRED CABIN FRAME STA 360 L/T PER ECRA 5311-01488 AND GENERATED DIP PER PER ECRA 5311-01488 STEP 11 ON N/R LOG PAGE 9716560, SEQ N00714 STEP 12 ON N/R LOG PAGE 9716559, SEQ N00715 ATSDR ASAA1047957Frame · corrodedAFT CARGO PIT FRAME CORRODED. REMOVED DAMAGE AREA INSTALLED REPAIR.SDR SWAA102449Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA102400Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102399Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102398Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102397Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102396Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102395Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102394Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102393Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA102361Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA102360Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102359Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102357Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR FDEA201004291400Frame · damagedBS 395 FRAME, BETWEEN S1/ 2L, HAS MULTIPLE HOLES THAT ARE NOT WITHIN PITCH LIMITS.SDR FDEA201004291399Frame · damagedBS 1100, FRAME, S3R/ 4R, HAS MULTIPLE HOLES THAT ARE NOT WITHIN PITCH LIMITS.SDR FDEA201004291398Frame · damagedBS 1120 FRAME, BETWEEN S3R/ 4R, HAS MULTIPLE HOLES THAT ARE NOT WITHIN PITCH LIMITS.SDR CALA2010042900176Frame · crackedSUPPORT TASK - FRAME WEB OVAL HOLE CRACKED .5 INCH LONG AT STA BS 303.9 AND STRINGER S16L AREA. TRIMMED OUT CRACKED SECTION OF FRAME & SPLICED IN NEW SECTION PER EA5310-04659 OP 2.SDR AALA20100428AFW02Failsafe · corrodedSTATION 614 BOTTOM SIDE OF FAIL SAFE STRAP CORRODED. ACCOMPLISHED REPAIR PER EA B767-53-010004.SDR AALA20100428TUL01Frame · bentFRAME SEGMENT AT STATION 1220 LOWER LEG WAS BENT DURING FASTNER REMOVAL. REMOVED DAMAGED FRAME SEGMENT AND INSTALLED SERVICEABLE FRAME SEGMENT PER SRM 53-30-05, SRM 51-10-03 AND EA MD80-51-010298 REV C.SDR ASAA1047959Frame · gougedCABIN FRAME GOUGED. REMOVED DAMAGE AREA, INSTALLED REPAIR.SDR ASAA1047958Frame · gougedCABIN FRAME GOUGED. REMOVED DAMAGE AREA, INSTALLED REPAIR.SDR ASAA1047948Frame · chafedFRAME AT STA 559 IS CHAFED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR AALA20100427TUL05Frame · corrodedFRAME STATION 951 CORRODED BEYOND LIMITS. REPAIRED WITH A DOUBLER REPAIR.
Back to JASC 5311