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 DALA1222099259Frame · corrodedDURING HMV, FOUND FRAME BS 1364 HAS SURFACE CORROSION BETWEEN RBL 29 AND LBL 29. REPLACE DAMAGED FRAME SECTION IAW SRM 53-10-02 FIG 2.SDR SIMA20120408010Frame · damagedFRAME DAMAGED. REPAIRED FRAME 68 LT HALF IAW EO EM-53MR-1590, PART B.SDR SIMA20120408009Frame · corrodedCARGO BAY FRAME 68 IS CORRODED AT LOWER END. REPAIRED FRAME 68 IAW AE EO EM-53MR-1129, PART B.SDR SIMA20120408008Frame · corrodedDURING HEAVY CHECK, FOUND CARGO FRAME 65 CORRODED AT LOWER END. REPAIRED FRAME IAW AE EO EM-53MR-1129, PART A.SDR ASAA12511352Frame · wornFRAME LOWER CHORD STA 727 +2, WORN WHEEL WELL AFT LOWER. REF SRM 53-60-71 DETERMINED DAMAGE FRAME TO EXCEED ALLOWABLE DAMAGE LIMITS. REMOVED AND REPLACED FRAME LOWER CHORD PER 53-40-07.SDR DALA1221210678Frame · corrodedBULK CARGO COMPARTMENT FRAME CORRODED BS 1480, STR 25-27L. REPAIRED FRAME IAW SRM 53-00-07 FIG 201.SDR UHLA2012040700149Frame · damagedMAJOR REPAIR - MIS-DRILLED HOLE IN FR10 AT STR 27L MEASURING 0.341". PERFORMED BUSHING REPAIR TO FR10 AND LEFT NLG BAY SPAR AND INSTALLED ORIGINAL EQUIPMENT FASTENER IAW ETD 2012-170-005008, CONFIRMED BUSHING MANUFACTURED TO SPECS STATED IN ETD 2012-170-0050SDR DALA1221151606Frame · crackedCABIN LEFT BS 903 BETWEEN S20L & 20R FRAME INNER CHORD CRACKED. REPAIRED AS PER ERA 500356-14AD REV ORG.SDR DALA1221080678Frame · bentFORWARD CARGO BAY FRAME BENT BS 620 STR 26L-27L. REPAIRED IAW SRM 53-00-07 FIG 201.SDR DALA1221070678Frame · dentedCARGO BAY FRAME DENTED BS 1560 STR 26L. FRAME REPAIRED IAW SRM 53-00-07 FIG 201.SDR DALA1221060678Frame · dentedCARGO BAY FRAME DENTED FS 1580 STR 25 - 26R. REPAIRED IAW SRM 53-00-07 FIG 201.SDR DALA1221050678Frame · dentedCARGO FRAME DENTED BS 1520 STR 25 - 27L. REPAIRED IAW SRM 53-00-07 FIG 201 DETAIL 3.SDR DALA1221021501Frame · crackedMID BS 903 S20 - 21L FRAME INNER CHORD CRACKED.SDR USAA2012052400020Frame · crackedQ1 CHECK - CRACK IN FUSELAGE FRAME AT FASTENER HOLE AT BS 907 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 907 BETWEEN S8L TO S9L IAW TYPICAL REPAIR TR737-5310-10-0287.SDR DALA1227841501Frame · crackedBS 903 STR 20L-21L FRAME INNER CHORD CRACKED. REPAIRED PER ERA 501534-14AD REV ORIG SECT 1.SDR DALA1220956901Frame · damagedWHILE ACCOMPLISHING OPN 50321AD, MTC FOUND THAT SEVERAL FASTENER HOLES WHERE OVERSIZED AND 1/8 BLIND FASTENERS WERE PREVIOUSLY INSTALLED. THESE FASTENERS ARE BEYOND THE REQUIREMENTS OF AD 2002-24-02. ACCOMPLISHED PERMANENT REPAIR PER ERA 501775-14 REV 2 TO RSDR DALA1220940678Frame · dentedCARGO BAY FRAME DENTED BS 1500, STR 23-24L. REPAIRED IAW SRM 53-00-07 FIG 201 DETAIL 3.SDR AALA20120406007Frame · crackedHIGH FREQUENCY EDDY CURRENT SHOWS POSITIVE CRACK INDICATION IN FRAME AT BIN SUPPORT RAIL BRACKET STATION 500C RIGHT BETWEEN STRINGERS 8 AND 9 RIGHT. INSTALLED REPAIR ANGLE PER ECO J1159AD-006.SDR AALA20120406006Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT BIN SUPPORT RAIL BRACKET STATION 480 RIGHT. INSTALLED REPAIR DOUBLER ON FRAME AT RIGHT BIN SUPPORT RAIL BRACKET STATION 480R PER ECO J1159AD-006.SDR AALA20120406005Frame · crackedFRAME AT STATION 480, VISUAL INDICATION OF CRACK AT LEFT BIN RAIL ATTACH BRACKET LOCATION. COMPLETED DOUBLER REPAIR AT STATION 480L FRAME PER ECO J1159AD.SDR SWAA03183Frame · damagedFRAME DAMAGED AT BS 220, STR 24R. REPAIRED FRAME IAW ER AND EA.SDR SWAA2012041703183Frame · damagedFRAME DAMAGED AT BS 220, STR 24R. REPAIRED FRAME IAW ER AND EA.SDR QXEA2012040500267Frame · corrodedFRAME X1.00 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29S AND 30S. CLEANED FRAME FLANGE, FOUND NO CORROSION IAW Q400 AMM 51-27-01-110-801. ALONDINED, PRIMED AND TOPCOATED IAW SRM 51-25-15-02-01. APPLIED CPC IAW AMM 51-25-01-390-801.SDR DALA1220630673Frame · dentedFWD PIT LT FRAME REPAIR MISSING FASTENER, DENT UNDERNEATH NOT ADDRESSED BS 580, STR 26L- STR 27L FAA FINDING DURING AAI INSPECTION. REMOVED REPAIR ANGLE IAW SRM 51-40-02. CUT OUT DENT DAMAGE TO FRAME IAW SRM 53-00-07, REPAIR 5. HFEC INSPECTION PERFORMED IAWSDR AALA20120404021Frame · crackedRIGHT AIR CONDITION SUPPORT FRAME IS CRACKED AT ATTACH FITTING AT STATION 500A. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR AALA20120404019Frame · crackedRIGHT AIR CONDITION SUPPORT FRAME IS CRACKED AT ATTACH FITTING AT STATION 727D. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR AALA20120404018Frame · crackedRIGHT AIR CONDITION SUPPORT FRAME IS CRACKED AT ATTACH FITTING AT STATION 727B. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR AALA20120404017Frame · crackedRIGHT AIR CONDITION SUPPORT FRAME IS CRACKED AT FITTING ATTACH AT BS 400R. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR AALA20120404016Frame · crackedRIGHT AIR CONDITION SUPPORT FRAME IS CRACKED AT FITTING ATTACH AT BS 440R. REMOVED THE DAMAGE AND INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR CALA2012040400230Frame · crackedFRAME IS CRACKED AT BS 440 BETWEEN S-8R AND S-9R. REPAIRED PER EA 5310-04716 REV C.SDR CALA2012040400229Frame · crackedFRAME IS CRACKED AT BS 727B BETWEEN S-8L AND S9-L. COMPLETED REPAIRED FRAME AT BS 727B STRINGER 8L-9L REF ECRA 5310-04716 REV C.SDR FDEA201204041246Frame · dentedAFT LOWER CARGO BAY FRAME, BS 1540 STRINGER 26L UPPER FLANGE DENTED. REPAIRED IAW SRM 53-00-07, FIG.201, DETAIL I, REPAIR 5, REV 106 AND EA F-5310-155882 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR CHQA20120403122Frame · crackedDURING INSPECTION, THE LEFT AND RIGHT FRAME 10 WERE FOUND TO BE CRACKED. THE LEFT AND RIGHT FRAME 10 WERE REPLACED AND INSTALLED WITH SOLID RIVETS IN ACCORDANCE WITH SRM 51-40-02.SDR CHQA20120403121Frame · crackedDURING INSPECTION, THE LEFT AND RIGHT FRAME 10 WERE FOUND TO BE CRACKED. THE LEFT AND RIGHT FRAME 10 WERE REPLACED AND INSTALLED WITH SOLID RIVETS IN ACCORDANCE WITH SRM 51-40-02.SDR SWAA2012041603127Frame · crackedFRAME CRACKED AT BS 953, BETWEEN STR 11L TO STR 7L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012041603122Frame · crackedFRAME CRACKED AT BS 492, STR 25R. REPAIRED FRAME PER EA.SDR ASOA201201154Frame · corrodedFS 364 FRAME CORRODED BETWEEN LBL 26 AND RBL 26.SDR AALA20120403019Frame · crackedCRACK IN FRAME 727B LEFT AT AIR CONDITIONING SUPPORT RAIL. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120403018Frame · crackedCRACK IN FRAME 500D LEFT AT AIR CONDITIONING SUPPORT RAIL. INSTALLED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120403017Frame · crackedCRACK IN FRAME 480L AT AIR CONDITIONING SUPPORT RAIL. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120403016Frame · crackedCRACK IN FRAME 440L AT AIR CONDITIONING SUPPORT RAIL. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120403015Frame · crackedCRACK IN FRAME 400L AT AIR CONDITIONING SUPPORT RAIL. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR CALA2012040400228Frame · crackedFRAME IS CRACKED AT STA 440L BETWEEN S-8L AND S-9L. REMOVED SUPPORT BRACKET, CUT OUT DAMAGE, NDT AREA, FABRICATED REPAIR ANGLES A&B TREATED & PRIMED, COLD WORKED 6 HOLES & INSTALLED, INSTALLED SUPPORT BRACKET, APPLIED FILLET SEAL REF EA 5310-04716 REV C FIG 3SDR CALA2012040400227Frame · crackedFRAME IS CRACKED AT BS 500C BETWEEN S-8L AND S9L. FABRICATED AND INSTALLED REPAIR ANGLES A, B COLD WORKED HOLES, REF EA 5310-04716 REV C OPERATION 02.SDR CALA2012040400226Frame · crackedFRAME IS CRACKED AT BS 480L BETWEEN STR 8L AND 9L. REPAIRED PER EA 5310-04716 REV C OP 2.SDR AALA20120403014Frame · crackedCRACK IN FRAME 380 LEFT AT AIR CONDITIONING SUPPORT RAIL. INSTALLED REPAIR ANGLE PER ECO J1159AD.SDR DALA1229160926Frame · corrodedAFT CARGO COMPT FRAME CORRODED ON FRONT AT FS 1309 LONGERON 23R-22R. REMOVED CORROSION, MATERIAL LOSS OUT OF LIMITS. REMOVED GUSSET AND REPLACED IAW SRM 51-30-2.SDR IPXA2573175Frame · gougedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT FRAME GOUGED ON INBD FREE FLANGE STA 345 BETWEEN STRINGER 15R AND 16R. FABRICATED AND INSTALLED REPAIR DOUBLER IAW EA 120547IR AND EO B757-5 310-46849-A.SDR IPXA2573136Frame · damagedINSPECTION TYPE:C-CK, FORWARD CARGO COMPATMENT BS 660, STRINGER 23R AND 24R, INNER CORD OF FRAME DAMAGED. TRIMMED OUT DAMAGE. FABRICATED AND INSTALLED REPAIR IAW EA120515 IR AND EO B757-5310-46820-A.SDR IPXA12572989Frame · crackedINSPECTION TYPE: C, FORWARD CARGO COMPARTMENT BS 820, S22L FRAME CRACKED AND DENTED. CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 53-00-07-2R 5, REPAIR 5, DETAIL II.
Back to JASC 5311