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 IPXA10562932Frame · damagedINSPECTION TYPE:C3, SCREW STRIKE ON FRAME INBD FLANGE INBD SURFACE AT BS 1620 BETWEEN STR 15-16 RT. REPAIR IAW ER 10-4676, DATED 10-1-10.SDR IPXA10562879Frame · dentedINSPECTION TYPE:C3, DENT IN FREE FLANGE OF FRAME STA 820 BETWEEN STR 24R AND STR 25R. REPAIRED IAW ATS ER 10-4645.SDR IPXA10562853Frame · dentedINSPECTION TYPE:C3, DENT IN FREE FLANGE OF FRAME STA 680 BETWEEN STR 23L AND 24L. REPAIRED IAW SRM 53-00-07-2R5.SDR IPXA10562481Frame · dentedINSPECTION TYPE:C3, DENT IN FREE FLANGE OF FRAME STA 760 AT STR 24R. REPAIRED FRAME IAW SRM 53-00-07-2R-5.SDR IPXA10562918Frame · gougedINSPECTION TYPE:C3, BS 1060, STR 15L, FRAME INBD FLANGE SCREW START. REPAIRED IAW ER 10-4492, DATED 27SEP2010 AND EO B757-5310-39875-A, DATED 28SEP10.SDR IPXA10562901Frame · damagedINSPECTION TYPE:C3, BS 440 STR 6R, FRAME INBD FLANGE SCREW START. REPAIR IAW ER 10-4480.SDR DALA1025060617Frame · dentedDENT ON FRAME FLANGE STA 1300 RT STR 26. REPAIRED IAW ERA 485376-14 REV ORIG.SDR IPXA10562556Frame · damagedINSPECTION TYPE:C3, MAIN CARGO DOOR INTERNAL SIDE AT BS 486.75 FRAME HAS SCREW STRIKES BETWEEN WL 212-213. REPLACED IAW SRM 52-30-02-1A1, SRM 51-40-05-06, SRM 51-40-02-0G AND DWG 65-25327.SDR ZZDA2010404Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 2. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2987.SDR ZZDA2010403Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2979.SDR USAA2010090791952Frame · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FRAME AT BS 847 BETWEEN S26R TO S27R. REPLACED FRAME AT BS 847 BETWEEN S26R TO S27R IAW B737 SRM 51-10-02.SDR SIMA201025009Frame · damagedDURING MAINTENANCE BASE VISIT MISDRILLED HOLE ON FRAME 66, RIGHT SIDE AT STRINGER 16 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME IAW SRM 53-00-04 FIG 206. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1027240195Failsafe · damagedFUS - LT STA 955 REAR SPAR BULKHEAD FAIL SAFE STRAP REPAIR ACCOMPLISHED AS PER ER/A 485464-14AD REV O (DL76L102807).SDR ASOA201001257Frame · corrodedFS 333 SECTOR BETWEEN STR 25L AND 25R IS CORRODED. REMOVED FRAME SECTOR FROM FS 333 STR 23L-23R IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW FRAME SECTOR IAW SRM 51-40-11. INSTALLED NEW FRAME SECTOR AT FS 333 STR 23L-23R IAW SRM 51-42-06 AND 51-4SDR ASOA201001256Frame · corrodedFS 409+32 SECTOR CORRODED FROM STR 25L TO 25R. REMOVED FASTENERS AND CUT FRAME AT S25R AND 25L IAW SRM 51-00-15. C/W SRM 53-00-15 REPAIR 1 STEP 5, A6. PERFORMED EDDY CURRENT OF FRAME CUT LINES IAW NDTM 51-20-06. NO INDICATIONS NOTED. FABRICATED REPAIR SPLSDR ASOA201001255Frame · corrodedFRAME AT BS 409+16 IS CORRODED FROM S27-26R. REMOVED FS 409+16 FRAME SECTOR FROM S21L-21R IAW SRM 51-42-06. LOCATED, DRILLED AND DEBURRED NEW FRAME IAW SRM 51-40-11. CUT FRAME AT STA 333 BETWEEN S26R & 25R IAW SRM 53-00-15. COMPLIED WITH SRM 53-00-15. SDR QXEA2010090700515Frame · corrodedC-CHECK - DURING INSP, FOUND CORROSION ON FRAME AT FS349 ON ATTACH ANGLE LOCATED JUST FWD OF ATTACHMENT ANGLE 26R. REMOVED RIVETS FROM ATTACH ANGLE IAW SRM 51-42-06-001-001-A01. BLENDED CORRODED AREAS ON WEB AND ATTACH FLANGE IAW SRM 51-21-06-001-001-A01. BLESDR ASOA201001230Frame · corrodedFS 349 SECTOR BETWEEN STR 25L AND 25R IS CORRODED. R & R FRAME SECTOR AT FS 349 BETWEEN STR 23L AND 23R IAW SRM 51-42-06 AND 51-42-21.SDR SWAA105185Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO FRAME ANGLE CORRODED AT BS 847, RBL 8. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA105183Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105170Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR EE4Y1009370Frame · crackedUPPER FUSELAGE MAIN CARGO CABIN AT STA Y 446 AT LEVEL LONGERON 18L FRAME WITH CRACK.SDR COMA2010090250189Frame · crackedCRACK ON LEFT FRAME CAP ANGLE AT FS 559.00 LBL 18.00. REPAIRED FS 559 CAP ANGLE IAW REO 601R-53-41-260 LT REPAIR.SDR SIMA201025008Frame · damagedDURING MAINTENANCE BASE VISIT AND DURING A CARGO DOOR SILL REPAIR MISDRILLED HOLES ON FRAME 67. THE AIRCRAFT WAS REMOVED FROM SERVICE. CUT OUT DAMAGE AND REPAIRED FRAME 67 IAW EMBRAER SRM 53-00-04 FIGURE 201. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR ASOA201001223Frame · corrodedFRAME 349 HAS CORROSION WITH 100 PERCENT MATERIAL LOSS BETWEEN STR 26L TO STR 26R AT DEEPEST POINT. REMOVED FRAME AT FS 349 IAW SRM 51-42-06. LOCATED AND DRILLED UP NEW FRAME IAW SRM 51-42-06 AND 51-42-21. INSTALLED ALL RIVETS COMMON TO FRAME THROUGH SKIN ANSDR ASOA201001222Frame · corrodedFRAME 333 HAS CORROSION WITH 100 PERCENT MATERIAL LOSS BETWEEN STR 26L TO STR 26R AT DEEPEST POINT. REMOVED CORRODED FRAME FROM FS 333 BETWEEN STR 26L TO 26R IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW SERVICEABLE FRAME AT FS 333 BETWEEN STR 26L TSDR ASOA201001221Frame · corrodedFRAME 310, HAS CORROSION WITH 50 PERCENT MATERIAL LOSS AT DEEPEST POINT BETWEEN STR 26L TO 26R. REMOVED FRAME SECTION 310 IAW SRM 51-42-06 AND SRM 51-42-21. LOCATED AND DRILLED UP NEW FRAME SECTION 310 IAW SRM 51-42-06. INSTALLED NEW FRAME SECTION AT FS 310 SDR ASOA201001220Frame · corrodedFRAME 319 HAS CORROSION WITH 100 PERCENT MATERIAL LOSS AT DEEPEST POINT BETWEEN STR 26L TO STR 26R. R & R LT FS 449.85 OVERWING ATTACHMENT ANGLE IAW SRM 51-42-06, 51-40-11, 51-42-15 AND AMM 51-23-00-100-801.SDR ASOA201001215Frame · corrodedFS 605, FRAME CORRODED FWD & AFT SIDE AT STR 26L - 26R. FOUND CORROSION OF FS 605 FROM TO BE OUT OF LIMITS IAW SRM 53-00-00. REMOVED OUT OF LIMITS FROM SECTION AT FS 605.00 FROM STR 21L - STR 21R IAW SRM 51-42-06. INSTALLED FRAME IAW SRM 51-42-06 & 51-42-2SDR FDEA201009013236Frame · gougedMAIN DECK FRAME BS 1640, BETWEEN S- 5L & S-6L GOUGED AT BS 1640 FRAME, S5-6L.SDR FDEA201009013230Frame · damagedMAIN CABIN INTERIOR LINER ATTACH BRACKET HAS A FASTENER THRU THE RADIUS OF FRAME 1159; BETWEEN STRINGER 11R - STRINGER 12R. COMPLIED WITH EA 8-5310-136699.SDR IPXA10562832Frame · dentedINSPECTION TYPE:C3, MCB FRAME INBD FLANGE IS DENTED AT BS 600 BETWEEN S-16R AND S-17R JUST BELOW ISOLATOR. REPLACED FRAME SEGMENT ASSY IAW SRM 51-40-02.SDR MALA100134Frame · unknownLOWER FRAME, UPPER FLANGE, STA 294 RBL 18.3. REPAIRED IAW S53108.SDR MALA100133Frame · unknownLOWER FRAME, UPPER FLANGE, STA 294 LBL 18 TO BL0. REPAIRED IAW S53776.SDR DALA1020963101Frame · corrodedFWD CARGO COMP FR, BETWEEN S-42R & S-43R, HAS CORROSION ON FRAME ANGLE & RIVETS. RII: N, REMOVED 2EA FASTENERS FROM FR 28ST42R & 43R IAW SRM 51-42-11, REMOVED FRAME ANGLE AT FR27, STR 42R, STR43R IAW SRM 51-42-11, FABRICATED NEW CLEAT, LOCATED AND DRILLED ANGSDR SWAA105145Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA105137Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105133Frame Splice · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME SPLICE CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED SPLICE PER ER AND EA.SDR AALA20100831TUL08Frame · damagedSIXTH HOLE UP FROM SUBFLOOR IN FRAME AT STATION 160 APPROXIMATELY 8 INCHES ABOVE FLOOR LINE IS DOUBLE DRILLED FORWARD SERVICE DOOR AREA. INSTALLED DOUBLER AND STRAP DOUBLER PER EA MD80-53-012704.SDR USAA2010092792111Frame · crackedPIT - S3 - MAJOR REPAIR - FUSELAGE FRAME CRACKED COMPLETELY THRU AT FR43, S25R. REPLACED FUSELAGE FRAME AT FR43, S25R IAW EA 116028.SDR FDEA201008303200Frame · damagedFUSELAGE INTERNAL FRAME HAS DAMAGE AT STA 1099 BETWEEN LONGERON 14R AND 15R. REPAIRED IAW E.A. 8-5310-136696,SDR SWAA105125Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA105107Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA105094Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND STUB FRAME CRACKED AT BS 294.5. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA105088Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER EA.SDR VGQY2010082900130Frame · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND CRACK INDICATION ON 2 EA HOLES ON FRAME AND 2 EA HOLES ON FWD CHANNEL AT RT BS 820 AT TENSION TIE AREA. CHANNEL CUT OUT AS PER SRM 53-10-11 FIGURE 2 REVISION 117. FRAME CUTOUT AS PER SRM 53-10-04 FIGURE 132 REVISIOSDR VGQY2010082900129Frame · crackedDURING HFEC INSPECTION ON TENSION TIE AND FRAME AT RT BS 900, FOUND 01 EA HOLE CRACK INDICATION ON FWD 'C' CHANNEL. TENSION TIE AND FRAME AT RT BS 900 REPAIR CARRIED OUT REPAIR ON FWD CHANNEL AS PER SRM 53-10-11 REV 117 FIGURE 2.SDR C8GA201000039Frame · corrodedWHILE IN HEAVY MX PERFORMING INSP, IT WAS NOTED THAT FRAME IS CORRODED AT STA 1149 BETWEEN STRINGER 25L-26L. REMOVED DAMAGE, FABRICATED REPAIR FROM 7075-0 HEAT TREATED TO T6 2" X 12", INSTALLED REPAIR. NO OTHER DEFECTS NOTED. ACFT WAS RETURNED TO SERVICE.SDR CALA2010090200408Frame · crackedSUPPORT TASK STA 303.9 FRAME WEB CRACKED AT S16L REF EA 5310-04 659 OP2 STEPS 8 & 9 CABIN INSTALLED REPAIR AT FRAME STA 303.9 REF EA 5310-04659 OP2.SDR ASOA201001198Frame · corrodedFS 364.00 JUST FWD OF AVIONICS CUTOUT FRAME HAS CORROSION FROM STR 25L TO STR 25R. REMOVED 7 FITTINGS AND 2 EA GUSSET PLATES IAW SRM 51-42-06, 51-42-21 AND 51-41-02 LOCATED AND DRILLED UP FRAME SECTION IAW SRM 51-42-06. INSTALLED NEW SERVICEABLE FRAME SECT
Back to JASC 5311