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 AALA202405016985Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AND CRACK IN PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 947, LBL 53. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202404128976Transmitter · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS DID NOT EXTEND, NO FLAP MOVEMENT, NO FLAP INDICATION; AIRCRAFT LANDED SAFELY AT AUS. REPLACED RIGHT HAND FLAP POSITION TRANSMITTER. PER AMM 27-58-01-400-801**(CLOSED).SDR AALA202404118976Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS DID NOT EXTEND, NO FLAP MOVEMENT, NO FLAP INDICATION; AIRCRAFT LANDED SAFELY AT AUS. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404111117Slide · out of positionAIRCRAFT WAS NOT GROUNDED: REMOVED L1 SLIDE, FOUND TO BE WRONG POSITION FOR CHANGE. REINSTALLED L1 DOOR SLIDE. PER J/C 09L20025004.SDR AALA202404114537Tube · missingAIRCRAFT WAS NOT GROUNDED: 1L DOOR MISSING ONE RED GIRT BAR HEATSHRINK. REPLACED MISSING RED TAPE ON GIRT BAR. PER AMM 25-66-01.SDR AALA202404155779Door · noneAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. PERFORMED OPERTIONAL CHECK OF LAVATORY-D DOOR. PER AMM 25-40-14, DOOR FOUND TO BE SMOOTH AND OPERATING NORMALLY. NO FAULT FOUND**(CLOSED).SDR AALA202404105338Holder · unsecureAIRCRAFT WAS NOT GROUNDED: LIGHT ABOVE THE LUGGAGE BINS BY ROW 12EDF HANGING BY ITS WIRES. REINSTALLED EMERGENCY EXIT LIGHT HOUSING ABOVE BINS 12DEF. PER AMM 33-51-01.SDR AALA202404106440Stud · missingAIRCRAFT WAS NOT GROUNDED: SERVICE DOOR 1R, RIGHT SIDE GIRT BAR RED PART LOOSE. REPLACED MISSING STUD FOR SERVICE DOOR 1R, RIGHT SIDE GIRT BAR. PER AMM 25-66-00.SDR AALA202404104022Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE GUST LOCK ON THE 1L DOOR IS DIFFICULT TO RELEASE. LUBE L1 DOOR GUST LOCK, OPERTIONAL CHECK GOOD. PER AMM 52-11-00.SDR AALA202404105779Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404108198Slide · low pressureAIRCRAFT WAS GROUNDED: PRESSURE INDICATION IN RED (APPROXIMATELY 2250 PSI) ON 4L EMERGENCY SLIDE. **SUPPLEMENTAL REPORT FOR (AALA202404098198): REMOVED AND REPLACED 4L (AFT LEFT) EMERGENCY ESCAPE SLIDE. PER JOBCARD 08L22125001**(CLOSED).SDR AALA202404103340Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND LAVATORY VENT AT BS 917, FROM S21L TO S22L. REPAIRED SKIN PER SRM 53-70-01-2R-3.SDR AALA202404098198Bottle · low pressureAIRCRAFT WAS GROUNDED: PRESSURE INDICATION IN RED (APPROXIMATELY 2250 PSI) ON 4L EMERGENCY SLIDE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404090145Holder · brokenAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT ON SEAT 32C BROKEN OFF. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ON SEAT 32C. OPERTIONAL CHECK GOOD. PER AMM 33-51-11.SDR AALA202404097899Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN L1 DOOR SURROUND STRUCTURE CREASE ANGLE FROM BS 270 TO BS 360, LBL 55. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202405035374Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR STRUCTURE WEB NEAR AFT GALLEY MOUNT AT STA 987, LBL 30. REPAIRED WEB PER SRM 51-70-13-2R-4 AND EA 353421.SDR AALA202404244244Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 960, RBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202404248722Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 960, LBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-40-05.SDR AALA202404248829Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 947, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1R.SDR AALA202404228536Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN RIGHT AFT ENTRY DOOR SILL INNER CHORD FROM STA 967 TO STA 987, WL 208. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202404121456Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. REMOVE AND REPLACED LAVATORY-D BI-FOLD DOOR. PER AMM 25-40-14 AND CMM 25-40-58**(CLOSED).SDR AALA202404100149Lug · crackedAIRCRAFT WAS NOT GROUNDED: NUMBER 2 ENGINE, NUMBER 1 PLATFORM HAS CRACKED LUG. REMOVE AND REPLACED NUMBER 2 ENGINE PLATFORM SET. PER MCM 4901.SDR AALA202404105208Pcu · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LOSS OF SYSTEM-B HYDRAULICS IN FLIGHT; AIRCRAFT PERFOMRED GO AROUND AND LANDED SAFELY AT DFW.**SUPPLEMENTAL REPORT (AALA202404095208): UPON INVESTIGATION FOUND LEAK FROM MAIN RUDDER (PCU)-POWER CONTROL USDR AALA202404103689Tube · leakingAIRCRAFT WAS GROUNDED: AIRCRAFT HAS HAD MULTIPLE OUT OF SERVICE FOR STRONG REPEATED SMELL OF FISH ORDOR IN THE CABIN. **SUPPLEMENTAL REPORT FOR (AALA202404097715): REMOVED AND REPLACED AIR DISTRIBUTIONSYSTEM MUFFLER ASSEMBLY (AALA202404097715), PER AMM 21-22-0SDR AALA202404107715Muffler · dirtyAIRCRAFT WAS GROUNDED: AIRCRAFT HAS HAD MULTIPLE OUT OF SERVICE FOR STRONG REPEATED SMELL OF FISH ORDOR IN THE CABIN. **SUPPLEMENTAL REPORT FOR (AALA202404097715): REMOVED AND REPLACED AIR DISTRIBUTIONSYSTEM MUFFLER ASSEMBLY (AALA202404097715), PER AMM 21-22-0SDR AALA202404091501Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AISLE LIGHT ROW 23 RIGHT HAND SIDE INOPERATIVE. REMOVED AND REPLACED INOPERATIVE EMERGENCY AISLE LIGHT CONNECTOR AT ROW 23DEF. PERFORMED SATISFACOTRY CHECK GOOD. PER B737-NG-SWPM 20-10-13, B737-NG-AMM 33-51-00-720-801.SDR AALA202404098001Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AISLE LIGHT ROW 18 LEFT HAND SIDE INOPERATIVE. REMOVED AND REPLACED INOPERATIVE EMERGENCY AISLE LIGHT CONNECTOR AT ROW 18ABC. PERFORMED SATISFACOTRY CHECK GOOD. PER B737-NG-SWPM 20-10-13, B737-NG-AMM 33-51-00-720-801.SDR AALA202404097715Unknown · odorAIRCRAFT WAS GROUNDED: AIRCRAFT HAS HAD MULTIPLE OUT OF SERVICE FOR STRONG REPEATED SMELL OF FISH ORDOR IN THE CABIN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404095208Hydraulic System · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LOSS OF SYSTEM-B HYDRAULICS IN FLIGHT; AIRCRAFT PERFOMRED GO AROUND AND LANDED SAFELY AT DFW.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404097530Light · damagedAIRCRAFT WAS GROUNDED: CATERING REPORTS AFT LEFT SERVICE DOOR EXTERIOR EMERGENCY LIGHT DAMAGED. REMOVED AND REPLACED L4 EMERGENCY EXTERIOR LIGHT ASSEMBLY. PER AMM 33-51-04.SDR AALA202404091456Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404094048Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. LUBED DOOR. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202404092836Cover · missingAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THE PROTECTIVE COVER OF THE EXIT SIGN LOCATED BY THEAFT LEFT LAVATORY IS MISSING. ACCOMPLISHED EXIT SIGN LIGHT ASSEMBLY REPLACEMENT, OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202404090498Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 8C TRIM BROKEN AND EMERGENCY LIGHT CORD HANGING OUT. REMOVE AND REPLACED EMERGENCY LIGHT SHROUD AT SEAT 8C. PER CMM 25-23-67.SDR AALA202404098209Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 26C EMERGENCY LIGHT HOUSING DETACHED FROM SEAT. REMOVED AND REPLACED EMERGENCY LIGHT SHROUD AT SEAT 26C. PER CMM 25-23-67.SDR AALA202404098022Door · lack of lubeAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN. LUBRICATED DOOR HINGE AND STRIKE. PER AMM 52-51-00.SDR AALA202404196716Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 18 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202404150217Stop Fitting · faultyAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY (3/5) FLIGHT DECK DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED DOOR STOP ASSYEMBLY, FUNCATIONAL CHECKS GOOD ON DOOR. PER AMM 52-51-01**(CLOSED).SDR AALA202404157247Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500C TO BS 500I, LBL 28. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202404157404Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500C TO BS 500I, LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202404159896Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500C TO BS 500I, LBL 28. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202404115234Housing · detachedAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT AT 24ABC EMERGENCY PATH LIGHT DETACHED.**SUPPLEMENTAL REPORT FOR (AALA202404085234): REMOVED AND REPLACED (EPL)-EMERGENCY PATH LIGHTING SEAT SHROUD AT ROW 24 RIGHT**(CLOSED).SDR AALA202404101476Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHT ON SEAT 23C IS DETACHED, HANGING LOOSE.**SUPPLEMENTAL REPORT FOR (AALA202404081476): REMOVED AND REPLACED EMERGENCY LIGHT SHROUD HOUSING AT SEAT 23C. PER CMM 25-23-67**(CLOSED).SDR AALA202404102305Doubler · crackedAIRCRAFT WAS GROUNDED: EXTERNAL POWER DOOR CUTOUT LOWER FLANGE AND BACKING DOUBLER CRACKED AT BS 230, S23R. REPAIRED PER SRM 53-10-15-1A PROCEDURE 4 AND SRM 53-10-15-2R-4.SDR AALA202404083874Air Filter · dirtyAIRCRAFT WAS GROUNDED: AN IRRITANT OF SOME SORT IN THE AIR LASTED THROUGHTOUT THE WHOLE FLIGHT. REMOVED AND REPLACED RECIRCULATION AIR FILTERS IAW AMM 21-25-01 AND RAN ENGINES 10 MINUTES. NO EVIDENCE OF IRRENTANT IN THE AIRCRAFT.SDR AALA202404083434Door · lack of lubeAIRFCRAFT WAS NOT GROUNDED:V AFT LEFT HAND LAVATORY DOOR STICK WHEN OPENING AND CLOSING. CLEANED AND LUBED DOOR TRACK. PER CMM 25-40-64.SDR AALA202404082792Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: LEFT MAIN DOOR LIFE RAFT MANUAL DEPLOY HANDLE COVER STUCK BELOW THE DOOR. INSPECTED AND ADJUSTED L1 DOOR GIRT BAR. PER AMM 25-66-01-200-802.SDR AALA202404080217Door · stiffAIRCRAFT WAS NOT GROUNDED: CHRONIC HISTORY (3/5) FLIGHT DECK DOOR DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404085234Light · detachedAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT AT 24ABC EMERGENCY PATH LIGHT DETACHED.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202404082993Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR JAMMED CLOSED WILL NOT OPEN. ADJUSTED DOOR LOCK ASSEMBLY AND LUBE, OPERTIONAL CHECK GOOD. PER AMM 25-40-15.
Back to Boeing 737-823