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 AALA202309198816Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR HARD TO OPEN/CLOSE. CLEANED AND LUBED DOOR LATCH.SDR AALA202309199233Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D ACCORDION DOOR HARD TO OPEN AND CLOSE. LUBRICATED DOOR AS REQUIRED.SDR AALA202309194530Oven · odorAIRCRAFT WAS GROUNDED: WHEN OVEN ON BURNING SMELL. REPLACED FORWARD GALLEY #2 OVER PER AMM 25-32-02.SDR AALA202309188648Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. LUBRICATED DOOR LATCH AS REQUIRED.SDR AALA202309277112Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: OVERSIZED HOLE IN FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE LOCATED FROM BS 460 TO BS 480 AT LBL 25. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202309273709Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 5OOG TO BS 500H AT RBL 25. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202309216277Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WING, LEADING EDGE TO WING LOWER ATTACH STRAP ASSEMBLY LOCATED AT FRONT SPAR BETWEEN WS 643.50 TO WS 667.50. REPAIRED STAP PER EA 347564.SDR AALA202309156037Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GUST LOCK LATCH DIFFICULT TO ENGAGE. CLEANED AND LUBED L1 DOOR GUST LOCK RELEASE LEVER.SDR AALA202309154635Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT AFT LEFT FLASHLIGHT INOPERATIVE. REMOVE AND REPLACE FLASHLIGHT BATTERY ON AFT LEFT FLIGHT ATTENDANT FLASHLIGHT PER AMM 25-64-00.SDR AALA202309157323Door Frame · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR HARD TO OPEN AND CLOSE. RE-SECURED DOOR FRAME.SDR AALA202309141243Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT HAND OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED BULB AT LEFT HAND OVERWING EMERGENCY EXIT. PER AMM 33-51-00.SDR AALA202309143198Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPERATE (STICKS). LUBRICATED DOOR HINGES AND DOOR HANDLE OF LEFT AFT LAVATORY DOOR PER AMM 52-50-00.SDR AALA202309137644Bracket · dirtyAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT ENTRY DOOR GIRT BAR DOES NOT SNAP INTO BRACKET TIGHTLY ON FLOOR WHEN ARMING. CLEANED 1L DOOR SLIDE GIRT BAR FLOOR BRACKETS. PER AMM 25-66-02.SDR AALA202309131364Bracket · looseAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD ENTRY DOOR GIRT BAR BRACKET ON THE RIGHT SIDE IS LOOSE. REPOSITIONED LEFT HAND FORWARD ENTRY DOOR GIRT BAR BRACKET. PER AFMM 17.03.9.SDR AALA202309137596Lamp · burned outAIRCRAFT IN BASE MAINTENANCE: AFT LEFT DOOR EXTERIOR EMERGENCY EXIT LIGHT IS INOPERATIVE. MAINTENANCE FOUND CANON PLUG UNCONNECTED TO THE AFT LEFT DOOR EXTERIOR EMERGENCY LIGHT, RECONNECTED CANON PLUG PER WDM 33-51-14. (AALA202309132565) RE-LAMPED AFT LEFT DOOSDR AALA202309132565Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: AFT LEFT DOOR EXTERIOR EMERGENCY EXIT LIGHT IS INOPERATIVE. MAINTENANCE FOUND CANON PLUG UNCONNECTED TO THE AFT LEFT DOOR EXTERIOR EMERGENCY LIGHT, RECONNECTED CANON PLUG PER WDM 33-51-14. (AALA202309132565) RE-LAMPED AFT LEFT DOOSDR AALA202309130252Shroud · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 27C DETACHED. REMOVED AND REPLACED EMERGENCY LIGHT SHROUD ASSEMBLY.SDR AALA202309139985Oven · smokeAIRCRAFT WAS NOT GROUNDED: GALLEY 1 NUMBER 2 OVEN HAS SMOKING BURNING SMELL. REMOVED AND REPLACED NUMBER 2 OVEN PER AMM 25-11-21.SDR AALA202309132771Adiru · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO UNCOMMANDED YAW RIGHT AT 130 KIAS ON TAKEOFF. AIRCRAFT LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. MAINTENANCE PERFORMED STALL MANAGEMENT YAW DAMPER BITE TEST PROCEDURE PER FIM 27-32-00-810-801. FOUND SDR AALA202309131723Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309133489Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309133101Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309139786Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309130842Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309132935Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309134502Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309139237Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309130770Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309134503Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309129361Screw · looseAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR IS HARD TO OPEN BECAUSE BOTTOM OF DOOR STICKS TO TRACK. ADJUSTED LOOSE SCREWS ON BOTTOM OF TRACK.SDR AALA202309147099Baffle · unknownAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500D TO BS 500E AT S25R REQUIRES REPLACEMENT DUE TO PREVIOUS SPLICE REPAIR. REPLACED BAFFLE PER AARD 51-00-05-1 AND AARD 53-00-01-6.SDR AALA202309137384Shutoff Valve · faultedAIRCRAFT WAS GROUNDED: AFTER BOTH ENGINE STARTED LEFT BLEED LIGHT ILLUMINATED ACCOMPANIED BY STRONG ODOR.REMOVED AND REPLACED PRESSURE REGULATING AND SHUT OFF VALVE (PRSOV) ON ENGINE NUMBER 1 PER AMM 36-11-04.SDR AALA202309121421Schrader Valve · looseAIRCRAFT WAS GROUNDED. AIRCRAFT ABORTED TAKEOFF AT 40 KNOTS DUE TO AIRCRAFT YAWED TO THE RIGHT DURING TAKE OFF ROLL, VIBRATION FELT IN BRAKE PEDAL. TROUBLESHOOT FOUND HYDRAULIC SYSTEM A AND B SCHRADER VALVE LOOSE AND LEAKING. 0 HEAD PRESSURE. TIGHTENED AND SECSDR AALA2023091204458Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO MOVE OPEN. CLEANED AND LUBED COCKPIT DOOR.SDR AALA202309126150Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: PASSENGER ENTRY DOOR GUST LOCK DIFFICULT TO UNLOCK. LUBRICATED FORWARD ENTRY DOOR GUST LOCK.SDR AALA202309122889Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY BIFOLD DOOR IS DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBED AFT LEFT LAV BIFOLD DOOR TRACK AND HINGES PER CMM 25-40-64.SDR AALA202309129284Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202309116296Module · faultyAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTS ARE ON WHEN SWITCH IS PLACED TO OFF. REPLACED AFT ATTENDANT CONTROL PANEL EMERGENCY LIGHT MODULE. PER AMM 23-42-00.SDR AALA202309123560Door · unknownAIRCRAFT WAS NOT GROUNDED: L1 DOOR IS DIFFICULT TO OPEN OR CLOSE. FOUND AIRCRAFT SLIGHTLY PRESSURIZED. DEPRESSURIZED CABIN L-1 DOOR OPS CHECK GOOD.SDR AALA202309111697Air Filter · dirtyAIRCRAFT WAS GROUNDED: ODOR (DIRTY SOCKS) WAS PRESENT ON TAKE OFF AND DESCENT. ACCOMPLISHED SMOKE ODOR FUMES TROUBLESHOOTING CARD 059670. REMOVED AND REPLACED LEFT AND RIGHT RECIRCULATING AIR FILTERS PER AMM 21-25-01 (AALA202309111697, AALA202309115280).SDR AALA202309115280Air Filter · odorAIRCRAFT WAS GROUNDED: ODOR (DIRTY SOCKS) WAS PRESENT ON TAKE OFF AND DESCENT. ACCOMPLISHED SMOKE ODOR FUMES TROUBLESHOOTING CARD. REMOVED AND REPLACED LEFT AND RIGHT RECIRCULATING AIR FILTERS PER AMM 21-25-01 (AALA202309111697, AALA202309115280).SDR AALA202309112449Oven · odorAIRCRAFT WAS GROUNDED: FORWARD GALLEY OVEN #1 HAS A BURNING AND EXHAUST ODOR DURING OPERATION. REMOVED AND REPLACED FORWARD GALLEY #1 OVEN PER AMM 25-32-03.SDR AALA202309119176Outflow Valve · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED. AIRCRAFT RETURN TO DFW SAFELY. PRESSURIZATION FAILURE DURING CLIMB. REPLACED AFT OUTFLOW VALVE ASSEMBLY PER AMM 21-31-03.SDR AALA202404115426Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER INSPAR RIB 3, LOCATED AT STABILIZER STA 129.50. REPAIRED RIB PER SRM 55-10-09-2R-4. **SUPPLEMENTAL REPORT FOR AALA202309215426 TO ADD SECTION 5 PART INFORMATION AND TO REMOVE THE LEVEL 2 INSDR AALA202309278616Door Sill · wornAIRCRAFT IN BASE MAINTENANCE: TOOLING MARKS ON FORWARD CARGO COMPARTMENT DOOR THRESHOLD WEB LOCATED FROM BS 440 TO BS 488 AT RBL 26. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202309215426Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER INSPAR RIB 3, LOCATED AT STABILIZER STA 129.50. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202309129164Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FORWARD INBOARD FLIGHT ATTENDANT FLASHLIGHT BATTERY.SDR AALA202309120126Mount · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ROW 33 (ABC) LOOSE. REPLACED AISLE EMERGENCY LIGHT MOUNT AT SEAT 33 (ABC) PER AMM 33-51-03.SDR AALA202309124458Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 92.70, REPLACED RIB PER AARD 51-00-05-1.SDR AALA202309120531Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT RB 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.
Back to Boeing 737-823