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 QXEA200800403Frame · corrodedPDX C4 CHECK SUSPECT CORROSION OF FRA X201 AT STR 31S. REMOVED CORROSION IAW CPM CHAP 4 PARA 9A-B(1-6(A)). UT THICKNESS CHECK IAW -8 200 NDTM PT 1, 51-00-04 HI .032 LOW .029. HFEC INSP. IAW -8 200 NDTM PT 6, 51-00-01 NO CRACKS NOTED. ALODINED PRIMED IAW -8SDR USAA920080880Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - CRACKED FRAME, BS 380, S20L - S21L. REPAIRED FRAME, BS 380, S20L - S21L IAW USAIRWAYS EA 100383.SDR MALA080060Frame · corrodedAT STA 288 ON RIGHT UPPER FLANGE ON THE BOTTOM FRAME CORROSION WAS FOUND. REPAIRED AREA IAW EOS53108.SDR 2008UALA02292Frame · dentedAFT PIT AT BS 1540 AND STR 26L, FRAME INBOARD FLANGE DENTED. REMOVED DAMAGE FABRICATED AND INSTALLED RPR IAW 53-00-07 RPR 5.THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 12,000FC THEREAFTER. INSSDR UPS08B52561Tension Tie · crackedINSPECTION TYPE:BCF BS1180 TENSION TIE LT FWD SIDE CRACKED. BS 1180 TENSION TIE REPAIRED PER SRM 53-40-31 FIG 201.SDR UPS08B52560Tension Tie · crackedINSPECTION TYPE:BCF BS 1140 TENSION TIE RT AFT SIDE FOUND CRACK. BS 1140 TENSION TIE REPAIRED PER SRM 53-40-30 FIG 201.SDR UPS08B52559Tension Tie · crackedINSPECTION TYPE:BCF BS1180 TENSION TIE LT AFT SIDE CRACKED. BS 1180 TENSION TIE REPAIRED PER SRM 53-40-30 FIG 201.SDR UPS08B52558Failsafe · crackedINSPECTION TYPE:BCF LT BS 1140 TENSION TIE FRAME FAIL/SAFE CHORD CRACKED. LT BS 1140 TENSION TIE FRAME FAIL/SAFE CHORD REPLACED PER SRM 51-70-11.SDR UPS08B52557Frame · crackedINSPECTION TYPE:BCF RT BS 1180 TENSION TIE FRAME CRACKED ABOUT 0.040 INCH. RT BS 1180 TENSION TIE FRAME REPLACED PER SRM 53-40-07 REPAIR 4.SDR UPS08B52556Frame · crackedINSPECTION TYPE:BCF RT BS1140 TENSION TIE FRAME CRACKED MORN THAN 0.060 INCH. RT BS 1140 TENSION TIE FRAME REPLACED PER SRM 53-40-07.SDR UPS08B52555Frame · crackedINSPECTION TYPE:BCF LT BS1180 TENSION TIE FOUND CRACKED AT FRAME MORN THAN 0.200 INCH. LT BS 1180 TENSION TIE FRAME REPLACED PER SRM 53-40-07.SDR UPS08B52554Frame · crackedINSPECTION TYPE:BCF LT BS 1140 TENSION TIE FRAME CRACKED. LT BS 1140 TENSION TIE FRAME REPAIRED PER SRM 53-40-07.SDR UPS08B52385Failsafe · crackedINSPECTION TYPE:C LT BS 1140 TENSION TIE FRAME FAIL SAFE CHORD CRACKED. LT BS 1140 TENSION TIE FRAME FAIL SAFE CHORD REPLACED PER SRM 51-70-11.SDR UPS08B52384Failsafe · crackedINSPECTION TYPE:C RT BS 1140 TENSION TIE FAIL SAFE CHORD CRACKED ABOUT O.030 INCH. RT BS 1140 TENSION TIE FAIL SAFE CHORD REPLACED PER SRM 51-70-11.SDR UPS08B52383Frame · crackedINSPECTION TYPE:C RT BS 1180 TENSION TIE FRAME CRACKED ABOUT 0.040 INCH. RT BS 1180 TENSION TIE FRAMED REPLACED PER SRM 53-40-07, REPAIR 4.SDR UPS08B52382Frame · crackedINSPECTION TYPE:C RT BS 1140 TENSION TIE FRAME CRACKED MORE THAN 0.060". RT BS 1140 TENSION TIE FRAME REPLACED PER SRM 53-40-07.SDR UPS08B52381Frame · crackedLT BS 1180 TENSION TIE FOUND CRACKED AT FRAME MORE THAN O.200 INCH. LT BS 1180 TENSION TIE FRAME REPLACED PER SRM 53-40-07.SDR USAA920080974Frame · crackedPIT - MAJOR REPAIR - CRACKED FRAME, BS 492.4, S24R. REPAIRED FRAME, BS 492.4, S24R IAW USAIRWAYS EA 110913.SDR 2008UALA02246Frame · damagedRT FRAME REPAIR WAS ACP'D BS 1681, WL-209. ACCOMPLISHED MAJOR, PER EVA MOC1-8433 REVA. AFTER DTA, THIS REPAIR IS CONSIDERED TO BE A CAT 'A' TIME LIMITED REPAIR. THIS REPAIR MUST BE REPLACED PER REVISED EVA-40093, NO LATER THAN NEXT HMV CURRENTLY SCHEDULED SDR CALA0800341Frame · crackedRIGHT SIDE FRAME 907 BETWEEN S-8 AND S-9 AC BRACKET HOLE CRACKED. REPAIRED RIGHT FRAME AT STATION 907 BETWEEN S-8 AND S-9 AC BRACKET PER EA5310-04498.SDR USAA920080902Frame · corrodedPIT-MAJOR REPAIR - CORROSION ON SHEAR PLATE SUPPORT FRAME AT FR 70, STR 23R. REPLACED FRAME IAW SRM 51-72-11.SDR SWAA082052Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947, STR 18R. REPAIRED FRAME PER SRM.SDR SWAA082048Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR ABXR080144Frame · crackedLONGERON 25 LEFT HAD CRACK INDICATIONS AT BOTH ATTACH FASTENERS TO FRAME AT FS 160. REMOVED AND REPLACED DAMAGED SECTION IAW DC9 SRM.SDR 2008UALA02222Frame · dentedAFT PIT STA 1400 STR 26L IS DENTED ON FRAME. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 2. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS STARTING IN 25,000 FLIGHT CYCLES AND 11,000FC THERE AFTER.SDR 2008UALA02221Frame · chafedAFT PIT STA 1520 AT STR 26L, FRAME CHAFED. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 1. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTION S STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 12,000 FC THERE SDR 2008UALA02220Frame · dentedAFT PIT STA 1420, STR 27L HAS 1 FRAME DENT. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 2. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTION S STARTING IN 25,000 FLIGHT CYCLES AND 11,000FC THERE AFTER.SDR 2008UALA02219Frame · dentedAFT PIT STA 1440 HAS 3 EACH DENTS STRINGER 26L - 24L. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 1. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 12,00SDR 2008UALA02218Frame · dentedAFT PIT STA 1500 STR 26L FRAME HAS 1 DENT. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 1. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 12,000FC THERE ASDR 2008UALA02217Frame · dentedAFT PIT STA 1580 STR 22R HAS DENTED FRAME. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 1. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTION S STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 12,000FC THERE SDR 2008UALA02216Frame Splice · gougedAFT PIT STA 1520 FRAME SPLICE GOUGED BETWEEN STR 22R AND 24R. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 1. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES ANSDR 2008UALA02215Frame · dentedAFT PIT STA 1600 RT SIDE STR 24R HAS DENTED FRAME. REMOVED DAMAGE FABRICATED AND INSTALLED RPR PER SRM 53-00-07 RPR 5 TABLE II ZONE 1. RPR IS A CAT B RPR AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 12,000FC TSDR 2008UALA02214Frame · dentedAFT PIT BS 1540, FRAME INBOARD FLANGE DENTED AT STR 24R. REMOVED DAMAGED FABRICATED RPR AND INSTALLED IAW SRM 53-00-07 RPR 5 TABLE II THIS IS A CAT B RPR IN ZONE 1 AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES ANDSDR SWAA082038Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 277, BETWEEN STR 14R AND STR 16R. REMOVED AND REPLACED WEB PER SRM.SDR USAA920080878Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - CRACKED FRAME, BS 440, S26R. REPLACED FRAME, BS 440, S26R IAW B737 SRM 51-10-02.SDR SWAA082028Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA082023Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR 2008UALA02166Frame · dentedAFT PIT STA 1540, BETWEEN STR 25L AND 27L FRAME DENTED (3 EA DENTS). AFT PIT STA 1540, BETWEEN STR 25L AND 27 L FRAME DENTED (3 EA DENTS) REPAIRED FRAME DENTS IAW S RM 53-00-07 RPR 5 TABLE II ZONE 1.THIS REPAIR MUST BE REINSPECT ED STARTING AT 50000 TOTAL FLISDR 2008UALA02165Frame · dentedAFT PIT STA 1480, STR 26L FRAME DENTED. AFT PIT STA 1480, STR 26L FRAME DENTED. REPAIRED FRAME DENTS IAW S RM 53-00-07 RPR 5 TABLE II ZONE 1.THIS REPAIR MUST BE REINSPECT ED STARTING AT 50000 TOTAL FLIGHT CYCLES AND 12000FC THERE AFTER .SDR SWAA082012Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 15R. REPAIRED FRAME PER SRM.SDR SWAA082009Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND BELT FRAME CRACKED AT BS 277, STR 16R. REPAIRED BELT FRAME PER SWA EA.SDR SWAA081995Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR 08FDEA01401Frame · crackedDURING MD10 MODIFICATION TO ACF IN AVIONIC COMPARTMENT RT SIDE STA 469 X =-61 FOUND FRAME WITH CRACK 1 INCH REPAIRED FOR SRM 53-30-00 FIG 11 VOL I.SDR 08FDEA01397Frame · chafedMAIN DECK, LEFT FRAME AT STATION 535, LONGERON 21 LT, ONE EACH CHAFED MARK FOUND CAUSED BY 9G NET YOKE. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100.SDR 08FDEA01396Frame · chafedMAIN DECK, LEFT FRAME AT STATION 535, LONGERON 24 LEFT, ONE EACH CHAFED MARK FOUND CAUSED BY 9G NET YOKE. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100.SDR 08FDEA01395Frame · dentedMAIN DECK, LEFT FUSELAGE FRAME AT STATION 1721, LONGERON 12 LEFT FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT ASDR 08FDEA01394Frame · dentedMAIN DECK, LEFT FUSELAGE FRAME AT STATION 1701, LONGERON 12 LEFT FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT ASDR 08FDEA01393Frame · dentedMAIN DECK, RIGHT FUSELAGE FRAME AT STATION 1701, LONGERON 12 RIGHT FOUND DENTED. REPAIRED AS PER SRM 53-30-00- FIGURE 1 VOLUME I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUSDR 08FDEA01392Frame · dentedMAIN DECK, RIGHT FUSELAGE FRAME AT STATION 1681, LONGERON 12 RIGHT FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUSDR SWAA081974Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED SKIN PER SRM.
Back to JASC 5311