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 SWAA063847Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR K11A2008121872301Frame · corrodedFRAME HAS AREA OF CORROSION.SDR QXEA200603425Frame · crackedPDX C3 - 1.4" CRACK IN FLANGE RADIUS OF EMPENNAGE OBLIQUE FRAME AT X935, 11 O'CLOCK POSITION. LEFT SIDE OF CUTOUT FOR V-STAB TUNNEL. REPAIRED IAW Q400 SRM 51-42-05 AND 51-40-10.SDR TRAX200600839Frame · corrodedCORROSION FOUND ON FUSELAGE FRAME STA 349 AROUND STRINGER 27. REMOVEED CORROSION ON FUSELAGE FRAME STA 349 AROUND STRINGER 27 IAW SRM 51-00-00. (SUPPLEMENTAL - SDR CLOSED)SDR TRAX200600838Frame · corrodedCORROSION FOUND ON FUSELAGE FRAME STA 333 AROUND STRINGER 27. REMOVED CORROSION ON FUSELAGE FRAME STA 333 AROUND STRINGER 27 IAW SRM 51-00-00 (SUPPLEMENTAL-SDR CLOSED).SDR TRAX200600837Frame · corrodedCORROSION FOUND ON FUSELAGE FRAME STA 319 AROUND STRINGER 27. REMOVED CORROSION ON FUSELAGE FRAME STA 319 AROUND STRINGER 27 IW SRM 51-00-00 10-11-06 ( SUPPLEMENTAL - SDR CLOSED 10/13/06 )SDR TRAX200600835Frame · crackedASD FWD FRAME MEMBER STA 320 CRACKED LOWER END (LOCKING BAR END)SDR SWAA063839Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063838Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063837Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063836Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 17L. REPAIRED FRAME SECTION PER BOEING SB.SDR SWAA063821Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063820Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063819Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063818Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063814Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063813Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063812Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063811Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063810Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063809Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR USAA061204Frame · crackedFOUND CRACK FRAME STATION 727L ABOVE STRINGER 14L. INSTALLED DOUBLER REPAIR IAW EA 97996, DEFECT SIZE: 1".SDR UPS06548444Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, S26L DIMENSIONS OF THE DENT, 1.3'L BY 1.0'W BY 0.030' D REMOVE TRANSITIONAL PANEL LT STA 1310-1410 IAW SRM 51-40-02 TRIM OUT DENT AREA IAW EA 75 7-5362-27-A1561 STEP 1 PREM. TRIM OUT SIZE: 1.3' L BYSDR UPS06548447Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, S26R. TRIMMED OUT THE DENT AREA PER EA NR 757-5362-27-A1555 L=1", W= 1.0" D= .045". HFEC INSP PER EA NR 757-5362-27-A1555 STEP 2 OF DAMAGE REMOVAL INSP. NO NOTED CRACKS.SDR MWEA060220Frame · corrodedCORROSION ON FRAME AT LONGERON 30 ATTACHMENT Y 11, 17 X-2 TO X-2.SDR USAA061201Frame · corrodedFOUND FRAME STA 380 BETWEEN STR 28R AND 28L. REMOVED DAMAGE, INSTALLED REPAIR PARTS IAW SRM 53-00-07 REPAIR 3, DEFECT SIZE: 2" BY 4".SDR SWAA063788Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, STR 17R. REPAIRED FRAME SECTION PER SRM.SDR SWAA063787Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR KCSA061399Frame · crackedFOUND BS 1265 RT SIDE FRAME WEB HAS CRACK INDICATION AT FASTENER HOLE JUST BELOW FLOORSILLSDR KCSA061397Frame · corrodedFOUND CORROSION ON BS 580 FUSELAGE FRAME UPPER CHORD AT LBL 36.SDR KCSA061396Frame · crackedFRAME CRACKED STA 1580 RBL 72 WL 126 AT GUIDE SUPPORT BRACKET.SDR AWXA200601692Frame · crackedMCN - L2 DOOR CUT OUT FORWARD FRAME CRACKED, BS 957, S10L. REPAIRED L2 DOOR CUT OUT FORWARD FRAME, BS 957, S10L IAW B737-300 SRM 51-70-11, FIGURE 1.SDR AWXA200601759Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT FRAME, BS 827 BETWEEN LBL 3.00 AND RBL 3.00. REPAIRED AFT CARGO COMPARTMENT FRAME, BS 827 BETWEEN LBL 3.00 AND RBL 3.00 IAW SRM 53-00-07-2R 5 FIG 201.SDR TRAX200600815Frame · crackedLEFT FS 640.00 FRAME DOUBLER CRACKED.SDR RAIA00610003Frame · corrodedMX - INSP - LEVEL 2 CORROSION ON L-SHAPED PROFILE AT Y=0.0 AND FRAME 20. MAINTENANCE REMOVED AND REPLACED THE L-SHAPED PROFILE AT Y=0.0 AND FRAME 20.SDR KCSA061391Frame · crackedFOUND FRAME CRACKED BS 1580, RBL 72 AT GUIDE SUPPORT BRACKET WL 208.SDR KCSA061390Frame · corrodedFOUND FUSELAGE FRAME UPPER CHORD IS CORRODED AT STA 700 AT RBL 41.SDR 06FDEA03559Frame · crackedRT MLG W/W FOUND 1 CRACK 2" LONG ON FRAME AT STA 1505 X= -98. DISCONNECTED PIPES IAW MM 20-10-01-2. REMOVED PARTS IAW SRM 51-35-01 VOL 2 PAR 1-5. REPAIRED FRAME IAW SRM 53-00-01 VOL 1 FIG 8 SHEET 2-4. REINSTALLED PARTS IAW SRM 51- 35-01 VOL 2 PAR 1-5. RECSDR AWXA200601812Frame · crackedMCN - MAJOR REPAIR - FORWARD CARGO COMPARTMENT DOOR OPENING FORWARD FRAME WEB CRACKED, BS 440, S24R. REPAIRED FORWARD CARGO COMPARTMENT DOOR OPENING FORWARD FRAME WEB, BS 440, S24R IAW AWA ER 03-5332-06293-ES4.SDR AWXA200601810Frame · crackedMCN - MAJOR REPAIR - FORWARD CARGO COMPARTMENT DOOR OPENING AFT FRAME WEB CRACKED, BS 492.3, S24R. REPAIRED FORWARD CARGO COMPARTMENT DOOR OPENING AFT FRAME WEB, BS 492.3, S24R IAW AWA ER 03-5332-06293-ES3.SDR DHL2006770507Frame · dentedAFT CARGO COMPARTMENT, BS 1130 OVER STR 26R HAS FRAME WITH UPPER CHORD DENTED IN. CUT OUT DAMAGED AREA APPROX SIZE 1.875" BY 1.0" IAW B727 SRM 51-40-3 FIG 1. FAB DOUBLER REPAIR WITH 7075-0, .071, SIZE 8" BY 4", PO NR 9003817 IAW B727 SRM 53-10-2 FIG 3 AND 51SDR DHL2006770508Frame · corrodedAFT CARGO COMPARTMENT, BS 970, BETWEEN STR 28R AND 29R, FRAME LWR FLANGE BLOWN-UP WITH CORROSION. REMOVED FLOOR SUPPORT, VERTICAL STIFFENERS AND ANGLES FOR ACCESS IAW B727 SRM 51-30-2. CUT OUT DAMAGED AREA AT LWR FRAME FLANGE IAW B727 SRM 53-10-4 FIG 11. FASDR TRAX200600812Frame · crackedRT 640 FRAME DOUBLER CRACKED. MODIFIED RT 640 FRAME REF S.B.601-53-061 APPENDIX B AND EO 600-53-0081. (CLOSED)SDR TRAX200600811Frame · crackedLT 640 FRAME DOUBLER CRACKED. COMPLIED WITH EC/TC REO 601R-53-61-506. ALL DEFECTS CORRECTED, RII INSP COMPLETED SATISFACTORILY. (CLOSED)SDR DL76L060813Frame · crackedA CRACK WAS FOUND ON THE INNER CHORD OF THE STA 500 LOWER FRAME SEGMENT IN THE FORWARD CARGO BAY AT APPROX LBL 60. THE DAMAGED AREA OF CHORD WAS REMOVED AND A REPAIR ANGLE WAS INSTALLED.SDR SWAA063761Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 65, WL 201. REPAIRED FRAME SECTION PER TYPICAL REPAIR MANUAL.SDR SWAA063759Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 2R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063758Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 17R. REPAIRED FRAME SECTION PER SRM.SDR KCSA061385Strap · crackedFOUND INNER FRAME STRAP CRACKED 2 INCHES. STRINGER 25R BS 2231.SDR KCSA061384Frame · crackedFRAME STRAP CRACKED, BS 2231, S24L
Back to JASC 5311