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 AALA20140924008Door Frame · crackedFORWARD CARGO DOOR AFT CUT OUT FRAME WAS DENTED, GOUGED & HFEC SHOWED CRACK INDICATION AT STATION 495 BETWEEN STRINGERS 22 & 23 RT. CUT OUT DAMAGE & INSTALLED DOUBLER IAW SRM 53-00-01 FIGURE 202 1.SDR DALA2014091805163Spacer · corrodedCORROSION ON AFT CARGO DOOR LOWER FRAME BEAM REPAIR SPACER BETWEEN BS 1155-1212. SPACER WAS REPLACED IAW SRM 53-05, FIG 123.SDR DALA2014091805162Door Frame · corrodedCORROSION ON AFT CARGO LOWER DOOR JAMB BEAM HORIZONTAL L/E BELOW PREVIOUS REPAIR DOUBLER BETWEEN BS 1158-1205. REPAIR DOUBLER WAS REPLACED IAW SRM 53-05, FIG 123.SDR DALA2014091805145Doubler · wornWEAR ON INNER DOUBLER OF TITANIUM AT AFT LAVATORY SERVICE PANEL TRAY. DOUBLER WAS REPLACED IAW DWG 5911423, REV CD AND SRM 51-30-2, SRM 51-30-5, SRM 51-10-3, PAR 14.SDR SCNA20140919120Structure · corrodedPASSENGER CABIN AFT WET AREA FS 986.5, 2.5 INCHES INBD OF MOP SILL AT L2 DOOR, CORRODED. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED.SDR SWAA2014120334622Window Frame · crackedRIGHT NR 3 WINDOW FRAME HOLE AT EF POST 2ND HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR ASOA2014102711507Door Frame · corrodedAVIONICS BAY DOOR CUT-OUT, ENTIRE CUTOUT, CORRODED. BLENDED CORROSION ALONG THE FWD EDGE OF THE AVIONICS BAY DOOR CUT OUT IN REF TO SRM 51-21-06-001-001-A01, CORROSION IN A NON DAMAGEABLE AREA. THIS REPAIR IS CLASSIFIED AS MAJOR REPAIR IAW SOP 5702. COMPLSDR ASOA2014102111459Doubler · chafedREPAIR AT BS 977 STRINGER 27 IS CHAFED. REMOVED AND REPLACED THE REPAIR DOUBLER IAW SRM 51-42-20-001-001-A01 AND REO 670-53-00-922, REV-10-03-14.SDR DALA2014091905118Linkage · damagedTHE TAILCONE CATWALK OVER THE VENTRAL STAIRWAY, RT SIDE LINKAGE WAS FOUND DAMAGED. THIS IS CONSIDERED A DEFECT IN THE EMERGENCY ESCAPE SYS AND COULD HAVE AN ADVERSE AFFECT ON THE EVACUATION ROUTE. THE LINK AT THE RT SIDE TORSION BAR WAS REPLACED, THE MOVEABLSDR SIMA20140917001Roller · defectiveFLIGHT ATTENDANT NOTED THAT MAIN CABIN DOOR HARD TO OPEN. R & R MAIN DOOR UPPER ADT FRAME J ROLLER IAW AMM 53-21-02. LUBRICATED REMAINING MAIN DOOR FRAME ROLLERS IAW ETN EM-52-048. OPERATIONS CHECKED GOOD.SDR 4AER20140917101Door Frame · corrodedAFT CARGO DOOR FRAME INTERIOR FWD EDGE HAS MULTIPLE AREAS OF CORROSION INCLUDING EXFOLIATION.SDR SWIA201439286Structure · damagedBIRDSTRIKE TO THE FUSELAGE BELOW THE F/O`S WINDOW IN AND ABOVE THE RVSM AREA. FORWARD OF BS 220 AND SPANS BETWEEN STR 13 AND STR 15 AND DIRECTLY OVER STR 14. REPAIRED RT FWD FUSELAGE BS 210 - 220 BETWEEN STRINGERS 13-15R ORIGINAL CONTOUR IAW REO.SDR SIMA20140916006Roller · dirtyMAIN CABIN DOOR DIFFICULT TO CLOSE & OPEN. CLEANED & LUBED DOOR ROLLERS NO DEFECT NOTED IAW AMM 53-21-02.SDR USAR201411130001Frame · crackedAIRSTAIR DOOR LOWER CLOSURE FRAME MID SECTION HAS A CRACK APPROXIMATELY .320 IN LENGTH.SDR ASOA2014101511416Door Frame · corrodedMAIN AVIONICS BAY DOOR CUT OUT FWD SIDE HAS CORROSION BETWEEN STR 25R AND STR 25L WHERE THE DOOR SEAL CONTACTS THE FUSELAGE. REMOVED CORROSION AT FWD SIDE AVIONICS DOOR CUTOUT IAW SRM 51-21-06-001-001-A01.SDR SWAA2014093032453Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME CRACKED ON FWD INBD SIDE, 2 1/4 DOWN FROM TOP OF WINDOW FRAME. REPAIRED FRAME IAW ACO.SDR UHLA2014091500631Crossbeam · corrodedCORROSION FOUND ON FRAME 84 CROSSBEAM BETWEEN SEAT TRACKS. REMOVED DAMAGE IAW ETD2014-170-074965.SDR REXA2014091400976Door Frame · brokenTASK CARD 900-52-810-103 CTR CARGO DOOR WAY DOOR JAMB HAS A CORNER BROKEN OFF. PANEL 1512LW REMOVED IAW AMM 25-52-01-000-802-A02, TO BE INSTALLED ON PANEL SHEET OPS 192 TALLY 424. DOOR JAM WAS REPLACED.SDR SWAA2014092232131Crease Beam · corrodedFORWARD GALLEY DOOR CREASE BEAM ANGLE CORRODED. R & R ANGLE IAW DWG & SRM.SDR SCNA20140919121Beam · corrodedPASSENGER CABIN AFT WET AREA INBD OF L2 DOOR AT BS 967, LBL 36 HAS CORROSION ON TOP SURFACE OF BEAM . BLENDED CORROSION IAW EA 15791 FOUND TO BE OUT OF LIMITS.SDR DALA2014091805113Beam · crackedCRACKED BEAM NR 1 FWD AND AFT ENDS AT R1 DOOR STRUCTURE. DAMAGED BEAM WAS REPLACED IAW SRM 51-30-1, 51-30-2 , 51-30-5.SDR IXXA20150331086Strap · corrodedAIRCRAFT ON GND FOR HEAVY MX, FAILSAFE INSPECTION. ALC DOOR FRAME STRAP AT FS 1269 BETWEEN STRINGER 32 - 31 CORRODED AROUND FASTENER. INSTALLED NEW STRAP IAW SRM 51-40-02. SPLICE FABRICATED IAW REA 47089REA16.SDR SWAA2014100332591Window Frame · crackedRIGHT NR 1 WINDOW FRAME OTBD POST CRACKED FROM UPPER INBD HOLE ON FLANGE COMMON TO NR 2 FRAME. R & R FRAME IAW ACO.SDR SWAA2014100232544Window Frame · crackedFIRST OFFICER'S SIDE NR 3 WINDOW FRAME E-F POST CRACKED AROUND UPPER FWD FASTENER. R & R FRAME IAW EA.SDR SWAA2014100232534Window Frame · crackedLEFT NR 3 WINDOW FRAME E-F POST CRACKED AT UPPER FWD FASTENER. R & R FRAME IAW EA.SDR IPXA2014092684403Panel · corrodedINSPECTION C-14, PANEL 198LR HAS EVIDENCE OF LIGHT CORROSION ON UPPER SURFACE CORROSION OUT OF LIMITS. REPLACED CHORD IAW SRM 51-40-02-06 PARA 4 AND 7 AND DWG 149N7633, REV H.SDR SWAA2014091632029Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 788. REPAIRED WEB IAW SRM.SDR SIMA20140909001Channel · corrodedDURING MBV INSPECTION, QA FOUND SERVICE DOOR CUT OUT CORRODED AT LOWER AFT FASTENER HOLE. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. PERFORMED PERMANENT REPAIR ON SERVICE DOOR CUT OUT AT FRAME 22 IAW SDR ASOA20140909272Beam · corrodedDURING C-CHECK, CARGO DOOR LOWER CUTOUT CORRODED. R & R CARGO DOOR LOWER CUTOUT IAW SRM 51-40-02. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA20140908017Structure · crackedRIGHT FWD EQUIPMENT COMPARTMENT SHELF IS CRACKED AT WL 79.50 JUST FWD OF FS 202.75. CRACK APPROX 1/4 INCH IN LENGTH. REPAIRED RT FWD EQUIPMENT COMPARTMENT SHELF CRACK AT WL 79.50 JUST FWD OF FS 202.75 IAW ETN-CR-53-099.SDR FDEA201409082531Dome Nut · brokenBS 1040 - 60 LT INBD CREASE BEAM DOME NUTS BROKEN. R & R CREASE BEAM WITH A NEW ONE IAW SRM 51-40-02 & DWG 146N5600.SDR KO0R201409080007Door Frame · corrodedFORWARD LOWER CORNER OF THE LOWER AFT CARGO DOOR CUTOUT IS CORRODED AT BS 1637 AT LONGERON, 43R.SDR SWAA2014091632028Crease Beam · corrodedCREASE BEAM CORRODED BETWEEN BS 947.5 TO 986.5 RBL 54. R & R CREASE BEAM IAW DWG & SRM.SDR ASOA20140906270Beam · corrodedDURING C-CHECK, CARGO DOOR CUTOUT LOWER BEAM FOUND CORRODED BETWEEN FRAMES 65-68. MAINTENANCE REMOVED AND INSTALLED NEW DOOR CUTOUT BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2014102233245Crease Beam · corrodedRIGHT CREASE BEAM CORRODED BETWEEN BS 945 TO 952.5 RBL 55. R & R CREASE BEAM IAW SRM.SDR SWAA2014101432907Crease Beam · corrodedLEFT CREASE BEAM CORRODED AT BS 993 LBL 45. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2014101432906Crease Beam · corrodedLEFT CREASE BEAM CORRODED BETWEEN BS 947.5 TO 956 LBL 54. R &R CREASE BEAM IAW SRM & DWG.SDR SWAA2014092532301Door Frame · crackedFRAME AT L1 DOOR INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014092232155Crease Beam · crackedL1 DOOR AREA, CREASE BEAM CRACKED AT BS 348.2 AT ATTACH FASTENER HOLE FOR FRAME INNER CHORD. R & R BEAM IAW DWG & SRM.SDR UHLA2014090400800Structure · corrodedCORROSION FOUND ON WASTE SERVICE BOX EXTERIOR SIDE FWD EDGE CORRODED. R & R WASTE BOX EXTERNAL DOUBLER IAW SRM 51-41-02 AND SB 170-53-0095. MAJOR REPAIRSDR UHLA2014090300656Finger Doubler · corrodedCORROSION FOUND ON FWD CARGO CUTOUT AFT FINGER DOUBLER. R & R AFT FINGER DOUBLER IAW SRM 51-41-02, 51-43-04, & 51-21-01.SDR UHLA2014090100637Rib · crackedRIB 4 CRACKED AT 341AR. CUTOUT DAMAGE IAW ETD2014-170-073905, REV A. FABRICATED REPAIR DOUBLER AND FILLER IAW ETD 2014-170-073905, REV A. INSTALLED REPAIR IAW 2014-170-073905, REV A.SDR SWAA2014091531941Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW AT E - F POST 2ND LOWER FASTENER HOLE CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014091531940Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR ASOA2014090511183Structure · damagedDURING GEAR RETRACTION AND EXTENSION, FOUND LT MLG WHEEL WELL DAMAGED. REPAIRED IAW EA 20-2014-157 P1.SDR FDEA201409012387Door Frame · chafedCABIN STATION 685 STRINGER 8L TO 9L L2 DOOR CUT OUT FWD FRAME FOUND CHAFED AT INNER SURFACE.SDR SWAA2014100232572Window Frame · crackedRIGHT NR 3 WINDOW FRAME E-F POST 2ND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW SI.SDR SWAA2014093032480Window Frame · crackedLEFT NR 3 WINDOW FRAME E-F POST 2ND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014092932390Window Frame · crackedRIGHT NR 1 WINDOW FRAME OTBD UPPER CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014092532324Door Frame · crackedFORWARD CARGO DOOR CUT OUT FRAME WEB CRACKED AT BS 492 STRINGER 24R. R & R FRAME IAW EO & EA.
Back to JASC 5310