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 AALA202403272862Sign · brokenAIRCRAFT WAS NOT GROUNDED: AFT ENTRY EXIT SIGN BROKEN.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403273312Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ACCOMPLISHED LUBRICATED FORWARD LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202403274232Wire · detachedAIRCRAFT WAS NOT GROUNDED: WIRE HANGING OUT OF R1 DOOR SLIDE (LEFT SIDE). RESECURED LOOSE WIRE.SDR AALA202403278687Pin · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS A PIN HANGING OUT OF AFT SERVICE DOOR SLIDE CONTAINER. REINSTALLED R2 DOOR SLIDE INFLATION BOTTLE SAFETY PIN INTO POUCH. REINSTALLED R2 DOOR SLIDE. PER M/M 25-66-01. OK FOR CONTINUED SERVICE.SDR AALA202403271486Sliding Window · looseAIRCRAFT WAS GROUNDED: FIRST OFFICER SIDE WINDOW DIFFICULT TO OPEN AND CLOSE. FOUND LOOSE DOOR ROLLER. TIGHTENED ROLLER, PRESSURIZED AND OPERATIONAL CHECKED WINDOW. PER AMM 56-12-11.SDR AALA202403273886Flashlight · missingAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER FORWARD FLIGHT ATTENDANT JUMP SEAT MISSING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403269576Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT WHITE PLASTIC STOPPER ON THE FORWARD SERVICE DOOR GIRT BAR IS MOVING. ADJUSTED GIRT BAR STOPPER.SDR AALA202403269284Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. CHECKED AND ADJUST FORWARD LAVATORY DOOR. FUNCTIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202403261768Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY ENTRY DOOR STICKS AND IS DIFFICULT TO OPEN. LUBRICATED DOOR FUNCTIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202403260050Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER FELL OFF AT 1L DOOR. RESECURED LOOSE COVER ON EXIT SIGN AT 1L. PER AMM 25-00-00.SDR AALA202403265651Shutoff Valve · inoperativeAIRCRAFT WAS GROUNDED: DURING CLIMB NOTICED A FUEL IMBALANCE IN EXCESS OF 1200 LBS. **SUPPLEMENTAL REPORT FOR (AALA202403255651): REMOVED AND REPLACED LEFT MAIN FUEL SCAVENGE FLOAT-OPERATED SHUT-OFF VALVE. PER AMM'S 28-22-16-000-801 AND 28-22-16-400-801 AND ACSDR AALA202403256134Handle · unsecureAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT LAVATORY DOOR HANDLE LOOSE. RESCUED RIGHT AFT LAVATORY DOOR HANDLE. PER CMM 25-40-59SDR AALA202403255819Light · out of adjustAIRCRAFT WAS NOT GROUNDED: EXIT ROW LIGHT FLICKERING (17F). ADJUSTED LIGHT AT EXIT ROW AS REQUIRED. PER AMM 33-50-00.SDR AALA202403254161Door · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS STICKING CLOSED. SECURED LOOSE HARDWARE ON FORWARD LAVATORY DOOR JAMB. OPERATIONAL CHECK NORMAL.SDR AALA202403255651Fuel Sys · out of balanceAIRCRAFT WAS GROUNDED: DURING CLIMB NOTICED A FUEL IMBALANCE IN EXCESS OF 1200 LBS. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403253478Cam · boundAIRCRAFT WAS NOT GROUNDED: DOOR 2L GIRT BAR JAMMED AND WILL NOT ARM. REMOVED STUCK GIRT BAR. OPERATION IS NORMAL. REF MM 52-13-61.SDR AALA202404037910A/C Pack · odorAIRCRAFT WAS GROUNDED: AFTER ENGINE NUMBER 2 START THERE WAS A STRONG FUEL SMELL THROUGHOUT THE FLIGHT DECK AND CABIN WHEN THE RIGHT PACK WAS TURNED ON. ACCOMPLISHED SOF TROUBLE SHOOTING PER J/C 09L00021001 AND ACCOMPLISHED FIM 71-00-00-810-893/894, ALSO ACCSDR AALA202403255808Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D LOCKING LATCH JAMMED MAKING DOOR UNUSABLE. ADJUSTED LAVATORY D LATCH. OPERATIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202403257910Unknown · odorAIRCRAFT WAS GROUNDED: AFTER ENGINE NUMBER 2 START THERE WAS A STRONG FUEL SMELL THROUGHOUT THE FLIGHT DECK AND CABIN WHEN THE RIGHT PACK WAS TURNED ON. (OPEN).SDR AALA202403259390Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: CATERING INFORMED MAINTENANCE THAT WHILE CLOSING THE L2 DOOR, THE DOOR SLIDE FELL OUT OF THE DOOR. INSTALLED SLIDE. PER AMM 25-66-01.SDR AALA202403255383Bulb · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT IN ROW 17, RIGHT SIDE IS FLICKERING. RESECURED EMERGENCY EXIT LIGHT BULB. OPERATIONAL CHECK GOOD PER AMM 33-51-00.SDR AALA202406070379Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERNAL FUSELAGE SKIN FROM STA 727I TO STA 860, FROM S27R TO S 27L. REPAIRED SKIN PER EA 352428.SDR AALA202404093423Rib · wornAIRCRAFT IN BASE MAINTENANCE: WEAR MARKS ON VERTICAL STABILIZER RIB AT BS 1016, WL 308. REPLACED RIB PER AARD 51-00-05-1 .SDR AALA202404037444Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D ENTRY DOOR DIFFICULT TO MOVE IN TRACK.**SUPPLEMENTAL REPORT FOR (AALA202403257444): ADJUSTED AFT LAVATORY-D DOOR AS REQUIRED. OPERTIONAL CHECK GOOD**(CLOSED).SDR AALA202403272587Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344, LBL 44. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202403271155Skin · delaminatedAIRCRAFT WAS GROUNDED: RIGHT WING TRAILING EDGE FLAP DELAMINATED AND DISBONDED. INSTALLED SERVICEABLE INBOARD FLAP WEDGE PER SRM 57-53-01.SDR AALA202403277222Skin · delaminatedAIRCRAFT WAS GROUNDED: LEFT WING INBOARD FLAP LOWER SKIN DELAMINATED. INSTALLED SERVICEABLE INBOARD FLAP WEDGE PER SRM 57-53-01.SDR AALA202403264249Skin · delaminatedAIRCRAFT WAS GROUNDED: RIGHT HAND OUTBOARD T/E FLAP END LOWER SKIN HAS A 1O BY 9 INCH AREA OF DELAMINATION. REMOVED AND REPLACED RIGHT HAND OUTBOARD T/E FLAP. PER AMM 27-51-22.SDR AALA202403268518Windshield · crackedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WINDSHIELD CRACKED AT FLIGHT LEVEL 350; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BHM.**SUPPLEMENTAL REPORT FOR (AALA202403258518): REMOVED AND REPLACED FIRST OFFICER NUMBER 1 WINDSHIELD PER JC 08L210560SDR AALA202403250324Interface Unit · out of rigAIRCRAFT WAS NOT GROUNDED: AFTER TAKE OFF WHILE MOVING GEAR HANDLE FROM UP TO OFF, HANDLE DID NOT CATCH IN THE OFF POSITION. REMOVE AND REPLACED THE LANDING GEAR CONTROL LEVER MODULE. PER AMM 32-31-11. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202403258518Windshield · crackedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WINDSHIELD CRACKED AT FLIGHT LEVEL 350; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BHM.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202403257444Door · stiffAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D ENTRY DOOR DIFFICULT TO MOVE IN TRACK. (OPEN).SDR AALA202403254445Connector · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ESCAPE PATH LIGHT ON SEAT 25ABC INOPERATIVE. REPOSITIONED BACKED OUT PINS 1 AND 2 OF CONNECTOR P2 OF SEAT 24ABC. FUNCTIONAL CHECK GOOD. PER WDM 33-51-22 AND SWPM 20-63-00.SDR AALA202403259883Door · out of adjustAIRCRAFT WAS NOT GROUNDED: ONE OF THE AFT LAVATORY DOOR KNOBS ARE BROKEN ON THE INSIDE OF THE DOOR. ADJUSTED DOOR AS NEEDED, OPERATIONAL NORMAL.SDR AALA202403250239Light · unsecureAIRCRAFT WAS NOT GROUNDED: THE FLOOR EMERGENCY LIGHT FOR ROW 21C HAS POPPED OUT OF ITS SOCKET. RESECURED ROW 21C EMERGENCY FLOOR LIGHT BACK TO ITS SOCKET. FUNCTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202403257411Door Sill · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR HANDLES GETS JAMMED AND IS HARD TO OPEN. ADJUSTED AND LUBRICATED DOOR SILLS LAVATORY DOOR NOW OPENS AND CLOSES NORMALLY. PER AMM 52-50-00.SDR AALA202403259761Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, LBL 44. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403253201Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 270 TO BS 277, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403255069Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404018230Skin Panel · debondedAIRCRAFT WAS NOT GROUNDED: UPPER SURFACE OF LEFT WING FIXED TRAILING EDGE SKIN PANEL 551ET IS DISBONDED. REPAIRED PANEL PER EA 352845A AND SRM 57-51-01-1A-1.SDR AALA202403262998Warning Message · activatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RECEIVED CABIN ALTITUDE ALERT AND MASKS WERE DEPLOYED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MEX. PERFORMED DIGITAL CABIN PRESSURE CONTROLLER (DCPC) BITE PROCEDURE AT NO. 1 AND NO.2 DCPC SDR AALA202403258836Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: FOUND L1 DOOR VERY DIFFICULT TO OPEN AND CLOSE. LUBRICATED L1 DOOR TRACKS PER AMM 12-25-11. DOOR OPERATIONAL CHECK NORMAL. NO LEAKS NOTED PER AMM 05-51-91.SDR AALA202403252317Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR STRUCTURE INTERCOSTAL UPPER SUPPORT ANGLE FROM BS 380 TO BS 400, LBL 14. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202403228230Skin Panel · debondedAIRCRAFT WAS NOT GROUNDED: UPPER SURFACE OF LEFT WING FIXED TRAILING EDGE SKIN PANEL 551ET IS DISBONDED.**SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202403221574Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT ROW 8 KNOCKED OFF SEAT. REATTACHED EMERGENCY LIGHT AT ROW 8 PER AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202404160840Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947 TO BS 967, LBL 26. REPLACED INTERCOSTAL PER SRM 53-70-51-2R PROCEDURE 5.SDR AALA202404014294Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE AT BS 639 , LBL 65. REPLACED CREASE ANGLE PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202403221758Flashlight · missingAIRCRAFT WAS NOT GROUNDED: AFT RIGHT FLIGHT ATTENDANT AISLE FLASHLIGHT MISSING. REPLACED FLASHLIGHT ASSEMBLY PER AMM 25-64-00.SDR AALA202403217895Oven · odorAIRCRAFT WAS GROUNDED: THE #1 OVEN IN THE FOREWORD GALLEY EMITTED A BURNING RUBBER SMELL AND LIGHT SMOKE WHEN OPENED. IT WAS TURNED OFF, AND THE SMELLSTOPPED AND THE TRACE OF SMOKE DISSIPATED. OVEN REMAINED OFF FOR THE REMAINDER OF THE FLIGHT. REMOVED AND REPSDR AALA202403202880Light · damagedAIRCRAFT WAS GROUNDED: L FWD O/W EXIT LIGHT ASSY DMG. A/C REQUIRES MFF FOR REPAIR. CAPPED AND SECURED EMG LIGHT WIRES.
Back to Boeing 737-823