JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 SWAA2013031113501Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STA 300 TO STA 319. REPAIRED BEAM PER SRM.SDR SWAA2013040214381Window Frame · crackedNR 3 FIRST OFFICER WINDOW FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM AND EA.SDR SWAA2013040214390Window Frame · crackedFIRST OFFICERS WINDOW FRAME CRACKED ON THE 1ST OFFICERS WINDOW FRAME. REMOVED AND REPLACED FRAME IAW ACO AND EA.SDR SWAA2013040214389Window Frame · crackedCAPTAINS NR 1 WINDOW FRAME CRACKED. REMOVED AND REPLACED FRAME IAW ACO AND EA.SDR V0XR201303100174Door Frame · corrodedSURFACE UNDER LOWER AFT MAIN DOOR GUIDE AT FRAME 18 BS 5417 CORRODED. BLENDED CORRODED AREA , FOUND WITHIN LIMITS AT FRAME 18 STA. 5417 IAW EC5310-01684 (TEMPORARY REPAIR OF 600 FC'S PERMANENT REPAIR EC5310-01690)SDR FDEA201303070510Crease Beam · corrodedMAIN DECK RT BS 1340 CREASE BEAM INNER CHORD CORRODED. R & R WITH NEW CREASE BEAM IAW DWG 146N8322 SHT 1, REV F, REPAIR IS MAJOR.SDR DALA1307616707Door Frame · gougedMAIN CABIN FLOOR FRAME, BS 880, RBL 50 HAS FASTENER HOLE WITH DEEP GOUGE. ACCOMLISHED REPAIR IAW SRM 53-00-51 REP. 1 PG 201 FIG 201 PARA 17.SDR UALA2013030801398Door · brokenFIXED LEADING EDGE ICE DOOR AT WS 306, BENEATH LEFT KRUEGER FLAP, BROKEN IN HALF. REMOVED AND REPLACED ICE DOOR AT WS 306.SDR FDEA201303060501Door Frame · misrepairedR2 DOOR LOWER FRAME AFT END LONGERON 27, RT BS 850 MISREPAIRED. REPAIRED IAW EA 1-5310-163599, PART 1.SDR DALA13010879245Structure · crackedMAIN CABIN CENTER WING BOX UPPER SURFACE LT SIDE UPPER CHORD CRACKED AT FORWARD FASTENER GOING VERTICAL APPROX STA 913, LBL 48. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW ERA 498192-14MA AND SRM 51-30-02.SDR HNAA2013030600114Plate · corrodedPLATE ON TOP OF LAVATORY SERVICE BOX IS CORRODED, AROUND DRAIN TUBE VALVE. REMOVED & REPLACED PLATE IAW DWG 85320983.SDR NACA20130402002Door Frame · damagedHOLE DAMAGE TO BS 248.2 FRAME INNER CHORD & INTERCOSTALS & DOORSTOPS FROM S14 TO S7 L1 DOOR ORIFICE.SDR DALA1307463747Failsafe · corrodedAFT CARGO COMPARTMENT BILGE FRAME FAILSAFE CHORD IS CORRODED AT STA 727I S27L TO 27R. INSTALLED ANGLE REPAIR IAW ERA 511666-14, ORIG 1742444.SDR FDEA201303050498Crease Beam · corrodedCABIN BS 1320 TO 1340, LBL 64 TO LBL 70 HAS CORROSION UNDERSIDE OF CREASE BEAM WEB. REMOVED AND REPLACED WITH NEW CREASE BEAM WEB FABRICATED AND INSTALLED IAW DWG 146N8322 SHT.1. REV.F. REPAIR IS MAJOR.SDR ASOA2013032703261Beam · crackedCARGO DOOR SUPPORT BEAM LOWER CLIP IS CRACKED AT FS 621. REMOVED CARGO DOOR SUPPORT BEAM LOWER CLIP AND REPLACED WITH NEW PARTS IAW SRM 51-40-11 AND 5-42-21, PN 601R35050-109, PO W19731.SDR HYIA20130308001Spar Cap · crackedDURING A SCHEDULED MX EVENT CRACKS FOUND ON THE REAR SPAR WEB CRACKS AT FLOOR SUPPORT LOCATIONS. THERE WERE ALSO 5 MISS DRILLS IN THE TOP OF THE REAR SPAR THAT WERE NOTED. AFTER REVIEWING ENGINEERING REPAIR OPTIONS, THE DECISION WAS MADE TO REPLACE REAR SPAR SDR F3LA2013040200841Plate · crackedLT LATERAL SHEAR PLATE CRACKED AFT OF FR69. R & R SHEAR PLATE IAW SRM 51-42-11, PARA 6 AND 10.SDR F3LA2013040200840Plate · crackedRT LATERAL SHEAR PLATE CRACKED AFT OF FR 69. R & R SHEAR PLATE IAW SRM 51-42-11, PARA 6 AND 10.SDR WX0A2013030471524Seat Track · crackedCABIN SEAT TRACK AT FS 950 LBL 22 IS CRACKED AT CENTER. CUT OUT DAMAGED AREA, REPAIRED SEAT TRACK BY INSTALLING REPAIR PLUG.SDR ASOA20130302279TCrossbeam · corrodedACFT IS IN FOR A C-CHECK WHEN CORROSION WAS FOUND IN THE CROSS-MEMBER AT FRAME 20. MX REMOVED THE CORROSION AND INSTALLED A NEW PART AT FRAME 20 SRM 51-40-02 AND 51-40-03. ALL WORK ACCOMPLISHED AND WILL BE RELEASED AT THE END OF THE CHECK.SDR SWAA2013031913826Window Frame · crackedRIGHT NUMBER 3 FLIGHT DECK WINDOW FRAMED CRACKED AT SECOND LOWER CORNER FASTENER HOLE. REMOVED AND REPLACED FRAMES IAW SRM.SDR MTNA20130304013Crease Beam · corrodedFOUND PITTING CORROSION ON CREASE BEAM WEB P/N S53575001225 OUT OF LIMITS. REPLACED WEB IAW ATR SRM.SDR MTNA20130304012Crease Beam · corrodedFOUND PITTING CORROSION ON CREASE BEAM WEB P/N S53575001200 OUT OF LIMITS. REPLACED WEB IAW ATR SRM.SDR MTNA20130304011Crease Beam · corrodedCORROSION ON CREASE BEAM WEB OUT OF LIMITS. REPLACED CREASE BEAM WEB IAW SRM.SDR MTNA20130304010HCrease Beam · corrodedFOUND PITTING CORROSION ON CREASE BEAM WEB P/N S53575002201 OUT OF LIMITS. REPLACED WEB IAW ATR SRM.SDR MTNA20130304009Crease Beam · corrodedFOUND PITTING CORROSION ON CREASE BEAM WEB P/N S53575002200 OUT OF LIMITS. REPLACED WEB IAW ATR SRM.SDR IXXA2013041500002Failsafe · crackedRIGHT FAILSAFE STRAP HAS A 0.450" CRACKED AT THE LOWER HOLE IN INSPECTION AREA. THE CRACK WAS REMOVED DURING THE FAILSAFE TRIM OUT PROCEDURE THAT WAS PERFORMED IAW AMES ENGINEERING DOCUMENT 47008ORD04. REF SB 767-53A0100, REV 3, DATED FEB 06, 2012 AND SB 76SDR ASOA2013031903233Post · crackedRBL 18.0 FS 409.0+128 VERTICAL POST OTBD SIDE HAS A CRACK INDICATION NOTED AT WL 69.0 IN THE AFT FLANGE RADIUS, APPROX .4" X 50 PERCENT FSH FAILED NDT. REMOVED VERTICAL POST AND LOCATED AND DRILLED NEW VERTICAL POST IAW SRM 51-40-11. INSTALLED POST IAW REO 6SDR SWAA2013031913797Window Frame · crackedFLIGHT DECK RIGHT NUMBER 1 WINDOW FRAME UPPER OUTBD CORNER CRACKED. REMOVED AND REPLACED FRAME PER ACO.SDR MTNA20130227008Crease Beam · corrodedFOUND PITTING CORROSION ON CREASE BEAM WEB P/N S53371226220 OUT OF LIMITS. REPLACED WEB IAW ATR SRM.SDR QXEA2013022600506Structure · corrodedFOUND CORROSION ON VERTICAL LEG OF STRINGER 31S AFT OF X156. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED AREA CRACK FREE REF NTM 51-00-06-910-801, PT 1, REV 8.SDR DALA13010329243Beam · corrodedMID CARGO COMPARTMENT DOOR FRAME BEAM CORRODED AROUND FASTENER HOLE, 5" FORWARD OF STA 750. BLENDED, ALODINED, FABRICATED, ANNEALED, PRIMED, AND INSTALLED NEW REPAIR DOUBLER AND FILLER IAW SRM 53-60-02, FIG 9, SHEETS 3 & 4.SDR UALA2013022601152Structure · damagedDAMAGED AREA AT BS 1780-1800 S44R IAW SRM 53-00-01 PER 51-40-08. DOUBLER AND FILLER MANUFACTURED IAW SRM 53-00-01, TREATED WITH CHEMICAL CONVERSION AND PRIMED. MAJOR REPAIR.SDR DALA13009393273Blanking Plate · corrodedDURING INSPECTION, FOUND R1 DOOR FWD AND AFT BLANKING PLATES CORRODED. REMOVED CORROSION IAW SRM 51-74-00, DIMENSIONS AS FOLLOWS: FWD L=1.5" W=1.0"D=.006", AFT L=1.0" W=1.0" D=.005" NO ALLOWABLE DANAGE LIMITATION IN SRM, REPLACED FWD & AFT BLANKING PLATESDR ASOA20130226088Beam · corrodedDURING C-CHECK THE CARGO DOOR CUT-OUT LOWER BEAM WAS FOUND TO BE CORRODED FROM FRAMES 65-68 BETWEEN STRINGERS 15L-16L. MX R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA13013189239Beam · corrodedAFT CARGO DOOR JAM LOWER BEAM IS CORRODED IN SEVERAL PLACES. MARKED DOT NR 89-02 NR0170 - REMOVED CORROSION AT AFT CARGO DOOR JAM LWR BEAM, ORIG MAT 0.280", MAT LOSS 0.084", MAT REMAINING 0.196, FOUND TO BE OUT OF LIMITS, FABRICATED NEW DOUBLER USING SA0952SDR WX0A2013030471523Door Frame · corrodedAFT CARGO DOOR CUTOUT FRAME AT FS 1155 IS CORRODED AT FWD FACE OF FRAME. FABRICATED CHANNEL, FILLER, INTERCOSTAL AND CLIPS AND INSTALLED REPAIR PARTS.SDR DALA13009370909Door Frame · damagedRIGHT WHEEL WELL FWD MLG DOOR FRAME HAS 3 INCH CRACK BELOW DOOR PROXIMITY SENSOR. REMOVED RT MLG FWD DOOR FRAME DAMAGED SECTION. INSTALLED RT MLG FWD DOOR FRAME SECTION IAW DWG 5930584. R & R RT MLG DOOR OPEN SENSOR IAW AMM32-60.SDR SIMA20130222005Frame · crackedCHECKED RIGGING HATCH AREA AND A CRACK WAS FOUND ON FOWARD FRAME. REPAIRED IAW EO EM-53MR-2092 RI.SDR DALA1307020130Structure · crackedCRACKED LOCATION ON STRIP AT STR 7R, TRIMMED OFF IAW SRM 53-80-01, REPAIR 5, FIG 201. REV 91.02. REPAIR PARTS FABRICATED IAW SRM 53-80-01, FIG 201, REPAIR 5. REV 91.02 REPAIR PARTS AT BS 1725.5, STR 7R INSTALLED IAW SRM 53-80-01 FIG 201. REPAIR 5. REV 91.0SDR FDEA201302220416Door Frame · crackedMAIN DECK R3 DOOR FORWARD FRAME WEB FOUND CRACKED. REPAIRED AS PER SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 51. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 116.SDR DALA13008793274Structure · corrodedDURING INSPECTION, FOUND CORROSION ON FWD LOWER CORNER FR 66 AT LEVEL OF STR 23R AFT PAX CABIN. REPLACED IAW 51-72-11 AND DWG D53480505.SDR ASOA2013031403198Post · crackedOTBD VERTICAL POST AT FS 409.00+128, RBL 18 HAS AN INDICATION NOTED AT WL 69.00 .3" LONG X 55 PERCENT FSH. FAILED NDT INSPECTION AFT FLANGE RADIUS. REMOVED INBD & CRACKED OTBD VERTICAL POST AT FS 409+128 RBL 18 IAW SRM 51-42-06. LOCATED FASTENER HOLES IN NEWSDR FDEA201302210395Doubler · corrodedMAIN DECK LT CREASE BEAM WEB DOUBLER CORODED BETWEEN BS 1060 AND 1080. CORRODED DOUBLER REMOVED AN REPLACED WITH NEW DOUBLER FABRICATED AS PER DWG 144N5211 REV.A AND INSTALLED IAW DWG 144N5200 SHT.1 REV.B. REPAIR IS MAJOR.SDR FDEA201302210390Doubler · corrodedMAIN DECK RT CREASE BEAM WEB DOUBLER CORRODED AT STA 312, RBL 64. CORRODED DOUBLER REMOVED. NEW DOUBLER FABRICATED AND INSTALLED IAW DWG 141N8422 SHT. 1 REV. R. REPAIR IS MAJOR.SDR DALA13010290907Window Frame · damagedBS 1132, STR 13R ONE LIGHTING STRIKE ON WINDOW FRAME WINDOW 48. REPAIRED IAW ERA 512095-14 REV ORIG SECTION I TIME LIMITED REPAIR.SDR DALA13010280907Window Frame · damagedBS 1174, S12R ON WINDOW FRAME ONE LIGHTNING STRIKE (WINDOW HAS HEAT DAMAGE) WINDOW NR 51. REPAIRED IAW ERA 512095-14, REV ORIG SECTION I TIME LIMITED REPAIR.SDR DALA13010260907Window Frame · damagedBS 1174, S12R ONE LIGHTNING STRIKE ON WINDOW FRAME. (WINDOW HAS HEAT DAMAGE) WINDOW 50. REPAIRED IAW ERA 512095-14, REV ORIG SECTION I TIME LIMITED REPAIR.SDR DALA13010250907Window Frame · damagedBS 1155, S12R ONE LIGHTNING STRIKE ON WINDOW FRAME. WINDOW NR 50. REPAIRED IAW ERA 512095-14, REV ORIG SECTION I TIME LIMITED REPAIR.SDR DALA13010240907Window Frame · damagedBS 1140, STR 13R, ONE LIGHTNING STRIKE ON WINDOW FRAME. WINDOW 49. REPAIRED IAW ERA 512095-14, REV ORIG SECTION I TIME LIMITED REPAIR.
Back to JASC 5310