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 GLBA2009090409GFrame · bentMAJOR REPAIR-UPON INSP OF ACFT, LWR CTR FRAME SECTION WAS FOUND BENT AT FS 13945.0 FRAME 41, BETWEEN STRINGERS 20L AND 21L. MX REPLACED THE LWR CTR FRAME 41 IAW EO 09-120-53-010. RII COMPLIED WITH IAW EO 09-120-53-010. MATERIALS UTILIZED ARE INCLUDED IN THSDR SWAA095672Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA095667Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA095666Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR FDEA200909023251Frame · damagedAFT CARGO COMPT FRAME 1480 UPPER FLANGE HAS A DENT AT S-25L. REMOVED DAMAGED AREA AND ORIGINAL SPLICE FOR REPAIR IAW SRM 51-40-2; NDT NO CRACK NOTED; FABED NEW SPLICE ON MAE TRAVELER NR T9/800805; LOCATED AND DRILLED IAW SRM 51-40-5; REMOVED STRINGER FOR SDR FDEA200909023229Frame · gougedRE-WORK BS 1480, STR 22L TO STR 27L FRAME DAMAGED DUE TO NON-COMPLIANCE OF EA NR F-5310-131075 STEP 1. REFER TO SNRM NR N00883. EA NR F-5310-131075 COMPLIED WITH. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200909023228Frame · gougedFRAME GOUGE BETWEEN STR 25L TO STR 27L AT BS 1480. FOUND OUT OF LIMIT IAW SRM 53-00-07 REV 97. REPAIR CARRIED OUT IAW SRM 53-00-07 FIG. 201 (SHT 4 OF 15) REPAIR 5. NOTE: INSP THRESHOLD AT 37,500 FC AFTER REPAIR INSTALLATION OR 50,000 AIRFRAME FC WHICHEVER CSDR C2XA09TY228Frame · chafedHOLE CHAFED INTO FRAME 60 AT STRINGER 5L. REPAIRED FRAME IAW EMB 145 SRM 53-00-04.SDR FDEA200909013221Frame · dentedCABIN - RT STA 1741 LONGERON 11 - LONGERON 12 FRAME FOUND DENT. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2 REV. 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG. 201, REPAIR 2SDR FDEA200909013205Frame · dentedAT BS 1340 STR 26R FRAME DAMAGED. DENTED FUSELAGE FRAME FLANGE AT BS 1340 REPAIRED IAW SRM 53-00-07 REV 97. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200909013204Frame · corrodedAT BS 1360 STR 23R TO 26R FRAME CORRODED. CORRODED FRAME AT BS 1360 REPAIRED IAW SRM 53-00-07 REV 97. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR IPXA09557496Frame · dentedINSPECTION TYPE:C DENT ON AFT CARGO COMPARTMENT AT FRAME STA 1540, BETWEEN STRINGERS S-26L AND S-27L. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE PER SRM 53-00-07-2R5 FIG 201. HFEC AT CUT+HOLES IAW NDT PT6 51-00-19/-16, NO CRSDR IPXA09557431Frame · dentedINSPECTION TYPE:C DENT ON BULK CARGO PIT FRAME STA 1500 BETWEEN STR 25L &26L. DENTS OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. TRIMMED OUT 3 LOCATIONS IAW EA757-5362-27-A1905. HFEC AT CUT OUT AND HOLES IAW NTM 51-00-19PT6/-16PT6. FAB'D PART ON TRAV T9/803SDR IPXA09557430Frame · dentedINSPECTION TYPE:C DENT ON AFT PIT FRAME STA 1260 ABOVE STR 25L. DENT OUT OF LIMITS PER SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE EA 757-5362-27-A1906. HFEC CUTOUT + HOLE PER NTM51-00-19 PT6/-16 PT6, NO CRACKS NOTED. FAB PARTS MAE TR T9/803596, T9/803595. RSDR IPXA09557405Frame · dentedINSPECTION TYPE:C DENTS ON AFT CARGO COMPARTMENT AT FRAME STA 1500, ALONG STR S-25R (2 LOCATIONS). DENTS FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE IAW SRM 53-00-07-2R5 FIG 201. HFEC AT CUTOUT + HOLES IAW NTM51-00-19PT6/-16PT6, NSDR IPXA09557404Frame · dentedINSPECTION TYPE:C DENT ON BULK CARGO COMPARTMENT AT FRAME STA 1580, ALONG STR S-25R TO S-26R. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE IAW SRM 53-00-07-2R5 FIG 201. HFEC AT CUTOUT + HOLED IAW NTM 51-00-19PT6/-16PT6, NO CRASDR AALA20090902TUL06Frame · crackedAFT ACCESSORY 1418 FRAME CRACKED AT LONGERON 2 LEFT TO 2 RIGHT. INSTALLED DOUBLER IAW 53-11-04.SDR FDEA200908313191Frame · dentedAFT CARGO COMP, STA 1540, STR 26R ATTACH FRAME HAS DENT. FOUND OUT OF LIMITS IAW 53-00-07. CUT OUT DAMAGE IAW SRM 53-00-07. REMOVED CLIP IAW SRM 51-40-02. RECEIVED REPAIR FABED ON TRAVELER NR T9/801702. RECEIVED CLIP IAW TRAVELER NR T9/801701. LOCATED SDR FDEA200908313159Frame · dentedCABIN - LT STA 1761 LONGERON 11 TO LONGERON 12 FRAME FOUND DENT. REPAIRED IAW SRM 53-00-07, FIG 20, REPAIR 2 REV 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG. 201, REPAIR 2SDR FDEA200908313158Frame · chafedCABIN - LT STA 1741 LONGERON 11 TO LONGERON 12 FRAME FOUND CHAFED. REPAIRED IAW SRM 53-00-07, FIG. 201, REPAIR 2 REV. 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG. 201, REPASDR FDEA200908313156Frame · dentedLEFT STA 1721 LONGERON 11 TO LONGERON 12 FRAME FOUND DENT. REPAIRED IAW SRM 53-00-07, FIG. 201. REPAIR 2 REV 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG. 201. REPAIR 2, RSDR FDEA200908313152Frame · dentedCABIN - RT STA LONGERON 11 TO LONGERON 12 FRAME FOUND DENT. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV. 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG 201, REPAIR 2, RSDR FDEA200908313151Frame · chafedCABIN - RT STA 1661 LONGERON 11 TO LONGERON 12 FRAME FOUND CHAFED. REPAIRED IAW SRM 53-00-07 FIG 201, REPAIR 2, REV. 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG 201, REPAISDR Q2S2010F00003Frame · crackedCABIN, STA 800, LT SIDE STRINGER 17, WHILE CARRYING OUT BS800 FRAME ASSY NDT INSP, FOUND QUANTITY 01 HOLE HAVEING INDICATION. REPAIR CARRIED OUT IAW EN NR: 1378-09.SDR USAA2009090992422Frame · crackedSAL - BC-7 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT FR40 BETWEEN S22R TO S23R. REPAIRED FUSELAGE FRAME AT FR40 BETWEEN S22R TO S23R IAW US AIRWAYS EA 132591.SDR USAA2009090992421Frame · crackedSAL - BC-7 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT FR41 BETWEEN S23R TO S24R. REPAIRED FUSELAGE FRAME AT FR41 BETWEEN S23R TO S24R IAW US AIRWAYS EA 132591.SDR USAA2009090992420Frame · corrodedSAL - BC-7 - MAJOR REPAIR - CORROSION ON FUSELAGE FRAME AT FR59 BETWEEN S33R TO S34R. REPAIRED FUSELAGE FRAME AT FR59 BETWEEN S33R TO S34R IAW EA 132619.SDR SWAA095602Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 887, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA095599Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR FDEA200908303128Frame · corrodedBS 1400, RBL 22 FRAME SUPPORT ANGLE FOUND CORRODED. EVALUATE AND REPAIR. FRAME SUPPORT ANGLE REMOVED AT BS 1400, RBL 22 IAW SRM 51-40-02 REV 97. CORROSION FOUND EXCEED LIMIT IAW SRM 53-00-07, FIG 101 REV 97. SUPPORT ANGLE FABRICATED IAW DWG NR 140N2006, SHTSDR FDEA200908303122Frame · corrodedCORROSION FOUND STA 879L STR 45. REPAIRED REF EA NR 8-5330-133747.SDR SWAA095629Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME LOWER FITTING LUG BORE CORRODED AT BS 685 RT. REPAIRED FRAME PER SWA EA.SDR SWAA095621Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME LOWER FITTING LUG BORE CORRODED AT BS 685 LT. REPAIRED FRAME PER SWA EA.SDR ZZDA2009245Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2984.SDR ZZDA2009244Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2975.SDR USAA2009090292321Frame · crackedCLT - Q4 - MAJOR REPAIR - 3 CRACKS IN FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S21L IAW TYPICAL REPAIR 53-60-07A.SDR AALA20090902TUL19Frame · crackedCRACK IN FRAME 1418 AT LONGERON 2 RIGHT. REPAIR DOUBLER INSTALLED UNDER SRM 53-03-00.SDR FDEA200908283118Frame · corrodedCORROSION FOUND STA 1641R STR 47-48. REPAIRED REF: MD1010F SRM 53-20-00 VOL I, FIG 6, SHEET 9.SDR DU4R2009395Frame · crackedDURING SCHEDULED INSP, FOUND CABIN, FUSELAGE FRAME AT BS 616, INBD CHORD CRACKED AT LWR (2) FASTENERS, WL 201.6 LT.SDR USAA2009090992419Frame · crackedSAL - BC-7 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT FR39 BETWEEN S22R & S23R, ALSO AT S22R. REPAIRED FUSELAGE FRAME AT FR39 BETWEEN S22R & S23R, ALSO AT S22R IAW US AIRWAYS EA 132591.SDR ASOA200900952Frame · corrodedCORROSION FOUND ON FRAME FUS STA 333 AT STRINGER 24R. REMOVED 1 EA RIVET, REMOVED CORROSION AND REINSTALLED 1 EA RIVET IAW SRM 53-21-15 AND 51-42-06.SDR FDEA200908263107Frame · damagedSTA 418, FRAME B/T STR 3L-3R, NUMEROUS MISDRILLED HOLES. (INCOMING CONDITION) AT BS 418, B/T STR 3L-3R, FRAME REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE W/C NR 118450524AZD, AND MAE EA 757-5332-16-F2172, REV A, DATED 08/17SDR FDEA200908263106Frame · damagedFRAME STA 395 B/T STR 3L-3R, NUMERIOUS MISDRILLED HOLES, (INCOMING CONDITION). REPAIR WAS ACCOMPLISHED,DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE MOD W/C 118450524AZD, AND MAE EA 757-5332-16-F2172, REV A, DATED AUG 17, 2009, THIS NON ROUTINE ISSDR FDEA200908263105Frame · damagedFRAME STA 377.7, B/T STR 3L-3R, NUMERIOUS MISDRILLED HOLES. (INCOMING CONDITION) AT BS 377.7, B/T STR 3L-3R, NUMERIOUS MISDRILLED HOLES, FRAME REPAIR WAS ACCOMPLISHED DUE TO DISCREPANCY AFFECTING THE PTF CONVERSION, OM MAE W/C NR 118450524AZD, AND MAE EA RN 7SDR ASOA200900931Frame · crackedIN REFERENCE TO TASK CARD AWL2 53-41-201. FRAME CAP ANGLE BEND RADIUS CRACKED BELOW VERTICAL BEAM AT LBL 18.00 AND RBL 18.00 LOCATED AT FS 559.00. REPAIRED 601R-53-41-559 LBL & RBL IAW REO 601R-53-41-260.SDR SWAA095505Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ER.SDR FDEA200908253084Frame · damagedBS. 560, FRAME LWR FLANGE OUTBD OF STR 26L, OTBD HOLE ED, WILL NOT ALLOW ACCOMPLISHMENT OF PTF, COVERSION, PRE- EXISTING INSTALL. BS. 560, FRAME, LWR FLANGE OTBD OF STR 26L, O/B HOLE SED WAS ACCOMPLISHED ON MAE MOD W/C NR 118250287DSSRO8, AND MAE EA NR 75SDR FDEA200908253083Frame · damagedBS 620, FRAME LWR FLANGE OUTBD OF STR 26L, OUTBD HOLE E.D. WILL NOT ALLOW ACCOMPLISHMENT OF PTF CONVERSION, PRE- EXISTING INSTALL. BS. 620, FRAME, LOWER FLANGE O/B OF S26L, O/B HOLE S.E.D. WAS ACCOMPLISHED ON MAE MOD W/C NR 118250287DSSR08, AND MAE EA NR SDR FDEA200908253082Frame · misalignedBS 580 FRAME LWR FLANGE OTBD OF STR 26L OTBD HOLE ED WILL NOT ALLOW ACCOMPLISH OF PTF CONVERSION - PREEXISTING INSTALL BS 580 FRAME, LWR FLANGE OTBD OF STR 26L O/B HOLE SED WAS ACCOMPLISHED ON MAE MOD W/C 118250287 DSSR08, AND MAE EA NR 757-5332-16-F2205 REV-,SDR FDEA200908253081Frame · misalignedBS 600 FRAME LWR FLANGE OTBD OF STR 26L O/B HOLE ED WILL NOT ALLOW ACCOMPLISHMENT OF PTF CONVERSION - PREEXISTING INSTALL BS 600 FRAME, LWR FLANGE OTBD OF STR 26L O/B HOLE SED WAS ACCOMPLISHED ON MAE W/C NR 118250287 DSS R08, AND MAE NR 757-5332-16-F2205 REV
Back to JASC 5311