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 SWAA097302Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR USAA2010011590110Frame · corrodedMAJOR REPAIR - LEVEL 2 CORROSION ON FUSELAGE FRAME AT BS 794 AND BETWEEN S26R TO S27R, RBL 9. REPAIRED FUSELAGE FRAME AT BS 794 AND BETWEEN S26R TO S27R, RBBL9 IAW US AIRWAYS EA NR 132774.SDR USAA2010011190069Frame · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FUSELAGE FRAME AT BS 827, RBL 3. REPAIRED FUSELAGE FRAME AT BS 827, RBL 3 IAW B737 SRM 53-00-07 REPAIR 5.SDR USAA2009122893437Frame · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FUSELAGE FRAME AT BS 767, RBL 4. REPAIRED FUSELAGE FRAME AT BS 767, RBL 4 IAW B737 SRM 53-00-07 REPAIR 5.SDR AALA20091117TUL08Frame · crackedFRAME 1418 CRACKED AT LONGERON 2 LEFT. REPAIRED FRAME PER 53-03 FIG 31A WITH DEVIATIONS PER EA MD80-53-008121.SDR AALA20091117TUL05Frame · crackedCANTED FRAME 1474 CRACKED AT ELEVATOR ACCUMULATOR SUPPORT BRACKET FASTENERS. DOUBLER INSTALLED PER AARD 53-10-00-15.SDR SWAA097359Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA097358Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA097292Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, BETWEEN STR 13R AND STR 14R. REPAIRED FRAME PER ER.SDR USAA2010010890056Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 303.9, S16L. REPAIRED FUSELAGE FRAME AT BS 303.9, S16L IAW ENGINEERING JOB CARD M1L53001.SDR USAA2009112493221Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500E BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20R TO S21R IAW EA 101545 & B737 SRM 53-00-07.SDR SWAA097334Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097333Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SRM AND ER.SDR ZZDA2009358Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2984.SDR SWAA097295Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 7R TO STR 8R. REPAIRED FRAME PER EA.SDR USAA2009113093261Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 601, WL 201. REPAIRED FUSELAGE FRAME AT BS 601, WL 201 IAW EA 101556.SDR ZZDA2009357Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2975.SDR USAA2009122293404Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727D BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 727D BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009112493223Frame · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 747 BETWEEN S27R TO S25L. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S27R TO S25L IAW B737 SRM 53-00-07 & EA101533.SDR SWAA097283Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 19R TO STR 20R. REPAIRED FRAME PER SRM.SDR ASOA200901303Frame · crackedFS 718 FRAME DOUBLER HAS POSSIBLE CRACK.SDR SWAA097200Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER ER.SDR AALA20091117TUL03Beltframe · crackedBELTFRAME CRACKED (AT AC HANGER BRACKET). INSTALLED REPAIR DOUBLER PER ECO J1159AC.SDR AALA20091117TUL02Beltframe · crackedBELTFRAME CRACKED AT RIGHT HAND AC HANGER BRACKET. INSTALLED REPAIR DOUBLER PER ECO J1159AC.SDR AALA20091113AFW02Frame · bentFOUND FUSELAGE STATION 500 FRAME INNER CHORD HORIZONTAL FLANGE BENT DOWN BETWEEN STATION 30 LEFT AND 31 LEFT DUE TO SUSPECTED IMPACT FROM A CARGO PALLET. APPROXIMATELY 6 INCHES LONG BY 0.5 INCH WIDE SECTION OF THE FLANGE WAS FOUND BENT DOWN A MAXIMUM OF 0.150SDR USAA2009111793122Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 747 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR ASOA200901297Frame · crackedCRACK INDICATIONS NOTED AT LBL18.0 INBD CAP ANGLE AND RBL 18.0 WL 59.10 ON WEB FS 559. REMOVED POSTS AT RBL9.0 & 18.0 ON FS559.0 IAW REO 601R-53-41-260 REV D. CUTOUT DAMAGED SECTION OF BULKHEAD WEB & LWR ANGLE IAW REO 601R-53-41-260 REV D. ET INSP IAW REO NSDR AALA20091112TUL03Frame · crackedSTATION 1463 FRAME WEB CRACKED ABOVE LEFT LOUVER BOX. INSTALLED DOUBLER PER EA MD 80-53-008078.SDR AALA20091112TUL01Frame · damagedCOCKPIT TEMPERATURE CONTROL VALVE WEARING INTO LEFT 1380 FRAME. INSTALLED DOUBLER PER AARD 53-10-00-28.SDR SWAA097282Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA097234Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 13R. REPAIRED FRAME PER EA.SDR SWAA097233Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 13R. REPAIRED FRAME PER EA.SDR SWAA097278Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, BL 0. REPAIRED FRAME PER SRM.SDR SWAA097179Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 21R TO STR 22R. REPAIRED FRAME PER SRM.SDR ZZDA2009397Frame · corrodedAFT CARGO COMPARTMENT FRAME, STA 974, LONG L30, CORROSION. ACCOMPLISHED FRAME BLENDING WITHIN LIMITS PER B717 SRM 51-10-01 AND B717 SRM 53-00-00 FIG 103.SDR ZZDA2009394Frame · corrodedAFT CARGO COMPARTMENT FRAME, STA 870, LONG L29L TO L30, CORROSION. ACCOMPLISHED FRAME BLENDING WITHIN LIMITS PER B717 SRM 51-10-01 AND B717 SRM 51-22-01.SDR ZZDA2009393Frame · corrodedAFT CARGO COMPARTMENT FRAME, STA 851, LONG L29L TO L29R, CORROSION. ACCOMPLISHED FRAME BLENDING WITHIN LIMITS PER B717 SRM 51-10-01 AND B717 SRM 51-22-01.SDR ZZDA2009395Frame · corrodedAFT CARGO COMPARTMENT FRAME, STA 927, LONG L29L, CORROSION. ACCOMPLISHED FRAME BLENDING WITHIN LIMITS PER B717 SRM 51-10-01.SDR ZZDA2009367Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2975.SDR ZZDA2009366Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR CA091110008Frame · chafed(CAN) WHEN PERFORMING SB 24-3939, IT WAS DISCOVERED THAT ONE OF THE WIRING HARNESS WAS CONTACTING THE FWD FRAME OF THE CO-PILOT CIRCUIT BREAKER PANEL RECESS. CHAFING HAS NOT PENETRATED THE WIRING INSULATION. CONTACT AREA WAS LIMITED TO THE FRAME `TAB` PROTRUSDR ZZDA2009354Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 2. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW TASK CARD 17-5310-2987.SDR ZZDA2009353Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 2. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW TASK CARD 17-5310-2977.SDR GLBA20091110HSpar · damagedDURING ROUTINE SCHEDULED MAINTENANCE AFTER REMOVAL OF A FASTENER, A HOLE WAS FOUND TO BE STEPPED AND OVERSIZED AT THE LEFT HAND WING SPAR W.S. 104.0. APPROXIMATE DIAMETER OF .230". MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED THE REQUIRED RII INSPECTIOSDR DLM88091730Frame · crackedDURING HMV A CRACK WAS FOUND ON UPPER RADIUS OF THE FRAME TAB OF THE OVERWING FRAME AT STATION Y=864 LT REF EA 09-460094-12AD. FRAME WAS REPLACE IAW EA 09-460094-12ADSDR ASOA200901255Frame · crackedWHILE PERFORMING FS 559 BULKHEAD WEB AND FRAME INSP AN INDICATION WAS NOTED AT THE LT CAP ANGLE AT BUTT LINE 18 IN RADIUS APPROX .30 IN LENGTH AND 79 PERCENT FULL SCREEN HEIGHT. FAILS NDT. COMPLIED WITH EC/TC REO 601R-53-41-260 IAW REO 601R-53-41-260 REV D.SDR AALA20091105TUL04Frame · crackedONE INCH CRACK IN UPPER J-ANGLE, FORWARD SIDE OF FRAME STATION 1418 AT LONGERON 2 LEFT. FABRICATED AND INSTALLED DOUBLER AT FRAME 1418 AND LONGERON 2 LEFT PER ENGINEERING AUTHORIZATION MD80-53-007990.SDR USAA2009111393107Frame · crackedPIT - SEAT MOD - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 440, S24R. REPAIRED FUSELAGE FRAME AT BS 440, S24R IAW EA 113834.SDR SWAA097131Strap · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME STRAP CRACKED AT BS 492, STR 18R TO STR 19R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097130Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.
Back to JASC 5311