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 2008UALA01667Frame · dentedAFT PIT FS 1400 FRAME DENTED STR 26L. CAUSE, UNKNOWN. AFT PIT FS 1400 FRAME DENTED STR 26L. REMOVED DAMAGED SECTION OF FRAME INBOARD FLANGE. FABRICATED -5 'J' DOUBLER AND STRINGER CLIPS AND INSTALLED PER REPAIR 5. THIS IS A CAT B REPAIR IN ZONE 2 AND REQUSDR NWAA081216310Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME RT WEB AT BS 1265 S26R. REPAIRED PER EA 63-212257 SECT I. REPETITIVE INSPECTIONS TO BE ACCOMPLISHED AT 2000 CYCLE INTERVALS PER SECT II UNTIL SECT III PERMANENT REPAIR IS ACCOMPLISHED.SDR SWAA081588Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081587Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR 08FDEA01123Frame · damagedFWD PIT; FS 899, L51L FRAME HAD DOUBLE DRILLED HOLES. REPAIRED IAW SRM 53-00-01 VOL. I FIG. 10.SDR KCSA081203Frame · crackedLOWER FUSELAGE FRAME CRACKED AT BS 2742, BL-0.SDR 08FDEA01118Frame · dentedMAIN DECK LEFT FRAME AT BS 1721 S12L FOUND DENTED. REPAIRED AS PER SRM 53-30-00, FIG.1, VOL.1. INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00, FIG.1, VOL.1. REPAIR CLASSIFIED AS MAJOR ASDR 08FDEA01117Frame · chafedMAIN DECK LT FRAME AT STATION 535 , BETWEEN L23-24L, 1 CHAFED MARK FOUND. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR 08FDEA01116Frame · chafedMAIN DECK LEFT FRAME AT BS 535, BETWEEN L19-20L, 01 EACH CHAFED MARK FOUND NEAR 9G NET YOKE. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR 08FDEA01115Frame · dentedMAIN DECK LEFT FRAME AT STATION 1661, STRINGER 12 LEFT FOUND DENTED. REPAIRED AS PER SRM 53-30-00, FIG.1, VOL.1. INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00, FIG.1, VOL.1. REPAIR CLASSIFSDR 08FDEA01114Frame · dentedMAIN DECK RIGHT FRAME AT BS 1721 S12R FOUND DENTED. REPAIRED AS PER SRM 53-30-00, FIG.1, VOL.1. INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00, FIG.1, VOL.1. REPAIR CLASSIFIED AS MAJOR AS PSDR 08FDEA01113Frame · dentedMAIN DECK RIGHT FRAME AT STATION 1681, STRINGER 12 RIGHT FOUND DENTED. REPAIRED AS PER SRM 53-30-00, FIG.1, VOL.1. INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-30-00, FIG.1, VOL.1. REPAIR CLASSSDR SWAA081572Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081573Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081574Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR KCSA081195Frame · damagedSTA-1780 FRAME WEB DAMAGED AT RBL-17 ABOVE STR-43R.SDR KCSA081194Frame · damagedSTA-1760 RBL-16 FRAME WEB DAMAGED AROUND FASTENERS.SDR QXEA200800316Frame · corrodedPDX - C4- CORROSION ON FRAME CASTELLATION AFT SIDE OF FRAME X597.5 JUST OUTBOARD OF STR 31S. DRILLED OUT THREE RIVETS AND REMOVED CORROSION IAW CPCM CHAPTER 4. HFEC INSPECTED BLEND AREA FOR CRACKS IAW NDTM, PART 6, 51-00-01, NO CRACKS NOTED. UT THICKNESS CHSDR QXEA200800322Frame · corrodedPDX -C4- SUSPECT CORROSION ON FRAME CASTELLATION AT FRAME X580.5 JUST O/B OF STR 31S. REMOVED RIVETS FROM CASTELLATION AND BLENDED OUT CORROSION REF DHC8/200 CPCM CHAPTER 4. HFEC INSPECTED BLEND AREA FOR CRACKS IAW D 8/200 NDTM, PART 6, 51-00-01, NO CRACKS NOSDR 08FDEA01084Frame · corrodedFWD LOWER CARGO BILGE J-CHANNEL IS CORRODED AT BS 899 BETWEEN STR 51L AND STR 51R. REMOVED CORROSION FROM THE LOWER FRAME CAP (J CHANNEL) IAW SRM 51-21-01 VOL II PG 28 & FOUND MATERIAL LOSS EXCEEDED ALLOWABLE LIMITS. ORIGINAL THICKNESS 0.071, MATERIAL REMAINSDR KCSA081187Frame · damagedSTA-1600 FRAME UPPER CHORD DAMAGED AT RBL-15.SDR 08FDEA01071Frame · dentedFOUND DENT AT C74, P26-27 LT/RT REPAIR PERFORMED BY REWORK OF FRAME OUTER FLANGE AT P26 LT/RT, NDT FOR CRACK FREE IAW RAS/EFW/9000010/2008 ISS A, APPROVED BY EA 6-5318-114865SDR USAA920080801Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - A .5" CRACK ON FRAME AT BS 727D BETWEEN STR 8R AND STR 9R. INSTALLED REPAIR IAW SRM TR 53-10-20E.SDR 2008UALA01581Frame · damagedFWD PIT FRAME REPAIR AT STA 800, STR 28L TO STR 28R HAS DAMAGE. ACCOMPLISHED MAJOR REPAIR.SDR 2008UALA01580Frame · damagedFWD PIT REPAIR ON FRAME STA 780 STR 28L AND STR 28R HAS DAMAGE. ACCOMPLISHED MAJOR REPAIR.SDR 2008UALA01579Frame · damagedFWD PIT FRAME AT STA 760 STR 28L TO STR 28R HAS DAMAGE. ACCOMPLISHED MAJOR REPAIR.SDR 2008UALA01577Frame · damagedFWD PIT FRAME REPAIR AT STA 740 STR 28L TO STR 28R. ACCOMPLISHED MAJOR REPAIR.SDR 2008UALA01576Frame · dentedFWD PIT FRAME DENTED STA 540, STR 25L. ACCOMPLISHED MAJOR REPAIR.
SDR 2008UALA01575Frame · damagedFRAME AT BS 800-1420 LBL 5 - RBL 5 S25L REQUIRED REPAIR.SDR 2008UALA01574Frame · damagedAFT PIT STA 1520 BETWEEN S22-23R HAS DAMAGE. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SECTION OF INBOARD FLANGE. FABRICATED & INSTALLED J-ANGLE.SDR SWAA081528Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 1006, STR 17R TO STR 19R. REPAIRED FRAME PER SRM.SDR SWAA081520Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR A6WA200840242Frame · crackedCRACKS EXISTS ON FRAME FS 280 LBL 9. REPAIR ON FLOORBEAM AT FS 280 LBL 9. PERFORMED IAW REO 601R-53-11-171 REV D. (M)SDR A6WA200840241Frame · crackedCRACK FOUND ON FRAME FS 280 RBL 9 AND BRACKET INBOARD. FLOOR STRUCTURE REPAIRED IAW REO 601R-53-11-171 REV D. (M)SDR SWAA081509Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STUB FRAME CORRODED AT BS 312, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA081492Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 26L TO BS 27R. REPAIRED FRAME PER SRM.SDR SWAA081507Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081504Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 727E, STR 27L TO 27R. REPAIRED FRAME PER SRM.SDR SWAA081491Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER ER.SDR SWAA081480Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081479Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081478Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081477Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081476Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081500Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 25L. REPAIRED FRAME PER SRM.SDR CALA0800237Beltframe · corrodedAFT CARGO BILGE AREA - CORROSION AT BELT FRAME, STA 807, APPROX LBL 24. REMOVED CORROSION AND INSTALLED REPAIR AT STA 807 APPROX LBL 24 REF SRM 53-00-07.SDR CALA0800236Frame · corrodedAFT CARGO BILGE AREA - CORROSION ON FRAME AT STA 727E APPROX LBL 24. FABRICATED REPAIR PARTS, TREATED, PRIMED AND INSTALLED REF SRM 53-00-07 REPAIR 5.SDR KCSA081181Frame · damagedAFT PIT BS 2200 FAILSAFE CHORD DAMAGED AT APPROX STR-40L.SDR 2008UALA01515Frame · dentedAFT PIT FS 1460 STR 26L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED FRAME REPAIR.SDR 2008UALA01514Frame · dentedAFT PIT FS 1420 FRAME DENTED STR 26L. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED FRAME REPAIR.
Back to JASC 5311