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 AALA202504074417Air Filter · odorAIRCRAFT WAS GROUNDED: ON TAKEOFF ROLL SMELLED ODOR IN FLIGHTDECK THAT SMELLED MUSTY, FLIGHT ATTENDENTS ALSO REPORTED SMELL THROUGHOUT CABIN ON CLIMBOUT. SMELL DISSIPATED COMPLETELY AFTER APPROXIMATELY 12 MINUTES, ABOUT 15,000 FT. ACCOMPLISHED J/C 08L00021001 SDR AALA202504079952Floorboard · deterioratedAIRCRAFT WAS NOT GROUNDED: WHILE REMOVING LAVATORY-D THRESHOLD TRIM FOUND FLOORBOARD HONEYCOMB DETERIORATE. 2 OUT OF 4 NUTPLATE ARE NO GOOD 1 NUTPLATE IS COMPLETELY MISSING DUE TO THE HONEYCOMB DETERIORATION. WHERE THE THRESHOLD SITS FOR DOOR LOCKING MECHANISMSDR AALA202504078560Lock · brokenAIRCRAFT WAS NOT GROUNDED: LAVATORY-D BI-FOLD DOOR OUTER LOCK MECHANISM IS BROKEN MISSING SCREW FOR CREW TO LOCK OR UNLOCK DOOR. REMOVED AND REPLACED BROKEN OUTER LOCK DOOR MECHANISM. PER CMM -25-40-64.SDR AALA202504076463Door · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS SAID THAT LAVATORY-D DOOR IS HARD TO OPEN AND CLOSE. SECURED LOOSE LAVATORY-D FLOOR PLATE, OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202504074480Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR HARD TO OPEN AND CLOSE. AFT LAVATORY-D DOOR LATCH ADJUSTED, OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202504079478Floorbeam · scratchedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540 LBL 15. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202505073170Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 271.5, S17R, RBL 14. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA202505078113Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 275, S17R, RBL 14. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505071359Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 289 TO BS 291.5, S17R, RBL 14. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504286335Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE CREASE ANGLE AT L1 DOOR, BS 298, S17L, LBL 41. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202504283198Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN Z ANGE AT BS 979.5 LBL 48. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202504282827Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE CREASE ANGLE AT L1 DOOR, FROM BS 315 TO BS 343, AT S17L, LBL 49. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202504282915Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOR STRUCTURE INTERCOSTAL AT BS 954.5, RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504288236Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 958, S17L, LBL 49. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504166150Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 959, S17R, RBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504164624Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE AT STA 952, S17L. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202504156771Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500D TO BS 500E AT RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504140534Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT STA 857 FROM S22R TO S24R. REPAIRED PER SRM 53-00-04-1A-1.SDR AALA202504084804Transducer · faultyAIRCRAFT WAS NOT GROUNDED: ANTI-SKID INOPERATIVE LIGHT ILLUMINATED INTERMITTENTLY ON TAKE OFF ROLL ABOVE 100 KTS. LIGHT EXTINGUISHED PRIOR TO AFTER TAKEOFF CHECK. ACCOMPLISHED AACU BITE PER FIM 32-42-00-810-801. MEMORY RECALL SHOWS FAULT XDCR1. REMOVE AND REPASDR AALA202504080332Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202504081416Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202504087956Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 10 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202504084759Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202504081910Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202504070788Wire · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 GENERATOR DRIVE LIGHT CAME ON MULTIPLETIMES AND WENT OUT BEFORE DISCONNECTING; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT JFK. PARTIAL WORK ACCOMPLISHED, REPLACED WIRE W1264-300R YB-1SDR AALA202504077603Drive Assy · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WEATHER RADAR FAILED ENROUTE. ATTEMPTED TO TEST. WHEN PERFORMING THE TEST, THERE WAS A GRINDING NOISE FROM BELOW OUR FEET; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ORD. REMOVED AND REPLACES WEATHER RADASDR AALA202504074924Stop · dislodgedAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENTS REPORTS WHITE PLASTIC DONUT PIECE ON AFT SERVICE DOOR GIRT BAR CAME OFF. REMOVE AND REPLACED STOP ASSEMBLY CLIP. PER AMM 25-66-01.SDR AALA202504074097Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR LOCK STICKS IN LOCKED POSITION. LUBED MECHANISM, OPERTIONAL CHECK GOOD. PER CMM25-40-64.SDR AALA202504077975Door · stuckAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY BI-FOLD DOOR GETS STUCK HALFWAY THROUGH OPENING AND CLOSING. GREASED BI-FOLD DOOR TRACKS. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202504075687Roller · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. RESECURED LAVATORY-D ROLLER ON TOP OF DOOR. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202504079765Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR JAMMED. PERFORMED ADJUSTMENT AND TEST OF LAVATORY-D. PER CMM 25-40-64.SDR AALA202504072236Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR VERY HARD TO OPEN EVEN WITH FLIGHT DECK ACCESS SYSTEM SWITCH OFF. LUBRICATED COCKPIT DOOR LATCH, OPERTIONAL CHECK GOOD. PER MM 52-51-01.SDR AALA202504070030Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 352, LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504074293Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BALLE CLIP FROM STA 500H TO STA 500I, S26R. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202504071752Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FOWARD BAFFLE CLIP AT STA 500G, S26R. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202504077164Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT AFT BAFFLE CLIP AT STA 500G, S26R. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202504074441Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT STA 500G, S26L. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202504076457Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-+00-05-1.SDR AALA202504074376Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-+00-05-1.SDR AALA202504171528Monitor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON DESCENT BELOW 10000', ENGINE NUMBER 1 VIBRATION INDICATED AS HIGH AS 4.5. RAN CHECKLIST, CONTINUED FLIGHT WITH THRUST LEVER AT IDLE. VIBRATION INDICATION NEVER WENT BELOW 2.5. INDICATION REPEATEDLY BLSDR AALA202504102325Door Frame · deformedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FRAME 640 AT AFT OVER WING EMERGENCY EXIT AFT LOWER DOOR GUIDE LOWER INBOARD FRAME HOLE HAS AN INDICATION OF DEFECT NOTED ATTHE 12 O'CLOCK POSITION. REAMED THE HOLE TO SIZE 0.309, THE REWORK IS WITHIN LIMITS. PER B737 SSDR AALA202504097904Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, LBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6.SDR AALA202504072142Elec Connector · crackedAIRCRAFT IN BASE MAINTENANCE: BROKEN EMERGENCY LIGHT CONNECTORS AT SEAT 12ABC. REMOVE AND REPLACED PLUG SIDE OF BOTH EMERGENCY LIGHTING CONNECTORS (AALA202504072142) AND (AALA202504079130) ON SEATS 12ABC. PER SWPM 20-61-28.SDR AALA202504079130Elec Connector · crackedAIRCRAFT IN BASE MAINTENANCE: BROKEN EMERGENCY LIGHT CONNECTORS AT SEAT 12ABC. REMOVE AND REPLACED PLUG SIDE OF BOTH EMERGENCY LIGHTING CONNECTORS (AALA202504072142) AND (AALA202504079130) ON SEATS 12ABC. PER SWPM 20-61-28.SDR AALA202504070311Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: UPON ENTRY TO AIRCRAFT THROUGH R1 DOOR FOUND SLIDE DISLODGED FROM DOOR AND LAYING ON THE GALLEY FLOOR. REMOVED AND REPLACED R1 DOOR SLIDE. PER J/C 08L22125001.SDR AALA202504040630Tube · missingAIRCRAFT WAS GROUNDED: 1R DOOR GIRT BAR RIGHT HAND SAFETY CAP MISSING. INSTALLED NEW STOP RELEASE (AALA202504042132), PIN (AALA202504049949), AND A HEAT SHRINK TUBING (AALA20250404063) ON FORWARD RIGHT HAND DOOR SLIDE GIRT BAR. PER AMM 25-66-01 AND EO-2523J012SDR AALA202504049949Pin · missingAIRCRAFT WAS GROUNDED: 1R DOOR GIRT BAR RIGHT HAND SAFETY CAP MISSING. INSTALLED NEW STOP RELEASE (AALA202504042132), PIN (AALA202504049949), AND A HEAT SHRINK TUBING (AALA20250404063) ON FORWARD RIGHT HAND DOOR SLIDE GIRT BAR. PER AMM 25-66-01 AND EO-2523J012SDR AALA202504049130Gpws · faultedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: TERRIAN FAILED ON BOTH CAPTAIN AND FIRST OFFICER NAVIGATION DISPLAYS THE (GPWS)-GROUND PROXIMITY WARNING SENSOR INOPERATIVE LIGHT DISPLAYED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT SDR AALA202504042058Engine · vibrationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON DESCENT BELOW 10000', ENGINE NUMBER 1 VIBRATION INDICATED AS HIGH AS 4.5. RAN CHECKLIST, CONTINUED FLIGHT WITH THRUST LEVER AT IDLE. VIBRATION INDICATION NEVER WENT BELOW 2.5. INDICATION REPEATEDLY BLSDR AALA202504049752Bleed Valve · failedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS INTERMITTENT SULFUR LIKE ODOR AROUND AREA OF FORWARD SERVICE DOOR BY COAT CLOSET. ACCOMPLISHED JOB CARD 08L00021001. INSPECTED CABIN FOR SULFUR TYPE ODORS. UNABLE TO DUPLICATE. RAN PACKS SEVERAL MINUTES WHILE CYC
Back to Boeing 737-823