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 08FDEA04951Frame · corrodedEMPENNAGE FRAME 84 AT STRINGER 13 L, THE FRAME LOWER CHORD IS CORRODED AT AND UNDER THE CROSSBEAM. REMOVED CORROSION FROM THE FRAME FLANGE IAW SRM 51-74-10. FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00, FIG 105 AND TABLE 102. REMOVED THE FLANGE IAW SRM 51-40-SDR 08FDEA04950Frame · misrepairedFOUND AFT PIT FRAME REPAIR LOCATED AT APPROX BS 1050 STR S-27L TO 26L. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA EVALUATION DETERMINED INSUFFICIENT FASTENERS. REMOVED REPAIR SRM 51-30-SDR KCSA081601Frame · damagedFORWARD BILGE FUSELAGE FRAME IS DAMAGED AT STA 820, RBL 27.SDR DHLA2009743DH654Frame · dentedUPPER FUSELAGE MAIN CARGO CABIN AT BS 360 BTWN S-4L AND S-5L FRAME INBD FLANGE WITH DENT. REPAIRED FRAME SECTION AT BS 360 BTWN S-4L AND S-6L IAW EO COO-2-53-430-08 DTD 11/24/08 DOCUMENTED ON FAA FORM 8110-3.SDR AALA200810427Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP CORNER LEFT SIDE STATION 1098. REPAIRED PER AARD 53-10-00-25.SDR AALA200810426Frame · crackedWINDOW FRAME, CRACK IN FRAME TOP CORNER LEFT SIDE STATION 1060. REPAIRED PER AARD 53-10-00-25.SDR AALA200810349Frame · corrodedCORROSION IN FRAME 1287 BETWEEN LONGERON 25 LEFT AND LONGERON 29 RIGHT. INSTALLED JAY ANGLE.SDR MALA080206Frame · chafedSEVERAL FUSELAGE FRAMES INNER FLANGES CHAFED. REPAIRED IAW EO NR S53641, S53642, S53152.SDR UALA2008112106606Frame · dentedAFT PIT AT STA 1500, STR 26L FRAME DENTED AT INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED. INSTALLED FRAME REPAIR.SDR 08FDEA04936Frame · corrodedCORROSION ON THE FWD CARGO BILGE AREA AT ST 480 BETWEEN STR 27R AND STR 26R. CUT OUT DAMAGE AREA SHEAR TIE IAW SRM 53-10-4 FIG 15. FAB SHEAR TIE IAW SRM 53-10-2 FIG 3. HEAT TREAT PART IAW ENGINEERING REPORT NR 2-37153-801 REV A. TREATED AND PRIMED IAW SRM SDR SWAA086444Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086443Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086441Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086435Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER PAE ER.SDR SWAA086426Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086425Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086424Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR AALA200810343Frame · damagedAFT SIDE OF FRAME HAS DEEP WEAR MARK FROM CONTACT WITH G1 GALLEY STATION 148 LONGERON 4 RIGHT. INSTALLED DOUBLER PER ESO 80559 DATED 11-18-08.SDR AALA200810342Frame · corrodedCORROSION IN FRAME STATION 1231 LONGERON 29 RIGHT TO LONGERON 24 LEFT IN AFT CARGO. REMOVED AND REPLACED WITH NEW SECTION OF FRAME AND SPLICE STATION 1231 LONGERON 28 RIGHT TO LONGERON 29 LEFT.SDR UALA2008112006591Frame · dentedAFT PIT AT STA 1520, STR 26L FRAME DENTED AT INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED FRAME SECTION AND INSTALLED DOUBLER REPAIR.SDR 08FDEA04919Frame Splice · damagedAFT CARGO PIT STATION 1030 FRAME SPLICE AT APPROX STRINGER 24L IS DAMAGED. REPLACED FRAME SPLICE REF SRM 51-30-02 AND DRAWING 69-47200. THIS IS CLASSIFIED AS A MAJOR REPAIRSDR SWIA200821022Frame · crackedC-CHECK, FUSELAGE FRAME 10 CRACKED JUST BELOW LEFT DV WINDOW. REPAIRED PER SRM.SDR DHLA2008743524Frame · damagedFUSELAGE FRAME HAS DOUBLE DRILLED HOLES AT BS 680, STR 16R TO 17R. REPAIRED FUSE FRAME SECTION PER SRM 51-40-3 FIG 1.SDR DL757081633Frame · corrodedCORROSION ON FRAME UPPER FLANGE AND SIDE BS 1480 RBL 28 WL 148. REPAIRED FRAME PER SRM 53-00-07.SDR UALA2008112006585Frame · dentedAFT PIT FRAME DENTED STA 1520, RBL 8 TO RBL 9. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED J-ANGLE DOUBLER REPAIR.SDR SWAA086359Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086358Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086357Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086356Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086355Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086354Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086353Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086352Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086351Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086350Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086349Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086348Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086347Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086329Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA04916Frame · corrodedAFT CARGO COMPT, FRAME 1360, AT S-26L, IS CORRODED AND GOUGED. REPAIRED FRAME, AFT CARGO COMPT, BS 1360, AT S-26L, IAW SRM 53-00-07, REPAIR NR 5. THIS REPAIR IS CLASSIFIED AS A CAT "B" MAJOR REPAIR WITH THE FOLLOWING FOLLOW UP REQUIREMENTS, INITIAL AT 37SDR 08FDEA04913Frame · dentedAFT CARGO PIT STATION 1050 FUSELAGE FRAME DAMAGED AT STR 26L. REMOVED DAMAGE ON STA 1050 AT STR 26R. REF SRM 51-40-05 PG1 FABRICATED AND INSTALLED DOUBLER FOR FRAME. REF SRM 51-20-1 PG 1 SRM 51-30-02 PG 1-12 FABRICATED AND INSTALLED NEW END ATTACH ANGLE FOR ISDR 08FDEA04912Frame · dentedAFT CARGO PIT STATION 1030 FUSELAGE FRAME DAMAGED AT STR 26L. REMOVED FRAME DAMAGE STA 1030 STR 26L REF SRM 51-40-3 FIG 1 PGS 1-6. FORMED DOUBLER REF SRM 51-20-1 PG 1 HEAT TREAT DOUBLER TRACKING 2008-11-129. REMOVED INTERCOSTAL STA 1030, INSTALALED INTERCSDR 08FDEA04911Frame · dentedAFT CARGO PIT STATION 1010 FUSELAGE FRAME DAMAGED AT STRINGER 26L. REPAIRED FRAME REF SRM 51-40-03 FIG1 AND FABRICATED CHANNEL ANGLE REF DWG 65-84827-8 SRM 51-30-02 PG 1-5SDR 08FDEA04910Doubler · crackedLT FUSELAGE FRAME RE-INFORCING ANGLE (DOUBLER) HAS A CRACK BS-700, LBL 65 WL-200. REMOVED FRAME RE-INFORCING ANGLE/DOUBLER IAW SRM 51-40-02, RECEIVED NEW ANGLE/DOUBLER AND INSTALLED IAW SRM 51-40-02 AND DWG NR 143N1014 MAJOR REPAIR. NO FOLLOW-UP INSPECTION RSDR SWAA086326Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086313Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 10R. REPAIRED FRAME PER SRM.SDR SWAA086301Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086300Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086299Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086298Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311