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 AALA201904219001Tire · failedAIRCRAFT WAS GROUNDED: PILOT REPORTS EMERGENCY LANDING TO SEA ON ACCOUNT OF HYDRAULIC SYSTEM A DEPLEATD TO 23% AND ANTI-SKID LIGHT ILLUMINATED AFTER TAKEOFF DUE TO SUSPECTED TIRE BLOW OUT. MAINTENANCE FOUND THE #2 MAIN TIRE BLEW OUT WHICH CAUSED DAMAGE TO SOMESDR AALA2019042219006Battery Pack · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY PACK M1694 FAILED 15 MINUTE CAPACITY TEST. MAINTENANCE REPLACED BATTERY PACK M1694 IAW AMM 33-51-06. OPS TEST. IS NORMAL.SDR AALA2019042219004Battery Pack · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS THE EMERGENCY LIGHT BATTERY PACK M1671 FAILED CAP TEST IAW WORK CARD 2908. ACCOMPLISHED DEEP CYCLE PROCEDURE IAW AMM 33-51-06, TASK 600-802. OPS CHECKED NORMAL.SDR AALA2019042209016Flt Controls · malfunctionedAIRCRAFT NOT GROUNDED: ON DECENT FL 320 AIRCRAFT PITCHED DOWN EXCEEDING .82 (.825) FOR 3 SECONDS. ACCOMPLISHED CARD 5-96-08 ( 08L00005055), AIRCRAFT IS WITHIN OPERATING LIMITS, PER CARD.SDR AALA2019042219003Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER INNER RIB CRACKED AT STA 92.70. REPLACED RIB PER AARD 51-00-05-1.SDR AALA2019042219002Spacer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON HORIZONTAL SPACER AT APU INLET AT BS 1088. REPLACED SPACER PER AARD 51-00-05.SDR AALA2019042219001Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER HORIZONTAL ANGLE AT APU INLET AT BS 1088. REPLACED ANGLE PER AARD 51-00-05.SDR AALA201904199006Light · inoperativeAIRCRAFT NOT GROUNDED: PILOT REPORTS EMERGENCY EXIT NOT ARMED LIGHT WILL NOT ILLUMINATE WHEN TESTED. MAINTENANCE REPLACED THE EMERGENCY EXIT NOT ARMED LIGHT IAW SWPM 20-84-15. OPS CHECK GOOD.SDR AALA201904220004Battery Pack · no testAIRCRAFT NOT GROUNDED: BATTERY PACK FAILED OP"S CHECK AT LOCATION M1673, REMOVED AND REPLACED BATTERY PACK.SDR AALA201904220001Battery Pack · weakAIRCRAFT NOT GROUNDED: M1694 BATTERY PACK FAILED CAPACITY TEST PER WORK CARD 2908. REPLACED BATTERY PACK M1694 REF. AMM 33-51-06. OPS. TEST IS NORMAL REF. AMM 33-51-00.SDR AALA2019042218004Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 344 ADN BS 360 AT LBL 1. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA201904199007Gust Lock · dirtyAIRCRAFT NOT GROUNDED: FA REPORTS GUST LOCK ON MAIN CABIN DOOR DIFFICULT TO OPERATE. MAINTENANCE CLEANED DEBRIS FROM GUST LOCK MECHANISM AND LUBED IAW AMM 12-25-11. LOCK OPERATES EASILY NOW.SDR AALA201904199003Drain Line · leakingAIRCRAFT WAS GROUNDED: CABIN REPORTS STRONG BAD ODOR COMING FROM AIR VENTS IN FLIGHT LIKE DIRTY FEET. MAINTENANCE FOUND DRAIN MAST LINE LEAKING ON LEFT RECIRCULATION FILTER IN THE FWD CARGO COMPARTMENT. RELACED FWD DRAIN MAST FLEX LINE ABOVE RECIRCULATION FAN SDR AALA2019041989017Control Valve · unreliableAIRCRAFT WAS GROUNDED. PILOT DECLARED EMERGENCY INBOUND DUE TO A FLAPS ISSUE. FLIGHT LANDED WITHOUT INCIDENT. FLAPS WOULD NOT DEPLOY ON APPROACH. HYDRAULIC PRESSURE NORMAL. NO ASSEMENTRY. PSEU LIGHT ILLUMINATED ON LANDING ROLL. MAINTENANCE REMOVED AND REPLASDR AALA201904189002Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY SMOKE DETECTOR WENT OFF IN CRUISE FOR SECONDS AND WENT OUT. LAVATORY CHECKED AND NO SMOKE FOUND. MAINTENANCE ACCOMPLISHED RIGHT AFT LAV SMOKE DETECTOR TEST PER AMM 26-14-00 AND PERFORMED SATISFACTORY OPERATIONAL CHSDR AALA201904189001Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: JUST PRIOR TO TOP OF DESCENT, THE LAVATORY SMOKE LIGHT ILLUMINATED FOR APPROXIMATELY 5 SECONDS AND EXTINGUISHED WITH NO INDICATIONS OF A FIRE. MAINTENANCE ACCOMPLISHED LAVATORY SMOKE DETECTION TEST PER MM 26-14-00 AND PERFORMED SATISSDR AALA201904187008Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND THE EMERGENCY LIGHT POWER SUPPLY M1672 INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-06. OPS CHECK GOOD.SDR AALA201904187005Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR BEAM UPPER AND LOWER SURFACES AT BS 986.5 BETWEEN LBL 53 AND RBL 53. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-4.SDR AALA201904187004Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT WET AREA FLOOR INTERCOSTAL AT NS 950 AND LBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201904179001Drain Valve · odorAIRCRAFT WAS GROUNDED: PILOT REPORTS EXTREMELY FOUL ODOR THROUGHOUT A/C AS SOON AS RECIRCULATION FANS TURNED ON, APU OFF. MAINTENANCE ACCOMPLISHED WORK CARDS 05-96-70 AND 38-94-14. FOUND THE FIRST CLASS GALLEY DRAIN SILL VALVE FAILED CLOSED AND HOSE SPLIT. REMSDR AALA201904169004Not Reported · not reportedAIRCRAFT NOT GROUNDED: PILOT REPORTS TAKEOFF REJECTED AT 60 KTS WT 152.6 MEDIUM BRAKING. MAINTENANCE ACCOMPLISHED CARD 05-96-17, NO DEFECTS NOTED.SDR AALA201904179005Girt Bar · faultyAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR DISARMED. HOOK ON BOTTOM OF SLIDE BUSTLE ON LEFT HAND SIDE BROKEN. MAINTENANCE REPAIRED L1 DOOR GIRT BAR HOOK PER SRM 51-40-02-OG AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904169002Return Spring · unreliableAIRCRAFT NOT GROUNDED: PILOT REPORTS ON TAKE OFF, THE F/O SEAT SKID BACK TO REAR STOPS. AFTER RESET 6 POSITION # 7, SEAT SKID AGAIN. MAINTENANCE REPLACED THE F/O SEAT TRACK LOCK OUT PIN SPRING IAW CMM 25-11-39. OPS CHECK GOOD.SDR AALA2019041649004Unknown · unknownAIRCRAFT NOT GROUNDED: PILOT REPORTS WITH CENTER FUEL TANK EMPTY RIGHT TANK SHOWED INCREASE BURN THAN THE LEFT. THE DIFFERENCE WAS 100 LBS EVERY 10 MIN. FUEL FLOWS WERE THE SAME. AFTER LANDING A 220 LB DIFFERENCE CORRECTED IT SELF TO A 10 LB DIFFERENCE BY TSDR AALA2019041649021Ballast · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS SIDE WALL LIGHT INOP AT L/H EMERGENCY EXIT. MAINTENANCE IS TO REPLACE LAMP AND OR BALLAST FOR SIDEWALL LIGHT AT SEAT 15A.***SUPPLEMENTAL REPORT: MAINTENANCE REPLACED BALLAST ASSEMBLY FOR SIDE WALL LIGHT AT LH EMERGENCSDR AALA2019041649005Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY E, SMOKE DETECTOR WENT INTO ALARM IN FLIGHT. A PASSENGER WAS IN THE LAVATORY, SUSPECTED OF VAPING. ALARM CEASED WHEN FLIGHT ATTENDANTS OPENED DOOR. NO VISIBLE SMOKE, PASSENGER DENIED VAPING/SMOKING. MAINTENANCE PERSDR AALA2019041549007Ballast · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS ENTRY LIGHT AT FORWARD DOOR IS NOT WORKING OR VERY DIM. REPLACED BALLAST FOR ENTRY LIGHT IAW AMM 33-22-00.SDR AALA20190502006Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN BS 500A AND BS 500I. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA201904129018Pad · brokenAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR UPPER PRESSURE STOP FITTING BEARING PAD BROKEN. REPLACED PRESSURE STOP FITTING BEARING PAD PER AMM 52-11-01.SDR AALA201904129007Yoke · out of adjustAIRCRAFT WAS GROUNDED: PILOT REPORTS YOKE POSITIONED ALL THE WAY LEFT DIFFICULT TO POSITION OTHER THAN LEFT. TURNED ON HYDRAULICS AND NO CHANGE. LOOKED OUTSIDE WINDOW AT WINGS, LEFT SPOILERS WERE MOSTLY ALL THE WAY UP. RIGHT WING NO SPOILERS. MAINTENANCE FOUNSDR AALA201904129002Fuel Sys · malfunctionedAIRCRAFT WAS NOT GROUNDED: PILOT REPORTS FUEL STARTED OUT BALANCED. BY 1.5 HRS. INTO THE FLIGHT, CENTER TANK EMPTY, LEFT ENGINE HAD 500 MORE LBS. THANKS THE RT. FUEL FLOW WAS HIGHER ON THE LEFT 2.62 VS 2.58. BALANCED THE FUEL, AT THE TOP OF DESCENT 2 HRS IN FSDR AALA201904189027Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CAPTAIN'S #1 WINDOW POST CRACKED. REPAIRED PER ECO J2009AE.SDR AALA201904189026Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICERS #1 WINDOW POST CRACKED IN THE UPPER OUTBOARD CORNER. REPAIRED PER ECO J2009AE.SDR AALA201904129001Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: ABOUT 3 HOURS INTO FLIGHT, AT CRUISE, AFT LEFT LAVATORY SMOKE DETECTOR LIGHT ILLUMINATED, DISAPPEARED AFTER 10 SECONDS. FLIGHT ATTENDANTS DID THOROUGH CHECK OF LAVATORY AND TRASH. NO INDICATION OF SMOKE, FUMES, OR FIRE. BLOCKED OFF LSDR AALA201904129003Fuel Sys · malfunctionedAIRCRAFT WAS NOT GROUNDED: PILOT REPORTS APPROX. ONE MINUTE AFTER T.O. RIGHT MAIN TANK IMBALANCE ALERT DISPLAYED. FUEL FLOWS WERE EVEN. FUEL FOR BOTH ENGINES WERE BEING FED FROM RIGHT MAIN. RAN IMBAL QRH. NO FUEL LEAK SUSPECTED SO BALANCED MAIN TANKS, CROSSFEESDR AALA201904120013Life Raft · misinstalledMAINTENANCE FOUND THE #4 LIFE RAFT INSTALLED UPSIDE DOWN. INSTALLED LIFE RAFT CORRECTLY IAW AMM.SDR AALA201904120012Life Raft · misinstalledAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS THE #2 LIFE RAFT INSTALLED UPSIDE DOWN. INSTALLED LIFE RAFT CORRECTLY IAW AMM.SDR AALA201904120011Life Raft · misinstalledMAINTENANCE REPORTS THE #1 LIFE RAFT INSTALLED UPSIDE DOWN, INSTALLED LIFE RAFT CORRECTLY IAW AMM.SDR AALA201904110014Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR TIE DOWN TRACK AT BS 747 AND RBL 13. REPAIRED TRACK PER SRM 53-00-53-2R-3.SDR AALA201904110003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL BETWEEN BS 500B AND BS 500H AT S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2019041519001Fuel Sys · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS DURING FLIGHT, PREMATURE FUEL BURN FROM BOTH WING TANKS WITH FUEL IN CENTER TANK. ALL PUMPS SHOW NORMAL. 1:40 HRS INTO FLIGHT, LOST 700 LBS IN RIGHT TANK AND 300 LBS FROM LEFT TANK. CENTER TANK IS FEEDING NORMAL. WHEN CENTSDR AALA2019041109018Floor Panel · damagedAIRCRAFT WAS GROUNDED: CABIN FLOOR PANEL SOFT AT CENTER AISLE BETWEEN SEAT ROWS 14C AND 14D. REPLACED FLOOR PANEL PER AMM 53-21-00.SDR AALA2019041109017Floor Panel · damagedAIRCRAFT WAS GROUNDED: CABIN FLOOR PANEL SOFT AT CENTER AISLE BETWEEN SEAT ROWS 9 AND 11. REPLACED FLOOR PANEL PER AMM 53-21-00SDR AALA201904119003Switch · malfunctionedAIRCRAFT WAS NOT GROUNDED: PILOT REPORTS AFTER LANDING STAB TRIM RAN UNCOMMANDED CONTINUALLY IN BOTH DIRECTIONS. TURNED OFF BOTH STAB TRIM PEDESTAL SWITCHES, STOPPED STARTED AGAIN WITH BOTH SWITCHES ON. MAINTENANCE PERFORMED TASK 27-41-00-810-804 AND GOUND NO SDR AALA201904119002Module · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS CLIMBING THROUGH FL290 INTERMITTENT FAULT LIGHT ON FIRE DETECTION PANEL MASTER CAUTION OVERHEAT DET ON SIX PACK AND ENG #'2 ENGINE OVERHEAT ON FIRE DETECTION PANEL. MAINTENANCE PERFORMED AMM ENG FIRE DETECT 26-11-00 PB501.SDR AALA201904109014Slide · misinstalledAIRCRAFT WAS NOT GROUNDED: 1L DOOR SLIDE STOWED IMPROPERLY. MAINTENANCE RESECURED SLIDE PER AMM 25-66-01.SDR AALA201904109001Door · openAIRCRAFT WAS NOT GROUNDED: PILOT REPORTS DURING INITIAL CLIMB, AIRCRAFT DID NOT PRESSURIZE. EMERGENCY DECLARED, RETURNED TO DEPARTURE. MAINTENANCE FOUND THE E&E DOOR LEFT OPEN. CLOSED & LOCKED THE E&E DOOR.SDR AALA2019041090007Gusset · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPRT GUSSET CRACKED AT BS 500I AND S19R. REPLACED GUSSET PER EA 292255.SDR AALA2019041090004Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM TOP FLANGE AT BS 1016 AND RBL 32. REPAIRED FLOOR BEAM PER EA 291464.SDR AALA201904109005Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND LBL 2. REPLACED FLOOR SUPPORT PER SRM 51-40-02.
Back to Boeing 737-823