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 SWAA074372Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 616, STR 17R. REMOVED AND REPLACED FRAME CHORD PER MM.SDR SWAA074363Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074362Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR 07FDEA03339Frame · corrodedCORROSION ON FRAME 57 INNER FLANGE AT STR 14 RT. REPAIR PERFORMED BY REWORK IAW EA 6-5316-92212 AND RAS/DAHAM/4020097/2005 ISS B.SDR SWAA074356Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074357Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074355Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074352Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR 07FDEA03314Frame · damagedTOOLING MARKS WERE FOUND AT FRAME 12A BETWEEN STRG 26-27 RT. REPAIR PERFORMED BY REMOVING FASTENERS, SMOOTH BLEND OUTS, FOR ELIMINATE THE DEEPEST MARK A 13MM SKIN HOLE DIA WAS PERFORMED, ROTO TEST AND HFEC INSPECTION WITH NIL FINDINGS AND ONE 13MM DIAMETER SDR 07FDEA03313Frame · damagedNUMEROUS FASTENERS WERE FOUND TO BE NON CONFORMING AND ELONGATED ON FITTING FRAME 12A, FRAME 12A AND CORNERS RT AND LT SIDES. REPAIR PERFORMED BY DETAILED VISUAL AND ROTO TEST INSPECTIONS IN DAMAGED HOLES. REPLACMENT OF FITTING, CORNER SPLICE AND CORNER ANSDR NWAA073076719Frame · deformedDURING "M" CHECK, FOUND DEFORMATION DAMAGE TO FRAME INNER CHORD AT BS 1860 S11R. REPAIRED PER EA 67-209754.SDR CALA0700493Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FRAME AT STA 480 BETWEEN STRINGERS 8 AND 9R. A REPAIR WAS INSTALLED IAW ECRA 5310-04651.SDR SWAA074336Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074338Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074337Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700487Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 807 BETWEEN S27L AND S27R, LBL 6 TO RBL 6. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND 51-10-02.SDR DLM90071326Frame · corrodedAFT PIT FWD SIDE OF FRAME CORRODED STA1344 28L-29R. REPAIRED FRAME AT STA 1344 IAW MD90 SRM 53-10-02A VOL I.SDR SIMA200725608Frame · corrodedDURING A HMBV INSPECTION, THE GALLEY FLOOR FRAME AT STA 258 WAS FOUND CORRODED. REPAIRED CORRODED AREA IAW SAAB SRM 53-70-30 AND SRM 51-40-21. AIRCRAFT RETURNED TO SERVICE.SDR SWAA074327Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074346Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074349Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074348Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074328Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074329Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074351Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074350Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074347Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074345Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074326Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR NWAA073056719Frame · crackedDURING "M" CHECK, FOUND CRACKS IN FRAME AT BS 280 S24R TO S24L. REPAIRED PER EA 67-209749.SDR TRAX200701283Frame · corrodedFR 38 CORRODED, FOUND OUT OF LIMIT ON W/C 100-44, NEEDS REPAIR. REPAIRED AS PER SRM 53-61-40 FIG 414.SDR SWAA074313Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074314Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 312, STR 6L. REPAIRED FRAME PER SRM.SDR UIEA200700329Frame · crackedBS 800 S17 LT ONE FASTENER HOLE FOUND CRACK ON FWD INNER CHORD ANGLE. REPLACEMENT PER BOEING CONTROL NO PO24708.SDR 07FDEA03291Frame · crackedFRAME 38 CRACKED WHERE FRAME LEG ATTACHES TO FUSELAGE SKIN, BETWEEN STR 41L AND STR 42L. TRIMMED CRACKED FLANGE, FABRICATED AND INSTALLED REPAIR FALSE FLANGE IAW EA 6-5310-109195, FUSELAGE FRAME, FRAME 38 BETWEEN STRINGER 41 AND 42 CRACKED FLANGE, REPAIR.SDR 07FDEA03283Frame · damagedMISDRILLED HOLE IN AFT FITTING FRAME 47 LT, STRG 24 NEAR HOLE G OF SB 53-61-23. REPAIR PERFORMED BY SPOTFACING THE MISDRILLED HOLE, OVERSIZING HOLE G AND INSTALLING FASTENER NSA5357-4 IAW EA 6-5315-99153 AND RAS 0453451/012/2006 ISSUE A.SDR 07FDEA03266Frame · corrodedCORROSION FOUND ON FWD FACE OF FRAME 92 ON DOUBLER. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03265Frame · corrodedCORROSION FOUND ON FWD FACE OF FRAME 92 ON SEVERAL ANGLES. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03264Frame · corrodedCORROSION FOUND ON FWD FACE OF FRAME 92 ON T-SECTION. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR TRAX200701274Frame · corrodedON FRAME 38 BETWEEN STRINGER 21 LEFT AND STRINGER 20 LEFT CORROSION FOUND. CORROSION REMOVED IAW SRM 51-21-42.SDR ZZDA2007267Strap · crackedAFT FUSELAGE COMPARTMENT CANTE FRAME SUPPORT STRAP AT STA 1178, BETWEEN LONG 16 AND 17 LEFT HAND CRACKED. INSTALLED FORMED ANGLE REPAIR AT FUS 1178 BETWEEN LONG 16 AND 17 LEFT HAND PER SRM 51-70-11 FIG 201.SDR ZZDA2007266Strap · crackedAFT FUSELAGE COMPARTMENT CANTE FRAME SUPPORT STRAP AT STA 1178, BETWEEN LONG 16 AND 17 RIGHT HAND CRACKED. INSTALLED FORMED ANGLE REPAIR AT FUS 1178 BETWEEN LONG 16 AND 17 RIGHT HAND PER SRM 51-70-11 FIG 201.SDR SWAA074296Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA074303Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA070693Frame · corrodedSTA 727E, LBBL 8 ON FRAME WHERE IT ATTACHES TO SKIN EXFOLIATED. FABRICATED REPAIR PART & INSTALLED PER SRM 53-60-07; CORR TASK C53-208-01, DEFECT SIZE: 1 INCH.SDR 07FDEA03240Frame · damagedFOUND DEVIATIONS BETWEEN RAS/AS/212/2003A AND A/C CONDITION AND DEVIATIONS TO SB 53-6125 ON FRAME 45, STRG 26-28 RHS AND LHS. REPAIR: HOLES H1 RT AND LT AND H2 FRAME 45 LT: COLD WORKING, BUSH INSTALLATION IN FRAME AND DOUBLER, NEW NOMINAL FASTENER NSA5351V4 ISDR F3LA200700207Frame · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED RT SUPPORT FRAME BETWEEN FR69 AND FR70 CORRODED. REMOVED AND REPLACED SUPPORT FRAME IAW A319 SRM 51-42-11.SDR CALA0700474Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FRAME AT STA 500D ONE INCH ABOVE S13R. THE FRAME WAS REPAIRED IAW SRM 53-00-07.SDR NWAA073096719Frame · crackedDURING "M" CHECK, FOUND CRACKS IN FRAME WEB DOUBLER AT BS 880 S9L. REPAIRED PER EA 67-209743.SDR 2007UALA03464Frame · crackedFRAME CRACKED BS 616R RBL 62-64 OVERWING BODY FRAME INNER CHORD. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED REPAIR ANGLE.
Back to JASC 5311