JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 SWAA2013071218179Frame · crackedFS FRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW EA & ER.SDR SWAA2013071218178Frame · crackedFS FRAME CRACKED AT BS 747, STRINGER 8R. REPAIRED FRAME IAW EA & ER.SDR SWAA2013071218177Frame · crackedFS FRAME CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW EA & ER.SDR QXEA2013032700685Frame · corrodedFRAME 624.5 IS CORRODED STR 31S-32S. FRAME FLANGE FOUND OUT OF LIMITS DUE TO 90 PERCENT MATERIAL LOSS, IAW SRM 53-00-00-02-09. REMOVED 5 RIVETS & REMOVED CORROSION IAW SRM 53-00-00-02-09. REMOVED CORROSION FROM WEB AT STA 624.5, STR 31S-32S IAW SRM 51-21-00-0SDR QXEA2013032700682Frame · corrodedFRAME 449.5 FLANGE IS CORRODED STR 31P-32P. REMOVED 6 RIVETS IN FLANGE IAW SRM 51-42-05-02-01, REV 12. REMOVED CORROSION ON FLANGE 449.5 STR 31P-32P IAW SRM 51-21-00-00-02, REV 12. REMOVED CORROSION ON FRAME WEB 449.5 IAW SRM 51-21-00-00-02, REV 12. REMOVEDSDR GLBA2013032700217Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE FRAME AT FS 164 AND STRINGER 10R, 0.375" IN LENGTH. REPAIRED IAW EO 13-1900-53-028. MAJOR REPAIR.SDR GLBA2013032700216Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK AT FS 451 AND STRINGER 10R FRAME, .5" IN LENGTH. REPAIRED IAW EO 13-1900-53-027. MAJOR REPAIR.SDR EE4Y201303270045Frame · damagedAFT CARGO COMPARTMENT BS 889 BETWEEN L27 AND 28L FRAME WITH AN ELONGATE HOLE. REPAIRED IAW SRM 53-03 PARA 1C, FIG 2A.SDR EE4Y2013032700036Frame · crackedCARGO CABIN AT BS 813, L17R, FRAME WEB WITH CRACK. REPAIRED CARGO CABIN FRAME SECTION BS 813 BETWEEN L16 AND 18R DUE TO CRACK IAW SRM 53-03, FIG 32, PARA 26.SDR SWAA2013042415065Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013041014678Frame · crackedFRAME CRACKED AT BS 348.2, STR 16L. REMOVED AND REPLACED ATTACH CLIP IAW SRM & DWG.SDR AALA20130326020Frame · crackedTHE 1485 CANT FRAME CRACKED BELOW STAIR RET ACTUATOR. INSTALLED CANT FRAME SPLICE REPAIR AND FRAME STIFFENER AT STATION 1485 PER AARD 53-10-00-33.SDR ASOA20130326096Frame · gougedDURING C-CHECK FRAME 60 AT STRINGER 5L GOUGED. MX PERFORMED REPAIR AT FRAME 60 STRINGER 5L IAW SRM 53-00-04. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA2013032594696Frame · corrodedR2 GALLEY SERVICE DOOR STA 986, FRAME AT TOPSIDE OF FLOOR HAS OPEN HOLE ON BACKSIDE OF FRAME AND FRAME HAS CORRODED. ACFT GROUNDED. BLENDED CORRODED IAW SRM 51-10-02, MAT REMAINING IS OUT OF ALLOWABLE DAMAGE LIMITS IAW SRM 53-60-15. R & R DAMAGED LWR FRAMESDR C77A20130502002Frame · crackedON APPROACH, CREW REPORTED A BIRD STRIKE ON THE UPPER FUSELAGE SKIN JUST AFT OF THE RADOME. AFTER INSPECTION, MX FOUND EVIDENCE OF A BIRD STRIKE THAT CAUSED THE FOLLOWING DAMAGE: ON FR 1 AFTER OPENING THE RADOME AN 8" LONG DENT, .2187" DEEP AND 1.8" IN HEIGHTSDR ASAA2013032594573Frame · gougedFWD CARGO BS 400, FRAME GOUGED AT S25R. R & R SPLICE IAW SRM 51 40 02 0G 0, ITEM 4, PAGE 2.SDR SWAA2013041915021Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013041514833Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013041014641Frame · corrodedFRAME CORRODED AT STA 927, BETWEEN L30R TO L29R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013041014640Frame · corrodedFRAME CORRODED AT STA 908, L30. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013041014639Frame · corrodedFRAME CORRODED AT STA 889, L30. REMOVED AND REPLACED FRAME IAW SRM.SDR LR7A2013032500613Frame · crackedDURING SCHEDULED C-11 CHECK, FOUND RT CABIN RING SEGMENT CRACKED AT FS 405, WL139. REPAIRED IAW SMP583, SRM FIG 51-140-21.SDR LR7A2013032500611Frame · damagedDURING SCHEDULED C-11 CHECK, FOUND RT CABIN RING SEGMENT CLIP RIVET HOLE ELONGATED AT FS 411 WL 142. RBL 65. REPAIRED IAW SMP583 SRM FIG 51-140-21.SDR LR7A2013032500593Frame · corrodedDURING SCHEDULED C-11 CHECK, FOUND CARGO FLOOR BULKHEAD LOWER CAP CORRODED AT FS 257, RBL 5. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500572Frame · corrodedDURING SCHEDULED C-11 CHECK, FOUND RT FUSELAGE RING SEGMENT FS 777E, WL 144 CORRODED. RBL 65, REPAIRED IAW SMP583 SRM FIG 53-40-11.SDR LR7A2013032500556Frame Splice · corrodedDURING SCHEDULED C-11 CHECK, FOUND UNDERDECK FS 236 RING SEGMENT SPLICER HAD CORROSION AT WL 146, LBL 61. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500547Frame · crackedDURING SCHEDULED C-11 CHECK, FOUND RT FS 617 FRAME FLANGE CRACKED RB L62, WL 283. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500524Doubler · corrodedDURING SCHEDULED C-11 CHECK, FOUND CABIN LT FRAME SEGMENT HAD CORROSION ON REINFORCEMENT DOUBLER AT FS 357, WL 142, LBL 61. REPAIRED IAW SMP583 51-60 & 51-70.SDR LR7A2013032500509Frame · crackedDURING SCHEDULED C-11 CHECK, FOUND CABIN OVERHEAD FRAME CRACKED AT FS 617, RBL 20, WL 285. REPAIRED IAW SMP583, 51-60 AND 51-70.SDR LR7A2013032500508Frame · crackedDURING SCHEDULED C-11 CHECK, FOUND CABIN OVERHEAD FRAME SPLICE CRACKED AT FS 477, RBL 20, WL 286. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500500Frame · damagedDURING SCHEDULED C-11 CHECK, FOUND RT FUSELAGE RING SEGMENT HAD MULTIPLE MISDRILLED HOLES AND SURFACE CORROSION FS 351, WL 140-260. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500487Frame · crackedDURING SCHEDULED C-11 CHECK, FOUND RT FS 528, BL 61, WL 258 SIDEWALL MAIN FRAME HOLE HAD TWO CRACKS AT 4 & 5 O'CLOCK POSITION RESPECTIVELY. REPAIRED IAW MEA 382-53-12-096.SDR QXEA2013032500666Frame · corrodedFRAME 668.9, FLANGE IS CORRODED AT STR 24P. STARTED REMOVING CORROSION FROM FRAME FLANGE IAW SRM, REV 12 51-21-00-00-02. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. REMOVED INTERCOSTAL AND GUSSET AT FRAME 668.9 + STR 24P TO FOM IAW SRM 51-40-15-02-01 RESDR UALA2013032501873Frame · corrodedCORROSION ON FORWARD SIDE OF FRAME BS 1460 BETWEEN S29-30L. REPAIRED IAW ECRA 5310-05711.SDR DALA1311236801Frame · dentedFWD CARGO BILGE FRAME DENTED BS 580 AT S24L. REPAIRED IAW SRM 53-00-07, REPAIR 5, FIG 201.SDR ASAA2013032494568Frame · crackedFRAME AT BS 500B, RT SIDE HAS A CRACK AT THE 1 DIA WIRE PENETRATION HOLE APPROX .2500 LONG EXTENDING INBD FROM EDGE OF HOLE BELOW STRINGER 20R. REMOVED DAMAGE AND REPAIRED AREA ON FRAME BS 500B, STR 20 RT IAW SRM 53 00 07, REP 13.SDR SWAA2013042415098Frame · crackedFRAME OUTBOARD CHORD FWD FLANGE CRACKED AT BS 727, STR 18A LEFT. REPAIRED FRAME PER ER AND EA.SDR SWAA2013042415064Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR DALA1309716801Frame · dentedDENT ON FUSELAGE FRAME TOP FLANGE IN AFT CARGO BS 1500 BETWEEN S25-26L. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR SWAA2013041014634Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 26L AND STR 27L. REPAIRED FRAME IAW SRM.SDR LR7A2013032300623Frame · crackedDURING SCHEDULED B-3 CHECK, FOUND FRAME CRACKED AT FS 968, WL 278, LBL 61. REPAIRED IAW SRM 51-60 AND FIG 53-50-06.SDR LR7A2013032300622Frame · crackedDURING SCHEDULED B-3, FOUND FRAME CRACKED AT FS 814, WL 278, RBL 61. REPAIRED IAW SRM 51-70 AND FIG 51-140-21.SDR LR7A2013032300621Frame · crackedDURING SCHEDULED B-3 CHECK, FOUND CRACKED FRAME AT FS 814, LBL 61, WL 278. REPAIRED IAW SRM 51-70 AND FIG 51-140-21.SDR LR7A2013032500623Frame · crackedDURING SCHEDULED B-3 CHECK, FOUND FRAME CRACKED AT FS 968, WL 278, LBL 61. REPAIRED IAW SRM 51-60 AND FIG 53-50-06.SDR LR7A2013032500622Frame · crackedDURING SCHEDULED B-3 CHECK, FOUND FRAME CRACKED AT FS 814, WL 278, RBL 61. REPAIRED IAW SRM 51-70 AND FIG 51-140-21.SDR LR7A2013032500621Frame · crackedDURING SCHEDULED B-3, FOUND CRACKED FRAME AT FS 814, LBL 61, WL 278. REPAIRED IAW SRM 51-70 AND FIG 51-140-21.SDR SWAA2013032814204Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR DXTA2013032505335Frame · chafedFRAME IN MX BAY ABOVE HYD RESERVOIR IS CHAFED BY LP BLEED AIR VALVE. REMOVED LP BLEED AIR VALVE FOR ACCESS TO FRAME. CUT OUT CHAFED SECTION OF FRAME AT BS 479.5. FABRICATED DOUBLER FROM NEW FRAME SECTION AND INSTALLED. IAW MM 21-11-00.SDR SWAA2013071518216Frame · crackedFS FRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013071118076Frame · crackedFS FRAME CRACKED AT BS 360, STRINGER 8L. REPAIRED FRAME IAW EA.
Back to JASC 5311