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 ASAA0781864Frame · corrodedAFT CARGO FORMER CORRODED. REMOVED DAMAGED AREA OF FORMER FABRICATED, LOCATED, DRILLED AND INSTALLED A REPLACEMENT FORMER IAW SRM 51-10-3 PG 24.SDR DHL2007784527Frame Splice · crackedMAIN CABIN FRAME BS 783.95, LBL 70, WL 204 IS CRACKED LWR END OF WEB AREA, CRACK ABOUT 1.5 NDT FINDING. REMOVED FASTENERS AT MAIN CABIN FRAME AT LWR END IAW B727 SRM 51-30-2. STOP DRILLED CRACK .250 IAW B727 SRM 51-10-1. HFEC VERIFIED STOP DRILL IAW B727 NDSDR UPS07450273Frame · crackedINSPECTION TYPE:C M/D RT BS 2231 FRAME INNER CHORD S23R-25R FOUND 2 HOLES CRACK AT FRAME STRAP, CRACK LENGTH 1/16" AND 0.040". M/D BS 2231 FRAME ATTACH INNER CHORD AND STRAP AT BEN STR 22R TO STR26R AREA REPAIRED AS PER SRM 53-10-04 FIG 115. CONTINUE INSP RESDR UPS07450250Frame · crackedINSPECTION TYPE:C M/D LT BS2231 FRAME INNER CHORD S24L-25L FOUND 1 HOLE CRACK AT FRAME STRAP RUNNING FWD APPROX 1/8". M/D BS2231 FRAME ATTACH INNER CHORD AND STRAP REPAIRED BTN STR22L TO 26L AREA AS PER SRM 53-10-04 FIG 115. CONTINUE INSPECTION ARE REQ AS PESDR TRAX200700958Frame · corrodedFRAME AT FS 349.00 HAS CORROSION ON FWD FRAME DOUBLER AND AFT SIDE OF FRAME AT STR 27. REMOVED UPPER RIVETS AT STA 349 TOP OF FRAME AT FRAME DOUBLER AND REMOVED LT AND RT INTERCOSTAL SPLICES AT STA 364 FRAME TOP SIDE PER SRM 51-42-06, 51-42-20. REMOVED 4 EA SDR TRAX200700957Frame · corrodedFRAME AT FS 333.00 HAS CORROSION AT STR 27.SDR DLM88070896Frame · corrodedFOUND CORROSION ON FRAME AT STA. Y=1309 LONGERON 27 RT-28 LT, TASK 57-53300. REPAIRED PER SRM 53-01 FIG 1 ON N/R T0061108 AT HMV.SDR DLM88070884Frame · crackedCRACK ON FORMER STA Y=905 X=-58. DOUBLER MANUFACTURED PER SRM 51-70-5 FIG 1 ON N/R T0060286 HMV-3.SDR TRAX200700948Frame · corrodedSTA 605 FRAME HAS CORROSION BETWEEN STR 27 AND 26 LEFT. COMPLIED WITH EC/TC REO 601R-53-61-2260.SDR AWXA200700970Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961307, CRACKED FRAME WEB/UPPER RING, BS 663.75, S2L. REPAIRED FRAME WEB/UPPER RING, BS 663.75, S3L - S3R IAW B737-300 SRM 53-00-07-2R9 FIGURE 201.SDR AWXA200700922Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961279 AND 5961288, CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME, BS 480, S9L AND S9R IAW USAIRWAYS EA 120121.SDR AWXA200700918Frame · crackedMAJOR REPAIR - C-20 CHECK - NR 5961289, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700917Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961278, CRACKED FRAME, BS 440, S9L. REPAIRED FRAME, BS 440, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700913Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961287, CRACKED FRAME, BS 500A, S9R. REPAIRED FRAME, BS 500A, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700904Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961268, CRACKED FRAME FOOT, BS 360 S14R - S15R. REPAIRED FRAME FOOT, BS 360 S14R - S15R IAW B737-300 SRM 53-00-07-2R3.SDR QXEA200701135Frame · corrodedC4 PDX - MAINTENANCE REQUEST, CORROSION ON FRAME X467.00 BETWEEN STRINGERS 30R AND 31R. REPAIRED IAW SRM 51-20-16, 51-40-11, 51-20-36, 51-20-26.SDR QXEA200701134Frame · corrodedC4 PDX - MAINTENANCE REQUEST, CORROSION ON FRAME X488.500 BETWEEN STRINGER 25R AND 28R. REPAIRED IAW SRM 51-40-11, 51-20-36, 51-20-36.SDR QXEA200701133Frame · corrodedC4 PDX - MAINTENANCE REQUEST, CORROSION ON FRAME X488.500, BETWEEN STRINGERS 29R AND 31R. REPAIRED IAW SRM 51-40-11, 51-20-36, 51-20-26.SDR TRAX200700934Frame · corrodedFS 473.15 FRAME IS CORRODED ON RT SIDE INBOARD JUST ABOVE FLOOR LEVEL. BLENDED CORROSION AT FS 473.15 IAW CRJ 200 SRM 53-00-00, FOUND TO BE IN LIMIT. ALODINED, PRIMED AND PAINTED. SUPPLEMENTAL - SDR CLOSED 07/13/07.SDR TRAX200700933Frame · corrodedCORROSION AT FS 280 FRAME TO FS 295 FRAME BETWEEN STRINGERS 26L AND 26R BL 0 (MARKED). REMOVED CORROSION FROM FS 295 LOWER FRAME. DAMAGE FOUND TO BE WITHIN LIMITS IAW CRJ 700 SRM 53-21-06. REMOVED AND REPLACED FOUR SOLID RIVETS ON FS 295 FRAME ON RT SIDE OSDR SWAA073335Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073345Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA073337Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073336Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073340Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073339Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073338Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR AWXA200700934Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981847, CRACKED FRAME, BS 727E, S9R. REPAIRED FRAME, BS 727E, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700925Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981451, CRACKED FRAME, BS 887, S9R. REPAIRED FRAME, BS 887, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700924Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981843 AND 5981849, CRACKED FRAME, BS 827, S9L AND S9R. REPAIRED FRAME, BS 827, S9L AND S9R IAW USAIRWAYS EA 120121.SDR AWXA200700923Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981845 AND 5981452, CRACKED FRAME, BS 907, S9L AND S9R. REPAIRED FRAME, BS 907, S9L AND S9R IAW USAIRWAYS EA 120121.SDR AWXA200700921Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981844, CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700920Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981850, CRACKED FRAME, BS 867, S9R. REPAIRED FRAME, BS 867, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700919Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981841, CRACKED FRAME, BS 787, S9L. REPAIRED FRAME, BS 787, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700916Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981848, CRACKED FRAME, BS 767, S9R. REPAIRED FRAME, BS 767, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700915Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981840, CRACKED FRAME, BS 767, S9L. REPAIRED FRAME, BS 767, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700914Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981842, CRACKED FRAME, BS 807, S9L. REPAIRED FRAME, BS 807, S9L IAW USAIRWAYS EA 120121.SDR ASAA0781851Frame · corrodedAFT CARGO FRAME CORRODED AT BS 1322 BETWEEN LONG 29R AND LONG 29L. REMOVED DAMAGED AREA OF FRAME, LOCATED, DRILLED AND INSTALLED A REPLACEMENT FRAME AND SPLICE PARTS IAW SRM 53-03 FIG 2A, 51-30-2 PG 1 AND 51-30-5 PG 1.SDR ASAA0781850Frahm · corrodedAFT CARGO FRAME CORRODED AT BS 1287 BETWEEN LONG 29L AND LONG 29R. REMOVED DAMAGED SECTION OF FRAME, LOCATED, DRILLED A REPLACEMENT FRAME IAW SRM 53-3 FIG 2A AND DAC DWG 9957739.SDR ASAA0781849Frame · corrodedAFT CARGO FRAME CORRODED AT STA 1250 BETWEEN LONG 29L AND LONG 29R. REMOVED DAMAGED SECTION OF FRAME, LOCATED DRILLED AND INSTALLED A REPLACEMENT FRAME IAW SRM 51-03 FIG 2A AND 51-30-5 PG 12 AND 13.SDR UPS07450300Frame · crackedINSPECTION TYPE:C LT BS 940 TENSION TIE NR 1 FASTENER HOLE FOUND CRACK AT WEB DOUBLER RUNNING 5 O/C POSITION APPROX 1/16" IN LENGTH. M/D BS 940 LT SIDE FRAME DOUBLER THROUGH FRAME TENSION TIE, STEEL PLATE AND FAIL/SAFE CHORD HOLE OVERSIZED AND FASTENER INSTALSDR UPS07450299Frame · crackedINSPECTION TYPE:C LT BS 940 TENSION TIE NR 1 FASTENER HOLE FOUND CRACK AT FRAME RUNNING 7 O/C POSITION APPROX 0.040" IN LENGTH (LOOKING AFT). M/D BS 940 LT SIDE FRAME THROUGH FRAME DOUBLER, TENSION TIE, STEEL PLATE AND FAIL/SAFE CHORD HOLE OVERSIZED AND FASTESDR UPS07450295Frame · crackedINSPECTION TYPE:C RT BS 820 TENSION TIE TO FRAME CONNECTION AREA FOUND HOLE NR 4 CRACK AT FRAME WEB DOUBLER APPROX 0.040". M/ BS 820 RT TENSION TIE TO FRAME WEB ATTACH DOUBLER REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND EO B747-5310-23715-C AND SRM 51SDR DLM90070914Frame · damagedSTA 446 LONGERON 28L HAS DOUBLE DRILLED HOLES. FABBED NEW FORMER PER DRAWING. INST PER SRM 53-10-02D, REF N/R 1000-0320.SDR 07FDEA02369Frame · crackedLOWER CENTER CARGO COMPARTMENT, FLOORBEAM AT FRAME 1741 CRACKED AT LBL 1"-5" AND RBL 2.5"-4" ON UPPER FLANGE. REPAIRED BY CUTTING OUT DAMAGE AND FABRICATING AND INSTALLING FILLER AND REPAIR ANGLES IAW MD/DC 10 SRM 53-00-01 FIG 9 VOL I. ALODINED AND PRIMEREDSDR SWAA073296Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073295Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073297Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073298Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073294Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311