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 2009FA0000604Frame Splice · corrodedOUT OF LIMITS CORROSION ON FRAME SPLICE BS 986.5 BETWEEN STRINGERS 24 - 25 RT.SDR USAA2009070291656Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500B, S20R. REPAIRED FUSELAGE FRAME AT BS 500B, S20R IAW SRM 53-00-07 REPAIR 13.SDR SWAA094251Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 827, STR 27L TO STR 27R. REPAIRED FRAME PER SRM & EA.SDR SWAA094240Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094239Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA094238Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094237Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA094236Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWIA200922328Frame · corrodedFS 513 FRAME CORRODED. (C CHECK) REPAIRED PER REO.SDR ASAA0996078Frame · corrodedCORROSION ON FRAME IN AFT CARGO BAY BS 787 STR 26R TO 27R. REPAIRED FRAME.SDR EE4Y090181Frame · damagedLOWER FUSELAGE AT BS 219.8, RBL 17.5 FRAME OTBD CHORD DRILLED.SDR IPXA09556790Frame · dentedINSPECTION TYPE:C DENT ON AFT CARGO COMPARTMENT AT FRAME STA 1540, BETWEEN STRINGERS S-23L AND S-24L. DENT FOUND OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGED AREA IAW SRM 53-00-07-2R5 FIG 201. HFEC HOLES IAW NDT51-00-16PT6, NO CRACKS NOTED. SDR IPXA09556784Frame · dentedINSPECTION TYPE:C DENTS (2 PLS) ON AFT COMPARTMENT AT FRAME 1280, BETWEEN STRINGERS S-24L AND S-26L. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE IAW EA757-5362-27-A1891. HFEC AT CUT OUT + HOLES IAW NDT51 00-16PT6/-19PT6, NO CSDR IPXA09556783Frame · dentedINSPECTION TYPE:C DENT ON AFT CARGO COMPARTMENT AT FRAME STA 1300, S-26R. DENT FOUND OUT OF LIMITS IAW SRM 51-00-07-1A1 FIG 101. CUT OUT DAMAGE IAW EA757-5362-27-A1889. HFEC AT CUT OUT + HOLES PER NDT51-00-16PT6 /-19PT6, NO CRACKS NOTED. FAB REPAIR PARTS OSDR IPXA09556782Frame · dentedINSPECTION TYPE:C DENT ON AFT CARGO COMPARTMENT AT FRAME STA 1480, STG-26L. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE PER SRM 53-00-07-2R5 FIG 201. HFEC AT CUT OUT + HOLES IAW NTM51 00-16PT6/-01PT6, NO CRACKS NOTED. FAB RESDR IPXA09556780Frame · dentedINSPECTION TYPE:C DENT ON AFT CARGO COMPARTMENT AT STA 1500, S-26R. DENT FOUND OUT OF LIMITS IAW SRM 53-00-07-1A1 FIG 101. CUT OUT DAMAGE PER SRM 53-00-07-2R5 FIG 201. HFEC AT CUT OUT + HOLES PER NTM 51-00-0 1PT6, NO CRACKS FOUND. FAB REPAIR ANGLE ON MAE TSDR IPXA09556778Frame · dentedINSPECTION TYPE:C DENT ON AFT CARGO COMPARTMENT AT FRAME STA 1460, S-26R. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1, FIG 101. CUT OUT DAMAGED AREA IAW SRM 53-00-07-2R5, FIG 201. HFEC AT CUT OUT AREA + HOLES IAW NDT 51-00-01-16PT6, NO CRACKS FOUND.SDR DLM88091236Support · corrodedFRAME SUPPORT AT FS 1250 LONG 18 LEFT CORRODED. REPLACED FRAME IAW 51-10-4.SDR IPXA09556745Frame · dentedINSPECTION TYPE: C DENT ON AFT CARGO COMPARTMENT AT STA 1520, S-26L. DENT FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101. CUTOUT DAMAGE IAW EA757-5362-27-A1887. HFEC AT CUT OUT+HOLES IAW NDT51-00 -16 PT6/-19 PT6, NO CRACKS FOUND. FAB REPAIR PART ON MASDR AALA20090630TUL47Frame · crackedTWO CRACKS ON CANT FRAME 1463, ONE INBOARD OF LONGERON 3L AND ONE OUTBOARD OF LONGERON 3R. REPAIRED CRACKS PER EA MD-80-53-006604 AND EA MD-80-53-006618.SDR SWAA094198Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 15L. REPAIRED FRAME PER ACO & EA.SDR FDEA200906292388Frame · corrodedBS 900, WL 208 FRAME BEHIND DOUBLER CORRODED ON RT SIDE OF FUSELAGE. REPAIR CARRIED OUT IAW R-5340-13106. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR C2XA09SH178Frame · crackedSHV - DURING C-CHECK, FRAME 10 JUST ABOVE STR 10R CRACKED. REMOVED AND REPLACED FR 10 IAW SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20090630TUL43Frame · corrodedCORROSION AFT SIDE OF FRAME 1309, LONGERON 28L TO 28R. INSTALLED NEW SECTION OF FRAME FROM LONGERON 26L TO 26R AND PERFORMED SPLICE REPAIRS PER SRM 53-30-00, 51-30-05, AND 51-30-02, TREATED AND PAINTED PER SRM 51-10-03.SDR USAA2009070191647Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 616, BELOW S17L. REPAIRED FUSELAGE FRAME AT BS 616, BELOW S17L IAW US AIRWAYS TYPICAL REPAIR 53-62-01.SDR FDEA200906282353Frame · damagedFRAME STA 800, STR 3L- 3R, HAS MISDRILLED HOLES. REMOVED FRAME, FABED NEW FRAME SECTION ON MAE TRAV NR T9/794116, INSTALLED FRAME ALL REPAIR PARTS, STA 800, STR 5L- 5R, IAW SRM 53-00-07, 51-40-02. CATEGORY "A", REPAIR NR 1, MAJOR REPAIR.SDR USAA2009062991621Frame · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME AT BS 500B, S20L. REPAIRED FRAME AT BS 500B, S20L IAW 737 SRM 53-00-07 REPAIR 13.SDR SWAA094162Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR FDEA200906262323Frame · damagedFRAME STA 1340, STR 3L- 3R, HAVE MISDRILLED HOLES. REMOVED FRAME SECTION IAW SRM 53-00-07, FABED NEW FRAME ON MAE TRAV NR T9/794393. INSTALLED FRAME AND REPAIR PARTS STA 1340, STR 5L- 5R, IAW SRM 51-20-01, 53-00-07. REPAIR NR 1, CATEGORY "A". MAJOR REPAIR.SDR FDEA200906262322Frame · damagedFRAME AT STA 395, STR 3L- 3R, HAVE MISDRILLED HOLES AT BS. 395, STR 3L- 3R. FRAME REPAIR WAS ACCOMPLISHED DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE MOD CARD 118350472RCBR07, AND MAE EA 757- 5332- 16- F2030, REV-, DATED 06/05/2009. THIS NON ROUTSDR SWAA094151Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 20L TO STR 21L. REPAIRED FRAME PER EA AND SRM.SDR SWAA094150Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L TO STR 21L. REPAIRED FRAME PER EA AND SRM.SDR SWAA094149Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 20R TO STR 21R. REPAIRED FRAME PER EA AND SRM.SDR SWAA094148Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R TO STR 21R. REPAIRED FRAME PER EA AND SRM.SDR FDEA200906262318Frame · wornDURING INSP LT AIR COND FOUND DEEP WEAR ON FRAME. REPAIRED AREA IAW SRM 53-30-00 FIG 4 & 4A VOL I.SDR FDEA200906262317Frame · crackedDURING INSPECTION LT AIR COND FOUND CRACK ON FRAME. REPAIRED AREA IAW SRM 53-30-00 FIG 4 VOL I.SDR FDEA200906262316Frame · wornDURING INSP AVIONIC COMPT BILGE AREA FOUND DEEP WEAR ON FRAME. REPAIRED AREA IAW SRM 53-30-00 FIG 4, VOL I.SDR SWIA200922322Frame · crackedFS 605 FRAME CRACKED. (C CHECK) REPAIRED PER REO.SDR ASOA200900730Frame · damagedTOP FLANGE OF FRAME AT FS 628.0 BOTTOM, 2 INCHES LEFT OF STR 27 IS DENTED AND CRACKED. DENT MEASURES APPROX 1 INCH LONG X .50 INCH WIDE X .020 INCH DEEP, CRACK MEASURES APPROX .30 INCH LONG. REPAIR OF THE CRACK & DENT DAMAGE ON TOP FLANGE IAW REO 601R-53-61-SDR AALA20090630TUL37Frame · corrodedCORROSION ON UPPER AND LOWER SIDE OF AFT LOWER FLANGE OF FRAME 1309, LONGERON 28 RIGHT TO LONGERON 28 LEFT. INSTALLED REPAIR DOUBLER ON UPPER AND LOWER SIDE OF AFT LOWER FLANGE 1309, LONGERON 28 RIGHT TO LONGERON 28 LEFT PER SRM 53-03-00 FIGURE 2A SHEET 2.SDR ASOA200900719Frame · corrodedFS 349.00 AT STRINGER 27 HAS CORROSION ON FRAME. REMOVED 6 RIVETS TO ACCESS CORROSION. REMOVED CORROSION IAW SRM 51-21-06. INSTALLED RIVETS WET WITH SEALER IAW SRM 51-42-06 AND SRM 51-23-00. PRIMED AND PAINTED REPAIRED AREA IAW SRM 51-25-01. SLIGHTLY CORSDR FDEA200906252299Frame · crackedFOUND CRACKED FASTENER HOLES 5 AND 6 AND DAMAGED HOLE 8 IN CENTER WEB OF FRAME 44. REPAIR PERFORMED BY OVERSIZING THE HOLES 5 AN 6 AND COUNTERSINKS HOLE 8, NDT FOR CRACK FREE CONDITION AND INSTALLING CONICAL WASHER IAW RAS 70520180/009/2009 ISS.A, APPROVED BYSDR 2009FA0000575Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS440 STRINGER 9 LT.SDR 2009FA0000574Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 480 STRINGER 9 LT.SDR SWAA094118Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER EA.SDR SWAA094108Frame · crackedDURING SCHEDULED SPV, FOUND AFT CARGO DOOR CUTOUT FRAME CORRODED AT BS 764. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR COMA2009062550159Frame · crackedLT SIDE FS 640 FRAME CRACKED AT STR 9L. REPAIRED CRACK AT FS 640 STR 9L IAW REO 601R-53-61-557.SDR FDEA200906242285Frame · damagedFRAME STA 1320, STR 3L-3R, HAVE NUMEROUS MISDRILLED HOLES. REMOVED FRAME IAW SRM 51-40-02. FABED NEW FRAME IAW MAE TRAV NR T9/794120. INSTALLED FRAME REPAIR PARTS STA 1320, STR 5L- 5R, IAW SRM 53-00-07, 51-40-02. CATEGORY "A". MAJOR REPAIR.SDR FDEA200906242284Frame · damagedFRAME AT STA 418, STR 3L- 3R, HAVE NUMEROUS MISDRILLED HOLES AT BS 418, S3L- S3R, FRAME REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY AFFECTING THE PTF CONVERSION, ON MAE MOD W/C NR118350472RCBR07, AND MAE EA NR 757-5332-16- F2030, REV, DATED 06/05/2009. THIS SDR FDEA200906242282Frame · damagedSTA 520 LWR FRAME INTG, SPLICE CHORD PN 657N3222-1, 4EA EXISTING FASTENER HOLES WHEN DRILLED THROUGH CHORD ARE TOO CLOSE TO RADIUS TO ALLOW PROPER INSTALLATION OF FASTENERS AT STA 520, LWR FRAME INTG, AREA STR 26L, DUE TO DISCREPANCY AFFECTING THE PTF CONVERSI
Back to JASC 5311