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 AALA202505089770Door · bindingAIRCRAFT WAS GROUNDED: L1 DOOR HARD TO OPEN. (OPEN).SDR AALA202505085673Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS ADVISE THAT PASSENGERS ARE GETTING STUCK IN LAVATORY-E. THE DOOR WILL NOT OPEN FROM THE INSIDE. ADJUSTED DOOR AND OPERTIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202505080478Indication Sys · inaccurateAIRCRAFT WAS GROUNDED: CENTER TANK QUANTITY IS ON MEL. DURING DESCENT IT BEGAN DISPLAYING 29.46. IT SHOULD BE BLANK ACCORDING TO MEL. INSTALLED NEW BUSSING PLUG TO CENTER TANK. PER MEL REF 28-07B AND AMMREF 28-00-00-901.SDR AALA202505087615Door · off trackAIRCRAFT WAS NOT GROUNDED: LAVATORY-D PULLED OFF TRACK BY PASSENGER AND IS STUCK IN LAVATORY NOW. (OPEN).SDR AALA202505196555Light · brokenAIRCRAFT IN BASE MAINTENANCE: PROXMITY LIGHTS ON THE G7 ARE BORKEN. REMOVED AND REPLACED FLOOR PROXMITY LIGHTS, AND OPERTIONAL TEST GOOD. PER 33-51-14-960-802.SDR AALA202505090646Connector · inoperativeAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505099098Probe · inoperativeAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505098401Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505094794Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505099425Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505096093Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505090080Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505097875Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505093268Probe · faultyAIRCRAFT WAS GROUNDED: CENTER FUEL TANK QUANTITY UNRELIABLE. NEED VERIFICATION OF HOW MUCH FUEL IS IN CENTER TANK. REMOVE AND REPLACED CENTER TANK PROBES 1 THROUGH 8 (AALA202505099098), (AALA202505096093), (AALA202505090080), (AALA202505097875), (AALA202505093SDR AALA202505082705Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL AT BS 336, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505080219Aneroid · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G, RBL 26. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202505079079Threshold · damagedAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR BINDS AT BOTTOM AGAINST DOOR SILL. VERIFIED FORWARD LAVATORY-A DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED FORWARD LAVATORY THRESHOLD PLATE. PER CMM 25-45-46.SDR AALA202505073883Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT LBL 28. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505068726Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G, RBL 26. REPLACED BAFFLE CLIP PER AARD 51-00-05-1,SDR AALA202505064023Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB 3 VERTICAL STIFFENER AT STABILIZER STA 92.70. REPLACED VERTICAL STIFFENER PER SRM 51-40-02-0GSDR AALA202505076594Sensor · dirtyAIRCRAFT WAS GROUNDED: MULTIPLE REPEATS OF HOT COCKPIT WITH AN ODOR IN CABIN. REMOVED AND CLEANED FILTER SCREEN AND TEMP SENSOR AT FLIGHT DECK. OPERTIONAL CHECK WITH APU AND ENGINE BLEED GOOD. PER AMM 21-61-00-700-807-002.SDR AALA202505077573Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202505063627Door · draggingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED TRIM ON BOTTOM OF DOOR. WAS DRAGGING ON THRESHOLD. OPERTIONAL CHECK GOOD.SDR AALA202505069846Tire · blownAIRCRAFT WAS GROUNDED: NUMBER 3 MAIN LANDING GEAR TIRE BLOWN ON LANDING. REMOVED AND REPLACED NUMBER 3 MLG TIRE AND WHEEL ASSEMBLY. PER MM 32-45-11.SDR AALA202505067472Slide · unpackedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORT R1 DOOR DIFFICULT TO ARM AND DISARM SLIDE. REMOVED AND REPACKED R1 DOOR ESCAPE SLIDE. PER AMM 26-66-01. ARMING AND DISARMING OF DOOR OPERTIONAL CHECK GOOD.SDR AALA202505129613Girt Bar · chafedAIRCRAFT IN BASE MAINTENANCE: L2 DOOR ESCAPE SLIDE, GIRT RUB PAD CHAFED THROUGH. OFF AIRCRAFT PART REMOVED CHAFED SLIDE. INSTALLED SERVICEABLE SLIDE. PER B737NG AMM 25-66-01 AND TASK CARD 08L22125001.SDR AALA202505082439Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE FROM BS 380 TO BS 400, AT LBL 14. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202505080440Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE FROM BS 380 TO BS 400, AT RBL 10. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202505062999Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NUMBER 4 SEAT TRACK FROM BS 412 TO BS 418, AT RBL 45.50. REPLACED SEAT TRACK PER AARD 51-00-05-1.SDR AALA202505053120Brake Assy · vibrationAIRCRAFT WAS GROUNDED: EXCESSIVE BRAKE CHATTERING AFTER LANDING DURING TAXI CAUSED NOTICABLE VIBRATIONS THROUGHOUT COCKPIT AND CABIN. PERFORMED BLEEDING OF ALL BRAKES WITH A AND B SYSTEM. PER AMM 32-41-00 UNTIL FLUID FLOWED CLEAR AND PUCK MOVEMENTS VERIFIED.SDR AALA202505055409Screw · shearedAIRCRAFT WAS NOT GROUNDED: L1 DOOR HOLD OPEN ROD SCREW SHEARED. REPLACED HOLD OPEN PIN AND SCREW FOR L1 DOOR. PER AMM 52-11-21. OPERTIONAL CHECKS GOOD.SDR AALA202505062470Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947 TO BS 967, AT LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505053549Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: TRAILING EDGE FLAP ASYMMETRY DURING APPROACH; ONE UP AND ONE AT LESS THAN 1 DEGREE. AIRCRAFT EMERGENCY LANDED SAFELY AT PHL. PERFORM BITE TEST OF THE FLAP AND SLAT ELECTRONICS UNIT (FSEU), PER FIM 27-51-SDR AALA202505058796Bypass Valve · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF GEAR WOULD NOT RETRACT. ALL RED AND GREEN LIGHTS ILLUMINATED WITH HANDLE IN UP POSITION. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CLE. TROUBLESHOOT SYSTEM PERFORMED PROXIMITY BSDR AALA202505055582Locking Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: 1R GIRT BAR NEEDS ADJUSTED AS HARD TO ARM. LUBE FLOOR MOUNTED ESCAPE SLIDE BRACKETS, OPERTIONAL TEST GOOD. PER AMM 20-00-00.SDR AALA202505059204Processor · faultedAIRCRAFT WAS GROUNDED: CENTER FUEL TANK READ FULL AT 28000 LBS. RAN CENTER TANKS PUMPS TO TRANSFER FUEL AND CENTER TANK PUMPS LOW PRESSURE LIGHTS ILLUMINATED WHILE CENTER TANK SHOWED FULL. STUCK TANK WITH STICKS SHOWED NO FUEL IN TANK. HAD CURRENT FAULT 28-413SDR AALA202505071651Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202505056927Electronic Unit · jammedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS JAMMED BELOW 5 DEGREES. AIRCRAFT PERFOMRED A GO AROUND AND EMERGENCY LANDED SAFELY AT STX. ACCOMPLISHED FCEU BITE, PER FIM 27-51-00 FOUND FAULT 27-52261 ACCOMPLISHED FIM 27-51-00-810-832. NO DAMAGESDR AALA202505052807Pump · faultedAIRCRAFT WAS NOT GROUNDED: CENTER LEFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED WITH 4000LBS IN THE TANKS. REMOVE AND REPLACED LEFT HAND CENTER TANK FUEL PUMP, OPERTIONAL AND LEAKED CHECK GOOD. PER AMM 28-22-41.SDR AALA202505053074Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ON SEATS 26 TO THE AFT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M1672, OPERTIONAL CHECK GOOD. PER AMM 33-51-06.SDR AALA202505050163Door · out of adjustAIRCRAFT WAS GROUNDED: GATE AGENT COULD NOT OPEN THE MAIN CABIN DOOR FROM OUTSIDE. MAIN CABIN DOOR HAD TO BE OPENED FROM THE INSIDE. ACCOMPLISHED ADJUSTMENTS ON FORWARD ENTRY DOOR, OPERTIONAL CHECK GOOD. PER AMM 52-11-00-820-801.SDR AALA202505084823Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, BL 0. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202505070273Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202505054962Power Supply · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SEAT AISLE LIGHTS ON LEFT HAND SEAT 9 THROUG 14 DO NOT LIGHT UP. REMOVE AND REPLACED POWER SUPPLY, OPERTIONAL CHECK GOOD.SDR AALA202505059903Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, LEFT HAND ECS BAY AFT BULKHEAD, AT STA 663, LBL 64. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA202505026581Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: JUMPSEAT 2R OUTSIDE FLASHLIGHT NOT WORKING. REMOVED AND REPLACED FLASHLIGHT BATTERY. OPERTIONAL CHECK GOOD. PER MM 25-00-00.SDR AALA202505028968Pump · brokenAIRCRAFT WAS NOT GROUNDED: LEFT CENTER FUEL PUMP SHOWING LOW PRESSURE WITH 1,500 LBS IN THE CENTER TANK. FOUND LEFT CENTER UFI RESET PUSHBUTTON BROKEN OFF. REMOVED AND REPLACED LEFT CENTER BOOST PUMP UFI, OPERTIONAL CHECK GOOD. PER AMM 28-22-99.SDR AALA202505022476Indicator · no testAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING FLIGHT, WHEN TESTING LIGHTS, THE LEFT MAIN GEAR LIGHTS (BOTH OVERHEAD PANEL AND NEXT TO GEAR HANDLE) DID NOT TEST. AIRCRAFT EMERGENCY LANDED SAFELY AT JFK. REMOVE AND REPLACED THE LEFT MAIN GEAR ISDR AALA202505167460Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 277 AND BS 294.5 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505128401Bearing · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ELEVATOR POSITION NUMBER 7 AND NUMBER 8 HINGE BEARING PLATES HAVE EXCESSIVE VERTICAL PLAY. REMOVED AND REPLACED RIGHT HAND ELEVATOR POSITION HINGE PLATES NUMBER 7 (AALA202505128640) AND NUMBER 8 (AALA202505128401). PER
Back to Boeing 737-823