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 DALA1221630670Frame · dentedAFT CARGO FRAME DENTED UPPER FLANGE BS 1400 BETWEEN S26 AND 27L, DENTED FRAME. REPAIRED FRAME PER SRM 53-00-07.SDR DALA1221590670Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE BS 1480 BETWEEN STR 25 & 26L. FRAME OUT OF LIMITS DUE TO LOCATION OF DENT. REMOVED DAMAGE SECTION, FABRICATED REPAIR SPLICE AND INSTALLED IAW SRM 53-00-07.SDR A6WA201240328Frame · corrodedCORROSION ON RIB AT STA 349 IN AVIONICS BAY BILGE AREA ( FWD SIDE) R & R LOWER FRAME SECTION AT FS 349, STR 34L-24 PN 601R32005-69 IAW SRM 51-42-06, 51-42-21 & 51-40-11.SDR A6WA20124329Frame · corrodedCORROSION ON RIB AT STA 333 IN AVIONICS BAY BILGE AREA (FWD AND AFT SIDE) R 7 R FRAME SECTION PN 601R32004-55 IAW SRM 51-42-06, 51-42-21, 51-40-11.SDR A6WA201240330Frame · corrodedCORROSION ON RIB AT STA 319 IN AVIONICS BAY BILGE AREA (FWD & AFT SIDE). R & R LOWER FRAME SECTION AT BS 319 S24L-24R IAW SRM 51-42-06, 51-42-21, 51-40-11.SDR DALA1219780670Frame · dentedAFT CARGO FRAME DENTED STA 1520 BETWEEN STR 26&27L / DENT IS NOT ALLOWED IN UPPER FLANGE OF THE FRAME FOUND TO BE OUT OF LIMITS IAW B757 SRM 53-00-07 ALLOWABLE DAMAGE 1 FIG 101. INSTALLED REPAIR J SECTION AT AFT CARGO STA 1520 BETWEEN STR 26&27L IAW B757 SRM SDR DALA1219040670Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1500 LBL16 / FRAME FOUND TO BE OUT OF LIMITS, DENTS NOT ALLOWED ON UPPER FLANGE. REMOVED DAMAGE FRAME SECTION, FABRICATED REPAIR SECTION AND INSTALLED IAW 757 SRM 53-00-02 DURING HMV.SDR IPXA2572583Frame · damagedINSPECTION TYPE: C, FWD CARGO RT SIDE FRAME AT BS 820, S23R HAS DAMAGE. REPAIRED IAW SRM 53-00-07-2R REPAIR 5 DETAIL III, RCD 128729.SDR IPXA2572580Frame · damagedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT BS 1640, STR 11L, TOOLING MARK ON FRAME INNER FLANGE. REPAIRED IAW EA 120344 IR AND EO B757-5310-46338-A.SDR IPXA2572564Frame · damagedINSPECTION TYPE: C, MAIN CARGO BS 1640, STR 13L DAMAGE ON FRAME INNER FLANGE. REPAIRED IAW EA 120383 IR AND EO B757-5310-46520-A.SDR IPXA2572549Frame · damagedINSPECTION TYPE: C, FWD CARGO LEFT SIDE FRAME AT BS 720 BETWEEN STRINGERS 24L AND 25L IS DAMAGED. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R5.SDR SWAA2012032602532Frame · crackedR1 DOOR CUTOUT, LOWER STUB FRAME CRACKED AT BS 296, STR 16R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA2012032202481Frame · crackedFRAME CRACKED AT BS 312, STR 6L. REPAIRED FRAME PER ER AND EA.SDR IPXA2M72358Splice Plate · crackedINSPECTION TYPE:4C, MAIN CABIN LONGITUDINAL SPLICE CRACKED AT STA 1531/5-123 AND L11L. REPAIRED MAIN CABIN LONGITUDINAL SPLICE AT STA 1531/5-123 AND L11L REF DWG A5A7112 , SRM 51-33-01 PAGE 30 AND 45.SDR IPXA2572361Frame · damagedINSPECTION TYPE:C-CHECK, FWD CARGO LT SIDE FRAME AT STA 700 S-24L IS DAMAGED. REPAIRED IAW SRM 53-00-07-2R 5 DETAIL I REPAIR.SDR IPXA2572359Frame · damagedINSPECTION TYPE:C-CHECK, FWD CARGO LEFT SIDE FRAME AT STA 820 S-23L IS DAMAGED. REPAIRED IAW SRM 53-00-07-2R DETAIL I REPAIR.SDR WX0A2012031371126Frame · damagedHI-LOK TOO CLOSE TO RIVET ON FRAME STA 256 NEAR LONGERON 4R (MISDRILLED). CUT OUT DAMAGED SECTION, FABRICATED REPAIR PLATE, FILLER, LOCATED, DRILLED AND INSTALLED IAW MD80 SRM 53-03 FIG 4.SDR COMA0212030150010Frame · corrodedFUSELAGE FRAME FOUND TO BE CORRODED BEYOND LIMITS. REPAIRED FRAME IAW CRJ 200 SRM 53-00-15 AND CRJ 200 MDTM 51-20-08.SDR DALA1221620670Frame · dentedFWD CARGO FRAME DENTED BS 620 ABOVE STR 24-25L, DENT OUT OF LIMITS DUE TO LOCATION ON FRAME. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR SPLICE IAW SRM 53-00-07.SDR DALA1221610670Frame · dentedFWD CARGO FRAME DENTED BS 600 ABOVE S24L, FRAME OUT OF LIMITS DUE TO LOCATION OF DENT. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR SPLICE IAW SRM 53-00-07.SDR DALA1221580670Frame · dentedFWD CARGO FRAME UPPER FLANGE BENT BS 580 ABOVE STR 24L, DENT IS NOT ALLOWED ON UPPER FLANGE. TRIMMED OUT DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR SPLICE IAW SRM 53-00-07.SDR DALA1221520670Frame · dentedFWD CARGO FRAME DENTED BS 540 BETWEEN STR 24 AND 25L. DENT FOUND OUT OF LIMITS. REPAIR ACCOMPLISHED PER ERA 501020-14REV A.SDR SWAA2012031902302Frame · corrodedFRAME CORRODED AT BS 847, BL. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012031602273Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B BETWEEN STR 20L AND STR 21L. REPAIRED FRAME PER SRM & EA.SDR SWAA2012031602271Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME PER EA.SDR SWAA2012030601939Frame · damagedFRAME DAMAGED AT BS 787, STR 27R. REPAIRED FRAME IAW ER AND EA.SDR DALA1211780692Frame · dentedFWD PIT LEFT FRAME DENTED BS 580, STR 25L. REPAIRED IAW B757 SRM 53-00-07 FIG 201, PAGE 204.SDR CALA2012022800137Bracket · crackedSUPPORT TASK LEFT FRAME BRACKET AT STA 400L CRACKED INTO RADIUS. INSTALLED FRAME REPAIR REF EA-5310-04716 REV C AT STA 400L BETWEEN STR 8 AND 9 LEFT.SDR FDEA201202280695Frame · corrodedBS 1787 AT S3R, CORROSION ON THE AFT SIDE OF THE FRAME WHERE IT ATTACHES TO THE STRINGER. REPAIRED IAW EA F-5310-157138, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201202280694Frame · corrodedBS 1787 S3R, CORROSION ON THE AFT SIDE OF THE FRAME WHERE IT ATTACHES TO THE SKIN. REPAIR CARRIED OUT IAW EA F-5310-157138, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR CALA2012022800138Bracket · crackedSUPPORT TASK RIGHT FRAME BRACKET AT STA 440R CRACKED INTO RADIUS. REPAIRED FRAME IAW EA 5310-04716 REV C.SDR CA120227009Gusset · cracked(CAN) CRACKED FUSELAGE FRAME AT LT AFT, FLOAT/AFT WING SPAR ATTACHMENT AREA. CRACK IS IN AREA "C" OF WIPAIRE SL REV D. AREA ALREADY REPLACED WITH THE NEWEST VERSION OF TUBING. SUGGEST DRILLING HOLE AT AREA C TO IMPROVE FLEXIBILITY.SDR DALA1216570923Frame · crackedMAIN CABIN STA 1117 LONGERON 7L FRAME IS CRACKED. CUT OUT DAMAGED AREA IAW MD80 SRM 53-03D FIG 4. FABRICATED REPAIR PART 2 EA ANGLE REPAIR AND FILLER REPAIR IAW MD80 SRM 53-03D FIG 4 AND INSTALLED PER MD80 SRM 51-30-2 PARA 1 PG 1, MD80 SRM 51-30-5 PARA 1 PG SDR CALA2012022800135Bracket · crackedSUPPORT TASK LEFT FRAME BRACKET AT STA 480L CRACKED. REPAIRED LEFT FRAME BRACKET PER EA5310-04716.SDR KCSA201202271020Frame · crackedFUSELAGE FRAME CRACKED AT BS 2231, STR 24L IN THE AFT LOWER HOLE.SDR CALA2012022800133Bracket · crackedSUPPORT TASK - LEFT FRAME BRACKET AT STA 500C CRACKED. REPAIRED LEFT FRAME BRACKET STA 500C STR 8L-STR 9L PER ECRA 531 0-04716.SDR CALA2012022800132Bracket · crackedRIGHT FRAME BRACKET AT STA 480R CRACKED INTO RADIUS. REPAIR RIGHT FRAME BRACKET AT STA 480R IAW EA5310-04716 REV C.SDR FDEA201202260687Frame · gougedMAIN DECK AT FRAME 47 S13R FOUND GOUGED. REPAIRED IAW EA 6-5310-150437. REPAIR CLASSIFIED AS MINOR IAW GMM 6-2-100, REV 114.SDR FDEA201202260686Frame · gougedMAIN DECK AT FRAME 47, S13L, FOUND GOUGED. REPAIRED IAW EA 6-5310-150436. REPAIR CLASSIFIED AS MINOR IAW GMM 6-2-100, REV 114.SDR DALA1230229261Frame · corrodedFWD CARGO COMPARTMENT STA 465 FRAME AFT SIDE BETWEEN L20L TO L30 HAS CORROSION OUT OF LIMITS. REMOVED CORRODED FRAME SECTION AND REPLACED PER SRM 53-10-02 FIG 2 VOL I.SDR SWAA2012031902366Frame · crackedSTUB FRAME CRACKED AT BS 947+13.5, STR 17L. REPAIRED STUB FRAME IAW EO AND EA.SDR UALA2012022701160Strap · damagedRT FAILSAFE STRAP AT STA 955 FAILED ULTRA-SOUND TEST. ACCOMPLISHED COA 618451 RT STA 955 FLSF STRP RWK (SB 767-53A100 REV 1).SDR CALA2012022800131Bracket · crackedSUPPORT TASK - LEFT FRAME BRACKET AT STA 727D L CRACKED. REPAIR LEFT FRAME BRACKET AT STA 727 D LT IAW EA 5310-04716 REV C.SDR CALA2012022800130Bracket · crackedSUPPORT TASK - LEFT FRAME BRACKET AT STA 500A CRACKED. REPAIRED LEFT FRAME AT 500A IAW EA# 5310-04716.SDR IPXA2572606Frame · dentedINSPECTION TYPE:C-CK, MAIN CARGO FRAME AT BS 520, STR 16 - 17R INNER FLANGE IS DENTED. REPAIRED FRAME IAW EA 120283 AND EO B757-5310-46264-A.SDR IPXA2572556Frame · dentedINSPECTION TYPE:C-CK, MAIN CARGO FRAME BS 600 BETWEEN S16R AND S17R INBD FLANGE DENTED. REPAIRED MAIN CARGO FRAME IAW EA 120285 IR AND EO B757-5310-46266-A.SDR IPXA2572544Frame · dentedINSPECTION TYPE: C, MAIN CARGO BS 540 FRAME INNER FLANGE DENTED BETWEEN S16R AND S17R. REPAIRED MAIN CARGO FRAME INNER FLANGE IAW EA 120284 IR AND EO B757-5310-46265-A.SDR IPXA2572543Frame · damagedINSPECTION TYPE: C, MAIN CARGO BS 395 BETWEEN S6L AND S16L INBD FLANGE OF FRAME HAS 9 DAMAGED AREAS. REPAIRED MAIN CARGO FRAME INBD FLANGE IAW EA 120307 IR AND EO B757-5310-46331-A.SDR IPXA2572452Frame · gougedINSPECTION TYPE: C-CHECK, MAIN CARGO FRAME BS 1560 BETWEEN S16L AND 17L IS GOUGED. REPAIRED FRAME IAW EA.SDR SWAA2012030902056Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.
Back to JASC 5311