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 AALA20120814009Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 480R SHOWS CRACK INDICATION. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120814008Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 440R SHOWS CRACK INDICATION. INSTALLED REPAIR DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120814007Frame · crackedAIR CONDITIONING BRACKET FRAME AT STATION 400R SHOWS CRACK INDICATION. INSTALLED REAPIR DOUBLER PER ECO J1159AD CARD 0007.SDR WVER2012081492502Frame · corrodedFS 319.00 FRAME HAS CORROSION BETWEEN STRINGER 25L AND 25R.SDR FDEA201208132965Frame · misrepairedFRAME MISREPAIRED AT CENTER WHEEL WELL BS 1381, LONGERON 52. REPAIRED IAW SRM 53-30-00, FIG 4 VOLUME I, REV 99. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 115.SDR FDEA201208132974Frame · gougedFRAME BS1280 S11 - 14R, DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, DETAIL II FIG 101 SH. 3. INSTALLED NEW FRAME REPAIR IAW SRM 51-40-02 AND SRM 53-00-07 REPAIR 3, DETAIL II, FIG 201, SHEET 3 . MAJOR REPAIRSDR DALA12005350855Frame · damagedRT MLG WHEEL WELL DOOR CUTOUT HAS FRAME WITH CHAFE/GOUGES IN 2 AREAS BY DOOR PROX SENSORS. GAINED ACCESS, REMOVED DAMAGE PER PR/I 505955-14, PERFORMED HFEC INSPECTION AT THE TRIMMED EDGE OF THE FORMER PER NDT SPM 06-10-01.003, NO CRACK NOTED. PERFORMED DVI OSDR QXEA2012081200810Frame · corrodedFRAME X1.0, 4 IN ABOVE STRINGER 26S, FLOOR SUPPORT BEAM CORRODED. CLEANED FRAME IAW SRM 51-26-10-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .045" CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910SDR DALA1254733736Frame · damagedFRAME AT BS 440 AND STRINGER 8L IS CRACKED IN CABIN. REPAIRED FRAME IAW ERA 507347-14AD.SDR SWAA2012100108195Frame · crackedFRAME CRACKED AT BS 500B, STR 17R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012090407309Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW ATS ER AND EA.SDR SWAA2012090407302Frame · crackedFRAME CRACKED AT BS 907, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW ATS ER AND EA.SDR SWAA2012082106872Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012082106871Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012082006850Frame · crackedFRAME CRACKED AT BS 500A, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012082006849Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR AALA20120810014Strap · corrodedCORROSION ON SKIN UNDERNEATH RIGHT FAILSAFE STRAP JUST AFT OF STRINGER 20 RIGHT END PIECE. REPLACED FAILSAFE STRAP PER EA B767-53-024878 AND SB 767-53-0116.SDR SWAA2012100108117Frame · corrodedFRAME CORRODED AT BS 867, STR 27R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012090607398Frame · corrodedFRAME CORRODED AT BS 992.8, STR 17L. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012090407263Frame · corrodedFRAME CORRODED AT BS 1006, STR 19L. REPAIRED FRAME IAW SRM.SDR SWAA2012082706997Frame · crackedFRAME CRACKED AT BS 947.5, STR 18L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR CHQA20120809262Frame · corrodedDURING INSPECTION, A GOUGE WAS FOUND IN FRAME 60 BETWEEN STRINGERS 4L AND 5L. MAINTENANCE REPAIRED THE DAMAGED AREA IN ACCORDANCE WITH SRM 53-00-04, 51-20-03, 21-21-04, 51-21-05, AND 51-40-02.SDR CHQA20120809261Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND IN FRAME 22 AT THE LOWER SCREW HOLE FOR THE LINER. THE CORROSION WAS REMOVED IN PER SRM 51-10-03. THE REMAINING MATERIAL (0.068") IS ACCEPTED AS PERMANENT IN ACCORDANCE WITH ETD 2012-145-011370 REVISION A.SDR SWAA2012082206889Frame · corrodedFRAME CORRODED AT BS 727E O/B OF RIGHT KEEL BEAM AFT SIDE. REPAIRED FRAME PER SRM & DWG.SDR SWAA2012082106870Frame · crackedFRAME CRACKED AT BS 597, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012082006848Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012082006847Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012082006846Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012081706774Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012081606752Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR DALA1245080699Frame · dentedAFT CARGO BAY FRAME DENTED IN TWO PLACES BS 1480 STR 25L. REPAIRED IAW SRM 53-00-07 FIG 201.SDR USAA2012081000006Strap · crackedQ2 CHECK - FUSELAGE FRAME STRAP CRACKED AT BS 847, S26R. REPAIRED STRAP IAW EA 104164.SDR USAA2012081000005Failsafe · crackedQ2 CHECK - FUSELAGE FRAME FAILSAFE STRAP CRACKED FROM FASTENER HOLE AT BS 794, S26R. REPAIRED STRAP IAW EA 104124.SDR SWAA2012091707672Frame · crackedFRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012091107514Frame · corrodedFRAME CORRODED AT BS 500C, BTWEEN STR 28L AND STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2012091107513Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 27R AND STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR IPXA12M75160Frame · corrodedINSPECTION TYPE: 4C, FRAME BS 1996.75 CORRODED BETWEEN L51L -L51R. REPAIRED FRAME IAW EA 011- 5310-01-A4203 REV IR & EO MD11-5310-48442-A.SDR SWAA2012090407295Frame · crackedFRAME CRACKED AT BS 947, STR 18L. REMOVED AND REPLACED FRAME PER DWG AND SRM.SDR SWAA2012082707035Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012082406974Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2012082406973Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012082406941Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012082006845Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8R AND 9R. REPAIRED FRAME IAW EA.SDR SWAA2012082006844Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8L AND 9L. REPAIRED FRAME PER EA.SDR MASA2012081435036Frame · corrodedFS 319.00 FRAME HAS CORROSION ON FWD SIDE BETWEEN STR 25L AND 25R. PERFORMED A MAJOR REPAIR BY INCORPORATING BOMARDIER REO 670-53-21-799, ORIGINAL REV.SDR DALA1244940927Frame · corrodedCORROSION ON FRAME UPPER AND LWR SURFACE OF BILGE AREA FS 1307 BTW L 27R AND L23L IN AFT CARGO COMPT. REPLACED FRAME IAW SRM 51-30-5.SDR AALA20120808003Frame · crackedTHE 1510 CANT FRAME CRACKED BELOW RIGHT LOWER TAIL CONE LATCH. INSTALLED DOUBLER PER SRM 53-01-00.SDR NACA201208080005Frame · crackedE/E BAY, A CRACKED FRAME WEB AT BS 328 BETWEEN STRINGER 20-21R. REMOVED CRACKED FRAME IAW SRM 51-40-02. INSTALLED NEW FRAME IAW SRM.SDR FDEA201208082893Frame · misrepairedFRAME BS 1520, STR 23R -26R MISREPAIRED.SDR FDEA201208082888Frame · corrodedAFT CARGO BAY BS 1841 FRAME CORRODED. REMOVED DAMAGED AREA. FABRICATED, DRILLED, DEBURRED, ALODINED & PRIMED REPAIR ANGLE & SPLICE & FILLER IAW SRM53-30-00. FRAME REPAIRED IAW SRM.53-30-00, VOL I AND ER 12-03855.
Back to JASC 5311