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 ASOA2013073108819Frame · corrodedCORROSION ON FRAME BS 295 BETWEEN S26L AND 26R. REPAIRED IAW SRM 51-21-06-001-001-A01. REPAIR CLASSIFIED AS MAJOR.SDR SWAA2013072518574Frame · crackedFRAME CRACKED AT BS 747, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013072518573Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013072518572Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013072518571Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013072518570Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013072518569Frame · crackedFRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013072518568Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013072518567Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013072518566Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR FY4Y20130718197Frame · corroded8C CHECK. DURING CPCP INSPECTION, PERFORMED VISUAL INSPECTION AND FOUND LEVEL 2 CORROSION ON LOWER ANGLE OF BS 950 CANTED BULKHEAD BETWEEN S22-23L. BLENDED OUT CORROSION, PENETRATION DEPTH WAS OVER LIMITS IAW SRM 53-10-1, FIG 1.SDR CALA2013071700504Frame · crackedREF EA 5310-04716 REV E, FRAME BETWEEN STRINGER 8 AND 9R AT BS 867 INBD RIVET HAS CRACK EMINATING FROM HOLE VISUALLY AND INDICATED BY NDT. REPAIRED FRAME AT STA 867R IAW EA 5310-04716, REV E.SDR AALA20130808027Frame · damagedFRAME CHORD DAMAGE AT STATION 1640 JUST AFT OF STRINGER 8 RT. BLENDED DAMAGE & INSTALLED DOUBLER IAW B757-53-030942SDR SWAA2013080518823Frame · crackedFRAME CRACKED AT BS 480 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080518822Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080518821Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013080518820Frame · crackedFRAME CRACKED AT BS 360 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080518819Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080518818Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013080518817Frame · crackedFRAME CRACKED AT BS 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR ASOA2013073008806Frame · corrodedFRAME IS CORRODED AT FRAME BS 349 BETWEEN S26-27L. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-972. REPAIR CLASSIFIED AS MAJOR.SDR DALA13035639205Frame · corrodedAFT CARGO COMPARTMENT LT SIDE, BS 1364, LONGERON 23L - 25L, FRAME CORRODED ON AFT SIDE. TASK 53-302-07. R & R FRAME IAW SRM 53-10-02, 51-30-02 AND 51-30-05.SDR CALA2013071700503Frame · crackedFRAME BETWEEN STRINGER 8 AND 9R AT BS 727D INBD RIVET HAS CRACK EMINATING FROM HOLE VISUALLY AND INDICATED BY NDT. REPAIRED FRAME IAW EA 5310-04716, REV E.SDR SIMA20130716005Frame · damagedFRAME 27 HAS AN ELONGATED HOLE AT S15R FLOOR SUPPORT. REPAIRED FRAME 27 AT S15R IAW SRM 53-00-04.SDR SWAA2013080618895Frame · crackedFRAME CRACKED AT BS 328, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW EO & EA.SDR SWAA2013080118742Frame · corrodedFRAME CORRODED AT BS 727B, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013080118741Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013080118740Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STRINGER 27L TO STRINGER 26L. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013073118715Frame · corrodedFS FRAME CRACKED AT BS 767, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR COEA2013073107919Frame · gougedDURING HEAVY CHECKK, FRAME 20 UPPER FLANGE IS GOUGED AND BENT JUST OTBD OF STRINGER 21L. REPAIR IAW SRAS DT/S-4112/13.7905.SDR SWAA2013073018667Frame · corrodedFS FRAME CORRODED AT BS 927.5, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013073018666Frame · corrodedFS FRAME CORRODED AT BS 807, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013072618601Frame · crackedFS FRAME CRACKED AT BS 500C, STRINGER 20R & STRINGER 21R. REPAIRED FRAME IAW SRM.SDR COEA2013071903919Frame · crackedDURING HEAVY CHECK, RT FRAME 26 IS CRACKED AT THE STRINGER 13 CUTOUT. REPLACED IAW SRM 53-25-01 AND 53-51-40, FIG 103.SDR COEA2013071902919Frame · crackedDURING HEAVY CHECK, LT FRAME 26 IS CRACKED AT STRINGER 13L CUTOUT. REPLACED IAW SRM 53-25-01 AND 53-51-40, FIG 103.SDR SIMA20130715013Frame · damagedFRAME 26 HAS AN ELONGATED HOLE AT S15R, REPAIRED FRAME 26 AT S15R IAW SRM 53-00-04.SDR SWAA2013081919320Former · crackedSHEAR TIE CRACKED AT FRAME 1169, LONGERON 2L FORMER. R&R FORMER IAW SRM.SDR ASOA2013080908853Frame · corrodedCORROSION ON TOP PLATE OF FS 349 FRAME BETWEEN 27R AND 42.90R. REMOVED ANGLE, IAW SRM 51-42-21, 51-42-06 ANGLE CORRODED BEYOND LIMITS. INSTALLED ANGLE THAT WAS FABRICATED IAW IAW EO CL600-2B19-53-I00362A INSTALLATION ACCOMPLISHED IAW SRM 51-42-06 AND 51-42-2SDR ASOA2013080608838Frame · corrodedCORROSION ON TOP PLATE OF BS 349, FRAME BETWEEN S9-27R. REPAIRED IAW SRM 51-21-06, 51-42-13, 51-42-06, 51-42-15, 51-42-21.SDR ASOA2013073008803Frame · corrodedCORROSION ON FRAME BS 349 BETWEEN S25-27R. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-972. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013073008802Frame · corrodedCORROSION ON FRAME BS 333 AT S25L. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-972. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013073008801Frame · corrodedCORROISON ON FRAME BS 319 BETWEEN S26-27L. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-972. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013073008800Frame · corrodedCORROSION ON FRAME BS 310 BETWEEN S26L AND 26R. REPAIRED IAW SRM 51-21-06-001-001-A01 AND REO 670-53-21-972. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2013072408763Frame · corrodedFRAME TOP PLATE CORRODED BETWEEN LBL 27-42.9 AT BS 349. REMOVED CORRODED FASTENERS AND REMOVED TOP PLATE AT FS 349, LBL 27 TO LBL 42.9 IAW SRM 51-42-10. RE-INSTALLED FASTENERS IAW SRM 51-42-13. REMOVED COROSION ON BEAM AT FS349 LBL27 TO LBL42.9 IAW SRM 51SDR CALA2013071700502Frame · crackedCABIN FRAME BS 500A LT IS CRACKED AT SUPPORT FITTING ASSY FOR AIR CONDITION EXTRUSION AT INBD FASTENER HOLE. COMPLIED WITH REPAIR INSTRUCTIONS FOR THE FRAME IAW EA 5310- 04719, REV E.SDR CALA2013071700501Frame · crackedCABIN FRAME STA 480, LT IS CRACKED AT SUPPORT FITTING ASSY FOR AIR CONDITION EXTRUSION AT INBD FASTENER HOLE. COMPLIED WITH REPAIR INSTRUCTIONS FOR THE FRAME IAW EA 5310- 04719, REV E.SDR CALA2013071700500Frame · crackedCABIN FRAME BS 440, IS CRACKED AT SUPPORT FITTING ASSY FOR AIR CONDITION EXTRUSION AT INBD FASTENER HOLE. COMPLIED WITH REPAIR INSTRUCTIONS FOR THE FRAME IAW EA 5310-04719, REV E.SDR CALA2013071700499Frame · crackedCABIN FRAME BS 480 RT IS CRACKED AT SUPPORT FITTING ASSY FOR AIR CONDITION EXTRUSION AT INBD FASTENER HOLE. COMPLIED WITH REPAIR INSTRUCTIONS FOR THE FRAME IAW EA 5310- 04719, REV E.SDR CALA2013071700498Frame · crackedCABIN FRAME STA 500D LT IS CRACKED AT SUPPORT FITTING ASSY FOR AIR CONDITION EXTRUSION AT INBD FASTENER HOLE. COMPLIED WITH REPAIR INSTRUCTIONS FOR THE FRAME IAW EA 5310- 04719, REV E.SDR CALA2013071700497Frame · crackedCABIN FRAME BS 400, LT IS CRACKED AT SUPPORT FITTING ASSY FOR AIR CONDITION EXTRUSION AT INBD FASTENER HOLE. COMPLIED WITH REPAIR INSTRUCTIONS FOR THE FRAME IAW EA 5310- 04719, REV E.
Back to JASC 5311