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 AALA202108092556Packing · leakingAIRCRAFT WAS GROUNDED: MULTIPLE HYDRAULIC LOW PRESSURE LIGHTS ON TAKEOFF, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED PACKING IN LH MAIN LANDING GEAR FRANGIBLE FITTING WITH NEW IAW AMM 32-32-52, LEAK AND OPS CHECK GOOD.SDR AALA202108099796Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FWD LAVATORY DOOR STICKS. ADJUSTED DOOR IAW AMM 52-50-00, OPS CHECK GOOD.SDR AALA202108097765Circuit Breaker · damagedAIRCRAFT WAS GROUNDED: CABIN EMERGENCY LIGHT CIRCUIT BREAKER IS DAMAGED. REPLACED CIRCUIT BREAKER P9 ON PANEL P6-11 PER AMM 20-60-05.SDR AALA202108178498Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HORIZONTAL STABILIZER 3RD STIFFENER FROM THE FRONT IS CRACKED ON RIB AT STA 129.50. INSTALLED NEW RIB PER SRM 51-40-02.SDR AALA202108178099Rib · crackedAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER RIB CRACKED AT STA 92.70. NEW RIB INSTALLED PER SRM 51-40-02.SDR AALA202108092465Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN UPPER SUPPORT ANGLE OUTBD OF KEEL BEAM AT STA 663.75 AND RBL 13, MEASURING L=0.5 IN, W=0.001 IN, D=0.071 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 57-10-10 AND EA 329337.SDR AALA202108098401Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT BROKEN AT SEAT 8C. SECURED LIGHT ASSEMBLY IAW AMM 33-51-03, OPS CHECK GOOD.SDR AALA202108098402Fitting · damagedAIRCRAFT WAS GROUNDED: UNABLE TO RETRACT LH MAIN LANDING AFTER TAKEOFF, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD; FOUND FRANGIBLE FITTING DAMAGED DUE TO MULTIPLE BIRD STRIKES. REPLACED LH FRANGIBLE FITTING ASSEMBLY WITH NEW IAW AMM 32-32-52, OPS CHECK GSDR AALA202108090608Shroud · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DETACHED AT SEAT 15ABC. REPLACED SHROUD ASSEMBLY WITH NEW IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202108090061Lamp · burned outAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT OVER LEFT HAND REAR EMERGENCY EXIT DOOR IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202108064518: REPLACED LIGHT COVER AND RELAMPED (AALA202108090061) PER AMM 33-21-00** (CLOSED)SDR AALA202108094518Cover · missingAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT OVER LEFT HAND REAR EMERGENCY EXIT DOOR IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202108064518: REPLACED LIGHT COVER AND RELAMPED (AALA202108090061) PER AMM 33-21-00** (CLOSED)SDR AALA202108063060Slide · dislodgedAIRCRAFT WAS GROUNDED: THE SLIDE FELL OUT OF ITS HOLDER AFTER THE L1 DOOR WAS OPENED AT THE GATE. RESECURED SLIDE PER AMM 25-66-00.SDR AALA202108066366Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: FOUND CIRCUIT BREAKER OUT / OPEN FOR PASSENGER CABIN LIGHTING EMERGENCY CHARGER FORWARD P18-3 A11. RESET CIRCUIT BREAKER PER GPM 13-04-07. ACCOMPLISHED POWER SUPPLY TEST PER AMM 33-51-06 AND WDM 33-51-11. OK FOR SERVICE.SDR AALA202108064518Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT OVER LEFT HAND REAR EMERGENCY EXIT DOOR IS INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108208819Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF RH HORIZONTAL STABILIZER AT STA 138.7, 10 IN FWD OF REAR SPAR, MEASURING L=0.9 IN, W=0.002 IN, D=0.06 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202108207805Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF LH HORIZONTAL STABILIZER AT STA 138.7, 18 IN FWD OF REAR SPAR, MEASURING L=0.9 IN, W=0.002 IN, D=0.08 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202108207142Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER SKIN OF LH HORIZONTAL STABILIZER AT STA 138.7, 10 IN FWD OF REAR SPAR, MEASURING L=0.9 IN, W=0.002 IN, D=0.08 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 55-10-01-2R-11.SDR AALA202108069743Light · dislodgedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT ATTACHED TO SEAT 18C HAS COME UNMOUNTED AND IS HANGING BY ITS WIRES. SECURED ESCAPE PATH LIGHT COVER AS REQUIRED.SDR AALA202108050059Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 FLIGHT ATTENDANT FLASH LIGHT INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00.SDR AALA202108119459Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 20ABC. SECURED LIGHT SHROUD IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202108117249Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 23ABC. SECURED LIGHT SHROUD IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202108112120Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 32ABC. **SUPPLEMENTAL REPORT: SECURED LIGHT SHROUD IAW CMM 25-23-67, OPS CHECK GOOD.** (CLOSED)SDR AALA202108092527Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: TEMPORARY REPAIR IN PRESSURE DECK SKIN AT STA 663 BETWEEN RBL 40 AND RBL 45, MEASURING L=26.0 IN, W=14.0 IN, D=0.05 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 57-10-10-2R-3.SDR AALA202108069459Shroud · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 20ABC. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108067249Shroud · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 23ABC. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108067387Shroud · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 26ABC. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108062120Shroud · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SHROUD BROKEN AT SEAT 32ABC. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108045420Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR IS DIFFICULT TO OPEN. LUBED LATCH ASSEMBLY. CHECKS NORMAL.SDR AALA202108046579Fastener · looseAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR HARD TO OPEN AND CLOSE IN FLIGHT. TIGHTENED LOOSE DOOR JAMB FASTENERS.SDR AALA202108044235Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR CAN ONLY BE OPENED BY THE OUTSIDE BY PRYING IT EVEN THOUGH IT IS UNLOCKED. LUBED DOOR LATCH. OK FOR SERVICE.SDR AALA202108040991Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR DIFFICULT TO ARM AND DISARM FRONT RIGHT SERVICE DOOR. ADJUSTED GIRT BAR REST HOLDER.SDR AALA202108066290Housing · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LOOSE AT SEAT 22C. REPLACED EMERGENCY LIGHT HOUSING WITH NEW IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202108064071Light · damagedAIRCRAFT WAS NOT GROUNDED: PASSENGER ESCAPE PATH LIGHT DAMAGED AT SEAT 28C. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202108041549Flashlight · intermittentAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT LEFT FLASH LIGHT INTERMITTENT. REPLACED FLASH LIGHT PER AMM 25-64-00.SDR AALA202108030094Bracket · out of adjustAIRCRAFT WAS GROUNDED: GIRT BAR BRACKET ON 1R DOOR DOES NOT HOLD BAR IN PLACE WHEN DISARMED/STOWED. ADJUSTED BRACKET AS REQUIRED, OPS CHECK GOOD.SDR AALA202108030289Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. REPLACED BATTERY WITH NEW IAW AMM 25-64-00, OPS CHECK GOOD.SDR AALA202108036792Strap · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR SLIDE HAS PART OF SLIDE HANGING OUT OF LOWER PART OF THE COVER. FOUND SLIDE STRAP HANGING OUT OF COVER RE SECURED STRAP AS REQUIRED.SDR AALA202108032181Cam · brokenAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK DOES NOT ENGAGE. REPLACED BROKEN SPRING (AALA202108037880) AND CAM (AALA202108032181) ON GUST LOCK PER AMM 52-11-21.SDR AALA202108037880Spring · brokenAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK DOES NOT ENGAGE. REPLACED BROKEN SPRING (AALA202108037880) AND CAM (AALA202108032181) ON GUST LOCK PER AMM 52-11-21.SDR AALA202108034274Bustle · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE BUSTLE IS DAMAGED. ADJUSTED BUSTLE AT DOOR PER AMM 52-11-31.SDR AALA202108031866Cover · looseAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY EXIT LIGHT AT SEAT 10C PLASTIC COVER IS LOOSE. REATTACHED PLASTIC COVER PER CMM 25-23-67.SDR AALA202108204866Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT CREASE ANGLE HAS CORROSION LOCATED BETWEEN STA 967-987, STR 17L. REMOVED AND REPLACED WITH NEW LEFT CREASE ANGLE PER SRM 51-40-02.SDR AALA202108207498Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON Z ANGLE LOCATED AT STA 1016 AND LEFT BUTT LINE 45. REMOVED AND REPLACED Z ANGLE.SDR AALA202108188406Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=2.20 IN, W=2.40 IN, D=0.038 IN, ON LEFT HAND TRANSITION PANEL. PANEL LOCATED BETWEEN STA 500F TO 500I AT LBL 25. REPLACED PANEL PER SRM 51-40-02 AND SRM 50-00-50-2R-5.SDR AALA202108122738Shroud · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTING AT ROW 23 ABC IS LOOSE AND HANGING. **SUPPLEMENTAL REPORT FOR AALA202108032738: REPLACED LIGHT SHROUD AT SEAT 23 ABC PER ESO 61160.** (CLOSED)SDR AALA202108119540Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RH TRANSITION PANEL BETWEEN STA 500C AND STA 500F AT STR 25R, MEASURING L=2.0 IN, W=1.0 IN, D=0.035 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 51-40-02.SDR AALA202108116199Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RH TRANSITION PANEL BETWEEN STA 500A AND STA 500C AT RBL 26, MEASURING L=1.6 IN, W=1.0 IN, D=0.039 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 51-40-02.SDR AALA202108032738Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTING AT ROW 23ABC IS LOOSE AND HANGING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108027593Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS VERY DIFFICULT TO OPEN AND CLOSE. ADJUSTED LATCH PER AMM 25-44-00.SDR AALA202108237618Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FLOORBOARD SUPPORT CREASE ANGLE AT STA 325 AND RBL 57, MEASURING L=2.5 IN, W=1.0 IN, D=0.015 IN. REPLACED CREASE ANGLE WITH NEW IAW SRM 51-40-01-0G.
Back to Boeing 737-823