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 QXEA2012082000848Frame · corrodedCLEANED FRAME AND FLANGES IAW SRM 51-26-00-02-01. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. CORROSION FOUND OUT OF LIMITS IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .029", CONFIRMED AFFECTED AREA CRACKSDR QXEA2012082000840Frame · corrodedFRAME X1.0 FLANGES BETWEEN STRS 30S-33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED FOUR RIVETS AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. MIN REMAINING THICKNESS NOTED .045" REF NTM 51-00-04-910-801 PT 1. VERIFIED BLENDED AREAS TO BE CRSDR QXEA2012082000828Frame · corrodedFRAME X258, FLANGES BETWEEN STRS 25S-26S AND 28S-32S BUBBLING PAINT/PROBABLE CORROSION. CLEANED AREA IAW SRM 51-26-00-02-01. REMOVED 4 RIVETS, PAINT PRIMER AND CORROSION IAW SRM 51-42-05-02-01, AND 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .039" CONFIRMSDR AALA20120820010Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET, STATION 500A RIGHT. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120820009Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET, STATION 727D LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER J1159AD.SDR AALA20120820008Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET, STATION 480 RIGHT. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120820007Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL SUPPORT BRACKET, STATION 400 RIGHT. INSTALLED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120820006Frame · crackedFRAME CRACKED AT STATION 400 LEFT. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR FDEA201208203087Frame · gougedMAIN DECK CARGO LT SIDEWALL FR 73 GOUGES BETWEEN STGR 12 AND STGR 22 LT AT 12 PLACES. BLENDED GOUGES IAW SRM 51-73-10, PG 209. REPAIRED AREA 1 BY CUTTING OUT FRAME DAMAGE & INSTALLING REPAIR IAW SRM 53-10-13 F 202. SMOOTHED AREAS 2 THRU 12 IAW FSRM 51-73-10SDR SPUY20120820034Frame · deformedDURING ROUTINE C CHECK INSPECTION, FWD CARGO COMPT- FRAME DEFORMED BS 580 STR 25L REF NR 0798.SDR SPUY20120820033Frame · deformedDURING ROUTINE C CHECK INSPECTION, FWD CARGO COMPT FRAME DEFORMED BS 560 STR 25L REF NR 0797.SDR SPUY20120820032Frame · deformedDURING ROUTINE C CHECK INSPECTION, FWD CARGO COMPT FRAME DEFORMED, BS 540 STR 24L REF NR 0796.SDR SWAA2012082306921Frame · crackedFRAME CRACKED BS 747, STR 8R. REMOVED AND REPLACED FRAME IAW EA.SDR DALA1246849260Frame · crackedFOUND POSSIBLE CRACK AT FORWARD FRAME OF RIGHT MAIN LANDING GEAR WHEEL WELL OPENING. MAINTENANCE REMOVED AND REPLACED FRAME PER DAL DRAWING 5930584.SDR QXEA2012081800817Frame · corrodedFRAME X32.4, FLANGES, BETWEEN STRS 30S - 33 BUBBLING PAINT/PROBABLE CORROSION. REMOVED 17 RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .029 REF NTM 51-00-04-910-801 PT 1 AND RD 8/4-53-4708. VERIFIED FRAMESDR QXEA2012081800814Frame · corrodedFRAME 32.4 UPPER FLANGE IS CORRODED STR 30S -33. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801. MATERIAL LOSS FOUND TO BE IN LIMITS IAW RD 8/4-53-4708. ALODINED, PRIMED AND APPLIED ALUMINIZED PAINT ANSDR SIMA20120818001Frame · gougedDURING MAINTENANCE INSPECTION, FOUND FRAME 65 GOUGED IN 3 PLACES FROM STRINGER 2L TO 1L. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 65 IAW EO EM-53MR-2012. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA20120801010Frame · gougedDURING MAINTENANCE INSPECTION, FOUND FRAME 68 GOUGED AT STRINGER 1L. AIRCRAFT REMOVED FROM SERVICE. REPAIRED FRAME IAW AEA EO EM-53MR-2013. AIRCRAFT RETURNED TO SERVICE.SDR FDEA201208173043Frame · misrepairedFRAME AT CABIN BS 535, LONGERON 23 RT MISREPAIRED. REPAIRED AS PER SRM 53-30-00 FIGURE 13 VOLUME I REVISION 99. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 115.SDR FDEA201208173042Frame · misrepairedFRAME AT BS 535, LONGERON 19 LT MISREPAIRED. REPAIRED IAW SRM 53-30-00 FIGURE 14 VOLUME I REVISION 99. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 115.SDR QXEA2012081700850Frame · corrodedFRAME X604, FLANGES BETWEEN STRS 29S-32S BUBBLING PAINT/PROBABLE CORROSION. CLEANED AREA IAW SRM 51-26-00-02-01. REMOVED RIVETS AS NECESSARY, BLENDED CORROSION IAW RD 8/4-53-2344. REMOVED UPPER FRAME FLANGE IAW SRM 51-42-05-02-01 AND BLENDED CORROSION FROM SDR QXEA2012081700849Frame · corrodedFRAME X258, FLANGES BETWEEN STRS 27P-33 AND AT STR 24P, BUBBLING PAINT/PROBABLE CORROSION. REMOVED RIVETS, PAINT AND PRIMER IAW SRM 51-42-05-02-01 AND 51-26-10-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .027", CONFIRMED AFFECTESDR IPXA12B74922Frame · crackedINSPECTION TYPE: 1C, MAIN DECK LT BS 1265 FRAME ONE FASTENER HOLE FOUND CRACKED. REPAIRED IAW EO B747-5310-28006-C.SDR 2012F00169Frame · gougedDURING INSPECTION, A DRILL GOUGE DAMAGE WAS FOUND IN STATION 585, FRAME.SDR 2012F00168Frame · damagedDURING INSPECTION, RT STATION 817 FRAME WAS FOUND WITH DOUBLE-DRILLED HOLE FROM PREVIOUS INSTALLATION OF CARGO LINER.SDR AALA20120816015Frame · crackedCRACK INDICATION AT BRACKET ATTACH FRAME STATION 887 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120816014Frame · crackedCRACK INDICATION AT FRAME 787 LEFT BRACKET ATTACH. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120816012Frame · crackedFRAME CRACKED AT BRACKET ATTACH, STATION 380 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120816011Frame · crackedCRACK INDICATON AT BRACKET ATTACH, FRAME STATION 747. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120816010Frame · crackedCRACK INDICATION AT BRACKET ATTACH STATION 727 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR FDEA201208153010Frame · chafedFRAME AT BS 1280 CHAFED AT STR 13 L. REPAIRED IAW SRM 53-00-07 REPAIR 3, FIG. 201, REV.106. REPAIR IS MAJOR.SDR FDEA201208153008Frame · chafedCABIN BS 1280 FRAME CHAFED AT STR 12 L. REPAIRED IAW SRM 53-00-07 REPAIR 3, FIG. 201, REV.106. REPAIR IS MAJOR.SDR FDEA201208153007Frame · chafedBS 1280 FRAME CHAFED AT S11L. REPAIRED IAW SRM 53-00-07, REV 106, REPAIR 3, FIG 201. REPAIR IS MAJOR.SDR USAA2012082000017Frame · crackedFPBH CHECK - CRACK IN FUSELAGE FRAME AT BS 500C BETWEEN S20R & S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R & S21R IAW EA 203203 & B373 SRM 53-00-07, REPAIR 13.SDR CALA2012081700511Frame · crackedFRAME BS 907, CRACKED AT FASTENER, RADIUS GOOD. REPAIRED IAW ECRA5310-05570.SDR CALA2012081700510Frame · crackedFRAME BS 907, CRACKED AT BRACKET FASTENER RADIUS GOOD. REPAIRED FRAME AT 907 IAW ECRA 5310-0557.SDR CALA2012081700509Frame · crackedFRAME BS 827, CRACKED AT BRACKET FASTENER. RADIUS GOOD. ALL WORK COMPLETE.SDR FDEA201208142975Frame · crackedONE CRACK (2MM) WAS FOUND AT FRAME 44 RT HOLE "B" AREA INBD DIRECTION. REPAIRED IAW EO E6-5310-7-5006.SDR SWIA201231658Frame · crackedFUSELAGE FRAME 13 HAS TWO CRACKS AT UPPER DV WINDOW SEAL HEIGHT. (C-CHECK) REPAIRED FUSELAGE FRAME 13 UPPER DV WINDOW SEAL HEIGHT IN REFERENCE TO EMB ETD AND EMB SRM.SDR QXEA2012081400809Frame · corrodedFRAME X401, FLANGES BETWEEN STRINGERS 30S-33 CORRODED. BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .057" CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND WITHIN LIMITS IAW RD 8SDR SWAA2012082006842Frame · crackedFRAME CRACKED AT BS 1040, WL 306 TOP OF CROWN. REMOVED & REPLACED FRAME IAW SRM.SDR QXEA2012081400804Frame · corrodedFRAME X94.8, FLANGES BETWEEN STRINGERS 25P-33, BUBBLING PAINT PROBABLE CORROSION. REMOVED FRAME FLANGE FOM REF RD 8/4-53-017 AND REMOVED CORROSION IAW SRM 51-21-00-00-02. REMAINING THICKNESS .0395 REF NTM 51-00-04-910-801 PT 1. VERIFIED AREA CRACK FREE RESDR QXEA2012081400801Frame · corrodedCORROSION ON FRAME -54.0 BETWEEN STR 29P AND 30P. REMOVED CORROSION IAW SRM 51-21-00-00-02. REMAINING THICKNESS NOTED .038 REF NTM 51-00-04-910-801 PT 1. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. DAMAGE AREA IS WITHIN LIMITS IAW RDSDR AALA20120814016Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500F LEFT HAS A CRACK INDICATION. INSTALLED REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120814015Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 380 RIGHT HAS A CRACK INDICATION. INSTALLED REPAIRED ANGLE PER ECO J1159AD.SDR AALA20120814014Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 400 LEFT HAS A CRACK INDICATION. INSTALLED REPAIR PER ECO J1159AD.SDR AALA20120814013Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500A LEFT HAS A CRACK INDICATION. INSTALLED REPAIR ANGLE PER ECO J1159AD CARD 0007.SDR AALA20120814012Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500 H LEFT HAS A CRACK INDICATION. INSTALLED REPAIR ANGLER PER ECO J1159AD CARD 0006.SDR AALA20120814011Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500CR SHOWS CRACK INDICATION. INSTALLED REPAIR ANGLE PER ECO J1159AD CARD 0007.SDR AALA20120814010Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 500AR SHOWS CRACK INDICATION. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0007.
Back to JASC 5311