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 SWAA2013111922562Window Frame · crackedFLIGHT DECK RT HAND NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW EA.SDR SWIA201335514Door Frame · crackedCARGO DOOR FRAME CRACKED. C-CHECK REPLACED CARGO DOOR FRAME A STRUCTURAL COMPONENT IAW SRM.SDR SWAA2013112122664Window Frame · crackedRT NR 3 WINDOW FRAME E-F WINDOW POST CRACKED AT 1ST & 2ND HOLES FROM BOTTOM. R & R FRAME IAW EASDR SWAA2013112122663Window Frame · crackedLT NR 3 WINDOW FRAME E-F WINDOW POST CRACKED AT 2ND & 3RD HOLES FROM BOTTOM. R & R FRAME IAW EA.SDR SWAA2013111822495Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR YENA20131104225Crossbeam · corrodedDURING HEAVY MAINTENANCE CHECK, FOUND CORROSION ON FR 17 CROSSBEAM RT SIDE RBL 16. PERFORMED BLEND OUT OF AREA. PERFORMED NDT HFEC ON BLEND AREA. TREATED, PRIMED AND TOPCOAT AREA. FABRICATED ANGLE. DRILLED PARTS AND INSTALLED. TREAT PRIMED AND TOPCOAT ALL SDR YENA20131104223Crossbeam · corrodedDURING HEAVY MAINTENANCE CHECK, FOUND CORROSION ON CROSSBEAM FR 84 AT LBL 23. TREATED BLENDED AREA, FILLED LOW SPOTS WITH EA 9396. FABRICATED DOUBLER. LOCATED AND DRILLED PARTS. INSTALLED WET ALL REMOVED AND FABRICATED PARTS. PERFORMED PRIME AND TOPCOAT TSDR FDEA201311042676Fitting · crackedFUSELAGE CENTER BOX FRAME 43, LT UPPER FRAME BASE-TO-ARCH JUNCTION FOUND CRACKED. R & R SUPPORT FITTING SRM 51-40-21 & EA 6-5310-T0303124.SDR XE4R2013FA0000699Beam · corrodedLEFT AFT DOOR SILL BEAM HAS TWO AREAS OF CORROSION BETWEEN FR 66-68, S23-24L, AT Y1725. THE AREAS WERE REPAIRED IAW SRM 53-41-14, FIG 201K, PRINCIPLE 5.SDR SWAA2013112722826Window Frame · crackedCOCKPIT RT NR 3 WINDOW FRAME, E-F POST CRACKED. REPAIRED FRAME IAW SWA EA.SDR SWAA2013112522736Window Frame · crackedNR 1 LT COCKPIT WINDOW FRAME CRACKED. REPAIRED IAW SWA EA.SDR SWAA2013112522735Window Frame · crackedNR 3 LT COCKPIT WINDOW POST E-F FRAME CRACKED. REPAIRED IAW SWA EA.SDR SWAA2013111822494Window Frame · crackedFLIGHT COMPARTMENT LT NR 1 WINDOW FRAME CRACKED IN FRAME AT OTBD TOP CORNER FRAME TO STRUCTURE ATTACH FASTENER HOLE ON ATTACH FLANGE. R & R FRAME IAW ACO.SDR SWAA2013111822493Window Frame · crackedFLIGHT COMPARTMENT LT 1 WINDOW FRAME CRACKED AT TOP OTBD CORNER OF WINDOW CUTOUT. R & R FRAME PER ACO.SDR UHLA2013110300577Doubler · corrodedCORROSION FOUND ON LT FWD DOUBLER, FRAMES 13-16. R & R DOUBLER.SDR SWAA2013111122085Crease Beam · crackedCREASE BEAM INNER CHORD UPPER SURFACE CRACKED AT BS 616, RBL 65. REPAIRED CHORD IAW SRM.SDR C77A20131101002Finger Doubler · corrodedCORROSION AT FWD CARGO THRESHOLD AFT FINGER DOUBLER SURFACE. R & R AFT FINGER DOUBLER IAW SRM 51-41-01 AND 51-43-01.SDR C77A20131101001Finger Doubler · gougedFWD FINGER DOUBLER HAS A GOUGE AT FWD END, R & R FWD FINGER DOUBLER IAW SRM 51-41-01 AND 51-43-01.SDR CA131104009Cross Tie · cracked(CAN) A 0.900" CRACK FOUND ON RT FRAME CROSS TIE AT FUSELAGE BS 187 AND STR NR 7. CRACK ORIGINATED FROM THE FORWARD SIDE OF THE CROSS TIE AND SPREAD HOZONTALLY TO THE NEAREST RIVET HOLE AND THEN CONTINUED APPROXIMATELY 0.400".SDR EV7A201408220001Door Frame · corrodedCORROSION WAS FOUND AROUND MAIN ENTRY DOOR UPPER OPENING AT FRAME 5 DURING A SCHEDULED 3C, 18 YEAR, AIRFRAME INSPECTION. CORROSION WAS REMOVED AND A FABRICATED DOUBLER WAS INSTALLED AT UPPER OPENING AT FRAME 5 IAW MFG DWG FGFB222105A8 EO1-1. REPAIRED CORROSISDR UHLA2013110100590Seal Depressor · gougedL1 DOOR CUTOUT STRUCTURE GOUGED ON LOWER AFT SIDE UNDER LOWER AFT OF COMMAND RAMP. R & R AFT SEAL REST IAW SRM 51-41-01 AND 51-43-01. EDGE SEALED AND PAINTED AFT L1 DOOR CUTOUT STRUCTURE IAW SRM 51-21-00, 51-23-06. INSTALLED LOWER AFT DOOR STOP IAW AMM 52-1SDR UHLA2013110100589Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 84. REMOVED CORROSION . FABRICATED AND REPAIRED REPAIRED ANGLE, FILLER AND SHIM IAW 2013-170-055123.SDR FDEA201311012663Beam · crackedONE CRACK WAS FOUND ON THE NR 33 FASTENER OF THE INNER LONGERON BEAM FLANGE AT STRINGER 11 BETWEEN FRAMES 73A AND 75A (LT SIDE). CRACK LENGTH IS 1INCH IAW E6-5310-7-3314, PT3. DRILLED OUT AFFECTED FASTENER AND CUT OUT DAMAGE PORTION OF BEAM FLANGE. NDI WAS SDR RAIA201311010001Beam · corrodedCARGO DOOR BEAM CORRODED. MAINTENANCE REPLACED BEAM.SDR SWAA2013110722031Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME THE 2ND FROM LOWER FASTENER HOLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013110722030Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME THE 2ND FROM LOWER FASTENER HOLE CRACKED. REPAIRED FRAME IAW EA.SDR V0XD201311070277Structure · damagedPASSENGER DOOR LOWER SURROUND STRUCTURE HAS TWO DAMAGED RIVETS ON THE FWD LOWER AND AFT LOWER CORNER CAPS. R & R RIVETS IAW SRM 51-42-10.SDR ASAA2013103096372Doubler · crackedON REMOVAL OF BS 492 FRAME FOUND INNER DOUBLER CRACKED LOCATED AND DRILLED NEW INNER DOUBLER IAW SRM 51-40-05-0G-0.SDR GLBA2013103000346Door Frame · crackedDURING A SCHEDULED INSPECTION, FOUND A CRACK IN THE AFT LOWER CARGO DOOR FRAME AT FS 509.50 AND BETWEEN STRINGERS 10 - 11L, 2.5 INCHES IN LENGTH. REPAIRED IAW EO 13-1900-53-077.SDR SWAA2013110122076Window Frame · crackedFLIGHT DECK RT NR 3 WINDOW FRAME E-F POST 2ND HOLE UP FROM BOTTOM HOLE CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2013111122075Window Frame · crackedFLIGHT DECK LT NR 3 WINDOW FRAME E-F POST 2ND HOLE UP FROM BOTTOM HOLE CRACKED. REPAIRED FRAME IAW ACO.SDR FDEA201310302658Crease Beam · corrodedSTRINGER 17R CREASE BEAM INNER ANGLE FROM BS 900 TO 1040 HAS SURFACE CORROSION AROUND FASTENER HOLES. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-40-13, DET 7. R & R INBD ANGLE.SDR TSAA20131031003Structure · delaminatedCOMPOSITE DAMAGE NOTED ON FUESLAGE RT VENTRAL FIN OTBD FACE, SEVERAL LOCATIONS BETWEEN FS 756 AND 768.5. DAMAGE DETERMINED TO BE BEYOND LIMITS. DAMAGE REPAIRED IAW SRM CH 53-90-10 IAW REPAIR STATEMENT 340SDS034517.SDR FDEA201310302650Plate · gougedDAMAGE FOUND FRAMES 80- 82, FWD SIDE STRINGER 57. DAMAGED PLATE BLENDED IAW SRM 53-13-12. REPAIRED IAW EA 6-5318-T0207155.SDR FDEA201310302649Plate · gougedDAMAGE FOUND FRAMES 80-82 FWD SIDE STRINGER 57, DAMAGED PLATE BLENDED IAW SRM 53-13-12. MAX DEPTH 0.23 MM. NO SRM ALLOWANCE IN THIS AREA. REPAIRED IAW EA 6-5318-T0207155.SDR DALA13056809000Seal Depressor · crackedNOSE WW UPPER E&E BAY DOOR SEAL DEPRESSOR PAN CRACKED AT LOWER AFT RADIUS. REPAIRED IAW ER/A 519813-14.SDR FDEA201310302652Door Frame · chafedAFT CARGO DOOR CUTOUT FORWARD LOWER FRAME SKIN SECTION HAS CHAFE DAMAGE. REPAIR CARRIED OUT IAW EA 6-5317-T03033344 AND RDAS 70584162/003/2013.SDR FDEA201310292634Crease Beam · corrodedBS 1180 - 1220 RT CREASE BEAM INBD ANGLE CORRODED. REPAIRED IAW EA F-5310-T0303435 PART 1. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013112209465Angle · corrodedSERVICE DOOR ANGLE MOUNT CORRODED UNDER DOOR STOP. REMOVED SERVICE DOOR ANGLE MOUNT IAW SRM 51-42-06-001-001-A01. LOCATED AND DRILLED NEW ANGLE MOUNT. INSTALLED NEW ANGLE MOUNT IAW SRM 51-42-06-001-001-A01, 51-42-34-001-001-A01 AND DWG SH670-31996.SDR SWAA2013111122070Crease Beam · corrodedCREASE BEAM UPPER SURFACE CORRODED BETWEEN STATION 960 TO 986, RBL 52. R & R CREASE BEAM IAW SRM & DRAWING.SDR FDEA201310292637Frame · corrodedAFT RIGHT FUSELAGE AT BS 1825, APU INLET DOOR CUT OUT AFT FRAME CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 53-80-15 DET. II, REPAIRED FRAME IAW SRM 53-80-15 DET. II AND REPAIR I PART 1B PG.201, CAT"A" MAJOR REPAIR.SDR SWAA2013110421790Doubler · crackedEXTERNAL POWER DOOR FRAME DOUBLER CRACKED. REPAIRED DOUBLER IAW EA.SDR DALA13056579208Door Frame · damagedAFT CARGO DOOR FRAME SURROUNDING DOOR STOPS STRUCTURAL HAS DETERIORATED, CHIPPED PAINT. REPAIRED IAW SRM 53-60-02, PARA 14.SDR AALA20131029002Door Frame · crackedRT WW FWD RT CORNER DOOR JAMB STRUCTURE CRACKED IN RADIUS OF BEND OF CLIP. REPAIRED RT WW FWD RT CORNER DOOR JAMB STRUCTURE IAW SRM 51-70-13-0G.SDR SWAA2013111422370Window Frame · crackedRT NR 3 WINDOW FRAME, E-F WINDOW POST CRACKED AT 2ND, 3RD & 4TH HOLES FROM BOTTOM. R & R FRAME IAW SWA EA & DRAWING.SDR SWAA2013111322334Window Frame · crackedLT NR 3 WINDOW FRAME, E-F WINDOW POST CRACKED AT 2ND HOLE FROM BOTTOM. REPAIRED FRAME IAW EA & DRAWING.SDR SWAA2013111122178Window Frame · crackedRT NR 1 REMOVED WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR A6WA201310284311Drag Brace · crackedRT MLG WW DRAG BRACE COMMON TO BATTERY RIB CRACKED AT FWD SECTOR. REMOVED UNSERVICEABLE RT MLG DRAG BRACE & REPLACED WITH SERVICEABLE RT MLG W/W DRAG BRACE PN 600-10389-2.SDR A6WA201310284309Drag Brace · crackedLT MLG WW DRAG BRACE COMMON TO BATTERY RIB IS CRACKED. REMOVED UNSERVICEABLE LT MLG W/W DRAG BRACE REPLACED WITH SERVICEABLE LT MLG W/W DRAG BRACE, PN 600-10389-1.SDR DALA13056256301Lock Fastener · misinstalledLOCK FASTENER COLLARS INSTALLED FLUSH WITH NO THREADS SHOWING. LOCK FASTENER SCREWED INTO ADJACENT COLLARS. AII THE DISCREPENCIES CORRECTED IAW SRM 51-10-02 AND SRM 51-40-02.
Back to JASC 5310