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 AALA2020072089066Smoke Detector · false activationAIRCRAFT NOT GROUNDED, RIGHT AFT LAVATORY SMOKE DETECTOR ALERT SOUNDED ON TWO OCCASIONS. NO FIRE OR SMOKE EVIDENCE DETECTED BY FLIGHT ATTENDANTS. REMOVED AND REPLACED RIGHT AFT LAVATORY SMOKE DETECTOR IAW AMM 26-14-01, OPS CHECKED NORMAL.SDR AALA2020072099003Windshield · hazeAIRCRAFT WAS GROUNDED, L1 WINDSHIELD IS HARD TO SEE OUT OF AT NIGHT DUE TO LIGHT REFLACTION. REPLACED WINDSHIELD PER TASK CARD 56-94-03.SDR AALA2020072089070Terminal · disconnectedAIRCRAFT IN BASE MAINTENANCE, FORWARD R1 DOOR INTERIOR EXIT LIGHT INOPERATIVE. FOUND LIGHT DICONNECTED, CONNECTED THE LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA2020072089064Window · hazeAIRCRAFT IN BASE MAINTENANCE, L3 FLIGHT DECK WINDOW IS HAZEY. REPLACED THE WINDOW IAW AMM 56-11-21.SDR AALA2020072219017Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK IN FLOOR BREAK, INSTALLED NEW BREAK IAW SRM 51-40-02.SDR AALA2020071879008Fuel Filter · cloggedAIRCRAFT NOT GROUNDED - AT TAKEOFF, LEFT FILTER BYPASS LIGHT ILLUMINATED. RAN QRH (QUICK REFERENCE HANDBOOK), NO ABNORMAL L/H ENGINE INDICATIONS. REMOVED AND REPLACED FUEL FILTER, LEFT ENGINE, PER AMM 73-11-02, SYSTEM CHECKS OKAY, LEAK CHECK GOOD.SDR AALA2020072219027Angle · corrodedAIRCRAFT IN BASE MAINTENANCE, ANGLE CORRODED, REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA2020072219019Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE, CRACKED INTERCOSTAL, REPLACED INTERCOSTAL WITH NEW.SDR AALA2020072219016Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK IN END OF BREAK, REPLACED BREAK WITH NEW IAW SRM 51-10-02.SDR AALA202007189013Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK #1 WINDOW CUT OUT, LEFT HAND SIDE WINDOW POST AT BS 219 AND S5L. REPAIRED WINDOW POST PER ECO J2009BA-0002 AND SB 737-53-1335.SDR AALA202007189012Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK #1 WINDOW CUT OUT, RIGHT HAND SIDE WINDOW POST AT BS 219 AND S5R. REPAIRED WINDOW POST PER ECO J2009BA-0002 AND SB 737-53-1335.SDR AALA202007279023Floorbeam · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO FLOOR BEAM AT STA 445 AND RBL 6, MEASURING L=1.0 IN, W=2.0 IN, D=0.008 IN. ACCOMPLISHED PERMANENT REINFORCING SPLICE REPAIR IAW SRM 53-00-53-2R-2.SDR AALA2020072219026Baffle · crackedAIRCRAFT IN BASE MAINTENANCE, CRACKED BAFFLE, REPLACED THE BAFFLE WITH NEW.SDR AALA2020072219022Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FLOOR SUPPORT INTERCOSTAL CORRODED, REPLACED INTERCOSTAL WITH NEW.SDR AALA2020072219018Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE, CRACKED INTERCOSTAL, REPLACED INTERCOSTAL WITH NEW.SDR AALA2020071759018Controller · faultedAIRCRAFT WAS GROUNDED: AT ABOUT 550-1000 AGL ON DEPARTURE AUTO FAIL LIGHT ILLUMINATED. RAN QRH AND THE ALTERNATE POSITION DID NOT WORK. AIRCRAFT RETURNED TO DEPARTURE WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT. REPLACED THE CABIN PRESSURE CONTROLLER NRSDR AALA2020080429004Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION ANGLE BETWEEN STA 767 AND STA 787 AT STR 25R, MEASURING L=1.0 IN, W=2.0 IN, D=0.01 IN. REPLACED TRANSITION ANGLE WITH NEW IAW AARD 51-00-05-1 AND BOEING DRAWINGS 146A8127 AND 146A0081.SDR AALA202007279024Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL BETWEEN STA 727H AND 727I AT BL 21R, MEASURING L=1.0 IN, W=1.0 IN, D=0.007 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NEW TRANSITION SECTION AND SPLICE IAW SRM 53-00-53-2R AND AARD 51-00-05-1.SDR AALA202007279022Deck Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF DECK PLATE AROUND GALLEY MOUNT AT STA 988 AND LBL 32, MEASURING L=3.0 IN, W=4.0 IN, D=0.011 IN. PERMANENT REINFORCING SPLICE REPAIR ACCOMPLISHED IAW SRM 51-70-13-2R-4 AND EA 307279.SDR AALA2020072219021Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED Z ANGLE, REPLACED CHANNEL WITH NEW.SDR AALA2020072219020Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED Z CHANNEL, INSTALLED NEW Z ANGLE.SDR AALA202007179018Pump · low pressureAIRCRAFT WAS GROUNDED: LEFT AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AFTER TAKEOFF. REPLACED LEFT AFT BOOST PUMP AND ACCOMPLISHED A SATISFACTORY LEAK / OPERATIONAL CHECK IAW AMM 28-22-41.SDR AALA202007149012Autothrottle Sys · disconnectedAIRCRAFT NOT GROUNDED, AUTOTHROTTLE DISCONECTED DURING TAKEOFF. PERFORMED FIM 22-32-00-810-802 AUTOTHROTTLE RETARD PROBLEM, FAULT ISOLATION, BITE PROCEDURES, NO FAULTS NOTED.SDR AALA202007159023Sensor · faultyAIRCRAFT WAS GROUNDED: ON APROACH INTO DFW LEADING EDGE FLAPS TRANSIT LIGHT CAME ON WHEN FLAPS 10 DEGREES SELECTION. LEADING EDGE FLAP 1 CYCLED ON APPROACH CAUSING LEADING EDGE FLAP TRANSIT TO CYCLE FROM AMBER TO GREEN. NO ROLL ENCOUNTERED. AN EMERGENCY WASSDR AALA2020071549011Bolt · looseAIRCRAFT WAS GROUNDED: AIRCRAFT RETURNED TO ORD DUE TO LOUD WARNING HORN CONSTANTLY SOUNDING. STARTED PASSING FL28500 AND STOPPED ON DESCENT AT 12500. MAINTENANCE FOUND 5 BOLTS NOT PROPERLY TORQUED ON THE LEFT HAND ACCESS PANEL IN THE NOSE WHEEL WELL AND PROSDR AALA2020071549009Sliding Window · out of adjustAIRCRAFT GROUNDED - FIRST OFFICER SLIDING WINDOW (R2) DOES NOT LOCK IN CLOSED POSITION. ADJUSTED FIRST OFFICER SLIDING WINDOW PER AMM 56-12-11, OPERATIONAL CHECK GOOD, OKAY FOR SERVICE.SDR AALA2020071300332Warning Horn · activatedWHILE AT CRUISE AN AUDIBLE AURAL WARNING STARTED ON THE FLIGHT DECK.THE FLIGHT CREW DECIDED TO RETURN TO ORD. THE AIRCRAFT WAS TAKEN AOS AND ROUTED TO THE HANGAR FOR TROUBLESHOOTING. CURRENTLY IN WORK AT THE HANGAR.SDR AALA2020072979019Sensor · unserviceableAIRCRAFT GROUNDED - EMERGENCY DECLARED - DESCENDING, EXPERIENCED SUDDEN LOSS OF PRESSURIZATION, ALL MASKS DEPLOYED AT FL380 WHEN CABIN ALT LIGHT CAME ON FOLLOWED BY ALT HORN SOUNDING AND BOTH BLEED TRIP-OFF LIGHTS ILLUMINATED. FLIGHT CREW FOLLOWED BLEED TRIP-SDR AALA202007189004Frame · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FRAME HAS OVERSIZED FASTENER HOLE AT BS 727G AND S25R. REPAIRED FRAME PER EA 306896.SDR AALA202007189003Frame · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FRAME HAS OVERSIZED FASTENER HOLE AT BS 727H AND S25R. REPAIRED FRAME PER EA 306896.SDR AALA202007189002Frame · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FRAME HAS OVERSIZED FASTENER HOLE AT BS 747 AND S25R. REPAIRED FRAME PER EA 306896.SDR AALA202007139007Slide · unserviceableAIRCRAFT GROUNDED, L1 DOOR SLIDE PACK OUT OF CONTAINER. REMOVED AND REPLACED L1 DOOR SLIDE ASSEMBLY PER JOB CARD 08L2212501.SDR AALA202007139001Proximity Switch · unserviceableAIRCRAFT GROUNDED, PSEU LIGHT AND ASSOCIATED TAKE-OFF CONFIGURATION WARNING, LOW SPEED REJECTED TAKE OFF AT 34KTS. PROXIMITY SWITCH ELECTRONICS UNIT (PSEU) LIGHT SUBSEQUENTLY EXTINGUISHED AND DID NOT RETURN. ACCOMPLISHED FIM TASK 32-09-00, REMOVED AND REPLACSDR AALA202007279015Sensor · failedAIRCRAFT GROUNDED - EMERGENCY DECLARED - DESCENDING INTO DENVER, EXPERIENCED SUDDEN LOSS OF PRESSURIZATION, ALL MASKS DEPLOYED AT FL380 WHEN CABIN ALT LIGHT CAME ON FOLLOWED BY ALT HORN SOUNDING AND BOTH BLEED TRIP-OFF LIGHTS ILLUMINATED. FLIGHT CREW FOLLOWEDSDR AALA202007189001Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT INTERCOSTAL BETWEEN BS 500C AND BS 500D AT LBL 25. REPLACED INTERCOSTAL PER AARD51-00-05-1.SDR AALA202007139011Transmitter · defectiveAIRCRAFT WAS GROUNDED: AFTER TAKEOFF , UNABLE TO RETRACT FLAPS FROM 1 TO UP. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW WHEERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT.FLIGHT CREW FOLLOWED QRH. ALT FLAPS USED FOR F15 LANDING WITH A NORMAL TOUCSDR AALA202007139003Cabin Pressure · malfunctionedAIRCRAFT GROUNDED, DURING DESCENT, EXPERIENCED A SUDDEN LOSS OF PRESSURIZATION, ALL MASKS DEPLOYED AT FL 380 CABIN ALT LIGHT CAME ON AND ALT HORN SOUNDING, BOTH BLEED TRIP OFF LIGHTS ILLUMINATED. CREW FOLLOWED BLEED TRIP OFF IN QRH & PRESSURIZATION RESTORESDR AALA202007279025Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO LOWER FLOOR ATTACH ANGLE FOR FWD CARGO AFT BULKHEAD CENTER ACCESS PANEL AT STA 500I AND STR 26L-26R, MEASURING L=1.0 IN, W=1.0 IN, D=0.05 IN. REPLACED ATTACH ANGLE WITH NEW IAW SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA2020072219028Web · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION FOUND ON THE CARGO DOOR SILL WEB, REPLACED WITH NEW WEB.SDR AALA2020072219025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE, CORRODED TRANSITION PANEL, REPLACED THE TRANSITION PANEL WITH NEW IAW SRM 51-40-02.SDR AALA2020072219024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE, LEFT TRANSITION PANEL CORRODED FROM BS 500 TO 500I. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R5.SDR AALA202007189011Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT AFT BAFFLE CLIP AT BS 500H AND RBL 25. REPLACED BAFFLE CLIP PER SRM 51-40-02.SDR AALA202007189010Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT FORWARD BAFFLE CLIP AT BS 500G AND LBL 25. REPLACED BAFFLE CLIP PER SRM 51-40-02.SDR AALA2020071329009Pump · failedAIRCRAFT GROUNDED - ABORTED TAKEOFF - ENGINE NO. 1 WOULD NOT REACH TAKE-OFF THRUST, STALLED AT 85% N1. LOW SPEED REJECTED TAKE-OFF AT 70 KIAS (SECOND EVENT). REMOVED AND REPLACED HMU (HYDROMECHANICAL UNIT), ENGINE 1, PER JOB CARD 08L40073001, OPERATIONAL CHECKSDR AALA2020071329004Window · damagedAIRCRAFT IN BASE MAINTENANCE - RIGHT (FIRST OFFICER) #3 WINDOW, HAZY AND CRACKING. REMOVED AND REPLACED RH #3 WINDOW.SDR AALA2020071319010Hmu · malfunctionedAIRCRAFT GROUNDED - ABORTED TAKEOFF - ENGINE NO. 1 WOULD NOT REACH TAKE-OFF THRUST, STALLED AT 85% N1. LOW SPEED REJECTED TAKE-OFF AT 70 KIAS (SECOND EVENT). REMOVED AND REPLACED HMU (HYDROMECHANICAL UNIT), ENGINE 1, PER JOB CARD 08L40073001, OPERATIONAL CHECKSDR AALA2020071319006Guide Arm · bindingAIRCRAFT GROUNDED - L1 DOOR GUST LOCK VERY STIFF - HARD TO RELEASE. REMOVED AND REPLACED L1 DOOR GUIDE ARM AND ROLLER PER AMM 52-11-21, OPERATIONAL CHECK NORMAL.SDR AALA2020071309007Connector · looseAIRCRAFT NOT GROUNDED - PASSENGER SEAT MOUNTED ESCAPE PATH EMERGENCY LIGHT, ROW 9DEF, INOPERATIVE. RESEATED LOOSE CONNECTOR AT 9DEF SIDEWALL, SYSTEM CHECKED NORMAL PER AMM 33-51-00, CLEARED MEL.SDR AALA202007109002Fuel Filter · cloggedAIRCRAFT GROUNDED - ABORTED TAKEOFF - NO. 1 ENGINE WOULD NOT REACH TAKE-OFF THRUST (STALLED AT 85% N1). NO. 2 ENGINE AT FULL TAKE-OFF POWER (100.8% N1). ENGINE BLEED OFF, TAKEOFF AND LANDING PROCEDURE WITH APU ON - LOW SPEED REJECT AT 70 IAS. PERFORMED FIM 73SDR AALA202007109014Pump · failedAIRCRAFT WAS GROUNDED: DURING DESCENT, HYDRAULIC SYSTEM A FAILED, AN EMERGENCY WAS DECLARED AND THE AIRCRAFT LANDED SAFELY WITHOUT FURTHER INCIDENT. REPLACED HYDRAULIC A SYSTEM ELECTRIC / MOTOR PUMP AND ACCOMPLISHED A SATISFACTORY LEAK / OPERATIONAL CHECK PER
Back to Boeing 737-823