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 AALA202407109396Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT JUMP SEAT EMERGENCY FLASHLIGHT HAS NO CHARGE ON THE BATTERY. REPLACED BATTERIES IN BOTH (AALA202407109396) (AALA202407107999) FORWARD JUMPSEATS FLASHLIGHT. PER AMM 25-64-00.SDR AALA202407107999Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT JUMP SEAT EMERGENCY FLASHLIGHT HAS NO CHARGE ON THE BATTERY. REPLACED BATTERIES IN BOTH (AALA202407109396) (AALA202407107999) FORWARD JUMPSEATS FLASHLIGHT. PER AMM 25-64-00.SDR AALA202407109675Oil System · lowAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 2 OIL QUANTITY AND LOW PRESSURE FOLLOWED BY OIL TEMERATURE RISE AND ENGINE SHUT DOWN; AIRCRAFT LANDED SAFELY AT IAH.SDR AALA202407100198Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN STA 500E AND STA 500F, BETWEEN S25L AND S26L. REPLACED BAFFLE PER AARD 51-00-05-01.SDR AALA202407094481Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT AND RIGHT OUTSIDE DOOR LIGHTS INOPERATIVE. REMOVED AND REPLACED BOTH AFT LEFT (AALA202407094481) AND RIGHT (AALA202407093894) EMERGENCY LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407093894Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT AND RIGHT OUTSIDE DOOR LIGHTS INOPERATIVE. REMOVED AND REPLACED BOTH AFT LEFT (AALA202407094481) AND RIGHT (AALA202407093894) EMERGENCY LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407092565Buttstrap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER FUSELAGE OUTER SKIN PANEL BUTT STRAP AT STA 887 BETWEEN S27L AND S27R. REPAIRED STRAP PER EA 355602.SDR AALA202407243877Handle · unsecureAIRCRAFT WAS GROUNDED: REPEAT WRITE UP FORWARD ENTRY DOOR HANDLE GRADUALLY CREEPS UP AFTER TAKEOFF AND THROUGHOUT FLIGHT. **SUPPLEMENTAL REPORT FOR (AALA202407093877): ACCOMPLISHED WORK CARD 08C83152006, PRESSURIZED CABIN AND NO MOVEMENT ON HANDLE, LEAK CHECSDR AALA202407096117Spring · unknownAIRCRAFT WAS GROUNDED: EXTERIOR FORWARD SERVICE DOOR HANDLE MOVES TO THE PERPENDICULAR WHEN IN FLIGHT. UPON LANDING IN HOG GROUND CREW INFORMED US THAT THE EXTERIOR FORWARD SERVICE DOOR HANDLE WAS NOT STOWED. WE MADE SURE IT WAS STOWED PRIOR TO DEPARTURE AND ISDR AALA202407093877Handle · malfunctionedAIRCRAFT WAS GROUNDED: REPEAT WRITE UP FORWARD ENTRY DOOR HANDLE GRADUALLY CREEPS UP AFTER TAKEOFF AND THROUGHOUT FLIGHT. (OPEN)SDR AALA202407091755Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED SCREWS ON LOWER AFT CORNER OF FORWARD LAVATORY DOOR.SDR AALA202407097381Flashlight · not seatedAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT FLIGHT ATTENDANT STATION FLASHLIGHT IS INOPERATIVE. SECURED FLIGHT ATTENDANT FLASHLIGHT BATTERY IN PROPER POSITION. REINSTALLED FLASHLIGHT IN PROPER POSITION. PER AMM 25-64-00.SDR AALA202407097315Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR VERY DIFFICULT TO OPEN AND CLOSE. LUBED DOOR LATCH, OPERTIONAL CHECK GOOD.SDR AALA202408122733Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF PASSENGER CABIN FLOOR BEAM AT STA 947, RBL 25. REPLACED UPPER CHORD (T-CAP) PER SRM 53-70-51-2R-5.SDR AALA202407118057Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 331, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202407090616Tube · missingAIRCRAFT WAS NOT GROUNDED: R2 SLIDE REPLACED REQUIRES HEAT SHRINK TUBING APPLIED TO GIRT BAR. **SUPPLEMENTAL REPORT FOR (AALA202407080616): APPLIED HEAT SHRINK ON R-2 SLIDE GIRT BAR. PER AARD 25-66-00-4**(CLOSED).SDR AALA202407088867Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HANG FROM CEILING 12DEF. RESECURED EMERGENCY LIGHT HANGING FROM CEILING 12DEF. PER AMM 33-51-03.SDR AALA202407087131Bolt · unsecureAIRCRAFT WAS NOT GROUNDED: DOOR 1R EMERGENCY SLIDE COVER NEEDS PROPER REATTACHMENT. REPORTED THAT IT IS TOO LOOSE. RESECURED HOLDING BOLTS ON THE SLIDE COVER. PER AMM 25-66-01.SDR AALA202407088069Brake · fireAIRCRAFT WAS GROUNDED: ON ARRIVAL TO GATE NUMBER 2 BRAKE SMOKING HEAVILY AND MOMENTARILY CAUGHT FIRE AND SCORCHED PART OF THE LOWER STRUT. FIRETRUCKS AT GATE. ACCOMPLISHED HIGH ENERGY STOP INSPECTION, PER J/C 08L00005057. REMOVED AND REPLACED NUMBER 1 MLG TIRESDR AALA202407087395Brake · fireAIRCRAFT WAS GROUNDED: ON ARRIVAL TO GATE NUMBER 2 BRAKE SMOKING HEAVILY AND MOMENTARILY CAUGHT FIRE AND SCORCHED PART OF THE LOWER STRUT. FIRETRUCKS AT GATE. ACCOMPLISHED HIGH ENERGY STOP INSPECTION, PER J/C 08L00005057. REMOVED AND REPLACED NUMBER 1 MLG TIRESDR AALA202407086528Brake Assy · fireAIRCRAFT WAS GROUNDED: ON ARRIVAL TO GATE NUMBER 2 BRAKE SMOKING HEAVILY AND MOMENTARILY CAUGHT FIRE AND SCORCHED PART OF THE LOWER STRUT. FIRETRUCKS AT GATE. ACCOMPLISHED HIGH ENERGY STOP INSPECTION, PER J/C 08L00005057. REMOVED AND REPLACED NUMBER 1 MLG TIRESDR AALA202407080616Tube · missingAIRCRAFT WAS NOT GROUNDED: R2 SLIDE REPLACED REQUIRES HEAT SHRINK TUBING APPLIED TO GIRT BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408123603Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL FROM STA 318 TO STA 324, LBL 22. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202407088524Door · out of alignmentAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN AND CLOSE. REMOVED AND REALIGNED DOOR. PER AMM 25-40-11.SDR AALA202407089576Lamp · inoperativeAIRCRAFT WAS GROUNDED: LEFT HAND OVERWING FORWARD EXIT DOOR LIGHT INOPERATIVE. RELAMPED LEFT HAND OVERWING EXIT DOOR LIGHT. PER 33-51-04.SDR AALA202407085942Sign · incorrectAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS INFORMED US THAT THE OVER WING EXIT SIGNS WERE INCORRECT AND DID NOT HAVE THE DIRECTION ARROWS. REMOVED AND REPLACED OVERWING EXIT SIGNS. PER AMM 33-51-01. NO FURTHER DEFECTS NOTED.SDR AALA202407242257Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: THE LEFT CENTER TANK FUEL BOOST PUMP LOW PRESSURE LIGHT CAME ONWITH 700 LBS INDICATED REMAINING IN CENTER FUEL TANK. SUBSEQUENTLY THE LEFT MAIN TANK FUEL QUANTITY BEGAN TO DECREASE WHILE THERIGHT MAIN TANK FUEL QUANTITY STAYED THE SASDR AALA202407087834Light · detachedAIRCRAFT WAS NOT GROUNED: SEAT 10C EMERGENCY LIGHT HOUSING HANGING. REMOVE AND REPLACED EMERGENCY LIGHT HOUSING AT 10C. PER CMM 25-23-67. OPERTIONAL CHECKS GOOD. NO FURTHER DEFECTS NOTED.SDR AALA202407082257Pump · low pressureAIRCRAFT WAS NOT GROUNDED: THE LEFT CENTER TANK FUEL BOOST PUMP LOW PRESSURE LIGHT CAME ONWITH 700 LBS INDICATED REMAINING IN CENTER FUEL TANK. SUBSEQUENTLY THE LEFT MAIN TANK FUEL QUANTITY BEGAN TO DECREASE WHILE THERIGHT MAIN TANK FUEL QUANTITY STAYED THE SASDR AALA202407085564Slide · handler errorAIRCRAFT WAS GROUNDED: CATERING TRUCK OPENED AFT ENTRY DOOR AND SLIDE PARTIALLY DEPLOYED. REMOVED AND REPLACED AFT ENTRY DOOR ESCAPE SLIDE PACK. PER AMM 25-66-01.SDR AALA202407086373Guide Arm · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR VERY HARD TO OPEN AND CLOSE. ADJUSTED UPPER GUIDE ARM (AALA202407086373) AND FORWARD AND AFT DOOR STOPS (AALA202407085487) OPERTIONAL CHECK GOOD. PER AMM 52-41-00.SDR AALA202407085487Stop Fitting · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR VERY HARD TO OPEN AND CLOSE. ADJUSTED UPPER GUIDE ARM (AALA202407086373) AND FORWARD AND AFT DOOR STOPS (AALA202407085487) OPERTIONAL CHECK GOOD. PER AMM 52-41-00.SDR AALA202407082315Module · faultyAIRCRAFT WAS GROUNDED: ON CONFIGURE FOR LANDING DURING THE APPROACH ALL 3 RED AND ALL 3GREEN INDICATOR LIGHTS STAYED ILLUMINATED. INTERMITTENT GEAR HORN SOUNDED. UPPER PANEL SHOWED 3 GREEN. CYCLED GEAR, WHICH THEN OPERATED NORMALLY. LANDING GEAR MODULE STICKINSDR AALA202407087010Slide · will not armAIRCRAFT WAS NOT GROUNDED: DUE TO REPEAT REPORTS OF L-1 DOOR SLIDE BEING HARD TO ARM. REMOVE AND REPLACED L1 EMERGENCY ESCAPE SLIDE. PER JOB CARD 09L20025004.SDR AALA202407084190Slide · detachedAIRCRAFT WAS GROUNDED: DOOR 4R SLIDE CAME DETACHED WHILE OPENING THE DOOR FOR TRAINING. REPLACED DOOR MOUNTED SLIDE. PER WORK CARD 08L22125001.SDR AALA202407088710Light · detachedAIRCRAFT WAS NOT GROUNDED: FLAT CEILING MOUNTED EMERGENCY AISLE LIGHT ABEAM ROW 32 DEF IS HANGING FROM THE CEILING. RESECURED CEILING EMERGENCY LIGHT BY ROW 32DEF. PER AMM 33-51-03.SDR AALA202407086817Hinge Pin · migratedAIRCRAFT WAS GROUNDED: L1 DOOR DIFFICULT TO OPEN. REPLACED L1 ENTRY DOOR MIGRATING HINGE PIN. PER AARD 52-10-00-4.SDR AALA202407087264Actuator · overservicedAIRCRAFT WAS NOT GROUNDED: DURING GEAR RETRACTION RECEIVED 3 RED GEAR INDICATIONS WITH LANDING GEAR STILL INDICATING DOWN AND GREEN. FOLLOWED QRH PROCEDUREAND OPENED AND CLOSED MANUAL EXTENSION DOOR. GEAR RETRACTED NORMALLY. FOUND MANUAL EXTENSION ACCESS PANELSDR AALA202407084822Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR HARD TO OPEN. LUBRICATED LAVATORY-D LATCH. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202407088558Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: REPEAT ITEM 1R DOOR GIRT BAR DIFFICULT TO ARM. SLIDE APPEARS PACKED TOO TIGHTLY IN DOOR. RESCURED 1R DOOR GIRT BAR. PER AMM 25-66-00.SDR AALA202407051309Intercostal · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGED HOLES IN FORWARD CARGO COMPARTMENT INTERCOSTAL FROM STA 500H TO STA 500I, S23R. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202408143247Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500B TO STA 5OOG, FROM RBL 29 TO RBL 30. REPLACED TRANSITION PANEL PER SRM 53-42-011-11.SDR AALA202408065146Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500 TO STA 5OOG, FROM LBL 29 TO LBL 30. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5 AND AARD 51-00-05-01.SDR AALA202407248954Mount Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN AFT RIGHT LAVATORY MOUNT FITTING AT STA 947, RBL 24. REPLACED FITTING PER AARD 51-00-05-1.SDR AALA202407196618Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 947 TO STA 967, LBL 55. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202407096590Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR IS JAMMING IN FLIGHT, DIFFICULT TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT FOR (AALA202407036590): ADJUSTED LAVATORY-E DOOR. OPERTIONAL CHECKS GOOD. PER CMM 25-40-59**(CLOSED).SDR AALA202407098045Light · noneAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT OVER SEAT 17A FLICKERS ON AND OFF INTERMITTENTLY. NO FAULT FOUND.SDR AALA202407098429Light · brokenAIRCRAFT WAS NOT GROUNDED: FLOOR PATH LIGHT HOUSING AT 13C BROKE OFF. REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 35-51-11-960-802SDR AALA202407036590Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR IS JAMMING IN FLIGHT, DIFFICULT TO OPEN AND CLOSE. (OPEN).SDR AALA202407032560Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS IN THE AFT PORTION OF THE MAIN CABIN COME ON AND OFF ERRATICALLY. ACCOMPLISHED RESET AND TEST OF EMERGENCY LIGHTS, ALL OPERTIONAL CHECK NORMAL. PER AMM 33-51-00.
Back to Boeing 737-823