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 FDEA201211204100Frame · gougedFWD EQUIPMENT BAY FRAME BS 231 HAS SEVERAL GOUGES AT BL 0 TOP AFT SIDE OF FRAME. REPAIR CARRIED OUT IAW EA: F-5310-162910. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.SDR USAA2013011500008Failsafe · crackedC4 CHECK - CRACK ON RIGHT FUSELAGE FAIL SAFE STRAP AT BS 959, RBL 92. REPAIRED RIGHT FUSELAGE FAIL SAFE STRAP AT BS 959, RBL 92 IAW EA 131979.SDR USAA2013011500007Failsafe · crackedC4 CHECK - CRACK ON LEFT FUSELAGE FAIL SAFE STRAP AT BS 959, LBL92. REPAIRED LEFT FUSELAGE FAIL SAFE STRAP AT BS 959, LBL92 IAW EA 131979.SDR ASOA2012121802669Frame · corrodedFRAME BS 310 CORRODED AT STRINGER 27 FWD & AFT SIDES. BLENDED CORRODED AREA IAW SRM 51-42-06. BLENDED CORRODED AREA IAW SRM 51-21-06-001-001-A01. COMPLIED WITH REO 670-53-21-907.SDR ASOA2012121802666Frame · corrodedFRAME BS 295 CORRODED BETWEEN STGR 26R AND STGR26L. BLENDED FRAME IAW SRM 51-21-06-001-001-A01. COMPLIED WITH REO 670-53-21-908.SDR SWAA2012121310610Frame · crackedLEFT COCKPIT FRAME WEB AT BS 235-8 WL232 IS CRACKED. REPAIRED COCKPIT LEFT FRAME BS 235.8 WL 232 IAW ER 12-03592 AND EA 1-753-21218 FACT AS A RESULT OF POST REPAIR INSPECTIONSDR UALA2012111906651Frame · corrodedAFT PIT FRAME HAS CORROSION BS 1500, STR 30 AND STR 29L. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION ON FAIL SAFE AND FOUND MATERIAL REMAINING AFTER BLEND-OUT TO BE .071" FROM AN ORIGINAL .080". REMOVED FAIL SAFE CHORD, SPLICED IN REPAIR WITH 2 NEWLY FABRSDR SWAA2012121010394Frame · crackedCRACK ON FRAME AT BS 482 BETWEEN STR 20R TO 21R. REPAIRED FRAME IAW SRM.SDR SWAA2012121010393Frame · crackedCRACK ON FRAME HOLE AT BS 482B BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR DALA1255173606Frame · damagedDAMAGE TO FRAME AT BS 259 AT STR 21R. REPAIRED IAW ERA 509098-14, RE ORIG LP 544971019.SDR DALA12013439008Frame · crackedBS 1510, FRAME IS CRACKED AT TAIL CONE SPADE ATTACH POINT HOLE THREE O`CLOCK POSITION. CRACKED AFT FUSELAGE. REMOVED RT LOWER FRAME. DRILLED NEW FRAME. INSTALLED FRAME AND FRAME SPLICES IAW DWG 9911843.SDR FDEA201211184069Frame · damagedMAIN DEC CARGO FR 28 S8-20 LT FRAME DAMAGED, BLEND OUT THE DAMAGE IAW SRM 51-73-10, COMPLIED WITH EA 6-5310-163149.SDR ASOA20121117132Frame · crackedDURING C-CHECK, FRAME 10 CRACKED UNDER RT DV WINDOW CUTOUT. VERIFIED WITH EDDY CURRENT. MX R & R FRAME 10 IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013010711201Frame · crackedCRACK STUB FRAME AT BS 294.5 STR 7R GALLEY DOOR. REPLACED FRAME IAW SRM AND DWG.SDR ASAA2012111793445Frame · dentedFWD CARGO BAY LT SIDEWALL FRAME DENTED BS 480, STR 24L -STR 25L. ACFT GROUNDED. PERFORMED DAMAGE REMOVAL AND INSPECTION IAW REO G15718, REV IR. FABRICATED REPAIR PARTS IAW REO G15718, REV IR. R & R 5-24L & S25L STRINGER TIES IAW REO G15718 REV IR. INSTALLED SDR QXEA2012111701391Frame · corrodedFRAME BS 281, FLANGE AND WEB IS CORRODED STRINGER 29-33P. REMOVED RIVETS AND CORROSION AND COMPLIED WITH REPAIR IAW RD 8/4-53-2344 AND NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1.SDR QXEA2012111701399Frame · corrodedFRAME 301, FLANGES AND WEB ARE CORRODED, STRINGER 32P-27P. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. VERIFIED BLEND AREAS IAW NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. NOMINAL FRAME THICKNESS .040". NO MATERIAL LOSS TO FRAME WEB. FLASDR QXEA2012111701398Frame · corrodedFRAME BS 301 CORRODED STRINGER 32S-31S. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. VERIFIED BLENDED AREA IS CRACK FREE REF NTM 51-00-06-910-801 PT 1 AND 51-00-04-910-801 PT 1. FOUND TO BE WITHIN LIMITS PER RD 8/4-53-2344. ALODINED, PRIMED, INSTALLED FASSDR QXEA2012111701397Frame · corrodedFRAME BS 683.45 CORRODED STRINGER 33-31S. REMOVED FASTENERS AND CORROSION FROM FLANGES IAW RD 8/4-53-2344. VERIFIED FLANGES TO BE CRACK FREE USING HFEC REF NDTM 51-00-01-250-801. MIN REMAINING THICKNESS .037 REF NDTM 51-00-01-250-801 PT 4. FOUND IN LIMITS IAWSDR QXEA2012111701395Frame · corrodedFRAME BS 136, FLANGE IS CORRODED STRINGER 28 - 30P. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1. FOUND FLANGES WITHIN LIMITS IAW RD 8/4-53-2344.SDR QXEA2012111701393Frame · corrodedFRAME BS 196, FLANGE IS CORRODED STRINGER 31S -30S. REMOVED CORROSION IAW RD 8/4-53-2344. VERIFIED BLENDS CRACK FREE IAW NTM 51-00-04-910-801 PT 1 AND 51-00-01-250-801. FLANGE FOUND IN LIMITS IAW RD 8/4-53-2344.SDR QXEA2012111701392Frame · corrodedFRAME BS 281, FLANGE IS CORRODED STRINGER 27P-28P. REMOVED CORROSION IAW RD 8/4-53-2344. VERIFIED BLENDS CRACK FREE PER NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. FLANGES FOUND TO BE WITHIN LIMITS PER RD 8/4-53-2344.SDR QXEA2012111701390Frame · corrodedFRAME BS 281, FLANGE IS CORRODED STRINGER 33-30S. REMOVED CORROSION IAW 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. FLANGES FOUND TO BE IN LIMITS IAW RD 8/4-53-2344.SDR SWAA2012112109695Frame · crackedAFT CARGO BIN INTERIOR FRAME LEGS BETWEEN STR 27R & 27L AT STA 787 ARE CRACKED. REPAIR PER SRM 53-00-07-2R-7.SDR DALA1254943711Frame · damagedDURING INSPECTION FOUND FRAME BS 882 BETWEEN STR 24 AND 25L DAMAGED. MX REPAIRED DAMAGE IAW ERA 508826-14, REV ORIG.SDR DALA1254933711Frame · damagedDURING INSPECTION FOUND FRAME 857 BETWEEN STRINGER 25 AND 26L DAMAGED. MX REPAIRED DAMAGE IAW ERA 508826-14, REV ORIG.SDR ASOA20121117131Frame · crackedDURING C-CHECK, FRAME 10 CRACKED UNDER LT DV WINDOW CUTOUT. VERIFIED WITH EDDY CURRENT. MX R & R FRAME 10 UNDER LT DV WINDOW IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20121117130Frame · bentDURING C-CHECK, FRAME 72 BENT AT STRINGER 15L-16L. MX R & R FRAME 72, BETWEEN 16L AND 13R IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20121117129Frame Splice · crackedDURING C-CHECK, FRAME 72 SPLICE CRACKED AT STRINGER 15L-16L. MX R & R FRAME 72 SPLICE AT FRAME 72, STRINGER 15L AND 16L IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20121117128Frame · crackedDURING C-CHECK,K FRAME 72 CRACKED AT RIVET ON STRINGER 16L. MX R & R FRAME 72 BETWEEN STRINGER 16L AND 13R IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA1703586816Frame · dentedBS 231.25 FRAME AT BL 0 DENTED.SDR ASOA2012120502601Frame · corrodedRT FRAME INBD DOUBLER AT FS 473.15 HAS CORROSION LOCATED JUST BELOW LAST ROW OF RIVETS. REMOVED CORROSION IAW SRM 51-21-06. COMPLIED WITH REO 601R-53-41-1641.SDR SWIA201232263Frame · crackedFRAME AT FS 328.5, STRINGER 1L ABOVE PASSENGER DOOR CUTOUT HAS CRACK. (C-CHECK) REPAIRED FRAME AT FS 328.5 STRINGER 1LT ABOVE PAX DOOR CUTOUT IAW EA.SDR SWAA2012113010052Frame · corrodedCRACK HOLE SHEAR TIE FRAME AT BS 727D STR 27L CARGO COMPARTMENT. REPAIRED FRAME IAW SRM AND DWG.SDR WRLA20121116560Frame · crackedCRACK - DURING C04 CHECK, EGAT MECHANIC FOUND CRACKS ON FRAME (P/N: AGA7098-3) AND CAP (AGA7098-7) AT STA Y=1841.SDR QXEA2012111601403Frame · corrodedFRAME -18.25 HAS CORROSION ON THE UPPER FLANGE AT STRINGER 30P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .040", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. DAMAGE IS TO SURFACE PROSDR HNAA2012111601060Frame · corrodedFRAME CORRODED AND CRACKED. DOUBLER IS ALSO LIFTED. R & R FRAME SECTION AT BS 202 IAW EA 16-2012-013 AND DWG 85320004 AND EA 16-2012-014.SDR V0XR201211180153Frame · corrodedCORROSION FOUND ON FS 319.7 FRAME AT STGR 27. BLENDED FS319.7, FRAME 0.010" DEEP. ALODINED, PRIMED, TOP COATED AND APPLIED CORROSION INHIBITING COMPOUND IAW REO 670-53-21-902. NDT PERFORMED. NO DEFECTS FOUND.SDR V0XR201211180152Frame · corrodedCORROSION FOUND ON FS 349 FRAME BETWEEN STGR 27 AND 26R. BLENDED FS349 FRAME 0.015" DEEP. ALODINED, PRIMED, TOP COATED AND APPLIED CORROSION INHIBITING COMPOUND IAW REO 670-53-21-902. NDT PERFORMED. NO DEFECTS FOUND.SDR V0XR201211180151Frame · corrodedCORROSION FOUND ON FS 310 FRAME AT STGR 27. BLENDED (2) SPOTS ON FS 310 FRAME. SPOT 1 TO .007" DEEP AND SPOT 2 TO .010" DEEP. ALODINED, PRIMED, TOP COATED AND APPLIED CORROSION INHIBITING COMPOUND IAW REO 670-53-21-902. NDT PERFORMED. NO DEFECTS FOUND.SDR V0XR201211180149Frame · corrodedCORROSION FOUND ON FS 333 FRAME AT S27. BLENDED FS FRAME 333, 0.020 DEEP. ALODINED, PRIMED,TOP COATED AND APPLIED CORROSION INHIBITING COMPOUND IAW REO 670-53-21-902. NDT PERFORMED. NO DEFECTS FOUND.SDR HNAA2012111601058Frame · crackedFRAME CRACK IN CORNER NEAR RIVET HEAD AT BS 222 AND S31S CABIN UNDERFLOOR. REPAIRED FRAME LEG IAW SRM 53-20-21.SDR HNAA2012111601056Frame · crackedFRAME CRACKED AT LT SIDEWALL AT BS 545, AFT OF SEAT ROW 9, FORWARD OF BAG BAY DOOR TRACK. REMOVED FRAME MEMBER AND FABRICATED NEW ONE IAW DWG NR 85331201. HEAT TREATED, PERFORMED CONDUCTIVITY TEST ON FABRACATED PART. INSTALLED FRAME MEMBER AS REQUIRED.SDR CHQA20121115442Frame · damagedDURING HEAVY MAINTENANCE A PERMANENT REPAIR OF A LIGHTNING BURN AT FRAME 13 ON STRINGER 19L WAS COMPLETED IN ACCORDANCE WITH ETD2012-145-007033.SDR FDEA201211154033Frame · misrepairedFRAME MISREPAIRED AT CABIN LT BS 535, 9G NET LOWER SUPPORT YOKE AT LONGERON 24 LT. CARRIED OUT REPAIR IAW SRM 53-20-07, FIG 201, REPAIR 1, REV 51. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REV 115.SDR FDEA201211154032Frame · misrepairedFRAME MISREPAIRED AT CABIN LT BS 535, 9G NET UPPER SUPPORT YOKE AT LONGERON 18 LT. REPAIRED IAW SRM 53-20-07, FIG 202, REPAIR 1, REV 51. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REV 115.SDR SWAA2012121010447Frame · corrodedCORROSION FACE OF FRAME IN THE CARGO COMPARTMENT AT BS 787 BETWEEN STR 26R AND 27R. REPAIRED FRAME IAW SRM.SDR UALA2012111606616Failsafe · corrodedAFT BS 1480 FRAME FAILSAFE BETWEEN S25-27R CORRODED. FABRICATED & INSTALLED REPAIR ANGLE IAW ECRA 5360-01233. MAJOR REPAIRSDR SPUY20121115048Frame · corrodedDURING ROUTINE C-CHECK INSPECTION, AFT BULK CARGO COMPARTMENT FRAME SHOWS CORROSION BS 1562 S38L TO 38R REF NR-0083.SDR DALA1703576816Frame · dentedBS 540 FRAME BETWEEN STRINGERS 24L AND 25L DENTED.
Back to JASC 5311