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 AALA202409124799Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR VERY DIFFICULT TO OPEN. LUBRICATED FORWARD LAVATORY DOOR HINGES AND LOCKING MECHANISM. OPERTIONAL TEST DOOR GOOD WORKS SMOOTHLY. PER AMM 25-40-11.SDR AALA202409125440Light · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 21C EMERGENCY LIGHT IS OUT ON THE FLOOR. REINSTALLED EMERGENCY LIGHT AT SEAT 21C. PER CMM 25-23-67.SDR AALA202409123451Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409120126Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409124616Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409123489Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409122942Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409120616Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409129450Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409121646Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409120403Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409129002Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, LBL 31.83. REPAIRED CRACK PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202409116209Connector · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT 2ND LIGHT ON SEAT INOPERATIVE AT ROW 3AB, FOUND DAMAGED CONNECTOR WHILE PERFORMING EMERGENCY LIGHT TEST JOB CARD 08T20033001. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202409178956Guide Arm · not openedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. REMOVED AND REPLACED L1 DOOR GUIDE ARM ASSEMBLY ((AALA202409118956)), PER AMM 52-11-21. REMOVED AND INSTALLED L1 DOOR ASSEMBLY ((AALA202409176174)), PER AMM 52-11-00. ADJUSTED L1 DOOR TORQUE TUSDR AALA202409176174Door · not openedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. REMOVED AND REPLACED L1 DOOR GUIDE ARM ASSEMBLY ((AALA202409118956)), PER AMM 52-11-21. REMOVED AND INSTALLED L1 DOOR ASSEMBLY ((AALA202409176174)), PER AMM 52-11-00. ADJUSTED L1 DOOR TORQUE TUSDR AALA202409179431Torque Tube · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. REMOVED AND REPLACED L1 DOOR GUIDE ARM ASSEMBLY ((AALA202409118956)), PER AMM 52-11-21. REMOVED AND INSTALLED L1 DOOR ASSEMBLY ((AALA202409176174)), PER AMM 52-11-00. ADJUSTED L1 DOOR TORQUE TUSDR AALA202409173412Bolt · failedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. : REMOVED AND REPLACED L1 DOOR GUIDE ARM ASSEMBLY ((AALA202409118956)), PER AMM 52-11-21. REMOVED AND INSTALLED L1 DOOR ASSEMBLY ((AALA202409176174)), PER AMM 52-11-00. ADJUSTED L1 DOOR TORQUE TSDR AALA202409173326Guide Plate · not openedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. REMOVED AND REPLACED L1 DOOR GUIDE ARM ASSEMBLY ((AALA202409118956)), PER AMM 52-11-21. REMOVED AND INSTALLED L1 DOOR ASSEMBLY ((AALA202409176174)), PER AMM 52-11-00. ADJUSTED L1 DOOR TORQUE TUSDR AALA202409176795Guide Plate · not openedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. **SUPPLEMENTAL REPORT FOR (AALA202409118956): REMOVED AND REPLACED L1 DOOR GUIDE ARM ASSEMBLY ((AALA202409118956)), PER AMM 52-11-21. REMOVED AND INSTALLED L1 DOOR ASSEMBLY ((AALA202409176174)),SDR AALA202409162063Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 328 AND STA 344, LBL 44. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409166248Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787, RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202409168493Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, RBL 3, WL 208. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202409162935Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, LBL 3, WL 206. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202409118956Door · stuckAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR (L1) WILL NOT OPEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202409110305Light · detachedAIRCRAFT WAS NOT GROUNDED: WHITE ESCAPE PATH LIGHT ON SEAT 18C IS DETACHED FROM THE SEAT BRACKET. REATTACHED BRACKET FOR EMERGENCY LIGHT MARKER LIGHT. OPERTIONAL CHECKS GOOD. PER AMM 25-42-02.SDR AALA202409166016Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT BAFFLE FROM STA 500F TO STA 500F, S25L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202409164694Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT BAFFLE FROM STA 500G TO STA 500H, S25L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202409163174Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT BAFFLE FROM STA 500H TO STA 5001, S25L. REPLACED BAFFLE PER AARD 51-00-05-1SDR AALA202409164620Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT BAFFLE FROM STA 500E TO STA 500F, S25L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202409123568Intercostal · deformedAIRCRAFT WAS GROUNDED: FORWARD CARGO COMPARTMENT INTERCOSTAL FROM STA 500H TO STA 500I, S26R DEFORMED. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409125498Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE FROM STA 500F TO STA 500G, S26L. REPLACED BAFFLE PER SRM 53-30-53-2R-1.SDR AALA202409125926Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE FROM STA 500G TO STA 500H, S26L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202409112301Threshold · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS FORWARD LAVATORY DOOR STICKS IN CLOSED POSITION IN FLIGHT. ADJUSTED DOOR THRESHOLD AT AFT CORNER APPEARED TO BE RUBBING.SDR AALA202409118830Compensator · out of toleranceAIRCRAFT WAS GROUNDED: AIRCRAFT BURNS FUEL FROM RIGHT TANK WITH CENTER TANK FUEL RESULTING IN A FUEL IMBALANCE. NUMBER 2 TANK COMPENSATOR PROBE AND RIGHT TANK NUMBER 9 PROBE TESTED OUT OF LIMITS. REMOVED AND REPLACED BOTH RIGHT COMPENSATOR PROBE (AALA20240910SDR AALA202409117224Compensator · out of toleranceAIRCRAFT WAS GROUNDED: AIRCRAFT BURNS FUEL FROM RIGHT TANK WITH CENTER TANK FUEL RESULTING IN A FUEL IMBALANCE. NUMBER 2 TANK COMPENSATOR PROBE AND RIGHT TANK NUMBER 9 PROBE TESTED OUT OF LIMITS. REMOVED AND REPLACED BOTH RIGHT COMPENSATOR PROBE (AALA20240910SDR AALA202409110665Probe · out of toleranceAIRCRAFT WAS GROUNDED: AIRCRAFT BURNS FUEL FROM RIGHT TANK WITH CENTER TANK FUEL RESULTING IN A FUEL IMBALANCE. NUMBER 2 TANK COMPENSATOR PROBE AND RIGHT TANK NUMBER 9 PROBE TESTED OUT OF LIMITS. REMOVED AND REPLACED BOTH RIGHT COMPENSATOR PROBE (AALA20240910SDR AALA202409108830Fuel Sys · out of balanceAIRCRAFT WAS GROUNDED: AIRCRAFT BURNS FUEL FROM RIGHT TANK WITH CENTER TANK FUEL RESULTING IN A FUEL IMBALANCE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202409102942Sign · looseAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ON CEILING IN AFT GALLEY LOOSE AND NEEDS TO BE REATTACHED. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202409102301Threshold · out of adjustAIRCRAFT WAS NOT GROUNDED: FIRST CLASS FORWARD LAVATORY DOOR STICKS IN CLOSED POSITION IN FLIGHT. ADJUSTED DOOR THRESHOLD AT AFT CORNER APPEARED TO BE RUBBING.SDR AALA202409105710Handle · looseAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER SIDE OUTSIDE EMERGENCY EXIT WINDOW HANDLE IS LOOSE AND NOT STOWED. STOWED FIRST OFFICER EMERGENCY EXIT WINDOW HANDLE. PER AMM 56-12-11.SDR AALA202409100568Slide · partial deployAIRCRAFT WAS GROUNDED: PARTIALLY DEPLOYED L1 DOOR SLIDE REPORTED BY OPERATIONS AT SNU. REMOVED AND REPLACED L1 DOOR SLIDE. PER JOB CARD 08L22125001.SDR AALA202409094747Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS INOPERATIVE BETWEEN ROW 1 THROUGH ROW 4. REMOVE AND REPLACED BATTERY PACK FOR SEATS 1 THROUGH 4. OPERTIONAL CHECK GOOD. PER AMM 33-51-06.SDR AALA202409232342Guide Arm · stuckAIRCRAFT WAS NOT GROUNDED: GUST LUCK ON L1 MAIN ENTRY DOOR IS STUCK AND WILL NOT RELEASE. REPLACED L1 DOOR GUIDE ARM ASSEMBLY PER AMM 52-11-21.SDR AALA202409111659Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 380 TO STA 400, LBL 13. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409095367Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DIFFICULT TO OPEN AND CLOSE, DOOR STICKING. ADJUSTED LAVATORY-D DOOR, OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202409092342Gust Lock · stuckAIRCRAFT WAS NOT GROUNDED: GUST LUCK ON L1 MAIN ENTRY DOOR IS STUCK AND WILL NOT RELEASE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202409094041Transmitter · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SUSPECTED LEAK IN HYDRAULIC FLUID SYSTEM-A AND SYSTEM-B; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. SYSTEM-A (AALA202409094041) AND SYSTEM-B (AALA202409099466) HYDRAULIC FLUID QUANTITY TRANSMITTER WASDR AALA202409099466Transmitter · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SUSPECTED LEAK IN HYDRAULIC FLUID SYSTEM-A AND SYSTEM-B; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. SYSTEM-A (AALA202409094041) AND SYSTEM-B (AALA202409099466) HYDRAULIC FLUID QUANTITY TRANSMITTER WASDR AALA202409192678Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR LOWER CUT OUT WEB FROM STA 807 TO STA 847, S25R. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202409194282Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BRAKE ASSEMBLY PANEL AT STA 540, FROM LBL 0.07 TO RBL 24.2. REPLACED BRAKE ASSEMBLY PANEL PER AARD 51-00-05-1.
Back to Boeing 737-823