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 SWAA2013072518565Window Frame · crackedCAPTAIN`S NR1 WINDOW FRAME CRACKED. R&R FRAME IAW ACO.SDR DALA13035329205Support Fitting · out of limitsRIGHT MLG RETRACT ACTUATOR SUPPORT FITTING INBD BORE IS OVER 2.2755 RE-WORK LIMIT IAW 5740-01140-0201. REPAIRED RT MLG BUSHING IAW PRI ERA 51490-14AD, REV O AND FINAL ERA 514904-14AD, REV O.SDR FDEA201307091512Splice · damagedDURING PFM WORK CARD E6-5310-7-5017 B PT3" FUSE FR47 SPLICE FITTING BETWEEN STR 24 & 26. LT/RT, FOUND 1EA PREVIOUS DRILL MARK NEAR THE HOLE "E" ON 47 SPLICE FITTING LT SIDE. REPAIRED IAW EA 6-5720-T0301089SDR FDEA201307091511Splice · damagedDURING PFM WC E6-5310-7-5017 B PT3" FR 47 SPLICE FITTING BETWEEN STR 24 & 26. FOUND HOLE "N" ENLARGED. REPAIRED IAW EA 6-5310-T0300981.SDR DALA13034360947Door Frame · corrodedCORROSION ON LOWER DOOR FRAME BS 1174. REPAIR PARTS WAS FABRICATED, TREATED, PAINTED, AND INSTALLED IAW SRM 51-10-3, PAR 21 AND 14 53-05, FIG 123.SDR DALA13034279205Support Fitting · damagedRIGHT MLG RETRACT ACTUATOR SUPPORT FITTING BORE IS OVER 1.5260 REWORK LIMIT IAW 5740-01140-0201. REPAIRED IAW PRI ERA 514907-14AD, REV O.SDR DALA13034209205Door Frame · corrodedE & E COMPARTMENT INTERIOR DOOR FRAME LONGERON 28R LIGHTENING HOLE HAS CORROSION. REPAIRED CUTOUT IAW ER/A 516026-14, REV O.SDR SIMA20130709010Door Frame · crackedDURING MX INSPECTION, FOUND DOOR FRAME CRACKED AT HANGING BRACKET. ACFT REMOVED FROM SERVICE. REPAIRED IAW EO-EM-52MR-361. ACFT RETURNED TO SERVICE.SDR SWAA2013071918373Crease Beam · corrodedLT CREASE BEAM WEB CORRODED BETWEEN BS 787-BS 807, WL 208. R&R WEB IAW SRM.SDR FDEA201307081505Support · chafedCABIN - LT SUPPORT YOKE BS 535, LONGERON 19L FOUND CHAFED. REPAIRED IAW SRM 53-20-07, FIGURE 202 REPAIR 1, REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REVISION 116.SDR QMLA2013070813096Door Frame · crackedDURING SCHEDULED MX, FOUND CRACK EMERGING FROM UNDER PILOT'S DOOR UPPER STRIKER PLATE ON 14 DEGREE FRAME. REMOVED STRIKER PLATE AND FOUND 2 MORE CRACKS FROM SCREW HOLES THAT SECURE STRIKER PLATE.SDR SWAA2013072518564Window Frame · crackedFIRST OFFICER`S WINDOW FRAME CRACKED. R&R FRAME IAW ACO.SDR KNNA2013081401Door Frame · corrodedCORROSION FOUND AROUND L-1 DOOR UPPER FORWARD CORNER FRAME.SDR R61A201307060583Blowout Panel · dislodgedCREW RECEIVED AN AFT BAGGAGE DOOR OPEN WARNING INDICATION DURING FLIGHT. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. MX FOUND THE BLOWOUT PANEL WAS DISLODGED. MX RESET PANEL IAW AMM AND OPS CHECKED GOOD.SDR DALA13033833757Beam · corrodedDURING INSPECTION FOUND AFT LEFT LAV INBD AFT MOUNT BEAM CORRODED UPPER SURFACE. MX R & R LT LAV AFT MOUNT BEAM IAW SRM 51-40-05 AND 51-40-02.SDR DXTA2013070505433Seal · leakingWHILE CLIMBING THROUGH FL300, A HUMMING OR RUSHING NOISE WAS HEARD COMING FROM ABOVE HEADLINER ADJACENT TO CEO'S SEAT (BETWEEN FIRST 2 FWD FACING SEATS). AT FL400, NOISE INTENSIFIED AND WAS DISRUPTIVE TO PAX. A NOTICEABLE VIBRATION COULD BE FELT IN THE HEADSDR FDEA201307051481Crease Beam · damagedBS 1370 LEFT CREASE BEAM HAS A DOUBLE DRILLED HOLE AT DOME NUT AREA. REMOVED CREASE BEAM BS 1180 - 1310 IAW SRM 51-40-02. LOCATED AND DRILLED HOLES IAW SRM 51-40-05, TRIMMED CREASE BEAM IAW 53-60-13 & DWG 146N5590 . TREATED AND PRIMED IAW 51-20-01, PG 1. SDR SIMA20130722001Crossbeam · corrodedDURING 3C CHECK, FOUND RT SIDE OF CROSSBEAM AT BS 280 TO BE CORRODED. THE ACFT WAS REMOVED FROM SERVICE. REPAIRED CROSSBEAM IAW SRM 51-42-06. ACFT RETURNED TO SERVICE.SDR SWAA2013071718302Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN STATION 616-STATION 639, STRINGER 17R. REPAIRED WEB IAW SRM & DRAWING.SDR AALA20130714006Door Frame · crackedLOWER FORWARD INBD CORNER OF RT NR 1 DOOR JAMB CRACKED. INSTALLED REPAIR DOUBLER IAW SRM 51-70-11-2R.SDR SWAA2013071518253Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED AT 6TH FASTENER FROM LOWER CORNER ALONG THE E-F POST. REPAIRED FRAME IAW ER.SDR SWAA2013071118069Window Frame · crackedRT NR 3 WINDOW FRAME CRACKED AT 2ND LOWER CORNER FASTENER ALONG THE E-F POST. REPAIRED FRAME IAW ACO.SDR SWAA2013071118068Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED AT 2ND LOWER CORNER FASTENER ALONG THE E-F POST. REPAIRED FRAME IAW ACO.SDR CALA2013070500474Crease Beam · corrodedLT CREASE BEAM, BS 760 CORRODED AT SPLICE AREA. TRIMED DAMAGED CREASE BEAM AT BS 768. FABRICATED NEW SECTION. FABRICATED SPLICE CHANNEL. HEAT TREATED TO T6. FABRICATED A SPLICE STRAP IAW RES 2005983-14. INSTALLED REPAIR IAW RES 2005983-14. REPAIR IS FROMSDR CWQD20130703001Structure · damagedSQUIB ON SHARED FIRE BOTTLE IN RT NOSE COMPARTMENT HITTING AIRFRAME. DUE TO THE LIMITED SPACE ALLOWED IN RT NOSE COMPARTMENT AS COMPARED TO THE SIZE AND WEIGHT OF THE FIRE BOTTLE, SCRATCHES AND DENTS ARE BEING CAUSED IN THE NOSE COMPARTMENT AIRFRAME STRUCTURESDR SWAA2013071918242Window Frame · crackedRT NR 3 WINDOW FRAME CRACKED AT 2ND LOWER CORNER FASTENER ALONG THE E-F POST. REPAIRED FRAME IAW ACO.SDR SWAA2013071118111Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED AT 2ND LOWER CORNER FASTENER ALONG THE E-F POST. REPAIRED FRAME IAW ACO.SDR FDEA201307021472Crease Beam · damagedCREASE BEAM BETWEEN BS 297 - 310 INBD HAS ELONGATED HOLE. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101. REMOVED AND REPLACED WITH NEW CREASE BEAM AT BS 297 - 430, IAW SRM 51-40-02 AND DRAWING 657N3381. THIS REPAIR IS CLASSIFIED AS A CATEGORY A MAJOSDR ASOA20130702181Beam · corrodedDURING C-CHECK, CARGO DOOR LOWER BEAM CORRODED. R & R CARGO DOOR LOWER BEAM IAW SRM 51-40-02. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201307011434Crease Beam · corrodedBS 1000 -1010 RT CREASE BEAM INBD ANGLE FOUND CORRODED AROUND FASTENER HOLES. REPAIRED.SDR FDEA201307011433Crease Beam · corrodedBS 960-980 RT CREASE BEAM INBD ANGLE FOUND CORRODED AROUND THREE FASTENERS HOLES. REPAIRED IAW REPAIR DWG LOR5L53017 SHT 3, REV A. REPAIR IS MAJOR.SDR FDEA201307011432Crease Beam · chafedBS 1016 RT CREASE BEAM INBD ANGLE FOUND CHAFED. REPAIRED IAW REPAIR DWG LOR5L53017 SHT.3, REV A. REPAIR IS MAJOR.SDR DALA13033443757Support Beam · corrodedDURING INSPECTION FOUND AFT LT LAV AFT OTBD MOUNT SUPPORT BEAM CORRODED UPPER SURFACE. MX R & R WITH NEW PART IAW SRM 51-40-02, 51-40-05, 51-10-02, 53-70-51 AND AMM 20-60-07.SDR DALA13033413757Crease Beam · corrodedDURING INSPECTION, FOUND AFT GALLEY DOOR CUTOUT SCUFF PLATE ATTACH AREA ON CREASE BEAM FORWARD SIDE HAS CORROSION. MX R & R CEASE BEAM AT STA 900-1000 IAW SRM 53-70-15, FIG 103, SRM 51-40-02, PGS 1-10.SDR USAA2013072200028Door Frame · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR HATCH NR 844 SEGMENT FRAME ANGLE AT FR40 BETWEEN BEAM 1 TO BEAM 3. REPLACED FRAME ANGLE IAW EO 210Y228.SDR USAA2013072200027Door Frame · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR HATCH NR 834 SEGMENT FRAME ANGLE AT FR40 BETWEEN BEAM 1 TO BEAM 3. REPLACED FRAME ANGLE IAW EO 210Y228.SDR UALA2013070104597Structure · damagedSTRUCTURE DAMAGED BS 1420 TO 1440, STR 28L & 27R. INSTALLED REPAIR DOUBLER IAW ECRA 5360-01323.SDR FDEA201306291417Crease Beam · corrodedCREASE BEAM BS 1645, RB 60, WL 208.1 CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15, FIG 101, DETAIL V. REPAIRED IAW EA 757-5361-16-F4223. MAJOR REPAIR.SDR UHLA2013062800301Splice · corrodedCORROSION ON CENTER SPLICE PLATE FR90. R & R CENTER SPLICE PLATE.SDR UHLA2013062800300Gusset · corrodedCORROSION ON GUSSETT PLATE LT CENTER FR91. R & R LT GUSSET.SDR REXA2013062801401Unknown · corrodedFS 295 CORRODED AT STRINGER 27. REPAIRED IAW EO R53435.SDR REXA2013062801314Crossbeam · corrodedFS 280 CROSSBEAM FWD SPLICE ANGLE CORRODED. REMOVED CORROSION IAW EO R53425.SDR REXA2013062801310Crossbeam · corrodedRT FS 280 CROSSBEAM UPPER FLANGE AFT EDGE CORRODED AT RBL 12. EDGE BLENDED DAMAGE ON RT FS 280 CROSSBEAM UPPER FLANGE AFT EDGE AT EBL 12 IAW EO R53426.SDR UHLA2013062800293Beam · corrodedCORROSION ON BEAM LT FR87 AND 89 AROUND SCREW HOLES. R & T BEAM FROM FR87 TO 89.SDR DALA13033909205Beam · corrodedAFT CARGO COMPARTMENT DOOR FRAME LOWER BEAM HAS CORROSION AROUND RIV NUTS ON INTERIOR INBD SIDE BS 1250 - 1269. BLENDED CORROSION, FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM 53-60-02.SDR DALA13033019205Door Frame · corrodedLOWER DOOR FRAME FORWARD FACE HAS CORROSION. REMOVED CORROSION, TREATED AREA, FILLED VOIDS, APPLIED CIC. INSTALLED IAW SRM 51-30-02 AND ERA 516025-14.SDR DALA13032909002Door Frame · crackedDURING LINE INSPECTION, A 2 INCH CRACK WAS FOUND IN THE RT FWD MLG DOOR FRAME APPROXIMATELY 4 INCHES BELOW THE GEAR DOOR OPEN SENSOR. REPLACED DAMAGED FRAME IAW SRM 51-00 & -01.SDR A6WA201307011025Receptacle · crackedACFT GROUND POWER RECEPTACLE PLUG STRUCTURE IS CRACKED. R & R RECEPTACLE PLUG STRUCTURE.SDR ASOA2013071108606Structure · corrodedCORROSION FOUND NEAR RBL 9, BETWEEN FS 295 & 333. REPAIRED IAW SRM 51-21-06 AND REO 601R-53-21-2448 IAW NDTM PART 1 51-20-06.SDR USAA2013070900016Attach Bracket · cracked2S CHECK - CRACK ON RT AFT PASS/CREW DOOR CUT OUT FRAME LOWER ATTACH BRACKET BETWEEN FR68 TO FR69, S23R. REPLACED RT AFT PASS/CREW DOOR CUT OUT FRAME LOWER ATTACH BRACKET BETWEEN FR68 TO FR69, S23R IAW SRM 51-42-11, 51-44-11 & 51-75-12.
Back to JASC 5310