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 SWAA2014040226756Window Frame · crackedLEFT NR 1 FLIGHT DECK WINDOW FRAME CUT OUT CRACKED. REPAIRED FRAME IAW EA.SDR R61A201403220441Support Bracket · corrodedDURING HEAVY CHECK, FOUND LT PACK RAM AIR DUCT SUPPORT BRACKET CRACKED. MX R & R LT PACK RAM AIR DUCT SUPPORT BRACKET IAW SRM 51-40-02,51-41-01.SDR SWIA201436967Post · crackedRBL 18 OTBD POST AT 409+128 CRACKED AT BOTTOM OF POST. C-CHECK, INSTALLED NEW POST IAW REO, AMM AND SRM.SDR SWAA2014040326781Window Frame · crackedLEFT NR 1 WINDOW FRAME OTBD UPPER CORNER CRACKED. REPAIRED WINDOW FRAME IAW ACO.SDR UHLA2014031900285Rib · crackedCRACK ON RIB 4 RT, REWORKED AND REPAIRED CRACKED FLANGE IAW ETD2014-170-024140.SDR DALA14025889255Beam · damagedAFT CARGO C-3, LOWER BEAM, BS 1212-1269 DAMAGED. REPAIR WAS ACCOMPLISHED IAW NR 23 AND 127 DURING C-CHECK.SDR DALA14017385649Crease Beam · corrodedMAIN CABIN, CORROSION FOUND ON CREASE BEAM WEB BS 1184, LBL 67. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-60-13, FIG 101. FABRICATED REPAIR AND INSTALLED IAW SRM 51-40-02 AND ERA 522813-14, REV ORIGINAL.SDR SWIA201437974Diaphragm · damagedLT INBD DIAPHRAGM AT BS 364, STR 26L, FOUND TO BE OUT OF LIMITS. C-CHECK, R & R DIAPHRAM IAW SRM.SDR SWIA201436996Structure · corrodedCORROSION ON LOWER CENTER WING, FWD OF THE OTBD FWD CORNER OF RT WHEEL WELL. C-CHECK, BLENDED CORROSION AND FOUND WITHIN ALLOWABLE LIMITS AND REPAIRED LOWER CENTER WING, FORWARD OF THE OTBD CORNER OF RT WHEEL WELL IAW REO.SDR SWIA201436995Structure · corrodedCORROSION ON LOWER CENTER WING, FWD OF THE OTBD FWD CORNER OF LT WHEEL WELL. C-CHECK, REMOVED CORROSION ON LOWER CENTER WING, FWD OF THE OTBD FWD CORNER OF THE LT WHEEL WELL IAW REO.SDR SWIA201436885Angle · crackedLEFT SIDE COCKPIT WINDOW SIDE POST LOWER ANGLE CRACKED. C-CHECK, REPLACED CRACKED LT SIDE COCKPIT WINDOW SIDE POST LOWER ANGLE WITH NEW IAW SRM.SDR SWIA201436884Angle · crackedRIGHT SIDE COCKPIT WINDOW SIDE POST LOWER ANGLE CRACKED. C-CHECK, REPLACED CRACKED RT SIDE COCKPIT WINDOW SIDE POST LOWER ANGLE WITH NEW IAW SRM.SDR ASOA20140317029Beam · corrodedDURING C-CHECK. CARGO DOOR LOWER CUT OUT CORRODED BETWEEN FRAMES 65-68. R & R CARGO DOOR LOWER BEAM IAW SRM 51-40-02. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR R61A201403160428Door Frame · corrodedDURING HEAVY CHECK, L2 DOOR CUTOUT LOWER TOP FRAME NEXT TO GIRT BAR HAS TWO SPOTS OF CORROSION. MAINTENANCE R & R L2 DOOR CUTOUT LOWER TOP FRAME IAW SRM 51-41-02, 51-43-01, 51-42-02. MAJOR REPAIR.SDR SWAA2014032426434Window Frame · crackedLEFT NR 1 WINDOW FRAME UPPER AFT CORNER CRACKED. R & R FRAME IAW ACO.SDR R61A201403160117Door Frame · gougedDURING HEAVY CHECK, FOUND FWD AVIONICS DOOR RT SIDE FRAME GOUGED BELOW STOP. MX REPAIRED IAW ETD 20014-170-022373, REV A, VP-006114-2014/327, C1-C3 FOR WORK DETAILS THIS IS FCBS ITEM 52-43-00-008. REPAIR REQUIRES REINSPECT IAW ETD 2014-170-022373, REV A, TASSDR USAA2014031900004Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM WEB BETWEEN BS 1620 TO BS 1640, LBL 66. REPLACED CREASE BEAM WEB BETWEEN BS 1620 TO BS 1640, LBL 66 IAW SRM 51-40-02.SDR GLBA2014031700403Door Frame · crackedDURING A SCHEDULED INSPECTION MX FOUND LOWER AIRSTAIR DOOR FRAME AFT CRACKED APPROXIMATELY 1/2 INCH. REPAIRED THE AFFECTED AREA & PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 14-1900-53-022.SDR GLBA2014031700402Door Frame · crackedDURING A SCHEDULED INSPECTION MX FOUND FWD FRAME AIRSTAIR DOOR CUTOUT AT FS 150.6 BETWEEN STRINGER 10L & 11L CRACKED, CRACK IS APPROXIMATELY 1/2 INCHES. REPAIRED THE AFFECTED AREA & PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 14-1900-53-023.SDR SIMA20140314011Window Frame · corrodedCOPILOTS WINDSHIELD HAS CORROSION ON LOWER INBD SIDE OF THE OUTER FRAME. BLENDED AREAS FOR CORROSION ON COPILOTS WINDSHIELD LOWER INBD SIDE OF THE OUTER FRAME ACCEPTED IAW ERS-EM-5600-024.SDR SIMA20140314010Window Frame · corrodedPILOTS WINDSHIELD HAS CORROSION ON LOWER INBD SIDE OF THE OUTER FRAME. BLENDED AREAS FOR CORROSION ON PILOTS WINDSHIELD LOWER INBD SIDE OF OUTER FRAME ACCEPTED IAW ERS-EM-5600-023.SDR ASOA2014041410328Beam · corrodedBS 280 BEAM IS CORRODED TOP SURFACE, AT COCKPIT DOOR ENTERANCE. BEAM REPLACED IAW SB 670BA-53-041.SDR DALA14016520678Crease Beam · corrodedRT CREASE BEAM, BS 1020-1040 FOUND CORRODED. REPAIRED IAW ERA 524030-14.SDR SWAA2014041427047Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT BS 500D+18, LBL 64. REPAIRED CHORD IAW EO & EA.SDR SWAA2014033126672Window Frame · crackedRIGHT NR 3 WINDOW FRAME E F POST CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014033126670Window Frame · crackedNR 1 RT COCKPIT WINDOW FRAME CRACKED IN UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR SWAA2014033126669Window Frame · crackedNR 1 LT COCKPIT WINDOW FRAME CRACKED IN UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR SWAA2014032426428Window Frame · crackedFLIGHT DECK, LT NR 3 WINDOW CUT OUT FWD WINDOW FRAME CRACKED AT UPPER FASTENER. R & R PLACED FRAME IAW EA.SDR SWAA2014032426427Window Frame · crackedFLIGHT DECK, RT NR 3 WINDOW CUT OUT FWD WINDOW FRAME CRACKED AT UPPER FASTENER. R & R FRAME IAW EA.SDR DALA14016420698Structure · damagedBS 1720, STRINGER 28L TO 28R, HAS TAIL STRIKE DAMAGE. REPAIRED IAW ER/A 512505-14, REV A.SDR SWAA2014040126743Window Frame · crackedCOCKPIT LT NR 3 WINDOW FRAME E F POST CRACKED AT SECOND HOLE FROM BOTTOM. REPAIRED FRAME IAW EA.SDR ASAA2014031007319Failsafe · crackedFAILSAFE AT RT BS 480 IS CRACKED IN RADIUS JUST BELOW CABIN FLOOR LEVEL. ACFT GROUNDED. FABRICATED, LOCATED AND DRILLED NEW FAILSAFE IAW SRM 51-40-05-0G-0. R & R NEW FAILSAFE IAW SRM 51-40-02-0G-0.SDR FDEA201403100471Door Frame · crackedMAIN DECK CARGO BAY BS 1305, LONGERON 26L AFT OF L3 LOWER DOOR FRAME WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 55. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REVISION 120.SDR SWAA2014032426431Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME CRACKED IN UPPER AFT CORNER. R & R FRAME IAW ACO.SDR FDEA201403100470Door Frame · crackedMAIN DECK CARGO BAY BS 1256 LONGERON 26R FWD R3 LOWER DOOR FRAME WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 55. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 120.SDR FDEA201403100469Door Frame · crackedMAIN DECK CARGO BAY BS 1256 LONGERON 26L FWD L3 DOOR FRAME WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 55. CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 120.SDR SWAA2014032026290Window Frame · crackedLT NR 1 WINDOW FRAME CORNER CRACKED. REPAIRED FRAME IAW SRM & EA.SDR HALA2014031000033Window · failedDURING CRUISE FLIGHT 320, CAPTAIN`S & FORWARD WINDSHIELD, OUTER PANE SHATTERED. REMOVED AND INSTALLED NR 1 WINDOW IAW AMM 56-11-01. SEALED WINDOW, OPS CHECKED GOOD.SDR SWAA2014040726902Window Frame · crackedRIGHT NR 1 WINDOW FRAME UPPER AFT CORNER CRACKED. R & R FRAME IAW ACO.SDR SWAA2014032426471Fastener · missingFORWARD ENTRY DOOR CUT OUT AFT SIDE FRAME INNER CHORD FASTENER MISSING AT BS 348.2, STRINGER 15L. INSTALLED FASTENER IAW EA & EA.SDR AALA20140308007Window Frame · crackedWINDOW FRAME CRACKED AT STATION 1097 & STRINGER 14 LT. INSTALLED DOUBLER ANGLE IAW AARD 53-10-00.SDR AALA20140308006Window Frame · crackedRIGHT HAND FWD LOWER WINDOW FRAME CRACKED AT STATION 1136. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140308004Window Frame · crackedCRACK IN UPPER FWD CORNER OF WINDOW FRAME AT STATION 888 LT HAND. INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR AALA20140308003Window Frame · crackedFORWARD UPPER WINDOW FRAME CRACKED THRU FASTENER HOLE FROM STATIONS 946 TO 965 RT HAND. INSTALLED DOUBLER IAW AARD 53-10-025.SDR WX0A201403111874Door Frame · corrodedAFT CARGO DOOR CUTOUT FRAME BEAM CORRODED IN SEVERAL AREAS, BS 1174 - 1193. REMOVED CORROSION. LOCATED, DRILLED & INSTALLED TITANIUM DOUBLER, SPACERS, STRIP & NUTSTRIP IAW SRM 53-05 FIGURE 123.SDR USAA2014031000028Crease Beam · corrodedC4 CHECK, CREASE BEAM CHORD CORRODED AT BS 1340 & RBL 64. R & R CHORD IAW SRM 53-60-15-1A, 51-40-02 & 51-40-05.SDR WVER2014030892701Fitting · crackedPAX DOOR LINTEL CRACKED JUST AFT OF FS 280.00, STR 3L. PERFORMED A PERMANENT REPAIRED IAW REO 670BA-53-040, REV C.SDR SWAA2014040126741Window Frame · crackedRIGHT NR 3 E F WINDOW POST CRACKED IN 2ND FASTENER HOLE FROM BOTTOM. REPAIRED POST IAW ACO.SDR SWAA2014040126740Window Frame · crackedLEFT NR 3 E F WINDOW POST CRACKED IN 2ND FASTENER HOLE FROM BOTTOM. REPAIRED POST IAW ACO.SDR SWAA2014040126739Window Frame · crackedRIGHT NR 1 WINDOW POST CRACKED IN ZONE A. REPAIRED POST IAW ACO.
Back to JASC 5310