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 AALA202311072959Light · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LANDING GEAR INDICATION LIGHT DISAGREE. AIRCRAFT DIVERTED AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. REPLACED LIGHT ASSEMBLIES (L2) LEFT GEAR (AALA202311064106), NOSE GEAR (L6) ON P2-3 (AALA20231SDR AALA202311066032Unknown · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING EMERGENCY LIGHT WORK CARD 08T20033001 FOUND RIGHT EXTEMERENGY LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202311067391Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 EMERGENCY EXIT SLIDE FLAP IS HANGING VERY LOW, NOT STOWED ALL THE WAY INTO POSITION. ADJUSTED GIRT BAR CURTAIN ON L1 DOOR SLIDE. PER AMM 25-66-01.SDR AALA202311063698Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STUB BEAM AT BS 616, S17R, RBL 64. REPLACED STUB BEAM PER EA 348857.SDR AALA202311064495Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN OR CLOSE. ADJUSTED LAVATORY D DOOR.SDR AALA202311133649Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TRANSITION PANEL BETWEEN BS 727 AND BS 787, S25R. REPAIRED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202311060142Stringer · corrodedAIRCRAFT WAS IN BASE MAINTENANCE: CORROSION ON OUTER CHORD OF STR 23L BETWEEN STA 325 TO STA 348. REPAIRED CHORD PER EA 348691.SDR AALA202311061102Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY D IS DIFFICULT TO OPEN OR CLOSE IN FLIGHT. ADJUSTED LAVATORY D DOOR. FUNCTIONAL CHECKS GOOD. PER AMM 25-40-64.SDR AALA202311069527Spring · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR VERY DIFFICULT TO OPEN AND CLOSE IN FLIGHT. FOUND COCKPIT DOOR STOP SPRING NOT HOLDING DOOR STOP UP, REMOVED AND REPLACED DOOR STOP, OPERATIONAL CHECK NORMAL. PER AMM 52-51-00.SDR AALA202311062794Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT L1 BOARDING DOOR VERY DIFFICULT TO OPEN OR SHUT AND LOCKING HANDLE REQUIRES MORE FORCE TO OPERATE OPEN OR CLOSED. LUBRICATED 1L DOOR. FUNCTIONAL CHECK GOOD. PER AMM 52-11-00.SDR AALA202311066317Screw · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPERATE. DIFFICULT TO OPEN OR CLOSE. SECURED 2 LOOSE SCREWS AT DOOR THRESHOLD FLOOR PLATE.SDR AALA202311152590Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT WEB PANEL HAS CORRSION AT STA 801 TO 804 AND STR 25R. INSTALLED NEW WEB PANEL. PER BOEING DRAWING NUMBER 146A8340, AARD 51-00-05 AND SRM 51-40-02.SDR AALA202311139446Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 747 PLUS 10 INCHES, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-01 AND SRM 51-40-02.SDR AALA202311131096Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD RIGHT HAND GIRT BAR MOUNT FASTENER HOLE AT BS 986, RBL 42. INSTALLED STRAP REPAIR PER SRM 53-70-51-2R PROCEDURE 6 ALTERNATIVE 3.SDR AALA202311090865Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM CHORD AT BS 986, LBL 27. REPAIRED FLOOR BEAM CHORD PER 53-00-51-2R-1.SDR AALA202311096686Floorbeam · corrodedAIRCRAFT IN BASE MAINTENACE: CORROSOIN ON UPPER CHORD OF AFT PASSENGER CABIN FLOOR BEAM AT BS 986, RBL 48. REPAIRED FLOOR BEAM CHORD PER SRM SRM 53-70-51-2R REPAIR 6 ALTERNATIVE 4.SDR AALA202311084145Floor Support · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN FORWARD CARGO COMPARTMENT FLOOR SUPPORT AT BS 500I BETWEEN S25R AND S25L. REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202311063395Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR TRANSITION PANEL BETWEEN BS 767 AND BS 780 AT RBL 24.SDR AALA202311066248Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 382 TO BS 344, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202311063368Landing · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND WING PANEL LANDING AT WS 512, RIB 17. REPLACED PANEL LANDING PER SRM 51-40-02-0G.SDR AALA202311060166Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310025659: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311065578Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310025240: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311062731Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310029661: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311069770Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310028584: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311065321Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310026821: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311068825Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310025762: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311063297Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310029031: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311063834Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310026674: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311060492Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310023573: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00 REPAIR 1.SDR AALA202311060256Fitting · crackedITEM WAS PREVIOUSLY SUBMITTED UNDER FAA OPERATOR CONTROL NUMBER AALA202310023798: AIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202311030425Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT FAILS BITE TEST AND TAMPER SEALS BROKEN. REMOVED AND REPLACED FLASHLIGHT ASSEMBLY. PER AMM 25-64-00.SDR AALA202311036172Coffeemaker · leakingAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED DUE TO WATER LEAK IN AFT GALLEY, TURNED WATER OFF CONTINUED TO LEAK. AIRCRAFT LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. CHANGED COFFEE BREWER CARAFE ON UPPER COFFEE BREWER AFT GALLEY LEAK CHECK GOOD.SDR AALA202311037975Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663, RBL 34. REPLACED ATTACH ANGLE PER AARD 57-10-10-10 REPAIR 10.SDR AALA202311303935Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO LEFT HAND TRANSITION PANEL AT BS 500C TO 500I, LBL 25 HAS CORROSION. INSTALL NEW TRANSITION PANEL. PER SRM 53-00-53-2R AND AARD 51-00-05-1.SDR AALA202311156981Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL FROM AIRCRAFT STA 727 TO 294 AT WATERLINE 207 TO LBL 12. REMOVE AND REPLACED INTERCOSTAL. PER AARD 51-00-05-1 DRW 141A5600.SDR AALA202311136673Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE; CORROSION ON FORWARD LAVATORY MOUNT INTERCOSTAL AT BS 300, LBL 45. REPLACED INTERCOSTAL PER SRM 51-40-02, DWG 141A5600, AND AARD 51-00-05-1.SDR AALA202311100060Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500I, 2S25R. REPLACED TRANSITION PANEL PER SRM 51-00-05-1.SDR AALA202311093306Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500C TO BS 500D, S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202311090148Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500C, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202311096097Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500C TO BS 500D, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202311095028Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500D TO BS 500E, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202311069582Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WEB BELOW FORWARD CARGO DOOR CENTER THRESHOLD PANEL AT BS 440, RBL 23.25. REPAIRED WEB PER SRM 51-70-13 AND DWG 143A8330.SDR AALA202311020922Anti-Ice Valve · warning messageAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO PHL. AFTER TAKE OFF DURING CLIMB THE ENGINE COWL ANTI-ICE VALVE FAILURE LIGHTS ILLUMINATED ON BOTH ENGINES. THE FLIGHT CREW ACCOMPLISHED THE QRH PROCEDURES AND LANDED SAFELY AT PHL WSDR AALA202311027992Anti-Ice Valve · warning messageAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO PHL. AFTER TAKE OFF DURING CLIMB THE ENGINE COWL ANTI-ICE VALVE FAILURE LIGHTS ILLUMINATED ON BOTH ENGINES. THE FLIGHT CREW ACCOMPLISHED THE QRH PROCEDURES AND LANDED SAFELY AT PHL WSDR AALA202311026994Warning Light · false activationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO A FEEL DIFFERENCES PRESSURE LIGHT AND VERY LITTLE CONTROL RESPONSE. AIRCRAFT LANDED SAFELY AT JFK WITHOUT FURTHER INCIDENT. FEEL DIFFERENCES PRESSURE LIGHT ILLUMINATES ARE CONSIDERED A NUISANCE EVENT,SDR AALA202311026961Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LOCK DIFFICULT TO OPERATE. LUBED LEFT AFT LAVATORY DOOR LOCK LATCH. OPERATIONAL CHECKS NORMAL.SDR AALA202311023585Collar · misinstalledAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR, NEW RED COVER IS CAUSING PROBLEMS TOO BIG OR THICK. RESECURED GIRT BAR COLLAR, LOCATED RED COVER BACK TO CORRECT LOCATION. OPERATIONAL CHECK NORMAL.SDR AALA202311027024Door · out of adjustAIRCRAFT WAS NOT GROUNDED: BUSINESS CLASS LAVATORY DOOR STICKS WHEN OPENING AND CLOSING. ADJUSTED DOOR LATCH LAVATORY A. OPERATIONAL CHECKS GOOD. PER MM 25-40-11.SDR AALA202311091611Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT ANGLE AT BS 992, RBL 36. REPLACED ANGLE PER AARD 51-00-05-1 AND DWG 147A5700.SDR AALA202311090806Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE CREASE ANGLE LOCATED AT BS 947, RBL 47. REPAIRED CREASE ANGLE PER SRM 51-10-02.
Back to Boeing 737-823