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 AALA202512039768Inlet · corrodedAIRCRAFT IN BASE MAINTENANCE: APU AIR INLET DOOR OUTER SKIN CORRODED IN AFT CORNERS UPPER AND LOWER. INSTALLED INTAKE DIFFUSER DUCT. PER AMM 49-15-15.SDR AALA202511181446Bumper Block · wornAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR ON AFT DOOR FRAME ROLLER GUIDE FITTING HAS WEAR MARK. REMOVED AND REPLACED NEW BUMPER AT FORWARD ENTRY DOOR ON AFT DOOR FRAME ROLLER GUIDE FITTING. PER B737NG SRM 51-40--02-OG AND IPC 52-11-00-12.SDR AALA202511132460Support Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT VACUUM WASTE TANK ENCLOSURE SUPPORT BRACKET AT BS 867, LBL 18. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202511131110Guide · out of trackAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS LEFT SIDE AFT LAVATORY DOOR JAMS WHEN ATTEMPTING TO OPEN AND CLOSE. FOUND LAVATORY DOOR GUIDE OUT OF TRACK. REINSTALLED DOOR GUIDE.SDR AALA202511132337Track · bentAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT OPEN FROM THE INSIDE. FOUND LEFT AFT LAVATORY DOOR UPPER TRIM HAS LOOSE SCREWS AND BENT TRACK. RESHAPED TRIM RAIL TRACK AND SECURED RAIL FASTENERS. OPERATIONAL CHECK GOOD. PER 737 MM 25-40-14.SDR AALA202511132591Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY-D DOOR. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.SDR AALA202601143069Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500A TO BS 500I, AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202601142634Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B TO BS 500I, AT S25L, AT LBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202601149146Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500 TO BS 500A, AT S25L, AT LBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202511260523Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 320, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202511266094Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 336, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202511245665Roller Guide · crackedAIRCRAFT IN BASE MAINTENANCE: L2 DOOR FORWARD ENTRY DOOR CENTER GUIDE ROLLER IS CRACKED. REMOVED AND REPLACED L2 DOOR, CENTER GUIDE ROLLER AND ADJUSTMENT VERIFICATION COMPLETED. PER SRM 51-40-02 AND AMM 52-13-00-820.SDR AALA202511194351Wire Harness · faultedAIRCRAFT WAS GROUNDED: DURING CRUISE FUEL QUANTITIES INDICATOR BEGAN RAPIDLY DECREASING. REMOVE AND REPLACED OF FQIS WIRE HARNESS. PER AMM 28-41-44-40-801. PANEL LEAK CHECK GOOD, PER AMM 28-11-00-400-801.SDR AALA202511136382Sign · damagedAIRCRAFT IN BASE MAINTENANCE: CENTER AISLE EMERGENCY EXIT SIGN ABOVE THE OVERWING EXIT DAMAGED. REMOVED AND REPLACED CENTER AISLE EMERGENCY EXIT SIGN ABOVE THE OVERWING EXIT. PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202511138336Liner · out of positionAIRCRAFT IN BASE MAINTENANCE: L2 DOOR SLIDE GIRT BAR FLAP HANGING TOO LOW. REMOVED SLIDE PACK DOOR AFT ENTRY L2 AND REPOSITIONED SLIDE GIRT BAR VELCRO AND REINSTALLED SLIDE PACK DOOR AFT ENTRY L2. PER B737 NGAMM 25-66-01.SDR AALA202511134332Pump · malfunctionedAIRCRAFT WAS GROUNDED: FUEL LEAKING INTO CENTER TANK DURING FLIGHT. PUMPED CENTER TANK TO MAKE IT ZERO MULTIPLE TIMES AND FUEL STILL RETURNED. NO FUEL LEAK OR UNWATED TRANSFER TO CENTER TANKS, UNABLE TO DUPLICATE. NO FAULT FOUND. PER FIM TASK 28-21-00-810-81SDR AALA202511129711Control Unit · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING TAKEOFF ROLL, FIRST OFFICER LOST PITCH AND ROLL GUIDANCE. THEN ON CLIMB OUT, COULD NOT SELECT DIRECT TO A POINT IN LNAV, AND COULD NOT ENGAGE HEADING SELECT. ALSO, UNABLE TO SELECT AUTOPILOT-B ANDSDR AALA202511124351Fuel Sys · decreasingAIRCRAFT WAS GROUNDED: DURING CRUISE FUEL QUANTITIES INDICATOR BEGAN RAPIDLY DECREASING. (OPEN).SDR AALA202511124332Fuel Tank · leakingAIRCRAFT WAS GROUNDED: FUEL LEAKING INTO CENTER TANK DURING FLIGHT. PUMPED CENTER TANK TO MAKE IT ZERO MULTIPLE TIMES AND FUEL STILL RETURNED. (OPEN).SDR AALA202511127791Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN. LUBRICATED FORWARD LAVATORY DOOR FRAME AND DOOR LOCK. OPERATIONAL CHECK GOOD. PER AMM 25-40-11.SDR AALA202511126591Light · detachedAIRCRAFT WAS NOT GROUNDED: ROW 15ABC SEAT, AISLE EMERGENCY LIGHT ASSEMBLY DETACHED FROM SEAT. RESECURED LIGHT ASSEMBLY TO SEAT. PER CMM 25-23-67.SDR AALA202511121538Light · detachedAIRCRAFT WAS NOT GROUNDED: FLOOR EXIT LIGHT AT SEAT 24C FELL DOWN. SECURED EMERGENCY LIGHT PANEL ON SEAT 24C. PER CMM 25-23-67.SDR AALA202511245594Window · crazedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD EMERGENCY EXIT WINDOW L18 IS CRAZED. REMOVED AND REPLACED EMERGENCY EXIT WINDOW. PER AMM 56-22-00.SDR AALA202511122901Locking Cam · inoperativeAIRCRAFT WAS NOT GROUNDED: 2R GIRT BAR DIFFICULT ARM AND DISARM. ADJUSTED 2L DOOR GIRTBAR RETAINER CLIP. PER AMM 25-66-01. OPS CHECKED GOOD.SDR AALA202511118451Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE, LOCATED IN RIGHT HAND ECS BAY, AT STA 663, RBL 35. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202601148998Threshold Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD WEB FROM BS 794 TO BS 847, AT S25R, AT RBL 22. REPLACED WEB PER PER AARD 51-00-05-1.SDR AALA202511263673Shear Tie · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT SHEAR TIE DAMAGED AT STA 500G BETWEEN S25R AND S26R. REPLACED SHEAR TIE PER SRM 51-40-02-0G.SDR AALA202511123573Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: SEAT 29C EMERGENCY LIGHT ON END CAP IS OUT OF CONNECTOR. RECONNECTED IN USE LIGHT AT SEAT 29C. PER AMM 23-81-00. OPERATIONAL CHECK GOOD.SDR AALA202511120259Latch · missingAIRCRAFT IN BASE MAINTENANCE: L1 DOOR ESCAPE SLIDE GIRT BAR NYLON SPRING LATCH HAS OUTER SLEEVE MISSING. REMOVED DAMAGE SPRING LATCH AND INSTALLED NEW SPRING LATCH. PER AMM 25-66-01SDR AALA202511122748Latch · damagedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR ESCAPE SLIDE GIRT BAR NYLON SPRING LATCH HAS OUTER SLEEVE DISPLACED. REMOVED DAMAGED SPRING LATCH AND INSTALLED NEW SPRING LATCH. PER AMM 25-66-01SDR AALA202511129464Liner · frayedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR GIRT BAR ESCAPE SLIDE LOWER FABRIC FRAYED. REPAIRED FRAYED FABRIC. PER AARD 25-66-00-2 PROCEDURE REPAIR 2.SDR AALA202511123160Latch · damagedAIRCRAFT IN BASE MAINTENANCE: L2 DOOR ESCAPE SLIDE GIRT BAR NYLON SPRING LATCH HAS OUTER SLEEVE DAMAGED. REMOVED DAMAGED SPRING LATCH AND INSTALLED NEW SPRING LATCH. PER AMM 25-66-01.SDR AALA202511102526Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D BI-FOLD DOOR IS DIFFICULT TO OPEN. LUBED AFTER LEFT LAVATORY DOOR. OPERATIONAL CHECKS NORMAL.SDR AALA202511100132Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR DIFFICULT TO OPERATE. LUBRICATED FORWARD SERVICE DOOR GIRT BAR. PER 52-40-00.SDR AALA202511105158Downlock Sensor · faultedAIRCRAFT WAS GROUNDED: LEFT GEAR EXTENDED LIGHT ON OVERHEAD PANEL REMAINED ILLUMINATED AFTER GEAR RETRACTION. PERFORMED FIM TASK 32-61-00-810-801. REMOVED AND REPLACED LEFT MAIN GEAR DOWN LOCK SENSOR S302. PER AMM 32-61-31. OPERATIONAL CHECK GOOD, EXISTING FAUSDR AALA202601145241Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO R1 ENTRY WAY SILL CHORD (CREASE ANGLE) LOCATED FROM BS 294.5 TO BS 328 AT RBL 57. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202512035003Slider · crackedAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER LOWER SLIDER CRACKED AT UPPER CORNERS LEFT HAND. REMOVED AND REPLACED LEFT HAND LOWER SLIDER. PER AARD 51-00-05-1SDR AALA202512038349Slider · wornAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER UPPER SLIDER ROD ATTACH POINTS WORN LEFT HAND. REPLACED UPPER SLIDER ROD. PER AARD 51-00-05-1.SDR AALA202512032731Rod · wornAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER LOWER SLIDER ROD ATTACH POINTS WORN LEFT HAND. REPLACED SLIDER ROD. PER AARD 51-00-05-1.SDR AALA202512037805Slider · wornAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER UPPER SLIDER WORN AT ROD ATTACH POINTS ON RIGHT HAND. REMOVED AND REPLACED RIGHT HAND UPPER SLIDER. PER AARD 51-00-05-1.SDR AALA202512026178Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500G TO BS 500H. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202512021106Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500F TO BS 500G. REPLACED BAFFLE PER AARD 51-00-05-1SDR AALA202511190644Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK DIFFICULT TO OPERATE. CONFIRMED AFT LAVATORY DOOR INOPERATIVE, WILL NEED A NEW DOOR. REMOVED AND REPLACED LAVATORY-D BI-FOLD DOOR. PER CMM 25-40-64.SDR AALA202511126686Door · jammedAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR LOCK IS JAMMING. VERIFIED LAVATORY- D DOOR IS JAMMING. REMOVE AND REPLACED UPPER TRIM. PER CMM 25-40-64.SDR AALA202511100644Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK DIFFICULT TO OPERATE. CONFIRMED AFT LAVATORY DOOR INOPERATIVE, WILL NEED A NEW DOOR. (OPEN).SDR AALA202511105061Cam · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER ENTRY DOOR 4L GIRT BAR BRACKET IS DIFFICULT TO INSTALL AND REMOVE. ADJUSTED 4L ENTRY DOOR GIRT BAR BRACKET. PER AMM 25-66-02.SDR AALA202511107503Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FUSELAGE SKIN, AT ELECTRICAL GROUND POWER RECEPTACLE DOOR LOWER CUTOUT SURROUND DOUBLER AT BS 225, S22R. REPAIRED SKIN PER SRM 53-10-15-2R-4.SDR AALA202511106686Lock · jammedAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR LOCK IS JAMMING. VERIFIED LAVATORY- D DOOR IS JAMMING. (OPEN).SDR AALA202511106887Door · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO CLOSE. REQUIRES FORCE TO OPEN. RESECURED METAL FLOOR TRIM PIECE BETWEEN LAVATORY AND GALLEY FLOOR AS REQUIRED. OPERATIONAL CHECK OF FORWARD LAVATORY DOOR GOOD.SDR AALA202512223252Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT BS 947. REPLACED CHORD PER EA 370421.
Back to Boeing 737-823