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 SWAA2012122810956Frame · crackedMAIN CABIN FRAME CRACKED AT STA-440 BELOW STR 8R AT PSU RAIL. REPAIRED FRAME IAW EA 1-A53-12114.SDR HNAA2012121901121Frame · crackedFRAME LEG CRACKED AT BS 252.3 AND STR 31S. CRACK IS AT MOST OTBD RIVET. CUT FRAME LEG OFF FRAME. REPAIRED FRAME LEG IAW SRM 53-20-21.SDR HNAA2012121901116Frame · corrodedCORROSION ON FRAME BS 405, BETWEEN STR 31 AND 32S. CORROSION WAS FOUND TO BE MINOR SURFACE SORROSION. CLEANED AREA, REMOVED MINOR CORROSION, ALODINED AND PRIMED AREA IAW SRM 51-20-11, 51-20-16 AND 51-20-36.SDR USAA2013012800022Beltframe · crackedQ6 CHECK - CRACK ON FUSELAGE FRAME AT BS 500F BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500F BETWEEN S20R TO S21R IAW B737 SRM 53-00-07-2R-13 FIG 202 TABLE 1.SDR SWAA2013012111620Frame · corrodedCORROSION ON FRAME WEB LOCATED BS 285.62, AFT LEVEL S-27L, NLG AREA. REPLACED FRAME WEB LOC BS 285.62 AT LEVEL STR 23L TO STR 27L NLG AREA IAW B737-300 SRM 51-10-02 ITEM 8 AND DRAWING 65-45806.SDR DALA13002826307Frame · crackedDURING OPEN HOLE INSPECTION AT BS 1265 LT FRAME INNER CHORD AND WEB FOUND CRACK INDICATION AT THE FASTENER HOLE 4TH LAYER , 3 O`CLOCK DIRECTION VIEW FROM AFT AS MARKED. BS 1265 LT FRAME INNER CHORD AND WEB FOUND CRACK AT 4TH LAYER ,3 O'CLOCK DIRECTION REPAIRESDR DALA13002816307Frame · crackedDURING OPEN HOLE HFEC INSPECTION AT BS 1265 RT FRAME INNER CHORD AND WEB FOUND CRACK INDICATION AT THE FASTENER HOLE 4TH LAYE R 9 O'CLOCK DIRECTION VIEW FROM AFT. BS 1265 RT FRAME INNER CHORD AND WEB FOUND CRACK AT 4TH LAYER 9 O`CLOCK DIRECTION REPAIRED IAW PSDR ABXA20121217372Failsafe · crackedRIGHT FAILSAFE CRACKED. FAILSAFE STRAP TERMINATING ACTION PERFORMED ON EA 53500014-003, AMES DOCUMENT 47008ORD04, ACFT WAS GROUNDED.SDR A6WA20121215619Frame · damagedREPAIR FUSELAGE FRAME FS 333. REPAIRED IAW REO 601R-53-21-2383.SDR UIEA2012121900556Frame · damagedDURING THE D2/C2/A2 CHECK IAW EO 4453A295/ SB 747-53A2784 FOUND THE CROWN FRAME WEB AT BS 320 TO BE UNDERSIZED REQUIRING REPLACEMENT. WHILE ACCOMPLISHING THE WEB REPLACEMENT IAW PART 2 OF EO 4453A295, EGAT NOTICED SEVERAL DEVIATIONS FROM THE SB REQUIREMENTS.SDR QXEA2012121501693Frame · corrodedFRAME 32.4 HAS CORROSION ON THE FLANGES AND BOTH SIDES OF THE WEB STRINGER 29S-28P. REMOVED RIVETS AND X BRACE FOM IAW SRM 51-41-00-00-01 AND 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02 AND FOUND TO BE OUT OF LIMITS DUE TO 100 PERCENT MATERIAL LOSDR R5KB2013031150525Frame · corrodedFRAME AT BS 950B CORRODED ABOVE STR 28L.SDR SWAA2013012111627Frame · crackedCRACK ON UPPER STUB FRAME LOCATED BS 947.5+7" AND BETWEEN STR 9R AND STR 10R IN AFT CABIN. REPLACED UPPER STUB FRAME LOCATED BS 947.5+7" AND BETWEEN STR 9R AND STR 10R IAW B737-300 SRM 51-10-02 ITEM 8 AND 51-42-02 DRAWING 65-46561.SDR SWAA2013011011343Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 26R TO 25R. REPAIRED FRAME IAW EO.SDR SWAA2013010711159Frame · corrodedLOWER FLANGE FRAME CORRODED AT BS 847, BETWEEN STR 27L TO 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013010711157Frame · corrodedLOWER FLANGE FRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR ASOA2012122102721Frame · damagedWHILE REPLACING LONGERON AT STR25R LOWER FRAME SECTOR AT FS 349 TORE. NO REPAIR ALLOWED FOR THIS SECTOR REPLACEMENT IS REQUIRED. REMOVED FRAME, DRILLED UP NEW FRAME & INSTALLED FRAME ATTACH FLANGE SRM 51-42-06-001-001. REPAIRED IAW SRM 51-42-06-001-001 AND SDR ABXA20121214366Frame · corrodedLEFT SIDE FRAME FITTING NR 10 & 11 HOLES HAVE CORROSION AROUND THEM ON THE FWD FACE. REPAIRED AREAS OF CORROSION AROUND HOLES NR 10 & 11 IN LEFT SIDE FRAME FITTING IAW 47030REA06, ACFT WAS GROUNDED.SDR SWAA2013020112204Frame · crackedFRAME WEB CRACKED AT BS 294.5, STR 16L. REPAIRED WEB EO.SDR SWAA2013020112203Frame · crackedCRACK ON WEB OF FRAME LOCATED BS 277 AND STR 16L IN FWD CABIN. REPAIRED WEB OF FRAME LOCATED BS 277 AND S-15L AND S-17L IN FWD CABIN IAW EO AEM-HC53-583-12 R0 EA 1-353-21461 R0. FOR REQUIREMENT INSPECTION SEE TLD: T031015SDR SWAA2013012811955Frame · crackedCRACK ON FRAME LOCATED AT BS 500D, BETWEEN STR 23R AND STR 24R IN FWD CARGO COMPARTMENT. REPAIRED FRAME LOCATED AT BS 500D, BETWEEN STR 23R AND STR 24R IN FWD CARGO COMPARTMENT IAW SRM B737- 300 51-40-02,53-00-07-2R REPAIR 7.SDR SWAA2013012811954Frame · crackedCRACK ON FRAME LOCATED AT BS 500D, BETWEEN STR 20R AND STR 21R IN FWD CARGO COMPARTMENT. REPAIRED FRAME LOCATED AT BS 500D BETWEEN STR 20R AND STR 21R IN FWD CARGO COMPARTMENT IAW SRM B737- 300 53-00-07-2R-7 DETAIL REPAIR 7.SDR SWAA2013010211060Frame · crackedRIGHT FRAME AT STA 715 IS CRACKED AT I/B RADIUS, UNDER CUSP WEB. REMOVED AND REPLACED FRAME AT STA 715 LONGERON 9R-18R IAW EA 17-53-04005.SDR ABXA20121213365Frame · corrodedLEFT SIDE FRAME FITTING HAS SEVERAL AREAS OF CORROSION ON THE FORWARD FACE ABOVE HOLE 1. CLEANED AREAS OF CORROSION IAW B767-200 SRM 53-50-08. REMOVED CORROSION WITHIN LIMITS .638 REMAINING FROM ORIGINAL THICKNESS OF .700 VERIFIED WITH NDT. PRIMED AND PAINTSDR DALA12016243210Frame · corrodedDURING INSPECTION, FOUND RT AFT PASSENGER DOOR SILL AFT FRAME 66, UPPER SURFACE AROUND NUT PLATE HOLES HAS CORROSION. BLENDED OUT CORROSION IAW SRM 51-74-00. DIM. L=2", W=1.3", D=.035". FOUND OUT OF LIMITS IAW SRM 53-41-14, FIG1, SH2. ACCOMPLISHED ROTO SDR SIMA20121213009Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND FRAME 23 CRACKED AT STRINGER 15 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW EO EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR FOTR121420123041Frame · crackedFWD CARGO COMPARTMENT FRAME IS CRACKED AT 1.04" WIRE PENETRATION HOLE BETWEEN STR 20L AND STR 21L, BS 500G. REPAIRED ON FAS WO 22248, NR 3041.SDR ASOA20121213147Frame · corrodedDURING C-CHECK, FRAME 65 CORRODED, IN UPPER RADIUS AT STRINGER 17L AND AT NUT PLATES FOR GUIDE. MAINTENANCE COMPLETED REPAIR AT FRAME 65 STRINGER 17L IAW EC5330-02661. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR R5KB2013031150428Frame · corrodedFRAME AT BS 990, RBL 22 AREA OF CORROSION.SDR SWAA2013012511860Frame · corrodedCRACK ON FRAME LOCATED BS 947.5 AT LEVEL STR 19R IN AFT CARGO COMPARTMENT. REPLACED FRAME LOCATED BS 947.5 BETWEEN STR 17R TO STR 23R IN AFT CARGO COMPARTMENT IAW B737-300 SRM 51-40-02, B737-300 SRM 51-10-02 ITEM 8 AND DRAWING 365-46560.SDR ABXA20121212364Strap · corrodedLEFT FAILSAFE STRAP HAS MULTIPLE AREAS OF HEAVY CORROSION. REMOVED AND REPLACED FAILSAFE STRAP IAW B767-200 SRM 51-40-05 ON EA 53500013-008, AMES DOC. 47008ORD11, ACFT WAS GROUNDED.SDR ABXA20121212359Failsafe · crackedSTA 955 LEFT FAILSAFE LOWER HOLE CRACKED AT 2 O`CLOCK POS APPROX .310 LONG MARKED. LEFT FAILSAFE STRAP REPLACED ON EA 53500013-008, AMES DOC. 47008ORD11. ACFT WAS GROUNDED.SDR QXEA2012121201680Frame · corrodedCORROSION FOUND ON FRAME 669.300 UNDER STRINGER TIE FITTING AT STRINGER 25P. REMOVED CORROSION IAW SRM 51-21-00-00-02. VERIFIED AFFECTED AREA CRACK FREE USING HFEC REF NTM 51-00-06-910-801 PT 1 MIN THICKNESS REMAINING .093" REF NTM 51-00-04-910-801 PT 1. FOUNDSDR QXEA2012121201678Frame · corrodedCORROSION ON AFT SIDE OF FRAME X882.703 AND FWD SKIN ATTACHING ANGLE OF CANTED FRAME AT STA TR X105 BETWEEN STR 30P AND 30S. REMOVED FASTENERS COMMON TO SKIN AND FWD SKIN ATTACHING ANGLE, REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-01. MIN REMAINSDR QXEA2012121201667Frame · corrodedFRAME -18.25 HAS CORROSION ON THE FWD SURFACE AND UPPER FLANGE STRINGER 33. REMOVED RIVETS TO ACCESS CORROSION IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. REMOVED RIVETS FROM FRAME WEB AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-0SDR SWAA2013012411791Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 27L TO 27R. REPAIRED FRAME IAW SRM AND DWG.SDR AALA20130107004Frame · dentedAFT CARGO, STATION 1540 STRINGER 25 RIGHT FRAME DENTED. INSTALLED NESTED ANGLE REPAIR PER SRM 53-00-07-2R.SDR QXEA2012121101691Frame · damagedFRAME 236, FLANGE HAS TOOLING DAMAGE STRINGER 30P-31P. REMOVED FASTENER FOM IAW SRM 51-42-05-02-01. VERIFIED AFFECTED AREA TO BE CRACK FREE REF NTM 51-00-06-910-801 PT 1. FOUND CREASE DEPTH .008" OUT OF LIMITS IAW SRM 53-30-15-00-01. SMOOTHED OUT TOOLING DASDR AALA20130107007Frame · dentedAFT CARGO, FRAME STATION 1480 DENTED FROM STRINGERS 25 TO 27 LEFT. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-07-2R.SDR AALA20130107005Frame · dentedFRAME DENTED AT SATTION 1440, STRINGER 26 LEFT. INSTALLED NESTED ANGLE REPAIR PER SRM 53-00-07-2R 5 FIG 201 DETAIL I.SDR ASOA2012122102715Frame · corrodedFS 605.00 FRAME SECTOR HAS CORRODED FRAME FLANGE FWD AND AFT SIDE BETWEEN STRINGERS 27L AND 26L. CORROSION IS OUT OF LIMITS IAW SRM 53-61-15- AND 53-00-00 T/R 53-27, FIG 102, SHEET 2. REPAIRED IAW REO 601R-53-61-4737.SDR WRLA20121210576Frame · crackedCRACK - DURING SPECIAL CHECK OF DATUM AIRCRAFT, EGAT MECHANIC FOUND CRACK ON FRAME (P/N: AGA7137-17) AT L-52, STATION 1975.SDR WRLA20121210575Frame · crackedCRACK - DURING SPECIAL CHECK OF DATUM AIRCRAFT, EGAT MECHANIC FOUND CRACK ON FRAME (P/N: AGA7129-3) BETWEEN L-51L AND L-52, STATION 1902.SDR WRLA20121210573Frame · crackedCRACK - DURING SPECIAL CHECK OF DATUM AIRCRAFT, EGAT MECHANIC FOUND CRACK ON FRAME (P/N: AGA7350-31) BETWEEN L-51R AND L-52, STATION 1887.SDR WRLA20121210570Frame · crackedCRACK - DURING SPECIAL CHECK OF DATUM AIRCRAFT, EGAT MECHANIC FOUND CRACK ON FRAME (P/N: AGA7125-3) BETWEEN L-49L AND L-49R, STATION 1841.SDR WRLA20121210568Frame · crackedCRACK - DURING SPECIAL CHECK OF DATUM AIRCRAFT, EGAT MECHANIC FOUND CRACK ON FRAME (P/N: AGA7351-31) BETWEEN L-51L AND L-52, STATION 1871.SDR WRLA20121210567Frame · crackedCRACK - DURING SPECIAL CHECK OF DATUM AIRCRAFT, EGAT MECHANIC FOUND CRACK ON FRAME (P/N: AGA0016-3) BETWEEN L-51R AND L-52, STATION 1853.SDR QXEA2012121001638Frame · corrodedFRAME 836.452 HAS A SPOT OF CORROSION AT FLOOR LEVEL ABOVE STRINGER 25S. REMOVED FASTENER FROM FRAME IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02 MIN REMAINING THICKNESS NOTE .038" CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801SDR QXEA2012121001635Doubler · corrodedFRAME 547, FLANGE DOUBLER ON FORWARD SIDE IS CORRODED STRINGER 23S-25S. REMOVED RIVETS AND REMOVED FLANGE DOUBLER IAW SRM 51-42-05-02-01. INSTALLED NEW DOUBLER IAW SRM 51-42-05-02-01. PRIMED AND TOP COATED IAW SRM 51-25-15-02-01. APPLIED CPC IAW AMM 51-25-01-3SDR DALA12015895653Frame · dentedDURING MX-CK, A DENT WAS FOUND IN THE STA 760 FRAME BETWEEN S-24R AND S-25R. THE DENT WAS REPAIRED IAW ER/A 508950-14.
Back to JASC 5311