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 AALA202407232971Light · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY EXIT LIGHTS NOT SECURED AT SEAT 23C AND 29C. RESECURED EMERGENCY LIGHTS ON SEATS 23C AND 29C. PER CMM 25-23-67.SDR AALA202407232383O-Ring · tornAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT CRUISE ALTITUDE OF 36,000FT CHECKED OIL LEVEL AND IT WAS AT 6 QUARTS, CONTINUE TO DECREASE ALL THE WAY TO 0 ON APPROACH; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT RDU. ACCOMPLISHED GVI OF NUMBER 1 ENGSDR AALA202407233421Trim Motor · out of toleranceAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF LOST STAB TRIM, NON OPERATIONAL WITH NO AUTOPILOT; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CLT. PARTIAL WORK ACCOMPLISHED. TROUBLESHOT PER TSM 27-41-00-810-804. FOUND VOLTAGE SDR AALA202407253664Starter Gen · burned outAIRCRAFT WAS NOT GROUNDED: APU GENERATOR DROPPED OFFLINE AFTER ENGINE SHUTDOWN ACCOMPANIED BY A STRONG BURNING SMELL.**SUPPLEMENTAL REPORT FOR (AALA202407233664): ACCOMPLISHED SOF CARD 08L0021001 FOUND START GENERATOR ELECTRICAL CONECTIONS BURNT REMOVED AND RESDR AALA202407233535Battery · inoperativeAIRCRAFT WAS GROUNDED: MEGAPHONE IN FORWARD CLOSET INOPERATIVE. INSTALLED SERVICEABLE BATTERIES. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202407237389Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY INBOARD FLIGHT ATTENDENT FLASHLIGHT WILL NOT TEST. INSTALLED FLASHLIGHT IN THE CORRECT MANNER.SDR AALA202407234242Lens · incorrectAIRCRAFT IN BASE MAINTENANCE: OVERHEAD EXIT SIGN LIGHT LENS NOT CORRECT. REMOVED LENS COVER IN AFT OVERHEAD EXIT SIGN AND REINSTALLED TO THE CORRECT COLOR PATTERN. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202407239155Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY FLIGHT ATTENDANT SEAT RIGHT SIDE, INBOARD FLASHLIGHT WILL NOT TEST. INSTALLED FLASHLIGHT IN THE CORRECT MANNER.SDR AALA202407233664Generator · shutdownAIRCRAFT WAS NOT GROUNDED: APU GENERATOR DROPPED OFFLINE AFTER ENGINE SHUTDOWN ACCOMPANIED BY A STRONG BURNING SMELL.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202407230291Retainer · looseAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR IS LOOSE. READJUST SLIDE GIRT RETAINING BRACKET. OPERTIONAL CHECK GOOD. PER 25-66-02.SDR AALA202407233981Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND AFT MEGAPHONE WITH WEAK AND LOW VOICE OUTPUT. REMOVE AND REPLACED AFT MEGAPHONE. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202407232363Light · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT AT SEAT 22C IS SEPARATED FROM SEAT FRAME AND DANGLING ON THE FLOOR. RESECURED EXIT LIGHT AT 22C. PER AMM 33-51-11.SDR AALA202407224067Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN VERTICAL STABILIZER STIFFENER AT BS 1085.5, VERTICAL FIN STA 178.2. REPLACED STIFFENER PER EA 356098.SDR AALA202407197524Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR STOPPER R1 DOOR LOOSE ON RIGHT HAND SIDE. REINSTALED RELEASE STOP ASSEMBLY IN FORWARD GALLEY DOOR GIRT BAR. PER AMM 25-61-01.SDR AALA202407196997Oven · overheatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CREW REPORTS NUMBER 2 OVEN OVERHEATED; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TPA. PERFORMED OPERATIONAL TEST OF OVEN PER AMM 25-32-03, TEST PASSED. NO FAULT FOUND.SDR AALA202407194081Track · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER TORSION BOX COMPARTMENT FOWARD SPAR SLIDING PANEL FORWARD TRACK AT BS 1121, WL 276.3. REPLACED TRACK PER AARD 51-00-05-1.SDR AALA202408129927Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 947, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202408065536Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STATION 663, RBL 6 (FRONT WALL OF RIGHT HAND PACK COMPARTMENT). ACCOMPLISHED SPLICE REPAIR PER SRM 57-10-10-2R-5.SDR AALA202407244798Slide · partial deployAIRCRAFT WAS GROUNDED: AT THE GATE, DOOR 1L WILL NOT OPEN STUCK CLOSED, IF IT DOES OPEN IT ONLY OPENS PARTIALLY. **SUPPLEMENTAL REPORT FOR (AALA2024071847980): SLIDE REMOVED AND REPLACED ((AALA2024071847980)), PER AMM 25-66-01. ALSO DISCOVER DURING INSPECTION SDR AALA202407247377Link · gougedAIRCRAFT WAS GROUNDED: AT THE GATE, DOOR 1L WILL NOT OPEN STUCK CLOSED, IF IT DOES OPEN IT ONLY OPENS PARTIALLY. **SUPPLEMENTAL REPORT FOR (AALA2024071847980): SLIDE REMOVED AND REPLACED ((AALA2024071847980)), PER AMM 25-66-01. ALSO DISCOVER DURING INSPECTION SDR AALA202407247896Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR SILL INNER CHORD (CREASE ANGLE) AT STA 303, LBL 54. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202407224152Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY AT STA 540 FROM LBL 0 TO LBL 20. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202407220757Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY AT STA 540 FROM RBL 0 TO RBL 20. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202407183217Door · misalignedAIRCRAFT WAS GROUNDED: FORWARD LAVATORY-A DOOR HARD TO CLOSE AND OPEN. STRAIGHTEND BENT DOOR TRIM. PER MM 25-40-11.SDR AALA202407184798Door · stuckAIRCRAFT WAS GROUNDED: AT THE GATE, DOOR 1L WILL NOT OPEN STUCK CLOSED, IF IT DOES OPEN IT ONLY OPENS PARTIALLY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408122140Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 23L OUTER CHORD FROM STA 303 TO STA 360. REPAIRED PER EA 356612 AND AARD 51-00-05-1.SDR AALA202407178044Fscu · warning messageFLAPS FAILED TO MOVE USING NORMAL HANDLE. EXTENDED FLAPS WITH ALTERNATE FLAP SYSTEM. EMERGENCY WAS DECLARED, AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FSCU BITE SHOWS MSG. ALT MODE ARMED 27-51402 .NO OTHER EXISTINGOR FAULT HISTORY. ACCOMPLISHED FIM 27-51-0SDR AALA202408120466Transition Panel · corrodedCORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 420, LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1,SDR AALA202408085054Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 400, RBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE AND AARD 51-00-05-1.SDR AALA202408087373Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500G TO STA 500I, LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202408059341Transition Panel · corrodedAIRCRAFT IN BASE MAINTENACE: CORROSIN ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500 TO STA 500G, RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202408050153Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF PASSENGER CABIN FLOOR BEAM AT STA 947, LBL 5. FLOORBEAM UPPER CHORD REPLACED PER SRM 53-70-51-2R-5..SDR AALA202407246330Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR SILL INNER CHORD (CREASE ANGLE) AT STA 972, LBL 47. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202407239998Seal · leakingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FUEL PANEL 632AB HAS FUEL LEAK. REMOVED AND REPLACED SEAL (AALA202407239998) AND GASKET (AALA202407232227). PERFORMED SATISFACTORY LEAK CHECK. NO LEAKS NOTED. PER B737 NG AMM 28-11-11.SDR AALA202407232227Gasket · leakingAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FUEL PANEL 632AB HAS FUEL LEAK. REMOVED AND REPLACED SEAL (AALA202407239998) AND GASKET (AALA202407232227). PERFORMED SATISFACTORY LEAK CHECK. NO LEAKS NOTED. PER B737 NG AMM 28-11-11.SDR AALA202407166245Lamp · burned outAIRCRAFT WAS NOT GROUNDED: RIGHT HAND OVERWING EXIT EMERGENCY LIGHT LAMP BURNED OUT. REMOVED AND REPLACED THE RIGHT HAND OVERWING EMERGENCY LIGHT LAMP. OPERATIONAL CHECK GOOD. PER AMM 33-51-04-960-801.SDR AALA202407167415Gust Lock · unsecureAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS FORWARD ENTRY DOOR DOES NOT OPEN FULLY. REPLACED MISSING GUST LOCK HARDWARE ON L1 DOOR UPPER GUIDE ARM. PER AMM 52-11-21.SDR AALA202407161485Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: GATE AGENT AND FLIGHT ATTANDENT REPORTED L1 DOOR HARD TO OPEN WITH UNLOCKING MECHANISM NOT CATCHING. LUBRICATED DOOR HANDLE AND UNLOCKING MECHANISM AS REQUIRED OPERATIONAL CHECK NORMAL.SDR AALA202407168720Inlet Guide Vane · leakingAIRCRAFT WAS GROUNDED: STRONG SMELL OF FUEL IN THE CABIN AND FLIGHT DECK. FOUND APU INLET GUIDE VANE ACTUATOR LEAKING FUEL, REMOVED AND REPLACED APU INLET GUIDE VANE ACTUATOR. PER AMM 49-52-12 LEAK AND OPERTIONAL CHECK GOOD.SDR AALA202407162473Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 13C EMERGENCY LIGHT COVER FELL OFF. SECURED LIGHT AS REQUIRED.SDR AALA202407167395Door · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: 1L DOOR LOUD NOISE UNBEARABLE, CABIN PRESSURE LEAK; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. COMPLIED WITH FIM TASK 52-10-00. ACCOMPLISHED CABIN PRESSURE LEAK TEST. NO UNBEARABLE LOUD NSDR AALA202408123114Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STA 1040 FRAME LOWER FLANGE OF SHEAR TIE AT S24L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA202408044664Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSOIN ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL AT STA 727C, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202408044055Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727I TO STA 727H, RBL 18. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202408046247Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727I TO STA 727J, RBL 18..5 REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202408041983Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR LOWER CUTOUT WEB AT STA 827, RBL 30. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202408049400Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD AT STA 777, RBL 25. REPLACED SHIELD PER AARD 51-00-05-1SDR AALA202407247912Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 757, RBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202407163749Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: 1R DOOR EXT SLIDE EMERGENCY LIGHT IS INOPERATIVE. REPLACED 1R DOOR EMERGENCY SLIDE LIGHT BULB, PER B737-NG AMM 33-51-04. PERFORMED SATISFACTORY OPERATIONAL CHECK, PER B737-NG AMM 33-51-04.SDR AALA202407160788Radar · failedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WEATHER RADAR FAILED DURING CURISE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. PERFORMED OPERTIONAL CHECK OF WEATHER RADAR SYSTEM. NO FAULT FOUND NO FAIL HISTORY WITHIN PAST 60 DAYS.
Back to Boeing 737-823