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 SWIA200514559Frame · crackedFUSELAGE FRAME FS 364 STR 8R FLANGE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FRAME IAW CRJ REO 601R-53-21-561.SDR DL73S050097Frame · crackedA FASTENER HOLE COMMON TO THE OUTER CHORD OF THE AFT FRAME OF THE L2 DOOR CUTOUT (FS 992, BETWEEN STRINGERS 7L & 8L) WAS FOUND CRACKED. THE HOLE WAS OVERSIZED AND AN INSURANCE CUT MADE TO REMOVE THE CRACK. THE OVERSIZED HOLE WAS REPAIRED WITH AN ALUMINUM BUSSDR SWAA050365Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 360 TO BS 380, LBL 64, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA050359Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 767, FROM LBL 17 TO RBL 17, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 72300146Frame · corrodedA 1.5 X 24 INCH AREA OF CORROSION ON FRAME FLANGE AND WEB.SDR USAA050230Frame · crackedPIT - FOUND FRAME CRACKED .75 INCH, FS 616 S17R. INSTALLED DOUBLER PER TYPICAL REPAIR 53-62-01. (M)SDR SWAA050346Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 887, STRINGER 8R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050335Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 787, LBL 22, CORRODED. REPAIRED FRAME SECTION PER SRM.SDR 2005FA0000361Frame · fracturedDURING 6000 CYCLE AIRFRAME INSPECTION, FOUND LT AND RT CABIN FORMERS FRACTURED INTO 2 PIECES AT STA 177.00 AT WL 90-91 (APPROXIMATE) CAUSE OF FAILURE UNKNOWN (SUSPECT HARD LANDING). OBTAINED DER FOR REPAIR- CONSULTED MFG TECH SUPPORT ON FINDINGS. REMOVED ANDSDR 05FDEA00255Frame · corrodedFRAME AND INTERCOSTAL CORRODED AT STATION 1461 RIGHT WHEEL WELL INTERIOR AREA. COMPLIED WITH FEDEX EA 8-5310-83975, FUSELAGE- CORROSION DAMAGE TO LT STATION 1505, LONGERON 35 FRAME- REPAIR, AND FEDEX EA 8-5310-83974, AFT WHEEL WELL- PRESSURE BULKHEAD TEE FRAMSDR ASOA05181Frame · corrodedDURING A C-CHECK IN YUL, THE FRAME 37 RT, STRINGER 14 ON THE AFT SIDE WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FRAME 37 RT, STRINGER 14 IAW ASA EO 72-53-0162. (M)SDR SWAA050319Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR FWD FRAME AT THIRD STOP CRACKED. REPAIRED FRAME PER EA.SDR 05FDEA00241Frame · dentedMAIN DECK - DENT MARKS AT RIGHT HAND FRAME AT STA Y= 1681 LONGERON 12. LONGERON 12 REPAIRED PER SRM 53-30-00 VOLUME I, FIGURE 1.SDR 05FDEA00240Frame · dentedDENT MARK FOUND AT RIGHT HAND FRAME STA Y= 1641 LONGERON 12. LONGERON 12 REPAIRED PER SRM 53-30-00 VOLUME I, FIGURE 1.SDR 05FDEA00239Frame · dentedDENT MARKS FOUND AT LEFT HAND FRAME STA Y= 1681 LONGERON 14. LONGERON 14 REPAIRED PER SRM 53-30-00 VOLUME I, FIGURE 1.SDR SWAA050310Frame · crackedDURING SPV, FOUND FRAME CRACKED AT BS 380, STRINGER 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 05FDEA00238Frame · chafedMAIN DECK - RIGHT HAND SIDE FRAME G-NET ATTACHED YOKE ASSEMBLY AT STA Y=535 TOP AND BOTTOM PART FOUND WITH CHAFED MARK. MAIN DECK - RIGHT HAND SIDE FRAME G-NET ATTACHED YOKE ASSEMBLY AT STA Y=535, CHAFED MARK REMOVED PER SRM 53-00-01 VOLUME I, FIGURE 3. MATESDR 05FDEA00237Frame · chafedMAIN DECK - LEFT HAND SIDE FRAME G-NET ATTACHED YOKE ASSEMBLY AT STA Y=535 TOP AND BOTTOM REPAIR ANGLE FOUND WITH CHAFED MARK. MAIN DECK - LEFT HAND SIDE FRAME G-NET ATTACHED YOKE ASSEMBLY, CHAFED EXISTING REPAIR ANGLE AT STA Y=535, REMOVED PER SRM 51-31-01 VSDR SWAA050309Frame · crackedDURING SPV, FOUND FRAME AT BS 360, STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050307Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAMES AT RT AND LT BS 188, LBL 33 AND RBL 33, CRACKED. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR ASAA0540079Failsafe · corrodedPAE - CORROSION ON FAIL SAFE CHORD. B-STA 767. REMOVED AND REPLACED IAW SRM. (K)SDR DLM88050082Frame · crackedFUSELAGE OVERWING FRAME AT STATION 886 FOUND CRACKED AT LONGERON 18L. FRAME REPLACED I/A/W ERA 096171-14.SDR CALA0500039Frame · corrodedINSPECTION FOUND AFT CARGO COMPARTMENT FORWARD DOOR JAMB FRAME CORRODED AT LATCH FITTING, STA 787, S19R TO S27R. A NEW FRAME WAS INSTALLED IAW SRM 51-40 AND ECRA 5310-04456.SDR SWAA050295Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 500C, RBL 2, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050294Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 908, STRINGER 8L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR CALA0500037Frame · crackedINSPECTION FOUND A 1 INCH CRACK THROUGH RIVET IN LT FRAME WHERE FRAME JOINS CABIN FLOORBEAM AT STA 616, LBL 64. THE CRACKED AREA WAS CUT OUT AND AN ANGLE DOUBLER REPAIR WAS INSTALLED IAW ECRA 5311-01158.SDR UPS05843866Frame · corrodedFRAME AND SPLICE CORRODED BEYOND LIMITS AT STA 1420 L34R-L36. REMOVED SPLICE FTG AND CUT OUT CORRODED FRAME SECTION BETWEEN L36 AND L34R. FAB REPLACMENT SPLICE FROM SHT 7075-0-.063 HEAT TREAT TO T6. FAB FRAME SECTION FROM EXTR 2641520. INSTALLED PARTS REF SDR SWAA050269Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 500B, BETWEEN STRINGERS 27L AND 28R, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 72300072Frame · corrodedAPPROX 2 INCH BY 3 INCH AREA OF CORROSION ON FRAME.SDR SWAA050261Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE AT BS 947.5, STRINGER 27L, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050251Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 767, BETWEEN RBL 8 AND RBL 12, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050250Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 787, STRINGER 8L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050247Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 480, STRINGER 8R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR CALA0500032Frame · crackedINSPECTION FOUND A 1.75 INCH CRACK IN FRAME AT NR 5 STOP, UNDER STOP, IN RADIUS (STA 794.3, AFT CARGO DOOR OPENING FORWARD FRAME, L18R TO L27R). REPAIRED IAW BOEING DRAWING 65C35243.SDR HNAA0500005Frame · corrodedDURING C CHECK, FOUND WIDE SPREED CORROSION THAT REQUIRED STR 31 REMOVAL AND REPLACEMENT. FRAME X253 REQUIRES A FRAME SPLICE WHICH IS A MAJOR REPAIR TO ALLOW INSTALLATION OF REPLACEMENT STRINGER. FRAME SPLICE WAS DONE IAW PIEDMONT EO 8-53-05-0024.SDR AWXA200500296Strap · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .3125 INCH CRACK WAS FOUND IN LOWER FORWARD INBOARD EDGE OF FRAME STRAP AT BS 349, STR 16 LT. MAINTENANCE REMOVED DAMAGED FRAME STRAP AT BS 349, STR 16 LT; INSTALLED A NEW REPLACEMENT FRAME STRAP IAW ER 03-5300-05053-SSDR 05FDEA00192Frame · dentedBS 680, LBL 35, WL 162, DENT ON FRAME. REPAIRED PER SRM 51-40-3.SDR IXXA0500170SFrame · crackedDURING A ROUTINE C-CHECK FOUND FRAME JUST AFT OF AIRSTART COMPARTMENT CRACKED AT 2 LOCATIONS. REMOVED FASTENERS, AND DAMAGED AREA. FABRICATED REPAIR PARTS. LOCATED, DRILLED, TREATED, PRIMED AND INSTALLED REPAIR PARTS, IAW DC8 SRM 53-2-0, 51-1-20D, 51-3-0, 5SDR 05FDEA00187Frame · dentedBS 1030 STR 25L FRAME DENTED. REPAIRED PER SRM 51-40-3.SDR SWAA050240Frame · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH FRAMES CRACKED BETWEEN BS 827 AND BS 907, STRINGER 8L. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR SWAA050238Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 400, STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050237Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME SECTION AT BS 400, STRINGER 8L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050235Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 360, STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR RRXA05141Frame · damagedDURING A MAINTENANCE VISIT, FOUND MISDRILLED HOLES IN THE UPPER CARGO COMPT FS 1220 AND L21R TO L21L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLERS FROM 70SDR SWAA050218Frame · crackedDURING SPV FOUND BELT FRAME AT BS 908, STRINGER 4R, CRACKED. REPAIRED BELT FRAME PER SRM.SDR 05FDEA00177Frame · dentedDENT IN FRAME BS 1070 JUST BELOW STR 25R. REPAIRED PER SRM 53-10-2SDR 05FDEA00176Frame · dentedFRAME HAS TWO DENTS WITHIN 10 INCHES OF EACH OTHER BS 1110 BELOW STR 25R AND AT STR 26R. REPAIRED PER SRM 53-40-2SDR 05FDEA00175Frame · dentedBS 1030, STR 25R FRAME IS DENTED. REPAIRED PER SRM 51-40-3.SDR 05FDEA00174Frame · dentedBS 720, RBL 39, STR 24, WL 163 FRAME DENTED. REPAIRED FRAME AT BS 720, STR 24, RBL 39, WL 163 PER SRM 51-40-3.SDR 05FDEA00173Frame · dentedBS 720A, LBL 34, WL 167 DENT ON FRAME. REPAIRED FRAME BS 702A, LBL 36 PER SRM 53-10-1.
Back to JASC 5311