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 N921R40407Frame Splice · corrodedMAIN CARGO COMPARTMENT STA 520, L-17R FRAME SPLICE WITH CORROSION. REMOVED FRAME SPLICE IAW DPS 3-67-29. FABRICATED NEW FRAME SPLICE IAW DPS 3-69-4, PRIMED SPLICE IAW DC8 SRM 51-1-8. INSTALLED FRAME SPLICE IAW DC8 SRM 51-1-27 CPCP 5730-0551.SDR SWIA200717747Frame · crackedRBL9 LOWER FRAME CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AS PER CRJ200 REO 601R-53-11-171 REV C.SDR SWIA200717746Frame · crackedLBL9 STA 280 LOWER FRAME CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AND CLIPS AS PER CRJ200 REO 601R-53-11-171.SDR SWIA200717745Frame · crackedLBL9 STA 280 HAS CRACK UPPER FRAME, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AT STN 280, LBL9.0 UPPER IAW CRJ200 REO 601R-53-11-138 REVNC.SDR HNAA0700226Frame · corrodedCORROSION FOUND ON FRAME UNDERFLOOR AT X201.1560 BETWEEN STR 32S AND 30S. REPAIRED FRAME IAW ENGINEERING ORDER.SDR TRAX200700031Frame · crackedETNRC 2000-16 LOWER FRAME AND SUPPORT CLIPS AT FS 171.00 BETWEEN LBL 12.00 AND RBL 12.00 ARE BENT, CRACKED. LOWER FRAME AND SUPPORT CLIPS AT FS 171.00 BTW LBL12.00 AND RBL 12.00 REMOVED AND REPLACED IAW SRM 51-42-06.SDR AWXA200700041Frame · crackedMCN - LEFT WHEEL WELL CUT-OUT, FORWARD CHORD CRACKED, BS 663, LBL 63, WL 178. REPLACED LEFT WHEEL WELL CUT-OUT, FORWARD CHORD CRACKED, BS 663, LBL 63, WL 178 IAW B737-300 SRM 51-40-05 AND 51-40-02.SDR AWXA200700040Frame · crackedMCN - RIGHT WHEEL WELL CUT-OUT, FORWARD FRAME CRACKED, BS 663, RBL 63, WL 178. REPLACED RIGHT WHEEL WELL CUT-OUT, FORWARD FRAME CRACKED, BS 663, RBL 63, WL 178 IAW B737-300 SRM 51-40-05 AND 51-40-02.SDR 07FDEA00032Frame · dentedMAIN DECK CARGO COMPARTMENT: MAIN FRAME STA 1661 LONGERON 12L AREA EXISTING REPAIR DOUBLER FOUND DAMAGED. REPAIR CARRIED OUT AS PER SRM 53-30-00 VOLUME I FIGURE 1. INITIAL INSPECTION REQUIRED AT 14,500 CYCLES AND REPETITIVE INSPECTION REQUIRED EVERY 9,500SDR 07FDEA00031Frame · dentedMAIN DECK CARGO COMPARTMENT MAIN FRAME STA 1701 LONGERON 12L FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-30-00 VOLUME I FIGURE 1. INITIAL INSPECTION REQUIRED AT 14,500 CYCLES AND REPETITIVE INSPECTION REQUIRED EVERY 9,500 CYCLES THEREAFTER AS PER SRM 53SDR 07FDEA00030Frame · dentedMAIN DECK CARGO COMPARTMENT: MAIN FRAME STA 1781 LONGERON 12R FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-30-00 VOLUME I FIGURE 1. INITIAL INSPECTION REQUIRED AT 14,500 CYCLES AND REPETITIVE INSPECTION REQUIRED EVERY 9,500 CYCLES THEREAFTER AS PER SRM 53-SDR UPS07M49394Frame · crackedINSPECTION TYPE:C CABIN - CRACK ALONG THE GRAINS OF FRAME FLANGE AT STA 1256 L1 LEFT TO L1 RIGHT. GRAINS OF FRAME FLANGE CRACK AREA TRIMMED OUT AT STA 1256 L1 LEFT TO L1 RIGHT PER SRM 53-30-00 VI R38. HFEC INSP CUTOUT PER DAC NDTSPM R12 06-10.0 1.001 ON TRIMSDR UPS07549051Frame · dentedINSPECTION TYPE:C AFT PIT LEFT SIDE STA 1420, STR 25-26, FRAME DENTED. DIMENSION OF DENT .020 THE CENTER OF DENT FROM FLOOR TRANS PANEL 3.7 INCHES FROM PRODUCTION SPLICE TO DENT 9.2 INCHES LENGTH OF DENT WIDTH OF DENT .96; ACCOMPLISHED PER FINAL EA 757-5362-SDR UPS07549076Frame · dentedINSPECTION TYPE:C AFT PIT RIGHT SIDE STA 1260 BETWEEN STR 25-26 FRAME DENTED. COMPLIED WITH EA 757-5362-27-A1567 AND UPS EO B757-5310-26027-A.SDR UPS07549050Frame · dentedINSPECTION TYPE:C - FOUND AFT PIT STA 1240, STR 2526 FRAME DENTED, RIGHT SIDE DIMENSION OF DENT .020 FROM CENTER OF DENT TO TRANS PANEL 5"4 FROM CENTER OF DENT TO PRODUCTIONS SPLICE 9.8 LENGTH OF DENT .900 W= 1.0. TRIMMED OUT DENTED AREA PER EA NR 757-53SDR SWIA200717740Frame · crackedRBL9 LOWER FRAME CRACKED FS 280, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS TO RBL9 LWR FS 280 PER CRJ200 REO 6011R-53-11-171 STEP 6, 7, 8, 12, 13.SDR SWIA200717739Frame · crackedSTA 280 LBL9 UPPER FRAME HAS A CRACK, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FILLER ANGLE REPAIR SPLICE ANGLES AND TWO -57 CLIPS FS 280 UPPER FLOORBEAM LBL9 AS PER REO 601R-53-11-138 SHEET 1-3 NOTES 1-10.SDR SWIA200717737Frame · crackedSTA 621 LOWER FRAME AT FLOOR LEVEL RT SIDE HAS CRACK CORNER, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS 601R-53-61-117 ANGLE, REPAIR ANGLE AND STRAP IAW CR200 SRM 51-23-00 AND REO 601R-53-61-117.SDR 0700246732Frame · damagedDURING "L" CHECK WHILE PERFORMING REPLACEMENT OF DAMAGED TAILCONE FOUND MISALIGNED FASTENER HOLES IN FRAME AT BS 2725. REPAIRED PER EA 67-208742.SDR SWAA070053Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070052Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070051Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070050Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR UPS07449130Frame · crackedINSPECTION TYPE:C LEFT BS 920 FRAME TENSION TIE ATTACHMENT AREA FOUND 1EA FASTENER HOLE CRACKED AT FRAME APPROX 0.040" RUNNING UPWARD AND DOWNWARD. M/D LEFT BS 920 FRAME 1EA HOLE OVERSIZED BY INCREMENTS TO 0.247" DIA. CRACK FREE INSPECTED BY HFEC PER NTM PARSDR UPS07449129Frame · crackedINSPECTION TYPE:C M/D - RIGHT BS 840 TENSION TIE TO FRAME CONNECTION FOUND 2EA HOLES CRACK AT FRAME (0.040" & 0.060"). M/D RIGHT BS 840 TENSION TIE TO FRAME CONNECTION I/B & O/B 2EA HOLES OVERSIZED BY INCREMENTS TO 0.309" DIA. CRACK FREE INSPECTED BY HFEC PESDR 2007UALA00029Frame · crackedINTERIOR CABIN OVERWING EXIT FRAME BS 616 LT FWD INBOARD SIDE FRAME STUB INNER CHORD BOTTOM FASTENER HOLE JUST ABOVE PRESSURE DECK IS CRACKED. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED NESTED ANGLE AND FILLER REPAIR PER MM 53-11-89.SDR SWAA070040Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA070037Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070034Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR USAA07005Frame · corrodedAT FRAME 500D LBL 10 HAS CORROSION. REMOVED DAMAGED FRAME, ATTACH ANGLES IAW SRM 51-70-11 LEVEL 1 C53-208-01, DEFECT SIZE: 1 X 1 INCH.SDR USAA07006Frame · crackedWEB OF BS 639 FRAME S-17R CRACKED. FABRICATED AND INSTALLED DOUBLER IAW EA 98343, DEFECT SIZE: 2 INCHES.SDR UPS07448985Frame · corrodedINSPECTION TYPE:C FX STA 1171 FAIRING SUPPORT FRAME FOUND CORRODED AT LBL 49. FX BS 1171 LBL 49 FAIRING SUPPORT REPAIRED AS PER SRM 53-50-04 FIG 2.SDR UPS07448969Frame · corrodedINSPECTION TYPE:C FX STA 1171 FAIRING SUPPORT FRAME FOUND CORRODED AT RBL 12 AS MARKED. FX BS 1171 FAIRING SUPPORT FRAME UPPER CHORD REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR SWAA070020Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME SECTION CRACKED AT BS 480, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070019Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME SECTION CRACKED AT BS 867, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070018Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME SECTION CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070017Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME SECTION CRACKED AT BS 440, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070016Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME SECTION CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070008Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070007Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA065129Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER ER AND SB.SDR 06FDEA04392Frame · crackedFRAME AT ATTACH POINT STA 277 AT STR 21L IS CRACKED AT UPPER ATTACH HOLE TO SKIN. REMOVED DAMAGE AND REPAIRED FRAME REF SRM 53-10-4 FIG 11 PAGE 43. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR K11A2008122472304Frame · corrodedCORROSION ON OVERWING FRAME.SDR BAQA20050011Frame · crackedA CRACKED FRAME 5A WAS DISCOVERED DURING INSPECTION.SDR SWAA065105Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, LBL 65. REPAIRED FRAME SECTION PER ER.SDR SWAA065104Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 908, STR 7L. REPAIRED FRAME SECTION PER ER.SDR SWAA065097Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA065096Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA065095Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA065094Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER SWA EA.
Back to JASC 5311