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 AWXA200200137Crease Beam · crackedYVR - MAJOR REPAIR - C - DURING C-13 CHECK A 4 INCH CRACK WAS FOUND ON CREASE BEAM WEB RT BS 616 - 639. MAINTENANCE REMOVED DAMAGED CREASE BEAM WEB AND FITTED AND INSTALLED A NEW BEAM WEB IAW DWG 65-47973 AND SRM 51-40-2 PG 3.SDR UPS02837655Door Frame · crackedINSPECTION TYPE:C2 L2 LOWER AFT FRAME CRACKED AT STA 1660 NEAR 19L. REMOVED DAMAGED FRAME SECTION. FAB AND INSTALLED FRAME SECTION, FILLER AND DOUBLER PER DAC DWG 5751040, DC8-5310-11728 AND DC8-53A-011.SDR AT0200035LongeronLONG. 8R CRACKED AT STATION 718. CORRECTIVE ACTION: INSTALLED LONGERON REPAIR AT STATION 718 L-8R IN ACCORDANCE WITH DC-9 SRM 53-02, FIGURE 18. MATERIAL USED LONGERON (SPLICE) P/N 52777922-4-12000, LONGERON P/N 7637813-3,LOT # 1WOWGBH3, P.O. # : 2KSDR 0200449960Bulkhead · crackedDuring RON in CMH, a crack was found on the Apb radial stiffener at l 6 rhs. The crack runs from the outbrd edge of the stiffener to the outer most fastener hole. Repaired per EA 99-185524.SDR UPS02837620Door Frame · crackedINSPECTION TYPE:C2 L2 UPPER FWD DOOR JAMB CORNER CRACKED AT FASTENER HOLE. REPAIRED AREA IAW DC8 SRM 53-2-0 FIG 18.SDR QXEA0200122Stop Fitting · chafedPDX - RT EMERGENCY EXIT, ALL EIGHT DOOR STOPS HAVE .25 INCH GROOVE CHAFED ACROSS CENTER OF BEARING SURFACE. REPAIRED IAW RD8-53-126 AND DHC-8 SRM 51-20-16, PARAGRAPH D.SDR SWAA020218Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND WEB CRACKED BELOW FLOOR AT BS 578, STR 17R. REPAIRED WEB PER SRM.SDR SWAA020215Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CORRODED AT BS 960, STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR UPS02437574Shear Tie · crackedINSPECTION TYPE:C FWD CARGO COMPT, S-43L TO S-44L BS 760 FLOORBEAM SHEAR TIE CORROSION CRACKED. SHEAR TIE REPAIRED AS PER SRM 53-10-04 FIG 3.SDR SIMA200204210Beam · corrodedABI - DURING MBV INSPECTION MAINTENANCE, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. MAINTENANCE REMOVED CORROSION AND RETREATED SURFACE IAW EMB REPAIR STATEMENT GST 0332/02. (M)SDR 2002UALA00149Crease Beam · corrodedCABIN RIGHT HAND CREASE BEAM WEB BETWEEN STATION 996-1006 CORRODED. MAJOR REPAIR ACCOMPLISHED. CREASE BEAM WEB REPLACED.SDR 02FDEA00073Fitting · corrodedCORROSION ON INTERNAL JACK PAD FITTING, BS 1183, STR 3. R&R JACK PAD FITTING PER SRM 51-30-2.SDR 02FDEA00072Fastener · damaged1 EA MISSING & 10 EA DISHED FASTENERS IN EXTERNAL FUSELAGE SKIN, BS 1168-1183 AT STR 30. R&R STR PER SRM 53-10-3 FIG 1.SDR USAA020070Doubler · crackedPIT - FOUND DOUBLER CRACKED .5 INCHES AREA AND 1 INCH AREA BENT, LIP FOR A/C DOOR, STATION 490 BL 0. INSTALLED DOUBLER PER TR 53-30-05 AND EA 73180. (M)SDR AALA20020129Shear Tie · crackedTUL - FOUND SHEAR TIE CRCKED IN RADIUS FRAME 1437 AFT SIDE JUST RIGHT OF LONGERON. REMOVED AND REPLACED SHEAR TIE PER SRM 51-01 FRAME 1437 RIGHT OF LONGERON 1. (M)SDR 0200379878Bracket · crackedDuring M-ck in Atl, while working in the area of sta 69, the right and left brackets were found cracked. Repaired per EA 98-185475.SDR DL757020088Door Frame · corrodedOUTER CHORD AND WEB SPLICE; LOWER SILL CHORD SUBSTITUTION THE LOWER SILL OF THE C2 DOOR OPENING WAS FOUND WITH SEVERAL AREAS OF CORROSION. THE OUTER CHORD AND WEB OF THE FS 1440 OPENING FRAME WERE CUT AND THE LOWER SECTION REMOVED TO ALLOW REPLACEMENT OF THE SDR MWEA020056Frame · chafedCANTED FRAME AT STATION 1168 HAS A CHAFED AREA ON LOWER AFT SIDE AT 7 O'CLOCK POSITION. -- FABRICATED AND INSTALLED REPAIR DOUBLERS.SDR SWAA020159Tie Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND TIE CLIP CRACKED AT BS 927, 27L. REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA020177Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND BS 360 SHEAR TIES CRACKED, STRINGERS 14L-15L AND 14R-15R. REMOVED AND REPLACED SHEAR TIE SECTIONS PER SRM.SDR SWAA020167Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA020166Web · crackedDURING SCHEDULED D CHECK, FOUND WEB CRACKED AT BS294.5, STR 7L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA020158Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR QXEA0200096Door Frame · gougedPDX - CARGO DOOR SURROUND STRUCTURE UPPER FORWARD STOP IS GOUGED IN THREE PLACES. REPAIRED IAW DHC-8-200 SRM 51-20-16.SDR HNAA0200013Skin Panel · corrodedSkin corroded and cracked at station x182 and stringer 33. Replaced skin panel.SDR F3LA200200023Door Frame · crackedDURING C-7 CHECK, INSPECTION REPORTED CRACK IN FWD GALLEY DOOR FRAME, UPPER FWD SIDE, STA 294.5. REPLACED FWD GALLEY DOOR FRAME SEGMENT ABOVE DOOR STOP AT STA 294.5 PER SRM 51-10-1 AND EA 53-737-151.SDR 0200119603Door Frame · crackedDURING HCK IN ATL, THE VENTRAL DOOR JAMB AND CAP WERE FOUND CRACKED. REPAIRED PER EA 96-185463.SDR MALA020131Flange · corrodedDuring 4K-Check in CWA, Upper Flange at Frame Sta 294 is corroded at approximately RBL 18.3. Maintenance performed repair of Frame, at Sta 294 IAW EO3 S53108.SDR ABXA010862Door Frame · crackedLEFT FORWARD ENTRY DOOR MADE A BINDING NOISE WHEN MOVED FROM FULL OPEN POSITION. FOUND SNUBBER SUPPORT WEB CRACKED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED NEW SPLICE AT BOTH ENDS IAW REA D853-41451MR.SDR AALA20020091Window Frame · crackedTUL - FOUND FORWARD LOWER FORWARD CORNER OF WINDOW FRAME CRACKED ON RIGHT SIDE OF AC AT STATION 985. INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR AALA20020087Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED. REPLACED SHEAR TIE PER SRM 51-01. (M)SDR CA020125005Door Frame · cracked(CAN) THE INNER DOOR FRAME WAS FOUND CRACKED ALSO THE OUTER FRAME OF FUSELAGE SKIN WAS CRACKED. THE INNER FRAME WAS REPLACED. THE OUTER FRAME WAS CLEANED OF CORROSION TREATED AND ZING CHROMATED. THE OUTER CRACK WAS STOP DRILLED USING 7/64 INCH DIA STOP DRILL HSDR CA020125004Door Frame · cracked(CAN) ON A 200 HOUR INSPECTION WHILE INSTALLING LT HEATING DUCT LOOKING THROUGH LIGHTNING HOLE AT BOTTOM LT DOOR POST. FOUND AN 1 1/2 INCH CRACK AT DOOR HINGE SCREWS.SDR AALA2002051Door Frame · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR LOWER BEAM FROM STATION 1160-1193. INSTALLED FULL LENGTH DOUBLER NR 3 AS PER AARD 53-10-00-3. (M)SDR 0200159946Web · crackedDuring Hck in ATL, A crack was found in the lower outboard corner of the diagonal web in the L/H engine pylon just forward of the rear spar. Repaired per EA 99-185474.SDR 0200129873Bracket · crackedDuring an Mck in ATL a crack was found at the station 69 bracket (x=+/- 10). Repaired per EA 98-185453.SDR 2002UALA00106Door Frame · crackedFORWARD GALLEY DOOR CUTOUT FRAME 295.5 CRACKED ON FORWARD SIDE AT TOP STOP PAD FITTING. MAJOR REPAIR ACCOMPLISHED. REPLACED STUB FRAME.SDR 2002UALA00105Door Frame · corrodedAFT PIT DOOR CUTOUT FRAME WEB HAS CORROSION FROM STRINGER 22R TO STRINGER 25R BODY STATION 794. MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION AND REPLACED WEB.SDR SWAA020100Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 967, BETWEEN STR'S 6L AND 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR USAA020036Crease Beam · crackedCLT - FOUND WEB CRACKED 4 INCHES, CREASE BEAM WEB BS 1044 AND S176. REPLACED WEB PER SRM 51-10-20. (M)SDR 2002UALA00085Crease Beam · corrodedRIGHT HAND FORWARD CREASE BEAM NUMEROUS AREAS OF CORROSION FOUND FROM STATION 290 TO STA 358 WL 208 RBL 53 TO RBL 67. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR ABXA010693Fitting · crackedKEEL FITTING IN LEFT WHEEL WELL, FORWARD OF INBOARD GEAR DOOR ACTUATOR CRACKED AT TOP CENTER AT WING ATTACH POINT. STOP DRILLED CRACK IAW DC-9 SRM 51-10-4. REPAIRED KEEL FITTING IAW DC-9 SRM 53-03.SDR ABXA010692Door Frame · crackedUPPER CARGO DOOR, UPPER FORWARD CORNER STRUCTURE CRACKED INSIDE FUSELAGE. INSTALLED REPAIR DOUBLER ON UPPER CARGO DOOR, UPPER FORWARD CORNER DOOR PAN STRUCTURE IAW DC-9 SRM 51-30-5 AND 53-01.SDR 2002UALA00083Door Frame · crackedAFT GALLEY DOOR CUTOUT FORWARD FUSELAGE FRAME STATION 956 IS CRACKED 1.5 IN BETWEEN STRINGER 9-10R AT UPPER LATCH ROLLER FITTING ATTACHMENT. MAJOR REPAIR ACCOMPLISHED. STUB FRAME REPLACED.SDR UPS02537425Seat Track · corrodedINSPECTION TYPE:C CORROSION AROUND NUTPLATE HOLES ON O/B FLANGE OF SEAT TRACK LBL 45 BS 1182 - 1198 WL 208 REMOVED AND REPLACED DAMAGED SEAT TRACK FROM BS 1180 - 1230 LBL 45 W L 208 PER SRM 53-00-52 FIG 202 AND UPS EO 02-0078SDR UPS02537424Seat Track · corrodedINSPECTION TYPE:C CORROSION AROUND NUT-PLATE HOLE ON-OB FLANGE OF SEAT TRACK BS1192- RBL25-WL208. REMOVED & REPLACED DAMAGED SEAT TRACK BS 1180-1230 RBL 25 WL 208 PER SRM 51-40-02 AND E.O. 02-0078.SDR USAA020018Door Frame · crackedPIT - FOUND FRAME CRACKED 1 INCH, DOOR FRAME CUT OUT INTERIOR SKIN STATION 950 AT S11L. FABRICATED AND INSTALLED PER EA 73190 WITH TYPICAL REPAIR 53-30-07A. (M)SDR 2002UALA00077Door Frame · damagedAFT CARGO DOOR CUTOUT AFT BEAM STATION 845 WEB CHAFED AND GOUGED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR MWEA020047Frame · corrodedFUSEALAGE FRAME 1022 CORRODED AROUND ATTACH FASTENER TO LONGERON 28 LEFT -- REMOVED CAP FROM FRAME. LOCATED AND INSTALLED NEW FRAME CAP.SDR USAA020044Door Frame · crackedCLT - FOUND WEB AND CHORD CRACKED 3 INCHES, STATION 1380, FORWARD FRAME OF AFT CARGO DOOR CUTOUT. SPLICED IN WEB SECTION AND REPLACED CHORD PER EA85820 AND EA 85824. (M)
Back to JASC 5310