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 QXEA200701065Frame · corrodedC4 PDX - CORROSION UNDER FLOOR AT STATION 201 AT STRINGER 31L FITTING CASTING ON VERTICAL FRAME. REPAIRED IAW SRM 51-40-11.SDR QXEA200701062Frame · corrodedC4 PDX-CABIN UNDER FLOOR LEFT AT FRAME X467.00 AND BETWEEN STRINGER 30L AND 31L, FRAME CASTELLATION HAS CORROSION AT FASTENERS. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-30-26.SDR QXEA200701054Frame · corrodedC4 PDX - CORROSION AT FORWARD LOWER FLANGE OF FRAME X467.00, JUST OUTBOARD OF LEFT STRINGER 24. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-30-26, AND 51-20-51.SDR QXEA200701063Frame · corrodedC4 PDX-CABIN UNDER FLOOR LEFT AT FRAME X467.00 AND BETWEEN STRINGER 29L AND 30L, FRAME CASTELLATION HAS CORROSION AT FASTENERS. REPAIRED IAW SRM 51-20-11, 51-40-11, AND 51-20-51.SDR QXEA200701056Frame · corrodedC4 PDX-CORROSION AT LOWER FORWARD FLANGE X467.00, JUST OUTBOARD OF LEFT STRINGER 26. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-30-26, AND 51-20-51.SDR QXEA200701055Frame · corrodedC4 PDX - CORROSION AT FORWARD LOWER FLANGE OF FRAME X467.00 JUST OUTBOARD OF LEFT STRINGER 25. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-30-26, AND 51-20-51.SDR NWAA072326716Frame · crackedDURING "L" CHECK, FOUND CRACK IN FRAME AT BS 1800 S11R. REPAIRED PER EA 67-209723.SDR SWAA073174Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 600, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA073173Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SWA EA.SDR CALA0700320Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FORWARD CARGO DOOR CUTOUT FORWARD FRAME AT LOWER STOP PAD, STA 440, S16R TO S27R. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR KCSA071195Frame · damagedAFT PIT FUSELAGE FRAME WEB DAMAGED AT BS 1810 BETWEEN STR 39R AND STR 40R.SDR QXEA200701064Frame · corrodedC4 PDX - CORROSION UNDER FLOOR AT STATION 201 AT STRINGER 31R FITTING CASTING ON VERTICAL FRAME. REPAIRED IAW SRM 51-40-11.SDR QXEA200701059Frame · corrodedC4 PDX-CABIN UNDER FLOOR LEFT AT FRAME X270.500 AND BETWEEN STRINGER 30L AND 31L, FRAME CASTELLATION CORROSION AT FASTENERS. REPAIRED IAW SRM 51-20-11, 51-40-11, AND 51-20-26.SDR CALA0700317Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FORWARD CARGO DOOR CUTOUT AFT FRAME AT LOWER PAD FITTING, STA 480-500, S16R TO S27R. A NEW FRAME WAS INSTALLED IAW SRM 51-40-02.SDR SIMA200720429Frame · damagedDAMAGE BETWEEN FRAME 67 AND STRINGERS 15R AND 16R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB IC2007-145/04150. RETURNED AIRCRAFT TO SERVICE.SDR NWAA072436716Frame · crackedDURING "L" CHECK, FOUND CRACK IN FUSELAGE FRAME AND DOUBLER AT BS 360 S24L. REPAIRED PER EA 67-209717.SDR QXEA200701030Frame · corrodedC4 PDX - CABIN UNDER FLOOR CENTER AT FRAME X488.5 AND STRINGER 32L - 33 HAS CORROSION ON THE FRAME CASTELLATION. REPAIRED IAW SRM 51-20-11, 51-20-16.SDR QXEA200701031Frame · corrodedC4 PDX - CABIN UNDER FLOOR CENTER AT FRAME X488.5 AND STRINGER 31L-32L HAS CORROSION ON THE FRAME CASTELLATION AT THE OUTBOARD EDGE. REPAIRED IAW SRM 51-20-11, 51-20-16.SDR SWAA073140Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073132Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073131Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073139Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073138Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073137Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073136Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073135Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073134Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073133Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073141Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA070475Frame · crackedAROUND INBOARD LOCK FASTENER HEAD AT STA 867 BETWEEN S81 & S91 HAS CRACK. CUT OUT DAMAGE & INSTALLED DOUBLER PER TR 53-10-20E, DEFECT SIZE: .0625 INCH.SDR USAA070478Frame · crackedFUSELAGE FRAME STA 787 BETWEEN STR 8L & 9L AT A/C PSU RAIL ATTACH BRACKET HAS CRACK. CUT OUT DAMAGE & INSTALLED REPAIR DOUBLERS PER TR 53-10-20E, DEFECT SIZE: .0625 INCH.SDR USAA070479Frame · crackedBS 440 FWD CARGO DOOR FWD FRAME WL 180 HAS CRACK. REMOVED DAMAGE & INSTALLED REPAIR PARTS PER SRM 51-10-02 & DWG 65-20722, DEFECT SIZE: .125 INCH.SDR USAA070480Frame · crackedBS 492 FWD CARGO DOOR AFT FRAME S-24R WL 163 HAS CRACK. REMOVED & REPLACED FWD CARGO AFT FRAME PER SRM 51-10-02, DWG 65-20723, DEFECT SIZE: .500 INCH.SDR 07FDEA02248Frame · corrodedAFT PIT SHEAR TIE CORRODED STA 970 BETWEEN STRINGER 28-29L REMOVED SHEAR TIE, REMOVED CORROSION ON SIDE OF FRAME. CUT SHEAR TIE FROM FRAME. FABRICATED SHEAR TIE REPAIR FROM 7075-0 .071, HEAT TREATED TO T-6 CONDITION ON SNRM NR N01032, 8130 TRACKING NR 2007-SDR SWAA073098Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 360, STR 14L. REPAIRED BELTFRAME PER SRM.SDR SWAA073095Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073094Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA073104Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE STUB FRAME CORRODED AT BS 847, STR 13R. REPAIRED FRAME PER SRM.SDR SWAA073107Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA073106Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA073105Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 747, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA073113Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 18L. REPAIRED FRAME PER EA.SDR SWAA073112Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17R. REPAIRED FRAME PER EA.SDR SWAA073111Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073110Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR QXEA200701046Frame · corrodedC4 PDX - CABIN UNDER FLOOR CENTER AT FRAME X531.50 AND STRINGER 32R THERE IS CORROSION ON THE STRINGER ATTACH CLIP SPLICE. REPAIRED IAW SRM 51-40-11, 51-20-36 AND 51-20-51.SDR QXEA200701045Frame · corrodedC4 PDX - CABIN UNDER FLOOR CENTER AT FRAME X510.00 AND BETWEEN STRINGER 31R NAD 32R THERE IS CORROSION ON THE FRAME CASTELLATION. REPAIRED IAW DHC-8 SRM 51-40-11, 51-20-36 AND SRM 51-20-51.SDR QXEA200701050Frame · corrodedC4 - PDX CORROSION AT FRAME FORWARD FLANGE APPROXIMATELY X545.00 JUST OUTBOARD OF RIGHT STRINGER 31. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16, 51-00-01 AND SRM 51-20-51.SDR DLM88070811Frame · crackedCRACK ON FRAME ANGLE AT STA 1416 CANT LONGERON 6 LT. REPAIRED PER DRAWING 9977858 ITEM 160 ON NR T0058491.SDR SWAA073074Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 16L. REPAIRED FRAME PER SRM.
Back to JASC 5311