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 2005UALA00418Frame · dentedAFT PIT FRAME DENTED STA 1560, STR 26L. FRAME DENT WAS TRIMMED OUT AND J ANGLE REPAIR INSTALLED.SDR 2005UALA00417Frame · dentedAFT PIT FRAME DENTED STA 1440, STR 26L. FRAME DENT WAS TRIMMED OUT AND J ANGLE REPAIR INSTALLED.SDR 2005UALA00416Frame · dentedFWD PIT FRAME DENTED STA 600, STR 24L. FRAME DENT WAS TRIMMED OUT AND J ANGLE REPAIR INSTALLED.SDR 2005UALA00414Frame · dentedAFT PIT FRAME DENTED STA 1420 BETWEEN STR 25 & 26 LEFT. DAMAGE WAS CUTOUT OF FRAME AND REPAIR ANGLES INSTALLED.SDR SIMA200515102Frame · crackedABI - DURING AN INSPECTION, FOUND FRAME 81 TO BE CRACKED. REMOVED THE CRACKED FRAME AND INSTALLED NEW FRAME IAW EMB SRM, SRM 145/1142 REV 29, CHAPTER 51-40-02. (M)SDR VTZA200500071Frame · crackedLEFT FS 640 FRAME IS CRACKED IN RADIUS AT 1 INCH IN LENGTH.SDR SWAA051318Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051328Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9R. REPAIRED FRAME PER SRM.SDR USAA050582Frame · damagedCLT - FRAME HAS PREVIOUSLY REPAIRED DAMAGE UNKNOWN, STATION 787 BETWEEN STRINGER 8R AND 9R. REPAIRED PER SRM 53-00-01 FIG 202. (M)SDR AWXA200500618Frame · crackedDURING C-14 CHECK, FRAME AT BS 663.75 WAS FOUND CRACKED AT STRINGERS 1 LT, 2 LT, AND 3 LT. MAINTENANCE REPAIRED FRAME AT BS 663.75, AT STRINGERS 1 LT, 2 LT, AND 3 LT IAW B737-300 SRM 53-00-07-2, FIGURE 209.SDR 72300182Frame · corrodedA 1 X 1 INCH AREA OF CORROSION ON FRAME.SDR 2005UALA00408Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 616 BELOW STR 17R. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE AND INSTALLED ANGLE DOUBLER.SDR SWAA051324Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA051323Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051327Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051326Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR AWXA200500600Frame · crackedDURING C-14 CHECK, BS 178 BULKHEAD CHORD, LT SIDE AT WL 207, WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED BULKHEAD CHORD IAW B737-300 SRM 51-40-02-0 FIGURES 8 AND 12.SDR C2XA05TY039Frame · bentTYS - DURING A SCHEDULED INSPECTION FRAME 72, BETWEEN STRINGERS 15R AND 16R IN THE BAGGAGE COMPARTMENT WAS FOUND BENT. MAINTENANCE REMOVED AND REPLACED THE FRAME IAW EMB-135/145 SRM 51-40-02.SDR SWAA051314Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051313Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051310Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FUSELAGE FRAME AT BS 767, STR 27L TO STR 25R. REPAIRED FRAME PER SRM.SDR SWAA051307Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FRAME CHORDS CRACKED AT BS 616, LBL 65 & RBL 65, WL 202. REPAIRED FRAME CHORDS PER BFG ER.SDR SWAA051305Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON AFT CARGO FWD STUB FRAME AT BS 794.3, STR 24R TO STR 25R. REPAIRED STUB FRAME PER SWA EA.SDR 84Frame · crackedCRACKED FRAME AT BS 294.5, WL 208.1 FWD GALLEY DOOR.SDR 81Frame · crackedLOWER FWD SIDE OF FRAME AT STA 616 S-16R CRACKED AT LOWER FASTENER.SDR UPS05844685Frame · corrodedSTA 1160 SEVERE CORROSION ON BASE OF FRAME AT L33L. REMOVED, FABRICATED AND INSTALLED IAW SRM 51-1-20D, 51-1-20 D, DWG 3755842 AND SK808-785521.SDR AWXA200600249Frame · damagedPHX - FORWARD CARGO LOADING SYSTEM, AT BL 0, FROM STA 720 THROUGH STA 820, FRAMES DAMAGED BY LOADING JACK SCREW. MAINTENANCE TRIMMED OUT DAMAGE AREA IAW AWA ER 19-5332-05121-RA2. FABRICATED REPAIR ANGLES AND FRAME CLIPS IAW AWA ER NR 19-5332-05121-RA2. INSTSDR USAA050578Frame · corrodedCLT - FOUND A FRAME CORRODED, FS 294.5-S16L. INSTALLED REPAIR DOUBLER IAW SRM 57-70-11. (M)SDR USAA050565Frame · crackedCLT - FOUND FRAME CRACKED, BS 727E BETWEEN S24R AND S25R. REPAIR PCW IAW SRM 53-00-07. (M)SDR USAA050564Frame · crackedCLT - FOUND FRAME CRACKED, BS 727B BETWEEN S22L AND S24L. REPAIR PCW IAW SRM 53-00-07. (M)SDR USAA050560Frame · crackedCLT - FOUND FRAME CRACKED 1 INCH BS 500 FRAME RBL 1. CUT OUT CRACKED AREA OF FRAME. FABRICATED AND INSTALLED REPAIR IAW SRM 51-70-11. (M)SDR MALA050411Frame · dentedDURING C1, C2 INSPECTION IN YYC FOUND DENT AND GOUGE LT SIDE FUSELAGE FRAME 25 (ABOUT 5 INCHES AFT OF FRAME 25) BELOW CABIN WINDOW.SDR LR7A05090Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 470 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LEFT FS 470 WL 162 BL 68.SDR LR7A05089Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 457 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LEFT FS 457 WL 162 BL 68.SDR LR7A05088Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RIGHT FS 431, WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, RIGHT FS 431 WL 162 BL 68.SDR LR7A05087Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RIGHT FS 424 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, RIGHT FS 424 WL 162 BL 68.SDR LR7A05086Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 421 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LEFT FS 421 WL 162 BL 68.SDR LR7A05085Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 414 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LT FS 414 WL 162 BL 68.SDR LR7A05084Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 391 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LEFT FS 391 WL 162 BL 68.SDR LR7A05083Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 384 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LT FS 384 WL 162 BL 68.SDR LR7A05082Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 371 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LEFT FS 371 WL 162 BL 68.SDR LR7A05081Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 364 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LT FS 364 WL 162 BL 68.SDR LR7A05080Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LEFT FS 357 WL 162 BL 68. FRAME REPAIRED IAW R05-009-06, LAC MEA 382-53-05-048, LEFT FS 357 WL 162 BL 68.SDR LR7A05079Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 437 WL 162 BL 68. FRAME REPAIRED IAW R05-009-05, LAC MEA 382-53-05-047, LEFT FS 437 WL 162 BL 68.SDR LR7A05078Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT & RT FS 377 WL 162 BL 68. FRAME REPAIRED IAW R05-009-05, LAC MEA 382-53-05-047, RIGHT FS 687 WL 162 BL 68.SDR LR7A05077Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RIGHT FS 324 WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, RIGHT FS 324 WL 162 BL 68.SDR LR7A05076Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RT FS 317 WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, RIGHT FS 317 WL 162 BL 68.SDR LR7A05075Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT RIGHT FS 310 WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, RIGHT FS 310 WL 162 BL 68.SDR LR7A05074Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT FS 290 WL 176 BL 77. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LEFT FS 290 WL 176 BL 77.SDR LR7A05073Frame · damagedDURING SCHEDULED C-6 CHECK INTERIOR FUSELAGE FRAMES FOUND EXCESS & ELONGATED HOLES AT LT & RT FS 284 WL 162 BL 68. FRAME REPAIRED IAW R05-009-04, LAC MEA 382-53-05-046, LT & RT FS 284 WL 162 BL 68.
Back to JASC 5311