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 UALA2012120407044Frame · crackedBS 580 LOWER LOBE FRAME UPPER CAP AT LBL 24.5 CRACK. PERFORMED REPAIR PER ECRA 5320-02114SDR SWAA2012120710303Frame · crackedNOSE LANDING GEAR WHEEL WELL CUTOUT AT STA 106 RBL - 6, FRAME IS CRACKED. REMOVED AND REPLACED NLG WHEEL WELL CUTOUT FRAME AT STA 106, RBL 17 TO LBL 17 IAW B717 SRM 51-41-02, 51-40-08 AND MD DWG 5913421.SDR QXEA2012120401570Frame · corrodedFRAME 94.8, FOWARD SIDE IS CORRODED ON THE OTBD SIDE OF STRINGER 31P. REMOVED CORROSION IAW SRM 51-42-05-02-01. MIN REMAINING THICKNESS .031", CONFIRMED AFFECTED AREA CRACK FREE, REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. DAMAGE IS WITHIN LIMITS SDR SIMA20121204001Frame · crackedDURING HEAVY CHECK INSPECTION FOUND THE RIGHT FRAME 72 CRACKED AT FLOOR LEVEL STRINGER 13. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED DAMAGED AERA AND PERFORMED REPAIR IAW EMB SRM 53-00-04. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CALA2012120400845Frame · crackedA CRACK INDICATION NOTED AT FRAME BS 520 BETWEEN STR 8 AND 9R DURING MFEC INSPECTION. FRAME REPAIRED IAW EA 5310-04716 REV D OP 1.SDR CALA2012120400844Frame · crackedA CRACK INDICATION NOTED AT FRAME BS 400 BETWEEN STR 8 AND 9R. DURING MFEC INSPECTION. FRAME REPAIRED IAW EA 5310-04716, REV D OP 1.SDR QXEA2012120301560Doubler · corrodedFRAME 136 FLANGE DOUBLER IS CORRODED OTBD OF STRINGER 31P. REMOVED DOUBLER IAW SRM 51-42-05-02-01. INSPECTED WITH HFEC, NO CRACKS NOTED REF NDTM PT 6 TASK 51-00-01-250-801. MIN REMAINING THICKNESS .037" REF NDTM PT 1 TASK 51-00-04-910-801. REMOVED FLANGE IAWSDR QXEA2012120301558Frame · corrodedFRAME AT STATION 32.400 HAS CORRODED BOLT HOLES ABOVE STRINGER 25P. CLEANED IAW SRM 51-26-00-02-01, NO CORROSION NOTED IN INBD BOLT HOLE. INBD HOLE REMAINS NOMINAL SIZE, OTBD BOLT HOLE REAMED TO .297 IAW SRM 51-40-07-02-01 TO REMOVE CORROSION. VERIFIED BOLSDR QXEA2012120301556Doubler · corrodedFRAME 196, FLANGE DOUBLER IS CORRODED OTBD OF STRINGER 31P. REMOVED CORRODED DOUBLER AND 3 RIVETS FROM FRAME IAW SRM 51-42-05-02-01. FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344 WITH 100 PERCENT MATERIAL LOSS. REMOVED FRAME FLANGE IAW RD 8/4-53-017. CONFIRSDR DALA12015830957Frame · crackedLEFT OVERWING FRAME AT BS 864, CRACKED, HFEC VERIFIED. BLENDED FRAME TO LIMITS IAW AMDS CARD 5310-01415-0201. REMOVED FRAME DRILLED NEW FRAME, INSTALLED IAW AMDS 5310-01415-301 POS 11.SDR QXEA2012120301545Frame · corrodedFRAME 624.5, FLANGE IS CORRODED, STRINGER 32P-31P. BLENDED CORROSION ON FRAME IAW SRM 51-21-00-00-02. MIN NOTED THICKNESS .057" REF NTM 51-00-04-910-801 CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801, PT 1. NOMINAL THICKNESS IS .050" FRAME FLANGSDR QXEA2012120301543Frame · corrodedFRAME 624.5, FLANGE IS CORRODED, STRINGER 32S-31S. BLENDED OUT CORROSION ON FRAME IAW SRM 51-21-00-00-02 MIN NOTED THICKNESS .054" REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. NOMINAL THICKNESS OF FRAME ISSDR SWAA2012121010426Fitting · crackedAFT CARGO PIT FRAME CLIP AT STA 807 RBL 20 IS CRACKED. REPLACED AFT CARGO PIT FRAME CLIP AT STA 807 RBL 20 WITH NEW CLIP IAW SRM 51-40-02 CIC'D CLIP IAW SRM 51-20-01 & DWG 65-47957 REV B.SDR QXEA2012120301542Frame · corrodedFRAME 19.4, FLANGE IS CORRODED STRINGER 33S-32S. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .038" CONFIRMED BLENDED AREAS CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. FOUND FLANGE TO SDR QXEA2012120301541Frame · corrodedFRAME 449.5, FLANGES ARE CORRODED STRINGER 31P-33. REMOVED RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. MIN NOTED THICKNESS .063" CONFIRMED BLENDED AREAS CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PSDR QXEA2012120301540Frame · corrodedFRAME 281, FLANGE IS CORRODED, STRINGER 31P-32P. REMOVED RIVET FOM IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .044" REF NTM 51-00-04-910-801 PT 1. VERIFIED BLENDS CRACK FREE IAW NTM 51-00-06-910-801 PT 1. MATERIAL LSDR QXEA2012120301538Frame · corrodedFRAME -18.25, FLANGE IS CORRODED STRINGER 31S-30S. REMOVED NECESSARY RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .045" REF NTM 51-00-04-910-801 PT 1. VERIFIED BLENDS CRACK FREE IAW NTM 51-00-06-910-801 PT 1. FLANGE FOUND IN LIMITS IAW RD SDR QXEA2012120301554Frame · corrodedFRAME 644.5, FLANGES ARE CORRODED STRINGER 31P-33. REMOVED RIVET FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MIN THICKNESS .056", CONFIRMED BLENDED AREAS CRACK FREE REF NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. FLANGES FOUSDR QXEA2012120301553Frame · corrodedFRAME 1, FLANGES ARE CORRODED STRINGER 32P-29P. REMOVED RIVET FOM. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREAS CRACK FREE REF NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. NOMINAL THICKNESS .050". FLANGES FOUND TO BE IN LIMITS IAW RD 8SDR AALA20121203020Frame · damagedAFT CARGO STATION 1212 UPPER SIDE OF FRAME NUT PLATE ATTACH HOLE ELONGATED. INSTALLED REPAIR DOUBLER PER EA MD80-53-027356.SDR FDEA201212034233Frame · chafedBS 418.00 FRAME HAS DEEP CHAFE, BETWEEN S20-21R. ACCOMPLISHED EA F-5310-162460. REMOVED CHAFE. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101. MAJOR REPAIR.SDR CALA2012120400843Frame · crackedA CRACK INICATION NOTED AT FRAME BS 380 BETWEEN S8-9R. DURING MFEC INSPECTION. REPAIRED IAW EA5310-04716 OP1 REV C.SDR CALA2012120400842Frame · crackedA CRACK INDICATION NOTED AT FRAME BS 500A RT BETWEEN S8 - 9R DURING MFEC INSPECTION. REPAIRED IAW EA 5310-04716, REV D OP 1.SDR CALA2012120400841Frame · crackedA CRACK INICATION NOTED AT FRAME BS 400 BETWEEN S8 AND 9L DURING MFEC INSPECTION. INSTALLED REPAIR IAW EA 5310-04716.SDR SIMA20121203001Frame · crackedDURING MAINTENANCE INSPECTION FOUND THE RIGHT FRAME 23 CRACKED AT FLOOR LEVEL. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE RIGHT FRAME 23 AT FLOOR LEVEL IAW EMB SRM 51-20-03 AND AE EM-53MR-1681. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR ASOA20121203140Frame · chafedDURING C-CHECK FRAME 60 CHAFED STRINGER 4L-5L. MX PERFORMED REPAIR OF FRAME 60 STRINGER 4L-5L IAW EC5320-01728. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20121203139VFrame · crackedDURING C-CHECK CRACK AT FRAME 10 JUST BELOW RT DV WINDOW (STRINGER 9). MX R & R FRAME 10 UNDER RT DV WINDOW AT STRINGER 9R IAW SRM 51-40-02. ALODINED, PRIMED, AND PAINTED IAW CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20121203138VFrame · crackedDURING C-CHECK CRACK AT FRAME 10 JUST BELOW LT DV WINDOW (STRINGER 9). MX R & R FRAME 10 LT UNDER DV WINDOW IAW SRM 51-40-02. ALODINED, PRIMED AND PAINTED IAW CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR QXEA2012120201537Frame · corrodedFRAME 236 FLANGES ARE CORRODED, STRINGER 31P-32P. REMOVED RIVET FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02 AND RD 8/4-53-2344. MIN REMAINING THICKNESS .046" REF NTM 51-00-04-910-801 PT 1. VERIFIED BLENDS CRACK FREE IAW NTM 51-00-06-91SDR QXEA2012120201536Frame · corrodedFRAME 32.4 FLANGES ARE CORRODED, STRINGER 32P-29P. REMOVED RIVET FO IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039" REF NTM 51-00-04-910-801 PT 1. VERIFIED BLENDS CRACK FREE IAW NTM 51-00-06-910-801 PT 1. MATERIAL LSDR QXEA2012120201466Frame · corrodedFRAME BS 604.5, FLANGES ARE CORRODED STRINGERS 32-30P. BLENDED CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .054 REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. FOUND IN LIMITS IAW RD 8/4-53-2344. ALODINESDR QXEA2012120201534Frame · corrodedFRAME BS 19.4, FLANGE IS CORRODED STRINGER 33-32S. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. HFEC INSPECTED BLEND, NO CRACKS NOTED REF NDTM PART 6 TASK 51-00-01-250-801. MIN REMAINING THICKNESS .037" REF NDTM PART 1 TASK 51-00-04SDR QXEA2012120301529Frame · corrodedFRAME BS 116, FLANGES AND WEB ARE CORRODED STRINGER 29-32P. REMOVED RIVETS AND CORROSION IAW SRM 51-40-07-02-01, 51-21-00-00-02 AND RD 8/4-53-2344. VERIFIED BLENDS CRACK FREE IAW NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. ALODINED, PRIMED AND ISDR QXEA2012120201528Frame · corrodedFRAME BS 216 FLANGE IS CORRODED STRINGER 29-30P. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. VERIFIED BLENDS CRACK FREE AND MEASURED MIN REMAINING THICKNESS AS 0.039 IAW NTM 51-00-06-910-801 PT 1 AND 51-00-04-910-801 PT 1. FLANGES FOUND IN LIMITS IAW RDSDR CALA2012120400840Frame · crackedA CRACK INDICATION NOTED AT FRAME BS 480 BETWEEN S8 AND 9R DURING MFEC INSPECTION. REMOVED DAMAGE. FABRICATED AND INSTALLED FRAME REPAIR IAW EA 5310-04716, REV D, OP 1.SDR CALA2012120400839Frame · crackedCRACK INDICATION NOTED AT FRAME STA 867 BETWEEN S8 AND 9R DURING MFEC INSPECTION. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLES REF 5310-04716, REV D OP 1.SDR CALA2012120400835Frame · crackedAD 2009-01-02 CRACK INDICATION NOTED AT FRAME STA 727B BETWEEN STRINGER 8-9L DURING MFEC INSPECTION. REMOVED DAMAGE IAW EA. FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5310-04716, REV D.SDR CALA2012120400838Frame · crackedCRACK INDICATION NOTED AT FRAME BS 500C BETWEEN STRINGER S8-9L DURING MFEC INSPECTION. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5 310-04716, REV D, OP1.SDR CALA2012120400837Frame · crackedCRACK INDICATION NOTED AT FRAME BS 727D RT BETWEEN S8-9R DURING MFEC INSPECTION. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLES IAW EC/R A 5310-04716, REV D, OP1.SDR CALA2012120400836Frame · crackedCRACK INDICATION NOTED AT FRAME BS 480 BETWEEN STRINGER S8-9L DURING MFEC INSPECTION. FRAME REPAIRED IAW EA 5310-04716, REV D, OP1 FIG 3.SDR QXEA2012120101520Frame · corrodedFRAME 388, FLANGES ARE CORRODED, STRINGER 33-31S. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344 AND 51-21-00-00-02. MIN REMAINING THICKNESS .063, CONFIRMED AFFECTED AREA CRACK FREE REF 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERISDR QXEA2012120501569Frame · corrodedFRAME -18.25, FLANGES ARE CORRODED, STRINGER 31P-29P. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .040", CONFIRMED AFFECTED AREA CRACK FREE, REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. DAMAGE ISSDR QXEA2012120101484Frame · corrodedFRAME 341 FLANGE IS CORRODED, STRINGER 32S-31S. REMOVED FASTENER FOM IAW SRM 51-42-05-02-01. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .053" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. NOSDR QXEA2012120101483Frame · corrodedFRAME 321, FLANGE IS CORRODED STRINGER 32S-31S. REMOVED FASTENER FOM IAW SRM 51-42-05-02-01 AND BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .057" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1SDR QXEA2012120101482Frame · corrodedFRAME 321, FLANGE IS CORRODED STRINGER 32P-31P. REMOVED FASTENER FOM IAW SRM 51-42-05-02-01 AND BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .054" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. SDR QXEA2012120101481Frame · corrodedFRAME 301, FLANGE IS CORRODED STRINGER 32P-30P. REMOVED FASTENERS FOM IAW SRM 51-42-05-02-01 AND BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .047" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1SDR QXEA2012120101480Frame · corrodedFRAME 301, FLANGE IS CORRODED STRINGER 31S-32S. REMOVED FASTENER FOM IAW SRM 51-42-05-02-01 AND BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .046" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1.SDR QXEA2012120101477Frame · corrodedFRAME BS 156 IS CORRODED, STRINGERS 31-32S. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .044" NTM 51-00-04-910-801 PT 1 CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. NOMINAL FRAME THICKNESS IS .040" FLANGES FOUND IN LIMITSDR QXEA2012120101479Frame · corrodedFRAME 258.5, FLANGE IS CORRODED, STRINGER 31P-32P. REMOVED FASTENERS FOM IAW SR 51-42-05-02-01. BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .044" NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. NSDR QXEA2012120101478Frame · corrodedFRAME 216, FLANGE IS CORRODED STRINGER 33-29P. REMOVED FASTENERS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .043" NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. NOMINAL FRAME THICKNESS IS .040" FLAN
Back to JASC 5311