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 AALA202107097081Bracket · out of adjustAIRCRAFT WAS GROUNDED: DOOR IR GIRT BAR STOWAGE BRACKETS ARE TOO TIGHT. ADJUSTED GIRT BAR STORAGE BRACKET.SDR AALA202107091069Light · missingAIRCRAFT WAS NOT GROUNDED: FORWARD MAIN ENTRY DOOR AIRCRAFT LEFT MISSING EXIT SIGN BY JUMPSEAT. REPLACED L1 ENTRY EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA202107094767Shroud · looseAIRCRAFT WAS NOT GROUNDED: EXIT ROW LIGHT AT SEAT 14C LOOSE. RE-SECURED EXIT ROW LIGHT (EGRESS) LIGHT SHROUD AT 14C OK FOR SERVICE PER AMM 33-51-11.SDR AALA202107206712Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 DOOR RELEASE LATCH DIFFICULT TO RELEASE. **SUPPLEMENTAL REPORT: LUBED DOOR LATCH IAW AMM 12-25-11, OPS CHECK GOOD.** (CLOSED)SDR AALA202107124978Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: A LOW PRESSURE LIGHT ILLUMINATED DURING FLIGHT CONTROL CHECK JUST BEFORE TAXI TO ACTIVE RUNWAY. RETURN TO GATE. LOW PRESSURE WARNING SWITCH REPLACED IAN AM 27-09-61 PB 401.SDR AALA202107096712Latch · bindingAIRCRAFT WAS NOT GROUNDED: L1 DOOR RELEASE LATCH DIFFICULT TO RELEASE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202107082924Light · brokenAIRCRAFT WAS NOT GROUNDED: DOOR 2R EMERGENCY LIGHT PANEL IS MISSING WIRES EXPOSED. REMOVED AND REPLACED EMERGENCY EXIT LIGHT DOOR R2 OPERATIONS CHECK GOOD PER AMM 33-50-00.SDR AALA202107087531Bracket · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT BRACKET AT SEAT 30C NEEDS TO BE REPLACED PER ESO 61106. REMOVED AND REPLACED EMERGENCY ESCAPE PATH LIGHT BRACKET.SDR AALA202107086018Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: GIRT BAR WONT SECURE PROPERLY. RE-INSTALLED GIRT BAR.SDR AALA202107215828Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER BOTTOM SKIN HAS POSSIBLE CRACK AT STATION BETWEEN 92.7 AND 101.9. INSTALLED DOUBLER REPAIR OF LEFT HORIZONTAL STABILIZER BOTTOM SKIN PER 55-10-01-2R-11.SDR AALA202107080923Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT SEAT 8C IS NOT SECURE. RESECURED EMERGENCY LIGHT AT SEAT ROW 8 LEFT.SDR AALA202107074271Guard · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT SWITCH GUARD DOES NOT PROPERLY MOVE SWITCH. INSTALLED NEW SWITCH GUARD.SDR AALA202107074214Lens · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN OVER LEFT AFT SERVICE DOOR FELL OFF. INSTALLED EXIT SIGN LENS.SDR AALA202107135540Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY OVERHEAD LIGHT INOPERATIVE AT SEAT 32DEF. REACTIVATED EMERGENCY LIGHT PER AWDW 33-51-14, OPS CHECK GOOD. **SUPPLEMENTAL REPORT TO ADD AIRCRAFT TIME AND CYCLES TO SECTION 3**SDR AALA202107098764Window · crackedAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER WINDOW FORWARD SEEMS TO HAVE THE EDGES CRACKING ALONG RIGHT EDGE AND TOP LEFT. REPLACED RIGHT COCKPIT WINDOW #1 PER J/C 08L21056004.SDR AALA202107099355Window · overheatedAIRCRAFT WAS GROUNDED: DURING CLIMB MASTER CAUTION ILLUMINATED FOR A RIGHT FORWARD WINDSHIELD OVERHEAT, FOLLOWED QUICK REFERENCE HANDBOOK PROCEDURE, OVERHEAT DID NOT RESET. REMOVED AND REPLACED WINDOW.SDR AALA202107091304Wire Harness · frayedAIRCRAFT WAS GROUNDED: RIGHT SLIDING WINDOW POWER WIRE HARNESS FRAYED AT ATTACH POINT TO WINDOW. REMOVED AND REPLACED WINDOW REF JOB CARD 08C21256002.SDR AALA202107094364Overheat Loop · faultedAIRCRAFT WAS GROUNDED: WARNING MESSAGE FOR WING-TO-BODY OVERHEAT, FLIGHT DECLARED EMERGENCY AND RETURNED TO FIELD. REPLACED RH OUTBD OVERHEAT DETECTOR IAW TSM 26-18-00-810-802, OPS CHECK GOOD.SDR AALA202107065540Light · deactivatedAIRCRAFT WAS NOT GROUNDED: EMERGENCY OVERHEAD LIGHT INOPERATIVE AT SEAT 32DEF. REACTIVATED EMERGENCY LIGHT IAW AWDW 33-51-14, OPS CHECK GOOD.SDR AALA202107066749Motor · bindingAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, HORIZONTAL STABILIZER TRIM INOPERATIVE; MANUAL TRIM WHEEL UTILIZED, BUT SEVERE BINDING IN BOTH NOSE UP AND NOSE DOWN DIRECTIONS. REPLACED STABILIZER TRIM MOTOR WITH SERVICEABLE UNIT IAW FIM 27-41-00810-804, OPS CHECK GOOD.SDR AALA202107067662Adiru · faultedAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF DUE TO AIRSPEED DISAGREE. REPLACED AIR DATA INERTIAL REFERENCE UNIT WITH SERVICEABLE UNIT IAW AMM 34-21-01, OPS CHECK GOOD.SDR AALA202107067089Lens · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT HANGING DOWN AT SEAT 29C. SECURED EMERGENCY LIGHT LENS IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202107061263Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO OPEN WHEN LOCKING SYSTEM IS DE-ENERGIZED. LUBRICATED COCKPIT DOOR IAW AMM 52-00-00, OPS CHECK GOOD.SDR AALA202107074190Sliding Window · delaminatedAIRCRAFT WAS GROUNDED: COCKPIT L2 WINDOW HAS DELAMINATION IN FORWARD BOTTOM CORNER. REPLACED WINDOW PER JOB CARD 08L21056001.SDR AALA202107074921Slide · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT REAR DOOR SLIDE NEEDS ADJUSTMENT. ADJUSTED SLIDE SCREW PER AMM 52-10-00.SDR AALA202107077484Transducer · out of toleranceAIRCRAFT WAS GROUNDED: ANTISKID INOP LIGHT ILLUMINATED AFTER TAKE OFF. WHEN WE STARTED OUR DESCENT LIGHT WENT OUT AND STAYED OUT FOR REMAINDER OF FLIGHT. TROUBLESHOT PER FIM 32-42-00-810-806. FOUND TRANSDUCER 3 RESISTANCE OUT OF LIMITS. REPLACED PER AMM 32-42-SDR AALA202107074444Connector · looseAIRCRAFT WAS NOT GROUNDED: CEILING EMERGENCY LIGHT AT ROW 12 DEF INOPERATIVE. RESEATED CANNON PLUG FOR EMERGENCY LIGHT AT ROW 12 DEF PER AMM 33-51-00.SDR AALA202107079690Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: SPEED BRAKE WOULD NOT ARM FOR LANDING. NO LIGHTS. DOES NOT DEPLOY ON LANDING. AUTO SPEED BRAKE CIRCUIT BREAKER FOUND OPEN. RESET CIRCUIT BREAKER AND OPERATIONAL CHECK PREFORMED PER AMM 27-67-00.SDR AALA202107075301Access Door · missingAIRCRAFT WAS GROUNDED: AT CRUISE ALTITUDE APU DETECTION INOPERATIVE LIGHT ILLUMINATED INTERMITTENTLY FOLLOWED BY APU FIRE LIGHT / BELL. FOUND APU INLET DUCT ACCESS DOOR COVER ON TOP OF FIRE LOOP. RE-INSTALLED DOOR COVER PER CMM 49-26-93 (AALA202107065301). REPSDR AALA202107072291Processor · failedAIRCRAFT WAS GROUNDED: WEATHER RADAR FAILED IN FLIGHT, FLIGHT RETURNED TO FIELD. REPLACED WEATHER RADAR PROCESSOR WITH SERVICEABLE UNIT IAW AMM 34-41-00, OPS CHECK GOOD.SDR AALA202107073414Bracket · looseAIRCRAFT WAS NOT GROUNDED: BRACKET FOR GIRT BAR AT FORWARD ENTRY DOOR IS LOOSE. ADJUSTED BRACKET AS NEEDED.SDR AALA202107079359Latch · dirtyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY LOCK IS STICKY AND DIFFICULT TO MOVE. CLEANED AND LUBRICATED RIGHT AFT LAVATORY DOOR LOCK PER AMM 25-40-00.SDR AALA202107076071Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: GOT MULTIPLE ERRONEOUS LAVATORY SMOKE INDICATIONS AND ALARMS ON AFT LEFT LAVATORY D. PERFORMED AFT LEFT LAVATORY D ADJUSTMENT TEST ALL CHECKS OK , NO FAULTS NOTED.SDR AALA202107130293Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STIFFENER RADIUS AT STA 663 AND RBL 8, MEASURING L=1.0 IN. REPLACED STIFFENER WITH NEW IAW AARD 51-00-05-1.SDR AALA202107068169Cover · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 15C FLOOR ILLUMINATION LIGHT HAS FALLEN OFF. RE-ATTACHED AND SECURED SEAT 15C EMERGENCY LIGHT COVER PER AMM 33-50-00.SDR AALA202107060520Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AISLE PATH LIGHT NOT ATTACHED PROPERLY AT 20C. RESECURED EMERGENCY EXIT LIGHT AT SEAT 22C PER AMM 33-51-11.SDR AALA202107063285Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED L1 DOOR FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202107029004Interphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT STATION HAS EXTREME DIFFICULTY HEARING FORWARD STATION, FORWARD STATION HEARS AFT VERY WELL. REMOVED AND REPLACED FORWARD FLIGHT ATTENDANT HANDSET PER AMM 23-42-01.SDR AALA202107029008Door · stuckAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR WILL NOT OPEN. RESECURED LEFT AFT LAV DOOR OPS CHECK GOOD IAW CMM 25-40-65.SDR AALA202107029005Cover · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER FALLEN OFF AT 18C. RE-SECURED EXIT LIGHT COVER AT SEAT 18C IAW MM 33-50-00.SDR AALA202107134190Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 277 AND STA 294 AT BL 0, MEASURING L=0.5 IN, W=0.001 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202107019004Light · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT SEAT 11C HANGING DOWN. RE-SECURED ESCAPE PATH LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR AALA202107019003Sign · looseAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY EXIT SIGN OVERHEAD REPORTED LOOSE. SECURED SIGN PER AMM 33-51-00.SDR AALA202107019001Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 SLIDE LIGHT INOPERATIVE. REPLACED POWER SUPPLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202107150253Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED WEB AT RBL 32 AND STA 990. INSTALLED REPAIR TO RIGHT WEB IAW EA 328816, AARD 51-00-05 & SRM 51-40-02.SDR AALA202107132731Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY AT STA 537 BETWEEN BL 0 AND LBL 22, MEASURING L=2.0 IN, W=0.001 IN, D=0.032 IN. REPLACED BREAK ASSEMBLY WITH NEW IAW SRM 51-40-01.SDR AALA202107136378Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL BETWEEN STA 312 AND STA 328 AT LBL 45.60, MEASURING L=0.25 IN, W=0.5 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05-1.SDR AALA202106309004Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT ROW 19, 28, 31, EMERGENCY LIGHT ASSEMBLY DISCONNECTED. REATTACHED FLOOR PROXIMITY LIGHTS AT SEAT 19,28, AND 31 PER AMM 33-51-11.SDR AALA202106309005Retainer · looseAIRCRAFT WAS NOT GROUNDED: CABIN DOOR 1R SLIDE GIRT BAR CLIP LOOSE ON FORWARD SERVICE DOOR. SECURED R1 GIRT BAR CLIP PER AMM 25-66-02.SDR AALA202106309003Slide · failedAIRCRAFT WAS GROUNDED: R1 DOOR EMERGENCY ESCAPE SYSTEM OPERATIONAL CHECK FAILED. REPLACED SLIDE PER AMM 25-66-01.
Back to Boeing 737-823