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 AALA202508110644Indication Sys · faultedAIRCRAFT WAS GROUNDED: ON APPROACH AFTER FLAPS 1 SELECTED AND EXTENDED, NOSE GEAR LIGHTS BOTH RED AND GREEN WERE FLASHING AND MOMENTARILY STAYING LIT WITHOUT GEAR BEING ACTUATED. (OPEN).SDR AALA202508115201Slide · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS R1 IS DIFFICULT TO ARM. CHECKED AND ADJUSTED R1 DOOR SLIDE. OPERATIONAL CHECKS GOOD TO ARM. PER AMM 25-66-01SDR AALA202508118886Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR JAMMED. ADJUSTED LAVATORY-D DOOR ON AFT LEFT HAND CABIN, OPERATIONAL CHECK GOOD. PER AMM 25-40-14SDR AALA202508114438Girt Bar · unsecureAIRCRAFT WAS GROUNDED: AFT LEFT DOOR GIRT BAR FITTING LOOSE. SECURED AFT LEFT DOOR ASSEMBLY GIRT BAR LOCK. PER AMM 25-26-01.SDR AALA202508111880Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY SLIDE ON BOARDING DOOR L1 HAS A FLAP EXPOSED AFTER DISARMING. RESECURED LOOSE FABRIC STRAP ON L1 DOOR EMERGENCY SLIDE PACK AND PERFORMED OPERATIONAL CHEC KOF THE GIRT BAR SYSTEM. PER AMM 25-66-01. NO FURTHER DEFECTS NOTED.SDR AALA202508111631Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 23. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202508114199Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, RBL 23. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202508084932Stop Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: R1 SERVICE DOOR LOWER FORWARD DOOR STOP PLATE CRACKED. REPLACED DOOR STOP PLATE PER AMM 52-41-01SDR AALA202508073026Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS STICKING AND HARD TO OPEN. FOUND FIRST CLASS LAVATORY DOOR LATCH LOOSE, SECURED LATCH SCREW. DOOR OPERATIONAL CHECK GOOD.SDR AALA202508074415Control Unit · faultedAIRCRAFT WAS GROUNDED: DURING THE LANDING ROLL AND AGAIN DURING THE TAXI, THE ANTI-SKID AND BRAKING SYSTEM HAD A TENDENCY TO SKIP AND STUTTER. PERFORMED (AACU)-ANTISKID AUTOBRAKE CONTROL UNIT BITE PER FIM 32-42-00-810-801. FOUND MULTIPLE FAULTS. REMOVE AND REPSDR AALA202508076314Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE FROM THE OUTSIDE. FLIGHT ATTENDANT ADVISES YELLOW GUST LOCK INSIDE IS DIFFICULT TO PRESS. INSPECTED MAIN CABIN DOOR, PER AMM TASK 52-13-51-200-801. FOUND GUST LOCK NEEDED TO BE LUBED, OPERASDR AALA202508276174Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ECS BAY VERTICAL STIFFENER AT BS 663 INBOARD SIDE ON KEEL BEAM HAS FASTENER HOLES IN COMMON WITH HORIZONTAL STIFFENER TWO EACH CRACKED. INSTALLED NEW VERTICAL STIFFENER, PER AARD 51-00-05-1, BOEING DWG 144A7100 AND SRM SDR AALA202508214977Frame · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ECS BAY AFT BULKHEAD UPPER CHORD INBOARD SIDE CRACKED ALONG THE RIVET. REPAIRED RIGHT HAND ECS BAY AFT BULKHEAD UPPER CHORD INBOARD SIDE. PER B737-NG SRM 57-10-10-2R PROCEDURE 5 REPAIR 5.SDR AALA202508142655Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, AT THIRD STIFFENER FROM THE FRONT SPAR, AT STABILIZER STA 92.70. REPLACED RIB PER AARD 55-10-00-2.SDR AALA202508072240Lock · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D LOCK BROKEN, GETS JAMMED WITH OCCUPANTS UNABLE TO UNLOCK. RESECURED BEZEL AROUND DOOR LOCK WITH RTV. PER STANDARD PRACTICES. OPERATIONAL CHECK GOOD.SDR AALA202508062240Lock · brokenAIRCRAFT WAS NOT GROUNDED: LAVATORY-D LOCK BROKEN, GETS JAMMED WITH OCCUPANTS UNABLE TO UNLOCK. (OPEN).SDR AALA202508061918Girt Bar · faultyAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR HARD TO REMOVE FROM SLIDE CONTAINER HOOKS. REPOSITIONED FORWARD R1 DOOR GIRT BAR. PER AMM 25-66-00. OPERATIONAL CHECK GOOD.SDR AALA202508068650Lock · stuckAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK KEEPS GETTING STUCK IN THE CLOSED POSITION. PEOPLE ARE HAVING TROUBLE GETTING OUT OF THE LAVATORY. CLEANED OBSTRUCTION FROM LOCKING MECHANISM ON AFT LEFT LAVATORY OPERATIONAL CHECK NORMAL.SDR AALA202508065312Fastener · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY-A DOOR IS STICKING WHEN OPENING AND CLOSING. TIGHTENED LOOSE FASTENERS ON THRESHOLD DOOR. PER CMM25-48-48. OPERATIONAL CHECK GOOD.SDR AALA202508067657Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT ATTENDANT IN AFT GALLEY HAD SMELLED SMOKE LIKE A BURNING CLOTHING SMELL, IMMEDIATELY AFTER TAKEOFF. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. ACCOMPLISHED J/C 08L00021001 TROUBLESHOOTING SMOKSDR AALA202508069298Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 963, RBL 18. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508054668Slide · misinstalledAIRCRAFT IN BASE MAINTENANCE: R2 DOOR SLIDE INSTALLED INCORRECTLY. NEEDS TO BE RE-SEATED AGAINST THE DOOR MAINTENANCE REMOVED SLIDE PACK FROM DOOR AND REINSTALLED PER AMM 25-66-01-400-803 STEP E.SDR AALA202509033975Sill Drain · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 967 TO BS 986, AT RBL 47. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508137917Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT AT BS 986.5, RBL 40. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202508111629Guide · gougedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR CUTOUT, AFT DOOR FRAME, LOWER SIDE CENTERING GUIDE CASTING GOUGED. REPLACED CENTERING GUIDE CASTING PER AARD 51-00-05-1.SDR AALA202508084484Door · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SERVICE DOOR UPPER AFT STOP PAD CRACKED. REPLACED DOOR STOP PAD PER AMM 52-41-01SDR AALA202508087419Guide · wornAIRCRAFT IN BASE MAINTENANCE: L1 DOOR CENTERING GUIDE PLATES WORN ON THE AFT DOOR FRAME. REPLACED AND ADJUSTED THE L1 DOOR CENTERING GUIDE TRACK PER AMM 52-11-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202508056958Plunger · missingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT, LATCH HANDLE IS MISSING A BUSHING, THE SPRINGS AND THE PLUNGERS. MAINTENANCE INSTALLED NEW BUSHING, SPRINGS AND PLUNGERS ON LATCH HANDLE ASSEMBLY. MAINTENANCE INSTALLED LATCH HANDLE ASSEMBLY PER ASDR AALA202508050447Spring · missingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT, LATCH HANDLE IS MISSING A BUSHING, THE SPRINGS AND THE PLUNGERS. MAINTENANCE INSTALLED NEW BUSHING, SPRINGS AND PLUNGERS ON LATCH HANDLE ASSEMBLY. MAINTENANCE INSTALLED LATCH HANDLE ASSEMBLY PER ASDR AALA202508052455Bushing · missingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT, LATCH HANDLE IS MISSING A BUSHING, THE SPRINGS AND THE PLUNGERS. MAINTENANCE INSTALLED NEW BUSHING, SPRINGS AND PLUNGERS ON LATCH HANDLE ASSEMBLY. MAINTENANCE INSTALLED LATCH HANDLE ASSEMBLY PER ASDR AALA202508050886Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT THAT THE AFT RIGHT LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR THRESHOLD TO ALLOW PROPER DOOR CLEARANCE. PER AMM 25-40-08. OPERATIONAL CHECK GOOD.SDR AALA202508055175Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS STUCK CLOSED. LUBRICATED AFT LEFT LAVATORY DOOR TRACK AND LOCK. PER AMM 25-40-15. OPERATIONAL CHECK GOOD.SDR AALA202508053568Light · dislodgedAIRCRAFT WAS NOT GROUNDED: 24C EMERGENCY AISLE LIGHT HANGING BY A WIRE. SECURED 24C AISLE EMERGENCY LIGHT.SDR AALA202508056094Tube · leakingAIRCRAFT WAS GROUNDED: FUME EVENT STRONG CHEMICAL SMELL (SMELLS LIKE FERTILIZER) ON DESCENT AND THEN AGAIN ON THE GROUND WITH THE HIGH PRESSURE CART ATTACHED AND THE PACKS SELECTED ON. VERIFIED ENGINE OIL LEAKING OUT OF APU DRAIN MAST. VERIFIED ENGINE OIL LEAKSDR AALA202508058997Screen · unsecureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMBING THRU FL220 ENGINE NUMBER 1 OIL INDICATED 3Q, OIL PRESSURE INDICATION WAS ABNORMAL AND FLUCTUATING. SHUT DOWN ENGINE NUMBER 1, OIL QUANTITY THAN DROPPED TO ZERO. AIRCRAFT AIR INTERRUPTED BSDR AALA202508056127Slide · out of adjustAIRCRAFT WAS NOT GROUNDED: PIECES OF THE EVACUATION SLIDE ARE STICKING OUT OF THE FORWARD SERVICE DOOR. PERFORMED INSPECTION OF THE FORWARD SERVICE DOOR ESCAPE SLIDE PACK. FOUND VELCRO SKIRT NOT ATTACHED AND REATTACHED. PER AMM 25-66-01.SDR AALA202508059692Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT HAND NUMBER 1 EMERGENCY FLASHLIGHT INOPERATIVE. REMOVE AND REPLACED FLASHLIGHT BATTERY. PER AMM 25-60-00. OPERATIONAL CHECK GOOD.SDR AALA202508052760Light · dislodgedAIRCRAFT WAS NOT GROUNDED: CEILING LIGHT ABOVE ROW 27 DEF HANGING DOWN FROM IT'S MOUNTED POSITION. REMOVE AND REPLACED EMERGENCY AISLE LIGHT. PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA202508053196Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN AT OVERWING EXITS DETACHED FROM CEILING. REINSTALLED EMERGENCY EXIT SIGN ON CEILING. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202508059966Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN OVER EXIT ROW DETACHED. RESECURED OVERWING AISLE AFT SIDE EMERGENCY EXIT LIGHT SIGN. PER AMM 33-51-03.SDR AALA202508054684Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN MISSING AT 16A. REPLACED EXIT SIGN. PER AMM 33-50-00.SDR AALA202508116266Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD LOCATED FROM BS 747 TO BS 787 AT RBL 23. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202508055588Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAPS HAD ASYMMETRY. AIRCRAFT EMERGENCY LANDED SAFELY AT DTW. FSEU SHOWS MM 27-53256 IN FAULT HISTORY. INTERMITTENT ON FSEU. REMOVE AND REPLACED FLAP SKEW 7 SENSOR. PER AMM 27-59-01 AND FSDR AALA202508058209Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 66. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202508055618Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, RBL 23. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202508053303Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS DOOR STICKING IN RIGHT AFT LAVATORY REMOVED AND REPLACED RIGHT AFT LAVATORY DOOR. PER CMM 25-40-65. OPERATIONAL CHECK GOOD.SDR AALA202508041498Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508047743Intercostal · crazedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 274 TO BS 294.5 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508042315Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE FROM BS 500 TO BS 500A AT S26L. REPLACED BAFFLE PER AARD 51-00-05-1 .SDR AALA202508045722Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE FROM BS 500C TO BS 500D AT S25L. REPLACED BAFFLE PER AARD 51-00-05-1 .
Back to Boeing 737-823