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 2008UALA01513Frame · dentedAFT PIT FS 1500 STR 26L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED FRAME REPAIR.SDR 2008UALA01512Frame · dentedAFT PIT FS 1520 STR 26L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED FRAME REPAIR.SDR 2008UALA01511Frame · dentedAFT PIT FS 1440 FRAME DENTED AT STR 25L AND 26L. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED FRAME REPAIR.SDR SWAA081471Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 335, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA081461Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500D, STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081460Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, STR 28L. REPAIRED FRAME PER SRM.SDR SWAA081456Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR 08FDEA00995Frame · corrodedAFT PIT FRAME 69 HAS CORROSION ON THE UP RIGHT DAM ABOVE STR 55 LEFT. REMOVED CORROSION IAW SRM 51-74-10; CHECKED LIMITS IAW SRM 51-74-10. FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. REMOVED DAMAGED PARTS IAW SRM 51-40-21. RECIEVED NEW PART (WEB). LOCATED ANSDR USAA920080799Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - A .25" CRACK ON FRAME AT BS 500F BETWEEN STR 8L AND STR 9L. INSTALLED REPAIR IAW SRM TR 53-10-20E.SDR DHL2008763523Frame · dentedFRAME DAMAGED IN CARGO COMPT AT BS 347, ALONG STR 4L. CUT OUT DAMAGE, INSTALLED FRAME REPAIR PARTS, P/N AE727-2-360-11 AND AE727-2-360-12, PO NR 810972, PER B727 SRM 51-30-5, 51-30-2, AND AEI DWG AE727-2-360 REV G.SDR SWAA081417Beltframe · wornDURING SCHEDULED 8Y CHECK, FOUND BELTFRAME WORN AT BS 335, STR 5R. REPAIRED FRAME PER SRM.SDR SWAA081418Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 47R. REPAIRED FRAME PER SRM.SDR SWAA081419Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 990, RBL 38. REPAIRED WEB PER SRM AND BOEING DRAWING.SDR 2008UALA01475Frame · dentedFWD PIT, LEFT SIDE STA 660 BETWEEN STR 25 AND 26L, MAIN FRAME HAS DENT INTO RADIUS UPPER BEND. ACCOMPLISHED A MAJOR REPAIR AT ORD.SDR 2008UALA01474Frame · dentedFORWARD PIT, LT SIDE, STA 580 BETWEEN STR 24L AND 25L, MAIN FRAME IS DENTED 3 PLACES, WITH ONE INTO FRAME UPPER RADIUS BEND. ACCOMPLISHED MAJOR REPAIR AT ORD.SDR 2008UALA01473Frame · crackedFRAME WEB CRACKED AT UPPER SHEAR TIE FASTENER BELOW STR 13R AT BS 360. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED NESTED ANGLE FRAME SPLICE REPAIR.SDR KCSA081177Strap · crackedAFT BILGE FUSELAGE FRAME STABILIZATION STRAP IS CRACKED AT STA 2160, LBL 28.SDR KCSA081176Strap · missingAFT BILGE FUSELAGE FRAME STABILIZATION STRAP IS MISSING A SECTION AT STA 2160, LBL 6.SDR QXEA200800308Frame · corrodedPDX - C4- SUSPECT CORROSION ON FRAME CASTELLATION FWD SIDE AT STA X435.5 AND STR 24P LT UNDER FLOOR. REMOVED CORROSION IAW CPCM CHAPTER 4. HFEC INSPECTED BLEND AREA FOR CRACKS IAW NDTM PART 6, 51-00-01. NO CRACKS NOTED. UT THICKNESS CHECK BLENDED AREA IAW SDR 2008UALA01413Frame · crackedCABIN FRAME BS 303.9 IS CRACKED ON AFT SIDE DOUBLER AT FEED THROUGH FOR STR 16L. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED FRAME REPAIR ANGLE REPAIR. REPAIR OF INTERCOSTAL - FABRICATED AND INSTALLED 2 CLIPS & 2 ANGLES, 1 H-STRAP & 1 FRAME DOUBLER.SDR QXEA200800290Frame · corrodedPDX-C4 - FRAME CASTELLATION ON FRAME X136.0 BETWEEN STRINGERS 27P AND 28P HAS SUSPECT CORROSION AROUND RIVET TAILS. REMOVED RIVETS(3) IAW DASH 8 Q400 SRM 51-42-05. REMOVED CORROSION IAW Q400 SRM 51-21-00. HFEC INSPECTED BLENDED AREA FOR CRACK IAW Q400 NDTM SDR QXEA200800294Frame · corrodedPDX - C4 - SUSPECT CORROSION AT STA 176 ON FRAME, INBOARD OF STRINGER 31L. REMOVED RIVETS (4) AND BLENDED OUT CORROSION IAW Q400 SRM 51-42-05 AND 51-21-00. HFEC INSPECTED BLENDED AREA FOR CRACKS, IAW Q400 NDTM PART 6, 51-00-01, NO CRACKS NOTED. UT THICKNESSSDR 08FDEA00921Frame · corrodedFWD CARGO COMPARTMENT BILGE AREA; FS 899 FRAME LOWER FLANGE UPPER SURFACE HAS LIGHT CORROSION; STR 51R - 51L. REMOVED CORROSION IAW SRM 51-21-01; VOL II; PG 28 AT STA 899 STR 51R - 51L FRAME FLANGE. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-01;FIG 1A. ORIGINASDR SWAA081405Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA081394Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081404Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081406Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA081403Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500B, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA081392Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 24L. REPAIRED FRAME PER SRM.SDR USAA920080773Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME, BS 827, S8L - S9L IAW USAIRWAYS EO 5311-01019.SDR USAA920080739Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 747, S8L - S9L. REPAIRED FRAME, BS 747, S8L - S9L IAW USAIRWAYS EA 5311-01019.SDR USAA920080738Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 727D, S8L - S9L. REPAIRED FRAME, BS 727D, S8L - S9L IAW USAIRWAYS EA 5311-01019.SDR USAA920080737Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 500A, S8L - S9L. REPAIRED FRAME, BS 500A, S8L - S9L IAW USAIRWAYS EA 5311-01019.SDR USAA920080736Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 867, S8L - S9L AND S8R - S9R. REPAIRED FRAME, BS 867, S8L - S9L AND S8R - S9R IAW USAIRWAYS EA 5311-01019.SDR USAA920080735Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 787, S8L - S9L AND S8R - S9R. REPAIRED FRAME, BS 787, S8L - S9L AND S8R - S9R IAW USAIRWAYS EA 5311-01019.SDR USAA920080734Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 480, S8L - S9L AND S8R - S9R. REPAIRED FRAME, BS 480, S8L - S9L AND S8R - S9R IAW USAIRWAYS EA 5311-01019.SDR USAA920080732Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 440, S8L - S9L AND S8R - S9R. REPAIRED FRAME, BS 440, S8L - S9L AND S8R - S9R IAW USAIRWAYS EA 5311-01019.SDR USAA920080731Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 400, S8L - S9L AND S8R - S9R. REPAIRED FRAME, BS 400, S8L - S9L AND S8R - S9R IAW USAIRWAYS EA 5311-01019.SDR 08FDEA00913Frame · dentedMAIN DECK LT FRAME AT STA 535 L20 FOUND DENTED. DENTED AREA REPAIRED AS PER DWG SRZ-53- 503. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR 08FDEA00912Frame · dentedMAIN DECK LT FRAME AT STA 535 L24 FOUND DENTED. DENTED AREA REPAIRED AS PER DWG SRZ-53-503. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR 08FDEA00911Frame · dentedMAIN DECK FRAME AT RT STA 1701 L12 FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIG. 1 VOL.I. INITIAL INSPECTION AT 14500 CYCLES AND REPETITIVE INSPECTION AT 9500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-SDR 08FDEA00910Frame · dentedMAIN DECK FRAME AT RT STA 1681 L12 FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIG. 1 VOL.I. INITIAL INSPECTION AT 14500 CYCLES AND REPETITIVE INSPECTION AT 9500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR AS PER GMM SDR 08FDEA00909Frame · dentedMAIN DECK FRAME AT RT STA 1661 L12 FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIG. 1 VOL.I. INITIAL INSPECTION AT 14500 CYCLES AND REPETITIVE INSPECTION AT 9500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER GMSDR SWAA081373Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081366Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081368Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 20L. REPAIRED FRAME PER SRM.SDR KCSA081172Strap · crackedAFT CARGO PIT FUSELAGE FRAME STABILIZATION STRAP CRACKED BETWEEN BS 7150 AND 1770, LBL 83, WL 135.SDR CALA0800310Frame · damagedTWO RIVET HEADS SHEARED OFF ON AFT SIDE OF FRAME STA 348 AND THE AREA OF STR 12 LT (MARKED). REPLACED 2 RIVETS THAT WERE SHEARED OFF ON AFT SIDE OF FRAME AT STA 348 AND STR 12 LT PER PACE EA 641-53-001 CAL AND EC/RA 5310-04742.SDR USAA920080686Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - R1 DOOR CUTOUT FORWARD UPPER STUB FRAME CRACKED, BS 294, S7R, WL 276. REPLACED R1 DOOR CUTOUT FORWARD UPPER STUB FRAME CRACKED, BS 294, S7R, WL 276 IAW B737 SRM 51-40-02.SDR LR7A08042Frame · crackedDURING SCHEDULED B-1 CHECK, PER JOB CARD HB5302, FOUND CABIN BULKHEAD INBD FRAME CRACKED AT FS 814, WL176, RBL 67. REPAIR ACCOMPLISHED IAW SMP583 FIG 53-50-14.
Back to JASC 5311