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 AALA202110122697Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE IS BROKEN. TIGHTENED DOOR HANDLE, OPERATIONS CHECK GOOD PER AMM 52-00-00.SDR AALA202110144654Computer · faultyAIRCRAFT WAS GROUNDED: DURING FINAL APPROACH WITH FLAPS 40, MULTIPLE UNCOMMANDED RH WING BANK. REPLACED FLIGHT CONTROL COMPUTER B WITH SERVICEABLE UNIT IAW AMM 22-11-33, OPS CHECK GOOD.SDR AALA202110113744Housing · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGED EMERGENCY EXIT LIGHT HOUSING AT 1R DOOR. REPLACED HOUSING WITH NEW IAW AMM 33-25-00, OPS CHECK GOOD.SDR AALA202110125804Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE INDICATION QRH RAN. NO CONFORMATION. CHECKED ALL LAVATORY SMOKE DETECTORS PER AMM 26-14-00. NO FAULTS.SDR AALA202110121049None · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT DOOR SLIDE MATERIAL CONNECTED TO GIRT BAR ATTACHMENT SEEMS LOOSE. RE-ATTACHED VELCRO STRIP ON THE BACKING PAN SHELF PER AMM 25-66-01.SDR AALA202110117142Light · looseAIRCRAFT WAS NOT GROUNDED: SEAT 10C ESCAPE LIGHTING LOOSE. REATTACHED LIGHT ASSEMBLY PER AMM 33-52-1-11.SDR AALA202110116304Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: MOMENTARY, RIGHT AFT LAVATORY SMOKE WARNING, NO SMOKE CONFIRMED BY FLIGHT ATTENDANT. COMPLIED WITH FUNCTIONAL TEST OF THE RIGHT AFT LAVATORY PER AMM 26-14-00. CHECKS GOOD.SDR AALA202110110108Latch Handle · looseAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR HANDLE LOOSE. SECURED HANDLE.SDR AALA202110184323Door · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR STUCK CLOSED, DOOR FORCED OPEN TO FREE TRAPPED PASSENGER. DOOR NOW DOES NOT CLOSE. **SUPPLEMENTAL REPORT: CHECKED DOOR PER CMM 25-40-64. OPERATIONS CHECK GOOD.** (CLOSED)SDR AALA202110124323None · noneAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR STUCK CLOSED, DOOR FORCED OPEN TO FREE TRAPPED PASSENGER. DOOR NOW DOES NOT CLOSE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202110118266Door · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN OR CLOSE. CLEANED AND LUBED FLIGHT DECK DOOR CHECKS OK.SDR AALA202110119067Housing · out of positionAIRCRAFT WAS NOT GROUNDED: PLASTIC COVER FOUND ON FLOOR AT SEAT 27. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING AT 27C PER AMM 33-51-11.SDR AALA202110113050Smoke Detector · noneAIRCRAFT WAS GROUNDED: LAVATORY SMOKE INDICATIONS PREFORMED QUICK REFERENCE HANDBOOK PROCEDURE FLIGHT ATTENDANTS FOUND NOTHING. INSPECTED AND PERFORMED LAVATORY SMOKE DETECTOR OPERATIONAL TEST ON ALL 3 LAVATORIES PER AMM 26-14-00. NO DEFECTS NOTED AND OPERATIOSDR AALA202110110273Transmitter · inoperativeAIRCRAFT WAS GROUNDED: WHILE CONFIGURING FOR LANDING FLAPS SPLIT, THEN STUCK AT LESS THEN 1 DEGREE. CHECKLIST FOLLOWED NO FLAP LOG . ACCOMPLISHED AT 138K POUNDS LANDING WEIGHT REFERENCE SPEED OF 178 KNOTS. BRAKE TEMPERATURE REACHED 700 (LEFT) AND 600 (RIGHT) FSDR AALA202110114799Switch · defectiveAIRCRAFT WAS GROUNDED: TAKEOFF CONFIGURATION WARNING HORN ON TAKEOFF ROLL. TAKEOFF REJECTED LOW SPEED LESS THAN 10 KNOTS. TROUBLE SHOT AND FOUND SPEEDBRAKE TAKEOFF WARNING SWITCH DEFECTIVE. REPLACED SWITCH S651 PER AMM 31-51-03.SDR AALA202110111832Roller · out of positionAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR CAME OFF OF IT'S TRACK. REINSTALLED UPPER ROLLER ON AFT LEFT LAVATORY DOOR AND ADJUSTED LUBRICATED OK FOR SERVICE PER AMM 25-40-00.SDR AALA202110117039Lens · inoperativeAIRCRAFT WAS NOT GROUNDED: MID CABIN CEILING EXIT LIGHT MISSING COVER ON AFT SIDE. INSTALLED OVERWING EMERGENCY EXIT LENS AMM 33-51-01.SDR AALA202110111015Latch · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR LATCH LOCK VERY DIFFICULT TO OPERATE. LUBED LAVATORY DOOR LATCH LOCK OPERATIONS CHECKS NORMAL.SDR AALA202110111469Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY HANDLE LOOSE. SECURED FORWARD LAVATORY DOOR HANDLE OPERATIONS CHECK GOOD PER AMM 52-50-00.SDR AALA202110118169Probe · faultyAIRCRAFT WAS GROUNDED: EGT INCREASED RAPIDLY INTO AMBER RANGE ON RH ENGINE DURING CLIMB, CREW THROTTLED BACK TO AVOID REDLINE; FLIGHT DECLARED EMERGENCY AND DIVERTED TO LAS. REPLACED S1, S2, S3, AND S4 EGT PROBES (AALA202110113172, AALA202110112201, AALA202110SDR AALA202110113172Probe · faultyAIRCRAFT WAS GROUNDED: EGT INCREASED RAPIDLY INTO AMBER RANGE ON RH ENGINE DURING CLIMB, CREW THROTTLED BACK TO AVOID REDLINE; FLIGHT DECLARED EMERGENCY AND DIVERTED TO LAS. REPLACED S1, S2, S3, AND S4 EGT PROBES (AALA202110118169, AALA202110112201, AALA202110SDR AALA202110112201Probe · faultyAIRCRAFT WAS GROUNDED: EGT INCREASED RAPIDLY INTO AMBER RANGE ON RH ENGINE DURING CLIMB, CREW THROTTLED BACK TO AVOID REDLINE; FLIGHT DECLARED EMERGENCY AND DIVERTED TO LAS. REPLACED S1, S2, S3, AND S4 EGT PROBES (AALA202110113172, AALA202110118169, AALA202110SDR AALA202110119569Probe · faultyAIRCRAFT WAS GROUNDED: EGT INCREASED RAPIDLY INTO AMBER RANGE ON RH ENGINE DURING CLIMB, CREW THROTTLED BACK TO AVOID REDLINE; FLIGHT DECLARED EMERGENCY AND DIVERTED TO LAS. REPLACED S1, S2, S3, AND S4 EGT PROBES (AALA202110113172, AALA202110118169, AALA202110SDR AALA202110110927Hose · damagedAIRCRAFT WAS GROUNDED: LOSS OF HYDRAULIC SYSTEM A PRESSURE AND QUANTITY, FLIGHT DECLARED EMERGENCY; AFTER LANDING, HYDRAULIC SYSTEM B AT 40% QTY AND AIRCRAFT LOST NOSE WHEEL STEERING. REPLACED HYDRAULIC HOSE FOR RH MLG RETRACTION ACTUATOR WITH NEW IAW AMM 32-3SDR AALA202110082601Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING SECTION KEEL BEAM LOCATED AT BS 663 AND LBL 40 TO LBL 45. REPAIRED PER SRM 57-10-10-2R-3.SDR AALA202110089032Bracket · unsecureAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR, RIGHT SIDE BRACKET WHICH HOLDS SLIDE IN DISARMED POSITION IS NOT SECURE, THUS NOT SECURELY HOLDING SLIDE WHEN DISARMED. SECURED BRACKET AT R2 DOOR.SDR AALA202110080753Slider · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LATCH BROKEN. FREED STUCK LEFT AFT LAVATORY DOOR LOCK SLIDER.SDR AALA202110085194Oven · odorAIRCRAFT WAS GROUNDED: FIRST CLASS OVEN NUMBER 2 HAS A STRONG ODOR INSIDE OVEN. REMOVED AND REPLACED FORWARD GALLEY NUMBER 2 OVEN PER AMM 25-32-03.SDR AALA202110123502Plate · wornAIRCRAFT WAS NOT GROUNDED: L1 FORWARD ENTRY DOOR AFT EDGE PROXIMITY SWITCH STRIKE PLATE IS WORN. **SUPPLEMENTAL REPORT FOR AALA202110083502: REMOVED AND REPLACED PER B737 SRM 51-40-02.** (CLOSED)SDR AALA202110084811Door · out of rigAIRCRAFT WAS GROUNDED: 1L DOOR HANDLE WILL NOT STAY DOWN WHEN AIRCRAFT PRESSURIZES. RE-RIGGED 1L DOOR IAW AMM 52-11-91 AND AMM 52-11-00, OPS CHECK GOOD.SDR AALA202110083502None · noneAIRCRAFT WAS NOT GROUNDED: L1 FORWARD ENTRY DOOR AFT EDGE PROXIMITY SWITCH STRIKE PLATE IS WORN.**SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202110080847Wire · damagedAIRCRAFT WAS GROUNDED: SEAT MOUNTED EXIT LIGHTS INOPERATIVE AT ROWS 15-17. REPAIRED WIRE AT SEAT 16ABC IAW SDM 33-51-00, OPS CHECK GOOD.SDR AALA202110082326Cover · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT TRIM DAMAGED AT SEAT 16C. REPLACED LIGHT COVER WITH NEW, OPS CHECK GOOD.SDR AALA202110081940None · noneAIRCRAFT WAS NOT GROUNDED: R2 WINDOW HAS BURN MARK IN LOWER RH CORNER. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202110069804Light · detachedAIRCRAFT WAS NOT GROUNDED OVERWING EMERGENCY EXIT LIGHT PLASTIC AT SEAT 16F FELL OFF. REPLACED LIGHT PER AMM 33-51-01.SDR AALA202110061338Slide · bindingAIRCRAFT WAS NOT GROUNDED: DOOR 1R SLIDE DIFFICULT TO ARM. TIGHTENED HOUSING PER 25-66-00.SDR AALA202110064826Fastener · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND LAVATORY DOOR HARD TO OPEN AND CLOSE, ALSO WILL NOT LOCK. RE-TORQUED LOOSE FASTENERS AT UPPER DOOR TRACK PER AMM 25-40-00.SDR AALA202110068738Light · inoperativeAIRCRAFT WAS GROUNDED: ROW 29 EMERGENCY EXIT LIGHT COVER IS DETACHED AND HANGING DOWN. INSTALLED SERVICEABLE EMERGENCY LIGHT ASSEMBLY AT PASSENGER SEAT ROW 29.SDR AALA202110066472Handle · looseAIRCRAFT WAS NOT GROUNDED: INSIDE HANDLE OF FORWARD LAVATORY DOOR IS LOOSE. TIGHTENED HANDLE OF FORWARD LAVATORY DOOR.SDR AALA202110069636Outflow Valve · inoperativeAIRCRAFT WAS GROUNDED: DURING CRUISE CABIN ALTITUDE BEGAN TO CLIMB AND COULD NOT BE CONTROLLED IN AUTO. INITIATED EMERGENCY DESCENT AND FOLLOWED QUICK REFERENCE HANDBOOK PROCEDURES FOR RAPID DEPRESSURIZATION. CABIN OXYGEN MASKS MANUALLY DEPLOYED. REMOVED AND RSDR AALA202110063947Control Unit · inoperativeAIRCRAFT WAS GROUNDED: DURING CRUISE CABIN ALTITUDE BEGAN TO CLIMB AND COULD NOT BE CONTROLLED IN AUTO. INITIATED EMERGENCY DESCENT AND FOLLOWED QUICK REFERENCE HANDBOOK PROCEDURES FOR RAPID DEPRESSURIZATION. CABIN OXYGEN MASKS MANUALLY DEPLOYED. REMOVED AND RSDR AALA202110063377Control Unit · inoperativeAIRCRAFT WAS GROUNDED: DURING CRUISE CABIN ALTITUDE BEGAN TO CLIMB AND COULD NOT BE CONTROLLED IN AUTO. INITIATED EMERGENCY DESCENT AND FOLLOWED QUICK REFERENCE HANDBOOK PROCEDURES FOR RAPID DEPRESSURIZATION. CABIN OXYGEN MASKS MANUALLY DEPLOYED. REMOVED AND RSDR AALA202110058684Latch · stickingAIRCRAFT WAS NOT GROUNDED: THE FORWARD LAVATORY DOOR HANDLE STICKS IN THE UP POSITION. CLEANED DEBRIS AND LUBED DOOR LATCH PER AMM 20-30-21.SDR AALA202110053672Spring · unsecureAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICERS ESCAPE DOOR HANDLE SPRING INSECURE. SECURED SPRING FOR ESCAPE DOOR HANDLE PER SRM 51-40-02.SDR AALA202110040691Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FWD LAVATORY SMOKE LIGHT ILLUMINATED AT CRUISE FOR APPROXIMATELY 60 SECONDS, THEN EXTINGUISHED; NO SMOKE OR DETECTOR TAMPERING PRESENT. ACCOMPLISHED A FUNCTIONAL TEST OF THE SMOKE DETECTOR IAW AMM 26-14-00, OPS CHECK GOOD.SDR AALA202110044075Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: DOOR 1L SLIDE BRACKET IS VERY LOOSE. SECURED GIRT BAR PER 25-66-02.SDR AALA202110152786Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT LOOSE AT SEAT 10C FLOOR. **SUPPLEMENTAL REPORT: SECURED EMERGENCY LIGHT IAW AMM 25-21-00, OPS CHECK GOOD.** (CLOSED)SDR AALA202110062786None · noneAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT LOOSE AT SEAT 10C FLOOR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202110064017Transceiver · failedAIRCRAFT WAS GROUNDED: WEATHER RADAR FAILED AFTER TAKEOFF, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED WEATHER RADAR TRANSCEIVER IAW AMM 34-43-41 AND BLOWER ASSEMBLY (AALA202110060009) IAW AMM 34-43-51 WITH SERVICEABLE UNITS, OPS CHECK GOOD.SDR AALA202110060009Blower · damagedAIRCRAFT WAS GROUNDED: WEATHER RADAR FAILED AFTER TAKEOFF, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED WEATHER RADAR TRANSCEIVER (AALA202110064017) IAW AMM 34-43-41 AND BLOWER ASSEMBLY IAW AMM 34-43-51 WITH SERVICEABLE UNITS, OPS CHECK GOOD.
Back to Boeing 737-823