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 TAMF201103110065Frame · corrodedDURING C4 CHECK FUSELAGE SECTION 45" CORROSION DAMAGE TO BULKHEAD WEB- UPPER FRAME STA 1065 S11R, S12R. REPAIR WAS PERFORMED WITH EWO 767-53-119.SDR USAA2011040491321Frame · crackedCLT - Q5/QX6 - CRACK ON FUSELAGE FRAME AT BS 500E BETWEEN S20R TO S21R, WL 182.5. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20R TO S21R, WL 182.5 IAW B737 SRM 53-00-07 REPAIR 13 & EA 102765.SDR SWAA111880Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND CORROSION AFT PIT SHEAR TIE BILGE AREA STA 747, RBL 7. REPAIRED PER SRM.SDR SWAA111879Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND CORROSION AFT PIT SHEAR TIE BILGE AREA STA 747, LBL 3 TO RBL 3. REPAIRED PER SRM.SDR SWAA111878Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND CORROSION AFT PIT SHEAR TIE BILGE AREA STA 727C, LBL 9. REPAIRED PER SRM.SDR SWAA111864Failsafe · corrodedDURING SCHEDULED 16Y CHECK, FOUND CORROSION ON AFT CARGO COMPARTMENT FRAME FAIL-SAFE CHORD STA 767, BETWEEN STR 26L AND 26R. REMOVED AND REPLACED FAIL-SAFE CHORD PER SRM.SDR FY4Y197M20110315ASpar · corrodedHEAVY CORROSION ON RT WING INBD MIDFLAP REAR SPAR LOWER CHORD AT WBL142, ORIGINAL THICKNESS 0.121". AFTER CORROSION REMOVED, THE REMAINED THICKNESS WAS 0.051", AREA WAS 3" X 1". IT'S BEYOND LIMITED IAW SRM 57-50-1, PAGE 8. REPAIR METHOD REF SRM 57-50-2, PAGSDR DALA1118399878Frame · crackedMAIN CABIN STA 522 L17L FRAME CRACKED AT FASTENER. CUT OUT DAMAGE 1.5"X 3" AREA. FABBED -32 ANGLE DRILLED AND DEBURRED. REPAIR FROM SR09530095-5. DRILLED AND DEBURRED NEW FILLER PN SR09530095-29. DRILLED AND DEBURRED IAW DC9 SRM 53-01 FIGURE 32 SHEET 4. SDR CA110516028Frame · crackedDURING A PRE-PURCHASE INSP THE ABOVE FRAME ASSY WAS FOUND TO BE CRACKED FROM A RIVET HOLE PROTRUDING TO THE CENTER OF THE FRAME. THE SURROUNDING AREA WAS FURTHER INPECTED AND OTHER DEFECTS NOTED.SDR CA110516026Frame · crackedDURING A PRE-PURCHASE INSPECTION, FRAME WAS FOUND TO BE CRACKED ALL THE WAY ACROSS THE ENTIRE ANGLE AND FLANGE. THE AREA WAS FURTHER INSPECTED AND MORE CRACKS FOUND TO BE PRESENT.SDR CA110516025Frame · crackedDURING INSPECTION, FRAME WAS FOUND TO BE CRACKED ALMOST ALL THE WAY ACROSS THE ENTIRE FRAME. THE FRAME ASSY WAS R & R NEW.SDR A6WA201140222Frame · corrodedFS 333.00, FRAME CORRODED IN FWD AVIONICS BAY. REMOVED DAMAGED AREA FROM FRAME IAW REO 601R-53-21-1253, REV C. INSTALLED SERVICEABLE PARTS, IAW REO 601R-53-21-1253, REV C.SDR DALA1125190687Frame · dentedAFT PIT HAS TWO DENTS IN UPPER FLANGE OF FRAME AT BS 1460. ONS AT STR 26L AND ONE 3.5 INCHES ABOVE STR 26L. REPAIRED UPPER FLANGE FRAME IAW SRM 53-00-07 FIG 201 REPAIR 5.SDR DALA1125160687Frame · dentedFUSELAGE FRAME UPPER FLANGE HAS A DENT AT STA 1420 BETWEEN S25L TO S26L. REPAIRED J SECTION IAW SRM 53-00-07 FIG 201 REPAIR N'5 DETAIL II.SDR USAA2011040491320Frame · crackedCLT - Q5/QX6 - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R, WL 182.5. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R, WL 182.5 IAW B737 SRM 53-00-01 REPAIR 13 &S AIRWAYS EA 102744.SDR ASOA201100460Frame · corrodedFUSELAGE FRAME AT FS 319.70 HAS SEVERAL AREAS OF CORROSION BETWEEN STR 25L AND STR 25R. FOUND CORROSION DAMAGE ON FRAME SECTOR AT FS 319.70 BETWEEN STRINGERS 25L AND 25R TO BE BEYOND ALLOWABLE DAMAGE LIMITS IAW SRM 53-00-00. NEW SERVICEABLE FS 319.70 FRAME SSDR ASOA201100459Frame · corrodedFUSELAGE FRAME AT FS 333.00 HAS SEVERAL AREAS OF CORROSION ON FWD SIDE OF FRAME BETWEEN STR 25L AND STR 25R. FOUND TO BE BEYOND ALLOWABLE DAMAGE LIMITS IAW SRM 53-00-00. REMOVED, LOCATED, DRILLED, AND INSTALLED FRAME IAW SRM 51-40-11, 51-42-06 & 51-42-21.SDR SWAA111660Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR DALA1117086309Frame · crackedDURING HFEC INSPECTION FOUND 2 INCH LONG CRACK AT BX 2674.85 WL 305. FWD SIDE OF FRAME. CUT OUT DAMAGE, FABBED REPAIR OUT OF 2024T3 .050", TREATED AND INSTALLED PER SRM 51-70-11 FG 201 ID TAG INSTALLED PER PS 900 5-1 INSPECTION RII MTC COMPLETE.SDR ZZDA2011288Frame · corrodedAFT CARGO COMPARTMENT FRAME SECTION, STA 1002, LONG 30, CORROSION. ACCOMPLISHED FRAME SECTION REPLACEMENT PER B717 SRM 51-41-02 AND 51-41-05 AND BOEING DWG PL9957739-151.SDR FDEA201103090926Frame · gougedAFT PIT FRAME AT BS 1070 UPPER FLANGE IS GOUGED ABOVE STR. 27L. CUT OUT DAMAGED AREA OF FRAME BS 1070 UPPER FLANGE ABOVE STR 27L IAW SRM 51-40-3 FIG 1. FABRICATED DOUBLER IAW SRM REV 103, 51-40-3 FIG 1 AND 51-30-5. INSTALLED DOUBLER IAW SRM 51-40-3 FIG 1.SDR SWAA111645Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA111644Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA111567Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA111566Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA111565Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR C2XA11SH062Frame · crackedSHV - DURING C-CHECK RT FRAME 10 CRACKED. REMOVED AND REPLACED FRAME 10 IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA111910Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND CRACK ON DOOR CUTOUT STRUCTURE STA 294.5, STR 7R. REPAIRED FRAME PER EA.SDR IPXA11565458Frame · damagedINSPECTION TYPE:C3, BS 500, FRAME HAS A PREVIOUS OVERSIZED HOLE THAT REQUIRES REPAIR JUST ABOVE STR 14R IN WEB OF FRAME. REPAIRED BS 500 FRAME IAW SRM 53-00-07-2R-1.SDR SWAA111881Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND CORROSION AFT PIT SHEAR TIE BILGE AREA STA 807, LBL 3. REPAIRED PER SRM.SDR DALA1116309878Frame · crackedAFT ACCESSORY CANTED FRAME, STA 1245, STIFFENER CRACKED AT L6R. REMOVED FASTENERS TO GET ACCESS AT CRACKED STIFFENER IAW SRM 51-30-2 STOP DRILLED ENDS OF CRACK IAW SRM 53-01, FIG 2. FABRICATED 2EA REPAIR ANGLES IAW SRM 53-01, FIG 2. INSTALLED REPAIR ANGLES SDR SWAA111537Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111536Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111527Doubler · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME DOUBLER CRACKED AT BS 492, STR 25R. REPAIRED DOUBLER PER SRM AND BAC DWG.SDR SWAA111493Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA111487Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER EA.SDR SWAA111480Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA111472Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 23L TO STR 25L. REPAIRED FRAME PER SRM.SDR SWAA111471Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111470Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA111467Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 25L TO STR 27L. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA111466Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM AND BAC DWG.SDR AALA20110308TUL01Frame · crackedAFT ACCESSORY FRAME 1418 CRACKED IN RADIUS AT LONGERON 2 RIGHT. STOP DRILLED CRACK AND INSTALLED REPAIR ANGLE AND RADIUS STRAP PER SRM 53-03-00 FIGURE 31A.SDR FDEA201103080907Spar Cap · corrodedLT WHEEL WEEL REAR SPAR CAP ANGLE SHOWS SIGNS OF CORROSION ON INBD AND OTBD ENDS OF ANGLE, APB7080-1. REMOVED CORROSION ON LT WHEEL WELL REAR SPAR CAP ANGLE IAW SRM 51-21-00.SDR 1MUR20110307001Frame · corrodedAFT CARGO COMPARTMENT AT BS NR 787 FRAME BELOW DOOR SILL AT RBL NR 26 HAS WIDE SPREAD LEVEL II CORROSION NOTED ON FRAME.SDR CALA2011F00108Frame · corrodedSTRINGER S22R- S 26R, LEVEL II, CORROSION NOTED ON FRAME.SDR USAA2011033191296Frame · crackedCLT - Q5/QX6 - CRACK ON FUSELAGE FRAME AT BS500C, S21L. REPAIRED FUSELAGE FRAME AT BS500C, S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA1123131200Frame · crackedCABIN RT STA 903 BETWEEN STR 20R AND STR 21R FRAME INNER CHORD CRACK REPAIR ACCOMPLISHED AS PER ERA 489714-14AD REV ORIG.SDR FDEA201103070900Frame · corrodedAFT PIT, HAS SURFACE CORROSION ON FRAME BS 950B BETWEEN STR 28L & 27L. CUTOUT DAMAGE AREA, FABRICATED REPAIR DOUBLER & INSTALLED DOUBLER IAW SRM 51-40-3 FIG. 1 REV. 103.SDR SWAA111580Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 294.5 BETWEEN STR 2R -3R. INSTALLED NEW FRAME AND FASTENERS PER SRM.
Back to JASC 5311