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 DALA1121829878Attach Angle · corrodedAFT CARGO STATION 1167 BETWEEN L28L-L30 AFT SIDE OF FRAME ATTACH ANGLE HAS CORROSION. ATTACH ANGLE FOUND TO BE OUT OF LIMITS. REMOVED CORRODED ANGLE. NEW ATTACH ANGLE LOCATED DRILLED, TREATED, PRIMED AND INSTALLED. RESTORED ACCESS IAW DC9 SRM 51-30-2, 51-3SDR DALA1121819870Frame · damagedMAIN PAX CABIN/GALLEY HOLE IN EXISTING FRAME REPAIR BLOWN OUT AT STA 1151 AND L-17-L. REMOVED EXISTING REPAIR IAW SRM 51-30-2, 51-30-5. FABBED NEW REPAIR PLATE .063 7070-T6. FABBED REPAIR ANGLE & FILLER .050 7075-0. TREATED & PRIMED IAW DC-9 SRM 51-10-3. SDR CALA2011032400171Frame · crackedCABIN AREA FRAME AT RT STA 440 CRACK INDICATION NOTED, AROUND I/B FASTENER AND BETWEEN STRINGERS S8 TO S9. REPAIRED FRAME AT STA 440 IAW EA 5310-04716 REV B.SDR AALA20110323TUL03Frame · corrodedCARGO AFT CORROSION FRAME 1271 AFT SIDE LONGERON 29 RIGHT TO LONGERON 28 LEFT. INSTALL NEW "J" ANGLE PER AARD 53-10-00-14.SDR CALA2011032300164Frame · crackedSUPPORT TASK REF STEP 6 EA 5310-04716 REV B OP 2 STA 727B LEFT FRAME CRACKED AT A/C BRACKET BETWEEN STR 8L AND 9L. REPAIRED FRAME W/REF TO ECRA 5310-04716 REV B STEP 9.0 AND FIG 3.SDR C2XA11SH069Frame · corrodedSHV - DURING C-CHECK FRAME 65 HAS AREAS OF CORROSION. REPAIRED FRAME IAW EC5310-01505. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR HNAA2011042400097Frame · corrodedSMALL SPOT OF CORROSION UNDER LAV SERVICE DOOR ON AFT FRAME. REMOVED CORROSION AND RESTORED SURFACE PROTECTION IAW -8-300 SRM 51-20-11.SDR DALA1124489224Frame · corrodedHMV2 RT MLG CUTOUT FWD FRAME CORRODED. REPLACED FRAME PER SRM 51-30-02.SDR SWAA112186Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 22L TO STR 23L. REPAIRED FRAME PER EA.SDR SWAA112179Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 26R. REPAIRED FRAME PER EO.SDR AALA20110322TUL04Frame · crackedAFT ACCESSORY STATION 1510 CANT FRAME CRACKED LOWER RIGHT SIDE. INSTALLED DOUBLER SRM 53-01-00.SDR COEA2011032206903Frame · corrodedHEAVY CK COE / LEVEL 2 CORROSION / MAJOR REPAIR: RT FR 25 HAS A SMALL AREA OF CORROSION ON THE AFT SIDE AT FLOOR LEVEL (LENGTH: .4", WIDTH .4", DEPTH .040"). CORROSION DAMAGE ON FRAME 25 RT FLOOR LEVEL BLENDED AND MAPPED. REPAIRED PER STRUCTURAL REPAIR INSTSDR SWAA112081Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA112075Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 727D, LBL 2. REPAIRED FRAME PER ER.SDR SWAA112052Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA112002Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN LBL 0 TO LBL 13. REPAIRED FRAME SRM.SDR CALA2011032200161Frame · crackedSUPPORT TASK CABIN AREA FRAME AT RT STA 400 CRACK INDICATION NOTED AROUND INBOARD FASTENER AND STR 8R TO 9R. REPAIRED FRAME AT STA 400 PER EA 5310-04716 REV B.SDR CALA2011032200160Frame · crackedSUPPORT TASK: CABIN AREA FRAME AT STA 380 RT CRACK INDICATION NOTED AROUND I/B FASTENER AND BETWEEN S8 TO S9 RT . REPAIRED FRAME AT STA 380 RT PER EA 5310-04716.SDR AALA20120314023Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT STATION 440 R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120314022Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 480 R. ACCOMPLISHED NESTED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120312028Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 727B-R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0007.SDR DALA1125370689Frame · dentedAFT CARGO FRAME DENTED STA 1580 ABOVE STR 26R. ACCOMPLISHED ERA ON NRC 181034 ON SECTION REPAIR STA 1580 STR 26R IAW SRM 53-00-07 REP 5 PG 201 FIG 201 AT SAA ON HMV.SDR DALA1125360689Frame · dentedAFT CARGO FRAME DENTED ON RADIUS STA 1440 ABOVE OB SIDE OF STR 26L. ACCOMPLISHED ERA ON NRC 181145 PER B757 SRM 53-00-07 PG 201 FIG 201 REPAIR 5.SDR DALA1125350689Frame · dentedAFT CARGO FRAME DENTED STA 1400 ABOVE IB SIDE OF STR 26L. ACOMPLISHED ERA 53-00-07 REP 5 PG 201 FIG 201 AT SAA ON HMV.SDR DALA1125320689Frame · dentedAFT CARGO FRAME DENTED ON RADIUS STA 1420 ABOVE I/B SIDE OF STR 26L. ACCOMPLISHED ERA ON NRC 181143 AT SAA ON HMV.SDR V0XR20110321001Fitting · corroded(V0XR) FRAME FOOT AT FR 62 AND STR 19-185 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SHEAR CLIP AT FR 62 AND STR 19-185 IAW EMB145 SRM 51-10-02, 51-40-02, 51-20-03. W/C 1069SDR AALA20110321TUL09Frame · crackedAFT ACCS 1510 CANT FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH. REPAIRED 1510 CANT FRAME PER EA MD80-53-015821.SDR FDEA201103211098Frame · misrepairedREWORK SNRM N00219 - AFT CARGO COMPT EXISTING REPAIR FOUND ON LT FRAME AT STA 1440 S26L. THIS REPAIR IS NOT ALLOWED IAW SRM REQUIREMENTS ON SF ACFT. EXISTING REPAIR R & R CARRIED OUT IAW EA F-5310-135897 (BS 1440, S-26L - S-27L) EXISTING LOWER LOBE FRAME REPSDR DALA1121279870Frame Splice · corrodedAFT CARGO COMPARTMENT FRAME AT STA 1116 HAS CORROSION ON LOWER AFT FLANGE SPLICE ANGLE BETWEEN LONG 28L AND LONG 30. FOUND SPLICE OUT OF LIMITS IAW DC9 SRM 53-01. REMOVED SPLICE IAW DC9 SRM 51-30-5. FABBED NEW SPLICE FROM 7075-0 .050. HEAT TREATED TO TO 7075T6SDR SWAA111964Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 970, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER ER AND EA.SDR SWAA111963Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME WEB CRACKED AT BS 440, STR 17R. REPAIRED FRAME PER ER AND EA.SDR FDEA201103211092Longeron · corrodedLOWER CARGO COMPARTMENT - FWD CARGO BILGE AREA BETWEEN FRAME STA 6.70 TO STA 6.50 RT SIDE LONGERON 49 FOUND WITH CORROSION. CUT- OUT SRM 51-31-01, REV 46 AND SRM 53-0-05, REV 46, REPAIR 1. FABRICATED LONGERON, REPAIR SPLICE AND FASTENERS INSTALLED IAW SRM 53SDR AALA20110321TUL05Frame · damagedFRAME DAMAGED AT STATION 310 AND STRINGER 4 LEFT. INSTALLED DOUBLER IAW SRM 51-70-11-0G AND EA B757-53-015755.SDR DALA1132960689Frame · dentedFWD CARGO FRAME DENT STA 540 S 24L. C/W ERA 491078-14 REV ORIG PERM REPAIR.SDR IPXA1565716Frame · chafedINSPECTION TYPE:C4, STA 1060 FRAME INBD FORE IS CHAFED AT STRINGER 15R. BLENDED OUT DAMAGE. FABRICATED AND INSTALLED REPAIR DOUBLER IAW EA 110 155 IR AND EO B757-5310-41937-A.SDR DALA1120519877Frame · corrodedFRAME & WEB HAS CORROSION AT STA 157 LT SIDE, FWD OF AIRSTAIR CUTOUT REMOVED CORR FROM FRAME AT STA IAW SRM 51-10-3 FOUND TO BE WITHIN LIMITS FRAME IAW SRM 53-01 WEB AT STA 157 LT SIDE FWD OF AIRSTAIR CUTOUT. FOUND TO BE OUT OF LIMITS IAW SRM 53-01 FIG 1 CUTOSDR USAA2011032991278Frame · corrodedCLT - Q2 - CORROSION ON FUSELAGE FRAME AT BS 578, RBL 64. REPAIRED FUSELAGE FRAME AT BS 578, RBL 64 IAW EA 102663.SDR ASOA201100525Frame · crackedFRAME IN AFT EQUIPMENT BAY AT FS 700 S9R IS CRACKED AT BOTTOM RIVET APPROX 1"L. REPAIRED FRAME IAW SRM 53-00-15, REPAIR NR 2 AND REO 601R-53-61-4017.SDR FDEA201103181073Frame · gougedAFT CARGO DOOR CUTOUT STA 1380 S-25R TO S27R, FRAME INBD CHORD GOUGED AND BARE METAL AFT CARGO DOOR CUTOUT, STA 1380 S-25R TO S-27R REPAIR COMPLIED WITH EA F-5310-146264. REF FAA FORM 8100-9 DATED MARCH 14, 2011. CLASSIFIED MAJOR REPAIR.SDR USAA2011032991280Frame · corrodedCLT - Q2 - LEVEL 2 GALVANIC CORROSION ON FUSELAGE FRAME AT BS 847 BETWEEN S27L TO S27R. REPAIRED FUSELAGE FRAME AT BS 847 BETWEEN S27L TO S27R IAW 102726.SDR USAA2011032291171Frame · corrodedCLT - Q2 - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 847 BETWEEN S22R TO S24R. REPLACED FUSELAGE FRAME AT BS 847 BETWEEN S22R TO S24R IAW B737 SRM 51-40-02 & BOEING DRAWING 65-47960.SDR ASAA1149258Shear Tie · corrodedCORROSION AT FRAME BS 727E SHEAR TIE STR 27R TO STR 27L. REPAIRED FRAME SHEAR TIE IAW B737 400 SRM 53 00 07 FIG 201 REPAIR 3.SDR SIMA201108005Frame · crackedDURING MAINTENANCE BASE VISIT FOUND FRAME 23 CRACKED BETWEEN STRINGER 15 RIGHT AND 16 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW EO EM-53MR-1789. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201108003Frame · crackedDURING MAINTENANCE BASE VISIT FOUND FRAME 23 CRACKED BETWEEN STRINGERS 15 RIGHT AND 16 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW EO EM-53MR-1789. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR USAA2011031891149Frame · crackedCLT - C3 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME WEB AT BS 303.9, S16L ON L-1 DOOR FORWARD CUTOUT SECTION OF LOWER STOP. REPAIRED FUSELAGE FRAME WEB AT BS 303.9, S16L ON L-1 DOOR FORWARD CUTOUT SECTION OF LOWER STOP IAW EO 5311-01025.SDR USAA2011031891147Frame · crackedCLT - C3 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME WEB AT BS 303.9, S16L ON L-1 DOOR FORWARD CUTOUT SECTION OF LOWER STOP. REPAIRED FUSELAGE FRAME WEB AT BS 303.9, S16L ON L-1 DOOR FORWARD CUTOUT SECTION OF LOWER STOP IAW EO 5311-01025.SDR UIEA2011031600195Seat Track · crackedCRACK - SEAT TRACK UNDER FLOOR OF MAIN CARGO COMPT STA 995 LBL 76. (REPAIR IAW SRM 53-00-52-2R-13, REV 58)SDR FDEA201103161004Frame · corrodedLOWER AFT CARGO COMPARTMENT STATION 1841 X-22 WEB FRAME FOUND CORROSION. AFT CARGO COMPARTMENT STATION 1841 X-22 FRAME WAS FABRICATED AS PER DOUGLAS DRAWING AGA 7170 REVISION R. FRAME WAS REMOVED AND REPLACED AS PER SRM 51-31-01 REVISION 45. REPAIR CLASSIFIEDSDR USAA2011032291166Frame · crackedCLT - Q2 - CRACK ON FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S21L IAW EA 102696.SDR ASOA201100498Frame · corrodedFUSELAGE FRAME AT FS 333.00 HAS SEVERAL AREAS OF CORROSION ON FWD SIDE OF FRAME BETWEEN STR 25L AND STR 25R.
Back to JASC 5311