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 SWAA074233Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074228Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074232Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074231Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA03150Frame Splice · corrodedCORROSION ON CONNECTION SECTION FRAME 69-70 BETWEEN STRG 45-48 LT, REMAINING THICKNESS IS OUT OF LIMIT. REPAIR PERFORMED BY REPLACEMENT OF AFFECTED PARTS IAW SRM 51-72-10.SDR SWAA074187Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA03122Frame · corrodedFWD PIT BILGE, BODY FRAME CHORD IS CORRODED, BS 740, STR 27L- 28L, WL149 REMOVED AND REPLACED CHORD ANGLE REF B727 SRM 51-30-02 PG 2 DUE TO CORROSION BEING OUT OF LIMITS REF SRM 727 SRM 51-10-1, CLASSIFIED AS A MAJOR REPAIR.SDR 07FDEA03120Frame · corrodedLWR FUSELAGE RT SIDE STA 743, RBL 7", SUPPORT FRAME AT IB SIDE OF ACCESS DOOR 3449R IS CORRODED OB SIDE REMOVED BEACON, REMOVED PANELS 3449R AND 3346. CORROSION THROUGH SUPPORT FRAME. REMOVED SUPPORT FRAME. FABRICATED NEW PARTS, ASSEMBLED NEW FRAME. INSTALSDR SWAA074209Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074206Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074205Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074207Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074208Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR COEA0756821Frame · corrodedFOUND DURING HEAVY CHECK. LEVEL 2 CORROSION: CORROSION ON CABIN FRAME 39. FRAME 39 LOWER SEGMENT FROM STRINGER 13L TO 13R. FRAME 39L, FRAME DOUBLER ABOVE CREASE BEAM. FRAME 39R, FRAME DOUBLER AT STRINGER 14R. REMOVED AND REPLACED, LOWER FRAME SEGMENT PN SSDR 07FDEA03106Frame · damagedDEFORMED FRAME CAP STRIP ON FRAME 74, STRG 26 RHS REPAIR PERFORMED BY INSTALLING NEW PARTS IN ZONE 170.SDR 07FDEA03091Frame · crackedCRACK FOUND IN HOLE H27 OF AFT FRAME 46, STRG 27-28 LT REPAIR PERFORMED BY OVERSIZING COLD WORKING AND INSTALLING NSA5357-5 FASTENER WITH HIGH INTERFERENCE FIT IAW EA 6-5315-103255 AND RAS: 046120/021/2006 ISS "A".SDR 07FDEA03090Frame · crackedCRACK IN DOUBLER FOUND IN HOLE H22 ON FRAME 45, STRG 26-28 LT REPAIR PERFORMED BY OVERSIZING, COLD WORKING AND INSTALLING NSA5359-5 FASTENER WITH HIGH INTERFERENCE FIT IAW EA 6-5315-103255 AND RAS: 046120/021/2006 ISS "A".SDR 07FDEA03089Frame · crackedDAMAGES, CRACKS AND CORROSION IN HOLE H4, H5, AND H6 AND MISDRILLED HOLE IN FITTING AND FRAME 44, BETWEEN STRG 26-27 LT REPAIR PERFORMED BY OVERSIZING HOLES, COLD WORKING, REPLACEMENT OF FITTING AND INSTALLING FASTENERS (NSA5357-5) WITH HIGH INTERFERENCE FITSDR 07FDEA03087Frame · crackedCRACK FOUND IN FRAME 43 LT, STR 26-27 LT REPAIR PERFORMED BY REPLACEMENT OF FITTING IAW SRM 53-15-18/FIG 1 AND EA 6-5315-03255.SDR 07FDEA03083Frame · crackedTWO CRACKED HOLES (H1, H2) WERE FOUND AT FRAME 43, STRG 26-27 RT, REPAIR PERFORMED BY REPLACING FITTING AND APPLY SB A310-53-2124 ON THE NEW FITTING HOLES IAW EA 6-5315-103254.SDR 07FDEA03082Frame · crackedCRACKED HOLE (H22) IN UPPER FRAME FEET AT FRAME 45, STRG 26-27 RT REPAIR PERFORMED BY OVERSIZING, COLD WORKING AND INSTALLATION OF FASTENER WITH HIGH INTERFERENCE FIT IAW EA 6-5315-103254 AND RAS: 046149/010/2006 ISS "A"SDR COEA0751821Frame · crackedFOUND DURING HEAVY CHECK. MAJOR REPAIR: FUSELAGE RT FRAME 27 IS CRACKED AT UPPER BOX AFT INTERCOSTAL ATTACHMENT. REMOVED DAMAGED AREA AND STRESS RELIEVED IAW ATR SRAS, DO/TS-3941/07, 4264. REF: NOTE DO/TS 5198/07. WO 72242, NR 200014. (K)SDR UPS07550652Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT, FUSELAGE FRAME STA 1500, S25L. REPAIRED IAW SRM 53-00-07 THIS REPAIR IS A CATEGORY -B- REPAIR PER DETAIL V FIG 201 (SHT 12 OF 15) PG 212. INSPECTION REQUIREMENTS AS SHOWN IN TABLE II FIG 201 (SHT 10 OF 15) PG SDR UPS07550651Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT, FUSELAGE FRAME STA 1540, BETWEEN S25L AND S26L. REPAIR AT STA 1540, S25L AND S26L WERE ACCOMPLISHED IAW SRM 53-00-07 DETAIL I, FIG 201 (SHT 4 OF 15). THIS IS A CATEGORY -B- REPAIR AND REQUIRES REINSPECTION IAWSDR UPS07550650Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1520, BETWEEN S25R AND S26R. REPAIRED DENT IAW SRM 53-00-07, THIS IS A CATEGORY B, ZONE 1, M PER DETAIL V, TABLE II PG'S 212 AND 210 FIG 201 10 OF 15. REPAIR ACCOMPLISHED PER DETAIL I FIG 201SDR 2007UALA03355Attach Angle · crackedPASSENGER CABIN STA 294 STR 12L FRAME ATTACH ANGLE CRACKED ON LOWER SIDE. MAJOR REPAIR ACCOMPLISHED: REMOVED, FABRICATED & INSTALLED INTERCOSTAL WEB.SDR SWAA074180Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND L2 DOOR LOWER STUB FRAME CRACKED AT BS 296. REPAIRED FRAME PER SRM.SDR 07FDEA03078Frame · failedON AGING, A/C INSP FOUND EXISTING REPAIR ON FRAME AT BS 700 BETWEEN STR 24L AND 26L DID NOT CONFORM TO SRM 51-40-3. REMOVED EXISTING REPAIR, FABRICATED REPAIR, HFEC FRAME TRIM OUT, NO CRACKS EXIST. INSTALLED FORMED REPAIR. REF FED EX EA 7-53-113940. THIS ISDR 07FDEA03072Frame · corrodedCORROSION FOUND ON REEINFORCING ANGLE FRAME 38.1-39, STRG 54 LT. REPAIR PERFORMED BY REPLACEMENT OF ANGLE WITHOUT CUTTING OF FRAME IAW EA 6- 5314-101270 AND RAS/DABRE/7006844/2006 ISS "A".SDR 2008UALA04372Frame · damagedFOUND CIRC FRAME ABOVE DOORS 1L & 1R, BS 460 STR 14-STR 15 HAS SHORT EDGE MARGIN FOR FASTENER INSTALLATION FOR EXTERNAL DOUBLER. *S/D* MAJOR REPAIR ACCOMPLISHED: MANUFACTURED & INSTALLED STRAPS FWD AND AFT OF FRAMES AT BS 460. ALSO MANUFACTURED & INSTALLEDSDR ABXA070280Frame · crackedWHILE COMPLYING WITH EA 53300036, FOUND FRAME CRACKED. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070279Frame · crackedWHILE COMPLYING WITH EA 53300036, FOUND CRACKED FRAME. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070278Frame · crackedWHILE COMPLYING WITH EA 53300036, FOUND CRACKED FRAME. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR SWAA074154Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074153Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074161Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 14L. REPAIRED FRAME PER SRM.SDR AMWA25033GFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1SDR AMWA25033FFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1.SDR AMWA25033EFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1.SDR AMWA25033DFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1.SDR AMWA25033CFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1.SDR AMWA25033BFrame · chafedFUSELAGE FRAME HAS FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1.SDR AMWA25033AFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-1.SDR AMWA25033IFrame · chafedFUSELAGE FRAME DAMAGED BY CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-2, REV 1R DATED AUG 1, 2007.SDR AMWA25033HFrame · chafedFUSELAGE FRAME HAD FRICTION CHAFING. REPAIRED IAW ENGINEERING REPORT 6829-2.SDR 07FDEA03055Frame · misrepairedON AGING A/C INSP FOUND EXISTING REPAIR ON FRAME 720A BETWEEN STR 24L AND 25L DID NOT CONFORM TO SRM 51-40-3. REMOVED EXISTING REPAIR, FABRICATED FORMED SECTION REPAIR REF SRM 51-40-3 AND INSTALLED REF FED EX EA NR 7-5310-113941 THIS IS CLASSIFIED AS A MAJOR SDR 07FDEA03052Frame · misrepairedON AGING A/C INSP, FOUND EXISTING REPAIR ON FRAME 680 BETWEEN STR 22L AND 25L DID NOT CONFORM TO SRM 51-40-3. REMOVED EXISTNG REPAIR, REMOVED EXISTING SLICE PLATE AT STR 25L. FABICATED REPAIR AND INSTALLED REF SRM 51-40-3 AND FED EX EO NR 7-5310-113081 THIS SDR 07FDEA03024Frame · corrodedCORROSION AT CROSSBEAM FRAME 87 RT AFT FACE, OUT OF LIMIT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03023Frame · chafedCHAFING MARK ON THE INNER FLANGE OF FRAME 38.2 BETWEEN STRG 14-15 LT. REPAIR PERFORMED BY BLEND OUT AND INSTALLING A REPAIR ANGLE AS PER SRM 53-10-13/FIG 202 IAW EA 6-5310-103329 AND RAS/DABRE/7006981/2006 ISS "A".SDR 07FDEA03021Frame · chafedCHAFING MARKS ON THE INNER FLANGE OF FRAME 22 BETWEEN STRG 14-15 RT. REPAIR PERFORMED BY BLEND OUT AND INSTALLING A REPAIR ANGLE AS PER SRM53-10-13/FIG 202 IAW EA 6-5310-103329 AND RAS/DABRE/7006981/2006 ISS "A".
Back to JASC 5311