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 AALA202411213583Screw · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR WILL NOT STAY SHUT OR OPEN. SECURED STICKING OUT SCREW IN UPPER DOOR RAIL DOOR OPERATES NORMALLY.SDR AALA202411218011Unknown · odorAIRCRAFT WAS GROUNDED: IT WAS A STRONG SMELL OF EXHAUST. IT WAS DURING TAXI BACK TO THE GATE. IT WAS NOT DURING THE TAXI OUT. THE SMELL LASTED ABOUT 5 TO 10 MINUTES BEFORE WE SHUT DOWN THE ENGINES. THE AIR CONDITIONING SYSTEM WAS CONFIGURED WITH A BLEED OFF ANSDR AALA202411212232Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH IN MODERATE ICING CONDITIONS, LEADING EDGE FLAPS TRANSITION LIGHT ILLUMINATED AND STAYED ON DURING APPROACH; AIRCRAFT LANDED SAFELY AT MSP. PERFORMED FSU BITE PER FIM 27-51-00. NO ACCIVE SDR AALA202411217019Warning Message · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH IN MODERATE ICING WE ENCOUNTERED AIRSPEED UNRELIABLE INDICATIONS. PRIMARILY, MIN MANEUVER AND STALL SPEED INDICATORS CONVERGED WITH MAX MANEUVER SPEED BAND CREATING 3 KT "COFFIN CORNER"; SDR AALA202412197389Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND HORIZONTAL STABILIZER REAR SPAR TERMINAL FITTING LOWER LUG AFT FACE AT RBL 83.05. REPAIRED PER JOB CARD 08L30055002.SDR AALA202412198823Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR TERMINAL FITTING LOWER LUG AFT FACE AT LBL 83.05. REPAIRED PER JOB CARD 08L30055002.SDR AALA202412066094Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO FORWARD FLOOR SHIELD TRANSITION PANEL HAS CORROSION AT FASTENER HOLES. LOCATED AT BS-787 RBL-35. REMOVE AND REPLACED TRANSITION PANEL PER SRM 52-00-05-1.SDR AALA202411296518Baffle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED FASTENER HOLE IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED FROM STA 500D TO STA 500E AT LBL 23. REPLACED BAFFLE PER AARD 53-00-01-6 AND SRM 53-30-53-2R-1SDR AALA202411270528Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T CAP) AT STA 986, RBL 47. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202411277223Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 318, LBL 45. REPLACED INTERCOSTAL PER AARD 53-00-05-1.SDR AALA202411271507Baffle · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE TO HOLES IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE BETWEEN STA 500A TO STA 500B, LBL 23. REPLACED BAFFLE PER AARD 53-00-05-01 AND SRM 53-30-53.SDR AALA202411267608Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT STA 950, LBL 27. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA202411255732Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND SIDE SHIELD LOCATED FROM STA 850 TO STA 867, S26R. REPLACED SHIELD PER SRM 51-40-02.SDR AALA202411253076Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD LOCATED FROM STA 767 TO STA 787, S26R. REPLACED SHIELD PER SRM 51-40-02.SDR AALA202411210348Pin · missingAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR - EMERGENCY ESCAPE SLIDE GIRT BAR STOP IS MISSINGL OCKING PIN. REMOVED AND REPLACED GIRT BAR CLIP PIN. PER B737 NG AMM 25-66-01-400-803.SDR AALA202411212656Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT AT FORWARD R1 DOOR INOPERATIVE. RELAMPED AND STILL INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202411202656): CLEANED THE HOUSING OF THE FORWARD R1 DOOR EMERGENCY LIGHT, AND REPLACED THE LAMP. PER AMM 33-51-0SDR AALA202411202656Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT AT FORWARD R1 DOOR INOPERATIVE. RELAMPED AND STILL INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202412024238Engine · overheatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF NUMBER 1 ENGINE OVERHEAT AND ENGINE FIRE LIGHTS CAME ON WITH ASSOCIATED HIGH ENGINE TEMP INDICATIONS. PERFORMED ENGINE FIRE QRC AND BLE NUMBER 1 FIRE BOTTLE AND SECURED THE LEFT ENGINE; AIRCRASDR AALA202411269369Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 954, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411200099Connector · wrong partAIRCRAFT IN BASE MAINTENANCE: SEAT 12 FED AND 18 ABC BULLNOSE LIGHTS WILL NOT ILLUMINATE DURING TEST. FOUND CONNECTORS TO BE THE WRONG CONNECTORS, RECONNECTED WITH CORRECT CONNECTORS, PERFORMED SATISFACTORY OPERTIONAL CHECK GOOD. PER B737-NG AMM 33-51-00.SDR AALA202411205457Socket · dirtyAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD ENTRY DOOR SLIDE LIGHT WILL NOT ILLUMINATE DURING TEST. CLEANDED TERNIMAL LUGS AT SOCKET OF LEFT HAND FORWARD ENTRY DOOR SLIDE LIGHT, PERFORMED SATISFACTORY OPERTIONAL CHECK GOOD. PER B737-NG SWPM 20-30-00 AND AMSDR AALA202411208279Elec Connector · looseAIRCRAFT IN BASE MAINTENANCE: LEFT HAND CABIN SEAT 19-25 EMERGENCY LIGHT WILL NOT ILLUMINATE DURING TEST. FOUND CONNECTORS LOOSE, CHECKED AND ADJUSTED, PERFORMED SATISFACTORY OPERTIONAL CHECK GOOD. PER B737-NG AMM 31-51-00.SDR AALA202411200556Ballast · burnedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED SEAT 17F EMERGENCY EXIT SIGN LIGHT ILLUMINATED INFLIGHT. COULD NOT SHUT OFF BY CYCLING LIGHTS. ALSO REPORTED HOT SMELL COMING FROM GALLEY GASPER AT APPROXIMATELY THE SAME TIME. REMOVE AND REPLACED BALLAST (ASDR AALA202411204123Sign · shortedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED SEAT 17F EMERGENCY EXIT SIGN LIGHT ILLUMINATED INFLIGHT. COULD NOT SHUT OFF BY CYCLING LIGHTS. ALSO REPORTED HOT SMELL COMING FROM GALLEY GASPER AT APPROXIMATELY THE SAME TIME. REMOVE AND REPLACED BALLAST (ASDR AALA202411204703Sill Drain · cloggedAIRCRAFT WAS NOT GROUNDED: SMELL (ROTTEN EGGS) EMANATING FROM AFT CABIN UPON LANDING. FOUND CAUSE OF SMELL IN AFT GALLEY, AFT SILL DRAIN FLOAT VALVE COMPLETELY CLOGGED. REMOVED AND REPLACED AFT SILL DRAIN FLOAT VALVE. PER AMM 38-31-06-400-802. POURED WATER DOWSDR AALA202411194916Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN. AFTER USING CODE, KEYPAD LIGHT GOES FROM AMBER TO GREEN ON SCHEDULE, HOWEVER, THE DOOR DOES NOT UNLOCK. LUBED DOOR LATCH , OPERTIONAL CHECK GOOD.SDR AALA202411190081Sign · missingAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORTS EMERGENCY EXIT LIGHT NEXT TO LEFT AFT SERVICE DOOR IS MISSING. REPLACED EMERGENCY EXIT LIGHT SIGN AT 2L DOOR. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202411194238Fire Warning · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF NUMBER 1 ENGINE OVERHEAT AND ENGINE FIRE LIGHTS CAME ON WITH ASSOCIATED HIGH ENGINE TEMP INDICATIONS. PERFORMED ENGINE FIRE QRC AND BLE NUMBER 1 FIRE BOTTLE AND SECURED THE LEFT ENGINE; AIRCRASDR AALA202411196891Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL LOCATED AT STA 540, BL 0. REPLACED BREAK ASSEMBLY PANEL PER SRM 51-40-02-0G.SDR AALA202411255094Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED FROM STA 500C TO STA 500D. REPLACED BAFFLE PER AARD 51-00-05-01.SDR AALA202411200032Elec Connector · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT INOPERATIVE AT SEAT ROW 24ABC. RESEATED D11321 CONNECTOR FOR EMERGENCY LIGHT AT SEAT ROW 24ABC. PER B737-NG WDM 33-51-14 AND B737-NG SWPM 20-60-06. PERFORMED A SATISFACTORY EMERGENCY LIGHTS OPERATIONAL TEST FOR EMESDR AALA202411180362Battery · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT AFT MEGAPHONE IS INOPERATIVE. FOUND MEGAPHONE TO BE MISSING BATTERIES, INSTALLED BATTERIES AND OPERTIONAL CHECKED GOOD. PER AMM 25-64-00.SDR AALA202411183820Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT MEGAPHONE IS INOPERATIVE. REMOVED AND REPLACED AFT MEGAPHONE. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202411183784Indication Sys · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONFIGURING FOR LANDING RECEIVED A LEADING EDGE FLAPS TRANSIT INDICATION WITH THE TRAILING EDGE FLAPS EXTENDED AND FLAP POSITION AGREEING WITH THE FLAP HANDLE. THE NUMBER 8 SLAT SEGMENT INDICATED IT WAS SDR AALA202412232793Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T CAP) AT STA 967, LBL 48. REPAIRED UPPER CHORD PER EA 359967.SDR AALA202411186098Latch · unserviceableAIRCRAFT IN BASE MAINTENANCE: L-2 SLIDE PACK LATCH IS UNSERVICABLE. REMOVED AND REPLACED SLIDE PACK LATCH AT L-2 DOOR. SATISFACTORY CHECK GOOD. PER B737-NG AMM 25-66-01.SDR AALA202411184117Pressure Switch · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT TOP OF CLIMB SPOILER LIGHT ILLUMINATED. AFTER LANDING MASTER CAUTION AND MAINTENANCE LIGHT ILLUMINATED; AIRCRAFT LANDED SAFELY AT MIA. REPLACED ARM SOLENOID PRESSURE SWITCH. ACCOMPLISHED ALL TEST REQUSDR AALA202411182043Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON APPROACH THE FLAPS WOULD NOT EXTEND TO 30 BUT THEY DID EXTENDTO 25. AIRCRAFT ABORTED APPROACH AND LANDED SAFELY AT ORD. BITE CHECK OF FSEU NOTED NO FAULTS, PER FIM 27-51-00-810-801 VISUALLY CHECKED FLSDR AALA202411182056Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411182469Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411189302Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411184303Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411181255Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411183516Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411184922Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411189858Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411186964Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202411181785Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202412234085Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 954 AT LBL 50. REPLACED INTERCOSTAL PER EA 359967.SDR AALA202411154908Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE EMERGENCY EXTERIOR LIGHT INOPERATIVE. RELAMPED AND OPERTIONAL CHECK GOOD. PER AMM 33-51-04.
Back to Boeing 737-823