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 SWAA2013042915326Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2013042915325Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2013042915324Frame · crackedFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2013042915323Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR DALA1310491401Frame · corrodedFUSELAGE FRAME FOUND CORROSION AT STA 1562, S39L AREA. FRAME REPAIRED IAW ERA.SDR FDEA201304160792Frame · gougedMAIN CARGO FRAME INNER ANGLE OUTER SURFACE AT BS 1681.8 STRINGER1L FOUND GOUGED. R & R FRAME AT STA 1681, STR 4R-4L IAW SRM 51-40-02 AND DWG 146N8712. MAJOR REPAIR.SDR DALA1309961401Frame · crackedCRACK FOUND ON LT SIDE BS 903.5 FRAME INNER CHORD DURING HFEC INSPECTION. REPAIR TO FRAME CARRIED OUT IAW WC 5311-01195-09-03A.SDR DALA1309951401Frame · crackedCRACK FOUND ON RT BS 883.5 FRAME INNER CHORD. REPAIR TO FRAME ACCOMPLISHED IAW WC 5311-01195-09-02B.SDR DALA1309931401Frame · crackedCRACK FOUND ON RT SIDE BS 903.5 FRAME INNER CHORD. DURING HFEC INSPECTION. REPAIRED FRAME IAW CARD 5311-01195-09-03B.SDR FDEA201304160794Frame · gougedR4 DOOR CUTOUT, BS 1681 S11R, FRAME INBD FLANGE GOUGED. COMPLIED WITH EA F-5310-T0300766 GOUGE WAS OUT OF LIMITS IAW SRM 51-60-15, PG 105, DETAIL 4. CAT "B" MAJOR REPAIR.SDR SWAA2013050115400Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2013050115399Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2013042915322Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR HYIA20130416001Spar · damagedDURING A SCHEDULED MX EVENT, DAMAGE WAS NOTED TO THE AFT CARRY THROUGH SPAR. MULTIPLE DAMAGE POINTS WERE DISCOVERED ON THE SPAR FLOOR SUPPORT FLANGE. OPENSDR CALA2013041500218Frame · crackedRT FUSELAGE FRAME STA 380R SHOWS CRACKED INBD FASTENER HFEC. FUSELAGE FRAME STA 380R HAS BEEN REPAIRED IAW EC/RA 5310-05715 ISSUE DIP TO READ "ACCOMPLISH INSPECTION REQUIREMENTS ON OR BEFORE THE ACFT REACHING 50,000 CYCLES. PLANNING TO CONTACT ENGINEERING AFSDR CALA2013041500217Frame · crackedRT FUSELAGE FRAME STA 440R SHOWS FRAME CRACKED INBD FASTENER HFEC. FUSELAGE FRAME STA 440R HAS BEEN REPAIRED IAW EC/RA 5310-05715. ISSUE DIP TO READ:" ACCOMPLISH INSPECTION REQUIREMENTS ON OR BEFORE THE ACFT REACHING 50,000 CYCLES. PLANNING TO CONTACT ENGINSDR DALA13016580946Frame · corrodedCORROSION ON FRAME BS 1332 BETWEEN LONGERONS 22-24R AT AFT CARGO COMPARTMENT (C3). CORROSION WAS REMOVED AND NEW FRAME WAS INSTALLED DWG 9958238 REV CF AND SRM 51-30-2 AND SRM 51-30-5.SDR DALA1312756709Frame · dentedTWO SMALL DENTS ON AFT CARGO COMPARTMENT FUSELAGE FRAME AT BS 1440 BETWEEN STR 26L AND 27L. REPAIRED IAW SRM 53-00-07, REPAIR 5.SDR DALA1312506709Frame · gougedGOUGES ON FUSELAGE FRAME AND SPLICE AT BS 1520 BETWEEN STR 23-26R. REPAIRED FRAME IAW SRM 53-00-02 REPAIR 5.SDR DALA1312480681Frame · gougedGOUGES ON FUSELAGE FRAME AND SPLICE AT STA 1520 BETWEEN STR 23R AND 24R. ACCOMPLISHED REPAIR AT FRAME STA 1520 IAW SRM 53-00-02, REPAIR 5.SDR SIMA20130413006Frame · crackedDURING MBV INSPECTION, QC FOUND FRAME 23 CRACKED BETWEEN STRINGERS 15R AND 16R. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED CRACKED SECTION OF THE FRAME, FABRICATED AND INSTALLED NEW REPAIR PARTS IAW EO EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR REXA2013041600635Frame · chafedFRAME AT FS 718 BETWEEN S-16R AND S-17R CHAFED FROM BRAIDED HYD SYSTEM LINE. REPAIRED IAW EA CRJ253-01496 AND ASSOCIATED 8110-3.SDR DALA1309216801Frame · dentedTWO DENTS ON FUSELAGE FRAME TOP FLANGE RADIUS AREA AT AFT CARGO BAY BS 1480 BETWEEN S25-26L. ACCOMPLISHED REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 5, DETAIL III.SDR DALA1309206801Frame · dentedDENT ON FUSELAGE FRAME TOP FLANGE AT AFT CARGO COMPARTMENT BS 1440 ABOVE S26L. ACCOMPLISHED REPAIR IAW ERA 513678-14, REV ORIG.SDR DALA1309176801Frame · dentedFWD CARGO, RT BILGE FRAME DENTED, BS 640 S25R. CUT OUT DAMAGE SECTION OF FRAME IAW SRM 53-00-07, REPAIR 5. REPAIRED FRAME IAW SRM 53-00-07, REPAIR 5. COMPLIED WITH ERA 513687-14, REV ORIGINAL.SDR FDEA201304130782Frame · gougedMAIN DECK BS 1280 S8-14R FRAME HAS DEEP GOUGES. REMOVED GOUGES IAW SRM 51-10-02, FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101, PG 103. ACCOMPLISHED FRAME, REPAIR 3 FUSELAGE FORMED ZEE FRAME REPAIR IAW SRM 53-00-07. THIS IS A CATEGORY B REPAIR.SDR SWAA2013051716139Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STR 18R. REPAIRED FRAME IAW EA.SDR SWAA2013051716138Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STR 18L. REPAIRED FRAME IAW EA.SDR SWAA2013050615638Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN LONGERON 29L TO LONGERON 29R. REPAIRED FRAME IAW SRM.SDR SWAA2013050615632Frame · crackedFRAME CRACKED AT STA 674, LONGERON 18R. REMOVED AND REPLACED FRAME IAW SRM.SDR UALA2013041502582Frame · gougedAFT CARGO BAY LEFT FRAME GOUGED AT FR 59, S36L. REPAIRED FRAME IAW SRM 53-00-12 FIG 201.SDR AALA20130412016Frame · wornFRAME 1380 HAS WEAR ON FORWARD SIDE, CONTACT WITH TEMPERATURE CONTROL VALVE, LEFT. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-28.SDR FDEA201304110767Frame · corrodedAFT CARGO BILGE HAS CORROSION ON FRAME SKIN NEAR STRINGER 27R AT BS 1480. REMOVED CORROSION FROM FRAME IAW SRM 51-10-02. MAJOR REPAIR.SDR SWAA2013050815849Frame · crackedFRAME CRACKED AT BS 727, OUTBOARD CHORD FORWARD FLANGE, RIGHT LOWER ROW. REPAIRED FRAME IAW EA.SDR SWAA2013050815846Frame · crackedFRAME CRACKED AT BS 727, STR 18L. REPAIRED FRAME IAW EA.SDR DALA1309253748Frame · crackedPASSENGER CABIN FRAME AT BS 500C CRACKED AT STRINGER 8R. REPAIRED IAW ERA 511674-14.SDR SWAA2013050715795Frame · crackedFRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013050715794Frame · crackedFRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013050615623Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN LONGERON 29L TO LONGERON 29R. REPAIRED FRAME IAW SRM.SDR DALA1309921401Frame · corrodedCABIN FRAME BS 1131, BL 0 FOUND CORRODED. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 1, REV 91.02.SDR USAA2013041600012Doubler · corrodedC2 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FORWARD FRAME DOUBLER AT FR16 BETWEEN LBL 11 TO LBL 40. REPLACED FORWARD FRAME DOUBLER AT FR16 BETWEEN LBL 11 TO LBL 40 IAW EMBRAER SRM II 51-41-02, 51-40-02, 51-40-04 & 51-23-04.SDR DALA1309293748Frame · crackedPASSENGER CABIN FRAME AT BS 380 STRINGER 8R CRACKED. REPAIRED IAW ERA 511674-14AD.SDR DALA1309273748Frame · crackedPASSENGER CABIN FRAME CRACKED AT BS 400 AT STRINGER 8L. REPAIRED IAW ERA 511674-14AD.SDR DALA1309263748Frame · crackedBS 440 FRAME CRACKED AT PSU RAIL ATTACH POINT AT STRINGER 8L. REPAIRED IAW ERA 511674-14AD.SDR DALA1308611401Frame · corrodedBS 412 FRAME BETWEEN S15 & 16R FOUND CORRODED OUT OF LIMITS. REPAIRED IAW SRM 53-00-07, FIG 201 REPAIR 1 REV 91-02.SDR ASOA2013050803481Frame · crackedLT FS 718 FRAME PREVIOUS REPAIR SHOWS VISUAL SIGNS OF A CRACK BETWEEN STRINGERS 10L AND 12L. REPLACED SECTION OF FRAME BS 718 FROM STR 5L-21L IAW SRM 51-42-06 AND 51-41-02 TO ACCOMODATE SB 601R-53-055.SDR ASOA2013050803480Frame · crackedRT FS 718, FRAME PREVIOUS REPAIR SHOWS VISUAL SIGNS OF A CRACK BETWEEN STRINGERS 10R AND 12R. REMOVED SECTION OF FRAME STATION 718 BETWEEN STR 5R AND 21R IAW SRM 51-42-06 AND 51-41-02. RECEIVED NEW FRAME SECTION PO 600-36030-24, REQ'S LOCATING AND DRILLING.SDR SWAA2013042415102Frame · crackedFRAME CRACKED AT BS 380, BETWEEN STR 14L AND STR 15L. REPAIRED FRAME PER ER AND EA.SDR SWAA2013042415101Frame · crackedFRAME CRACKED AT BS 380, BETWEEN STR 14L AND STR 15L. REPAIRED FRAME PER ER AND EA.SDR QXEA2013040900773Frame · corrodedFRAME 604.5 IS CORRODED STR 32S-31S. REMOVED CORROSION FROM FRAME IAW SRM 53-00-00-02-09 REV. VERIFIED CRACK FREE IAW NTM 51-00-06-910-801, PART 1, REV 8 ALODINED, PRIMED AND PAINTED IAW SRM 51-21-10-02-01, 51-28-45-02-01, 51-25-10-02-01, AND 51-25-15-02
Back to JASC 5311