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 AALA202505307235Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER NUMBER 1 FLIGHT ATTANDENT JUMPSEAT THE (FORWARD JUMPSEAT) GREEN BLINKING LIGHT IS NOT ILLUMINATING. REMOVED AND REPLACED FORWARD JUMP SEAT EMERGENCY FLASHLIGHT WITH 4R JUMP SEAT EMERGENCY FLASHLIGHT. PER MM 25-64-00.SDR AALA202505303280Girt Bar · misalignedAIRCRAFT WAS NOT GROUNDED: LEFT CLIP THAT HOLDS GIRT BAR ON FORWARD ENTRY DOOR MAKES IT REALLY HARD TO REMOVE GIRT BAR. ALIGNED AND LUBRICATED GIRT BAR ON FORWARD ENTRY DOOR. PER AMM 25-66-01. OPERTIONAL CHECKED GOOD.SDR AALA202505302127Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND RAM AIR MODULATION DEFLECTOR DOOR CHANNEL AT BS 500G FROM S22L TO S24L. REPLACED CHANNEL PER 51-40-02-OG.SDR AALA202505300894Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND ECS BAY AFT VAPOR BARRIER UPPER INBOARD ATTACH ANGLE AT BS 663 FROM LBL 5 TO LBL 15. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202506261979Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 27 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202506262294Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202506198974Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUTOUT BRACKET AT BS 847, S24R. REPLACED BRACKET PER AARD 51-00--05-1.SDR AALA202506130837Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL ASSEMBLY AT BS 500I, LBL 20. REPLACED RAIL ASSEMBLY PER AARD 51-00-05-1.SDR AALA202506134068Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER S23L CHORD AT BS 338. REPAIRED CHORD PER EA 365282.SDR AALA202505294704Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT BULKHEAD PANEL 141TW AT BS 947, S10. REPAIRED PER SRM 51-10-02.SDR AALA202505292370Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202505298938Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202505287908Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 537.45, RBL 4. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202505289922Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 537.45, LBL 3. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202506195701Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR LOWER SILL INNER CHORD (CREASE ANGLE) FROM BS 308 TO BS 320 AT LBL 52. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202506190427Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED FORWARD GIRT BAR TIEDOWN AT BS 312, LBL 55. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202506190955Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 956 TO BS 959 AT RBL 50 REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506133686Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 490 TO BS 500B PLUS 12 INCHES, AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1SDR AALA202506139253Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B TO BS 500I AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506134119Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500D TO BS 500E PLUS 10 INCHES, AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202506135385Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 59. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202506137318Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, RBL 53. REPAIRED CHORD PER SRM 53-70-51-2R-6.SDR AALA202506137083Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, FROM LBL 15 TO RBL 15. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202506138840Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 956 TO BS 959 AT LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506050973Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, FROM LBL 29 TO LBL 35. . REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA202505294440Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER, RIGHT MLG WHEEL WELL. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9.SDR AALA202505288568Air Filter · odorAIRCRAFT WAS GROUNDED: FOUL ODOR INTHE AFT GALLEY. REMOVE AND REPLACED BOTH LEFT (AALA202505284604) AND RIGHT (AALA202505288568) RECIRCULATION FAN AIR FILTERS. PER MM 21-25-01.SDR AALA202505285788Gust Lock · lack of lubeAIRCRAFT WAS GROUNDED: GUST LOCK WILL NOT RELEASE. LUBED GUEST LOCK AREA. PER AMM52-11-21. OPERTIONAL CHECK GOOD.SDR AALA202505280538Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR IS HARD TO OPEN. READJUSTED LAVATORY-A DOOR LATCH. PER AMM 25-40-11.SDR AALA202505284604Air Filter · odorAIRCRAFT WAS GROUNDED: FOUL ODOR INTHE AFT GALLEY. REMOVE AND REPLACED BOTH LEFT (AALA202505284604) AND RIGHT (AALA202505288568) RECIRCULATION FAN AIR FILTERS. PER MM 21-25-01.SDR AALA202505296757Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: LEFT DUCT PRESSURE WENT TO ZERO AFTER TAKEOFF, N1 SPLIT UP TO 4%, REPEAT WRITE UP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED MW0311 HARNESS ON LEFT ENGINE. OPERSDR AALA202505285710Elec Connector · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT TAKEOFF ROTATION, THE TAKE OFF CONFIGURATION WARNING HORN SOUNDED. THE HORN SILENCED SHORTLY AFTER, HOWEVER THE FLAPS WOULD NOT RESPOND HYDRAULICALLY TO FLAP HANDLE MOVEMENT. THE FLAPS REMAINED IN TAKSDR AALA202505286757Bleed Air Sys · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: LEFT DUCT PRESSURE WENT TO ZERO AFTER TAKEOFF, N1 SPLIT UP TO 4%, REPEAT WRITE UP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. (OPEN).SDR AALA202505286528Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR STUCK AND IS HARD TO OPEN. RESECURED AFT RIGHT LAVATORY DOOR. PER CMM 25-40-64.SDR AALA202505283224Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER MOVING FLAPS FROM 25 TO 30 FOR LANDING THEY REMAINED AT 25, FLAPS WOULD NOT RETRACT DURING GO AROUND. AIRCRAFT EMERGENCY LANDED SAFELY AT ORD. COMPLETED REMAINING STEPS OF FIM 27-51-00-810-830. NO SDR AALA202505289256Fuel Sys · out of balanceAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF HAD A FUEL IMBALANCE OF OVER 1000LBS, FUEL WOULD NOT REBALANCE. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CLE. ACCOMPLISHED ENGINE FUEL FEED PUMPS FUNCTIONAL TEST, PER AMM 28-22SDR AALA202505282559Interrupter · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT CENTER FUEL TANK PUM LOW PRESSURE LIGHT ILLUMINATED WITH ENGINES RUNNING. CONFIRMED CENTER RIGHT PUMP UFI FAILURE, PER FIM 28-22-301. REMOVE AND REPLACED RUGHT CENTER (UFI)-UNIVERSAL FAULT INTERRUPTER, PER AMM 28-22-99. OPERTIOSDR AALA202505280696Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH MEGAPHONES NEED NEW BATTERIES. REPLACED BOTH MEGAPHONE BATTERIES (AALA202505280623) AND (AALA202505280696). PER JC 08C20025010.SDR AALA202505280623Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH MEGAPHONES NEED NEW BATTERIES. REPLACED BOTH MEGAPHONE BATTERIES (AALA202505280623) AND (AALA202505280696). PER JC 08C20025010.SDR AALA202505283033Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 19FED EMERGENCY OVERHEAD LIGHT INOPERATIVE. REMOVE AND REPLACED EMERGENCY AISLE LIGHT AT 19FED. PER AMM 33-51-03. OPERTIONAL CHECK GOOD.SDR AALA202506029094Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN RIGHT HAND SILL WEB BETWEEN BS 927 AND BS 950. REPLACED WEB PER AARD 51-00-05-1 AND EA364911.SDR AALA202505301248Sensor · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 4 LEADING EDGE DEVICE LIGHT ILLUMINATED AT APPROXIMATELY 1200FT ON FINAL AFTER 30 FLAPS AND GREEN LEADING EDGE FLAPS EXTENDED LIGHT ILLUMINATED. LEADING EDGE TRANSIT LIGHT CAME ON AND A GO AROUND SDR AALA202505281108Warning Light · false activationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: EQUIPMENT COOLING EXHAUST OFF LIGHT ILLUMINATED DURING FLIGHT. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED EXHAUST LOW FLOW DETECTOR SENSOR. PER AMM 21-21-03. OPERSDR AALA202505288321Oven · smokeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS RIGHT HAND OVEN HAS A BURNING RUBBER SMELL AND SOME SMOKE WHEN TURNED ON. REMOVED AND REPLACED FORWARD GALLEY RIGHT OVEN. PER AMM 25-32-02. OPERTIONAL CHECK GOOD.SDR AALA202505281203Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE AND LOCK. LUBRICATED HINGE POINTS AND UPPER ROLLER OF LAVATORY-D DOOR. PER CMM 25-40-64. OPERTIONAL CHECK GOOD.SDR AALA202505282167Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT ADVISED US THAT AFT LEFT LAV DOOR KEEPS GETTING STUCK. REMOVE AND REPLACED AFT LAVATORY-D TOP DOOR ROLLER. PER CMM 25-40-64.SDR AALA202505283768Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 887, S26L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5 AND AARD 51-00-05-1.SDR AALA202506104795Spring · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ELEVATOR CONTROL TAB MECHANISM SPRING SUPPORTS RUST. REMOVED AND REPLACED RIGHT ELEVATOR CONTROL TAB MECHANISM SPRINGS SUPPORT BUSHINGS. PER B737NG-AMM-27-31-34 AND PERFORMED SATISFACTORY OPERTIONAL CHECKS. PER B737NG ASDR AALA202505281723Control Handle · bindingAIRCRAFT WAS NOT GROUNDED: AFTER LANDING GEAR RETRACTION MOVING LANDING GEAR HANDLE TO OFF POSITION LANDING GEAR HANDLE WAS STICKING AND DIFFICULT TO DETERMINE IF THE LANDING GEAR HANDLE WAS IN THE OFF POSITION. ACCOMPLISHED LANDING GEAR CONTROL TEST, PER AMSDR AALA202505280888Sliding Window · stuckAIRCRAFT WAS NOT GROUNDED: CAPTAIN EXIT WINDOW IS VERY HARD TO OPEN AND GETS STUCK. LUBED CAPTAIN EXIT WINDOW TRACK. PER AMM 20-30-21. OPERTIONAL CHECK GOOD AT THIS TIME.
Back to Boeing 737-823