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 AALA20190429003Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR "Z" ANGLE BETWEEN BS 991 AND BS 992 AT LBL 32. REPLACED "Z" ANGLE PER 51-00-05-1AND SRM 51-40-02.SDR AALA201904309004Control Lever · lack of lubeAIRCRAFT WAS NOT GROUNDED: ON GEAR EXTENSION, ALL GEAR GREEN LIGHTS, BUT HORN AND ALL RED GEAR LIGHTS ALSO ILLUMINATED. RAN QRH CHECKLIST AND LANDED UNEVENTFULLY. MAINTENANCE FOUND LANDING GEAR CONTROL LEVER STICKY, CLEANED AND LUBRICATED LEVER IN PER FIM 32-3SDR AALA201904309007Smoke Warning · false activationAIRCRAFT WAS NOT GROUNDED: SMOKE LIGHT ILLUMINATED SMOKE ALARM IN LAVATORY E, AFT RIGHT. SMOKE ALARM WAS RESET AND SMOKE LIGHT WENT OUT. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK OF SMOKE DETECTOR IN RIGHT AFT LAVATORY PER AMM 26-14-00.SDR AALA201904309003Smoke Warning · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE LIGHT ILLUMINATED WITH ASSOCIATED CHIME FOR 2 TO 3 MINUTES, THEN LIGHT AND CHIME STOPPED. MAINTENANCE ACCOMPLISHED LAVATORY SMOKE DETECTION SELF TEST PER AMM 26-14-00, NO FAULTS NOTED.SDR AALA201905029020Flashlight · faultyAIRCRAFT WAS NOT GROUNDED: FORWARD JUMPSEAT FLIGHT ATTENDANT FLASHLIGHT DID NOT HAVE A RED LIGHT. MAINTENANCE INSTALLED NEW FLASHLIGHT PER STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019043099033Proximity Sensor · faultyAIRCRAFT WAS GROUNDED: CREW REPORTS FLAPS INDICATION ISSUE ON APPROACH. EMERGENCY WAS DECLARED. FLIGHT WAS NOT OVERWEIGHT, LANDED WITHOUT INCIDENT. LE FLAPS TRANSIT LIGHT IN FLIGHT. MAINTENANCE FOUND O/B #6 L/E PROX SW FAULTY. REPLACED LE SLAT #6 OUTBOARD SENSSDR AALA201904309025Striker · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WOULD NOT OPEN FROM THE CABIN SIDE, WITH CODE, WOULD ONLY OPEN FROM COCKPIT SIDE. MAINTENANCE CLEANED AND ADJUSTED COCKPIT DOOR ELECTRIC STRIKE PER MM 52-51-03-400-80 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904309009Skin · crackedAIRCRAFT WAS NOT GROUNDED: LEFT HAND SIDE OF RUDDER NEAR TOP CONDUCTIVE FRAME ON RUDDER SKIN LOOSE AND CRACKED. REPAIRED CONDUCTIVE FRAME ON RUDDER SKIN PER SRM 55-40-01-2R.SDR AALA201904299004Hose · leakingAIRCRAFT WAS GROUNDED: PILOT REPORTS L1 DOOR WATER LEAK , BAD ODOR. MAINTENANCE REMOVED AND REPLACED L1 DOOR Y HOSE ASSY IAW AMM 38-31-00. NO LEAKS NOTED. OK FOR SERVICE.SDR AALA201904299002Heater · fodAIRCRAFT WAS GROUNDED: F/A'S REPORTED WHITE SMOKE AND STRONG ELECTRICAL BURNING SMELL FROM AFT GALLEY. RAN QRH SMOKE/FIRE/FUMES CHECKLIST SMOKE DISSIPATED. MAINTENANCE FOUND DEBRIS IN THE AFT DOOR AREA HEATER. REMOVED AND REPLACED THE HEATER. OPS TEST GOOD IAWSDR AALA201904296003Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND FORWARD ENTRY DOOR CUTOUT CREASE BEAM BETWEEN BS 312 AND BS 344. REPLACED CREASE BEAM PER AARD 51-00-05-1.SDR AALA201904296002Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND FORWARD ENTRY DOOR CUTOUT CREASE BEAM BETWEEN BS 312 AND BS 344. REPLACED CREASE BEAM PER 51-00-05-1.SDR AALA201904296005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA LEFT HAND CREASE BEAM ANGLE BETWEEN BS 947 AND BS 1016. REPLACED CREASE BEAM ANGLE PER AARD 51--05-1.SDR AALA201904296004Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT ENTRY DOOR CUTOUT CREASE BEAM ANGLE BETWEEN BS 887 AND BS 1016. REPLACED CREASE BEAM ANGLE PER AARD 51-10-05SRM 51-40-02.SDR AALA201904296001Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET ARE FLOOR RIGHT HAND "K" WEB BETWEEN BS 986.5 AND BS 1016. REPLACED "K" WEB PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA2019042979002Battery · no testAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT LED FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904295008Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT STATION 157.10 AND 11" FROM THE FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA201904295007Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR HALF MOON WEB BETWEEN BS 1018 AND BS 1020, BETWEEN LBL 32 AND LBL 35. REPLACED WEB PER AARD 51-00-05-1.SDR AALA201904295006Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 992, BETWEEN RBL 32 AND RBL 45. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA201904295005Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR RIGHT HAND HALF MOON WEB AT BS 1016. REPLACED WEB PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA201904295004Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR STRAP AT BS 1006 AND RBL 25. REPLACED STRAP PER SRM 51-40-02.SDR AALA201904295003Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR STRAP AT BS 1006 AND RBL 18. REPLACED STRAP PER SRM 51-40-02.SDR AALA201904295002Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR STRAP AT BS 1006 AND RBL3. REPLACED STRAP PER SRM 51-40-02.SDR AALA201904269031Bulkhead Web · crackedAIRCRAFT WAS NOT GROUNDED: LEFT WHEEL WELL VAPOR BARRIER CRACKED AT BS 663 AND LBL 45.64. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA201904254008Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT STATION 92.70. REPAIRED HORIZONTAL STABILIZER LOWER SURFACE SKIN PER SRM 55-10-01-2R-11.SDR AALA201904254007Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT STATION 147.90. REPAIRED HORIZONTAL STABILIZER LOWER SURFACE SKIN PER SRM 55-10-01-2R-11.SDR AALA201904254006Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT BETWEEN BS 992 AND BS 1016 AT RBL 32. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA201904254005Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 328 AND BS 344 AT LBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA201904254004Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 312 AND BS 328 AT LBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA201904254003Stiffener · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU INLET AREA HORIZONTAL STIFFENER BETWEEN BS 1088 AND BS 1156. REPLACED STIFFENER PER SRM 51-10-02 AND AARD 51-00-05.SDR AALA201904254002Stiffener · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU COMPARTMENT VERTICAL STIFFENER AT BS 1125. REPLACED STIFFENER PER SRM 51-10-02 AND AARD 51-00-05.SDR AALA201904259003Pin · shearedAIRCRAFT NOT GROUNDED: MAINTENANCE FOUND THE FWD ENTRY DOOR LEFT SIDE GUIDE ARM MOUNTING PIN SHEARED, (GUST LOCK PIN). MAINTENANCE REPLACED PIN AND HARDWARE IAW AMM 52-11-21. OPS CHECK GOOD.SDR AALA201904249010Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT ON SEAT ROW 29, RIGHT HAND WAS INOPERATIVE. RESEATED/LOCKED PIN ON CONNECTOR 0201875-003 AT SEAT ROW 29 PER SWPM B737 20-42-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER B737 AMM 33-51-00.SDR AALA201904243006Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT STATION 129.50 AND 18" FROM THE AFT SPAR. REPAIRED HORIZONTAL STABILIZER LOWER SURFACE SKIN PER SRM 55-10-01-2R-11 FIGURE. 204 SHEET 6 DETAIL F.SDR AALA201905099029Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED VAPOR BARRIER ON THE AFT SIDE OF THE LEFT HAND ESC BAY NEAR BOTTOM OF STIFFENER AT LBL 31.83. REPAIRED PER SRM 57-10-10-2R-2 AND 57-10-9.SDR AALA201905099028Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN VAPOR BARRIER ON AFT SIDE OF RIGHT HAND ESC BAY NEAR BOTTOM STIFFENER AT RBL 15.54. REPAIRED PER SRM 57-10-10-2R-2 AND 57-10-10-9.SDR AALA201904242007Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE BETWEEN BS 500E AND BS 500F CRACKED. REPLACED BAFFLE PER AARD51-00-05-1 AND AARD 53-00-01-6.SDR AALA201904242006Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 344 AND BS 360 AT LBL 10. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201904242005Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND LBL 1. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA201904242004Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND RBL 1. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA201904239001Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED: UNCOMMANDED AUTOTHROTTLE DISCONNECTED. IT APPEARS THE RIGHT THROTTLE STICKS AND LEFT RETARDS WITH A DISCONNECT. FOUND FAULT CODE 22-31525 IN A/T BITE TEST. ACCOMPLISHED FIM TASK 22-31-00. GRD TEST NORMAL.SDR AALA2019042329025Fire Loop · unreliableAIRCRAFT WAS GROUNDED: RETURNED TO PHL ON ACCOUNT OF WHEEL WELL FIRE INDICATION AFTER TAKEOFF. CREW DECLARED AN EMERGENCY. FLIGHT LANDED WITHOUT INCIDENT, TAXIED TO THE GATE UNDER OWN POWER. MAINTENANCE REMOVED AND REPLACED THE SHORT FIRE LOOP IN THE WHEEL WELSDR AALA201904229008Door · faultyAIRCRAFT WAS NOT GROUNDED: L2 DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE LUBRICATED L2 DOOR UPPER GUIDE ARM ROLLER AND GUIDE PLATE TRACKS PER MCM 2502 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 52-13-00.SDR AALA2019042329001Engine · fireAIRCRAFT NOT GROUNDED: PILOT REPORTS AFTER GATE ARRIVAL IN KIN, AND ENGINES AND APU SHUTDOWN. GROUND CREW REPORTED FIRE IN #'2 ENGINE. THERE WAS NO FIRE OR OVERHEAT INDICATION IN COCKPIT. FIRE WENT OUT, DURATION UNKNOWN, BUT LESS THAN 5 MINUTES CONTINUED. AISDR AALA201904229003Computer · faultyAIRCRAFT WAS GROUNDED: DURING DECENT IN VNAV MODE AIRCRAFT SUFFERED UNCOMMANDED ELEVATOR INPUTS FROM THE AUTO PILOT. THESE UNCOMMANDED INPUTS WERE MODERATE, AUTO PILOT CMD - A THE FIRST ONE WAS PASSING 25,000 FEET THE SECOND ONE WAS PASSING 18,000 FEET. ACCSDR AALA2019042329043Indicator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON APPROACH TO SAN THE LEADING EDGE FLAPS AND TRAILING EDGE FLAPS FAILED TO EXTEND, HYD PRESSURE NORMAL, FOLLOWED QRH PROCEDURES. MAINTENANCE ACCOMPLISHED BITE TEST OF FSEU AND FOUND MSG 27-58400 T/E FLAP INDICATION. ACCOMPSDR AALA2019042329002Control Unit · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON APPROACH TO SAN THE LEADING EDGE FLAPS AND TRAILING EDGE FLAPS FAILED TO EXTEND, HYD PRESSURE NORMAL, FOLLOWED QRH PROCEDURES. MAINTENANCE ACCOMPLISHED BITE TEST OF FSEU AND FOUND MSG 27-58400 T/E FLAP INDICATION. ACCOMPSDR AALA2019042219005Battery Pack · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY PACK M01695 FAILED CAP. TEST IAW WORK CARD 2908. ACCOMPLISHED DEEP CYCLE PROCEDURE IAW AMM 33-51-06, TASK 600-802. OPS CHECK NORMAL.SDR AALA201904219003Battery Pack · weakAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY PACK MO1672 IN AFT GALLEY R/H CEILING FAILED CAPACITY TEST IAW CARD 2908. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IN THE R/H AFT GALLEY IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR AALA201904229006Track · dirtyAIRCRAFT NOT GROUNDED: FO'S R2 SLIDING WINDOW DIFFICULT TO OPEN WONT OPEN ALL THE WAY. REMOVED DEBRIS FROM SLIDING WINDOW TRACK OPS CKS NORMAL OK FOR SERVICE.
Back to Boeing 737-823