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 SWAA104684Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA104683Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA104681Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA104680Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA104669Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 25R TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA104668Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA104667Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA104665Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 15L. REPAIRED WEB PER EO.SDR SWAA104664Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA104661Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR C2XA10SH260Frame · crackedSHV - DURING C-CHECK THE RT FRAME 10 SEGMENT AT STRINGER 10R WAS FOUND TO BE CRACKED DIRECTLY BELOW THE F/O DV WINDOW. MAINTENANCE REMOVED AND REPLACED THE FRAME SEGMENT IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA10SH259Frame · crackedSHV - DURING C-CHECK LT FRAME 10 WAS FOUND TO BE CRACKED AT STRINGER 10L DIRECTLY BELOW THE PILOT DV WINDOW. MAINTENANCE REMOVED AND REPLACED THE FRAME SEGMENT IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201008092881Frame · corrodedAFT PIT FRAME EXFOLIATED STA 1500, LBL 3 TO LBL 7. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL 1, P.103. REMOVED SPLICES, CLIP, TIE DOWN FITTINGS, FALSE CHORD, & FRAME, AND CUSP WEBS IAW SRM 51-40-02. LOCATED AND DRILLED NEWSDR EE4Y100307Frame · crackedTAIL COMPARTMENT AT STA Y964.019 CANT FRAME WITH CRACK AT STAIRWAY ACTUATOR SUPPORT FITTING AREA.SDR EE4Y100305Frame · crackedTAIL COMPARTMENT AT STA Y925.937 CANT, LONG 16L FRAME WITH CRACK.SDR EE4Y100297Frame · damagedUPPER FUSELAGE CARGO CABIN STA Y718 BETWEEN LONG 17 LT AND LONG 18 LT FRAME WITH DOUBLE HOLE.SDR EE4Y100296Frame · crackedUPPER FUSELAGE CARGO CABIN STA Y680 BETWEEN LONG 13R AND LONG 14R.SDR EE4Y100293Frame · damagedMAIN CARGO CABIN AT STA Y465 LONGERON 15 RT FRAME WITH DOUBLE HOLE.SDR EE4Y100292Frame · damagedMAIN CARGO CABIN AT STA Y446 BETWEEN LONG 9 RT AND LONG 11 RT FRAME WITH DOUBLE HOLES.SDR EE4Y100291Frame · damagedMAIN CARGO CABIN AT STA Y427 LONGERON 15 RT FRAME WITH DOUBLE HOLE.SDR EE4Y100290Frame · damagedMAIN CARGO CABIN AT STA Y408, LONGERON 15 RT FRAME WITH DOUBLE HOLE.SDR EE4Y100289Frame · damagedMAIN CARGO CABIN AT STA Y389, LONGERON 15 RT WITH DOUBLE HOLE.SDR EE4Y100288Frame · damagedMAIN CARGO CABIN AT STA Y370, LONGERON 15 RT FRAME WITH DOUBLE HOLE.SDR EE4Y100287Frame · damagedMAIN CARGO CABIN AT STA Y370, LONGERON 15 RT FRAME WITH DOUBLE HOLE.SDR EE4Y100286Frame · damagedMAIN CARGO CABIN AT STA Y332 BETWEEN LONG 10 RT AND LONG 11 RT FRAME WITH DOUBLE HOLES.SDR EE4Y100285Frame · damagedMAIN CARGO CABIN AT STA Y313 BETWEEN LONG 10R AND LONG 11R FRAME WITH DOUBLE HOLES.SDR EE4Y100284Frame · damagedMAIN CARGO CABIN AT STA Y294, LONGERON 15 RT FRAME AND STRAP WITH DOUBLE HOLES.SDR EE4Y100283Frame · wornMAIN CARGO CABIN AT STA Y275 BETWEEN LONG 14R AND LONG 15R AND LONG 17R AND LONG 18R FRAME WORN.SDR EE4Y100282Frame · damagedMAIN CARGO CABIN AT STA Y275 LONG 15 LT FRAME WITH ELONGATED HOLE.SDR EE4Y100281Frame · damagedMAIN CARGO CABIN AT STA Y237 LONGERON 11 RT FRAME WITH DOUBLE HOLES.SDR EE4Y100280Frame · damagedMAIN CARGO AT STA Y206 BETWEEN LONG 16R AND LONG 17 RT FRAME RADIUS WITH HOLE.SDR FDEA201008082873Frame · damagedMAIN DECK CARGO COMPT, FRAME 38.1 HAS 1 EA. DOUBLE DRILLED HOLE IN FRAME, ABOVE STRINGER 23, RT SIDE. REPAIRED RT FRAME 38.1 AT STRINGER 20R TO 21R IAW EA 6-5310-135249, EADS.SDR SWAA104623Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER EA.SDR DALA1018373270Frame · corrodedDURING M-CHECK FOUND CORROSION ON FRAME AT FR 20 STRINGER 23R. REPAIRED PER SRM 51-23-11, SRM 51-21-00, ERA484233-14.SDR DALA1018820186Frame · crackedM/D STA 903 STR 20R-21R FRAME INNER CHORD FOUND CRACKED. REPAIR CARRIED OUT IAW ERA 482260-14AD REV O/ REF NRC50994/ ACCOMPLISHED DURING HMV AD2.SDR R61A20100389Frame · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON FRAME 84 OUTBOARD OF LT SEAT TRACK. MAINTENANCE REMOVED CORROSION AND REPAIRED IAW EMB ETD 2010-170/06894 MATERIAL 7075 T6 .063 PO 315910. A/C STILL OUT OF SERVICE FOR HEAVY CHECK COMPLESDR EE4Y1008273Frame · crackedDURING INSPECTION UPPER FUSELAGE CARGO CABIN RT AT Y STA 585,-X59,-Z4 OVER WHEEL WELL FRAME AFT POCKET AREA WITH CRACK.SDR EE4Y1008272Frame · crackedDURING INSPECTION UPPER FUSELAGE MAIN CARGO CABIN Y STA 525 BETWEEN LONGERONS 18L AND 19L FUSELAGE FRAME WEB CRACKED.SDR EE4Y1008271Frame · crackedDURING INSPECTION UPPER FUSELAGE MAIN CARGO CABIN Y STA 544 BETWEEN LONGERONS 18R AND 19R FUSELAGE FRAME WEB CRACKED.SDR EE4Y1008269Frame · crackedDURING INSPECTION AFT FUSELAGE SUPPORT CANTED BULKHEAD LOWER FRAME WITH CORROSION AT CANTED STA 964,-X19.SDR SWAA104603Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA104597Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR EE4Y1008266Attach Fitting · crackedDURING INSPECTION LOWER FUSELAGE FWD CARGO COMPARMENT LEFT TUNNEL FUSELAGE FRAME ATTACHING FITTING CRACKED AT Y STA 446 BETWEEN LONGERONS 18L AND 19L.SDR FDEA201008052817Frame · dentedMAIN DECK CARGO RT STA 1601, L-12 FRAME FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-00-07 REPAIR 2 FIG 201 REV 43. INITIAL INSPECTION TO BE CARRIED OUT ON 14,500 FLT CYCLE AND REPETITIVE INSPECTION ON 9,500 FLT CYCLE AS PER SRM 53-00-07 REPAIR 2 TABLE 201 SDR FDEA201008052816Frame · dentedMAIN DECK CARGO RT STA 1761 L-12 FRAME FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-00-07 REPAIR 2 FIG 201 REV 44. INITIAL INSPECTION TO BE CARRIED OUT ON 14,500 FLT CYCLE AND REPETITIVE INSPECTION ON 9,500 FLT CYCLE AS PER SRM 53-00-07 REPAIR 2 TABLE 201 RSDR FDEA201008052815Frame · dentedMAIN DECK CARGO LT STA 1761 L-12 FRAME FOUND DENT. MAIN DECK CARGO STA 1761 L-12 FRAME FOUND DENT. REPAIR CARRIED OUT AS PER SRM 53-00-07 REPAIR 2 FIG 201 REV 43. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV 110. INITIAL INSPECTION TO BE CARRIED OUT ON 14SDR VGQY2010080500056Frame · crackedMAIN DECK CARGO COMPARTMENT - RT STA 1900 FRAME FOUND CRACKED. COMPLIED WITH EN 1179-10.SDR USAA2010081991710Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FRAME TRACE BEAM AT BS 243.7, S17L. REPAIRED FRAME TRACE BEAM AT BS 243.7, S17L IAW EA 102099.SDR USAA2010081091628Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FRAME WEB AT BS 303.9, S16L. REPLACED FRAME WEB AT BS 303.9, S16L IAW JOB CARD 03-0553-8-0528.SDR C2XA10SH256Frame · corrodedSHV - DURING C-CHECK FRAME 65 WAS FOUND TO BE CORRODED BETWEEN STRINGERS 16-17L. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW EC5310-01505. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.
Back to JASC 5311