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 DALA13051883762Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN STA 400 RT RAIL ATTACHMENT FRAME CRACKED BETWEEN STRINGER 8 AND 9. MX REPAIRED PASSENGER CABIN STA 400 RT RAIL ATTACHMENT FRAME BETWEEN STRINGER 8 AND 9 IAW ERA 518615-14AD, REV ORIGINAL.SDR DALA13051820955Frame · corrodedCORROSION ON FRAME AT STA Y=127 AND BETWEEN LONGERONS 17 AND 18R COCKPIT STRUCTURE. FRAME WAS REPLACED IAW SRM 51-30-5 , 51-30-2 AND DWG 9911511, REV "B".SDR CALA2013101000739Frame · crackedINBD RIVET HOLE AT STATION 500A LT SUPPORT BRACKET ATTACH HOLE FOR A/C OUTLET EXTRUSION IS CRACKED BETWEEN STRINGERS 8 & 9. CUT OUT DAMAGED SECTION OF FRAME & INSTALLED REPAIR IAW ECRA 5310-05871 PART 1.SDR SWAA2013121623416Splice · corrodedAFT CARGO COMPARTMENT FRAME SPLICE STRAP CORRODED AT STATION 954, LONGERON 28L. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2013112622788Frame · crackedFUSELAGE FRAME CRACKED AT BS 348, STRINGER 16L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013102921624Frame · crackedFRAME CRACKED AT STATION 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013102921623Frame · crackedFRAME CRACKED AT STATION 907, STRINGER 8R. REPAIRED FRAME IAW EA.SDR REXA2013100902113Frame · corrodedFRAME IS CORRODED AT FS 319 BETWEEN S26-27L. REMOVED CORROSION IAW EO R53277.SDR SWAA2013102821430Frame · crackedFRAME CRACKED AT STATION 360, STRINGER 8R. REPAIRED FRAME IAW EA.SDR FOTR2013102500035Frame · corrodedFRAME AT BS 767 IS CORRODED BETWEEN STR 28L-27L AFT CARGO. REPAIRED.SDR SWAA2013101821275Frame · crackedFUSELAGE FRAME CRACKED AT BS 500C, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821274Frame · crackedFS FRAME CRACKED AT BS 827, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821273Frame · crackedFS FRAME CRACKED AT BS 520, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821272Frame · crackedFS FRAME CRACKED AT BS 500A, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821271Frame · crackedFS FRAME CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821270Frame · crackedFUSELAGE FRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821269Frame · crackedFS FRAME CRACKED AT BS 827, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821268Frame · crackedFS FRAME CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821267Frame · crackedFS FRAME CRACKED AT BS 747, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821266Frame · crackedFS FRAME CRACKED AT BS 727D, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821265Frame · crackedFS FRAME CRACKED AT BS 440, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101821264Frame · crackedFS FRAME CRACKED AT BS 400, STRINGER 8R. REPAIRED FRAME IAW SWA EA.SDR SWAA2013101721255Frame · crackedFRAME CRACKED AT STATION 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013101721254Frame · crackedFRAME CRACKED STATION 727D, STRINGER 8L. REPAIRED FRAME IAW EA.SDR DALA13051673762Frame · crackedDURING INSPECTION, FOUND FWD NOSE COMPARTMENT BS 195 FRAME WEB CRACKED AT S24L. MX REPAIRED IAW SRM 51-70-03, REPAIR 4.SDR DALA13051496811Frame · gougedDURING MAINTENANCE CHECK, SEVERAL GOUGES WERE FOUND IN THE BS 1280, FRAME BETWEEN S10-15L. A NEW FRAME SECTION WAS SPLICED IAW ER/A 56-518272-14.SDR CALA2013100900737Frame · crackedCABIN FRAME AT STATION 440L BETWEEN STRINGER 8L & 9L HAS A CRACK INDICATION DURING INSPECTION WITH MFEC IAW EA 5310- 04716 OPS 2 REV F. FABRICATED & INSTALLED REPAIR ANGLES A & B STATION 440L IAW FIGURE 3 STEPS 1-13 OF EA5310-04716 REV F OP 02.SDR CALA2013100900736Frame · crackedCABIN FRAME AT STATION 480L BETWEEN STRINGER 8L & 9L HAS A CRACK INDICATION DURING INSPECTION WITH MFEC IAW EA 5310-04716 OP 2 REV F. COMPLETED CABIN FRAME CRACK REMOVAL AT STATION 480L BETWEEN STRINGER 8L & 9L IAW EA 5310-04716 REF F.SDR FDEA201310092458Frame · damagedFRAME 58 FOUND DAMAGED BETWEEN STRINGERS 14 AND 15 LEFT. REPAIRED IAW SRM 25-58- 22, CAT B.SDR SWAA2013111322301Frame · crackedFRAME CRACKED AT BS 482, STRINGER 14L. REPAIRED FRAME IAW EA.SDR COEA2013110504923Frame Splice · corrodedDURING HEAVY CHECK, FRAME 8 SPLICE AT BL 0 HAD CORROSION. REPLACED WITH OEM PART.SDR COEA2013110503923Frame Splice · corrodedDURING HEAVY CHECK, FRAME 10 DOUBLER AT STRINGER CUTOUT TO THE RT OF BL 0 HAD CORROSION. REPLACED FRAME SPLICE WITH OEM PART.SDR SWAA2013102821599Frame · crackedFRAME WEB CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW EO & EA.SDR SWIA201334970Frame · corrodedFUSELAGE FRAME AT FS 333.00 IS CORRODED BETWEEN STRINGER 25L & 26R ON FWD & AFT SIDE OF FRAME. C-CHECK REPLACED FS 333.00 LOWER FRAME SECTOR FROM STRINGER 23L TO STRINGER 23R IAW SRM.SDR SWIA201334953Frame · corrodedFS FRAME AT FS 319.70 IS CORRODED BETWEEN STRINGER 25L & 27 ON THE FWD SIDE OF FRAME. C-CHECK REPLACED FS 319.70 FROM STRINGER 23R & STRINGER 23L IAW SRM.SDR SWIA201334952Frame · corrodedFS FRAME AT FS 349.00 IS CORRODED BETWEEN STRINGER 25L & 25R ON AFT SIDE OF FRAME. C-CHECK REPLACED FS 349.00 LOWER FRAME SECTOR IAW SRM.SDR DALA13052880980Frame · crackedDURING SCHEDULED CHECK, UPPER RADIUS OF THE LT OVERWING FRAME TAB AT BS 866 WAS FOUND TO BE CRACKED. REPLACED FRAME IAW AMDS WC 5310-01415-031.SDR CALA2013100800732Frame · crackedCABIN FRAME AT STATION 500F LT BETWEEN STRINGERS 8L & 9L HAS A CRACK INDICATION DURING INSPECTION WITH MFEC IAW EA 5310-047 16 OP2 REV F CABIN FRAME AT STATION 500F LT HAS BEEN CW STEPS 1 THU 13 IAW EA 5310-04716 REF F.SDR DALA13052596812Frame · gougedFUSELAGE FRAME UPPER FLANGE IS GOUGED, STA 1520, BETWEEN S23R AND S26R ACCOMPLISHED PERMANENT REPAIR ON FUSELAGE FRAME STA 1520 BET. S23R AND S26R IAW SRM 53-00-07, FIG 201, REPAIR 5, DETAIL III. REPAIR ON FRAME STA 1520 BET S 23R AND S26R IS A CAT "B".SDR WX0A20131007717Frame · corrodedAFT CARGO BAY FRAME CORRODED BETWEEN LONGERONS 26R AND 26L. CUTOUT DAMAGED AREA, FABRICATED, LOCATED, DRILLED, REPAIR SPLICES, FORMERS, REPAIR PARTS, AND INSTALLED PERMANENT REPAIR IAW SRM 53-03, FIGURE 2A.SDR DALA13049846309Frame · crackedCRACKED FRAME WEB BS 1480, S33L BLG WHEEL WELL. REPAIRED CRACKED FRAME WEB LOCATION BS 1480, S33L IAW ERA 518819-14, REV ORIGINAL.SDR ASOA20131007248Frame · crackedDURING C-CHECK, FRAME 10 SEGMENT BETWEEN STRINGERS 9-10R WAS FOUND TO BE CRACKED, MX R & R FRAME SEGMENT IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR COEA2013120417923Frame · corrodedHEAVY CHECK, MINOR REPAIR. LEVEL 2 CORROSION FOUND ON FRAME 24A WEB, FLANGE & SUPPORT BRACKET. REPAIR IAW SRM 53-91-43 2B, MINOR REPAIR DUE TO SECONDARY STRUCTURE.SDR DALA13050170955Frame · corrodedCORROSION ON FRAME BS 1380 FROM X=-25 TO X=25. FRAME REPLACED IAW SRM 51-30-2 AND 51-30-5, DWG 9912246, REV CE.SDR SWAA2013101821281Frame · crackedFUSELAGE FRAME CRACKED AT BS 520, STRINGER 20L. REPAIRED FRAME IAW SRM.SDR DALA13050680997Frame · crackedWEB ON LEFT SIDE OF CANTED FRAME BS 1485 CRACKED AT 10:00 POSITION. REPAIRED IAW ER/A 519100-14, REV O.SDR DALA13050180956Frame · damagedCRACKED PREVIOUS REPAIR FRAME ON BS 1485 AND X=-16 AT AFT ACCESSORY COMPARTMENT. CRACKED REPAIR REMOVED, DAMAGE FRAME WAS CUT OUT, WAS FABRICATED NEW REPLACEMENT SECTION OF FRAME AND SPLICE, WERE TREATED AND PAINTED AND REPAIR PARTS WERE INSTALLED IAW ER/A 38SDR DALA13050100908Frame · crackedCRACKED FRAME BS 1497 OTBD OF INTERIOR TAILCONE RELEASE HANDLE. COMPLIED WITH PRI 591345-14, REV 0, ER/A 591345-14, REV ORIG.SDR ASOA20131005245Frame · corrodedDURING C-CHECK THE SERVICE DOOR CUTOUT WAS FOUND TO BE CORRODED AT FRAME 22 STRINGER 15R. MX REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW EC5310-01373. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR K9QR201310050587Frame · corrodedFUSELAGE FRAME CORRODED ON FWD FACE AT BS 349, BL 0 - LBL 3. BLENDED FRAME IAW REO 670-53-21-1014, REV A. FOUND TO BE WITHIN LIMITS.
Back to JASC 5311