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 QXEA0003005Structure · crackedPDX- AFT CARGO PIT DOOR TORSION BOX CHAFFED AND CRACKED AT FRAME 16260 AND STRINGER 72. REPAIRED IAW HORIZON AIR EA 4-53-1395 AND FOKKER SRM 51-10-4.SDR CALA0001644Door Frame · dentedINSPECTION FOUND R-1 DOOR JAMB AT AFT CENTER AREA MAIN FRAME BEHIND ROLLER ASSEMBLY DENTED IN RADIUS. THE DOOR STOP WAS REMOVED IAW SRM 51-30-1. A REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 42, 51-30-1, AND 51-30-2. A NEW DOOR STOP WAS INSTALLED IAW SRM 51-SDR MWEA001078Shear Tie · corrodedCORROSION ON SHEAR TIE AND ANGLE, AT STATION 1418, BELOW LONGERON 24 RIGHT. FABRICATED AND INSTALLED SHEAR TIE.SDR 00FDEA00740Shear Tie · corrodedDURING ROUTINE INSP SHEAR TIE AT BS 950E AT STR 29L FOUND CORRODED. REMOVED, REPLACED AND FAB PER IAW BAC SRM 53-10-4.SDR USAA001799Shear Tie · corrodedCLT - FOUND SHEAR TIE CORRODED 6 INCHES, STATION 727E BETWEEN RBBL 8.10 TO RBBL 3.0. REPAIRED DOUBLER PER SRM 53-00-07. (M)SDR MWEA001057Shear Tie · corrodedCORROSION ON SHEAR TIE AT STATION 1287 BETWEEN LONGERON 30 AND 29 LEFT. ALSO SOME AREAS OF BARE METAL ON INNER SKIN, AFT PIT. FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA001043Door Frame · scratchedFORWARD ACCESSORY DOOR JAMB HAS NUMEROUS SCRATCHS AROUND ENTIRE JAMB. FABRICATED AND INSTALLED ACCESSORY DOOR JAMB REPAIR.SDR QXEA0003000Rivet · crackedPDX- NOSE WHEEL BAY STATION 2510, LBL 15.5", WL-37 HAS CRACK AT RIVET. REPAIRED IAW HORIZON AIR EA 4-53-1374.SDR QXEA0002999Rivet · crackedPDX- NOSE WHEEL BAY STATION 2550 HAS CRACKED RIVET. REPAIRED IAW HORIZON AIR EA 4-53-1376.SDR AALA20001821Door Frame · gougedTUL - VAULT DOOR FRAME GOUGED FORWARD OF UPPER AND LOWER LOCK PIN HOLES. REMOVED AND REPLACED VAULT DOOR LEFT DOOR FRAME PER SRM 51-01. (X)SDR MWEA001067Door Frame · corrodedRIGHT HAND E&E BAY DOOR JAMB FRAME CORRODED. MAINTENANCE REMOVED CORROSION, FABRICATED, AND INSTALLED ATTACHMENT CLIPS.SDR SWAA002085Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FASTENER HOLES CORRODED AT BS 874 AND 877.5, LBL 64, WL 208. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR RRXA003223Sill · crackedDURING A MAINTENANCE VISIT FOUND A CRACK AND DOUBLE DRILLED HOLES TO THE R-1 DOOR SILL PLATE, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR MWEA001058Former · crackedFORMER UPPER RIGHT HAND SIDE OF APB AT STATION 996 IS CRACKED. MAINTENANCE REMOVED AND REPLACED FORMER.SDR USAA001787Shear Tie · corrodedCLT - FOUND SHEAR WEB CORRODD .5 INCH, BS 1715, RBL 8. CORROSION LEVEL 1 C53-252-03. INSTALLED FABRICATED REPAIR DOUBLER PER EA 68243. (M)SDR USAA001788Shear Tie · corrodedCLT - FOUND SHEAR WEB CORRODED 8 INCHES, BS 1715, RBL 18 TO RBL 26. CORROSION LEVEL 1 C53-252-03. INSTALLED FABRICATED REPAIR DOUBLER PER EA 68243. (M)SDR USAA001789Shear Tie · corrodedCLT - FOUND SHEAR WEB CORRODED .5 INCH BY .5 INCH, BS 1715, LBL 17. CORROSION LEVEL 1 C53-252-03. INSTALLED FABRICATED REPAIR DOUBLER PER EA 68243. (M)SDR UPS00834310Shear Tie · crackedINSPECTION TYPE:C2, CRACK IN SHEAR TIE FS 1360 BETWEEN LONGERON 32 TO 31 RIGHT. REMOVED DAMAGED SECTION OF SHEAR TIE, FABD NEW SHEAR TIE SECTION AND DOUBLER STRAP, ALODINED AND PRIMED, INSTALLED TIE SECTION AND DOUBLER STRAP.SDR DL777002070Structure · bird strikeFLT RETURNED TO JFK DUE TO POSSIBLE BIRD STRIKE. PERFORMED BIRD STRIKE INSPECTION, FOUND SMALL AMOUNT OF BLOOD ON LOWER FUSELAGE JUST AFT OF RIGHT NOSE GEAR DOOR. ALSO SMALL SPOT OF BLOOD ON RIGHT INBOARD TRAILING EDGE FLAP. OTHERWISE THERE WAS NO PHYSICAL SDR USAA001774Door Frame · crackedCLT - FOUND FRAME CRACKED 1 INCH, LEFT AFT DOOR FRAME UPPER HINGE FITTING. REPLACED FITTING PER SRM 51-10-02. (M)SDR MALA000702Structure · dentedFOUND DURING C-CHECK, DENT BELOW CARGO DOOR AT STA 640.0. REFER TO CELSIUS W/O 18910, TASK CARD 1522 AND CELSIUS SAAB STATEMENT 340SDS000299. MAINTENANCE CHECKED LIMIT FOUND SUBJECT DENT IS .025 DEEP X 1 LONG AND IS WITHIN 3 OF A SKIN SPLICE OUT OF LIMITS. RESDR UPS00234247Shear Tie · crackedINSPECTION TYPE:C, FLOORBEAM SHEAR TIE CRACKED AT BS 318 AND LBL 4. REPAIR CARRIED OUT IAW SRM 51-40-2.SDR UPS00234246Shear Tie · crackedINSPECTION TYPE:C, FLOORBEAM SHEAR TIE CRACKED AT BS 312 RBL 24. REPAIR CARRIED OUT IAW SRM 51-40-2.SDR MWEA00978Channel · crackedZEE CHANNEL CRACKED AT LOWER LEFT HAND CORNER OF CENTER WINDSCREEN. REMOVED AND REPLACED ZEE CHANNEL.SDR MWEA00977Channel · crackedZEE CHANNEL CRACKED AT LOWER RIGHT HAND CORNER OF CENTER WINDSCREEN. REMOVED AND REPLACED ZEE CHANNEL.SDR MWEA00986Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1019 BETWEEN LONGERONS RIGHT 16 AND 17. REMOVED AND REPLACED SHEAR TIE.SDR MWEA00929Shear Tie · damagedELONGATED HOLE ON SHEAR CLIP STATION 996 LONGERON 26 RIGHT THRU LONGERON 30 RIGHT AND LONGERON 26 LEFT THRU LONGERON 30 LEFT. REMOVED AND REPLACED SHEAR CLIP.SDR SIMA31812Angle · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE RIGHT AFT CARGO ZEE MEMBER CORRODED. MAINTENANCE REMOVED AND REPLACED THE ZEE MEMBER IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA3187Pan · corrodedDURING CPCP-2 INSPECTION, MAINTENANCE REPORTED THE CARGO DOOR UPPER AFT CORNER OF PAN CORRODED. MAINTENANCE REMOVED AND REPLACED THE PAN IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR UPS00834313Gusset · corrodedINSPECTION TYPE:C2, CORROSION AROUND FASTENERS IN GUSSET ON LOWER LEG OF FLOOR FRAME AT FS 1340 APROX 20 INCHES I/B OF RIGHT CUSP. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW DC8 SRM 53-2-0. REMOVED GUSSET, FAB NEW IAW DAC DWG 9754034, ALODINE AND PRIME SDR UPS00834312Gusset · corrodedINSPECTION TYPE:C2, CORROSION AROUND FASTENERS IN GUSSET ON LOWER LEG OF FLOOR FRAME AT FS 1320 APPROX 20 INCHES I/B OF THE RIGHT CUSP. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW DC8 SRM 53-2-0. REMOVED GUSSET, FAB NEW GUSSET IAW DAC DWG 9754034, ALODINSDR RRXA003261Angle · crackedDURING A MAINTENANCE VISIT FOUND A CRACK INSIDE DOOR ON UPPER ANGLE LT TYPE 1 DOOR AT STA 120 AND L14L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 52-2-0, 5SDR USAA001762Gusset · crackedCLT - GUSSET CRACKED 1 INCH AT BS 259, BBL ZERO TOP OF N/G WELL. INSTALLED NEW GUSSET PER DWG 65 45819. (X)SDR DLM88002064Door Frame · corrodedTHE LOWER JAMB OF THE C3 CARGO DOOR OPENING WAS FOUND WITH CORROSION AT THE DOOR STOP SET SCREW LOCATIONS. THE CORROSION WAS BLENDED AWAY AND THE JAMB REPAIRED WITH A TITANIUM ''ZEE'' SECTION REPAIR DOUBLER. THE REPAIR WAS ACCOMPLISHED PER MD-88 SRM 53-05 ANSDR 2000UALA00726Structure · damagedDUE TO GROUND EQUIPMENT IMPACT, STRINGER 22R BUCKLED BETWEEN BS 302.5 & 334.5. BS 328 FRAME WEB & SAFE CHORD BUCKLED & CRACKED ALONG A 13 INCH SECTION ADJACENT TO STRINGER 22R. FUSELAGE SKIN PUNCTURED & CRACKED LENGTHWISE BETWEEN BS 301 & 341 & CIRCUMFERENTISDR QXEA0002921Structure · corrodedPDX- MINOR PITTING CORROSION FOUND ON AIRCRAFT STRUCTURE UNDER MARKER BEACON ANTENNA. REPAIRED IAW FOKKER SRM 51-10-4 AND 53-01-01.SDR ABXA000478Structure · crackedCRACK AT END OF NR 3 RADIAL ON NR 6 T-CAP APPROXIMATELY .25 INCH LENGTH. REPLACED NR 6 T-CAP IAW ABX EA 53120037-006.SDR QXEA0002922Structure · corrodedPDX- PITTING CORROSION FOUND IN SEVERAL AREAS AROUND FASTENER HOLES ON AIRCRAFT STRUCTURE UNDER REAR BALANCING PLATE. REPAIRED IAW FOKKER SRM 51-10-4 AND 53-01-01.SDR DHL2000715010Door Frame · bentMAIN CARGO DOOR UPPER AFT FRAME FOUND BENT. FABRICATED AND INSTALLED NEW UPPER AFT FRAME PER B727 SRM 51-30-2 AND 51-10-3. SIZE OF REPAIR 8 X 28 INCHES.SDR UPS00434362Forging · corrodedINSPECTION TYPE:C, INTER FUSELAGE BS 2040 - 2060 RT FOUND CORROSION AROUND WINDOW FORGING. CORROSION REMOVED ACCORDING TO SRM 51-10-01, CORRODED AREA ON FWD SIDE OF WINDOW BELT WITHIN LIMITS, MAX DEPTH .02 INCH AND ON AFT SIDE OUT OF LIMITS MAX DEPTH .043 INCSDR UPS00434361Forging · corrodedINSPECTION TYPE:C, INTERNAL FUSELAGE STA 2140 AND 2160 LT. CORROSION BETWEEN WINDOW FORGING/FUSELAGE AT FWD AND AFT SIDE AND AFT LOWER CORNER. CORROSION REMOVED ACCORDING TO SRM 51-10-01, CORRODED AREA ON FWD SIDE OF WINDOW BELT WITHIN LIMITS AND ON AFT SIDESDR ASAA0010137Shear Tie · missingYXD-DURING SCHEDULED MAINTENANCE STA 500B FRAME SHEAR TIE MISSING BETWEEN STRINGER 4R AND 13R. REPAIRED PER BOEING DRAWING 65-64958 REV. D.SDR ASAA0010142Door Frame · damagedPAE-DURING SCHEDULED 'C' CHECK THE E&E COMPARTMENT DOOR FRAME AT STA 328-344, WL 148, RBL 14 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01864.SDR ASAA0010135Door Frame · crackedYXD-DURING SCHEDULED MAINTENANCE STA 480 FRAME WAS FOUND TO BE CRACKED THROUGH THE OUTBOARD FLANGE TERMINATING IN A FASTENER HOLE COMMON TO THE REINFORCEMENT STIFFNER VERTICAL LEG. REPAIRED PER EA 5310-01719.SDR ASAA0010136Shear Tie · missingYXD-DURING SCHEDULED MAINTENANCE STA 480 FRAME SHEAR TIE MISSING BETWEEN STRINGER 4R AND 10R. REPAIRED PER BOEING DRAWING 65-46532.SDR QXEA0003002Structure · scratchedPDX- DEEP SCRATCHES IN NOSE WHEEL BAY STRUCTURE STATION 2520, RBL 12.5", WL 60". REPAIRED IAW FOKKER SRM 51-10-04 AND 53-01-01 PAGE 5.SDR UPS00234229Structure · corrodedINSPECTION TYPE:C, BILGE IN SKIN (SUSPECT CORROSION) AT BS 1030 ABOVE STR 18 LT. GILL LINER REMOVED IAW MM 25-52-02. CORROSION ON EXTRUSION FOUND TO BE CORRODED AND OUTSIDE LIMITS SRM 53-30-01. NEW EXTRUSION INSTALLED IAW SRM 51-30-02. GILL LINER INSTALLEDSDR C2XA00IA373Strap · corrodedIAH-DURING C-CHECK INSPECTION, THE CENTER FLOORBEAM BUTTSTRAP WAS FOUND TO BE CHAFED FROM FRAME 18 TO FRAME 23. MAINTENANCE REMOVED AND REPLACED THE AFFECTED GUSSET IN ACCORDANCE WITH EMB145 SRM 51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA00IA372Strap · corrodedIAH-DURING C-CHECK INSPECTION, THE CENTER BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 15 TO FRAME 18. MAINTENANCE REMOVED THE CORRISION, AND PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH CONTINENTAL EXPRESS ENGINEERING CHANGE EC5310-01141, AND THE AIRCRAFT WSDR UPS00434191Forging · corrodedINSPECTION TYPE:C, CORROSION FOUND UNDER MAIN DECK WINDOW FORGING AT BS 720 TO 740 LT. CORROSION REMOVED IAW SRM WITHIN SRM LIMITS.
Back to JASC 5310