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 DU4R2006583Frame · corrodedCORROSION FS 1380 L-29 FWD/AFT SIDE OF FRAME. BLENDED CORROSION. FABRICATED AND INSTALLED DOUBLER REPAIRS 8.2 X 3 X 2.1 INCHES AND 8 X 2 X 1.1 INCHES FROM 7075-T6 .032 IAW MD-80 SRM 53-01 FIG 2, 51-30-5D.SDR GAIA06023STFrame · dentedNO FLIGHT: DURING INSPECTION THE FRAME AT STATION 380 WAS FOUND DENTED BETWEEN STRINGERS S5L AND S6L. REPAIRED FRAME WITH DOUBLER REPAIR IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR GAIA06024STFrame · dentedNO FLIGHT: DURING INSPECTIO THE FRAME AT STATION 400 WAS FOUND DENTED BETWEEN STRINGERS S6L AND S7L. REPAIRED FRAME WITH DOUBLER REPAIR SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR GAIA06025STFrame · dentedNO FLIGHT: DURING INSPECTION THE FRAME AT STATION 560 WAS FOUND DENTED BETWEEN STRINGERS S5R AND S6R. REPAIRED FRAME WITH DOUBLER REPAIR IAW SRM. AIRCRAFT RETRUNED TO SERVICE. (K)SDR GAIA06026STFrame · dentedNO FLIGHT: DURING INSPECTION THE FRAME AT STATION 600 WAS FOUND DENTED BETWEEN STRINGERS S6R AND S7R. REPAIRED FRAME WITH DOUBLER REPAIR SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR UPS06447701Frame · crackedINSPECTION TYPE-C LT SIDE BS800 FRAME AT STR16 FOUND 1EA HOLE CRACKED AT FRAME STRAP APPROX .0625 INCH LONG RUNNING. CABIN LT SIDE BS800 FRAME ATTACH STRAP BETWEEN STR15L TI STR18L AREA REAIRED IAW RS R53-10-35541. CONTINUE INSPECTION AND SUPPLEMENTAL INSPECTSDR UPS06447615Frame · crackedINSPECTION TYPE:C FWD CARGO COMPT - LT STA 980 STR39 FRAME FOUND CRACKED. CRACK LENGTH 1/2". FWD CARGO COMPT LT STA980 STR39 FRAME REPAIRED AS PER RS R53-10-35553 JUST BETWEEN STR36L AND STR40L AREA CONTINUE INSP IS REQUIRED AS PER RS R53-10-35553 AND UPS EO SDR QXEA200601850Frame · corrodedPDX C4 - CORROSION ON VERTICAL LEG OF FRAME AT LOWEST RIVET JUST OUTBOARD OF STRINGER 31S AND FRAME 222.7. CORROSION IS LOCATED ON FORWARD SIDE OF FRAME BY THE TAIL ON THE LOWEST RIVET. REPAIRED IAW DHC-8-200 SRM 51-20-16 AND 51-20-36.SDR 2006UALA01363Frame · crackedMID CABIN STA 663.75 FRAME CRACKED AT STRINGER CUTOUT AT 2R. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLE, STRINGER SPLICE AND STRINGER CLIP.SDR KCSA061195Frame · crackedSTA 760, S-41R, FRAME TO SIDERAIL ATTACH ANGLE CRACKED.SDR ASAA0640754Frame · dentedFOUND FWD CARGO COMP FRAME UPPER FLANGE IS DENTED. CUT OUT DAMAGED SECTION OF FRAME 2" BY 6.2" FROM ORIGINAL THICKNESS OF .050". INSTALLED REPAIR PARTS AND REFINISHED PER SRM 53 00 07.SDR SWAA062392Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D. STR 25L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR QXEA200601833Frame · corrodedPDX C4 - CORROSION BY RIVETS JUST RIGHT OF STRINGER 33 ON FRAME CASTELLATION OF X531.5. REPAIRED IAW DHC-8-200 SRM.SDR QXEA200601827Frame · corrodedPDX - C4 FRAME CASTELATION AT FRAME X545 AND STRINGER 30X IS CORRODED. REPAIRED IAW DHC-8-200 SRM 51-20-11, PAGE 1-4 AND SRM 51-20-36.SDR QXEA200601826Frame · corrodedPDX - C4 FRAME CASTELATION BETWEEN STRINGERS 26S AND 27S AT FRAME 531.5 IS CORRODED. REPAIRED IAW RD DHC-8-200 SRM 51-20-11 AND 51-20-36.SDR QXEA200601823Frame · corrodedPDX - C4 CORROSION ON FRAME CASTELATION JUST INBOARD OF STRINGER 31S AT FRAME X510. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND SRM 51-20-36.SDR QXEA200601824Frame · corrodedPDX - C4 FRAME X510 HAS TWO CASTELATIONS WITH CORROSION AROUND RIVETS FROM STRINGER 31S TO 28S. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND SRM 51-20-36.SDR QXEA200601820Frame · corrodedPDX - C4 CORROSION ON FRAME CASTELATION AT STRINGER 31S AND X488.5. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND SRM 51-20-36.SDR QXEA200601818Frame · corrodedPDX - C4 CORROSION ON FRAME CASTELATION AT STATION X488.5 AND STRINGER 33. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND 51-20-36.SDR UPS06447344Frame · crackedINSPECTION TYPE:C M/D BS 1283 RT S15-16 FRAME O/B FLANGE FOUND CRACK. CRACK LENGTH 1.25 INCH. M/D BS 1283 RT STR 15-16 FRAME O/B FLANGE REPAIRED AS PER SRM 53-10-04 FIG 1.SDR SWAA062376Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062375Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062374Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062373Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062372Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062371Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR UPS06447680Frame · crackedINSPECTION TYPE:C M/D BS360 S23R FRAME STRINGER CUTOUT CRACK, CRACK LENGTH 3/4". M/D BS360 STR23R FRAME REPAIRED AND ATTACH TIE CLIP REPLACED AS PER RS R53-11-35533 CONTINUE INSPECTION IS REQUIRED TO THE REPAIR AREA PER SB 747-53A2265 AND UPS EO B747-5310-247SDR QXEA200601830Floor Support · corrodedPDX C4 - CORROSION ON RIGHT HAND OUTBOARD END OF LOWER CARGO FLOOR SUPPORT ANGLE AT FRAME 597.5. REPAIRED IAW DHC-8-200 SRM 51-20-111, 51-20-16 AND 51-20-36.SDR QXEA200601822Frame · corrodedPDX - C4 CORROSION ON FRAME CASTELATION JUST RIGHT OF STRINGER 33 AND FRAME X510. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND SRM 51-20-36.SDR SWAA062363Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 520, STR 22L. REPAIRED FRAME WEB PER SRM.SDR HALA0600704Frame · corrodedFOUND CORROSION AFT CARGO BAY, ON FRAME UPPER CHORD 1197 RBL 38 WL 126. REMOVED CORROSION UPPER CHORD STA 1197, WL 126, IN AN AREA 2" BY 3" BY .041 PER SRM 51-10-2. ORIGINAL THICKNESS IS .100" OUT OF LIMITS PER SRM 53-00-07, FIG 101, SHEET 2. REMOVED OLD CHOSDR HALA0600703Frame · corrodedCORROSION AFT CARGO BAY, ON FRAME UPPER CHORD STA 1197 + 132 LBL 8 - 19 WL 126. REMOVED CORROSION ON FRAME UPPER CHORD STA 1197 + 132 LBL 8-19 WL 126 IN SEVERAL AREAS. LARGEST AREA REMOVED WAS .065 IN IN A 3" BY .9 " AREA. ORIGINAL THICKNESS TO BE .100 OUT SDR UPS06447610Frame · crackedINSPECTION TYPE:C BULK CARGO COMPT BS 2060 FRAME FOUND CRACK AT STA 29L CUTOUT. CRACK LENGTH 1 INCH. BULK CARGO COMPT BS 2060 STR 29L AREA FRAME REPAIRED AS PER SRM 53-10-04 FIG 39.SDR UPS06447479Frame · corrodedB/G RT W/W STA 1438 O/B SIDE AREA NEAR TOP PANEL FOUND CORROSION AS MARK AT RBL 115". CORROSION BLEND OUT 0.070" BY 1" BY 1.5" EXCEED SRM 53-10-01 FIG 1 LIMITS, B/G RT W/W STA 1438 BETWEEN WL 183 AND WL190 S28R FRAME REPAIRED AS PER SRM 51-40-03 FIG 1.SDR UPS06447355Frame · crackedINSPECTION TYPE: C AFT CARGO COMPT RT STA 1520 IN BETWEEN STR 38 AND STR 39 FRAME FOUND CRACKED. CRACK LENGTH 2 INCHES. FRAME REPAIRED IAW SRM 53-10-04 FIG 69.SDR UPS06547580Frame · dentedINSPECTION TYPE:C DENT IN FORWARD CARGO FUSELAGE FRAME STA 760, S23R. REPAIRED FRAME PER EA 757-5332-27-A1505 AND UPS EO B757-5310-24827-A.SDR 2006UALA01346Frame · crackedPASSENGER CABIN BS 616 WL 202 LBL 65 FRAME WEB CRACKED. REMOVED DAMAGE. INSTALLED FILLER AND ANGLE REPAIR.SDR SWAA062353Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 295, STR 16L. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA062352Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 295, STR 8L. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA062340Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062339Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062334Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 16R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062332Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062331Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20L. REPAIRED FRAME SECTION PER SWA EA.SDR UPS06547594Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, BET S26R TO S27R. REPAIRED IAW EA 757-5362-27-A1497.SDR UPS06447616Frame · crackedINSPECTION TYPE:C M/D BS540 STR23-25R FRAME FWD FACE O/B AREA FOUND CRACK. CRACK LENGTH 1/2". M/D BS540 STR23R TO STR25R FRAME REPAIRED AS PER RS R53-10-35538 AND UPS EO B747-5310-24760-A.SDR UPS06547591Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1320 S26R. COMPLIED WITH EA 757-5362-27-A1503.SDR UPS06547590Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1240 S26L. REMOVED DAMAGE STR FRAME STATION 1240 STR 26L. INSTALLED -J- ANGLE AND FILLER REPAIR IAW EA 757-5362-27-A1494.SDR UPS06547589Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1360, S26R. INSTALLED REPAIR DETAILS IAW EA 757-5362-27-A1504.SDR UPS06547578Frame · dentedINSPECTION TYPE:C FWD CARGO COMP, STA 760, S24L - S25L, FRAME HAS DENT. REPAIRED FRAME PER EA 757-5332-27-A1505 AND UPS EO B757-5310- 24827-A.
Back to JASC 5311