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 AALA202508223650Door Latch · looseAIRCRAFT WAS NOT GROUNDED: FORWARD BATHROOM DOOR HANDLE VERY LOOSE AND CAN NOT OPEN. REMOVE AND REPLACED LAVATORY DOOR LATCH. PER CMM 25-40-61. OPERATIONAL CHECK GOOD.SDR AALA202508226930Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR BINDS ON THE BOTTOM AND MAKES THE DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY DOOR. PER AMM 25-40-11.SDR AALA202508226670Spring · looseAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR GIRT BAR HAS LOOSE WHITE CAP. REMOVE AND REPLACED WHITE CAP RELEASE STOP ASSEMBLY SPRING CLIP ON L1 DOOR. PER AMM 25-66-01.SDR AALA202508228549Sill Drain · cloggedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS DURING DESCENT A STRONG ODOR ON THE LEFT AFT GALLEY AREA. FOUND AFT GALLEY THRESHHOLD DRAINS CLOGGED. CLEARED AFT GALLEY L2 (AALA202508228549) AND R2 (AALA202508220812) DOOR THRESHHOLD DRAINS.SDR AALA202508219012Light · detachedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTING EMERGENCY LIGHT HANGING DOWN FROM SEAT ROW 30C. REATTACHED AND SECURED EMERGENCY LIGHT COVER. OPERATIONAL CHECK GOOD. PER AMM 33-50-00.SDR AALA202508284012Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM THE FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508285079Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 8 INCHES FROM THE FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11SDR AALA202508283411Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FROM THE REAR SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508211540Adiru · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT IRS FAULT IN FLIGHT FIRST OFFICER PFD AND ALSO WENT BLANK, CONTINUED ERRONEOUS INDICATIONS OF BOTH WINDS AND LOCATIONS WHEN SHARING BOTH ON IRS 1. ERRONEOUS GPS LOCATION. AIRCRAFT AIR INTERRUPTED BSDR AALA202508215207Life Vest · damagedAIRCRAFT WAS NOT GROUNDED: CABIN SERVICE REPORTS SEAT 2B LIFEVEST DAMAGED. REPLACED LIFE VEST. PER AMM 25-64-00.SDR AALA202508212424Door · out of positionAIRCRAFT WAS NOT GROUNDED: AIRCRAFT AFT LAVATORY LEFT SIDE DOOR WILL NOT OPEN. REPOSITIONED LEFT AFT LAVATORY DOOR. PER AMM 25-40-00. OPERATIONAL TEST GOOD.SDR AALA202508211081Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: COMPACT FLASHLIGHT BELOW FORWARD FLIGHT ATTENDANT SEAT IS NOT WORKING. RESEATED FLASHLIGHT AND PERFORMED, OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202508214668Flashlight · dislodgedAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDENT JUMPSEAT RIGHT SIDE EMERGENCY FLASHFLIGHT FOUND ON FLOOR. REMOVED AND REPLACED FLASHLIGHT. PER AMM 25-64-00.SDR AALA202508215170Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT CRUISE ELECTRICAL ODOR IN THE FORWARD SECTION OF THE AIRCRAFT. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CUR. ACCOMPLISHED SOF INSPECTION, PER J/C 08L00021001. NO FAULT FOUND.SDR AALA202508292222Skin · crackedAIRCRAFT IN BASE MAINTENANCE: TWO CRACKS IN RUDDER SKIN LOCATED ON RIGHT SIDE, FROM RUDDER STA 254 TO STA 260. REPAIRED SKIN PER SRM 55-40-01-2R REPAIR 1 AND EA 366887.SDR AALA202508277233Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED INTERCOSTAL AT BS 312 TO 324. INSTALLED NEW INTERCOASTAL. PER AARD 51-00-05 AND BOEING DRAWING 141A5410.SDR AALA202508250416Pump · low pressureAIRCRAFT WAS GROUNDED: LEFT FORWARD MAIN FUEL TANK PUMP LOW PRESSURE LIGHT CAME ON AFTER TAKEOFF AND THROUGH CRUISE. REMOVED AND REPLACED LEFT HAND FORWARD MOTOR IMPELLER ASSEMBLY. PER AMM 28-22-41. PERFORMED OPS CHECK AND LEAK CHECK GOOD.SDR AALA202508259528Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED FROM BS 500G TO BS 500H AT S26R REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202508210259Pressure Switch · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THROUGH APPROXIMATELY 3000FT, GOT NUMBER 1 ENGINE OIL FILTER BYPASS. HAD TO REDUCED THRUST TO IDLE BEFORE LIGHT EXTINGUISHED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. ACCOSDR AALA202508200416Pump · low pressureAIRCRAFT WAS GROUNDED: LEFT FORWARD MAIN FUEL TANK PUMP LOW PRESSURE LIGHT CAME ON AFTER TAKEOFF AND THROUGH CRUISE. (OPEN).SDR AALA202508207405Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS THAT LAVATORY-D DOOR HARD TO OPEN AND CLOSED. LUBRICATED LAVATORY-D BI-FOLD LATCH AND PERFORMED, OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202508206435Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 25C HANGING BY WIRE. RESECURED LIGHT ASSEMBLY. PER AMM 33-20-00. OPERATIONAL CHECK GOOD.SDR AALA202508209791Carpet · odorAIRCRAFT WAS GROUNDED, STRONG ODOR LINGERING IN AFT SECTION OF AIRCRAFT. PREVIOUS CREW REPORTED SMELLING THE ODOR COMING FROM VENTS ON CLIMB OUT AND DESCENT. REMOVED AND REPLACED ROW 30-33 CARPET. PER AFMM 20-25-17. AFT GALLEY TRASH CART REPLACED BY CATERING SDR AALA202508200259Pressure Switch · failedAIRCRAFT WAS GROUNDED. AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THROUGH APPROXIMATELY 3000FT, GOT NUMBER 1 ENGINE OIL FILTER BYPASS. HAD TO REDUCED THRUST TO IDLE BEFORE LIGHT EXTINGUISHED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. ACCSDR AALA202509021869Fuel Control · low pressureAIRCRAFT WAS NOT GROUNDED: DURING CLIMB AT FL 360 THE RIGHT FUEL TANK, FORWARD PUMP, "LOW PRESSURE" LIGHT ILLUMINATED. FUEL TANK QUANTITY WAS 8,600 LBS. REMOVE AND REPLACED TANK NUMBER 2 FORWARD FUEL BOOST PUMP. PER AMM 28-22-41. OPERATIONAL AND LEAK CHECKS GOSDR AALA202508201444Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 344 TO BS 360 AT LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-+1.SDR AALA202508204578Stop Fitting · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT AIRCRAFT LEFT AFT LAVATORY DOOR JAMS CLOSED. CONFIRMED LEFT AFT LAVATOR-D LATCH JAM WHEN OPENING AND CLOSING. **SUPPLEMENTAL REPORT FOR (AALA202508194578): ADJUSTED DOOR STOP TO BETTER LINE UP DOOR LATCH. DOOSDR AALA202508209188Sign · damagedAIRCRAFT WAS NOT GROUNDED: OVERWING LEFT FORWARD EMERGENCY EXIT SIGN DECAL DAMAGED. REPLACED EXIT SIGN LENS.SDR AALA202508202320Pressure Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD FUEL PUMP LOW PRESSURE LIGHT CAME ON WHEN TAKEOFF POWER APPLIED. ON TAXI IN LOW PRESSURE CAME ON WHEN AIRCRAFT MADE A TURN LEFT OR RIGHT. REMOVED AND REPLACED LEFT FUEL BOOST PUMP PRESSURE SWITCH. PER AMM 28-42-11.SDR AALA202508194578Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT AIRCRAFT LEFT AFT LAVATORY DOOR JAMS CLOSED. CONFIRMED LEFT AFT LAVATOR-D LATCH JAM WHEN OPENING AND CLOSING. (OPEN).SDR AALA202508194274Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT THAT WHEN THE BOARDING DOOR WAS CLOSED AND THE EMERGENCY SLIDE WAS ARMED THE GIRT COVER WAS TWISTED. FOUND L1 DOOR GIRT VELCRO BECAME DETACHED FROM THE SLIDE CASE. REATTACHED GIRT VELCRO, PER AMM 25-66-01. OPESDR AALA202508198268Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR BEAM LOCATED FROM BS 300 TO BS 328. REPLACED BEAM PER CMM 52-41-05.SDR AALA202508290913Slide · deterioratedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EMERGENCY ESCAPE SLIDE GIRT FLAP IS DETERIORATED. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE.SDR AALA202508254942Slat · out of rigAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. REMOVED AND REPLACED OUTBOARD SLATSDR AALA202508259181Target · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. REMOVED AND REPLACED OUTBOARD SLATSDR AALA202508256316Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. REMOVED AND REPLACED OUTBOARD SLATSDR AALA202508194810Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN. READJUSTED AND LUBED LEFT AFT LAVATORY DOOR AND TRACKS. PER AMM 25-40-00.SDR AALA202508190359Sliding Window · out of positionAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: R2 WINDOW SHWOING DAYLIGHT AND IS EXTREMELY LOUD. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. FOUND R2 WINDOW UPPER ROLLER OUT OF TRACK. INSPECTED WINDOW SEAL, ROLLS AND TRACK, PER AMM 56-SDR AALA202508196316Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. (OPEN).SDR AALA202508189457Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 46. REPLACED INTERCOSTAL PER SRM 41-40-02.SDR AALA202508182878Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 270 TO BS 294 AT BL0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508195650Door · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN AND CLOSE. RESECURED FORWARD LAVATORY DOOR LATCH HANDLE. PER CMM 25-48-48. OPERATIONAL CHECK GOOD.SDR AALA202508198280Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR FOR L2 DOOR DIFFICULT TO RELEASE. LUBRICATED GIRT BAR AS REQUIRED.SDR AALA202508183647Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ANGLE LOCATED AT BS 285, S17R, RBL 64. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202508285674Pump · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT CENTER PUMP LOW PRESSURE LIGHT REMAINS ON WHEN PUMP TURNED ON. ACCOMPLISHED UFI FAULT ISOLATION PROCEDURE PER FIM TASK 28-22-00-810-822. REMOVE AND REPLACED (UFI)-UNIVERSAL FAULT INTERRUPTER (AALA202508209524) AND RAM MODULESDR AALA202508289524Interrupter · faultedAIRCRAFT WAS NOT GROUNDED: RIGHT CENTER PUMP LOW PRESSURE LIGHT REMAINS ON WHEN PUMP TURNED ON. ACCOMPLISHED UFI FAULT ISOLATION PROCEDURE PER FIM TASK 28-22-00-810-822. REMOVE AND REPLACED (UFI)-UNIVERSAL FAULT INTERRUPTER (AALA202508209524) AND RAM MODULE SDR AALA202508194559Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY AND FORWARD SERVICE DOORS BOTH GIRT BARS REQUIRED EXCESSIVE FORCE TO ARM AND DISARM. CORRECTED Z-FOLD, PER AMM 25-66-01-601.SDR AALA202508197772Grip · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT HAND OVERWING EMERGENCY EXIT DOOR "GRIP ASSEMBLY ACCESS" WHERE THE LIFT HANDLE GETS MOUNTED TO ON THE DOOR LINER FOUND DAMAGED. REPLACED DAMAGED GRIP ASSEMBLY ON FORWARD LEFT HAND OVERWING EXIT DOOR. PER AMM 52-22-51.SDR AALA202508196179Strap · frayedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EMERGENCY EXITD DOOR RED PULL STRAP IS FRAYED. REMOVED AND INSTALLED A SERVICABLE RED PULL STRAP ON THE RIGHT HAND OVERWING EMERGENCY EXIT DOOR. PER AMM 52-22-00.SDR AALA202508192006Control Panel · odorAIRCRAFT WAS GROUNDED: ACRID SMELL IN FLIGHT DECK. ACCOMPLISHED CARD 08L00021001. FOUND TCAS AND ATC PANEL PRODUCING ACRID ODOR. REMOVED AND REPLACED PANEL, PER AMM 34-53-03.
Back to Boeing 737-823