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 AALA201902121003Door Sill · corrodedCORROSION ON THE FORWARD CARGO DOOR CUTOUT LOWER THRESHOLD SILL BETWEEN BS 440 AND BS 492 AT S25R. REPLACED THE DOOR SILL IAW RD 51-00-05-1, AND SRM 51-40-02.SDR AALA201902121001Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO LEFT TRANSITION PANEL BETWEEN BS 500C AND 500I, S25L. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA201902129010Stop Fitting · damagedAIRCRAFT WAS NOT GROUNDED: DURING A CHECK INSPECTION THE DOOR STOP PLATE BEARING PAD WAS FOUND TO BE DAMAGED ON THE L1 DOOR AFT SIDE BETWEEN S11L AND S13L. REPLACED DOOR STOP PLATE PER AMM 52-11-01.SDR AALA201902119020Shaft · wornFLIGHT RETURNED DUE TO AN AFT LEFT SERVICE DOOR INDICATION. EMERGENCY DECLARED. FLIGHT LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED, LEFT AFT CABIN DOOR HANDLE MOVES FREELY WITH DOOR CLOSED AND CABIN PRESSURIZED. REMOVED AND REPLACED L2 DOOR SHAFT SDR AALA201902119001Smoke Detector · malfunctionedRIGHT AFT LAVATORY SMOKE ALARM WILL NOT TURN OFF. RESET THE RT AFT LAVATORY SMOKE DETECTOR IAW FIM 26-14-00. OPS CHECKED GOOD.SDR AALA201902109012Skin · crackedRIGHT WING LEADING EDGE SLAT NR 8, LOWER SURFACE SKIN CRACKED AT ACTUATOR RIB FITTING. REPLACED THE SLAT.SDR AALA2019021209006Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 344 AND 360, LBL 11.5. IN THE CABIN. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA2019021209005Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328 AT RBL 31. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA2019021208009Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 993 BETWEEN RBL 33 AND RBL 46. REPLACED THE ANGLE IAW SRM 51-10-02, AND RD 51-00-05-1.SDR AALA2019021208008Angle · corrodedLEFT CREASE ANGLE HAD CORROSION BETWEEN BS 985 AND 995. REPLACED THE ANGLE IAW RD 51-00-05.SDR AALA2019021208007Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 1015, LBL 31. REPLACED THE ANGLE IAW SRM 51-10-02, AND RD 51-00-05-1.SDR AALA20190208006Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE BETWEEN BS 986 AND 1016, RBL 32. REPLACED THE ANGLE IAW RD 51-00-05-1.SDR AALA2019021208005Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 460 AND 500. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND 51-40-01.SDR AALA2019021208004Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO BAY, LEFT TRANSITION PANEL BETWEEN BS 727 AND 847. REPLACED TRANSITION PANEL IAW SRM 53-00-53-2R 5.SDR AALA201902109003Actuator · faultyAIRCRAFT WAS GROUNDED: UNCOMMANDED AILERON MOVEMENT LEFT TRIM WHEN TESTED TO THE LEFT. MAINTENANCE REPLACED AILERON TRIM ACTUATOR PER AMM 27-11-54 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201902119009Battery · no testAFT LT, F/A EMERGENCY FLASHLIGHT FAILED TO TEST. REPLACED THE BATTERY IN THE FLASHILIGHT IAW AMM 25-64-00. OPS CHECK GOOD.SDR AALA201902119008Battery · no testAFT RIGHT F/A EMERGENCY FLASHLIGHT FAILED TO TEST. REPLACED THE BATTERY IN THE FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR AALA201902119002Engine · leakingREPORT FROM F/A DURING TAXI OUT, MULTIPLE PAX OBSERVED FLAMES FROM BOTTOM OF LEFT WING IN THE VICINITY OF THE ENGINE. THE AIRCRAFT WAS GROUNDED. ACCOMPLISHED INSPECTION FOUND NO DAMAGE OR EVIDENCE OF FIRE. FOUND OIL POOLING IN EXHAUST PLUG CAUITY, OIL COSDR AALA201904059022Valve · faultyAIRCRAFT WAS GROUNDED: 10 MINUTES AFTER SECURING LEFT PACK PER BLEED TRIP, QRH PROCEDURE, CABIN ALTITUDE WARNING SOUNDED. EMERGENCY DECLARED, DONNED THEIR O2 MASKS (NO CABIN O2 MASK DEPLOYED) AND DIVERTED TO MIA. FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTESDR AALA201902089002Sensor · faulted10 MINUTES AFTER SECURING LEFT PACK IAW BLEED TRIP, QRH PROCEDURE, CABIN ALTITUDE WARNING SOUNDED. EMERGENCY DECLARED, DONNED THEIR OXYGEN MASKS AND DIVERTED FLIGHT, LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED 450 SENSOR PER AMM 36-11-05 AND REPLACSDR AALA201903159021Flap · faultyDURING TAKEOFF, A MINOR VIBRATION WAS NOTED, LIKE A TIRE OUT OF BALANCE. AFTER RETRACTING THE LANDING GEAR, THE ANTI-SKID INOPERATIVE LIGHT ILLUMINATED AND THE NR 2 MAIN LANDING GEAR SEPERATED. THE -A- HYDRAULICS QUANTITY WAS AT 42 AND DECREASING. AN EMERGSDR AALA201902109007Battery · dischargedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND ON BOARD AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT OUT OF PLACE AND BATTERY DEAD. MAINTENANCE REPLACED BATTERY PER AMM 25-64-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201902087006Stringer · corrodedCORROSION FOUND ON THE STRINGER 24L AT BS 887. REPAIRED THE STRINGER IAW SRM53-00-03-2R-1, AND EA 289771.SDR AALA201902087005Stringer · crackedCRACKED STRINGER 24L BETWEEN BS 888 AND 889. REPAIRED THE STRINGER IAW SRM 53-00-03-2R-1, AND EA 289809.SDR AALA201902109010Slide · unsecureAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT DISARMED FORWARD EXIT DOOR, UPON GATE ARRIVAL, BUT AFTER OPENING THE DOOR THE SLIDE BAR FELL OUT AND GOT STUCK WITH THE SLIDE PARTIALLY OUT. MAINTENANCE REPLACED L1 DOOR SLIDE PER AMM25-66-01 AND PERFORMED SATISFACTORY OSDR AALA201902086007Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE: RIGHT TRANSITION PANEL IN FORWARD CARGO COMPARTMENT CORRODED BETWEEN STATIONS 500-500A. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND EA 289835.SDR AALA201902086006Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE: RIGHT TRANSITION PANEL IN FORWARD CARGO COMPARTMENT CORRODED BETWEEN STATIONS 500A-500I. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA201902086005Shield · corrodedCORROSION ON THE AFT CARGO BAY LOWER SHIELD ASSEMBLY BETWEEN BS 767 AND 787, STRINGER 25R. REPLACED THE SHIELD IAW RD 51-00-05-01, AND EA 289855.SDR AALA201902086004Transition Panel · corrodedCORROSION ON THE AFT CARGO BAY, RIGHT TRANSITION PANEL BETWEEN BS 727J AND 747, STRINGER 25R. REPLACED TRANSITION PANEL IAW RD 51-00-05-01.SDR AALA201902079003Vapor Barrier · crackedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND WHEEL WELL FORWARD BULKHEAD VAPOR BARRIER CRACKED NEAR FAIRINGS AT BOTTOM. REPAIRED PER 57-10-10.SDR AALA201902079005Slide · defectiveAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT NOTICED FIRING MECHANISM CABLE HANGING OFF SLIDE PACKAGE, SIMILAR TO A PLUG (4PIN) THAT ATTACHED TO INTERNAL PART OF SLIDE PACKAGE. MAINTENANCE REPLACED L1 DOOR SLIDE PER MCM 25-94-10 AND PERFORMED SATISFACTORY OPERATIONSDR AALA201902069013Connecting Rod · out of adjustTHE AIRCRAFT WAS NOT GROUNDED. FLIGHT SPOILERS 8 AND 9 START DEPLOYING AT 1.4 TO 1.5 UNITS RIGHT WING DOWN AILERON INPUT CONSISTENTLY. MAINTENANCE OBSERVERS DE-BRIEFED. ADJUSTED RATIO CHANGER INPUT ROD PER AMM 27-61-00. SPOILERS LIFT AT 1.8. OPERATIONS CHECK GSDR AALA201902059002Fmc · malfunctionedBOTH FLIGHT MANAGEMENT COMPUTER SYSTEMS FAILED DURING DESCENT. CAPTAIN'S NAVAGATION DISPLAY MAP BLANKED, MAP FLAGS, WITH NO REFERENCE SPEEDS ON CAPTAIN'S SIDE. AFTER SEVERAL MINUTES CAPTAIN'S SIDE RETURNED AND FIRST OFFICERS SIDE FAILED FOR THE REMAINING SEVESDR AALA201902069014Relay · malfunctionedTHE AIRCRAFT WAS GROUNDED. RIGHT HAND CENTER LOW PRESSURE LIGHT ILLUMINATED AFTER TAKEOFF. ONE CENTER TANK FUEL BOOST PUMP USABLE. REMOVED AND REPLACED RELAY R55 IAW FIM 28-22-00-810-802. CENTER TANK RIGHT FUEL PUMP OPS CHECK NORMAL.SDR AALA201902069024Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL WEB AT BS 304 AND S22L. REPAIRED INTERCOSTAL WEB PER EA 289129SDR AALA20190205005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CHORD ANGLE AT BS 305 AND S22L. REPAIRED CHORD ANGLE PER EA 289129.SDR AALA201902069003Bladder · odorCREW AS WELL AS PASSENGERS REPORTED A STRONG ODOR IN THE CABIN. DIFFICULT TO ISOLATE SOURCE, IT SMELLED LIKE HUMAN WASTE AND/OR VOMIT. ODOR INTENSIFIED AFTER TAKEOFF. THE AIRCRAFT WAS GROUNDED. MAINTENANCE ACCOMPLISHED MCM 05-96-70, AND MCM 38-94-14. REMOSDR AALA201902059001Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: GUST LOCK ON L1 DOOR WAS HARD TO OPERATE. MAINTENANCE CLEANED AND LUBED AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-00.SDR AALA201902059004Unknown · odorFUME EVENT STARTED AFTER TAKE OFF, SMOKE ODOR IN COCKPIT. EMERGENCY WAS DECLARED, FLIGHT RETURNED TO DEPARTURE AND LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. MAINTENANCE ACCOMPLISHED MCM 05-96-70, NO DISCREPANCIES OR ODOR FOUND. RAN ENGINESDR AALA201902054006Floorbeam · corrodedCORROSION FOUND ON THE CABIN FLOORBEAM AT BS 947, LBL 50. REPAIRED THE FLOORBEAM IAW EA 289534.SDR AALA201902049014Smoke Detector · false activationLEFT AFT LAVATORY SMOKE DETECTOR AURAL INDICATION, SMOKE UNCONFIRMED. ACCOMPLISHED AN OPS CHECK OF THE LAV SMOKE DETECTOR IAW AMM 26-14-00. NO DEFECTS NOTED. OK FOR SERVICE.SDR AALA201902049028Contact · brokenON INSPECTION OF THE EMERGENCY LIGHTS, FOUND THE EXIT SIGN AT THE L2 DOOR HAD FAILED TO ILLUMINATE. FOUND A BROKEN CONTACT AT CONNECTOR D10084. TERMINATED A NEW CONTACT IAW SWPM 20-30-12. OPS TESTED GOOD.SDR AALA201902052003Floorbeam · corrodedCORROSION FOUND ON THE FLOORBEAM AT BS 947, RBL 5. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R.SDR AALA201902049012Fmc · malfunctionedBOTH FMCS FAILED SIMULTANEOUSLY FOR ABOUT 1 MINUTE AND THEN RESUMED NORMAL FUNCTION. DURING THE FAILURE MENU PAGE DISPLAYED AND NEITHER FMC FUNCTIONED. PERFORMED FIM FIM 34-61-00 AND AMM 34-61-00, OPS CHECKED NORMAL. COULD NOT DUPLICATE.SDR AALA201902049011Director · failedLOST BOTH FLIGHT DIRECTORS AFTER TAKEOFF. SELECTED ROLL AND PITCH MODES ON CLEAN UP AND FLIGHT DIRECTOR INFORMATION WAS REGAINED. ACCOMPLISHED FIM 34-21-00, ADIRU BITE, AND FIM 22-11-00 DFCS BITE. ALL TESTED GOOD. NO FAULTS NOTED.SDR AALA201902049024Door · unknownL1 DOOR DIFFICULT TO OPEN . F/A ADVISED PILOTS IT WAS AS IF THE CABIN HAD RESIDUAL PRESSURE. FWD ENTRY DOOR OPS CHECKED GOOD, OK FOR CONTINUED SERVICE IAW AMM 52-11-00.SDR AALA201902039008Skin · crackedLEFT WING NR 1 SLAT LEADING EDGE NOSE SKIN WAS CRACKED, AT THE LOWER ACTUATOR RIB FITTING. THE AIRCRAFT WAS GROUNDED. REPLACED SLAT IAW TC 27994-05.SDR AALA201902039007Slat · crackedAIRCRAFT WAS GROUNDED: LEFT WING #2 SLAT LEADING EDGE NOSE SKIN CRACKED AT THE LOWER ACTUATOR RIB FITTING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN)SDR AALA201902054004Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN WAS FOUND CRACKED AT HSS 129.50. REPAIRED THE SKIN IAW RD 55-10-00-2SDR AALA201902049026Compensator · leakingAIRCRAFT WAS GROUNDED: DEPARTED WITH APPROXIMATELY 24.1 POUNDS ON CLIMB OUT WITH ALL TANK PUMPS ON AND FUEL TRANSFER FEED CLOSED. THEN STARTED LOSING FUEL OUT OF THE RIGHT TANK. GOT UP TO 8000 FEET, EMERGENCY DECLARED AND FLIGHT RETURNED TO MIA, LANDING OVERW
Back to Boeing 737-823