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 CALA2012070600432Frame · crackedCRACK IN FRAME AT BS 480, STRINGER 8L-9L INSTALLED SERVICEABLE REPAIR ANGLES IAW EA5310-04716, REV C.SDR FDEA201207062501Frame · misrepairedFRAME MISREPAIRED AT BS 1320, STR 23L -26L. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1007. MAJOR REPAIR.SDR SWAA2012082406953Frame · crackedFRAME WEB CRACKED AT BS 380, STR 15R. REPAIRED FRAME IAW EA.SDR SWAA2012082306895Frame · crackedFRAME INNER CHORD CRACKED AT BS 380, AT STR 15L. REPAIRED CHORD.SDR SWAA2012081306618Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REPAIRED FRAME IAW EA.SDR SWAA2012080706505Frame · corrodedFRAME CORRODED AT BS 993, STR 17R. REPAIRED FRAME IAW EA.SDR SWAA2012080306454Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012072606175Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 27L AND 27R. REPAIRED FRAME IAW SRM.SDR CHQA20120705216Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON FRAME 65 AT THE CARGO DOOR THRESHOLD. A HIGH FREQUENCY EDDY CURRENT INSPECTION WAS PERFORMED IAW NIM INTRO ITEM E, WITH NO CRACK LIKE INDICATIONS FOUND. REPAIRED IAW ETD 2012-145-009560 REVISION A.SDR QXEA2012070500614Frame · corrodedFRAME X19.400 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 29S AND 33. REMOVED FASTENERS FOM AND REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. VERIFIED LOWER FLANGES CRACK FREE REF NTM 51-00-06-910-801 PT 1. BLENDS FOUND IN LIMITS IAW RD 8/SDR FDEA201207052484Frame · crackedFOUND BS 1159 FRAME LOWER LEG CRACKED THROUGH WIDTH OF THE FLANGE ON RT SIDE.SDR SWAA2012072606174Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012072306125Frame · corrodedFRAME CORRODED AT BS 867, STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR UALA2012070303545Frame · corrodedAFT CARGO FRAME HAS CORROSION AT STA 1440 AND RBL4. MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION, JUST OUT OF SRM LIMITS, TREATED, PRIMED, INSTALLED REPAIR DOUBLER PER ECRA 5360-01209.SDR FDEA201207032459Frame · damagedAT BS 395 RBL2 UPPER FRAME HAS DOUBLE DRILLED HOLES. REPAIRED.SDR ASAA2012072092561Frame Splice · damagedFRAME SPLICE AT BS 328, STR 1 HAS ONLY 3 FASTENERS ENGAGED, THE 4TH HAS BEEN TRIMMED AROUND. REPAIRED IAW EA 400-53EA-08424.SDR SWAA2012073006317Frame · crackedFRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER ER AND EA.SDR ASAA2012072192604Frame · crackedFWD CARGO FWD FRAME AT STR 24 CRACKED. ACFT GROUNDED. R & R FRAME.SDR ASOA2012072501968Frame · corrodedCORROSION ON FRAME AT FS 319 AND FROM STRINGERS 26L TO 26R. REMOVED CORROSION ON FRAME IAW SRM 53-21-06-101-002-A01. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT INSPECTION PROCEDURE UT-3. MIN MATERIAL REMAINING IS .042"7, ORIGINAL IS .050" MSDR ASAA2012072192565Frame · crackedFORWARD CARGO FORWARD FRAME AT STR 24 CRACKED. ACFT GROUNDED. REMOVED AND REPLACED FRAME.SDR ASOA2012071901936Frame · corrodedCORROSION AT FS 333 BETWEEN STRINGERS 26 AND 27 LEFT. BLENDED DAMAGE ON FRAME. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURE UT-3. MIN MATERIAL REMAINING IS .040" ORIGINAL IS .050" MATERIAL REMOVED IS .010" . REPAIRED IAW REO 670-SDR SWAA2012071205737Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012071205736Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2012071205734Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2012071205733Frame · crackedFRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER EA.SDR SIMA20120702006Frame · bentDURING MAINTENANCE INSPECTION FOUND FRAME 24 BENT BETWEEN STRINGER 14R & 15R. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 24 BETWEEN STRINGER 14R & 15R IAW EMB SRM 53-00-04, ITEM 4. FABRICATED SPLICE PLATE IAW SRM 51-30-01. THE AIRCRAFT WAS RETURSDR SWAA2012070205429Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012070205428Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR MASA2012070234958Frame · corrodedFRAME CORRODED AT FS 349.00 FROM STRINGERS 24R TO 24L. REPAIRED.SDR DU4R20120702001Frame · crackedDURING SCHEDULED INSPECTION, FOUND RT OVERWING FRAMES STA 886.0 FOUND CRACK APPROX .300 IN LENGTH. CRACK TIP OUTSIDE SHADOW OF FASTENER HOLE, CRACK FALLS UNDER CONDITION 3 OF THE SB MD80-53A01, PAGE 16.SDR FDEA201207012431Frame · dentedFRAME AT BS 1661, LONGERON 11L, FOUND DENTED. REPAIRED IAW SRM SRM 51-33-01 REVISION 49. AND SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 49. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 115.SDR FDEA201207012430Frame · dentedFRAME AT BS 1721, LONGERON 11R FOUND DENTED. REPAIRED IAW SRM 51-33-01 REVISION 49 AND SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 49. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 115.SDR FDEA201207012429Frame · dentedFRAME AT BS 1661, LONGERON 11R FOUND DENTED. REPAIRED IAW 51-33-01 REVISION 49 AND SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 49. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 115.SDR FDEA201207012428Frame · dentedFRAME AT BS 1641, LONGERON 11, FOUND DENTED. CARRIED OUT REPAIR AS PER SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 49. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 115.SDR DALA1242890635Frame · crackedON REMOVAL OF FRAME SPLICE AT BS 1440 STRINGER 24L, FOUND FRAME IN AFT CARGO CRACKED. ACCOMPLISHED ERA 505288-14 REV ORIG.SDR SWAA2012071805948Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012071605837Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW EA.SDR SWAA2012071205732Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012071205731Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR DALA1239730633Frame · dentedSMALL DENT ON INNER FREE FLANGE OF FUSELAGE FRAME, BS 1380, APPROXIMATELY ABOVE STRINGER 26 LEFT. REPAIRED IAW SRM 53-00-07 FIG. 201 DETAIL 2.SDR UALA2012070203521Frame · corrodedAFT CARGO COMPARTMENT STA 1620, STR 28L - 29L FRAME CORRODED. REMOVED FASTENERS AND SHEAR TIE PER SRM, REMOVED CORROSION PER SRM, ACCOMPISHED NDT FOR MAT THICKNESS PER NTM. ORIG THICKNESS .063, REMOVED .004" TO .059"; WITHIN LIMITS PER SRM, TREATED AND PRIMEDSDR FDEA201206302415Frame · dentedAFT CARGO FRAME AT BS 1340, STR 26L WITH A DENT ON INNER FLANGE. FRAME REPAIRED IAW EA F-5310-155906, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201206292405Frame · chafedFRAME BS 535, 9G NET LOWER SUPPORT YOKE FOUND CHAFED. REMOVED AND REPLACED AS PER SRM 51-33-01 REVISION 49.SDR FDEA201206292404Frame · chafedFRAME BS 535, 9G NET UPPER SUPPORT YOKE FOUND CHAFED. REMOVED AND REPLACED AS PER SRM 51-33-01 REVISION 49.SDR SWAA2012071905970Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012071905968Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012071905967Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012071805957Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW SRM.SDR SWAA2012071805956Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW SRM.SDR SWAA2012071605882Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.
Back to JASC 5311