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 DALA13050289207Beam · corrodedAFT CARGO BAY, MAIN BEAM L28R, CORRODED BETWEEN BS 1269-1250. BEAM FOUND TO BE OUT OF LIMITS. R & R BEAM IAW SRM 51-30-05 AND DWG 5730483 AT STA 1174-1307.SDR USAA2013101000006Doubler · corrodedC4 CHECK, CORROSION ON DOUBLER BETWEEN BS 1661 TO 1681 & BETWEEN S24-25R. REPLACED DOUBLER IAW SRM 51-10-02, 53-00-53-1A, 51-30-01 & 51-40-02.SDR FDEA201310042412Support Fitting · crackedMCD LOWER FRAME 6 SUPPORT FITTING IS CRACKED AT "C" HOLE. VERIFIED WITH HFEC AND BORESCOPE. R & R NR 6 SUPPORT FITTING MCD SPOOL REF SRM 51-31-01, VOL II.SDR DALA13050219207Stop Fitting · crackedFORWARD CARGO DOOR, FORWARD UPPER FOUR STOP FITTINGS CRACKED. R & R STOP FITTINGS IAW CMM 52-30-01.SDR FDEA201310032383Door Frame · corrodedAFT CARGO BAY RT SIDE CARGO DOOR CUT OUT FWD FRAME BS 1380, FRAME HAS CORROSION ON AFT WEB, AT AFT CARGO DOOR DOWN NR 1 SWITCH. ATTACHMENT, BETWEEN S23 - 24R. REMOVED AND REPLACED WITH NEW WEB FABRICATED AND INSTALLED IAW DWG 146N8511 SHT 21 REV B. REPAIR ISSDR FDEA201310032385Failsafe · corrodedBS 500 FRAME OTBD FAILSAFE FOUND CORRODED AT EDGE S17R. REPAIRED IAW EA F-5310-T0302910 PART 1. REPAIR CLASSIFIED MAJOR PER GMM 6-2-100.SDR RAIA201310030001Beam · corrodedCARGO DOOR BEAM CORRODED. REPLACED BEAM, OPS CHECKED GOOD.SDR DALA13051323762Crease Beam · corrodedDURING INSPECTION, FOUND MAIN DECK R2 DOOR THRESHOLD AREA, RT CREASE BEAM UPPER FLANGE BS 967-986 UPPER AND LOWER SURFACES ARE CORRODED. MX R & R CREASE BEAM ASSY IAW DWG 147A8501, REV C AND SRM 51-40-02.SDR DALA2013100459207Beam · corrodedAFT CARGO COMPARTMENT, STA 1212-1288, L29R BEAM IS CORRODED UNDER INTERCOSTAL. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPLACED BEAM IAW SRM 53-00-01 AND 51-10-05 AND 51-30-05.SDR FDEA201310022373Door Frame · wornUPPER CARGO DOOR FRAME WEB BUSHING FOUND WORN. BUSHINGS REMOVED AND REPLACED AS PER SRM 53-00-15 FIGURE 201 REPAIR 5 REVISION 53 NEW REPAIR BUSHINGS FABRICATED BY MACHINING AS PER SRM 53-00-15 FIGURE 201 REPAIR 5 REVISION 53. REPAIR CLASSIFIED MAJOR AS SDR RAIA201310020004Beam · corrodedDOUBLER ON BEAM Y 479 AT FR 22 CORRODED. MAINTENANCE REPLACED DOUBLER, OPS CHECK GOOD.SDR RAIA201310020002Gusset · corrodedGUSSET ON BEAM Y 0.0 FR 18-23 CORRODED. MX REPLACED GUSSET, OPS CHECK GOOD.SDR FDEA201310022379Strap · corrodedAPU INLET DOOR SHROUD CUT-OUT AFT SUPPORT FRAME CORRODED. BLENDED CORRODED AREA OF APU INLET DOOR CUT-OUT IAW SRM 51-10-02, FOUND TO BE OUT OF LIMITS IAW SRM 53-80-15, FIG 101, DET II FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-80-15, REPAIR 1, DET I. SDR CALA2013100291648Structure · gougedGOUGE IN RVSM AREA ON RT SIDE. GOUGE LOCATED 1.437" ABOVE PORT, .750 " LONG & AFTER BLEND JUST UNDER .003 " DEPTH. DIMENSIONS ALL WITHIN LIMITS IAW SRM 53-00-11 PG. 107-108. APPLIED ALODINE NO FURTHER ACTION REQUIRED.SDR USAA2013102500014Door Frame · crackedDURING 2S CHECK, CRACK IN FRAME SEGMENT OF EMERGENCY EXIT DOOR 844 BETWEEN FR40 TO FR41 & BETWEEN S14R TO S20R. REPLACED SEGMENT FRAME OF EMERGENCY EXIT DOOR 844 IAW EO 5210Y228.SDR SWAA2013101121093Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR DALA13048776811Dome Nut · corrodedAFT CARGO BILGE BS 1500-1520, S27-28R ANTENNA DOME NUT DOUBLER UPPER SURFACE CORRODED 1 EA DOME NUT MISSING (TR019). REMOVED CORROSION FROM DOUBLER (NUT HOLDING PLATE) ORIGINAL, MATERIAL THICKNESS .050" MECHANICALLY MEASURED , MATERIAL LOSS .018", MAX MATERISDR FDEA201309302351Strap · corrodedAPU AIR INLET DOOR CUTOUT-INNER STRAP FOUND CORRODED AT BS 1825, S1 - 9R AFTER APU AIR INLET HOUSING REMOVED. FOUND OUT OF LIMITS IAW SRM 53-80-15 FIG 101 DETAIL II REV 110. STRAP REMOVED & REPLACED IAW DWG 148N3105 SHT 1 REV C. REPAIR CLASSIFIED AS MAJOR.SDR FDEA201309302347Failsafe · corrodedCABIN, BS 620, STRINGER 17R FRAME OTBD FAILSAFE FOUND CORRODED AT EDGE. FAILSAFE REMOVED AND REPLACED IAW DWG 146N8513 SHT.1 REV.A AND INSTALLED IAW DWG 143N8512 SHT.1 REV.J. REPAIR IS MAJOR.SDR FDEA201309302346Crease Beam · chafedBS 755 -780 LT CREASE BEAM INBD ANGLE FOUND CHAFED AT UPPER SURFACE. REPAIRED IAW EA F-5310-T0302749, PART 1. REPAIR CLASSIFIED MINOR PER BMM 6-2-100.SDR SWAA2013102821549Window Frame · crackedLT 1 WINDOW FRAME CRACKED AT OTBD UPPER CORNER, 1". REPAIRED FRAME IAW ATS ER & ACO.SDR SWAA2013101421200Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT OTBD UPPER CORNER. REPAIRED FRAME IAW EA.SDR SWAA2013102821521Window Frame · crackedRT NR 3 WINDOW FRAME CRACKED AT THE SECOND & THIRD HOLE FROM THE BOTTOM. REPAIRED FRAME IAW EA & DRAWING.SDR SWAA2013102921520Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED AT THE SECOND HOLE FROM THE BOTTOM. R & R FRAME IAW EA.SDR REXA2013092901962Structure · corrodedFOUND LT AND RT AFT NLG DOOR FUSELAGE FITTINGS TO HAVE CORROSION IN BUSHING BORES. REPLACED FITTINGS IAW SRM 51-23-00 AND 51-42-21.SDR REXA2013092901922Door Frame · corrodedLT DOOR FRAME FS 280 CORRODED. REPAIRED IAW EE CRJ953-01934, EO R53495.SDR DALA13048723141Stop Fitting · chafedLEFT AFT DOOR FRAME AT FRAME 68 MID ROLLER STOP FITTING CHAFED. BLENDED AREA IAW SRM 51-73-00. NO ESTABLISHED LIMIT ON SRM. R & R STOP FITTING IAW SRM 51-42-11 & DWG D53480082.SDR DALA13048713141Stop Fitting · chafedRIGHT AFT PASSENGER DOOR FRAME AT FRAME 68 MID ROLLER STOP FITTING CHAFED. BLENDED AREA IAW SRM 51-73-00. NO ESTABLISHED LIMITS IN SRM. R & R FITTING IAW SRM 51-42-11 & DWG D53480082.SDR ASOA20130930387Crossbeam · corrodedCENTER AISLE CROSSBEAM CORRODED BEYOND LIMITS. R & R CROSSBEAM.SDR DALA13047786309Stop Fitting · crackedSTOP FITTING L4 DOORWAY CRACKED. R & R IAW AMDS CARD:5310-01283-07C.SDR SWAA2013101421167Window Frame · crackedLT NR 1 WINDOW FRAME FASTENER HOLE CRACKED. R & R FRAME IAW ACO.SDR DALA13048013759Door Frame · damagedDURING INSP FOUND AFT CARGO BAY BA 787 +6" AND 3" BELOW S-20R SCREW HOLE ELONGATED ON FWD DOOR FRAME. MX C/W PRI 518616-14, REV 0 AND ERA 518616-14, REV ORG.SDR AALA20130929007Door Frame · crackedCABIN SIDEWALL LT AFT OVER WING EXIT DOOR CUT OUT UPPER RADIUS IS CRACKED AFT OF DOOR UPPER STRIKER. INSTALLED DOUBLER IAW EA MD80-53-031799 & SRM 53-05 FIGURE 32.SDR REXA2013092601905Crossbeam · corrodedRT FS 280 CROSSBEAM IS CORRODED. REPLACED CROSSBEAM IAW EO R53489, R53117 & EO R53127.SDR REXA2013092601904Crossbeam · corrodedLEFT FS 280 CROSSBEAM IS CORRODED. REPLACED LT FS 280 CROSSBEAM IAW EO R53489 & R53117 & EO R53127.SDR SWAA2013102221351Door Frame · corrodedFWD CARGO DOOR, DOOR JAMB CORRODED BETWEEN BS 370 TO BS 380. REPAIRED JAMB IAW SRM.SDR REXA2013092501984Doubler · corrodedFS 280 SPLICE DOUBLER CORRODED. R & R SPLICE DOUBLER IAW SRM 51-42-06.SDR REXA2013092501980Structure · gougedTWO SCREW GOUGES AT BS 913-927, STR 27. BLENDED GOUGES AND IS IN LIMITS IAW REO 670-53-00-290 AND EO R53498.SDR REXA2013092501961Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. R & R RT CROSSBEAM IAW EO R53497, R53117, & R53127.SDR REXA2013092501960Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. R & R CROSSBEAM IAW EO R53497.SDR REXA2013092501940Plate · corrodedREPLACED RADAR ALTIMETER NR 1 TRANSMITTER ANTENNA BASE PLATE IAW SRM 51-42-06. BLENDED CHAFE UPPER AFT GUIDE PLATE AND IS IN LIMITS IAW EO R52097. GAP CHECKED GOOD IAW MM 52-11-00.SDR HNAA2013092500513Frame · corrodedPAX DOOR THRESHOLD FRAME CORRODED. R & R THRESHOLD FRAME WITH NEW IAW SRM 51-42-05 AND DWG 85321241.SDR SWAA2013120222875Door Frame · corrodedFWD CARGO DOOR CUT OUT LOWER SECTION JAMB CORRODED BETWEEN STATION 370 TO STATION 427. R & R JAMB IAW SRM & DRAWING.SDR R61A201309240925Door Frame · dirtyF/A STATED THAT THE L1 DOOR IS HISSING IN FLIGHT. AN EMERGENCY WAS NOT DECLARED AND LANDED WITHOUT INCIDENT. CLEANED DEBRIS FROM DOOR FRAME AND PERFORMED PRESSURIZATION CHECK OF THE L1 DOOR IAW AMM. OPS CHECKED GOOD AND ACFT IS GOOD FOR SERVICE.SDR DALA13047023721Beam · damagedDURING INSPECTION, FOUND FUSELAGE AFTERBODY LOWER HORIZONTAL BEAM RT OTBD LIGHTNING HOLE AT BS 1116, RBL 25 AND CRACK. MX REPAIRED DAMAGE IAW ERA 507491-14.SDR SCNA20131004156Door Frame · crackedR1 DOOR FWD CUTOUT LOWER STUB FRAME AT BS 296 CRACKED ACROSS LOWER FASTENER HOLES. R & R LOWER STUB FRAME.SDR SWAA2013100320783Crease Beam · corrodedLT CREASE BEAM INNER CHORD CORRODED BETWEEN BS 706 TO BS 727. REPAIRED CHORD IAW EA.SDR USAA2013092400012Beam · corroded2S CHECK, CORROSION ON R1 DOOR SILL BEAM AROUND FASTENERS AT FRAME 20 BETWEEN -Y1603 TO -Y1609. REMOVED CORROSION & REPAIRED IAW SRM 53-11-14.SDR UHLA2013092200488Finger Doubler · corrodedCORROSION FOUND ON FWD CARGO DOOR FWD FINGER DOUBLER. R & R FINGER DOUBLER.SDR R61A201309220933Crossbeam · damagedDURING HEAVY CHECK, KNIFE EDGE ON RT CROSSBEAM BETWEEN R1 DOOR AND RT SEAT TRACK. MX REPAIRED FRAME 14 FLOOR CROSSBEAM IAW ETD 2013 -170-042101 FABERICATED DOUBLER FROM AL 7075-T6511 PO 003973-2013 SEE CONTINUATION CARD C-1,2 FOR ALL MX. PERFORMED, PERMANEN
Back to JASC 5310