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 AALA202310269505Socket · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL TANK PUMP WILL NOT SHUT OFF. REPLACED CONNECTOR (AALA202310266531) AND SOCKETS (AALA202310269505) ON D872, RIGHT AFT FUEL PUMP PRESSURE SWITCH. PER SWPM 20-61-11 AND WDM 28-43-11. OPERATIONAL CHECK PASSED.SDR AALA202310242814Girt Bar · damagedAIRCRAFT WAS NOT GROUNDED: FOUND HEAT SHRINK TUBING MISSING ON BOTH ENDS OF THE L1 DOOR SLIDE GIRT BAR. INSTALLED HEAT SHRINK TUBING ON L1 DOOR. PER AARD 25-66-00-4.SDR AALA202310248296Brake Assy · seizedAIRCRAFT WAS GROUNDED: AIRCRAFT BRAKES LOCKED UP, PREVENTED AIRCRAFT FROM TAXIING TO GATE. REMOVED AND REPLACED MLG BRAKE ASSEMBLY NUMBER 1 (AALA202310238296) AND BRAKE ASSEMBLY NUMBER 2 (AALA202310231858). FUNCTIONAL CHECK GOOD. PER AMM 32-42-00-720-801SDR AALA202310241858Brake Assy · seizedAIRCRAFT WAS GROUNDED: AIRCRAFT BRAKES LOCKED UP, PREVENTED AIRCRAFT FROM TAXIING TO GATE. REMOVED AND REPLACED MLG BRAKE ASSEMBLY NUMBER 1 (AALA202310238296) AND BRAKE ASSEMBLY NUMBER 2 (AALA202310231858). FUNCTIONAL CHECK GOOD. PER AMM 32-42-00-720-801SDR AALA2023102036343Battery · no testAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FLIGHT ATTENDANT FLASHLIGHT FLASHES RED. REMOVE AND REPLACED RIGHT HAND FLIGHT ATTENDANT FLASHLIGHT BATTERY. FUNCTIONAL CHECK GOOD. PER MM 25-64-00.SDR AALA202310237908Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD INBOARD ATTENDANT FLASHLIGHT REQUIRES BATTERY REPLACEMENT. REPLACED FLASHLIGHT BATTERY PACK. FUNCTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202310234613Transmitter · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO SJU DUE TO HYDRAULIC SYSTEM A QUANTITY LEVEL LOW. AIRCRAFT LANDED SAFELY AT SJU WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED HYDRAULIC SYSTEM A QUANTITY TRANSMITTER PER 29-33-12-40SDR AALA202310234191Pitot Tube · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IAD DUE TO FIRST OFFICER'S AIRSPEED INDICATION UNRELIABLE. AIRCRAFT LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT. REPLACED FIRST OFFICER'S PITOT TUBE PER AMM 34-11-01 (AALA202310234SDR AALA202310232497Module · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IAD DUE TO FIRST OFFICER'S AIRSPEED INDICATION UNRELIABLE ON CLIMB. AIRCRAFT LANDED SAFELY AT IAD WITHOUT FURTHER INCIDENT. REPLACED FIRST OFFICER'S PITOT TUBE PER AMM 34-11-01 (AALASDR AALA202310230784Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BRACKET AT LEFT WING STA 308. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202310233503Flashlight · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT INBOARD L1 DOOR FLIGHT ATTENDANT SEAT MISSING FLASHLIGHT. REPLACED EMERGENCY FLASHLIGHT AT L1 DOOR FLIGHT ATTENDANT SEAT. PER AMM 25-64-00.SDR AALA202310315579Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT INTERCOSTAL AT BS 540 FROM BL 0 TO LBL 24.75. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202310312494Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LOWER CHORD AT WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE, STA 663, RBL 15. REPLACED CHORD ANGLE PER SRM 57-10-10-2R REPAIR 5.SDR AALA202310273586Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN AT RIB 97.7 AND FORWARD OF THE REAR SPAR. REPAIRED RIGHT HAND HORIZONTAL STABILIZER SKIN PER SRM 55-10-01-2R-11.SDR AALA202310232865Light · brokenAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT COVER BROKEN AT SEAT 10 ABC. REPLACED EMERGENCY LIGHT AT SEAT 10ABC. FUNCTIONAL CHECK GOOD. PER CMM 25-23-67 AND SWPM 20-61-11.SDR AALA202310205232Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT JUMPSEAT FLASHLIGHT NO TEST. REMOVED AND REPLACED AFT JUMPSEAT FLASHLIGHT. FUNCTIONAL CHECK GOOD. PER AMM 25-00-00.SDR AALA202310208401Mount · lack of lubeAIRCRAFT WAS NOT GROUNDED: NUMBER 1 FLIGHT ATTENDANT REPORTS FORWARD ENTRY DOOR SLIDE IS DIFFICULT TO ARM. CLEANED AND LUBED FLOOR MOUNTS. FUNCTIONAL CHECK NORMAL. PER AMM 25-66-01-200-802.SDR AALA202310193967Gust Lock · lack of lubeAIRCRAFT IN BASE MAINTENANCE: L1 DOOR GUST LOCK DIFFICULT TO OPERATE AND RELEASE. CLEANED AND LUBRICATED L1 CABIN DOOR GUST LOCK FOR SERVICEABLE OPERATION. PER AMM 52-11-21.SDR AALA202310271451Contact · inoperativeAIRCRAFT IN BASE MAINTENANCE: G7 FLOOR EMERGENCY LIGHT INOPERATIVE FOUND A DAMAGED INOPERATIVE CONTACT. REPAIRED CONTACT AND REINSTALLED G7 FLOOR EMERGENCY LIGHT, OPERATIONAL CHECK GOOD. PER B737NG AMM 34- 51-14 AND SWPM 20-10-13.SDR AALA202310207504Engine · vibrationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT CRUISE 310' HEARD A BANG AND ENGINE STARTED VIBRATING. ALL OTHER ENGINE PARAMETERS WERE NORMAL. AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT FOR (AALA202310187504): RESDR AALA202310188755Slide · out of positionAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR TAIL PART OF ATTACHED TO GIRT BAR IS HANGING TOO FAR OUT. PERFORMED FORWARD ENTRY DOOR ESCAPE SLIDE PACK AND COVER REMOVAL AND INSTALLATION. PER AMM 25-66-01-400-803.SDR AALA202310186229Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY CEILING LIGHT L01507 ABOVE LEFT HAND ROW 17 INOPERATIVE. RE-SEATED PIN A OF CONNECTOR D11321 FOR EMERGENCY CEILING LIGHT L01507. PER B737NG SWPM 20-63-02 AND WDM 33-51-13. EMERGENCY LIGHT TEST GOOD. PER IAW B737NG AMM 3SDR AALA202310187504Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT CRUISE 310' HEARD A BANG AND ENGINE STARTED VIBRATING. ALL OTHER ENGINE PARAMETERS WERE NORMAL. AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202310183033Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT FLASHLIGHT WON'T TEST. REPLACED FLASHLIGHT. PER JOB CARD 08C00005024.SDR AALA202310236009Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT ANGLE LOCATED AT BS 537.45, LBL 1. REPLACED ANGLE PER AARD 51-00-05.SDR AALA202310184608Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT NUMBER 1 DO NOT PRESS TO TEST. ADJUSTED FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHTS AND PERFORMED PRESS TO TEST. PER B737NG AMM 25-64-00SDR AALA202310189328Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT NUMBER 2 DO NOT PRESS TO TEST. ADJUSTED FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHTS AND PERFORMED PRESS TO TEST. PER B737NG AMM 25-64-00SDR AALA202310179104Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY AT BS 537.45, RBL 20. REMOVED AND REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER AARD 51-00-60.SDR AALA202310172710Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT NUMBER 1 FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVE AND REPLACED AFT NUMBER 1 FLIGHT ATTENDANT FLASHLIGHT BATTERY. FUNCTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202310170247Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO TRANSITION PANEL BETWEEN STA 500G AND STA 500H AT STR 26L. BLENDED CORROSION DAMAGE PER SRM 53-00-53-1A.SDR AALA202310160903Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR RIGHT HAND CUSP WEB IN BOARD ANGLE BETWEEN BS 674 AND BS 727, RBL 63. REPAIRED ANGLE PER SRM 53-40-13-1ASDR AALA202310168962Wire · miswiredAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1671 IS INOPERATIVE. CORRECTLY CONNECTED POWER SUPPLY WIRES. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202310168786Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M1676 IS INOPERATIVE. REPLACED POWER SUPPLY PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202310165402Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE STICKS, ROD HARD TO GET OFF. CLEANED, LUBED AND ADJUSTED BRACKET ON L1 DOOR GIRT BAR ATTACHMENT. FUNCTIONAL CHECK GOOD. PER AMM 25-66-00.SDR AALA202310192214Sensor · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY LIGHT ILLUMINATED AFTER LANDING, HANDLE CONFIRMED DOWN. DOOR WARNING SENSOR S199 OUT OF ADJUSTMENT. ADJUSTED S199 BACK INTO ADJUSTMENT ON BAR GRAPH ON PSEU. PER AMM 52-11-00.SDR AALA202310183382Axle · crackedAIRCRAFT WAS GROUNDED: FOUND IN AXLE ASSEMBLY CRACKED ON MLG NUMBER 3 DURING TIRE CHANGE. REMOVED AND REPLACED THE NUMBER 3 "IN-AXLE ADAPTER". PER AMM 32-42-11-400-801.SDR AALA202310176982Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: L2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT PER AMM 33-51-04-960-801. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202310179395Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT PER AMM 33-51-04-960-801. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202310176505Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT WING SLIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT PER AMM 33-51-04-960-801. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202310179767Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: COSSOROIN ON FUSELAGE SKIN AROUND AFT LAVATORY VENT AT BS 917, FROM S21L TO S 22L. REPAIRED SKIN PER SRM 53-70-01-2R-3.SDR AALA202310312343Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM BS 767 TO BS 793, RBL 21. REPLACED SHIELD PER SRM51-10-02-0G, AARD 51-00-05-1R, AND DWG 146A0081.SDR AALA202310181274Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. CLEANED BURRS FROM DOOR LATCH AND LUBRICATED LATCH MECHANISM.SDR AALA202310168515Light · damagedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT LEFT EMERGENCY EXIT LIGHT DAMAGED. REMOVED AND REPLACED LEFT EMERGENCY EXIT LIGHT ASSEMBLY AT LEFTOVER WING EXIT, FORWARD OF THE FORWARD EXIT. FUNCTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202310244025Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BILGE AREA SKIN INNER SURFACE, FROM STA 807 TO STA 827, S27R TO S26R. REPAIRED SKIN PER EA 348767.SDR AALA202310249522Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BILGE AREA SKIN INNER SURFACE, FROM STA 847 TO STA 867, S27R TO S26R. REPAIRED SKIN PER EA 348767.SDR AALA202310164731Compressor · stalledAIRCRAFT WAS GROUNDED: COMPRESSOR STALL ON NUMBER 1 ENGINE, DURING DECELERATION AT FL 310 DESCENDED TO FL 240. REMOVED AND INSTALLED SERVICEABLE NUMBER 1 ENGINE. PER JOB CARD 08L40072003.SDR AALA202310135448Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EMERGENCY EXIT DOOR FORWARD LOWER EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY.SDR AALA202310131180Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY D DOOR LATCH STICKING AND DIFFICULT TO LATCH AND OPEN. ADJUSTED AND LUBRICATED AFT LAVATORY D DOOR. FUNCTIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202310130892Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT OPEN. CLEANED AND LUBED AFT LEFT LAVATORY DOOR. FUNCTIONAL CHECK GOOD.SDR AALA202310139250Girt Bar · unsecureAIRCRAFT WAS GROUNDED: GIRT BAR AT L1 DOOR DIFFICULT TO REMOVE WHEN DISARMING DOOR. RESECURED SLIDE FOLD AS REQUIRED. ARM AND DISARM OF SLIDE FUNCTIONAL CHECK NORMAL. PER AMM 25-66-01.
Back to Boeing 737-823