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 AALA202402283649Channel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT CHANNEL FORWARD SIDE OF BS 540, WL 204, RBL 2. REPLACED CHANNEL PER SRM 51-40-02.SDR AALA202402279798Adiru · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: BOTH IRS FAILED AFTER TAKEOFF, AIRCRAFT RETURN TO AND LANDED SAFELY AT MBJ. **SUPPLEMENTAL REPORT FOR (AALA202402269798): REMOVED AND REPLACED (ADIRU) AIR DATA INERTIAL REFERENCE LEFT (AALA202402269798)SDR AALA202402276369Adiru · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: BOTH IRS FAILED AFTER TAKEOFF, AIRCRAFT RETURN TO AND LANDED SAFELY AT MBJ. **SUPPLEMENTAL REPORT FOR (AALA202402269798): REMOVED AND REPLACED (ADIRU) AIR DATA INERTIAL REFERENCE LEFT (AALA202402269798)SDR AALA202402270569Display · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: BOTH IRS FAILED AFTER TAKEOFF, AIRCRAFT RETURN TO AND LANDED SAFELY AT MBJ. **SUPPLEMENTAL REPORT FOR (AALA202402269798): REMOVED AND REPLACED (ADIRU) AIR DATA INERTIAL REFERENCE LEFT (AALA202402269798)SDR AALA202402273424Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR GIRT BAR IS MISSING RED HEAT SHRINK. INSTALLED MISSING HEAT SHRINK TUBING. PER AARD 25-66-00-4.SDR AALA202402275984Collar · misinstalledAIRCRAFT WAS NOT GROUNDED: LEFT AFT SERVICE DOOR GIRT BAR MISSING WHITE COLLARS STOP. FOUND WHITE COLLAR AND REINSTALLED. PER AMM 52-20-00.SDR AALA202402260042Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT AT RIGHT HAND AFT DOOR INOPERATIVE. RELAMPED EXTERIOR EMERGENCY LIGHT AT RIGHT HAND AFT DOOR. PER AMM 33-51-04.SDR AALA202402268212Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND L1 DOOR FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED L1 DOOR FLIGHT ATTENDANT FLASHLIGHT. PER AMM 25-64-00.SDR AALA202402265585Access Door · unsecureAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: AFTER TAKEOFF AND RAISING THE LANDING GEAR LEVER, THE LANDING GEAR WILL NOT COME UP, AIRCRAFT AIR INTERRUPTED BACK AND LANDED SAFELY AT CLE. FOUND MANUAL LANDING GEAR EXTENSION ACCESS DOOR NOT FUSDR AALA202402263276Autopilot Sys · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: BOTH AUTOPILOTS INOPERATIVE IN FLIGHT, AIRCRAFT RETURN TO AND LANDED SAFELY AT JFK. FOUND AUTO STAB TRIM CUTOUT-TRIM CUTOUT FAULT ON DFCS BITE CHANNEL "A" AND "B". RETURNED THE STAB TRIM CUTOUT SWITCH TOSDR AALA202402269798Irs · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: BOTH IRS FAILED AFTER TAKEOFF, AIRCRAFT RETURN TO AND LANDED SAFELY AT MBJ. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406106376Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S27R BETWEEN STA 747 AND STA 767. REPLACED STRINGER PER EA 353348 AND AARD 51-00-0501.SDR AALA202406100919Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S27R BETWEEN STA 767 AND STA 787. REPAIRED STRINGER PER EA 353348.SDR AALA202406101545Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE; CORROSION ON STRINGER S27R BETWEEN STA 787 AND STA 807. REPLACED STRINGER PER EA 353348 AND AARD 51-00-05-1.SDR AALA202406078400Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S27R BETWEEN STA 807 AND STA 827. REPAIRED STRINGER PER SRM 51-10-02.SDR AALA202404090548Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL FROM BS 927 TO BS 947, S27L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404095279Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL FROM BS 927 TO BS 947, S27L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403055842Holder · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT GIRT BAR TIEDOWN LOCATED AT BS 344 AND LBL 64. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202403010123Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR WILL NOT OPEN. ADJUSTED LAVATORY D DOOR. PER CMM 25-40-64. FUNCATIONAL CHECK GOOD **(CLOSED).SDR AALA202402278041Actuator · shortedAIRCRAFT WAS GROUNDED: FOUND FUEL CROSS FEED CIRCUIT BREAKER POPPED. REMOVED AND REPLACED FUEL CROSS FEED ACTUATOR. PER AMM TASK 28- 22-21, OPERATIONAL CHECK GOOD.SDR AALA202402266519Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY-D LOCK IS DIFFICULT TO USE FROM THE INSIDE. ADJUSTED DOOR ON LAVATORY-D. PER CMM 25-47-21. FUNCTIONAL CHECK NORMAL.SDR AALA202402269075Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT BELOW RIGHT HAND AFT OUTBOARD FLIGHT ATTENDANT SEAT DEAD BATTERY. REPLACED BATTERY FOR EMERGENCY FLASHLIGHT BELOW RIGHT HAND AFT OUTBOARD FLIGHT ATTENDANT SEAT. PER AMM 25-64-00.SDR AALA202402265754Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT BELOW RIGHT HAND AFT INBOARD FLIGHT ATTENDANT SEAT DEAD BATTERY. REPLACED BATTERY FOR EMERGENCY FLASHLIGHT BELOW RIGHT HAND AFT INBOARD FLIGHT ATTENDANT SEAT. PER AMM 25-64-00.SDR AALA202402260123Door · stuckAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR WILL NOT OPEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402263894Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL AT STA 727G AND S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5.SDR AALA202402263536Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BRAKE ASSEMBLY AT BS 540, FROM BL 0 TO RBL 25. REPAIRED BRAKE ASSEMBLY PER SRM 51-40-05-0G.SDR AALA202406075536Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE; CORROSION ON S27R BETWEEN STA 727I AND STA 727J. REPAIRED STRINGER PER EA 353348 AND AARD 51-00-05-1.SDR AALA202403133788Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD FROM BS 767 TO BS 787, RBL 34. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202403040156Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION SHIELD FROM STA 500 TO STA 500A, S25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA202402278622Interrupter · faultyAIRCRAFT WAS GROUNDED: LEFT CENTER BOOST PUMP LOW PRESSURE ILLUMINATED WHEN TURNED ON. UNABLE TO USE CENTER TANK FUEL. REMOVED AND REPLACED RIGHT CENTER FUEL TANK RELAY (UFI) UNIVERSAL FAULT INTERRUPTER M09902 (AALA202402268622), AND CENTER LEFT FUEL TANK RELASDR AALA202402275244Relay · faultyAIRCRAFT WAS GROUNDED: LEFT CENTER BOOST PUMP LOW PRESSURE ILLUMINATED WHEN TURNED ON. UNABLE TO USE CENTER TANK FUEL. REMOVED AND REPLACED RIGHT CENTER FUEL TANK RELAY (UFI) UNIVERSAL FAULT INTERRUPTER M09902 (AALA202402268622), AND CENTER LEFT FUEL TANK RELASDR AALA202402276890Interrupter · faultyAIRCRAFT WAS GROUNDED: LEFT CENTER BOOST PUMP LOW PRESSURE ILLUMINATED WHEN TURNED ON. UNABLE TO USE CENTER TANK FUEL. REMOVED AND REPLACED RIGHT CENTER FUEL TANK RELAY (UFI) UNIVERSAL FAULT INTERRUPTER M09902 (AALA202402268622), AND CENTER LEFT FUEL TANK RELASDR AALA202402263656Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D BIFOLD DOOR STICKING. ADJUSTED LAVATORY-D BIFOLD DOOR AS REQUIRED.SDR AALA202402264044Slide · will not armAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS 1L DOORS HARD AND DIFFICULT TO ARM. REMOVED AND REPLACED 1L DOOR SLIDE ASSEMBLY. PER WORK CARD 08L22125001.SDR AALA202402264884Door · lockedAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR WILL NOT OPEN. UNLOCKED DOOR AS REQUIRED.SDR AALA202402265494Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT SIGN DANGLING AT 18C. RESECURED EMERGENCY LIGHT. PER CMM 25-23-67.SDR AALA202402237295Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL AT BS 500C, S26R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202404099730Stringer · crackedAIR CART IN BASE MAINTENANCE: CRACK IN UPPER FLANGE OF RIGHT WING STRINGER #9 FROM WS 485 TO WS 591. REPLACED STRINGER PER EA 352320.SDR AALA202403256842Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, RBL 53. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403134421Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN L1 DOOR FRAME LOWER INNER CHORD AT STA 302, LBL 55. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202403137405Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR LOWER SILL CHORD FROM BS 947 TO BS 983. REPLACED CHORD PER AARD 51-00-05-01.SDR AALA202403078642Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION UPPER CHORD OF AFT PASSENGER CABIN FLOOR BEAM AT BS 947, RBL 50. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202403072364Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403019998Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BRAKE ASSEMBLY PANEL AT BS 540, BL 0. REPLACED BRAKE ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202403019253Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BRAKE ASSEMBLY PANEL AT BS 540, LBL 2. REPLACED BRAKE ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202402286626Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, RBL 32. REPLACED INTERCOSTAL PER AARD 51-40-02.SDR AALA202402281124Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344, LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-02 .SDR AALA202402284032Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 328 TO BS 344, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02 .SDR AALA202402274917Brake Sys · out of adjustAIRCRAFT WAS GROUNDED: AIRCRAFT PULLED VERY HARD TO THE LEFT DURING LANDING ROLL REQUIRING EXCESSIVE RIGHT PEDAL FORCE TO MAINTAIN CENTERLINE. ACCOMPLISHED HYDRAULIC BRAKE SYSTEM ADJUSTMENTS (AALA202402264917), PER AMM 32-41-00, TAXI CHECK GOOD. REMOVE AND REPSDR AALA202402273278Pulley · bindingAIRCRAFT WAS GROUNDED: AIRCRAFT PULLED VERY HARD TO THE LEFT DURING LANDING ROLL REQUIRING EXCESSIVE RIGHT PEDAL FORCE TO MAINTAIN CENTERLINE. ACCOMPLISHED HYDRAULIC BRAKE SYSTEM ADJUSTMENTS (AALA202402264917), PER AMM 32-41-00, TAXI CHECK GOOD. REMOVE AND REP
Back to Boeing 737-823