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 AALA202408277207Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN STA 767 AND STA 787, RBL 21. REPLACED SHIELD PER AARD 51-00-05.SDR AALA202408226458Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727 TO STA 847, S25L REPLACED TRANSITION PANEL PER SRM 51-40-02..SDR AALA202408210997Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT AFT BULKHEAD SUPPORT ANGLE AT STA 947.5, FROM LBL 20 TO RBL 20. REPLACED SUPPORT ANGLE PER AARD 51-00-05-01.SDR AALA202408125121Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR AFT FLOOR MOUNTED GIRT BAR TIEDOWN AT BS 346, LBL 60. REPLACED TIEDOWN PER 51-00-05-1. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202408097378Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED GIRT BAR TIEDOWN AT BS 313, LBL 59. REPLACED TIEDOWN PER 51-00-05-1.SDR AALA202408057386Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT CLIP UNDER TRANSITION PANEL AT STA 727 FORWARD BULKHEAD, LBL 24.SDR AALA202407305230Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ON OVERHEAD BINS ABOVE SEATS 14C AND 16D FALLING OUT AND WON'T SNAP BACK IN. SECURED OVERHEAD EMERGENCY LIGHTS 14C AND 16D. PER MM 33-51-00.SDR AALA202407309215Door · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR AT AFT LEFT IS DIFFICULT TO OPEN. TIGHTENED SCREWS IN UPPER RAIL. PER CMM 25-47-21.SDR AALA202407306841Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN OVER AFT ENTRY DOOR FELL OFF AFTER TAKEOFF. RESECURED EMERGENCY EXIT LENS AT L2 DOOR. PER AMM 33-51-01.SDR AALA202407301964Exhaust Port · corrodedAIRCRAFT WAS GROUNDED: WASTE TASK EXHAUST PORT HAS SIGN OF CORROSION AROUND. INSPECTED AREA AND PERFORMED REPAIR AT WASTE TANK EXHAUST PORT. PER AMM 38-32-00-140-801.SDR AALA202407308253Light · detachedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS EXPOSED ELEMENT HANGING FROM UNDER SEAT26C. EMERGENCY LIGHT HOUSING REATTACHED, EMERGENCY PROXIMITY LIGHT OPERTIONAL CEHCK GOOD. PER AMM 33-51-11.SDR AALA202407303508Access Door · openAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKE OFF NOSE WHEEL VIBRATION HEARD AND FELT A SEVERE VIBRATION UNDER THE FLIGHT DECK, VIBRATION DID NOT QUIET DOWN; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CUN. AIRCRAFT ARRIVED AT POSITION WITH EXSDR AALA202408205832Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500E TO STA 500F, LBL 23, S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 6.SDR AALA202408204160Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500G TO STA 500F, S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 6.SDR AALA202408204502Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500H TO STA 500G, S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 6.SDR AALA202408209508Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500C TO STA 500D, LBL 23, S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 6.SDR AALA202408202609Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500D TO STA 500E, LBL 23, S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 6.SDR AALA202408128853Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD AT STA 439, RBL 23. REPLACED SHIED PER AARD 51-00-05-1. **SUPPLEMENTAL REPORT FOR AALA202408088853: QC REVIEWED THIS EVENT AND DETERMINED THAT IT WAS A LEVEL 2 FINDING. SECTION 7 CORROSDR AALA202408128915Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500 TO STA 500I, S24L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202408088853Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD AT STA 439, RBL 23. REPLACED SHIED PER AARD 51-00-05-1.SDR AALA202408052466Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AFT OF STA 947, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202407309395Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY LIGHTS TEST FOUND RIGHT HAND REAR SLIDE LIGHT INOPERATIVE. RELAMP RIGHT REAR SLIDE EMERGENCY LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202407307122Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 10C EMERGENCY LIGHT IS UNATTACHED. REINSTALLED FLOOR PROXIMITY LIGHTING HOLDER. PER AMM 33-51-11.SDR AALA202407302067Light · unsecureAIRCRAFT WAS NOT GROUNDED: LIGHT ASSEMBLY ABOVE THE OVERHEAD BIN AT 10 ABC NEEDS TO BE SECURED CURRENTLY HELD WITH TAPE. RESECURED ABOVE 10 ABC OVERHEAD BIN EMERGENCY AISLE LIGHT ASSEMBLY. PER AMM 33-51-03-960.SDR AALA202407304570Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: 1L BOARDING DOOR WAS DIFFICULT TO OPEN UPON ARRIVAL IN MIA. LUBRICATED FORWARD. L1 ENTRY DOOR , OPERTIONAL CHECKED DOOR NORMAL. PER AMM 52-11-00.SDR AALA202407308987Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY HANDLE HARD TO OPEN AND CLOSE. MADE ADJUSTMENTS TO FORWARD LAVATORY DOOR, OPERTIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202407300088Regulator Valve · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: IMMEDIATELY AFTER TAKEOFF, NOTICED LEFT PNEUMATIC DUCT PRESSUREWAS LOW INDICATING APPROXIMATELY 5PSI. NO ASSOCIATED PNEUMATIC ANNUNCIATIONS OCCURRED. AIRCRAFT CABIN PRESSURIZED NORMALLY; AIRCRAFT AIR INTSDR AALA202407306695Bleed Valve · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: IMMEDIATELY AFTER TAKEOFF, NOTICED LEFT PNEUMATIC DUCT PRESSUREWAS LOW INDICATING APPROXIMATELY 5PSI. NO ASSOCIATED PNEUMATIC ANNUNCIATIONS OCCURRED. AIRCRAFT CABIN PRESSURIZED NORMALLY; AIRCRAFT AIR INTSDR AALA202408205655Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD WEB FROM STA 807 TO STA 847, S25L. REPLACED WEB PER SRM 53-00-53 AND AARD 51-00-05-1A.SDR AALA202408057727Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES FROM FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202408052371Skin · 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 AALA202407317521Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT IN ROW 16DEF IS FLASHING.**SUPPLEMENTAL REPORT FOR (AALA202407307521): TROUBLESHOT PER JC 08L20033001 ACCOMPLISHED FULL SYSTEM RESET, OPERTIONAL CHECK PASSED, NO FAULT FOUND**(CLOSED).SDR AALA202407309974Girt Bar · dislodgedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR PART OF THE SLIDE IS STICKING OUT FROM UNDERTHE SLIDE WHEN THE DOOR IS ARMED. ADJUSTED GIRT BAR VERIFIED INSTALLED CORRECTLY. PER AMM 25-66-02.SDR AALA202407302917Switchpack · failedAIRCRAFT WAS GROUNDED: DESCENDING THROUGH APPROXIMATELY 14,000 FT AND ABOUT 260 KNOTS, GEAR WARNING HORN SOUNDED FOR SEVERAL SECONDS AND ALL 3 GEAR LIGHTS STEADY RED FOR SEVERAL SECONDS WITH HANDLE IN THE OFF POSITION. GEAR OPERATED NORMALLY ON THE APPROACH. BSDR AALA202407305857Fuel Panel · leakingAIRCRAFT WAS NOT GROUNDED: FUEL PANEL 531AB LEAKING FUEL. REMOVED AND CLOSED FUEL PANEL 531AB. LEAK CHECK GOOD. PER AMM 28-11-31.SDR AALA202407304815Sign · detachedAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT SIGN FELL OFF OF CABIN CEILING DURING TAKEOFF ROLL. REINSTALLED OVER THE WING EMERGENCY SIGN. OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202407307521Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT IN ROW 16DEF IS FLASHING. (OPEN).SDR AALA202407260303Sign · wornAIRCRAFT IN BASE MAINTENANCE: FOUND MOUNTING PLATE BROKEN. REMOVE AND REPLACED EXIT SIGN LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202408098267Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 500A TO STA 500G, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202408099065Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 500B TO STA 500G, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202408055363Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SILL INNER CHORD (CREASE ANGLE) AT STA 316, LBL 57. REPLACED INNER CHORD PER AARD 51-00-05.SDR AALA202408050958Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SILL INNER CHORD (CREASE ANGLE) AT STA 330, LBL 57. REPLACED INNER CHORD PER AARD 51-00-05.SDR AALA202407311540Pump · shortedAIRCRAFT WAS GROUNDED: LEFT AFT FUEL LOW PRESSURE LIGHT CAME ON IN CRUISE FLIGHT JUST PRIOR TO DESCENT. REMOVED AND INSTALLED NEW LEFT HNAD AFT FUEL PUMP. PER AMM 28-22-41. OPERTIONAL LEAK CHECKS GOOD.SDR AALA202407301662Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT ANGLE FOR INTERCOSTAL AT BS 500G, RBL 23. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202407265604Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY L1 DOOR GIRT BAR BRACKET TOO TIGHT AND DIFFICULT TO UTILIZE. LUBE FORWARD L1 DOOR GIRT BAR AS REQUIRED. OPERTIONAL CHECK GOOD. PER AMM 25-66-02.SDR AALA202407261540Warning Light · illuminatedAIRCRAFT WAS GROUNDED: LEFT AFT FUEL LOW PRESSURE LIGHT CAME ON IN CRUISE FLIGHT JUST PRIOR TO DESCENT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202407269580Sensor · faultyAIRCRAFT WAS GROUNDED: NO EMERGENCY DECLARED DUE TO: WHEN GEAR WAS RETRACTED OUT OF LAS THE NOSE GEAR DID NOT RETRACT. GEAR EXTENDED DURING LANDING; AIRCRAFT LANDED SAFELY AT ORD. TROUBLESHOT, PER FIM 32-61-00-810-803. CONFIRMED SENSOR S853 FAULTY. REMOVED ANDSDR AALA202407268277Slide · faultyAIRCRAFT WAS GROUNDED: UNUSUAL AMOUNT OF FORCE REQUIRED TO STOW AND RELEASE GIRT BAR FROM THE STOWED POSITION. REMOVED AND REPLACED FRONT SLIDE PACK COVER AT FORWARD RIGHT HAND DOOR AND SLIDE PACK INSTALLED. OPERTIONAL CHECK GOOD. PER AMM 25-66-01.SDR AALA202407269753Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR TO LAVATORY-D IS DIFFICULT TO OPEN. LUBRICATED LAVATORY-D DOOR TRACKS. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202408190665Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOORBEAM AT STA 947.5, LBL 26. REPAIRED UPPER CHORD (T CAP) PER SRM 53-70-51-2R REPAIR 5, ALTERNATIVE 2.
Back to Boeing 737-823