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 AALA202401240373Door · misalignedAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK HARD TO OPERATE. FOUND LAVATORY D DOOR SCREWS LOOSE CAUSING MISALIGNMENT. SECURED SCREWS. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202401247264Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK IS BINDING. LUBED DOOR AND LOCK ASSEMBLY OPERATIONAL CHECK GOOD.SDR AALA202401249525Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN AT 2L DOOR FELL OFF. REMOVED AND REPLACED 2L DOOR EMERGENCY EXIT LIGHT ASSEMBLY. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202401243504Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR IS MISSING SHRINK TUBING FROM THE GIRT BAR.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401249190Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS. LUBED DOOR HINGE OPERATIONAL CHECK GOOD.SDR AALA202401247875Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401249997Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR CAME OFF THE SLIDE AND WILL NOT OPEN OR CLOSE. READJUSTED LAVATORY DOOR. PER CMM 25-40-64. DOOR OPERATES NORMAL.SDR AALA202401241869Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL BETWEEN BS 867 AND BS 887, S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202401242734Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT AFT BULKHEAD CENTER ACCESS PANEL LOWER SUPPORT BRACKET ASSEMBLY AT BS 947.5 FROM RBL 8 TO RBL 15. REPLACED BRACKET PER SRM 51-40-02-0G.SDR AALA202401243069Fuel Sys · malfunctionedAIRCRAFT WAS GROUNDED: UNWANTED FUEL TRANSFER LEFT WING TO CENTER. NOTED THAT WITH ALL PUMPS ON AND CROSSFEED CLOSED THE LEFT WING FUEL INDICATED 7.85,CENTER .30 AND RIGHT WING 8.63.**SUPPLEMENTAL REPORT FOR (AALA202401233069): ACCOMPLISHED FIM 28-21-00-810-80SDR AALA202401243265Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL BETWEEN BS 937AND BS 944, S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202401238755Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HANDLE IS EXTREMELY LOOSE. FEELS LIKE IT'S ABOUT TO FALL OFF. ADJUSTED AND RE-AFFIXED LAVATORY DOOR HANDLE. FUNCTIONAL CHECK NORMAL. PER AMM 25-40-00.SDR AALA202401233069Fuel Sys · malfunctionedAIRCRAFT WAS GROUNDED: UNWANTED FUEL TRANSFER LEFT WING TO CENTER. NOTED THAT WITH ALL PUMPS ON AND CROSSFEED CLOSED THE LEFT WING FUEL INDICATED 7.85,CENTER .30 AND RIGHT WING 8.63.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401231056Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY INSIDE DOOR HANDLE LOOSE. RESECURED FORWARD LAVATORY DOOR HANDLE PER STANDARD PRACTICES.SDR AALA202401231391Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS HARD TO OPEN AND CLOSE. LUBED LAVATORY D DOOR SPRING AND ROLLERS. OPERATIONAL CHECKS NORMAL.SDR AALA202401233339Girt Bar · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 GIRT BAR DIFFICULT TO GET INTO GIRT BAR RETAINER. REPAIRED GIRT BAR SLIDE BUSTLE MATERIAL. PER AARD 25-66-00-04.SDR AALA202401234209Fitting · out of positionAIRCRAFT WAS NOT GROUNDED: L2 DOOR GIRT AND SLIDE HANGS LOW AND DRAGS FLOOR. REMOVED L2 SLIDE. CHECKED GRIT BAR FITTING GOT CLEARANCE TO INSTALL L2 DOOR SLIDE. PER AMM 25-66-01 AND COMPLETED SLIDE INSTALL. CHECKED MEASUREMENTS ON GIRT BAR FOUND TO BE WITHIN LISDR AALA202401232097Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOD CEILING LIGHT AT CLASS DIVIDER RIGHT SIDE INOPERATIVE. CONNECTED CANNON PLUGS FOR EMERGENCY FLOOD CEILING LIGHT AT CLASS DIVIDER RIGHT SIDE. PER SWPM 20-64-12. OPERATIONAL CHECKS GOOD.SDR AALA202401234014Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR WON'T OPEN. ADJUSTED AND LUBED DOOR OPERATIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202401239136Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR LEFT SIDE OF FORWARD SERVICE IS DIFFICULT TO REMOVE FROM BRACKET. REMOVED DEBRIS AND LUBED FORWARD SERVICE DOOR FORWARD GIRT BAR BRACKET. OPERATIONAL CHECK GOOD. PER GPM 17.11.4.SDR AALA202401236650Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS DID NOT EXTEND TO 30 WHEN SELECTED. AIRCRAFT DIVERTED AND LANDED SAFELY AT LCH WITHOUT FURTHER INCIDENT. TROUBLESHOOT PER FIM 27-51-00-810-803. ALL TESTING SHOWS PROPER OPERATION AND NO FAULTS INDISDR AALA202401250833Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL AT BS 500D, RBL 27. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202401236797Shroud · unsecureAIRCRAFT WAS NOT GROUNDED: FA ATTENDANT REPORTS EXPOSED WIRING AT SEAT 15C. RESECURED SEAT 15C SIDE ESCAPE PATH LIGHTING SHROUD. OPERATIONAL CHECK GOOD. PER CMM 25-23-67.SDR AALA202401220410Housing · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 29C EMERGENCY PATH LIGHT HOUSING IS BROKEN. REMOVE AND REPLACED EMERGENCY PATH LIGHT HOUSING. PER AMM 33-51-11.SDR AALA202401226721Oven · fireAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FIRE IN THE FORWARD GALLEY OVEN CAUSED SMOKE AND FUMES IN AIRCRAFT. AIRCRAFT DIVERTED AND LANDED SAFELY AT IAH WITHOUT FURTHER INCIDENT. ACCOMPLISHED JOB CARD 08L00021001. FIRE WAS INSIDE OVEN. NO DAMAGESDR AALA202401228970Scuff Plate · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS VERY STICKY AND DIFFICULT TO OPERATE. DOOR LATCH ALSO DIFFICULT TO OPERATE. CLEANED AND LUBED LAVATORY D LOWER SILL SCUFF PLATE AREA.SDR AALA202401223812Door Sill · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR, BOTTOM LEFT CORNER STICKING; MAKING THE DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED LOOSE DOOR SILL.SDR AALA202401229136Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL AT STA 500E, S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202401231452Door · out of positionAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY (LAVATORY D) DOOR DIFFICULT TO OPEN OR CLOSE. ALSO DIFFICULT TO LOCK DOOR WHEN INSIDE. RESET DOOR INTO TRACK.SDR AALA202401222356Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR IS HARD TO OPEN AND CLOSE. ADJUSTED AND LUBED AFT LAVATORY D DOOR PER AMM 25-40-00.SDR AALA202401227815Holder · missingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR EXIT SIGN MISSING. LOCATED AND INSTALLED LIGHT COVER. PER STANDARD PRACTICES.SDR AALA202401223567Slide · out of positionAIRCRAFT WAS NOT GROUNDED: R2 DOOR SLIDE PACK GETTING CAUGHT ON DOOR FRAME WHEN ATTEMPTING TO CLOSE DOOR, MATERIAL HANGING DOWN TOO FAR FROM SLIDE PACK. REMOVED AND REPLACED R2 DOOR SLIDE. PER AMM 25-66-01-400-803.SDR AALA202401225387Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: CHRONIC REPEAT FOR LAVATORY E DOOR LATCH DIFFICULT TO OPERATE. REMOVE AND REPLACED LAVATORY E DOOR LATCH. PER CMM 25-40-59.SDR AALA202401225294Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK IS NOT WORKING. ADJUSTED LEFT HAND LAVATORY DOOR LOCK, OPERATIONAL CHECK NORMAL. PER CMM 25-40-64.SDR AALA202401227980Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT ATTENDANT NOTIFIED FLIGHT DECK OF A FAINT ELECTRICAL BURNING SMELL COMING FROM LAVATORY D. AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. ACCOMPLISHED WORK CARD 09L00021001. NO ODOR NOTEDSDR AALA202401221842Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT AT BS 537.45, RBL 24. REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202401224433Track · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS STICKING. RE-SECURED AND CLEANED DOOR TRACK PER CMM 25-40-59.SDR AALA202401227913Pitot Tube · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT ELEVATOR PITOT LIGHT CAME ON DURING FLIGHT AIRCRAFT RETURN TO AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED RIGHT ELEVATOR PITOT PROBE. PER AMM 27-31-94 ACCOMPLISHED ALL RSDR AALA202401226334Tube · missingAIRCRAFT WAS NOT GROUNDED: HEAT SHRINK ON R1 DOOR SLIDE REQUIRES DEFERRAL DUE TO PARTS NIS. INSTALLED NEW RED HEAT SHRINK TUBING IN R1 DOOR. PER AARD 25-66-00-4-E-516SDR AALA202401223750Ballast · corrodedAIRCRAFT WAS NOT GROUNDED: DURING WALK AROUND FOUND SURFACE CORROSION ON LEFT HAND WING LEADING EDGE WING BALLAST. REPAIRED SURFACE CORROSION ON LEFT HAND LEADING EDGE BALLAST. PER AARD 57-20-20.SDR AALA202401223386Pressure Deck · crackedAIRCRAFT WAS NOT GROUNDED: 0.375 INCH CRACK IN VERTICAL PRESSURE DECK WEB BETWEEN RBL 40 TO 45.64. PERFORMED REPAIR PER SRM 57-10-10-2R-3 REPAIR 3 TABLE 205/REPAIR 3.SDR AALA202401225877Door · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR HARD TO CLOSE AND HARD TO OPEN, GETTING STUCK. FOUND THE LAVATORY DOOR LOOSE. ADJUSTED THE LEFT LAVATORY DOOR. PER AMM 25-40-15.SDR AALA202401220252Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAP FAILED AT FLAPS 10 POSITION DURING FINAL APPROACH TO LANDING. USED ALTERNATE FLAP SYSTEM SUCCESSFULLY. AIRCRAFT LANDED SAFELY AT STL WITHOUT FURTHER INCIDENT. PERFORMED FIM TASK 27-51-00-810-820 NO SDR AALA202402061010Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947 TO BS 67, RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202402061263Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 947 TO BS 967, RBL 40. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202401259662Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN INTERCOSTAL FROM BS 327 TO BS 344, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202401256201Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BOARD SUPPORT AT BS 540, LBL 1. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA202401244247Panel · bentAIRCARFT IN BASE MAINTENANCE: MAIN CABIN FLOOR PANEL SUPPORT UPPER SHIM IS BENT UP AT BS 540, FROM LBL 24.75 TO LBL 45.5. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02-0GSDR AALA202401227887Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM BS 767 TO BS 787, S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202401229832Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STRINGER CLIP AT BS 500G, S26L. REPLACED STRINGER CLIP PER AARD 51-40-02-0G.
Back to Boeing 737-823