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 AALA202107234262Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO DOOR THRESHOLD WEB HAS SEVERAL AREAS OF CORROSION AT STA 787 TO 847. INSTALLED NEW WEB IAW AARD 51-00-05, BOEING DWG 146A8123, EA 329209.SDR AALA202107133622Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF FLOOR BEAM AT STA 986 AND LBL 46, MEASURING L=1.0 IN, W=0.075 IN, D=0.056 IN. ACCOMPLISHED PERMANENT REINFORCING REPAIR WITH NESTED ANGLES IAW SRM 53-00-51-2R-1 AND EA 328862.SDR AALA202107132142Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF Z-ANGLE AT STA 990 BETWEEN RBL 34 AND RBL 47, MEASURING L=0.25 IN, W=0.5 IN, D=0.04 IN. REPLACED Z-ANGLE WITH NEW IAW AARD 51-00-05-1.SDR AALA202107134842Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF INTERCOSTAL BETWEEN STA 947 AND STA 967 AT LBL 24.75, MEASURING L=1.0 IN, W=1.25 IN, D=0.05 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05.SDR AALA202107130170Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL BETWEEN STA 727 AND STA 767 AT STR 25R, MEASURING L=1.0 IN, W=1.0 IN, D=0.005 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 53-00-53-2R-5.SDR AALA202107130257Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL BETWEEN STA 727B+12 AND STA 847 AT LBL 27, MEASURING L=1.0 IN, W=1.0 IN, D=0.029 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 53-00-53-2R-5.SDR AALA202106300255Pin · shearedAIRCRAFT WAS OUT OF SERVICE: L1 DOOR WILL NOT OPEN. GUIDE ARM PIN SHEARED. INSTALLED NEW GUIDE ARM PIN PER AMM 52-11-21.SDR AALA202106299011Adc · inoperativeAIRCRAFT WAS GROUNDED: AIRSPEED UNRELIABLE AT CLIMB OUT. BETWEEN 11,000-13,000 FEET, AFTER RUNNING CHECKLIST COMFIRM CO-PILOT THAT INDICATED AIRSPEED WAS UNRELIABLE AND CO- PILOT ALTITUDE UNRELIABLE. DECLARED EMERGENCY RETURNED TO MIAMI. OVERWEIGHT LANDING 150SDR AALA202106299010Warning Horn · false activationAIRCRAFT WAS GROUNDED: AT 8000 FEET AND 250 KTS, DESCENDING ON ARRIVAL, THROTTLES IDLE. GEAR WARNING HORN SOUNDED AND ALL THREE RED LIGHTS FOR GEAR NOT DOWN AND LOCKED ILLUMINATED. CANCELLED HORN AND LIGHTS. ACCOMPLISHED FLIGHT DATA RECORDER DOWNLOAD PER WORKSDR AALA202106299009Radar · false indicationAIRCRAFT WAS NOT GROUNDED: REJECTED TAKEOFF AT 55 KNOTS DUE TO WINDSHEAR WARNING. WEATHER RADAR BITE PASSED, NO FAULT FOUND PER FIM FIM 34-43-00.SDR AALA202106299008Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: FLIGHT ATTENDANT FORWARD RIGHT EMERGENCY FLASHLIGHT INOPERATIVE. ADJUSTED FLASHLIGHT IN MOUNTING BRACKET PER AMM 25-64-00-200-802.SDR AALA202106299006Handle · stickingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN. REPLACED PULL HANDLE ON INSIDE OF DOOR PER AMM 25-40-00.SDR AALA202107217693Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL CORRODED UNDER ADJACENT STRUCTURE AT 500H+12 TO 500I. INSTALLED RIGHT TRANSITION PANEL IAW SRM 53-00-53-2R-5, AARD 51-00-05, BOEING DWG 143A7501.SDR AALA202107155774Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO LEFT TRANSITION PANEL CORRODED AT STA 500D +7 AND LBL23. REPLACED TRANSITION PANEL STA 500D TO 500I IAW SRM 53-00-53-2R-5 AND AARD 51-00-05 AND BOEING DRAWING # 143A7501.SDR AALA202107131488Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT CREASE ANGLE ON INNER CHORD BETWEEN 947 TO 997 AND STR 17R. INSTALLED INNER CHORD IAW 51-40-02.SDR AALA202107136117Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL CORRODED AT STA 500+6 AND RBL 27. INSTALLED NEW SHIELD ASSEMBLY IAW 51-40-02.SDR AALA202106289023Strap · missingAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE IS MISSING NECK STRAP. REPLACED AFT MEGAPHONE IAW AMM 25-64-00.SDR AALA202106299012Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY FLIGHT ATTENDANT RIGHT HAND OUTBOARD FLASH LIGHT INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00-200-802.SDR AALA202106299007Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY FLIGHT ATTENDANT LEFT HAND OUTBOARD FLASHLIGHT INOPERATIVE. ADJUSTED FLASHLIGHT PER AMM 25-64-00-200-802.SDR AALA202106289030Retainer · looseAIRCRAFT WAS NOT GROUNDED: MAIN CABIN R1 DOOR GIRT BAR CLIP LOOSE. TIGHTNED GIRT BAR CLIP RETAINERS PER AMM 25-66-01.SDR AALA202106289025Retainer · looseAIRCRAFT WAS NOT GROUNDED: MAIN CABIN L1 DOOR GIRT BAR CLIP LOOSE. TIGHTNED GIRT BAR CLIP RETAINERS PER AMM 25-66-01.SDR AALA202106289026Slide · unserviceableAIRCRAFT WAS NOT GROUNDED: L2 DOOR SLIDE FLAP DRAGGING AND CATCHING ON DOOR THRESHHOLD. REPLACED ESCAPE SLIDE WITH SERVICEABLE UNIT IAW AMM 25-66-01.SDR AALA202106289024Girt Bar · stickingAIRCRAFT WAS NOT GROUNDED: DOOR 1L GIRT BAR EXTREMELY DIFFICULT TO UNHINGE FROM HOLDER. PERFORMED ADJUSTMENT DOOR 1L GIRT BAR HOLDER AS REQUIRED.SDR AALA202107217770Keelbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER SURFACE OF KEEL BEAM AT STA 649. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER EA 329124.SDR AALA202106309008Toilet · leakingAIRCRAFT WAS GROUNDED: AFT LAVATORY LEAK FOLLOWED BY STRANGE ODOR, FLIGHT DIVERTED TO SJU. CLEANED TOILET SHROUD AND ACCOMPLISHED FUNCTIONAL TEST IAW FIM 38-30-00, LEAK AND OPS CHECK GOOD.SDR AALA202106289019Retainer · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED 1L GIRT BAR CLIP ON ENTRY DOOR DOES NOT HOLD GIRT BAR SECURELY. ADJUSTED GIRT BAR CLIP L-1 DOOR.SDR AALA202106289031Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT 2 BATTERIES INOPERATIVE. INSTALLED NEW BATTERIES .SDR AALA202106289020Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT 1 BATTERY INOPERATIVE. INSTALLED NEW BATTERY .SDR AALA202106289017Bracket · looseAIRCRAFT WAS NOT GROUNDED: 1L DOOR BRACKET THAT HOLDS GIRT BAR LOOSE. ADJUSTED BRACKET.SDR AALA202106289009Fuel Sys · leakingAIRCRAFT WAS GROUNDED: CLIMBING THROUGH ABOUT 10,000 FEET, GOT AMBER FUEL IMBALANCE. LEFT TANK CONTINUED TO DECREASE. TOTALIZER DECREASED AS WELL. EMERGENCY DECLARED. DIVERTED TO CANCUN WHERE CONFIRMED FUEL LEAK ON LEFT ENGINE. PROBLEM GOT WORSE USING THE ONLYSDR AALA202106289015Door · bindingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY D ENTRY DOOR JAMMED AND INOPERATIVE. DOES NOT OPEN OR CLOSE. CLEARED JAM. ACCOMPLISHED OPERATIONAL TEST PER CMM 25-49-71.SDR AALA202106289014Lens · looseAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT MOUNTED ESCAPE PATH LIGHT COVER LOOSE. REPLACED LIGHT COVER WITH NEW IAW STANDARD MAINTENANCE PRACTICES, OPS CHECK GOOD.SDR AALA202106289016Connector · looseAIRCRAFT WAS NOT GROUNDED: 17F EXIT ROW LIGHT FOR OPERATING DOOR INOPERATIVE. TIGHTENED LOOSE CONNECTION OPERATIONS NORMALSDR AALA202106259012Light · looseAIRCRAFT WAS NOT GROUNDED: 12C EMERGENCY EXIT LIGHT PANEL LOOSE. SECURED LIGHT.SDR AALA202106259009Track · dirtyAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR UPPER TRACK OBSTRUCTED AND DIFFICULT TO OPERATE. CLEANED DOOR TRACKS PER AMM 52-50-00.SDR AALA202106259010Slide · not reportedAIRCRAFT WAS NOT GROUNDED: R1 DOOR ESCAPE SLIDE NEED TO BE REPLACED. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE ASSEMBLY PER MCM 08L22125001.SDR AALA202106259011Wire · brokenAIRCRAFT WAS NOT GROUNDED: FOUND FORWARD MEGAPHONE BATTERY TRAY WIRE BROKEN. REMOVED AND REPLACED MEGAPHONE IAW WORK CARD 08C20025010.SDR AALA202106249004Light · crackedAIRCRAFT IN BASE MAINTENANCE: LAVATORY A EXIT LIGHT NEXT TO THE L1 DOOR IS CRACKED. REMOVED AND REPLACED LAVATORY A EXIT LIGHT PER BOEING 737NG AMM 33-51-01-960-802.SDR AALA202106249002Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: DUE TO GROUND INTERRUPT AND HISTORY OF LEADING EDGE FAULTS, PERFORM FIM TASK 27-51-00-810-801. RECORD THE INDICATED FAULTS AND REPAIR AS REQUIRED. POSSIBLE FAULTY LEADING EDGE FLAP SENSORS. ACCOMPLISHED FIM 27-88-00-810-805. CONFIRMED FASDR AALA202106239011Light · intermittentAIRCRAFT WAS NOT GROUNDED: OVERHEAD ESCAPE PATH LIGHT AT ROW 17 LEFT INOPERATIVE. PERFORMED OPS CHECK OF EMERGENCY ESCAPE PATH LIGHTING IAW AMM 33-51-03. NO DEFECTS NOTED AT THIS TIME.SDR AALA202106259015Snubber · brokenAIRCRAFT WAS GROUNDED: L1 CABIN ENTRY DOOR BROKEN, WILL NOT CLOSE. FOUND L1 DOOR SNUBBER / ACTUATOR BROKEN AND REPLACED IT PER AMM 52-11-51. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202106239007Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ROW 29 LOOSE. REPAIRED TRIM FOR EMERGENCY LIGHT AT ROW 29-ASDR AALA202106239010Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT LOOSE AT SEAT 22C. SECURED EMERGENCY EXIT LIGHT IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202106239012Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY LOCK GETS STUCK. LUBED LOCK MECHANISM PER AMM 52-50-00SDR AALA202106239008Screw · brokenAIRCRAFT WAS NOT GROUNDED: MEGAPHONE BATTERY COMPARTMENT SCREW BROKEN. REPLACED MEGAPHONE IAW AMM 25-64-00.SDR AALA202106229007Retainer · looseAIRCRAFT WAS NOT GROUNDED: L1 GIRT BAR CLIP IS LOOSE. ADJUSTED GIRT BAR CLIP AS REQUIRED.SDR AALA202106229006Lens · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT LENS COVER ABOVE RIGHT AFT CABIN DOOR DETACHED FROM WALL ABOVE DOOR. REATTACHED EXIT LENS COVER PER STANDARD PROCEDURES, EXIT LIGHTS OPERATIONS NORMAL.SDR AALA202106309532Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY AREA INTERCOSTAL BETWEEN STA 328 AND STA 344 AT LBL 45 CRACKED. REPLACED INTERCOSTAL PER SRM 51-00-05-1.SDR AALA202106294229Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON INTERCOSTAL LOCATED AT STA 323, RIGHT BUTT LINE 31. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202106239019Window · leakingAIRCRAFT WAS GROUNDED: LOUD SQUEAL FROM FLIGHT DECK WINDOWS WHILE CLIMBING FROM 3,700 THROUGH 10,000 FT, FLIGHT RETURNED TO FIELD. REPLACED L1 (AALA202106239018) AND R1 WINDOWS IAW WORKCARDS 08L21056003 AND 08L21056004, LEAK AND OPS CHECK GOOD.
Back to Boeing 737-823