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 AALA202007319006Antenna · looseAIRCRAFT NOT GROUNDED - AUTOTHROTTLE DISENGAGED 3 TIMES ON DESCENT. ON APPROACH, RE-ENGAGED NORMALLY. MEL 07-1810-C AUTOTHROTTLE SYSTEM, AUTHORIZED. ACCOMPLISHED AUTOTHROTTLE SYSTEM BITE CHECK PER FIM 22-31-00-810-801, FOUND MOUNT SCREWS LOOSE ON RADIO ALTSDR AALA202008109024Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ATTACH CLIP OF TRANSITION PANEL AT STA 500H AND STR 25R, MEASURING L=0.5 IN, W=0.02 IN, D=0.002 IN. REPLACED ATTACH CLIP WITH NEW IAW AARD 51-00-05.SDR AALA2020080769022Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRSION OF INTERCOSTAL BETWEEN STA 947 AND STA 967 AT LBL 24, MEASURING L=2.0 IN, W=1.0 IN, D=0.04 IN. REPLACED INTERCOSTAL WITH NEW IAW SRM 51-10-02-0G.SDR AALA2020080769020Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT BS 540 BETWEEN BL0 AND LBL 24.75, MEASURING L=2.0 IN, W=0.005 IN. REPLACED FLOOR SUPPORT WITH NEW IAW AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA2020080769019Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT AT STA 540 BETWEEN BL0 AND RBL 24.75, MEASURING L=0.5 IN, W=0.005 IN. REPLACED FLOOR SUPPORT WITH NEW IAW AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202007319001Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FORWARD DOOR SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT HAND FORWARD SLIDE LIGHT PER AMM 33-51-04.SDR AALA202007309021Module · malfunctionedAIRCRAT WAS GROUNDED, LANDING GEAR WOULD NOT RETRACT, CREW CONFIRMED MANUAL EXTENSION DOOR WAS CLOSED AND CYCLED GEAR HANDLE AND LANDING GEARS RETRACTED. AIRCRAFT RETURNED TO DEPARTURE, LANDED SAFELY WITHOUT FURTHER INCIDENT. NO EMERGENCY WAS DECLARED. REMOVSDR AALA2020080309009Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOORBEAM AT BS 947.5 AND RBL 4. REPAIRED FLOORBEAM PER SRM 53-70-51.SDR AALA202007309008Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED FLOOR SUPPORT AT TWO NUT PLATE LOCATIONS, BETWEEN BS 312 AND 328, LBL 42, MEASURING L=5.0 IN, W=0.002 IN, D=0.063 IN. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA2020073099020Sensor · malfunctionedAIRCRAFT WAS NOT GROUNDED: UPON SELECTING CMD A. THERE WAS A NOTEABLE PITCH DOWN DURING CLIMB OUT. VNAV WAS WAS ENGAGED. FLIGHT WAS OPERATED IN CMD B. WITH NO FURTHER ISSUES. TROUBLESHOT AUTO PILOT A PITCH FOUND FAULT CODE 22-11127 (ELEVATOR POSITION SENSOR. SDR AALA2020073099007Light · detachedAIRCRAFT WAS NOT GROUNDED, SEAT 26C EMERGENCY LIGHT HANGING FROM ARMREST. REPOSITIONED EMERGENCY LIGHT COVER AT SEAT 26C IAW AMM 33-51-11.SDR AALA2020073029016Placard · brokenAIRCRAFT NOT GROUNDED - OVERWING EXIT PLACARD BROKEN OFF, NEAR SEAT 14F. REPLACED PLASTIC OVERWING EXIT PLACARD PER AMM 11-32-01.SDR AALA2020073029010Lens · missingAIRCRAFT NOT GROUNDED - EMERGENCY EXIT SIGN MISSING, FIRST CLASS GALLEY DOOR. REPLACED EMERGENCY EXIT SIGN LENS PER AMM 33-20-00, GROUND CHECKS GOOD.SDR AALA2020073089015Module · inoperativeAIRCRAFT WAS GROUNDED, ON FIRST APPROACH, AFTER PUTTING GEAR HANDLE DOWN, GEAR WARNING HORN SOUNDED, THEN WENT OUT. GEAR DOWN INDICATION SHOWED THREE GREEN AND THREE RED IN THE GEAR HANDLE, THREE GREEN ON OVERHEAD PANEL. EXECUTED A GO-AROUND, RAISED GEAR. SDR AALA202007309023Autothrottle Sys · malfunctionedAIRCRAFT NOT GROUNDED - AFTER TOUCH DOWN, THROTTLES BROUGHT TO IDLE AND SPEED BRAKES DEPLOYED. REACHING FOR REVERSERS, BOTH THROTTLES MOVED FORWARD. NORMAL LANDING AFTER MAINS ON GROUND (REPEAT ITEM). MEL 07-1672-C AUTOTHROTTLE SYSTEM, AUTHORIZED. ACCOMPLISSDR AALA202007289010Guide Arm · looseAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO OPEN. INSTALLED NEW SCREW AND WASHER ON L1 DOOR GUIDE ARM PER AMM 52-11-21-400-802.SDR AALA202007289017Water Heater · overheatedAIRCRAFT WAS GROUNDED: AFT RIGHT LAV WATER HEATER VERY HOT WITH SLIGHT BURNING SMELL. REMOVED AND REPLACED ON AFT RIGHT LAV THE WATER HEATER AND OPERATIONAL AND LEAK CHECK GOOD IAW AMM 38-13-01.SDR AALA202007289012Lamp · burned outAIRCRAFT WAS NOT GROUNDED: WINDOW LIGHT ADJACENT TO SEAT 14A BURNED. RELAMPED L/H EMERGENCY LIGHT PER AMM 33-21-00.SDR AALA2020072879043Aoa · inoperativeAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL UPON ENGAGING TOGO AUTOTHROTTLES DISENGAGED AND TAKE OFF CONFIGURATION WARNING SOUNDED, REJECTED TAKE OFF AT APPROXIMATELY 45 / KNOTS. MAINTENANCE DETERINED THAT THE SPEED BRAKE TAKEOFF WARNING SWITCH WAS NOT ENGAGING USDR AALA2020072879042Aoa · inoperativeAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL UPON ENGAGING TOGO AUTOTHROTTLES DISENGAGED AND TAKE OFF CONFIGURATION WARNING SOUNDED, REJECTED TAKE OFF AT APPROXIMATELY 45 / KNOTS. MAINTENANCE DETERINED THAT THE SPEED BRAKE TAKEOFF WARNING SWITCH WAS NOT ENGAGING USDR AALA2020072879013Switch · out of adjustAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL UPON ENGAGING TOGO AUTOTHROTTLES DISENGAGED AND TAKE OFF CONFIGURATION WARNING SOUNDED, REJECTED TAKE OFF AT APPROXIMATELY 45 / KNOTS. MAINTENANCE DETERINED THAT THE SPEED BRAKE TAKEOFF WARNING SWITCH WAS NOT ENGAGING USDR AALA2020080769021Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER INTERCOSTAL AT STA 294.5 AND BL 0, MEASURING L=1.125 IN, W=0.75 IN, D=0.063 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05.SDR AALA2020072869007Door · lack of lubeAIRCRAFT NOT GROUNDED - LEFT AFT CABIN DOOR, GUST LOCK DIFFICULT TO ENGAGE. LUBRICATED DOOR GUIDE ARM ROLLER PER AMM 12-25-12, DOOR OPERATES SATISFACTORY PER AMM 52-11-00.SDR AALA2020072769010Landing Gear · malfunctionedAIRCRAFT WAS GROUNDED: AFTER TAKE OFF LANDING GEAR WOULD NOT RETRACT. FOLLOWED QRH PROCEDURE. AFTER EMERGENCY GEAR DOOR CYCLED AND VERIFIED CLOSED, GEAR CYCLED NORMALLY AND OPERATED NORMALLY FOR LANDING. ACCOMPLISHED OPERATIONAL CHECK OF LANDING GEAR IAW B737SDR AALA202008109023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LH TRANSITION PANEL AT FASTENER HOLES BETWEEN STA 500A AND STA 500I AT STR 25L, MEASURING L=1.5 IN, W=1.5 IN, D=0.033 IN. REPLACED TRANSITION PANEL WITH NEW IAW AARD 51-00-05-1.SDR AALA2020080309011Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BETWEEN BS 947 AND BS 967 AT RBL 54. REPAIRED CREASE ANGLE PER SRM 53-60-13.SDR AALA2020080309010Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BETWEEN BS 947 AND BS 967 AT LBL 54. REPAIRED CREASE ANGLE PER SRM 53-60-13.SDR AALA2020080399005Control Valve · defectiveAIRCRAFT WAS GROUNDED: DESCENDING THRU FL 330 MASTER CAUTION AUTO FAIL LIGHTS ILLUMINATED, ACCOMPLISHED QRH PROCEDURE - MODE SELECTOR - ALTN - AUTO FAIL LIGHT EXTINGUISHED. NORMAL PRESSURIZATION. REPLACED CABIN PRESSURE CONTROLLER #2 PER AMM 21-31-01 AND ACCOMSDR AALA202008038922Control Valve · defectiveAIRCRAFT WAS GROUNDED: ALTERNATE PRESSURIZATION CONTROLLER SURGES DURING DESCENT BETWEEN 300FT/MIN UP TO OVER 800 FT/MIN. REPLACED CABIN PRESSURE CONTROLLER #2 PER AMM 21-31-01 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK. ALSO REPLACED RIGHT HAND PACK TESDR AALA2020072759002Cover · missingAIRCRAFT WAS NOT GROUNDED: FORWARD AISLE LOWER EXIT LIGHT COVER MISSING. REPLACED EMERGENCY LIGHT COVER AT FORWARD AISLE PER AMM 33-51-11.SDR AALA202007279041Controller · malfunctionedAIRCRAFT WAS GROUNDED: ALTERNATE PRESSURIZATION CONTROLLER SURGES DURING DESCENT BETWEEN 300FT/MIN UP TO OVER 800 FT/MIN. REPLACED CABIN PRESSURE CONTROLLER #2 PER AMM 21-31-01 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK. ALSO REPLACED RIGHT HAND PACKSDR AALA202007279040Warning Light · illuminatedAIRCRAFT WAS GROUNDED: DESCENDING THRU FL 330 MASTER CAUTION AUTO FAIL LIGHTS ILLUMINATED, ACCOMPLISHED QRH PROCEDURE - MODE SELECTOR - ALTN - AUTO FAIL LIGHT EXTINGUISHED. NORMAL PRESSURIZATION. REPLACED CABIN PRESSURE CONTROLLER #2 PER AMM 21-31-01 AND ACCSDR AALA202007319009Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PRESSURE DECK OF OF RH UPPER WHEEL WELL AT STA 663 BETWEEN RBL 40 AND RBL 45, MEASURING L=0.6 IN, W=0.3 IN, D=0.4 IN. ACCOMPLISHED PERMANENT REINFORCING DOUBLER REPAIR IAW SRM 57-10-10-2R-3.SDR AALA202007309007Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED FLOOR SUPPORT AT BS 325, LBL 42, MEASURING L=1.5 IN, W=0.003 IN. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA202007309006Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED FLOOR SUPPORT AT BS 315, LBL 42, MEASURING L=1.375 IN, W=0.001 IN. REPLACED THE FLOOR SUPPORT IAW 51-00-05, AND DRAWING 141A400.SDR AALA2020072749008Light · defectiveAIRCRAFT IN BASE MAINTENANCE - EMERGENCY LIGHT BLINKING, SEAT 17F OVERHEAD BIN EMERGENCY EXIT LIGHT. MEL07-1392-C AUTHORIZED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-22-00, OPERATIONAL CHECK NORMAL, CLEARED MEL.SDR AALA2020072749001Aoa · malfunctionedAIRCRAFT NOT GROUNDED - INTERMITTENT SPEED LIMIT INDICATION ON CAPTAIN'S PRIMARY FLIGHT DISPLAY (PFD). LOW AIRSPEED WARNING HOOK DISAPPEARS AT SAME TIME. REMOVED AND REPLACED LEFT ANGLE OF ATTACK (AOA) SENSOR PER AMM 34-21-05, ALL REQUIRED CHECKS PASS.SDR AALA2020080769024Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LT SIDE PLATE BETWEEN BS 500A AND 500I, MEASURING L=118 IN, W=0.5 IN, D=0.02 IN. REPLACED SIDE PLATE WITH NEW IAW SRM 53-00-53-2R-5.SDR AALA2020080769023Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RT SIDE PLATE BETWEEN BS 500A AND 500I, MEASURING L=160 IN, W=0.5 IN, D=0.02 IN. REPLACED SIDE PLATE WITH NEW IAW SRM 53-00-53-2R-5.SDR AALA2020072329018Sign · inoperativeAIRCRAFT NOT GROUNDED, EMERGENCY EXIT IDENTIFIER, ROW 16DEF FORWARD, INOPERATIVE. REMOVED AND REPLACED THE OVERWING EMERGENCY EXIT IDENTIFIER IAW AMM 33-51-01, OPERATIONAL CHECKED OKAY.SDR AALA2020072319015Starter Gen · burnedAIRCRAFT WAS GROUNDED: ON APU POWER- ALL AC BUSSES TRIPPED OFF AND STRONG ELEC SMOKE SMELL FOR APPROX 1 MINUTE. NO COCKPIT C/BS POPPED. APU OPERATION NORMAL. SMOKE/BURN SMELL THROUT ENTIRE CABIN. MEL 07-1260DC-C. UPON FURTHER INSPECTION FOUND APU STARTER GENESDR AALA202007219005Door · lack of lubeAIRCRAFT NOT GROUNDED - L1 DOOR DIFFICULT TO OPEN/CLOSE. LUBRICATED L1 DOOR PER AMM 12-25-11, OPERATIONAL CHECK GOOD.SDR AALA202007219006Slide · out of adjustAIRCRAFT NOT GROUNDED - SLIDE DRAGS WHEN L1 DOOR OPENED/CLOSED. ADJUSTED SLIDE Z-FOLD MATERIAL ON L1 DOOR SLIDE PACK UNTIL SLIDE NO LONGER DRAGS, PER AMM 25-66-00. NO DEFECTS NOTED AT THIS TIME.SDR AALA2020072219023Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE, CRACKED RIB VERTICAL STIFFENER FOR THE RT HORIZONTAL STABILIZER AT HSS 101.9. REPAIRED WITH REINFORCEMENT ANGLES IAW SRM 55-10-09-2R.SDR AALA2020072209017Control Unit · defectiveAIRCRAFT WAS GROUNDED: PASSING 13,500 BAT DISCHARGE LIGHT ILLUMINATED . AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ORF WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT. REPLACED BATTERY CHARGER PER AMM 24-31-21,(AALA202007199006) REPLACED STATIC INSDR AALA2020072209016Battery · defectiveAIRCRAFT WAS GROUNDED: PASSING 13,500 BAT DISCHARGE LIGHT ILLUMINATED . AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ORF WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT.REPLACED BATTERY CHARGER PER AMM 24-31-21, REPLACED STATIC INVERTER PER AMM 24-3SDR AALA202007209015Inverter · defectiveAIRCRAFT WAS GROUNDED: PASSING 13,500 BAT DISCHARGE LIGHT ILLUMINATED . AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ORF WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT.REPLACED BATTERY CHARGER PER AMM 24-31-21,REPLACED STATIC INVERTER PER AMM 24-34-SDR AALA2020072299006Charger · defectiveAIRCRAFT WAS GROUNDED: PASSING 13,500 BAT DISCHARGE LIGHT ILLUMINATED . AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ORF WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT.REPLACED BATTERY CHARGER PER AMM 24-31-21, REPLACED STATIC INVERTER PER AMM 24-3SDR AALA202007219010Sensor · inoperativeAIRCRAFT NOT GROUNDED - (REPEAT ISSUE) AT CRUISE, N1 DID NOT GO TO CLIMB. MEL 07-1046-C AUTOTHROTTLE SYSTEM AUTHORIZED. REMOVED AND REPLACED LEFT ANGLE OF ATTACK (AOA) SENSOR PER AMM 34-21-05, ACCOMPLISHED AOA SYSTEM TEST, SYSTEM OPERATIONS CHECK NORMAL. REISDR AALA2020072089067Smoke Detector · false activationAIRCRAFT NOT GROUNDED, RIGHT AFT LAVATORY SMOKE DETECTOR ALERT SOUNDED PER FLIGHT ATTENDANT. REMOVED AND REPLACED THE RIGHT AFT LAV SMOKE DETECTOR IAW AMM 26-14-01, OPS CHECKED GOOD,
Back to Boeing 737-823