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 AALA202501063468Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING ACCOMPLISHMENT OF W/C 08T20033001 FOUND RIGHT OVERWING ESCAPE GROUND ILLUMINATION LIGHT (L548) INOPERATIVE. (OPEN).SDR AALA202501063146Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFTER LAVATORY DOOR HARD TO MOVE. ADJUSTED DOOR HINGE. PER CMM 25-40-58. OPERTIONAL GOOD.SDR AALA202501064667Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH-LOCK INOPERATIVE. REMOVED AND REPLACED AFTER LEFT LAVATORY SWITCH LATCH. PER CMM 25-40-58.SDR AALA202501062150Megaphone · no testAIRCRAFT WAS NOT GROUNDED: FOUND FORWARD MEGAPHONE INOPERATIVE. REMOVE AND REPLACED FORWARD MEGAPHONE. PER AMM 25-64-00. OPERTIONAL CHECK GOOD.SDR AALA202501240906Fitting · gougedAIRCRAFT WAS IN BASE MAINTENANCE: FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT AFT FRAME-MOUNTED LATCHTRACK FITTING HAS A GOUGE, LOWER SIDE. DOT 129-005. REMOVED AND INSTALLED NEW LOWER LATCH TRACK FITTING ON FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT AFT FRAMSDR AALA202501138403Door Frame · deterioratedAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR FUSELAGE CUTOUT SKIN AFT FRAME LOWER END LEVELING COMPOUND IS DETERIORATED. INSTALLED NEW LEVELING COMPOUND. PER B737NG AMM 51-31-00.SDR AALA202501096616Light · brokenAIRCRAFT WAS NOT GROUNDED: SEATS 22ABC AND SEATS 25ABC EMERGENCY AISLE LIGHT HOUSING NEEDS TO BE REPLACED AT THE BOTTOM OF ARMREST. REMOVED AND REPLACED ROW 22ABC AND 25ABC EMERGENCY LIGHT HOUSINGS. PER CMM 25-23-67.SDR AALA202501088905Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED FROM STA 500B TO STA 500C AT LBL 26. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202501066616Housing · not reportedAIRCRAFT WAS NOT GROUNDED: SEATS 22ABC AND SEATS 25ABC EMERGENCY AISLE LIGHT HOUSING NEEDS TO BE REPLACED AT THE BOTTOM OF ARMREST. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202501065390Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. LUBED DOOR TRACK, OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202501066056Coffeemaker · burnedAIRCRAFT WAS NOT GROUNDED: AT CRUISE, FLIGHT ATTADNENT REPORTED BURNING SMELL AFTER GALLEY. CAPTAIN VERIFIED VERY STRONG ELECTRICAL BURNING SMELL PRESENT STARTING AT ROW 30. REMOVED AND REPLACED BOTH COFFEE MAKERS (AALA202501066056), (AALA202501065717) IN AFT SDR AALA202501065717Coffeemaker · burnedAIRCRAFT WAS NOT GROUNDED: AT CRUISE, FLIGHT ATTADNENT REPORTED BURNING SMELL AFTER GALLEY. CAPTAIN VERIFIED VERY STRONG ELECTRICAL BURNING SMELL PRESENT STARTING AT ROW 30. REMOVED AND REPLACED BOTH COFFEE MAKERS (AALA202501066056), (AALA202501065717) IN AFT SDR AALA202501242871Gate · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY SERVICE DOOR LOWER GATE HAS AREAS OF CORROSION. REMOVED AND REPLACED AFT GALLEY SERVICE DOOR LOWER GATE. PER B737NG AMM 52-10--02. PERFORMED SATISFACTORY ADJUSTMENT CHECK AND OPERTIONAL CHECK AT R-2 END GATE ASSEMBLY LOSDR AALA202501242318Beam · wornAIRCRAFT IN BASE MAINTENANCE: 192CR DOOR BEAM LANDING HAS A WORN SPOT. ACCOMPLISHED PERMANENT REPAIR AT 192CR BEAM LANDING. PER B737NG SRM 57-10-13-2R PROCEDURE 3.SDR AALA202501065454Control Lever · faultedAIRCRAFT WAS GROUNDED: ON DEPARTURE, PUT GEAR IN UP POSITION. GEAR RETRACTED NORMAL AFTER FLAP RETRACTION AND CLEAN, PERFORMED AFTER TAKEOFF CHECKLIST. PUT GEAR HANDLE IN OFF POSITION, AROUND TWO MINUTES LATER AROUND 6000 FEET, LANDING GEAR DROPPED ON ITS ON. SDR AALA202501061997Lock · jammedAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK IS JAMMING AND PREVENTING PASSENGER EXIT. OPENS FROM CABIN BUT NOT FROM INSIDE. LUBRICATED AFT LEFT LAVATORY DOOR LOCK ASSEMBLY, OPERTIONAL CHECK GOOD.SDR AALA202501069299Oven · inoperativeAIRCRAFT WAS NOT GROUNDED: A SMELL COMING FROM FORWARD GALLEY OVEN NUMBER 2, SOF IS CONFIRMED AND IS ALSO INOPERATIVE.REMOVE AND REPLACED FORWARD GALLEY OVEN NUMBER 2. OPERATIONAL CHECK GOOD. PER AMM 25-32-03.SDR AALA202501033236Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AROUND LAVATORY EXHAUST PORT LOCATED AT STA 917, FROM S21L TO S22L. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-70-01-2R-3 AND EA 359973.SDR AALA202501030841Sign · missingAIRCRAFT WAS GROUNDED: ILLUMINATED EXIT SIGN ABOVE FORWARD CATERING DOOR IS MISSING AND WIRES APPEARS CUT. REMOVED AND REPLACED LIGHT ASSEMBLY. PER AMM 33-51-01-960-802.SDR AALA202501076204Light · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CEILING HORSESHOE PANEL EMERGENCY LIGHT CRACKED. REMOVED AND REPLACED FORWARD CEILING HORSESHOE PANEL EMERGENCY LIGHT AND PERFORMED SATISFACTORY OPERTIONAL CHECK GOOD. PER B737NG AMM 33-51-03-960-805.SDR AALA202501074549Pump · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: DURING CRUISE BOTH OF NUMBER 2 ENGINE AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AND STAYED ON; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. **SUPPLEMENTAL REPORT FOR (AALA20250103454SDR AALA202501030802Megaphone · missingAIRCRAFT WAS NOT GROUNDED: FORWARD CLOSET MEGAPHONE ROBBED. REPLACED FORWEARD CLOSET MEGAPHONE. PER 25-64-00.SDR AALA202501031169Escape Rope · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 17 FED EMERGENCY EXIT ROPE COVER INOPERATIVE. SECURED ROW 17FED EMERGENCY EXIT ROPE COVER. PER AMM 25-61-10.SDR AALA202501034549Pump · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: DURING CRUISE BOTH OF NUMBER 2 ENGINE AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AND STAYED ON; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(SDR AALA202501035620Sign · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN MISSING ABOVE 14A. **SUPPLEMENTAL REPORT FOR (AALA202501025620): REMOVED AND REPLACED EMERGENCY AISLE LIGHT ASSEMBLY AT ROW 14ABC. PER AMM 33-51-03.SDR AALA202501021168Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFTER LAVATORY DOOR DIFFICULT TO OPEN IN FLIGHT. LUBED DOOR LATCH ASSEMBLY ON AFT LEFT LAVATOPRY AND OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202501025584Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR JAMS AGAINST FLOOR DURING FLIGHT. ADJUSTED AFT LEFT LAVATORY DOOR. OPERTIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202501025620Sign · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN MISSING ABOVE 14A. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202501221955Beam · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WING LOWER TRAILING EDGE PANEL JUST INBOARD OF PYLON HAS WORN LOWER INBOARD SUPPORT. DAMAGE BEAM AND REPLACED WITH NEW BEAM PER SRM 51-40-02.SDR AALA202501107343Beam · gougedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING BEAM ASSEMBLY FOUND TO BE GOUGED DURING THE INTIAL REPAIR OF THE FLAP DETECTION FITTING. CUTOUT DAMAGE LOCATED AND DRILLED REPAIR DOUBLER AND SERRATED PLATE INSTALLED REPAIR AT RIGHT HAND WING BEAM ASSEMBLY OF THE SDR AALA202501020076Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE STRINGER CLIP LOCATED AT STA 500I AND S26R. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA202501023913Stop · missingAIRCRAFT WAS NOT GROUNDED: AFT ENTRY GERT BAR STOPPER MISSING. REPLACED GIRT BAR STOP RELEASE. PER AMM 25-66-01.SDR AALA202501021754Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS AND DIFFICULT TO OPERATE. ADJUSTED LAVATORY-D DOOR AND LUBED UPPER TRACK. PER AMM 25-40-14.SDR AALA202501175872Strut · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT ENGINE STRUT BOOT AT 12 0'CLOCK HAS POSSIBLE CRACKS. REMOVE AND REPLACE LEFT ENGINE STRUT BOOT AT 12 0'CLOCK. PER B737-NG AMM 72-23-02.SDR AALA202501039035Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY E, AIRCRAFT AFT RIGHT LAVATORY DOOR IS STUCK IN THE CLOSED POSITION AND THE HANDLE WILL NOT OPEN THE DOOR. MAINTENANCE REPLACED THE DOOR LATCH AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER CMM 25-40-65.SDR AALA202501035825Oven · odorAIRCRAFT WAS NOT GROUNDED: OVEN NUMBER 1 IS A BIT SMOKEY WHEN USED. MAINTENANCE VERIFIED OVEN HAD A BURNT PLASTIC SMELL AND REPLACED IT PER AMM 25-32-03.SDR AALA202501024671Girt Bar · defectiveAIRCRAFT WAS NOT GROUNDED: LEFT AFT ENTRY DOOR GIRT BAR IS MISSING RED HEAT SHRINK TUBING / INDICATOR TAB. MAINTENANCE REPAIRED GIRT BAR INDICATOR PER AARD 25-66-00-4SDR AALA202501024023Pressure Switch · faultedAIRCRAFT WAS GROUNDED: THE # 2 ENGINE FUEL FILTER BYPASS LIGHT ILLUMINATED FOR TWO MINUTES AFTER TAKEOFF AND REPEATEDLY THROUGHOUT THE FLIGHT. MAINTENANCE REPLACED THE #2 ENGINE FULE FILTER PER AMM 73-11-02 (AALA202501026652) AND THE FUEL FILTER DIFFERENTIAL PSDR AALA202501026652Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: THE # 2 ENGINE FUEL FILTER BYPASS LIGHT ILLUMINATED FOR TWO MINUTES AFTER TAKEOFF AND REPEATEDLY THROUGHOUT THE FLIGHT. MAINTENANCE REPLACED THE #2 ENGINE FULE FILTER PER AMM 73-11-02 (AALA202501026652) AND THE FUEL FILTER DIFFERENTIAL PSDR AALA202412317244Screw · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT ON DOOR L1, THE ATTACHMENT SCREW ON THE LEFT SIDE OF THE SLIDE IS MISSING. MAINTENANCE INSTALLED LEFT HAND L1 DOOR SLIDE MOUNTING FASTENER PER AMM 25-66-01-400.SDR AALA202412318188Faucet · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO ORD DUE TO THE FLIGHT CREW REPORTING THAT THE FIRST-CLASS LAVATORY SINK STARTED LEAKING 1 1/2 HOURS INTO FLIGHT. THE FLIGHT ATTENDANTS WERE UNABLE TO CONTROL LEAK WITH THE SHUT OFF VSDR AALA202412313972Selector Valve · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO ORD DUE TO THE FLIGHT CREW REPORTING THAT THE FIRST-CLASS LAVATORY SINK STARTED LEAKING 1 1/2 HOURS INTO FLIGHT. THE FLIGHT ATTENDANTS WERE UNABLE TO CONTROL LEAK WITH THE SHUT OFF VSDR AALA202412312098Hose · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO ORD DUE TO THE FLIGHT CREW REPORTING THAT THE FIRST-CLASS LAVATORY SINK STARTED LEAKING 1 1/2 HOURS INTO FLIGHT. THE FLIGHT ATTENDANTS WERE UNABLE TO CONTROL LEAK WITH THE SHUT OFF VSDR AALA202412308459Sliding Window · crackedAIRCRAFT WAS GROUNDED: DURING TAXI OUT L2 WINDOW PAIN STARTED TO CRACK IN MULTIPLE PLACES AND THE AIRCRAFT RETURNED TO THE GATE. MAINTENANCE REPLACED THE L2 SLIDING WINDOW AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 56-11-31.SDR AALA202412309455Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT THE FLIGHT DECK ACCESS LOCK INTERMITTENTLY DOES NOT UNLOCK WHEN FLIGHT DECK ACCESS SYSTEM SWITCH IS TURNED OFF. FLIGHT CREW REPORTED THAT THE LOCK FAIL LIGHT DOES NOT ILLUMINATE AND THERE IS NO AUDIBLE SOLENSDR AALA202412309507Brake Sys · contaminatedAIRCRAFT IN BASE MAINTENANCE: DURING POST CHECK TEST FLIGHT THE FLIGHT CREW REPORTED THAT THE AIRCRAFT PULLS HARD LEFT DURING HARD MANUAL BRAKING DURING LANDING ROLLOUT AND TAXI WITH MANUAL OR ANTI SKID OPERATION. MAINTENANCE BLED THE BRAKES PER AMM 32-41-00 ASDR AALA202412303347Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT AT AFT RIGHT DOOR INOPERATIVE. MAINTENANCE RELAMPED EXTERIOR EMERGENCY LIGHT AT AFT RIGHT DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04.SDR AALA202412308188Sink · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO ORD DUE TO THE FLIGHT CREW REPORTING THAT THE FIRST CLASS LAVATORY SINK STARTED LEAKING 1 1/2 HOURS INTO FLIGHT. THE FLIGHT ATTENDANTS WERE UNABLE TO CONTROL LEAK WITH THE SHUT OFF VSDR AALA202412307954Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S25L AT STA 837. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-03-2R-1.SDR AALA202412303262Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM STA 847 TO STA 867 AT S25L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.
Back to Boeing 737-823