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 AALA202401223015Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL ATTACH CLIP AT BS 500D, S26L. REPLACED CLIP PER 53-00-01-6 REPAIR 6.SDR AALA202401229973Attach Angle · scratchedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL ATTACH CLIP AT BS 500F, S26L. REPLACED CLIP PER 53-00-01-6 REPAIR 6.SDR AALA202401197786Sliding Window · misriggedAIRCRAFT WAS NOT GROUNDED: CAPTAIN L2 WINDOW DIFFICULT TO CLOSE. RIGGED WINDOW. PER AMM 56-12-11 OPERATIONAL CHECK GOOD.SDR AALA202401197846Slide · out of positionAIRCRAFT WAS GROUNDED: CATERING REPORTS R 1 DOOR SLIDE GIRT BAR LAYING ON FLOOR WITH SLIDE MATERIAL DRAGGING ON FLOOR. INSTALLED NEW SLIDE PACK. PER JOB CARD 08L22125001.SDR AALA202401194386Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON SEAT 28C IS HANGING BY THE WIRES. REPLACED MISSING HARDWARE ON EMERGENCY PATH LIGHT HOUSING AT SEAT 28C. OPERATIONAL CHECK NORMAL. PER AMM 33-51-11.SDR AALA202401192785Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ACCOMPLISHED READJUSTMENT OF AFT LEFT LAVATORY DOOR. PER AMM 52-00-00.SDR AALA202401197868Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR STICKS AND LIGHT DOES NOT COME ON WHEN LOCKED. REALIGNED DOOR AS REQUIRED. PER AMM 25-40-14.SDR AALA202401191928Door Latch · looseAIRCRAFT WAS GROUNDED: RIGHT AFT LAVATORY DOOR HANDLE LOOSE, DIFFICULT TO OPERATE OPEN AND CLOSE. REPLACED AFT LEFT LAVATORY DOOR LOCK. OPERATIONAL CHECK GOOD. PER AMM 25-50-00.SDR AALA202401195016Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR 1R (SERVICE DOOR) GRIT BAR DIFFICULT TO DISARM. REMOVED DEBRIS AND LUBRICATED GRIT BAR SLIDE BRACKETS. OPERATIONAL CHECK GOOD. PER AMM 26-66-02.SDR AALA202401195053Door · out of adjustAIRCRAFT WAS GROUNDED: DOOR ON AFT RIGHT LAVATORY DIFFICULT TO OPEN AND CLOSE. ADJUSTED AFT LAVATORY RIGHT HAND DOOR. OPERATIONAL CHECKED GOOD.SDR AALA202401197350Shock Mount · brokenAIRCRAFT WAS GROUNDED: FORWARD RIGHT EMERGENCY EXIT HATCH (ROW 16F) 1 SHOCK MOUNT REQUIRES REPLACEMENT. **SUPPLEMENTAL REPORT FOR (AALA202401187350): INSTALLED NEW SHOCK MOUNT PER BOEING SRM 51-40-02**(CLOSED).SDR AALA202401187350Shock Mount · unknownAIRCRAFT WAS GROUNDED: FORWARD RIGHT EMERGENCY EXIT HATCH (ROW 16F) 1 SHOCK MOUNT REQUIRES REPLACEMENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401258889Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL FROM BS 312 TO BS 327, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202401224214Tube · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK ON GIRT BAR MISSING AT FORWARD GALLEY RIGHT SERVICE ENTRY DOOR.**SUPPLEMENTAL REPORT FOR (AALA202401184214): INSTALLED RED HEAT SHRINK AT FORWARD GALLEY RIGHT SERVICE ENTRY DOOR. PER AARD 25-66-00-4. OK FOR SERVICE.**SDR AALA202401223184Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DIFFICULT TO LOCK AND UNLOCK. ACCOMPLISHED AARD 25-40-10-10 FOR LAVATORY D HINGE. OPERTIONAL CHECKS GOOD.**(CLOSED).SDR AALA202401227670Door · out of rigAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED ON TOUCHDOWN FLIGHT ATTENDANT STATES HANDLE HAD RAISED UP DURING DESCENT.**SUPPLEMENTAL REPORT FOR (AALA202401187670): PARTIAL WORK ACCOMPLISHED ACCOMPLISHED RIGGED DOOR. PER WORK CARD 08C83152006**(CSDR AALA202401198535Pressure Switch · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL LOW PRESSURE LIGHT ILLUMINATED IN FLIGHT, AIRCRAFT WAS IN LEVEL FLIGHT. REMOVE AND REPLACED RIGHT AFT BOOST PUMP PRESSURE SWITCH. PER AMM 24-42-11. OPERATIONAL CHECK GOOD.SDR AALA202401180559Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 DOOR EXTERIOR, EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP AT R1 DOOR SLIDE EMERGENCY LIGHT PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202401185178Cover · looseAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR 4L EMERGENCY EXIT SLIDE COVER LOOSE. RESECURED L4 DOOR EMERGENCY ESCAPE SLIDE COVER. PER AMM 25-66-01-400-803. OPERATIONAL CHECK GOOD.SDR AALA202401187670Door · faultedAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED ON TOUCHDOWN FLIGHT ATTENDANT STATES HANDLE HAD RAISED UP DURING DESCENT.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401184072Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE IS LOOSE AND REQUIRES TIGHTENING. SECURED DOOR HANDLE AS REQUIRED. CHECKED NORMAL.SDR AALA202401183184Lock · unknownAIRCRAFT WAS NOT GROUNDED: LAVATORY D DIFFICULT TO LOCK AND UNLOCK.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401184214Tube · missingAIRCRAFT WAS NOT GROUNDED: RED HEAT SHRINK ON GIRT BAR MISSING AT FORWARD GALLEY RIGHT SERVICE ENTRY DOOR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401184824Shock Mount · brokenAIRCRAFT WAS GROUNDED: AFT RIGHT EMERGENCY EXIT HATCH (17F) 1 SHOCK MOUNT REQUIRES REPLACEMENT. REMOVED AND REPLACED DAMAGED SHOCK MOUNT ON RIGHT HAND AFT EMERGENCY EXIT DOOR. PER SRM 51-40-02.SDR AALA202402081596Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947 TO BS 967, RBL 24.5. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202401257453Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL FROM BS 294 TO BS 277, BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202401234102Module · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT CONTROL ISSUES WITH EVERY RIGHT-HAND DEFLECTION OF YOKE. AIRCRAFT RETURN TO AND LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202401171607): REMOVED AND REPLACED SDR AALA202401231607Module · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT CONTROL ISSUES WITH EVERY RIGHT-HAND DEFLECTION OF YOKE. AIRCRAFT RETURN TO AND LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202401171607): REMOVED AND REPLACED SDR AALA202401238902Pcu · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT CONTROL ISSUES WITH EVERY RIGHT-HAND DEFLECTION OF YOKE. AIRCRAFT RETURN TO AND LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202401171607): REMOVED AND REPLACED SDR AALA202401233612Pcu · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT CONTROL ISSUES WITH EVERY RIGHT-HAND DEFLECTION OF YOKE. AIRCRAFT RETURN TO AND LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202401171607): REMOVED AND REPLACED SDR AALA202401197901Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT STA 354. LBL 10. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202401195549Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT STA 335. BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202401195547Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT STA 321, BL 0. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA2024011899056Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY LOCK IS DIFFICULT TO OPERATE. SECURED AFT LEFT LAVATORY DOOR UPPER TRIM PER AMM 25-40 -00SDR AALA202401177239Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND LAVATORY DIFFICULT TO LOCK AND UNLOCK. LUBED DOOR LOCK. OPERATIONAL CHECK GOOD.SDR AALA202401176447Hinge · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR HINGE IS LOOSE. REATTACHED LEFT AFT LAVATORY DOOR HINGE PER CMM.SDR AALA202401172048Brake Assy · seizedAIRCRAFT WAS GROUNDED: WITH BRAKES RELEASED, THE AIRCRAFT WILL NOT MOVE WHEN TRYING TO PUSHBACK. BRAKES DISCOVER TO BE SEIZED, REMOVED AND REPLACED NUMBER 1 BRAKE (AALA202401172048) AND NUMBER 2 BRAKE (AALA202401176128) ASSEMBLY. PER AMM 32-41-41. OPERATIONAL SDR AALA202401176128Brake Assy · seizedAIRCRAFT WAS GROUNDED: WITH BRAKES RELEASED, THE AIRCRAFT WILL NOT MOVE WHEN TRYING TO PUSHBACK. BRAKES DISCOVER TO BE SEIZED, REMOVED AND REPLACED NUMBER 1 BRAKE (AALA202401172048) AND NUMBER 2 BRAKE (AALA202401176128) ASSEMBLY. PER AMM 32-41-41. OPERATIONAL SDR AALA202401171607Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT CONTROL ISSUES WITH EVERY RIGHT HAND DEFLECTION OF YOKE. AIRCRAFT RETURN TO AND LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. (OPEN).SDR AALA202401177276Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202401172473Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK MAIN CABIN FLOOR SUPPORT BREAK ASSEMBLY AT STA 540, LBL 2. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202401178750Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK MAIN CABIN FLOOR SUPPORT BREAK ASSEMBLY AT STA 540, RBL 2. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202401163602Idg · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WITH NUMBER 1 GENERATOR INOPERATIVE ALREADY, APU QUIT WORKING ASLO. AIRCRAFT RETURN TO AND LANDED SAFELY AT ORD WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED LEFT HAND ENGINE IDG PER AMM 24-11-00. OPERASDR AALA202401168890Pin · shearedAIRCRAFT WAS GROUNDED: L1 DOOR WILL NOT OPEN. FOUND RADIUS PIN SCREW SHEARED. REMOVED AND REPLACE RADIUS PIN AND SCREW PER AMM 52-11-21. DOOR OPERATES NORMAL.SDR AALA202401160707Threshold · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN AND CLOSE. DOOR DRAGS ON THRESHOLD. CLEANED DEBRIS FROM BOTTOM OF DOOR AND SECURED LOWER SILL.SDR AALA202402167972Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER CHORD OF APU ENCLOSURE AT BS 1104, RBL 21. REPAIRED CHORD PER EA 351132.SDR AALA202402085921Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT BS 947.5, RBL 45. REPLACED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202402062226Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOOR BEAM, AROUND LAVATORY FLOOR MOUNT, AT BS 947.5, LBL 25. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA202402069836Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL, , CORROSION ON TRANSITION PANEL BETWEEN BS 747 AND BS 767, RBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2 AND AARD 51-00-05-01SDR AALA202402061038Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK N FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C MINUS 6 INCHES, RBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02 AND SRM 53-00-53-2R-6.
Back to Boeing 737-823