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 AALA202405157469Slide · dislodgedAIRCRAFT WAS GROUNDED: L1 DOOR STUCK OPEN AND SLIDE FELL OUT. REMOVED AND REPLACED EMERGENCY SLIDE AT L1 DOOR. PER WORK CARD 08L22125001.SDR AALA202405153327Collar · missingAIRCRAFT WAS NOT GROUNDED: RED COLLAR ON 1L DOOR GIRT BAR IS MISSING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405200396Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BOARD SUPPORT BREAK ASSEMBLY PANEL AT STA 538, LBL 1. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202405204154Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BOARD SUPPORT BREAK ASSEMBLY PANEL AT STA 538, RBL 1. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202405169828Target · out of positionAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAP TRANSIT LIGHT ILLUMINATED WITH FORWARD SLAT 6 INDICATING OUT OF POSITION WHEN FLAPS 30 SELECTED; AIRCRAFT LANDED SAFELY AT MSP. INSTALLED NEW TARGET IN CORRECT POSITIONS, REPAIR CONFISDR AALA202405158631Switch · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THE LANDING GEAR WOULD NOT RETRACT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA.**SUPPLEMENTAL REPORT FOR (AALA202405148631): REMOVED AND REPLACED MANUAL SYSTEM ACCESS DOOR SWSDR AALA202405144969Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS ON THE BOTTOM SKID PLATE MAKING IT HARD TO OPEN AND CLOSE. READJUSTED LAVATORY DOOR A SKID PLATE. FUNCATIONAL CHECK GOOD. PER AMM 25-40-11.SDR AALA202405149504Air Filter · dirtyAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, MUSTY DIRTY SOCK SMELL FROM MID CABIN TO THE FLIGHT DECK. RECIRULATION FILTERS CHANGED. PER JOB CARD 08C1221001.SDR AALA202405149828Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAP TRANSIT LIGHT ILLUMINATED WITH FORWARD SLAT 6 INDICATING OUT OF POSITION WHEN FLAPS 30 SELECTED; AIRCRAFT LANDED SAFELY AT MSP. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405143917Tat Probe · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AUTO PILOT HORN SOUNDED, FLIGHT DIRECTORS FAILED, AUTOTHROTTLES FAILED, AND AUTO TILT FAILED APPEARED ON THE RADAR; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. REPLACED TAT PROBE. ADIRU'S BITE CHECK GSDR AALA202405148631Landing Gear · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THE LANDING GEAR WOULD NOT RETRACT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405157581Door · bindingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR WILL NOT OPEN OR CLOSE FULLY. REPLACED LEFT AFT LAVATORY BI-FOLD DOOR LOWER TRIM PIECE. DOOR OPERATES NORMAL NOW. PER CMM 25-40-64.SDR AALA202405150072Door · bindingAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED DOOR SIL, OPERTIONAL CHECK GOOD. PER SRM 51-40-00.SDR AALA202405148073Floorboard · damagedAIRCRAFT WAS NOT GROUNDED: FLOOR BOARD IS SOFT BETWEEN ROW 18 AND ROW 19. ACCOMPLISHED REPAIRED. PER AARD 53-00-00-6 REPAIRED 6.SDR AALA202405137581Door · bindingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR WILL NOT OPEN OR CLOSE FULLY.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405137564Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHT AT 30C HANGING LOOSE. REPOSITIONED AND SECURED EMERGENCY LIGHT ASSEMBLY AT 30C. PER AMM 33-51-00.SDR AALA202405130072Door · stiffAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405131387Sign · unsecureAIRCRAFT WAS NOT GROUNDED: 12C EMERGENCY EXIT LIGHT COVER HANGING. RESECURED EMERGENCY EXIT COVER. PER AMM 33-50-00.SDR AALA202405136294Faucet · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING TAKEOFF, SINK FAUCET BROKE OFF IN FORWARD LAVATORY, CAUSING WATER TO SPRAY ALL OVER LAVATORY, LEAK OUT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. INSTALLED FORWARD LAVATORY FAUCETSDR AALA202405132637Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D LOCK DIFFICULT TO OPERATE. REMOVE AND REPLACED LAVATORY-D DOOR. PER CMM 25-40-58.SDR AALA202405131038Windshield · crackedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT FLIGHT LEVEL 340 CAPTAIN WINDSHIELD CRACKED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BNA. REPLACED CAPTAINS WINDSHIELD. PER J/C 08L21056003.SDR AALA202405145796Relay · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AUTO FAIL ON PRESSURIZATION PANEL ILLUMINATED AT FL 370; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. REMOVED AND REPLACED AUTO FAIL RELAY R557 (AALA202405135796) AND R556 (AALA202405144425). PER WDMSDR AALA202405144425Relay · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AUTO FAIL ON PRESSURIZATION PANEL ILLUMINATED AT FL 370; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. REMOVED AND REPLACED AUTO FAIL RELAY R557 (AALA202405135796) AND R556 (AALA202405144425). PER WDSDR AALA202405138737Cradle · no testAIRCRAFT WAS NOT GROUNDED: BOTH FIRST CLASS FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. REMOVED AND REPLACED BOTH FIRST CLASS FLIGHT ATTENDANT FLASHLIGHT MOUNTING BRACKETS (AALA202405138737 AND AALA202405131519). OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202405131519Cradle · no testAIRCRAFT WAS NOT GROUNDED: BOTH FIRST CLASS FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. REMOVED AND REPLACED BOTH FIRST CLASS FLIGHT ATTENDANT FLASHLIGHT MOUNTING BRACKETS (AALA202405138737 AND AALA202405131519). OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202405135796Cabin Pressure · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AUTO FAIL ON PRESSURIZATION PANEL ILLUMINATED AT FL 370; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405136196Lamp · burned outAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NO INDICATION FOR RIGHT MAIN GEAR; AIRCRAFT LANDED SAFELY AT DFW. RELAMPED RIGHT HAND MLG INDICATOR LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-18-00.SDR AALA202405133641Slide · unsecureAIRCRAFT WAS GROUNDED: FORWARD SERVICE DOOR SLIDE HAS EXTRA MATERIAL PROTRUDING FROM THE BOTTOM OF THE SLIDE PACK. REMOVED AND REPLACE R1 DOOR SLIDE. PER CARD 08L22125001.SDR AALA202405131700Door · sticksAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-E DOOR STICKS AND IS DIFFICULT TO OPEN OR CLOSE. REMOVED AND REPLACED LAVATORYE-DOOR. PER AMM 25-40-14-401.SDR AALA202406249796Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727J TO STA 767, RBL 27. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406103672Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD (T-CAP) OF FLOORBEAM AT STA 986, LBL 48. REPAIRED CHORD PER SRM 53-70-51-2R.SDR AALA202405149357Bracket · detachedAIRCRAFT WAS NOT GROUNDED: 32C EMERGENCY ESCAPE PATH LIGHT ASSEMBLY BRACKET FALLEN OFF. NO FAULT NOTED.SDR AALA202405132856Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LOWER RAIL ASSEMBLY AT STA 500I, FROM S25R TO S25L. REPLACED RAIL PER SRM-51-40-02-0G.SDR AALA202405109357Light · detachedAIRCRAFT WAS NOT GROUNDED: 32C EMERGENCY ESCAPE PATH LIGHT ASSEMBLY BRACKET FALLEN OFF.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406217117Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY, LEFT FORWARD, FLOOR MOUNT AT STA 986, LBL 32. REPLACED FLOOR MOUNT PER AARD 51-00-05-1.SDR AALA202405140884Control Panel · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: (MCP) MODE CONTROL PANEL FAILED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. REMOVED AND REPLACED MCP (AALA202405090884), PER AMM 22-11-34. MCP FAULT CLEARED BUT CAME ACROSS FAULT BUS PWR CONTROL UNSDR AALA202405140325Bpcu · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: (MCP) MODE CONTROL PANEL FAILED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. REMOVED AND REPLACED MCP (AALA202405090884), PER AMM 22-11-34. MCP FAULT CLEARED BUT CAME ACROSS FAULT BUS PWR CONTROL UNISDR AALA202405141172Control Unit · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: (MCP) MODE CONTROL PANEL FAILED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. REMOVED AND REPLACED MCP (AALA202405090884), PER AMM 22-11-34. MCP FAULT CLEARED BUT CAME ACROSS FAULT BUS PWR CONTROL UNISDR AALA202405149254Control Panel · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRST OFFICER SIDE FLIGHT DIRECTOR AND COURSE SELECTION ON (MCP) MODE CONTROL PANEL WENT OUT AT 4000 AND CAME BACK INTERMITTENTLY; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. REMOVED AND REPLACED MCSDR AALA202405146992Tube · missingAIRCRAFT WAS GROUNDED: RED HEAT SHRINK NOT INSTALLED ON R1 DOOR EMERGENCY ESCAPE SLIDE GIRT BAR. INSTALLED RED HEAT SHRINK ON R1 DOOR EMERGENCY ESCAPE SLIDE GIRT BAR. PER AARD 25-66-00-4.SDR AALA202405090884Control Panel · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: (MCP) MODE CONTROL PANEL; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY. (OPEN).SDR AALA202405099254Control Panel · intermittentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRST OFFICER SIDE FLIGHT DIRECTOR AND COURSE SELECTION ON (MCP) MODE CONTROL PANEL WENT OUT AT 4000 AND CAME BACK INTERMITTENTLY; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MSY.**SUPPLEMENTAL REPORT WILLSDR AALA202405097597Pump · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FUEL IMBALANCE DURING FLIGHT, REBALANCED BUT FUEL WOULD NOT STOP TRANSFERING ONCE PUMP TURN OFF; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. SUCCESSFULLY TRANSFERRED FUEL, FQIS BITE CHECK,SDR AALA202405096410Track · dislodgedAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS AND IS DIFFICULT TO MOVE. FOUND LAVATORY-D DOOR TOP ROLLER OUT OF TRACK, PUT ROLLER BACK IN TRACK. OPERTIONAL CHECKS GOOD. PER CMM 25-40-58.SDR AALA202405094823Roller · dislodgedAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS STICKING AND HARD TO OPERATE. FOUND LAVATOR- D DOOR TOP ROLLER OUT OF TRACK, PUT ROLLER BACK IN TRACK. . OPERTIONAL CHECKS GOOD. PER CMM 25-40-58.SDR AALA202405099504Sliding Window · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER WINDOW OPENS AND CLOSES TOO TIGHTLY. CLEANED AND LUBED WINDOW TRACKS AND OPERATING MECHANISM. FUNCATIONAL CHECK GOOD. PER AMM 56-12-11,SDR AALA202405091244Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR 1R DIFFICULT TO ARM AND DISARM, SPECIALLY THE RIGHT SIDE. ADJUSTED GRIT BAR 1R DOOR. PER AMM 25-66-02.SDR AALA202405096992Tube · missingAIRCRAFT WAS GROUNDED: RED HEAT SHRINK NOT INSTALLED ON R1 DOOR EMERGENCY ESCAPE SLIDE GIRT BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405149841Anti-Skid Valve · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING GEAR RETRACTION AFTER TAKEOFF ANTI-SKID INOPERATIVE LIGHT ILLUMINATED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT LAX. REPLACED RIGHT HAND WHEEL WELL ALTERNATE ANTI-SKID VALVE, LEAK CHECK GOOD. PSDR AALA202405099841Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING GEAR RETRACTION AFTER TAKEOFF ANTI-SKID INOPERATIVE LIGHT ILLUMINATED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT LAX. (OPEN).
Back to Boeing 737-823