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 USAA2013020400007Frame · crackedQ6 CHECK - CRACKS ON FUSELAGE FRAME AT BS 847 BETWEEN S19R & S21R. REPLACED FUSELAGE FRAME AT BS 847 BETWEEN S19R & S21R IAW B737 SRM 51-40-02-0G, PAR 4, FIGS 3, 8 & 12.SDR USAA2013020400006Frame · corrodedQ6 CHECK - CORROSION ON FUSELAGE FRAME AT BS 794.3, S25R BETWEEN RBL 20 TO RBL 25. REPLACED FUSELAGE FRAME AT BS 794.3, S25R BETWEEN RBL 20 TO RBL 25 IAW B737 SRM 51-40-02-0G, PAR 4 & 7D, FIGS 3, 8 & 12.SDR SPUY201302020012Frame · corrodedDURING ROUTINE C-CHECK INSPECTION, CARGO COMPARTMENT. FRAME SHOWS CORROSION AT STA 1168 NEAR STRINGER S16R.SDR SWAA2013021412684Frame · crackedTHE FRAME AT THE SUPPORT BRACKET AT BS 747 STR 8L IS CRACKED. REPAIR OF FRAME AT BS 747 STR 8L WILL BE ACCOMPLISHED ON EA 1-A53-12114 R2.SDR QXEA2013020100253Frame · corrodedFRAME -18.25 FLANGES AND WEB ARE CORRODED STR 33-31S. REMOVED FRAME SPLICE IAW SRM 51-42-05-02-01. BLENDED CORROSION AT FRAME -18.25 IAW SRM 51-21-00-00-02. FOUND OUT OF LIMITS IAW SRM 53-20-15-00-01. CUT OUT FRAME FOR SPLICE REPAIR IAW RD 8/4-53-4575. CONFIRSDR SWAA2013020812470Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE FOR PSU RAIL SUPPORT BS 500A STR 8 - 9R. INSTALLED FRAME REPAIR AT BS 500A STR 8-9R IAW EA 1-A53-12114 REV 2.SDR SWAA2013020812469Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE FOR PSU RAIL SUPPORT BS 500C STR 8 - 9L. FRAME REPAIR AT BS 500C STR 8-9L WILL BE ACCOMPLISHED ON EA 1-53-12114 R2.SDR SWAA2013020812466Frame · crackedTHE FRAME AT THE SUPPORT BRACKET AT BS 727D STR 8L IS CRACKED. REPAIR OF FRAME AT BS 727D STR 8L WILL BE ACCOMPLISHED ON EA 1-A53-12114 R2.SDR SWAA2013020812465Frame · crackedTHE FRAME AT THE SUPPORT BRACKET AT BS 827 STR 8R IS CRACKED. REPAIRED CRACKED FRAME AT THE SUPPORT BRACKET BS 827 STR 8R PER EA 1-A53-12114R2SDR SWAA2013020812464Frame · crackedTHE FRAME AT THE SUPPORT BRACKET AT BS 400 STR 8R IS CRACKED. ACCOMPLISHED FRAME REPAIR AT BS400 STR 8R PER EA 1-A53-12114 R2.SDR SWAA2013020712392Frame · crackedTHE FRAME AT THE SUPPORT BRACKET AT BS 480 STR 8R IS CRACKED. PERFORMED FRAME REPAIR AT BS 480 STR 8R PER EA 1-A53-12114R2.SDR SWAA2013020712387Frame · crackedTHE FRAME AT THE SUPPORT BRACKET AT BS 787 STR 8R IS CRACKED. INSTALLED FRAME REPAIR AT BS 787 STR 8R IAW EA 1-A53-12114 REV 2.SDR WX0A071510Frame · gougedLIP UNDER LT AND RT LOWER SIDEWALL PANEL MOUNT SCREWS AT FRAME 522 HAVE SCREW GOUGES. REPLACED FUSELAGE FRAME AT STATION 522.SDR USAA2013040400009Frame · cracked3S CHECK - FUSELAGE FRAME CRACKED AT FR 68 AND S23R. PERFORMED TIME LIMITED REPAIR ON FR 68 RT AT LEVEL STOP FITTING 1 IN THE HOLE BOLT IAW EA 503840.SDR USAA2013040400008Frame · cracked3S CHECK. FUSELAGE FRAME CRACKED AT FR 66 AND S10R. PERFORMED TIME LIMITED REPAIR ON FR 66 RT AT LEVEL STOP FITTING 7 IN THE HOLE BOLT IAW EA 503840 FIG 7, 8, 9 AND 10.SDR USAA2013040300010Frame · cracked3S CHECK - CRACK ON FRAME AT FR66, S12R. REPAIRED FRAME AT FR66, S12R IAW EA 503840, PART "E" FIG 7.SDR FDEA201301310232Frame · misrepairedFRAME MISREPAIRED BS 535, LONGERON 24L. REPAIRED IAW SRM 53-20-07 FIG 201, REPAIR 1, REV 51. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 116.SDR FDEA201301310231Frame · misrepairedFRAME MISREPAIRED BS 535, LONGERON 18L, REPAIRED IAW SRM 53-20-07, FIG 202, REPAIR 1, REV 51. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 116.SDR SWAA2013021912820Frame · crackedLEFT FRAME HAS A CRACK IN RADIOS BELOW FLOOR LEVEL. REMOVED AND REPLACED FRAME AT LEFT FS 715. FRAME P/N SA 95530034-11 PO 2300928 IAW B717 SRM 51-41-05 & 51-41-02, 51-40-08.SDR QXEA2013013100216Frame · corrodedX547 FRAME FLANGES HAVE CORROSION BETWEEN STRINGERS 32P AND 31S. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02 MIN THICKNESS NOTED .045, CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1. MATSDR DALA13005711813Frame · corrodedFRAME STATION 1809.5, CORROSION UNDER BOTH APU INLET LOWER BRACKETS TO FRAME 1809.5. C/A REPAIRED IAW PRI 511090-14, REV 2, ON NR 201.SDR SCNA20130201036Frame · crackedPASSENGER CABIN LEFT SIDE STA 480 FRAME CRACKED AT PSU RAIL ATTACH POINT ABOVE STRINGER 8L. CUT & REMOVED DAMAGED PART OF FRAME AT STA 480 STR 8L.SDR SCNA20130201035Frame · crackedPASSENGER CABIN RIGHT SIDE STA 480 FRAME CRACKED AT PSU RAIL ATTACH POINT ABOVE STRINGER 8R. CUT & REMOVED DAMAGED PART OF FRAME.SDR DALA13005670986Frame · corrodedAFT CARGO BAY FRAME IS CORRODED BS 1271, STR 29L-29R. CORROSION WAS FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGED LOWER SECTION OF CORRODED FRAME AND INSTALLED REPAIR IAW SRM 53-03, FIG 2A. RII COMPLIED WITH.SDR FDEA201301310239Frame · crackedSTA 377.7 BETWEEN S-8R TO S-9R FRAME IS CRACKED AROUND RIVET HOLE IN WEB OF FRAME. NON-ROUTINE FOR TRACKING PURPOSES ONLY A FRAME REPAIR WAS ACCOMPLISHED AT STA 377.7 BETWEEN S-8R TO S-9R ON STAM NR 49016710001 AND STAM EA 757-5312-16-F4012. THIS N/R IS FORSDR UALA2013013100578Frame · crackedFRAME BS 827 CRACKED AT PSU RAIL ATTACHMENT FASTENER BETWEEN S8-9L. REMOVED DAMAGE AND ACCOMPLISHED NDT FOR CRACKS. FABRICATED AND INSTALLED NESTED ANGLE REPAIR DOUBLERS AND FILLER REF AMM 53-10-84 REPAIR NR 3.SDR UALA2013013100577Frame · crackedFRAME AT BS 440 CRACKED AT PSU RAIL ATTACHMENT FASTENER BETWEEN STR 8R-9R. REMOVED DAMAGE AND NDT FOR CRACKS. FABRICATED AND INSTALLED NESTED ANGLES REPAIR DOUBLERS AND FILLER REF AMM 53-10-84 REPAIR NR 3.SDR QXEA2013013000268Frame · corrodedFRAME 94.8, FLANGES AND WEB ARE CORRODED STR 33-31S. REMOVED FASTENERS COMMON TO SKIN FOM, BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN THICKNESS NOTED .036" REF NDTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NDTM 51-0SDR QXEA2013013000213Frame · corrodedFRAME 94.8 FLANGES AND WEB ARE CORRODED STR 33-29P. REMOVED FASTENERS COMMON TO SKIN AND STANCHION FOM BLENDED CORROSION IAW RD 8/4-53-2344, SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN THICKNESS NOTED .035" REF NDTM 51-00-04-910-801 PT 1, VERIFIED AFFECTED ARESDR WX0A071502Frame · crackedCANTED FRAME STATION 1474 CRACKED AT LONGERON 18L. VERIFIED STOP DRILL CRACK. FABRICATED DOUBLERS, LOCATED, DRILLED AND INSTALLED.SDR DALA1302443742Frame · crackedSIDEWALL FRAME CRACKED COMMON TO PSU RAIL SUPPORT ANGLE AT STA 727B S8R. REPAIRED IAW ERA 509154-14AD.SDR GLBA2013013000166Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK AT FS 107 AND STRINGER 8R, FRAME CRACK PROTRUDING OUT OF RIVET, .5 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-007.SDR GLBA2013013000165Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND TWO CRACKS AT FS 107 AND STRINGER 8L IN THE BEND RADIUS, CRACK PROTRUDING OUT OF RIVET, 1.25 INCHES IN LENGTH. REPAIRED IAW EO 13-1900-53-008.SDR GLBA2013013000164Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE FUSELAGE FRAME AT FS 456 AT THE GAS STRUT UPPER INBD NUTPLATE BETWEEN STRINGERS 3L AND 4L, .75" IN LENGTH. REPAIRED IAW EO 13-1900-53-002.SDR CALA2013020100076Frame · corrodedCORROSION ON UPPER SURFACE OF FRAME BS 967 APPROX LBL 40 INSTALLED STRAP REPAIR IAW ECRA 5321-01834.SDR A6WA0134660Frame · corrodedCORROSION ON FRAME 333 STR 26L TO 25R & AROUND GROUND LOCATIONS. REMOVED AND REPLACED FRAME SECTION (601R32004-55) IAW REO 601R-53-21-2400.SDR ASOA2013031103130Frame · corrodedCIRCUMFERENTIAL FRAME AT FS 280 BL 0 HAS CORROSION ON AFT WEB. RECEIVED AND COMPLIED WITH REO 670-53-11-789 P1 IAW NDTM PART 1, 51-20-006.SDR QXEA2013012800197Frame · corrodedFRAME BS 116 FLANGES ARE CORRODED STR 33-29S. REMOVED FASTENERS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD8/4-53-2344. MIN REMAINING THICKNESS NOTED .022" CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1. SDR QXEA2013012800196Frame · corrodedFRAME BS 116 FLANGES ARE CORRODED STR 29P-33. REMOVED FASTENERS FOM IAW RD 8/4-53-2344. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .033" CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. SDR QXEA2013012800194Frame · corrodedX341 FRAME FLANGES HAVE CORROSION BETWEEN STRINGERS 29P AND 32P. REMOVED FASTENERS AS NECESSARY AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .046" REF NTM 51-00-04-910-801 PT 1. CONFIRMED BLENDED AREAS CRACK FREE RSDR IPXA3B76912Frame · crackedINSPECTION TYPE: C03, DURING C03 CHECK OF DATUM ACFT, TWO INCHES LONG CRACK DAMAGE WAS FOUND ON THE FRAME AT BS 2696.18, WL 292. REPAIR IAW EO B747-5310-49695-A AND SR:1-2407977602.SDR SWAA2013013012119Frame · crackedEXTERNAL POWER DOOR FRAME CRACKED. REPAIRED PER EA 1-A53-9269.SDR R5KB2013012850568Frame · damagedFRAME DAMAGED AT STA 1130 BETWEEN STR 27 AND 28 RIGHT.SDR R5KB2013012846396Frame · corrodedFRAME AT STA 1148 CORRODED AT STR 26R.SDR ASOA20130128246Frame · corrodedACFT IS IN C-CHECK WHEN INSPECTION FOUND EVIDENCE OF CORROSION AROUND SCREW HOLES AT LOWER SERVICE DOOR AT FRAME 20 AND FRAME 22. MX CLEANED FR 20 AND WAS WITHIN LIMITS. FRAME 22 WAS CLEANED AND A DOUBLER WAS INSTALL IAW EC 5310--01373. ALL WORK ACCOMPLISHESDR SCNA20130130027Frame · bentAFT CARGO PIT FRAME AT 727I IS BENT AT 26R. REMOVED, REPAIRED, AND RE-INSTALLED AFT CARGO PIT FRAME AT STA 737I, 26R.SDR WX0A071499Frame · gougedRIGHT STATION 1510 CANT FRAME GOUGED AT LONGERON 9L. REMOVED DAMAGED AREA, HFEL. HFEL - NO DEFECTS NOTED. FABRICATED REPAIR ANGLE AND INSTALLED.SDR SCNA20130128015Frame · bentFORWARD CARGO PIT RIGHT SIDE FRAME AT 500D BENT FROM STR 26R TO 23R. REMOVED, RE-WORKED, AND RE-INSTALLED ANGLE BRACE AT FWD CARGO STA 500D STR 26R -23R.SDR SCNA20130128011Frame · bentAFT CARGO PIT FRAME BENT, STA 727I FROM 24L TO Z-ANGLE. REMOVED, RE-WORKED, & RE-INSTALLED LEFT SIDE ANGLE BRACE AT FS 727I.SDR DALA1302166703Frame · dentedFRAME IN AFT CARGO DENTED AT STA 1460 ABOVE STR 26L AT UPPER FLANGE. ACCOMPLISHED SRM 53-00-07, FIG 201, REPAIR 5.
Back to JASC 5311