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 USAA060371Frame · crackedFOUND CRACK BS 380 BETWEEN S-8R AND S-9R AT OVERHEAD BIN LOWER ATTACH. CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES IAW TR 53-10-20C, DEFECT SIZE: .125 INCH.SDR USAA060382Frame · crackedFOUND FRAME CRACKED LT BODY STA 480. REMOVED AND REPLACED PSU BRACKET WITH FABRICATED PARTS IAW TR 53-10-20C, DEFECT SIZE: .250 INCH.SDR USAA060384Frame · crackedFOUND CRACK AT FRAME STA 827 BETWEEN S8L. FABRICATED FRAME REPAIR ANGLES AND INSTALLED PER T/R 53-10-20C, DEFECT SIZE: .125 INCH.SDR USAA060385Frame · crackedFOUND CRACK STA 807 BETWEEN S8L-9L AT OVERHEAD BIN LOWER ATTACH POINT. REMOVED AND REPLACED FRAME SUPPORT BRACKETS IAW TR 53-10-20C, DEFECT SIZE: 1 INCH.SDR 06FDEA0884Frame · corrodedFOUND FRAME AT STA 950E AND STRINGER 29L IS CORRODED. REMOVED DAMAGE, FABRICATED, ALODINED, PRIMED AND INSTALLED FRAME REPAIR AT STA 950E BETWEEN S28L AND S29L ALL IAW FX B727 SRM'S 53-10-4 FIG 12, 53-10-1, 53-10-2, 51-30-2, 51-10-6 AND 51-10-2, SNRM N00986.SDR UPS06547194Frame · dentedINSPECTION TYPE:CK DENT IN AFT CARGO FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1369 AND UPS EO NR B757-5310-239 64A - NO DEVIATIONS FROM FINAL EA. NOTE: SEE ECA STEP 18 FOR REPAIR DIMENSIONS.SDR UPS06547193Frame · dentedINSPECTION TYPE:CK DENTS IN AFT CARGO FUSELAGE. REPAIRED DAMAGED AREA IAW EA FINAL 757-5362-27-A1353.SDR UPS06547192Frame · dentedINSPECTION TYPE:CK DENTS IN AFT CARGO FUSELAGE. COMPLIED WITH EA NR FINAL 757-5362-27-A1358 REV.SDR UPS06547191Frame · dentedINSPECTION TYPE:CK AFT CARGO FUSELAGE FRAME HAS DENT. CUT OUT DAMAGE AREA, 1 IN X 1.2 IN X .045 DEEP, OF FRAME PER PRELIMINARY NR 2 EA 757-5362-27-A 1349. HFEC INSPECTION NO CRACKS FOUND IAW WTM PT6 51-00-00. FABBED REPAIR ANGLE IAW NR T61585875, MATERIAL 7SDR UPS06547190Frame · dentedINSPECTION TYPE:CK DENTS IN AFT CARGO FUSELAGE. COMPLIED WITH EA FINAL B757-5362-27-A1362.SDR UPS06547188Frame · dentedINSPECTION TYPE:CK DENT IN AFT CARGO FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1347 REV.SDR UPS06547187Frame · dentedINSPECTION TYPE:CK DENT IN AFT CARGO FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1363 APPLIED CC IAW AMM 25-50-0 0-06.SDR UPS06547186Frame · dentedINSPECTION TYPE:CK DENT IN AFT CARGO FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1359, AND UPS EO B757-5310-23 960-A. NO DEVIATIONS FROM FINAL EA NOTE: SEE ATTACHED ECA STEP 14 FOR FINAL DIMENSIONS OF (2) EA CUTOUTS AND REPAIR ANGLE.SDR UPS06547183Frame · dentedINSPECTION TYPE:CK DENT IN AFT CARGO FUSELAGE. COMPLIED WITH EA NR 757-5362-27-A1366 REV A AND UPS EO NR B757-5310-23 963-B, WITH NO DEVIATIONS FROM EA NOTE: SEE STEPS 16 AND 19 FOR FINAL DIMENSIONS.SDR ABXA060129Frame · crackedLEFT, CENTER MAIN FRAME, STA 718, WAS CRACKED AT POINTS J & G IN FORWARD AND AFT FLANGES AND POINTS F TO E IN FORWARD FLANGE. CRACK ASLO EXTENDS ABOVE 9" REPAIR IN LEFT WHEEL WELL. MAIN FRAME TO BE REPLACED IAW EA 53400323-001-2.SDR 2006UALA00364Frame · dentedAFT CARGO COMPARTMENT STA 727B AT S22L FRAME DENTED. REPAIRED FRAME AT STA 727B AT STRINGER 22L WITH REF TO MM CHAPTER 53-11-99. REPLACED STRINGER CLIP ON FRAME 727B AND STRINGER 22L DUE TO REPAIR WITH REF TO SRM 51-40-02.SDR DU4R2006282Frame · bentFRAME AS STA 1300, S-26L IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 11.40 X 2.50 INCHES FROM 7075-T6 .071 IAW B757 SRM 51-70-11 AND 51-20-1.SDR DU4R2006286Frame · bentFRAME AS STA 1240, S-26R IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 10.4 X 2.5 INCHES FROM 7075-T6 .080 IAW B757 SRM 51-70-11, 51-20-01 AND 51-40-02.SDR DU4R2006285Frame · bentFRAME AS STA 1480, S-26L IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 10 X 2.4 INCHES FROM 7075-T6 .063 IAW B757 SRM 51-70-11, 51-20-01 AND 51-40-02.SDR SWAA060673Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 21R. REPAIRED FRAME PER SWA EA & SRM.SDR SWAA060671Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT L1 DOOR CUTOUT, BS 348, BETWEEN STR 13L TO STR 17L. REPAIRED FRAME PER SRM.SDR MALA060117Frame · corrodedDURING N4K BRIDGE CHECK IN BNA, FOUND FRAME AT FS 258 FROM LBL 18 RBL 18 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO#S53102. REF: EAMS WORK ORDER 213551 TASK 1556.SDR MALA060111Frame · corrodedDURING 4K BRIDGE CHECK IN BNA FOUND FRAME AT FS 294 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EOS53108.SDR 06FDEA0863Frame · corrodedFRAME AT STA 950C 4 INCHES RT OF CENTER LINE IS CORRODED. REMOVED DAMAGE, FABRICATED, ALODINED, PRIMED AND INSTALLED FRAME REPAIR AT STA 950C LBL 4 TO RBL 4 ALL IAW FX B727 SRM 53-10-4 FIG12,51-30-2,53-10-1, 53-10-2 AND 51-10-2.SDR 06FDEA0859Frame · corrodedFRAME STA 950F STRINGER 29L, CORROSION. REMOVED DAMAGE, FABRICATED, ALODINED, PRIMED AND INSTALLED FRAME REPAIR STA 950F AT S29L ALL IA FX B727 SRM'S 53-10-4 FIG 12,53-10-1,53-10-2 AND 51-10-2 SNRM N00990.SDR 06FDEA0852Frame · dentedMAIN DECK COMPARTMENT FRAME FOUND WITH DENT AT STATION 715 BETWEEN STRINGER 12-13R. DECK COMPARTMENT DENT AT FRAME AT STATION 715 BETWEEN STR 12- 13R, REPAIR CARRIED OUT AS PER SRM 53-30-00 FIGURE I VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-SDR DHL2007751514Frame · corrodedA/C IN C CHECK, AFT CARGO COMPT FRAME AT STA 950D IS CORRODED AT BOTTOM BETWEEN STR 29L-28L. REPLACED DAMAGED SHEER TIE AT BS 950D BETWEEN STRINGER 29L-28L. FABRICATED NEW PART 7075-0 .080 PO NR 9002619 IAW B727 SRM 53-10-4 FIG15 AND 53-10-2 FIG 5. HEAT TRESDR SIMA200607507Frame · bentCARGO FRAME 725 BENT. RECONTOURED FRAME, PERFORMED NDT INSPECTION WITH NO REJECTABLE INDICATIONS NOTED. FABRICATED AN L ANGLE AND DOUBLER. REPAIR DONE IAW SRM. (K)SDR 2006UALA00339Frame · gougedFOUND FUSELAGE BODY FRAME WEB IS GOUGED NEAR BLEED AIR CUTOUT BS 1040, STR 26L - 27L. CUT OUT DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED REPAIR REF MM 53-11-86. REPAIR SCHEME DOUBLER AND TRIPLER.SDR SIMA200607504Frame · corrodedFRAME 272 UPPER FLANGE CORRODED. REMOVED CORROSION AND FABRICATED A FILLER, 2 SHIMS AND DOUBLER. REPAIR DONE IAW SRM. (K)SDR SIMA200606909Frame · damagedCARGO FRAME 677 DAMAGED. REMOVED THE DAMAGED AREAS BY MAKING 2 CUTOUTS. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW SRM. (K)SDR QXEA200600654Frame · crackedPDX-C4 CHECK, FRAME CRACKED APPROX STATION X253.4, BLR 24R Z100.8. REPAIRED IAW EA 2-53-690.SDR DU4R2006284Frame · bentFRAME AS STA 1320, S-26R IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 13 X 4 FROM 7075-T6 .071 AND CLIP P/N 140N2063-56 IAW B757 SRM 51-70-11 AND 51-40-02.SDR DU4R2006283Frame · bentFRAME AS STA 1340, S-26R IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 13 X 4 INCHES FROM 7075-T6 .071 AND CLIP IAW B757 SRM 51-70-11 AND 51-40-02.SDR SWAA060645Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA060644Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA060643Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA060642Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, BL 0. REPAIRED FRAME PER SRM.SDR SWAA060641Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 727E, STR 14R. REPAIRED SHEAR TIE PER SWA EA.SDR SIMA200607505Frame · dentedCARGO FRAME 677 DENTED ON RT LWR SIDE. RECONTOURED DENT AND PERFORMED NDT WITH NO REJECTABLE INDICATIONS NOTED. PREPARED A DOUBLER FOR REPAIR. REPAIR DONE IAW SRM. (K)SDR SIMA200607502Frame · dentedCARGO FRAME 658.5 DENTED ON RT LWR SIDE. RECONTOURED DENT AND PERFORMED NDT WITH NO REJECTABLE INDICATIONS NOTED. PREPARED A DOUBLER FOR REPAIR. REPAIR DONE IAW SRM. (K)SDR USAA060359Frame · crackedSTA 807 BETWEEN S8L AND 9L AT OVERHEAD BIN LOWER ATTACH POINT CRACKED. FABRICATED REPAIR PARTS AND INSTALLED IAW TR 53-10-20C, DEFECT SIZE: 1 INCH.SDR USAA060361Frame · crackedJUST AFT OF STA 291 STUB FRAME CRACKED. REMOVED DAMAGE, INSTALLED WEB REPAIR IAW SRM 51-70-13, DEFECT SIZE: .375 INCH.SDR 06FDEA0831Repair · unknownSTA 645 BETWEEN LONGERONS 11-13 RT FOUND FRAME REPAIR. PERFORMED EA 8-5330-95683.SDR QXEA200600652Frame · corrodedPDX - C4 CHECK, FRAME X151 IS CORRODED AT CASTELLATION BETWEEN STRINGER 31R AND 32R. REPAIRED IAW SRM 51-20-16, SRM 51-20-36 AND SRM 51-20-11.SDR QXEA200600651Frame · corrodedPDX - C4 CHECK, FRAME X167 IS CORRODED AT CASTELLATION BETWEEN STRINGER 30R AND 31R. REPAIRED IAW SRM 51-20-16, SRM 51-20-36 AND SRM 51-20-11.SDR QXEA200600650Frame · corrodedPDX - C4 CHECK, FRAME X167 IS CORRODED AT CASTELLATION BETWEEN STRINGER 32L AND 33L. REPAIRED IAW SRM 51-20-16, SRM 51-20-36 AND SRM 51-20-11.SDR QXEA200600649Frame · corrodedPDX-C4 CHECK, FRAME X167 IS CORRODED AT CASTELLATION BETWEEN STRINGER 28L AND 29L. REPAIRED IAW SRM 51-20-16, SRM 51-20-36 AND SRM 51-20-11.SDR QXEA200600648Frame · corrodedPDX-C4 CHECK, FRAME X167 HAS SMALL AREA OF CORROSION ON FORWARD SIDE JUST OUTBOARD OF STRINGER 29L. REPAIRED IAW SRM 51-20-16, SRM 51-00-04, SRM 51-20-36 AND SRM 51-20-11.SDR QXEA200600653Frame · corrodedPDX - C4 CHECK, FRAME X167 IS CORRODED AT CASTELLATION BETWEEN STRINGER 31R AND 32R. REPAIRED IAW SRM 51-20-16, SRM 51-20-36 AND SRM 51-20-11.
Back to JASC 5311