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 FDEA200901190251Frame · gougedAFT CARGO PIT STA 1340, STR 25-27L FRAME IS GOUGED. REPAIRED FRAME AT STA 1320 BET STR 25-27L IAW SRM 53-00-07 FIG 201 REPAIR NR 5 DETAIL I. THIS REPAIR IS CATEGORY "B" MAJOR REPAIR.SDR CALA2009012000048Frame · crackedFRAME CRACKED AT STATION 597 BETWEEN STR 8 AND 9 LEFT. INSTALLED REPAIR PER ECRA 5311-01443 INITIATED DIP 092289 TO READ AS FOLLOWS, BEFORE THE ACCUMULATION OF 76,000 TOTAL AIRCRAFT FLIGHT CYCLES PERFORM AN INSPECTION PER PART 2 OF ECRA 5311-01443 BEFORE THE SDR USAA2009012290125Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME IS CRACKED AT BS 727D, BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 727D, BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR UALA2009011900208Frame · crackedCRACKS ON FRAMES BS 680 AT STR 12 AND STR 11 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED AND REPLACED P/N 143N8334-28 FRAME INTERCOSTAL. PERFORMED GIRT BAR PROX SENSOR, OPS CHECK GOOD.SDR UALA2009011900207Frame · crackedCRACK ON FRAME AT BS 680 AND STRINGER 12L. MAJOR REPAIR ACCOMPLISHED: REMOVED AND REPLACED P/N 143N8334-27 FRAME INTERCOSTAL. ACCOMPLISHED GIRT BAR PROX SWITCH, OPS CHECKED GOOD.SDR DL757090622Frame · corrodedFRAME CORRODED AT FS 1480 STR 24L-24R. REPLACED SECTION PER SRM 51-40-02/05, 51-20-01, 51-30-01.SDR ASAA0944373Frame · gougedAFT PIT BS 727 JUST BELOW STRINGER 25L FRAME GOUGED AT FWD TOP. CUT OUT DAMAGED AREA. FABRICATED REPAIR PARTS AND INSTALLED REPAIR IAW B737 400 SRM 51 70 11.SDR ASAA0944372Frame · crackedAFT PIT BS 767 FRAME FWD FACE IS CRACKED BETWEEN S27R AND S 28R. REMOVED DAMAGED FRAME SHEAR TIE. FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA0944319Frame · corrodedAFT PIT AT BS 867 STRINGER 27L STRINGER 28R FRAME CORRODED. REPAIRED FRAME AT BS 867 IAW B737 400 SRM 53 00 07 FIG 1.SDR ASAA0944231Frame · damagedOVERSIZED HOLES IN UPPER FRAME BS 847 STR 13R-18R. REMOVED AND REPLACED FRAME PER SRM 51-40-02.SDR USAA2009012290124Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME HAS A .125 INCH CRACK AT BS 440, BETWEEN S8R & S9R. ALSO BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 440, BETWEEN S8R & S9R, ALSO BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR ASAA0944235Failsafe · damagedOVERSIZED HOLES IN FAILSAFE CHORD BS 847 FROM STR 13R 18R. R&R FAILSAFE CHORD BS 847 FROM STR 13R 18R.SDR FDEA200901160218Frame · crackedAIR COND COMPT FOUND CRACK ON CAP FRAME, REPAIRED AREA IAW SRM 53-00-01 FIG 2, SHT 2, VOL I.SDR FDEA200901150205Frame · gougedMAIN CABIN FRAME 34 L IS GOUGED AT APPROX STRINGER 13 L. BLENDED AREA IN RF TO A310-200 SRM 51-73-10. ORIGINAL MATERIAL 0.236. MATERIAL REMOVED 0.040. MATERIAL REMAINING 0.196 WITHIN LIMITS IN REF TO DAN 26. ALODINED IN REF TO SRM 51-21-10. PRIMED & PSDR SWAA090368Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500, STR 14R. REPAIRED FRAME PER ER.SDR SWAA090367Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 727D, STR 13R. REPAIRED FRAME PER ER.SDR SWAA090345Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090344Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR AALA2009021300109Frame · crackedCANT FRAME 1463 WEB CRACKED 2 INCHES AT RIGHT SIDE ABOVE ACCUMULATOR LONGERON 17 TO 18 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-00-00-09 AND SRM 53-01-00 FIGURE 162.SDR CA090114004Frame · cracked(CAN) BOTH FRAMES CRACKED WHERE THE FLANGE ATTACH RIVETS THAT ARE COMMON TO THE WING TO FUSELAGE CLOSING ANGLES P/N 6511001-49 AND -50 ATTACH. THIS IS THE SECOND A/C WE HAVE FOUND THIS CONDITION ON. A COMPANY GENERATED REPAIR ENGINEERING ORDER WAS USED TO ISDR CA090114003Frame · cracked(CAN) BOTH FRAME HAD CRACKED FLANGES WHERE THE RIVETS COMMON TO THE WING TO FUSELAGE CLOSURE ANGLES ARE ATTACHED, ANGLE P/N`S 6511001-49 AND -50. DUE TO RESTRICTIONS OF USE FOR FORMED FLANGE REPAIRS IN THE SRM, A COMPANY GENERATED ENGINEERING ORDER WAS USED TSDR UALA2009011500165Frame · dentedAFT PIT FRAME STA 1420, DENT IN FRAME LT SIDE IN SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FRAME & INSTALLED DOUBLER REPAIR.SDR UALA2009011500164Frame · dentedAFT PIT FRAME STA 1360, DENT IN FRAME, LT SIDE SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2009011500163Frame · dentedAFT PIT FRAME STA 1440, DENT IN FRAME LT SIDE IN SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FRAME & INSTALLED DOUBLER REPAIR.SDR UALA2009011500162Frame · dentedAFT PIT FRAME STA 1460, DENT IN FRAME LT SIDE IN SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2009011500161Frame · damagedFUSELAGE DOUBLER AT FRAME 23 + 24 BETWEEN STR 20L + 21L HAS DAMAGE. DOCUMENTED MAJOR REPAIR ACCOMPLISHED ON W-U'S M8934Q AND D9656Y.SDR SWAA090332Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA090319Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090318Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090317Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090316Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090315Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR UALA2009011400156Frame · dentedAFT PIT FRAME STA 1340, DENT IN FRAME RT SIDE IN SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR SWAA090313Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090312Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090292Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME ANGLE CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA090282Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090281Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR. 8L. REPAIRED FRAME PER SWA EA.SDR USAA2009012690179Support · corrodedSAL - C3 - MAJOR REPAIR - GALVANIC CORROSION ON FRAME SUPPORT BETWEEN FR69 TO FR70, S23R, -Y1300. REPLACED FRAME SUPPORT BETWEEN FR69 TO FR70, S23R, -Y1300 IAW A320 SRM 51-72-11.SDR AALA200910590Frame · cracked1510 CANT FRAME CRACKED AT RIGHT LOWER TAIL CONE ALIGNMENT PIN. INSTALLED REPAIR PER ESO 80559 DATED 01/12/09.SDR AALA200910589Frame · crackedSTATION 1510 CANT FRAME CRACKED AT TAIL CONE ALIGNMENT PIN, JUST ABOVE RIGHT LOWER TAIL CONE LATCH. INSTALLED REPAIR PER ESO 80559 DATED 01/12/09.SDR SWAA090276Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA090256Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 312, BETWEEN STR 22R TO STR 23R. REPAIRED FRAME PER EA.SDR SWAA090253Frame Splice · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SPLICE CRACKED AT BS 500A, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA090243Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 887, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ACO.SDR SWAA090227Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR ZZDA2009010Frame · damagedREPAIR OF FUSELAGE CANTED FRAME CAP STA 1178.225 ACFT RT SIDE. ACCOMPLISHED T/C 17-5310-2989 REV IR STEPS 3-20 RT SIDE.SDR ZZDA2009009Frame · damagedREPAIR OF FUSELAGE CANTED FRAME CAP STA 1178.225 ACFT LT SIDE. ACCOMPLISHED T/C 17-5310-2973 REV IR STEPS 3-20 LT SIDE.SDR SWAA090219Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090218Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311