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 AALA201906139001Fire Detector · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS FIRE WARNING ILLUMINATED IN FLIGHT. NO OTHER INDICATIONS OF FIRE. HAPPENED 3 TIMES DURING FLIGHT. MAINTENANCE REPLACED #2 ENGINE RIGHT AND LEFT CORE DETECTORS IAW FIM 26-10-00. BITE CHECKS GOOD PERFORMED OPERATIONAL TEST ISDR AALA2019061219002Fuel Sys · malfunctionedAIRCRAFT WAS GROUNDED: PILOT REPORTS BOTH WING TANKS FEED 400 LBS THEN STOP WITH CENTER FUEL PUMPS ON. AFTER FEEDING 400LBS OUT OF WINGS, ALL FUEL FEED IS OK. MAINTENANCE ACCOMPLISHED WORK CARD 28-26-00, OPS CHECK GOOD. ALSO ACCOMPLISHED FQIS BITE TEST NO FAULSDR AALA201906119006Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA201906109007Sill Drain · odorAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR 1L SILL DRAIN ODOR. MAINTENANCE ADDED BIOZYME AT 1L DOOR SILL DRAIN PLUGS PER AMM 38-35-00, NO FAULTS NOTED.SDR AALA201906099009Hinge · dirtyAIRCRAFT WAS NOT GROUNDED: L1 DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE CLEANED AND LUBRICATED L1 DOOR HINGES AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-00.SDR AALA201907029046Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT STRAP BETWEEN BS 772.6 AND BS 774.6 AT S24L, REPLACED FLOOR SUPPORT STRAP PER 51-00-05-1.SDR AALA201906259006Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR SUPPORT (TEE) AT BS 887 AND S27L. REPLACED FLOOR SUPPORT PER SRM 53-00-53.SDR AALA201906179034Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 950 BETWEEN RBL 27 AND RBL 47. FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA2019061109014Sensor · failedAIRCRAFT WAS GROUNDED: PILOT DECLARED EMERGENCY INBOUND TO ORD ON ACCOUNT OF FLIGHT CONTROL ISSUES. FLIGHT LANDED WITHOUT INCIDENT. ON APPROACH, NO FLAPS, NO SLATS. RAN CHECKLIST. USED ALT FLAPS SWITCH GOT LEADING EDGE SLATS. DID NO FLAP LANDING. 188-190 TOUCHSDR AALA2019061089004Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD MEGAPHONE INOPERABLE. MAINTENANCE REPLACED MEGAPHONE PER AMM 25-64-00.SDR AALA2019061099008Spring · stickingAIRCRAFT WAS GROUNDED. PILOT REPORTS GUST LOCK ON MAIN ENTRANCE DOOR STICKS AND IS DIFFICULT TO OPERATE. MAINTENANCE REPLACED ASSITS LEVER SPRING ON L1 DOOR IAW AMM 52-11-21. OPS CHECKED GOOD.SDR AALA201906179037Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR INTERCOSTAL BETWEEN BS 947 AND BS 967 AT RBL 51. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA201906179035Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR INTERCOSTAL BETWEEN BS 947 AND BS 967 AT RBL 51. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA201906179033Torque Box · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU TORQUE BOX LEFT HAND LOWER CHORD BETWEEN BS 1088 AND BS 1156. REPAIRED CHORD PER EA 294911.SDR AALA2019061089005Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT BATTERY AND SEAL PER AMM 25-64-00.SDR AALA201906079004Antenna · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING APPROACH FOR LANDING AFTER EXTENDING LANDING GEAR, HAD UNSAFE GEAR INDICATED . ALL THREE GEAR LIGHTS GREEN /RED. COMPLIED WITH QRH AND ATTEMPT AT LOWERING THE LANDING GEAR. HAD ALL THREE GREEN SAFE INDICATIONS. MAINTSDR AALA201906179038Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 951 BETWEEN LBL 18 AND LBL 22. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA201906179036Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR SUPPORT AT BS 950 BETWEEN LBL 24 AND LBL 43. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1SDR AALA201906069002Warning Light · no indicationAIRCRAFT WAS GROUNDED: PILOT REPORTS ON TAKEOFF, AFTER ROTATION, FLAPS 1 AND FLAPS UP BUGS DISAPPEARED FROM BOTH PFDS WITH VERIFY GW MESSAGES IN SCRATCHPAD. GW WAS MANUALLY INPUT PRIOR TO T/O. MAINTENANCE ACCOMPLISHED PSEU BITE TEST IAW MM 32-09-10. FOUND FAULSDR AALA201906069001Warning Light · false activationAIRCRAFT WAS NOT GROUNDED: SLOWING FROM 300 KNOTS TO 250 KNOTS, ON THE DESCENT 3 RED LIGHTS DISPLAYED AND LANDING GEAR WARNING HORN SOUNDED FOR APPROXIMATELY 5 SECONDS. MAINTENANCE ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER FIM TASK 32-09-00, NO FAULTS NOSDR AALA201906069010Floor Panel · buckledAIRCRAFT NOT GROUNDED: CARPET AROUND ROW 12 HAS LARGE BUMP. REMOVED AND REPLACED CENTER AISLE FLOOR BOARD AT SEATS 11C AND 11D IAW AMM 52-21-00.SDR AALA201906259007Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 35. REPLACED INTERCOSTAL.SDR AALA201906059007Turbine Blades · damagedAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING ROTATION, A FLOCK OF BIRDS IMPACTED ENGINE #1 SUBSEQUENTLY DAMAGING 5 TURBINE BLADES. EMERGENCY RETURN TO JFK. NORMAL LANDING. UNDER MAX LANDING WEIGHT. SLIGHT ODOR NOTICED DURING ROLL OUT. MAINTENANCE DECLARED AN ESDR AALA20190605001Stiffener · crackedHORIZONTAL STIFFENER IN RH AC BAY PACK ON VAPOR BARRIER STA.663 FWD SIDE IS CRACKED IB END, REPALCED HORIZONTAL STIFFENER IAW 51-00-05 AND BOEING DRAWING 144A7100 AND 111A1000 AND 111A1001.SDR AALA201906049002Windshield · failedAIRCRAFT WAS GROUNDED: WINDSHIELD SHATTERED ON DEPARTURE AT 18,000 FEET. EMERGENCY DECLARED, FLIGHT DIVERTED TO SFO, AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REMOVED AND REPLACED FO SIDE WINDSHIELD IAW CARD 56-94-04. ALL OPS CHECKS GOOD.SDR AALA2019060549006Indicator · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS AFTER TAKE OFF IN CLIMB, RIGHT FUEL QUANTITY DROPPED 700 POUNDS LOWER THAN LEFT QUANTITY WITH FUEL IN CENTER TANK. REMAINED 700 LOWER FOR BALANCE OF FLIGHT. MAINTENANCE ACCOMPLISHED ADJ/TESTS OF FUEL QTY IAW AMM 28-41-00. SDR AALA201906059005Computer · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS AFTER TOUCH DOWN, THE SPOILERS DEPLOYED THEN RETRACTED, THE THROTTLE ADVANCED, THEN THE SPOILERS DEPLOYED AGAIN. THEN THE PSEU LIGHT CAME ON FOR A FEW MINUTES THE EXTINGUISHED. MAINTENANCE REPLACED THE FCC IAW AMM 22-11-33.SDR AALA201906049003Fuel Sys · malfunctionedAIRCRAFT WAS GROUNDED: DURING CRUISE, TOTAL FUEL MINUS FUEL USED DIFFERED BY AS MUCH AS 1,900 LBS. FMC FUEL PREDICTION DURING CRUISE TO DECENT DIFFERED BY AS MUCH AS 1800 LBS. TRANSFERRED 3 TIMES TO KEEP FUEL BALANCED. MAINTENANCE ACCOMPLISHED SATISFACTORY OPESDR AALA2019060539001Processor · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS WHILE ENROUTE IN ANU WHILE BURNING FUEL FROM CENTER TANK, RIGHT MAIN TANK QUANTITY DECREASED VERY SLOWLY TO ABOUT 500 LBS IMBALANCE BALANCE TANK STABILIZED. NO NOTICEABLE ROLL IN AIRCRAFT UPON GATE ARRIVAL. IMBALANCE DECREASDR AALA201906032006Angle · corrodedAIRCRAFT IN BASE VISIT: INSPECTION FOUND CORROSION IN THE AFT WET AREA SUBFLOOR, AT THE LOWER R2 DOOR CUTOUT INNER CHORD ANGLE. MAINTENANCE REMOVED AND REPLACED WITH NEW THE R2 DOOR LOWER CUTOUT INNER CHORD CREASE ANGLE.SDR AALA201906032005Angle · corrodedAIRCRAFT IN BASE VISIT: INSPECTION FOUND CORROSION IN THE AFT WET SUBFLOOR AREA, ON THE L2 DOOR LOWER INNER CHORD ANGLE. MAINTENANCE REMOVED AND REPLACED WITH NEW THE L2 DOOR LOWER INBOARD CREASE/CHORD ANGLE.SDR AALA201906032004Intercostal · corrodedAIRCRAFT IN BASE VISIT: INSPECTION FOUND CORROSION IN THE AFT WET AREA SUBFLOOR AT STA 950 LBL 25, ON INTERCOSTAL 147A5660-3. MAINTENANCE REMOVED AND REPLACED WITH NEW THE INTERCOSTAL AT STA .950. LBL 25.SDR AALA201906032003Floorbeam · corrodedAIRCRAFT IN BASE VISIT: INSPECTION FOUND CORROSION IN THE AFT CABIN WET AREA SUBFLOOR STA 986.5 LBL 55 THRU RBL 55 ON THE FLOOR BEAM TOP FLANGES. TULSA MAINTENANCE REMOVED AND REPLACED WITH NEW THE STA 986.5 FLOOR BEAM UPPER FLANGES IAW THE SRM REPAIR.SDR AALA201906032002Floorbeam · corrodedAIRCRAFT IN BASE VISIT: INSPECTION FOUND CORROSION IN THE AFT WET AREA SUBFLOOR ON THE 947 FLOOR BEAM AT THE INBOARD AFT LAV MOUNT. TULSA MAINTENANCE REMOVED THE CORROSION IN THE AFT WET AREA SUBFLOOR ON THE 947 FLOOR BEAM AT THE INBOARD AFT LAV MOUNT WITH A SDR AALA2019060439002Socket · odorAIRCRAFT WAS GROUNDED: AFTER LANDING STRONG ELECTRICAL ODOR REPORTED IN AFT LEFT LAVATORY. MAINTENANCE TROUBLESHOT AND FOUND LEFT AFT LAVATORY LIGHT ASSEMBLY TO HAVE A BURNT SOCKET AND REPLACED BAD SOCKET. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK PSDR AALA2019061989021Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM AT BS 947 BETWEEN LBL 5 AND RBL 10. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6.SDR AALA201906069012Power Unit · contaminatedAIRCRAFT NOT GROUNDED: PILOT REPORTS DURING FLIGHT, CREW WAS ALERTED TO ISSUE AT SEAT 18B. CREW OBSERVED WHAT APPEARED TO BE WHITE SMOKE COMING FROM SEAT. CREW TOOK PRECAUTIONS WITH FIRE EXTENGUISHER. CAPT. WAS ADVISED. POWER TO ENTERTAINMENT SYSTEM WAS HALTEDSDR AALA2019060319002Engine · fireAIRCRAFT WAS GROUNDED: PILOT REPORTS WHEN THRUST APPLIED TO THE #1 ENGINE, FLAMES SHOT OUT THE EXHAUST 10 FEET, A DEADHEAD CAPT IN THE CABIN SAID HE COULD HEAR A SLIGHT POP WHEN THRUST WAS APPLIED. MAINTENANCE ACCOMPLISHED FIM TASK 71-05-00-810-811-F00 STEP DSDR AALA2019060319003Power Port · overheatedAIRCRAFT WAS GROUNDED: PILOT DECLARED EMERGENCY ON ACCOUNT OF ELECTRICAL /PLASTIC BURNING SMELL MID CABIN. COULD NOT LOCATE SOURCE. SMELL INCREASED AS WE DESCENDED. MAINTENANCE ACCOMPLISHED CARD 05-96-70 737-NG SMOKE/ODOR FUMES INITIAL TROUBLESHOOTING. FIRE DSDR AALA2019060319004Unknown · odorAIRCRAFT WAS GROUNDED: PILOT ABORTED T/O AT 75 KIAS AT GW OF 149.5 DUE TO SMOKE ENTERING COCKPIT. SMOKE ENTERS COCKPIT AND CAN BE SMELLED IN CABIN WHEN ENGINES ARE OVER APPROX. 45-50%. SMOKE HAS OILY SMELL TO IT. MAINTENANCE ACCOMPLISHED CARD 05-96-07 & AMM 2SDR AALA2019060319018Cover · out of adjustAIRCRAFT WAS NOT GROUNDED: 1R SLIDE BUSTLE COVER APPEARED SKEWED LOW AND LEFT. MAINTENANCE ADJUSTED SLIDE COVERING AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201905319005Warning System · false activationAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING APPROACH WHEN LANDING GEAR WAS SELECTED DOWN RED AND GREEN LIGHTS ILLUMINATED ON MAIN PANEL, OVERHEAD PANEL SHOWED 3 GREEN LIGHTS. AFTER GO AROUND, GEAR WAS CYCLED AND NORMAL LANDING GEAR INDICATION DISPLAYED. MAINTESDR AALA2019060319001Fire Detector · faultedAIRCRAFT NOT GROUNDED: PILOT REPORTS FWD CARGO FIRE LIGHT ILLUMINATED ERRONIOUSLY. TEST BUTTON HOLD IN LIGHT GOES OUT AFTER TEST BUT THEN COMES BACK ON. MAINTENANCE WORKING THIS EVENT. MAINTENANCE FOUND THE FWD CARGO #2 SMOKE DETECTOR LOOP B FAULTED. REMOVED SDR AALA201906039041Circuit Board · burnedAIRCRAFT WAS GROUNDED: CAPTAIN REPORTED A PERSISTENT ODOR LASTING 120 MINUTES WAS NOTICED DURING CLIMB/CRUISE/DESCENT/APPROACH/LANDING/TAXI-IN. A CHEMICAL/MILD SULFUR ODOR NOTICED FROM ROW 7 TO ROW 30. MAINTENANCE PERFORMED CARD 05-96-70. NO FINDINGS DURING ENSDR AALA201905319011Battery · unserviceableAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT BATTERY UNSERVICEABLE AT FORWARD FLIGHT ATTENDANT SEAT. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA20190529003Panel · crackedAIRCRAFT IN BASE VISIT: INSPECTION FOUND A CRACKED MID CABIN BREAKER PANEL AT STA 540, LBL 2-24. MAINTENANCE REMOVED AND REPLACED WITH NEW THE BREAKER PANEL 143A5240-36 IN THE MID CABIN AT STA 540, LBL 2-24.SDR AALA20190529004Panel · crackedAIRCRAFT IN BASE VISIT: INSPECTION FOUND A CRACK IN THE MID CABIN SUBFLOOR BREAKER PANEL STA540 RBL2-24. MAINTENANCE REMOVED AND REPLACED WITH NEW THE RT BREAKER PANEL ASSY AT STA 540 RBL 2-24 MID CABIN SUBFLOOR.SDR AALA20190529006Web · corrodedAIRCRAFT IN BASE VISIT: INSPECTION FOUND CORROSION ON THE L2 DOOR ENTRY WAY LOWER WEB AT HEAVY C INSPECTION. MAINTENANCE REMOVED AND REPLACED THE L2 DOOR CUTOUT LOWER WEB ASSY.SDR AALA20190529007Baffle · damagedAIRCRAFT IN BASE VISIT: FORWARD CARGO AREA: LEFT HAND BAFFLE DAMAGED DURING MAINTENANCE VISIT. STATION 500D TO STATION 500E, AT STRINGER 25L. REMOVED AND REPLACED BAFFLE, IN ACCORDANCE WITH REPAIR DOCUMENT 51-00-05, REPAIR 1. AND DRAWING 143A7505.SDR AALA20190529009Angle · corrodedAIRCRAFT IN BASE VISIT: CORROSION ON APU INLET AT STA.1088 UPPER ANGLE, REPLACED UPPER ANGLE IAW AARD51-00-05 AND DRAWING 148A0924.
Back to Boeing 737-823