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 K11A2008121672001Frame · corrodedFRAME HAS EVIDENCE OF CORROSION.SDR 2007UALA04076Frame · dentedFOUND AFT PIT STA 1360 STR 26R MAIN FRAME HAS DENT.SDR SWAA074957Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA074958Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 15L. REPAIRED FRAME PER SRM.SDR RMXA2007002Frame · crackedDURING SCHEDULED INSPECTION A 18MM LONG CRACK WAS DISCOVERED ON THE LT 'A' FUSELAGE FRAME 2L. THE CRACK IS ON THE LOWER SKIN ONLY OF A DOUBLE SKIN ASSEMBLY. THE CRACK ORIGINATES FROM A BOLT HOLE, EXTENDS 9MM IN EACH DIRECTION FROM THE BOLT HOLE. THE BOLT IS SDR 2007UALA04051Frame · corrodedFOUND AFT PIT FRAME CORRODED STA 794 RBL TO 15-28 STR 25-27R. FABRICATED AND INSTALLED REPAIR ANGLE, STRINGER CLIP AND REPAIR ANGLE CLIP.
SDR 2007UALA04050Frame · damagedLT UPPER INTERIOR FUSELAGE STA 294.5 FRAME OB FLANGE AT STR 9L+2" HAS TOOLING DAMAGE THROUGH FLANGE. CUTOUT TOOLING DAMAGE. FABRICATED AND INSTALLED ANGLE DOUBLER.SDR 2007UALA04047Failsafe · corrodedAFT PIT FAIL/SAFE FRAME CHORD CORRODED, BS 787, LBL 1" TO RBL 7". REMOVED DAMAGE. FABRICATED AND INSTALLED FAIL SAFE CHORD REPAIR.SDR SWAA074940Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074942Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA074939Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 22L. REPAIRED FRAME PER SRM.SDR SWAA074941Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074943Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074954Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 188, STR 17R. REPAIRED WEB PER SRM.SDR SWAA074953Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 322, STR 20L. REPAIRED FRAME PER SRM.SDR 2007UALA04034Frame · damagedBS 680 LBL 26", BS 720 LBL 26" ON FRAME UPPER CAPS HAVE MIS-DRILLED HOLES. *S/D* MAJOR REPAIR ACCOMPLISHED. AFTER DTA THESE REPAIRS HAVE BEEN CONSIDERED CAT 'C' OR TIME LIMITED. ENGINEERING TO REVIEW CURRENT REPAIRS FOR CAT 'A' OR 'B' CONSIDERATIONS. ALL SDR 2007UALA04027Frame · dentedAFT PIT FRAME DENTED AT STA 1340 LT AND RT SLOPE AREAS. 10-26-07 MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE AREA AND FABRICATED AND INSTALLED AN APPROVED REPAIR.SDR AMWA0828013BFrame · chafedREPAIRED LT AND RT FUSELAGE FRAME DAMAGED BY FRICTION CHAFING AT FS 213.25.SDR AMWA0828013JFrame · chafedREPAIRED FUSELAGE FRAMES DAMAGED BY FRICTION CHAFING AT LT AND RT FS 408.25.SDR AMWA0828013DFrame · chafedREPAIRED FUSELAGE FRAME DAMAGED BY FRICTION CHAFING AT FS 243.25, RT.SDR AMWA0828013CFrame · chafedREPAIRED LT AND RT FUSELAGE FRAMES DAMAGED BY FRICTION CHAFING AT FS 228.25.SDR AMWA0828013GFrame · chafedREPAIRED FUSELAGE FRAMES DAMAGED BY FRICTION CHAFING AT LT AND RT FS 318.25.SDR AMWA0828013HFrame · chafedREPAIRED FUSELAGE FRAME DAMAGED BY FRICTION CHAFING AT RT FS 363.25.SDR AMWA0828013KFrame · chafedREPAIRED FUSELAGE FRAMES DAMAGED BY FRICTION CHAFING AT LT AND RT FS 438.25.SDR AMWA0828013IFrame · chafedREPAIRED FUSELAGE FRAMES DAMAGED BY FRICTION CHAFING AT LT AND RT FS 378.25.SDR AMWA0828013FFrame · chafedREPAIRED FUSELAGE FRAME DAMAGED BY FRICTION CHAFING AT RT FS 303.25.SDR AMWA0828013EFrame · chafedREPAIRED LT AND RT FUSELAGE FRAMES DAMAGED BY FRICTION CHAFFING AT FS 258.25.SDR 07FDEA04471Frame · corrodedBULK CARGO PIT T CAP AT FRAME 64 BL0 TO LBL15 IS CORRODED NO ALLOWABLE REWORK FOR T-CAP SPECIFIED IAW A310 SRM 53-10-15, REMOVED AND REPLACED T-CAP IAW A310 SRM 51-40-21.SDR MWEA070232Frame · chafedLEFT PNEUMATIC DUCT VALVE CHAFING AGAINST WEB AT FRAME STATION 1382 BELOW STRINGER 4 LEFT. REMOVED DAMAGED WEB DOUBLER, FABRICATED AND INSTALLED DOUBLER.SDR SWAA074915Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074914Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074913Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074912Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR 07FDEA04470Frame · corrodedFOUND AFT CARGO PIT AT FRAME 61 AT S-54L IS CORRODED. 10-11-07 NO GENERAL OR SPECFIC ALLOWABLE DAMAGE FOR STRINGER IAW A310 SRM 53-17-14, REMOVED STRINGER SECTION AND COUPLINGS AND FABBED NEW STRINGER SECTION AND 2 COUPLINGS IAW A310 SRM 53-10-14 PG 2SDR 07FDEA04469Frame · corrodedFOUND AFT CARGO PIT AT FRAME 54.1 S-52L CORRODED. 10-29-07 REMOVED CORROSION AT STRINGER 52L FRAME 54.1 IAW A310 SRM 51-74-10, FOUND OUT OF LIMITS IAW A310 SRM 53-10-14, REMOVED STRINGER IAW A310 SRM 53-10-14, FABBRICATED NEW SRTINGER REPAIR AND 2 COUPLISDR 07FDEA04464Frame · damagedFOUND ENLARGED HOLES AT C 26/32 BETWEEN P 13-22 RT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR DHL2007748006Frame · dentedFRAME DENTED IN MAIN CABIN BS 540 STRINGER 17R. REMOVED PREVIOUS REPAIR AT MAIN CABIN BS 540 STRINGER 17R IAW B-727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MATERIAL USED 7075-T6 0.063" PO NR 9005713 DIMENSION (9.25 BY 4.875") IAW B-727 SRM 53-10-2 FIGURE 3 SDR LR7A07119Frame · brokenDURING SCHEDULED C-7 CHECK PER JOB CARD HC5324 FOUND RT MLG FRAME OUTBOARD CAP BROKEN AT FS 528 WL 209 & 232 RBL 66. REPAIR ACCOMPLISHED IAW LYNDEN AIR CARGO MEA 382-53-07-063.SDR LR7A07118Frame · crackedDURING SCHEDULED C-7 CHECK PER JOB CARD HC5324 FOUND RIGHT MLG FRAME INNER CAP CRACKED AT FS 528 WL 232-240 RBL 66. REPAIR ACCOMPLISHED IAW LYNDEN AIR CARGO MEA 382-53-07-063.SDR LR7A07105Splice · crackedDURING SCHEDULED C-7 CHECK PER JOB CARD HC5317 FOUND CABIN OVERHEAD RING SEGMENT SPLICER CRACKED AT FS 477 WL 285 RBL 20. REPAIR ACCOMPLISHED IAW SMP583 CHAPTER 51-60 & 51-70.SDR LR7A07102Rib · crackedDURING SCHEDULED C-7 CHECK PER JOB CARD HC5311 FOUND COCKPIT RIB CRACKED AT FS 132 WL 207 TO 215 LBL 61. REPAIR ACCOMPLISHED IAW SMP583 CHAPTER 51-60 & 51-70 USING 2024T3 .050".SDR UIEA200700424Frame · damagedAFT LOWER FUSELAGE AT FS 2658 FRAME LOWER SURFACE SCRAPED DUE TO TAIL DRAG. PERMANENT REPAIR ACCOMPLISHED AS PER B747-200 SRM 53-10-04 FIG 75 SHEETS 1 THRU 15. REFERENCE ATLAS AIR XEO 53-093007.SDR UIEA200700423Frame · damagedAFT LOWER FUSELAGE AT FS 2638 FRAME LOWER SURFACE SCRAPED DUE TO TAIL DRAG. PERMANENT REPAIR ACCOMPLISHED AS PER B747-200 SRM 51-20-01 FIG 3, AND SRM 51-30-02. ALSO REFERENCE ATLAS AIR XEO NR 53-093007-1.SDR GLBA20061008Frame · crackedFRAME CRACKED AT STRINGER CUTOUT FS 177 AT STRINGER 9AR. REPAIRED FRAME AT STRINGER RELIEF HOLE FS 177 AND STRINGER 9AR IAW 1900D SRM 51-70. REPAIR DIMENSIONS 4.5 BY 2.5 . 2024 T-3 .080. RII COMPLIED WITH IAW TASKCARD 8.2.1.SDR SWAA074878Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074877Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074881Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 787, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA074880Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074879Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR KCSA071436Frame · crackedOUTER FLANGE OF FRAME AT SKIN ATTACHMENT AT STA-440 BEWTEEN STR-11L AND STR-12L IS CRACKED .75 INCH.
Back to JASC 5311