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 SWAA116033Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 794.3, BETWEEN STR 23R TO STR 25R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA116020Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM AND DWG.SDR UIEA2011082400466Frame · crackedBS 820, S6R FRAME CRACKED, REPAIR ACCOMPLISHED DURING A C4 CHECK ON NRC 505315 IAW SRM 53-10-04, FIGURE 54.SDR UIEA2011082400465Frame · crackedBS820, S6L FRAME CRACKED, REPAIR ACCOMPLISHED DURING A C4 CHECK ON NRC 505323 IAW SRM 53-10-04, FIGURE 54.SDR EIAA2011159Frame · damagedMAIN DECK FRAME DAMAGED DUE TO DRILL HOLE AT BS 1200 BETWEEN STRINGER 17R AND 21R. FRAME REPAIRED PER B747 SRM 51-4-04, FIGURE 3.SDR FDEA201108243459Frame Splice · misrepairedFRAME SPLICE REPAIR AT BS 720, S29L- S29R, REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH APPROVED DATA. FRAME SPLICE REPAIR REPLACED IAW EA F-5310-147720. MAJOR REPAIR.SDR C2XA11SH121Frame · crackedSHV - DURING C-CHECK THE RT FRAME 10 WAS FOUND TO BE CRACKED BETWEEN STRINGERS 10R-11R, DIRECTLY BELOW THE RT DV WINDOW. MAINTENANCE REMOVED AND REPLACED THE CRACKED FRAME SEGMENT IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IPXA20110823001AFrame · dentedINSPECTION TYPE:C-CK, AFT CARGO COMPARTMENT FUSELAGE FRAME AT STA 1280 AT S-26R HAS DENT IN FREE FLANGE. REPAIRED AFT CARGO COMPARTMENT FRAME STA 1280, S26R IAW EA 111101IR AND EO B757-5310-44339-A.SDR IPXA20110823001Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT FUSELAGE FRAME AT STA 660 AT 24R HAS DENT IN FREE FLANGE. REMOVED DENT DAMAGE AND INSTALLED REPAIR ANGLE IAW EA 111107 IR AND EO B757-5310-44328.SDR IPXA11569167Frame · dentedINSPECTION TYPE:C-CHECK, REMOVED DAMAGE FROM BS 800 AT S25R HAS DENT IN FREE FLANGE. FABRICATED REPAIR PARTS FROM FROM 7075-0-.080 AND HEAT TREATED TO T6, DRILLED AND INSTALLED REPAIR PARTS IAW SRM 53-00-07-2R5, DETAIL III.SDR IPXA11569165Frame · dentedINSPECTION TYPE:C-CHECK, AFT CARGO COMPARTMENT FUSELAGE FRAME AT BS 1260 BETWEEN S25-26R HAS A DENT IN FREE FLANGE. REPAIRED AFT CARGO COMPARTMENT FRAME IAW EA 111100.SDR IPXA11569160Frame · dentedINSPECTION TYPE:C-CHECK FWD CARGO COMPARTMENT FRAME AT BS 720 BETWEEN S24-25R HAS A DENT IN FREE FLANGE. REPAIRED FWD CARGO COMPARTMENT FRAME BS 720 BETWEEN S24-25R IAW SRM 53-00-07-2R-5 AND EA 111111.SDR 3S8R201108230001Frame · crackedMAIN GEAR BOX FRAME HAS A CRACK ON THE LT SIDE RADIUS, STA 227.10, WL 65.00.SDR IPXA1569033Frame · dentedINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT FUSELAGE FRAME AT STA 1580 AT S25L HAS DENT IN FREE FLANGE. REMOVED DAMAGE FABRICATED REPAIR ANGLE FROM 7075-0.080 HEAT TREATED TO T6 DRILLED UP AND INSTALLED REPAIR IAW SRM 53-00-07-2R5 FASTENER INSTALLED THROUGH SDR USAA2011083100032Frame · crackedQ5 CHECK - .75 INCH CRACK ON FRAME AT BS 500F, BETWEEN S20L TO S21L, WL 182. REPAIRED FRAME AT BS 500F, BETWEEN S20L TO S21L, WL 182 IAW SRM 53-00-07.SDR FDEA201108233434Frame · damagedFRAME BS 1500 BETWEEN S26-27L, UPPER AREA GOUGED AND DENTED. REMOVED AND REPLACED FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR ASOA201101592Frame · corrodedFOUND FRAME STA 349 LOWER SECTION TO BE CORRODED AND REQUIRES REPLACEMENT. CLASSIFIED AS A MINOR REPAIR.SDR QXEA2011082600749Frame · corrodedFRAME 19.4 FLANGES STR 30P-32P ARE CORRODED. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .038", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. MATERIAL LOSS DETERMINED TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINEDSDR QXEA2011082600748Frame · corrodedFRAME 19.4 FLANGES ARE CORRODED STR 33-27S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .037", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. MATERIAL LOSS DETERMINED TO BE WITHIN LIMITS IAW RD 8/4-53-2344. TREATED, SDR QXEA2011082600747Frame · corrodedFRAME 94.8 FLANGES 30P-30S ARE CORRODED. REMOVED CORROSION FROM AFFECTED FLANGES IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .038", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. DAMAGE AND REMAINING THICKNESS DETERMINED TO BE WITHIN SDR QXEA2011082600746Frame · corrodedFRAME 136 FLANGES ARE CORRODED STR 30P-32P. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .040", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. MATERIAL LOSS THICKNESS DETERMINED TO BE WITHIN LIMITS IAW RD 8/4-53-2344.SDR QXEA2011082600745Frame · corrodedFRAME 136 FLANGES ARE CORRODED STR 30S-32S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .045", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. DAMAGE AND REMAINING THICKNESS DETERMINED TO BE WITHIN LIMITS IAW RD 8/4-SDR QXEA2011082600744Frame · corrodedFRAME 321 FLANGE IS CORRODED STR 32P-31P. REMOVED CORROSION IAW 51-21-00-00-02. MINIMUM REMAINING THICKNESS .049", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. DAMAGE AND REMAINING THICKNESS DETERMINED TO BE WITHIN LIMITS IAW RD 8/4-53-SDR QXEA2011082600743Frame · corrodedFRAME 564.5 FLANGES ARE CORRODED AND HAS MISSING FASTENER STR 31P-32P. BLENDED CORROSION IAW RD 8/4-53-2344. REMOVED RIVETS IAW SRM 51-41-05-02-01. MINIMUM REMAINING THICKNESS .051", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. DAMAGESDR QXEA2011082600742Frame · corrodedFRAME 624.5 FLANGES ARE CORRODED STR 33-30P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS .055", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. DAMAGE AND REMAINING THICKNESS DETERMINED TO BE WITHIN LIMITS IAW RDSDR QXEA2011082600741Frame · corrodedFRAME 644.5 FLANGES ARE CORRODED STR 33-30P. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .056", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801 AND 51-00-02-250-801. DAMAGE AND REMAINING THICKNESS DETERMINED TO BE WITHIN LIMITS IAW RD 8/4-SDR UIEA2011090900481Frame · crackedDURING C4 CHECK, WHILE COMPLYING WITH SB 747-53A2265, REV 9, FOUND CRACK DAMAGE TO FRAME. DAMAGE WAS REPAIRED IAW SRM 53-10-04 FIG 11.SDR USAA2011083100025Frame · crackedQ5 CHECK - 0.5 INCH CRACK ON FRAME AT BS 500C, BETWEEN S20R TO S21R, WL 182.5. REPAIRED FRAME AT BS 500C, BETWEEN S20R TO S21R, WL 182.5 IAW SRM 53-00-07, REPAIR 13.SDR USAA2011082300024Frame · corrodedRON CHECK - CORROSION ON FRAME AT BS 1460 BETWEEN BBL 0 TO RBL 6 & BETWEEN S29R TO S30. REPAIRED FRAME AT BS 1460 BETWEEN BBL 0 TO RBL 6 & BETWEEN S29R TO S30 IAW EA 200659 & 103312.SDR UIEA2011082200462Frame · crackedBS 580, S24L FRAME CRACKED, REPAIRED IAW SRM 53-10-04, FIG 35.SDR UIEA2011082200460Frame · crackedFUSELAGE - BS540, S24L-S25L FRAME CRACK - REPAIR (THIS EO DOCUMENTS A REPAIR ACCOMPLISHED DURING A C4 CHECK OF THE DATUM ACFT ON NRC 502668 IAW SRM 53-10-04, FIG 35. THE SRM REPAIR IS CLASSIFIED AS A CATAGORY B, WITH AN INITIAL INSP THRESHOLD OF 20,000 TFC ANSDR UIEA2011082200459Frame · crackedBS 560, S24-S25L FRAME CRACKED. REPAIRED IAW SRM 53-10-04, FIG 35.SDR SWAA115946Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, STR 17R. REPAIRED CHORD IAW EA.SDR SWAA115942Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27L. REPAIRIED FRAME IAW SRM AND DWG.SDR SWAA115941Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA115934Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 420, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR DALA1149061611Strap · crackedFX BS 955 LT REAR SPAR B/H FITTING AREA FAILSAFE STRAP CRACKED AND REPAIRED PER ERA 491118-14AD.SDR DALA1150530693Frame · dentedAFT CARGO FRAME DENTED STA 1400 ABOVE STR 26L. FABRICATED J SECTION REPAIR IAW B757 SRM 53-00-07 REPAIR 5 STEP 4 FIG 201 PG 201 DETAIL I. INSTALLED REPAIR J SECTION ON STA 1400 S 26L. AFT CARGO COMPT IAW B757 SRM 53-00-07 REPAIR 5 DETAIL I FIG 201 PG 201 STSDR QXEA2011082300728Frame · corrodedFRAME 71.2 FLANGES 30P-32P ARE CORRODED. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300727Frame · corrodedFRAME 71.2 FLANGE IS CORRODED STR 31S-32S. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300726Frame · corrodedFRAME 116.0 FLANGES ARE CORRODED STR 33-30S. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300725Frame · corrodedFRAME 116.0 FLANGES ARE CORRODED STR 32P-30P. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300724Frame · corrodedFRAME 156 FLANGES ARE CORRODED STR 30S-32S. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300723Frame · corrodedFRAME 156 FLANGES ARE CORRODED STR 30P-32P. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300722Frame · corrodedFRAME 176 FLANGES ARE CORRODED STR 33-30P. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300721Frame · corrodedFRAME 176 FLANGES ARE CORRODED STR 32S-30S. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300720Frame · corrodedFRAME 196 FLANGE IS CORRODED STR 31P-30P. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300719Frame · corrodedFRAME 281 FLANGE IS CORRODED STR 32S-31S. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300718Frame · corrodedFRAME 584.5 FLANGES ARE CORRODED STR 33-30S. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.SDR QXEA2011082300717Frame · corrodedFRAME 584.5 FLANGES ARE CORRODED STR 33-30P. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. COMPLETED REPAIRS IAW RD 8/4-53-2344.
Back to JASC 5311