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 IPXA12574030Frame · dentedINSPECTION TYPE: C, FWD CARGO PIT STA 800 STR 23 & 24R FRAME IS DENTED. REMOVED DAMAGE AT FRAME, FABRICATED REPAIR DOUBLER. DRILLED AND INSTALLED REPAIR IAW SRM 53-00-07-2R5, REV 83, DETAIL II.SDR IPXA12574029Frame · dentedINSPECTION TYPE: C, FWD CARGO PIT BS 760, S23L FRAME IS DENTED. REMOVED DAMAGE AT FRAME, FABRICATED REPAIR DOUBLER, DRILLED AND INSTALLED IAW SRM 53-00-07-2R5 REV 83, DETAIL II.SDR SWAA2012061905073Frame · crackedFRAME CRACKED AT BS 500C, STR 21L. REPAIRED FRAME IAW EA AND EA.SDR IPXA2573886Frame · dentedINSPECTION TYPE: C, FWD CARGO BAY BS 820 S23L FRAME IS DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07, DETA IL III.SDR IPXA2573885Frame · dentedINSPECTION TYPE: C, FWD CARGO BAY BS 680 STR 24R FRAME IS DENTED, REMOVED DAMAGE AND REPAIRED FRAME IAW 53-00-07-2R5, DETAIL III.SDR CALA2012060400390Frame · crackedFRAME 907 LT, HAS A CRACK PERFORMED INTERIM REPAIR IAW ECRA 5310-05521.SDR SWAA2012060404556Frame · corrodedFRAME CORRODED AT BS 851, BETWEEN STR 26L TO STR 30L. REMOVED AND REPLACED FRME IAW SRM.SDR SWAA2012060404555Frame · corrodedFRAME CORRODED AT BS 832, BETWEEN STR 27L TO STR 29L. REMOVED AND REPLACED FRME IAW SRM.SDR SWAA2012060404554Frame · corrodedFRAME CORRODED AT BS 832, BETWEEN STR 30R TO STR 26R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2012060404553Frame · corrodedFRAME CORRODED AT BS 851, BETWEEN STR 29L TO STR 27L. REMOVED AND REPLACED FRAME IAW SRM.SDR ASAA2012062192577Frame · dentedAFT CARGO COMPARTMENT, BS 727A S24L FRAME DENTED. ACFT GROUNDED. REPAIRED FRAME REF REO-G15102, REV B, DATED 07-08-2012 AND EA 900-53EA-08344, REV NEW DATED 07-09-2012.SDR DALA1242189265Frame · corrodedCARGO BAY BS 1310 STR 30 FRAME HAS CORROSION. CUT OUT DAMAGED SECTION OF FRAME FROM LONGERON 26R TO 27L. INSTALLED FRAME REPAIR PER MD90 SRM 53-10-07 VOL I INSTALLATION -703.SDR ASAA2012062192485Frame · dentedAFT CARGO COMPARTMENT, FRAME BS 727A, S24L DENTED. REPAIRED FRAME REF REO-G15102, REV B, DATED 07-08-2012 AND ASA EA 900-53EA-08344, REV NEW DATED 07-09-2012.SDR ASAA2012062592477Frame Splice · gougedFRAME SPLICE AT STA 727H GOUGED. R & R FRAME SPLICE.SDR FDEA201206022058Frame · dentedBS 1240, S26L FRAME DENTED. NOT ALLOWED IAW SRM 53-00-07 FIG 101. REMOVED AND REPLACED FRAME IAW SRM 51-40-02 AND DWG 146N1003. MAJOR REPAIR.SDR USAA2012062500034Frame · corroded2S CHECK - CORROSION ON FUSELAGE FRAME AT FR68, S23L. REPAIRED FUSELAGE FRAME AT FR68, S23L IAW EA 500730.SDR USAA2012061400011Frame · corrodedQ4 CHECK - LEVEL 2 CORROSION ON APU INLET OPENING FRAME AT BS 1112, BETWEEN S5R TO S12R. REPAIRED APU INLET OPENING FRAME AT BS 1112, BETWEEN S5R TO S12R IAW EA 103980.SDR USAA2012061200010Coupling · elongated3S CHECK - ELONGATED HOLE ON FRAME COUPLING AT FR66, STR 23R, -Y1732. REPLACED FRAME COUPLING AT FR66, STR 23R, -Y1732 IAW A320 SRM 51-72-11 AND DRAWING D53474250.SDR USAA2012061200009Coupling · elongated3S CHECK - ELONGATED HOLE ON FRAME COUPLING AT FR66, STR 23R, -Y1732. REPLACED FRAME COUPLING AT FR66, STR 23R, -Y1732 IAW A320 SRM 51-72-11 AND DRAWING D53474250.SDR USAA2012061200008Coupling · elongated3S CHECK - ELONGATED HOLE ON FRAME COUPLING AT FR66, STR23R, -Y1732. REPLACED FRAME COUPLING AT FR66, STR 23R, -Y1732 IAW A320 SRM 51-72-11 AND DRAWING D53474250.SDR USAA2012061200006Coupling · elongated3S CHECK - ELONGATED HOLE ON FRAME COUPLING AT FR66, STR23R, -Y1732. REPLACED FRAME COUPLING AT FR66, STR 23R, -Y1732 IAW A320 SRM 51-72-11 AND DRAWING D53474250.SDR AALA20120601014Frame · crackedSTATION 1510 CANT FRAME CRACKED ABOVE MAINTENANCE LIGHT SWITCH. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER EA MD80-53-024052.SDR DALA1235139256Frame · corrodedDURING HMV/MOD, FOUND AFT PIT FRAME 1307 CORRODED. REMOVED FLOOR SUPPORT ANGLE, REMOVED CORROSION FOUND TO BE OUT OF LIMITS. CUTOUT SECTION OF FRAME STA 1307 L26L TO 26R, LOCATED, DRILLED AND INSTALLED FRAME AND REPAIR PARTS IAW SRM 53-10-02 FIG 2.SDR DALA1235129256Frame · corrodedDURING HMV/MOD, FOUND AFT FRAME 1288 CORRODED. REMOVED CORRODED FRAME SECTION, LOCATED, DRILLED AND INSTALLED FRAME SECTION AND REPAIR PARTS IAW SRM 53-10-02 FIG 2 VOL1.SDR DALA1235109256Frame · corrodedDURING HMV/MOD, FOUND AFT PIT FRAME 1328 HEAVILY CORRODED. CUTOUT DAMAGED FRAME SECTION, LOCATED, DRILLED AND INSTALLED REPAIR IAW SRM 53-10-02 FIG 2 VOL I.SDR GLBA2012060401Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND CRACK ON THE RT SIDEWALL FS 456 AND STRINGER 10R, FRAME AT STRINGER CUTOUT, .2" IN LENGTH. REPAIRED IAW EO 12-1900-53-032. MAJOR REPAIRSDR CALA2012060100387Frame · crackedFUSELAGE LT FRAME CRACKED STA 360 BETWEEN S 8 & 9 REPAIRED FRAME IAW ECRA.5311-01551.SDR GLBA2012053101Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE FRAME AT FS 456 BETWEEN STRINGER 3 & 4L, FWD CARGO DOOR CUTOUT. REPAIRED IAW EO 12-1900-53-031. MAJOR REPAIRSDR AALA20120611002Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET STATION 500D RIGHT. INSTALLED REPAIR DOUBLER PER ECO J1159AD-7.SDR AALA20120611001Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET STATION 500F. INSTALLED REPAIR DOUBLER PER ECO J1159AD-6.SDR USAA2012061200007Coupling · corroded3S CHECK - CORROSION ON OUTBOARD LOWER COUPLING AT FR66, S23L, Y1450. REPLACED OUTBOARD LOWER COUPLING AT FR66, S23L, Y1450 IAW A320 SRM 51-42-11 AND DRAWING D53474250.SDR USAA2012061200005Coupling · corroded3S CHECK - CORROSION ON INBOARD LOWER COUPLING AT FR66, S23L, Y1450. REPLACED INBOARD LOWER COUPLING AT FR66, S23L, Y1450 IAW A320 SRM 51-42-11 AND DRAWING D53474250.SDR USAA2012061200004Coupling · corroded3S CHECK - CORROSION ON OUTBOARD UPPER COUPLING AT FR66, S23L, Y1450. REPLACED OUTBOARD UPPER COUPLING AT FR66, S23L, Y1450 IAW A320 SRM 51-42-11 AND DRAWING D53474250.SDR USAA2012061200003Coupling · corroded3S CHECK - CORROSION ON INBOARD UPPER COUPLING AT FR66, S23L, Y1450. REPLACED INBOARD UPPER COUPLING AT FR66, S23L, Y1450 IAW A320 A320 51-42-11 AND DRAWING D53474250.SDR AALA20120608010Frame · crackedFRAME STATION 500A CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0007.SDR AALA20120608009Frame · crackedFRAME STATION 500C CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0007.SDR AALA20120606011Frame · crackedFRAME 480, RIGHT SIDE OF CABIN, CRACKED AT AIR CONDITIONING RAIL BETWEEN STRINGERS 8 AND 9. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0007.SDR AALA20120606010Frame · crackedFRAME 500A, RIGHT SIDE OF CABIN, CRACKED AT AIR CONDITIONING RAIL BETWEEN STRINGERS 8 AND 9. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0007.SDR AALA20120604013Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET STATION 380L. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0006.SDR DALA1235250690Frame · dentedFWD CARGO FRAME DENTED ON UPPER FLANGE STA 540 BETWEEN STR 24 AND 25L IN 2 PLACES, OUT OF LIMITS. REPAIRED PER ERA 503008-14 REV ORIG.SDR DALA1235180690Frame · dentedAFT CARGO COMPT FRAME DENTED IN 2 SPOTS AT STA 1440 STR 24L - 26L, DENT OUT OF LIMITS. REPAIRED PER 757 SRM 53-00-07 REPAIR 5 PG 204.SDR DALA1235150690Frame · dentedAFT CARGO COMPT FRAME DENTED IN 2 SPOTS AT STA 1420 STR 24L-26L, DENT FOUND OUT OF LIMITS. REPAIRED PER 757 SRM 53-00-07 FIG 201 REPAIR 5SDR TSAA20120531002Frame · crackedCRACK APPROX 2.6250 FOUND AT BS 927, STRINGER 23L. REPAIR COMPLIED WITH IAW SRM 53-30-3, FIG 48, DETAIL XI.SDR CALA2012060100385Frame · crackedFRAME 400L HAS A CRACK. REPAIRED FRAME IAW EC/RA 5310-05522.SDR AALA20120531003Frame · crackedTHE 1418 CANT FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED REPAIR DOUBLER AND STRAP PER SRM 53-03-00.SDR AALA20120531001Frame · crackedTHE 1510 CANT FRAME AT 2 EA TAIL CONE ALIGNMENT PINS ABOVE LEFT LOWER TAIL CONE LATCH CRACKED. STOPPED DRILLED CRACKS AND INSTALLED DOUBLERS PER SRM 53-01-00.SDR FDEA201205312021Frame · corrodedAFT LOWER CARGO COMPARTMENT FRAME BS 1340 BETWEEN STR 26L TO STR 27L CORRODED ON INNER FLANGE. FRAME REPAIRED IAW EA F-5310-155906 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201205312020Frame · gougedAFT LOWER CARGO COMPARTMENT FRAME AT BS 1340 BETWEEN STR 25L TO STR 27L GOUGED. DAMAGED FRAME REPAIRED IAW EA F-5310-155906, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR IPXA2M74084Frame · dentedINSPECTION TYPE:4C, MAIN CABIN STA 755 FRAME DENTED BETWEEN L12R & L13R REPAIRED STA.755 FRAME IAW STASA EA 011-5310-01-A3983 REV IR & EO MD11-5310-47647-A.SDR IPXA2M74083Frame · dentedINSPECTION TYPE:4C, MAIN CABIN FRAME STA 655 DENTED BETWEEN L12R & L13R. REPAIRED STA 655, FRAME IAW STA SA EA 011-5310-01-A3981 REV IR & EO MD11-5310-47648-A.
Back to JASC 5311