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 SWAA074286Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074267Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074282Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074269Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074273Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074281Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074272Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074287Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074270Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074271Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700472Frame · crackedINSPECTION FOUND A .5 INCH CRACK AROUND RIVET IN FRAME AT STA 887 ABOVE S9L STRINGER TIE. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700471Frame · crackedINSPECTION FOUND A .5 INCH CRACK AROUND RIVET IN FRAME AT STA 867 ABOVE S9L STRINGER TIE. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700470Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 400 BELOW S8R. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700469Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FRAME AT STA 380 BELOW S8R. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700468Frame · crackedINSPECTION FOUND A .75 INCH CRACK AROUND RIVET IN FRAME AT STA 827 ABOVE S9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700467Frame · crackedINSPECTION FOUND A .75 INCH CRACK AROUND RIVET IN FRAME AT STA 887 ABOVE S9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700466Frame · crackedINSPECTION FOUND A .75 INCH CRACK AROUND RIVET IN FRAME AT STA 827 ABOVE S9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700465Frame · crackedINSPECTION FOUND A .75 INCH CRACK AROUND RIVET IN FRAME AT STA 867 ABOVE S9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04650.SDR CALA0700464Frame · crackedINSPECTION FOUND A .75 INCH CRACK AROUND RIVET IN FRAME AT STA 807 ABOVE S9L. REPAIR PARTS WERE INSTALLED IAW ECRA 5310-04650.SDR 07FDEA03223Frame · gougedGOUGES FOUND AT FRAME 55 LHS AND RHS, BETWEEN STRG 14-15. REPAIR PERFORMED BY SMOOTH BLENDING AND NDT INSPECTION IAW EA 6-5316-99140 AND RAS/DATLS/0003069/2006 ISSUE A.SDR COEA0706900Frame · crackedPERMANENT REPAIR OF HYDRAULIC CUTOUTS. PERMANENT REPAIR TO FRAME 25 LT AND RT SIDES C/W SB ATR 42-53-0121. (K)SDR COEA0701900Frame · corrodedCORROSION FOUND IN HEAVY CK: FLIGHT DECK FRAME 13 STRINGER 21R-14R HAS LEVEL 2 CORROSION TOP AND LOWER SIDE OF FLOORBEAM. REMOVED CORRODED FLOORBEAM FROM STR 21R TO RBL RUNOUT. INSTALLED FABRICATED FLOORBEAM AT FRAME 13 STR 21R-14R. WO NR 69312, NR 100014. SDR 07FDEA03196Spar · crackedFOUND CRACKS AT HOLE H NR 11 AND H NR 24 IN REAR SPAR AT SPOILER NO:NR 3 LT ACTUATOR FITTING. REPAIR PERFORMED BY REAM UP UNTIL CRACK REMOVAL OF HOLES IAW EA 6-5720-103316 AND RAS/BAE/1003422/2006 ISS "A".SDR SWAA074256Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074246Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074249Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074259Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074250Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074255Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787 S8L AND S8R. REPAIRED FRAME PER SWA EA.SDR SWAA074247Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747 S8R. REPAIRED FRAME PER SWA EA.SDR SWAA074258Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074248Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074251Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074245Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074257Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074252Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L AND STR 17R. REPAIRED FRAME PER SRM.SDR CALA0700463Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 947, S26R TO S27R. THE FRAME WAS REPAIRED IAW SRM 53-00-07.SDR 07FDEA03195Frame · damagedFOUND 3 DRILLING MARKS AT FRAME 12 LH OF NLG-WELL. REPAIR PERFORMED BY SMOOTH REWORK OF DRILLING MARKS IAW EA 6-5312-101328 AND RAS/046631/007/2006 ISS A.SDR 07FDEA03176Frame · corrodedHEAVY CORROSION FOUND ON FRAME 92 AT SEVERAL ANGLE SECTIONS, STRG 14 RT TO 17 LT. REPAIR PERFORMED BY REPLACEMENT OF PARTS IAW SRM 51-72-10.SDR 07FDEA03173Skin Panel · dentedTOOLING MARK (DENT) IN SKIN 240MM BEHIND FRAME 26/32 BETWEEN STRG 50-51 LHS. DENT REPAIR PERFORMED WITH SKIN REPAIR BUSH PER SRM 53-10-12/FIG 221/SH 1 AND 2.SDR 07FDEA03172Frame · damagedOLD MISDRILLED MARK ON THE CONNECTION SECTION FRAME 64-65, STRG 37 RT. REMAINING THICKNESS AFTER REMOVING OUT OF LIMIT. REPLACEMENT OF CONNECTING SECTION IAW SRM 51-72-10.SDR 07FDEA03169Frame · corrodedCORROSION ON CROSS STRUT FRAME 86, STRG 15 RHS. REMAINING THICKNESS OUT OF LIMIT. CROSS STRUT REPLACED IAW SRM 51-72-10.SDR 07FDEA03165Frame · corrodedCORRSOSION IN UPPER CORNER FITTING AT FRAME 88, STRG 15-17 RHS. REPAIR PERFORMED BY CUTTING AND INSTALLING DOUBLER IAW EA 6-5319-103257.SDR 07FDEA03164Frame · corrodedCORRSOSION IN UPPER CORNER FITTING AT FRAME 88, STRG 15-17 RHS. REPAIR PERFORMED BY CUTTING AND INSTALLING DOUBLER IAW EA 6-5319-103257.SDR 07FDEA03163Frame · corrodedCORRSOSION IN UPPER CORNER FITTING AT FRAME 88, STRG 15-17 RHS. REPAIR PERFORMED BY CUTTING AND INSTALLING DOUBLER IAW EA 6-5319-103257.SDR USAA070672Frame · crackedSTA 867 AT I/B FASTENER FOR A/C SUPPORT BRACKET, BETWEEN STR 8 & 9R HAS CRACK. INSTALLED TYPICAL FRAME REPAIR DOUBLER PARTS PER TR 53-10-20E, DEFECT SIZE: .125 INCH.SDR GLBA20060991Frame · crackedFRAME CRACKED AT FS 177.35 APPROXIMATELY 1 INCH AT CUTOUT FOR STRINGER 9R. MAINTENANCE REPAIRED CRACK AT STRINGER RELIEF HOLE 9R AT F.S. 177.35 IAW SRM 51-70. REPAIR APPROXIMATELY 5.5 INCH BY 2.5 INCH. 2024 T3, .080. RII COMPLIED WITH IAW TASKCARD 8.2.1.SDR SWAA074225Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074227Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074229Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311