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 USAA920081971Frame · crackedCLT Q5 MAJOR REPAIR NR 03C20853011/012 CRACK AT FRAME 500E BETWEEN S20L AND S21L. REPAIRED FRAME 500E BETWEEN S20L AND S21L IAW SRM 53-00-07, REPAIR 13.SDR USAA920081968Frame · crackedCLT Q3 MAJOR REPAIR NR 03055380546/002 CRACK IN FRAME/SIDE FRAME AT BS 500D AT FASTENER JUST BELOW S13L. REPAIRED FRAME/SIDE FRAME AT BS 500D AT FASTENER JUST BELOW S13L IAW TYPICAL REPAIR NR 53-10-21A.SDR 08FDEA04547Frame · damagedAFT PIT BS 1090 FRAME HAS DOUBLE DRILLED HOLE INBD OF TIEDOWN FITTING AT S27R. REPAIRED IAW SRM 51-40-3. FABRCATED BRACKET IAW DWG 69-44106 TREATED, PRIMED IAW SRM 51-10-2. THIS CLASSIFIED AS A MAJOR REPAIR.SDR 08FDEA04546Frame · damagedAFT PIT BS 1130 FRAME UPPER CHORD HAS TRIPLE DRILLED HOLE INBD OF TIE DOWN FITTING AT S27R. CUTOUT DAMAGE, REMOVED FASTENERS FROM FRAME AT REPAIR AREA. FABRICATED REPAIR ANGLE & HEAT TREATED TO T6 CONDITION. TREATED, PRIMED, & INSTALLED FRAME REPAIR ANGLESDR 08FDEA04545Frame · damagedAFT PIT BS 1130 FRAME UPPER CHORD HAS DOUBLE DRILLLED HOLE IB OF TIE DOWN FITTING AT S27L. REMOVED AND INSTALLED FLOOR SUPPORT BRACKET, TIE DOWN BRACKET, FLOOR SUPPORT REF 51-30-2. REPAIRED DAMAGED FRAME REF SRM 51-40-3 FIG 1. TREATED AND PRIMED REF SRM 51-10SDR 08FDEA04544Frame · wornFUSELAGE UPPER LOBE INTERIOR STRUCTURE, FRAME 1166 SCRATCHED RBL 68 AT STR R11- R12 BLENDED DAMAGE REF SRM 53-10-1 PG 1-2A, OUT OF LIMITS, HEAT TREATED NEW REPAIR. REMOVED DAMAGE REF SRM 51-40-3 PG 1-6. TREATED AND PRIMED REPAIR REF SRM 51-20-13 AND 51-20-2SDR 08FDEA04542Frame · damagedAFTER REMOVAL DOUBLER FROM TV MONITOR SUPPORT FOUNDED SEVERAL HOLES ON FRAME AT STA, 1020 REPAIRED FRAME IAW SRM 53-00-07 REPAIR NR 3, THIS IS A CATEGORY "B" REPAIR WITH THE FOLLOW-UP INSPECTION. HFEC INSPECTION EVERY 12,000 F/C AS GIVEN IN NDT PART. 6 ,51-0SDR FDEA200810244533Frame · damagedAFTER REMOVAL OF DOUBLER FROM TV MONITOR SUPPORT, BS1340, S-4L - S-4R, FOUND SEVERAL HOLES ON FRAME. REMOVED DAMAGE IAW SRM 53-00-07, REPAIR 3. FABRICATED AND INSTALLED REPAIR PARTS AT BS 1340, S-4L - S-4R, IAW SRM 53-00-07, REPAIR 3. REPAIR PARTS FABRICATESDR FDEA200810244532Frame · damagedAFTER REMOVAL OF DOUBLER FROM TV MONITOR SUPPORT, AT BS 1360, FOUND SEVERAL HOLES ON FRAME. REMOVED DAMAGE AT BS 1360, S-4L - S-4R, IAW SRM 53-00-07, REPAIR 3. FABRICATED AND INSTALED REPAIR PARTS, BS 1360, S-4L - S-4R, IAW SRM 53-00-07, REPAIR 3. REPAIR PARSDR AALA200810148Frame · crackedCRACK IN 905 FRAME AT LONGERON 18L. INSTALLED NEW FRAME AT STATION 905 PER ADK 3290AC.SDR 08FDEA04537Frame · damagedMAIN CARGO DOOR AREA AT STA 663.542, LONGERON 28, UPON SPOOL BACK UP FITTING REMOVAL, REPAIR BUSHINGS WERE FOUND IN FRAME P/N ACA 7230-6 AND ANGLE P/N ACA 7230-8. REPAIRED FRAME, ANGLE AND SHEAR TIE IAW FEDEX EA 8-5310-123514 TITLE "FUSELAGE STA 663.542 MCD SSDR COMA0860441Frame · crackedLT FS 640 FRAME DOUBLER AND BONDED SKIN DOUBLER ARE CRACKED. REMOVED DAMAGED PARTS AND COMPLIED WITH MODIFICATION K601R36009-3 ON LT FS 640 FRAME AND DOUBLER PER S/B601R-53-061 KIT DRWG. K601R36009 REV B, 601R-53-61-506 REV C AMD 601R53-61-569.SDR USAA920082003Frame · crackedCLT Q5 MAJOR REPAIR NR 03C20853011/014 AND 4262806 FRAME CRACKED AT 500B BETWEEN S20L AND S21L. REPAIRED FRAME AT 500B BETWEEN S20L AND S21L IAW US AIRWAYS EA NR 100705.SDR USAA920081943Frame · crackedCLT Q3 MAJOR REPAIR NR 03-0553-8-0546/003 CRACK IN FRAME/SIDE FRAME AT BS520 BELOW S13L. REPAIRED FRAME/SIDE FRAME AT BS520 BELOW S13L IAW US AIRWAYS TYPICAL REPAIR 51-10-21A.SDR KCSA081542AFrame · crackedBS 960 FUSELAGE FRAME CRACKED AT STR 39LSDR KCSA081541Frame · crackedBS 880 FUSELAGE FRAME CRACKED BETWEEN STR 39R AND STR 40R.SDR USAA920081977Frame · crackedCLT Q5 MAJOR REPAIR NR 03C20853011/019 CRACK AT FRAME BS500B, BETWEEN S20L AND S21L. REPAIRED FRAME AT BS500B, BETWEEN S20L AND S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA920081978Frame · crackedCLT Q5 MAJOR REPAIR NR 03C20853011/017 AND 03C20853011/016 FRAME STIFFENER CRACKED AT BS 500E BETWEEN S20L - S21L AND S20R - S21R. REPAIRED FRAME STIFFENER AT BS 500E BETWEEN S20L - S21L AND S20R - S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA920081970Frame · crackedCLT Q5 MAJOR REPAIR NR 03C20853011/005 CRACK IN FRAME AT LIGHTNING HOLE AT BS 500D BETWEEN S20R TO S21R. REPAIRED FRAME AT LIGHTNING HOLE AT BS 500D BETWEEN S20R TO S21R IAW SRM 53-00-07.SDR USAA920081955Frame · crackedCLT MAJOR REPAIR Q5 CHECK NR 03C20853011/007, CRACKED FRAME AT BS 500C, S20L - S21L. REPAIRED FRAME AT BS 500C, S20L - S21L IAW B737 SRM 53-00-07.SDR SWAA085739Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 727E, RBL 17, WL 150. REPAIRED FRAME PER SRM.SDR CALA0801002Frame · crackedBODY STATION 360 LT SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED FRAME AT BODY STATION 360L BETWEEN S-8 AND S-9 IAW EA 5310-04498.SDR CALA0801001Frame · crackedBODY STATION 400L FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S8 AND S9. REPAIRED FRAME AT BODY STATION 400L BETWEEN S-8 AND S-9 IAW EA 5310-04498.SDR CALA0801000Frame · crackedBODY STATION 440 LT SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRD FRAME AT BODY STATION 440 LT SIDE AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9 IAW EA 5310-04498.SDR CALA0800997Frame · crackedBODY STATION 747 RT SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED BODY STATION 747 RIGHT FRAME AT S8 AND S9 PER EA 5310-04498.SDR CALA0800994Frame · crackedBODY STATION 867 RIGHT FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED BODY STATION 867 RIGHT FRAME AT S8 AND S9 PER EA 5310-04498.SDR CALA0800993Frame · crackedBODY STATION 787R FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED BODY STATION 787 RIGHT FRAME AT S8R AND S9R PER EA 5310-04498.SDR CALA0800992Frame · crackedBODY STATION 907R FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED BODY STATION 907 RIGHT FRAME AT S8R AND S9R PER EA 5310-04498.SDR CALA0800991Frame · crackedBODY STATION 827R FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED BODY STATION FRAME 827 RIGHT AT S8R AND S9R PER EA 5310-04498.SDR CALA0800990Frame · crackedBODY STATION 482 RT SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. CUT OUT DAMAGE ON FRAME AT STATION 482 BETWEEN S8R AND S9R, REPAIRED SAME IAW EA 5310-04498.SDR CALA0800989Frame · crackedBODY STATION 787L FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. CUT OUT DAMAGE ON FRAME AT BODY STATION 787L BETWEEN S-8 AND S-9. FABRICATED REPAIR PARTS AND INSTALLED PER EA 5310-04498.SDR CALA0800988Frame · crackedBODY STATION 440 RT SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S8 AND S9. CUT OUT DAMAGE ON FRAME AT STATION 440 BETWEEN S8R AND S9R REPAIRED SAME IAW EA 5310-04498.SDR CALA0800987Frame · crackedBODY STATION 827L FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. CUT OUT DAMAGE ON FRAME AT BODY STATION 827L BETWEEN S-8 AND S9. FABRICATED REPAIR PARTS AND INSTALLED PER EA 5310-04498.SDR CALA0800985Frame · crackedBODY STATION 867 LT SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. CUT OUT DAMAGE ON FRAME AT BODY STATION 867L BETWEEN S8 AND S9. FABRICATED REPAIR PARTS AND INSTALLED PER EA5310-04498.SDR CALA0800983Frame · crackedBODY STATION 400R FRAME CRACKED AT AIR CONDITION (A/C) BRACKET BETWEEN S-8 AND S-9. CUT OUT DAMAGE ON FRAME AT STATION 400 BETWEEN STR 8R AND 9R, REPAIRED SAME IAW EA 5310-04498.SDR CALA0800977Frame · crackedLEFT FUSELAGE FRAME IS CRACKED AT PSU RAIL SUPPORT BRACKET MOUNT RIVET LOCATED BETWEEN STRINGERS 8 AND 9 AND STATION 360. REMOVED SUPPORT RAIL AND ACCOMPLISHED REPAIR PER ECRA 5311-01428.SDR USAA920081939Frame · crackedCLT Q3 MAJOR REPAIR NR 03C10753039/006 FRAME CRACKED AT BS847 BETWEEN S8L AND S9L. REPAIRED FRAME AT BS847 BETWEEN S8L AND S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR 2008UALA06246Frame · dentedAFT CARGO COMPT, FRAME AT BS 1500 LT AND STR 25L HAS A DENT AT INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06245Frame · dentedAFT PIT, BS 1440LT, STR 23-25L, FRAME INBOARD FLANGE DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED FRAME SECTION AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06243Frame · dentedAFT PIT BS 1420LT, STR 24L, FRAME INBOARD FLANGE DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06242Frame · dentedAFT PIT BS 1400, LT SIDE STR 24L, FRAME INBOARD FLANGE DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 2008UALA06239Frame · crackedCRACK ON FRAME, FWD OF R-2 DOOR CUTOUT, BS 665, STR. 12R. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED WEB AND INSTALLED NEW WEB.SDR 08FDEA04483Frame · corrodedAFT LOWER CARGO PIT STA 1010 BETWEEN STR 28R AND 27R FRAME CORRODEDSDR 08FDEA04473Frame · wornCABIN BS 360 S4R FRAME INNER CHORD WORN. BLENDED AREA, FOUND OUT OF LIMITS IAW SRM 53-10-04. FABRICATED REPAIR PART IAW SRM 53-10-04, REMOVED DAMAGE AND INSTALLED FARICATED REPAIR PART IAW SRM 53-10-4. TREATED AND PRIMED. THIS IS CLASSIFIED AS A MAJOR REPAIRSDR SWIA200821046Frame · damagedFS 437 STR 27R AND 26R FRAME FLANGE DAMAGED, DAMAGE REPAIR. REPAIRED PER REO.SDR SWIA200821045Frame · damagedFRAME AT FS 409 (STRINGER 27) DAMAGED, DAMAGE REPAIR. REPAIRED PER REO.SDR SWIA200821044Frame · damagedFRAME 220 FROM STR 16R-26R DAMAGED, DAMAGE REPAIR. REPLACED PER SRM.SDR SWIA200821040Frame · damagedFS 169 MACHINED FRAME/BULKHEAD DAMAGED, DAMAGE REPAIR. REPLACED FRAME PER SRM.SDR USAA920081938Frame · crackedCLT Q3 MAJOR REPAIR NR 03C10753039/007 FRAME CRACKED AT BS907 JUST ABOVE S9L. REPAIRED FRAME AT BS907 JUST ABOVE S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR 2008UALA06229Frame · dentedFWD PIT AT STA 600, STR 23L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.
Back to JASC 5311