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 AALA202206272194Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS DIFFICULT TO OPERATE. ADJUSTED DOOR PER AMM 52-50-00.SDR AALA202206271235Door Sill · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN. ADJUSTED LOWER SILL PER AMM 25-40-11. OPERATIONAL CHECK NORMAL.SDR AALA202206270870Sensor · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR LIGHT CAME ON DURING TAKEOFF. RAN CHECKLIST. PRESSURIZED NORMALLY LIGHT, BLINKED ON AND OFF UNTIL 15,000 FEET, THEN WENT OUT. ADJUSTED ENTRY DOOR SENSOR S199 PER AMM 52-71-11.SDR AALA202206239384Lamp · inoperativeAIRCRAFT WAS GROUNDED: L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT BULB PER AMM 33-51-04.SDR AALA202206230674Retaining Clip · looseAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY SERVICE DOOR GIRT BAR CLIPS ARE LOOSE. INSPECTED GIRT BAR RETAINING CLIPS PER AMM 25-66-01-200-801 NO DEFECTS NOTED. OK FOR SERVICE.SDR AALA202206233019Girt Bar · dirtyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT SERVICE DOOR GIRT BAR IS DIFFICULT TO MOVE IN AND OUT OF IT'S BRACKETS. DIFFICULT TO ARM AND DISARM. CHECKED AND CLEANED AFT RIGHT HAND SERVICE DOOR GIRT BAR PER AMM 25-66-00. GOOD FOR SERVICE.SDR AALA202206239801Controller · unserviceableAIRCRAFT WAS GROUNDED: GLOWING FLAMES IN CAPTAIN'S L1 WINDSHIELD WIRING FOLLOWED BY SMOKE, THEN WINDSHIELD SHATTERED ON LEFT SIDE. FLIGHT LEVEL 350. EMERGENCY DECLARED, FLIGHT DIVERTED TO IND, LANDING SAFELY. ACCOMPLISHED SMOKE ODOR FUME INITIAL TROUBLESHOOTINSDR AALA202206234158Windshield · destroyedAIRCRAFT WAS GROUNDED: GLOWING FLAMES IN CAPTAIN'S L1 WINDSHIELD WIRING FOLLOWED BY SMOKE, THEN WINDSHIELD SHATTERED ON LEFT SIDE. FLIGHT LEVEL 350. EMERGENCY DECLARED, FLIGHT DIVERTED TO IND, LANDING SAFELY. ACCOMPLISHED SMOKE ODOR FUME INITIAL TROUBLESHOOTINSDR AALA202206227945Retainer Cup · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR FOR THE L1 DOOR DOES NOT STAY SECURED WHEN STOWED. ADJUSTED RETAINER CLIPS PER AMM 25-66-01.SDR AALA202206223151Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBRICATED DOOR FRAME. OPEN AND CLOSING GROUND CHECKS NORMAL.SDR AALA202206215929Threshold · stickingAIRCRAFT IN BASE MAINTENANCE: DURING MAIN BASE VISIT FUNCTIONAL CHECK FLIGHT, LAVATORY A DOOR HARD TO OPEN AND CLOSE IN FLIGHT. REPLACED DOOR THRESHOLD PER AMM 25-40-01.SDR AALA202206211495Windshield · delaminatedAIRCRAFT WAS GROUNDED: FIRST OFFICER'S WINDSHIELD APPEARS CRACKED / DELAMINATED IN TOP LEFT CORNER. REPLACED WINDSHIELD PER JOB CARD 08C21256001.SDR AALA202206212680Hub · unsecureAIRCRAFT WAS GROUNDED: CABIN ENTRY DOOR 1 RIGHT HANDLE SLOPPY, MOVES WHILE IN CLOSED POSITION. INSPECTED R-1 DOOR HANDLE AND FOUND LOSE INTERIOR HANDLE HUB. SECURED HANDLE HUB PER AMM 52-41-11.SDR AALA202206218459Probe · unserviceableAIRCRAFT WAS GROUNDED: #1 ENGINE EGT OVERTEMP ON TAKEOFF. EMERGENCY DECLARED, FLIGHT RETURNED TO DFW, LANDING SAFELY. REPLACED #1 ENGINE T49.553 PROBE PER AMM 77-21-01. ACCOMPLISHED SATISFACTORY POWER ASSURANCE RUN PER JOB CARD 08L40072006,SDR AALA202206206697Bracket · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR SLIDE/GIRT BAR BRACKET LOOSE. RE-SECURED SLIDE GIRT BAR IN RETAINER CLIPS PER AMM 25-66-01.SDR AALA202206201066Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT SEAT 12C FELL OFF. SECURED EMERGENCY LIGHT AT 12C PER AMM 33-51-11.SDR AALA202206215726Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 16A AND 17F EXIT LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202206200125Door · stickingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY ENTRY DOOR IS DIFFICULT TO OPEN/CLOSE. ADJUSTED AFT LAVATORY DOOR PER CMM 25-40-64.SDR AALA202206299422Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN RIGHT HAND AFT ENTRY DOOR FLOOR BOARD SUPPORT, AROUND DRAIN FITTING, LOCATED FROM BS 947 TO BS 967 AND LBL 52. REPLACED FLOOR BOARD SUPPORT PER AARD 51-00-05 AND DWG 147A5660.SDR AALA202206235605Skin Panel · damagedAIRCRAFT IN BASE MAINTENANCE: FUSELAGE SKIN DAMAGED AT BS 270 FROM S12L TO S13L. REPAIRED PER EA 336786.SDR AALA202206200180Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D LATCH STUCK. CLEANED AND LUBED LAVATORY D DOOR LATCH, REFERENCE STANDARD PRACTICES. OPERATIONS CHECK GOOD.SDR AALA202206203439Switch · warning lightAIRCRAFT WAS GROUNDED: ON TAKE-OFF TAKE-OFF CONFIG LIGHT AS WELL AS PROXIMITY SENSOR ELECTRONIC UNIT LIGHT. REJECTED BELOW 60 KNOTS. TROUBLE SHOT FOUND MESSAGE 27-62001. ACCOMPLISHED FIM TASK 27-62-00-810-808. REPLACED SPEED BRAKE TAKE OFF WARNING SWITCH PER ASDR AALA202206289906Skin · damagedAIRCRAFT IN BASE MAINTENANCE: L1 PASSENGER DOOR UPPER AFT CORNER OF EXTERIOR SKIN HAS AN AREA OF DAMAGE APPROXIMATELY 1.0 INCH 0.5 INCH. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202206237138Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK IN UPPER RADIUS OF CAPTAINS WINDOW POST. LOCATED AT STA 224.8 AND LEFT BUTT LINE 36. REPAIRED WITH DOUBLER PER EO 5319J023-007.SDR AALA202206235193Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: DOUBLER/TRIPLER INSTALLATION REQUIRED AT CAPTAINS NUMBER 1 WINDOW. LOCATED AT STA 205-220 AND WATER LINE 250. INSTALLED REINFORCING MODIFICATION. PER ECO 5616J009-007.SDR AALA202206230274Web · crackedAIRCRAFT IN BASE MAINTENANCE: WING CENTER SECTION REAR SPAR WEB CRACKED STA 663.75 LEFT BUTT LINE 30-40. PERFORMED BONDED REPAIR PER SRM 57-10-10-2R.SDR AALA202206201856Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY INOPERATIVE. REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202206207523Window · scratchedAIRCRAFT WAS GROUNDED: FIRST OFFICER FORWARD WINDOW NUMBER 1. NOTED SCRATCH NEAR CENTER AND LOWER RIGHT SIDE REFERENCE AMM 56-11-00-200-803. REMOVED AND REPLACED FIRST OFFICERS FORWARD WINDOW NUMBER 1.SDR AALA202206176440Control Unit · fault messageAIRCRAFT WAS GROUNDED: AIR RETURNED TO MIA ACCOUNT GENERATOR ISSUE/STANDBY POWER LIGHT ILLUMINATED MESSAGE. EMERGENCY WAS DECLARED. FLIGHT WAS OVERWEIGHT FOR LANDING. ACCOMPLISHED FIN CHECKS IAW 24-34-00. REPLACED STANDBY POWER CONTROL UNIT PER AMM 24-34-11.SDR AALA202206233461Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FIRST OFFICER'S #1 WINDOW FRAME LOCATED BETWEEN BS 205 AND BS 200 AND WL 250. REPAIRED PER ECO 5616J009-008.SDR AALA202206239940Pressure Web · crackedAIRCRAFT IN BASE MAINTENANCE: WING CENTER SECTION REAR SPAR PRESSURE DECK WEB CRACKED LOCATED AT STA 663.75 BETWEEN RBL10 AND RBL 15. REPAIRED WING CENTER SECTION REAR SPAR WEB PER SRM 57-10-10-2R REP 2 AND SRM 51-70-04-2R REP 10.SDR AALA202206239589Pressure Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER BOX SECTION REAR SPAR VERTICAL PRESSURE DECK WEB LOCATED AT BS 663.75 AND RBL 45. REPAIRED WEB PER SRM 57-10-10-2R-3.SDR AALA202206177863Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE INDICATION LIGHT WITH ORAL WARNING AFT LEFT LAVATORY NO SMOKE OR FIRE DETECTIVE BY FLIGHT ATTENDANT. OPERATIONS CHECKED AFT/LEFT LAVATORY SMOKE DETECTOR PER B737 AMM 26-14-00-710-802. NO FAULT FOUND.SDR AALA202206173671Control Panel · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206177808Control Panel · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206171683Control Panel · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206173307Control Panel · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206173286Control Panel · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206170923Control Panel · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206175590Smoke Detector · unserviceableAIRCRAFT WAS GROUNDED: CARGO FIRE LOOP TEST DOES NOT TEST PROPERLY. REPLACED AFT CARGO, CARGO ELECTRONIC UNIT (AALA202206161683), SMOKE DETECTORS A1 (AALA202206160923), A2 (AALA202206165590), B2 (AALA202206163307) AND FORWARD CARGO SMOKE DETECTORS A1 (AALA2022SDR AALA202206163344Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. RE-LAMPED LIGHT. OPERATIONAL CHECK GOOD PER AMM 33-51-04.SDR AALA202206168355Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 EXTERIOR EMERGENCY LIGHT INOPERATIVE. RE-LAMPED LIGHT. OPERATIONAL CHECK GOOD PER AMM 33-51-04.SDR AALA202206286943Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: 10 INCHES BY 1 INCH CORRODED AREA 1016 BULKHEAD BOTTOM LEFT SIDE AREA OF DIAPHRAGM RETAINER. LOCATED AT STA 1016 AND LEFT BUTT LINE 62 CORROSION OUT OF LIMITS. REMOVED AND REPLACED WITH FABRICATION PER BOEING DRAWING 65-54862.SDR AALA202206167100Guide Arm · unserviceableAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO CLOSE. REPLACED L1 DOOR GUIDE ARM PER AMM 52-11-21. ADJUSTED DOOR PER AMM 52-11-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202206234842Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY SMOKE DETECTOR AURAL ALERT NO SMELL OF CIGARETTE SMOKE OR VAPING. NO EVIDENCE OF CIGARETTE OR VAPING.**SUPPLEMENTAL REPORT FOR AALA202206164842: COMPLIED WITH AFT RIGHT HAND LAVATORY SMOKE DETECTOR TEST PER AMM 26-SDR AALA202206206643Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER RIB CRACKED, LOCATED AT STABILIZER STA 92.70, THIRD STIFFENER FROM THE FRONT SPAR. REPLACED RIB PER AARD 55-10-00-2 AND DRAWING 182A5301.SDR AALA202206146912Hinge · stickingAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR DIFFICULT TO OPERATE - STICKS AT BOTTOM. REMOVED AND REPLACED FIRST CLASS LAVATORY DOOR HINGE, PER CMM/AMM 25-47-66 & 52-50-00.SDR AALA202206164643Landing Gear · false indicationAIRCRAFT WAS GROUND: ON CLIMB OUT, GEAR LEVER WAS POSITIONED FROM UP TO OFF AND GEAR EXTENDED. LEVER WAS RETURNED TO UP, GEAR STOWED. FLIGHT DECLARED AN EMERGENCY AND RETURNED TO ORD LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202206134643: ACCOMPLISHED FIM SDR AALA202206140169Bracket · brokenAIRCRAFT WAS NOT GROUNDED: AT APPROXIMATELY 1500. FORWARD ENTRY DOOR LIGHT ILLUMINATED. FLIGHT ATTENDANT SAID DOOR HANDLE HAD MOVED UPWARD FROM FULL DOWN INFLIGHT. REMOVED AND REPLACED BROKEN SENSOR BRACKET PER AARD 51-00-05-1 ALSO ADJUSTED SWITCH TO WITHIN LISDR AALA202206134643None · noneAIRCRAFT WAS GROUND: ON CLIMB OUT, GEAR LEVER WAS POSITIONED FROM UP TO OFF AND GEAR EXTENDED. LEVER WAS RETURNED TO UP, GEAR STOWED. FLIGHT DECLARED AN EMERGENCY AND RETURNED TO ORD LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)
Back to Boeing 737-823