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 AALA202410218421O-Ring · leakingAIRCRAFT WAS GROUNDED: STRONG MUSTY DIRTY SOCK SMELL, PERSISTED THROUGHOUT FLIGHT STRONG IN BACK BUT DISSIPATED FOR A LITTLE WHILE, BUT CAME BACK VERY STRONG DURING ARRIVAL. FLIGHT ATTANDENT NEEDED TO WEAR MASK. **SUPPLEMENTAL REPORT FOR (AALA202410176015): RESDR AALA202410219137Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 947 PLUS 6 INCHES, LBL 45.5. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410211157Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE LOCATED FROM STA 386 TO STA 387, LBL 13. REPLACED ANGLE PER AARD 51-00-05-01.SDR AALA202410218886Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM STA 277 TO STA 294.5, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410172740Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT SIDEWALL PANEL ATTACH ANGLE AT STA 867, LBL 24. REPLACED BRACKET PER SRM 51-40-02-0G.SDR AALA202410174239Hydraulic System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENROUTE INDICATIONS OF A HYDRAULIC SYSTEM A FLUID LEAK, QUANTITY % WAS DROPPING 1% EVERY 8 MINUTES OR SO; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TUL. PERFORMED A THOROUGH DETAILED VISUAL INSPECTION OFSDR AALA202410174258Light · inoperativeAIRCRAFT WAS GROUNDED: L2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. RELAMPED L2 DOOR EXTERNAL EMERGENCY LIGHT. PER AMM 33-51-04.SDR AALA202410173681Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTEY DOOR GIRT BAR DIFFICULT TO PUT INTO LEFT SIDE ARMING BRACKET. LUBRICATION OF AREA ACCOMPLISHED, OPERTIONAL CHECK GOOD. PER 25-66-01.SDR AALA202410175118Oven · odorAIRCRAFT WAS NOT GROUNDED: OVEN NUMBER 2 STRANGE SMELL REPORTED BY FLIGHT ATTANDENT, CHECKED AND CONFIRMED OVEN 2 SMELLS. REMOVED AND REPLACED OVEN NUMBER 2. PER AMM 25-32-03.SDR AALA202410176015Unknown · odorAIRCRAFT WAS GROUNDED: STRONG MUSTY DIRTY SOCK SMELL, PERSISTED THROUGHOUT FLIGHT STRONG IN BACK BUT DISSIPATED FOR A LITTLE WHILE, BUT CAME BACK VERY STRONG DURING ARRIVAL. FLIGHT ATTANDENT NEEDED TO WEAR MASK. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202410160518Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT FOR 4L DOOR IS INOPERATIVE. RELAMPED EXTERIOR EMERGENCY SLIDE LIGHT AT AFT 4L DOOR. OPERTIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202410169882Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411065525Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ANGLE CONNECTED TO FRAME AND FUSELAGE SKIN AT STA 328, S23L. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202411050790Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 23L AT STA 328. REPLACED STRINGER PER EA 358969.SDR AALA202410167807Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING INTERIOR EMERGENCY LIGHT SYSTEM , LIGHT ON ROW 17ABC EMERGENCY PROXIMITY LIGHT TURN OUT TO BE INOPERATIVE. ROW 17 ABC EMERGENCY PROXIMITY LIGHT FIXED AFTER DISCONNECTED CONNECTOR HAS BEEN RECONNECTED, OPERATIONAL TESDR AALA202410166417Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT AFT GALLEY UNSECURE. SECURED THE AFT GALLEY EMERGENCY LIGHT ASSEMBLY. OPERATIONAL CHECK OF THE LIGHT IS NORMAL. PER AMM 33-51-01.SDR AALA202410162996Light · inoperativeAIRCRAFT WAS GROUNDED: R2 DOOR EMERGENCY EXIT LIGHT IS OUT. REMOVE AND REPLACED EEL ASSEMBLY. PER AMM 33-51-01.SDR AALA202410165883Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, RBL 42. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410169331Generator · failedAIRCRAFT WAS GROUNDED: AFTER BOARDING WHILE ON APU POWER THE APU GENERATOR KICKED OFF AND ENTIRE PLANE HAD OVERWHELMING SMOKE ODOR SMELL. **SUPPLEMENTAL REPORT FOR (AALA202410159331): REMOVED AND REPLACED APU GENERATOR. OPERTIONAL AND LEAK CHECK GOOD. PER AMM SDR AALA202410160180Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND FRAME (PICKLE FORK) AT STA 663, S18L. REPLACED FRAME PER EA 358150.SDR AALA202410159331Generator · disengagedAIRCRAFT WAS GROUNDED: AFTER BOARDING WHILE ON APU POWER THE APU GENERATOR KICKED OFF AND ENTIRE PLANE HAD OVERWHELMING SMOKE ODOR SMELL. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202410157619Unknown · odorAIRCRAFT WAS GROUNDED: SOF EVENT. AIRCRAFT OUT OF SERVICE DUE TO CREW REPORT ODOR IN CABIN DURING TAKE OFF AND CLIMB DESCRIBED AS DIRTY SOCK SMELL. ODOR APPEARED TO DISSIPATE WITH RIGHT PACK OFF **SUPPLEMENTAL REPORT FOR (AALA202410147619): RAN ENGINES, NO SMESDR AALA202410158017Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR HORIZONTAL BEAM FROM STA 328.87 TO STA 299.10. REPLACED BEAM PER AARD 51-00-05-1.SDR AALA202410147619Unknown · odorAIRCRAFT WAS GROUNDED: SOF EVENT. AIRCRAFT OUT OF SERVICE DUE TO CREW REPORT ODOR IN CABIN DURING TAKE OFF AND CLIMB DESCRIBED AS DIRTY SOCK SMELL. ODOR APPEARED TO DISSIPATE WITH RIGHT PACK OFF**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202411056164Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER ARIL ASSEMBLY LOCATED AT STA 500I, FROM LBL 24 TO RBL 24. REPLACED BULKHEAD SUPPORT RAIL PER SRM 53-30-08.SDR AALA202411056043Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL BETWEEN STA 500D AND STA 500E, AT LBL 24. REPAIRED TRANSITION PANEL PER SRM 53-00-53 2R.SDR AALA202410300850Web · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WHEEL WELL FORWARD WHEEL CUT OUT HAS CORROSION. WEB FOUND TO BE OUT OF LIMITS, PER B737-NG-SRM 53-40-71-1A PROCEDURE 1. - 4-D. REMOVED OUT OFLIMITS WHEEL WELL WEB, PER B737-NG SRM 51-40-02. REPAIRED WEB ASSEMBLY, PER B73SDR AALA202410211290Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBOAD SUPPORT AT STA 950, FROM RBL 17 TO RBL 24. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202410218999Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 947 TO STA 967, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410140664Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD FROM STA 767 TO STA 787, S23R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-01.SDR AALA202410144884Light · detachedAIRCRAFT WAS NOT GROUNDED: ROW 27ABC EMERGENCY LIGHTING IN THE AISLE IS HANGING DOWN BY THE WIRES ON THE SIDE OF 27C. REATTACHED AISLE EMERGENCY LIGHT AT ROW 27C. OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202410149964Door · stickingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS STIFF AND HARD TO OPEN. REMOVED AND REPLACED LAVATORY-D DOOR. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202410147317Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS FORWARD MEGAPHONE DOES NOT FUNCTION. REMOVED AND REPLACED FORWARD MEGAPHONE. PER DBF 2000-5.SDR AALA202411052319Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, RBL 26.5. ACCOMPLISHED REPAIR PER PER SRM 53-70-51-2R-5.SDR AALA202410214941Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT STA 992.5, LBL 46. REPAIRED WEB PER EA 358799.SDR AALA202410166863Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787, S23R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202410144563Lamp · burned outAIRCRAFT IN BASE MAINTENANCE: L2 PASSANGER DOOR EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP FOR EMERGENCY LIGHT. OPERTIONAL TESTED GOOD. PER AMM 33-51-04.SDR AALA202410116839Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND EMERGENCY EXIT LIGHT ON EXTERIOR OF FUSELAGE IS INOPERATIVE. REMOVED AND REPLACED RIGHT HAND AFT EMERGENCY EXIT LIGHT BULB. OPERTIONAL CHECK GOOD. PER 33-51-04.SDR AALA202410153847Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 272, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410156578Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 320, RBL 42. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410153545Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE FROM STA 380 TO STA 400, LBL 13. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202410115760Bolt · missingAIRCRAFT WAS GROUNDED: ON TAKEOFF ROLL, AIRPORT GROUND CREW REPORTED A CONTINUOUS STREAM OF CLEAR LIQUID STREAMING OUT OF THE RIGHT WING. COCKPIT INDICATIONS WERE NORMAL DURING FLIGHT. FOUND 4 BOLTS MISSING AT SURGE TANK ACCESS DOOR 533BB ON RIGHT WING. INSTALSDR AAL2024F00007Bulkhead · crackedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT FORWARD BULKHEAD CENTER PANEL IS CRACKED 1O INCH FROM BOTTOM OF PANEL. REMOVED AND INSTALLED AFT CARGO COMPARTMENT FORWARD BULKHEAD CENTER PANEL. PER B737NG AMM 25-52-18.SDR AALA202410151506Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202410150963Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, LBL 22. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202410157129Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202410115551Light · dislodgedAIRCRAFT WAS NOT GROUNDED: FLOOR LEVEL EMERGENCY LIGHTING HANGING ON SIDE OF SEAT 12C BY ITS WIRING. **SUPPLEMENTAL REPORT FOR (AALA202410105551): REMOVED AND REPLACED RACEWAY SHROUD AT SEAT ROW 12ABC. OPERTIONAL CHECK GOOD. PER B/E AEROSPACE CMM 25-23-67**(CLSDR AALA202410101877Guide Arm · out of positionAIRCRAFT WAS NOT GROUNDED: MAIN CABIN DOOR WAS JAMMED. WERE ABLE TO OPEN AFTER SEVERAL ATTEMPTS. AFTER PAX DEPLANED. THE AGENT AND I TRIED TO OPEN AND CLOSE AGAIN. THE DOOR GOT STUCK 1/4 OF THE WAY OPEN. TOOK SEVERAL MORE ATTEMPTS TO OPEN UP. FOUND FORWARD ENTSDR AALA202410102086Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 32C EMERGENCY LIGHTING DETACHED. REMOVED AND REPLACED PAX SEAT 32C EMERGENCY LIGHT ASSEMBLY; OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202410105551Light · detachedAIRCRAFT WAS NOT GROUNDED: FLOOR LEVEL EMERGENCY LIGHTING HANGING ON SIDE OF SEAT 12C BY ITS WIRING. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).
Back to Boeing 737-823