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 SWAA118208Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND LT FRAME INNER CHORD CRACKED AT BS 616. REPAIRED FRAME IAW EA.SDR SWAA118203Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CHORD CORRODED AT BS 270, BETWEEN LBL 10 TO RBL 11. REPAIRED CHORD IAW SRM AND DWG.SDR SWAA118194Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND LT STUB BEAM FRAME CRACKED AT BS 616. REMOVED AND REPLACED FRAME IAW EA.SDR AALA20111127TUL01Frame · buckledACCIDENTAL IMPACT TO STATIONS 1720 TO 1743 STRINGERS 22 TO 23 LEFT. PERMANENT REPAIR ACCOMPLISHED PER EA B757-53-020221.SDR SWAA118160Failsafe · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO BAY FRAME FAIL SAFE ANGLE CORRODED AT BS 727E, BETWEEN STR 27L TO STR 27R. REPAIRED ANGLE IAW SRM.SDR SWAA118158Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118157Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 17R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118156Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 727, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118155Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW RM.SDR DALA1165011704Attach Fitting · crackedFS 927 RT AT STR 21R FRAME ATTACH FITTING CRACKED.SDR DALA1165001704Frame · crackedFS 903 LT AT STR 20L-21L FRAME INNER CHORD IS CRACKED.SDR DALA1164991704Frame · crackedFS 903 RT AT STR 20R-21R FRAME INNER CHORD IS CRACKED.SDR KCSA111282Frame · corrodedUPPER DECK BS 720 FWD SIDE OF FRAME FROM STR 7L TO 4R HAS AREAS OF LIGHT CORROSION.SDR NSVA2011307Frame · buckledBOTTOM FRAME IN AFT CARGO AT STA 702 IS BUCKLED NEAR UPPER FLANGE FROM RBL 19 TO LBL 5. REF SAAB STATEMENT 340SDS023421, TD340-53-11-83 AND MM409# 405698 FOR REPAIR DETAILS.SDR NSVA2011306Frame · buckledBOTTOM FRAME IN AFT CARGO AT STA 718 IS BUCKLED NEAR UPPER FLANGE FROM RBL 15.5 TO LBL 9.75. REF SAAB STATEMENT 340SDS023421, TD340-53-11-85 AND MM409# 405700 FOR REPAIR DETAILS.SDR NSVA2011305Frame · buckledBOTTOM FRAME IN AFT CARGO AT STA 710 IS BUCKLED NEAR UPPER FLANGE FROM RBL 3.5 TO LBL 28.5. REF SAAB STATEMENT 340SDS023421, TD340-53-11-84 AND MM409# 405699 FOR REPAIR DETAILS.SDR FDEA201111255043Frame · damagedAFTER THE REMOVAL OF REPAIR SPLICE AT RT FRAME 22 L8-9, FOUND UNDERLYING STRUCTURAL DAMAGE. DAMAGED FRAME REMOVED IAW SRM 51-40-21, REV 21. FABRICATED IAW DWG A5377169420300, ISSUE B AND INSTALLED IAW SRM 51-40-21, REV 21. REPAIR CLASSFIED MAJOR IAW GMM 6-2-SDR FDEA201111255042Frame · damagedAFTER THE REMOVAL OF REPAIR SPLICE AT FRAME 23 L8-9, FOUND UNDERLYING STRUCTURE DAMAGE. DAMAGED FRAME REMOVED IAW SRM 51-40-21, REV 21. FABRICATED IAW DWG A53770911200 ISSUE B AND INSTALLED IAW SRM 51-40-21, REV 21. REPAIR CLASSFIED MAJOR IAW GMM 6-2-100, RSDR NSVA2011304Frame · corrodedCORROSION FOUND AT FR294 CORRODED AREA AT RBL 13 TO 22 ON FRAME FACE AND UPPER FLANGE. CORROSION EXTENDS THROUGH FLANGE FACE IN ONE AREA. REPAIRED CORROSION DAMAGE IAW SAAB SDS 023421 DATED 2011-11-18, FOR DEATAILS SEE MM-409 FOR REMOVAL AND REPLACEMENT OF WSDR SWAA118149Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 312+10, STR 20L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201111255024Frame · damagedBS 377.7, S9-10R FRAME HAS A CUT MARK. DAMAGED FRAME REPAIRED IAW EA F-5310-157103. REPAIR CLASSIFIED AS MAJOR.SDR UALA2011112706504Frame · misrepairedBS 1265 LT FRAME INNER CHORD AND WEB HAS SHORT EDGE MARGIN 4 LOCATIONS. REPAIRED IAW 747EN- 53-0364.SDR DALA1164290950Frame · crackedSTA 1463 CANTED FRAME WEB ABOVE L9L FOUND CRACKED FROM FASTENER HOLE ON -53 WEB. REPAIRED PER ERA 498041-14.SDR NSVA2011300Repair · corrodedFOUND PREVIOUS REPAIR TO UPPER FLANGE OF BOTTOM FRAME AT STA 272 TO BE CORRODED AND INSTALLED INCORRECTLY. REF MM409#406777 AND TD 340-53-11-58.SDR NSVA201130Repair · corrodedFOUND PREVIOUS REPAIR TO UPPER FLANGE OF BOTTOM FRAME AT STA 272 TO BE CORRODED AND INSTALLED INCORRECTLY. REF MM409#406777 AND TD 340-53-11-58.SDR FDEA201111225049Frame · misrepairedFRAME STA 1600 BETWEEN S-21R TO S-23R MISREPAIRED. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR FDEA201111224998Frame · corrodedAFT PIT FRAME BS 1360 S26- 27R HAS CORROSION. REMOVED CORROSION IAW SRM 51-10-02. ORIG MATERIAL .063 REMAINING .043 FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101. DETAIL II ALLOWABLE DAMAGE 2. R & R FRAME STA 1360, BETWEEN S-24L TO S24R IAW SRM 51-40-02. SDR UALA2011112206423Frame · crackedBODY STATION 1180 LT TENSION TIE FRAME CRACKED AT 1 FASTENER HOLE. MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME SECTION.SDR UALA2011112206422Frame · crackedBODY STATION 1200 RT TENSION TIE FRAME CRACKED AT 2 FASTENER HOLES. MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME SECTION.SDR UALA2011112206421Frame · crackedBODY STATION 1160 RT TENSION TIE FRAME CRACKED AT 4 FASTENER HOLES. MAJOR REPAIR ACCOMPLISHED. REPLACED FRAME SECTION.SDR UALA2011112206420Frame · crackedBODY STATION 1265 FRAME WEB CRACKED AT FASTENER HOLE APPROX 6 INCHES ABOVE FLOORLINE AT DOORWAY 3L. MAJOR REPAIR ACCOMPLISHED. REPLACED BS 1265 LT FRAME INNER CHORD, WEB, AND INTERCOSTAL UPPER CHORD & WEB PER COA TASK CARD 897887102.SDR ASAA11410693Frame · crackedCRACKED FRAME STA 616 ABOVE STR 18R. REPAIRED FRAME IAW AD 20102506 400 53 12 AND ASA EA 400 53EA 06916.SDR CHQA201100457Fitting · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE FRAME 65 SHEAR FOOT AT THE CARGO DOOR SILL. MAINTENANCE REPAIRED THE FRAME 65 SHEAR CLIP FOOT IN ACCORDANCE WITH IC2010-145-10445 WITH NO FURTHER DEFECTS NOTED.SDR SWAA118082Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW SRM.SDR SWAA118076Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA118075Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 25R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA118074Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA118073Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA118033Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA118028Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA118027Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, WL 208. REPAIRED CHORD IAW EA.SDR SWAA118019Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT INNER CHORD FRAME CRACKED AT BS 639, BETWEEN STR 14L TO STR 15L. REPAIRED FRAME PER EA.SDR CHQA201100474Frame · crackedDURING INSPECTION, THE LEFT FRAME JUST BELOW THE COCKPIT WINDOW WAS FOUND TO BE CRACKED. THE LEFT FRAME JUST BELOW THE COCKPIT WINDOW WAS REPLACED. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR FOTR2011111815077Frame · corrodedCORROSION AFT CARGO PIT BILGE AREA LWR AND AFT SURFACE OF FRAME 1309 FROM LONGERON 29L TO 28R. REPAIRED ON FASI WO21186, NR 15077.SDR FOTR2011111815056Frame · corrodedCORROSION AND BARE METAL AFT CARGO PIT BILGE AREA ON LWR AFT SIDE OF FRAME STA 1250 BETWEEN LONGERON 28L AND 29R. REPAIRED ON FASI WO21186, NR15056.SDR AALA20111118TUL03Frame · corrodedFRAME AT STATION 1600 STRINGER 23 TO 25 LEFT CORRODED. ACCOMPLISHED NESTED ANGLES REPAIR PER SRM 53-00-07-2R-5 SHEET 8.SDR SWAA118106Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR FDEA201111174951Frame · misrepairedFRAME BS 1420 S24-26L MISREPAIRED. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1028.SDR CHQA201100471Frame · crackedDURING INSPECTION, A CRACK WAS FOUND ON FRAME 23 AT STRINGER 16R. MAINTENANCE REPAIRED FRAME 23 AT STRINGER 16R IN ACCORDANCE WITH ETD 2011-145-108247 AND SRM 53-00-04.SDR FDEA201111174969Frame · corrodedFRAME AT STA 1645 LOWER END HAS CORROSION AT W.L.210, INBD FLANGE RBL 55. REMOVED CORROSION IAW-SRM-51-10-02, ORIGINAL MATERIAL .063 AFTER REWORK .055, REMOVED .008 FOUND TO BE OUT OF LIMITS IAW SRM-53-00-07, PG 103, FIG 101, DETAIL II. REPAIR WAS ACCOMPLISHE
Back to JASC 5311