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 AALA202009019016Sensor · inoperativeAIRCRAFT WAS GROUNDED: L1 DOOR UNLOCK INDICATION ON APPROACH, REPEAT ITEM. REPLACED DOOR SENSOR WITH NEW AND ADJUSTED GUIDE ARM AND LATCH IAW AMM 52-11-00, OPS CHECK GOOD.SDR AALA202009119013Sensor · unserviceableAIRCRAFT GROUNDED, AT FL370 IN CRUISE IAS DISAGREE: AIRSPEED ON CAPTAIN`S SIDE DECREASED TO 120KTS, F/O`S WAS IN RED BAND; CAPTAIN`S ALTITUDE BEGAN CLIMB, F/O`S BEGAN DESCENT (STBY A/S AND ALT INDICATED NORMAL AT ALL TIMES). RAN QRC AND QRH PROCEDURE. AN EMESDR AALA202009119009Display · unserviceableAIRCRAFT GROUNDED, AT FL370 IN CRUISE IAS DISAGREE: AIRSPEED ON CAPTAIN`S SIDE DECREASED TO 120KTS, F/O`S WAS IN RED BAND; CAPTAIN`S ALTITUDE BEGAN CLIMB, F/O`S BEGAN DESCENT (STBY A/S AND ALT INDICATED NORMAL AT ALL TIMES). RAN QRC AND QRH PROCEDURE. AN EMESDR AALA202009119008Computer · malfunctionedAIRCRAFT GROUNDED, AT FL370 IN CRUISE IAS DISAGREE: AIRSPEED ON CAPTAIN`S SIDE DECREASED TO 120KTS, F/O`S WAS IN RED BAND; CAPTAIN`S ALTITUDE BEGAN CLIMB, F/O`S BEGAN DESCENT (STBY A/S AND ALT INDICATED NORMAL AT ALL TIMES). RAN QRC AND QRH PROCEDURE. AN EMESDR AALA202009019001Cover · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER MISSING. LEFT SIDE OVER WING SEAT 16A. INSTALLED COVER ON EMERGENCY EXIT LIGHT PER AMM 33-51-01.SDR AALA202008319007Indicator · malfunctionedAIRCRAFT GROUNDED, AT FL370 IN CRUISE IAS DISAGREE: AIRSPEED ON CAPTS DECREASED TO 120KTS, F/O WAS IN RED BAND, CAPTS ALTITUDE BEGAN CLIMB, F/O BEGAN DESCENT (STBY A/S AND ALT INDICATED NORMAL AT ALL TIMES). RAN QRC & QRH PROCEDURE. AN EMERGENCY WAS DECLAREDSDR AALA202009019002Lamp · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT NOT ARMED LITE, LOWER HALF BURNED OUT. REMOVED AND REPLACED EMERGENCY EXIT INDICATOR LIGHT LAMP PER AMM 33-18-00.SDR AALA202009019003Guide Arm · wornAIRCRAFT GROUNDED - L1 DOOR GUST LOCK PIN WILL NOT STAY IN DETENT. CLEANED PIN, TRACK AND DETENT, NO HELP. REMOVED AND REPLACED L1 DOOR GUST LOCK/GUIDE ARM PER AMM 52-11-00, DOOR ADJUSTMENTS GOOD.SDR AALA202008319010Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR PANEL BREAK ASSEMBLY AT STA 540 BETWEEN BL 0 AND BL 24R, MEASURING L=1.0 IN. REPLACED BREAK WITH NEW IAW AARD 51-00-05-1.SDR AALA202008319009Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR PANEL BREAK ASSEMBLY AT STA 540 BETWEEN BL 0 AND BL 24L, MEASURING L=1.0 IN. REPLACED BREAK WITH NEW IAW AARD 51-00-05-1.SDR AALA2020083199001Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT L1 DOOR OUT OF CHARGER (INBOARD). INSTALLED FLASHLIGHT WITH NEW BATTERY AT INBOARD FLIGHT ATTENDANT SEAT AT 1L DOOR PER AMM 25-64-00.SDR AALA202008309004Pump · failedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND CENTER BOOST PUMP LOW PRESSURE LIGHT ILLUMINATED WITH 4000 LBS FUEL IN CENTER TANK CONFIRMED FUEL PUMP FAILURE WITH FUEL IMBALANCE IN MAIN TANKS. REPLACED RT CENTER FUEL PUMP AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CSDR AALA2020083189024Actuator · defectiveAIRCRAFT WAS NOT GROUNDED: AT ALTITUDE WHEN AUTOPILOT A ENGAGED, AIRCRAFT C HAD A 2G PITCH UP FOLLOWED BY AUTOPILOT DISCONECT. AUTOPILOT B WORKED NORMAL. REPLACED HYDRAULIC AUTOPILOT AILERON CONTROL ACTUATOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PSDR AALA2020090109016Rib · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 0.750 INCH CRACK ON RIB ON RIGHT HAND HORIZONTAL STABILIZER AT STATION 92.70, 3RD STIFFENER FROM THE FRONT SPAR.. REMOVED AND REPLACED RIB PER SRM 55-10-09-2R-4.SDR AALA2020083189016Slide · detachedAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR WILL NOT DISARM WITHOUT EXCESSIVE FORCE. FOUND TAIL OF SLIDE ASSEMBLY DETACHED FROM VELCRO ON PACK RETENTION FLAP. RESECURED VELCRO OPS CK GOOD PER AMM 25-66-01.SDR AALA202008309007Target · out of adjustAIRCRAFT WAS GROUNDED: DURING APPROACH LEADING EDGE FLAPS TRANSIT YELLOW LIGHT ON WITH FLAPS EXTENDED TO 15 DEGREES #8 SLAT LIGHT YELLOW ON OVERHEAD AND PERFORMED A GO AROUND. FOUND #8 SLAT OUTBOARD SENSOR TARGET (S1008) OUT OF POSITION, READJUSTED TARGET ANDSDR AALA2020090190015Rib · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 0.750 INCH CRACK ON RIB ON LEFT HORIZONTABL STABILIZER STA 92.7 3RD STIFFENER BACK FROM THE FRONT SPAR. REMOVED AND REPLACED RIB PER SRM 55-10-09-2R-4.SDR AALA202008269001Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND INBOARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY FROM THE AFT LEFT HAND INBOARD FLIGHT ATTENDANT FLASHLIGHT INSTALLED TEMPER SHIELD OPERATIONS CHECK GOOD PER 25-64-00.SDR AALA202009099022Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL IN RH FWD CARGO COMPARTMENT BETWEEN STA 500B AND STA 500I AT RBL 26, MEASURING L=3.0 IN, W=2.0 IN, D=0.02 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 53-00-53-2R-5.SDR AALA202008319011Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF ANGLE STRUCTURE BENEATH SILL PLATE OF FWD SERVICE DOOR CUTOUT BETWEEN STA 308 AND STA 325 AT BL 58R, MEASURING L=0.5 IN, W=0.5 IN, D=0.014 IN. REPLACED ANGLE WITH NEW IAW AARD 51-00-05-1 AND EA308274.SDR AALA202008309008Computer · defectiveAIRCRAFT WAS GROUNDED: DURING A FUNCTIONAL CHECK FLIGHT; AUTOPILOT ENGAGEMENT BOTH CMD A AND CMD B HAD A PRONOUNCED AILERON DISPLACEMENT TO THE LEFT. CMD B ENGAGEMENT WAS SIGNIFICANTLY WORSE THAN CMD A.. REPLACED FLIGHT CONTROL COMPUTER B PER AMM 22-11-33-401SDR AALA202008259010Static Port · obstructedAIRCRAFT WAS GROUNDED: DURING CLIMBOUT AT APPROXIMATELY 500 MSL ALT DISAGREE DISPLAYED BOTH PFDS. ALT DISAGREED BY 350 - 400 BETWEEN CAPTAIN AND FIRST OFFICER. STANDBY AGREED WITH FIRST OFFICER ALT INDICATION. FOUND LT STATIC PORTS BLOCKED. OBSTRUCTION WAS SDR AALA202008259009Indicator · malfunctionedAIRCRAFT WAS GROUNDED: DURING CLIMBOUT, AT APPROX 4000 MSL, IAS DISAGREE MESSAGE DISPLAYED ON BOTH PFDS. IAS DIFFERED BY 6-8 KTS BETWEEN CAPTAIN AND FIRST OFFICER IAS. STANDBY IAS AGREED WITH FIRST OFFICER IAS. FOUND LT STATIC PORTS BLOCKED. OBSTRUCTION WASDR AALA202008259007Tat Probe · inoperativeAIRCRAFT WAS GROUNDED: ALTITUDE AND AIRSPEED DISAGREE MESSAGES AT FL380, BOTH SELF-CORRECTED ON DESCENT. REPLACED TOTAL AIR TEMPERATURE PROBE WITH NEW IAW AMM 34-21-06, OPS CHECK GOOD.SDR AALA2020082549006Light · looseAIRCRAFT WAS NOT GROUNDED: LOOSE EMERGENCY EXIT LIGHT ASSEMBLY AT SEAT 15C. REPLACED FASTENERS AND SECURED LIGHT ASSEMBLY IAW AMM 35-51-11, OPS CHECK GOOD.SDR AALA202008249007Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS OVERWING EXIT SIGNS ON RIGHT SIDE OF AIRCRAFT FLICKER OFF AND ON. REMOVED AND REPLACED BATTERY PACK ASSEMBLY FOR OVERWING SIGN IAW 33-51-06.SDR AALA202008249003Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT PATH LIGHTING IN FIRST CLASS OPPOSITE FIGHT ATTENDANT SUPPLY CLOSET IS INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPERATIONS CHECK OK PER AMM 33-51-00.SDR AALA2020082549009Ufi · inoperativeAIRCRAFT WAS GROUNDED: UNIVERSAL FAULT INTERRUPTER (UFI) NOT RESPONDING TO COMMANDS, CAUSING CTR FUEL TANK CONFIG MESSAGE AFTER TAKEOFF AND SUBSEQUENT AIR INTERRUPT. REPLACED UFI WITH NEW IAW AMM 28-22-99, OPS CHECK GOOD.SDR AALA2020082549012Fmc · failedAIRCRAFT WAS GROUNDED: SHORTLY AFTER REACHING CRUISE AT FL320 BOTH FMCS SUDDENLY AND SIMULTANEOUSLY FAILED, BOTH NAV DISPLAYS BLANKED,AND THE AUTOPILOT )A)) DEFAULTED TO CWS IN BOTH PITCH AND ROLL AFTER 30 SECONDS BOTH FMCS RETURNED TO NORMAL OPERATION. SDR AALA202008259015Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT TEST LIGHT INOPERATIVE. REMOVED AND REPLACE BOTH FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERIES.SDR AALA2020082549008Latch · out of adjustAIRCRAFT GROUNDED - L1 DOOR HARD TO CLOSE FROM INSIDE, NOT SEATING CORRECTLY. LUBED L1 DOOR, NO HELP. ADJUSTED UPPER AFT LATCH PLATE PER AMM 52-11-00, OPERATIONAL CHECK GOOD, OKAY FOR SERVICE.SDR AALA2020082439009Sign · damagedAIRCRAFT WAS NOT GROUNDED: AFT LEFT CABIN DOOR EXIT LIGHT COVER NOT ATTACHED. LIGHT LENS/COVER/BEZEL DAMAGED. REMOVED AND REPLACED AFT LEFT EXIT DOOR EXIT SIGN IAW WITH 33-51-01.SDR AALA2020082439030Bulkhead Web · crackedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER PREVIOUS REPAIR RE-CRACKED AT BS 663 AND THE 4TH BAY OUT-BOARD. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA202009039024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RT TRANSITION PANEL BETWEEN STA 767 AND STA 787 AT BL 26R, MEASURING L=1.0 IN, W=1.0 IN, D=0.007 IN. REPLACED TRANSITION PANEL WITH NEW, IAW AARD 51-00-05-1A.SDR AALA202009039023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL BETWEEN STA 727 AND STA 847 AT BL 18L, MEASURING L=0.5 IN, W=0.5 IN, D=0.033 IN. REPLACED TRANSITION PANEL WITH NEW, IAW AARD 51-00-05-1A.SDR AALA202008249010Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND FLIGHT ATTENDANT SEAT INBOARD FLASHLIGHT DOES NOT WORK. REMOVED AND REPLACED BATTERY IN FLASHLIGHT IAW AMM 25-64-00-200-802.SDR AALA202008219013Window · crackedAIRCRAFT WAS GROUNDED: R1 WINDOW CRACKED IN LOWER RIGHT AREA AND ALONG RIGHT EDGE NEAR HEAT ELEMENT. REPLACED R1 WINDOW WITH NEW IAW WORKCARD 56-94-04.SDR AALA202008219010Lens · unsecureAIRCRAFT NOT GROUNDED - LENS DAMAGED, EMERGENCY ESCAPE PATH LIGHT AT SEAT 8C. NEF: CLT8-1137NEF-N LIGHT LENS/COVER/BEZEL DAMAGED AUTHORIZED. RESECURED EMERGENCY ESCAPE PATH LIGHT LENS AT SEAT 8C PER CMM 25-23-67, OPERATIONAL CHECK GOOD. CLEARED NEF ITEM.SDR AALA202008219009Sign · missingAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR 4R EMERGENCY EXIT LIGHT/SIGN DAMAGED/MISSING. INSTALLED CABIN ENTRY DOOR SIGN AT DOOR 4R.SDR AALA202008219018Proximity Sensor · malfunctionedAIRCRAFT WAS NOT GROUNDED: TAKE OFF PLUS 25, FL 370 AFT ENTRY LIGHT ON: F/A PUSHED HANDLE DOWN, LIGHT OUT. ADJUSTED S200 PROXIMITY SENSOR AND ACCOMPLISHED A SATISFACTORY OPEERATIONAL CHECK PER FIM 52-10-00-810+-801SDR AALA202008209021Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: SUSPECTED CRACKED RIGHT HAND FLIGHT DECK #1 WINDOW FRAME POST AT BS 140 AND S4 RIGHT. REPAIRED AND INSTALLED PREVENTIIVE MOD ON THE WINDOW FRAME POST PER EA 305915 AND ECO J2009BA.SDR AALA202008209020Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: SUSPECTED CRACKED LEFT HAND FLIGHT DECK #1 WINDOW FRAME POST AT BS 140 AND S5 LEFT. REPAIRED AND INSTALLED PREVENTIIVE MOD ON THE WINDOW FRAME POST PER EA 305915 AND ECO J2009BA.SDR AALA202008209007Flashlight · inoperativeAIRCRAFT NOT GROUNDED - FORWARD INBOARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA202008249011Sensor · defectiveAIRCRAFT WAS GROUNDED: WHEN LEVELING OFF AT FL3700 FROM CLIMB AT CONTINUOUS POWER, AS POWER THRUST IS RETARED CABIN CLIMBS AT 500-1000 FPM - CABIN AUTO FAIL DID NOT ILLUMINATED - SUSPECT BLEED ISSUE LEFT DUCT PSI ZERO PSI. REPLACED LEFT ENGINE PRECOOLER VALVSDR AALA2020082439029Valve · defectiveAIRCRAFT WAS GROUNDED: WHEN LEVELING OFF AT FL3700 FROM CLIMB AT CONTINUOUS POWER, AS POWER THRUST IS RETARED CABIN CLIMBS AT 500-1000 FPM - CABIN AUTO FAIL DID NOT ILLUMINATED - SUSPECT BLEED ISSUE LEFT DUCT PSI ZERO PSI. REPLACED LEFT ENGINE PRECOOLER VALVSDR AALA202008199007Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT NOT ARMED LIGHT BULB INOPERATIVE. RELAMPED EMERGENCY NOT ARMED LIGHT PER AMM 33-10-00.SDR AALA202009229019Relay · defectiveAIRCRAFT WAS GROUNDED. CMD A AP ON, CA F/O ON DURING DESCENT FO AIRSPEED REF BUG INCREASED AND SEPARATED FROM CA STANDBY AIRSPEED INDICATIONS. F/O`S INDICATION INCREASED TO VMO. F/O`S AIR SPEED INDICATION RETURNED TO MATCH CAPTAINS STANDBY INDICATION WHEN VNSDR AALA202009229018Relay · defectiveAIRCRAFT WAS GROUNDED. CMD A AP ON, CA F/O ON DURING DESCENT F/O AIRSPEED REF BUG INCREASED AND SEPARATED FROM CA STANDBY AIRSPEED INDICATIONS. F/O`S INDICATION INCREASED TO VMO. F/O`S AIR SPEED INDICATION RETURNED TO MATCH CAPATAIN`S STANDBY INDICATION WHESDR AALA202008279005Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LH BAFFLE OF FWD CARGO COMPARTMENT BETWEEN STA 500D AND STA 500I AT STR 26L, MEASURING L=0.35 IN, W=0.005 IN, D=0.02 IN. REPLACED BAFFLE WITH NEW IAW SRM 51-40-02.SDR AALA202008279004Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STRINGER CLIP AT BS 500I AND STR 26L, MEASURING L=0.5 IN, W=0.003 IN, D=0.02 IN. REPLACED STRINGER CLIP WITH NEW IAW AARD 51-00-05 AND DRAWING 143A1234.
Back to Boeing 737-823