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 LR7A07046Segment · brokenDURING SCHEDULED B-3 CHECK PER JOB CARD HB5302, FOUND OVERHEAD RING SEGMENT BROKEN AT FS477, RBL35. REPAIRED RING SEGMENT IAW SK382-53-184 R1 REPAIR "B'".SDR KCSA071187Frame · corrodedFUSELAGE FRAME AFT CHORD IS CORRODED AT STA 2598, STR 8L.SDR USAA070462Frame · corrodedFRAME 66 HAS CORROSION. INSTALLED BATH TUB FITTING PER TR 53-41-01, DEFECT SIZE: 1" X 1" X .067".SDR USAA070446Frame · crackedTHREE EACH RADIATING CRACKS AT STA 480L, BETWEEN S8L & S9L. CUT OUT CRACKED AREA, INSTALLED REPAIR ANGLES PER TR 53-10-20E, DEFECT SIZE: .080 INCH.SDR 07FDEA02087Frame · crackedC44 RT AND C46 RT, FOUND OLD DOUBLER REPAIR ON FRAME DUE TO CRACKING FINDINGS IAW SB 53-6122 REPAIR PERFORMED BY REPLACEMENT OF FRAME C 44 (P/N A538-12310-201) AND 46 (P/N A538-12312-201) IAW SRM 51-72-10.SDR MASA200700374Frame · crackedMODIFICATION OF THE FRAME AT FS 640 CRACKED. REPAIRED FRAME.SDR UPS07M50093Frame · crackedINSPECTION TYPE:C AFT FUSELAGE, AFT PRESSURE BULKHEAD, AFT FACE STA 2007, RBL10', UPPER PORTION OF T CHORD FOUND WITH CRACK AT EDGE AS MARKED. AFT FUSELAGE, AFT PRESSURE BULKHEAD, AFT FACE STA 2007 RBL UPP PORTION REMOVED FOR ACCESS REPAIR PER SRM 51-21-01V.RSDR DHL2007740545Frame · corrodedAFT CARGO BS 950D BETWEEN STR27L AND STR 29R RT FWD SIDE OF FRAME HAS FLANGE WITH CORROSION SEVERAL PLACES. REMOVED CORROSION AT FRAME BS 950D BETWEEN STR29R AND 28R ORIGINAL MAT .071" MAT LOSS .036" MAT REMAINING .035" FOUND OUT OF LIMITS IAW B727 SRM 53-10-SDR DU4R2007133Frame · dentedAFT PIT FRAME DENTED BS 1440, STR 27L. REMOVED OLD REPAIR, FABRICATED AND INSTALLED FRAME REPAIR 16"BY 3" BY 1" FROM 7075-T6 .071" IAW B757 SRM 51-40-02, 51-40-05, 51-70-11, 53-00-07, 51-20-01 AND 51-20-02.SDR CALA0700293Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN AFT CARGO DOOR CUTOUT AFT FRAME AT LOWER STOP FITTING, STA 847, S24R. A NEW FRAME WAS INSTALLED IAW SRM 51-40-02.SDR CALA0700292Frame · crackedINSPECTION FOUND A 0.012 INCH CRACK IN BELTFRAME AT STA 231, BL 0, JUST FORWARD OF FORWARD ACCESSORY DOOR CUTOUT. THE CRACKED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW ECRA 5313-01010, REV A.SDR USAA070441Frame · crackedBS 867, BETWEEN S-8R AND S-9R HAS CRACKS. CUT OUT CRACKS, INSTALLED REPAIR ANGLES PER TR 53-10-20E, DEFECT SIZE: .5 INCH.SDR USAA070444Frame · crackedSTA 440R BETWEEN S8R & S9R AC SUPPORT BRACKET ATTACH POINT HAS CRACK. REPAIRED PER T/R 53-10-20E, DEFECT SIZE: .125 INCH.SDR USAA070445Frame · crackedSTA 360, S13L HAS CRACK. INSTALLED REPAIR ANGLE PER SRM 51-10-02, 51-40-02, DEFECT SIZE: .125 INCH.SDR DHL2007740518Frame · corrodedAFT CARGO BS 990 BETWEEN STRS 27L AND 30 FWD SIDE OF FRAME HAS CORROSION 3 PLACES. REMOVED CORROSION AT FRAME BS 990 BETWEEN STR 26L AND 28L ORIG. THICKNESS .063 MAT. LOSS .003 REMAINING .060 WITHIN LIMITS IAW 727 SRM 51-10-6 FIG 1 AND 53-10-2 FIG 5. REMOVEDSDR DHL2007740514Frame · corrodedAFT CARGO BS 1130 BETWEEN STR'S 27R AND 29L, FRAME HAS BARE METAL AND CORROSION. CORROSION REMOVAL OUT OF LIMITS PER B727 SRM 53-10-1 FIG 1. REMOVED AND FABRICATED 4 SHEAR TIE ANGLES FROM 7075-T6, .063" BY 6" BY 2.5" ( 4 EACH), PO NR 9004690. TREATED, PRIMSDR UPS07M50285Frame · corrodedINSPECTION TYPE:C AFT CGO STA 1841 APPROX LONGERON 44 AREA, FRAME FOUND WITH CORROSION AS MARKED. DAMAGED FRAME REMOVED PER SRM 51-31-01 V.2R.38. NEW FRAME FASTENER HOLES PICKED UP PER SRM51-31-01 V.2R.38. NEW FRAME REPROTECTED AND PAINT TOUCHED UP PER SRM SDR ZZDA2007216Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT BS 1002 FRAME BETWEEN LONGERON 30 AND LONGERON 22L. INSTALLED NEW FRAME AT STA 1002 BETWEEN LONGERON 30L AND 22L PER B717 SRM 51-41-02 AND SRM 51-41-05.SDR ZZDA2007246Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT BS 974 FRAME BETWEEN LONG 29R AND 21L. REPLACED FRAME BS 974 BETWEEN LONGERON 29R AND LONGERON 21L IAW SRM 51-41-02.SDR ZZDA2007245Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT BS 927 FRAME BETWEEN LONG 29R AND 22L. REPLACED FRAME BS 927 BETWEEN LONGERON 29R AND LONGERON 22L IAW SRM 51-41-02.SDR ZZDA2007244Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT BS 908 FRAME BETWEEN LONG 28R AND 22L. REPLACED FRAME BS 908 BETWEEN LONGERON 28R AND LONGERON 22L IAW SRM 51-41-02.SDR ZZDA070605201Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT BS 1037 ON FRAME BETWEEN LONGERON 29R AND LONG 21L. INSTALLED NEW FRAME SECTION STA STA 1037 FROM LONGERON 29R TO 18L AS PER B717 SRM 51-41-02 AND SRM 51-41-05. MATERIAL USED 7075-T6 .063 AND 7075-T6 0.071.SDR ZZDA070605200Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT FRAME BETWEEN LONG 30 AND LONG 22L. INSTALLED FRAME SPLICE AT STA 1022 FROM LONGERON 25L TO 23L AS PER B717 SRM 51-41-02 AND SRM 51-41-05. MATERIAL USED 7075-T6 .050 AND 7075-T6 0.071.SDR 2007UALA01831Frame · crackedCABIN BS 616 FRAME INBOARD CHORD IS CRACKED, WL 202, RBL 64. MAJOR REPAIR ACCOMPLISHED: MANUFACTURED & INSTALLED REPAIR ANGLE & FILLER.SDR SWAA072835Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA072842Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072844Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072840Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072847Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, S8R. REPAIRED FRAME PER SWA EA.SDR SWAA072846Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, S8R. REPAIRED FRAME PER SWA EA.SDR SWAA072841Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072845Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072848Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072849Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 580, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072843Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR USAA070423Frame · crackedSTA 727D BETWEEN STRINGERS 8 & 9 ON FRAME HAS CRACK. REMOVED DAMAGED AREA & INSTALLED REPAIR PARTS PER SRM 53-10-20E, STEP 9, DEFECT SIZE: .25 INCH.SDR USAA070424Frame · crackedSTA 747 BETWEEN STRINGERS 8 & 9 LEFT HAS CRACK. REMOVED DAMAGED AREA & INSTALLED REPAIR PARTS PER TR 53-10-22A, 53-10-20E, DEFECT SIZE: .25 INCH.SDR UPS07450036Frame · crackedINSPECTION TYPE:C CABIN BS 480 S15L FRAME FOUND CRACK. CRACK LENGTH 2 1/4" CABIN BS 480 STR 13AL TO STR 16L FRAME REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450020Doubler · crackedINSPECTION TYPE:C CABIN BS 460 S14R FRAME DOUBLER FOUND CRACKED (CRACK LENGTH 1.5 INCH). CABIN BS 460 BETWEEN STR 11R TO STR 14ER AREA FRAME ATTACH DOUBLER REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450019Doubler · crackedINSPECTION TYPE:C CABIN BS 420 S14ER FRAME DOUBLER FOUND CRACKED. (CRACK LENGTH 6 INCHES) CABIN BS 420 STR 13AR TO STR 15R FRAME ATTACH DOUBLER AND BETWEEN STR 10AR TO STR 16R FRAME ATTACH INNER CHORD & INNER ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-01 SDR UPS07450011Frame · crackedINSPECTION TYPE:C CABIN BS 480 S15R FRAME FOUND CRACK. CRACK LENGTH 2.5 INCHES. CABIN BS 480 STR 13AR TO STR 16R FRAME REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR 07FDEA02070Frame · noneEXISTING REPAIR, UPPER CARGO COMPARTMENT, LT SIDEWALL STRUCTURE FRAME AT STA 1701, L-12L, FOUND WITH REPAIR DOUBLER. EXISTING REPAIR EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-SDR DHL2007740520Frame · corrodedWHILE IN "C" CHECK, AFT CARGO BS 1070 STR 28L-29L FWD FRAME FLANGE HAS CORROSION. REMOVED CORROSION IAW B727 SRM 51-10-6. REMOVED FASTENERS TO GAIN ACCESS TO AREA IAW B727 SRM 51-30-2. ORIGINAL MAT .063 IAW B727 SRM 53-10-2 FIG 5, MAT LOSS .008, REMAINING MASDR SWAA072827Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 1. REPAIRED FRAME PER SWA EA.SDR SWAA072816Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072815Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR TRAX200700784Frame · crackedRT FRAME 640 RT IS CRACKED ON OUTBOARD FLANGE JUST ABOVE STR 9, RESOLVED ON W/O: 59833 TASKCARD: N/R-00072. FOUND CRACK ON RT FRAME 640.00 O/B FLANGE REPAIRED IAW ASA EC/TC REO 601R-53-61-2202 STEPS 1 TO 16. HFEC PERFORMED ON RT FRAME 640.00 O/B FLANGE CUT-OSDR TRAX200700780Frame · crackedCRACK ON LOWER FLANGE OF FRAME 280.00 RBL 9.00 REO 601R53-11-171 TO BE C/OUT MAJOR, RESOLVED ON W/O: 59833 TASKCARD: N/R-00027. CUTOUT DONE ON LOWER FLANGE OF FRAME 280.00 RBL 9 IAW REO 601R53-11-171 REV D. HFEC PERFORMED ON LOWER FLANGE OF FRAME 280 RBL 285SDR UPS07450035Frame · crackedINSPECTION TYPE:C NR 2 DOOR FWD FRAME AT BS 800 RT SIDE FOUND CRACKED AT NR 5 AND NR 6 FAST HOLE BELOW STR 16 BOTH HOLE CRACKED AT STRAP WITH LENGTH 0.040" RUNNING AFTWARD. BS 800 RT SIDE FRAME FWD INNER CHORD AND STRAP REPAIRED AT BTN STR 15T TO STR 18R AREASDR 2007UALA01776Frame · corrodedFWD PIT HAS NUMEROUS CORRODED FASTENERS ON FRAME CLEATS, STRINGERS, STRINGER CLIPS AND SKIN DOUBLERS, FROM FRAME 24 TO FRAME 35 BETWEEN STR 38L AND 38R. REPLACED A TOTAL OF 1290 RIVETS.
Back to JASC 5311