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 NSVA2011432Repair · corrodedFOUND PREVIOUS UNDOCUMENTED REPAIR TO THE AFT FLANGE OF THE BOTTOM FRAME AT STA 258 TO HAVE DEEP CORROSION FROM LBL 7.75 TO LBL 12.25. THE REINFORCEMENT ANGLE HAS SINGLE ROW RIVETS FROM LBL 12 TO LBL 17. REF SAAB STATEMENT 340 SDS 023532 DATED 1-24-2012, TD SDR DALA1157520138Frame · crackedCABIN RT STA 883 BETWEEN STR 20R AND STR 21R FRAME INNER CHORD CRACK. REPAIR ACCOMPLISHED AS PER ERA 491126-14AD REV 0.SDR FDEA201109123853Frame · misrepairedFUSELAGE FRAME STA 1340 BETWEEN S-25R AND S-26R HAS AN EXISTING REPAIR WHICH DOES NOT COMPLY WITH CURRENT SRM REQUIREMENTS. FABRICATED NEW FRAME SECTION IAW TR 895247, LOCATED AND DRILLED NEW FRAME IAW SRM 51-40-05. INSTALLED SPLICES, FAILSAFE, AND FRAME IAW SDR SWAA116497Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 867, STR 27L. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA116496Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA116495Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR CALA2011091200590Beltframe · crackedSUPPORT TASK- FUSELAGE BELTFRAME STA 480 BETWEEN STRINGER 8R-9R CRACKED AT FASTENER OF A/C OUTLET ASSY. SUPPORT BRACKET INSTALLED REPAIR ANGLES A&B PER EA 5310-04716.SDR CALA2011091200589Frame · crackedSUPPORT TASK - FUSE FRAME CRACKED AT STA 727B BETWEEN S8R AND S9R. AT A/C OUTLET EXTRUSION SUPPORT ATTACHMENT. REPAIRED FRAME AT STA 727B BETWEEN STR 8R AND 9R AT A/C OUTLET EXTRUSION SUPPORT ATTACHMENT REF EA 5310-04716 REV C OP 2.SDR DALA1156740966Frame · crackedDURING PSV, PAX MOD VISIT IN MSP FOUND AFT FUSELAGE TAIL CONE ATTACH FRAME STA 1510 CRACKED AT 3RD ALIGNMENT PIN BELOW LOWER RT LATCH ASSY. INSTALLED NEW FRAME SECTION PER MD88 SRM 53-03 FIG 802D.SDR ASAA11410355Frame · crackedBS 601 L FRAME INNER CHORD CRACKED AT LOWEST 2 EA FASTENER HOLES WL 200 MARKED. CUT OUT DAMAGE AT LOWEST 2 FASTENER HOLES AND REPAIRED CHORD IAW ASA EA 400 53EA 06253 AND ATS ER 11 04185.SDR ASAA11410354Frame · crackedBS 601 RT FRAME INNER CHORD CRACKED AT 1 EA LOWEST FASTENER HOLE WL 200. FOUND DURING NDI HEEC BOTTOM SIDE OF HOLE MARKED. CUT OUT CRACKED FASTENER HOLE AND REPAIRED IAW ASA EA 400 53EA 06258 AND ATS ER 11 04186.SDR SWAA116476Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 321, BETWEEN STR 17L TO STR 21L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR ASAA11410358Frame · crackedBS 616 RT FRAME INNER CHORD CRACKED AT LOWEST FASTENER HOLE WL 200. FOUND DURING NDI HFEC BOTTOM POSITION OF HOLE MARKED. REPAIRED BS 616 RT FRAME INNER CHORD WL 200 PER T/C AD20102506 400 53 8 AND EA 400 53EA 06250.SDR FDEA201109103822Frame · misrepairedFRAME AT BS 1200 S27R MISREPAIRED. R & R FUSELAGE FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR SWAA116562Frame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME CRACKED AT BS 420, STR 26L. REPAIRED FRAME IAW EO.SDR SWAA116550Frame · corrodedDURING SCHEDULED 22Y CHECK FOUND, SHEAR TIE CORRODED AT BS 482A, BETWEEN STR 27R TO STR 28R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR ASOA201101686Frame · crackedBS 280 FRAME APPEARS TO BE CRACKED AFT LOWER SIDE NEAR LBL 9.00. PERFORMED ET INSPECTION IAW MAC NDT INSPECTION PROCEDURE ET-2. VERIFIED FRAME CRACKED. REPAIRED IAW REO 601R-53-11-171. PERFORMED NDT IAW NDTM 51-20-06. NO INDICATIONS NOTED.SDR DALA1152646309Frame · crackedDURING LCK, A CRACK WAS FOUND ON THE STA Y00 LBL 45 FRAME IN THE FWD CARGO COMPARTMENT. ER/A 495580-14 SECT I WAS ACCOMP. FOLLOW ON ACTION IS REQ FOR THIRD STAGE APPROVAL. DFRD 233849 STA MSP 09SEP11 ATA 5311 ENTR 233849 S ACCOMP ER/A 495580-14 SECT II BEFSDR USAA2011091100011Frame · crackedC1 CHECK - FRAME CRACKED AT BS 500D AND S21L. REPAIRED FRAME AT BS 500D AND S21L I/A/W B737 SRM 53-00-07.SDR FDEA201109093807Frame · damagedFRAME AT BS 1300 S1 HAS ELONGATED HOLE. REPAIRED FRAME IAW SRM 53-00-07.SDR CHQA201100384Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE AIRSTAIRS FORWARD SIDE FRAME. MAINTENANCE REPLACED THE AIRSTAIRS FORWARD SIDE FRAME. THE NEW PART WAS INSTALLED WITH A SOLID RIVET, IN ACCORDANCE WITH SRM 51-40-02.SDR IPXA1569353Frame · dentedFWD CARGO COMPT FRAME DENTED BS 700, S23L. REPAIRED IAW SRM-53-00-07, DETAIL 1.SDR IPXA1569352Frame · dentedFWD CARGO COMPT FRAME DENTED BS800 STR 22R-23R. REPAIRED IAW SRM-53-00-07, DETAIL 1.SDR IPXA1569351Frame · dentedFWD CARGO COMPT FRAME DENTED BS 780, STR23L-STR24L. REPAIRED IAW B757-SRM-53-00-07, DETAIL 1.SDR IPXA1569350Frame · dentedFWD CARGO COMPT FRAME DENTED BS800, STR 22-23L. REPAIRED IAW SRM 53-00-07, DETAIL 2.SDR FDEA201109083756Frame · gougedCABIN STA 1560, GOUGE ON FRAME FLANGE ABOVE S9R. REPAIRED IAW SRM 53-00-07 REPAIR 3 FIG.201, REV.103. REPAIR IS CLASSIFIED AS MAJOR.SDR ABXA20110907104Tee Fitting · corrodedLT FAILSAFE STRAP "T" FITTING IS DEEPLY CORRODED AND ONE OF THE FASTENER HOLES HAS INSUFFICIENT. REMOVED AND REPLACED "T" FITTING IAW REA B653-59439-MR, AWG.SDR USAA2011091000016Frame · crackedC1 CHECK - CRACKED FRAME WIRE PENETRATION HOLE AT BS 500G BETWEEN S20R AND S21R. REPAIRED FRAME AT BS 500G BETWEEN S20R AND S21R IAW B737 SRM 53-00-07.SDR DALA1151929014Beltframe · damagedLIGHTNING STRIKE ON AFT LOWER CORNER OF LT WINDOW BELT FRAME STA 7=712 AT FUS EXTERNAL SKIN. REWORKED PER ERA 495214-14 REV ORG.SDR AALA20110907TUL09Frame · corrodedCORROSION ON AFT SIDE OF FRAME, LONGERON 30, STATION 1250. INSTALLED J-ANGLE REPAIR PER AARD 53-10-00-14.SDR SWAA116430Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW SRM.SDR SWAA116427Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME OUTER CHORD CRACKED AT BS 639, STR 16L. REPAIRED CHORD IAW EA.SDR SWAA116396Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA116395Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA116393Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA116392Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA116391Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEENS STR 2L TO STR 3L. REPAIRED FRAME IAW EO.SDR SWAA116388Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 927, BETWEEN STR 22L TO STR 23L. REPAIRED FRAME IAW EO.SDR HYIA20110906001Frame · corrodedDURING HEAVY CHECK INSP, CORROSION WAS FOUND ON FUSELAGE FRAME 25 LOWER FLANGE AT STRINGER 20 THAT WAS BEYOND THE SRM LIMITS. REPAIRED IAW STRUCTURAL REPAIR APPROVAL SHEET (SRAS) SO/TS-2865/11...6640.SDR DALA1151510693Frame · damagedFABRICATED J SECTION ANGLE, TREATED AND PRIMED IAW B757 SRM 53-00-07 REPAIR 5 PAGE 201 FIG 201. INSTALLED J SECTION ANGLE ON AFT CARGO FRAME AT STA 1480 ABOVE STR S-26L IAW B757 SRM 53-00-07 REPAIR 5 PG 201 FIG 201. AT SAA/SAT DURING HMV ON N/R 185588 W/O 88SDR DALA1151429014Frame · corrodedCORROSION ON LOWER CAP OF FRAME AT STA 1380 BETWEEN LONGERONS 27LT AND 27RT. "T" CAP WAS REPAIRED IAW ERA 495215-4 REV ORIG.SDR SWAA116416Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 794, BETWEEN STR 27R TO STR 25R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA116367Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA116365Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA116361Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947, STR 18L. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA116354Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 947, STR 19R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA116352Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 967, BETWEEN STR 6L TO STR 7L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA116330Frame · crackedDURING SCHEDULE 28Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED WEB PER ACO.SDR JR2R2011090600378Frame · corrodedFRAME AT STA 310 CORRODED FROM STR 26L TO 25R.SDR IPXA1569587Frame · damagedC1 CHECK, SCREW START MARK ON INNER FLANGE OF FRAME, BS 1400 BETWEEN 25L-26L. REPAIRED IAW SRM 53-00-07-2R5 AND ATS ER 11-04537.
Back to JASC 5311