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 AALA20120712024Frame · crackedTHE RIGHT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT INBOARD FASTENER AT STATION 500A. INSTALLED REPAIR ANGLES PER ECO J1159AD.SDR QXEA2012071200655Frame · corrodedFRAME X94.800, LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 29P AND 33. REMOVED RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .035 REF NTM 51-00-04-910-801 PT 1. CONFIRMED CRACK FREE CONDITION REF NTM 51SDR QXEA2012071200651Frame · corrodedFRAME X196.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED 5 RIVETS AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. FOUND CRACKS IN LOWER FLANGE, CUT AND FABRICATED ANGLE IAW SRM 53-10-15-02-01. FABRICATED ANGLE OUT OSDR HNAA2012071200856Frame · corrodedMINOR CORROSION AT BOTTOM OF VERTICAL FRAME MEMBER AT STA X510.00 BETWEEN STR 32S AND 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED, PRIMED AREA IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071200855Frame · corrodedCORROSION AT FRAME LEG STA X531.5 BETWEEN STR 32S AND 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED, PRIMED AREA IAW SRM 51-20-16, 51-20-36.SDR USAA2012081000004Frame · corrodedQ2 CHECK - FUSELAGE FRAME CORRODED AT BS 847 BETWEEN S25R AND S27R. REPAIRED FRAME IAW EA 104164.SDR SWAA2012080706573Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR DALA1244470699Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED BS 1460 STR 26-27L. REPAIRED IAW SRM 53-00-07 FIG 201 DETAIL III.SDR SWAA2012073006349Frame · crackedFRAME CRACKED AT BS 727E, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA2012073006339Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR FDEA201207112544Frame · corrodedBS 1460, STR 27R CORROSION ON FRAME REMOVED CORROSION IAW SRM 51-10-02. BLENDED AREA ORIGINAL MATERIAL .063 MATERIAL REMAINING .040 D=.023. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, ALLOWABLE DAMAGE 2. R & R FRAME STA 1460, S-25R TO S-25L IAW SRMSDR QXEA2012071100640Frame · corrodedFRAME X176.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGER 27P AND 28P. REMOVED RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .039", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06SDR QXEA2012071100639Frame · corrodedFRAME X 32.400 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED RIVETS IAW SRM 51-42-05-02-0-1. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .039", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 AND 51-00SDR CALA2012071200446Frame · crackedDURING INSPECTION OF OP4, NOTICED FRAME 500C RT CRACKED AND NO REPAIR WAS PERFORMED. VISUAL INSPECTION SHOWS RIVET CLOSEST TO RADIUS HAS 2 CRACKS. REPAIRED IAW EA 5330-04716, REV C, OP 1.SDR FDEA201207102534Frame · misrepairedEXISTING FRAME REPAIR AT BS 1360, S26R MISREPAIRED R & R FRAME AND FAILSAFE IAW SRM 51-40-02, AND DWG 146N1009 AND 146N1028. MAJOR REPAIR.SDR CALA2012071000439Frame · crackedCRACK IN FRAME AT BS 727D, STRINGER 8-9L. REPAIRED FRAME IAW EA 5310-04716, FIG 3, REV C. OP1.SDR CALA2012071000440Frame · crackedCRACK IN FRAME AT BS 787 LT STRINGER 8-9L. REPAIRED FRAME IAW EA 5310-04716, REV C, OP 1.SDR QXEA2012071000687Frame · corrodedFRAME X258.500 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31S AND 33. REMOVED 10 RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .038" REF NTM 51-00-04-910-801 PT 1. CONFIRMED AFFECTED AREA CRACK FSDR QXEA2012071000637Frame · corrodedFRAME 32.400, LOWER FLANGE HAVE CORROSION BETWEEN STRINGERS 30S AND 29S. REMOVED RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .038", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910SDR QXEA2012071000635Frame · corrodedFRAME BS 258.5 FLANGES HAVE CORROSION BETWEEN STRINGER 31 AND 33 PORT. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .039" REF NTM 51-00-04-910-801 PT 1. CONFIRMED CRACK FREE CONDITION OF AFFECTED AREA REF NTM 51-00-06-910-801 PT 1. MASDR DALA1241179264Frame · crackedRT AFT CABIN FUSELAGE FRAME TIE CRACKED AT STA 1364 L15R TO L16R. REMOVED AND REPLACED FORMER FROM RT AFT CABIN FUSELAGE AND BULKHEAD WEB AT BS 1364 BETWEEN LONGERONS L13R-L16R IN REF WITH SRM 51-30-05, 51-30-03 VOL II AND DRAWING NR 9912243.SDR QXEA2012071000632Frame · corrodedFRAME X258.500 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 27P AND 29P. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. CONFIRMED AFFECTED AREA CRACK FREE, MIN REMAINING THICKNESS .039" REF NTM 51-00-06-910-801 AND 51-00-04-910-801 PT 1. MATERIAL LOSS FSDR DALA1241189264Frame · crackedLT CABIN FUSELAGE FRAME CRACKED AT BS 1364 L15L TO L16L. REMOVED AND REPLACED FRAME BS 1364 BETWEEN L13L-L16L IN REF WITH SRM 51-30-05, 51-30-03 VOL II AND DRAWING 9912243.SDR CALA2012071000442Frame · crackedCRACK IN FRAME AT STA 867 LT STRINGER 8L-9L. REPAIRED FRAME REF EA 5310-04716.SDR CALA2012071000441Frame · crackedCRACK IN FRAME AT STA 747L, STRINGER 8L-9L FWD RIVET REPAIRED REF EA 5310-0716, REV C, OP 1.SDR ASOA2012071901939Frame · corrodedCORROSION ON FS 349 FRAME FROM STRINGERS 24-26 RIGHT. BLENDED CORROSION AND FOUND FRAME TO BE OUT OF LIMITS REF SRM 51-21-06-001-001 & SRM 53-21-06-101-006. REMOVED FRAME IAW SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01. LOCATED AND DRILLED NEW FRAMESDR USAA2012071300006Frame · crackedCDFI, FUSELAGE FRAME CRACKED AT BS 500B BETWEEN S19L AND S20L. REPAIRED FRAME IAW B737 SRM 53-00-07-2R, REPAIR 13.SDR QXEA2012070900628Frame · corrodedFRAME BS 301.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039 REF NTM 51-00-04-910-801 PT 1. CONFIRMED BLENDED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. BLENDSDR QXEA2012070900627Frame · corrodedFRAME 301 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 32P AND 33. REMOVED FASTENERS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .038 REF NTM 51-00-04-910-801 PT 1. BLENDED AREA CONFIRMED CRACK FREE REF NTM 51-00-06-910-801 PT 1. BLEND WITSDR QXEA2012070900613Frame · corrodedFRAME X19.400 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .037 REF NTM 51-00-04-910-801 PT 1. VERIFIED LOWER FLANGES TO BE CRACK FREE USING HFEC AND NTM 51-00-06-910-801 PT 1.SDR FDEA201207092522Frame · dentedFRAME IS DENTED AND HOLE IS OVERSIZED AT STA 418 S-3L. REPAIR ACCOMPLISHEDSDR FDEA201207092521Frame · damagedFRAME HAS OVERSIZED HOLES AT BS 395 BETWEEN S-2R TO S-3R. REPAIR ACCOMPLISHED.SDR USAA2012072400032Frame · crackedQ1 CHECK - 2 CRACKS AT FASTENER HOLES ON AFT FRAME OF AFT CARGO DOOR OPENING AT BS 847 BETWEEN S23R & S24R. REPLACED AFT FRAME OF AFT CARGO DOOR OPENING IAW B737-400 SRM 51-40-02-0G FIG 8 & 12.SDR CALA2012070900436Frame · crackedCRACK IN FRAME AT STA 400R STRINGER 8L-9L. COMPLETE REPAIR IAW EA 5310-04716.SDR CALA2012070900435Frame · crackedCRACK IN FRAME AT STATION 500C LEFT. REPAIRED FRAME IAW EA 5310-04716.SDR CALA2012070900434Frame · crackedCRACK IN FRAME AT STA 500 AL, STRINGER 8L - 9L INSTALLED REPAIR REF EA 5310-04716, REV C.SDR CALA2012070900438Frame · crackedCRACK IN FRAME AT STA 500A RT STRINGER 8L-9L FWD RIVET INDICATION. INSTALLED REPAIR IAW EA 5310-04716, REV C.SDR CALA2012070900437Frame · crackedCRACK IN FRAME AT STA 440 R STRINGER 8L-9L FWD RIVET. COMPLETED REPAIR IAW EA 5310-04716.SDR CALA2012070900433Frame · crackedCRACK IN FRAME AT STATION 400 LEFT. REPAIRED FRAME IAW EA 5310-04716.SDR SWAA2012080706509Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012080706508Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012080306455Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012073006309Frame · crackedFRAME CRACKED AT BS 188, BETWEEN STR 17L TO STR 18L. REPAIRED FRAME IAW SRM.SDR SWAA2012072606205Frame · crackedSTUB FRAME CRACKED AT BS 951, STR 17R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201207062500Frame · misrepairedFRAME AT BS 1500, STR 23 - 26R, MISREPAIRED. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR SWAA2012080706507Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012073106369Frame · crackedFRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME IAW SRM.SDR U2RA201207120002Frame · crackedUPPER DECK BS 1200, STRINGER 5 TO 6R FRAME DOUBLER CRACKED. REF AD 2007-23-18, SB 747-53A2507, CRACK LENGTH .13".SDR QXEA2012070600600Frame · corrodedFRAME X32.400 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED RIVET FOM AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .039" REF NTM 51-00-04-910-801 PT 1. CONFIRMED AFFECTED AREA CRACK FRESDR FDEA201207062504Frame · misrepairedFRAME MISREPAIRED AT BS 1520, STR 23R-26R. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1017. CLASSIFIED AS A MAJOR REPAIR.
Back to JASC 5311