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 QXEA2011101701020Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X401.0 FLANGE HAS CORROSION BETWEEN STRINGERS 31S AND 33. BLENDED CORROSION IAW Q400 RD 8/4-53/2344. REMAINING THICKNESS .062" AND CRACK FREE. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101701019Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X401 FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED CORROSION IAW SRM 51-21-00-00-01. REMAINING THICKNESS 0.67" AND CRACK FREE. ALODINED PRIMED AND PAINTED AREA.SDR QXEA201110170108Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X388 FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED CORROSION IAW RD 51-00-02-250-80 AND 51-11-01-250-801. MATERIAL LOSS WITHIN LIMITS AND CRACK FREE. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101701017Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X449.500 FLANGE HAS CORROSION BETWEEN STRINGERS 31S AND 32S. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .069" CONFIRMED CRACK FREE. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101701016Frame · corrodedINTERIOR BELLY FUSELAGE FRAME X301, FLANGE HAS CORROSION BETWEEN STRINGERS 32S AND 33. BLENDED AREA IAW RD 8/4-53-2344. REMAINING MATERIAL 0.42" CONFIRMED CRACK FREE. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101701014Frame · corrodedINTERIOR BELLY FRAME X156 FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 33. REMOVED CORROSION AND BLENDED AREA IAW RD 8/4-53-2344. REMAINING THICKNESS 0.45" AND CRACK FREE. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101701013Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X136 HAS CORROSION BETWEEN STRINGERS 30S AND 33. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS 0.42" CRACK FREE. ALODINED PRIMED AND PAINTED.SDR QXEA2011101701012Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X136 FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS IS 0.43" NO CRACKS DETECTED. ALODINED PRIMED AND PAINTED AREA.SDR QXEA2011101701011Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X116 FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 33. REMOVED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS 0.45" CRACK FREE. PRIMED AND ALODINED AND PAINTED AREA.SDR AALA20111012TUL09Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER AT 1418 LONGERON 2 LEFT PER SRM 53-03-00.SDR FDEA201110124451Frame · corrodedAFT PIT FRAME IS CORRODED ON AFT SIDE BELOW FAIL SAFE CHORD AT BS 1166 BETWEEN S29R - S27R. REPLACED FRAME ASSY.SDR FDEA201110124433Frame · corrodedCORROSION ON STUB FRAME WEB AT BS 950E PLUSE 5 INCHES, BOTH FWD AND AFT OF FRAME BETWEEN STRINGER 29R AND 28R.SDR FDEA201110124426Frame Splice · gougedAFT LWR CARGO COMP FRAME SPLICE PLATE AFT SIDE HAS GOUGE MARK AT STA 1480, BETWEEN STRINGERS S24R AND S25R. DAMAGED FRAME SPLICE AT STA 1480, BETWEEN S-24R AND S-25R. R & R IAW SRM 51-40-02 REV 103. REPAIR IS CLASSIFIED AS MAJOR.SDR CALA2011101200659Frame · crackedSUPPORT TASK - PAX CABIN HAS CRACKED FRAME STA 727B BETWEEN STR 8R AND 9R. TRIMMED OUT CRACKED SECTION AND INSTALLED REPAIR DOUBLERS PER ECRA 5310-05414.SDR ASAA11410525Frame · crackedFS 360 FRAME CRACKED BELOW STR 8. REPAIRED IAW ASA EA AD20062609 400 53 124.SDR SWAA117034Frame · corrodedDURING SCHEDULED 2HC1 CHECK, FOUND FRAME CORRODED AT BS 967, LBL 2. REPAIRED FRAME PER SRM.SDR SWAA117019Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA116997Frame · crackedDURING SCHEDULED SPV CHECK, FOUND STUB BEAM FRAME CRACKED AT RT BS 616, BOTTOM FASTENER HOLE COMMON TO INNER CHORD. REMOVED AND REPLACED FRAME IAW EA.SDR IPXA1569673Frame · dentedINSPECTION TYPE:C-CK, AFT PIT, STA 1620 FRAME DENTED, LBL 27 BETWEEN STRINGERS 25L AND 26L. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R, REPAIR 5, DETAIL II I.SDR ASOA201101938Frame · corrodedFS 349.00 FRAME HAS CORROSION AT STR 25L TO 26R. FOUND OUT OF LIMITS IAW SRM 53-00-00. REMOVED AND REPLACED FRAME SECTION IAW SRM 51-42-006.SDR ASOA201101937Frame · corrodedFS 333.00 FRAME HAS CORROSION DAMAGE S25-26R. FRAME SECTION BADLY DAMAGED, OUT OF LIMITS IAW SRM 53-00-00. REMOVED FRAME SECTION IAW SRM 51-42-06. DRILLED & REAMED FRAME SECTION IAW SRM 51-40-11. INSTALLED SRM 51-42-21.SDR ASOA201101936Frame · corrodedFS 310.00 FRAME HAS CORROSION BETWEEN STRINGERS 26 LT & RT. REMOVED CORROSION IAW SRM 51-42-06. CORROSION IS OUT OF LIMITS IAW SRM 53-00-00. REMOVED AND REPLACED FRAME SECTION IAW SRM 51-42-06 & SRM 51-42-21.SDR ASOA201101925Frame · corrodedFS 319.70 FRAME CORRODED BETWEEN STR 26 AND 27 RT. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURE UT-3. MINIMUM MATERIAL REMAINING IS .048. BLENDED AREA FOUND TO BE WITHIN LIMITS IAW SRMSDR ASOA201101924Frame · corrodedFS 275 FRAME CORRODED AT S29R. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURE UT-3. MINIMUM MATERIAL REMAINING IS .048. BLENDED AREA FOUND TO BE WITHIN LIMITS IAW SRM 53-21-06-101-002-ASDR ASOA201101923Frame · corrodedFRAME CORRODED AT FS 319.70 AND BETWEEN STR 27 AND 26L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURE UT-3. MINIMUM MATERIAL REMAINING IS .046. BLENDED AREA FOUND TO BE WITHIN LIMITSSDR ASOA201101922Frame · corrodedFRAME CORRODED AT FS 310 AND ON BOTH SIDES OF STR 27. CORROSION REMOVED IAW SRM 51-21-06-001-001-A01. PERFORMED UT THICKNESS INSPECTION IAW MAC NDT PROCEDURE UT-3. MIN MATERIAL REMAINING IS .047. BLENDED AREA FOUND TO BE WITHIN LIMITS IAW SRM 53-21-06-101SDR SIMA201128504Frame · crackedDURING MAINTENANCE BASE VISIT FOUND FRAME 67 CRACKED JUST ABOVE STRINGER 16 LEFT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 67 AT STRINGER 16 LEFT IAW EMB SRM 53-00-04. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201128503Frame · damagedDURING MAINTENANCE BASE VISIT FOUND FRAME 65 TO HAVE AN EXTRA HOLE UNDER NUT PLATE AT 12 O'CLOCK POSITION. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 65 IAW EO EM-53MR-1877. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA116983Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW ER.SDR NOCA10211Frame · damagedSTA 1702 FRAME AND PLATFORM DAMAGED AFT OF SECTION 48 ENTERY DOOR - DAMAGED RIGHT AFT. REMOVED DAMAGED PLATFORM AND CUT OUT DAMAGE SECTION OF WEB DAMAGE ON UPPER CHORD CLASSIFIED AS GOUGE ON EDGE CLEANED DAMAGE PER SRM 53-00-07 ALLOWABLE DAMAGE, DRILLED UP NESDR FDEA201110084386Failsafe · corrodedFAILSAFE CORRODED AT BS 1166 BTWN S27-29L. REMOVED FAILSAFE IAW SRM 51-30-2. FABRICATED NEW FAILSAFE IAW SRM 53-10-2 FIG 5 AND 51-20-1. INSTALLED NEW FAILSAFE IAW SRM 51-30-2 AND DWG 65-16349 REV T.SDR AALA20111015TUL01Frame · crackedCRACK ON CANTED FRAME 1510. INSTALLED DOUBLER PER SRM 51-10-4.SDR SWAA116934Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 277, STR 16R. REMOVED AND REPLACED WEB IAW EA AND DWG.SDR COEA2011100702919Frame · corrodedDURING HEAVY CHECK FOUND LEVEL 2 CORROSION FRAME 13 AT LT CREASE BEAM. REPAIRED IAW SRM.SDR AALA20111007TUL06Frame · crackedTHE 1485 CANT FRAME CRACKED AT LOWER END OF STAIR RET ACTUATOR. INSTALLED DOUBLER AT 1485 CANT FRAME PER AARD 53-10-00-33.SDR IPXA11570117Frame · wornINSPECTION TYPE:C-CK, MAIN CARGO INTERIOR FUSELAGE AT BS 800, BETWEEN STRINGER 15R AND 16R, FRAME INNER CHORD IS WORN. REMOVED DAMAGE AND REPAIRED IAW EA 111391 EO B757-5310-44909-A. INSTALLED REPAIR ANGLE AND HEAT TREATED TO T6 CONDITION.SDR IPXA11570087Frame · gougedINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT BS 1340 STR 15R FRAME HAS GOUGE. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE IAW EA 111427 IR/ EO B757-5310-44913-A.SDR IPXA11570084Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO COMPARTMENT, FRAME DENTED, BS 1240 BETWEEN STRINGERS 26R AND 25R. REPAIRED FRAME IAW EA 111379IR AND EO B757-5310-44882-A.SDR SWAA116952Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 25L. REPAIRED FRAME IAW EO AND EA.SDR SWAA116950Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW EA.SDR IPXA11569619Frame · dentedINSPECTION TYPE:C-CK, INBD FLANGE OF STA 700, FRAME AT STR 23R AND 24R DENTED BEYOND SRM LIMITS. REPAIR IAW SRM 53-00-07-2R 5, DET 3.SDR SWAA116920Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 25R. REPAIRED FRAME IAW EA.SDR SWAA116919Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 20R. REPAIRED FRAME IAW EA.SDR SWAA116916Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947, STR 25R. REPAIRED FRAME IAW EO AND EA.SDR SWAA116913Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME IAW ER AND EA.SDR CHQA201100398Frame · corrodedDURING INSPECTION, MAINTENANCE FOUND CORROSION ON FRAME 65 BETWEEN STRINGERS 16L AND 17L. MAINTENANCE REPAIRED FRAME 65 BETWEEN STRINGERS 16L AND 17L IN ACCORDANCE WITH ETD 2011-145-10626 REVISION A. A HIGH FREQUENCY EDDY CURRENT INSPECTION WAS CARRIED OUT INSDR IPXA11570116Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO COMPARTMENT BS 1500 STR 26R FRAME DENTED. REMOVED DAMAGE, FABRICATED REPAIR ANGLE AND HEAT TREATED TO T6 CONDITION. INSTALLED FASTENERS COMMON TO STRINGER CLIP 26R AND STRINGER IAW EA 111381 EO B757-5310-44840-A.SDR IPXA11570088Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO FRAME AT BS 1280 S25L HAS DENT IN INBD FLANGE. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE IAW EA 111376 IR/ EO B757-5310-44910-A.SDR IPXA11570027Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO FRAME AT BS 1260 S25L HAS DENT IN INBD FLANGE. REMOVED DENT AND INSTALLED REPAIR IAW EA 111378 AND EO B757-5310-44846 -A.SDR IPXA11569969Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO COMPARTMENT STA 1540 S25L FRAME DENTED. REPAIRED AFT CARGO COMPARTMENT FRAME STA 1540 S25L IAW SRM 53-00-07-2 REPAIR 5, DETAIL 3.
Back to JASC 5311