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 A6WA201141117Frame · corrodedFRAME BS 605, CORRODED BETWEEN STR 26-27L. REMOVED MINOR CORROSION.SDR HALA2011110200524Frame · corrodedCORROSION ON AFT CARGO FRAME UPPER TEE AT STA 1197 & 88. REPLACED TEE IAW SRM 51-40-02.SDR FDEA201111024721Frame · dentedFRAME BS 1701, L12-13L FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-00-07 FIGURE 201, REPAIR 2, REVISION 47. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 113.SDR SWAA117610Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, STR 17L. REPAIRED FRAME IAW EA.SDR ASOA201102111Frame · crackedINDICATION NOTED AT FS 409+128, WL 69.00, RBL 18 INBD CHANNEL 60 PERCENT FSH & OTBD CHANNEL 85 PERCENT FSH AT .040 EDM NOTCH APPROX 10 IN LENGTH, FAILED NDT.REPAIRED IAW REO 601R-53-41-889 REV A.SDR SWAA117574Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR AALA20111102TUL03Frame · crackedTHE 1474 CANT FRAME CRACKED AFT OF LONGERON 18 LEFT. INSTALLED REPAIR ANGLE PER EA MD80-53-020101 DATED 11-2-11.SDR DALA1160891703Frame · crackedFS 903 RT AT STR 21R FRAME INNER CHORD IS CRACKED. REPAIRED IAW ER/A 496354-14AD REV O.SDR DALA1160901703Frame · crackedFS 903 LT AT STR 21L FRAME INNER CHORD IS CRACKED. REPAIRED IAW ER/A 496353-14AD REV 0.SDR ASAA11410644Frame · crackedFRAME 500F RT SIDE CRACKED AT STAND OFF PEG BELOW STR 21. REPAIRED CRACKED FRAME IAW EA 400 53EA 06775.SDR ASAA11410634Frame · crackedFRAME 500B LT HAS CRACK AT WIRE PENETRATION HOLE. REPAIRED FRAME IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA11410633Frame · crackedFRAME 500B RT SIDE CRACKED AT WIRE PENETRATION HOLE. REPAIRED FRAME AT 500B RT IAW B737 400 SRM 53 00 07 FIG 202 REPAIR 13.SDR ASOA201102103Frame · corrodedFUSELAGE FRAME IS CORRODED AT ACFT BELLY CENTERLINE FS 349. REMOVED AND INSTALLED FRAME IAW SRM 51-42-06 AND 51-42-21.SDR ASOA201102102Frame · corrodedFUSELAGE FRAME IS CORRODED AT ACFT BELLY CENTERLINE FS 333. REMOVED FRAME IAW SRM 51-42-06. LOCATED, DRILLED & INSTALLED FRAME IAW SRM 51-42-06.SDR SWAA117532Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 639, RBL 63.5. REPAIRED WEB IAW EA AND ER.SDR SWAA117529Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 639, STR 16L. REPAIRED FRAME IAW EA AND ER.SDR SWAA117528Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 639, WL 208.5. REPAIRED WEB IAW ER AND EA.SDR SWAA117522Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, WL 209. REPAIRED FRAME IAW EA.SDR FDEA201111014716Frame · misrepairedFRAME BS 1500, STR 24-26L MISREPAIRED. REMOVED FRAME IAW SRM 51-40-02. INSTALLED NEW FRAME IAW SRM 51-40-02, AND DWG 146N1030.SDR FDEA201110314692Frame · dentedCABIN - RT STA 1721, L-11 FRAME FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIG 201 REPAIR 2 REVISION 47. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 113.SDR FOTR2011103106449Frame · corrodedAFT CARGO FRAME AT STA 794, S28R HAS CORROSION. REPAIRED ON FASI WO21142, NR 06449.SDR FOTR2011103106450Frame · corrodedAFT CARGO FRAME AT STA 787, S27R HAS CORROSION. REPAIRED ON FASI WO21142, NR 06450.SDR FOTR2011103106811Frame · corrodedAFT CARGO FRAME AT BS 807 BL 0, CORRODED. REPAIRED ON FASI WO21142, NR06811.SDR DALA1160701703Attach Fitting · crackedFS 927 RT FRAME LWR ATTACH SUPPORT FITTING IS CRACKED.SDR JR2R2011103100550Frame · corrodedWHILE WORKING CIRCUMFERENTIAL JOINT STRAP AT FS 333.00 FOUND CORROSION ON FRAME 333.00 BETWEEN STGR 24R AND 25R. REPAIRED FRAME IAW MESA RO# CRJ9-53-0860 AS ON AAR WO# 1007307-1000-0156 AND MESA WO# 711014235.SDR NSVA2011283Frame · crackedCONTROL # 198-57 FRAME AT FUSELAGE STAION 294.0 RBL 17.5 IS CRACKED. FOR REF SEE TD 340-53-11-75 AND MM-409# 405391. CONTROL # 198-70 CORROSION ON FRAME 294 UPPER FLANGE FROM RBL 21.3 TO LBL 23.8. SEE TD 340-53-11-75 AND MM-409# 405419 FOR DETAILS.SDR NSVA20111030280Frame · corrodedUPPER FLANGE OF BOTTOM FRAME AT STA 294 IS CORRODED FROM RBL 21.3 TO LBL 23.8. REFERENCE TD 340-53-11-09 AND MM 409 405419 FOR REPAIR DETAILS.SDR DALA1160726816Frame · dentedFWD CARGO FRAME DENTED 2 PLACES STA 540 BETWEEN STR 24 AND 25L. SUBMITTED TO ENGINEERING AT SAA/SAT AND DOCUMENTED ON N/R 184385 W/O 89268380001. DURING HMV.SDR USAA2011110700003Frame · corrodedC11 CHECK - LEVEL 2 SURFACE CORROSION ON FUSELAGE FRAME AT FR68, S23R. REPAIRED FUSELAGE FRAME AT FR68, S23R IAW A321 SRM SRM 53-41-12.SDR SWAA117487Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME INNER CHORD WEB CRACKED AT BS 807, STR 25L. REPAIRED WEB IAW ER.SDR SWAA117485Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294, STR 7R. REPAIRED FRAME PER ER.SDR AALA20111028TUL02Frame · corrodedAFT CARGO CORROSION ON FRAME 1309 AFT SIDE LONGERON 29 RIGHT TO LONGERON 26 LEFT. REMOVED DAMAGED AREA OF FRAME SPLICED IN NEW SECTION OF FRAME FROM LONGERONS 28 RIGHT TO 28 LEFT PER SRM 53-03-00 FIGURE 2A.SDR AALA20111028TUL01Frame · corrodedCORROSION ON FRAME STATION 1480, STRINGER 26 RIGHT. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-07-2R.SDR HEEA20111028360Frame · corrodedTHE RT INNER/OUTER FRAMES ON THE AFT LOWER SHELL WERE FOUND TO BE CORRODED. THE AFT LOWER SHELL WILL THEN BE REPAIRED IAW THE FAA-APPROVED REPAIR DATA.SDR SWAA117474Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 26R. REPAIRED FRAME IAW SRM.SDR HYIA836HC201113AFrame · crackedDURING HEAVY CHECK A CRACK WAS FOUND ON THE LT SIDE OF UPPER FRAME 28. REPAIRED IAW EA 12-2011-010. REPAIR PERFORMED BY TECH SERVICES (MRO) UNDER W/O 17010. DTA EVALUATION TO BE ACCOMPLISHED WITHIN 12 MONTHS IAW AC120-93.SDR HYIA836HC201119Frame · damagedDURING HEAVY CHECK, RT SPONSON FRAME WAS DAMAGED. SPONSON FRAME WAS REPAIRED IAW EA 09/2011-184. REPAIR PERFORMED BY TECH SERVICE (MRO) UNDER W/O 17077.SDR HYIA836HC201113Frame · crackedDURING HEAVY CHECK A CRACK WAS FOUND ON THE LT SIDE OF THE UPPER FRAME 28. THE DAMAGE CONSISTS OF A SINGLE CRACK THAT STARTS MIDWAY DOWN THE WEB RUNNING 1.6" THROUGH A .098" HOLE AND INTO THE AFT FACING FLANGE 0.6". REPAIRED IAW STS ENGINEERING SOLUTIONS EA 1SDR SWAA117499Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT FRAME INNER CHORD CRACKED AT BS 616, WL 202. REPAIRED CHORD IAW EA.SDR AALA20111026TUL11Frame · crackedFRAME CRACKED AT STATIONS 440 TO 480, STRINGERS 8 TO 9 LEFT AT A/C RAIL BRACKET AND STATION 380 RIGHT. FRAME REPAIR COMPLETED AS PER ECO J1159AD.SDR AALA20111026TUL10Frame · crackedFRAME CRACKED AT STATION 440 RIGHT STRINGER 8 TO 9. FRAME REPAIR COMPLETED AS PER ECO J1159AD.SDR AALA20111026TUL09Frame · crackedFRAME CRACKED AT STATION 500C STRINGER 8 TO 9 RIGHT AT AIR CONDITION RAIL BRACKET INBOARD RIVET. FRAME REPAIR COMPLETED AS PER ECO J1159AD.SDR AALA20111026TUL08Frame · crackedFRAME CRACKED AT STATION 480 STRINGER 8 TO 9 RIGHT AT AIR CONDITION RAIL BRACKET INBOARD RIVET. FRAME REPAIR COMPLETED AS PER ECO J1159AD.SDR AALA20111026TUL07Frame · crackedFRAME CRACKED AT STATION 500A STRINGER 8 TO 9 RIGHT AT AIR CONDITION RAIL BRACKET INBOARD RIVET. FRAME REPAIR COMPLETED PER ECO J1159AD.SDR SWAA117430Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 1L. REPAIRED FRAME IAW SRM.SDR FDEA201110264658Frame · misrepairedFRAME AT BS 1320 STR 22L- 26L MISREPAIRED. REMOVED & REPLACED FRAME IAW SRM 51-40-02 AND DWG 146N1028.SDR DALA1162730969Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT FUSELAGE FRAME LOWER FLANGE AFT SIDE AT STA 1136 BETWEEN LONGERON 29R AND LONGERON 30. REMOVED CORROSION ON FRAME, MATERIAL LOSS FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE, FABRICATED REPAIR ANGLES AND FILLERS AND INSTALLED SDR IPXA11570132Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO LT SIDE FRAME AT BS 1500, BETWEEN S25-26L, DENTED IN INNER FREE FLANGE. REPAIRED IAW SRM 53-00-07-2R REPAIR 5, DETAIL 1.SDR IPXA11570128Frame · dentedINSPECTION TYPE:C-CK, FORWARD CARGO COMPARTMENT BS 740 S24R FRAME INNER CHORD DENTED. REPAIRED FRAME IAW SRM 53-00- 07-2R REPAIR 5.SDR FDEA201110254646Frame · misrepairedFUSELAGE FRAME, BS 1480 BETWEEN S22-25L MISREPAIRED. REMOVED AND REPLACED FRAME IAW SRM 51-40-02. MAJOR REPAIR.
Back to JASC 5311