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 AALA202009279010Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE. RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED UNDER THE HYDRAULIC B RESERVOIR. REPAIRED VAPOR BARRIER, PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2.SDR AALA202010269027Frame · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN FRAME OF INBOARD LT HORIZONTAL STABILIZER AT HSTAB STA 101.90, MEASURING L=0.5 IN, W=0.25 IN, D=0.04 IN. REPLACED FRAME WITH NEW, IAW SRM 55-10-09-2R-4.SDR AALA202009269007Fuse · blownAIRCRAFT IN BASE MAINTENANCE. EXIT LIGHTS L1188, L1189 AND L1405 ARE INOPERATIVE. REPLACED BLOWN FUSE IN NN695 POWER SUPPLY AT STA 565, RBL 68.SDR AALA202009269006Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE. L1210 OVERWING SLIDE LIGHT INOPERATIVE. RELAMPED L1210 SLIDE LIGHT.SDR AALA202010129020Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN INTERCOSTAL AT STA 317 AND RBL 32, MEASURING L=1.25 IN. REPLACED INTERCOSTAL WITH NEW, IAW SRM 51-40-02.SDR AALA202009309008Baffle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACKED BAFFLE IN FORWARD CARGO BETWEEN STATION 500G AND 500H. REPLACED BAFFLE, IAW AARD 51-00-05 AND DWG 143A7505.SDR AALA202009309013Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BAFFLE CLIP AT STA 500G AND STR 26L IN FWD CARGO COMPARTMENT, MEASURING L=0.5 IN, D=0.032 IN. REPLACED CLIP WITH NEW, IAW AARD 51-00-05 AND DRAWING 143A7505.SDR AALA202009309012Angle · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN BAFFLE CLIP AT STA 500G AND STR 26L IN FWD CARGO COMPARTMENT, MEASURING L=0.8 IN, D=0.02 IN. REPLACED BAFFLE CLIP WITH NEW, IAW AARD 51-00-05 AND DRAWING 143A7505.SDR AALA202009259018Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED. SMOKE LIGHT ILLUMINATED FOR LEFT AFT LAVATORY LIGHT. WENT OUT IN ABOUT 5-7 SECONDS. FLIGHT ATTENDANT INVESTIGATED AND FOUND NO ODORS OR SECONDARY INDICATIONS. PERFORMED LAVATORY SMOKE TEST, PER AMM 26-14-00. NO FAULT FOUND.SDR AALA202009259017Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED. LAVATORY SMOKE LIGHT ILLUMINATED. PERFORMED SELF TEST OF ALL LAVATORY SMOKE DETECTORS, PER AMM 26-14-00. NO FAULTS NOTED.SDR AALA202009259015Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS NOT ARMED, BULB INOPERATIVE. REPLACED EMERGENCY EXIT NOT ARMED BULB.SDR AALA202010269026Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LT TRANSITION PANEL IN AFT CARGO BETWEEN STA 727 AND STA 827 AT STR 26L, MEASURING L=2.0 IN, W=1.25 IN, D=0.007 IN. REPLACED TRANSITION PANEL WITH MODIFIED PART, IAW SRM 53-00-53-2.SDR AALA202010269025Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF RT TRANSITION PANEL BETWEEN STA 727 AND STA 867 AT STR 25R, MEASURING L=1.0 IN, W=0.5 IN, D=0.038 IN. REPLACED TRANSITION PANEL WITH NEW, IAW SRM 53-00-53-2R-6.SDR AALA202010269015Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON AFT CARGO DOOR CUT OUT SCUFFPLATE WEB BETWEEN BS 792 AND BS 847 AT S25R. REPLACED WEB PER BOEING DRAWING 146A8123 SHEET 6.SDR AALA202010089010Angle · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN BAFFLE CLIP OF FWD CARGO AT STA 500H AND STR 26R, MEASURING L=2.5 IN, D=0.02 IN. REPLACED BAFFLE CLIP WITH NEW, IAW AARD 51-00-05 AND DRAWING 143A7505.SDR AALA202009309006Baffle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACKED BAFFLE CLIP AT FORWARD CARGO STATION 500H AND S36L LEFT. REPLACED BAFFLE CLIP, IAW AARD 51-00-05 AND DWG 143A7505.SDR AALA202009309007Baffle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACKED AFT BAFFLE CLIP AT RT STA 500G. REMOVED AND REPLACED BAFFLE CLIP, IAW AARD 51-00-05 AND BWG DWG 143A7502.SDR AALA202009289022Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CABIN FLOOR INTERCOSTAL CRACKED NEAR FASTENER HOLE BETWEEN STA 344 AND 360 AT BL 0. REPLACED INTERCOSTAL, IAW SRM 51-40-02.SDR AALA202009289020Baffle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACKED BAFFLE CLIP IN FORWARD CARGO COMPARTMENT AT STA 400. REPLACED BAFFLE CLIP, IAW AARD 51-00-05.SDR AALA202009249013Cover · looseAIRCRAFT NOT GROUNDED. R1 DOOR EXIT LIGHT COVER LOOSE. REPLACED MISSING HARDWARE IN EXIT LIGHT COVER, AMM 33-51-00. OPERATIONAL CHECK NORMAL, OKAY FOR SERVICE.SDR AALA202010269016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND 500I AT S27R. REPLACED TRANSITION PANEL, PER SRM 51-40-02.SDR AALA202010129019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LT TRANSITION PANEL BETWEEN STA 500 AND STA 500I AT STR 26L, MEASURING L=1.75 IN, W=1.0 IN, D=0.008 IN. REPLACED TRANSITION PANEL WITH NEW, IAW SRM 53-00-53-2R-6.SDR AALA202009289027Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 0.25 INCH CRACK ON INTERCOSTAL AT STA 540.5 AND LBL 0-12. REPLACED INTERCOSTAL, REF SRM 51-40-02.SDR AALA202009289025Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND 0.25 INCH CRACK ON INTERCOSTAL AT STA 540.5 BETWEEN RBL 0-12. REMOVED AND REPLACED INTERCOSTAL, REF SRM 51-40-02.SDR AALA202009239023Rib · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND RIGHT HORIZONTAL STABILIZER INSPAR RIB 92.70 HAS CRACKED VERTICAL STIFFENER 10 INCH AFT OF FRONT SPAR. INSTALLED REPAIR TO RIB, PER SRM 55-10-09-2R-4.SDR AALA202009229006Slide · low pressureAIRCRAFT IN BASE MAINTENANCE. AFT GALLEY ESCAPE SLIDE PRESSURE LOW. REMOVED AFT R2 DOOR SLIDE AND INSTALLED SERVICEABLE SLIDE.SDR AALA202009229005Slide · looseAIRCRAFT WAS NOT GROUNDED. AFT LEFT ENTRY DOOR SLIDE HOUSING ATTACHMENT SCREWS LOOSE ON DOOR. VERIFIED SCREWS SECURED, PER AMM 26-66-01-400-803.SDR AALA202009219010Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT ADVISED THAT AFT LAVATORY SMOKE DETECTOR ACTIVATED UPON PASSENGER LEAVING LAVATORY. PERFORMED LAVATORY SMOKE DETECTION SELF TEST, OPERATES NORMALLY, PER AMM 26-14-00.SDR AALA202009219012Light · inoperativeBASE MAINTENANCE: EMERGENCY LIGHT INOP, ROW 12ABC OVERHEAD BIN. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY SEAT 12ABC, PER AMM 33-51-03. OPERATIONAL CHECKS NORMAL.SDR AALA202009289026Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACKED STIFFENER ANGLE AT BL 12 ON HORIZONTAL STABILIZER. MANUFACTURED NEW STIFFENER AND REPLACED CRACKED ONE WITH NEW ONE, REF SRM 51-40-02.SDR AALA202009209009Spring · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD RIGHT EMERGENCY EXIT DOOR HANDLE, UPON REMOVAL FOUND SPRINGS DAMAGED. REMOVED AND REPLACED EXIT DOOR HANDLE SPRING ON FORWARD RT EMERGENCY DOOR PRIOR TO LINER INSTALL, PER AMM 52-22-51-400-801.SDR AALA202009209008Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: IN FLIGHT RIGHT AFT LAVATORY SMOKE DETECTOR FALSE ALARM. OPERATIONAL TEST OF FIRE DETECTOR GOOD, PER AMM 26-14-00.SDR AALA202009289028Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND LIGHT CORROSION ON INTERCOSTAL AT STA 1006 TO 1016 AND RBL 28. REPLACED INTERCOSTAL, IAW AARD 51-00-05-1.SDR AALA202009289021Baffle · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND LEFT BAFFLE CLIP CRACKED AT STA 400 IN FORWARD CARGO COMPARTMENT. REPLACED BAFFLE CLIP, REF AARD 51-00-05.SDR AALA202009199008Spring · dislodgedAIRCRAFT NOT GROUNDED, SPRING FROM EMERGENCY LIGHT PLASTIC COVER IS PROTRUDING, AFT ENTRY DOOR. RESECURED EMERGENCY LIGHT COVER SAFETY SCREW, PER AMM 33-51-01. OKAY FOR SERVICE.SDR AALA202009189006Cover · brokenAIRCRAFT NOT GROUNDED, COVER BROKEN, FORWARD GALLEY EMERGENCY LIGHT. REPLACED LIGHT COVER, R1 EMERGENCY EXIT LIGHT. OPERATIONAL CHECK GOOD.SDR AALA202009189010Computer · damagedAIRCRAFT WAS GROUNDED: NUMBER 2 FLIGHT DIRECTOR INTERMITTENT. AUTOPILOT B WONT STAY ENGAGED. STAB OUT OF TRIM FLASHES. REMOVED AND REPLACED FLIGHT CONTROL COMPUTER B, DUE TO PHYSICAL EVIDENCE OF DAMAGE ON FRONT CORNERS, PER AMM 22-11-33. ALL RELATED TEST PSDR AALA202009189007Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY AURAL LIGHT SMOKE ALERT WITH ACCOMPANYING COCKPIT SMOKE LIGHT. NO SMOKE PRESENT. ACCOMPLISHED LAVATORY SMOKE DETECTOR TEST IN RIGHT AFT LAVATORY, PER FIM 26-14-00. CHECKS GOOD.SDR AALA202009309017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RT TRANSITION PANEL IN FWD CARGO COMPARTMENT BETWEEN STA 495 AND STA 500A AT RBL 26, MEASURING L=1.0 IN, W=2.0 IN, D=0.011 IN. ACCOMPLISHED PERMANENT REPAIR BY REMOVING CORROSION, IAW SRM 53-30-53. ENGINEERING REVIESDR AALA202009309016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LT TRANSITION PANEL BETWEEN STA 727D+6 AND STA 807 AT STR 25L, MEASURING L=1.0 IN, W=0.5 IN, D=0.008 IN. REPLACED TRANSITION PANEL WITH NEW, IAW SRM 53-00-53-2R-5.SDR AALA202009309015Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RT TRANSITION PANEL BETWEEN STA 767 AND STA 787 AT STR 25R, MEASURING L=1.0 IN, W=0.5 IN, D=0.03 IN. REPLACED TRANSITION PANEL WITH NEW, IAW AARD 51-00-05-1.SDR AALA202009309014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RT TRANSITION PANEL BETWEEN STA 727B+14 AND STA 767 AT STR 25R, MEASURING L=1.0 IN, W=0.5 IN, D=0.006 IN. REPLACED TRANSITION PANEL WITH NEW, IAW SRM 53-00-53-2R-5.SDR AALA202009189009Computer · failedAIRCRAFT WAS GROUNDED: TWENTY MINUTES AFTER TAKEOFF CLIMBING THROUGH FL 340, TERR FAIL ANNUNCIATED IN CAPTAINS AND FIRST OFFICERS NAV DISPLAYS. GPWS INOPERATIVE ANNUNCIATOR ALSO ILLUMINATED. REMAINED ILLUMINATED THROUGHOUT FLIGHT. REPLACED GROUND PROXIMITYSDR AALA202009179009Transceiver · defectiveAIRCRAFT WAS NOT GROUNDED: ON TAKE OFF NO RADIO ALTIMETER DISPLAYED EITHER SIDE. VNAV WOULD NOT ENGAGE UNTIL 2500 AFL. REPLACED LOW RANGE RADIO ALTIMETER RECIEVER/TRANSMITTER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK, PER AMM 34-33-21.SDR AALA202009179007Autothrottle Sys · disengagedAIRCRAFT NOT GROUNDED: AUTO THROTTLES WILL NOT STAY ENGAGED ON EITHER CMD 1 OR CMD 2. THROTTLES SPLIT 1/2 INCH, MEL 09-650-C REF 2205 AUTOTHROTTLE SYSTEM AUTHORIZED. TROUBLESHOOTING ACCOMPLISHED FIM 22-11-00-810-801- DIGITAL FLIGHT CONTROL SYSTEM (DFCS) BITSDR AALA202009289031Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN INTERCOSTAL BETWEEN STA 328 AND STA 344 AT LBL 46, MEASURING L=0.75 IN. REPLACED INTERCOSTAL WITH MODIFIED PART, IAW DRAWING 141A5410-141 AND AARD 51-00-05-1.SDR AALA202009179008Warning Message · false activationAIRCRAFT WAS GROUNDED: TAKE OFF CONFIG WARNING UPON POWER UP ON RUNWAY. REJECTED TAKE OFF AT LESS THAN 10 KNOTS. UNABLE TO DETERMINE THE CAUSE. FLAPS 5, SPEED BRAKE STOWED, LANDING GEAR GREEN, FLAPS GREEN, NO AMBER, NO RED LIGHTS, REJECTED TAKE OFF ARMED. SDR AALA202009169008Connector · looseAIRCRAFT WAS GROUNDED ON DEPARTURE ROLL AT APPROXIMATELY 60 KNOTS, THE MASTER CAUTION, AMBER OVERHEAD ON SIX PACK, AND RIGHT FORWARD OVERWING AND RIGHT AFT OVERWING LIGHTS ILLUMINATED. TAKE OFF ABORTED AND SPEED NEVER ABOVE 75 KNOTS. FOUND CANNON PLUG D40700SDR AALA2020091549004Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: FOUND CABIN EMERGENCY LIGHT CIRCUIT BREAKER POPPED DURING PREFLIGHT. RESET CIRCUIT BREAKER AND SYSTEM OPERATIONS CHECKS NORMAL, PER AMM 33-51-00.SDR AALA2020091549007Lamp · wrong partAIRCRAFT WAS GROUNDED: DURING FINAL APPROACH PRIOR TO GEAR EXTENSION, THE GEAR UNSAFE LIGHTS FLICKER FOR ABOUT 10 SECONDS WITH THE HORN. A BURNING SMELL ACCOMPANIED THE FLICKERING. REPLACED LOW RANGE RADIO ALTIMETER ANTENNA NR 2 AND ACCOMPLISHED A SATISFACTO
Back to Boeing 737-823