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 AALA202304059083Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: STRINGER SPLICE SHOWS SIGNS OF CORROSION AT BODY STATION 362, AND STR 26L. REMOVED AND REPLACED STRINGER PER SRM.SDR AALA202303228676Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500B TO BS 500C AT S26L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303220046Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT PRESSURE BULKHEAD LOWER RUBBER SEAL RETAINER WEB LOCATED AT BS 1016 BETWEEN BL 0 AND LBL 10. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202303224946Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PRESSURE BULKHEAD LOWER SEAL RETAINER LOCATED AT BS 1156 AND LBL 11. REPLACED SEAL RETAINER PER SRM 51-40-02-0G.SDR AALA202303229455Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT PRESSURE BULKHEAD LOWER SEAL RETAINER WEB LOCATED AT BS 1016 FROM LBL 10 TO LBL 20. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202303225557Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PRESSURE BULKHEAD LOWER FORWARD SEAL RETAINER ANGLE LOCATED AT BS 1156 AND WL 246.1. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202303224847Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND INTERCOSTAL LOCATED FROM BS 767 TO BS 787 AT S27R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303228943Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LOWER FUSELAGE SKIN AROUND POTABLE WATER DRAIN LOCATED AT BS 953 BETWEEN S26L AND S27L. REPAIRED SKIN PER EA 343010 AND SRM 53-00-01-2R PROCEDURE 3.SDR AALA202303220811Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER CLOSE OUT WEB JUST ABOVE CABIN FLOOR LOCATED AT BS 1016 AND RBL 33. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202303221688Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT PRESSURE BULKHEAD LOWER CLOSE OUT WEB JUST ABOVE CABIN FLOOR LOCATED AT BS 1016 AND LBL 21. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202303217793Angle · crackedAIRCRAFT IN BASE MAINTENANCE: 1 INCH CRACK ON ANGLE LOCATED AT STA 663.5 AND LEFT BUTT LINE 10. INSTALLED ANGLE AND ANGLE SPLICE PER SRM.SDR AALA202303209104Guide Arm · lockedAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO CLOSE. **SUPPLEMENTAL REPORT FOR AALA202303179104: MAINTENANCE FOUND DOOR GUIDE ARM LOCKED UP. REPLACED GUIDE ARM AND RIG ADJUSTED DOOR PER AMM 52-11-21 AND AMM 52-11-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.*SDR AALA202303179104Unknown · unknownAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202303168949Cotter Pin · missingAIRCRAFT WAS GROUNDED: 4L CABIN ENTRY DOOR HANDLE CREEPS UP ONLY DURING CLIMB PHASE OF FLIGHT, NOT CRUISE. AFT ENTRY LIGHT ILLUMINATED AS HANDLE CREEPS UP. MAINTENANCE REPLACED A MISSING COTTER KEY ON DOOR HANDLE FASTENER AND TIGHTENED FASTENERS PER AMM 52-13-SDR AALA202303238861Guide Arm · jammedAIRCRAFT WAS GROUNDED: DOOR 1L GUST LOCK JAMMED, WILL NOT MOVE. **SUPPLEMENTAL REPORT FOR AALA202303168861: MAINTENANCE REPLACED 1L DOOR GUIDE ARM / GUST LOCK ASSEMBLY PER AMM 52-11-21. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202303228684Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727D TO BS 727E AT S25R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202303229579Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOORBEAM T CHORD LOCATED AT BS 947.5 AND LBL 5. REPAIRED FLOOR BEAM T CHORD PER SRM 53-70-51-2R-5.SDR AALA202303227058Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE LOCATED AT BS 927 BETWEEN S26L AND S27L. REPLACED SHEAR TIE PER SRM 51-40-02-0G.SDR AALA202303226163Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727J TO BS 747 AT RBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202303214211Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 767 TO BS 807 AT LBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202303212465Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 747 TO BS 767 AT RBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202303168861Unknown · unknownAIRCRAFT WAS GROUNDED: DOOR 1L GUST LOCK JAMMED, WILL NOT MOVE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202303151683Unknown · looseAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAV DOOR STICKS. SECURED LOOSE TRIM AT TOP OF DOOR. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303153193Door Latch · out of adjustAIRCRAFT WAS NOT GOURDED: FLIGHT DECK DOOR DIFFICULT TO CLOSE. ADJUSTED AND LUBRICATED DOOR LATCH ASSEMBLY PER AMM 52-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303157047Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY CLOSET DOOR LOCKING MECHANISM PIN DOES NOT ENGAGE TO KEEP DOOR LOCKED. RESECURED LATCH.SDR AALA202303223977Engine · failedAIRCRAFT WAS GROUNDED: WHILE AT CRUISE, LOSS OF OIL QUANTITY AND LOSS OF OIL PRESSURE ON NUMBER 2 ENGINE, OIL PRESSURE APPROXIMATELY 14 PSI, ALTERNATING BETWEEN AMBER AND RED BOX. **SUPPLEMENTAL REPORT FOR AALA202303163977: MAINTENANCE REPLACED NUMBER 2 ENGINESDR AALA202303163977Unknown · unknownAIRCRAFT WAS GROUNDED: WHILE AT CRUISE, LOSS OF OIL QUANTITY AND LOSS OF OIL PRESSURE ON NUMBER 2 ENGINE, OIL PRESSURE APPROXIMATELY 14 PSI, ALTERNATING BETWEEN AMBER AND RED BOX. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202303158157Oven · dirtyAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY OUTBOARD OVEN SMOKING EXCESSIVELY. TURNED OFF AND SMOKING STOPPED. CLEANED OVEN #1 PER AMM 25-32-02-100-801, RAN OVEN ON HIGH FOR TEN MINUTES. NO SMOKE NOTED.SDR AALA202303155500Switch · shortedAIRCRAFT WAS GROUNDED: DURING CLIMB STABILIZER TRIP BECAME INOPERATIVE. STAB TRIM CIRCUIT BREAKER POPPED. FLIGHT RETURNED TO CLT LANDING SAFELY. MAINTENANCE FOUND FIRST OFFICERÏ¿½S COLUMN CUTOUT SWITCH M1201 SHORTED. REPLACED SWITCH M1201 PER AMM 27-41-51. ACCSDR AALA202303145585Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: AIRCRAFT IN LAVATORY E DOOR DIFFICULT TO UNLATCH FROM WITHIN LAVATORY. REMOVED AND REPLACED LAVATORY E DOOR LATCH.SDR AALA202303218214Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATION OF LEFT OUTBOARD FLAP LOWER SKIN LOCATED AT WS 302.50 TO WS 326.50, WBL 658.17. REPAIRED SKIN PER SRM 57-53-01-2R REPAIR 16.SDR AALA202303211263Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATION OF LEFT INBOARD FLAP WEDGE LOWER SKIN LOCATED FROM WS 228.25 TO WS 278.50, WBL 658.17. REPAIRED SKIN PER SRM 57-53-01-2R REPAIR 18.SDR AALA202303215397Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WING TO BODY FAIRING AFT LOWER SUPPORT FRAME ASSEMBLY LOCATED AT BS 727 AND FROM S26L TO S26R. REPLACED FRAME ASSEMBLY PER EA 342891.SDR AALA202303140634Acm · odorAIRCRAFT WAS GROUNDED: A VERY STRONG SMELL ON TAKE OFF AND LANDING. REMOVED AND REPLACED LEFT PACK AIR CYCLE MACHINE.SDR AALA202303133955Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: ROW 16 RIGHT HAND OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303138590Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AROUND CUTOUT FOR WASTE TANK EXHAUST PORT LOCATED AT BS 917 BETWEEN S21L AND S22L. REPAIRED FUSELAGE SKIN PER SRM 53-70-01-2R-3.SDR AALA202303130751Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT OVERWING EMERGENCY EXIT SIGN L1203 CONNECTOR DISCONNECTED. CONNECTED CONNECTOR.SDR AALA202303131800Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT AT L1 FLIGHT ATTENDANT SEAT OUTBOARD INOPERATIVE. REPLACED FLASHLIGHT PER AMM 25-64-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303134654Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: ROW 17 RIGHT HAND OVERWING EMERGENCY EXIT OVER THE WINDOW LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303130940Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: ROW 17 LEFT HAND OVERWING EMERGENCY EXIT LOWER LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303135224Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: ROW 17 RIGHT HAND OVERWING EMERGENCY EXIT LOWER SIDEWALL LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303133042Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: ROW 16 RIGHT HAND OVERWING EMERGENCY EXIT OVER THE WINDOW LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PACK PER AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303211847Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRACK ASSEMBLY LOCATED FROM BS 794 TO BS 840 AT RBL 14. REPLACED CARGO TRACK ASSEMBLY PER SRM 53-00-53-2R-3.SDR AALA202303134326Girt Bar · dirtyAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR DIFFICULT TO ARM. CLEANED R1 DOOR GIRT BAR AREA PER AMM 25-66-02.SDR AALA202303137361Roller · unserviceableAIRCRAFT WAS GROUNDED: L2 CABIN DOOR DIFFICULT TO OPEN. L2 DOOR SNUBBER (AALA202303130928) REPLACED PER AMM 52-13-51. GUIDE ARM (AALA202303139897) AND ROLLER (AALA202303137361) REPLACED PER AMM 52-13-21. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303130928Snubber · unserviceableAIRCRAFT WAS GROUNDED: L2 CABIN DOOR DIFFICULT TO OPEN. L2 DOOR SNUBBER (AALA202303130928) REPLACED PER AMM 52-13-51. GUIDE ARM (AALA202303139897) AND ROLLER (AALA202303137361) REPLACED PER AMM 52-13-21. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303139897Guide Arm · unserviceableAIRCRAFT WAS GROUNDED: L2 CABIN DOOR DIFFICULT TO OPEN. L2 DOOR SNUBBER (AALA202303130928) REPLACED PER AMM 52-13-51. GUIDE ARM (AALA202303139897) AND ROLLER (AALA202303137361) REPLACED PER AMM 52-13-21. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303134203Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS. LUBED DOOR. ACCOMPLISHED SATISFACTORY CHECK.SDR AALA202303135309None · unserviceableAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED DOOR UPPER TRIM RAIL PER CMM 25-40-64. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202304188917Frame · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT MAIN LANDING GEAR PICKLE FORK FRAME FITTING CRACK FOUND FROM FASTENER TO END OF FITTING. DIMENSIONS FORWARDED TO ENGINEERING. **SUPPLEMENTAL REPORT FOR AALA202303148917: LEFT PICKLE FORK FRAME REPLACED WITH 8130 UNIT** (CLOSE
Back to Boeing 737-823