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 AALA202510042300Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727G TO STA 767 AT RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202510040523Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSEMBLY LOCATED FROM BS 767 TO BS 787, AT RBL 25. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05-1SDR AALA202510046778Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 990, FROM RBL 34 TO RBL 47. REPLACED FLOOR SUPPORT Z ANGLE PER AARD 51-00-05-1.SDR AALA202510022319Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT BEZEL FELL OFF ROW 20ABC. CONFIRMED ON SEAT 20C EMERGENCY ESCAPE PATH LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202509252319): REMOVE AND REPLACED SEAT ROW 20 ABC EMERGENCY LIGHT AND REATTACHED LIGSDR AALA202509307658Hinge · wornAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. FOUND THAT LAVATORY-D DOOR HINGE TO BE WORN; TRIED TO ADJUST THE DOOR UP. NO HELP. DOOR DRAGS ON THRESHOLD. REMOVED AND REPLACED LAVATORY-D DOOR. PER CMM 25-40-64. OPERATIONAL CHECK GOSDR AALA202509272720Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER FUSELAGE SKIN AROUND AFT LAVATORY VACUUM VENT LOCATED AT BS 917 FROM S21L AND S22L. ACCOMPLISHED TRIPLER REPAIR PER SRM 53-70-01-2R REPAIR AND EA 368349.SDR AALA202509255664Elec Connector · not seatedAIRCRAFT WAS NOT GROUNDED: AFT LEFT FUEL PUMP LOW PRESSURE LIGHT DID NOT ILLUMINATE. CLEANED AND RESEATED CONNECTOR ON BOOST PUMP. PER AMM 28-22-41.SDR AALA202509257658Hinge · wornAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. FOUND THAT LAVATORY-D DOOR HINGE TO BE WORN, TRIED TO ADJUST THE DOOR UP. NO HELP. DOOR DRAGS ON THRESHOLD. (OPEN).SDR AALA202509252319Bezel · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT BEZEL FELL OFF ROW 20ABC. CONFIRMED ON SEAT 20C EMERGENCY ESCAPE PATH LIGHT INOPERATIVE. (OPEN).SDR AALA202509258788Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: OVERHEAD EXIT SIGN BY WING EMERGENCY EXIT ROWS FELL DOWN. REINSTALLED EXIT LIGHT SIGN FOR OVERHEAD AISLE EXIT MARKERS LIGHT. PER AMM 33-51-02.SDR AALA202509250175Light · intermittentAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW LIGHT IS FLICKERING AT ROW17ABC. RESET EMERGENCY EXIT ROW 17ABC. PER AMM 33-50-00.SDR AALA202509255327Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT ELEVATOR INBOARD TRAILING EDGE SKIN TOP SIDE. ACCOMPLISHED BONDED REPAIR PER ESO 60243 AND CMM 55-20-17.SDR AALA202510106345Skin · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND WING FIXED LEADING EDGE SKIN WORN AT CONTACT AREA WITH PYLON PANEL 441CL. REMOVED WORN LEADING EDGE WRAP AROUND SKIN AND REPLACED WITH NEW SERVICEABLE WRAP AROUND SKIN. PER SRM 57-41-01SDR AALA202510088003Girt Bar · damagedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE GIRT BAR FLAP IS DAMAGED. REMOVED AND REPLACED R1 DOOR SLIDE. PER TASK CARD 08L22125001.SDR AALA202510075429Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) AT BS 327, RBL 58. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202510076216Track · gougedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE AFT LOWER FRAME-MOUNTED LATCH TRACK FITTING HAS A GOUGE AT THE ROLLER TRACK AREA. REMOVED AND REPLACED LATCH TRACK FITTING ON THE AFT ENTRY DOOR CUTOUT LOWER FRAME. PER B737NG SRM 51-40-02 SDR AALA202510079369Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B PLUS 10 INCHES AND BS 500I AT RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202510070646Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D AND 500F AT LBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202510074795Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500D PLUS 10 INCHES AND BS 500I AT RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202510079320Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL ASSEMBLY AT BS 500I, FROM LBL 26 TO RBL 26. REPLACED RAIL ASSEMBLY PER AARD 51-00-05-1.SDR AALA202509252855Elec Connector · damagedAIRCRAFT WAS NOT GROUNDED: ROW 4AB SEAT AISLE EMERGENCY LIGHTS INOPERATIVE. REPAIRED CONNECTOR, PER TSM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA202509255838Wire · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING WIRING ON SEAT 20C LOOSE. RESTOWED EMERGENCY EXIT LIGHTING WIRING IN CLIPS ON SEAT 20C. PER AMM 33-51-11.SDR AALA202509259393Air Filter · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT THAT SMELLED LIKE DIRTY SOCK. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LEFT HAND RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSDR AALA202509257830Insulation · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT THAT SMELLED LIKE DIRTY SOCK. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LEFT HAND RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSDR AALA202509257742Fan · contaminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT THAT SMELLED LIKE DIRTY SOCK. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LEFT HAND RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSDR AALA202509256714Hose · leakingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED STRONG ODOR ON TAKEOFF AND ON CLIMB OUT, THAT SMELLED LIKE DIRTY SOCKS. GOT BETTER IN CRUISE AND WORSE ON DESCENT. FOUND LEAKING GREY WATER HOSE ABOVE LT RECIRCULATING FAN FILTER. REMOVE AND REPLACED HOSESDR AALA202509242789Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT AFT OF L2 DOOR TOP BULB BURNED OUT. REPALCED EMERGENCY EXIT LIGHT AFT OF L2 DOOR. PER AMM 33-55-01-960-802.SDR AALA202509244534Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT SAYS THAT LAVATORY-D IS VERY DIFFICULT TO OPEN. LUBRICATED LAVATORY-D LOCK, OPERATIONAL CHECK GOOD. PER 25-41-00.SDR AALA202509243499Light · dislodgedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK ENTRY DOOR EMERGENCY EXIT PANEL DISLODGE. REATTACHED LIGHT EMERGENCY EXIT NEAR FLIGHT DECK. PER AMM 33-51-01.SDR AALA202509249106Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN KNOCKED DOWN OVER 16C. RESECURED EMERGENCY EXIT SIGN. PER 33-51-01.SDR AALA202509247394Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD MEGAPHONE HAS LOW POWER LEVEL. REPLACED BATTERIES IN FORWARD MEGAPHONE. OPERATIONAL CHECK GOOD. PER MM 25-64-00-900-804.SDR AALA202509241076Gust Lock · missingAIRCRAFT WAS NOT GROUNDED: DOOR 2R GUST RELEASE BUTTON IS MISSING. REMOVE AND REPLACED AFT ENTRY DOOR GUST LOCK. OPERATIONAL CHECK GOOD. PER AMM 52-13-21.SDR AALA202509240834Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LATCH IS DIFFICULT TO LATCH AND OPEN. LUBED LAVATORY-D DOOR LATCH. OPERATIONAL CHECK GOOD.SDR AALA202509234715Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: LOWER EMERGENCY EXIT LIGHT NEAR LEFT HAND FORWARD EMERGENCY DOOR DOES NOT WORK. RECONNECT CONNECTORS FOR EMERGENCY LIGHT, OPERATIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202510077496Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510071935Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, RBL 25. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202510060554Liner · misinstalledAIRCRAFT IN BASE MAINTENANCE: BOTH LEFT HAND AND RIGHT HAND AFT POSITION EMERGENCY EXIT DOOR LINERS ARE INSTALLED INCORRECTLY EMOVED AND REINSTALLED LEFT HAND (AALA202510069425) AND RIGHT HAND (AALA202510060554) AFT POSITION EMERGENCY EXIT DOOR LINERS IN CORRESDR AALA202510069425Liner · misinstalledAIRCRAFT IN BASE MAINTENANCE: BOTH LEFT HAND AND RIGHT HAND AFT POSITION EMERGENCY EXIT DOOR LINERS ARE INSTALLED INCORRECTLY EMOVED AND REINSTALLED LEFT HAND (AALA202510069425) AND RIGHT HAND (AALA202510060554) AFT POSITION EMERGENCY EXIT DOOR LINERS IN CORRESDR AALA202510048085Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB AT STABILIZER STA 138.70, 18 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202510047724Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB AT STABILIZER STA 138.70, 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11 AND EA 368024.SDR AALA202510043802Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, FROM BL0 TO LBL 24. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-01SDR AALA202510029202Trunnion · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT MLG FORWARD TRUNNION FITTING CORROSION IS OUT OF LIMITS. WORK CARD REMOVE AND REPLACED TRUNNION FITTING. PER TASK CARD 08L70032009.SDR AALA202509237548Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE LOCATED IN LEFT HAND ECS BAY, AT AFT BULKHEAD BS 663, RBL 13. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202509231791Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY AT L1 DOOR FAILED. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-00 OPERATIONAL CHECKED GOOD.SDR AALA202509238880Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT LEFT HAND SLIDE LIGHT INOPERATIVE. REMOVE AND REPLACED EPL BATTERY M1670 (AALA202509235892), PER AMM 33-51-66. ALSO, FOUND CONNECTOR D11083 DISCONNECTED, RECONNECTED CONNECTOR (AALA202509230084), PER WDM 3SDR AALA202509236857Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT LEFT HAND SLIDE LIGHT INOPERATIVE. REMOVE AND REPLACED EPL BATTERY M1670 (AALA202509235892), PER AMM 33-51-66. ALSO, FOUND CONNECTOR D11083 DISCONNECTED, RECONNECTED CONNECTOR (AALA202509230084), PER WDM 3SDR AALA202509232513Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: FAILED EMERGENCY BATTERY AT L1 DOOR. REMOVED AND REPLACED L1 DOOR EMERGENCY BATTERY PACK. PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA202509230745Lens · brokenAIRCRAFT WAS NOT GROUNDED: L2 DOOR EMERGENCY EXIT LIGHT AND LENS BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT AND LENSE. OPERATIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202509234190Fitting · unsecureAIRCRAFT WAS NOT GROUNDED: R2 GIRT BAR CLIPS APPEAR TO BE DAMAGED AND NOT CLIPPED. RESECURED GIRT BAR ATTACH BRACKET. PER SRM 51-40-02.SDR AALA202509237751Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR 1R DIFFICULT TO ARM AND DISARM. LUBED GIRT BAR, OPERATIONAL CHECK GOOD. PER AMM 25-66-01.
Back to Boeing 737-823