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 CALA0800500Frame · crackedRIGHT-HAND STATION 827 AT S-8 AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME RIGHT-HAND STATION 827 S8R PER EA 5310-04498.SDR CALA0800499Frame · crackedRIGHT-HAND STATION 747 AT S8R AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME RIGHT-HAND STATION 747 S8R PER EA 5310-04498.SDR CALA0800498Frame · crackedRIGHT-HAND STATION 440 AT S8R AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME RIGHT-HAND STATION 440 S8R PER EA 5310-04498.SDR CALA0800497Frame · crackedRIGHT-HAND STATION 400 AT S8R AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME RIGHT-HAND STATION 400 S8R PER EA 5310-04498.SDR CALA0800496Frame · crackedRIGHT-HAND STATION 380 AT S8R AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME RIGHT-HAND STATION 380 S8R PER EA 5310-04498.SDR CALA0800495Frame · crackedRIGHT-HAND STATION 787 AT S8R AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME RIGHT-HAND STATION 787 S8R PER EA 5310-04498.SDR CALA0800494Frame · crackedLEFT-HAND STATION 787 AT S8L AIR CONDITIONING (A/C) BRACKET INBOARD MOUNT HOLE CRACKED. REPAIRED CRACKED FRAME AT LEFT-HAND STATION 787 S8L PER EA 5310-04498.SDR SWAA082885Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082886Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082887Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082888Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA02010Frame · dentedAFT CABIN AT APPROXIMATELY STATION 1721 LEFT SIDE LONGERON 12 LEFT FOUND FRAME DENTED. CARRIED OUT REPAIR AS PER SRM 53-30-00, REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100.SDR 08FDEA02009Frame · dentedAFT CABIN AT APPROXIMATELY STATION 1761 LEFT SIDE LONGERON 12 LEFT FOUND FRAME DENTED. BS 1761 LT LONGERON 12 LT FRAME CARRIED OUT REPAIR AS PER SRM 53-30-00, FIG.1, VOL.I. DUE TO CAT B REPAIR, INITIAL INSPECTION TO BE CARRIED OUT AT 14,500 CYCLE, WITH REPETSDR 08FDEA02008Frame · dentedAFT CABIN AT APPROXIMATELY STATION 1701 RIGHT SIDE LONGERON 12 RIGHT TO LONGERON 13 RIGHT FOUND FRAME DENTED. AFT BS 1701 FRAME RT LONGERON 12 TO 13 RT CARRIED OUT REPAIR AS PER SRM 53-30-00, FIG.1, VOL.I. DUE TO CAT B REPAIR, INITIAL INSPECTION TO BE CARRSDR 2008UALA03042Frame · damagedFRAME WEB AT STA 1219 BETWEEN STR 37 TO 38L HAS AN ELONGATED FASTENER HOLE. MAJOR REPAIR ACCOMPLISHED, CUTOUT DAMAGE. INSTALLED NEW SHEARTIE.SDR SWAA082834Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082835Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082836Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082874Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082879Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082872Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082873Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR 08FDEA01999Frame · corrodedAFT PIT BILGE BODY FRAME UPPER FLG IS BUCKLED/CORRODED BS 1050, STR 26L-28L, WL 148 (MKD). REMOVED CORROSION ON AFT PIT BILGE BODY FRAME UPPER FLG STA 1050 STR 26L 28L WL148. ORIGINAL THICKNESS IS .063 REMAINING MATERIAL IS .061, .002 REMOVED FOUND TO BE INSDR 08FDEA01988Frame · damagedAFT PIT BILGE BODY FRAME UPPER FLG IS BUCKLED, BS 1070, STR 25R - 27R DAMAGE ON FRAME FLANGE FOUND TO BE OUT OF LIMITS PER SRM 53-10-1 PG 1-3 DETAIL 4 NOTE 5. REMOVED DAMAGE, NDT VERIFIED DAMAGE REMOVAL. VERIFIED MATERIAL FOR REPAIR DOUBLER, 7075 - O - .06SDR DHL2008764527Frame · dentedWHILE AT C-CHECK, DENT AT MAIN FRAME BS 580 BETWEEN STR 16 AND 17R. REPAIRED IAW SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3, 7075T6 .050 DIM 7.125" X 6.25" PO 9006742.SDR SWAA082856Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA082849Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082848Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR KCSA081257Stiffener · damagedFUSELAGE FRAME STIFFENERS (2EA) AND STRINGER CLIP DAMAGED AT BS 2280, STR-12R.SDR USAA920081141Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - NR O3C10753045/14, CRACKED FUSELAGE FRAME, BS 360, S16R. REPAIRED CRACKED FUSELAGE FRAME, BS 360, S16R IAW US AIRWAYS EA 100485.SDR 2008UALA02986Attach Fitting · crackedFUSELAGE FRAME 360 LEFT AFT SIDE OUTBOARD ATTACH CLIP CRACKED AT STR 13L. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED CLIP.SDR CALA0800486Frame · crackedFUSELAGE FRAME IS CRACKED AT STATION 827 BETWEEN S8L AND S9L. INSTALLED FRAME REPAIR PER ECRA 5310-04774.SDR DHL2008764521Frame · dentedDENTS ON MAIN CABIN FRAME BS 640 BETWEEN STR 16 AND 17R. CUT OUT DAMAGED AREA AT FRAME BS 640 BETWEEN STR 16 & 17 RT APPROX 7/8" X 1", FAB DOUBLER REPAIR WITH 7075-T6 .050", DIM 7" X 5" AND PO 9006742 IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1.SDR SWAA082789Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 3L. REPAIRED FRAME PER SRM.SDR SWAA082790Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 2L. REPAIRED FRAME PER SRM.SDR SWAA082776Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, STR 17L. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA082775Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, STR 17R. REMOVED AND REPLACED CHORD PER SRM.SDR CALA0800484Frame · crackedFRAME CRACKED STATION 360 ABOVE S9L. REPAIRED FRAME AT STATION 360 S9L PER ECRA 5310-04775.SDR QXEA200800533Frame · corrodedPDX-C4 CHECK - THE LOWER FLANGE ON FRAME X71.2 BETWEEN STR 31&32L HAS CORROSION. REMOVED CORROSION IAW D8/400 RD8/4-53-2344 STEPS 1&2. HFEC INSPECTED IAW Q400 NDTM PART 6 61-00-01 NO CRACKS NOTED. UT THICKNESS CHECK IAW Q400 NDTM PART 151-00-04 HIGH .040 LOSDR COMA0860250Frame · crackedCARGO COMPARTMENT UNDERFLOOR FRAME SECTOR AT FS 605 IS CRACKED. REMOVED AND REPLACED WITH SERV FRAME IAW CRJ SRM 51-42-06 AND COMAIR SR99-5140-0001.SDR COMA0860247Frame · corrodedDURING A 72/48 MO INSPECTION, TASK CRJ-2-142005, FOUND FUSELAGE FRAME CORRODED ON TOP EDGE AND CRACKED ON LOWER EDGE. PERFORMED PERMANENT REPAIR IAW REO 601R-53-11-136.SDR 2008UALA02954Frame · dentedAFT PIT STA 1540 BETWEEN STR 25R AND 26R FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE. INSTALLED ANGLE REPAIR. INSTALLED NEW SPLICE PLATE & 2EA STR CLIPS (P/N 140N2001).SDR 08FDEA01928Frame · corrodedAFT PIT BILGE BODY FRAME UPPER FLG IS CORRODED BS 103, STR 26R - 28R, WL 147 REMOVED .007 INCH FROM ORIGINAL MATERIAL OF .063 INCHES WITH .056 INCH REMAINING AND FOUND FRAME TO BE OUT OF LIMITS. HEAT TREATED, DRILLED TREATED, PRIMED AND PAINTED, REPAIR DOUBLESDR 08FDEA01924Frame · dentedMAIN DECK TRANSVERSE FRAME REPAIR AT STA 1701 L=12R FOUND DENTED. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. INITIAL INSPECTION REQUIRED AT 14,500 CYCLES AND REPETITIVE INSPECTION AT EVERY 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00 FIGURE 1 VOLSDR ABXA080166Frame · crackedRIGHT AFT MAIN FRAME FS 737, FRAME CRACKS EXCEEDS LIMITS OF EXSISTING 5935650. FRAME HAD CRACKS AT FORWARD POINTS H & I AND AFT FLANGE POINTS G & J. REMOVED & REPLACED MAIN FRAME IAW DC9 SRM. (A)SDR NWAA082396623Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME INNER CHORD STRAP HOLE AT BS 800 S16R. REPAIRED PER EA 66-212931.SDR USAA920081143Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 795, S22R. REPAIRED FRAME, BS 795, S22R IAW B737 SRM 51-10-02.SDR MWEA080078Frame · corrodedLIGHT CORROSION EVIDENT AT LOWER FLANGE OF FUSELAGE FRAME STATION AT 908, AT ATTACH POINT WITH LONGERON 30 RIGHT. FLANGE IN AFT CARGO COMPARTMENT. REMOVED DAMAGE SECTION OF FLANGE, FABRICATED AND INSTALLED FLANGE.SDR DHL2008764507Frame · gougedWHILE AT C CHECK REF N/R 097896, 4 EACH TOOLING MARKS/GOUGES ON MAIN CABIN FRAME BS 700 BETWEEN S7-8L. REPAIRED IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3 MATERIAL 7075-O PO NR 9006027 HEAT TREATED FROM 7075-O TO 7075-T6 IAW FAS ENGINEERING REPORT NR 2-3715SDR DHL2008764506Frame · dentedWHILE AT C CHECK REF N/R 098177, DENT ON MAIN CABIN FRAME BS 600 BETWEEN STR 16 AND 17R. REPAIRED IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3 MATERIAL 7075-T6 .050 INCH DIMENSION 7 INCH BY 5 1/4 INCH PO NR 9006153.
Back to JASC 5311