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 AALA202212220367Support Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT BRACKET LOCATED AT BS 947.5 AND FROM RBL 12 TO RBL 22. REPLACED BRACKET PER SRM 51-40-02-0G.SDR AALA202212216413Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 927 TO BS 947.5 AND FROM RBL 19 TO RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202211152321Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 747 TO BS 767 AND S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R REPAIR 5. OPENSDR AALA202211031024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED AT STA 747 AND STR 25R. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-0-53-2R.SDR AALA202212213635Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 760 TO BS 787 AND FROM LBL 19 TO LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202212215637Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727I TO BS 767 AND FROM RBL 19 TO RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212214705Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727G TO BS 727H AND FROM LBL 19 TO LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212219542Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 727I AND LBL 22. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202212238594Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LOWER RAIL HAS SIGNS OF CORROSION IN RADIUS LOCATED AT STA 500I AND STR 25R AND 26R. REMOVED AND REPLACED FORWARD CARGO AFT BULKHEAD LOWER RAIL PER B737-NG SRM 51-40-02-0G.SDR AALA202212215819Support Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WING TO BODY AFT FAIRING SUPPORT FRAME ASSEMBLY LOCATED AT BS 727 +2 AND RBL 9.5. REPAIRED FRAME ASSEMBLY PER EA 340107.SDR AALA202210051780Anti-Ice Valve · faultedAIRCRAFT WAS GROUNDED: ABORTED TAKEOFF AT APPROXIMATELY 50 KNOTS DUE TO LEFT COWL ANTI ICE MASTER CAUTION. REPLACED LEFT ENGINE COWL THERMAL ANTI ICE (TAI) VALVE PER AMM 30-21-11. ACCOMPLISHED SATISFACTORY OPERATIONAL AND LEAK CHECKS.SDR AALA202301037242Smoke Detector · false activationAIRCRAFT IN BASE MAINTENANCE: FORWARD LAVATORY SMOKE DETECTOR ACTIVATED ON VECTORS TO FINAL APPROACH, CONTINUED AFTER PARKING. REMOVED AND REPLACED FORWARD LAVATORY SMOKE DETECTOR.SDR AALA202210040564Light · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE LIGHT PATH LIGHTING AT SEAT 27 ABC AND 30 ABC LOOSE. SECURED ESCAPE PATH LIGHTING BRACKET AT 27 ABC AND 30 ABC IN ACCORDANCE WITH CMM 25-23-67.SDR AALA202210030067Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN/CLOSE. ADJUSTED LAVATORY D DOOR.SDR AALA202210057003Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND PASSENGER CABIN MAIN DECK PREVIOUS REPAIR DOUBLER LOCATED AT BS 992.8 AND LBL 64. REPLACED REPAIR DOUBLER UNDERLYING SHEAR WEB PER SRM 53-70-51-1A PROCEDURE 1.SDR AALA202210046771Ground Stud · damagedAIRCRAFT WAS GROUNDED: RAPID FUEL QUANTITY DECREASE RIGHT NUMBER 2 MAIN TANK QUANTITY, WHILE AT CRUISE, AIRCRAFT DIVERTED TO BNA AND DECLARED AN EMERGENCY. DURING DESCENT QUANTITY IN RIGHT TANK INCREASED. SUSPECT GAGE ERROR. PERFORMED FUEL QUANTITY INDICATION SDR AALA202210044239Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE AREAS OF CORROSION AROUND FASTENER HOLES AND UPPER SURFACE OF FORWARD CARGO COMPARTMENT FLOOR STRUCTURE RIGHT SIDE PLATE BETWEEN BODY STATION 500 A AND BODY STATION 500 I RIGHT BUTT LINE 24. CUT AND FABRICATED A NEW SIDE SDR AALA202210035484Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR LATCH DIFFICULT TO OPERATE AND DOES NOT ILLUMINATE INTERIOR LIGHT WHEN ENGAGED. LUBED RIGHT AFT LAVATORY DOOR LATCH IN ACCORDANCE WITH CMM 25-40-65.SDR AALA202210034157Hook · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT RETAINING CLIP ON 1R DOOR THAT HOLDS THE GIRT BAR DOES NOT SECURE GIRT BAR WELL. ADJUSTED CLIP. OPERATIONAL CHECK GOOD.SDR AALA202210037418Door · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR IS DIFFICULT TO OPEN. TIGHTENED DOOR HARDWARE. OPERATIONAL CHECK NORMAL PER CMM 25-40-64.SDR AALA202210036770Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT SIDEWALL PANEL EMERGENCY EXIT LIGHT AT ROW 16 HAS ONE BULB INOPERATIVE. REMOVED AND REPLACED LAMP ON EMERGENCY EXIT LIGHT OF LEFT SIDEWALL PANEL AT ROW 16 IN ACCORDANCE WITH 33-51-01-960-801.SDR AALA202210039737Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT GALLEY CEILING CENTER EMERGENCY LIGHT HAS ONE BULB INOPERATIVE, RIGHT OF EXIT SIGN. REPLACED LAMP ON EMERGENCY EXIT SIGN (LIGHT SIDE) AT AFT GALLEY CEILING CENTER IN ACCORDANCE WITH 33-51-01-960-801.SDR AALA2022100305484Girt Bar · tornAIRCRAFT IN BASE MAINTENANCE: L2 DOOR ESCAPE SLIDE GIRT BAR FOLD IS TORN. OPEN.SDR AALA202210038104Hook · looseAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR CLIP IS LOOSE. TIGHTENED 1R DOOR GIRT BAR RETAINER CLIP. OK FOR SERVICE PER AMM25-66-01.SDR AALA202210038317Wire Harness · unserviceableAIRCRAFT WAS GROUNDED: DURING CLIMB OUT ABOVE FL200 SUSTAINED ENGINE 2 VIBRATIONS GREATER THAN 4.0 MAX; APPROXIMATELY 4.3 ON DESCENT; WITH POWER AT IDLE NOTICEABLE AIRFRAME VIBRATIONS. ENGINE INDICATION NORMAL. FLIGHT RETURNED TO MIA, LANDING SAFELY. REPLACED SDR AALA202210039221Accelerometer · unserviceableAIRCRAFT WAS GROUNDED: DURING CLIMB OUT ABOVE FL200 SUSTAINED ENGINE 2 VIBRATIONS GREATER THAN 4.0 MAX; APPROXIMATELY 4.3 ON DESCENT; WITH POWER AT IDLE NOTICEABLE AIRFRAME VIBRATIONS. ENGINE INDICATION NORMAL. FLIGHT RETURNED TO MIA, LANDING SAFELY. REPLACED SDR AALA202210196684Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WHEEL WELL VERTICAL PRESSURE DECK WEB CRACKED AT CENTER OUT BOARD WEB LOCATIONS. LOCATED AT STA 663 AND RIGHT BUTT LINE 45. REMOVED AND REPLACED WEB PER SRM 57-10-1002RSDR AALA202210047948Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 15.04. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210047832Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 32.40. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210040217Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL40.87. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210043556Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 54.60. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210040298Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 6.14. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210045937Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 15.04. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210044957Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 40.87. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210042883Plate · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 54.60. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210034902Light · odorAIRCRAFT WAS NOT GROUNDED: CLIMBING OUT OF 13000' WE SMELLED A MILD SULFUR OR BURNING OVEN ODOR THAT CONTINUED FOR ABOUT 10-15 MINUTES. NO OVENS IN USE. IT SEEMED TO GO AWAY. POSSIBLY STRONGEST SMELL IN MID CABIN. ACCOMPLISHED SMOKE ODOR FUMES INITIAL TROUBLE SDR AALA202210039687Light · not reportedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DOOR LIGHT BY SEAT 17F.(OPEN)SDR AALA202209295308Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY LATCH IS VERY DIFFICULT TO UNLOCK. LUBRICATED LEFT AFT LAVATORY LATCH ASSEMBLY DOOR LATCH.SDR AALA202210198212Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL CRACKED BETWEEN STA 312 AND 328 AND LEFT BUTT LINE 46. REMOVED AND REPLACED INTERCOSTAL PER BOEING DRAWING.SDR AALA202210041061Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, LBL 32.40. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202210047299Fitting · crackedAIRCRAFT WAS GROUNDED: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540, RBL 6.14. REPLACED SHEAR FITTING PER EA 339148.SDR AALA202209303759Guide Arm · unserviceableAIRCRAFT WAS GROUNDED: 1L DOOR DOES NOT OPERATE PROPERLY, HOLD OPEN LATCH WONÏ¿½T RELEASE. REPLACED GUIDE ARM PER AMM 52-11-21 A AND AMM 52-11-00-820-801.SDR AALA202209296042Plate · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPERATE LOWER DOOR RUBBING ON FLOOR. FOUND AFT LAVATORY LEFT HAND DOOR BOTTOM PLATE LOOSE WHICH WAS JAMMING THE DOOR. RESECURED IN ACCORDANCE WITH CMM 25-40-64.SDR AALA202209292923Rub Strip · damagedAIRCRAFT IN BASE MAINTENANCE: 1R DOOR SLIDE GIRT RUB STRIP DAMAGED. REPLACED SLIDE PER AMM 25-66-01.SDR AALA202210195190Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT WHEEL WHEEL FORWARD BULKHEAD HAS 10 IN CRACK ON VAPOR BARRIER, LOCATED AT STA 663, AND RIGHT BUTT LINE 30-38.SDR AALA202210207297Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION, LEFT HAND WHEEL WELL VAPOR BARRIER, LOCATED AT BS 663 FROM LBL 28 TO LBL 35. REPAIRED VAPOR BARRIER PER SRM 57-1-10-2R-2 AND AARD 57-10-10-9.SDR AALA202210055704Floor Support · dentedAIRCRAFT IN BASE MAINTENANCE: FLIGHT CONTROL COMPARTMENT AFT FLOOR STRUCTURE ADJACENT TO AFT SECTION OF CENTER PEDESTAL HAS DENT LOCATED AT BS 252, LBL 5. REPAIRED PER SRM 53-10-51-2R FIGURE 203.SDR AALA202210044799Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION BAFFLE LOCATED FROM BS 500A TO BS 500B, S26L. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202210048778Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION BAFFLE LOCATED FROM BS 500D TO BS 500E, S26R. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202209309679Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT HAND AFT SIDE EMERGENCY LIGHT BULB IN ACCORDANCE WITH AMM 33-51-04.
Back to Boeing 737-823