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 AWXA200700429Frame · crackedMCN - AFT CARGO COMPARTMENT DOOR SURROUND FORWARD FRAME CRACKED, BS 794, S25R. REPAIRED AFT CARGO COMPARTMENT DOOR SURROUND FORWARD FRAME CRACKED, BS 794, S25R IAW AWA ER 03-5362-07091-SS1.SDR AWM070223021AFrame · chafedLT FUSELAGE FRAME DAMAGED BY CHAFING. REPAIRED IAW ENGINEERING REPORT 6593-1, REV IR DATED 5 MAR 07..SDR AWM070223021BFrame · chafedLT FUSELAGE FRAME DAMAGED BY CHAFING. REPAIRED IAW ENGINEERING REPORT 6593-1, REV IR DATED 5 MAR 07..SDR AWM070223021CFrame · chafedRT FUSELAGE FRAME DAMAGED BY CHAFING. REPAIRED IAW ENGINEERING REPORT 6593-1, REV IR (MAR 5, 2007)..SDR AWXA200700346Frame · crackedMCN - FOUND FRAME UPPER INNER FLANGE STRAP CRACKED, BS 492, S22R. REPLACED FRAME UPPER INNER FLANGE STRAP, BS 492, S22R IAW B737-300 SRM 51-40-02 AND 51-40-05.SDR SWAA071248Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071249Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071242Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071247Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071246Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071245Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071244Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071243Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071253Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA071206Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER SWA EA.SDR CALA0700117Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN FORWARD BAGGAGE BIN FORWARD FRAME AT LOWER STOP PAD FITTING AT STA 400. THE FRAME WAS REPLACED IAW SRM 51-40-02 AND BOEING DRAWING 65C33514.SDR UIEA200700117Frame · crackedCRACK FOUND IN THE FRAME WEB AT STATION 360 STR 14ER CUTOUT. THE CRACK IN THE FRAME WEB WERE INSPECTED AND A .063" DOUBLER WAS INSTALLED AS PER BOEING MESSAGE 1-28580146-3/5 AND 8100-9.SDR UIEA200700112Frame · crackedFOUND BS 840 FRAME TO TENSION TIE CONNECTION FOUND 1 HOLE CRACKED. REPAIR ACCOMPLISHED PER BOEING DRAWING ON MESSAGE 1-283852403-4.SDR SWAA071197Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071175Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9R. REPAIRED FRAME PER SWA EA.SDR CALA0700114Frame · crackedLEFT MAIN FRAME CRACKED AT STA 639. REPAIRED IAW ECRA 5311-01299.SDR SWAA071172Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 17L. REPAIRED FRAME PER SWA EA.SDR ABXA070111Frame · corrodedCRACK WITH EXFOLIATION ABOVE RADIUS ON FORWARD SIDE OF FRAME AT STA 718, APPEARED TO BE IN THE WEB AREA. REPLACED FRAME ON EA 53400323-001-2.SDR ABXA070079Frame · corrodedFORWARD LOWER CARGO FRAME CORRODED AT FS 465 BETWEEN LONGERON 28 LEFT AND LONGERON 28 RIGHT. REMOVED CORROSION AND REPLACED SECTION OF FRAME IAW DC9 SRM 53-03.SDR DHL2007751511Frame · damagedFOUND INTERIOR E/E COMPARTMENT, BS 318, RBL 18-24, WL 160, LEVELING COMPOUND BLOWN UP AT FASTENERS BY FRAME WALKWAY BEAM INTERSECTION. REMOVED LEVELING COMPOUND FOR CORROSION EVAL IAW B727 SRM 51-10-6. CORROSION FOUND OUT OF LIMITS AT FRAME SHEAR TIE IAW B72SDR 07FDEA00615Frame · unknownCAC CIRCUMFERENTIAL FRAME AT STA 1099 BETWEEN STRINGER NR 39 LT TO 45 RT EXISTING FRAME REPAIRS AND REPAIRS CHANNEL IN DIF LOCATIONS. REMOVED OLD REPAIR CHANNEL SPLICE AT L NR 52, CUT CAP FRAME AT L NR 41 R. REMOVED SECTION FRAME BTWN L NR 47 L TO 46 R. RSDR UPS07449467Frame · crackedINSPECTION TYPE:C M/D BS 820 STR 11-12R FRAME FOUND CRACK. CRACK LENGTH .875 - 1 INCH. M/D BS 820 STR 11-12R FRAME REPAIRED AS PER RS R53-12-35770. CONTINUE INSPECTION IS REQUIRED AS PER RS R53-12-35770 AND UPS EO B747-5310-26322.SDR NWAA070816305Frame · crackedDURING "M" CHECK, FOUND CRACK IN LT FRAME WEB AT BS 1265 STRINGER 26L. REPAIRED PER EA 63-208883 SECTION I. REPETITIVE INSPECTIONS PER SECTION II TO BE ACCOMPLISHED EVERY 2000 CYCLES. SECTION III WILL BE BASED ON SECTION II FINDINGS.SDR NWAA070806305Frame · crackedDURING "M" CHECK, FOUND CRACK ON THE BS 1256 FRAME WEB AT STRINGER 26R. INTERIM REPAIR WAS ACCOMPLISHED PER SECTION I OF EA 63-208895. REPETITIVE INSPECTIONS PER SECTION II TO BE ACCOMPLISHED EVERY 2000 CYCLES. SECTION III WILL BE BASED ON SECTION II FINDINGSDR CALA0700100Frame · crackedAFT CARGO COMPARTMENT CRACKED ON FWD BULKHEAD FRAME. INSTALLED STIFFENER IAW SRM 51-10-02, 51-30-01, AND 51-40-02.SDR USAA070143Frame · crackedBS 440 S-24R WL 160 HAS CRACK. REMOVED DAMAGE & INSTALLED FAB'D REPAIR PARTS PER EA 98455, DEFECT SIZE: .250 INCH.SDR DHL2007781016Intercostal · crackedAFT CARGO COMPT AT BS 925, INTERCOSTAL WEB ATTACH TO STR 20L IS CRACKED. STOP DRILLED CRACK PER B727 SRM 51-10-1. CRACK CONTAINMENT VERIFIED BY HFEC METHOD. FABRICATED REPAIR ANGLE FROM 7075-T6, .080" BY 9" BY 2.25", PO NR 9003958, PER B727 SRM 53-10-2 FIG SDR 07FDEA00588Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1721 BETWEEN LONGERONS 11 AND 12 LT. REMOVED RIVETS AND INSTALLED HI LOCKS IAW SRM 53-30-00 FIG 5 VOL 1, USED OVERSIZE FASTENERS AS REQUIRED IAW SRM 51-33-00 VOL 2.SDR 07FDEA00587Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1741 BETWEEN LONGERONS 11 AND 12 LT. REMOVED RIVETS AND INSTALLED HI LOCKS IAW SRM 53-30-00 FIG 5 SHT 2 VOL 1, USED OVERSIZE FASTENERS AS REQUIRED IAW SRM 51-33-01 VOL 2.SDR 07FDEA00586Frame · misrepairedFOUND EXISTING FRAME REPAIR AFT CARGO COMPARTMENT AT STA 1856 BETWEEN LONGERONS 52 AND 51 RT. PERFORMED INSPECTION OF REPAIR AND NOT FOUND INCOMPLIANCE WITH CRITERIA REQUEST BY EO NR 8-5100-7-5001-P2 BECAUSE FOUND 20 RIVETS INSTEAD OF HI LOCKS IAW SRM 53-30-0SDR 07FDEA00585Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1741 BETWEEN LONGERONS 11 AND 12 RT. REMOVED RIVETS AND INSTALLED HI LOCKS IAW SRM 53-30-00 FIG 5 SHT 2 VOL 1, USED OVERSIZE FASTENERS AS REQUIRED IAW SRM 51-33-01 VOL 2.SDR 07FDEA00584Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1721 BETWEEN LONGERONS 11 AND 12 RT. REMOVED RIVETS AND INSTALLED HI LOCKS IAW SRM 53-30-00 FIG 5 SHT 2 VOL 1, USED OVERSIZE FASTENERS AS REQUIRED IAW SRM 51-33-01 VOL 2.SDR 07FDEA00583Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1701 BETWEEN LONGERONS 11 AND 12 RT. REMOVED RIVETS AND INSTALLED HI LOCKS IAW SRM 53-30-00 FIG 5 SHT 2 VOL 1, USED FIRST OVERSIZE FASTENERS AS REQUIRED IAW SRM 51-33-01 VOL 2.SDR 07FDEA00582Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1781 BETWEEN LONGERONS 11 AND 12 RT. REMOVED RIVETS AND INSTALLED HI LOCKS FIRST OVERSIZE IAW SRM 53-30-00 FIG 5 SHT 2 VOL 1 AND SRM 51-33-01 PAR 6-10 VOL 2.SDR 07FDEA00581Frame · damagedFOUND EXISTING FRAME REPAIR AT STA 1761 BETWEEN LONGERONS 11 AND 12 RT. REMOVED RIVETS AND INSTALLED HI LOCKS FIRST OVERSIZE IAW SRM 53-30-00 FIG 5 SHT 2 VOL 1 AND SRM 51-33-01 PAR 6-10 VOL 2.SDR SIMA200707105Frame · corrodedFOUND WEB AT STATION 280 RIGHT SIDE CORRODED AT FLOORBEAM MATING AREA. SPLICED IN NEW WEB AT STATION 280 IAE AMERICAN EAGLE ENGINEERING ORDER CR-53MR-109. RETURNED AIRCRAFT TO SERVICE.SDR DHL2007751513Frame · corrodedA/C IN "C" CHECK, AFT CARGO COMPT FRAME AT STA 950C IS CORRODED AT BOTTOM BETWEEN STR 29L-28L. REPLACED DAMAGED SHEAR TIE AT BS 950C BETWEEN STR 29L-28L. FABRICATED NEW PART 7075-0 .080 PO NR 9002619 IAW B727 SRM 53-10-4 FIG 15 AND 53-10-2 FIG 5. HEAT TREATSDR DHL2007751512Frame · puncturedIN "C" CHECK, AFT CARGO COMPT FRAME AT STA 1090 IS PUNCTURED IN UPPER FLANGE RADIUS ABOVE STR 27L. REMOVAL TRANSITION PANEL FOR ACCESS IAW B727 SRM 51-30-2, FAB FRAME REPAIR FROM 7075-0 .063 PO NR 9004384 DIM 8" BY 3 1/2"BY 1" BY 1" IAW B727 SRM 53-10-2 FIG 1SDR DHL2007751508Frame · dentedIN "C", FWD CARGO COMPT FRAME STA 660 HAS DEEP DENT AT UPPER FLANGE BETWEEN STR.23R-24R. CUT OUT DAMAGED AREA APPROX DIM 1 1/4" IAW B727 SRM 51-40-3. FAB DOUBLER REPAIR FROM 7075-0 .063 PO NR 9004384 APPROX DIM 13" IAW B727 SRM 51-40-3 PAGE 1 AND 3 AND SRM 5SDR DHL2007751507Frame · dentedIN "C" CHECK, FWD CARGO COMPT FRAME STA 700 HAS 3 DENTS AT UPPER FLANGE BETWEEN STR 24L-25L. CUT OUT DAMAGED AREA APPROX 1" BY 3/4" IAW B727 SRM 51-40-3 FIG 1. FAB REPAIR ANGLE FROM 7075-0 .063 PO NR 9004384 APPROX DIM 11.7" BY 4" IAW B727 SRM 51-40-3 FIG 1 SDR DHL2007751506Frame · dentedIN "C" CHECK, FWD CARGO COMPT FRAME STA 520 IS DENTED AT UPPER FLANGE ABOVE STR 24R. CUT OUT DAMAGED AREA APPROX DIM 1" BY 3/4" IAW B727 SRM 51-40-3 FIG 1. FAB REPAIR ANGLE FROM 7075-0 .050 PO NR 9004219 APPROX DIM 10 1/4" BY 3 1/4" IAW B727 SRM 51-40-3 FIG SDR DHL2007751502Frame · dentedWHILE IN "C" CHECK, FWD CARGO COMPT FRAME STA 500 IS DENTED IN TWO PLACES AT UPPER FLANGE BETWEEN STR 23R-24R. CUTOUT DAMAGED AREA AT FWD CARGO COMPT BS 500 BETWEEN STR 23R AND 24R APPROX DIM 1 1/2" BY 1" IAW B727 SRM 51-40-3 FIG 1. FAB REPAIR ANGLE FROM 707SDR DHL2007751501Frame · dentedWHILE IN "C" CHECK, AFT CARGO COMPT FRAME AT STA1050 IS DENTED BETWEEN STR 26L AND 27L IN THE UPPER FLANGE. CUTOUT DENTED AREA (DIM 7" BY 2 1/2" BY 1 1/2") IAW B727 SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR ANGLE FROM 7075-0 0.063 (D.7"X 2 1/2") PO NR 9004SDR 2007UALA00591Frame · gougedFUSELAGE FRAME HAS DEEP GOUGES STA 1720 BETWEEN STR 29L TO JUST O/B OF STR 29R.SDR SWAA071125Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311