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 IPXA10559498Frame · gougedINSPECTION TYPE:C4, INBD SURFACE OF FRAME GOUGED BS 1500, STR 15 RT REPAIRED IAW ER NR 10-2376.SDR IPXA10559497Frame · gougedINSPECTION TYPE:C4, INBD SURFACE OF FRAME GOUGED BS 1380, STR 15 RT. REPAIRED IAW ER NR 10-2371.SDR IPXA10559496Frame · gougedINSPECTION TYPE:C4 INBOARD SURFACE OF FRAME GOUGED AT BS 1260, STR 15 RT. REPAIRED PER ER 10-2369.SDR IPXA10559495Frame · gougedINSPECTION TYPE:C4 INBOARD FACE OF FRAME GOUGED BS 1340, STR 15 LT. REPAIRED PER ER 10-2375.SDR IPXA10559494Frame · gougedINSPECTION TYPE:C4 INBOARD FACE OF FRAME GOUGED BS 1300 APPROXIMATELY STR 15 LT. REPAIR PER ER 10-2374.SDR IPXA10559468Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED BS 1280, STR 15R. REPAIRED IAW ATS ER 10-2373.SDR IPXA10559467Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED AT BS 1280, STR15L. REPAIRED IAW ATS ER 10-2370.SDR IPXA10559196Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 1380, STR 15L. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559195Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 1200, STR 15L, REPAIRED IAW EO B757-5310-19952.SDR IPXA10559194Frame · gougedINSP TYPE:C4, FRAME GOUGED, BS 700, LBL 67, WL222. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559193Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 620, RBL 67, WL 222. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559192Frame · gougedINSPECTION TYPE:C4 FRAME GOUGED, BS 720, LBL67, WL222. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559191Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 860, LBL 67, WL 122. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559190Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 660, RBL67, WL 122. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559189Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 740, RBL 67, WL 222. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559188Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 1340, STR 15R. REPAIRED IAW EO B757-5310-19952.SDR IPXA10559187Frame · gougedINSPECTION TYPE:C4, FRAME GOUGED, BS 1500, STRINGER 15L INBD FACE. REPAIRED IAW EO B757-5310-19952.SDR DLM88100783Frame · corrodedAFT CARGO STA 1271, STR 26L-27R FRAME CORRODED/REPLACED FRAME SECTION AT HMV IAW SRM 53-03D, FIG 286 4A.SDR ZZDA2010234Frame · damagedAFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2989.SDR ZZDA2010233Frame · damagedAFT 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 UALA2010033101077Frame · puncturedFRAME WEB PUNCTURE AFT PIT STA 1820 APPROX LBL 48. MAJOR REPAIR ACCOMPLISHED: REPAIRED IAW FRR UAL-744-0625. IAW UA-EVA-73628.SDR UALA2010033101076Rib · puncturedAFT CARGO STA 1820 LBL 48 RIB PUNCTURE. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGED AREA. HFEC, NO CRACK. INSTALLED REPAIR DOUBLER IAW FRR UAL-744-0625.SDR ASOA20100458Frame · corrodedREMOVED 24 FASTENERS AT FS 280.00 BUTT STRAP IN BETWEEN STR 26R AND 25R AND REMOVED CORROSION IAW SRM 51-42-06-001-001-A01 AND 51-21-06-001-001-A01. CORRODED AREA NEEDS A THICKNESS CHECK AND FURTHER EVALUATION. PERFORMED THICKNESS INSP OF BLEND AREA ON BUTT STSDR IPXA10559472Frame · chafedINSPECTION TYPE:C4, APU COMPARTMENT ACCESS PANEL NR 316AD FWD OTBD CORNER FRAME IS CHAFED ON INNER SURFACE. (MARKED) REPAIRED CHAFED FRAME IAW ER NR 10-2353.SDR A6WA201040259Frame · corrodedFRAME 333.00 HAS MINOR SURFACE CORROSION BETWEEN STR 26L & 26R. REMOVED SURFACE W CORROSION, TREATED, PRIMED & PAINTED REPAIR AREA, IAW SRM 51-21-06, 51-25-00, 51-25-06.SDR FDEA201003301035Frame · damagedINTERIOR FRAME WITH DOUBLE HOLE AND CLOSE SPACED HOLES AT BS 418, BETWEEN STR 2L TO STR 2R. FRAME AT BS 418, STR 2L TO STR 2R, REPAIRED IAW STA EA 757-5312-08-E0612 (EXTRANEOUS FASTENER HOLES FOUND ON STA 395 AND STA 418 FRAMES, BETWEEN S-2L AND S-2R). REPASDR FDEA201003301034Frame · damagedINTERIOR FRAME WITH DOUBLE HOLE AND CLOSE SPACED HOLES AT BS 395, BETWEEN STR 2L TO STR 2R. FRAME AT STA 395, BETWEEN STR 2L AND 2R REPAIRED IAW EA 757-5312-08-E0612 (EXTRANEOUS FASTENER HOLES FOUND ON STA 395 AND 418 FRAMES, BETWEEN S-2L AND S-2R). REPAIR SDR AALA20100329TUL02Frame · crackedCANTON FRAME CRACKED STATION 1418 LONGERON 2 RIGHT. REPAIR DOUBLER WAS INSTALLED PER SRM 53-03-00 FIGURE 31A.SDR R61A20100140Frame · damagedWHILE AC WAS IN FOR HEAVY CHECK, A MAJOR REPAIR WAS ACCOMPLISHED DUE TO REPLACEMENT OF FRAME 80. MAINTENANCE REQUESTED EMB ENGINEERING SUPPORT AND RECEIVED ETD 2010-170/02228. MAINTENANCE REPLACED FRAME PER ETD AND SRM.SDR AALA20100328TUL03Frame · corrodedCORROSION ON AFT SIDE OF STATION 1309 FRAME BETWEEN LONGERON 27 LEFT AND LONGERON 28 LEFT. INSTALLED STATION 1309 FRAME REPAIR PER SRM 53-03-00.SDR SWAA101822Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500, STR 13L TO STR 14L. REPAIRED FRAME PER ER.SDR SWAA101818Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101817Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 485A, STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101750Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101749Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101747Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME LOCATED AT BS 1016 FWD FACE AFT PRESSURE BULKHEAD CRACKED. REPAIRED FRAME PER SRM.SDR AALA20100326TUL03Frame · wornFRAME 1418 HAS WORN AREA. REMOVED DAMAGE, INSTALLED DOUBLER REPAIR PER AARD 53-10-00-14.SDR QXEA2010033000197Frame · corrodedCORROSION ON FRAME FS 319 BETWEEN STRINGERS 23R-24R. BLENDED AREA. REMOVED MATERIAL .003" WITHIN LIMITS. PRIMED, TREATED, PAINTED AREA AND INSTALLED ANY REMOVED FASTENERS.SDR QXEA2010033000196Frame · corrodedFOUND CORROSION ON FRAME STA 310, BETWEEN STRINGERS 26L-26R. REMOVED RIVETS TO GAIN ACCESS. BLENDED AREA 8" LONG. MATERIAL REMOVED .003". WITHIN LIMITS. TREATED AREA, PRIMED AND PAINTED. REINSTALLED FASTNERS.SDR UIEA201000079Frame · crackedDURING C-CHECK, A CRACK WAS FOUND IN THE 65B07373-4 1540, LBL 15-17 LOWER LOBE FRAME INNER CHORD. THE DAMAGE WAS TRIMMED OUT AND NEW SECTION WAS SPLICED IAW NRC 727 AND SRM 51-40-04, FIG 2. THE 65B07373-4 CHORD IS MADE FROM BAC1505-100166 EXTRUSION IN 7075-T6SDR UIEA201000073Frame · crackedDURING C-CHECK, A CRACK WAS FOUND IN THE 65B06871-2 BS 560, RBL 35 LOWER LOBE FRAME INNER CHORD. THE DAMAGE WAS TRIMMED OUT AND NEW SECTION WAS SPLICED IAW NRC 305 AND SRM 51-40-04, FIG 2. 65B06871-2 CHORD IS MADE FROM BAC1505-100246 EXTRUSION IN 7075-0 ALUMISDR FDEA201003251010Frame · corrodedC-2 DOOR CUTOUT AFT FRAME BS 990, UPPER FLANGE IS CORRODED WITH EXFOLIATION ON LOWER SURFACE BTWN STR. 26R-25R. REMOVED CORROSION AND FOUND OUT OF LIMITS, CUT OUT DAMAGED AREA DIMS 1.5" X 1", FABRICATED REPAIR ANGLE USING 15-5PH .080 DIMS 28" X 3", 2 FILLERSDR SIMA201008905Frame · damagedAT THE MAINTENANCE BASE VISIT DURING ACCOMPLISHMENT OF SB 145-53-0068 A HOLE WAS MISDRILLED ON FRAME 49 AT STRINGER 8 LEFT. THE AIRCRAFT WAS REMOVED FROM SERVICE. ACCOMPLISHED REPAIR TO FRAME 49 AT STRINGER 8 LEFT IAW EO EM-53MR-1501. THE AIRCRAFT WAS RETURSDR ASOA201000428Frame · corrodedFRAME CORRODED AT FS 364 STG 26R FWD SIDE. REMOVED CORROSION FROM FRAME FS 364, STR 26R ON FWD SIDE IAW SRM 51-21-06. REMOVING ONE BOLT TO ACCESS CORROSION IAW SRM 51-41-02 AND FOUND TO BE WITHIN LIMITS WITH OEM 0.080 AND MATERIAL LOSS TO BE 0.006 IAW SRM 53SDR ASOA201000427Frame · corrodedFRAME CORRODED AT FS 319 STG-26R FWD SIDE. UPON FURTHER INVESTIGATION FOUND FRAME AT FS 319, STA 26R FWD SIDE TO BE OUT OF LIMITS WITH .008 MATERIAL LOSS BEFORE CORROSION WAS REMOVED IAW SRM 51-21-15 AND 53-00-00. FRAME AT FS 319, STR 26R, REQUIRES REPLACEMESDR DALA106283229Frame · chafedDURING (H) CHECK FOUND CHAFED AREA ON AFT FUSELAGE FRAME AT FR86. REPAIRED IAW SRM 51-42-11, 51-44-11, 51-75-12.SDR FDEA201003251001Frame · gougedFUSELAGE FRAME AT BS 1280, S10R-S11R, FLANGE IS GOUGED. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL 2, P.103. REMOVED AND INSTALLED NEW FRAME SECTION, AND 2EA. CHANNELS, AT BS 1280, S10R TO S11R IAW SRM 51-40-02 / 53-00-07, FIG 202, P.201-206SDR ASAA1047583Frame · crackedLT FRAME 727D IS CRACKED BETWEEN STR 8 & 9. REPAIRED FRAME WITH DOUBLERS.SDR ASAA1047582Frame · crackedRT FRAME 867 IS CRACKED BETWEEN STR 8 & 9. REPAIRED FRAME WITH DOUBLERS.SDR ASAA1047581Frame · crackedLT FRAME AT 727F CRACKED BETWEEN STR 8 AND 9. REPAIRED FRAME WITH DOUBLERS.
Back to JASC 5311