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 SWAA080637Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080636Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080635Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080634Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080633Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080647Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA080632Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA080631Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME PER SRM.SDR DL757080338Frame · corrodedSURFACE CORROSION ON FRAME AT FS 690 RBL 13. FABRICATED "U" CHANNEL IAW B757 DRAWING 453N1853 AND SRM 51-70-11. INSTALLED IAW SRM 51-40-02.SDR TRAX200800186Frame · corrodedLIGHT SURFACE CORROSION ON FRAME AT FS 645.00 BETWEEN BL 27L AND 27R AND BELLY SKIN JUST AFT OF FRAME INSIDE FWD CARGO BAY. CLEAN IMMEDIATE SURROUNDING AREA AND INSPECT FOR FURTHER CORROSION DAMAGE.SDR SWAA080617Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65. REPAIRED FRAME PER SRM.SDR KCSA081066Frame · dentedAFT BILGE FUSELAGE FRAME UPPER CHORD IS DENTED AT STA 1780, RBL 51.SDR C2XA08SH014Frame · corrodedSHV - DURING C-CHECK FRAME 65 HAS CORROSION AT STR 17L. MX REPAIRED FR 65 STR 17 IAW EC 5310-01432. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR CA080227004Frame · cracked(CAN) THE UPPER RT ATTACH POINT ON THE AIRFRAME SIDE CRACKED ON THE FRAME RING ONLY. PART REPLACED WITH NEW FROM MFG. (TC NR 20080227004)SDR UPS08551705Frame · dentedINSPECTION TYPE:C2 FRAME DENTED AT BS 1260, STR 26-27R. REPAIRED PER SRM 53-00-07, SRM 51-70-11-0G.SDR 2008UALA00596Frame · crackedMID CABIN STUB FRAME AT BS 616 LEFT SIDE BELOW WL 208 CRACKED. INSTALLED ANGLE REPAIR.SDR KCSA081053Frame · corrodedFOUND FUSELAGE FRAME WEB IS CORRODED AT STA-1680 AT LBL-50.SDR SIMA200806006Frame · corrodedDURING MBV INSP, A PREVIOUS REPAIR ON FRAME 258 WAS FOUND CORRODED. REPAIR, REMOVED THE EXISTING REPAIR AND CLEANED THE AREA. PERFORMED A CUTOUT, FABRICATED A REPAIR ANGLE, FILLER AND DOUBLER. CLEANED AND TREATED THE REPAIR PARTS AND INSTALLED. REPAIR DONESDR TRAX200800156Frame · crackedLT WHEEL WELL FR 26 CRACKED. REPLACED IAW 51-25-04.
SDR SWAA080575Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA080565Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA080576Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080585Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA080577Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR QXEA200800172Frame · corrodedPDX - C5 CHECK - FRAME CASTELLATION AT STATION X333.3 AFT FACE OF FRAME BETWEEN STRINGERS 23L AND 24L HAS SUSPECT CORROSION. REPAIRED IAW DHC8 200 CPM CHAPTER 4 STEP 8, NDTM PT-1 51-00-04 AND PT-6 51-00-01, DHC8 200 SRM 51-20-11, 51-12-16, 51-20-51 AND 51-40SDR 08FDEA00545Failsafe · corrodedFUSELAGE, CORROSION FOUND ON TOP SURFACE OF RT FWD PAX DOOR FAIL/SAFE RING, BETWEEN FR 14 AND 14B. FAIL/SAFE RING REPAIRED IN ACCORDANCE WITH FEDEX EA 6-5310-117229 AND RAS/AS/023/2008 ISSUE A.SDR NWAA080446308Failsafe · crackedDURING "M" CHECK, FOUND FAIL/SAFE CHORD FASTENER HOLES CRACKED AND WITH SHORT EDGE MARGIN AT BS 1140 RT AND LT. REPAIRED PER EA 63-211705.SDR USAA920080335Frame · crackedCLT - MAJOR REPAIR - FPBH INSP - NR 6005985 AND 03-0553-8-0385-1, FORWARD CARGO DOOR CUT OUT AFT FRAME CRACKED, BS 492.4, S24R. REPAIRED FORWARD CARGO DOOR CUT OUT AFT FRAME, BS 492.4, S24R IAW USAIRWAYS EA 100205.SDR 2008UALA00506Frame · dentedAFT PIT FRAME DENTED AT STR 26L STA 1420 ON INBOARD FLANGE. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR 2008UALA00505Frame Splice · damagedAFT PIT STA 1520 BETWEEN STR 24R AND 25R FRAME SPLICE HAS TOOL MARKS. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR SWAA080554Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 336, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA080553Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 320, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA080551Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291, STR 16R. REPAIRED SKIN PER EA.SDR SWAA080529Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 278, STR 21R. REPAIRED FRAME PER SRM.SDR MWEA080020Doubler · corrodedCORROSION ON STAR DOUBLER LOCATED ON TOP OF FRAME AT STATION 944 AND LONGERON 29 RIGHT. BLENDED CORROSION, FABRICATED AND INSTALLED DOUBLER.SDR USAA920080298Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME UPPER CHORD, BS 663.75, S3L, S1, S2R, S3R. REPAIRED FRAME UPPER CHORD, BS 663.75, S3L, S1, S2R, S3R, IAW B737 SRM 53-00-07-2R9 FIGURE 201.SDR DHL2008765010Frame · gougedDURING C CHECK, FUSELAGE FRAME GOUGED AT BS 480 BELOW STRINGER 17L. BLENDED AREA AT BS 480 BELOW STRINGER 17L, ORIGINAL MATERIAL 0.150", MATERIAL REMAINING WAS APPROXIMATE 40% OF THICKNESS LEAVING 60% FOUND TO BE WITHIN LIMITS IAW EO NR OE-N765AT-1-25-08. TRSDR DHL2008765009Frame · damagedDURING C CHECK, 2 MISDRILLED HOLES IN FUSELAGE FRAME STRINGER 18L BS 480. REMOVED AND REINSTALLED HINGE ASSEMBLY AT FRAME, STRINGER 18 BS 480 IAW STC DRAWING 727021025-1, DRILLED THROUGH THE TWO HOLES AND INSTALLED MS20426AD6-6 RIVET FLUSH IAW DRAWING NR 7270SDR UPS08851651Frame · crackedINSPECTION TYPE:C2 POSSIBLE CRACK ON STA 980 FRAME IN C-PIT AT L36. REMOVED CRACKED L ANGLE AT STA 980, DRILLED UP NEW L ANGLE AND INSTALLED AT STA 980 AT L36.SDR CALA0800094Frame · crackedFUSELAGE FRAME CRACKED AT STA 847 BETWEEN STRINGER 8L AND 9L. REPAIR PER ECRA 5310-04697.SDR CALA0800093Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 887 BETWEEN STRINGER 8L AND 9L. REPAIRED PER ECRA 5310-04697.SDR CALA0800092Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 867 BETWEEN STRINGER 8L AND 9L. REPAIRED PER ECRA 5310-04697.SDR CALA0800091Frame · crackedFUSELAGE FRAME IS CRACKED AT BS 767 BETWEEN STRINGER 8R AND 9R. REPAIR DONE PER ECRA 5310-04697.SDR CALA0800090Frame · crackedCABIN FRAME IS CRACKED AT STA 380 RIGHT ABOVE STRINGER 8R AT SUPPORT BRACKET. REPAIRED PER ECRA 5310-04697.SDR ZZDA2008064Frame · crackedCRACK AT TAIL COMPARTMENT, RIGHT CANTED FRAME 1178.225 BETWEEN LONG 13 AND 14 R. INSTALLED FORMED CHANNEL REPAIR ON RIGHT CANTED 1178.225 PER SRM 41-70-11 F 201.SDR ZZDA2008063Frame · crackedTWO CRACKS FOUND AT INT TAIL COMP LT SIDE CANTED FRAME STA 1178.225 BETWEEN LONG 13L AND 14L. INSTALLED FORMED CHANNEL REPAIR ON CANTED FRAME LT STA 1178.225 PER B717 SRM 51-70-11 FIG 201.SDR SWAA080521Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800086Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 727E BETWEEN STRINGER 8L AND 9L. REPAIRED PER ECRA 5310-04697.SDR CALA0800085Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 767 BETWEEN STRINGER 8L AND 9L. REPAIR PER ECRA 5310-04697.SDR CALA0800084Beltframe · crackedFUSELAGE CROWN INTERIOR BELT FRAME HAS CRACK AROUND FASTENER OF OVERHEAD GRILL MOUNTING BRACKET JUST ABOVE STRINGER S9R AT STA 480.
Back to JASC 5311