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 SWAA063748Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063745Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 747, STR 26R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR DHL2006770506Frame · dentedFORWARD CARGO COMPARTMENT, BS 720C, STR 26R, DENT IN FRAME RADIUS. CUT OUT DAMAGED AREA SIZE 1.50 INCH BY 1.50 INCH IAW SRM 51-40-3 FIG 1. FAB DOUBLER WITH 7075-0, .071, SIZE 15 INCHES BY 4 INCHES, PO NR 9003817 IAW SRM 53-10-2 FIG.3 AND 51-40-3 FIG.1. HEAT TSDR DHL2006770504Frame · dentedFORWARD CARGO COMPARTMENT, BS 660, STR 27R, DENT IN FRAME RADIUS. CUT OUT DAMAGED AREA SIZE 1.25" BY 1.625" IAW B727 SRM 51-40-3 FIG 1. FAB DOUBLER WITH 7075-0, .071, SIZE 15" BY 4", PO NR 9003817 IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. HEAT TREATED DSDR DHL2006770510Frame · dentedFORWARD CARGO COMPARTMENT BS 680, STR 26R, DENT IN FRAME RADIUS. CUT OUT DAMAGED AREA IAW SRM 51-40-3 FIG.1. FABRICATED DOUBLER IAW SRM 53-10-2 FIG.3 AND 51-40-3 FIG.1. HEAT TREATED DOUBLER IAW ENGINEERING REPORT NR 2-37153-801 REV.IR. INSTALLED REPAIR PARTS SDR DHL2006770503Frame · dentedFORWARD CARGO COMPARTMENT BS 680, STR 26R, DENT IN FRAME RADIUS. CUT OUT DAMAGED AREA IAW B727 SRM 51-40-3 FIG 1. FAB DOUBLER WITH 7075-0, .071, SIZE 15 INCHES BY 4 INCHES, PO 9003817 IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. HEAT TREATED DOUBLER FROM 7SDR DL76L060806Frame · crackedTHE FUSELAGE FRAME, LOWER END HAS A CRACK, STA 903 LT SIDE. THE DAMAGED END OF THE FRAME WAS REMOVED AND A REPAIR ANGLE WAS INSTALLED.SDR DU4R2006640Frame · corrodedCORROSION ON CANT 1463 LT BOTTOM OF CANT. FABRICATED AND INSTALLED REPAIR SPLICES 1 7-3/4" AND 3/4" AND 5/8", 2 6-3/8" BY 5/8" BY 5/8" FROM 7075-T6 .050" AND 1 9-1/4" BY 1/2" BY 3/4" FROM 7075-T6511 EXTRUSION IAW DC-9/MD-80 SRM 53-01 FIG 1, DELTA PS 900-4-01 SDR SWAA063733Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 26L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063726Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CORRODED AT BS 847, STR 24R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 06FDEA03470Frame · bentMAIN DECK CARGO, FRAME AT RT INTERIOR FUSELAGE STA 1761, L11-13 FOUND BENT. REPAIR CARRIED OUT AT MAIN DECK CARGO FRAME, RT INTERIOR FUSELAGE STA 1761, L11-13 AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 1060731037CFrame · corrodedCORROSION, FRAME AFT FACE. FS 288.0 AT APPROX. LBL 26.0 AND RBL 25.0. FOUND DURING INSPECTION REPAIRED IAW MFG FR.CO.01399 REV. 1.SDR 1060731037BFrame · corrodedCORROSION FUSELAGE FRAME AT FS 213.25 (LBL 8.4) CORROSION FOUND DURING INSPECTION. REPAIRED IAW MFG FR.CO.01423 REV. 1.SDR UPS06548279Frame · chafedINSPECTION TYPE:C MAIN CARGO DECK FUSELAGE FRAME AT STA 385 LT SIDE HAS CHAFE BETWEEN S STRINGERS 15-16 DAMAGE DIM. L= 0.104 W= 0.126 D= 0.045, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A FIG 101 DETAILS I II IV PER EO B757-5310-20559-B. REPAIRED FRAME SDR UPS06548278Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, S26R. CUT OUT DAMAGED SECTION STA 1340 RT S=26R. L=.95" X W=1.0". HFEC IAW NTM 51-00-00, NO CRACK INDICATIONS NOTED COMPLIED WITH EA 757-5362-27-A1548 & UPS EO B757-5310-25385A.SDR UPS06548277Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1300, S26R. REMOVED TRANS PNL, CUT OUT DAMAGE S=26R L=.95 X W1.10. HFEC IAW NTM 51-00-00 PT 6, NO CRACK INDICATIONS NOTED REPAIRED IAW EA 757-5362-27-A1547, UPS EO B757-5310-25366.SDR UPS06548276Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1240, BETWEEN S26R - S27R. TRIMMED OUT FUSELAGE FRAME STA 1240 BETWEEN S26R-S27R. DAMAGE 0.790"L X .0950"W. HFEC IAW NTM 51-00-00, NO CRACK INDICATION NOTED. ENLARGED TRIM OUT BY 0.04" NEW DIM. L=0.830SDR UPS06548275Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1300, S26L. REMOVED TRANS PNL STA 1200-1300 LT SIDE FOR ACCESS, CUT OUT DAMAGE SECT. L=1.25" W=1.0". REMOVED TIE DOWN FITTING HFEC IAW NTM 51-00-PL 6, NO CRACK INDICATIONS NOTED COMPLIED WITH EA 757-5362SDR UPS06548271Frame · chafedINSPECTION TYPE:C MAIN CARGO DECK FRAME AT STA 365 HAS CHAFE BETWEEN STR 15R-16R. PERFORMED PARTIAL BLEND OF AREA OF FRAME DIMENSIONS ARE AS FOLLOWS: L= .6, W= .6, D= .013, ORIGINAL DAMAGE STILL EVIDENT. REPAIR ACCOM ON EA 757-5332-27-A1557 AND UPS EO B757-5SDR UPS06548270Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1280, S25L. TRIMMED OUT FUSELAGE STA 1280 FLANGE DAMAGED PER EA 757-5362-27-A1550, STEP NR 1 DIMENSIONS ARE 0.590"L X 0.900"W. HFEC IAW NTM 51-00-00 PT 6 NO CRACK INDICATIONS NOTED. COMPLIED WITH FINAL SDR DU4R2006638Frame · corrodedCORROSION ON FITTING ON AFT SIDE OF APU BAY. REPAIRED BY FABRICATING AND INSTALLING FITTING 18-1/2" FROM 7075-T6511 EXTRUSION IAW DC-9/MD-80 SRM 51-30-5, 51-10-4 PARA 2, 51-10-3D PG 24, 25 AND DELTA PS 900-4-1 NR 1.SDR 06FDEA03467Frame · misdrilledFOUND INTERIOR CABIN, BS 720E FRAME HAS MISDRILLED HOLE 1" ABOVE STR 7L. REMOVED DAMAGE IN FRAME BS 720E STR 7L AND REPAIRED IAW SRM 53-10-4.SDR DL76S060791Frame · crackedFUSELAGE STATION 903.5 FRAME INNER CHORD FOUND CRACKED. ON BOTH LT AND RT AT TRANSITION BETWEEN CHORD FLANGES. AREA TRIMMED AND REPAIR INSTALLED.SDR CALA0600373Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN AFT CARGO DOOR CUTOUT FORWARD FRAME AT LOWER STOP FITTING, STA 794.3. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND 51-10-2.SDR 2007FA0000135Frame · crackedFRAME IS CRACKED AT BODY STATION 727, STRINGER 14L. (K)SDR 2007FA0000126Frame · crackedFRAME IS CRACKED AT BODY STAION 727, STRINGER 14L. (K)SDR SWAA063691Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063690Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 9R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063689Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FRAME SECTION PER SWA EA.SDR 06FDEA03460Frame · dentedFWD CARGO BAY DENT IN FRAME INNER FLANGE STA 660 BETWEEN STR 23R - 24R. REMOVED DAMAGE ON FRAME STA 660 BETWEEN STR 23R - 24R AND REPAIRED IAW SRM 51-40-3 AND 53-10-1.SDR 06FDEA03459Frame · dentedFWD CARGO BAY DENTS IN FRAME STA 600 BETWEEN STR 22L-25L. REMOVED DAMAGE ON FRAME BS 600 BETWEEN STR 22L - 25L AND REPAIRED IAW SRM 51-40-3.SDR 06FDEA03450Frame · crackedINTERIOR CABIN, BS 800 FRAME IS CRACKED AT STR 14R, AT RADIUS AREA. REMOVED FRAME SECTION BS 800 STR 14R TO 18R AND REPLACED IAW SRM 51-30-5 AND 51-30-2.SDR 06FDEA03455Frame · dentedAFT CARGO BAY FRAME DENTED BS 950F STR 25-26L. REMOVED DAMAGE ON FRAME BS 950F STR 25L-26L AND REPARIED IAW SRM 51-40-3.SDR 06FDEA03454Frame · dentedFWD CARGO BAY DENT IN FRAME FLANGE BS 500 STR 22 RT. ** SD ** COMING. REPAIRED FWD CARGO BAY FRAME AT BS 500 STR 22 RT IAW SRM 53-10-4.SDR 06FDEA03444Frame · dentedM/D CARGO LT STA 1721 FOUND FRAME DENT. REPAIR CARRIED OUT AT M/D CARGO LT BS 1721 FRAME AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA03443Frame · dentedM/D CARGO RT STA 1701 FOUND FRAME DENT. REPAIR CARRIED OUT AT M/D CARGO RH STA 1701 FRAME AS PER SRM 53-30--00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 2007FA0000125Frame · crackedUPPER FUSELAGE, BS 500A, BETWEEN STR 8R AND STR 9R, FRAME IS CRACKED AT PSU MOUNT. (K)SDR AWXA200601666Frame · crackedMCN - FOUND FORWARD CARGO COMPARTMENT OPENING AFT FRAME WEB CRACKED, BS 492.5, S24R. REPAIRED FORWARD CARGO COMPARTMENT OPENING AFT FRAME WEB CRACKED, BS 492.5, S24R IAW ER 03-5331-06267-SS1.SDR SWAA063674Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063673Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063672Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063670Strap · corrodedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME STRAP CORRODED AT BS 807, STR 25R. REMOVED AND REPLACED STRAP PER SRM.SDR 06FDEA03435Frame · dentedFWD CARGO BAY DENT IN I/B FLANGE OF FRAME STA 520 BETWEEN STR 24L - 25L. REMOVED DAMAGE IB FLANGE OF FRAME STA 520 BETWEEN STR 24L - 25L AND REPAIRED IAW SRM 51-40-03.SDR KCSA061363Frame · crackedFRAME CRACKED ON TOP CHORD RBL 61 STA 1720 WL 120.SDR KCSA061362Frame · crackedFRAME CRACKED AT STA 1700 RBL 56 WL 118.SDR KCSA061361Frame · bentFRAME BENT STA 1780 RBL 52 JUST ABOVE FLOOR.SDR KCSA061360Frame · corrodedFRAME CORRODED AT SKIN ATTACH ANGLE STA 1680 WL 180.SDR KCSA061356Frame · puncturedLOWER LOBE FRAME PUNCTURED STA 1740 LBL 50.SDR TRAX200600794Frame · corrodedLOWER PART OF FRAME 38 BETWEEN STR 21L AND 21R IS CORRODED. (RESOLVED ON W/O: 36809 TASKCARD: N/R-00305 ) CORROSION REMOVED ON LOWER PART OF FRAME 38 STR 21L-21R IAW SRM 51-21-42. REPAIRED FRAME 38 PER TC EO 72-53-0233. MATERIAL THICKNESS 0.063, MATERIAL RSDR ASAA0671017Frame · gougedFOUND AFT CARGO PIT STA 867 GOUGED REPAIRED IAW SRM 53 60 07 FIG 4 AND 51 70 11 FIG 202.
Back to JASC 5311