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 AALA201905299001Fuel · contaminatedAIRCRAFT WAS GROUNDED: PILOT REPORTS POSSIBLE UNCOMMANDED FUEL TRANSFER FROM RIGHT MAIN TANK TO CENTER TANK OF 500LBS DURING INITIAL CLIMB WITH FUEL IN ALL 3 TANKS AND ALL FUEL PUMPS ON FUEL DECREASED 500 LBS ON RT MAIN TANK INDICATION. A COMPARISON OF FUEL USSDR AALA201905299010Switch · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SWITCH BROKEN INSIDE AUTO OFF SWITCH, WILL NOT TOGGLE OFF. MAINTENANCE REPLACED SWITCH GUARD PER SWPM 20-83-11.SDR AALA20190528001Fitting · corrodedAIRCRAFT IN BASE VISIT:INSPECTION FOUND CORROSION ON THE MAIN ENTRY DOOR GIRT BAR FITTINGS IN THE FORWARD CABIN SUBFLOOR WET AREA. MAINTENANCE REMOVED AND REPLACED WITH NEW BOTH L1 ENTRY DOOR GIRT BASE FITTINGS AT STA. 312 AND STA. 344 PN. 141A5220-4/5SDR AALA201905299002Unknown · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS AUTO THROTTLE UNCOMMANDED DISCONNECT IN FLIGHT. TRIED TO RE ENGAGE AND DID NOT WORK. MAINTENANCE ACCOMPLISHED FIM PROCEDURE AND AMM ADJ / TESTS FOR A/TS SEVERAL TIMES. ALL TESTS PASSED (NO FAULTS) IAW FIM 23-31-00 AND IAW SDR AALA20190527004Threshold · corrodedAIRCRAFT IN BASE VISIT: FWD CARGO: FORWARD CARGO DOOR THRESHOLD AREA HAS SEVERAL AREAS OF CORROSION. INSTALLED SILL WEB IAW DWG#14A8330 AND 51-00-05.SDR AALA20190527005Transition Panel · corrodedAIRCRAFT IN BASE VISIT: FWD CARGO: RT TRANSITION PANEL HAS NUMEROUS AREAS OF CORROSION ON UPPER SURFACE AND AROUND FASTENER HOLES BETWEEN STA. 500A-500I. INSTALLED RT TRANSITION PANEL FROM STA. 500A-500I IAW SRM 53-00-53-2R-5.SDR AALA20190527006Transition Panel · corrodedAIRCRAFT IN BASE VISIT: LT AFT CARGO TRANSITION PANEL CORRODED STA. 727B - 807. , FINISHED INSTALLATION OF NEW TRANSITION ANGLE FROM STA 727C+10 TO STA 807 IAW SRM 53-00-53-2R, 51-00-05-1, AND DRAWING #146A7502.SDR AALA20190527007Torque Box · corrodedAIRCRAFT IN BASE VISIT: AFT. CARGO DOORWAY TORQUE BOX UPPER WEB HAS AREAS OF CORROSION STA. 804-840, NEW WEB IS INSTALLED IAW SRM 53-13-05.SDR AALA201905289002Turnbuckle · shearedAIRCRAFT WAS NOT GROUNDED: LEFTHAND FORWARD EMERGENCY SLIDE, FORWARD SUPPORT TURNBUCKLE END SHEARED AT TOP END OF UPPER ATTACH BRACKET. MAINTNENANCE REPLACED SLIDE FORWARD SUPPORT LINK PER IPC 25-24-56 AND AMM 25-24-40.SDR AALA201907019065Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOORBEAM AT BS 986.5 BETWEEN LBL 50 AND RBL 50. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-4.SDR AALA201905289001Ballast · arcedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY LIGHT BALLAST ARCING, L1 DOOR. MAINTENANCE REPLACED FORWARD ENTRY LIGHT BALLAST (M1679) PER AMM 33-29-00.SDR AALA201905279005Fire Bottle · faultyAIRCRAFT WAS NOT GROUNDED: AFT FIRE BOTTLE NEEDED TO BE REPLACED. MAINTENANCE REPLACED FIRE BOTTLE PER AMM 26-20-00.SDR AALA201905279003Warning System · false activationAIRCRAFT NOT GROUNDED: PILOT REPORTS INTERMITTENT SYSTEM FAILURE WARNINGS ILLUMINATED ON THE HUD COMBINER THE DURATION OF THE WARNINGS WERE JUST 1-2 SECONDS. THE FIRST OFFICER HUD ANNUNCIATOR PANEL ALSO ILLUMINATED SYSTEM FAIL BUT ALSO JUST FOR 1-2 SECS. ALL HSDR AALA201905279007Sliding Window · out of adjustAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS CAPTS SLIDING L2 WINDOW VERY DIFFICULT TO OPEN AND CLOSE. MAINTENANCE ADJUSTED L2 WINDOW IAW AMM 56-12-11.SDR AALA201905279006Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT EMERGENCY FLASHLIGHT, SEAT DOOR 4R, INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER MM 33-20-00.SDR AALA201905269013Warning System · false activationAIRCRAFT WAS NOT GROUNDED: TAKEOFF CONFIGURATION LIGHT HORN ILLUMINATED ON INTITIAL TAKE OFF ROLL. ABORTED TAKE OFF AT VIRTUAL STANDOFF. MAITNENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 31-51-00.SDR AALA201905269012Pressure Switch · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS UNCOMMANDED FUEL TRANSFER / BURN OUT OF #1 WING TANK AT APPROX 200 PPH VERIFIED BY CONSTANT NEED TO ADD LEFT RUDDER TRIM TO COUNTERACT . 500 POUND SPLIT IN LESS THEN 3 HRS. MAINTENANCE REMOVED AND REPLACED LT AFT BOOST PUMPSDR AALA201905239011Antenna · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS DESCENDING TO 12000, PASSING 13,500 AT 293 KNOTS, AUTO PILOT AND AUTOTHROTTLES ENGAGED, LNAV-VNAV PATH. IN CRUISE CONFIGURATION, WE GOT 3 RED GEAR LIGHTS AND HORN FOR APPROXIMATEY 3-4 SECONDS. THEN NORMAL. ALL INDICATIONS NSDR AALA20190522005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR CUT OUT CREASE ANGLE BETWEEN BS 294 AND BS 348, BETWEEN RBL 51 AND RBL 53. REPLACED CREASE ANGLE PER 51-00-05-1.SDR AALA20190522001Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 277 AND BS 294 AT BL 0. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA201905229010Wire · brokenAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT ABOVE ROW 15 FAILS TO COME ON. SPLICED WIRE AT EMERGENCY LIGHT ABOVE ROW 15 IAW SWPM 20-30-12 AND 33-51-13. OPS NORMAL IAW AMM 25-21-45.SDR AALA201905239009Bracket · looseAIRCRAFT WAS NOT GROUNDED: AFT GIRT BAR BRACKET ON FORWARD SERVICE DOOR WAS LOOSE AND WOULD NOT ALLOW GIRT BAR TO PROPERLY ENGAGE. MAINTENANCE ADJUSTED GIRT BAR BRACKET PER SIC 25-94-11.SDR AALA20190521001Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL SHIELD BETWEEN BS 767 AND BS 787 AT S26R. REPLACED TRANSITION PANEL SHIELD PER 51-00-05-01.SDR AALA201905219005Computer · faultyAIRCRAFT NOT GROUNDED: PILOT REPORTS DURING TAKEOFF ROLL COMMANDED N1 INCREASED BY .87% (AFTER SELECTING THE TOGA SWITCH) ON THE LEFT ENGINE. MAINTENANCE FOUND NUMEROUS LEG FAULTS FOR FCC-A . REPLACED FCC-A IAW AMM 22-11-33 . SYSTEM PASSED ALL REQUIRED TESTS.SDR AALA201905219002Unknown · malfunctionedAIRCRAFT WAS GROUNDED: AOA SPLIT OF MORE THAN 5.6. MAINTENANCE ACCOMPLISHED GROUND BITE TEST PER AMM 27-32-00-740-803 AND AOA INPUT SENSOR TEST PER AMM 34-21-05-400-801. NO FAULTS NOTED.SDR AALA20190520002Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND RBL 2. REPLACED FLOOR SUPPORT PER SRM 51-10-02-0G.SDR AALA20190520001Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND LBL 2. REPLACED FLOOR SUPPORT PER SRM 51-10-02-0G.SDR AALA201905209004Unknown · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTED THAT THREE HOURS INTO THE FLIGHT, AMBER VOR 2 FAILURE FLAG APPEARED ON BOTH CA AND FO NAV DISPLAYS. NOTE: WE HAD A GOOD VOR STATION DIALED IN SJN ONLY 35 MILES AWAY 112.3 MHZ VOR 1 RECEIVED VALID SIGNAL BUT VOR 2 DIDNT ORSDR AALA201905209006Unknown · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS AT TOP OF DESCENT FL350 IN VNAV PATH, ACFT NOSED DOWN AND OVERSPEED WARNING ACTIVATED. WARNING ON 1 TO 2 SECONDS. MAINTENANCE ACCOMPLISHED DFCS BITE, NO CURRENT FAULTS, NO PREVIOUS FAULTS, AP SYSTEM OK IAW FIM 22-11, TASK 8SDR AALA20190519003Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 328 AND BS 344 AT LBL 45. REPLACED INTERCOSTAL PER 51-00-05-1SDR AALA20190519002Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 312 AND BS 328 AT LBL 45. REPLACED INTERCOSTAL PER 51-00-05-1SDR AALA20190519001Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 312 AND BS 328 AT RBL 31. REPLACED INTERCOSTAL PER 51-00-05-1SDR AALA20190518007Battery Pack · faultyAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS INSTALLING NEW EEL BATTERY PACK, OPS CHECK WAS GOOD. 5 HOURS LATER SHOWED FAULT LIGHT, TESTED BAD. REPLACED WITH NEW BATTERY PACK. 12 HOURS RECHECK WAS GOOD.SDR AALA20190518008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 727 AND BS 847 AT S26L. REPLACED TRANSITION PANEL PER 51-00-05-01SDR AALA20190518006Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA FLOOR INTERCOSTAL CRACKED BETWEEN BS 344 AND BS 360 AT BL 0. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA20190518004Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BELOW THE SILL PLATE AT THE RIGHT HAND SERVICE DOOR AREA BETWEEN BS 305 AND BS 327. REPLACED CREASE ANGLE PER 51-00-05-01 REPAIR 1.SDR AALA201905219022Window · crackedAIRCRAFT WAS GROUNDED: FIRST OFFICERS R1 WINDOW CRACKED. REPLACED R1 WINDOW.SDR AALA20190518003Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE AT BS 500 CRACKED. REPLACED BAFFLE PER 51-00-05-1SDR AALA20190518002Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE BETWEEN BS 500H AND BS 500I HAS ELONGATED HOLES. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA20190518001Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT LEFT HAND BAFFLE BETWEEN BS 500G AND BS 500H HAS ELONGATED HOLES. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA20190517006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 500D AND BS 500I AND S26R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA20190517007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 500D AND BS 500I AT S26L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA20190517005Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORZONTAL STABILIZER RIB AT STATION 92.70 CRACKED. REPLACED RIB PER 55-10-00-2.SDR AALA20190517008Vane · faultyAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING CLIMB, CAPTAINS SPEED LIMIT AMBER ALERT ILLUMINATED INTERMITTENTLY AND STICK SHAKER ACTIVATED DURING CLIMBOUT. ALL AIRSPEED INDICATIONS WERE NORMAL. EMERGENCY DECLARED. LANDED AT 145,500 LBS, SMOOTH LANDING. FUEL WASSDR AALA201905199015Slide · abnormalAIRCRAFT NOT GROUNDED: PILOT REPORTS DOOR 1L EVAC SLIDE FELL OUT OF ITS COVER AND ONTO THE JETBRIDGE AS DOOR 1L WAS OPENED. NO SLIDE DEPLOYMENT. MAINTENANCE REINSTALLED SLIDE IAW AMM 25-66-01. SLIDE REPACK ONLY.SDR AALA201905199013Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD MEGAPHONE DID NOT WORK. MAINTENANCE REPLACED MEGAPHONE UNIT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 25-64-00.SDR AALA20190517004Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: OVERWING EMERGENCY LIGHT INOPERABLE IN CABIN. REPLACED BATTERY PACK PER STANDARD PRACTICES.SDR AALA201906031003Floor Support · corrodedAIRCRAFT IN BASE VISIT: AFT CARGO FLOOR SUPPORT RBL 14, STA 787 AND 807 HAVE CORROSION. INSTALLED AFT CARGO FLOOR SUPPORT STA. 760-887 RBL14 IAW SRM 51-70-12.SDR AALA201906031006Floor Support · corrodedAIRCRAFT IN BASE VISIT: R/H TRANSITION ANGLE FLOOR SUPPORT, STA 847 & 850 HAS CORROSION. INSTALLED NEW TRANSITION ANGLE FROM STA 847 TO 867 IAW AARD 51-00-05-1 AND BOEING DRAWING 146A0081.SDR AALA20190517003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 480 AND 500I. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.
Back to Boeing 737-823