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 AALA202206131728Bracket · looseAIRCRAFT WAS GROUNDED: FORWARD SERVICE DOOR GIRT BAR CLIPS FOR UNARMED POSITION LOOSE. ADJUSTED GIRT BAR CLIPS. OPERATIONAL CHECK GOOD.SDR AALA202206294283Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN CRACKED FLOOR BOARD SUPPORT, STA 540, RIGHT BUTT LINE 0-3. REMOVED AND REPLACED INSTALLED NEW BREAK ASSEMBLY PER SRM 51-00-05.SDR AALA202206290059Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN LEFT HAND AFT ENTRY DOOR CREASE ANGEL AT FLOOR AREA LOCATED FROM BS 938 TO BS 987, S17L, WL 208, LBL 64. REPLACED CREASE ANGLE PER SRM 51-40-02 AND EA 337233.SDR AALA202206294830Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE #4 AND EA 337062.SDR AALA202206298741Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED LOCATED AT STABILIZER STA 129.50, 34 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202206130213Proximity Sensor · warning lightAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR CAUTION LIGHT CAME ON INTERMITTENTLY DURING DESCENT, HANDLE WAS FULLY DOWN, PRESSURIZATION NORMAL. REMOVED AND REPLACED FORWARD ENTRY DOOR L1 PROXIMITY SENSOR.SDR AALA202206139077Lubrication Unit · reads lowAIRCRAFT WAS GROUNDED: AIRCRAFT DIVERTED TO OMA ACCOUNT OIL QUANTITY PRESSURE ISSUE. OIL QUANTITY READS 5 IN FLIGHT FOR NUMBER 1 ENGINE. FLIGHT DID NOT DECLARE AN EMERGENCY AND DID NOT LAND OVERWEIGHT. REMOVED AND REPLACED NUMBER 1 ENGINE LUBRICATION UNIT PER SDR AALA202206134555Brake Assy · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR BOARD SUPPORT BREAK ASSEMBLY LOCATED AT BS 540, LBL 3. REPLACED BREAK ASSEMBLY PER AARD 51-00-05.SDR AALA202206298274Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO CORROSION ON THRESHOLD LOCATED AT STA 793 TO 847. REPLACED THRESHOLD WEB PER SRM 51-40-02.SDR AALA202206293996Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO RIGHT HAND TRANSITION PANEL LOCATED FROM BS 767 TO BS 793 AT RBL 44. REPLACED TRANSITION PANEL PER DWG 146A8127, AARD 51-00-05, AND SRM 51-40-02.SDR AALA202206293427Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT FLOOR SUPPORT LOCATED AT BS 500I AND BL 44. REPLACED FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA202206274369Latch · failedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE LATCH FAILED CLOSE TEST. REMOVED AND REPLACED L1 DOOR SLIDE LATCH AA B737NG AMM 25-66-01-400-801.SDR AALA202206230468Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO LEFT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202206102952Control Unit · inoperativeAIRCRAFT WAS GROUNDED: SLOWING TO CONFIGURE FOR APPROACH INTO DCA - NO FLAPS OR SLATS WHEN FLAPS 1 WAS SELECTED. DIVERTED TO IAD EMERGENCY WAS DECLARED. REMOVED AND REPLACED FLAP SLAT ELECTRONIC UNIT PER AMM 27-51-01.SDR AALA202206230650Light · faultyAIRCRAFT WAS NOT GROUNDED: LIGHT ON 17A EMERGENCY EXIT DOOR FLICKERS CONSTANTLY. **SUPPLEMENTAL REPORT FOR AALA202206100650: REMOVED AND REPLACED OVERWING EXIT LED LIGHT ASSEMBLY PER AMM 33-21-01** (CLOSED)SDR AALA202206145491Light · damagedAIRCRAFT WAS NOT GROUNDED: CABIN EMERGENCY EXIT LIGHT COVER DAMAGED ABOVE FLIGHT DECK DOOR. **SUPPLEMENTAL REPORT FOR AALA202206105491: REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT FLIGHT DECK DOOR PER AMM 33-51-01. ** (CLOSED)SDR AALA202206100650Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LIGHT ON 17A EMERGENCY EXIT DOOR FLICKERS CONSTANTLY. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202206105491Cover · damagedAIRCRAFT WAS NOT GROUNDED: CABIN EMERGENCY EXIT LIGHT COVER DAMAGED ABOVE FLIGHT DECK DOOR. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202206238210Indicator · warning messageAIRCRAFT WAS NOT GROUNDED: REJECTED TAKE OFF DUE TO LEFT AFT OVERWING EXIT ILLUMINATION AT 70-80 KNOTS. APPROXIMATELY 30 MIN LATER PROXIMITY SENSOR ELECTRONIC UNIT LIGHT ILLUMINATED. 10 MIN LATER BOTH LIGHTS WENT OUT. BOTH LIGHTS ILLUMINATED AGAIN ON TAXI IN. SDR AALA202206143613Skin · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE ON WING FIXED LEADING EDGE SKIN BEHIND THE NUMBER 4 SLAT TEMPORARY REPAIR INSTALLED FOR MAINTENANCE FERRY FROM GSO TO TUL PER EA 336732. **SUPPLEMENTAL REPORT FOR AALA202206103613: LEFT WING LEADING EDGE REPAIRED PER SRM 51SDR AALA202206103613Skin · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE ON WING FIXED LEADING EDGE SKIN BEHIND THE NUMBER 4 SLAT TEMPERARY REPAIR INSTALLED FOR MAINTENANCE FERRY FROM GSO TO TUL PER EA 336732. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202206108210Proximity Sensor · intermittentAIRCRAFT WAS NOT GROUNDED: REJECTED TAKE OFF DUE TO LEFT AFT OVERWING EXIT ILLUMINATION AT 70-80 KNOTS. APPROXIMATELY 30 MIN LATER PROXIMITY SENSOR ELECTRONIC UNIT LIGHT ILLUMINATED. 10 MIN LATER BOTH LIGHTS WENT OUT. BOTH LIGHTS ILLUMINATED AGAIN ON TAXI IN. SDR AALA202206103045Sensor · warning lightAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR CAUTION LIGHT CAME ON INTERMITTENTLY, CABIN PRESSURE IS FINE, NO LOSS AND DOOR HANDLE IN CLOSED POSITION. ACCOMPLISHED ADJUSTMENT OF ENTRY DOOR INDICATION SENSOR (S199) PER AMM 52-71-11-820-801.SDR AALA202206234081Bracket · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR CLIP DOES NOT HOLD THE GIRT BAR SECURELY. ACCOMPLISHED ADJUSTMENT OF SLIDE PACK GIRT BAR RETAINER CLIP PER AMM 25-66-01-200-802. NEED CLIP REPLACEMENT ON NEXT MAINTENANCE OPPORTUNITY. **SUPPLEMENTAL REPOSDR AALA202206175333Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT LOWER FUSELAGE WASTE VENT SKIN CORRODED LOCATED AT STA 917 AND STR 21L-22L. INSTALLED TRIPLER AND DOUBLER REPAIR AT AFT LOWER FUSELAGE LAV WASTE VENT SKIN PER SRM 53-70-01-2R.SDR AALA202206078574Cap · missingAIRCRAFT WAS NOT GROUNDED: AFT HINGE CAP MISSING FROM 4L DOOR GIRT BAR. REPLACED STOP CAP TO 4L DOOR GIRT BAR.SDR AALA202206211498Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM NUT PLATE HOLES LOCATED AT STA 986.5 AND RIGHT BUTT LINE 44. BLENDED CORROSION AND INSTALLED STRAP REINFORCEMENT PER SRM 53-70-51-2R-6.SDR AALA202206217659Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA FOUND ON FLOORBEAM LOCATED AT STA 986 AND LEFT BUTT LINE 43. 1.00X0.500X0.006. PERFORMED SPLICE REPAIR ON FLOORBEAM PER SRM 53-70-51-2R-6.SDR AALA202206144722Shroud · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING AT 23C NEEDS REATTACHING. **SUPPLEMENTAL REPORT FOR AALA202206084722: REATTACHED LIGHT SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202206136703Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED AT BS 947, RBL 24. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202206291632Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FLOOR INTERCOSTAL CRACKED BETWEEN STA 328 AND STA 344 APPROXIMATELY 48 INCHES LEFT BUTT LINE. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202206173178Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL BETWEEN STA 312 AND STA 328, 48 LEFT BUTT LINE CRACKED. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202206134547Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED BETWEEN BS 312 AND BS 328, AT RBL 30. REPLACED INTERCOSTAL PER AARD 51-40-02.SDR AALA202206295202Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION ANGLE LOCATED FROM BS 727H TO BS 767, RBL 21. REPAIRED PER SRM 53-00-53-2R REPAIR 5.SDR AALA202206235631Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION IN THRESHOLD WEB AT CARGO DOOR, LOCATED AT STA 793-847 AND STR 25R. REMOVED AND REPLACED WEB AT CARGO DOOR THRESHOLD.SDR AALA202206234537Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD RIGHT TRANSITION SHIELD HAS CORROSION LOCATED AT STA 767 TO 795 AND RIGHT BUTT LINE 21. REMOVED AND REPLACED TRANSITION SHIELD PER SRM 51-40-02.SDR AALA202206132091Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 440 AND 500H AT LBL 24. REPLACED PANEL PER AARD 51-00-05-1 AND SRM 51-40-2.SDR AALA202206132705Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED BETWWEN BS 500A TO BS 500H, RBL 25. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202206131463Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUNS ON UPPER CORNERS OF BAFFLES LOCATED BETWEEN STA 500C AND 500D AND RIGHT BUTT LINE 28. REMOVED AND REPLACED BAFFLE PER SRM 51-40-02.SDR AALA202206075004Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND .50 INCH CRACK IN PRESSURE DECK LOCATED AT STA 663 AND RIGHT BUTT LINE 36. INSTALLED DOUBLER REPAIR ON RIGH UPPER PRESSURE DECK PER SRM 57-10-10-2R-3.SDR AALA202206077932Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON TRANSITION SHIELD LOCATED BETWEEN STA 495 AND 500, AND STR 25R. INSTALLED SHIELD AFTER BLENDING OUT CORROSION PER SRM 51-10-02.SDR AALA202206079303Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CENTER BAY IN LEFT WHEEL WELL KEEL BEAM CENTER SECTION HAS A CRACK. CRACK 3/8 OF AN INCH LON AT BOTTOM OF CHEM-MILL. CRACK LOCATED AT STA 663 AND LEFT BUTT LINE 36. INSTALLED EXTERNAL DOUBLER ON UPPER LEFT PRESSURE DECK PER SRM 57SDR AALA202206142092Bleed Valve · inoperativeAIRCRAFT WAS GROUNDED: WITH SINGLE BLEED SOURCE CABIN ALTITUDE CONTINUED TO RISE. STOPPED CLIMB AND DESCENDING O2 MASKS DROPPED DURING DESCENT. FLIGHT DIVERTED TO SJU. **SUPPLEMENTAL REPORT FOR AALA202205262092: REMOVED AND REPLACED AUXILIARY POWER UNIT BLEED SDR AALA202206145787Canister · dischargedAIRCRAFT WAS GROUNDED: WITH SINGLE BLEED SOURCE CABIN ALTITUDE CONTINUED TO RISE. STOPPED CLIMB AND DESCENDING O2 MASKS DROPPED DURING DESCENT. FLIGHT DIVERTED TO SJU. **SUPPLEMENTAL REPORT FOR AALA202205262092: REMOVED AND REPLACED AUXILIARY POWER UNIT BLEED SDR AALA202206238236Cover · out of positionAIRCRAFT WAS NOT GROUNDED: CREW REPORTS EMERGENCY LIGHT COVER HANGING AT SEAT 11C. **SUPPLEMENTAL REPORT FOR AALA202205258236: REMOVED AND REPLACED EMERGENCY LIGHT COVER AT SEAT 11C PER CMM 25-23-67** (CLOSED)SDR AALA202206232978Floorboard · unstableAIRCRAFT WAS NOT GROUNDED: FLOOR BOARD SOFT AND FLEXIBLE BETWEEN SEATS 2E AND 2B. FLOOR MAKES A POPPING NOISE WHEN WEIGHT IS REMOVED. **SUPPLEMENTAL REPORT FOR AALA202205232978: FOUND FLOOR BOARD AT ROW 2 AND 3 TO BE IN SERVICEABLE CONDITION.** (CLOSED)SDR AALA202206134212Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLE AT FLOOR BOARD SUPPORT. LOCATED AT STA 990 AND RIGHT BUTT LINE 36. REMOVED AND REPLACED FLOORBOARD SUPPORT ANGLE PER AARD 51-00-05-1.SDR AALA202206070320Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FLOOR BEAM LOCATED AT STA 947 AND RIGHT BUTT LINE 50. INSTALLED T-CAP REPAIR PER SRM 53-70-51-2R-5.SDR AALA202205265917Control Module · warning lightAIRCRAFT WAS NOT GROUNDED: DURING CLIMB OUT, ANTISKID LIGHT ILLUMINATED. LIGHT EXTINGUISHED IN DESCENT PASSING 25 THOUSAND FEET. AIRCRAFT DIVERTED TO IAD DUE TO SHORT RUNWAY AT DCA. **SUPPLEMENTAL REPORT FOR AALA202205205917: REMOVED AND REPLACED AUTO BRAKE COSDR AALA202205180615Cover · out of positionAIRCRAFT WAS NOT GROUNDED: 16A EMERGENCY EXIT LIGHT COVER FOUND OFF DURING FLIGHT. RESECURED EMERGENCY LIGHT EXIT COVER. SYSTEM OPERATIONS CHECKS NORMAL PER AMM 33-51-01.
Back to Boeing 737-823