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 AALA20100224TUL23Frame · crackedFRAME 400 CRACKED AT INBOARD RIVET OF AIR CONDITIONING RAIL BRACKET RIGHT SIDE. REPAIRED FRAME PER J1159AC.SDR AALA20100224TUL22Frame · crackedFRAME CRACKED STA 500 I/B RIGHT A/C RAIL BRACKET. REPAIRED PER ECO-1159AC REF DWMS NON ROUTINE 1298061.SDR AALA20100224TUL20Frame · crackedFRAME CRACKED AT INBOARD AIR CONDITIONING RAIL BRACKET ATTACHMENT FASTENER AT STATION 480 LEFT. REPAIRED FRAME PER ECO J1159AC.SDR AALA20100224TUL15Frame · crackedFRAME CRACKED AT INBOARD AIR CONDITIONING RAIL BRACKET RIGHT SIDE STATION 400. REPAIRED PER ECO-J1159AC.SDR AALA20100224TUL11Frame · crackedFRAME CRACKED AT INBOARD AIR CONDITIONING RAIL BRACKET STATION 480 LEFT. REPAIRED PER ECO J1159AC.SDR AALA20100224TUL19Frame · crackedFRAME CRACKED AT INBOARD AIR CONDITIONING RAIL BRACKET ATTACHMENT FASTENER AT STATION 480 LEFT. REPAIRED FRAME PER ECO J1159AC.SDR USAA2010021890397Attach Fitting · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME ATTACH CLIP AT BS 360, S11L. REPLACED FRAME ATTACH CLIP AT BS 360, S11L IAW B737 SRM 51-10-02.SDR SWAA100907Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER AEM EO.SDR C2XA10SH060Frame · crackedSHV - DURING C-CHECK FR 10 CRACKED AT STR 10R. REPAIRED FR 10 IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20100216TUL03Frame · corrodedHEAVY CARGO/AFT - CORROSION ON FRAME LOWER FLANGE STATION 1271 LONGERON 28 LEFT TO LONGERON 28 RIGHT. BLENDED AND REMOVED CORROSION PER SRM 51-10-03 FOUND TO BE OUT OF LIMITS PER SRM 53-01. TREATED AND PRIMED AREA PER SRM 51-10-3. INSTALLED REPAIR DOUBLER PSDR USAA2010021990406Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 601, S17L. REPAIRED FUSELAGE FRAME AT BS 601, S17L IAW EA 101739.SDR FDEA201002160435Frame · damagedMAIN DECK STA 395 FRAME BETWEEN STR S-1 AND S-2R HAS EXISITING HOLES WITH LESS THAN SRM PITCH AT BS 395 S-2L TO S-2R FRAME REPAIR WAS ACCOMPLISHED ON MAE W/C 43188560001 AND MAE EA 757-5332-16-F2538, REV -DATED 02/10/2010. CLASSIFIED CATEGORY "A" MAJOR REPAISDR SWAA100896Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER AEM EO.SDR AALA20100215TUL04Frame · crackedAFT ACCESSORY CANT FRAME CRACKED AT STATION 1497 BELOW RIGHT LOUVER BOX. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-15 AND SRM 51-01-00.SDR ASOA201000244Frame · corrodedCORROSION ON FS 349.00 FRAME TO ATTACHMENT FLANGE BETWEEN STR 26L - STR 26R. (3 PLACES). REMOVED FRAME IAW SRM 51-42-06 STEPS A, B1 THROUGH 6 AND SRM 51-42-21 STEPS 11A1 AND B1. LOCATED AND DRILLED NEW FRAME SECTOR IAW AMM 51-42-06. INSTALLED NEW FRAME SECTSDR DALA103849861Frame · crackedDURING "L" CHECK FOUND FRAME WEB AT STA 1209, FRL12L, WAS CRACKED, AT LIGHTING HOLE. REPAIRED IAW SRM 51-70-4.SDR SWAA100816Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 291.5, RBL 55. REPAIRED FRAME PER SWA EA.SDR DLM88100375Frame · corrodedAFT CARGO COMPARTMENT FWD SIDE OF APB, TEE CHORD AND FRAME AFT SIDE HAS CORROSION AT L-30 TO L29L. MRB 53-100-17 REPLACE BOTH TEE CHORD AND T-CAP/FRAME/ANGLE.SDR SWAA100812Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 380, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA100807Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727C, STR 14R. REPAIRED FRAME PER ER.SDR SWAA100803Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 942, STR 18L. REMOVED AND REPLACED FRAME PER SRM.SDR C2XA10SH059Frame · corrodedSHV - DURING C-CHECK FR 65 HAS CORROSION BETWEEN STR 16L AND 17L. REPAIRED FR 65 IAW EC5310-01505. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 22AA201000048Frame · corrodedDURING "C" CHECK , AFT CARGO COMPARTMENT BILGE AREA FRAME (STA 1996) LOWER CHORD CORRODED AT LBL 15 TO RBL 15 AS MARKED. NON-ROUTINE NR 0610, AFT CARGO COMPARTMENT BILGE AREA FRAME (STA 1996) LOWER CHORD, LBL 15 TO RBL 15 CORROSION, REMOVED AND REPROTECTED IAWSDR ZZDA2010112Frame · corrodedAFT CARGO COMPARTMENT FRAME SECTION, STA 1022, LONG L28L TO L28R, CORROSION. ACCOMPLISHED FRAME SECTION SPLICE REPAIR PER B717 SRM 53-20-07 FIG 201.SDR USAA2010021590380Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME AT BS 727D, S8L - S9L. REPAIRED FRAME AT BS 727D, S8L - S9L IAW B737 SRM 53-10-20.SDR ASOA201000220Frame · corrodedGENERATED FROM OP 297/FRAME SECTION 333 BETWEEN RBL 26 AND LBL 26 CORRODED FWD AND AFT SIDE. FINISH INSTALLING FRAME PN 601R32004-55. TP161741 2/13/10 (AJ 2/13/10) INSTALLED REMAINING FASTNER IN FRAME 333 AND APPLIED FINISH A023 IAW SRM 51-42-21 AND 51-21-16SDR COMA2010021550042Angle · crackedFOUND CRACK IN FRAME CAP ANGLE AT FS 559.00 LBL 18.00 INBOARD SIDE. REPAIRED CAP ANGLE AT FS 559.00 IAW REO 601R-53-41-260.SDR USAA2010021590386Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME AT BS 380, S8L - S9L. REPAIRED FRAME AT BS 380, S8L - S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010021590369Structure · corrodedPIT - C11 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FRAME CLEATS AT FR 35.1 TO FR 35.5 & BETWEEN S40R TO S41R. REPLACED FRAME CLEATS AT FR 35.1 TO FR 35.5 & BETWEEN S40R TO S41R IAW A321 SRM 51-42-11, 51-72-11 & 53-21-12.SDR FDEA201002120406Frame · damagedBS 640, S26L/R, FRAME HAS AN EXISTING ELONGATED HOLE AT BS 640 FRAME, S26L, PREVIOUS ELONGATED HOLE CONFLICTED WITH ACCOMPLISHMENT OF PTF CONVERSION. A NEW FRAME REPAIR WAS ACCOMPLISHED AT BS 640 FRAME, S25L / 26L, DURING PTF CONVERSION ON MAE MOD W/C NR 11SDR AALA20100211TUL14Frame · crackedTHE 1418 FRAME IS CRACKED ON AFT SIDE OF FRAME AT LONGERON 2 LEFT AND 2 RIGHT. REPAIRED PER SRM 53-03 FIGURE 31A.SDR UIEA201000046Frame · crackedFUSELAGE - BS 1540, S5;-S6L FRAME CRACK REPAIR. 8100-9 SRM 53-10-04 FIG 1, 2ND STAGE 25,000 TFC.SDR USAA2010021990407Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 787 BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8R & S9R IAW TYPICAL REPAIR 53-10-20.SDR ASAA1047393Frame · crackedFRAME IS CRACKED AT BS 296.5. FOUND REPAIR DOUBLER ON FRAME AT BS 296 TO BE CRACKED. FABRICATED REPAIR PARTS AND REPLACED DOUBLER.SDR USAA2010021590385Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME AT BS 747, S8R - S9R. REPAIRED FRAME AT BS 747, S8R - S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010021590384Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME AT BS 727D, S8R - S9R. REPAIRED FRAME AT BS 727D, S8R - S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010021590382Frame · corrodedCLT - MAJOR REPAIR - Q5 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FRAME FOOT AT BS 1006, RBL 3. REPAIRED FRAME FOOT AT BS 1006, RBL 3 IAW B737 SRM 51-40-02.SDR SWAA100788Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, STR 6L. REPAIRED FRAME PER SRM.SDR ASOA201000204Frame · corrodedCORROSION FOUND ON FRAME FS 349 LBL 6 APPROX (MARKED). REMOVED FRAME. VERIFIED POSITION OF NEW FRAME AND DRILLED IAW SRM 51-40-11. INSTALLED FRAME IAW SRM 51-42-06.SDR ASOA201000203Frame · corrodedFRAME SECTION 333 BETWEEN RBL 26 AND LBL 26 CORRODED FWD AND AFT SIDE. REMOVED CORROSION ON FRAME IAW SRM 53-21-15. MECHANICALLY MEASURED FRAME 333 FOUND TO BE OUT OF LIMITS IAW SRM 53-21-15. REMOVED FRAME. DRILLED NEW FRAME IAW SRM 51-42-06 AND 51-42-21SDR ASOA201000201Frame · corrodedFUSELAGE FRAME HAS CORROSION FS 333.0 STR 26L TO STR 27. REMOVED FUSELAGE FRAME AT FS 333.00 STR 23L-23R IAW SRM 51-42-06 & 51-42-21. NEW FRAME SECTOR REQUIRES LOCATED, DRILLED, AND INSTALLED. NEW FRAME SECTOR IS LOCATED AND DRILLED IAW 51-42-06 STEP 7 A & SDR ASOA201000200Frame · corrodedFUSELAGE FRAME HAS CORROSION AT FS 319.7 STR 27. REMOVED 9 EA RIVETS FOR ACCESS TO CORROSION AND BLENDED (APPROX .001-.002) FROM FRAME AT FS 319.7 STR 27 TO REMOVE CORROSION IAW SRM 51-42-06 & 51-21-06 STEP 3E. INSTALLED RIVETS 9 EA AND TREATED, PRIMED, ANSDR SWAA100776Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED BS 440, STR 25R. REMOVED AND REPLACED FRAME PER SRM.SDR UVVR2010021100001Frame · cracked3 INCH CRACK IN LEFT FUSELAGE SIDE FRAME AT FUSELAGE STATION 257.65 APPROXIMATELY 2 INCHES ABOVE CABIN FLOOR.SDR FOTR20006NR2027Frame · damagedUPPER CABIN FRAME DAMAGED AT BS 380 STR 5L. REPAIRED ON FASI WO 20006. N/R 02027. INSTALLED REPAIR ANGLE TO FUSELAGE FRAME AT BS 380, STR 5L IAW B727 SRM 53-10-4 FIG 1, REV 102. MATERIAL USED; 7075-O, HEAT TREATED TO T-6 CONDITION. DIM.; 11 BY 1 BY 0.063.SDR ASAA1047386Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE JUST ABOVE STR 8L AT BS 360. CUTOUT CRACK AND REPAIRED WITH DOUBLERS.SDR USAA2010021990409Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 601, S17L, LBL 65.5. REPAIRED FUSELAGE FRAME AT BS 601, S17L, LBL 65.5 IAW TYPICAL REPAIR 53-62-01.SDR ASAA1047384Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT BS 380. REPLACED FRAME.SDR SWAA100769Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA100749Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER EA.
Back to JASC 5311