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 A6WA201307014142Frame · damagedFRAME AT FS 589, BELOW CARGO FLOOR, LT SIDE DAMAGED. REPAIRED IAW EA 15-2013-285.SDR A6WA201307014141Frame · damagedFRAME AT FS 574 BELOW CARGO FLOOR LT SIDE DAMAGED. REPAIRED IAW STS EA 15-2013-284.SDR DALA13033573755Frame · crackedDURING INSPECTION FOUND PASSENGER CABIN RIGHT SIDE BS 500F STR 8R FRAME CRACKED AT PSU RAIL ATTACH POINT. MX REPAIRED IAW PRI 514904-14AD REV ORIGINAL AND ERA 514904-14AD REV ORIGINAL.SDR DALA13033563755Frame · crackedDURING INSPECTION FOUND PASSENGER CABIN RT SIDE, BS 480, S8R FRAME CRACKED AT PSU RAIL ATTACH POINT. MX REPAIRED IAW PRI 514904-14AD REV ORIGINAL AND ER/A 514904-14AD, REV ORIGINAL.SDR DALA13033553755Frame · crackedDURING INSPECTION FOUND PASSENGER CABIN LT SIDE STATION 480, STR 8L FRAME CRACKED AT PSU RAIL ATTACH POINT. MX STARTED REPAIR IAW ERA 514904-14AD. ERA SUPERCEEDED BY ERA 516028-14AD. THIS REPAIR ACCOMPLISHED ON WO 27480-2400-0050, CARD NR 2018993 ER/A 516028SDR DALA13033543755Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN RT SIDE, BS 500F, S8R FRAME CRACKED AT PSU RAIL ATTACH POINT. MX REPAIRED STATION 500F, STR 8R IAW ERA 514904-14AD REV ORIGINAL.SDR DALA13033533755Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN RT SIDE STA 480, STR 8R FRAME CRACKED AT PSU RAIL ATTACH POINT. MX ACCOMPLISHED FRAME REPAIR AT STATION 480 STR 8R FRAME IAW ERA 514904-14AD, REV ORIGINAL.SDR FDEA201307011440Frame · corrodedAFT CARGO, BS 1520 S25R FRAME CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND OUT OF LIMITS IAW SRM 53-00-53, FIG 101, DET II, PG 103, REMOVED DAMAGED FRAME AND INSTALLED FABRICATED FRAME IAW SRM 51-40-02 AND DWG 146N1030 . MAJOR REPAIR.SDR FDEA201307011436Frame · dentedFWD CARGO BAY BS 680 S24L FRAME UPPER FLANGE DENTED. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101. R & R FRAME AT BS 680 S17-24L IAW DWG 143N1024 AND SRM 51-40-02. CAT "A" MAJOR REPAIR.SDR DALA13033433755Frame · crackedDURING INSPECTION FOUND PASSENGER CABIN LT SIDE STA 480, STR 8L FRAME CRACKED AT PSU RAIL ATTACH POINT. MX STARTED REPAIR IAW ER/A 514904-14AD. ER/A CANCELED DUE TO ELONGATED HOLE. REPAIR ACCOMPLISHED ON WO 27480-2400-0050, CARD 2018946, ER/A 516028-14AD.SDR CALA2013070100471Frame · crackedR-1 DOOR CUTOUT, STA 296 LOWER STUB FRAME CRACKED. TRIMMED OUT DAMAGED SECTION OF FRAME AND INSTALLED REPAIR DOUBLER REF ECRA 5311-01613.SDR AALA20130630002Frame · dentedFRAME DENTED AT FORWARD PIT OF LT SIDE AT BS 540 & STRINGER 25 LT. ACCOMPLISHED REPAIR FOR FRAME IAW REO-G16336 REVISION C & EA B757-53-030495.SDR SWAA2013073018684Frame · crackedSTUB FRAME CRACKED AT BS 616, STRINGER 17R. REPAIRED FRAME IAW SWA EA.SDR FDEA201306291439Frame · crackedFRAME CRACKED AT BS 395, S2 AND 3 RT. REPAIRED IAW EA 757-5312-16-F4237. MAJOR REPAIR.SDR SWAA2013070217828Frame · crackedFRAME CRACKED AT STATION 500D, STRINGER 16L. REPAIRED FRAME IAW SRM.SDR DALA13032880964Frame · crackedDURING SCHEDULED INSPECTION, THE B FRAME AFT OUTER FLANGE WAS FOUND CRACKED UNDER THE RADIUS BLOCK AT BS 1418 AT LONGERON 2R. REPAIRS ACCOMPLISHED IAW ER/A 516423-14.SDR DALA13032773755Frame · damagedDURING INSTALLATION OF STR 8, AT BS 480, LT 4TH FASTENER HOLE UP AND OTBD IS ELONGATED. MX ACCOMPLISHED REPAIR TO FRAME AT STA 480, STR 8L IAW ER/A 516028-14AD.SDR SWAA2013080118736Frame · crackedLT FRAME CRACKED AT BS 188, WL 207.5. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013073018683Frame · crackedRT FS FRAME CRACKED AT BS 188, WL 207.5. REPAIRED FRAME IAW SRM.SDR SWAA2013072418510Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR REXA2013062801308Frame · corrodedFS 693 FWD PRESSURE BULKHEAD BOTTOM MACHINED FRAME HAS CORROSION AROUND TWO SOLID FASTENERS AT BOTTOM CENTERLINE. REPAIRED IAW EO R53438.SDR UIEA2013071700386Frame · crackedWHILE ACCOMPLISHING EO:4453A295, REV 6, FOUND CRACK ON LOWER FRAME WEB BS 320, LBL 28. WEB REPLACED IAW EO:4453A295, PART 2 WHICH IS RELATED TO SB747-53A2784. NOTE: EO COMPLIES WITH AD 2012-22-02.SDR DALA13033740954Frame · crackedBS 1437. STR 1, FRAME CRACKED. REMOVED FASTENERS, STRIPPED DAMAGE AREA, COMPLETED NDT INSPECTION AT AREA IAW NDT SPM 06-10-01. CUT OUT DAMAGE AREA, FABRICATED, AND INSTALLED REPAIR PARTS IAW SRM 53-03 FIG 4.SDR DALA13032870964Frame · crackedDURING SCHEDULED INSPECTION, FRAME BS 1418 WAS FOUND CRACKED AT STRINGER 2R AT THE FWD FACE UPPER RADIUS. REPAIRS ACCOMPLISHED IAW ER/A 516423-14.SDR FDEA201306281412Frame · dentedAFT CARGO, BS 1400 S26L, FRAME UPPER FLANGE DENTED. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07. R & R FRAME IAW SRM 51-40-02 & DWG 146N1011.SDR SWAA2013071918370Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20R-STRINGER 21R. REPAIRED FRAME IAW SRM.SDR FDEA201306271407Frame · chafedMAIN DECK CARGO COMPARTMENT BS 535, LONGERON NR 19L TO NR 21L AT YOKE ATTACHED FITTING EXISTING REPAIR OUTER ANGLE FOUND CHAFED. REMOVED AND REPLACED IAW SRM 53-20-07, FIGURE 202, REPAIR 1, REV. 52. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REV 116.SDR SWAA2013101421170Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2013101421159Frame · crackedFRAME OUT CHORD CRACKED AT BS 727, BELOW STRINGER 18A RT CENTER LINE. REPAIRED CHORD IAW EA.SDR SWAA2013100720804Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727 STRINGER 18A LT CENTER LINE. REPAIRED CHORD IAW EA.SDR SWAA2013100320756Frame · crackedFRAME OUTER CHORD CRACKED AT BS 727 STRINGER 18A LT CENTER LINE. REPAIRED CHORD IAW EA.SDR UALA2013062604433Frame · crackedAFT CARGO BAY LOWER LOBE FRAME WEB CRACKED AT BS 2020 LBL 108. REMOVED DAMAGE, INSTALLED STIFFENER & DOUBLER REF ECRA 5320-02150. MAJOR REPAIR.SDR QXEA2013062601125Frame · corrodedCORROSION AFT SIDE FS 49.5 FLANGE FROM STR 28R TO STR 31R. CORROSION FOUND TO BE LIGHT SURFACE CORROSION, REMOVED BY HAND, REF SRM 51-21-00, NO MATERIAL LOST. APPLIED CPC TO WORKED AREA REF AMM 51-25-01-390-801. RESTORED FINISH ON WORKED AREA REF SRM 51-25-SDR SIMA20130626006Frame · chafedDURING MX INSPECTION, FOUND FRAME 19 CHAFED AT STRINGER 3R. THE ACFT WAS REMOVED FROM SERVICE. PERFORMED REPAIR IAW AEA EO-EM-53MR-2152. THE OPS CHECK WAS GOOD. THE ACFT WAS RETURNED TO SERVICE.SDR DALA13031990964Frame · crackedDURING SCHEDULED TAILCONE FUNCTIONAL CHECK, THE CANTED FRAME AT BS 1510 WAS FOUND TO BE CRACKED AT THE TAILCONE ALIGNMENT PIN BETWEEN THE 9 & 10 OCLOCK POSITION. COMPLETED REPAIR IAW ER/A 516370-14.SDR DALA13031890964Frame · crackedDURING SCHEDULED INSPECTION, THE CANTED FRAME AT BS 1510 WAS FOUND TO BE CRACKED AT THE TAILCONE ALIGNMENT PIN ABOVE THE LOWER RT LATCH. REPAIRED IAW ER/A 516318-14.SDR SWAA2013073018675Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STRINGER 7R. REPAIRED FRAME IAW SWA EA.SDR USAA2013071000011Frame · crackedQ4 CHECK - CRACK ON FRAME AT BS440, S26R. REPLACED FRAME AT BS440, S26R IAW SRM 51-40-02 & BOEING DWG 65-20722.SDR FDEA201306251414Frame · dentedAFT CARGO, BS 1520 S-26L, FRAME UPPER ANGLE DENTED. NO DENTS ALLOWED IAW SRM 53-00-07. REMOVED FRAME IAW SRM 51-40-02. FABRICATED NEW FRAME AND INSTALLED IAW SRM 51-40-02 AND DWG 146N1017. REPAIR IS CLASSIFIED AS A CATEGORY "A" MAJOR.SDR DALA1316190683Frame · dentedA DENT LOCATED ON THE INNER FREE FLANGE FRAME, BS 1300 JUST ABOVE STRINGER 24 RT REF AD 2006-11-11 AND SRM 53-00-07, FIGURE 101 AND 201. WAS NOT IDENTIFIED DURING INTIAL INSPECTION, ACCOMPLISHED PERMANENT REPAIR ON AFT CARGO FRAME, BS 1300, ABOVE S24R IAW ERASDR C77A20130627021Frame · gougedA SMALL STRAIGHT LINE DRILL MARK FOUND ON THE REAR PRESSURE BULKHEAD RING, ON THE RT SIDE BETWEEN STGR 12R AND 13R. BLENDED OUT DRILL MARK IAW SRM PART II 51-10-03 ON WO 725877-303 IAW COMPASS, EO E17X-53AD-001.1, REV IR.SDR C77A20130627020Frame · gougedMECHANICAL DAMAGED FOUND ON THE REAR PRESSURE BULKHEAD RING, LT SIDE BETWEEN STRINGERS 12 AND 13 LEFT. BLENDED OUT DAMAGE IAW SRM 51-10-03 PART II.SDR DALA13031690964Frame · crackedDURING SCHEDULED INSPECTION, FRAME 1510 WAS FOUND TO BE CRACKED AT THE TAIL CONE ALIGNMENT PIN, FIRST PIN ABOVE LWR LT LATCH ASSY. REPAIRS COMPLETED IAW ER/A 497316-14MA.SDR CALA2013062500448Frame · corrodedLOWER FUSELAGE PANEL SUPPORT STRUCTURE BS 727, RBL-22 HAS AN ENLONGATED HOLE. R & R FRAME AT LOWER FUSELAGE AT BS 727 FROM LBL-6 TO RBL-45 REF SRM 51-40-02.SDR SWIA201334449Frame · damagedUPPER FRAME AT FS 193 IS DAMAGED IN SEVERAL AREAS. SERVICE REPLACED UPPER FRAME AT FS 193.SDR SWAA2013072218448Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STRINGER 27L-STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013072218447Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STRINGER 27R-STRINGER 27L. REPAIRED FRAME IAW SRM.SDR USAA2013071100005Frame · crackedQ4 CHECK - CRACKS IN FUSELAGE FRAME AT BS380, S20L. REPAIRED FUSELAGE FRAME AT BS380, S20L IAW EA 104847.SDR CALA2013062600456Frame · crackedFRAME CRACKED BS 400 BETWEEN S8-9L. REPAIRED FRAME IAW EA 5310-04716 REV E, OP1.SDR UALA2013062404376Frame · corrodedFRAME BS 1701 CORRODED BETWEEN S9-10R. REMOVED DAMAGED SECTION OF FRAME. FABRICATED AND INSTALLED REPAIR ANGLE.
Back to JASC 5311