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 AWXA200500113Frame · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT SIDE OF FRAME AT BS 360, BETWEEN STR 27 LT AND STR 28 LT. MAINTENANCE REMOVED SHEAR TIE AND CUTOUT DAMAGE IN FRAME FOOT AT BS 360, BETWEEN STR 27 LT AND STR 28 LT; FABRICATED A NEW SDR SWAA043720Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, WL 201, RT SIDE. REPAIRED FRAME PER T1-153-018.SDR SWAA043719Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 15L TO STR 16L. REPAIRED FRAME PER BOEING SB.SDR 0402256719Frame · crackedDURING L-CHECK, FOUND CRACK IN FRAME AT BS 380 S24R. REPAIRED PER EA 67-165180.SDR 0402236719Frame · crackedDURING L-CHECK FOUND CRACK IN FRAME AT BS 400 S23L. REPAIRED PER EA 67-165182.SDR 2004UALA01248Frame · dentedDENT WAS FOUND ON THE UPPER I/B T-CHORD ON FRAME AT STA 900 APPROX LBL 20 IN THE FWD HORIZONTAL FLANGE OF THE CHORD. REPAIR ACCOMPLISHED.SDR COMA0560004Frame · crackedLEFT HAND FUSELAGE 718 CRACKED BETWEEN STRINGER 10 AND 12. REPAIRED IAW EO 53-027.SDR COMA0560003Frame · crackedRIGHT HAND 718 FRAME CRACKED. REPAIRED IAW EO 53-027.SDR COMA0560001Frame · crackedLEFT HAND FS FRAME 621.00 CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR 249TR0042Frame · damagedAFT CARGO FRAME DAMAGED ON UPPER FLANGE AT BS 787 ABOVE STRINGER 26RT. REPAIRED PER SRM 51-70-11.SDR SWAA043704Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 360, BETWEEN STRINGER 14R AND STRINGER 15R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043693Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH SHEAR TIES CRACKED FROM BS 360, STRINGER 13L AND BS 400, STRINGER 14L. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA043691Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FRAMES CRACKED AT BS 787, STRINGER 9R AND BS 827, STRINGER 9. REPAIRED FRAME SECTIONS PER SRM.SDR ASA0440350Frame · dentedPAE - FRAME DAMAGED. REMOVED DAMAGED FRAME, FABRICATED REPAIR, INSTALLED FRAME. (M)SDR SWAA043690Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 727E, STRINGER 9R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA043688Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT FRAME AT BS 492, STRINGER 24R, CRACKED. REPAIRED FRAME PER ER.SDR SWAA043687Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 663, STRINGER 2R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043683Frame · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH FUSELAGE FRAMES CRACKED BETWEEN BS 867 AND BS 787, STRINGER 9L AND BS 787, STRINGER 9R. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA043682Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 907, STRINGER 8L, CRACKED. REPAIRED FRAME SECTION SRM.SDR SWAA043678Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 827, STRINGER 9R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR MALA040897Frame · chafedDURING 4K INSPECTION IN BNA, INNER FLANGE OF FRAME AT FS 686.888 HAS BEEN CHAFFED OUT OF LIMITS BY CARGO DOOR CABLE. DAMAGE HAS BEEN REPAIRED IAW MESABA EO NR S53275. REFER EAMS WORK ORDER NR 211236/TASK 2584 FOR ADDITIONAL INFORMATION. AIRCRAFT RETURNED TOSDR QXEA200400905Strap · gougedPDX - GOUGE IN INNER, UPPER FRAME STRAP ON UPPER AFT CORNER OF MAIN CABIN DOOR FRAME STRUCTURE AT FS 349.00. REPAIRED IAW HORIZON AIR EA R-53-247.SDR 04FDEA03437Frame · corrodedFLT CREW COMPARTMENT LEFT SIDE AT FS 227.8 FRAME HAS 2 EACH AREAS OF CORROSION ABOVE AND BELOW OXYGEN PANEL. REMOVED DAMAGE AREA IAW SRM 51-40-2, MADE NEW WEB FROM 7075-T6 .125C BATCH 0000828965 & DOUBLER MADE FROM 7075-T6 .160C BATCH 0000687676 IAW SRM 51SDR ASAA0480617Frame · gougedOKC - HV-CHECK, MOUNTING HOLES GOUGED AT BOTTOM FRAME OF RIGHT OVERWING EXIT. INSTALLED DOUBLER PER EA 5320-01680. (M)SDR 2004UALA01223Frame · dentedFWD PIT STA 580 AND BETWEEN STR 24L AND 25L, FRAME HAS DENT. INSTALLED "J" ANGLE REPAIR ON TOP OF FRAME.SDR SWAA043652Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME AT BS 616, STRINGER 17R, CRACKED. REPAIRED FRAME SECTION PER EA.SDR SWAA043646Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FRAMES CRACKED BETWEEN BS 827 AND BS 867, STRINGER 9R. REPAIRED FRAME SECTIONS PER SRM.SDR COMA0460689Frame · crackedRIGHT 640 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-487.SDR COMA0460693Frame · crackedLEFT HAND 621.00 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR COMA0460687Frame · crackedRIGHT HAND 621.00 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-117.SDR ASA0440331Frame · damagedPAE - FOUND FRAME DAMAGED. REPAIRED PER SRM. (M)SDR 2004UALA01220Frame · dentedAFT PIT FRAME DENTED AT STA 1320 NEAR STR 26L AT INBOARD FLANGE. REPAIRED FRAME WITH INNER NESTED J-ANGLE.SDR 2004UALA01219Frame · dentedAFT PIT FRAME DENTED STA 1420 BY STR 26L. REPAIRED FRAME WITH NESTED "J" ANGLE REPAIR.SDR 2004UALA01218Frame · corrodedFRAME WEB CORRODED OUT OF LIMITS AT STA 1400 RT BETWEEN STR 28R AND 29R. REPLACED FRAME SECTION.SDR SWAA043635Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 827, STRINGER 8L, CRACKED. REPAIRED FRAME PER SRM.SDR COMA0460686Doubler · crackedRIGHT HAND 640 FRAME DOUBLER CRACKED. REPAIRED IAW SRM 51-44-06 AND 51-42-21.SDR COMA0460685Frame · crackedLEFT HAND FUSELAGE 718 CRACKED BETWEEN STRINGER 11 AND 12. REPAIRED IAW EO 53-027.SDR COMA0460684Frame · crackedRIGHT HAND FUSELAGE 718.00 CRACKED AT 2 LOCATIONS BETWEEN STRINGERS 10 AND 12. REPAIRED IAW EO 53-027.SDR ASA0440326Frame · dentedPAE - FOUND DENT ON TOP OF FRAME FLANGE. REPLACED FLANGE. (M)SDR ASA0440316Frame · dentedPAE - DENT AFT CARGO BAY FRAME. REPAIRED FRAME PER SRM. (M)SDR ASA0440317Frame · dentedPAE - FOUND DENT ON TOP OF FRAME. REPAIRED FRAME PER SRM. (M)SDR ASA0440319Frame · damagedPAE - FOUND FRAME DAMAGED. REPAIRED PER SRM. (M)SDR 0402159943Frame · crackedDURING "M" CHECK, FOUND CRACK IN FUSELAGE FRAME AT FS 408 L16R TO L18R. REPAIRED PER EA 99-201809.SDR SWAA043621Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPT FRAME AT BS 767, RBL 12, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043619Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPT FRAME AT BS 727E, BETWEEN RBL10 AND RBL 20, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043618Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPT FRAME AT BS 500B, BETWEEN LBL 6 AND RBL 6, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASA0440312Frame · dentedPAE - FOUND DENT ON TOP OF FRAME FLANGES. REPAIRED PER SRM. (M)SDR ASAA0440313Frame · dentedPAE - FOUND DENT ON TOP OF FRAME FLANGES. REPAIRED PER SRM. (M)SDR ASA0440305Frame · crackedPAE - FOUND FRAME CRACKED. REPLACED PER EA. (M)SDR CALA0400742Frame · corrodedINSPECTION FOUND FORWARD SIDE OF FRAME CORRODED IN FORWARD CARGO PIT AT STA 500D BETWEEN S27L AND S28L. INSTALLED REPAIR IAW SRM 53-00-07, FIGURE 205.
Back to JASC 5311