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 CALA2013080890247Frame · mismanufacturedBS 1265, FRAME MISMANUFACTURED. REPAIRED IAW ECRA 5310-05788.SDR CALA2013080690172Frame · crackedBS 1265, FRAME WEB, NR 1 FASTENER HOLE CRACKED. REPAIRED.SDR CALA2013080700539Frame · crackedFRAME BS 480 BETWEEN S8-9L, A/C OUTER EXTRUSION ATTACHMENT BRACKET CRACKED AT INBD RIVET. REPAIRED FRAME IAW EA 5310-04716.SDR CALA2013080700538Frame · crackedFRAME BS 400 BETWEEN S8-9R, AIRCONDITIONING OUTER EXTRUSION ATTACHMENT BRACKET CRACKED AT INBD RIVET. REPAIRED FRAME IAW EA 5310-04716, REV E.SDR ASOA20130806353Frame · crackedC-CHECK, FRAME 10 WAS FOUND CRACKED NEAR THE DV WINDOW DRAIN. MX R & R FRAME IAW 53-11-00.SDR SWAA2013082619506Frame · crackedFRAME CRACKED AT STATION 907 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013082219445Frame · crackedFRAME CRACKED AT STATION 907 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082119406Frame · crackedFRAME CRACKED AT STATION 907, STRINGER 8L. REPAIRED FRAME IAW AAR EA.SDR USAA2013081500006Frame · crackedDURING 2S CHECK, FOUND A CRACK ON FUSELAGE FRAME AT BS 440 BETWEEN S8-9L. REPAIRED FRAME IAW TR 737- 5310-10-287.SDR USAA2013081500005Frame · crackedDURING 2S CHECK, FOUND A CRACK ON FUSELAGE FRAME AT BS 727F BETWEEN S8R TO S9R. REPAIRED FRAME IAW TR 737- 5310-10-287.SDR SWAA2013081219081Frame · crackedFRAME CRACKED AT STATION 727B, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219080Frame · crackedFRAME CRACKED AT STATION 827, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081219079Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081219078Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081219077Frame · crackedFRAME CRACKED AT STATION 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219076Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219075Frame · crackedFRAME CRACKED AT STATION 380, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219074Frame · crackedFRAME CRACKED AT STATION 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081219073Frame · crackedFRAME CRACKED AT STATION 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219072Frame · crackedFRAME CRACKED AT STATION 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219071Frame · crackedFRAME CRACKED AT STATION 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219049Frame · crackedFRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED FRAME IAW EA.SDR CALA2013080700545Frame · crackedFRAME BS 500A, S8-9R, AIR CONDITIONING OUTER EXTRUSION ATTACHMENT BRACKET IS CRACKED AT INBD RIVET. INSTALLED REPAIR IAW EA 5310-04716, REV E.SDR CALA2013080700544Frame · crackedFRAME BS 380 BETWEEN S8-9R, AIR CONDITIONING OUTER EXTRUSION ATTACHMENT BRACKET IS CRACKED AT INBD RIVET. INSTALLED REPAIR IAW EA 5310-04716, REV E.SDR CALA2013080700543Frame · crackedFRAME BS 440, BETWEEN S8-9R, AIR CONDITIONING OUTER EXTRUSION ATTACHMENT BRACKET IS CRACKED AT INBD RIVET. FRAME REPAIRED IAW EA 5310-04716, REV E.SDR CALA2013080700542Frame · crackedFRAME BS 747, BETWEEN S8-9L, AIR CONDITIONING OUTER EXTRUSION ATTACHMENT BRACKET IS CRACKED AT INBD RIVET. REPAIRED FRAME IAW EA 5310-04716 REV E.SDR CALA2013080700541Frame · crackedFRAME BS 480 BETWEEN S8-9R, AIR CONDITIONING OUTER EXTRUSION ATTACHMENT BRACKET IS CRACKED AT INBD RIVET. INSTALLED FRAME REPAIR IAW EA-5310-04716, REV E.SDR SWAA2013082119416Frame · crackedRT FS FRAME WEB CRACKED AT STATION 259.5, STRINGER 9R. REPAIRED WEB IAW EA.SDR SWAA2013081919326Frame · crackedFRAME CRACKED AT BS 520, STRINGER 8L. REPAIRED FRAME IAW SRM.SDR SWAA2013081219041Frame · crackedFRAME CRACKED AT BS 727B STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081219040Frame · crackedFRAME CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081219039Frame · crackedFRAME CRACKED AT BS 727B, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013103021704Frame · crackedRT OVERWING FRAME 715 CRACKED. R & R FRAME SRM & DRAWING.SDR SWAA2013103021703Frame · crackedRT OVERWING FRAME 696 CRACKED. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013082719618Frame · corrodedFRAME CORRODED ON UPPER FLANGE AT BS 947 LBL 9. R&R FRAME IAW SRM.SDR USAA2013081900032Frame · crackedDURING Q3 CHECK, THREE CRACKS FOUND ON FUSELAGE FRAME BS 400 BETWEEN S8-9L. REPAIRED FRAME IAW TR 737-5310-10-0287.SDR USAA2013081900031Frame · crackedDURING Q3 CHECK, TWO CRACKS FOUND ON FUSELAGE FRAME BS 380 BETWEEN S8-9L. REPAIRED FRAME IAW TR 737-5310-10-0287.SDR SWAA2013081919328Frame · crackedFRAME AT CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW ER & EA.SDR CHQA20130802312Frame · bentDURING INSPECTION, FRAME 72 WAS BENT BETWEEN STRINGERS 14-15R. FRAME REPAIRED IAW SRM 53-00-04.SDR SWAA2013081519235Frame · crackedFRAME AT CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013081519234Frame · crackedFRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081419203Frame · crackedFRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013081319160Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR FDEA201308021751Frame · corrodedAFT CARGO, BS 1280 BETWEEN S28-29L FRAME LOWER WEB CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL I. R & R FRAME IAW DWG 146N1005, SH3 REV E AND SRM 51-40-02. MAJOR REPAIR.SDR USAA2013080500015Frame · corrodedC3 CHECK - CORROSION ON AFT CARGO AFT FRAME AT BS 845, S25R. REPLACED AFT CARGO AFT FRAMER IAW SRM 51-40-02 & DWG 65-47960.SDR GLBA2013080200289Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE COCKPIT RT SIDEWALL FRAME AT FS 107 AT UPPER FASTENER, .5" IN LENGTH. REPAIRED IAW EO 13-1900-53-053.SDR SWAA2013080218808Frame · corrodedFRAME CORRODED AT STATION 908, LONGERON 30. REPAIRED FRAME IAW SRM.SDR SWAA2013090919970Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727, STRINGER 18A CENTER LINE LT SIDE. REPAIRED CHORD IAW EA & EO.SDR SWAA2013090919961Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727, STRINGER 18A CENTER LINE RT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2013082619504Frame · crackedFRAME CRACKED AT BS 907 STRINGER 8R. REPAIRED FRAME IAW EA.
Back to JASC 5311