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 AALA201901049005Autopilot Sys · inoperativeFLIGHT DIRECTOR INOPERATIVE. EMERGENCY DECLARED AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE RAN A BITE TEST ON THE AUTOPILOT SYSTEM, FOUND THE NR 2 AUTOPILOT INOPERATIVE AND REPLACED.SDR AALA201901049018Lens · missingLENS AND HARDWARE WERE MISSING, EXPOSING WIRES BETWEEN THE RIGHT OVERWING EMERGENCY EXIT DOORS. MAINTENANCE REPLACED THE LENS AND HARDWARE IAW AMM 33-20-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901039014Not Reported · malfunctionedAIRCRAFT WAS GROUNDED: ON APPROACH FLAPS WOULD NOT EXTEND BEYOND 15 DEGREES WHEN FLAP HANDLE WAS MOVED TO 25 DEGREES. RETRACTED FLAG HANDLE TO 15 DEGREES POSITION AND LANDED WITH SELECTED FLAPS. EMERGENCY DECLARED, FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTSDR AALA201901029014Flap System · malfunctionedON APPROACH, THE FLAPS WOULD NOT EXTEND BEYOND 15 WHEN THE FLAP HANDLE WAS MOVED TO 25. RETURNED FLAP HANDLE 15 POSITION, AN EMERGENCY DECLARED AND DIVERTED, LANDED WITH SELECTED FLAPS WITHOUT FUTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE PERFORSDR AALA201901039012Pitot Head · inoperativeAIRCRAFT WAS GROUNDED: AIRSPEED INDICATION ISSUE. EMERGENCY DECLARED, FLIGHT LANDED OVERWEIGHT WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND AUXILIARY PITOT HEAD INOPERABLE AND REPLACED AUXILIARY PITOT TUBE PER AMM 34-11-01 AND PERFORMED SATISFACTORY OPERATIONALSDR AALA201901039001Oven · smokeAIRCRAFT WAS NOT GROUNDED: OVEN SMOKES AND HAS BAD ODOR WHEN IN USE, COULD NOT USE. MAINTENANCE REPLACED NR 1 OVEN IN FIRST CLASS PER MM 25-32-02 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901029037Lens · detachedEXIT SIGN LENS, LEFT FORWARD OVERWING CAME OFF. REPLACED THE LT OVERWING EXIT SIGN LENS.SDR AALA201901029036Light · inoperativeEMERGENCY EXIT LIGHT AT THE LEFT AFT DOOR WAS INOPERATIVE. MAINTENANCE REPAIRED THE LIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA201901029009Pitot Tube · inoperativeISFD AIRSPEED UNRELIABLE. AIRSPEED WENT FROM 300KTS TO 50 KTS, RETURNED TO NORMAL LATE IN APPROACH. AIRSPEED UNRELIABLE AT 17000 AND CONTINUED UNTIL 2500. EMERGENCY DECLARED AND FLIGHT LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCESDR AALA201901021002Sign · brokenEXIT SIGN OVER THE AFT DOOR WAS BROKEN. MAINTENANCE REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201901039011Slide · out of positionAIRCRAFT WAS GROUNDED: FORWARD GALLEY DOOR SLIDE PARTIALLY OUT OF HOLDER WHEN DOOR OPENED. MAINTENANCE REPLACED R1 DOOR SLIDE PACK PER MCM 25-94-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901039010Pitot Tube · defectiveAIRCRAFT WAS GROUNDED: FIRST OFFICER INSTRUMENT CLUSTER UNRELIABLE. EMERGENCY DECLARED INTO DFW. FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED PITOT TUBE PER AMM 34-11-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901029005Pitot Tube · defectiveAIRSPEED UNRELIABLE, FIRST OFFICER`S SIDE IN ICEING CONDITIONS. AIRSPEED OFF BY 150 KTS, ALTITUDE OFF 1800. THE AIRCRAFT WAS GROUNDED. FOUND FIRST OFFICER`S PITOT TUBE NOT HEATING. REPLACED FOS PITOT TUBE IAW AMM 34-11-01, CHECKED OK, LEAK CHECKED OK IAW AMSDR AALA201901029032Smoke Detector · false activationSMOKE DETECTOR ALARMED FOR 15 SECONDS IN THE L4 LAVATORY, ODOR OF SMOKE DETECTED BY FLIGHT ATTENDANT AND DEAD HEADING PILOT. ONLY HAPPENED THE ONE TIME. SOURCE NOT FOUND. OPS CHECK OF THE LAVATORY SMOKE DETECTOR IAW AMM 26-14-00. NO SMOKE NOTED FROM THE WATESDR AALA201901029038Sign · detachedMID CABIN EXIT SIGN ON THE OVERHEAD FELL OFF. MAINTENANCE ATTACHED THE SIGN AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201901029034Slide · out of positionTHE R4 DOOR SLIDE WAS COMING OUT OF THE CONTAINER. MAINTENANCE INSPECTED THE SLIDE AND RESTOWED IAW MM 25-66-01, REFERENCE GPM 18.01-2 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901029006Slide · dislodgedFORWARD GALLEY DOOR SLIDE PARTIALLY OUT OF THE HOLDER WHEN DOOR WAS OPENED. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE R1 DOOR SLIDE IAW MCM 25-94-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201901021001Light · looseEMERGENCY LIGHT AT THE LEFT AFT DOOR WAS INOPERATIVE WAS LOOSE. MAINTENANCE REPAIRED THE LIGHT, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA2019010228002Switch · faultedTAKE OFF CONFIGURATION LIGHT ILLUMINATED AFTER THE POWER WAS ADVANCED TO TAKEOFF POWER. REJECTED TAKEOFF, THE AIRCRAFT WAS CONFIGURED PROPERLY. TRIM IN GREEN TAKEOFF BAN, FLAPS AT 01 DEGREES. BRAKES OFF, SPEED BRAKE LEVER STOWED, AT ARM. THE AIRCRAFT WAS SDR AALA201812287002Circuit Board · burnedODOR OF OVERHEATED MOTOR EMITTED FROM PRINTER IN THE COCKPIT. THE AIRCRAFT WAS GROUNDED. NO ONE IN CABIN REPORTED THE ODOR. REPLACED PRINTER IAW AMM 31-33-01 AND ACCOMPLISHED SMOKE ODOR FUMES INITIAL TROUBLESHOOTING SIC 05-96-70.SDR AALA201812287003Fuse · failedEMERGENCY EXIT LIGHTS IN THE FIRST CLASS SECTION, DOES NOT COME ON. REPLACED THE FUSES IN THE BATTERY PACK.SDR AALA201812289007Light · inoperativeLEFT AFT EMERGENCY LIGHT ASSEMBLY WAS INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-51-01. FUNCTIONAL CHECKED NORMAL.SDR AALA2018122769019Shaft · failedTHE L2 DOOR HANDLE ON THE EXTERIOR, UNLOCKED AFTER TAKEOFF. THE FLIGHT DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE. LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE L2 DOOR EXTERIOR DOOR HANDLE SHAFT ASSEMBLY IAW AMM 52-13-11. OSDR AALA201812269015Control Lever · defectiveGEAR WOULD NOT RETRACT AFTER TAKEOFF. CYCLED DOWN AND UP, NO HELP. THE FLIGHT DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE. LANDED WITHOUT FURTHER INCIDENT. REPLACED THE LANDING GEAR CONTROL LEVER IAW AMM 32-31-11 AND ACCOMPLISHED A SATISFACTORY OPERATISDR AALA201812279001Control Handle · defectiveGEAR WOULD NOT RETRACT AFTER TAKEOFF. CYCLED DOWN AND UP, NO HELP. REPLACED LANDING GEAR CONTROL LEVER IAW AMM 32-31-11. RETRACTED GEAR IAW FIM 32-30-00. OPS CHECKED NORMAL. THE AIRCRAFT WAS GROUNDED.SDR AALA201812274001Shaft · damagedL2 DOOR EXTERIOR HANDLE UNLOCKED AFTER TAKEOFF. THE AIRCRAFT REMOVED FROM SERVICE. REPLACED THE L2 EXTERIOR DOOR HANDLE SHAFT ASSEMBLY IAW AMM 52-13-11.SDR AALA201812269020Manifold · faultedFOLLOWING ALTERNATE GEAR EXTENSION CHECK IN FLIGHT, THE NOSE GEAR FAILED TO RETRACT USING THE L6TU. THE AIRCRAFT WAS GROUNDED. MAINTENANCE OBSERVER STATED BOTH THE MAIN GEAR RETRACTED NORMAL. REPLACED THE RETRACT ACTUATOR IAW AMM 32-33-11. OPS CHECKED NOSDR AALA201812269011Actuator · faultyFOLLOWING ALTERNATE GEAR EXTENSION CHECK IN FLIGHT, THE NOSE GEAR FAILED TO RETRACT USING THE L6TU. THE AIRCRAFT WAS GROUNDED. MAINTENANCE OBSERVER STATED BOTH THE MAIN GEAR RETRACTED NORMAL. REPLACED THE RETRACT ACTUATOR IAW AMM 32-33-11. OPS CHECKED NOSDR AALA201812269010Outlet · odorTRANSIENT METALLIC ODOR REPORTED IN THE CABIN, DISAPATED ON FIRST REPORT. NO ODOR IN THE COCKPIT. F/A REPORTED A WHINNING SOUND NEAR THE WINDOW EXITS. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED CARD 05-96-70. IDENTIFIED THE SOURCE AS A POWER PORT OVER E/E ROSDR AALA20181222003Anti-Ice Valve · failedDURING CLIMB, CAPTAIN REPORTED THE NR 2 ENGINE COWL ANTI ICE BLUE LIGHT ILLUMINATED, FOLLOWED BY A NR 2 ENGINE COWL ANTI ICE CIRCUIT BREAKER TRIPPED. THE AIRCRAFT WAS GROUNDED. MAINTENANCE R & R THE RIGHT ENGINE TAI VALVE IAW AMM 30-21-11. OPS CHECK GOOD. OKSDR AALA2018122649006Relay · faultedAFTER TAKEOFF, THE PILOT REPORTED A RUNAWAY STABILIZER TRIM CONDITION. AN EMERGENCY WAS DECLARED, RETURNED TO DEPARTURE, AND LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE ELECTRIC TRIM RELAY R-64. OPS CHECKED IAW AMM 22-11-81.SDR AALA201812262002Trim Motor · malfunctionedAFTER TAKEOFF, THE PILOT REPORTED A RUNAWAY STABILIZER TRIM CONDITION. AN EMERGENCY WAS DECLARED AND RETURNED TO DEPARTURE, LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE STAB TRIM MOTOR IAW AMM 27-41-71. OPS CHECKED IAW AMM 22-11-81.SDR AALA201812242001Engine · failedNR 1 ENGINE SURGED. FLIGHT ATTENDANTS AND PASSENGERS REPORT FLAMES COMING OUT OF THE EXHAUST. AIRCRAFT SHOOK SEVERAL TIMES. ENGINE LOST POWER. FLIGHT CREW SET ENGINE TO IDLE AND SURGE STOPPED, LANDED WITH ONE ENGINE. THE AIRCRAFT WAS GROUNDED.SDR AALA2018122649003Controller · faultedWHILE ON THE GROUND, FOUND THE FIRST OFFICIER`S SLIDING WINDOW CRACKED. REPLACED THE WINDOW HEAT CONTROLLER M320 IAW AMM 30-41-11. OPS CHECKED NORMAL.SDR AALA2018122649001Relay · failedA TRIM RUNAWAY DURING CLIMB, TURNED OFF BOTH STABALIZER TRIMS FOR THE REMAINDER OF THE FLIGHT. DECLARED EMERGENCY INBOUND TO DESTINATION. LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE STABILIZER TRIM CUTOUT RELAY R384 IAW AMM 20-81-22. PSDR AALA201812281005Threshold · corrodedFORWARD CARGO DOOR HAS CORROSION ON THETHRESHOLD, BS 440 - 490. REPLACED THE THRESHOLD IAW SRM 51-40-02.SDR AALA201812281001Support Angle · corrodedCORROSION FOUND ON THE LOWER SUPPORT ANGLE FOR THE AFT BULKHEAD, BS 500I, IN THE FORWARD CARGO. REPLACED THE LOWER SUPPORT ANGLE IAW 51-40-02.SDR AALA2018122649002Window · distortedCAPTAIN`S L-1 WINDOW HAD A WAVY DISTORTION IN THE MID-REGION. REPLACED THE WINDOW IAW MCM 2711.SDR AALA201812210002Fuse · failedTHE LOWER RIGHT FUSELAGE SLIDE LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED FUSE ON THE BATTERY PACK M1671, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA20181220006Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO, RIGHT TRANSITION PANEL, BS 869. REPLACED THE TRANSITION PANEL IAW RD 51-00-05-01, AND DRAWING 147A7500.SDR AALA20181220004Baffle · damagedRIGHT BAFFLE FROM BS 500G TO 500H HAD HOLES OUT OF ROUND. REPLACED THE BAFFLE IAW RD 51-00-05-7, AND DRAWING 143A7505.SDR AALA2018122019003Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO, LEFT TRANSITION PANEL, BS 400 TO 500I. REPLACED THE TRANSITION PANEL ASSEMBLY IAW SRM 53-00-53-2R-6.SDR AALA2018122019002Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO, LEFT TRANSITION PANEL, BS 767 TO 787. REPLACED THE TRANSITION PANEL ASSEMBLY IAW SRM 53-00-53-2R-5.SDR AALA2018122109005Unknown · odorDURING CLIMB, AND DESCENT, A WET MOP OR SOCK ODOR, NOT NOTICE IN THE CABIN. THE AIRCRAFT WAS GROUNDED. PERFORMED TC 05-96-70. NO ODOR DETECTED THROUGH OUT CABIN AND COCKPIT WITH LEFT ENGINE BLEED, RIGHT ENGINE BLEED, OR APU BLEED. ENGINE BLEED AT 40% N1 TSDR AALA201812249004Girt Bar · detachedTHE R1 DOOR GIRT BAR WAS HANGING LOOSE. ATTACHED THE GIRT BAR. OPS CHECKED GOOD.SDR AALA201812209018Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY SMOKE DETECTOR ACTIVATED WITH NO ASSOCIATED SMOKE. MAINTENANCE ACCOMPLISHED OPERATIONAL TEST OF RIGHT AFT LAVATORY SMOKE DETECTOR PER AMM 26-14-00. NO FAULTS NOTED AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201812209021Battery · dischargedFLASHLIGHTS ON FWD AND AFT JUMP SEAT LOW ON POWER. REPLACED THE BATTERY IAW AMM 25-64-00. OK FOR SERVICE.SDR AALA201812209020Battery · dischargedFLASHLIGHTS ON FWD AND AFT JUMP SEAT LOW ON POWER. REPLACED THE BATTERY IAW AMM 25-64-00. OK FOR SERVICE.SDR AALA201812209006Sliding Window · bindingFIRST OFFICIER`S SLIDING WINDOW WAS DIFFICULT TO OPEN AND CLOSE. THE AIRCRAFT WAS GROUNDED. REPLACED THE WINDOW IAW CARD 56-94-02.SDR AALA20181218006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO, RIGHT HAND TRANSITION PANEL FROM BS 847 TO BS 867. REPLACED TRANSITION PANEL PER DRAWING 143A0080 AND 51-00-05-01.
Back to Boeing 737-823