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 FDEA201110054306Frame · corrodedFRAME IS CORRODED ON AFT SIDE BELOW THE FAILSAFE CHORD AT BS 1166 BETWEEN S27-29L. REMOVED & REPLACED FRAME IAW DWG 65- 16349 AND SRM 51-30-2.SDR ASOA201101856Frame · corrodedFUSELAGE FRAME AT FS 605 IS CORRODED BETWEEN STR 25 LT & RT. REPAIRED IAW ALL SRM`S.SDR ASOA201101855Frame · corrodedFUSELAGE FRAME AT FS 605 IS CORRODED. BETWEEN S25 LT & RT. REPAIRED IAW ALL SRM`S.SDR DALA1157140187Failsafe · crackedFUSELAGE LT STA 955 WING REAR SPAR B/H FAIL SAFE STRAP AND "T" FTG 1 EACH FASTENER HOLE CRACKED.SDR DALA1157130187Failsafe · crackedFUSELAGE RT STA 955 WING REAR SPAR B/H FAIL SAFE STRAP AND "T" FTG 1 EACH FASTENER HOLES CRACKED.SDR IPXA11569617Frame · dentedINSPECTION TYPE:C-CK, AFT PIT, PREVIOUS FRAME REPAIR DENTED AND GOUGED, STATION 1580, RBL 28, BETWEEN STRINGERS 25R AND 26R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R 5, REPAIR DETAIL III.SDR IPXA11569616Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT STA 720, FRAME DENTED BETWEEN STR 24L AND STR 23L. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R 5, REPAIR 5 DETAIL I.SDR SWAA116925Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 947, STR 21L. REPAIRED FRAME IAW EA.SDR EE4Y20111005009Frame · crackedSECTION 43, FWD C/C BS 380 FRAME WITH UPPER FLANGE CRACKED AT S26R. A PERMANENT IS INSTALLED IAW SRM 51-40-3, FIG 1 GUIDELINES UNDER WO Z10226, ITEM 1-112.SDR FOTR2011100406428Frame · corrodedSURFACE CORROSION ON FRAME AT BS 727D AFT SIDE OF RBL 3 AFT CARGO. REPAIRED ON FASI WO 21142, NR 06428.SDR FOTR2011100406432Frame · corrodedSURFACE CORROSION AT BS 727, FRAME LBL 5 TO RBL 5 , AFT SIDE, LWR AFT CARGO. REPAIRED ON FASI WO 21142, NR 06432.SDR UALA2011100505387Frame · dentedFORWARD CARGO BAY, MAIN FRAME4 DENTED ON INBOARD FLANGE. TRIMMED OUT DAMAGED AREA OF FLANGE, FABRICATED A REPAIR DOUBLER AND INSTALLED PER SRM 53-00-07, REPAIR 5. MAJOR REPAIR.SDR SWAA116891Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 986.5, BETWEEN STR 2L TO STR 3L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR DALA1500820966Frame · crackedBS 1485 FRAME CRACKED. REPAIRED IAW ERA 496701-14.SDR FOTR201110306608Frame · gougedTOP OF FRAME BS 747, S25L, GOUGED. REPAIRED ON FASI WO 21142, NR 06608.SDR UALA2011100505368Frame · corrodedCORROSION FOUND ON BS 1460 FRAME BETWEEN STRINGERS 28L & 29R. REMOVED CORROSION & FOUND OUT OF SRM LIMITS. TRIMMED OUT DAMAGE AT FRAME BOTTOM & ACCOMPLISHED NDT ON TRIMMED OUT AREA & FASTENER HOLES COMMON TO REPAIR AREA. NO DEFECTS FOUND. FABRICATED & INSTSDR AALA20111003TUL11Frame · crackedFRAME CRACKED AFT SIDE OF 1418 AT LONGERON 2. INSTALLED FRAME DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR FDEA201110034269Frame · crackedCABIN, AFTER BRACKET REMOVAL FOUND BS 1580 ADJACENT TO S3R CRACK IN FRAME AT FASTENER LOCATION. FRAME R & R IAW SRM 53-00-07, REPAIR 3, FIG 201, REV 103. REPAIR CLASSIFIED AS MAJOR.SDR IPXA1569564Frame · dentedINSPECTION TYPE:C-CK, FWD PIT COMPARTMENT, STA 700 FRAME DENTED BETWEEN STRINGER 24L AND 23L. FABICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R, REPAIR 5, DETAIL 1.SDR SWAA116863Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 639, LBL 63. REPAIRED FRAME IAW ER AND EA.SDR SWAA116862Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 639, BETWEEN STR 14L TO STR 16L. REPAIRED FRAME IAW ER AND EA.SDR FDEA201110014262Frame · misrepairedFRAME BS 1520 S22-26L MISREPAIRED. REMOVED AND REPLACED FRAME STA 1520 S-24R TO S24L. IAW SRM 51-40-02. FABRICATED NEW FRAME AND NEW SPLICE PLATES. MAJOR REPAIRSDR DALA1156520694Frame · dentedAFT CARGO FRAME DENTED ON UPPER RADIUS STA 1480 ABOVE AND O/B STR 26L. FABRICATED REPAIR J SECTION AND LOCATED AND DRILLED HOLE REF 757 SRM 53-00-07 REPAIR 5 PAGE 201 FIG 201 STEP 4 AND 7. AT SAA/SAT DURING HMV ON N/R 199631 W/O 89012090001. INSTALLED REPAISDR DALA1156910946Frame · crackedFOUND CRACK IN LEFT MAIN WHEEL WELL FORWARD FRAME OUTBOARD EDGE. REPLACED FRAME PER BAC DWG 5930584 457226 PERFORMED OPERATIONAL CHECK OF GEAR DOOR OPEN SWITCH IAW MD-88 AMM 32-60.SDR CALA2011100400637Frame · crackedCABIN FRAME CRACKED AT STA 380 BTWN S-8R & S-9R ALL WORKED PERFORMED AND VERIFIED ON ATTACHED FORMS. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLERS PER EA 5310-04716 REVC OP2.SDR CALA2011100400636Frame · crackedSUPPORT TASK PAX CABIN HAS CRACKED FRAME NR 440 BETWEEN STR 8R AND 9R ALL WORKED PERFORMED AND VERIFIED ON ATTACHED FORMS. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLERS PER EA 5310-04716 REVC OP2.SDR CALA2011100400635Frame · crackedCABIN FRAME CRACKED STA 480 BTWN S-8 RT & S-9 RT (SEE ATTACHED FORMS 44.0008 & 43.0150) ALL WORKED PERFORMED AND VERIFIED ON ATTACHED FORMS. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLERS PER EA 5310-04716 REV C OP2.SDR DALA1156556310Frame · crackedFUSELAGE FRAME CRACK BS 1160. S-9R - 10R. L=1.2". MAINTENANCE REPAIRED THE DAMAGE FRAME PER B747-400 SRM 53-40-07 REPAIR 6.SDR UALA2011100305315Frame · corrodedAFT CARGO BAY FRAME CORRODED BS 1360, JUST OTBD OF RT TRANSITION PANEL. REPAIRED FRAME PER ECRA 5310-05409 AND EVA 81353. MAJOR REPAIRSDR UALA2011100305314Frame · damagedAFT CARGO BAY FRAME, BS 1540 S26L MISDRILLED. FRAME REPAIRED IAW ECRA 5310-05410 AND EVA 81353. MAJOR REPAIR.SDR WRLA20110930513Frame · crackedDURING TENSION TIE INSPECTION FOUND FRAME CRACKED AT BS 1140 RT STRINGER CUTOUT AT S10R. PERFORMED FRAME REPAIR PER SRM 53-40-07.SDR SWAA116864Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616. REPAIRED CHORD PER EA.SDR FDEA201109304228Frame · misrepairedFUSELAGE FRAME BS 1460 BETWEEN STR 29L AND STR 29R MISREPAIRED. REMOVED FRAME IAW SRM 51-40-02. FABRICATED NEW FRAME, LOCATED AND DRILLED IAW SRM 51-40-05. INSTALLED FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR K11A201203076004Doubler · corrodedCORROSION ON DOUBLER, DRILLED HOLE ON FRAME, 5 X 5 CORROSION (NR 21758).SDR AALA20110929TUL01Frame · crackedFRAME CRACKED AFT SIDE OF 1418. INSTALLED DOUBLER REPAIR PER SRM 53-03-00.SDR SWAA116857Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME WEB CRACKED AT BS 500D, LBL 5. REPAIRED WEB PER EA.SDR SWAA116833Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA116822Frame · corrodedDURING SCHEDULED 28Y CHECK, FOUND FRAME CRACKED AT BS 348, WL 209. REPAIRED FRAME EPR SRM.SDR JR2R2011092900437Frame · corrodedFRAME AT FS 364 CORRODED BETWEEN STRINGERS 27 AND 25R. REPAIRED DAMAGED FRAME IAW OE CRJ9-53-0775.SDR JR2R2011092900435Frame · corrodedFRAME 364 CORRODED BETWEEN STRINGER 26R AND 25R. REPAIRED FRAME IAW RO CRJ7-53-0463.SDR FDEA201109284168Frame · crackedFRAME AT BS 970 BETWEEN S26-27L CRACKED. REMOVED FRAME DAMAGED SECTION, FABRICATED NEW FRAME SECTION, SPLICES AND INSTALLED IAW SRM 51-40-3, FIG 1, SRM 53-10-2 FIG 5 & SRM 51-30-2.SDR FDEA201109284186Frame · misrepairedFRAME BS 1500 BETWEEN S22L-25R MISREPAIRED. REMOVED AND REPLACED FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR IPXA11569618Frame · dentedINSPECTION TYPE:C-CK, AFT CARGO COMPARTMENT STA 1520 FRAME DENTED BETWEEN S-26R & S-27R. REPAIRED FRAME IAW SRM 53-00-07-2R, REPAIR 5, DETAIL I.SDR QXEA2011100300923Frame · corrodedFRAME X8.000 LOWER FLANGE HAS CORROSION ABOVE STRINGER 25P JUST BELOW FWD LT PAX DOOR. REMOVED CORROSION IAW SRM 51-21-00-00-02. REMAINING THICKNESS .043", CONFIRMED CRACK FREE REF NTM 51-00-01-250-801. MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW SRM 53-20-SDR IPXA1569478Frame · dentedINSPECTION TYPE:C-CK, FORWARD CARGO COMPARTMENT BS 660 AND STR 24-R FRAME DENTED ON INBD FLANGE. REPAIRED BS 660 FRAME AT STR 24R IAW EO B757-5310-44513-A.SDR JR2R2011092700428Frame · corrodedFRAME AT STA 319.70 CORRODED BETWEEN STRINGERS 26L AND 26R (FWD AND AFT SIDED). CUT OUT DAMAGE AND REPAIRED IAW RO CRJ9-53-0799.SDR JR2R2011092700426Frame · gougedFRAME ATTACH FLANGE AT STATION 364 HAS EDGE DAMAGE BETWEEN STRINGER 10L AND 11L. BLENDED IAW RO CRJ9-53-0783.SDR DALA1155666310Frame · cracked27/240 LEFT BS 1265 FRAME INNER CHORD AND WEB, DONE NDT HFEC INSPECTION. FOUND CRACK INDICATION AT A & B HOLE. MAINTENANCE PERFORMED THE REPAIR PER ER/A 495592-14 AD REV ORIG AT 1900 FLIGHT CYCLES INTERVALS AFTER SECTION I UNTIL SECTION III.SDR DALA1155676310Frame · cracked28/240 RIGHT BS 1265 FRAME INNER CHORD AND WEB, DONE NDT HFEC INSPECTION. FOUND CRACK INDICATION AT A, B, C HOLE. MAINTENANCE PERFORMED THE REPAIR PER ER/A 495593-14 AD REV ORIG AT 1900 FLIGHT CYCLES INTERVALS AFTER SECTION I UNTIL SECTION III.SDR IPXA11M70184Frame · corrodedINSPECTION TYPE:4C FUSELAGE TRANSVERSE FRAME AT STA 1196.75 AFT LOWER FLANGE BETWEEN L50L-L50R HAS HEAVY CORROSION. GAINED ACCESS TO FRAME, CUT-OUT CORRODED FRAME SECTION BETWEEN L50L & L50R. FABRICATED & INSTALLED REPAIR ON STA 1996.75 FRAME IAW SRM 53-00 00
Back to JASC 5311