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 CALA2012100900662Frame · crackedRT FRAME BS 400 HAS A CRACK INDICATION AT INBD FASTENER. INSTALLED FRAME REPAIRED IAW EA 5310-04716.SDR USAA2012111400017Strap · crackedC2 CHECK - CRACK IN RIGHT FAILSAFE STRAP AT BS 955, RBL 92. REPAIRED RIGHT FAILSAFE STRAP AT BS 955, RBL 92 IAW EA 130973.SDR USAA2012111300003Strap · crackedC2 CHECK - CRACK ON LEFT FAIL SAFE STRAP AT BS 955, LBL 92. REPAIRED LEFT FAIL SAFE STRAP AT BS 955, LBL 92 IAW EA 130973.SDR SWAA2012103008976Frame · crackedR1 DOOR STUB FRAME CRACKED AT BS 295, RBL 53. REPAIRED ANGLE PER ER & SRM.SDR SWAA2012101608563Frame · crackedFRAME CRACKED AT BS 268.62, BETWEEN STR 23R TO STR 26R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR QXEA2012100801195Frame · corrodedFRAME 258.5, FLANGES ARE CORRODED STR 31P-32S. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .037" REF NDTM 51-00-04-910-801 PT 1. INSPECTED BLEND WITH HFEC, NO CRACKS NOTED REF NDTM 51-00-06-910-801 PT 1. FOUND SDR AALA20121008008Frame · crackedTHE 1485 CANT FRAME CRACKED BELOW AIRSTAIR STAIR ACTUATOR. INSTALLED SPLICE DOUBLER ON 1485 CANT FRAME RIGHT BELOW AIRSTAIR ACTUATOR PER AARD 53-10-00-33.SDR CALA2012100800659Frame · crackedRIGHT FRAME, BS 480, SHOWS A CRACK INDICATION, INBD FASTENER. REPAIRED FRAME IAW EA 5310-04716.SDR CALA2012100800658Frame · crackedRIGHT FRAME BS 440 HAS A CRACK INDICATION AT INBD FASTENER, REPAIRED FRAME IAW EA 5310-04716.SDR GLBA2012100800077Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK ON FRAME AT FS 163.97 AT STRINGER 9R CUTOUT, .5" IN LENGTH. REPAIRED IAW EO 12-1900-53-053. MAJOR REPAIR.SDR QXEA2012100701180Frame · corrodedFRAME 301, FLANGES AND WEB ARE CORRODED STR 30P-27P. REMOVED NECESSARY FASTENERS AND BLENDED OUT CORROSION IAW RD 8/4-53-2344 MIN REMAINING THICKNESS NOTED .037" CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1. REPAIR TO FSDR CALA2012100800657Frame · crackedLEFT FRAME BS 400 HAS A CRACK INDICATION, INBD FASTENER SIDE. REPAIRED FRAME IAW EA 5310-04716.SDR CALA2012100800656Frame · crackedLEFT FRAME, BS 440 HAS A CRACK, HFEC OTBD FASTENER SIDE. REPAIRED LT FRAME AT BS 440 IAW EA 5310-04716, REV C, FIG 3.SDR SWAA2012110109016Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012102308791Frame · crackedLEFT PASSENGER COMPARTMENT FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012102308731Frame · crackedFRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012102308730Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012102308729Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012102308711Frame · crackedSTUB FRAME CRACKED AT BS 947+10.5, STR 17R. REPAIRED STUB FRAME IAW EO AND EA.SDR SWAA2012101808637Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012101708608Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012101708603Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR QXEA2012100601179Frame · corrodedFRAME 664.5 FLANGE IS CORRODED STR 23P-24P. CLEANED AREA, REMOVED NECESSARY FASTENERS AND BLENDED OUT CORROSION IAW SRM 51-26-00-02-01, 51-42-05-02-01 AND RD 8/4-53-2344. MIN REMAINING THICKNESS NOTED .059" REF NTM 51-00-04-910-801 PT 1. INSPECTED BLENDED ARESDR ASAA2012100693061Frame · crackedFRAME AT BS 500C HAS A CRACK AT RAIL ATTACH BRACKET. REPAIRED IAW TASK CARD AD20062609-400-53-1-786, FIG 3.SDR QXEA2012100601169Frame · corrodedFRAME 1.0, FLANGE IS CORRODED STR 31S-32S. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801 PT 1. MIN REMAINING THICKNESS .045", INSPECTED BLEND USING HFEC, NO CRACKS NOTED REF Q400 SDR QXEA2012100601168Frame · corrodedFRAME 1.0, FLANGE IS CORRODED STR 31P-32P. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED UT THICKNESS OF BLENDS PER Q400 NTM 51-00-04-910-801 PT 1. MIN REMAINING THICKNESS 0.045". INSPECTED BLEND USING HFEC, NO CRACKS NOTED REFSDR QXEA2012100601167Frame · corrodedFRAME -18.25 IS CORRODED ON THE UPPER AND LOWER FLANGES AND THE WEB STR 32P-33. REMOVED RIVETS TO ACCESS CORROSION IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. VERIFIED AFFECTED AREA TO BE CRACK FREE USING HFEC REF NDTM 51-00-06-910-80SDR CALA2012100800654Frame · crackedLEFT FRAME, BS 867 SHOWS A CRACK INBD FASTENER. CUT OUT DAMAGED AREA IAW EA 5310-04716, FABRICATED REPAIR ANGLES IAW EA5310-04716 TREAT & PRIMED & INSTALLED IAW EA 5310-0 4716, REV C & SRM 51-40-02.SDR CALA2012100800653Frame · crackedFRAME BS 727F SHOWS A CRACK MFEC INBD FASTENER. REPAIR LT FRAME BS 727F, REF EA 5310-04716, REV C.SDR CALA2012100800652Frame · crackedRT FRAME BS 867 SHOWS A CRACK MFEC INBD FASTENER, REPAIRED CRACKED FRAME AT BS 867 RT SIDE IAW EA 5310-04716, REV C, OP 1.SDR QXEA2012100601165Frame · corrodedFRAME -18.25 FLANGE IS CORRODED 32S-31S. REMOVED CORROSION IAW RD 8/4-53-2344. VERIFIED AFFECTED AREA TO BE CRACK FREE USING HFEC REF NDTM 51-00-06-910-801 PT 1. MIN REMAINING THICKNESS .038" REF NTM 51-00-04-910-801 PT 1. MATERIAL LOSS FOUND TO BE IN LIMITSSDR QXEA2012100601160Frame · corrodedFRAME -18.25 FLANGE IS CORRODED STR 29P-30P. REMOVED RIVETS TO ACCESS CORROSION IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. VERIFIED AFFECTED AREA TO BE CRACK FREE USING HFEC REF NDTM 51-00-06-910-801 PT 1. MIN REMAINING THICKNESS .037SDR SWAA2012111209270Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012111209269Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW EO AND EA.SDR DALA1251123735Frame · crackedMAIN CABIN FUSELAGE STA 380 LT SIDE FRAME CRACKED AT RIVET. LOCATION ABOVE STR 8. REPAIRED IAW ERA 507331-14AD AT IND ON NR1353419.SDR SWAA2012101508490Frame · corrodedFRAME CORRODDED AT BS 974. REPAIRED FRAME PER SRM.SDR ASAA2012100593068Frame · crackedFRAME AT BS 380 RT IS CRACKED AT ATTACH BRACKET. REPAIRED IAW TASK CARD AD20062609-400-52-1-786.SDR ASAA2012100593067Frame · crackedFRAME AT STA 500C LT IS CRACKED AT ACFT RAIL ATTACH BRACKET. ACFT GROUNDED. REPAIRED FRAME IAW TASK CARD AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593066Frame · crackedFRAME AT STA 867 R IS CRACKED AT AC RAIL ATTACH BRACKET. ACFT GROUNDED. REPAIRED FRAME IAW TASK CARD AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593065Frame · crackedFRAME AT BS 747 L IS CRACKED AT ATTACH BRACKET. REPAIRED IAW TASK CARD AD20062609-53-1-786, FIG 3.SDR ASAA2012100593064Frame · crackedFRAME AT BS 787, HAS A CRACK AT RAIL ATTACH BRACKET. REPAIRED FRAME IAW TASK CARD AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593063Frame · crackedFRAME AT BS 907 IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED IAW AD20062609-400-53-786, FIG 3.SDR ASAA2012100593062Frame · crackedFRAME AT STA 500A RT IS CRACKED AT ACFT RAIL ATTACH BRACKET. ACFT GROUNDED. REPAIRED IAW TASK CARD AS20062609-400-53-1-786.SDR ASAA2012100593060Frame · crackedFRAME AT BS 440 IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED IAWAD 20062609-400-53-1-786, FIG 3.SDR ASAA2012100593059Frame · crackedFRAME AT BS 400 R IS CRACKED AT ATTACH BRACKET. REPAIRED IAW TASK CARD AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593050Frame · crackedFRAME BS 827 RT IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609, 400-53-1-786, FIG 3.SDR ASAA2012100593047Frame · crackedFRAME AT BS 500A, IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593046Frame · crackedFRAME AT BS 480 LT IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593043Frame · crackedFRAME AT BS 440 IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609, 400-53-1-786, FIG 3.SDR ASAA2012100593042Frame · crackedFRAME AT BS 727D IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609, 400-53-1-786, FIG 3.
Back to JASC 5311