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 ABXA20130810503Failsafe · crackedFRAME FAILSAFE CRACKED AND CORRODED. CRACK VERIFIED WITH HFEC IAW NDTM, PART 6 51-00-19 AND VISUALLY VERIFIED. FAILSAFE REPAIRED ON JC EA53500013-003. ACFT WAS GROUNDED.SDR IPXA2013082300937Tension Tie · crackedINSPECTION TYPE:C, BS 720 TENSION TIE FWD CHANNEL FOUND CRACKED. REPAIRED IAW SRM 53-20-30-2R-2. REPAIR 2, FIG 201 REV 67. MAJOR REPAIR.SDR IPXA2013082300935Tension Tie · crackedINSPECTION TYPE:C, MAIN DECK BS 720 TENSION TIE FOUND CRACKED. REPAIRED IAW SRM 53-20-30 -2R-1, REPAIR 1, FIG 201, REV 67. MAJOR REPAIR.SDR UHLA2013081000365Splice · corrodedCORROSION FOUND ON AFT CENTER SPLICE AT FR 90. R & R AFT CENTER SPLICE.SDR ASOA20130811201VDoor Frame · corrodedDURING C-CHECK THE SERVICE DOOR CUTOUT AFT FRAME 22 AT STRINGER 15-16R WAS FOUND TO BE CORRODED. MX REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW EC5310-01373. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130811199VBeam · corrodedDURING C-CHECK THE CARGO DOOR LOWER CUTOUT BEAM WAS FOUND TO BE CORRODED. MX R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013082219446Window Frame · crackedRT NR 1 WINDOW FRAME & WINDSHIELD ASSEMBLY CRACKED. R&R FRAME IAW ACO.SDR FDEA201308081812Structure · corrodedRT WW SLANT PANEL AREA EDGE MEMBER CORRODED. REMOVED EDGE MEMBER SLANT PANEL. FABRICATED EDGE MEMBER IAW DWG AEA0449. INSTALLED NEW EDGE MEMBER IAW SRM 51-35-01, VOL II.SDR CALA2013080890261Failsafe · crackedBS 1220, FRAME DOUBLER & FAILSAFE CRACKED.SDR SWAA2013082919695Window Frame · crackedLT CABIN WINDOW AT FRAME STATION 889L, WINDOW FRAME LOWER AFT END CRACKED. REPAIRED FRAME IAW SRM.SDR SWAA2013082919694Window Frame · crackedLT MAIN WINDOW AT FRAME STATION 636L, WINDOW FRAME LOWER FWD END CRACKED. REPAIRED FRAME IAW SRM & DRAWING.SDR FDEA201308071802Crease Beam · corrodedCREASE BEAM INBD CHORD AT BS 1170 RT SIDE CORRODED. REMOVED CORROSION IAW SRM 51-10-02; FOUND OUT OF LIMITS IAW SRM 53-40-13, DETAIL III, FIG 101. REMOVED INBD ANGLE BS 1040-1180, IAW SRM 51-40-02. FABRICATED NEW INBD ANGLE LOCATED & DRILLED IAW SRM 51-40-SDR ANCF2013080700163Unknown · vibrationHIGH VIBRATION DURING CLIMBING AT 25,000 FT AND 27,000 FT, IAW TSM 53-35-00-810-801. A VIBRATION AND/OR NOSE FELT AND TSM 05-50-00-810-801-A IDENTIFICATION OF THE CAUSE OF IN-FLIGHT AIRFRAME VIBRATIONS AND/OR NOISES WERE PERFORMED, VIBRATION REPORTING SHEET ASDR MJYA201308100002Window Frame · crackedRT NR 11 PASSENGER COMPARTMENT WINDOW CUTOUT HAS CRACK INDICATION LOWER AFT CORNER.SDR MJYA201308100001Door Frame · crackedAFT PRESSURE BULKHEAD DOOR FRAME CRACKED APPROX 12 INCHES FROM BOTTOM FRAME.SDR IPXA3580073Angle · corrodedINSPECTION TYPE:C8, MAIN CABIN BS 1610-1630, RBL 60 CREASE BEAM RETAINER ANGLE CORRODED IN TWO PLACES. R & R RETAINER ANGLE IAW PRODUCTION DWG 146N5353-70-2.SDR SWAA2013082719635Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED SECOND FASTENER HOLE LOWER CORNER. R&R FRAME IAW EA & DRAWING & SRM.SDR SWAA2013082319482Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT FASTENER HOLE AT UPPER OTBD CORNER. R&R FRAME IAW ACO.SDR SWAA2013082319481Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R&R FRAME IAW ACO.SDR DXTA2013080605471Frame · damagedDURING DESCENT THRU 17,000 FT, THE ACFT HAD A BIRD STRIKE AT 300 KTS JUST BELOW THE RT WINDSCREEN. THERE IS A DENT THE SIZE OF A SOFTBALL WITH A LARGE HOLE IN IT. INSPECTED AREA AND FOUND BS 2669 FRAME DAMAGED. REMOVED DAMAGE FRAME SECTION IAW DWG SEB51011SDR ABXA20130805504Failsafe · crackedFAILSAFE CRACKED 1.7", LEFT FS 955, LBL 85.9. AIRCRAFT WAS GROUNDED. REPAIRED IAW REA B653-60654-MR.SDR CHQA20130805313Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE BOTTOM OF THE PASSENGER DOOR FRAME. THE FRAME WAS REPLACED IAW SRM 51-20-03 AND 51-40-02.SDR SWAA2013081519229Crease Beam · corrodedCREASE BEAM INBD CHORD CORRODED AT BS 706, LBL 65. REPAIRED CHORD IAW ER & EA.SDR SWAA2013081519228Crease Beam · corrodedCREASE BEAM INBD CHORD CORRODED AT BS 722, LBL 65. REPAIRED CHORD IAW ER & EA.SDR CALA2013080890242Tension Tie · crackedCRACK IN FWD TENSION TIE. REPAIRED IAW SRM 53-40-30, BS 1200.SDR FDEA201308051778Crease Beam · corrodedBS 1064, RT CREASE BEAM WEB CUTOUT FOUND CORRODED. R & R IAW DWG 144N5210 SHT , REV AND INSTALLED IAW DWG 144N5200, SHT 1, REV B. REPAIR IS MAJOR.SDR FDEA201308051777Crease Beam · corrodedBS 943, RT CREASE BEAM WEB CUTOUT FOUND CORRODED. R & R IAW DWG 144N5140, SHT 3, REV D, REPAIR IS MAJOR.SDR 2013FA0000431Spar · crackedCARRY-THRU SPAR WAS FOUND CRACKED AT THE RT FORWARD WING ATTACH AREA AT ABOUT 2-3 O'CLOCK POSITION WHILE LOOKING AFT.SDR DALA13038303756Crease Beam · corrodedDURING INSPECTION FOUND AFT WET AREA, R2 DOOR CREASE BEAM, INNER ANGLE IS CORRODED. MX REMOVED CREASE BEAM AND INSTALLED NEW IAW DWG 147A8501.SDR SWAA2013082619505Window Frame · crackedFLIGHT DECK LT NR 3 WINDOW FRAME AT E-F POST THE 2ND FASTENER HOLE FROM LOWER CORNER CRACKED. REPAIRED FRAME IAW SWA EA.SDR SWAA2013082219432Crease Beam · corrodedCREASE BEAM INBD CHORD CORRODED BETWEEN STATION 724 TO STATION 727 + 2 LBL 63. REPAIRED CHORD IAW EA.SDR SWAA2013082219425Window Frame · crackedNR 3 LT WINDOW SECOND LOWER CORNER FASTENER HOLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013082219424Window Frame · crackedNR 3 RT WINDOW SECOND LOWER CORNER FASTENER HOLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013082219423Window Frame · crackedNR 3 RT WINDOW THIRD LOWER FASTENER HOLE CRACKED. REPAIRED FRAME IAW EA.SDR A6WA2013081641127Mount · crackedACFT GROUND POWER RECEPTACLE MOUNT IS CRACKED AT FASTENER HOLE. REPAIRED MOUNT IAW REO 601R-53-11-569, REV A.SDR DALA13037519250Door Frame · corrodedMID CARGO COMPARTMENT DOOR FRAME HAS SLIGHT CORROSION BS 695, LONGERON 28L. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED, TREATED, PRIMED AND INSTALLED DOUBLER IAW SRM 51-10-03.SDR SIMA20130801007Plate · corrodedPLATE IN BELLY OF ACFT FWD OF FRAME 67 BETWEEN STR'S 21L AND 20L IS CORRODED AROUND THE RIVETS. PLATE IN BELLY OF ACFT FWD OF FRAME 67 BETWEEN STR'S 21L AND 20L REMOVED REFER TO EO EM-53MR-2189, STEP 12 AND ETA EM-5300-3088.SDR SWAA2013091220098Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME E-F POST 2ND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013082219422Window Frame · crackedCAPTAIN'S NR 1 WINDOW FRAME CRACKED IN UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR SWAA2013082219421Window Frame · crackedFIRST OFFICER'S NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR SWAA2013081619268Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME E-F POST, 2ND & 3RD FASTENER HOLES FROM BOTTOM CRACKED. REPAIRED FRAME IAW SWA EA.SDR SWAA2013081619267Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME E-F POST, 2ND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013081319153Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME SECOND LOWER CORNER FASTENER HOLE CRACKED. R&R FRAME IAW EA.SDR SWAA2013081319152Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME SECOND LOWER CORNER FASTENER HOLE CRACKED. R&R FRAME IAW EA.SDR KC8A201308010001Window Frame · crackedRT REAR WINDOW GLASS PANEL FRAME FOUND CRACKED BEYOND LIMITS DURING INSPECTION. THE WINDOW FRAME WILL BE REPLACED.SDR REXA2013073101631Mount · corrodedRADAR ALTIMETER TRANSMITTER NR 2 ANTENNA BASE IS CORRODED. REPAIRED RADIO ALT TRANSMITTER NR 2 ANTENNA BASE IAW REO 690-34-44-002 AND EO R53448.SDR SWAA2013082219444Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME AT E-F POST CRACKED AT SECOND LOWER CORNER FASTENER HOLE. R&R FRAME IAW EA.SDR SWAA2013082219443Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME AT E-F POST CRACKED AT SECOND LOWER CORNER FASTENER. CRACK EXTENDS THROUGH BOTH SIDES OF HOLE. R&R FRAME IAW SRM & DRAWING.SDR FDEA201307311707Crease Beam · corrodedCREASE BEAM INBD ANGLE CORRODED AT BS 1040 LT SIDE. REMOVED CORROSION IAW SRM 53-40-14. CHECKED LIMITS FOUND TO BE OUT OF LIMITS IAW SRM 53-40-14, FIG 1, DETAIL 2. R & R CREASEBEAM INBD ANGLE AT BS 1040-1180 LT SIDE IAW SRM 51-40-02 AND DWG 144N5214. MAJOSDR SWAA2013081419225Window Frame · crackedRT NR 1 WINDOW FRAME ASSEMBLY CRACKED UPPER AFT CORNER. R&R FRAME IAW ACO.
Back to JASC 5310