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 USAA2009071091793Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500D BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009071091792Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 400 BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 400 BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009071091791Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 827 BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 827 BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009071091785Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 380 BETWEEN S20L TO S21L IAW US AIRWAYS TYPICAL REPAIR 53-60-07A.SDR UALA2009071001989Frame · crackedAFT CARGO FRAME HAS CRACKED WEB STA 1351, STR 24R- 25R. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF WEB, AND FABRICATED AND INSTALLED A REPAIR DOUBLER AND FILLER.SDR CALA2009071000366Frame · crackedFRAME CRACKED AT ATTACH BRACKET STATION 380 AT S-8L. REPAIRED FUSELAGE FRAME STATION 380 AT S-8L PER EC/RA 5310-04 974.SDR CALA2009071000365Frame · crackedFRAME CRACKED AT ATTACH BRACKET STATION 440 AT S-8R. REPAIRED FUSELAGE FRAME STATION 440 AT S-8R PER EC/RA 5310-04 974.SDR CALA2009071000364Frame · crackedFRAME CRACKED AT ATTACH BRACKET STATION 400 AT S-8R. REPAIRED FUSELAGE FRAME STATION 400 AT S-8R PER EC/RA 5310-04 974.SDR FDEA200907092549Frame · corrodedAT BS 1380, STR 24L TO 28L FRAME CORRODED. CORROSION ON AFT CARGO FRAME AT BS 1380 FOUND EXCEEDED SRM ALLOWABLE DAMAGE LIMITS. FRAME REPAIRED IAW SRM 53-00-07 REV. 97, REPAIR 5 FIG. 201. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR DLM88091242Support · corrodedAFT CARGO FS 1155 FRAME SUPPORT LONGERON 28 LEFT TO 29 LEFT CORRODED. REPAIRED SUPPORT IAW SRM 53-03.SDR AALA20090714TUL06Frame · crackedFRAME CRACKED FORWARD AND AFT SIDES AT LONGERON 2 LEFT. REPAIRED FRAME PER EA MD80-53-006722.SDR AALA20090714TUL05Frame · crackedFRAME CRACKED FORWARD SIDE AT LONGERON 2 RIGHT HAND. REPAIRED FRAME PER EA MD80-53-006722.SDR USAA2009071091790Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727D BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 727D BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR SWAA094342Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 947, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA094341Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR FDEA200907082531Failsafe · corrodedFOUND CORROSION ON LT FWD PAX DOOR 1 LOWER FAIL SAFE RING. REPAIR PERFORMED BY BLEND OUT THE CORROSION , NDT FOR CRACK FREE CONDITION IAW RAS 70520367/004/2009 ISS A , APPROVED BY EA 6-5310-131247.SDR FDEA200907082524Frame · damagedFOUND MISDRILLED FASTENER HOLE IN C 64, ADJACENT TO P44 LT REPAIR PERFORMED BY REAM UP THE HOLE IN FITTING AND INSTALLING A SHOULDERED BUSHING IAW RAS/EFW/9000206/2009 ISS. B, APPROVED BY EA 6-5310-129175.SDR 2009FA0000616Frame · corrodedOUT OF LIMITS CORROSION ON FUSELAGE FRAME AT BS 847 JUST ABOVE STRINGER 25 LT.SDR SWIA200922186Frame · corrodedCORROSION ON FRAME 23. (C CHECK) REPAIRED PER SRM.SDR IPXA09556739Frame · gougedINSPECTION TYPE: C2 MAIN CARGO DOOR BS 487 FRAME DOUBLER HAS A SCREW GOUGE G.S. INCHES DOWN FROM STR 14L. BLEND GOUGE OUT OF LIMITS IAW SRM 52-30-02-1A1, FABRICATED DOUBLER ALODINED, PRIMED AND INSTALLED IAW SRM 51-40-02-0G 51-20-01 AND DWG 65-25327.SDR WX0A070348Frame · crackedTHE FORMER THAT HELPS MAKE UP THE BULKHEAD AT STA 37 WAS FOUND CRACKED AT THE 4 O CLOCK RADOME ALIGNMENT PIN, REPAIRED AS REQUIRED.SDR USAA2009071091787Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 294, S17R. REPAIRED FUSELAGE FRAME AT BS 294, S17R IAW B737 SRM 51-70-11.SDR ASOA200900748Frame · crackedFRAME AT FS 319.00 FROM STR 0 TO STR 4R IS CRACKED. REMOVED DAMAGED FROM IAW SRM 51-42-06. INSTALLED NEW SERVICEABLE FRAME IAW SRM 51-42-06 AND 51-42-21 AND DRAWING 601R32003 REV P.SDR SWAA094321Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094318Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA094312Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 847, STR 27L TO STR 27R. REPAIRED FRAME PER AAR EA.SDR USAA2009071791873Frame · crackedCLT - Q4 - MAJOR REPAIR - NR 03-0553-8-0538/002 - CRACK ON FUSELAGE FRAME AT BS500D BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS500D BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13 & US AIRWAYS EA 101281.SDR USAA2009071691856Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FRAME AT BS 500F, S20L TO S21L. REPAIRED CRACK ON FRAME AT BS 500F, S20L TO S21L IAW B737 SRM 53-60-07 REPAIR 13.SDR USAA2009071391820Frame · crackedSAL - Q2 - MAJOR REPAIR - NR 03C20553006/009 - CRACK IN FUSELAGE FRAME AT BS380 BETWEEN S20L TO S22L. REPAIRED FUSELAGE FRAME AT BS380 BETWEEN S20L TO S22L IAW US AIRWAYS TYPICAL REPAIR 53-60-07A.SDR USAA2009071091794Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727B BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR FDEA200907062497Frame · damagedFRAME 41; LEFT SIDE AT STRINGER 35; HAS A DOUBLE DRILLED HOLE IN THE FOOT FITTING. COMPLIED WITH E.A. 6-5310-127976.SDR QXEA2009070700494Frame · corrodedPDX - MODIFICATION - FRAME CASTELLATION AT STA 54.0 BETWEEN STR 31P AND 32P HAS CORROSION FORMING AT 2 O/B RIVETS. DRILLED OUT 2 RIVETS. REMOVED CORROSION REF Q400 SRM 51-21-00. HFEC INSPECTED BLENDED AREAS FOR CRACKS IAW -8 400 NDTM PART 6, 51-00-01. NO CSDR USAA2009071091781Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 440 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 440 BETWEEN S8L TO S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR CALA2009070300360Frame · crackedFRAME CRACKED AT STA 400 BETWEEN S-8R AND S-9R AT PSU ATTACH MOUNT BRACKET. CRACKED FRAME REPAIRED REF ECRA 5310-04973.SDR CALA2009070300359Frame · crackedCABIN STA 787 FRAME CRACKED BETWEEN S-8R AND S-9R. CRACKED FRAME REPAIRED REF ECRA 5310-04973.SDR ASAA0946131Frame · crackedFRAME CRACKED AT STA 827 BETWEEN STR 8 AND 9 LT. REPAIRED FRAME IAW EA.SDR ASAA0946130Frame · crackedFRAME CRACKED AT STA 907 BETWEEN STR 8 AND 9 RT. REPAIRED FRAME IAW EA.SDR ASAA0946129Frame · crackedFRAME CRACKED AT STA 907 BETWEEN STR 8 AND 9 LT. REPAIRED FRAME AT STA 907 IAW EA.SDR ASAA0946128Frame · crackedFRAME CRACKED AT STA 787 BETWEEN STR 8 AND 9 LT. REPAIRED FRAME IAW EA.SDR ASAA0946117Frame · crackedFRAME CRACKED AT STA 400 BETWEEN STR 8L AND 9L. REPAIRED FRAME AT STA 400 LT.SDR ASAA0946116Frame · crackedFRAME CRACKED AT STA 747 BETWEEN STR 8R AND 9R. REPAIRED FRAME AT STA 747 RT.SDR ASAA0946115Frame · crackedFRAME CRACKED AT STA 827 BETWEEN STR 8R AND 9R. REPAIRED FRAME AT STA 827 RT.SDR ASAA0946113Frame · crackedFRAME CRACKED AT STA 747 BETWEEN STR 8L AND 9L. REPAIRED FRAME AT STA 747 LT.SDR USAA2009072791914Frame · crackedCLT - Q-4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 440 BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 440 BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR FDEA200907022678Frame · crackedFORWARD CARGO, STA 560, STR 21L - 22L, STUB FRAME EXTENSION CRACKED IN RADIUS. REMOVED CRACKED STUB FRAME EXTENSION AT FWD CARGO STA 560 S21-22L IAW SRM 51-30-2. HEAT TREATED STUB FRAME IAW FAS ENG REPORT 2-37153-801 REV A CW CONDUCTIVITY MEASUREMENT IAW NDTMSDR USAA2009071391819Frame · crackedSAL - Q2 - MAJOR REPAIR - NR 03C10753039/008 - CRACK IN FUSELAGE FRAME AT BS747 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS747 BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009071091783Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 440 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 440 BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009071091782Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727B BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8L TO S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009070991774Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR AALA20090703TUL20Frame · damagedDOUBLE DRILLED HOLE IN 1212 FRAME, RIGHT SIDE ABOVE STRINGER 18, BOTTOM HOLE OF UPPER HALF OF STRAP. INSTALLED FREEZE PLUG PER EA MD80-53-006681.
Back to JASC 5311