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 DL73K011673Frame · cracked1" CRACK IN R-2 DOOR CUTOUT FRAME, JUST BELOW UPPER FWD. ROLLER CASTING REMOVE & REPLACE FRAME SECTION PER DRAWINGSDR SWAA012856Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 7 EA ) BETWEEN STR 8L & 9L, BS 807, 827, 847, 867, 907, 887 & 480. REPAIRED FRAMES PER BFG ER.SDR SWAA012855Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 4 EA ) BETWEEN STR 8R & 9R, BS 440, 480, 827 & 887. REPAIRED FRAMES PER BFG ER.SDR MWEA011399Longeron · corrodedAFT PIT LONGERON 22 RIGHT HAS TWO AREAS OF CORROSION PRESENT AT STATION 1306 AND 1313 -- REMOVED DAMAGED SECTION AND INSTALLED REPAIR SPLICES AND LONGERON SECTION.SDR MWEA001396Door Frame · corrodedFORWARD CARGO BAY LOWER JAMB AREA HAS LIGHT CORROSION AND PREVIOUS BLENDS BETWEEN STATION 395 TO 400. FABRICATED AND INSTALLED FORWARD CARGO DOOR JAMB PLATE AND SEAL DEPRESSOR.SDR MWEA011393Door Frame · corrodedAFT CARGO COMPARTMENT DOOR JAMB BOTTOM WEB HAS AREAS OF LIGHT CORROSION FROM STATION 1148 TO 1212. FABRICATED AND INSTALLED 4 DOUBLER REPAIR.SDR MWEA011392Doubler · gougedCABIN FUSELAGE SKIN AT STATION 971 ABOVE LONGERON 7 RIGHT HAS DEEP GOUGE -- FABRICATED AND INSTALLED REPAIR DOUBLER.SDR C2XA01TY158Latch · gougedTYS DURING A SCHEDULED INSPECTION THE FUSELAGE CUTOUT FOR LEFT HAND EMERGENCY EXIT HATCH WAS FOUND TO BE GOUGED ON THE UPPER RELEASE LATCH. MAINTENANCE REMOVED AND REPLACED THE LATCH IAW EMB-145 MM 20-10-01, ALL OPERATIONAL AND PRESSURE CHECKS WERE SATISFACTSDR DHL2001801550Door Frame · damagedMAIN CARGO DOOR UPPER FRAME SKIN FROM STA 200 TO 240.000 SHOWS BREAKS OF 3.5 , 2 INCH. TRIMMED OUT DAMAGED AREA PER SRM 53-2-0 FIG 15. FABRICATED FILLER AND DOUBLER PER SRM 53-2-0 FIG 15. INSTALLED FILLER AND DOUBLER PER SRM 53-2-0 FIG 15.SDR SWAA012812Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 987, RBL 51 & WL 199. R&R SHEAR TIE PER SRM.SDR HEEA076616Bearing · mismanufacturedI/D BORE BEARING TOO SMALL. (BEARING P/N 209-031-351-001) REPLACED WITH SERVICEABLE PART.SDR DL75A011657Door Frame · corrodedTHE FWD FRAME OF THE C2 DOOR OPENING AT FS 1380 WAS FOUND WITH CORROSION ON THE OUTER FRAME CAP NEAR STRINGER 27R. THE CHORD WAS CUT JUST ABOVE THE DAMAGE AND THE LOWER SECTION REMOVED. A NEW SECTION OF CHORD WAS FABRICATED AND SPLICED IN WITH REPAIR ANGLES.SDR SWAA012793Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, STR 17R. R&R WEB SECTION PER SRM.SDR GTIA011083Door Frame · corrodedFTW - FORWARD LOWER CARGO COMP, FORWARD SIDE OF LOWER DOOR JAMB CORRODED AT STATION 370 TO STATION 427. INBOARD FACE OF AREA FOUND TO BE OUT OF LIMITS IAW MD-80 SRM 53-01-00. CUT OUT DAMAGE SECTION OF PAN. INSTALLED ANGLES REPAIR AT FORWARD AND AFT SECTION SDR 2001UALA02108Structure · damagedFUSELAGE DAMAGE FOUND DURING MAINTENANCE CHECK. MAJOR REPAIR ACCOMPLISHED. REPAIRED DAMAGE. OPERATIONS CHECK NORMAL.SDR SWAA012795Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 967, LBL 2 & WL 171. REPAIRED FRAME PER SRM.SDR SIMA200128302Door Frame · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE RIGHT FORWARD EXIT CUTOUT, INSIDE FORWARD LOWER CORNER. REPAIRED EXIT CUTOUT IAW SAAB REPAIR STATEMENT 340SDS002802 AND STANDARD SRM REPAIR PRACTICES. (M)SDR SWAA012778Web · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, STR 17L. R&R WEB PER SRM.SDR 01FDEA00877Door Frame · corrodedCENTER CARGO DOOR JAMB AREA LWR AFT OF OUTER BAIL CORRODED. *S/D* COMINGSDR AUS20011113Door Frame · cracked(AUS) LOWER CABIN DOOR FRAME CRACKED IN AREA ADJACENT TO AFT HINGEPOINT.SDR DL75A011649Door Frame · corrodedTHE LOWER SILL BEAM OF THE C2 DOOR OPENING WAS BADLY CORRODED AND REQUIRED REPLACEMENT. TO REMOVE AND INSTALL A NEW SECTION, THE OUTER CHORD OF THE FS 1440 OPENING FRAME WAS CUT AT STRINGER 26R AND THE WEB CUT AT STRINGER 23R. THE LOWER SECTIONS WERE REMOVEDSDR ALG2001F00045Frame · crackedDAILY INSPECTION, CRACKED DOUBLER AND FRAME AT RIGHT HAND NUT PLATE TAB.SDR 2001UALA02102Shear Tie · crackedSTRINGER 12R AT STA 344 SHEAR TIE CRACKED AFT OF DOOR R1 CENTER LINE. MAJOR REPAIR ACCOMPLISHED. REPLACED THE SHEAR TIE AT STRINGER 12R STA 344.SDR DHL2001801535Support · crackedFWD CARGO COMPT B-2 DOOR SUPPORT FRAME CRACKED 1.5 INCH BETWEEN STA 520.000 TO 560.000. REMOVED DAMAGED AREA PER SRM 53-2-0 FIG 1B. FABRICATED REINFORCING ANGLE PER SRM 53-2-0 FIG 1B. INSTALLED REINFORCING ANGLE PER SRM 53-2-0 FIG 1B.SDR QXEA0101677Door Frame · corrodedPDX - CORROSION FOUND UNDER SEVERAL NUT PLATES AT CARGO BAY DOOR SURROUND STRUCTURE, LOWER THRESHOLD. REPAIRED IAW DHC-8 SRM 53-00-16, PAGE 3 TABLE 1, SHEET 2.SDR SWAA012789Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CORRODED BETWEEN BS 847 & BS 857, BETWEEN STR 27R & STR 27L.SDR SWAA012755Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESS WEB CRACKED AT BS 663, LBL 32. REPAIRED WEB PER SWA TI-353-046.SDR 0103629853Bracket · crackedDuring M ck in ATL and while accomplishing the rework per amitask Job #116. The left and Right brackets, P/N 995786-5/-6 brackets, made from .063" thick 7075-t6 aluminum clad sheet. Repaired per EA 98-185170.SDR 0103559759Pressure Panel · crackedEA 97-185179 During H-ck at ATL Base Maintenance a crack was found in the horizontal pressure panel Web P/N 9910073-3-13 at sta 105 and X 25rh. the crack is typical and was trimmed out. The repair was accomplished IAW NWA tRM 53-10-02 dated april 18/01. MateriSDR HEEA076417Panel · crackedPILOT DOOR POST TRIM PANEL CRACKED. SCRAPPED AND REPLACED WITH SERVICEABLE PANEL.SDR SWAA012744Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED ( 3 EA )AT BS 178, BETWEEN LBL 1.0 & LBL 12.0, BETWEEN WL 187 & WL 218. REPAIRED WEB PER SRM.SDR USAA011308Crease Beam · corrodedCLT - FOUND CREASE BEAM CORRODED .250 INCH BY .250 INCH, LEFT DOOR SILL AREA L4. REMOVED AND REPLACED PER SRM 51-10-00. (M)SDR UPS01237039Stringer · corrodedINSPECTION TYPE:C ON REMOVAL OF FLOOR PANELS FOR CABLE INSPECTION, CORROSION FOUND ON FLOOR BEAM TOP CAP BS 344 RBL6. CORROSION REMOVED IAW SRM 51-10-06, DAMAGE OUT OF LIMITS, REPAIRED I AW SRM 53-10-08SDR SWAA012740Tie Clip · crackedDURING SCHEDULED 1/2D CHECK AT DALFORT, FOUND STRINGER TIE CLIP CRACKED AT BS 663, STR 10L R&R TIE CLIP PER SRM.SDR SWAA012718Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED AT BS 178, WL 187 & RBL 1.0. REPAIRED WEB PER SRM.SDR UPS01237038Stringer · crackedINSPECTION TYPE:C WHILE INVESTIGATING WING SCANNING LIGHT SUSPECT CRACK STRINGER 15L F OUND CRACKED AT BS 680. DAMAGE BLENDED OUT IAW SRM 53-10-3SDR SWAA012733Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA CRACKS AT BS 178, LBL 17.1 & WL 234, LBL 11 & WL 218. REPAIRED WEB PER SRM.SDR 01FDEA00869Frame · damagedN 703 BAD FASTENER HOLES AT BS 420 FRAME STR 8L. R&R DOUBLER PER EA 7-5310-60509.SDR SWAA012685Frame · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND Z FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SRM.SDR MWEA011322Door Frame · corrodedAFT CARGO COMPARTMENT DOOR JAMB BOTTOM FRAME HAS NUMEROUS AREAS OF LIGHT CORROSION FROM STATION 1155 TO 1212 ON OUTBOARD SIDE. REMOVED AND REPLACED DOOR JAMB FRAME.SDR MWEA011319Longeron · chafedLONGERON 14 RIGHT HAS SEVERE CHAFE DAMAGE ON UPPER LEG BETWEEN STATION 1401 AND 1418. -- FABRICATED AND INSTALLED LONGERON SECTION AND SPLICE.SDR MWEA011318Longeron · chafedLONGERON 8 LEFT CHAFED BETWEEN STATION 1418 AND 1401. -- FABRICATED AND INSTALLED LONGERON REPAIR PARTS.SDR MWEA011317Longeron · chafedLONGERON 13 RIGHT HAS VERY DEEP CHAFE MARKS BETWEEN AFT PRESSURE BULKHEAD AND STATION 1361. -- FABRICATED AND INSTALLED LONGERON REPAIR SECTION AND SPLICE PLATE.SDR MWEA011314Web · tool damageSTATION 1338 LONGERON 18 THROUGH LONGERON 30 LEFT WEB SUPPORT ANGLE HAS TOOL DAMAGE. -- REMOVED AND REPLACED WEB SUPPORT ANGLE.SDR MWEA011313Shear Tie · corrodedSTATION 1338 LONGERON 18 THROUGH LONGERON 22 LEFT SHEAR TIE HAS CORROSION. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011312Shear Tie · corrodedSTATION 1338 LONGERON 18 THROUGH LONGERON 22 RIGHT SHEAR TIE HAS CORROSION. FABRICATED AND INSTALLED SHEAR TIE.SDR UPS01237037Stringer · corrodedINSPECTION TYPE:C EVIDENCE OF CORROSION ON STRINGER NESTING SECTION AT BS 440 STR24L STRINGER REPAIR CARRIED OUT IAW SRM 53-10-03SDR SWAA012721Tie Clip · crackedDURING SCHEDULED 1/2D CHECK AT DALFORT, FOUND TIE CLIP CRACKED AT BS 663, STR 10R. R&R TIE CLIP PER SRM.SDR SWAA012684Intercostal · crackedDURING SCHEDULED SPECIAL VISIT, FOUND INTERCOSTAL CRACKED AT BS 178, LBL 24 & WL 207. REPAIRED INTERCOSTAL PER SRM.SDR USAA011310Window Post · crackedPIT - FOUND WINDSHIELD POST CRACKED .375 INCH, PILOTS UPPER WINDSHIELD POST OUTBOARD CORNER. STAR DOUBLER INSTALLED PER SRM 53-10-01 FIG 210/EO 56937096. (M)
Back to JASC 5310