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 SWAA2012062605349Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012062605348Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012062605347Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012062605294Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR DALA12001926302Frame · damagedDURING INSPECTION FOUND UPPER LEG OF FRAME DAMAGED BS 570 FORWARD CARGO APPROX 2 FT INBOARD OF THE DOOR OPENING. MAINTENANCE CUTOUT DAMAGE AND REPAIRED PARTS PER SRM 51-70-11 FIG 1.SDR ASOA2012070901876Frame · corrodedFRAME AT FS 364.00 IS HEAVILY CORRODED. REMOVED FS 364.00 FRAME IAW SRM 51-42-06 AND 51-42-21. DRILLED UP NEW FRAME IAW SRM 51-40-11. INSTALLED NEW FRAME IAW SRM 51-42-06 & 51-41-21.SDR ASOA2012070201849Frame · corrodedFRAME AT FS 33.00 HEAVILY CORRODED. REMOVED AND REPLACED FRAME SECTION IAW SRM 51-42-06 & 51-42-21.SDR AALA20120620005Frame · crackedFRAME CRACKED AT BIN BRACKET ATTACH FASTENER HOLES AT STATION 440R. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120620004Frame · crackedFRAME CRACKED AT BIN BRACKET ATTACH FASTENER HOLES AT STATION 400R. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120618015Frame · crackedFRAME CRACKED AT BIN BRACKET ATTACH FASTENER HOLES AT STATION 480R. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR SWAA2012071705910Frame · crackedFRAME WEB CRACKED AT STA 727, LBL 60. REPAIRED WEB IAW EA AND AAR EA.SDR SWAA2012070905675Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012070905674Frame · crackedFRAME CRACKED AT BS 380, BETWEEN STR 8L AND STR 7L. REPAIRED FRAME IAW EA.SDR MASA2012061834903Frame · corrodedFRAME HAS TWO AREAS OF CORROSION ON FS 319.70 BETWEEN STRINGERS 28L - 26R. PERFORMED A MAJOR REPAIR TO FRAME.SDR QXEA2012061600580Frame · corrodedFUSELAGE FRAME X71.200 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29P AND 31P. REMOVED RIVETS FOM AND REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED HFEC OF BLENDS FOR CRACKS IAW NTM 51-00-06-910-801 PART 1, NO CRACKS NOTED. MATERIAL LOSS FOUND WITHIN LSDR AALA20120616006Frame · crackedFRAME CRACKED AT STATION 500C LEFT SIDE AT AC RAIL ATTACH BRACKET. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR MASA2012061834901Frame · corrodedFS 333 FRAME SECTOR CORRODED BETWEEN STRINGERS 25L AND 25R. PERFORMED A MAJOR REPAIR,SDR AALA20120615016Frame · crackedFRAMED CRACKED AT ATTACH BRACKET INBOARD RIVET BETWEEN STRINGERS 8 AND 9 RIGHT AT STATION 440. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR QXEA2012061500486Frame · corrodedFUSELAGE FRAME X258.500 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED RIVETS FOM AND REMOVED CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUNSDR QXEA2012061500485Frame · corrodedFUSELAGE FRAME X258.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED 4 RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND WITHIN LIMITS IAW SDR QXEA2012061500484Frame · corrodedFUSELAGE FRAME X196.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED 11 RIVETS AND CORROSION IAW 8/4-53-2344. CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND WITHIN LIMITS IAW 8/4-53-234SDR QXEA2012061500483Frame · corrodedFUSELAGE FRAME X196.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED 11 RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE IN LIMITS IAW RDSDR QXEA2012061500477Frame · corrodedFUSELAGE FRAME X94.800 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED RIVETS FOM IAW RD 8/4-53-2344. REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED HFEC ON BLENDS FOR CRACKS IAW NTM 51-00-06910-801 PT 1, NO CRACKS NOTED. PERFORMED UT THSDR AALA20120615008Frame · crackedFRAMED CRACKED AT ATTACH BRACKET BETWEEN STRINGERS 8 AND 9 RIGHT AND STATION 400 RIGHT CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR QXEA2012061500464Frame · corrodedFUSELAGE FRAME X136.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30P AND 31P. REMOVED RIVETS AND DUCT FOM IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-01-250-801 PT 6. MIN REMAINING THICKNESS .039". CONFIRMED CRACK FREE REF NTM 51-00-04SDR DALA1244700927Frame · damagedCORROSION ON FRAME UPPER AND LOWER SURFACE BOTH SIDES INTERNAL BILGE AREA AT BS 1271, L27R AND FOUND OUT OF LIMITS. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW SRM 53-05.SDR QXEA2012061400504Frame · corrodedFUSELAGE FRAME X32.400 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29P AND 32P. REMOVED 13 RIVETS FOM IAW 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02 AND RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801. MATERIAL LOSS FOUND IN LISDR QXEA2012061400476Frame · corrodedFUSELAGE FRAME X49.500 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29P AND 32P. REMOVED RIVETS FOM IAW RD 8/4-53-2344. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FSDR QXEA2012061400475Frame · corrodedFUSELAGE FRAME X19.400 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30P AND 33. REMOVED RIVETS FOM IAW RD 8/4-53-2344. REMOVED CORROSION IAW RD 8/4-53-2344 AND SRM 51-21-00-00-02. CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 SDR QXEA2012061400460Frame · corrodedFUSELAGE FRAME X94.800 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 28S AND 32S. REMOVED RIVETS FOM IAW SRM 51-21-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. PERFORMED HFEC OF BLENDS FOR CRACKS IAW NTM 51-00-06-910-801, PT 1. NO CRACKS NOTED. PERFSDR AALA20120614021Beltframe · crackedBELT FRAME CRACKED AT SUPPORT FOR RIGHT AIR CONDITIONING RAIL STATION 400. INSTALLED FRAME REPAIR PER ECO J1159AD.SDR AALA20120614008Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 480R. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120614007Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 440R. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120614006Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 400R. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR USAA2012070900042Frame · crackedQ1 CHECK - CRACK ON FUSELAGE FRAME AT BS 980, S7L. REPAIRED FUSELAGE FRAME AT BS 980, S7L IAW B737 SRM 53-00-07-2R-1 FIG 201.SDR SWAA2012062505187Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012062505186Frame · corrodedFRAME CORROED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012062105124Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012062005098Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR QXEA2012061300478Frame · corrodedFUSELAGE FRAME X116.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED 5 RIVETS AND CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA TO BE CRACK FREE REF NTM 51-00-01-250-801 PT 6. PERFORMED UT THICKNESS OF BLEND IAW NTM 51-00-04-910-801 PT 1SDR AALA20120613007Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 727B STRINGER 9 LEFT. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120613006Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 727B STRINGER 9 RIGHT. INSTALLED DOUBLER ANGLES PER ECO J1159AD.SDR UALA2012061303252Frame · corrodedBULK CARGO PIT LOWER FRAME CORRODED AT BS 1701 BL 0. MANUFACTURED & INSTALLED NEW FRAME REF SRM 53-60-07, 51-20-01, & BACO DWG 146N1032.SDR EE4Y2012102300309Frame · crackedUPPER FUSELAGE AT YSTA 699 CARGO DECK WHEEL WELL FRAME RT FWD FITTING LOWER POCKET AFT FACE LOWER FLANGE AND INBD RADIUS CRAKED. REPLACED MAIN CARGO WHEEL WELL FRAME FITTING AT BS 699 RT SIDE IAW S/B 53-131, OPTION 2, FIG 3, REV 4.SDR QXEA2012061200481Frame · corrodedFUSELAGE FRAME X176.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED RIVETS IAW RD 8/4-53-2344. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE WSDR QXEA2012061200480Frame · corrodedFUSELAGE FRAME X155.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 33. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREAS TO BE CRACK FREE REF NTM 51-00-01-250-801. MATERIAL LOSS FOUND TO BE IN LIMITS SDR QXEA2012061200479Frame · corrodedFUSELAGE FRAME X156.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOSDR AALA20120618014Frame · crackedFRAME 440, LEFT SIDE OF CABIN CRACKED BETWEEN STRINGERS 8 AND 9 LEFT AT BIN ATTACH BRACKET. INSTALLED DOUBLER PER ECO J1159AD CARD 0006.SDR AALA20120618013Frame · crackedFRAME 400, LEFT SIDE OF CABIN CRACKED BETWEEN STRINGERS 8 AND 9 LEFT AT BIN ATTACH BRACKET. INSTALLED DOUBLER PER ECO J1159AD CARD 0006.SDR FDEA201206122223Frame · dentedFRAME DENTED AT BS 1280, STR 26L AFT CARGO BAY. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1028, BS 1280 BETWEEN S-25L TO S-25R. MAJOR REPAIR.
Back to JASC 5311