Boeing 737-823
Service difficulty reports · 31,890
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 = '737823' 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 = '737823' 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 AALA202301301627Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301306167Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301305393Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301304767Oven · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED BURNING SMELL COMING FROM NUMBER 1 OVEN IN G1 GALLEY. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202301301740Retainer · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR R1 DOOR LOOSE. REMOVED AND REPLACED R1 DOOR GIRT CLIPS.SDR AALA202301307718Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPERATE. LUBRICATED DOOR TRACK. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301309474Connector · unsecureAIRCRAFT WAS GROUNDED: INTERIOR EMERGENCY LIGHT ON G1 GALLEY INOPERATIVE. RESECURED CONNECTION AT G1 EMERGENCY LIGHT ASSEMBLY.SDR AALA202301308481Light · inoperativeAIRCRAFT WAS GROUNDED: EXTERIOR EMERGENCY LIGHT INOPERATIVE AT LEFT FORWARD OVER-WING EXIT DOOR. REPLACED LEFT OVER-WING EMERGENCY LIGHT IAW AMM 33-51-04.SDR AALA202301274484Striker · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR HARD TO CLOSE. ADJUSTED STRIKER PLATE PER AMM 52-51-03. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301275279Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR GRIT BAR CLIP IS LOOSE. ADJUSTED L1 DOOR GIRT BAR RETAINER CLIP PER AMM 25-66-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301278449Circuit Breaker · shearedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTING CIRCUIT BREAKER 9A ON PANEL P6-11 IS SHEARED OFF. REPLACED CIRCUIT BREAKER PER SWPM 20-30-00 AND WDM 33-51-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTS PER AMM 33-51-00.SDR AALA202304059774Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE TRANSITION PANEL SECTION BETWEEN BODY STATION 500G+10 AND BODY STATION 500I. REMOVED AND REPLACED FORWARD CARGO RIGHT TRANSITION PANEL.SDR AALA202302165838Oven · smokeAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY RIGHT OVEN SMOKING. **SUPPLEMENTAL REPORT FOR AALA202301305838: MAINTENANCE REPLACED OVEN PER AMM 25-32-03 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202301308244Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301306002Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301306040Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: 1.5 IN CRACK ON CENTER WING BOX UPPER FORWARD SHEAR FITTING AT STA 540 AND RIGHT BUTT LINE 6.14. REMOVED CRACKED SHEAR FITTING AND INSTALLED NEW SHEAR FITTING.SDR AALA202301305838Oven · smokeAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY RIGHT OVEN SMOKING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202301277788Window · delaminatedAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICER`S R3 WINDOW SCRATCHED & DELAMINATED. REPLACED WINDOW PER AMM 56-11-21.SDR AALA202301267205Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: 1L DOOR GIRT BAR DIFFICULT TO ARM AND DISARM. LUBRICATED GIRT BAR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 25-66-00.SDR AALA202301268348Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR LOCKED AND UNABLE TO OPEN FROM THE OUTSIDE. LUBRICATED DOOR LATCHING MECHANISM. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301267157Warning Flag · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR RED WARNING FLAG LOOSE. ADJUSTED RED FLAG.SDR AALA202305125353Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK AFT PRESSURE BULKHEAD RIGHT LOWER END RIGHT BUTT LINE 30 CORRODED. CORROSION LOCATED AT STA 1016 AND RIGHT BUTT LINE 30. REMOVED AND REPLACED INTERCOSTAL.SDR AALA202304058837Doubler · damagedAIRCRAFT IN BASE MAINTENANCE: EXTERNAL POWER DOOR CUTOUT LOWER AREA PORTION OF DOOR LANDING SKIN TORN/MISSING. LOCATED AT STA 277 AND STR 18R. REMOVED DAMAGE AND INSTALLED DOUBLER AND FILLER AT DOOR CUTOUT.SDR AALA202302078086Web · wornAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN AFT PASSENGER CABIN FLOOR WEB LOCATED FROM BS 1016 TO BS 1030 AND FROM RBL 0 TO RBL 36. REPLACED WEB PER DWG 14A5700.SDR AALA202301274834Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT ABOVE R1 DOOR IS PARTIALLY ILLUMINATED. REMOVED AND REPLACED LAMPS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01-960-801.SDR AALA202301278421Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT ABOVE L 1 DOOR IS PARTIALLY ILLUMINATED. REMOVED AND REPLACED LAMPS. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01-960-801.SDR AALA202301267047Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER SUPPORT ANGLE LOCATED AT BS 663 AND RBL 9. REPAIRED ANGLE PER SRM 51-40-02 AND SRM 57-10-10-2R-5.SDR AALA202303288913Unknown · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) SLIDE GIRT BAR CLIPS ADJUSTED IAW AMM 25-66-01. **SUPPLEMENTAL REPORT FOR AALA202301258913: REPLACED GIRT BAR RETAINER CLIPS PER JOB CARD 2520J031-001.** (CLOSED)SDR AALA202302247937Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN DECK AFT WET AREA BETWEEN STA 947 TO 986.5 RIGHT CREASE BEAM CORRODED AT RIGHT BUTT LINE 54. REMOVED FABRICATED AND INSTALLED CREASE BEAM PER SRM.SDR AALA202301250504Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPERATE. REMOVED AND REINSTALLED AND LUBRICATED AFT LEFT LAVATORY DOOR IAW AMM 52-00-00.SDR AALA202301258913Adjuster · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) SLIDE GIRT BAR CLIPS ADJUSTED IAW AMM 25-66-01. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202301254650Control System · faultedAIRCRAFT WAS GROUNDED: SPEED TRIM FAIL LIGHT ANNUNCIATED IN CLIMBOUT. EMERGENCY DECLARED; FLIGHT RETURNED TO CLT LANDING SAFELY. MAINTENANCE FOUND DIGITAL FLIGHT CONTROL SYSTEM (DFCS) FAULT CODES FOR AUTO STAB TRIM CUTOUT, TRIM COMMAND RESPONSE FAIL, AND TRIM SDR AALA202301245671Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD SERVICE DOOR SLIDE IS HARD TO ARM DUE TO SLIDE NOT FULLY PACKED INTO SLIDE BUSTLE. ACCOMPLISHED DOOR ESCAPE SLIDE PACK CHECK FORWARD ENTRY DOOR (1L). ADJUSTED RETAINER CLIPS.SDR AALA202301244919Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR LOOSE. ADJUSTED R1 DOOR GIRT BAR PER AMM 25-66-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301241588Retainer · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR CLIPS ARE TOO TIGHT. ADJUSTED R1 DOOR GIRT BAR CLIPS.SDR AALA202302242887Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: FINDING UPON THE REMOVAL OF AFT PRESSURE BULKHEAD LOWER SKIRT SEAL FOUND CORROSION AT INTERCOSTAL APPROXIMATELY AT STA 1030 AND LEFT BUTT LINE 30 TO LEFT BUTT LINE 41. REMOVED AND FABRICATED AND INSTALLED INTERCOSTAL PER SRM.SDR AALA202302225602Skin · crackedAIRCRAFT IN BASE MAINTENANCE: SEVERAL AREAS OF CORROSION IN AFT CARGO COMPARTMENT INTERNAL FUSELAGE SKIN BETWEEN STA 727I AND STA 787 STR 27L-27R. PERFORMED DOUBLER REPAIR PER SRM.SDR AALA202301267481Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER SUPPORT ANGLE LOCATED AT BS 663 AND LBL 9. REPAIRED ANGLE PER SRM 51-40-02 AND SRM 57-10-10-2R-5.SDR AALA202301257768Windshield · scratchedAIRCRAFT WAS GROUNDED: APPROXIMATE 5 INCH SCRATCH ON INNER PANE L1 WINDSHIELD. REMOVED AND REPLACED NUMBER 1 WINDSHIELD.SDR AALA202301249478Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: UPON ARRIVAL INTO MIA WE NOTED THE EMERGENCY EXIT PANEL OF COCKPIT DOOR HAS ONE LATCH ON RIGHT SIDE THAT WILL NOT ENGAGE. READJUSTED COCKPIT DOOR EMERGENCY EXIT PANEL LATCH.SDR AALA202301231422Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN. ADJUSTED DOOR LATCH. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301234466Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR STUCK IN RETAINING CLIP. ADJUST GIRT BAR PER AMM 25-61-00.SDR AALA202302063058Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR RIGHT HAND SHEAR WEB LOCATED AT BS 988, S18R, AND RBL 32. REPAIRED SHEAR WEB PER EA 341977.SDR AALA202301233125Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT AFT OF L1 DOOR INOPERATIVE. REPLACED LAMP PER AMM 33-51-04. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202301266273Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD LOCATED FROM BS 767 TO BS 793 AND FROM RBL 17 TO RBL 21. INSTALLED NEW SHIELD PER AARD 51-00-05-1 AND DWG 146A0081.SDR AALA202301252612Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WHEEL WHEEL FORWARD BULKHEAD 1ST BAY OUTBOARD OF KEEL BEAM CRACKED LOCATED AT STA 663.75 AND RIGHT BUTT LINE 32.53. PERFORMED BONDED REPAIR PER AARD.SDR AALA202301256275Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 92.70, AT SECOND STIFFENER. REPAIRED RIB PER SRM 55-10-09-2R-5.SDR AALA202301255723Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 92.70, AT THIRD STIFFENER FROM FRONT SPAR. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202301231567Relay · faultyAIRCRAFT WAS GROUNDED: MAIN ELECTRIC TRIM FAILED AT 5000 FEET. EMERGENCY DECLARED; FLIGHT RETURNED TO MIA LANDING SAFELY. REMOVED AND REPLACED MAIN TRIM ARM RELAY R1193 (AALA202301232322) AND STAB TRIM CONTROL RELAY R64 (AALA202301231567) PER WDM 27-41-12. REPSDR AALA202301232322Relay · faultedAIRCRAFT WAS GROUNDED: MAIN ELECTRIC TRIM FAILED AT 5000 FEET. EMERGENCY DECLARED; FLIGHT RETURNED TO MIA LANDING SAFELY. REMOVED AND REPLACED MAIN TRIM ARM RELAY R1193 (AALA202301232322) AND STAB TRIM CONTROL RELAY R64 (AALA202301231567) PER WDM 27-41-12. REP
Back to Boeing 737-823