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 SWAA101950Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101949Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101948Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA101947Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA101946Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA101945Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101943Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR QXEA2010040800235Frame · corrodedC-CHECK - CORROSION ON THE ATTACH FLANGE AT FRAME FS 549.00 BETWEEN STR 27 AND 26L. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMAINING MATERIAL THICKNESS IS .059" AND WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-001SDR QXEA2010040800234Frame · corrodedC CHECK - CORROSION ON THE ATTACH FLANGE AT FRAME FS 517.00 BETWEEN STR 27 AND 26R. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMAINING MATERIAL THICKNESS IS .045" AND WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-001SDR QXEA2010040800233Frame · corrodedC CHECK - CORROSION ON THE ATTACH FLANGE AT FRAME FS 517.00 BETWEEN STR 27 AND 26L. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMAINING MATERIAL THICKNESS IS .068" AND WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-001SDR QXEA2010040800232Frame · corrodedC CHECK - CORROSION ON THE ATTACH FLANGE AT FRAME FS 517.00 BETWEEN STR 26L AND 25L. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMAINING MATERIAL THICKNESS IS .067" AND WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-001SDR QXEA2010040800231Frame · corrodedC CHECK -CORROSION ON THE ATTACH FLANGE AT FRAME FS 517.00 BETWEEN STR 23L AND 22L. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMAINING MATERIAL THICKNESS IS .069" AND WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-00SDR QXEA2010040800230Frame · corrodedC CHECK -CORROSION ON THE FWD FREE FLANGE ON FRAME FS 517.00 BETWEEN STR 26L AND 26R. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMAINING MATERIAL THICKNESS IS .048" AND WITHIN LIMITS OR SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-SDR QXEA2010040800229Frame · corrodedC-CHECK - CORROSION ON THE ATTACH FLANGE OF FRAME FS 629.00 BETWEEN STR 27 AND 26R. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REMOVED .003", REMAINING MATERIAL THICKNESS IS .060" AND WITHIN LIMITS OR SRM 53-31-06-101-003-A01. ALODINED IAW 51-21-11-00SDR DALA107289867Frame · crackedDURING H-CHECK FOUND CRACK IN FORMER AT BS 1167 AT L18. REPAIRED IAW SRM 51-10-4, 51-30-02, 51-30-05.SDR UALA2010040701160Failsafe · crackedCRACK - FAIL SAFE CHORD HOLE AT STA 1180 RT SIDE STR 9R TO 10R 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALL REPAIR PARTS.SDR USAA2010042990868Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FRAME WEB AT BS 303.9, S16L FORWARD OF L-1 DOOR. REPAIRED FRAME WEB AT BS 303.9, S16L FORWARD OF L-1 DOOR IAW JOB CARD M1L53001.SDR ASAA1047762Frame · crackedFRAME AT STA 827 CRACKED BETWEEN STR 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047761Frame · crackedFRAME AT STA 787 CRACKED BETWEEN STR 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047760Frame · crackedFRAME AT STA 380 CRACKED BETWEEN STR 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047759Frame · crackedFWD CABIN STA 440 ABOVE STR 9L FRAME CRACKED. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047758Frame · crackedFRAME CRACKED BETWEEN STRINGERS 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR IPXA10559509Frame · damagedINSPECTION TYPE:C4, BS 580 FRAME BETWEEN STR 22 AND 23 LT HAD HOLES IN THE RADIUS DUE TO A SIDEWALL LINER REPAIR. REPAIRED IAW ER NR 10-2333.SDR FDEA201004061060Frame · damagedDURING ACCOMPLISHMENT OF EO1-2620-7-5005 B PT1 STEP B2 DWG VA-FSS-26-2101 ARGON TANK INSTALLATION AT STA1461 L-1L TO L-2L AND L-3L TO L-4L FRAME DOUBLER PN VA-FSS-6158 AND VA-FSS-6159 WILL HAVE SHORT EDGE MARGIN WITH EXISTING PILOT HOLES ON NEW HANGAR PN VA-FSSDR SWAA101924Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER EA.SDR UALA2010040601144Failsafe · crackedCRACK - FAIL SAFE CHORD HOLE AT STA 1140 RT SIDE STR 9R TO 10R 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALL REPAIR PARTS.SDR UALA2010040601143Failsafe · crackedCRACK - FAIL SAFE CHORD HOLE AT STA 1140 LT SIDE 2 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALL REPAIR PARTS.SDR UALA2010040601142Frame · crackedCRACK - UPPER DECK FRAME AT STA 1220 RT FASTENER HOLE 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALLED REPAIR PARTS.SDR UALA2010040601141Frame · crackedCRACK - UPPER DECK FRAME AT STA 1180 RT FASTENER HOLE 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALLED REPAIR PARTS.SDR UALA2010040601139Frame · crackedCRACK - UPPER DECK FRAME AT STA 1140 RT SIDE FASTENER HOLE 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALL REPAIR PARTS.SDR UALA2010040601132Frame · crackedCRACK - UPPER DECK FRAME AT STA 1160 RT FASTENER HOLE 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALL REPAIR PARTS.SDR UALA2010040601130Frame · crackedCRACK - UPPER DECK FRAME AT STA 1120 RT FASTENER HOLE 1 EACH. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. HFEC MFG AND INSTALLED REPAIR PARTS.SDR 2010F00086Fastener · missingDURING A PHASE 3 AND 4 INSP MISSING RIVETS WERE DISCOVERED AT STA 100.5 ON THE LOWER FUSELAGE FRAME 128-555148-605 UNDER THE COPILOTS FLOORBOARDS JUST AFT OF THE RUDDER PEDALS. THE 4 MISSING RIVETS WERE SUPPOSE TO ATTACH THE FRAME TO AN OTBD CLIP. THERE WAS NOSDR SWAA101862Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101858Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101857Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR CALA2010040600122Frame · corrodedCORROSION ON FRAME STA 907 BETWEEN STR 21R - STR 22R AT SKIN ATTACH POINT. INSTALLED FRAME REPAIR AT SKIN ATTACHMENT REF SRM 53-00-07, ATTACH HEAT TREAT FORM 43.0150 AND 44.0008.SDR EE4Y1004044Frame · damagedDURING THE INSPECTION CARGO CABIN AT STA 370 LOG 6R AND 7R COOPESA FOUND FRAME REPAIRED CRACK EXTENDS BEYOND STOP DRILL.SDR EE4Y1004043Frame · damagedDURING THE INSPECTION CARGO CABIN AT STA 313 LOG 8R AND 10R COOPESA FOUND FRAME I/B FLANGE WITH DOUBLE HOLES.SDR EE4Y1004042Frame · damagedDURING THE INSPECTION CARGO CABIN AT STA 484 LOG 4R AND 5R COOPESA FOUND FRAME I/B FLANGE WITH A HOLE RADIUS AREA.SDR EE4Y1004041Frame · damagedDURING THE INSPECTION CARGO CABIN AT STA 484 LOG 4L COOPESA FOUND FRAME I/B FLANGE WITH A HOLE RADIUS AREA.SDR ASAA1047686Frame · corrodedAFT PIT FRAME IS CORRODED ON UNDERSIDE OF UPPER FLANGE AT HI-LOK Z-ANGLE ATTACH POINT. CUT OUT DAMAGED AREA OF FRAME, FABRICATED REPAIR ANGLE AND 2 EACH FILLERS AND INSTALLED.SDR F3LA2010041500389Frame · corrodedREFERENCE C CHECK NON ROUTINE N0307. AFT CARGO COMPARTMENT FRAME 59 TWELVE INCHES RIGHT OF CENTERLINE PROFILE TOP SURFACE CORRODED. REMOVED AND REPLACED PROFILE IAW AIRBUS A319 SRM 51-40-00.SDR IPXA10559543Frame · dentedINSPECTION TYPE:C4, BS 1360 FRAME IS DENTED AT STR 26 RT. REPAIRED IAW SRM 53-00-07-2R 5, FIG 201 AND SRM 53-60-07-0I 1, FIG. 1.SDR IPXA10559507Frame · dentedINSPECTION TYPE:C4, BS 1360 FRAME IS DENTED AT STR 26 RT. REPAIRED IAW SRM 53-00-07-2R 5, FIG. 201 AND SRM 53-60-07-0I 1, FIG. 1.SDR FDEA201004011047Frame · crackedFWD PIT - UPPER SURFACE OF FRAME IS DENTED AT BS 600, ABOVE STRINGER 24 L. REMOVED CRACKED SECTION OF BS 600 FRAME 1" X 2 1/8" ABOVE STR 24L IAW FED EX B727 SRM REV 102 51-10-1 FABRICATED REPAIR DOUBLER FROM 7075 -0 .050 X6" X 12" IAW B727 SRM 53-10-2SDR ASOA201000491Frame · crackedSTA 718 BETWEEN STR 10 AND 11 RT, FRAME FLANGE IS CRACKED. REPAIR TO BE C/W ON CARD S/B 601R-53-055.SDR ASOA201000480Attach Fitting · crackedBS 280 FRAME CLIP AT RBL9 IS CRACKED. REMOVED CRACKED FRAME CLIP & REPLACED WITH NEW AT STA 280, RBL 9, IAW SRM 53-21-43.SDR USAA2010042990865Frame · crackedMCN - C20 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 360, S13R. REPAIRED FUSELAGE FRAME AT BS 360, S13R IAW TYPICAL REPAIR 53-10-21B.SDR UALA2010042701396Frame · puncturedFRAME WEB PUNCTURE AFT PIT STA 1820 APPROX LBL 48. MAJOR REPAIR ACCOMPLISHED: REPAIRED IAW KOREAN AIR FRR 744-0625. PER EVA-73628, THIS REPAIR IS TIME LIMITED UNTIL THE AIRPLANE REACHES 22,000 TOTAL AIRPLANE FLIGHT CYCLES.
Back to JASC 5311