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 AALA20130713004Frame · crackedHFEC & LFEC INDICATES CRACK IN FRAME AT AC RAIL, STATION 500A LT. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159AE.SDR AALA20130713003Frame · crackedHFEC & LFEC INDICATES CRACKS AT A/C FRAME, STATION 727B RT. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159AE-0007.SDR AALA20130713002Frame · crackedFRAME RAIL AT STATION 480 LT BETWEEN STRINGERS 8 & 9 CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR IAW J1159AE.SDR IPXA3579551Frame · crackedINSPECTION TYPE:C-8, MAIN DECK FRAME INNER FLANGE CRACKED BS345, STR 11-12R. FABRICATED AND INSTALLED REPAIR IAW EO B757-5310-51500-A.SDR DALA13034940973Frame · crackedFRAME CRACKED, BS 1437 AT L2R UPPER TAIL INTERIOR OTBD OF RT VERTICAL ATTACH FITTING ON PREV REPAIR. REPAIRED IAW ER/A 516946-14.SDR ASOA20130712187Frame · damagedDURING C-CHECK THE LT FRAME 10 SEGMENT BETWEEN STRINGERS 8L-12L WAS FOUND TO HAVE ELONGATED FASTENER HOLES. MX R & R THE FRAME SEGMENT IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR GLBA2013071200715Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE AFT FUSELAGE FRAME AT BS 509.5 AND STRINGER 3L IN THE FLANGE BEND RADIUS, 1.25" IN LENGTH. REPAIRED IAW EO 13-1900-53-048.SDR GLBA2013071100712Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK ON THE RT FRAME AT FS 451 AND STRINGER 10R IN THE BEND RADIUS, 1.3" IN LENGTH. REPAIRED IAW EO 13-1900-53-049.SDR SWAA2013071118138Beltframe · corrodedBELT FRAME CORRODED AT STATION 1006, BL 0. R&R FRAME IAW DRAWING.SDR AALA20130711001Frame · crackedHFEC & LFEC INSPECTION INDICATES CRACKS AT A/C FRAME, STATION 7271 RT. INSTALLED ANGLES, FILLER & INSTALLED FASTENERS IAWSDR EIAA20130711006Frame · chafedFUSELAGE FRAME CHAFED AT BS 2701 BL 0 INSIDE APU COMPARTMENT. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 51-70-11, FIG. 1.SDR AALA20130710006Frame · crackedHFEC & LFEC INSPECTION INDICATES CRACKS AT A/C FRAME, STATION 727 RT. INSTALLED ANGLES, FILLER & INSTALLED FASTENERS IAW ECO J1159AE CARD 007.SDR AALA20130710005Frame · crackedHFEC & LFEC INSPECTION INDICATES CRACKS AT A/C FRAME. STATION 727 J RT INSTALLED ANGLES, FILLER & INSTALLED FASTENERS IAWSDR AALA20130709004Frame · damagedFRAME DAMAGED & DENTED AT STATION 39 AT LONGERON 19 LT. INSTALLED DOUBLER IAW AARD 53-30-00-02 & INSTALLED NEW FRAME IAW AARD 51-00-05-1 & DRAWING 9911501.SDR SWAA2013080818967Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 25L TO STRINGER 25L. R&R FRAME IAW SRM & DRAWING.SDR FDEA201307081513Frame · dentedAFT CARGO, BS 1540 S25-26L, FRAME UPPER ANGLE DENTED. REMOVED FRAME, IAW SRM 51- 40-02. FABRICATED FRAME. INSTALLED NEW FRAME IAW SRM 51-40-02 AND DWG 146N1048. MAJOR REPAIRSDR FDEA201307081500Frame · dentedLEFT FRAME BS 1741, LONGERON 12L FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 52. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 116.SDR FDEA201307081499Frame · dentedLEFT FRAME BS 1701, LONGERON 12L FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIGURE 201 REPAIR 2 REVISION 52. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 116SDR FDEA201307081498Frame · dentedLEFT FRAME BS 1681, LONGERON 12L FOUND DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201307081497Frame · dentedLEFT FRAME BS 1661, LONGERON 12L FOUND DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR DALA1316676710Frame · dentedAFT CARGO FRAME, BS 1520 BETWEEN STR 25-26L IS DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR FDEA201307081496Frame · crackedFRAME BS 1641, LONGERON 12L FOUND CRACKED. REPAIRED IAW EA 1-5310-T0301233, PART 1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR UALA2013070804740Frame · gougedFWD CARGO FRAME AREA AT BS 600 AT STR 27R, GOUGED. REPAIR ACCOMPLISHED IAW ECRA5330-04657. MAJOR REPAIR.SDR USAA2013071000010Frame · crackedQ4 CHECK -CRACK ON FRAME AT BS303.9, ABOVE S17L. REPAIRED FRAME AT BS303.9, ABOVE S17L IAW ENGINEERING M1L53001.SDR AALA20130707006Frame · crackedCRACK IN AFT WHEEL WALL FRAME AT TOP OTBD END ABOVE FLAP BUS CABLE PULLEYS. INSTALLED REPAIR DOUBLER & -5 JAMB SECTION IAW SRM 51-70-05.SDR AALA20130707002Beltframe · crackedCRACK IN BELTFRAME AT OVERHEAD BIN MOUNT, STATION 727B. ACCOMPLISHED REPAIR IAW ESO J1159-0001.SDR SWAA2013072318473Frame · crackedFRAME CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2013071718311Frame · crackedFRAME CRACKED AT BS 727D STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013071518228Frame · crackedFRAME CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013071518227Frame · crackedFRAME CRACKED AT STATION 500C, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013071518226Frame · crackedFRAME CRACKED AT STATION 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013071518225Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013071518224Frame · crackedFRAME CRACKED AT STATION 440, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013071518223Frame · crackedFRAME CRACKED AT STATION 827, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013071518222Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013071518221Frame · crackedFRAME CRACKED AT BS 727D, STRINGER 8R. REPAIRED FRAME IAW EA.SDR AALA20130705008Frame · crackedFRAME AT STATION 480 RT CRACKED AT BIN RAIL ATTACHMENT BRACKET HOLE. INSTALLED ALL FRAME REPAIR PARTS & FASTENERS IAW ECO J1159AE CARD 0007.SDR ASOA2013072308752Frame · crackedFRAME BS 333 AT 12 O`CLOCK POSITION IS CRACKED IN HALF. REMOVED DAMAGED FRAME SECTION IAW SRM 51-42-06 AND 51-42-20. LOCATED AND DRILLED REPLACEMENT FRAME IAW SRM 51-42-06. REPAIR CLASSIFIED AS MAJOR.SDR REXA2013070301275Frame · corrodedFRAME BS 333 CORRODED BETWEEN STR 25R AND 25L. REMOVED CORROSION FROM FRAME IAW SRM 51-21-06 REO 690-53-21-491 AND EO R53409.SDR DALA13033699205Frame · crackedPASS CABIN BS 480 BETWEEN STR 8 AND 9L FRAME CRACKED. REPAIRED FRAME IAW PRI ERA 516030-14AD, REV O.SDR DALA13033689205Frame · crackedPASSENGER CABIN BS 440 FRAME BETWEEN STR 8 AND 9L CRACKED. REPAIRED FRAME IAW ERA 516030-14AD, REV O.SDR DALA13033679205Frame · crackedPASSENGER CABIN BS 440 BETWEEN S8 AND 9R FRAME CRACKED. REPAIRED FRAME IAW ERA 516030-14AD, REV O.SDR DALA13033669205Frame · crackedPASSENGER CABIN BS 480 BETWEEN STR 8 AND 9 RIGHT FRAME CRACKED. REPAIRED FRAME IAW ERA 516030-14AD, REV O.SDR SWAA2013071118109Frame · crackedFRAME CRACKED AT STATION 986, STRINGER 19R. R&R FRAME SECTION IAW SRM & DRAWING.SDR AALA20130709003Beltframe · crackedCABIN BELLFRAME 867 HAS CRACK AT OVERHEAD BIN ATTACH BRACKET. CUT OUT DAMAGE & INSTALLED REPAIR DOUBLER IAW ECO J1159AE.SDR AALA20130709002Beltframe · crackedCABIN BELLFRAME 827 HAS CRACK AT OVERHEAD BIN ATTACH BRACKET. CUT OUT DAMAGE & INSTALLED REPAIR DOUBLER IAW ECO J1159AE.SDR DALA13033730929Frame · crackedCANTED FRAME AT BS 1474, TAIL INTERIOR. CRACKED AT FASTENER 4:00 POSITION. REMOVED CRACKED SECTION. HFEC INSP CUTOUT 2" X 1.5" IAW NDT SPM 06-10-01.001, NO DEFECTS NOTED. INSTALLED DOUBLER IAW SRM 51-70-5. IDENTIFIED REPAIR "P" WITH TAG. JOB COMPLET. REQSDR REXA2013070301084Frame · corrodedMX FOUND CORROSION TO THE LOWER SECTOR OF THE FRAME AT FS 319.7 BETWEEN S26R AND S26L. REPAIRED IAW EA CRJ253-01691.SDR SIMA20130702005Frame · damagedDURING MX BASE VISIT INSPECTION, FOUND FRAME 68, HAS MARRED UP AREAS AROUND SCREW HOLES, FOR INTERIOR PANELS. REMOVED FROM SERVICE. REPAIRED FRAME 68 IAW EO EM-53MR2151-R1. RETURNED TO SERVICE.SDR SIMA20130702001Frame · gougedDURING MX INSEPCTION FOUND GOUGES ON FRAME 68 BETWEEN STRINGERS 9L AND 11L. THE ACFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 68 IAW EO EM-53MR-2151 R1. THE ACFT WAS RETURNED TO SERVICE.
Back to JASC 5311