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 SWAA096290Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 291, BETWEEN STR 9R TO STR 15R. REPAIRED FRAME PER AEM.SDR SWAA096289Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 23L TO STR 24L. REPAIRED FRAME PER AEM.SDR SWAA096288Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294.5, STR 10L. REPAIRED FRAME PER AEM.SDR SWAA096287Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AEM.SDR SWAA096259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR AFT LOWER CORNER EDGE FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA096255Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR DLM88091573Frame · crackedMAIN CABIN MAIN FRAME STA 886 CRACKED ON LT SIDE. REMOVED AND REPLACED MAIN FRAME AT STA 886 PER EA09-460094-12AD REV A.SDR ZZDA2009288Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR ZZDA2009287Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2980.SDR ASOA200901071Frame · crackedFOUND FS 559 HAS 3 INDICATIONS NOTED : LBL 18 CAP ANGLE APPROX .2" IN LENGTH, 70 PERCENT FSH. RBL 18 CAP ANGLE APPROX .2" IN LENGTH, 80 PERCENT FSH. RT BULKHEAD WEB APPROX .4" IN LENGTH, 75 PERCENT FSH AT WL 59.10 INBD OF RBL 18. ALL FAILED NDT INSPECTION. SDR SWAA096247Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT BS 685 FRAME LOWER FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA096229Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CORRODED AT BS 482A, BL 0. REPAIRED FRAME PER SRM.SDR SWAA096228Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, BETWEEN STR 16R TO STR 17R. REPAIRED FRAME PER AAR EA.SDR ZZDA2009274Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2973.SDR ZZDA2009273Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR SWAA096192Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 663, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA096191Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER SRM.SDR IPXA09557522Frame · dentedINSPECTION TYPE:C2 BS 1300 FRAME DENTED AT STR 26R. REPAIRED DENTED AREA IAW SRM 53-00-07-1A AND ER 09-4632.SDR DLM88091566Frame · corrodedFRAME CORRODED AT STA 1308 ABOVE LONGERON 30 FRAME. REPAIRED PER SRM 53-05D FIG 5 AT LONGERON 30.SDR SWAA096131Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA096119Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA096118Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER AAR EA.SDR FDEA200909283411Frame · corrodedAFT CARGO COMPARTMENT, FRAME AT STA 1620, RBL 9, AFT SIDE CORRODED. CORRODED FRAME AT STA 1620 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR SWIA200923481Frame · crackedC-CHECK, FS 559 PRESSURE BULKHEAD FRAME CAP ANGLE RADIUS CRACKED. REPAIRED PER REO.SDR ASAA0976709Frame · corrodedFRETTING ON WHEEL WELL FAIRING SUPPORT TEE CHORD BS 663 674 RBL 27. FRETTING TO BE OUT OF LIMITS, REPLACED WHEEL WELL FRAME.SDR SIMA200927203Fitting · crackedDURING MAINTENANCE INSPECTION FOUND FRAME 81 CLIP AT THE 9 O’CLOCK POSITION CRACKED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED FRAME 81 CLIP IAW EMB SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR C2XA09SH301Support · corrodedSHV - DURING C-CHECK FRAME 65 SUPPORT BETWEEN STR 18L-17L HAS CORROSION AT BEND. MAINTENANCE COMPLETED REPAIR OF FRAME 65 BETWEEN STR 17L-18L IAW IC2009-145/07501A. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR MALA090126Frame · damagedDURING N4K, NOTED CHAFED CABIN FRAME INNER FLANGE REINFORCEMENT AT STA 535, SL1605. REPAIRED DAMAGED REINFORCEMENT ANGLE IAW EO S53731SDR FDEA200909253385Frame · dentedFWD CARGO COMPT, BILGE AREA, STA 720, BL-0, WL 154, TOP OF FRAME HAS SMALL DENT AND SMALL CHAFE MARK ON TOP SURFACE. DOT NR102-013. TRIMMED OUT DAMAGED AREA IAW SRM 53-00-07, FIG 201; PERFORMED HFEC IAW NTM 51-00- 19, PT 6 ON INITIAL FASTENER HOLES COMMON TOSDR ASOA200901050Frame · crackedFRAME CAP ANGLE CRACKED IN RADIUS AT FS 559.00, LBL18. COMPLIED WITH N/R-00274. REPAIRED ON E/C REO 601R-53-41-260 W/O 132389.SDR USAA2009092592629Frame · corrodedCRACK ON FUSELAGE FRAME AT BS 440 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS440 BETWEEN S8L TO S9L IAW REPAIR 53-10-20E. (K)SDR KCSA091101Frame · crackedFUSELAGE FRAME IS CRACKED (1 INCH) IN APU COMPARTMENT STA 2674.85 RT SIDE 1 O'CLOCK POSITION.SDR USAA2009102992939Frame · crackedSAL - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 601, S17L + 5 INCHES. REPAIRED FUSELAGE FRAME AT BS 601, S17L + 5 INCHES IAW EA 132536.SDR USAA2009092592630Frame · crackedCRACK ON FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R IAW REPAIR NR 53-10-20E. (K)SDR USAA2009102292844Frame · crackedSAL - Q2 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 616, S17 + 6.5 INCHES LT. REPAIRED FUSELAGE FRAME AT BS 616, S17 + 6.5 INCHES LT IAW TYPICAL REPAIR 53-62-01.SDR ASAA0976669Frame · crackedBS 867 FRAME CRACKED AT BIN RAIL ATTACH BRACKET. CUTOUT FRAME AND REPAIRED WITH DOUBLER.SDR ASAA0976670Frame · crackedBS 747 FRAME CRACKED AT BIN RAIL ATTACH BRACKET. CUTOUT FRAME AND REPAIRED WITH DOUBLER.SDR ASAA0976672Frame · crackedBS 480 FRAME CRACKED AT BIN RAIL BRACKET. CUTOUT FRAME AND REPAIRED WITH DOUBLER.SDR ASAA0976671Frame · crackedBS 440 FRAME CRACKED AT BIN RAIL BRACKET. REPAIRED WITH DOUBLER.SDR DLM88091545Angle · crackedAFT ACCESSORY STA 1463 CANTED FRAME L-3-L Z ANGLE HAS CRACK. REMOVED DAMAGED ANGLE, REPAIRED ANGLE IAW MD80 SRM 51-70-5 FIG 1. RE-INSTALLED ANGLE.SDR AALA20090924TUL08Frame · crackedCRACK ON CANT FRAME 1510 AT GUIDE PIN, THIRD FROM TOP RIGHT. INSTALLED DOUBLER PER SRM 53-01, PARA 4.SDR USAA2009092492618Frame · crackedCLT - C5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009110693052Frame · corrodedSAL - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON FRAME AT BS 794.3, S24R - S26R. REPLACED FRAME AT BS 794.3, S24R - S26R IAW B737 SRM 51-10-02 AND EA 132716.SDR ASAA0976660Frame · gougedFWD CARGO BAY FRAME GOUGED. REPAIRED FRAME PER EA.SDR ASOA200901035Frame · crackedRT FS718.00 FRAME CRACKED BETWEEN STRINGERS 10 AND 11. REPAIRED BOTH LT & RT 718.00 FRAME PER S/B 601R-53-055.SDR SWAA096041Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096040Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096039Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096038Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA096037Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.
Back to JASC 5311