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 DL757081350Failsafe · corrodedFOUND FAILSAFE STRAP ON THE RT SIDE OF THE FS 900 BULKHEAD CORRODED. REMOVED AND REPLACED DAMAGED STRAP PER BLUEPRINT.SDR SWAA085567Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR DHLA2008745530Frame · crackedFUSE FRAME O/B CHORD CRACKED AT BS 188, WL 208. ACCOMPLISHED ANGLE REPAIR TO FRAME CHORD IAW B727 SRM 51-40-3 FIG 1, AT BS 188, WL 183 TO WL 216. REF N/R 4987-2-421.SDR SWAA085528Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, STR 16R. REPAIRED FRAME PER AAR EA.SDR SWAA085523Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 788, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA085522Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA085521Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA085520Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR DL757081581Frame · dentedMAIN CABIN FRAME STA 395 LT SIDE FWD CABIN 2 DENTS. BLENDED GOUGES, FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 101 PG 103 DETAIL II. INSTALLED REPAIR PARTS AT FRAME 395 IAW ERA 461183-14 STEP 8.SDR UPS08853797Frame · crackedINSPECTION TYPE:SV EVAL AND DISPOSITION REPAIR EFN 71520041070 ORIG NR 735729 FRAME STA 7 81 AND X20 (CRACK). REPAIR WAS ACCOMPLISHED WITH DC8 SRM 53-02-00 FIG 001B REV 78.SDR USAA920081871Frame · crackedCLT Q5 MAJOR REPAIR NR 03C10753038/006 FUSELAGE FRAME CRACKED ON INNER CHORD AT BS 601, S17R, WL 202, RBL 66. REPAIRED FUSELAGE FRAME INNER CHORD AT BS 601, S17R, WL 202, RBL 66 IAW EA NR 100688.SDR COMA0860417Frame · crackedDURING 640 FRAME INSPECTION FOUND FRAME CRACKED AT STRINGER 9 RT CUTOUT. REPAIRED 640 FRAME PER REO 601R-53-61-557.SDR COMA0860416Frame · crackedDURING 640 FRAME INSPECTION FOUND FRAME CRACKED AT STRINGER 9 LT CUTOUT. REPAIRED 640 FRAME PER REO 601R-53-61-557.SDR 2008UALA06069Frame · dentedAFT PIT DENTED FRAME STA 1520 BETWEEN STR 24-25 LEFT. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION FOR FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06068Frame · dentedAFT PIT FRAME DENTED STA 1420 AT STR 26L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR SWAA085559Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, BETWEEN STR 23L TO STR 22L. REPAIRED FRAME PER SRM.SDR CALA0800964Frame · crackedCABIN STATION 907 BETWEEN S8R AND S9R PSU SUPPORT BRACKET TO FRAME CRACKED, APPROXIMATELY 1 INCH. REPAIRED FRAME PER EA 5310-04498 OPT 2.SDR CALA0800963Frame · crackedFUSELAGE STATION 360 LT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET INBOARD RIVET BETWEEN STRINGERS 8 AND 9. REPAIRED 360 FRAME AT STR 8-9 LEFT PER ECRA 5310-04845.SDR 08FDEA04297Frame · corrodedCORROSION ON FRAME LOWER AT AFT CARGO BILGE L50L- L50R. CORRODED FRAME AT AFT CARGO BILGE BS 1967 L50L- L50R REMOVED AND REPLACED WITH A FABRICATED FRAME AS PER SRM 51-31-01. FRAME FABRICATED AS PER E.A. 1-5310-123128. REPAIR CLASSIFIED AS MINOR AS PER GMMSDR 08FDEA04296Frame · corrodedCORROSION ON FRAME LOWER AT AFT CARGO BILGE STA. 1979 L49L-49R. AFT CARGO LOWER FRAME AT BILGE STA. 1979 L49L - L49R DAMAGED REMOVED, REWORKED EXTRUSION P/N: S4933678X7075-0 AS PER DRAWING AGA8002 AND INSTALLED IN PLACED AS PER SRM 51-31-01 VOL. II. REPAISDR USAA2008111492060Frame · corrodedSAL - MAJOR REPAIR - C21 CHECK - NR 6062844, LEVEL 2 CORROSION ON FRAME AT BS 827, LBL 5, IN THE AFT CARGO COMPARTMENT. REPAIRED FRAME AT BS 827, LBL 5 IN THE AFT CARGO COMPARTMENT IAW B737 SRM 53-00-07-2R 8 FIGURE 201.SDR USAA920081855Frame · crackedMCN C18 MAJOR REPAIR NR 6123120. FRAME DOUBLER WEB CRACKED AT BS 303.9, S16L. REPLACED FRAME DOUBLER AT BS 303.9, S16L. IAW EO NR 5311-01025 & EA NR 130129.SDR SWAA085532Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085501Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA085499Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER PAE EA.SDR SWAA085498Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER PAE EA.SDR SWAA085497Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER PAE EA.SDR 08FDEA04292Frame · chafed9G BULKHEAD CONTACTING FRAME AT STA 344 AND STR 5L. TRIMMED OUT FRAME AND FABRICATED FRAME REPAIR, INSTALLED FRAME REPAIR IAW B727 SRM 51-30-2, 53-10-2 FIG 3 AND SRM 53-10-4 FIG2.SDR DHLA2008745501Frame · crackedFRAME CRACKED, BS 380, FWD GALLEY DOOR. REPLACED FRAME SECTION BY FABRICATION IAW B727 SRM 51-10-1 AND 51-30-2.SDR 08FDEA04281Frame · crackedMAIN DECK REINFORCE UPPER FRAME BASE TO ARCHES JUNCTIONS FRAME FOOT 46 LEFT, REWORK HOLES 23, 26, 27 BY E.A 6-5310-123911. REAMED HOLES 23, 26,& 27. TO .433. BUSHINGS FABED ON TRAVELER T8/762882, BUSHINGS INSTALLED IAW E.A 6-5310-123911SDR USAA920082083Frame · corrodedSAL C21 MAJOR REPAIR NR 6056756 CORROSION ON FRAME UPPER FLANGE AT BS807 BETWEEN S16R TO S27R. REPAIRED FRAME UPPER FLANGE AT BS807, BETWEEN S16R TO S27R IAW B737 SRM 51-10-02.SDR SWAA085472Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085471Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085470Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085469Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085468Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085467Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085462Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085461Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA085460Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR 08FDEA04279Frame · dentedMAIN DECK CARGO COMPARTMENT, LT SIDEWALL STRUCTURE FRAME BS 1701 FOUND DENTED, LONGERON 12L. MAIN DECK CARGO BAY, LT SIDEWALL STRUCTURE FRAME BS 1701 AT L-12L, DENTED AREA REPAIRED AS PER SRM 53-30-00 FIG. 1 VOL. I. REPETITIVE INSPECTION REQUIRED - INITIALSDR SWAA085436Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM.SDR CALA0800960Frame · crackedFUSELAGE STATION 867 LT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8L AND 9L. CUT OUT DAMAGE AT FUSELAGE STATION 867 BETWEEN S8L AND S9L, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.SDR CALA0800959Frame · crackedFUSELAGE STATION 827 LT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8L AND 9L. CUT OUT DAMAGE AT FUSELAGE STATION 827 BETWEEN S8L AND S9L, FABRICATED AND INSTALLED REPAIR PARTS PER EA5310-044498.SDR CALA0800958Frame · crackedFUSELAGE STATION 747 LT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8L AND 9L. CUT OUT DAMAGE AT FUSELAGE STATION 747 BETWEEN S8L AND S9L, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.SDR CALA0800957Frame · crackedFUSELAGE STATION 787 LT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8L AND 9L. CUT OUT DAMAGE AT FUSELAGE STATION 787 BETWEEN S8L AND S9L, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.SDR CALA0800956Frame · crackedFUSELAGE STATION 867 RT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE AT FUSELAGE STATION 867 BETWEEN S8R AND S9R, FABRICATED AND INSTALLED REPAIR ANGLES PER EA5310-04498.SDR CALA0800955Frame · crackedFUSELAGE STATION 827 RT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE AT FUSELAGE STATION 827 BETWEEN S8R AND S9R, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.SDR CALA0800954Frame · crackedFUSELAGE STATION 787 RT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE AT FUSELAGE STATION 787 BETWEEN S8R AND S9R, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.SDR CALA0800953Frame · crackedFUSELAGE STATION 747 RT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE AT FUSELAGE STATION 747 BETWEEN S8R AND S9R, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.
Back to JASC 5311