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 SWAA2013080818974Frame · crackedFRAME CRACKED AT STATION 727D, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080818973Frame · crackedFRAME CRACKED AT STATION 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080818972Frame · crackedFRAME CRACKED AT STATION 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080818971Frame · crackedFRAME CRACKED AT STATION 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080818970Frame · crackedFRAME CRACKED AT STATION 520, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080818969Frame · crackedFRAME CRACKED AT STATION 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080818968Frame · crackedFRAME CRACKED AT STATION 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080818965Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080818964Frame · crackedFRAME CRACKED AT STATION 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080818963Frame · crackedFRAME CRACKED AT STATION 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080818962Frame · crackedFRAME CRACKED AT STATION 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR CALA2013073090089Doubler · crackedBS 1180, LEFT FRAME DOUBLER CRACK AT TENSION TIE. REMOVED DOUBLER. HFEC INSTALLED NEW DOUBLER IAW SRM 51-40-02. MAJOR REPAIRSDR DALA13036600972Frame · crackedDURING SCHEDULED INSPECTION, THE TAILCONE GUIDE PIN WAS FOUND TO BE LOOSE AND THE FRAME HOLE WAS CRACKED AT THE 7:00 POSITION. CRACKED SECTION OF FRAME AT BS 1510 WAS REPLACED IAW SRM 51-30.SDR DALA13036590972Frame · crackedDURING SCHEDULED INSPECTION, THE TAILCONE GUIDE PIN WAS FOUND TO BE LOOSE AND THE FRAME HOLE WAS CRACKED AT THE 4:30 POSITION. CRACKED FRAME REPLACED DURING THIS MAJOR MX CHECK.SDR DALA13036580972Frame · crackedDURING SCHEDULED INSPECTION, THE TAILCONE GUIDE PIN WAS FOUND TO BE LOOSE AND THE FRAME HOLE WAS CRACKED AT THE 8:30 POSITION. CRACKED FRAME REPLACED DURING MAJOR MX CHECK.SDR DALA13036570972Frame · crackedDURING SCHEDULED INSPECTION, THE TAILCONE GUIDE PIN WAS FOUND TO BE LOOSE AND THE FRAME HOLE WAS CRACKED AT THE 9:00 POSITION. FRAME WAS REPLACED.SDR USAA2013090500011Frame · crackedQ3 CHECK, CRACK ON FORWARD SIDE OF FUSELAGE FRAME AT BS 500D, S20L. REPAIRED FRAME IAW SRM53-00-07-2R-13.SDR QXEA2013082101267Frame · corrodedFRAME BS 196 HAS SURFACE CORROSION ON AFT SIDE AT STRINGER CUTOUT OTBD OF S31L. REMOVED CORROSION IAW SRM 53-00-00, PROC.6 STEP A AND B. PERFORMED NDI, NO DEFECTS NOTED IN BLENDED AREA. FOUND WITHIN MANUFACTURER SPECS.SDR ASAA2013072695746Frame · crackedFRAME BS 500G RT SIDE HAS A CRACK APPROXIMATELY .1250 INCH LONG EXTENDING INBD FROM THE EDGE OF THE 1.04 WIRE PENETRATION HOLE. REPAIRED FRAME AIW SRM 53-00-07-2R-13.SDR ASAA2013072695745Frame · crackedFRAME BS 500G HAS A CRACK APPROXIMATELY .1250 INCHES LONG EXTENDING INBD FROM THE EDGE OF THE 1.04, WORN PENETRATION HOLE. REPAIRED FRAME IAW SRM 53-00-07-2R-13.SDR QXEA2013072601179Frame · corrodedFRAME BS 258.5 HAS SURFACE CORROSION ON CLIP BETWEEN STR 29 & 20 LT. REMOVED SURFACE CORROSION ON CLIP BETWEEN STR 29 AND 30 (LH) FS X258.500 BY HAND IAW SRM 51-21-00, PROC 4 ITEM A. ET INSP REF NDTM PT 1 51-00-06, NO DEFECT NOTED. PERFORMED UT INSP IAW NDTSDR SWAA2013082619543Frame · crackedFRAME CHORD CRACKED AT BS 727 STRINGER 18A RT SIDE. R&R CHORD IAW SRM & EA.SDR ASAA2013072595857Frame · crackedFRAME CRACKED AT BS 400 S8-9R. REPAIRED FRAME IAW T/C AD20062609 400 53 1755.SDR ASAA2013072595801Frame · crackedBS 480, STR 8-9R FRAME IS CRACKED AT AC DUCT ATTACH POINT. ACFT GROUNDED. REPAIRED FRAME CRACKED IAW T/C AD20062609 400-53-1-755, FIG 3.SDR REXA2013072501436Frame · corrodedFRAME BS 349 CORRODED BETWEEN RT INBD AND OTBD DIAPHRAM. REPAIRED FRAME AND FOUND WITHIN LIMITS IAW EO R53277.SDR REXA2013072501435Frame · corrodedFRAME IS CORRODED AT BS 295 BETWEEN S26R & 26L. REPAIRED FRAME. FOUND WITHIN LIMITS IAW EO R53277.SDR DALA1317096712Frame · dentedAFT CARGO BILGE FRAME, STA 1420 S-26L DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR QXEA2013072501181Frame · corrodedFRAME BS 321 HAS SURFACE CORROSION ON CLIP BETWEEN S31-32R. REMOVED CORROSION. NO MATERIAL LOSS, IAW SRM 51-21-00 STEP 4 A(2). RESTORED FINISH REF SRM 51-21-10 STEP 6D AND SRM 51-25-10, STEP 5F.SDR DALA13036273754Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 440, ABOVE STR 8L, FRAME IS CRACKED AT INBD FASTENER OF PSU RAIL SUPPORT BRACKET ATTACH POINT. MX ACCOMPLISHED REPAIR TO FRAME WEB AT STATION 440, STR 8L IAW PRI ERA 516046-14AD, REV ORIGINAL.SDR 39LA2013072400064Frame · gougedFOUND DEEP GOUGE RT SIDE IN FRAME 1F. REPAIRED IAW EO 2021032-309 AND EO2012032-424, AND AIRLIFT DWG NR 2012032-2030.SDR 39LA2013072400034Frame · crackedFOUND CRACKED FRAME AT BS 9650 LT SIDE RAMP AREA FUSELAGE 5TH STRINGER FROM BOTTOM. REPAIRED IAW EO 2021032-309 AND EO2012032-424, AND DWG NR 2012032-2029.SDR DALA13037159206Frame · corrodedAFT CARGO BILGE FRAME CORRODED BS 1328, LONGERON 28 - 28R TASK 53-302-07. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R FRAME AT STA 1328, LONGERON 28L -28R IAW SRM 51-30-02, PG 1-6.SDR ABXA20130723498Frame · corrodedFRAME CORRODED AT APU EXHAUST DUCT SUPPORT FUSELAGE, BS 1943.5. CLEANED UP CORROSION, SPLICED IN NEW SECTION OF FRAME AT STA 1943.5 IAW REA B653-60618, ACFT GROUNDED.SDR LR7A2013072300693Rib · crackedDURING SCHEDULED C-11 CHECK, WHILE PERFORMING NR 2009, FOUND RIB CRACKED; FS 918, WL 190-210, RBL 67. REPAIRED BY REPLACEMENT ACCOMPLISHED IAW SMP583, 51-60 AND 51-70.SDR LR7A2013072300676Rib · crackedDURING SCHEDULED C-11 CHECK, WHILE PERFORMING NR 2009, FOUND RIB CRACKED BS 830, WL 165-180, RBL 67. REPAIRED BY REPLACEMENT ACCOMPLISHED IAW SMP583, 51-60 AND 51-70.SDR USAA2013080200008Frame · corrodedC3 CHECK - CORROSION FOUND ON FRAME LEG AT BS 927 BETWEEN S24-25R. REPAIRED FRAME LEG IAW SRM 53-00-07-2R.SDR DALA13037179206Frame · corrodedAFT CARGO FRAME, BS 1379, BETWEEN LONGERONS 28L - 28R, HAS AREAS OF CORROSION ON FWD SIDE OF FRAME. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED PARTS IAW SRM 53-10-02.SDR DALA1316966712Frame · dentedAFT CARGO BILGE FRAME, BS 1420, S26L DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA13035940958Frame · crackedFRAME BS 1418 AFT FLANGE CRACKED AT LONGERON 2R. REMOVED FRAME, DRILLED NEW FRAME & INSTALLED ALL FASTENERS IAW DWG SR09530003.SDR REXA2013072101098Frame · corrodedFRAME AT BS 394 BETWEEN S23-24R CORRODED 100 PERCENT THROUGH. REPAIRED IAW REO 601R-53-21-2451.SDR IXXA20130718042Frame · corrodedTOP FLANGE OF FRAME IS CORRODED AT BS 1460 BETWEEN S26-27R. REPAIRED FRAME IAW SRM 53-00-07, REPAIR NR 5.SDR ASOA2013073008809Frame · corrodedFRAME AT BS 333 AND BETWEEN RBL 27 TO 42.9 CORRODED. REPAIRED IAW SRM 51-21-06, SRM 53-21-15 SRM TR 53-27, FIG 102. REPAIR CLASSIFIED AS MAJOR.SDR CALA2013071900506Frame · crackedFRAME BETWEEN STRINGER 8 AND 9 AT BS 380R HAS A CRACK EMINATING FROM HOLE VISUALLY AND INDICATED BY NDT. REPAIRED IAW EA 5310-04716.SDR CHQA20130717303Frame · damagedDURING INSPECTION, A DAMAGED NUTPLATE ON FRAME 69 ON THE RT SIDE BETWEEN STRINGERS 13R AND 14R WAS FOUND. THE DAMAGED AREA WAS REPAIRED IAW ETD 2013-145-018588 A.SDR USAA2013080200015Frame · corrodedC3 CHECK - CORROSION ON FUSELAGE FRAME AT BS 847, S26R. REPLACED FRAME IAW SRM 53-70-13-00G & 51-40-02.SDR USAA2013080200014Frame · corrodedC3 CHECK - CORROSION ON FUSELAGE FRAME AT BS 847, S24R. REPLACED FRAME IAW SRM 53-70-13-00G & 51-40-02.SDR USAA2013080200013Frame · corrodedC3 CHECK - CORROSION ON FUSELAGE FRAME AT BS 847, S22R. REPLACED FRAME IAW SRM 53-70-13-00G & 51-40-02.SDR USAA2013080200012Frame · corrodedC3 CHECK - CORROSION FOUND ON FUSELAGE FRAME AT BS 847 BETWEEN S23-24R. REPLACED FRAME IAW SRM 53-70-13-00G & 51-40-02.SDR USAA2013080200011Frame · corrodedC3 CHECK - CORROSION FOUND ON FUSELAGE FRAME AT BS 847 BETWEEN S21-22R. REPLACED FRAME IAW SRM 53-70-13-00G & 51-40-02.SDR SWAA2013080118755Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW AAR & EA.
Back to JASC 5311