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 ASAA2013101496371Door Frame · crackedFWD CARGO DOOR AFT FRAME HAS CRACK AT THE INBD UPPER EDGE OF THE VERTICAL FOOTPRINT OF THE TOP STOP PAD FITTING BETWEEN STR 19R AND 20R APPROX .1875 INCHES LONG. ACFT GROUNDED. REPAIRED FRAME IAW SRM 51-40-02-0G-0.SDR SWAA2013110521895Frame · crackedFRAME CRACKED AT STATION 907,STRINGER 8R. R & R FRAME IAW EA.SDR SWAA2013102921672Frame · crackedFRAME CRACKED AT STATION 440, STRINGER 8L. REPAIRED FRAME IAW SW EA.SDR SWAA2013102921671Frame · crackedFRAME CRACKED AT STATION 727B, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013102921670Frame · crackedFRAME CRACKED AT STATION 380, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013102921666Frame · crackedFRAME CRACKED AT STATION 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013102921608Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013102921642Frame · crackedFRAME CRACKED AT STATION 500A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013102921641Frame · crackedFRAME CRACKED AT STATION 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013102921640Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013102821456Frame · crackedFRAME CRACKED AT STATION 727B, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013102821461Frame · crackedFRAME CRACKED AT STATION 500A, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013102821460Frame · crackedFRAME CRACKED AT STATION 500C, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013102821459Frame · crackedFRAME CRACKED AT STATION 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR REXA2013101801164Frame · corrodedMAINTENANCE FOUND CORROSION ON THE LOWER FRAME SECTOR AT FS 605 AS SHOWN IN FIG 1. THE MATERIAL LOSS AFTER BLENDING MEASURES A MAXIMUM OF .018" IN THE WEB OF THE FRAME AND .008" ON THE FLANGE. REPAIRED IAW EA CRJ253-01968A AND ASSOCIATED 8110-3.SDR AALA20131014004Frame · crackedFRAME STATION 1322 & LONGERON 17 RT CRACKED. REPAIR J-ANGLE SRM 53-03-00 FIGURE 51.SDR AALA20131014003Frame · crackedFRAME CRACKED AT LONGERON 17 LT & STATION 1322. INSTALLED REPAIR J ANGLE IAW SRM 53-03-00 FIGURE 51.SDR AALA20131014005Frame · corrodedCORROSION AT FRAME STATION 1155 & LONGERON 26R. INSTALLED DOUBLER IAW EA MD80-53-031966.SDR CALA2013101500741Frame · crackedCABIN FRAME AT STATION 500C RT BETWEEN STRINGERS 8R & 9R HAS A CRACK INDICATION DURING INSPECTION WITH MFEC IAW EA. 5310-0471 6 OP2 REV F. CABIN FRAME AT STATION 500C RT HAS BEEN CW STEPS 1 THROUGH 13 IAW EA 5310-04716 OP2 REV F.SDR CALA2013101500740Frame · crackedCABIN FRAME AT STATION 440R BETWEEN STRINGERS 8R & 9R HAS CRACK INDICATION DURING INSPECTION WITH MFEC, IAW EA. 5310-04716 OP .2 REV. F. CABIN FRAME AT STATION 440R HAS BEEN CW STEPS 1 THROUGH 13 IAW EA 5310-04716 OP2 REV FSDR SWAA2013111222269Frame · crackedFRAME CRACKED AT BS 277, BETWEEN STRINGER 15L & STRINGER 16L. REPAIRED FRAME IAW EO & EA.SDR SWAA2013111122093Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STRINGER 15L TO STRINGER 16L. REPAIRED FRAME IAW SRM.SDR SWAA2013110421834Frame · crackedFRAME CRACKED AT BS 277, STRINGER 16R. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013103121736Former · crackedFORMER CRACKED AT BS 1152, LONGERON 2L. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013102921620Frame · crackedFRAME CRACKED AT BS 715, RBL 57. R & R FRAME IAW SRM.SDR SWAA2013102921610Frame · crackedFRAME CRACKED AT BS 674, RBL 57. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013102821468Former · crackedUNDER WING BARREL KEEL BEAM RT SIDE BS 715 FORMER CRACKED AT OTBD END. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013102821464Former · crackedUNDER WING BARREL KEEL BEAM LT SIDE BS 715 FORMER CRACKED AT OTBD END. R & R FORMER IAW SRM.SDR SWAA2013102821463Former · crackedCANTED KEEL AREA CRACKED FORMER INSIDE LT SIDE AT STATION 679. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013102821462Former · crackedCANTED KEEL AREA CRACKED FORMER ON RT SIDE AT STATION 679. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013110521964Frame · crackedBS 727 FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18L. REPAIRED CHORD IAW EA.SDR SWAA2013110421853Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18R. R & R FLANGE IAW EA.SDR SIMA20131012002Spar · crackedLEFT WING SPAR III CRACKED. REPAIRED SPAR IAW EO EM-57MR-711.SDR SWAA2013102821455Frame · crackedFRAME WEB CRACKED AT STATION 259.5, STRINGER 9L. REPAIRED WEB IAW EA.SDR REXA2013101102040Frame · corrodedFRAME AT FS 319.70 CORRODED BETWEEN S26-27R. REMOVED CORROSION AND RESTORED FINISH IAW EO R53277. ,SDR REXA2013101102039Frame · corrodedFS 295 FRAME CORRODED BETWEEN S26-27R. REMOVED CORROSION AND RESTORED FINISH IAW EO R53277.SDR REXA2013101102038Frame · corrodedFRAME FLANGE CORRODED FS 310 BETWEEN STRINGERS 25 & 26R. R & R IAW SRM 51-52-16 AND EO R53277.SDR REXA2013101102037Frame · corrodedFS 310, FRAME CORRODED BETWEEN S25-26L. REMOVED CORROSION AND RESTORED FINISH IAW SRM 51-21-11, 51-25-16 AND IAW EO R53277.SDR SWAA2013111322320Frame · crackedFUSELAGE FRAME CRACKED AT STATION 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR CALA2013101091939Frame · crackedDURING TENSION TIE INSPECTION, FOUND FRAME HAS CRACK AT ONE HOLE BS 1160 LT. REAMED HOLE IAW AMM 53-10-99. HFEC ALL HOLES, NO CRACKS NOTED IAW NDT PT 6, 51-0 0-00. INSTALLED NEW FRAME .SDR FOTR2013102500242Frame · corrodedSTRINGER 25 AT FRAME 312 HAS CORROSION, E & E BAY. REPAIRED.SDR CHQA20131010377Frame · bentDURING INSPECTION, FRAME 72 WAS FOUND TO BE BENT BETWEEN STRINGERS 15R AND 16R. THE FRAME WAS REPAIRED IAW ETD 2013-145-048739.SDR SWAA2013102221328Frame · crackedFRAME CRACKED AT STATION 420, STRINGER 3L. REPAIRED FRAME IAW SRM.SDR DALA13051953762Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 440 LT RAIL ATTACHMENT FRAME CRACKED BETWEEN STRINGER 8 AND 9. MX REPAIRED PASSENGER CABIN STA 440 LT RAIL ATTACHMENT FRAME BETWEEN STRINGER 8 AND 9 IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051943762Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 440, RT RAIL ATTACHMENT FRAME CRACKED BETWEEN STRINGER 8 AND 9. MX REPAIRED PASSENGER CABIN STA 440 RT RAIL ATTACHMENT FRAME BETWEEN STRINGER 8 AND 9 IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051933762Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 380 LT RAIL ATTACHMENT FRAME CRACKED BETWEEN STRINGER 8 AND 9. MX REPAIRED PASSENGER CABIN STA 380 LT RAIL ATTACHMENT FRAME BETWEEN STRINGER 8 AND 9 IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051923762Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 867, S8L FRAME IS CRACKED. MX REPAIRED PASSENGER CABIN STA 867, 58L FRAME IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051913762Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN S 727B 58R, FRAME IS CRACKED. MX REPAIRED PASSENGER CABIN STA 727B, 58R FRAME IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051903762Frame · crackedDURING INSP, FOUND PASSENGER CABIN BS 480 RT RAIL ATTACHMENT FRAME CRACKED BETWEEN STRINGER 8 AND 9. MX REPAIRED PASSENGER CABIN STA 480 RT RAIL ATTACHMENT FRAME BETWEEN STRINGER 8 AND 9 IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051893762Frame · crackedDURING INSP, FOUND PASSENGER CABIN BS 480 LT RAIL ATTACHMENT FRAME CRACKED BETWEEN STRINGER 8 AND 9. MX REPAIRED PASSENGER CABIN STA 480 LT RAIL ATTACHMENT FRAME BETWEEN STRINGER 8 AND 9 IAW ERA 518615-14AD, REV ORIGINAL.
Back to JASC 5311