Boeing 737-8H4
Service difficulty reports · 24,314
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7378H4' 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 aircraft_model_key = '7378H4' 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 SWAA2023042730736Slide · out of adjustL1 SLIDE DETACHED FROM DOOR<[01] REINSTALLED L1 DOOR ESCAPE SLIDE PER AMM 25-66-01 AND MT 725-61-06. A/C OK FOR SERVICE.SDR SWAA2023042730734Slide · out of adjustRT FWD SERVICE DOOR SLIDE PARTIALLY OUT OF SLIDE CONTAINER<[01] COMPLIED W/ MT 725-61-06SDR SWAA2023052430176Angle · crackedAFT CARGO COMPARTMENT WASTE TANK BULKHEAD SUPPORT ANGLE CRACKED AT STA 867; LBL11.<[01] REMOVED DISCREPANT SUPPORT ANGLE IAW SRM 51-40-02;[02] DRILLED UP NEW SUPPORT ANGLE PER SRM 51-40-05 AND INSTALLED NEW SUPPORT ANGLE (149A8109U114) AT STA 867 LBL11 PER SRMSDR SWAA2023052430168Strap · corrodedAFT CARGO COMPARTMENT FLOOR STRAP AT RBL 20 FROM STA 787-794 HAS CORROSION ON THE LOWER SURFACE.<[01] REMOVED AND REPLACED AFT CARGO COMPARTMENT FLOOR STRAP AT RBL 20 FROM STA 787-794 PER SRM 51-40-02;[02] INSPECTION C/W.SDR SWAA2023052430166Angle · corrodedAFT CARGO STA 727D + 4' LH TRANS ANGLE HAS LIGHT CORROSION<[01] REMOVED SURFACE CORROSION ON L/H TRANSITION ANGLE AT STA. 727D +4' PER SRM 51-10+02. REMOVED .007? OF MATERIAL. MATERIAL REMAINING THICKNESS IS .033' AND FOUND TO BE OUT OF LIMITS PER SRM 53-00-53SDR SWAA2023052430171Angle · corrodedAFT CARGO STA 727F THRU STA 727G LH TRANS ANGLE HAS CORROSION<[01] REMOVED SURFACE CORROSION ON L/H TRANSITION ANGLE AT STA. 727F TO 727G PER SRM 51-10+02. REMOVED .005? OF MATERIAL. MATERIAL REMAINING THICKNESS IS .035' AND FOUND TO BE OUT OF LIMITS PER SRM 5SDR SWAA2023052430172Angle · corrodedAFT CARGO STA 727G THRU STA 727H RH TRANS ANGLE HAS CORROSION<[01] REMOVED SURFACE CORROSION ON TRANSITION ANGLE. MATERIAL REMAINING THICKNESS IS .035 AND FOUND TO BE OUT OF LIMITE PER SRM 53-00-53-1A2.;[02] VERIFIED DAMAGE REMOVAL IS OUT OF LIMITS.;[03] CUT ASDR SWAA2023052430184Angle · corrodedAFT CARGO STA 727H THRU STA 727I RH TRANS ANGLE HAS CORROSION<[01] REMOVED SURFACE CORROSION ON TRANSITION ANGLE. MATERIAL REMAINING THICKNESS IS .035 AND FOUND TO BE OUT OF LIMITE PER SRM 53-00-53-1A2.;[02] VERIFIED DAMAGE REMOVAL IS OUT OF LIMITS.;[03] REMOVSDR SWAA2023052430185Angle · corrodedAFT CARGO STA 727H THRU STA 727I LH TRANS ANGLE HAS CORROSION<[01] REMOVED SURFACE CORROSION ON L/H TRANSITION ANGLE AT STA. 727H- 727I PER SRM 51-10-02. REMOVED .007? OF MATERIAL. MATERIAL REMAINING THICKNESS IS .033' AND FOUND TO BE OUT OF LIMITS PER SRM 53-SDR SWAA2023052430175Splice · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE; CARGO FLOOR SPLICE CORRODED AT STA 887.<[01] BLENDED CORROSION ON AFT CARGO FLOOR SPLICE AT STA. 887 PER SRM 51-10-02. REMOVED .023 OF MATERIAL. REMAINING THICKNESS IS .047?. DAMAGE REMOVAL IS OUT OF LIMITS PER SRM 53-00-SDR SWAA2023052430187Angle · corrodedAFT CARGO COMPARTMENT AFT BULKHEAD SUPPORT ANGLE STA 947 HAS SURFACE CORROSION AT RBL20.<[01] REMOVED AFT CARGO AFT BULKHEAD SUPPORT ANGLE AT STA 947 PER SRM 51-40-02;[02] LOCATED AND DRILLED NEW AFT CARGO AFT BULKHEAD SUPPORT ANGLE AT STA 947 PER SRM 51-40-05SDR SWAA2023052430177Shield · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION WEB CORRODED AT STA 847-867 RBL 20<[01] BLENDED 2 LIGHT SPOTS OF SURFACE CORROSION ON R/H TRANSITION ANGLE AT STA. 847+4? AND STA. 847+9? PER SRM 51-10-02. REMOVED .003? OF MATERIAL. REMAINING THICKNESS IS .037?DAMAGE REMSDR SWAA2023052430189Angle · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 727I-727J.<[01] REMOVED SURFACE CORROSION ON TRANSITION ANGLE. MATERIAL REMAINING THICKNESS IS .035 AND FOUND TO BE OUT OF LIMITE PER SRM 53-00-53-1A2.;[02] VERIFIED DAMAGE REMOVAL SDR SWAA2023052430190Angle · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 727J - 747.<[01] REMOVED SURFACE CORROSION ON TRANSITION ANGLE. MATERIAL REMAINING THICKNESS IS .035 AND FOUND TO BE OUT OF LIMITE PER SRM 53-00-53-1A2.;[02] VERIFIED DAMAGE REMOVALSDR SWAA2023052430191Angle · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 747-767.<[01] REMOVED SURFACE CORROSION ON TRANSITION ANGLE. MATERIAL REMAINING THICKNESS IS .035 AND FOUND TO BE OUT OF LIMITE PER SRM 53-00-53-1A2.;[02] VERIFIED DAMAGE REMOVAL ISSDR SWAA2023052430178Shield · corrodedAFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE HAS SURFACE CORROSION ON THE TOP AND BOTTOM BETWEEN STA767-794.<[01] BLENDED MULTIPLE CORROSION SPOTS ON R/H TRANSITION SHIELD FROM STA. 767 TO STA. 794; RBL 20? PER SRM 51-01-02. DEEPEST AMOUNT OF MATERIAL REMOVED SDR SWAA2023052430179Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA727I - 727J.<[01] REMOVED SURFACE CORROSION ON L/H TRANSITION ANGLE AT STA. 727I-727J PER SRM 51-10-02. REMOVED .005? OF MATERIAL. MATERIAL REMAINING THICKNESS IS .035' AND FOUND TO BSDR SWAA2023052430192Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 727J-747.<[01] EDITED THE FAULT FROM AFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 727J-747. [TTG8Q00KLY4M] TO AFT CARGO COMPARTMENT LEFT TRANSITION SDR SWAA2023052430180Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 747-767.<[01] REMOVED CORROSION PER SRM 53-00-53-1A-2 DAMAGE IS OUT OF LIMITS. REMOVED 0.007 REMAINING THICKNESS IS 0.033.;[02] C/W INSPECTION;[03] FAULT RESOLVED ON TTG8Q00KRJY6;[04SDR SWAA2023052430181Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 767-787<[01] REMOVED CORROSION PER SRM 53-00-53-1A-2 DAMAGE IS OUT OF LIMITS. REMOVED 0.005 REMAINING THICKNESS IS 0.035.;[02] C/W INSPECTION;[03] FAULT RESOLVED ON TTG8Q00KRJY6;[04]SDR SWAA2023052430193Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 787-807.<[01] REMOVED CORROSION PER SRM 53-00-53-1A-2 DAMAGE IS OUT OF LIMITS. REMOVED 0.007 REMAINING THICKNESS IS 0.033.;[02] C/W INSPECTION;[03] FAULT RESOLVED ON TTG8Q00KRJY6;[04SDR SWAA2023052430182Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 807-827.<[01] REMOVED CORROSION PER SRM 53-00-53-1A-2 DAMAGE IS OUT OF LIMITS. REMOVED 0.006 REMAINING THICKNESS IS 0.034.;[02] C/W INSPECTION;[03] FAULT RESOLVED ON TTG8Q00KRJY6;[04SDR SWAA2023052430194Angle · corrodedAFT CARGO COMPARTMENT LEFT TRANSITION ANGLE HAS SURFACE CORROSION BETWEEN STA 827-847.<[01] REMOVED CORROSION PER SRM 53-00-53-1A-2 DAMAGE IS OUT OF LIMITS. REMOVED 0.007 REMAINING THICKNESS IS 0.033.;[02] C/W INSPECTION;[03] LOCATED AND DRILLED FASTENER HOLESSDR SWAA2023052430186Floor Panel · corrodedAFT CARGO STA 767 + 4' FLOOR PANEL SPICE STRIP HAS CORROSION<[01] BLENDED CORROSION ON AFT CARGO FLOOR PANEL SPLICE AT STA. 767+4? PER SRM 51-10-02. REMOVED .040? OF MATERIAL. REMAINING THICKNESS IS .030?. DAMAGE REMOVAL IS OUT OF LIMITS PER SRM 53-00-53-1A-2.SDR SWAA2023052430342Angle · corrodedFWD CARGO AFT BULKHEAD FLOOR SUPPORT ANGLE CORRODED BETWEEN STR 26L AND 26R FWD CARGO AFT BULKHEAD FLOOR SUPPORT ANGLE AT STA 500I CORRODED BETWEEN STR 26L AND 26R<[01] DUPLICATE N/R SEE N/R TTG8Q00KM6QV FOR CORRECTIVE ACTION.;[02] VERIFIED: DUPLICATE N/R SEE SDR SWAA2023050930635Seal · crackedRIGHT HORIZONTAL STAB ACCESS PANEL 343AT HAS BLADE SEAL CRACKED<[01] REMOVED AND REPLACED BLADE SEAL ON RIGHT HORIZONTAL STAB ACCESS PANEL 343AT AS PER SRM 51-40-02-0G-0. WORK WAS ACCOMPLISHED BY NOE M. ORTEGA.;[02] VERIFIED STEP 1SDR SWAA2023050930633Seal · crackedLEFT HORIZONTAL STAB ACCESS PANEL 333AB HAS BLADE SEAL CRACKED<[01] REMOVED AND REPLACED BLADE SEAL AT LEFT HORIZONTAL STAB ACCESS PANEL 333AB IRW SRM 51-40-02;[02] VERIFIED STEP 1.SDR SWAA2023050130204Bracket · crackedPANEL 551EB: FWD INBOARD ATTACH WAFFLE BRACKET IS CRACKED AND FASTENER IS LOOSE.<[01] REMOVED AND REPLACED WAFFLE BRACKET PER SRM 51-40-02.;[02] COMPLETESDR SWAA2023050130203Battery Pack · inoperativeEMERGENCY EXIT SIGN LIGHTS INOP AT RH BS614 AND LH BS614<[01] R&R BATTERY BACK FOR POWER SUPPLY M1695 IAW AMM 33-51-06.;[02] INSPECTED THE WORK PERFORMED ON C/A #1; NO DEFECT NOTED. PARTS INFORMATION WAS VERIFIED.SDR SWAA2023042730560Slide · out of adjustFWD ENTRY DOOR; FLOOR-MOUNTED ESCAPE SLIDE FORWARD BRACKET STUCK.<[01] REMOVED FOD FROM FWD ENTRY DOOR; FLOOR-MOUNTED ESCAPE SLIDE FWD BRACKET PER SIP & OPS CHECKED GOOD PER AMM 25-66-00.SDR SWAA2023042730719Flashlight · out of positionFA FLASHLIGHT AFT LEFT UNDER JUMPSEAT NOT WORKING<[01] RESEATED AND SEALED AFT L/H FA FLASHLIGHT OPS CHECK GOOD AMM 25-64-00SDR SWAA2023042729975Battery · icedAFT FA EMERGENCY FLASHLIGHT BATTERY DEAD<[01] OKAY TO CONTINUE PER MEL 25-12-01. SP1B APPLIED AUTH# 131224;[02] REPLACED BATTERY PER AMM 25-64-00SDR SWAA2023042629980Battery Pack · inoperativeFWD RIGHT SECTION OF EMERGENCY EXIT LIGHTS ARE INOP.<[01] REPLACED M2816 AND M1676 EMERGENCY LIGHT BATTERIES AND CHARGERS PER AMM 33-51-06-960-806 AND AMM 33-51-06-960-805. MOST LIGHTS IN AREA NOW OPERATE CORRECTLY; THE RIGHT OVERWING EMERGENCY HATCH FLOOR PROSDR SWAA2023052530331Plate · corrodedAFT CARGO SIDEPLATE FWD OF DOOR CUTOUT HAS CORROSION AT FASTENER HOLES RBL 21; STA. 767-787<[01] REMOVED AND REPLACED R/H SIDE PLATE FROM STA 767-787 RBL 21 PER SRM 51-40-02.;[02] INSPECTED WORK PERFORMED.SDR SWAA2023052530329Plate · corrodedAFT CARGO R/H SIDEPLATE HAS CORROSION AT FASTENER HOLES RBL 21; STA. 727J-747<[01] REMOVED CORROSION FOUND TO BE OUT OF LIMIT ;CUT OUT SECTION OF R/H SIDEPLATE AT BS 272F+10-767 PER SRM 53-00-53-2R;[02] C/W INSPECTION.;[03] FABBED ; LOCATED ; DRILLED ; TREATEDSDR SWAA2023052530337Plate · corrodedAFT CARGO L/H SIDEPLATE HAS CORROSION AT FASTENER HOLES LBL 21; STA. 727I-727J<[01] REMOVED CORROSION AFT CARGO L/H SIDEPLATE AT FASTENER HOLES LBL 21; STA. 727I-727J FOUND OUT OF LIMIT CUT OUT SECTION OF L/H TRANSITION ANGLE BS 727G +10 -747 +12 PER SRM 53-00SDR SWAA2023052530330Plate · corrodedAFT CARGO R/H SIDEPLATE HAS CORROSION AT FASTENER HOLES RBL 21; STA. 747-767<[01] REMOVED CORROSION FOUND OUT OF LIMT ;ACCOMPLISHED REPAIR ON TTG8QOOLPHD LINE # 2133;[02] C/W INSPECTION.SDR SWAA2023052530317Plate · corrodedAFT CARGO R/H SIDEPLATE HAS CORROSION AT FASTENER HOLES RBL 21; STA. 727I-727J<[01] REMOVED CORROSION FOUND OUT OF LIMIT ;ACCOMPLISHED REPAIR ON TTG8QOOKLPHD LINE #2133;[02] C/W INSPECTION.SDR SWAA2023052530338Plate · corrodedAFT CARGO L/H SIDEPLATE HAS CORROSION AT FASTENER HOLES LBL 21; STA. 727J-747<[01] REMOVED CORROSION FOUND TO BE OUT OF LIMIT ;ACCOMPLISHED REPAIR ON TTG8QOOKLPHZ LINE #2143;[02] C/W INSPECTION.SDR SWAA2023052530328Plate · corrodedAFT CARGO R/H SIDEPLATE HAS CORROSION AT FASTENER HOLES RBL 21; STA. 727G-727H<[01] REMOVED CORROSION FOUND OUT OF LIMIT ;ACCOMPLISHED REPAIR ON TTG8QOOKLPHD LINE #2133;[02] C/W INSPECTION.SDR SWAA2023052530335Plate · corrodedAFT CARGO L/H SIDEPLATE HAS CORROSION AT FASTENER HOLES LBL 21; STA. 727G-727H<[01] REMOVED CORROSION FOUND OUT OF LIMIT ; ACCOMPLISHED REPAIR ON TTG8QOOKLPHZ LINE #2143;[02] C/W INSPECTION.SDR SWAA2023052530316Plate · corrodedAFT CARGO R/H SIDEPLATE HAS CORROSION AT FASTENER HOLES RBL 21; STA. 727H-727I<[01] REMOVED CORROSION FOUND TO BE OUT OF LIMIT ;ACCOMPLISHED REPAIR ON TTG8QOOKLPHD LINE # 2133;[02] C/W INSPECTION.SDR SWAA2023052530336Plate · corrodedAFT CARGO L/H SIDEPLATE HAS CORROSION AT FASTENER HOLES LBL 21; STA. 727H-727I<[01] REMOVED CORROSION FOUND OUT OF LIMIT ; ACCOMPLISHED REPAIR ON TTG8QOOKLPHZ LINE # 2143;[02] C/W INSPECTION.SDR SWAA2023052430147Seal · crackedLEFT HORIZONTAL STABILIZER UPPER FWD SLIDER SEAL IS CRACKED.<[01] REMOVED AND INSTALLED NEW LH UPPER FWD STAB SLIDER SEAL PER AMM 53-31-31;[02] INSPECTED CA #1;[03] REMOVED AND INSTALLED NEW LH UPPER FWD STAB SLIDER SEAL PER AMM 53-31-31;[04] INSPECTION C/W.SDR SWAA2023052430156Seal · crackedRIGHT HORIZONTAL STABILIZER UPPER FWD SLIDER SEAL IS CRACKED.<[01] MATCHED DRILLED AND RIVETED ATTACH BRACKETS ON NEW SERVICABLE SLIDER PER SRM 51-40-02.;[02] C/W INSPECTION REF. CORRECTIVE ACTION #1;[03] MATCHED DRILLED AND RIVETED ATTACH BRACKETS ON NEW SERVSDR SWAA2023042630388Fairing · crackedCRACK; #1 ENGINE PYLON AFT STRUT SUPPORT FAIRING ASSY<[01] R&R #1 ENGINE PYLON AFT STRUT SUPPORT FAIRING TIP ASSY PER SRM 51-10-02 AND SRM 51-40-02. EDGE SEALED NEW PART PER AMM 51-31-00SDR SWAA2023042530528Girt Bar · looseDOOR MOUNTED GIRT BAR HOLDING HOOK IS LOOSE<[01] REINSTALL FASTENER ON GIRT BAR HOOK PER SRM 51-40-02SDR SWAA2023042530478Lens · missingOVERHEAD EXIT SIGN COME OUT OF HOLDER<[01] REINSTALLED BOTH LENSES PER AMM 33-51-01.SDR SWAA2023052530269Panel · crackedAFT CARGO PANEL 142KW CRACKED.<[01] PANEL 142KW WILL BE REPLACED ON TTG8Q00KJL1N;[02] VERIFIED RICHARD PARRY (TECHNICIAN); 19-MAY-2023 08:51 UTC<BR>PANEL 142KW WILL BE REPLACED ON TTG8Q00KJL1NSDR SWAA2023052430258Scuff Plate · crackedFWD CARGO AFT CORNER THRESHOLD PLATE 143A8331-4 IS CRACKED AT FWD EDGE.<[01] REMOVED AND REPLACED FWD CARGO AFT CORNER SCUFF PLATE PER AMM 53-11-02.;[02] C/W INSPECTION.
Back to Boeing 737-8H4