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 SWAA2023122827262Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 727H+19.75 LBL 20 WL 156. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] C/W INSPECTION OF C.A. STEP 1 (AMT MICHAEL PETERSON) OF THE REPLACED TRANSDR SWAA2023122827263Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 727H+20 LBL 21 WL 156. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] C/W INSPECTION OF C.A. STEP 1 (AMT MICHAEL PETERSON) OF THE REPLACED TRANSITSDR SWAA2023122827243Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 727H+20 LBL 20 WL 156. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] C/W INSPECTION OF C.A. STEP 1 (AMT MICHAEL PETERSON) OF THE REPLACED TRANSITSDR SWAA2023122827259Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 727H+9 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827260Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 727H+13 LBL 21 WL 156. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED REF (TTG8Q00Q22QW).;[02] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[03] C/W ISDR SWAA2023122827261Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 727H+16.25 LBL 20 WL 156. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] C/W INSPECTION OF C.A. STEP 1 (AMT MICHAEL PETERSON) OF THE REPLACED TRANSDR SWAA2023122827209Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE 727D+1 LBL 20 WL 156. MRKD<[01] OKAY TO INSTALL NEW TRANSITION ANGLE PER SRM 51-40-02;[02] OK TO INSTALL NEW TRANSITION ANGLE L/H STA.727-849;[03] INSTALLED NEW TRANSITION ANGLE L/H STA. 727-849 IAW SRM SDR SWAA2023122827231Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727G+2 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827224Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT RIVET HEAD STA 727G RBL 21 WL 156. MRKD<[01] REMOVED CORROSION FROM AFT CARGO R/H TRANSITION ANGLE ATTACH FASTENER HOLE AT STA 727G RBL 21. ORIGINAL THICKNESS IS 0.040?. MAX MATERIAL REMOVED 0.006?. MAX ALLOWED 0SDR SWAA2023122827225Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727G+6 RBL 21 WL 156. MRKD<[01] REMOVED CORROSION ON AFT CARGO R/H TRANSITION ANGLE AT N/P HOLE AT STA 727G +6? RBL 21. ORIGINAL THICKNESS IS 0.040?. MAX MATERIAL REMOVED 0.007. MAX ALLOWED 0.004. FOSDR SWAA2023122827226Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727G+9 RBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQSDR SWAA2023122827227Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727G+13 RBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQSDR SWAA2023122827221Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+6 RBL 21 WL 156. MRKD<[01] REMOVED CORROSION FROM AFT CARGO R/H TRANSITION ANGLE AT N/P HOLE STA 727F +6 RBL 21. ORIGINAL THICKNESS IS 0.040?. MAX MATERIAL REMOVED 0.005?; MAX ALLOWED 0.004?. FOSDR SWAA2023122827222Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+16 RBL 21 WL 156. MRKD<[01] REMOVED CORROSION FROM AFT CARGO R/H TRANSITION ANGLE AT N/P HOLE STATION 727F +16? RBL 21. ORIGINAL THICKNESS IS 0.040?. MAX MATERIAL REMOVED 0.006?. MAX ALLOWED IS SDR SWAA2023122827223Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+20 RBL 21 WL 156. MRKD<[01] REMOVED CORROSION FROM AFT CARGO R/H TRANSITION ANGLE AT N/P HOLE STA 727F +20? RBL 21. ORIGINAL THICKNESS IS 0.040?. MAX MATERIAL REMOVED 0.007?. MAX ALLOWED 0.004?.SDR SWAA2023122827239Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+20 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827218Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+9 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827219Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+13 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827220Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+19.5 LBL 20 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827238Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+6 LBL 20 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827216Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+2 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827217Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727F+6 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827213Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727E+13 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827214Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727E+16 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827215Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727E+20 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827210Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727D+6 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827211Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727D+7.5 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827212Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE STA 727E+9 LBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22QW.SDR SWAA2023122827207Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE 727B+12 RBL 20 WL 156. MRKD<[01] PART REPLACED OUT TO LIMITS PLEASE SEE TTG8Q00Q22PQ FOR CORRECTIVE ACTION;[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827208Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE 727B+15.5 RBL 20 WL 156. MRKD<[01] PART REPLACED OUT TO LIMITS PLEASE SEE TTG8Q00Q22PQ FOR CORRECTIVE ACTION;[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827315Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 785.5 LBL 21 WL 157. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827253Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 749 RBL 20 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQSDR SWAA2023122827254Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 749.5 RBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQSDR SWAA2023122827316Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 752.25 RBL 20 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.SDR SWAA2023122827256Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 755.5 RBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQSDR SWAA2023122827255Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 753.5 RBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQ.;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q22PQSDR SWAA2023122827654Angle · corrodedFORWARD CARGO RIGHT TRANSITION ANGLE HAS CORROSION AT BS 500F TO 500G.<[01] BLENDED AREAS; REMOVED .010' MATERIAL; FOUND TO BE OUT OF LIMITS PER SRM 53-00-53-2R-5.;[02] DAMAGE REMOVED FROM STA. 500D+10 TO 500F+10 . REPAIR TO BE ACCOMPLISHED ON NR# TTG8Q00Q4FZSSDR SWAA2023122827649Support · corrodedAFT LAV MOUNT SUPPORT STRUCTURE CORRODED @ RBL50 BS949<[01] MEASURED DAMAGE AND FOUND TO BE OUT OF LIMITS PER SRM 53-70-51-1A-1.;[02] DRILLED UP REPLACEMENT INTERCOSTAL PER SRM 51-40-05. COUNTERSUNK APPLICABLE HOLES PER SRM 51-40-08.;[03] R/R INTERCOSTAL IAW SSDR SWAA2023122827662Floorbeam · corrodedFLOOR BEAM BS947 CORRODED UNDER AND AROUND LAV MOUNT RBL50.5<[01] REMOVED CORROSION ON TOP OF UPPER CHORD OF FLOOR BEAM STA 947.5 RBL 50.5 (REMOVED 0.039? OF .180? MATERIAL) FOUND TO BE OUT OF LIMITS PER SRM 53-70-51-1A-1.;[02] INSPECTION C/W REMOVED CORROSIONSDR SWAA2023122827642Panel · crackedPANEL 343FB HAS CRACKING AT FASTENER HOLE(MARKED)<[01] REMOVED DAMAGE FROM FASTENER HOLE ON PANEL 343FB IAW SRM 51-70-05-2R-9;[02] VERIFIED DAMAGE REMOVED FROM FASTENER HOLE ON PANEL 343FB IAW SRM 51-70-05-2R-9.;[03] REPAIRED DAMAGED FASTENER HOLE ON PANEL 343SDR SWAA2023122827341Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 882.5 RBL 20 WL 164. MRKD<[01] REMOVED SURFACE CORROSION AT AFT CARGO R/H TRANSITION ANGLE AT N/P HOLE AT STA 882.5 RBL 20 WL 164.;[02] REMOVED SURFACE CORROSION AT AFT CARGO R/H TRANSITION ANGLE SDR SWAA2023122827337Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 801.5 LBL 21 WL 159. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827336Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 797.5 LBL 21 WL 159. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827335Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 793.5 LBL 21 WL 159. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827334Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 792.5 LBL 20 WL 159. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827333Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 789.5 LBL 21 WL 159. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827257Angle · corrodedAFT CARGO L/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 789 LBL 20 WL 159. MRKD<[01] THIS TRANSITION ANGLE IS REMOVED AND REPLACED PER SRM 51-40-02 REF (TTG8Q00Q22QW);[02] INSPECTED AS REQUIRED. CORRECTIVE ACTION #1SDR SWAA2023122827332Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 786.75 RBL 21 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q24G9;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q24G9.SDR SWAA2023122827331Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 786 RBL 20 WL 156. MRKD<[01] REMOVED R/H TRANSITION ANGLE IAW SRM 51-40-02 <BR>LOCATED AND DRILLED NEW R/H TRANSITION ANGLE IAW SRM 51-40-10;[02] INSTALLED NUTPLATES PER SRM 51-40-02;[03] REMOVED SDR SWAA2023122827330Angle · corrodedAFT CARGO R/H TRANSITION ANGLE HAS CORROSION AT N/P HOLE AT STA 783 RBL 20 WL 156. MRKD<[01] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q24G9;[02] REPAIR ACCOMPLISHED ON CARD TTG8Q00Q24G9.
Back to Boeing 737-8H4