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 AALA201712189026Lens · missingEMERGENCY LIGHT SIGN LENS MISSING BY THE L4 DOOR. REPLACED THE LENS. OPS CHECKED GOOD IAW AMM 33-51-01.SDR AALA20171214008Transmitter · malfunctionedAIRCRAFT WAS GROUNDED: DECLARED EMERGENCY, ON DOWNWIND FLAPS STOPPED AT 1/2 DEGREE WITH LEFT TRANSIT LIGHT ILLUMINATED. MOVED FLAP LEVER BACK TO UP WITH NO MOVEMENT. FOLLOWED QRH PROCEDURE AND MOVED FLAP LEVER BACK TO 1 DEGREE. AFTER LANDING FLAPS MOVED TO 1 DSDR AALA20171214004Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL, BS 500D- 500I. REMOVED AND SPLICED IN NEW TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA201712159030Strap · brokenAIRCRAFT WAS NOT GROUNDED. CABIN DOOR SLIDE ARMED STRAP (ARMING SAFETY STRAP OVER 3R DOOR AFT RIGHT)BROKEN. REMOVED AND REPLACED RED STRAP AS REQUIRED.SDR AALA201712159028Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED. DOOR 1R GIRT BAR DIFFICULT TO ENGAGE AND DOES NOT STAY IN PLACE ONCE ENGAGED IN DISARM POSITION. ADJUSTED 1R DOOR GIRT BAR HANGERS PER AMM 25-66-00. OPERATIONAL CHECK NORMAL. OK FOR SERVICE.SDR AALA201712159027Slide · displacedAIRCRAFT WAS NOT GROUNDED. A SMALL PORTION OF THE FORWARD ENTRY DOOR SLIDE PACK APPEARS TO BE PROTRUDING AT THE BOTTOM OF ITS CONTAINER. INSPECTED FWD ENTRY DOOR SLIDE PACK AND HOUSING. NO FAULTS NOTED PER AMM 25-66-00.SDR AALA20171214006Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON AFT GALLEY AREA SHEAR WEB AT STATION 988 (LBL 33). INSTALLED DOUBLER PER SRM 51-70-13-2R-4.SDR AALA20171214005Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE. AFT CARGO CORROSION AROUND FASTENER HOLE AT BS 727H, ABOVE STRINGER 27 RIGHT. REMOVED CORROSION AND INSTALLED FILLER CHANNEL AND BOTH SPLICE CHANNELS PER SRM 53-00-53-2R.SDR AALA201712159040Lens · unsecureAIRCRAFT NOT GROUNDED. 1R DOOR EXIT LIGHT LENS NOT SECURED. REINSTALLED 1R DOOR EXIT LIGHT LENS PER MM 33-51-00. OPERATIONS CHECK OF EMERGENCY LIGHTS GOOD.SDR AALA201712159033Light · brokenAIRCRAFT WAS NOT GROUNDED. ROW 25FED EMERGENCY PATH LIGHT BASE BROKEN. REPLACED EMERGENCY LIGHT BASE PER AMM 33-51-11. OPERATIONAL CHECK OK.SDR AALA201712159032Light · missingAIRCRAFT WAS NOT GROUNDED. AFT RIGHT SERVICE DOOR EXIT SIGN COVER MISSING. REPLACED EMERGENCY LIGHT AT 4R PER AMM 33-51-00.SDR AALA201712159031Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ILLUMINATION LIGHT LENS COVER AT WALL LAVATORY E CAME OFF. REPLACED EMERGENCY ILLUMINATION LIGHT LENS COVER AS NEEDED.SDR AALA201712159026Lens · damagedEMERGENCY EXIT LIGHT COVER HALFWAY UP THE L4 DOOR DOES NOT STAY ATTACHED. REMOVED THE DAMAGED LENS AND INSTALLED A NEW EMERGENCY EXIT LIGHT LENS ASSY IAW AMM 33-51-00.SDR AALA20171214002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERABLE. REPLACED BATTERY PACK PER AMM 25-64-00.SDR AALA201712159029Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERATVE. REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA201712159039Battery Pack · inoperativeAIRCRAFT NOT GROUNDED. FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK TO FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT PER B-737 AMM 25-64-00.SDR AALA201712149035Sign · damagedAIRCRAFT WAS NOT GROUNDED. CABIN SERVICES REPORTS R-1 DOOR ILLUMINATED EXIT SIGN DAMAGED. REPLACED EMERGENCY EXIT DOOR SIGN PER AMM 33-51-01.SDR AALA201712149034Lens · looseAIRCRAFT WAS NOT GROUNDED. F/A REPORTS EXIT ROW CEILING SIGN NEEDS TO BE SECURED. SECURED LIGHT LENS, OPERATIONS CHECK GOOD.SDR AALA201712149033Screw · pulledAIRCRAFT WAS NOT GROUNDED. THE TWO SCREWS HOLDING THE SLIDE COMPARTMENT TO THE LEFT HAND AFT ENTRY DOOR IS PULLED OUT FROM THE DOORS SCREW ANCHORS. INSPECTED LEFT HAND AFT SLIDE COMPARTMENT DOORS, SCREWS SECURED PER AMM 25-66-01.SDR AALA20171213002Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED INTERCOSTAL IN CABIN AT FORWARD WET AREA, BETWEEN ST 312 TO ST 328 AT LEFT BUTTLINE 46. REPLACED INTERCOSTAL BRACKET ON FORWARD ENTRY BETWEEN STATION 312 TO 328 AT LEFT BUTTLINE 46 PER AARD 51-00-05-1.SDR AALA20171213003Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CABIN, FORWARD WET AREA, INTERCOSTAL BETWEEN STATION 328 AND 344, LBL46 INCHES, IS CRACKED. INSTALLED NEW INTERCOSTAL BRACKET ON FORWARD ENTRY PER AARD 51-00-05-1.SDR AALA201712159002Charger · no testAIRCRAFT WAS NOT GROUNDED: BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS NOT TESTING. MAINTENANCE REPLACED CHARGER AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA20171212001Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS NOT TESTING. MAINTENANCE REPLACED POWER SUPPLY BATTERY PACK AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA201712149036Lens · missingAIRCRAFT WAS NOT GROUNDED. DURING A-CHECK THERE WAS ONE MISSING EMERGENCY LIGHT LENS ON THE CEILING ABOVE ROW 18. REPLACED MISSING EMERGENCY LIGHT LENS PER AMM 33-51-00.SDR AALA201712139007Lens · missingAIRCRAFT NOT GROUNDED. LIGHT CLEAR LENS COVER MISSING AT DOOR 4L AREA. REPLACED LIGHT LENS COVER AT DOOR 4L PER AMM 33-26-01.SDR AALA201712149024Snubber · damagedAIRCRAFT WAS GROUNDED. AT LGA, FOUND L1 ENTRY DOOR WOULD NOT CLOSE AT DEPARTURE. MAINTENANCE FOUND L1 DOOR SNUBBER BROKEN AT ROD END AND LOWER HINGE CUTOUT WAS DAMAGED.SDR AALA20171213001Damper · low pressureAIRCRAFT NOT GROUNDED. L1 DOOR DAMPER PRESSURE LOW, SERVICED DOOR DAMPER TO LIMITS PER AMM.SDR AALA201712139016Connector · disconnectedAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY DOOR SLIDE PACK HAS METAL WIRE PROTRUDING FROM THE LOWER PORTION OF THE SLIDE PACK. SECURED CONNECTOR /PIGTAIL PER AMM 25-60-00.SDR AALA201712139010Lens · missingAIRCRAFT NOT GROUNDED. EXIT SIGN COVER BY1R SERVICE DOOR IS MISSING. REPLACED EXIT SIGN ASSEMBLY AND COVER AT 1R DOOR PER MM 33-51-01.SDR AALA201712139009Battery Pack · inoperativeAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK M1674 AT FORWARD GALLEY CEILING CENTER RIGHT SIDE PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201712139014Cover · missingAIRCRAFT WAS NOT GROUNDED. EXIT SIGN LIGHT COVER MISSING FROM RIGHT SIDE AFT CABIN DOOR. REPLACED EXIT SIGN IDENTIFIER AT RT AFT CABIN DOOR PER AMM 33-51-01.SDR AALA201712139012Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE LIGHT ILLUMINATED ON OVERHEAD PANEL, ACCOMPANIED WITH THE TWO MASTER CAUTION LIGHTS. AFTER FLIGHT ATTENDANTS INVESTIGATED THE RIGHT AFT LAVATORY, FOUND NO EVIDENCE OF SMOKE. THE LIGHT STAYED ON FOR APPROXIMATELY 3MINUTSDR AALA201712129047Vapor Barrier · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CENTER WING LEFT MAIN LANDING GEAR WHEEL WELL HAS AN 8 INCH CRACK AT THE INBOARD END OF THE VAPOR BARRIER. REPAIRED PER AARD 57-10-10-9.SDR AALA201712139008Battery Pack · inoperativeAIRCRAFT NOT GROUNDED. FIRST CLASS EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK M1674 AT FORWARD GALLEY CEILING CENTER RIGHT SIDE PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201712129052Girt Bar · obstructedAIRCRAFT WAS NOT GROUNDED. CABIN DOOR 1R DIFFICULT TO ARM OR DISARM. CLEANED DEBRIS FROM GIRT BAR LOCKS PER AMM 25-66-02. OPERATIONAL CHECK NORMAL.SDR AALA201712129050Light · inoperativeAIRCRAFT WAS NOT GROUNDED. LIGHT BULBS INOPERATIVE, EMERGENCY EXIT LIGHTS NOT ARMED, AND EQUIPMENT COOLING SUPPLY OFF. RELAMPED OVERHEAD EMERGENCY LIGHT AND EQUIPMENT COOLING LIGHT PER MM 33-10-00.SDR AALA201712129017Light · damagedAIRCRAFT WAS NOT GROUNDED. DURING INTERIOR CABIN CHECK, AFT LEFT EXIT LIGHT ASSEMBLY, WAS FOUND DAMAGED. REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712129022Light · damagedAIRCRAFT WAS NOT GROUNDED. DURING INTERIOR CABIN CHECK, RIGHT AFT EXIT LIGHT ASSEMBLY WAS FOUND DAMAGED. REPLACED AFT RIGHT EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK OK.SDR AALA20180114006Floorbeam · corrodedCORROSION ON FLOORBEAM BS 986, RBL 25 TO RBL 46. REPAIRED THE FLOORBEAM IAW SRM 51-10-02.SDR AALA20180114005Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT, BS 952, RBL 25. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02-0G.SDR AALA20180121004Angle · corrodedCORROSION ON THE ZEE ANGLE AT BS 993, RBL 32 TO RBL 46. REPLACED THE ANGLE IAW 53-00-05-1, AND DRAWING 147A5700.SDR AALA201712129051Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT 15F OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED EXIT LIGHT PER AMM 33-51-01. OPERATIONAL CHECK NORMAL.SDR AALA201712119052Light · detachedAIRCRAFT WAS NOT GROUNDED. AFT LEFT EMERGENCY EXIT LIGHT DETACHING. REPLACED AFT LEFT GALLEY SERVICE DOOR L-2 ENTRY EMERGENCY LIGHT ASSEMBLY PER MM 33-51-14.SDR AALA201712129053Counter · meltedAIRCRAFT WAS NOT GROUNDED. BURNING SMELL IN THE LEFT AFT LAVATORY. INSPECTION SHOWED SOMETHING HAS MELTED THE LAW COUNTER. NO EVIDENCE OF FIRE IN AFT LAVATORY ODOR CAUSED BY MELTED COUNTER TOP. OK FOR SERVICE.SDR AALA201712129001Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT LEFT WINDOW INOPERATIVE. RELAMPED EXIT LIGHT AT LEFT WINDOW.SDR AALA20171211001Light · damagedAIRCRAFT WAS NOT GROUNDED. DURING INTERIOR CABIN CHECK FOUND RIGHT AFT EXIT LIGHT ASSEMBLY DAMAGED. REPLACED AFT RIGHT EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712119040Lens · brokenAIRCRAFT NOT GROUNDED. LENS BROKEN ON EXIT IDENTIFIER AT THE FORWARD FLIGHT ATTENDANT SEAT. REPLACED LENS PER AMM 33-51-01.SDR AALA201712119039Lens · brokenAIRCRAFT NOT GROUNDED. LENS IS BROKEN ON THE FORWARD SERVICE DOOR EXIT IDENTIFIER. REPLACED LENS PER AMM 33-51-01.SDR AALA201712119037Girt Bar · stuckAIRCRAFT NOT GROUNDED. 1R SERVICE DOOR GIRT BAR DIFFICULT TO ARM AND DISARM - RIGHT SIDE STICKS. REMOVED GROUND IN DEBRIS FROM RIGHT SIDE FLOOR LATCH FOR GIRT BAR PER AMM 25-66-01 OPERATIONS CHECK GOOD.SDR AALA201712129002Lens · brokenAIRCRAFT WAS NOT GROUNDED. LENS IS BROKEN ON EXIT IDENTIFIER AT THE LEFT AFT GALLEY DOOR. REPLACED LENS PER AMM 33-51-01.
Back to Boeing 737-823