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 AALA202405062973Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202405060021Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202405061475Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202405069350Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202405069053Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202405067118Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202405066964Probe · out of toleranceAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT FOR AALA202404166125: REPLACED RIGHT WING MAIN TANK COMPENSATOR AND ALL 12 FUEL PROBES PER AMM 28-41-21. ACCOMPLISHED SATISFACTORY CHECKS. SDR AALA202404251311Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOORBEAM ASSEMBLY AT STA 540 FROM BL 0 TO RBL 24. REPLACED FLOORBEAM ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202404240399Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN UPPER FLANGE OF FLOOR SUPPORT FROM BS 344 TO BS 360, LBL 10. REPLACED THE FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA202404224178Skin · delaminatedAIRCRAFT WAS GROUNDED: DURING PHASE 1 INSPECTION FOUND RIGHT HAND OUTBOARD AFT FLAP TRAILING EDGE TO HAVE DISBONDED SKIN APPROXIMATELY 57 IN ACROSS BY 10 IN HIGH. **SUPPLEMENTAL REPORT FOR AALA202404164178: REPLACED RIGHT HAND OUTBOARD AFT FLAP PER AMM 27-51-SDR AALA202404196346Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM BS 727 TO BS 887, LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202404184929Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN UPPER FLANGE OF PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 344, RBL 1. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404183916Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: 2 CRACKS IN UPPER FLANGE OF PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 312, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404185354Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN UPPER FLANGE OF PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344, LBL 45 REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404175204Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR JAMS HALFWAY CLOSED REQUIRING THE FLIGHT ATTENDANTS TO MANUALLY RELEASE THE DOOR EVERYTIME A PASSENGER USES THE LAVTORY. ADJUSTED LAVATORY-D DOOR. PER AARD 25-40-10-04 NO FURTHER DEFECTS NOTED AT THIS TIME.SDR AALA202404173369Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN. LUBE LEFT AFT LAVATORY DOOR LOCK LATCH AND HINGE. FUNCATIONAL CHECK GOOD. **(CLOSED).SDR AALA202404160741Connector · looseAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INTERMITTENT MASTER CAUTION WITH ELECTRIC LIGHT FOR RIGHT GENERATOR TRANSFER BUS OFF LIGHT FLICKERS AT SAME TIME; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. FOUND CONNECTORS DP1205 & DP1206 LOOSE, RESDR AALA202404164178Skin · debondedAIRCRAFT WAS GROUNDED: DURING PHASE 1 INSPECTION FOUND RIGHT HAND OUTBOARD AFT FLAP TRAILING EDGE TO HAVE DISBONDED SKIN APPROXIMATELY 57 IN ACROSS BY 10 IN HIGH. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404169574Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT INBOARD FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT AT AFT RIGHT FIGHT FLIGHT ATTENDANT SEAT. FUNCATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202404162498Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ON CEILING MISSING THE PANEL. REPLACED EMERGENCY EXIT OVERHEAD SIGN. PER AMM 33-51-01.SDR AALA202404169775Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR STICKS AND DIFFICULT TO OPEN. ADJUSTED DOOR. FUNCATIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202404164129Light · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING HANGING OFF SEAT IN AISLE ROW 16ABC. REATTACHED 16ABC ESCAPE PATH LIGHT. PER AMM 33-51-11.SDR AALA202404163369Door · lack of lubeAIRCRAFT WAS NOT GROUBNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN. LUBE LEFT AFT LAVATORY DOOR LOCK LATCH AND HINGE. FUNCATIONAL CHECK GOOD.SDR AALA202404160266Pin · crackedAIRCRAFT IN BASE MAINTENANCE: INSPECTION REVEALED CRACK ON THE SURFACE. REPLACED PIN ON HORIZONTAL STABILIZER (AALA2024041602660) AND (AALA202404161206). PER AMM 55-10-10.SDR AALA202404161206Pin · crackedAIRCRAFT IN BASE MAINTENANCE: INSPECTION REVEALED CRACK ON THE SURFACE. REPLACED PIN ON HORIZONTAL STABILIZER (AALA2024041602660) AND (AALA202404161206). PER AMM 55-10-10.SDR AALA202404166125Fuel Sys · unknownAIRCRAFT WAS GROUNDED: RIGHT FUEL TANK BURNING FUEL WITH CENTER PUMPS ON. CREATES FUEL IMBALANCE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404167325Unknown · unknownAIRCRAFT WAS GROUNDED: DUE TO CHRONIC HISTORY OF FUEL IMBALANCETAC AUTHORIZED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404168823Door Frame · unsecureAIRCRAFT WAS NOT GROUNDED: THE LAVATORY-A DOOR IS STICKING. SECURED LAVATORY DOOR FRAME. CHECK GOOD. PER AMM 25-40-11.SDR AALA202404165204Door · malfunctionedAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR JAMS HALFWAY CLOSED REQUIRING THE FLIGHT ATTENDANTS TO MANUALLY RELEASE THE DOOR EVERYTIME A PASSENGER USES THE LAVTORY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404165473Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, LBL 45. REPLACED INTERCOSTAL PER SRM 51-00-5-1.SDR AALA202404159920Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS JAMMED SHUT. LUBRICATED LOCKING MECHANISM, FUNCATIONAL CHECK GOOD.SDR AALA202404159714Fuel Cell · overservicedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF ROLL FUEL WAS OBSERVED LEAKING FROM THE RIGHT WING; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT FDF. VERIFIED FUEL LOAD AND SUSPECT FUEL TANK OVERFUELED. NO FAULT FOUND. PER AMM 28-4SDR AALA202404159641Holder · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER FELL OFF IN MID CABIN. INSTALLED NEW EMERGENCY EXIT LIGHT MID CABIN. PER AMM 33-51-01.SDR AALA202404237882Door · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY-E DOOR IS DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT FOR (AALA202404157882): REMOVE AND REPLACED DOOR TRIM EDGE. PER AMM 25-40-14.SDR AALA202404157693Battery · misinstalledAIRCRAFT WAS NOT GROUNDED: AFT RIGHT HAND FLIGHT ATTENDANT LEFT HAND FLASHLIGHT WILL NOT TEST. FOUND AFT RIGHT HAND FLIGHT ATTENDANT LEFT HAND FLASHLIGHT BATTERY INSTALLED INCORRECTLY, INSTALLED BATTERY CORRECTLY. TEST GOOD. PER MM 25-64-00.SDR AALA202404157124Battery · misinstalledAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND FLIGHT ATTENDANT FLASHLIGHT WILL NOT TEST. FOUND AFT LEFT HAND FLIGHT ATTENDANT FLASHLIGHT BATTERY INSTALLED INCORRECTLY, INSTALLED BATTERY CORRECTLY, TEST GOOD. PER MM 25-64-00.SDR AALA202404157452Pressure Valve · faultyAIRCRAFT WAS NOT GROUNDED: ON CLIMBOUT FUEL IMBALANCE BETWEEN LEFT TANK AND CENTER TANK. LEFT HAND WING CENTER WING PRESSURE VALVE WAS REMOVED AND REPLACED. PER 28-22-15-400-801 BY TANK TIGERS W.O. #12450R436.SDR AALA202404152783Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW FOUND FLIGHT DECK DOOR DIFFICULT TO OPEN. CLEANED AND LUBRICATED DOOR LATCH ASSEMBLY. DOOR CHECKS GOOD. PER AMM 52-51-00.SDR AALA202404156975Door · damagedAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR VERY DIFFICULT TO OPEN. DEBURRED LOWER AFT CORNER OF FORWARD LAVATORY DOOR. OPERTIONAL CHECKED NORMAL. PER GPM 02-01-2.SDR AALA202404157882Door · bindingAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY-E DOOR IS DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404157127Shrader Valve · corrodedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND MAIN LANDING GEAR HAS SURFACE CORROSION AT SHRADER VALVE AREA. ACCOMPLISHED PERMANENT REPAIR. PER AARD 32-00-00-1.SDR AALA202404157491Slide · no testAIRCRAFT IN BASE MAINTENANCE: OPERTIONAL CHECK FOR L1 DOOR SLIDE. INSTALLED NEW L1 DOOR SLIDE.SDR AALA202404263953Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN SEAT TRACK AT STA 727 PLUS 10 INCHES, RBL 24. REPLACED SEAT TRACK CROWN PER SRM 53-00-52-2R-3 AND SRM 51-40-02-0G.SDR AALA202404191117Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 986.5, LBL 43. REPAIRED CHORD PER 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202404163000Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 787, WL 155, RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202404120162Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR ON LEFT HAND SIDE DIFFICULTTO OPEN AND CLOSE. LUBRICATED LAVATORY-D DOOR. PER CMM 25-40-64.SDR AALA202404129762Door · out of positionAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN. REPOSITIONED AFT LEFT LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202404121034Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOGHOUSE FLASHLIGHT APPEARS TO BE DISCHARGED. REPLACED THE BATTERY PACK ON THE FORWARD LEFT FLIGHT ATTENDANT SEAT. PER AMM 25-64-00.SDR AALA202404120461Door · openAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: IN ALL PHASE OF FLIGHT A PERSISTENT LIGHT AIR FRAME VIBRATION AND BUFFETING WAS FELT WITH AND WITHOUT AUTOPILOT ENGAGED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. INSPECTED AIRCRAFT PER AMM 05-51-67SDR AALA202404127263Blower · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ALL LAVATORY INOPERATIVE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT TPA. REMOVED OBSTRUCTION FROM LAVATORY LINE (CLOG) AND INSTALLED NEW VACUUM GEN BLOWER AND REINSTALLED ACCESS PANEL. PER AM
Back to Boeing 737-823