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 AALA202509205552Door Seal · fodAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF LOUD SQUEAL COMING FROM THE DOOR POSSIBILITY OF A LEAK AT THJE FORWARD RIGHT SERVICE DOOR. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. INSPECTED R1 DOOR AND FOUND DEBRIS LODSDR AALA202510146970Panel · splitAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZE, FORWARD SPAR UPPER SLIDER PANEL IN FUSELAGE IS SPLIT ALONG THE EDGE. INSTALLED RIGHT HAND UPPER SLIDER. PER AMM 53-31-31.SDR AALA202509268801Stop Fitting · wornAIRCRAFT IN BASE MAINTENANCE: L2 DOOR AFT DOOR FRAME STOP PADS WORN. REMOVED AND REPLACED WORN AFT DOOR FRAME STOP PADS. PER AMM 52-13-01.SDR AALA202509215572Stop Pad · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR, 4 STOP PADS ON AFT DOOR FRAME HAVE EXCESSIVE WEAR. REPLACED THE 4 MIDDLE STOP PADS PER AMM 52-41-01.SDR AALA202509209419Pump · faultedAIRCRAFT WAS NOT GROUNDED: DURING TAKEOFF THE NUMBER 2 AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED. MAIN TANKS WERE FULL AS WE HAD FUEL IN THE CENTER TANK. T/S PERFORMED PER FIM 28-22-00-810-805. CONFIRMED TANK 2 AFT BOOST PUMP GFI RELAY RESET BUTTON NOT OUTSDR AALA202509204956Slide · dislodgedAIRCRAFT WAS GROUNDED: AFTER PARKING, WHILE THEY WERE OPENING THE FORWARD ENTRY DOOR, THE CASING FOR THE EMERGENCY EXIT SLIDE CRACKED OPEN AND WEDGED THE SLIDE AND THE GIRT BAR ON THE GALLEY FLOOR, CAUSING THE DOOR TO BE STUCK ABOUT A QUARTER OPEN. REMOVED ANDSDR AALA202509204392Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS LAVATORY-D DOOR IS STICKING, BINDING AND DIFFICULT TO LOCK AND UNLOCK. LUBRICATED UPPER ROLLER TRACK AND DOOR LOCK MECHINISM, OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202509207834Striker · lockedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR AUTO UNLOCK SYSTEM NOT WORKING. REMOVED AND REPLACED COCKPIT DOOR ELECTRIC STRIKER. PER AMM 52-51-03. OPERATIONAL CHECK GOOD.SDR AALA202509206151Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ROW 19ABC LOOSE AND DETACHED. REATTACHED AND SECURED EMERGENCY LIGHT AT ROW 19ABC. PER AMM 33-51-00, EMERGENCY LIGHTS CHECKED NORMAL.SDR AALA202509208103Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: THE L2 DOOR AFT ESCAPE SLIDE LIGHT (L732) INOPERATIVE. RELAMPED L2 DOOR ESCAPE SLIDE LIGHT NO HELP. REPLACED EMERGENCY LIGHTING BATTERY PACK (M1673), PER AMM 33-51-06. EMERGENCY LIGHT SOPS CHECK NORMAL.SDR AALA202509205005Light · dislodgedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS THAT SEAT 31C EXIT LIGHT IS HANGING ON FLOOR. REPOSITIONED AND SECURED 31C EMERGENCY LIGHT. PER AMM 33-51-11.SDR AALA202509206484Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY DOOR. PER 52-50-00.SDR AALA202509172676Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY FLASHLIGHTS UNDER FORWARD FLIGHT ATTENDANT SEATS DO NOT TEST. REMOVED UNSERVICEABLE EMERGENCY FLASHLIGHTS AND INSTALLED 2 SERVICEABLE EMERGENCY FLASHLIGHTS (AALA202509176588) (AALA202509172676) UNDER FORWARD FLIGHT SDR AALA202509176588Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY FLASHLIGHTS UNDER FORWARD FLIGHT ATTENDANT SEATS DO NOT TEST. REMOVED UNSERVICEABLE EMERGENCY FLASHLIGHTS AND INSTALLED 2 SERVICEABLE EMERGENCY FLASHLIGHTS (AALA202509176588) (AALA202509172676) UNDER FORWARD FLIGHT SDR AALA202510202607Fairing · corrodedAIRCRAFT IN BASE MAINTENANCE: #2 ENGINE AFT STRUT FAIRING TRAILING EDGE ASSEMBLY HAS CORROSION ON INBOARD SIDE. REPLACED TRAILING TRAILING EDGE ASSEMBLY REPLACED PER AARD 51-00-05-1.SDR AALA202509173252Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR WILL NOT SEAT PROPERLY IN THE BRACKETS. ADJUSTED AFT GIRT BAR FITTING. PER AMM 25-66-02. OPERATIONAL CHECK GOOD.SDR AALA202509179801Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR. PER CMM 25-40-58. OPERATIONAL CHECK GOOD.SDR AALA202509173276Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: LEFT FUEL FILTER BYPASS LIGHT ILLUMINATED FOR APPROX 4 MINUTES. REMOVED AND REPLACED FUEL FILTER (AALA202509173276) AND FUEL PRESSURE SWITCH (AALA202509173475). PER AMM 73-11-02 AND AMM 73-34-01. LEAK AND OPERATIONAL CHECKS GOOD.SDR AALA202509173475Pressure Switch · cloggedAIRCRAFT WAS GROUNDED: LEFT FUEL FILTER BYPASS LIGHT ILLUMINATED FOR APPROX 4 MINUTES. REMOVED AND REPLACED FUEL FILTER (AALA202509173276) AND FUEL PRESSURE SWITCH (AALA202509173475). PER AMM 73-11-02 AND AMM 73-34-01. LEAK AND OPERATIONAL CHECKS GOOD.SDR AALA202509175897Light · disconnectedAIRCRAFT WAS NOT GROUNDED: 32C FLOOR EMERGENCY EXIT PATH LIGHTING HAS COME LOOSE AND IS DISCONNECTED. RESECURED 32C EMERGENCY LIGHT.SDR AALA202509170801Door · out of adjustAIRCRAFT WAS GROUNDED: LAVATORY-D DOOR VERY DIFFICULT TO OPEN. REPEAT DISCREPANCY. ADJUSTED BI-FOLD DOOR. PER CMM 25-40-64. DOOR OPERATIONAL CHECK GOOD.SDR AALA202509171470Skirt · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT THE BOARDING DOOR SLIDE SKIRT MUST BE FOLDED UNDER FOR GIRT BAR TO FIT PROPERLY IN BRACKETS. NON-STANDARD OPERATION. ADJUSTED SKIRT ON BOARDING DOOR AS REQUIRED.SDR AALA202509172714Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR ON AFT LEFT SIDE. THE LOCKING MECHANISM IS DIFFICULT TO OPERATE AND IS LOCKING PEOPLE IN THE LAVATORY. CLEANED AND LUBED LATCH AT LAVATORY-D DOOR. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202510015874Lens · crackedAIRCRAFT IN BASE MAINTENANCE: G7 EMERGENCY PROXIMITY LIGHTS LENS ARE CRACKED. REMOVED AND REPLACED G7 EMERGENCY PROXIMITY LIGHTS AND PERFORMED SATISFACTORY OPERATIONAL CHECK GOOD. PER B737NG AMM 33-51-14.SDR AALA202509175711Trim Motor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: STAB OUT OF TRIM LIGHT ILLUMINATION DURING CRUISE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. REMOVED AND REPLACED STABILIZER TRIM MOTOR FOLLOWING FIM 22-11-00 AND AMM 27-41-71. OPERATIONAL CHECK GOOSDR AALA202509167478Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT OUTER RIGHT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT DOES NOT TEST. ADJUSTED FLASHLIGHT AND RESEALED.SDR AALA202509165493Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANTS JUMPSEAT FLASHLIGHT DOES NOT WORK. REPLACED INBD FLASHLIGHT BATTERY IN FORWARD FLIGHT ATTENDANT JUMPSEAT. OPS CHECKED GOOD. PER AMM 25-64-00.SDR AALA202509160542Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBE LAVATORY-D DOOR. PER AMM 25-40-14.SDR AALA202509164399Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS OFF TRACK. PASSENGER WAS STUCK IN THE LAVATORY AND THE FLIGHT ATTENDANTS HAD TO USE A LOT OF FORCE TO OPEN THE DOOR. ADJUSTED DOOR BACK ON TRACKS AS REQUIRED. DOOR OPERATIONAL CHECK GOOD.SDR AALA202509169304Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT FRAME OVER ROW 12DEF IS LOOSEN. SECURED EMERGENCY LIGHT FRAME. PER AMM 33-51-00.SDR AALA202509162507Flashlight · no testAIRCRAFT WAS NOT GROUNDED: BOTH EMERGENCY FLASHLIGHTS UNDER AFT LEFT FLIGHT ATTENDANT SEATS DID NOT TEST. REPLACED BOTH EMERGENCY FLASHLIGHTS (AALA202509162507) (AALA202509165391) UNDER AFT LEFT FLIGHT ATTENDANT SEATS, OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202509165391Flashlight · no testAIRCRAFT WAS NOT GROUNDED: BOTH EMERGENCY FLASHLIGHTS UNDER AFT LEFT FLIGHT ATTENDANT SEATS DID NOT TEST. REPLACED BOTH EMERGENCY FLASHLIGHTS (AALA202509162507) (AALA202509165391) UNDER AFT LEFT FLIGHT ATTENDANT SEATS, OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202509160888Light · unsecureAIRCRAFT WAS NOT GROUNDED: A LIGHT IN MIDDLE OF PASSENGER AISLE BEHIND THE FIRST EMERGENCY EXIT NEEDS TO BE RESECURED. IT IS DANGLING FROM CEILING. RESET OVERHEAD EMERGENCY LIGHT AND RESECURED. PER AMM 33-51-01.SDR AALA202509155454Seal · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC PRESSURE DURING FLIGHT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DTW. NUMBER 2 ENGINE DRIVEN HYDRAULIC PUMP DRIVE PAD SEAL ON THE GEAR BOX REQUIRES REPLACEMENT DUE TO PUMP FAILURE AND HEAT. RESDR AALA202509155523Slide · inoperativeAIRCRAFT IN BASE MAINTENANCE: SLIDES NEEDS TO BE REMOVED. REMOVED AND REPLACED DOOR SLIDE. PER AMM 25-66-01.SDR AALA202509151885Locking Cam · undertorquedAIRCRAFT WAS GROUNDED: GIRT BAR BRACKET IN BACK OF AIRPLANE NEEDS TO BE TIGHTENED. BRACKET IS COMING UP. REMOVED AND REPLACED FLOOR MOUNTED ESCAPE SLIDE BRACKET HARDWARE. PER AMM 25-66-02.SDR AALA202509158574Bracket · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR FLOOR MOUNTED ESCAPE SLIDE AFT BRACKET HAS INCORRECT HARDWARE. REMOVE AND REPLACED L2 DOOR FLOOR MOUNTED ESCAPE SLIDE AFT BRACKET HARDWARE. PER AMM 25-66-02.SDR AALA202509153350Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-A DOOR IS DIFFICULT TO OPEN AND CLOSE IN FLIGHT. READJUSTED LAVATORY-A DOOR. PER CMM 25-40-64.SDR AALA202510103177Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR BEAM. REPLACED DOOR BEAM PER SRM 20-10-02-01 AND CMM 52-41-05.SDR AALA202509168023Heater · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER LIFT OFF, STRONG FUME SMELL WAS PRESENT IN CABIN. IT SMELLED LIKE SOMETHING WAS BURNING BUT NO SMOKE WAS PRESENT. WE COULD NOT DETERMINE THE SOURCE OF THE FUMES. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202509163759Relay · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER LIFT OFF, STRONG FUME SMELL WAS PRESENT IN CABIN. IT SMELLED LIKE SOMETHING WAS BURNING BUT NO SMOKE WAS PRESENT. WE COULD NOT DETERMINE THE SOURCE OF THE FUMES. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202509158023Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER LIFT OFF, STRONG FUME SMELL WAS PRESENT IN CABIN. IT SMELLED LIKE SOMETHING WAS BURNING BUT NO SMOKE WAS PRESENT. WE COULD NOT DETERMINE THE SOURCE OF THE FUMES. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202509152366Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. THE DOOR WILL INTERMITTENTLY COME OF THE RAIL. FOUND LOOSE SCREW AT TOP OF DOOR, RETORQUED SCREW OPERATIONAL CHECK NORMAL. PER CMM 25-40-64.SDR AALA202509150428Door · jammedAIRCRAFT WAS NOT GROUNDED: TOP OF AFT LAVATORY-D DOOR IS JAMMING MAKING IT HARD TO OPEN AND CLOSE. RESCURED LAVATORY-D DOOR TRACK. PER AMM 25-40-00.SDR AALA202509152572Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN NEAR THE KNEES OF A PASSENGER SEATED IN SEAT 17F HAS A COVER THAT HAS FALLEN OFF. REPLACE EXIT LIGHT ASSEMBLY AT SEAT 17F. PER AMM 33-51-01.SDR AALA202509121547Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR BEAM LOCATED FROM BS 300 TO BS 328. REPLACED DOOR BEAM PER CMM 52-41-05.SDR AALA202509161383Fire Detector · fault messageAIRCRAFT WAS GROUNDED: CLIMBING THROUGH AROUND FL230, WE RECEIVED 2 OVERHEAT DETECTION ALERTS FOLLOWED BY A FIRE BELL AND ENGINE 2 OVERHEAT. NO FIRE HANDLES ILLUMINATED. THE BELL LASTED UNDER 1 SECOND AND SELF EXTINGUISHED AND A FAULT LIGHT FOLLOWED. ENGINE 2SDR AALA202509165144Wire Harness · faultyAIRCRAFT WAS GROUNDED: CLIMBING THROUGH AROUND FL230, WE RECEIVED 2 OVERHEAT DETECTION ALERTS FOLLOWED BY A FIRE BELL AND ENGINE 2 OVERHEAT. NO FIRE HANDLES ILLUMINATED. THE BELL LASTED UNDER 1 SECOND AND SELF EXTINGUISHED AND A FAULT LIGHT FOLLOWED. ENGINE 2SDR AALA202509160897Girt Bar · no discrepancyAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS GIRT BAR LOCKS ON L2 DOOR TO STIFF AND HARD TO ARM AND DISARM. : PERFORMED OPERATIONAL CHECK OF L2 GRIT BAR LOCKS. FOUND LOCKS TO BE OPERATING SMOOTH AND NORMAL FUNCTION. PER AMM 25-66-00. NO FAULT FOUND.SDR AALA202509169355Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: LEFT AFTER FUEL PUMP LIGHT WILL ILLUMINATE IN TEST, BUT LIGHT DOES NOT COME ON WHEN BOOST PUMP IS TURNED OFF. CONFIRMED INTERMITTENT INDICATION OF LOW-PRESSURE LIGHT WHEN AFT LEFT FUEL BOOST PUMP SWITCHED TO OFF. REMOVED AND REPLACE
Back to Boeing 737-823